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 '设备名称',
    `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',
    `order_no` varchar(32) NOT NULL COMMENT '工单编号',
    `device_id` int(11) NOT NULL COMMENT '设备ID',
    `order_type` tinyint NOT NULL DEFAULT '1' COMMENT '工单类型（1:故障报修 2:保养管理）',
    `title` varchar(255) NOT NULL COMMENT '工单标题',
    `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='工单流转记录表';

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:保养管理');
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_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_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, 'pointCheck', 'device/pointCheck/index', '', 1, 0, 'C', '0', '0', 'device:pointCheck', '#', 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:pointCheck: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:pointCheck: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:pointCheck: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:pointCheck: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', '0', '0', 'device:pointCheck:remove', 'skip-start-circle', 'btn btn-light-primary', 'handleStart@1', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2016, '停止点检签到', 352, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:pointCheck:remove', 'stop-circle', 'btn btn-light-danger', 'handleStop@1', 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', '0', '0', 'device:deviceMaintenanceTask:start', 'skip-start-circle', 'btn btn-light-primary', 'handleStart@1', 100, 1, '2025-10-15 15:02:19', NULL, '2025-10-15 15:02:19', '');
INSERT INTO `sys_menu` VALUES (2036, '停止保养任务', 354, 0, '#', NULL, '', 1, 0, 'F', '0', '0', 'device:deviceMaintenanceTask:stop', 'stop-circle', 'btn btn-light-danger', 'handleStop@1', 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, 'pointCheckLose', 'device/report/pointCheck', '', 1, 0, 'C', '0', '0', 'device:report:pointCheck', '#', 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, );