ManualAuditService.php 22 KB

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