From 56bcea62b0f4c9a2fc737502c35bd44b847c20a4 Mon Sep 17 00:00:00 2001 From: CZT <czt18638530771@163.com> Date: 星期四, 28 九月 2023 11:58:55 +0800 Subject: [PATCH] 贝博粮情解析3 --- igds-doc/sql/update-v35-to-v40.sql | 80 +++++++++++++++++++++++++++++++++++++++ 1 files changed, 79 insertions(+), 1 deletions(-) diff --git a/igds-doc/sql/update-v35-to-v40.sql b/igds-doc/sql/update-v35-to-v40.sql index 49d48fa..7c0a02a 100644 --- a/igds-doc/sql/update-v35-to-v40.sql +++ b/igds-doc/sql/update-v35-to-v40.sql @@ -23,4 +23,82 @@ RENAME TABLE D_M_STOCK_CHANGE TO D_INOUT_STOCK_CHANGE; --瀹㈡埛淇＄敤 -RENAME TABLE D_CREDIT TO D_INTOU_CREDIT; \ No newline at end of file +RENAME TABLE D_CREDIT TO D_INTOU_CREDIT; + + +-- 鍗囩骇浠撴埧鐘舵�� 1=绌轰粨銆�2=鍏ュ簱涓��3=婊′粨銆�4=鍑哄簱涓��9=鍏朵粬 銆�31姘旇皟涓��32鐔忚捀涓��33閫氶涓� 34娓╂帶涓� +UPDATE D_DEPOT SET DEPOT_STATUS_ = '1' WHERE DEPOT_STATUS_ ='01'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '2' WHERE DEPOT_STATUS_ ='03'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '3' WHERE DEPOT_STATUS_ ='02'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '4' WHERE DEPOT_STATUS_ ='04'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '31' WHERE DEPOT_STATUS_ ='05'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '32' WHERE DEPOT_STATUS_ ='06'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '33' WHERE DEPOT_STATUS_ ='07'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '34' WHERE DEPOT_STATUS_ ='09'; + +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '1' WHERE DEPOT_STATUS_ ='01'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '2' WHERE DEPOT_STATUS_ ='03'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '3' WHERE DEPOT_STATUS_ ='02'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '4' WHERE DEPOT_STATUS_ ='04'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '31' WHERE DEPOT_STATUS_ ='05'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '32' WHERE DEPOT_STATUS_ ='06'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '33' WHERE DEPOT_STATUS_ ='07'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '34' WHERE DEPOT_STATUS_ ='09'; + +-- 璋冩暣鍑哄叆搴撴暟鎹姸鎬� +UPDATE D_INOUT_RECORD SET RECORD_STATUS_ ='DEL' WHERE RECORD_STATUS_='ERROR'; + +-- 璋冩暣缁撶畻瀛楁 +ALTER TABLE `d_inout_settle` +CHANGE COLUMN `PAY_SUM_` `PAY_MONEY_` double NULL DEFAULT NULL AFTER `PAY_PRICE_`; + + +-- 鏇存柊鍖栭獙椤� +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '020101' WHERE CODE_ ='C01'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01010301' WHERE CODE_ ='C02'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01010701' WHERE CODE_ ='C03'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01010401' WHERE CODE_ ='C04'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01010304' WHERE CODE_ ='C05'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '010101' WHERE CODE_ ='C06'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '040302' WHERE CODE_ ='C07'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '040103' WHERE CODE_ ='C08'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01012101' WHERE CODE_ ='C09'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01012104' WHERE CODE_ ='C10'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01012102' WHERE CODE_ ='C11'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01012103' WHERE CODE_ ='C12'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01010201' WHERE CODE_ ='C13'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '02010306' WHERE CODE_ ='C14'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01010405' WHERE CODE_ ='C15'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '010105' WHERE CODE_ ='C16'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '02010301' WHERE CODE_ ='C18'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '02010401' WHERE CODE_ ='C19'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01012114' WHERE CODE_ ='C20'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01020303' WHERE CODE_ ='C21'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '02010331' WHERE CODE_ ='C22'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '02010332' WHERE CODE_ ='C23'; +UPDATE D_DIC_CHECK_ITEM SET CODE_ = '02030922' WHERE CODE_ ='C24'; + +-- 鏇存柊鍖栭獙鏁版嵁 +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '020101' WHERE SETSTANDARD_ID_ ='C01'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01010301' WHERE SETSTANDARD_ID_ ='C02'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01010701' WHERE SETSTANDARD_ID_ ='C03'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01010401' WHERE SETSTANDARD_ID_ ='C04'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01010304' WHERE SETSTANDARD_ID_ ='C05'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '010101' WHERE SETSTANDARD_ID_ ='C06'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '040302' WHERE SETSTANDARD_ID_ ='C07'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '040103' WHERE SETSTANDARD_ID_ ='C08'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01012101' WHERE SETSTANDARD_ID_ ='C09'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01012104' WHERE SETSTANDARD_ID_ ='C10'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01012102' WHERE SETSTANDARD_ID_ ='C11'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01012103' WHERE SETSTANDARD_ID_ ='C12'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01010201' WHERE SETSTANDARD_ID_ ='C13'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '02010306' WHERE SETSTANDARD_ID_ ='C14'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01010405' WHERE SETSTANDARD_ID_ ='C15'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '010105' WHERE SETSTANDARD_ID_ ='C16'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '02010301' WHERE SETSTANDARD_ID_ ='C18'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '02010401' WHERE SETSTANDARD_ID_ ='C19'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01012114' WHERE SETSTANDARD_ID_ ='C20'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '01020303' WHERE SETSTANDARD_ID_ ='C21'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '02010331' WHERE SETSTANDARD_ID_ ='C22'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '02010332' WHERE SETSTANDARD_ID_ ='C23'; +UPDATE D_CHECK_ITEM SETSTANDARD_ID_ = '02030922' WHERE SETSTANDARD_ID_ ='C24'; -- Gitblit v1.9.3