ChickenFarm/SERVER/ChickenFarmV3/.script/sql/new/init_y.sql

/* 设备管理表 */
DROP TABLE IF EXISTS `d_device`;
CREATE TABLE `d_device`(
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '设备ID',
    `name` varchar(255) DEFAULT NULL COMMENT '设备名称',
    `type` varchar(255) DEFAULT NULL COMMENT '设备类型',
    `status`  tinyint NOT NULL DEFAULT '0' COMMENT '状态（ 0：正常工作中 1：维修中 2：带病运行 3：退役）',
    `location` varchar(255) DEFAULT NULL COMMENT '位置',
    `manufacturer` varchar(255) DEFAULT NULL COMMENT '厂家',
    `installation_date` date DEFAULT NULL COMMENT '安装日期',
    `responsible_person` varchar(255) DEFAULT NULL COMMENT '负责人',
    `responsible_phone` varchar(255) DEFAULT NULL COMMENT '负责人电话',
    `manual` varchar(255) DEFAULT NULL COMMENT '说明书',
    `create_org` bigint NOT NULL COMMENT '创建组织',
    `create_by` bigint NOT NULL COMMENT '创建人',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` bigint NOT NULL COMMENT '更新人',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注',
    `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）',
    PRIMARY KEY (`id`),
    INDEX `idx_device_name` (`name`),
    INDEX `idx_device_status` (`status`),
    INDEX `idx_device_location` (`location`),
    INDEX `idx_device_manufacturer` (`manufacturer`),
    INDEX `idx_device_create_by` (`create_by`),
    INDEX `idx_device_update_by` (`update_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='设备资产台账表';

-- ----------------------------
-- 故障报修和保养管理工单表
-- ----------------------------
DROP TABLE IF EXISTS `d_device_order`;
CREATE TABLE `d_device_order` (
    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '工单ID',
    `task_id` bigint NULL DEFAULT NULL COMMENT '任务ID',
    `order_no` varchar(32) NOT NULL COMMENT '工单编号',
    `title` varchar(255) NOT NULL COMMENT '工单标题',
    `device_id` int(11) NOT NULL COMMENT '设备ID',
    `order_type` tinyint NOT NULL DEFAULT '1' COMMENT '工单类型（1:故障报修 2:保养管理 3:清洁消毒）',
    `clean_type` tinyint NULL DEFAULT NULL COMMENT '清洁消毒类型（1:清洁 2:消毒 3:定期清洁 4:定期消毒）',
    `content` text COMMENT '工单内容',
    `status` tinyint NOT NULL DEFAULT '0' COMMENT '工单状态（0:待处理 1:处理中 2:已暂缓 3:待验收 4:验收未通过 5:已完成）',
    `reporter_id` bigint NOT NULL COMMENT '报修人ID',
    `report_time` datetime NOT NULL COMMENT '报修时间',
    `receiver_id` bigint NULL DEFAULT NULL COMMENT '接收人ID',
    `receive_time` datetime NULL DEFAULT NULL COMMENT '接收时间',
    `petty_workers` varchar(500) NULL DEFAULT NULL COMMENT '小工',
    `complete_time` datetime NULL DEFAULT NULL COMMENT '完成时间',
    `suspend_reason` varchar(500) NULL DEFAULT NULL COMMENT '暂缓原因',
    `suspend_time` datetime NULL DEFAULT NULL COMMENT '暂缓时间',
    `resume_time` datetime NULL DEFAULT NULL COMMENT '恢复时间',
    `acceptance_time` datetime NULL DEFAULT NULL COMMENT '验收时间',
    `acceptance_result` tinyint NULL DEFAULT NULL COMMENT '验收结果（1:通过 2:拒绝）',
    `acceptance_remark` varchar(500) NULL DEFAULT NULL COMMENT '验收备注',
    `acceptor_id` bigint NULL DEFAULT NULL COMMENT '验收人ID',
    `fault_duration` float NULL DEFAULT 0 COMMENT '故障耗时（单位：小时）',
    `suspend_duration` float NULL DEFAULT 0 COMMENT '暂缓时长（单位：小时）',
    `attachment_urls` text COMMENT '附件URL列表（JSON格式）',
    `create_org` bigint NOT NULL COMMENT '创建组织',
    `create_by` bigint NOT NULL COMMENT '创建人',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` bigint NOT NULL COMMENT '更新人',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注',
    `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）',
    PRIMARY KEY (`id`),
    UNIQUE INDEX `uk_order_no` (`order_no`),
    INDEX `idx_device_id` (`device_id`),
    INDEX `idx_order_type` (`order_type`),
    INDEX `idx_status` (`status`),
    INDEX `idx_reporter_id` (`reporter_id`),
    INDEX `idx_receiver_id` (`receiver_id`),
    INDEX `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='工单表';

-- ----------------------------
-- 工单协助人关联表
-- ----------------------------
DROP TABLE IF EXISTS `d_device_order_assistant`;
CREATE TABLE `d_device_order_assistant` (
    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `order_id` bigint NOT NULL COMMENT '工单ID',
    `user_id` bigint NOT NULL COMMENT '用户ID',
    `work_hours` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '工时',
    `work_content` varchar(500) NULL DEFAULT NULL COMMENT '工作内容',
    `create_org` bigint NOT NULL COMMENT '创建组织',
    `create_by` bigint NOT NULL COMMENT '创建人',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` bigint NOT NULL COMMENT '更新人',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注',
    `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）',
    PRIMARY KEY (`id`),
    INDEX `idx_order_id` (`order_id`),
    INDEX `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='工单协助人关联表';

-- ----------------------------
-- 工单流转记录表
-- ----------------------------
DROP TABLE IF EXISTS `d_device_order_flow`;
CREATE TABLE `d_device_order_flow` (
    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '流转记录ID',
    `order_id` bigint NOT NULL COMMENT '工单ID',
    `flow_type` tinyint NOT NULL COMMENT '流转类型（1:创建 2:接收 3:提交验收 4:验收通过 5:验收拒绝 6:关闭）',
    `operator_id` bigint NOT NULL COMMENT '操作人ID',
    `operate_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间',
    `content` text COMMENT '操作内容/说明',
    `attachment_urls` text COMMENT '附件URL列表',
    `create_org` bigint NOT NULL COMMENT '创建组织',
    `create_by` bigint NOT NULL COMMENT '创建人',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` bigint NOT NULL COMMENT '更新人',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注',
    `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）',
    PRIMARY KEY (`id`),
    INDEX `idx_order_id` (`order_id`),
    INDEX `idx_flow_type` (`flow_type`),
    INDEX `idx_operator_id` (`operator_id`),
    INDEX `idx_operate_time` (`operate_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='工单流转记录表';

-- ----------------------------
-- Table structure for d_device_task
-- ----------------------------
DROP TABLE IF EXISTS `d_device_task`;
CREATE TABLE `d_device_task`  (
      `id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务ID',
      `task_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '保养任务名称',
      `task_desc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '保养任务描述',
      `task_type` tinyint NOT NULL COMMENT '任务类型（1:设备保养 2:设备清洁）',
      `device_id` bigint NOT NULL COMMENT '设备ID',
      `cycle` float NOT NULL default 0 COMMENT '保养周期(小时)',
      `executor_id` bigint NOT NULL COMMENT '执行责任人ID',
      `acceptor_id` bigint NOT NULL COMMENT '验收责任人ID',
      `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:启用 1:停用）',
      `startTime` datetime NULL DEFAULT NULL COMMENT '开始时间',
      `endTime` datetime NULL DEFAULT NULL COMMENT '结束时间',
      `lastCreateTime` datetime NULL DEFAULT NULL COMMENT '最后创建工单时间',
      `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织',
      `create_by` bigint NULL DEFAULT NULL COMMENT '创建者',
      `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
      `update_by` bigint NULL DEFAULT NULL COMMENT '更新者',
      `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
      `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
      `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
      PRIMARY KEY (`id`) USING BTREE,
      INDEX `idx_device_id`(`device_id` ASC) USING BTREE,
      INDEX `idx_task_name`(`task_name` ASC) USING BTREE,
      INDEX `idx_task_type`(`task_type` ASC) USING BTREE,
      INDEX `idx_clean_type`(`clean_type` ASC) USING BTREE,
      INDEX `idx_executor_id`(`executor_id` ASC) USING BTREE,
      INDEX `idx_acceptor_id`(`acceptor_id` ASC) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT = '设备任务表';

-- ----------------------------
-- Table structure for d_inspection_rule
-- ----------------------------
DROP TABLE IF EXISTS `d_inspection_rule`;
CREATE TABLE `d_inspection_rule` (
     `id` bigint NOT NULL AUTO_INCREMENT COMMENT '点检规则ID',
     `task_name` varchar(255) NOT NULL COMMENT '点检任务名称',
     `location` varchar(255) DEFAULT NULL COMMENT '地点',
     `cycle_hours` float NOT NULL COMMENT '点检周期（小时）',
     `tolerance_hours` float DEFAULT NULL COMMENT '允许误差范围（小时）',
     `start_time` datetime DEFAULT NULL COMMENT '点检开始时间',
     `end_time` datetime DEFAULT NULL COMMENT '点检结束时间',
     `required_count` int NOT NULL COMMENT '需点检总次数',
     `actual_count` int NOT NULL DEFAULT '0'COMMENT '实际点检次数',
     `missed_count` int NOT NULL DEFAULT '0' COMMENT '漏检次数',
     `executor_id` bigint DEFAULT NULL COMMENT '执行人ID',
     `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态（0:正常 1:停用）',
     `create_org` bigint NOT NULL COMMENT '创建组织',
     `create_by` bigint NOT NULL COMMENT '创建人',
     `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
     `update_by` bigint NOT NULL COMMENT '更新人',
     `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
     `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注',
     `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）',
     PRIMARY KEY (`id`),
     INDEX `idx_task_name` (`task_name`),
     INDEX `idx_executor_id` (`executor_id`),
     INDEX `idx_status` (`status`),
     INDEX `idx_create_by` (`create_by`),
     INDEX `idx_update_by` (`update_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='点检规则管理表';

-- ----------------------------
-- Table structure for d_inspection_checkin
-- ----------------------------
DROP TABLE IF EXISTS `d_inspection_checkin`;
CREATE TABLE `d_inspection_checkin` (
    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '点检签到ID',
    `inspection_rule_id` bigint NOT NULL COMMENT '点检任务ID',
    `inspector_id` bigint NOT NULL COMMENT '点检人ID',
    `planned_sequence` int NOT NULL COMMENT '点检计划次序',
    `execute_time` datetime  NULL COMMENT '执行时间',
    `plan_time` datetime  NULL COMMENT '计划时间',
    `image_url` varchar(255) DEFAULT NULL COMMENT '签到图片',
    `checkin_status` tinyint NOT NULL DEFAULT '0' COMMENT '状态（0:正常 1:异常）',
    `create_org` bigint NOT NULL COMMENT '创建组织',
    `create_by` bigint NOT NULL COMMENT '创建人',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` bigint NOT NULL COMMENT '更新人',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注',
    `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）',
    PRIMARY KEY (`id`),
    INDEX `idx_inspection_rule_id` (`inspection_rule_id`),
    INDEX `idx_inspector_id` (`inspector_id`),
    INDEX `idx_execute_time` (`execute_time`),
    INDEX `idx_status` (`checkin_status`),
    INDEX `idx_create_by` (`create_by`),
    INDEX `idx_update_by` (`update_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='点检签到表';

INSERT INTO `sys_config` VALUES (11, '000000', '维修人员USER_ID', 'sys.repair.userIds', '5,6', 'Y', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修人员ID');

INSERT INTO `sys_dict_type` VALUES (13, '000000', '设备状态', 'sys_notice_read_status', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '0：正常运行 1：维修中 2：带病运行 3：退役');
INSERT INTO `sys_dict_data` VALUES (41, '000000', 0, '未读', '0', 'sys_notice_read_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修中');
INSERT INTO `sys_dict_data` VALUES (42, '000000', 0, '已读', '1', 'sys_notice_read_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修中');

INSERT INTO `sys_dict_type` VALUES (301, '000000', '设备状态', 'device_status', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '0：正常运行 1：维修中 2：带病运行 3：退役');
INSERT INTO `sys_dict_data` VALUES (301, '000000', 0, '正常运行', '0', 'device_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修中');
INSERT INTO `sys_dict_data` VALUES (302, '000000', 0, '维修中', '1', 'device_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修中');
INSERT INTO `sys_dict_data` VALUES (303, '000000', 0, '带病运行', '2', 'device_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '带病运行');
INSERT INTO `sys_dict_data` VALUES (304, '000000', 0, '退役', '3', 'device_status', '', 'info', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '退役');

INSERT INTO `sys_dict_type` VALUES (302, '000000', '设备工单类型', 'device_order_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1:故障报修 2:设备保养 3:清洁消毒');
INSERT INTO `sys_dict_data` VALUES (307, '000000', 0, '故障报修', '1', 'device_order_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '故障报修');
INSERT INTO `sys_dict_data` VALUES (308, '000000', 0, '设备保养', '2', 'device_order_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '设备保养');
INSERT INTO `sys_dict_data` VALUES (309, '000000', 0, '清洁消毒', '3', 'device_order_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '清洁消毒');

INSERT INTO `sys_dict_type` VALUES (303, '000000', '设备工单状态', 'device_order_status', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '0:待处理 1:处理中 2:已暂缓 3:待验收 4:验收未通过 5:已完成');
INSERT INTO `sys_dict_data` VALUES (311, '000000', 0, '待处理', '0', 'device_order_status', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '待处理');
INSERT INTO `sys_dict_data` VALUES (312, '000000', 0, '处理中', '1', 'device_order_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '处理中');
INSERT INTO `sys_dict_data` VALUES (313, '000000', 0, '已暂缓', '2', 'device_order_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已暂缓');
INSERT INTO `sys_dict_data` VALUES (314, '000000', 0, '待验收', '3', 'device_order_status', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '待验收');
INSERT INTO `sys_dict_data` VALUES (315, '000000', 0, '验收未通过', '4', 'device_order_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '验收未通过');
INSERT INTO `sys_dict_data` VALUES (316, '000000', 0, '已完成', '5', 'device_order_status', '', 'default', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已完成');

INSERT INTO `sys_dict_type` VALUES (304, '000000', '工单流转类型', 'device_order_flow_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1:创建工单 2:修改工单 3:变更协助人 4:接收工单 5:暂缓工单 6:恢复工单 7:提交验收 8:验收通过 9:验收拒绝');
INSERT INTO `sys_dict_data` VALUES (319, '000000', 0, '创建工单', '1', 'device_order_flow_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '创建工单');
INSERT INTO `sys_dict_data` VALUES (320, '000000', 0, '修改工单', '2', 'device_order_flow_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '修改工单');
INSERT INTO `sys_dict_data` VALUES (321, '000000', 0, '变更协助人', '3', 'device_order_flow_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '变更协助人');
INSERT INTO `sys_dict_data` VALUES (322, '000000', 0, '接收工单', '4', 'device_order_flow_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '接收工单');
INSERT INTO `sys_dict_data` VALUES (323, '000000', 0, '暂缓工单', '5', 'device_order_flow_type', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '暂缓工单');
INSERT INTO `sys_dict_data` VALUES (324, '000000', 0, '恢复工单', '6', 'device_order_flow_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '恢复工单');
INSERT INTO `sys_dict_data` VALUES (325, '000000', 0, '提交验收', '7', 'device_order_flow_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '提交验收');
INSERT INTO `sys_dict_data` VALUES (326, '000000', 0, '验收通过', '8', 'device_order_flow_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '验收通过');
INSERT INTO `sys_dict_data` VALUES (327, '000000', 0, '验收拒绝', '9', 'device_order_flow_type', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '验收拒绝');

INSERT INTO `sys_dict_type` VALUES (305, '000000', '任务类型', 'device_task_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1:设备保养 2:设备清洁');
INSERT INTO `sys_dict_data` VALUES (331, '000000', 0, '设备保养', '1', 'device_task_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '故障报修');
INSERT INTO `sys_dict_data` VALUES (332, '000000', 0, '设备清洁', '2', 'device_task_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '保养管理');

INSERT INTO `sys_dict_type` VALUES (306, '000000', '清洁类型', 'device_clean_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1:清洁 2:消毒 3:定期清洁 4:定期消毒');
INSERT INTO `sys_dict_data` VALUES (335, '000000', 0, '清洁', '1', 'device_clean_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '故障报修');
INSERT INTO `sys_dict_data` VALUES (336, '000000', 0, '消毒', '2', 'device_clean_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '保养管理');
INSERT INTO `sys_dict_data` VALUES (337, '000000', 0, '定期清洁', '3', 'device_clean_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '故障报修');
INSERT INTO `sys_dict_data` VALUES (338, '000000', 0, '定期消毒', '4', 'device_clean_type', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '保养管理');

INSERT INTO `sys_dict_type` VALUES (307, '000000', '点检签到类型', 'device_inspection_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '0:未签到 1:签到');
INSERT INTO `sys_dict_data` VALUES (341, '000000', 0, '未签到', '0', 'device_inspection_type', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '未签到');
INSERT INTO `sys_dict_data` VALUES (342, '000000', 0, '签到', '1', 'device_inspection_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '签到');

INSERT INTO `sys_menu` VALUES (21, '设备管理', 0, 21, 'deviceMg', NULL, '', 1, 0, 'M', '0', '0', '', 'suitcase-lg', '', '', 100, 1, '2025-10-15 12:00:00', 1, '2025-10-15 12:00:00', '设备管理');

INSERT INTO `sys_menu` VALUES (351, '设备资产', 21, 1, 'device', 'device/device/index', '', 1, 0, 'C', '0', '0', 'device:device', '#', NULL, NULL, 100, 1, '2025-10-15 15:02:26', NULL, '2025-10-15 15:02:26', '');
INSERT INTO `sys_menu` VALUES (2001, '查询设备资产', 351, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:device:query', 'eye', '', '', 100, 1, '2025-10-15 15:02:26', NULL, '2025-10-15 15:02:26', '');
INSERT INTO `sys_menu` VALUES (2002, '新增设备资产', 351, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:device:add', 'plus-square', 'btn btn-light-primary', 'handleCreate', 100, 1, '2025-10-15 15:02:26', NULL, '2025-10-15 15:02:26', '');
INSERT INTO `sys_menu` VALUES (2003, '修改设备资产', 351, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:device:edit', 'pencil-square', 'btn btn-light-success', 'handleUpdate@1', 100, 1, '2025-10-15 15:02:26', NULL, '2025-10-15 15:02:26', '');
INSERT INTO `sys_menu` VALUES (2004, '删除设备资产', 351, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:device:remove', 'dash-square', 'btn btn-light-danger', 'handleDelete@0', 100, 1, '2025-10-15 15:02:26', NULL, '2025-10-15 15:02:26', '');
INSERT INTO `sys_menu` VALUES (352, '点检签到规则', 21, 2, 'inspection', 'device/inspection/index', '', 1, 0, 'C', '0', '0', 'device:inspection', '#', NULL, NULL, 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2011, '查询点检规则', 352, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:inspection:query', 'eye', '', '', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2012, '新增点检规则', 352, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:inspection:add', 'plus-square', 'btn btn-light-primary', 'handleCreate', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2013, '修改点检规则', 352, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:inspection:edit', 'pencil-square', 'btn btn-light-success', 'handleUpdate@1', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2014, '删除点检规则', 352, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:inspection:remove', 'dash-square', 'btn btn-light-danger', 'handleDelete@0', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2015, '启停点检签到', 352, 0, '#', NULL, '', 1, 0, 'F', '1', '0', 'device:inspection:startStop', '', '', '', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (353, '设备维修工单', 21, 3, 'deviceRepairOrder', 'device/deviceRepairOrder/index', '', 1, 0, 'C', '0', '0', 'device:deviceRepairOrder', '#', NULL, NULL, 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2021, '查询维修工单', 353, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceRepairOrder:query', 'eye', '', '', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2022, '新增维修工单', 353, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceRepairOrder:add', 'plus-square', 'btn btn-light-primary', 'handleCreate', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2023, '修改维修工单', 353, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceRepairOrder:edit', 'pencil-square', 'btn btn-light-success', 'handleUpdate@1', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2024, '删除维修工单', 353, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceRepairOrder:remove', 'dash-square', 'btn btn-light-danger', 'handleDelete@0', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (354, '设备保养任务', 21, 4, 'deviceMaintenanceTask', 'device/deviceMaintenanceTask/index', '', 1, 0, 'C', '0', '0', 'device:deviceMaintenanceTask', '#', NULL, NULL, 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2031, '查询保养任务', 354, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceMaintenanceTask:query', 'eye', '', '', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2032, '新增保养任务', 354, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceMaintenanceTask:add', 'plus-square', 'btn btn-light-primary', 'handleCreate', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2033, '修改保养任务', 354, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceMaintenanceTask:edit', 'pencil-square', 'btn btn-light-success', 'handleUpdate@1', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2034, '删除保养任务', 354, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceMaintenanceTask:remove', 'dash-square', 'btn btn-light-danger', 'handleDelete@0', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2035, '启停保养任务', 354, 0, '#', NULL, '', 1, 0, 'F', '1', '0', 'device:deviceMaintenanceTask:startStop', '', '', '', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (355, '设备保养工单', 21, 5, 'deviceMaintenanceOrder', 'device/deviceMaintenanceOrder/index', '', 1, 0, 'C', '0', '0', 'device:deviceMaintenanceOrder', '#', NULL, NULL, 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2041, '查询保养工单', 355, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceMaintenanceOrder:query', 'eye', '', '', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2042, '新增保养工单', 355, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceMaintenanceOrder:add', 'plus-square', 'btn btn-light-primary', 'handleCreate', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2043, '修改保养工单', 355, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceMaintenanceOrder:edit', 'pencil-square', 'btn btn-light-success', 'handleUpdate@1', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2044, '删除保养工单', 355, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceMaintenanceOrder:remove', 'dash-square', 'btn btn-light-danger', 'handleDelete@0', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (356, '设备报表', 21, 6, 'report', NULL, '', 1, 0, 'M', '0', '0', '', 'file-earmark-bar-graph', '', '', 100, 1, '2025-10-15 12:00:00', 1, '2025-10-15 12:00:00', '设备报表');
INSERT INTO `sys_menu` VALUES (2051, '设备故障统计表', 356, 1, 'deviceFault', 'device/report/fault', '', 1, 0, 'C', '0', '0', 'device:report:fault', '#', NULL, NULL, 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2052, '机修工维修明细表', 356, 2, 'deviceRepairDetail', 'device/report/repair', '', 1, 0, 'C', '0', '0', 'device:report:repair', '#', NULL, NULL, 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2053, '点检签到漏点统计表', 356, 3, 'inspectionLose', 'device/report/inspection', '', 1, 0, 'C', '0', '0', 'device:report:inspection', '#', NULL, NULL, 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');

-- INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, );