-- ---------------------------- -- 通用任务管理数据字典 -- ---------------------------- -- 1. 任务类型字典 -- ---------------------------- INSERT INTO sys_dict_type(dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES('任务类型', 'sys_task_type', '0', 'admin', SYSDATE(), '', NULL, '任务类型列表'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(1, '维修保养', 'MAINTENANCE', 'sys_task_type', '', 'primary', 'N', '0', 'admin', SYSDATE(), '', NULL, '维修保养任务'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(2, '加油任务', 'FUEL', 'sys_task_type', '', 'success', 'N', '0', 'admin', SYSDATE(), '', NULL, '加油任务'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(3, '其他', 'OTHER', 'sys_task_type', '', 'info', 'N', '0', 'admin', SYSDATE(), '', NULL, '其他类型任务'); -- 2. 任务状态字典 -- ---------------------------- INSERT INTO sys_dict_type(dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES('任务状态', 'sys_task_status', '0', 'admin', SYSDATE(), '', NULL, '任务状态列表'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(1, '待开始', 'PENDING', 'sys_task_status', '', 'warning', 'N', '0', 'admin', SYSDATE(), '', NULL, '任务已创建,等待开始'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(2, '任务中', 'IN_PROGRESS', 'sys_task_status', '', 'primary', 'N', '0', 'admin', SYSDATE(), '', NULL, '任务已经开始'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(3, '已完成', 'COMPLETED', 'sys_task_status', '', 'success', 'N', '0', 'admin', SYSDATE(), '', NULL, '任务已完成'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(4, '已取消', 'CANCELLED', 'sys_task_status', '', 'danger', 'N', '0', 'admin', SYSDATE(), '', NULL, '任务已取消'); -- 3. 车辆类型字典 -- ---------------------------- INSERT INTO sys_dict_type(dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES('车辆类型', 'sys_vehicle_type', '0', 'admin', SYSDATE(), '', NULL, '车辆类型列表'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(1, '救护车', 'AMBULANCE', 'sys_vehicle_type', '', 'danger', 'N', '0', 'admin', SYSDATE(), '', NULL, '救护车'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(2, '转运车', 'TRANSFER', 'sys_vehicle_type', '', 'primary', 'N', '0', 'admin', SYSDATE(), '', NULL, '转运车'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(3, '维修车', 'MAINTENANCE', 'sys_vehicle_type', '', 'warning', 'N', '0', 'admin', SYSDATE(), '', NULL, '维修车'); -- 4. 车辆状态字典 -- ---------------------------- INSERT INTO sys_dict_type(dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES('车辆状态', 'sys_vehicle_status', '0', 'admin', SYSDATE(), '', NULL, '车辆状态列表'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(1, '正常', '0', 'sys_vehicle_status', '', 'success', 'N', '0', 'admin', SYSDATE(), '', NULL, '车辆正常使用'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(2, '停用', '1', 'sys_vehicle_status', '', 'danger', 'N', '0', 'admin', SYSDATE(), '', NULL, '车辆停用'); -- 5. 任务车辆关联状态字典 -- ---------------------------- INSERT INTO sys_dict_type(dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES('任务车辆关联状态', 'sys_task_vehicle_status', '0', 'admin', SYSDATE(), '', NULL, '任务车辆关联状态列表'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(1, '已分配', 'ASSIGNED', 'sys_task_vehicle_status', '', 'primary', 'N', '0', 'admin', SYSDATE(), '', NULL, '车辆已分配给任务'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(2, '执行中', 'ACTIVE', 'sys_task_vehicle_status', '', 'success', 'N', '0', 'admin', SYSDATE(), '', NULL, '车辆正在执行任务'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(3, '已完成', 'COMPLETED', 'sys_task_vehicle_status', '', 'info', 'N', '0', 'admin', SYSDATE(), '', NULL, '车辆任务已完成'); INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(4, '已取消', 'CANCELLED', 'sys_task_vehicle_status', '', 'danger', 'N', '0', 'admin', SYSDATE(), '', NULL, '车辆任务已取消');