-- ===================================================== -- 需求四 第5点 —— 厂区直发绑厂区出库单 + 出库按钮权限(幂等) -- ===================================================== -- 1. 外贸订单增加“厂区出库单”关联字段 SET @c1 := (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='trade_foreign_order' AND COLUMN_NAME='out_product_sales_id'); SET @d1 := IF(@c1=0, 'ALTER TABLE `trade_foreign_order` ADD COLUMN `out_product_sales_id` bigint NULL COMMENT ''厂区直发:绑定的厂区出库单(MES成品出库单)编号'' AFTER `out_count`', 'SELECT 1'); PREPARE s FROM @d1; EXECUTE s; DEALLOCATE PREPARE s; SET @c2 := (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='trade_foreign_order' AND COLUMN_NAME='out_product_sales_code'); SET @d2 := IF(@c2=0, 'ALTER TABLE `trade_foreign_order` ADD COLUMN `out_product_sales_code` varchar(64) NULL COMMENT ''厂区直发:厂区出库单号'' AFTER `out_product_sales_id`', 'SELECT 1'); PREPARE s FROM @d2; EXECUTE s; DEALLOCATE PREPARE s; -- 2. 出库按钮权限(幂等) INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) SELECT 1067110,'外贸订单出库','trade:foreign-order:outbound',3,9,1067101,'','','','',0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0' WHERE NOT EXISTS (SELECT 1 FROM `system_menu` WHERE id=1067110);