From 0641c59519c3c5ef731962fdc2c447d1b44bb9f4 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期四, 26 十月 2023 20:32:25 +0800
Subject: [PATCH] fix: 根据调拨单生成出库单，根据出库单id进行出库

---
 consum-base/doc/更新正式环境需要添加.sql |   11 +++++++++++
 1 files changed, 11 insertions(+), 0 deletions(-)

diff --git "a/consum-base/doc/\346\233\264\346\226\260\346\255\243\345\274\217\347\216\257\345\242\203\351\234\200\350\246\201\346\267\273\345\212\240.sql" "b/consum-base/doc/\346\233\264\346\226\260\346\255\243\345\274\217\347\216\257\345\242\203\351\234\200\350\246\201\346\267\273\345\212\240.sql"
index df6403b..f06fbe0 100644
--- "a/consum-base/doc/\346\233\264\346\226\260\346\255\243\345\274\217\347\216\257\345\242\203\351\234\200\350\246\201\346\267\273\345\212\240.sql"
+++ "b/consum-base/doc/\346\233\264\346\226\260\346\255\243\345\274\217\347\216\257\345\242\203\351\234\200\350\246\201\346\267\273\345\212\240.sql"
@@ -12,3 +12,14 @@
 SET i=i+1; END WHILE;-- If no errors, commit the transaction
 COMMIT; END
 -- 鍒涘缓瀛樺偍杩囩▼缁撴潫  -----------
+
+-- 鍒涘缓瀛樺偍杩囩▼寮�濮�-----------
+DELIMITER //
+CREATE PROCEDURE `insert_WH_GOODS_RECORD_DETAILS` (IN WHGOODSIDList TEXT,IN WH_GOODS_RECORD_ID BIGINT,IN THIS_TYPE INT) BEGIN DECLARE i INT DEFAULT 1; DECLARE n INT DEFAULT 0; DECLARE WH_GOODS_ID BIGINT;
+SET n=LENGTH(WHGOODSIDList)-LENGTH(
+        REPLACE (WHGOODSIDList,',',''))+1; WHILE i<=n
+DO
+SET WH_GOODS_ID=SUBSTRING_INDEX(SUBSTRING_INDEX(WHGOODSIDList,',',i),',',-1);
+INSERT INTO L_WH_GOODS_RECORD_DETAILS (WH_GOODS_RECORD_ID,WH_GOODS_ID,THIS_TYPE) VALUES (WH_GOODS_RECORD_ID,WH_GOODS_ID,THIS_TYPE);
+SET i=i+1; END WHILE; END
+-- 鍒涘缓瀛樺偍杩囩▼缁撴潫  -----------

--
Gitblit v1.9.1