CleanupPlanController.php 9.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258
  1. <?php
  2. namespace App\Module\Cleanup\AdminControllers;
  3. use App\Module\Cleanup\Models\CleanupPlan;
  4. use App\Module\Cleanup\Repositories\CleanupPlanRepository;
  5. use Dcat\Admin\Admin;
  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/plans
  16. */
  17. #[Resource('cleanup/plans', names: 'dcat.admin.cleanup.plans')]
  18. class CleanupPlanController extends AdminController
  19. {
  20. /**
  21. * 页面标题
  22. */
  23. protected $title = '清理计划管理';
  24. /**
  25. * 数据仓库
  26. */
  27. protected function repository()
  28. {
  29. return CleanupPlanRepository::class;
  30. }
  31. /**
  32. * 列表页面
  33. */
  34. protected function grid(): Grid
  35. {
  36. return Grid::make(new CleanupPlanRepository(), function (Grid $grid) {
  37. // 基础设置
  38. $grid->column('id', 'ID')->sortable();
  39. $grid->column('plan_name', '计划名称')->sortable();
  40. // 选择的Model类数量
  41. $grid->column('selected_tables_count', '选择Model数')->display(function () {
  42. return is_array($this->selected_tables) ? count($this->selected_tables) : 0;
  43. });
  44. // 状态
  45. $grid->column('is_template', '模板')->switch()->sortable();
  46. $grid->column('is_enabled', '启用状态')->switch()->sortable();
  47. // 统计信息
  48. $grid->column('contents_count', '包含表数')->display(function () {
  49. return $this->contents()->count();
  50. });
  51. $grid->column('tasks_count', '关联任务数')->display(function () {
  52. return $this->tasks()->count();
  53. });
  54. // 时间
  55. $grid->column('created_at', '创建时间')->sortable();
  56. $grid->column('updated_at', '更新时间')->sortable();
  57. // 筛选器
  58. $grid->filter(function (Grid\Filter $filter) {
  59. $filter->equal('is_template', '模板')->select([
  60. 1 => '是',
  61. 0 => '否',
  62. ]);
  63. $filter->equal('is_enabled', '启用状态')->select([
  64. 1 => '启用',
  65. 0 => '禁用',
  66. ]);
  67. $filter->like('plan_name', '计划名称');
  68. $filter->between('created_at', '创建时间')->datetime();
  69. });
  70. // 行操作
  71. $grid->actions(function (Grid\Displayers\Actions $actions) {
  72. $actions->append(new \App\Module\Cleanup\AdminControllers\Actions\ViewPlanContentsAction());
  73. $actions->append(new \App\Module\Cleanup\AdminControllers\Actions\AddTableToPlanAction());
  74. $actions->append(new \App\Module\Cleanup\AdminControllers\Actions\CreateTaskFromPlanAction());
  75. $actions->append(new \App\Module\Cleanup\AdminControllers\Actions\PreviewPlanAction());
  76. });
  77. // 批量操作
  78. $grid->batchActions([
  79. new \App\Module\Cleanup\AdminControllers\Actions\BatchEnablePlanAction(),
  80. new \App\Module\Cleanup\AdminControllers\Actions\BatchDisablePlanAction(),
  81. ]);
  82. // 工具栏
  83. $grid->tools([
  84. new \App\Module\Cleanup\AdminControllers\Actions\CreatePlanFromTemplateAction(),
  85. ]);
  86. // 设置每页显示数量
  87. $grid->paginate(20);
  88. });
  89. }
  90. /**
  91. * 详情页面
  92. */
  93. protected function detail($id): Show
  94. {
  95. return Show::make($id, new CleanupPlanRepository(), function (Show $show) {
  96. $show->field('id', 'ID');
  97. $show->field('plan_name', '计划名称');
  98. $show->field('selected_tables', '选择的Model类')->json();
  99. $show->field('global_conditions', '全局清理条件')->json();
  100. $show->field('backup_config', '备份配置')->json();
  101. $show->field('is_template', '模板')->using([1 => '是', 0 => '否']);
  102. $show->field('is_enabled', '启用状态')->using([1 => '启用', 0 => '禁用']);
  103. $show->field('description', '计划描述');
  104. $show->field('created_by', '创建者ID');
  105. $show->field('created_at', '创建时间');
  106. $show->field('updated_at', '更新时间');
  107. // 显示计划内容
  108. $show->relation('contents', '计划内容', function ($model) {
  109. $grid = new Grid(new \App\Module\Cleanup\Models\CleanupPlanContent());
  110. $grid->model()->where('plan_id', $model->id);
  111. $grid->column('table_name', '表名');
  112. $grid->column('cleanup_type', '清理类型')->using([
  113. 1 => '清空表',
  114. 2 => '删除所有',
  115. 3 => '按时间删除',
  116. 4 => '按用户删除',
  117. 5 => '按条件删除',
  118. ]);
  119. $grid->column('priority', '优先级');
  120. $grid->column('batch_size', '批处理大小');
  121. $grid->column('is_enabled', '启用')->using([1 => '是', 0 => '否']);
  122. $grid->column('backup_enabled', '备份')->using([1 => '是', 0 => '否']);
  123. $grid->disableActions();
  124. $grid->disableCreateButton();
  125. $grid->disableFilter();
  126. $grid->disablePagination();
  127. return $grid;
  128. });
  129. // 显示关联任务
  130. $show->relation('tasks', '关联任务', function ($model) {
  131. $grid = new Grid(new \App\Module\Cleanup\Models\CleanupTask());
  132. $grid->model()->where('plan_id', $model->id);
  133. $grid->column('id', 'ID');
  134. $grid->column('task_name', '任务名称');
  135. $grid->column('status', '状态')->using([
  136. 1 => '待执行',
  137. 2 => '备份中',
  138. 3 => '执行中',
  139. 4 => '已完成',
  140. 5 => '已失败',
  141. 6 => '已取消',
  142. 7 => '已暂停',
  143. ]);
  144. $grid->column('progress', '进度')->display(function ($progress) {
  145. return $progress . '%';
  146. });
  147. $grid->column('created_at', '创建时间');
  148. $grid->disableActions();
  149. $grid->disableCreateButton();
  150. $grid->disableFilter();
  151. $grid->disablePagination();
  152. return $grid;
  153. });
  154. });
  155. }
  156. /**
  157. * 创建/编辑表单
  158. */
  159. protected function form(): Form
  160. {
  161. return Form::make(new CleanupPlanRepository(), function (Form $form) {
  162. $form->display('id', 'ID');
  163. $form->text('plan_name', '计划名称')->required();
  164. // 获取所有可用的Model类
  165. $availableModels = $this->getAvailableModels();
  166. $form->multipleSelect('selected_tables', '选择要清理的Model类')
  167. ->options($availableModels)
  168. ->help('选择需要清理的Model类')
  169. ->required();
  170. $form->keyValue('global_conditions', '全局清理条件')
  171. ->help('JSON格式的全局清理条件');
  172. $form->keyValue('backup_config', '备份配置')
  173. ->help('JSON格式的备份配置');
  174. $form->switch('is_template', '设为模板')->default(0);
  175. $form->switch('is_enabled', '启用状态')->default(1);
  176. $form->textarea('description', '计划描述');
  177. $form->hidden('created_by')->value(Admin::user()->getKey());
  178. $form->display('created_at', '创建时间');
  179. $form->display('updated_at', '更新时间');
  180. });
  181. }
  182. /**
  183. * 获取所有可用的Model类
  184. */
  185. private function getAvailableModels(): array
  186. {
  187. $modelList = [];
  188. // 扫描所有模块的Models目录
  189. $modulesPath = app_path('Module');
  190. if (is_dir($modulesPath)) {
  191. $moduleIterator = new \RecursiveDirectoryIterator($modulesPath);
  192. $iterator = new \RecursiveIteratorIterator($moduleIterator);
  193. foreach ($iterator as $file) {
  194. if ($file->isFile() && $file->getExtension() === 'php') {
  195. $relativePath = str_replace(app_path() . '/', '', $file->getPathname());
  196. // 只处理Models目录下的文件
  197. if (strpos($relativePath, '/Models/') !== false) {
  198. // 转换为类名
  199. $className = 'App\\' . str_replace(['/', '.php'], ['\\', ''], $relativePath);
  200. // 检查是否是有效的Model类
  201. if (class_exists($className) && is_subclass_of($className, \Illuminate\Database\Eloquent\Model::class)) {
  202. $modelList[$className] = $className;
  203. }
  204. }
  205. }
  206. }
  207. }
  208. // 按类名排序
  209. ksort($modelList);
  210. return $modelList;
  211. }
  212. }