-- 2025-07-22添加的菜单栏 INSERT INTO sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('设备维护记录', 2168, 4, 'inspectionItemRecord', 'mes/equipment/inspectionItemRecord', NULL, 1, 0, 'C', '0', '0', 'equipment:inspectionItemRecord:list', '#', 'admin', '2025-07-13 00:15:38', '', NULL, ''); INSERT INTO sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('温湿度采集', 2168, 5, 'humidity', 'mes/equipment/humidity/index', NULL, 1, 0, 'C', '0', '0', 'equipment:humidity:list', '#', 'admin', '2025-07-21 15:59:01', 'admin', '2025-07-21 15:59:36', ''); INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序', 2123, 9, 'reportWarehousing', 'mes/quality/reportWarehousing/index', NULL, 1, 0, 'C', '0', '0', 'quality:reportWarehousing:list', 'button', 'yavii', '2025-07-21 10:50:57', '', NULL, ''); INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序查询', 2328, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'quality:reportWarehousing:query', '#', 'yavii', '2025-07-21 10:53:00', '', NULL, ''); INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序新增', 2328, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'quality:reportWarehousing:add', '#', 'yavii', '2025-07-21 10:54:02', 'yavii', '2025-07-21 10:54:14', ''); INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序修改', 2328, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'quality:reportWarehousing:edit', '#', 'yavii', '2025-07-21 10:54:47', '', NULL, ''); INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序删除', 2328, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'quality:reportWarehousing:remove', '#', 'yavii', '2025-07-21 10:55:47', 'yavii', '2025-07-21 10:56:05', ''); INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序导出', 2328, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'quality:reportWarehousing:export', '#', 'yavii', '2025-07-21 10:56:54', '', NULL, ''); DROP TABLE IF EXISTS `qc_warehousing`; CREATE TABLE `qc_warehousing` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID', `qc_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '质检单号', `qc_item` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '质检物品', `start_time` datetime NOT NULL COMMENT '开始时间', `duration` int NULL DEFAULT NULL COMMENT '持续时间(分钟)', `is_qualified` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '是否合格(0=不合格,1=合格)', `remarks` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `spare1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备用字段1', `spare2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备用字段2', `spare3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备用字段3', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_qc_no`(`qc_no`) USING BTREE COMMENT '质检单号唯一索引' ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '入库质检记录表' ROW_FORMAT = DYNAMIC; DROP TABLE IF EXISTS `dm_inspection_record`; CREATE TABLE `dm_inspection_record` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录ID', `inspection_item_id` bigint(20) NOT NULL COMMENT '点检项目ID', `check_date` date NOT NULL COMMENT '点检日期', `check_time` time NOT NULL COMMENT '点检时间', `status` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '点检结果（0=正常，1=异常）', `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注说明', `checked_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '点检人', `photos` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行图片', `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建者', `create_time` datetime NOT NULL COMMENT '创建时间', `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_item_date`(`inspection_item_id`, `check_date`) USING BTREE COMMENT '项目日期索引' ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备点检记录表' ROW_FORMAT = DYNAMIC;