ItemFreeze.php 43 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168
  1. <?php
  2. namespace App\Module\GameItems\Logics;
  3. use App\Module\GameItems\Enums\FREEZE_ACTION_TYPE;
  4. use App\Module\GameItems\Enums\FREEZE_REASON_TYPE;
  5. use App\Module\GameItems\Enums\TRANSACTION_TYPE;
  6. use App\Module\GameItems\Events\ItemQuantityChanged;
  7. use App\Module\GameItems\Models\Item;
  8. use App\Module\GameItems\Models\ItemFreezeLog;
  9. use App\Module\GameItems\Models\ItemUser;
  10. use Exception;
  11. use Illuminate\Support\Collection;
  12. use Illuminate\Support\Facades\Log;
  13. use UCore\Db\Helper;
  14. use UCore\Helper\Logger;
  15. /**
  16. * 物品冻结逻辑类
  17. *
  18. * 处理物品冻结和解冻的核心业务逻辑,包括:
  19. * - 统一属性物品的冻结/解冻(拆堆模式)
  20. * - 单独属性物品的冻结/解冻
  21. * - 冻结状态验证和数量查询
  22. * - 批量冻结操作
  23. */
  24. class ItemFreeze
  25. {
  26. /**
  27. * 冻结统一属性物品(拆堆模式)
  28. *
  29. * 实现逻辑:
  30. * 1. 查找用户可用的物品堆叠(is_frozen=false)
  31. * 2. 从可用堆叠中扣除冻结数量
  32. * 3. 创建新的冻结堆叠记录(is_frozen=true)
  33. * 4. 记录冻结日志
  34. *
  35. * @param int $userId 用户ID
  36. * @param int $itemId 物品ID
  37. * @param int $quantity 冻结数量
  38. * @param FREEZE_REASON_TYPE $reason 冻结原因
  39. * @param int|null $sourceId 来源ID
  40. * @param string|null $sourceType 来源类型
  41. * @param int|null $operatorId 操作员ID
  42. * @return array 冻结结果
  43. * @throws Exception
  44. */
  45. public static function freezeNormalItem(
  46. int $userId,
  47. int $itemId,
  48. int $quantity,
  49. FREEZE_REASON_TYPE $reason,
  50. ?int $sourceId = null,
  51. ?string $sourceType = null,
  52. ?int $operatorId = null
  53. ): array {
  54. // 检查事务
  55. Helper::check_tr();
  56. // 验证冻结操作的合法性
  57. if (!self::validateFreezeOperation($userId, $itemId, $quantity)) {
  58. throw new Exception("用户 {$userId} 的物品 {$itemId} 可用数量不足,无法冻结 {$quantity} 个");
  59. }
  60. // 获取用户可用的物品堆叠(按过期时间排序,优先冻结即将过期的)
  61. $availableItems = ItemUser::where('user_id', $userId)
  62. ->where('item_id', $itemId)
  63. ->where('is_frozen', false)
  64. ->whereNull('instance_id')
  65. ->where('quantity', '>', 0)
  66. ->orderBy('expire_at')
  67. ->get();
  68. $remainingQuantity = $quantity;
  69. $frozenItems = [];
  70. $changedItems = []; // 记录所有变更的物品,包括数量减少和冻结创建
  71. foreach ($availableItems as $userItem) {
  72. if ($remainingQuantity <= 0) {
  73. break;
  74. }
  75. $availableQuantity = $userItem->quantity;
  76. $freezeQuantity = min($remainingQuantity, $availableQuantity);
  77. // 创建冻结日志
  78. $freezeLog = ItemFreezeLog::createLog(
  79. $userId,
  80. $itemId,
  81. null,
  82. $freezeQuantity,
  83. FREEZE_ACTION_TYPE::FREEZE,
  84. $reason->getName($reason->value),
  85. $sourceId,
  86. $sourceType,
  87. $operatorId
  88. );
  89. if ($freezeQuantity == $availableQuantity) {
  90. Logger::debug('不拆堆');
  91. // 全部冻结,直接标记为冻结状态
  92. $userItem->is_frozen = true;
  93. $userItem->frozen_log_id = $freezeLog->id;
  94. $userItem->save();
  95. $frozenItems[] = [
  96. 'user_item_id' => $userItem->id,
  97. 'quantity' => $freezeQuantity,
  98. 'freeze_log_id' => $freezeLog->id,
  99. ];
  100. // 记录冻结状态变更(数量不变,但冻结状态从false变为true)
  101. $changedItems[] = [
  102. 'type' => 'freeze_status_change',
  103. 'user_item_id' => $userItem->id,
  104. 'old_quantity' => $availableQuantity,
  105. 'new_quantity' => $availableQuantity,
  106. 'old_frozen_status' => false,
  107. 'new_frozen_status' => true,
  108. 'freeze_log_id' => $freezeLog->id,
  109. ];
  110. } else {
  111. // 部分冻结,需要拆堆
  112. Logger::debug('拆堆');
  113. // 减少原堆叠数量
  114. $userItem->quantity = $availableQuantity - $freezeQuantity;
  115. $userItem->save();
  116. // 记录原堆叠数量减少(非冻结物品减少)
  117. $changedItems[] = [
  118. 'type' => 'quantity_decrease',
  119. 'user_item_id' => $userItem->id,
  120. 'old_quantity' => $availableQuantity,
  121. 'new_quantity' => $availableQuantity - $freezeQuantity,
  122. 'old_frozen_status' => false,
  123. 'new_frozen_status' => false, // 冻结状态不变,仍为未冻结
  124. 'freeze_log_id' => null,
  125. ];
  126. // 创建新的冻结堆叠
  127. $frozenItem = new ItemUser([
  128. 'user_id' => $userId,
  129. 'item_id' => $itemId,
  130. 'instance_id' => null,
  131. 'quantity' => $freezeQuantity,
  132. 'expire_at' => $userItem->expire_at,
  133. 'is_frozen' => true,
  134. 'frozen_log_id' => $freezeLog->id,
  135. ]);
  136. $frozenItem->save();
  137. $frozenItems[] = [
  138. 'user_item_id' => $frozenItem->id,
  139. 'quantity' => $freezeQuantity,
  140. 'freeze_log_id' => $freezeLog->id,
  141. ];
  142. // 记录新冻结堆叠创建(冻结物品创建)
  143. $changedItems[] = [
  144. 'type' => 'frozen_item_create',
  145. 'user_item_id' => $frozenItem->id,
  146. 'old_quantity' => 0, // 新创建的物品,旧数量为0
  147. 'new_quantity' => $freezeQuantity,
  148. 'old_frozen_status' => null, // 新创建的物品,旧冻结状态为null
  149. 'new_frozen_status' => true,
  150. 'freeze_log_id' => $freezeLog->id,
  151. ];
  152. }
  153. $remainingQuantity -= $freezeQuantity;
  154. }
  155. if ($remainingQuantity > 0) {
  156. throw new Exception("冻结操作失败,剩余未冻结数量:{$remainingQuantity}");
  157. }
  158. // 触发物品变更事件(包括非冻结减少和冻结创建)
  159. foreach ($changedItems as $changedItem) {
  160. event(new ItemQuantityChanged(
  161. $userId,
  162. $itemId,
  163. null, // 统一属性物品没有实例ID
  164. $changedItem['old_quantity'],
  165. $changedItem['new_quantity'],
  166. $changedItem['user_item_id'],
  167. $changedItem['old_frozen_status'],
  168. $changedItem['new_frozen_status'],
  169. [
  170. 'freeze_action' => 'freeze',
  171. 'change_type' => $changedItem['type'], // 变更类型:quantity_decrease, frozen_item_create, freeze_status_change
  172. 'freeze_log_id' => $changedItem['freeze_log_id'],
  173. 'reason' => $reason->getName($reason->value),
  174. 'source_id' => $sourceId,
  175. 'source_type' => $sourceType,
  176. 'operator_id' => $operatorId,
  177. ]
  178. ));
  179. }
  180. return [
  181. 'success' => true,
  182. 'user_id' => $userId,
  183. 'item_id' => $itemId,
  184. 'frozen_quantity' => $quantity,
  185. 'frozen_items' => $frozenItems,
  186. ];
  187. }
  188. /**
  189. * 冻结单独属性物品
  190. *
  191. * @param int $userId 用户ID
  192. * @param int $itemId 物品ID
  193. * @param int $instanceId 物品实例ID
  194. * @param FREEZE_REASON_TYPE $reason 冻结原因
  195. * @param int|null $sourceId 来源ID
  196. * @param string|null $sourceType 来源类型
  197. * @param int|null $operatorId 操作员ID
  198. * @return array 冻结结果
  199. * @throws Exception
  200. */
  201. public static function freezeUniqueItem(
  202. int $userId,
  203. int $itemId,
  204. int $instanceId,
  205. FREEZE_REASON_TYPE $reason,
  206. ?int $sourceId = null,
  207. ?string $sourceType = null,
  208. ?int $operatorId = null
  209. ): array {
  210. // 检查事务
  211. Helper::check_tr();
  212. // 查找用户的单独属性物品
  213. $userItem = ItemUser::where('user_id', $userId)
  214. ->where('item_id', $itemId)
  215. ->where('instance_id', $instanceId)
  216. ->where('is_frozen', false)
  217. ->first();
  218. if (!$userItem) {
  219. throw new Exception("用户 {$userId} 没有可冻结的物品实例 {$instanceId}");
  220. }
  221. // 创建冻结日志
  222. $freezeLog = ItemFreezeLog::createLog(
  223. $userId,
  224. $itemId,
  225. $instanceId,
  226. 1, // 单独属性物品数量始终为1
  227. FREEZE_ACTION_TYPE::FREEZE,
  228. $reason->getName($reason->value),
  229. $sourceId,
  230. $sourceType,
  231. $operatorId
  232. );
  233. // 标记为冻结状态
  234. $userItem->is_frozen = true;
  235. $userItem->frozen_log_id = $freezeLog->id;
  236. $userItem->save();
  237. // 触发物品变更事件(冻结状态变更)
  238. event(new ItemQuantityChanged(
  239. $userId,
  240. $itemId,
  241. $instanceId,
  242. 1, // 旧数量(单独属性物品数量始终为1)
  243. 1, // 新数量(数量未变)
  244. $userItem->id,
  245. false, // 旧冻结状态:未冻结
  246. true, // 新冻结状态:已冻结
  247. [
  248. 'freeze_action' => 'freeze',
  249. 'freeze_log_id' => $freezeLog->id,
  250. 'reason' => $reason->getName($reason->value),
  251. 'source_id' => $sourceId,
  252. 'source_type' => $sourceType,
  253. 'operator_id' => $operatorId,
  254. ]
  255. ));
  256. return [
  257. 'success' => true,
  258. 'user_id' => $userId,
  259. 'item_id' => $itemId,
  260. 'instance_id' => $instanceId,
  261. 'user_item_id' => $userItem->id,
  262. 'freeze_log_id' => $freezeLog->id,
  263. ];
  264. }
  265. /**
  266. * 解冻物品(通过冻结日志ID)
  267. *
  268. * @param int $freezeLogId 冻结日志ID
  269. * @return array 解冻结果
  270. * @throws Exception
  271. */
  272. public static function unfreezeByLogId(int $freezeLogId): array
  273. {
  274. // 检查事务
  275. Helper::check_tr();
  276. // 查找冻结日志
  277. $freezeLog = ItemFreezeLog::find($freezeLogId);
  278. if (!$freezeLog) {
  279. throw new Exception("冻结日志 {$freezeLogId} 不存在");
  280. }
  281. if (!$freezeLog->isFreeze()) {
  282. throw new Exception("日志 {$freezeLogId} 不是冻结操作记录");
  283. }
  284. // 查找对应的冻结物品
  285. $frozenItem = ItemUser::where('frozen_log_id', $freezeLogId)
  286. ->where('is_frozen', true)
  287. ->first();
  288. if (!$frozenItem) {
  289. throw new Exception("未找到冻结日志 {$freezeLogId} 对应的冻结物品");
  290. }
  291. // 获取原始冻结数量和当前剩余数量
  292. $originalFrozenQuantity = $freezeLog->quantity;
  293. $currentQuantity = $frozenItem->quantity;
  294. if ($currentQuantity <= 0) {
  295. // 冻结堆已被完全消耗,无法解冻
  296. throw new Exception("冻结日志 {$freezeLogId} 对应的冻结物品已被完全消耗,无法解冻");
  297. }
  298. // 检查是否需要补足差额
  299. $shortageQuantity = $originalFrozenQuantity - $currentQuantity;
  300. if ($shortageQuantity > 0) {
  301. // 冻结堆被部分消耗,需要从用户其他可用物品中补足
  302. $availableQuantity = self::getAvailableQuantity(
  303. $frozenItem->user_id,
  304. $frozenItem->item_id,
  305. $frozenItem->instance_id
  306. );
  307. if ($availableQuantity < $shortageQuantity) {
  308. throw new Exception(
  309. "解冻失败:原始冻结数量 {$originalFrozenQuantity},当前冻结剩余 {$currentQuantity}," .
  310. "需要补足 {$shortageQuantity},但用户可用数量只有 {$availableQuantity}"
  311. );
  312. }
  313. // 从用户可用物品中扣除差额,补足到冻结堆
  314. $availableItems = ItemUser::where('user_id', $frozenItem->user_id)
  315. ->where('item_id', $frozenItem->item_id)
  316. ->where('is_frozen', false)
  317. ->whereNull('instance_id')
  318. ->where('quantity', '>', 0)
  319. ->orderBy('expire_at')
  320. ->get();
  321. $remainingShortage = $shortageQuantity;
  322. $transferDetails = []; // 记录转移详情
  323. foreach ($availableItems as $availableItem) {
  324. if ($remainingShortage <= 0) break;
  325. $deductQuantity = min($availableItem->quantity, $remainingShortage);
  326. $oldQuantity = $availableItem->quantity;
  327. $newQuantity = $oldQuantity - $deductQuantity;
  328. // 更新可用物品数量
  329. $availableItem->quantity = $newQuantity;
  330. $availableItem->save();
  331. // 记录转移详情
  332. $transferDetails[] = [
  333. 'from_user_item_id' => $availableItem->id,
  334. 'transferred_quantity' => $deductQuantity,
  335. 'old_quantity' => $oldQuantity,
  336. 'new_quantity' => $newQuantity,
  337. ];
  338. // 记录交易日志(从可用物品扣除)
  339. \App\Module\GameItems\Logics\Item::logTransaction(
  340. $frozenItem->user_id,
  341. $frozenItem->item_id,
  342. null,
  343. -$deductQuantity,
  344. TRANSACTION_TYPE::TRADE_OUT, // 使用交易失去类型
  345. 'unfreeze_compensation',
  346. $freezeLogId,
  347. ["解冻补足转移:从可用物品转移 {$deductQuantity} 个到冻结堆"]
  348. );
  349. // 触发物品数量变更事件(可用物品减少)
  350. event(new ItemQuantityChanged(
  351. $frozenItem->user_id,
  352. $frozenItem->item_id,
  353. null,
  354. $oldQuantity,
  355. $newQuantity,
  356. $availableItem->id,
  357. false, // 旧冻结状态:未冻结
  358. false, // 新冻结状态:未冻结
  359. [
  360. 'action' => 'unfreeze_compensation_transfer_out',
  361. 'freeze_log_id' => $freezeLogId,
  362. 'transferred_quantity' => $deductQuantity,
  363. ]
  364. ));
  365. $remainingShortage -= $deductQuantity;
  366. }
  367. // 将补足的数量加到冻结堆
  368. $oldFrozenQuantity = $frozenItem->quantity;
  369. $frozenItem->quantity = $originalFrozenQuantity;
  370. $frozenItem->save();
  371. // 记录交易日志(向冻结堆补足)
  372. \App\Module\GameItems\Logics\Item::logTransaction(
  373. $frozenItem->user_id,
  374. $frozenItem->item_id,
  375. $frozenItem->instance_id,
  376. $shortageQuantity,
  377. TRANSACTION_TYPE::TRADE_IN, // 使用交易获得类型
  378. 'unfreeze_compensation',
  379. $freezeLogId,
  380. ["解冻补足转移:向冻结堆补足 {$shortageQuantity} 个,转移详情:" . json_encode($transferDetails)]
  381. );
  382. // 触发物品数量变更事件(冻结堆增加)
  383. event(new ItemQuantityChanged(
  384. $frozenItem->user_id,
  385. $frozenItem->item_id,
  386. $frozenItem->instance_id,
  387. $oldFrozenQuantity,
  388. $originalFrozenQuantity,
  389. $frozenItem->id,
  390. true, // 旧冻结状态:已冻结
  391. true, // 新冻结状态:已冻结
  392. [
  393. 'action' => 'unfreeze_compensation_transfer_in',
  394. 'freeze_log_id' => $freezeLogId,
  395. 'compensated_quantity' => $shortageQuantity,
  396. 'transfer_details' => $transferDetails,
  397. ]
  398. ));
  399. }
  400. // 创建解冻日志,记录原始冻结数量
  401. $unfreezeLog = ItemFreezeLog::createLog(
  402. $frozenItem->user_id,
  403. $frozenItem->item_id,
  404. $frozenItem->instance_id,
  405. $originalFrozenQuantity, // 解冻原始数量
  406. FREEZE_ACTION_TYPE::UNFREEZE,
  407. "解冻操作,原冻结日志ID: {$freezeLogId},原始冻结数量: {$originalFrozenQuantity}" .
  408. ($shortageQuantity > 0 ? ",补足差额: {$shortageQuantity}" : ""),
  409. $freezeLog->source_id,
  410. $freezeLog->source_type,
  411. $freezeLog->operator_id
  412. );
  413. // 解冻物品(保持独立,不合并堆叠)
  414. $frozenItem->is_frozen = false;
  415. $frozenItem->frozen_log_id = null;
  416. $frozenItem->save();
  417. // 触发物品变更事件(解冻状态变更)
  418. event(new ItemQuantityChanged(
  419. $frozenItem->user_id,
  420. $frozenItem->item_id,
  421. $frozenItem->instance_id,
  422. $originalFrozenQuantity, // 旧数量(恢复到原始数量)
  423. $originalFrozenQuantity, // 新数量(数量未变,只是解冻状态变更)
  424. $frozenItem->id,
  425. true, // 旧冻结状态:已冻结
  426. false, // 新冻结状态:未冻结
  427. [
  428. 'freeze_action' => 'unfreeze',
  429. 'unfreeze_log_id' => $unfreezeLog->id,
  430. 'original_freeze_log_id' => $freezeLogId,
  431. 'original_frozen_quantity' => $originalFrozenQuantity,
  432. 'shortage_compensated' => $shortageQuantity,
  433. 'source_id' => $freezeLog->source_id,
  434. 'source_type' => $freezeLog->source_type,
  435. 'operator_id' => $freezeLog->operator_id,
  436. ]
  437. ));
  438. return [
  439. 'success' => true,
  440. 'user_id' => $frozenItem->user_id,
  441. 'item_id' => $frozenItem->item_id,
  442. 'instance_id' => $frozenItem->instance_id,
  443. 'unfrozen_quantity' => $originalFrozenQuantity, // 返回原始冻结数量
  444. 'shortage_compensated' => $shortageQuantity, // 返回补足的差额
  445. 'user_item_id' => $frozenItem->id,
  446. 'unfreeze_log_id' => $unfreezeLog->id,
  447. ];
  448. }
  449. /**
  450. * 检查用户可用物品数量(排除冻结堆叠)
  451. *
  452. * @param int $userId 用户ID
  453. * @param int $itemId 物品ID
  454. * @param int|null $instanceId 实例ID
  455. * @return int 可用数量
  456. */
  457. public static function getAvailableQuantity(
  458. int $userId,
  459. int $itemId,
  460. ?int $instanceId = null
  461. ): int {
  462. return ItemUser::getAvailableQuantity($userId, $itemId, $instanceId);
  463. }
  464. /**
  465. * 验证用户是否有足够的可用物品
  466. *
  467. * @param int $userId 用户ID
  468. * @param int $itemId 物品ID
  469. * @param int $requiredQuantity 需要的数量
  470. * @param int|null $instanceId 实例ID
  471. * @return bool 是否有足够的可用物品
  472. */
  473. public static function checkAvailableQuantity(
  474. int $userId,
  475. int $itemId,
  476. int $requiredQuantity,
  477. ?int $instanceId = null
  478. ): bool {
  479. $availableQuantity = self::getAvailableQuantity($userId, $itemId, $instanceId);
  480. return $availableQuantity >= $requiredQuantity;
  481. }
  482. /**
  483. * 验证冻结操作的合法性
  484. *
  485. * @param int $userId 用户ID
  486. * @param int $itemId 物品ID
  487. * @param int $quantity 冻结数量
  488. * @param int|null $instanceId 实例ID
  489. * @return bool 是否可以冻结
  490. */
  491. public static function validateFreezeOperation(
  492. int $userId,
  493. int $itemId,
  494. int $quantity,
  495. ?int $instanceId = null
  496. ): bool {
  497. // 检查物品是否存在
  498. $item = Item::find($itemId);
  499. if (!$item) {
  500. return false;
  501. }
  502. // 检查数量是否合法
  503. if ($quantity <= 0) {
  504. return false;
  505. }
  506. // 检查可用数量是否足够
  507. return self::checkAvailableQuantity($userId, $itemId, $quantity, $instanceId);
  508. }
  509. /**
  510. * 批量冻结物品
  511. *
  512. * @param int $userId 用户ID
  513. * @param array $items 物品列表 [['item_id' => 1, 'quantity' => 10], ...]
  514. * @param FREEZE_REASON_TYPE $reason 冻结原因
  515. * @param int|null $sourceId 来源ID
  516. * @param string|null $sourceType 来源类型
  517. * @param int|null $operatorId 操作员ID
  518. * @return array 冻结结果
  519. * @throws Exception
  520. */
  521. public static function batchFreezeItems(
  522. int $userId,
  523. array $items,
  524. FREEZE_REASON_TYPE $reason,
  525. ?int $sourceId = null,
  526. ?string $sourceType = null,
  527. ?int $operatorId = null
  528. ): array {
  529. // 检查事务
  530. Helper::check_tr();
  531. $results = [];
  532. $errors = [];
  533. foreach ($items as $itemData) {
  534. $itemId = $itemData['item_id'];
  535. $quantity = $itemData['quantity'] ?? 1;
  536. $instanceId = $itemData['instance_id'] ?? null;
  537. try {
  538. if ($instanceId) {
  539. // 单独属性物品
  540. $result = self::freezeUniqueItem(
  541. $userId,
  542. $itemId,
  543. $instanceId,
  544. $reason,
  545. $sourceId,
  546. $sourceType,
  547. $operatorId
  548. );
  549. } else {
  550. // 统一属性物品
  551. $result = self::freezeNormalItem(
  552. $userId,
  553. $itemId,
  554. $quantity,
  555. $reason,
  556. $sourceId,
  557. $sourceType,
  558. $operatorId
  559. );
  560. }
  561. $results[] = $result;
  562. } catch (Exception $e) {
  563. $errors[] = [
  564. 'item_id' => $itemId,
  565. 'instance_id' => $instanceId,
  566. 'quantity' => $quantity,
  567. 'error' => $e->getMessage(),
  568. ];
  569. }
  570. }
  571. if (!empty($errors)) {
  572. throw new Exception("批量冻结操作部分失败:" . json_encode($errors, JSON_UNESCAPED_UNICODE));
  573. }
  574. return [
  575. 'success' => true,
  576. 'user_id' => $userId,
  577. 'frozen_items_count' => count($results),
  578. 'results' => $results,
  579. ];
  580. }
  581. /**
  582. * 检查冻结物品是否过期并处理
  583. *
  584. * @param int $userId 用户ID
  585. * @return int 处理的过期冻结物品数量
  586. */
  587. public static function handleExpiredFrozenItems(int $userId): int
  588. {
  589. // 查找过期的冻结物品
  590. $expiredFrozenItems = ItemUser::where('user_id', $userId)
  591. ->where('is_frozen', true)
  592. ->where('expire_at', '<', now())
  593. ->whereNotNull('expire_at')
  594. ->get();
  595. $processedCount = 0;
  596. foreach ($expiredFrozenItems as $frozenItem) {
  597. try {
  598. // 先解冻再处理过期
  599. if ($frozenItem->frozen_log_id) {
  600. self::unfreezeByLogId($frozenItem->frozen_log_id);
  601. }
  602. // 处理过期逻辑(这里可以根据业务需求决定是删除还是其他处理)
  603. // 暂时设置数量为0,不删除记录
  604. $frozenItem->quantity = 0;
  605. $frozenItem->save();
  606. $processedCount++;
  607. } catch (Exception $e) {
  608. // 记录错误日志,但不中断处理
  609. Log::error("处理过期冻结物品失败", [
  610. 'user_id' => $userId,
  611. 'item_user_id' => $frozenItem->id,
  612. 'error' => $e->getMessage(),
  613. ]);
  614. }
  615. }
  616. return $processedCount;
  617. }
  618. /**
  619. * 获取用户的冻结物品列表
  620. *
  621. * @param int $userId 用户ID
  622. * @param array $filters 过滤条件
  623. * @return Collection 冻结物品集合
  624. */
  625. public static function getFrozenItems(int $userId, array $filters = []): Collection
  626. {
  627. $query = ItemUser::where('user_id', $userId)
  628. ->where('is_frozen', true)
  629. ->with(['item', 'instance', 'freezeLog']);
  630. // 应用过滤条件
  631. if (isset($filters['item_id'])) {
  632. $query->where('item_id', $filters['item_id']);
  633. }
  634. if (isset($filters['source_type'])) {
  635. $query->whereHas('freezeLog', function ($q) use ($filters) {
  636. $q->where('source_type', $filters['source_type']);
  637. });
  638. }
  639. if (isset($filters['reason'])) {
  640. $query->whereHas('freezeLog', function ($q) use ($filters) {
  641. $q->where('reason', 'like', '%' . $filters['reason'] . '%');
  642. });
  643. }
  644. return $query->get();
  645. }
  646. /**
  647. * 获取冻结统计信息
  648. *
  649. * @param int $userId 用户ID
  650. * @return array 统计信息
  651. */
  652. public static function getFreezeStatistics(int $userId): array
  653. {
  654. $frozenItems = ItemUser::where('user_id', $userId)
  655. ->where('is_frozen', true)
  656. ->with(['item', 'freezeLog'])
  657. ->get();
  658. $statistics = [
  659. 'total_frozen_items' => $frozenItems->count(),
  660. 'total_frozen_quantity' => $frozenItems->sum('quantity'),
  661. 'frozen_by_reason' => [],
  662. 'frozen_by_source_type' => [],
  663. ];
  664. // 按原因分组统计
  665. $frozenItems->groupBy('freezeLog.reason')->each(function ($items, $reason) use (&$statistics) {
  666. $statistics['frozen_by_reason'][$reason] = [
  667. 'count' => $items->count(),
  668. 'quantity' => $items->sum('quantity'),
  669. ];
  670. });
  671. // 按来源类型分组统计
  672. $frozenItems->groupBy('freezeLog.source_type')->each(function ($items, $sourceType) use (&$statistics) {
  673. $statistics['frozen_by_source_type'][$sourceType] = [
  674. 'count' => $items->count(),
  675. 'quantity' => $items->sum('quantity'),
  676. ];
  677. });
  678. return $statistics;
  679. }
  680. /**
  681. * 安全解冻物品(处理已被消耗的冻结堆)
  682. *
  683. * 与unfreezeByLogId不同,此方法会检查冻结物品是否已被消耗:
  684. * - 如果冻结物品数量为0,则标记为已处理,不抛出异常
  685. * - 如果冻结物品数量大于0,则正常解冻
  686. * - 返回详细的处理结果信息
  687. *
  688. * @param int $freezeLogId 冻结日志ID
  689. * @return array 解冻结果
  690. * @throws Exception
  691. */
  692. public static function safeUnfreezeByLogId(int $freezeLogId): array
  693. {
  694. // 检查事务
  695. Helper::check_tr();
  696. // 查找冻结日志
  697. $freezeLog = ItemFreezeLog::find($freezeLogId);
  698. if (!$freezeLog) {
  699. throw new Exception("冻结日志 {$freezeLogId} 不存在");
  700. }
  701. if (!$freezeLog->isFreeze()) {
  702. throw new Exception("日志 {$freezeLogId} 不是冻结操作记录");
  703. }
  704. // 查找对应的冻结物品
  705. $frozenItem = ItemUser::where('frozen_log_id', $freezeLogId)
  706. ->where('is_frozen', true)
  707. ->first();
  708. if (!$frozenItem) {
  709. // 冻结物品不存在,可能已被删除或处理
  710. return [
  711. 'success' => true,
  712. 'status' => 'already_processed',
  713. 'message' => "冻结日志 {$freezeLogId} 对应的冻结物品不存在,可能已被处理",
  714. 'freeze_log_id' => $freezeLogId,
  715. 'unfrozen_quantity' => 0,
  716. ];
  717. }
  718. // 获取原始冻结数量和当前剩余数量
  719. $originalFrozenQuantity = $freezeLog->quantity;
  720. $currentQuantity = $frozenItem->quantity;
  721. if ($currentQuantity <= 0) {
  722. // 冻结堆已被完全消耗,尝试从用户其他可用物品中补足
  723. $availableQuantity = self::getAvailableQuantity(
  724. $frozenItem->user_id,
  725. $frozenItem->item_id,
  726. $frozenItem->instance_id
  727. );
  728. if ($availableQuantity < $originalFrozenQuantity) {
  729. // 用户可用数量不足,无法完全解冻
  730. return [
  731. 'success' => false,
  732. 'status' => 'insufficient_available',
  733. 'message' => "冻结物品已被完全消耗,用户可用数量不足以补足原始冻结数量",
  734. 'user_id' => $frozenItem->user_id,
  735. 'item_id' => $frozenItem->item_id,
  736. 'instance_id' => $frozenItem->instance_id,
  737. 'unfrozen_quantity' => 0,
  738. 'original_frozen_quantity' => $originalFrozenQuantity,
  739. 'current_frozen_quantity' => $currentQuantity,
  740. 'available_quantity' => $availableQuantity,
  741. 'shortage_quantity' => $originalFrozenQuantity - $availableQuantity,
  742. ];
  743. }
  744. // 从用户可用物品中补足全部数量
  745. $availableItems = ItemUser::where('user_id', $frozenItem->user_id)
  746. ->where('item_id', $frozenItem->item_id)
  747. ->where('is_frozen', false)
  748. ->whereNull('instance_id')
  749. ->where('quantity', '>', 0)
  750. ->orderBy('expire_at')
  751. ->get();
  752. $remainingQuantity = $originalFrozenQuantity;
  753. $transferDetails = []; // 记录转移详情
  754. foreach ($availableItems as $availableItem) {
  755. if ($remainingQuantity <= 0) break;
  756. $deductQuantity = min($availableItem->quantity, $remainingQuantity);
  757. $oldQuantity = $availableItem->quantity;
  758. $newQuantity = $oldQuantity - $deductQuantity;
  759. // 更新可用物品数量
  760. $availableItem->quantity = $newQuantity;
  761. $availableItem->save();
  762. // 记录转移详情
  763. $transferDetails[] = [
  764. 'from_user_item_id' => $availableItem->id,
  765. 'transferred_quantity' => $deductQuantity,
  766. 'old_quantity' => $oldQuantity,
  767. 'new_quantity' => $newQuantity,
  768. ];
  769. // 记录交易日志(从可用物品扣除)
  770. \App\Module\GameItems\Logics\Item::logTransaction(
  771. $frozenItem->user_id,
  772. $frozenItem->item_id,
  773. null,
  774. -$deductQuantity,
  775. TRANSACTION_TYPE::TRADE_OUT,
  776. 'safe_unfreeze_compensation',
  777. $freezeLogId,
  778. ["安全解冻补足转移:从可用物品转移 {$deductQuantity} 个到冻结堆"]
  779. );
  780. // 触发物品数量变更事件(可用物品减少)
  781. event(new ItemQuantityChanged(
  782. $frozenItem->user_id,
  783. $frozenItem->item_id,
  784. null,
  785. $oldQuantity,
  786. $newQuantity,
  787. $availableItem->id,
  788. false, // 旧冻结状态:未冻结
  789. false, // 新冻结状态:未冻结
  790. [
  791. 'action' => 'safe_unfreeze_compensation_transfer_out',
  792. 'freeze_log_id' => $freezeLogId,
  793. 'transferred_quantity' => $deductQuantity,
  794. ]
  795. ));
  796. $remainingQuantity -= $deductQuantity;
  797. }
  798. // 恢复冻结堆到原始数量
  799. $oldFrozenQuantity = $frozenItem->quantity;
  800. $frozenItem->quantity = $originalFrozenQuantity;
  801. $frozenItem->save();
  802. // 记录交易日志(向冻结堆补足)
  803. \App\Module\GameItems\Logics\Item::logTransaction(
  804. $frozenItem->user_id,
  805. $frozenItem->item_id,
  806. $frozenItem->instance_id,
  807. $originalFrozenQuantity,
  808. TRANSACTION_TYPE::TRADE_IN,
  809. 'safe_unfreeze_compensation',
  810. $freezeLogId,
  811. ["安全解冻补足转移:向冻结堆补足 {$originalFrozenQuantity} 个,转移详情:" . json_encode($transferDetails)]
  812. );
  813. // 触发物品数量变更事件(冻结堆增加)
  814. event(new ItemQuantityChanged(
  815. $frozenItem->user_id,
  816. $frozenItem->item_id,
  817. $frozenItem->instance_id,
  818. $oldFrozenQuantity,
  819. $originalFrozenQuantity,
  820. $frozenItem->id,
  821. true, // 旧冻结状态:已冻结
  822. true, // 新冻结状态:已冻结
  823. [
  824. 'action' => 'safe_unfreeze_compensation_transfer_in',
  825. 'freeze_log_id' => $freezeLogId,
  826. 'compensated_quantity' => $originalFrozenQuantity,
  827. 'transfer_details' => $transferDetails,
  828. ]
  829. ));
  830. $shortageQuantity = $originalFrozenQuantity;
  831. } else {
  832. // 检查是否需要补足差额
  833. $shortageQuantity = $originalFrozenQuantity - $currentQuantity;
  834. if ($shortageQuantity > 0) {
  835. // 冻结堆被部分消耗,需要从用户其他可用物品中补足
  836. $availableQuantity = self::getAvailableQuantity(
  837. $frozenItem->user_id,
  838. $frozenItem->item_id,
  839. $frozenItem->instance_id
  840. );
  841. if ($availableQuantity < $shortageQuantity) {
  842. return [
  843. 'success' => false,
  844. 'status' => 'insufficient_available',
  845. 'message' => "解冻失败:需要补足 {$shortageQuantity},但用户可用数量只有 {$availableQuantity}",
  846. 'user_id' => $frozenItem->user_id,
  847. 'item_id' => $frozenItem->item_id,
  848. 'instance_id' => $frozenItem->instance_id,
  849. 'unfrozen_quantity' => 0,
  850. 'original_frozen_quantity' => $originalFrozenQuantity,
  851. 'current_frozen_quantity' => $currentQuantity,
  852. 'shortage_quantity' => $shortageQuantity,
  853. 'available_quantity' => $availableQuantity,
  854. ];
  855. }
  856. // 从用户可用物品中扣除差额,补足到冻结堆
  857. $availableItems = ItemUser::where('user_id', $frozenItem->user_id)
  858. ->where('item_id', $frozenItem->item_id)
  859. ->where('is_frozen', false)
  860. ->whereNull('instance_id')
  861. ->where('quantity', '>', 0)
  862. ->orderBy('expire_at')
  863. ->get();
  864. $remainingShortage = $shortageQuantity;
  865. $transferDetails = []; // 记录转移详情
  866. foreach ($availableItems as $availableItem) {
  867. if ($remainingShortage <= 0) break;
  868. $deductQuantity = min($availableItem->quantity, $remainingShortage);
  869. $oldQuantity = $availableItem->quantity;
  870. $newQuantity = $oldQuantity - $deductQuantity;
  871. // 更新可用物品数量
  872. $availableItem->quantity = $newQuantity;
  873. $availableItem->save();
  874. // 记录转移详情
  875. $transferDetails[] = [
  876. 'from_user_item_id' => $availableItem->id,
  877. 'transferred_quantity' => $deductQuantity,
  878. 'old_quantity' => $oldQuantity,
  879. 'new_quantity' => $newQuantity,
  880. ];
  881. // 记录交易日志(从可用物品扣除)
  882. \App\Module\GameItems\Logics\Item::logTransaction(
  883. $frozenItem->user_id,
  884. $frozenItem->item_id,
  885. null,
  886. -$deductQuantity,
  887. TRANSACTION_TYPE::TRADE_OUT,
  888. 'safe_unfreeze_partial_compensation',
  889. $freezeLogId,
  890. ["安全解冻部分补足转移:从可用物品转移 {$deductQuantity} 个到冻结堆"]
  891. );
  892. // 触发物品数量变更事件(可用物品减少)
  893. event(new ItemQuantityChanged(
  894. $frozenItem->user_id,
  895. $frozenItem->item_id,
  896. null,
  897. $oldQuantity,
  898. $newQuantity,
  899. $availableItem->id,
  900. false, // 旧冻结状态:未冻结
  901. false, // 新冻结状态:未冻结
  902. [
  903. 'action' => 'safe_unfreeze_partial_compensation_transfer_out',
  904. 'freeze_log_id' => $freezeLogId,
  905. 'transferred_quantity' => $deductQuantity,
  906. ]
  907. ));
  908. $remainingShortage -= $deductQuantity;
  909. }
  910. // 将补足的数量加到冻结堆
  911. $oldFrozenQuantity = $frozenItem->quantity;
  912. $frozenItem->quantity = $originalFrozenQuantity;
  913. $frozenItem->save();
  914. // 记录交易日志(向冻结堆补足)
  915. \App\Module\GameItems\Logics\Item::logTransaction(
  916. $frozenItem->user_id,
  917. $frozenItem->item_id,
  918. $frozenItem->instance_id,
  919. $shortageQuantity,
  920. TRANSACTION_TYPE::TRADE_IN,
  921. 'safe_unfreeze_partial_compensation',
  922. $freezeLogId,
  923. ["安全解冻部分补足转移:向冻结堆补足 {$shortageQuantity} 个,转移详情:" . json_encode($transferDetails)]
  924. );
  925. // 触发物品数量变更事件(冻结堆增加)
  926. event(new ItemQuantityChanged(
  927. $frozenItem->user_id,
  928. $frozenItem->item_id,
  929. $frozenItem->instance_id,
  930. $oldFrozenQuantity,
  931. $originalFrozenQuantity,
  932. $frozenItem->id,
  933. true, // 旧冻结状态:已冻结
  934. true, // 新冻结状态:已冻结
  935. [
  936. 'action' => 'safe_unfreeze_partial_compensation_transfer_in',
  937. 'freeze_log_id' => $freezeLogId,
  938. 'compensated_quantity' => $shortageQuantity,
  939. 'transfer_details' => $transferDetails,
  940. ]
  941. ));
  942. }
  943. }
  944. // 创建解冻日志
  945. $unfreezeLog = ItemFreezeLog::createLog(
  946. $frozenItem->user_id,
  947. $frozenItem->item_id,
  948. $frozenItem->instance_id,
  949. $originalFrozenQuantity,
  950. FREEZE_ACTION_TYPE::UNFREEZE,
  951. "安全解冻操作,原冻结日志ID: {$freezeLogId},原始冻结数量: {$originalFrozenQuantity}" .
  952. ($shortageQuantity > 0 ? ",补足差额: {$shortageQuantity}" : ""),
  953. $freezeLog->source_id,
  954. $freezeLog->source_type,
  955. $freezeLog->operator_id
  956. );
  957. // 解冻物品
  958. $frozenItem->is_frozen = false;
  959. $frozenItem->frozen_log_id = null;
  960. $frozenItem->save();
  961. // 触发物品变更事件
  962. event(new ItemQuantityChanged(
  963. $frozenItem->user_id,
  964. $frozenItem->item_id,
  965. $frozenItem->instance_id,
  966. $originalFrozenQuantity,
  967. $originalFrozenQuantity,
  968. $frozenItem->id,
  969. true, // 旧冻结状态:已冻结
  970. false, // 新冻结状态:未冻结
  971. [
  972. 'freeze_action' => 'safe_unfreeze',
  973. 'unfreeze_log_id' => $unfreezeLog->id,
  974. 'original_freeze_log_id' => $freezeLogId,
  975. 'original_frozen_quantity' => $originalFrozenQuantity,
  976. 'shortage_compensated' => $shortageQuantity,
  977. 'source_id' => $freezeLog->source_id,
  978. 'source_type' => $freezeLog->source_type,
  979. 'operator_id' => $freezeLog->operator_id,
  980. ]
  981. ));
  982. return [
  983. 'success' => true,
  984. 'status' => 'unfrozen',
  985. 'message' => "成功解冻物品",
  986. 'user_id' => $frozenItem->user_id,
  987. 'item_id' => $frozenItem->item_id,
  988. 'instance_id' => $frozenItem->instance_id,
  989. 'unfrozen_quantity' => $originalFrozenQuantity,
  990. 'shortage_compensated' => $shortageQuantity,
  991. 'user_item_id' => $frozenItem->id,
  992. 'unfreeze_log_id' => $unfreezeLog->id,
  993. ];
  994. }
  995. /**
  996. * 获取已被消耗的冻结物品统计
  997. *
  998. * 查找所有数量为0的冻结物品记录并返回统计信息
  999. * 注意:不删除记录,只提供统计信息
  1000. *
  1001. * @param int|null $userId 用户ID,为null时统计所有用户
  1002. * @return array 统计结果
  1003. */
  1004. public static function getConsumedFrozenItemsStatistics(?int $userId = null): array
  1005. {
  1006. $query = ItemUser::where('is_frozen', true)
  1007. ->where('quantity', '<=', 0);
  1008. if ($userId) {
  1009. $query->where('user_id', $userId);
  1010. }
  1011. $consumedFrozenItems = $query->get();
  1012. $statistics = [
  1013. 'total_count' => $consumedFrozenItems->count(),
  1014. 'by_user' => [],
  1015. 'by_item' => [],
  1016. 'items' => [],
  1017. ];
  1018. foreach ($consumedFrozenItems as $frozenItem) {
  1019. // 按用户统计
  1020. if (!isset($statistics['by_user'][$frozenItem->user_id])) {
  1021. $statistics['by_user'][$frozenItem->user_id] = 0;
  1022. }
  1023. $statistics['by_user'][$frozenItem->user_id]++;
  1024. // 按物品统计
  1025. if (!isset($statistics['by_item'][$frozenItem->item_id])) {
  1026. $statistics['by_item'][$frozenItem->item_id] = 0;
  1027. }
  1028. $statistics['by_item'][$frozenItem->item_id]++;
  1029. // 详细记录
  1030. $statistics['items'][] = [
  1031. 'user_id' => $frozenItem->user_id,
  1032. 'item_id' => $frozenItem->item_id,
  1033. 'instance_id' => $frozenItem->instance_id,
  1034. 'user_item_id' => $frozenItem->id,
  1035. 'frozen_log_id' => $frozenItem->frozen_log_id,
  1036. 'quantity' => $frozenItem->quantity,
  1037. ];
  1038. }
  1039. return $statistics;
  1040. }
  1041. }