GridHelperTrait.php 14 KB

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