where('status', 1)->count();
$data['withdraw_task'] = Withdraw::where('status', 0)->count();
return $this->success($data);
}
/**
* @api {post} /admin/wallet/topUp 人工充值
* @apiGroup 充值管理
* @apiUse result
* @apiUse header
* @apiVersion 1.0.0
* @apiParam {float} amount 充值金额
* - 可以是负数 负数则为扣款
* @apiParam {string} member_id 会员ID
* @apiParam {string} remark 充值/扣款 说明
*/
public function topUp()
{
DB::beginTransaction();
try {
request()->validate([
'amount' => ['required', 'numeric'],
'member_id' => ['required', 'string', 'min:1'],
'remark' => ['required', 'string', 'min:1']
]);
$memberId = request()->input('member_id');
$amount = request()->input('amount');
$remark = request()->input('remark');
$wallet = WalletModel::where('member_id', $memberId)
->first();
if (!$wallet) throw new Exception('用户不存在', HttpStatus::CUSTOM_ERROR);
$available_balance = bcadd($wallet->available_balance, $amount, 10);
$changeType = ($amount > 0 ? "人工充值" : "人工扣款");
BalanceLogService::addLog(
$memberId,
$amount,
$wallet->available_balance,
$available_balance,
$changeType,
null,
$remark
);
$wallet->available_balance = $available_balance;
$wallet->save();
DB::commit();
} catch (ValidationException $e) {
DB::rollBack();
return $this->error(HttpStatus::CUSTOM_ERROR, $e->validator->errors()->first());
} catch (Exception $e) {
DB::rollBack();
return $this->error(intval($e->getCode()), $e->getMessage());
}
$available_balance = floatval($available_balance);
// 去除多余0后，再用 sprintf 补足两位
$available_balance = sprintf('%.2f', $available_balance);
TopUpService::notifyTransferSuccess($memberId, "您的账户余额更新：".($amount>0?'+':'')."{$amount} \n总余额为：{$available_balance}");
return $this->success();
}
/**
* @api {post} /admin/wallet/verifyRecharge 审核
* @apiGroup 充值管理
* @apiUse result
* @apiUse header
* @apiVersion 1.0.0
* @apiParam {int} id 充值表的ID
* @apiParam {int} status 状态
* - 1 通过
* - 2 拒绝
* @apiParam {string} [remark] 说明
* - 当status =2 时，此参数必填
*/
public function verifyRecharge()
{
DB::beginTransaction();
try {
request()->validate([
'id' => ['required', 'integer', 'min:1'],
'status' => ['required', 'integer', 'in:1,2'],
'remark' => ['required_if:status,2', 'string', 'min:1']
]);
$id = request()->input('id');
$status = request()->input('status');
$remark = request()->input('remark', '');
$recharge = Recharge::where('id', $id)
->where('type', 2)
->where('status', 0)->first();
if (!$recharge) throw new Exception("数据不存在", HttpStatus::CUSTOM_ERROR);
$amount = floatval($recharge->amount);
if ($status == 2) {
$recharge->status = 2;
$recharge->save();
$text = "充值结果通知\n";
$text .= "充值数量：{$amount} USDT\n";
$text .= "充值地址：{$recharge->to_address}\n";
$text .= "状态：失败\n";
$text .= "原因：{$remark}\n";
TopUpService::notifyTransferSuccess($recharge->member_id, $text);
} else {
$recharge->status = 1;
$recharge->save();
$wallet = WalletModel::where('member_id', $recharge->member_id)
->first();
$available_balance = bcadd($wallet->available_balance, $amount, 10);
BalanceLogService::addLog(
$recharge->member_id,
$amount,
$wallet->available_balance,
$available_balance,
"充值",
$recharge->id,
"用户充值后台审核到账"
);
$wallet->available_balance = $available_balance;
$wallet->save();
$text = "充值结果通知\n";
$text .= "充值数量：{$amount} USDT\n";
$text .= "充值地址：{$recharge->to_address}\n";
$text .= "状态：成功\n";
TopUpService::notifyTransferSuccess($recharge->member_id, $text);
}
DB::commit();
} catch (ValidationException $e) {
DB::rollBack();
return $this->error(HttpStatus::CUSTOM_ERROR, $e->validator->errors()->first());
} catch (Exception $e) {
DB::rollBack();
return $this->error(intval($e->getCode()), $e->getMessage());
}
return $this->success();
}
/**
* @api {get} /admin/wallet 充值列表
* @apiGroup 充值管理
* @apiDescription 如果列表的type=2 并且 status = 0
那么代表这条数据是需要后台手动审核的
* 需要有审核按钮，审核通过或者拒绝，其它情况则不需要审核按钮
*
* @apiUse result
* @apiUse header
* @apiVersion 1.0.0
*
* @apiParam {int} [page=1]
* @apiParam {int} [limit=10]
* @apiParam {string} [member_id] 房主 tg会员ID
* @apiParam {int} [status] 状态
* - 0 待确认
* - 1 已确认
* - 2 失败
* - 3 已忽略
* @apiSuccess (data) {Object} data
* @apiSuccess (data) {int} data.total 数量
* @apiSuccess (data) {Object[]} data.data 列表
* @apiSuccess (data) {int} data.data.id
* @apiSuccess (data) {int} data.data.member_id tg会员id
* @apiSuccess (data) {string} data.data.net 链接类型
* @apiSuccess (data) {string} data.data.coin 币种
* @apiSuccess (data) {string} data.data.amount 充值数量
* @apiSuccess (data) {string} data.data.to_address 充值地址（平台地址）
* @apiSuccess (data) {string} data.data.from_address 转出地址（用户发起地址）
* @apiSuccess (data) {string} data.data.txid 链上交易哈希
* @apiSuccess (data) {string} data.data.block_time 区块时间
* @apiSuccess (data) {string} data.data.block_height
* @apiSuccess (data) {int} data.data.confirmations 确认数
* @apiSuccess (data) {string} data.data.updated_at
* @apiSuccess (data) {string} data.data.created_at
* @apiSuccess (data) {int} data.data.status 状态
* - 0 待确认
* - 1 已确认
* - 2 失败
* - 3 已忽略
* @apiSuccess (data) {int} data.data.type 充值类型
* - 1 自动
* - 2 手动
* @apiSuccess (data) {string} data.data.image 充值转账凭证图片
*/
public function index()
{
try {
request()->validate([
'member_id' => ['nullable', 'string', 'min:1'],
'status' => ['nullable', 'string', 'min:0', 'max:3'],
'type' => ['nullable', 'integer', 'in:1,2'],
]);
$search = request()->all();
$result = RechargeService::paginate($search);
} catch (ValidationException $e) {
return $this->error(HttpStatus::CUSTOM_ERROR, $e->validator->errors()->first());
} catch (Exception $e) {
return $this->error(intval($e->getCode()));
}
return $this->success($result);
}
public function test()
{
$input = request()->get('input','');
// var_dump($input);
// $contractAddress = TronHelper::getContractAddress('USDT');
// $result = TronHelper::getTrc20Balance('TTJ1vH18Q4K3seDcjD4912KDHHzm327rtL',$contractAddress);
// $result = TronHelper::getBalance('TDeGNiweUm86JBJHQ7kXwQ8XQKtrKorHad','USDT');
// dump($result);
// echo WalletService::createRechargeQrCode('TDeGNiweUm86JBJHQ7kXwQ8XQKtrKorHad');
// $result = TronHelper::getTrc20UsdtRecharges('TGQaMxtyWeGowy8xqwh98JNNLtc77nzZ8M');
// $result = TronHelper::getTransactionConfirmations('06407fa9a2ba51c88f1ed01c2296f0069bf305477d3847d41bc3f35cf9190f74');
// var_dump($result);
$memberId = '6325700519';
// $result = BetService::bet($memberId,$input);
// $info = IssueService::findOne(['issue_no'=>'202508271120']);
// $winning_numbers = explode(',',$info['winning_numbers']);
// $result = IssueService::award($winning_numbers);
// var_dump($result);
// RechargeService::handleRechargeConfirmation('45f313ccc3a2f4113f6cc9a7511e8b5096daa1de76cb57397e152a491c17249f');
// WalletService::getUserWallet('1777');
// $result = GameplayRuleService::validateInput('大100');
// $result = IssueService::currentLotteryResults($memberId);
// var_dump($result);
$result = IssueService::getLatestIssue();
echo "";
var_dump($result);
}
}