MexDailyPriceTrendController.php 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240
  1. <?php
  2. namespace App\Module\Mex\AdminControllers;
  3. use App\Module\Fund\Enums\FUND_CURRENCY_TYPE;
  4. use App\Module\Mex\AdminControllers\Helper\GridHelper;
  5. use App\Module\Mex\Metrics\PriceTrendChart;
  6. use App\Module\Mex\Repositories\MexDailyPriceTrendRepository;
  7. use App\Module\Mex\Service\MexDailyPriceTrendService;
  8. use Spatie\RouteAttributes\Attributes\Get;
  9. use Spatie\RouteAttributes\Attributes\Resource;
  10. use UCore\DcatAdmin\AdminController;
  11. use Dcat\Admin\Grid;
  12. use Dcat\Admin\Show;
  13. use Dcat\Admin\Layout\Content;
  14. /**
  15. * 农贸市场每日价格趋势管理
  16. *
  17. * 路由:/admin/mex-daily-price-trends
  18. */
  19. #[Resource('mex-daily-price-trends', names: 'dcat.admin.mex-daily-price-trends')]
  20. class MexDailyPriceTrendController extends AdminController
  21. {
  22. /**
  23. * 页面标题
  24. */
  25. protected $title = '农贸市场每日价格趋势';
  26. /**
  27. * 列表页面
  28. */
  29. public function index(Content $content)
  30. {
  31. return $content
  32. ->title('农贸市场每日价格趋势')
  33. ->description('价格趋势分析与数据管理')
  34. ->row(function ($row) {
  35. // 添加价格趋势图表
  36. $chart = new PriceTrendChart();
  37. $row->column(12, $chart);
  38. })
  39. ->body($this->grid());
  40. }
  41. /**
  42. * 数据表格
  43. */
  44. protected function grid()
  45. {
  46. return Grid::make(new MexDailyPriceTrendRepository(['item']), function (Grid $grid) {
  47. $helper = new GridHelper($grid, $this);
  48. $grid->column('id', 'ID')->sortable();
  49. $grid->column('item_id', '商品ID')->link(function ($value) {
  50. return admin_url("game-items/{$value}");
  51. });
  52. $grid->column('item.name', '商品名称');
  53. $grid->column('currency_type', '币种')->display(function ($value) {
  54. if (is_string($value)) {
  55. return FUND_CURRENCY_TYPE::from($value)->name;
  56. }
  57. return $value->name;
  58. });
  59. $grid->column('trade_date', '交易日期')->sortable();
  60. // 价格信息
  61. $grid->column('open_price', '开盘价')->display(function ($value) {
  62. return $value ? number_format($value, 5) : '-';
  63. });
  64. $grid->column('close_price', '收盘价')->display(function ($value) {
  65. return $value ? number_format($value, 5) : '-';
  66. });
  67. $grid->column('high_price', '最高价')->display(function ($value) {
  68. return $value ? number_format($value, 5) : '-';
  69. });
  70. $grid->column('low_price', '最低价')->display(function ($value) {
  71. return $value ? number_format($value, 5) : '-';
  72. });
  73. // 价格变化
  74. $grid->column('price_change_percent', '涨跌幅')->display(function ($value) {
  75. if ($value === null) return '-';
  76. $color = $value > 0 ? 'success' : ($value < 0 ? 'danger' : 'secondary');
  77. $symbol = $value > 0 ? '+' : '';
  78. return "<span class='text-{$color}'>{$symbol}" . number_format($value, 2) . "%</span>";
  79. });
  80. // 交易统计
  81. $grid->column('total_volume', '成交量')->sortable();
  82. $grid->column('total_amount', '成交额')->display(function ($value) {
  83. return number_format($value, 5);
  84. })->sortable();
  85. $grid->column('transaction_count', '成交笔数');
  86. // 波动率
  87. $grid->column('volatility', '波动率')->display(function ($value) {
  88. if ($value === null) return '-';
  89. $level = $this->volatility_level;
  90. $color = match($level) {
  91. '低波动' => 'success',
  92. '中等波动' => 'warning',
  93. '高波动' => 'danger',
  94. '极高波动' => 'dark',
  95. default => 'secondary'
  96. };
  97. return "<span class='badge badge-{$color}'>{$level} (" . number_format($value, 2) . "%)</span>";
  98. });
  99. $helper->columnUpdatedAt();
  100. // 筛选器
  101. $grid->filter(function (Grid\Filter $filter) {
  102. $filter->equal('item_id', '商品ID');
  103. $filter->equal('currency_type', '币种')->select([
  104. FUND_CURRENCY_TYPE::ZUANSHI->value => '钻石',
  105. FUND_CURRENCY_TYPE::JINBI->value => '金币',
  106. ]);
  107. $filter->between('trade_date', '交易日期')->date();
  108. $filter->between('total_volume', '成交量范围');
  109. $filter->between('total_amount', '成交额范围');
  110. $filter->between('price_change_percent', '涨跌幅范围');
  111. });
  112. // 默认排序
  113. $grid->model()->orderBy('trade_date', 'desc')->orderBy('item_id');
  114. // 禁用新增、编辑、删除操作
  115. $grid->disableCreateButton();
  116. $grid->disableActions();
  117. $grid->disableBatchActions();
  118. // 添加工具栏按钮
  119. $grid->tools(function (Grid\Tools $tools) {
  120. $tools->append('<a href="' . admin_url('mex-daily-price-trends/generate') . '" class="btn btn-primary btn-sm">
  121. <i class="fa fa-refresh"></i> 生成趋势数据
  122. </a>');
  123. });
  124. });
  125. }
  126. /**
  127. * 详情页面
  128. */
  129. protected function detail($id)
  130. {
  131. return Show::make($id, new MexDailyPriceTrendRepository(['item']), function (Show $show) {
  132. $show->field('id', 'ID');
  133. $show->field('item_id', '商品ID');
  134. $show->field('item.name', '商品名称');
  135. $show->field('currency_type', '币种')->as(function ($value) {
  136. if (is_string($value)) {
  137. return FUND_CURRENCY_TYPE::from($value)->name;
  138. }
  139. return $value->name;
  140. });
  141. $show->field('trade_date', '交易日期');
  142. $show->divider('价格信息');
  143. $show->field('open_price', '开盘价')->as(function ($value) {
  144. return $value ? number_format($value, 5) : '-';
  145. });
  146. $show->field('close_price', '收盘价')->as(function ($value) {
  147. return $value ? number_format($value, 5) : '-';
  148. });
  149. $show->field('high_price', '最高价')->as(function ($value) {
  150. return $value ? number_format($value, 5) : '-';
  151. });
  152. $show->field('low_price', '最低价')->as(function ($value) {
  153. return $value ? number_format($value, 5) : '-';
  154. });
  155. $show->field('avg_price', '平均价')->as(function ($value) {
  156. return $value ? number_format($value, 5) : '-';
  157. });
  158. $show->divider('价格变化');
  159. $show->field('price_change', '价格变化')->as(function ($value) {
  160. return $value ? number_format($value, 5) : '-';
  161. });
  162. $show->field('price_change_percent', '涨跌幅')->as(function ($value) {
  163. return $value ? number_format($value, 2) . '%' : '-';
  164. });
  165. $show->field('volatility', '波动率')->as(function ($value) {
  166. return $value ? number_format($value, 2) . '%' : '-';
  167. });
  168. $show->divider('交易统计');
  169. $show->field('total_volume', '总成交量');
  170. $show->field('total_amount', '总成交额')->as(function ($value) {
  171. return number_format($value, 5);
  172. });
  173. $show->field('transaction_count', '成交笔数');
  174. $show->field('buy_volume', '买入量');
  175. $show->field('sell_volume', '卖出量');
  176. $show->field('buy_amount', '买入额')->as(function ($value) {
  177. return number_format($value, 5);
  178. });
  179. $show->field('sell_amount', '卖出额')->as(function ($value) {
  180. return number_format($value, 5);
  181. });
  182. $show->divider('管理员操作');
  183. $show->field('admin_inject_volume', '管理员注入量');
  184. $show->field('admin_recycle_volume', '管理员回收量');
  185. $show->field('admin_inject_amount', '管理员注入额')->as(function ($value) {
  186. return number_format($value, 5);
  187. });
  188. $show->field('admin_recycle_amount', '管理员回收额')->as(function ($value) {
  189. return number_format($value, 5);
  190. });
  191. $show->field('created_at', '创建时间');
  192. $show->field('updated_at', '更新时间');
  193. // 禁用编辑和删除按钮
  194. $show->disableEditButton();
  195. $show->disableDeleteButton();
  196. });
  197. }
  198. /**
  199. * 生成趋势数据
  200. */
  201. #[Get('mex-daily-price-trends/generate', name: 'admin.mex-daily-price-trends.generate')]
  202. public function generate()
  203. {
  204. try {
  205. // 调用服务生成今日价格趋势数据
  206. $trends = MexDailyPriceTrendService::generateTodayTrends();
  207. return redirect()->back()->with('success', "价格趋势数据生成成功!共生成 {$trends->count()} 条记录。");
  208. } catch (\Exception $e) {
  209. return redirect()->back()->with('error', '生成失败:' . $e->getMessage());
  210. }
  211. }
  212. }