From eee03bbfea8b15d1a56ab63bd09a35c6c861c4cb Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期一, 09 十一月 2026 13:01:08 +0800
Subject: [PATCH] feat(mes): 不合格品处置联动入库与生产订单
---
docs/sql/config_export_all_20261108.sql | 178 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 174 insertions(+), 4 deletions(-)
diff --git a/docs/sql/config_export_all_20261108.sql b/docs/sql/config_export_all_20261108.sql
index 3de9454..121b26c 100644
--- a/docs/sql/config_export_all_20261108.sql
+++ b/docs/sql/config_export_all_20261108.sql
@@ -560,7 +560,7 @@
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='鍏徃鍝佺墝淇℃伅閰嶇疆琛�';
-INSERT INTO `system_company_config` (`id`, `company_name`, `logo_url`, `logo_blob_id`, `login_title`, `login_description`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1,'鍖椾含鍚屼粊鍫�','http://36.213.150.237:9016/admin-api/system/storage-blob/preview/ee1ba93d-c8f0-43ef-9609-b98f3f6a15a2_tongrentang_logo_transparent.png?publicKey=1e542685e9fb4e7c8cc152d3c57b633f',NULL,'鍖椾含鍚屼粊鍫傛櫤閫犵郴缁�','鍖椾含鍚屼粊鍫傛櫤閫犵郴缁�','1','2026-10-11 17:20:08','1','2026-10-11 17:20:31',0x00);
+INSERT INTO `system_company_config` (`id`, `company_name`, `logo_url`, `logo_blob_id`, `login_title`, `login_description`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1,'鍗楅�氳嫃鐝╃嚎缂�',NULL,NULL,'鍗楅�氳嫃鐝╃嚎缂嗘櫤閫犵郴缁�','鍗楅�氳嫃鐝╃嚎缂嗘櫤閫犵郴缁�','1','2026-10-11 17:20:08','1','2026-11-09 11:14:14',0x00);
-- ***********************************************************************
@@ -7214,6 +7214,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
`code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍗曞彿',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍚嶇О',
+ `type` int DEFAULT NULL COMMENT '鏉傞」绫诲瀷',
+ `source_doc_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鏉ユ簮鍗曟嵁绫诲瀷',
+ `source_doc_id` bigint DEFAULT NULL COMMENT '鏉ユ簮鍗曟嵁 ID',
+ `source_doc_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鏉ユ簮鍗曟嵁缂栧彿',
`receipt_date` datetime DEFAULT NULL COMMENT '鍏ュ簱鏃ユ湡',
`status` int DEFAULT NULL COMMENT '鐘舵��',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞',
@@ -7235,6 +7239,7 @@
`receipt_id` bigint DEFAULT NULL COMMENT '鍏ュ簱鍗� ID',
`item_id` bigint DEFAULT NULL COMMENT '鐗╂枡 ID',
`quantity` decimal(24,6) DEFAULT NULL COMMENT '鏁伴噺',
+ `batch_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵规鍙�',
`batch_id` bigint DEFAULT NULL COMMENT '鎵规 ID',
`warehouse_id` bigint DEFAULT NULL COMMENT '浠撳簱 ID',
`location_id` bigint DEFAULT NULL COMMENT '搴撳尯 ID',
@@ -7255,6 +7260,10 @@
`receipt_id` bigint DEFAULT NULL COMMENT '鍏ュ簱鍗� ID',
`item_id` bigint DEFAULT NULL COMMENT '鐗╂枡 ID',
`quantity` decimal(24,6) DEFAULT NULL COMMENT '鏁伴噺',
+ `batch_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵规鍙�',
+ `warehouse_id` bigint DEFAULT NULL COMMENT '浠撳簱 ID',
+ `location_id` bigint DEFAULT NULL COMMENT '搴撳尯 ID',
+ `area_id` bigint DEFAULT NULL COMMENT '搴撲綅 ID',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
@@ -11392,13 +11401,13 @@
-- 4. 瀹㈡埛寰�鏉� / 閿�鍞璐� / 鏍搁攢绠＄悊鑿滃崟
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, status, visible, keep_alive, always_show)
-SELECT 1075660, '瀹㈡埛寰�鏉�', 'crm:receivable:query', 2, 6, 1075497, 'customer-statement', '', 'crm/customerStatement/index', 0, 1, 1, 1
+SELECT 1075660, '瀹㈡埛寰�鏉�', 'crm:receivable:query', 2, 6, 1075497, 'customer-statement', 'ep:user', 'crm/customerStatement/index', 0, 1, 1, 1
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 1075660);
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, status, visible, keep_alive, always_show)
-SELECT 1075661, '閿�鍞璐�', 'crm:receivable:query', 2, 8, 2645, 'sale-reconciliation', '', 'erp/finance/reconciliation/index', 0, 1, 1, 1
+SELECT 1075661, '閿�鍞璐�', 'crm:receivable:query', 2, 8, 2645, 'sale-reconciliation', 'ep:document-checked', 'erp/finance/reconciliation/index', 0, 1, 1, 1
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 1075661);
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, status, visible, keep_alive, always_show)
-SELECT 1075662, '鏍搁攢绠＄悊', 'crm:receivable:query', 2, 9, 2645, 'write-off', '', 'erp/finance/writeoff/index', 0, 1, 1, 1
+SELECT 1075662, '鏍搁攢绠＄悊', 'crm:receivable:query', 2, 9, 2645, 'write-off', 'ep:stamp', 'erp/finance/writeoff/index', 0, 1, 1, 1
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 1075662);
-- 5. 璐ㄩ噺宸℃缂栫爜瑙勫垯锛歑J_ + yyyyMMdd + 3 浣嶆祦姘�
@@ -11587,6 +11596,28 @@
`status` = 0, `deleted` = 0, `update_time` = NOW();
-- ============================================================
+-- 闃舵涓�杩藉姞锛�2026-11-09锛夛細瀹㈡埛娲借皥杩涘害琛�
+-- 瀹㈡埛璇︽儏銆屾唇璋堣繘搴︺�嶉〉绛剧淮鎶ゅ鏉¤褰曪紱瀹㈡埛瀵煎嚭鏃跺彇姣忎釜瀹㈡埛鏈�鏂颁竴鏉★紙鎸� progress_time 鍊掑簭锛�
+-- 骞傜瓑锛氬彲閲嶅鎵ц
+-- ============================================================
+CREATE TABLE IF NOT EXISTS `crm_customer_progress`
+(
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `customer_id` bigint NOT NULL COMMENT '瀹㈡埛缂栧彿',
+ `content` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '娲借皥杩涘害鍐呭',
+ `progress_time` datetime NOT NULL COMMENT '娲借皥鏃堕棿',
+ `creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�',
+ `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `idx_customer_id` (`customer_id`) USING BTREE
+) ENGINE = InnoDB
+ DEFAULT CHARSET = utf8mb4
+ COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC COMMENT ='CRM 瀹㈡埛娲借皥杩涘害琛�';
+
+-- ============================================================
-- 闃舵浜岃拷鍔狅紙2026-11-09锛夛細瀹㈡埛绠＄悊涓庤仈绯讳汉绠＄悊鍚堝苟
-- 鑱旂郴浜轰笉鍐嶄綔涓洪攢鍞鐞嗕笅鐨勭嫭绔嬫ā鍧楋紝缁熶竴鍦ㄣ�屽鎴风鐞� 鈫� 瀹㈡埛璇︽儏 鈫� 鑱旂郴浜恒�嶉〉绛剧淮鎶�
-- 鑿滃崟 2416銆岃仈绯讳汉绠＄悊銆嶈褰曚繚鐣欙紙璺敱銆佹寜閽潈闄愩�佽鑹叉巿鏉冧笉鍙橈級锛屼粎浠庡乏渚ц彍鍗曢殣钘�
@@ -11595,3 +11626,142 @@
UPDATE `system_menu`
SET `visible` = 0, `updater` = '1', `update_time` = NOW()
WHERE `id` = 2416 AND `deleted` = 0;
+
+-- ============================================================
+-- 闃舵涓�杩藉姞锛�2026-11-09锛夛細瀹℃壒璇︽儏灞曠ず涓氬姟鍗曟嵁璇︽儏
+-- 鏈哄埗锛欱pmBusinessAttachServiceImpl#fillBusinessForm 鎸夈�屾祦绋嬪畾涔� Key 鈫� 娴佺▼鍒嗙被銆嶅尮閰�
+-- bpm_business_attach锛坰tatus=0 寮�鍚級锛屽懡涓悗鎶婂鎵硅鎯呰〃鍗曞尯娓叉煋涓轰笟鍔¤鎯呯粍浠讹紝
+-- 缁勪欢鎺ユ敹涓氬姟涓婚敭 businessKey锛堝嵆鍗曟嵁 id锛夛紝璺緞鐢卞墠绔� registerComponent 鍔ㄦ�佽В鏋愩��
+-- 鏈琛ュ厖锛�
+-- 1. 閿�鍞姤浠峰鎵癸紙娴佺▼ Key QWEDD锛屽垎绫� sale_quotation_approve锛夆啋 鎶ヤ环鍗曡鎯�
+-- 2. 璇峰亣瀹℃壒锛坔rm_leave / hrm_leave_approve锛夆啋 璇峰亣鐢宠璇︽儏
+-- 3. 绂昏亴瀹℃壒锛坔rm_resignation / hrm_resignation_approve锛夆啋 绂昏亴鐢宠璇︽儏
+-- 鍙﹁ˉ hrm_audit_status 瀛楀吀锛欻RM 瀹℃壒璇︽儏鐢� DictTag 缈昏瘧瀹℃壒鐘舵�侊紝缂鸿瀛楀吀鏃剁姸鎬佹樉绀虹┖鐧�
+-- 骞傜瓑锛氬彲閲嶅鎵ц
+-- ============================================================
+INSERT INTO `bpm_business_attach` (`id`, `process_definition_key`, `business_type`, `component_path`,
+ `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+VALUES (11, 'sale_quotation_approve', 'crm_sale_quotation',
+ '/crm/saleQuotation/detail/approve/index.vue', 0, '閿�鍞姤浠峰鎵瑰睍绀烘姤浠疯鎯�',
+ '1', NOW(), '1', NOW(), 0x00),
+ (12, 'hrm_leave_approve', 'hrm_leave_application',
+ '/hrm/leave/detail/approve/index.vue', 0, '璇峰亣瀹℃壒灞曠ず璇峰亣鐢宠璇︽儏',
+ '1', NOW(), '1', NOW(), 0x00),
+ (13, 'hrm_resignation_approve', 'hrm_resignation_application',
+ '/hrm/resignation/detail/approve/index.vue', 0, '绂昏亴瀹℃壒灞曠ず绂昏亴鐢宠璇︽儏',
+ '1', NOW(), '1', NOW(), 0x00)
+ON DUPLICATE KEY UPDATE `business_type` = VALUES(`business_type`),
+ `component_path` = VALUES(`component_path`),
+ `status` = 0, `remark` = VALUES(`remark`),
+ `deleted` = 0, `update_time` = NOW();
+
+-- 涓嶅悎鏍煎搧澶勭悊瀹℃壒锛坢es_ncr_approve锛夆啋 涓嶅悎鏍煎搧澶勭悊鍗曡鎯�
+-- 涓嶅啓姝� id锛氶伩鍏嶄笌鍚勭幆澧冩棦鏈夎嚜澧� id 鍐茬獊锛涙寜鍞竴閿� (process_definition_key, deleted) 骞傜瓑
+INSERT INTO `bpm_business_attach` (`process_definition_key`, `business_type`, `component_path`,
+ `status`, `remark`, `creator`, `updater`, `deleted`)
+VALUES ('mes_ncr_approve', 'mes_qc_ncr', '/mes/qc/ncr/detail/approve/index.vue', 0,
+ '涓嶅悎鏍煎搧澶勭悊瀹℃壒灞曠ず涓嶅悎鏍煎搧澶勭悊鍗曡鎯�', '1', '1', 0x00)
+ON DUPLICATE KEY UPDATE `business_type` = VALUES(`business_type`),
+ `component_path` = VALUES(`component_path`),
+ `status` = 0, `remark` = VALUES(`remark`),
+ `deleted` = 0, `update_time` = NOW();
+
+INSERT INTO `system_dict_type` (`id`, `name`, `type`, `status`, `remark`,
+ `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+VALUES (1065420, 'HRM 瀹℃壒鐘舵��', 'hrm_audit_status', 0, '浜轰簨瀹℃壒鐘舵��',
+ '1', NOW(), '1', NOW(), 0)
+ON DUPLICATE KEY UPDATE `name` = VALUES(`name`), `status` = 0,
+ `remark` = VALUES(`remark`), `deleted` = 0, `update_time` = NOW();
+
+-- 鍙栧�煎榻� HrmAuditStatusEnum锛�0=鑽夌锛�10=瀹℃壒涓紝20=瀹℃壒閫氳繃锛�30=瀹℃壒椹冲洖锛�40=宸叉挙閿�
+INSERT INTO `system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
+ `color_type`, `css_class`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+VALUES (1065530, 1, '鑽夌', '0', 'hrm_audit_status', 0, '', '', '1', NOW(), '1', NOW(), 0),
+ (1065531, 2, '瀹℃壒涓�', '10', 'hrm_audit_status', 0, '', '', '1', NOW(), '1', NOW(), 0),
+ (1065532, 3, '瀹℃壒閫氳繃', '20', 'hrm_audit_status', 0, '', '', '1', NOW(), '1', NOW(), 0),
+ (1065533, 4, '瀹℃壒椹冲洖', '30', 'hrm_audit_status', 0, '', '', '1', NOW(), '1', NOW(), 0),
+ (1065534, 5, '宸叉挙閿�', '40', 'hrm_audit_status', 0, '', '', '1', NOW(), '1', NOW(), 0)
+ON DUPLICATE KEY UPDATE `sort` = VALUES(`sort`), `label` = VALUES(`label`), `value` = VALUES(`value`),
+ `status` = 0, `deleted` = 0, `update_time` = NOW();
+
+-- ============================================================
+-- 闃舵涓�杩藉姞锛�2026-11-09锛夛細NCR 澶勭疆鑱斿姩鍏ュ簱 / 鐢熶骇
+-- 鑳屾櫙锛氫笉鍚堟牸鍝佸鐞嗗崟澶勭疆涓恒�岃姝ユ斁琛屻��/銆屾姤搴熴�嶆椂鑷姩鐢熸垚鏉傞」鍏ュ簱鍗曞苟鍏ュ簱瀛橈紝
+-- 澶勭疆涓恒�岃繑宸ャ��/銆岃繑淇�嶆椂鑷姩鐢熸垚鐢熶骇璁㈠崟銆�
+-- 1. mes_wm_misc_receipt 琛� type / source_doc_type / source_doc_id / source_doc_code
+-- 2. mes_wm_misc_receipt_line 琛� batch_code / warehouse_id / location_id / area_id
+-- 3. mes_wm_misc_receipt_detail 琛� batch_code
+-- 4. mes_wm_misc_receipt_type 瀛楀吀琛ャ�岃姝ユ斁琛屽叆搴�(2)銆嶃�屾姤搴熷叆搴�(3)銆�
+-- 鏂板缓搴擄細涓婇潰寤鸿〃璇彞宸插寘鍚笂杩板瓧娈碉紝鏈妭 ALTER 浼氳嚜鍔ㄨ烦杩�
+-- 宸蹭笂绾垮簱锛氱洿鎺ユ墽琛屾湰鑺傚嵆鍙紙MySQL 8.4 涓嶆敮鎸� ADD COLUMN IF NOT EXISTS锛�
+-- ============================================================
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt' AND column_name = 'type');
+SET @sql = IF(@col_exists = 0,
+ 'ALTER TABLE `mes_wm_misc_receipt` ADD COLUMN `type` int DEFAULT NULL COMMENT ''鏉傞」绫诲瀷'' AFTER `name`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt' AND column_name = 'source_doc_type');
+SET @sql = IF(@col_exists = 0,
+ 'ALTER TABLE `mes_wm_misc_receipt` ADD COLUMN `source_doc_type` varchar(64) DEFAULT NULL COMMENT ''鏉ユ簮鍗曟嵁绫诲瀷'' AFTER `type`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt' AND column_name = 'source_doc_id');
+SET @sql = IF(@col_exists = 0,
+ 'ALTER TABLE `mes_wm_misc_receipt` ADD COLUMN `source_doc_id` bigint DEFAULT NULL COMMENT ''鏉ユ簮鍗曟嵁 ID'' AFTER `source_doc_type`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt' AND column_name = 'source_doc_code');
+SET @sql = IF(@col_exists = 0,
+ 'ALTER TABLE `mes_wm_misc_receipt` ADD COLUMN `source_doc_code` varchar(100) DEFAULT NULL COMMENT ''鏉ユ簮鍗曟嵁缂栧彿'' AFTER `source_doc_id`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt_line' AND column_name = 'batch_code');
+SET @sql = IF(@col_exists = 0,
+ 'ALTER TABLE `mes_wm_misc_receipt_line` ADD COLUMN `batch_code` varchar(100) DEFAULT NULL COMMENT ''鎵规鍙�'' AFTER `quantity`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt_line' AND column_name = 'warehouse_id');
+SET @sql = IF(@col_exists = 0,
+ 'ALTER TABLE `mes_wm_misc_receipt_line` ADD COLUMN `warehouse_id` bigint DEFAULT NULL COMMENT ''浠撳簱 ID'' AFTER `batch_code`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt_line' AND column_name = 'location_id');
+SET @sql = IF(@col_exists = 0,
+ 'ALTER TABLE `mes_wm_misc_receipt_line` ADD COLUMN `location_id` bigint DEFAULT NULL COMMENT ''搴撳尯 ID'' AFTER `warehouse_id`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt_line' AND column_name = 'area_id');
+SET @sql = IF(@col_exists = 0,
+ 'ALTER TABLE `mes_wm_misc_receipt_line` ADD COLUMN `area_id` bigint DEFAULT NULL COMMENT ''搴撲綅 ID'' AFTER `location_id`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_misc_receipt_detail' AND column_name = 'batch_code');
+SET @sql = IF(@col_exists = 0,
+ 'ALTER TABLE `mes_wm_misc_receipt_detail` ADD COLUMN `batch_code` varchar(100) DEFAULT NULL COMMENT ''鎵规鍙�'' AFTER `quantity`',
+ 'SELECT 1');
+PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
+
+-- 鏉傞」鍏ュ簱绫诲瀷瀛楀吀锛氳姝ユ斁琛屽叆搴� / 鎶ュ簾鍏ュ簱
+INSERT INTO `system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
+ `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+VALUES (1065535, 2, '璁╂鏀捐鍏ュ簱', '2', 'mes_wm_misc_receipt_type', 0, 'primary', '', '璁╂鏀捐鍏ュ簱', '1', NOW(), '1', NOW(), 0),
+ (1065536, 3, '鎶ュ簾鍏ュ簱', '3', 'mes_wm_misc_receipt_type', 0, 'danger', '', '鎶ュ簾鍏ュ簱', '1', NOW(), '1', NOW(), 0)
+ON DUPLICATE KEY UPDATE `sort` = VALUES(`sort`), `label` = VALUES(`label`), `value` = VALUES(`value`),
+ `status` = 0, `remark` = VALUES(`remark`), `deleted` = 0, `update_time` = NOW();
--
Gitblit v1.9.3