mescloud/db/mysql/add_mes_batch_sn_batch_status.sql

-- 批次码记录表增加业务状态字段：0仓库中 1合格 2已发货，创建默认0
ALTER TABLE `mes_batch_sn`
  ADD COLUMN `batch_status` char(1) DEFAULT '0' COMMENT '状态：0仓库中 1合格 2已发货' AFTER `is_js`;

-- 历史数据补默认值
UPDATE `mes_batch_sn` SET `batch_status` = '0' WHERE `batch_status` IS NULL OR `batch_status` = '';

-- 字典类型：批次码业务状态
INSERT INTO `js_sys_dict_type` (
	`id`, `dict_name`, `dict_type`, `is_sys`, `status`,
	`create_by`, `create_date`, `update_by`, `update_date`, `remarks`
)
SELECT
	'1999000000000000101',
	'批次码-业务状态',
	'mes_batch_sn_status',
	'1',
	'0',
	'system',
	NOW(),
	'system',
	NOW(),
	'0仓库中 1合格 2已发货'
FROM DUAL
WHERE NOT EXISTS (
	SELECT 1 FROM `js_sys_dict_type` WHERE `dict_type` = 'mes_batch_sn_status'
);

-- 字典项：0 仓库中
INSERT INTO `js_sys_dict_data` (
	`dict_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`,
	`tree_leaf`, `tree_level`, `tree_names`, `dict_label`, `dict_value`,
	`dict_icon`, `dict_type`, `is_sys`, `description`, `css_style`, `css_class`,
	`status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`,
	`corp_code`, `corp_name`
)
SELECT
	'1999000000000000110', '0', '0,', 30, '0000000030,',
	'1', 0, '仓库中', '仓库中', '0',
	'', 'mes_batch_sn_status', '1', '创建后', '', 'tag blue',
	'0', 'system', NOW(), 'system', NOW(), '',
	'0', 'JeeSite'
FROM DUAL
WHERE NOT EXISTS (
	SELECT 1 FROM `js_sys_dict_data` WHERE `dict_type` = 'mes_batch_sn_status' AND `dict_value` = '0'
);

-- 字典项：1 合格
INSERT INTO `js_sys_dict_data` (
	`dict_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`,
	`tree_leaf`, `tree_level`, `tree_names`, `dict_label`, `dict_value`,
	`dict_icon`, `dict_type`, `is_sys`, `description`, `css_style`, `css_class`,
	`status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`,
	`corp_code`, `corp_name`
)
SELECT
	'1999000000000000111', '0', '0,', 40, '0000000040,',
	'1', 0, '合格', '合格', '1',
	'', 'mes_batch_sn_status', '1', '发货检后', '', 'tag green',
	'0', 'system', NOW(), 'system', NOW(), '',
	'0', 'JeeSite'
FROM DUAL
WHERE NOT EXISTS (
	SELECT 1 FROM `js_sys_dict_data` WHERE `dict_type` = 'mes_batch_sn_status' AND `dict_value` = '1'
);

-- 字典项：2 已发货
INSERT INTO `js_sys_dict_data` (
	`dict_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`,
	`tree_leaf`, `tree_level`, `tree_names`, `dict_label`, `dict_value`,
	`dict_icon`, `dict_type`, `is_sys`, `description`, `css_style`, `css_class`,
	`status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`,
	`corp_code`, `corp_name`
)
SELECT
	'1999000000000000112', '0', '0,', 50, '0000000050,',
	'1', 0, '已发货', '已发货', '2',
	'', 'mes_batch_sn_status', '1', '已发货', '', 'tag orange',
	'0', 'system', NOW(), 'system', NOW(), '',
	'0', 'JeeSite'
FROM DUAL
WHERE NOT EXISTS (
	SELECT 1 FROM `js_sys_dict_data` WHERE `dict_type` = 'mes_batch_sn_status' AND `dict_value` = '2'
);