ManualAuditService.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488
  1. <?php
  2. namespace App\Services;
  3. use App\Constants\HttpStatus;
  4. use App\Models\BalanceLog;
  5. use App\Models\Level;
  6. use App\Models\ManualAudit as ManualAuditRecord;
  7. use App\Models\User;
  8. use App\Models\Wallet;
  9. use Carbon\Carbon;
  10. use Exception;
  11. use Illuminate\Database\Eloquent\Builder;
  12. use Illuminate\Database\QueryException;
  13. use Illuminate\Support\Facades\DB;
  14. use Illuminate\Support\Facades\Log;
  15. class ManualAuditService
  16. {
  17. public const DEBIT_CHANGE_TYPE = '人工扣款';
  18. /** 上下分选择该充值类型时,按平台配置的提现打码倍数计算打码量 */
  19. public const PLATFORM_WAGER_TYPE = '人工充值';
  20. /** 按平台倍数计打码量的全部类型:“其他”与人工充值同样按倍数,但不触发充值钩子(不参与任何活动) */
  21. public const PLATFORM_WAGER_TYPES = ['人工充值', '其他'];
  22. public const STATUS_FAILED = ManualAuditRecord::STATUS_FAILED;
  23. public const STATUS_SUCCESS = ManualAuditRecord::STATUS_SUCCESS;
  24. public static function list(array $params): array
  25. {
  26. $page = max(1, (int)($params['page'] ?? 1));
  27. $limit = min(200, max(1, (int)($params['limit'] ?? 20)));
  28. $query = self::query($params);
  29. $total = (clone $query)->count('id');
  30. $rows = $query
  31. ->orderByDesc('id')
  32. ->forPage($page, $limit)
  33. ->get();
  34. $accounts = self::accounts($rows->pluck('member_id')->all());
  35. // 会员当前打码量(所需/当前/剩余),便于上下分、冻结时参考
  36. $wallets = WageringService::enabled()
  37. ? Wallet::whereIn('member_id', $rows->pluck('member_id')->unique()->values()->all() ?: [''])->get()->keyBy('member_id')
  38. : collect();
  39. return [
  40. 'total' => $total,
  41. 'data' => $rows->map(static fn(ManualAuditRecord $row): array => self::format($row, $accounts)
  42. + ['member_wager' => WageringService::summary($wallets->get((string)$row->member_id))])->all(),
  43. 'options' => [
  44. 'transaction_types' => [
  45. ['label' => '人工上分', 'value' => 'credit'],
  46. ['label' => '人工下分', 'value' => 'debit'],
  47. ],
  48. 'credit_types' => array_map(static fn(string $type): array => [
  49. 'label' => $type,
  50. 'value' => $type,
  51. ], BalanceLogService::$manualRecharge),
  52. 'statuses' => [
  53. ['label' => '失败', 'value' => self::STATUS_FAILED],
  54. ['label' => '成功', 'value' => self::STATUS_SUCCESS],
  55. ],
  56. // 人工充值、其他按平台提现打码倍数自动增减打码量,其余类型需填写 wager_amount
  57. 'platform_wager_type' => self::PLATFORM_WAGER_TYPE,
  58. 'platform_wager_types' => self::PLATFORM_WAGER_TYPES,
  59. 'withdraw_wager_multiple' => WageringService::multiple(),
  60. ],
  61. ];
  62. }
  63. public static function detail(int $id): array
  64. {
  65. $row = self::query(['id' => $id])->first();
  66. if (!$row) {
  67. throw new Exception('人工稽查记录不存在', HttpStatus::CUSTOM_ERROR);
  68. }
  69. return self::format($row, self::accounts([$row->member_id]));
  70. }
  71. /** 会员ID和账号可二选一,也可同时填写,但必须指向同一会员 */
  72. public static function resolveMemberId(?string $memberId, ?string $account): string
  73. {
  74. $memberId = trim((string)$memberId);
  75. $account = trim((string)$account);
  76. if ($account === '') {
  77. if ($memberId === '') throw new Exception('请填写会员ID或账号', HttpStatus::CUSTOM_ERROR);
  78. return $memberId;
  79. }
  80. $matches = User::where('account', $account)->limit(2)->pluck('member_id');
  81. if ($matches->isEmpty()) throw new Exception('账号不存在', HttpStatus::CUSTOM_ERROR);
  82. if ($matches->count() > 1) throw new Exception('该账号对应多个会员,请填写会员ID', HttpStatus::CUSTOM_ERROR);
  83. $resolved = (string)$matches->first();
  84. if ($memberId !== '' && $memberId !== $resolved) throw new Exception('会员ID与账号不一致', HttpStatus::CUSTOM_ERROR);
  85. return $resolved;
  86. }
  87. /** @return array<string,string> member_id => account */
  88. private static function accounts(array $memberIds): array
  89. {
  90. $memberIds = array_values(array_unique(array_filter(array_map('strval', $memberIds), 'strlen')));
  91. if (!$memberIds) return [];
  92. return User::whereIn('member_id', $memberIds)->pluck('account', 'member_id')
  93. ->map(static fn($account): string => (string)($account ?? ''))->all();
  94. }
  95. /**
  96. * @param string|null $wagerAmount 非“人工充值”类型时填写的打码量(为空视为0,可直接提现)
  97. */
  98. public static function credit(
  99. string $requestId,
  100. int $adminId,
  101. string $memberId,
  102. string $amount,
  103. string $changeType,
  104. string $remark,
  105. ?string $wagerAmount = null
  106. ): array {
  107. return self::adjust($requestId, $adminId, $memberId, $amount, $changeType, $remark, false, null, $wagerAmount);
  108. }
  109. /**
  110. * @param string|null $rechargeType 下分对应的充值类型:人工充值、“其他”按平台倍数扣除打码量;其余类型扣除 $wagerAmount;为空不调整打码量
  111. */
  112. public static function debit(
  113. string $requestId,
  114. int $adminId,
  115. string $memberId,
  116. string $amount,
  117. string $remark,
  118. ?string $rechargeType = null,
  119. ?string $wagerAmount = null
  120. ): array {
  121. return self::adjust(
  122. $requestId,
  123. $adminId,
  124. $memberId,
  125. $amount,
  126. self::DEBIT_CHANGE_TYPE,
  127. $remark,
  128. true,
  129. $rechargeType,
  130. $wagerAmount
  131. );
  132. }
  133. /**
  134. * 本次上下分对打码量的有符号调整。上分“人工充值”由充值钩子自动按平台倍数增加,这里只返回展示值。
  135. * @return array{0:string,1:bool} [有符号打码量, 是否需要在此处手动写入]
  136. */
  137. public static function wagerDelta(bool $isDebit, string $amount, string $changeType, ?string $rechargeType, ?string $wagerAmount): array
  138. {
  139. // 仅自填分支解析 wager_amount:按平台倍数的类型忽略该值;校验器的 numeric 会放行 "1e2" 等 bcmath 不接受的写法
  140. $custom = static function () use ($wagerAmount): string {
  141. try {
  142. return bcadd((string)($wagerAmount ?? '0'), '0', 10);
  143. } catch (\ValueError) {
  144. throw new Exception('打码量格式不正确', HttpStatus::CUSTOM_ERROR);
  145. }
  146. };
  147. if (!$isDebit) {
  148. if ($changeType === self::PLATFORM_WAGER_TYPE) return [WageringService::platformRequirement($amount), false];
  149. // “其他”不走充值钩子,平台倍数的打码量需在此处写入
  150. if (in_array($changeType, self::PLATFORM_WAGER_TYPES, true)) return [WageringService::platformRequirement($amount), true];
  151. return [$custom(), true];
  152. }
  153. if ($rechargeType === null || $rechargeType === '') return ['0', false];
  154. $value = in_array($rechargeType, self::PLATFORM_WAGER_TYPES, true) ? WageringService::platformRequirement($amount) : $custom();
  155. return [bcsub('0', $value, 10), true];
  156. }
  157. private static function adjust(
  158. string $requestId,
  159. int $adminId,
  160. string $memberId,
  161. string $amount,
  162. string $changeType,
  163. string $remark,
  164. bool $isDebit,
  165. ?string $rechargeType = null,
  166. ?string $wagerAmount = null
  167. ): array {
  168. $signedAmount = bcadd($amount, '0', 10);
  169. if ($isDebit) {
  170. $signedAmount = bcmul($signedAmount, '-1', 10);
  171. }
  172. $transactionType = $isDebit ? 'debit' : 'credit';
  173. [$wagerDelta, $writeWager] = self::wagerDelta($isDebit, $amount, $changeType, $rechargeType, $wagerAmount);
  174. $requestHash = self::requestHash(
  175. $adminId,
  176. $memberId,
  177. $signedAmount,
  178. $transactionType,
  179. $changeType,
  180. $remark,
  181. // 只摘要请求原始参数,平台倍数调整后同一 request_id 重试仍能识别为同一请求
  182. $rechargeType === null && $wagerAmount === null ? null
  183. : ['recharge_type' => $rechargeType, 'wager_amount' => $wagerAmount === null ? null : bcadd($wagerAmount, '0', 10)]
  184. );
  185. $existing = ManualAuditRecord::where('request_id', $requestId)->first();
  186. if ($existing) {
  187. self::assertRequestMatches($existing, $requestHash);
  188. return self::format($existing, self::accounts([$memberId]));
  189. }
  190. $created = false;
  191. try {
  192. $audit = DB::transaction(function () use (
  193. $requestId,
  194. $requestHash,
  195. $adminId,
  196. $memberId,
  197. $signedAmount,
  198. $transactionType,
  199. $changeType,
  200. $remark,
  201. $wagerDelta,
  202. $writeWager
  203. ): ManualAuditRecord {
  204. $audit = ManualAuditRecord::create(self::withWager([
  205. 'request_id' => $requestId,
  206. 'request_hash' => $requestHash,
  207. 'admin_id' => $adminId,
  208. 'member_id' => $memberId,
  209. 'username' => '',
  210. 'first_name' => '',
  211. 'transaction_type' => $transactionType,
  212. 'change_type' => $changeType,
  213. 'amount' => $signedAmount,
  214. 'level_before' => 0,
  215. 'level_before_name' => '普通会员',
  216. 'level_after' => 0,
  217. 'level_after_name' => '普通会员',
  218. 'status' => self::STATUS_FAILED,
  219. 'remark' => $remark,
  220. 'failure_reason' => '',
  221. ], $wagerDelta));
  222. // Keep the same lock order as payment callbacks: wallet first, user second.
  223. $wallet = Wallet::where('member_id', $memberId)->lockForUpdate()->first();
  224. $user = User::where('member_id', $memberId)->lockForUpdate()->first();
  225. [$level, $levelName] = self::levelSnapshot($user);
  226. $audit->fill([
  227. 'username' => (string)($user->username ?? ''),
  228. 'first_name' => (string)($user->first_name ?? ''),
  229. 'level_before' => $level,
  230. 'level_before_name' => $levelName,
  231. 'level_after' => $level,
  232. 'level_after_name' => $levelName,
  233. ]);
  234. if (!$user) {
  235. return self::fail($audit, '用户不存在');
  236. }
  237. if (!$wallet) {
  238. return self::fail($audit, '用户钱包不存在');
  239. }
  240. $beforeBalance = bcadd((string)$wallet->available_balance, '0', 10);
  241. $afterBalance = bcadd($beforeBalance, $signedAmount, 10);
  242. $audit->before_balance = $beforeBalance;
  243. if (bccomp($afterBalance, '0', 10) < 0) {
  244. $audit->after_balance = $beforeBalance;
  245. return self::fail($audit, '可用余额不足');
  246. }
  247. // 先保存余额再写日志:充值钩子(首充奖励、即充即送、打码量)会在同一事务内重新锁定并更新钱包。
  248. $wallet->available_balance = $afterBalance;
  249. if (!$wallet->save()) {
  250. throw new Exception('钱包更新失败', HttpStatus::CUSTOM_ERROR);
  251. }
  252. $log = BalanceLogService::addLog(
  253. $memberId,
  254. $signedAmount,
  255. $beforeBalance,
  256. $afterBalance,
  257. $changeType,
  258. null,
  259. $remark
  260. );
  261. if ($writeWager) {
  262. $wallet = Wallet::where('member_id', $memberId)->lockForUpdate()->first();
  263. WageringService::addRequirement($wallet, $wagerDelta, bccomp($signedAmount, '0', 10) < 0 ? 'manual_debit' : 'manual_credit',
  264. $audit->id, $changeType . ($remark !== '' ? ';' . $remark : ''), $adminId);
  265. }
  266. $audit->balance_log_id = $log->id;
  267. $audit->after_balance = $afterBalance;
  268. $audit->status = self::STATUS_SUCCESS;
  269. $audit->failure_reason = '';
  270. $audit->save();
  271. return $audit;
  272. }, 3);
  273. $created = true;
  274. } catch (QueryException $e) {
  275. $audit = ManualAuditRecord::where('request_id', $requestId)->first();
  276. if (!$audit) {
  277. throw $e;
  278. }
  279. self::assertRequestMatches($audit, $requestHash);
  280. }
  281. if ($created && (int)$audit->status === self::STATUS_SUCCESS) {
  282. self::notifyUser($memberId, (string)$audit->amount, (string)$audit->after_balance);
  283. }
  284. return self::format($audit, self::accounts([$memberId]));
  285. }
  286. private static ?bool $hasWagerColumn = null;
  287. private static function withWager(array $data, string $wagerDelta): array
  288. {
  289. self::$hasWagerColumn ??= DB::connection()->getSchemaBuilder()->hasColumn('manual_audits', 'wager_amount');
  290. if (self::$hasWagerColumn) $data['wager_amount'] = $wagerDelta;
  291. return $data;
  292. }
  293. private static function fail(ManualAuditRecord $audit, string $reason): ManualAuditRecord
  294. {
  295. $audit->status = self::STATUS_FAILED;
  296. $audit->failure_reason = $reason;
  297. $audit->save();
  298. return $audit;
  299. }
  300. private static function query(array $params = []): Builder
  301. {
  302. $query = ManualAuditRecord::query();
  303. \App\Support\MemberAudience::visibleMembers($query, 'member_id'); // 后台模拟会员只在模拟管理里出现
  304. if (!empty($params['id'])) {
  305. $query->where('id', (int)$params['id']);
  306. }
  307. if (!empty($params['member_id'])) {
  308. $query->where('member_id', (string)$params['member_id']);
  309. }
  310. if (!empty($params['account'])) {
  311. $query->whereIn('member_id', User::select('member_id')
  312. ->where('account', 'like', '%' . trim((string)$params['account']) . '%'));
  313. }
  314. if (!empty($params['first_name'])) {
  315. $query->where('first_name', 'like', '%' . $params['first_name'] . '%');
  316. }
  317. if (!empty($params['transaction_type'])) {
  318. $query->where('transaction_type', (string)$params['transaction_type']);
  319. }
  320. if (!empty($params['change_type'])) {
  321. $query->where('change_type', (string)$params['change_type']);
  322. }
  323. if (array_key_exists('status', $params) && $params['status'] !== null && $params['status'] !== '') {
  324. $query->where('status', (int)$params['status']);
  325. }
  326. if (!empty($params['start_date']) && !empty($params['end_date'])) {
  327. [$start, $end] = self::dateRange($params['start_date'], $params['end_date']);
  328. $query->whereBetween('created_at', [$start, $end]);
  329. }
  330. return $query;
  331. }
  332. private static function format(ManualAuditRecord $row, array $accounts = []): array
  333. {
  334. $amount = (string)$row->amount;
  335. $status = (int)$row->status;
  336. return [
  337. 'id' => (int)$row->id,
  338. 'request_id' => (string)$row->request_id,
  339. 'admin_id' => $row->admin_id === null ? null : (int)$row->admin_id,
  340. 'balance_log_id' => $row->balance_log_id === null ? null : (int)$row->balance_log_id,
  341. 'member_id' => (string)$row->member_id,
  342. 'account' => $accounts[(string)$row->member_id] ?? '',
  343. 'username' => (string)($row->username ?? ''),
  344. 'first_name' => (string)($row->first_name ?? ''),
  345. 'transaction_type' => (string)$row->transaction_type,
  346. 'transaction_type_text' => $row->transaction_type === 'debit' ? '人工下分' : '人工上分',
  347. 'change_type' => (string)$row->change_type,
  348. 'level_before' => (int)$row->level_before,
  349. 'level_before_name' => (string)$row->level_before_name,
  350. 'level_after' => (int)$row->level_after,
  351. 'level_after_name' => (string)$row->level_after_name,
  352. 'amount' => self::money(abs((float)$amount)),
  353. 'signed_amount' => self::money((float)$amount),
  354. 'before_balance' => self::nullableMoney($row->before_balance),
  355. 'after_balance' => self::nullableMoney($row->after_balance),
  356. 'status' => $status,
  357. 'status_text' => $status === self::STATUS_SUCCESS ? '成功' : '失败',
  358. 'remark' => (string)($row->remark ?? ''),
  359. 'wager_amount' => self::nullableMoney($row->getAttribute('wager_amount')) ?? '0.00',
  360. 'failure_reason' => (string)($row->failure_reason ?? ''),
  361. 'created_at' => (string)$row->created_at,
  362. ];
  363. }
  364. /**
  365. * @return array{0:int,1:string}
  366. */
  367. private static function levelSnapshot(?User $user): array
  368. {
  369. if (!$user) {
  370. return [0, '普通会员'];
  371. }
  372. $level = (int)($user->level ?? 0);
  373. $levelName = (string)(Level::where('level', $level)->value('level_name') ?? '');
  374. if ($levelName === '') {
  375. $levelName = $level > 0 ? '等级' . $level : '普通会员';
  376. }
  377. return [$level, $levelName];
  378. }
  379. private static function requestHash(
  380. int $adminId,
  381. string $memberId,
  382. string $signedAmount,
  383. string $transactionType,
  384. string $changeType,
  385. string $remark,
  386. ?array $wager = null
  387. ): string {
  388. $data = [
  389. 'admin_id' => $adminId,
  390. 'member_id' => $memberId,
  391. 'amount' => $signedAmount,
  392. 'transaction_type' => $transactionType,
  393. 'change_type' => $changeType,
  394. 'remark' => $remark,
  395. ];
  396. // 未传打码量参数的请求保持旧摘要,避免升级前后重放同一 request_id 被判为冲突
  397. if ($wager !== null) $data['wager'] = $wager;
  398. $payload = json_encode($data, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_THROW_ON_ERROR);
  399. return hash('sha256', $payload);
  400. }
  401. private static function assertRequestMatches(ManualAuditRecord $audit, string $requestHash): void
  402. {
  403. if (!hash_equals((string)$audit->request_hash, $requestHash)) {
  404. throw new Exception('request_id 已被其他人工操作使用', HttpStatus::CUSTOM_ERROR);
  405. }
  406. }
  407. private static function notifyUser(string $memberId, string $amount, string $afterBalance): void
  408. {
  409. try {
  410. $formattedAmount = self::money((float)$amount);
  411. $formattedBalance = self::money((float)$afterBalance);
  412. TopUpService::notifyTransferSuccess(
  413. $memberId,
  414. '您的账户余额更新:' . ((float)$amount > 0 ? '+' : '') . $formattedAmount
  415. . " \n总余额为:" . $formattedBalance
  416. );
  417. } catch (\Throwable $e) {
  418. Log::warning('manual_audit_notify_failed', [
  419. 'member_id' => $memberId,
  420. 'error' => $e->getMessage(),
  421. ]);
  422. }
  423. }
  424. private static function money(float $amount): string
  425. {
  426. return number_format($amount, 2, '.', '');
  427. }
  428. private static function nullableMoney($amount): ?string
  429. {
  430. return $amount === null || $amount === '' ? null : self::money((float)$amount);
  431. }
  432. /**
  433. * @return array{0: Carbon, 1: Carbon}
  434. */
  435. private static function dateRange(string $startDate, string $endDate): array
  436. {
  437. $timezone = config('app.timezone', 'Asia/Shanghai');
  438. return [
  439. Carbon::createFromFormat('Y-m-d', $startDate, $timezone)->startOfDay(),
  440. Carbon::createFromFormat('Y-m-d', $endDate, $timezone)->endOfDay(),
  441. ];
  442. }
  443. }