CleanupTaskController.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291
  1. <?php
  2. namespace App\Module\Cleanup\AdminControllers;
  3. use App\Module\Cleanup\Models\CleanupTask;
  4. use App\Module\Cleanup\Repositories\CleanupTaskRepository;
  5. use App\Module\Cleanup\Enums\TASK_STATUS;
  6. use UCore\DcatAdmin\AdminController;
  7. use Dcat\Admin\Form;
  8. use Dcat\Admin\Grid;
  9. use Dcat\Admin\Show;
  10. use Dcat\Admin\Layout\Content;
  11. use Spatie\RouteAttributes\Attributes\Resource;
  12. /**
  13. * 清理任务管理控制器
  14. *
  15. * 路由:/admin/cleanup/tasks
  16. */
  17. #[Resource('cleanup/tasks', names: 'dcat.admin.cleanup.tasks')]
  18. class CleanupTaskController extends AdminController
  19. {
  20. /**
  21. * 页面标题
  22. */
  23. protected $title = '清理任务管理';
  24. /**
  25. * 数据仓库
  26. */
  27. protected function repository()
  28. {
  29. return CleanupTaskRepository::class;
  30. }
  31. /**
  32. * 列表页面
  33. */
  34. protected function grid(): Grid
  35. {
  36. return Grid::make(new CleanupTaskRepository(), function (Grid $grid) {
  37. // 基础设置
  38. $grid->column('id', 'ID')->sortable();
  39. $grid->column('task_name', '任务名称')->sortable();
  40. // 关联计划
  41. $grid->column('plan.plan_name', '关联计划')->sortable();
  42. // 任务状态
  43. $grid->column('status', '任务状态')->using([
  44. 1 => '待执行',
  45. 2 => '备份中',
  46. 3 => '执行中',
  47. 4 => '已完成',
  48. 5 => '已失败',
  49. 6 => '已取消',
  50. 7 => '已暂停',
  51. ])->label([
  52. 1 => 'secondary',
  53. 2 => 'info',
  54. 3 => 'primary',
  55. 4 => 'success',
  56. 5 => 'danger',
  57. 6 => 'warning',
  58. 7 => 'dark',
  59. ])->sortable();
  60. // 进度信息
  61. $grid->column('progress', '执行进度')->display(function ($progress) {
  62. $color = 'secondary';
  63. if ($progress >= 100) $color = 'success';
  64. elseif ($progress >= 50) $color = 'primary';
  65. elseif ($progress > 0) $color = 'info';
  66. return "<div class='progress' style='height: 20px;'>
  67. <div class='progress-bar bg-{$color}' style='width: {$progress}%'>{$progress}%</div>
  68. </div>";
  69. });
  70. $grid->column('current_step', '当前步骤');
  71. // 统计信息
  72. $grid->column('processed_tables', '处理进度')->display(function () {
  73. return "{$this->processed_tables}/{$this->total_tables}";
  74. });
  75. $grid->column('deleted_records', '删除记录数')->display(function ($value) {
  76. return number_format($value);
  77. });
  78. // 执行时间
  79. $grid->column('execution_time', '执行时间(秒)')->display(function ($value) {
  80. return number_format($value, 3);
  81. });
  82. // 时间信息
  83. $grid->column('started_at', '开始时间')->sortable();
  84. $grid->column('completed_at', '完成时间')->sortable();
  85. $grid->column('created_at', '创建时间')->sortable();
  86. // 筛选器
  87. $grid->filter(function (Grid\Filter $filter) {
  88. $filter->equal('status', '任务状态')->select([
  89. 1 => '待执行',
  90. 2 => '备份中',
  91. 3 => '执行中',
  92. 4 => '已完成',
  93. 5 => '已失败',
  94. 6 => '已取消',
  95. 7 => '已暂停',
  96. ]);
  97. $filter->equal('plan_id', '关联计划')->select(
  98. \App\Module\Cleanup\Models\CleanupPlan::pluck('plan_name', 'id')->toArray()
  99. );
  100. $filter->like('task_name', '任务名称');
  101. $filter->between('created_at', '创建时间')->datetime();
  102. $filter->between('started_at', '开始时间')->datetime();
  103. $filter->between('completed_at', '完成时间')->datetime();
  104. });
  105. // 行操作
  106. $grid->actions(function (Grid\Displayers\Actions $actions) {
  107. $row = $actions->row;
  108. // 根据状态显示不同操作
  109. if ($row->status == 1) { // 待执行
  110. $actions->append(new \App\Module\Cleanup\AdminControllers\Actions\StartTaskAction());
  111. } elseif ($row->status == 3) { // 执行中
  112. $actions->append(new \App\Module\Cleanup\AdminControllers\Actions\PauseTaskAction());
  113. $actions->append(new \App\Module\Cleanup\AdminControllers\Actions\CancelTaskAction());
  114. } elseif ($row->status == 7) { // 已暂停
  115. $actions->append(new \App\Module\Cleanup\AdminControllers\Actions\ResumeTaskAction());
  116. $actions->append(new \App\Module\Cleanup\AdminControllers\Actions\CancelTaskAction());
  117. }
  118. $actions->append(new \App\Module\Cleanup\AdminControllers\Actions\ViewTaskLogsAction());
  119. if ($row->backup_id) {
  120. $actions->append(new \App\Module\Cleanup\AdminControllers\Actions\ViewBackupAction());
  121. }
  122. });
  123. // 批量操作
  124. $grid->batchActions([
  125. new \App\Module\Cleanup\AdminControllers\Actions\BatchCancelTaskAction(),
  126. ]);
  127. // 工具栏
  128. $grid->tools([
  129. new \App\Module\Cleanup\AdminControllers\Actions\CreateTaskAction(),
  130. ]);
  131. // 设置每页显示数量
  132. $grid->paginate(20);
  133. // 默认排序
  134. $grid->model()->orderBy('created_at', 'desc');
  135. });
  136. }
  137. /**
  138. * 详情页面
  139. */
  140. protected function detail($id): Show
  141. {
  142. return Show::make($id, new CleanupTaskRepository(), function (Show $show) {
  143. $show->field('id', 'ID');
  144. $show->field('task_name', '任务名称');
  145. $show->field('plan.plan_name', '关联计划');
  146. $show->field('status', '任务状态')->using([
  147. 1 => '待执行',
  148. 2 => '备份中',
  149. 3 => '执行中',
  150. 4 => '已完成',
  151. 5 => '已失败',
  152. 6 => '已取消',
  153. 7 => '已暂停',
  154. ]);
  155. $show->field('progress', '执行进度')->display(function ($progress) {
  156. return $progress . '%';
  157. });
  158. $show->field('current_step', '当前步骤');
  159. // 统计信息
  160. $show->field('total_tables', '总表数');
  161. $show->field('processed_tables', '已处理表数');
  162. $show->field('total_records', '总记录数')->display(function ($value) {
  163. return number_format($value);
  164. });
  165. $show->field('deleted_records', '已删除记录数')->display(function ($value) {
  166. return number_format($value);
  167. });
  168. // 性能信息
  169. $show->field('backup_size', '备份大小')->display(function ($value) {
  170. return \App\Module\Cleanup\Helpers\FormatHelper::formatBytes($value);
  171. });
  172. $show->field('execution_time', '执行时间')->display(function ($value) {
  173. return number_format($value, 3) . ' 秒';
  174. });
  175. $show->field('backup_time', '备份时间')->display(function ($value) {
  176. return number_format($value, 3) . ' 秒';
  177. });
  178. // 时间信息
  179. $show->field('started_at', '开始时间');
  180. $show->field('backup_completed_at', '备份完成时间');
  181. $show->field('completed_at', '完成时间');
  182. $show->field('error_message', '错误信息');
  183. $show->field('created_by', '创建者ID');
  184. $show->field('created_at', '创建时间');
  185. $show->field('updated_at', '更新时间');
  186. // 显示任务日志
  187. $show->relation('logs', '执行日志', function ($model) {
  188. $grid = new Grid(new \App\Module\Cleanup\Models\CleanupLog());
  189. $grid->model()->where('task_id', $model->id);
  190. $grid->column('table_name', '表名');
  191. $grid->column('cleanup_type', '清理类型')->using([
  192. 1 => '清空表',
  193. 2 => '删除所有',
  194. 3 => '按时间删除',
  195. 4 => '按用户删除',
  196. 5 => '按条件删除',
  197. ]);
  198. $grid->column('before_count', '清理前记录数')->display(function ($value) {
  199. return number_format($value);
  200. });
  201. $grid->column('after_count', '清理后记录数')->display(function ($value) {
  202. return number_format($value);
  203. });
  204. $grid->column('deleted_records', '删除记录数')->display(function ($value) {
  205. return number_format($value);
  206. });
  207. $grid->column('execution_time', '执行时间(秒)');
  208. $grid->column('created_at', '执行时间');
  209. $grid->disableActions();
  210. $grid->disableCreateButton();
  211. $grid->disableFilter();
  212. $grid->disablePagination();
  213. return $grid;
  214. });
  215. });
  216. }
  217. /**
  218. * 创建表单
  219. */
  220. protected function form(): Form
  221. {
  222. return Form::make(new CleanupTaskRepository(), function (Form $form) {
  223. $form->display('id', 'ID');
  224. $form->text('task_name', '任务名称')->required();
  225. $form->select('plan_id', '关联计划')
  226. ->options(\App\Module\Cleanup\Models\CleanupPlan::where('is_enabled', 1)->pluck('plan_name', 'id'))
  227. ->required();
  228. $form->hidden('status')->value(1); // 待执行
  229. $form->hidden('created_by')->value(admin_user_id());
  230. $form->display('created_at', '创建时间');
  231. $form->display('updated_at', '更新时间');
  232. // 禁用编辑(任务创建后不允许修改)
  233. $form->editing(function (Form $form) {
  234. $form->display('task_name', '任务名称');
  235. $form->display('plan.plan_name', '关联计划');
  236. $form->display('status', '任务状态')->using([
  237. 1 => '待执行',
  238. 2 => '备份中',
  239. 3 => '执行中',
  240. 4 => '已完成',
  241. 5 => '已失败',
  242. 6 => '已取消',
  243. 7 => '已暂停',
  244. ]);
  245. });
  246. });
  247. }
  248. }