GridHelperTrait.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439
  1. <?php
  2. namespace App\Module\Game\AdminControllers\Helper;
  3. use App\Module\Game\Enums\REWARD_SOURCE_TYPE;
  4. use App\Module\Game\Enums\REWARD_TYPE;
  5. use App\Module\Game\Models\GameRewardGroup;
  6. use App\Module\User\Enums\STATUS2;
  7. use Dcat\Admin\Grid;
  8. use Dcat\Admin\Grid\Column;
  9. /**
  10. * 游戏用户列表页辅助特性
  11. *
  12. * 提供游戏用户模块后台控制器的列表页构建功能的具体实现
  13. * 包含用户基础信息和游戏相关信息的显示方法
  14. */
  15. trait GridHelperTrait
  16. {
  17. /**
  18. * 添加用户信息组合列
  19. *
  20. * 复用价值:高 - 将用户ID、用户名和头像组合显示,提高信息密度
  21. *
  22. * @param string $idField 用户ID字段名
  23. * @param string $usernameField 用户名字段名
  24. * @param string $avatarField 头像字段名
  25. * @param string $label 标签名
  26. * @return Column
  27. */
  28. public function columnUserInfo(string $idField = 'id', string $usernameField = 'username', string $avatarField = 'avatar', string $label = '用户信息'): Column
  29. {
  30. return $this->grid->column($idField, $label)->display(function ($userId) use ($usernameField, $avatarField) {
  31. $username = $this->{$usernameField} ?? '';
  32. $avatar = $this->{$avatarField} ?? '';
  33. $avatarHtml = $avatar ? "<img src='{$avatar}' width='30' height='30' style='border-radius: 50%; margin-right: 5px;'>" : '';
  34. return <<<HTML
  35. <div style="display: flex; align-items: center;">
  36. {$avatarHtml}
  37. <div>
  38. <div>ID: {$userId}</div>
  39. <div>{$username}</div>
  40. </div>
  41. </div>
  42. HTML;
  43. });
  44. }
  45. /**
  46. * 添加用户联系信息组合列
  47. *
  48. * 复用价值:高 - 将用户手机号、邮箱和微信号组合显示,提高信息密度
  49. *
  50. * @param string $phoneField 手机号字段名
  51. * @param string $emailField 邮箱字段名
  52. * @param string $wxIdField 微信号字段名
  53. * @param string $label 标签名
  54. * @return Column
  55. */
  56. public function columnUserContact(string $phoneField = 'phone', string $emailField = 'email', string $wxIdField = 'wx_id', string $label = '联系方式'): Column
  57. {
  58. return $this->grid->column($phoneField, $label)->display(function ($phone) use ($emailField, $wxIdField) {
  59. $email = $this->{$emailField} ?? '';
  60. $wxId = $this->{$wxIdField} ?? '';
  61. $phoneHtml = $phone ? "<div>手机: {$phone}</div>" : '';
  62. $emailHtml = $email ? "<div>邮箱: {$email}</div>" : '';
  63. $wxIdHtml = $wxId ? "<div>微信: {$wxId}</div>" : '';
  64. return $phoneHtml . $emailHtml . $wxIdHtml;
  65. });
  66. }
  67. /**
  68. * 添加时间信息组合列
  69. *
  70. * 复用价值:高 - 将创建时间和更新时间组合显示,提高信息密度
  71. *
  72. * @param string $createdAtField 创建时间字段名
  73. * @param string $updatedAtField 更新时间字段名
  74. * @param string $label 标签名
  75. * @return Column
  76. */
  77. public function columnTimes(string $createdAtField = 'created_at', string $updatedAtField = 'updated_at', string $label = '时间信息'): Column
  78. {
  79. return $this->grid->column($createdAtField, $label)->display(function ($createdAt) use ($updatedAtField) {
  80. $updatedAt = $this->{$updatedAtField} ?? '';
  81. $createdAtHtml = "<div>创建: {$createdAt}</div>";
  82. $updatedAtHtml = $updatedAt ? "<div>更新: {$updatedAt}</div>" : '';
  83. return $createdAtHtml . $updatedAtHtml;
  84. });
  85. }
  86. /**
  87. * 添加用户资金账户信息列
  88. *
  89. * 复用价值:高 - 显示用户的资金账户信息
  90. *
  91. * @param string $idField 用户ID字段名
  92. * @param string $label 标签名
  93. * @return Column
  94. */
  95. public function columnUserFunds(string $idField = 'id', string $label = '资金账户'): Column
  96. {
  97. return $this->grid->column($idField, $label)->display(function ($userId) {
  98. // 获取用户的资金账户
  99. $funds = \App\Module\Fund\Models\FundModel::where('user_id', $userId)->get();
  100. if ($funds->isEmpty()) {
  101. return '<span class="text-muted">无资金账户</span>';
  102. }
  103. $fundNames = \App\Module\Fund\Services\AccountService::getFundsDesc();
  104. $html = '<div style="max-height: 150px; overflow-y: auto;">';
  105. foreach ($funds as $fund) {
  106. $fundName = $fundNames[$fund->fund_id] ?? "未知类型({$fund->fund_id})";
  107. $balance = number_format($fund->balance / 100, 2);
  108. $html .= "<div><span class='badge badge-info'>{$fundName}</span>: {$balance}</div>";
  109. }
  110. $html .= '</div>';
  111. $html .= "<div><a href='" . admin_url("fund-accounts?user_id={$userId}") . "' class='text-primary'>查看详情</a></div>";
  112. return $html;
  113. });
  114. }
  115. /**
  116. * 添加用户物品信息列
  117. *
  118. * 复用价值:高 - 显示用户的物品信息
  119. *
  120. * @param string $idField 用户ID字段名
  121. * @param string $label 标签名
  122. * @return Column
  123. */
  124. public function columnUserItems(string $idField = 'id', string $label = '物品背包'): Column
  125. {
  126. return $this->grid->column($idField, $label)->display(function ($userId) {
  127. // 获取用户的物品(限制最多显示5个)
  128. $items = \App\Module\GameItems\Models\ItemUser::with('item')
  129. ->where('user_id', $userId)
  130. ->orderBy('quantity', 'desc')
  131. ->limit(5)
  132. ->get();
  133. if ($items->isEmpty()) {
  134. return '<span class="text-muted">无物品</span>';
  135. }
  136. $html = '<div style="max-height: 150px; overflow-y: auto;">';
  137. foreach ($items as $userItem) {
  138. $itemName = $userItem->item->name ?? "物品 {$userItem->item_id}";
  139. $quantity = $userItem->quantity;
  140. $html .= "<div><span class='badge badge-success'>{$itemName}</span> x {$quantity}</div>";
  141. }
  142. // 获取用户物品总数
  143. $totalCount = \App\Module\GameItems\Models\ItemUser::where('user_id', $userId)->count();
  144. if ($totalCount > 5) {
  145. $html .= "<div>... 共 {$totalCount} 种物品</div>";
  146. }
  147. $html .= '</div>';
  148. $html .= "<div><a href='" . admin_url("game-items-users?user_id={$userId}") . "' class='text-primary'>查看详情</a></div>";
  149. return $html;
  150. });
  151. }
  152. /**
  153. * 添加用户土地信息列
  154. *
  155. * 复用价值:高 - 显示用户的土地信息
  156. *
  157. * @param string $idField 用户ID字段名
  158. * @param string $label 标签名
  159. * @return Column
  160. */
  161. public function columnUserLands(string $idField = 'id', string $label = '土地信息'): Column
  162. {
  163. return $this->grid->column($idField, $label)->display(function ($userId) {
  164. // 获取用户的土地
  165. $lands = \App\Module\Farm\Models\FarmLand::where('user_id', $userId)->get();
  166. if ($lands->isEmpty()) {
  167. return '<span class="text-muted">无土地</span>';
  168. }
  169. // 获取土地状态统计
  170. $statusCounts = $lands->groupBy('status')->map->count();
  171. $statusMap = [
  172. \App\Module\Farm\Enums\LAND_STATUS::IDLE->value => '空闲',
  173. \App\Module\Farm\Enums\LAND_STATUS::PLANTING->value => '种植中',
  174. \App\Module\Farm\Enums\LAND_STATUS::DISASTER->value => '灾害',
  175. \App\Module\Farm\Enums\LAND_STATUS::HARVESTABLE->value => '可收获',
  176. \App\Module\Farm\Enums\LAND_STATUS::WITHERED->value => '枯萎'
  177. ];
  178. $html = '<div style="max-height: 150px; overflow-y: auto;">';
  179. $html .= "<div>总数: {$lands->count()} 块</div>";
  180. foreach ($statusCounts as $status => $count) {
  181. $statusName = $statusMap[$status] ?? "未知状态({$status})";
  182. $badgeClass = match($status) {
  183. \App\Module\Farm\Enums\LAND_STATUS::IDLE->value => 'secondary',
  184. \App\Module\Farm\Enums\LAND_STATUS::PLANTING->value => 'primary',
  185. \App\Module\Farm\Enums\LAND_STATUS::DISASTER->value => 'warning',
  186. \App\Module\Farm\Enums\LAND_STATUS::HARVESTABLE->value => 'success',
  187. \App\Module\Farm\Enums\LAND_STATUS::WITHERED->value => 'danger',
  188. default => 'info'
  189. };
  190. $html .= "<div><span class='badge badge-{$badgeClass}'>{$statusName}</span>: {$count} 块</div>";
  191. }
  192. $html .= '</div>';
  193. $html .= "<div><a href='" . admin_url("farm-lands?user_id={$userId}") . "' class='text-primary'>查看详情</a></div>";
  194. return $html;
  195. });
  196. }
  197. /**
  198. * 添加用户神像buff信息列
  199. *
  200. * 复用价值:高 - 显示用户的神像buff信息
  201. *
  202. * @param string $idField 用户ID字段名
  203. * @param string $label 标签名
  204. * @return Column
  205. */
  206. public function columnUserBuffs(string $idField = 'id', string $label = '神像加持'): Column
  207. {
  208. return $this->grid->column($idField, $label)->display(function ($userId) {
  209. // 获取用户的神像buff
  210. $buffs = \App\Module\Farm\Models\FarmGodBuff::where('user_id', $userId)
  211. ->where('expire_time', '>', now())
  212. ->get();
  213. if ($buffs->isEmpty()) {
  214. return '<span class="text-muted">无有效神像加持</span>';
  215. }
  216. $buffTypes = [
  217. \App\Module\Farm\Enums\BUFF_TYPE::HARVEST_GOD->value => '丰收之神',
  218. \App\Module\Farm\Enums\BUFF_TYPE::RAIN_GOD->value => '雨露之神',
  219. \App\Module\Farm\Enums\BUFF_TYPE::WEED_KILLER_GOD->value => '屠草之神',
  220. \App\Module\Farm\Enums\BUFF_TYPE::PEST_CLEANER_GOD->value => '拭虫之神'
  221. ];
  222. $html = '<div style="max-height: 150px; overflow-y: auto;">';
  223. foreach ($buffs as $buff) {
  224. $buffName = $buffTypes[$buff->buff_type] ?? "未知神像({$buff->buff_type})";
  225. $expireTime = $buff->expire_time->format('Y-m-d H:i:s');
  226. $html .= "<div><span class='badge badge-warning'>{$buffName}</span> 到期: {$expireTime}</div>";
  227. }
  228. $html .= '</div>';
  229. $html .= "<div><a href='" . admin_url("farm-god-buffs?user_id={$userId}") . "' class='text-primary'>查看详情</a></div>";
  230. return $html;
  231. });
  232. }
  233. /**
  234. * 添加用户种植作物信息列
  235. *
  236. * 复用价值:高 - 显示用户的种植作物信息
  237. *
  238. * @param string $idField 用户ID字段名
  239. * @param string $label 标签名
  240. * @return Column
  241. */
  242. public function columnUserCrops(string $idField = 'id', string $label = '种植作物'): Column
  243. {
  244. return $this->grid->column($idField, $label)->display(function ($userId) {
  245. // 获取用户的作物
  246. $crops = \App\Module\Farm\Models\FarmCrop::with(['seed', 'land'])
  247. ->where('user_id', $userId)
  248. ->get();
  249. if ($crops->isEmpty()) {
  250. return '<span class="text-muted">无种植作物</span>';
  251. }
  252. // 获取作物生长阶段统计
  253. $stageCounts = $crops->groupBy('growth_stage')->map->count();
  254. $stageMap = [
  255. \App\Module\Farm\Enums\GROWTH_STAGE::SEED->value => '种子期',
  256. \App\Module\Farm\Enums\GROWTH_STAGE::SPROUT->value => '发芽期',
  257. \App\Module\Farm\Enums\GROWTH_STAGE::GROWTH->value => '生长期',
  258. \App\Module\Farm\Enums\GROWTH_STAGE::MATURE->value => '成熟期',
  259. \App\Module\Farm\Enums\GROWTH_STAGE::WITHERED->value => '枯萎期'
  260. ];
  261. $html = '<div style="max-height: 150px; overflow-y: auto;">';
  262. $html .= "<div>总数: {$crops->count()} 株</div>";
  263. foreach ($stageCounts as $stage => $count) {
  264. $stageName = $stageMap[$stage] ?? "未知阶段({$stage})";
  265. $badgeClass = match($stage) {
  266. \App\Module\Farm\Enums\GROWTH_STAGE::SEED->value => 'secondary',
  267. \App\Module\Farm\Enums\GROWTH_STAGE::SPROUT->value => 'info',
  268. \App\Module\Farm\Enums\GROWTH_STAGE::GROWTH->value => 'primary',
  269. \App\Module\Farm\Enums\GROWTH_STAGE::MATURE->value => 'success',
  270. \App\Module\Farm\Enums\GROWTH_STAGE::WITHERED->value => 'danger',
  271. default => 'dark'
  272. };
  273. $html .= "<div><span class='badge badge-{$badgeClass}'>{$stageName}</span>: {$count} 株</div>";
  274. }
  275. $html .= '</div>';
  276. $html .= "<div><a href='" . admin_url("farm-crops?user_id={$userId}") . "' class='text-primary'>查看详情</a></div>";
  277. return $html;
  278. });
  279. }
  280. /**
  281. * 添加奖励类型列
  282. *
  283. * @param string $field 字段名
  284. * @param string $label 标签名
  285. * @return Column
  286. */
  287. public function columnRewardType(string $field = 'reward_type', string $label = '奖励类型'): Column
  288. {
  289. return $this->grid->column($field, $label)->display(function ($value) {
  290. return REWARD_TYPE::getName($value);
  291. })->label([
  292. REWARD_TYPE::ITEM->value => 'primary',
  293. REWARD_TYPE::CURRENCY->value => 'success',
  294. REWARD_TYPE::PET_EXP->value => 'info',
  295. REWARD_TYPE::PET_ENERGY->value => 'warning',
  296. REWARD_TYPE::OTHER->value => 'default',
  297. ]);
  298. }
  299. /**
  300. * 添加奖励来源类型列
  301. *
  302. * @param string $field 字段名
  303. * @param string $label 标签名
  304. * @return Column
  305. */
  306. public function columnRewardSourceType(string $field = 'source_type', string $label = '奖励来源'): Column
  307. {
  308. return $this->grid->column($field, $label)->display(function ($value) {
  309. return REWARD_SOURCE_TYPE::getName($value);
  310. })->label([
  311. REWARD_SOURCE_TYPE::TASK->value => 'primary',
  312. REWARD_SOURCE_TYPE::ACTIVITY->value => 'success',
  313. REWARD_SOURCE_TYPE::SIGN_IN->value => 'info',
  314. REWARD_SOURCE_TYPE::ACHIEVEMENT->value => 'warning',
  315. REWARD_SOURCE_TYPE::LEVEL->value => 'danger',
  316. REWARD_SOURCE_TYPE::CHEST->value => 'dark',
  317. REWARD_SOURCE_TYPE::SYSTEM->value => 'default',
  318. ]);
  319. }
  320. /**
  321. * 添加奖励组列
  322. *
  323. * @param string $field 字段名
  324. * @param string $label 标签名
  325. * @return Column
  326. */
  327. public function columnRewardGroup(string $field = 'group_id', string $label = '奖励组'): Column
  328. {
  329. return $this->grid->column($field, $label)->display(function ($value) {
  330. $group = GameRewardGroup::find($value);
  331. return $group ? "{$group->name} ({$group->code})" : "未知 ({$value})";
  332. });
  333. }
  334. /**
  335. * 添加奖励项列
  336. *
  337. * @param string $field 字段名
  338. * @param string $label 标签名
  339. * @return Column
  340. */
  341. public function columnRewardItems(string $field = 'reward_items', string $label = '奖励项'): Column
  342. {
  343. return $this->grid->column($field, $label)->display(function ($value) {
  344. $items = json_decode($value, true);
  345. if (empty($items)) {
  346. return '无奖励项';
  347. }
  348. $count = count($items);
  349. return "<span class=\"badge badge-primary\">{$count}个奖励项</span>";
  350. });
  351. }
  352. /**
  353. * 添加是否随机发放列
  354. *
  355. * @param string $field 字段名
  356. * @param string $label 标签名
  357. * @return Column
  358. */
  359. public function columnIsRandom(string $field = 'is_random', string $label = '随机发放'): Column
  360. {
  361. return $this->grid->column($field, $label)->switch();
  362. }
  363. /**
  364. * 添加是否必中列
  365. *
  366. * @param string $field 字段名
  367. * @param string $label 标签名
  368. * @return Column
  369. */
  370. public function columnIsGuaranteed(string $field = 'is_guaranteed', string $label = '必中'): Column
  371. {
  372. return $this->grid->column($field, $label)->switch();
  373. }
  374. /**
  375. * 添加权重列
  376. *
  377. * @param string $field 字段名
  378. * @param string $label 标签名
  379. * @return Column
  380. */
  381. public function columnWeight(string $field = 'weight', string $label = '权重'): Column
  382. {
  383. return $this->grid->column($field, $label)->sortable();
  384. }
  385. }