mescloud/db/mysql/add_mes_erp_in_stock_inspect.sql

-- ERP 来料检记录（固定检查项：检验员、时间、OK/NG、数量、批号、备注）
-- 父菜单：生产管理 (menu_code: 1672118505143263232)

CREATE TABLE IF NOT EXISTS `mes_erp_in_stock_inspect` (
  `id` varchar(64) NOT NULL COMMENT '主键',
  `po_bill_no` varchar(64) NOT NULL COMMENT '采购订单号',
  `check_result` varchar(8) NOT NULL COMMENT '检验结果 OK/NG',
  `inspector_code` varchar(64) DEFAULT NULL COMMENT '检验员账号',
  `inspector_name` varchar(100) DEFAULT NULL COMMENT '检验员',
  `inspect_time` datetime NOT NULL COMMENT '检验时间',
  `remarks` varchar(500) DEFAULT NULL COMMENT '备注',
  `stock_number` varchar(64) DEFAULT NULL COMMENT '入库仓库编码',
  `stock_loc_number` varchar(64) DEFAULT NULL COMMENT '入库仓位编码',
  `in_stock_bill_no` varchar(64) DEFAULT NULL COMMENT '生成的采购入库单号',
  `in_stock_status` varchar(16) DEFAULT NULL COMMENT '入库状态 NONE/SUCCESS/FAIL',
  `in_stock_message` varchar(500) DEFAULT NULL COMMENT '入库结果说明',
  `line_count` int DEFAULT NULL COMMENT '明细行数',
  `total_qty` decimal(18,6) DEFAULT NULL COMMENT '合计检验数量',
  `channel` varchar(16) DEFAULT NULL COMMENT 'PC/PDA',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `create_by` varchar(64) NOT NULL COMMENT '创建者',
  `create_date` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(64) NOT NULL COMMENT '更新者',
  `update_date` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_mes_erp_inspect_po` (`po_bill_no`),
  KEY `idx_mes_erp_inspect_time` (`inspect_time`),
  KEY `idx_mes_erp_inspect_result` (`check_result`),
  KEY `idx_mes_erp_inspect_instock` (`in_stock_bill_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='ERP来料检记录';

CREATE TABLE IF NOT EXISTS `mes_erp_in_stock_inspect_item` (
  `id` varchar(64) NOT NULL COMMENT '主键',
  `inspect_id` varchar(64) NOT NULL COMMENT '来料检记录id',
  `entry_id` varchar(64) DEFAULT NULL COMMENT '采购订单分录内码',
  `seq` varchar(32) DEFAULT NULL COMMENT '行号',
  `material_number` varchar(100) DEFAULT NULL COMMENT '物料编码',
  `material_name` varchar(200) DEFAULT NULL COMMENT '物料名称',
  `unit_name` varchar(64) DEFAULT NULL COMMENT '单位',
  `inspect_qty` decimal(18,6) DEFAULT NULL COMMENT '检验数量',
  `lot_number` varchar(100) DEFAULT NULL COMMENT '批号',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `create_by` varchar(64) NOT NULL COMMENT '创建者',
  `create_date` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(64) NOT NULL COMMENT '更新者',
  `update_date` datetime NOT NULL COMMENT '更新时间',
  `remarks` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  KEY `idx_mes_erp_inspect_item_hid` (`inspect_id`),
  KEY `idx_mes_erp_inspect_item_mat` (`material_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='ERP来料检记录明细';

DELETE FROM `js_sys_menu` WHERE `menu_code` = 'mesErpInStockInspect';

INSERT INTO `js_sys_menu` (
  `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
) VALUES (
  'mesErpInStockInspect', '1672118505143263232', '0,1672118505143263232,',
  147, '0000009290,0000000147,', '1', 1,
  '生产管理/ERP来料检记录', 'ERP来料检记录', '1', '/mes/mesErpInStockInspect/list', '',
  'fa-clipboard', '', '', 'mes:mesErpInStockInspect:view', 84, '1', 'default', 'core', NULL, NULL,
  '0', 'system', NOW(), 'system', NOW(), ''
);