fix: 根据调拨单生成出库单，根据出库单id进行出库

cy

2023-10-26 0641c59519c3c5ef731962fdc2c447d1b44bb9f4

fix: 根据调拨单生成出库单，根据出库单id进行出库

 consum-base/doc/¸üÐÂÕýʽ»·¾³ÐèÒªÌí¼Ó.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
-- åˆ›å»ºå­˜å‚¨è¿‡ç¨‹ç»“束  -----------