DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0003/2022/TTr-0692105')

SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID

SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)

SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)

SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT GOODS_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)

SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT FR_GOOD_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)

SELECT * FROM CM_GOODSTYPE

SELECT * FROM PL_TRADEDETAIL_HIST WHERE REQ_ID =@REQ_ID

--SELECT * FROM CM_GOODS WHERE GD_CODE ='AD.I.N.CE.0117.2021'

--SELECT * FROM CM_NS_CP_ALL$ WHERE GD_ID ='GOO000000253580'

--UPDATE PL_REQUEST_DOC_DT SET PLAN_ID ='PLM000000251966', TRADE_ID ='PLT000000255042', GOODS_ID ='GOO000001061873' WHERE REQDT_ID ='PLRDD0000214524'

--UPDATE PL_REQUEST_TRANSFER SET TO_PLAN_ID ='PLM000000258444', TO_TRADE_ID ='PLT000000279146', TO_GOOD_ID ='GOO000000253580' WHERE REQ_TRANSFER_ID =''

----INSERT INTO PL_TRADEDETAIL (TRADE_ID, PLAN_ID, AMT_APP, AMT_ETM, AMT_EXE, AMT_TF, AMT_RECEIVE_TF, RECORD_STATUS, AUTH_STATUS,GOODS_ID)

--SELECT TRADE_ID, PLAN_ID,AMT_APP,AMT_ETM,AMT_EXE,AMT_TF,AMT_RECEIVE_TF,'1','A',GD_ID FROM CM_NS_CP_ALL$

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0005/2021/TTr-89900001')

EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)

@p_AUTH_STATUS = 'A', -- varchar(1)

@p_CHECKER_ID = 'trungnq1', -- varchar(15)

@p_APPROVE_DT = '2021-06-08 12:00:00 AM', -- datetime

@p_ROLE_LOGIN = 'TGD', -- varchar(50)

@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)

@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)

DELETE FROM PL_PROCESS WHERE REQ_ID =@REQ_ID AND CHECKER_ID ='trungnq1' 

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='TGD'

EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)

@p_AUTH_STATUS = 'A', -- varchar(1)

@p_CHECKER_ID = 'taila', -- varchar(15)

@p_APPROVE_DT = '2021-06-08 12:00:00 AM', -- datetime

@p_ROLE_LOGIN = 'HDQT', -- varchar(50)

@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)

@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)

SET @REQ_ID=(SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE ='NCC.2021.000485')

UPDATE TR_REQ_ADVANCE_PAYMENT SET AUTH_STATUS='A', AUTH_STATUS_KT='A', REQ_PAY_CODE ='062021/000429', REQ_DT ='2020-06-30',

APPROVE_DT ='2020-06-30', CREATE_DT_KT ='2020-06-30', APPROVE_DT_KT ='2020-06-30' WHERE REQ_PAY_ID =@REQ_ID

UPDATE TR_REQ_PAY_PERIOD SET AUTH_STATUS_KT='A' WHERE REQ_PAY_ID =@REQ_ID

UPDATE TR_REQ_PAY_SCHEDULE SET AUTH_STATUS_KT='A' WHERE REQ_PAY_ID =@REQ_ID

SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0052/2021/TTR-0692103')

UPDATE PL_REQUEST_DOC SET AUTH_STATUS='R', PROCESS_ID ='REJECT' WHERE REQ_ID =@REQ_ID

UPDATE PL_REQUEST_PROCESS SET STATUS ='U' WHERE REQ_ID =@REQ_ID

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='052021/001410')

SELECT * FROM PAY_ENTRIES_POST WHERE TRN_ID =@REQ_ID

UPDATE PL_REQUEST_DOC SET REQ_DT ='2021-05-20 12:00:00 AM' WHERE REQ_CODE ='0124/2021/TTr-0690604'

-- LÙI NGÀY

DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME

SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0130/2021/TTr-0690604')

SET @DATE='2021-05-20 12:00:00 AM'

UPDATE PL_REQUEST_DOC SET REQ_DT =@DATE, APPROVE_DT =@DATE, EFFEC_DT =@DATE, IS_BACKDAY=1 WHERE REQ_ID =@REQ_ID

UPDATE PL_REQUEST_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày',N'Hỗ trợ lùi ngày chủ trương theo yêu cầu','dungltm',GETDATE())

SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0036/2021/TTr-0690405')

SET @DATE='2021-05-05 12:00:00 AM'

UPDATE PL_REQUEST_DOC SET REQ_DT =@DATE, APPROVE_DT =@DATE, EFFEC_DT =@DATE, IS_BACKDAY=1 WHERE REQ_ID =@REQ_ID

UPDATE PL_REQUEST_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày',N'Hỗ trợ lùi ngày chủ trương theo yêu cầu','quanvta',GETDATE())

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000902')

UPDATE TR_REQUEST_DOC_DT SET SUP_ID ='CMS000000252058' WHERE REQ_DOC_ID =@REQ_ID AND TOTAL_AMT =14630000

--- CONFIG LUI NGAY TO TRINH CHU TRUONG 2021715

--- Lui ngay PYCMS

DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME, @USER_REQUEST VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001596')

SET @DATE='2021-10-05 12:00:00 AM'

UPDATE TR_REQUEST_DOC SET APPROVE_DT =@DATE='2021 WHERE REQ_ID =@REQ_ID 

UPDATE PL_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu','admin',GETDATE())

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='062021/000039')

UPDATE TR_REQ_PAYMENT SET REQ_REASON =N'Thanh toán đợt 1 (40%) và đợt 2 (30%) chi phí thi công Biển hiệu PGD Hậu Giang' WHERE REQ_PAY_ID =@REQ_ID

UPDATE TR_REQ_PAY_METHOD SET REQ_PAY_REASON =N'Thanh toán đợt 1 (40%) và đợt 2 (30%) chi phí thi công Biển hiệu PGD Hậu Giang', 

REQ_PAY_ENTRIES =N'Thanh toán đợt 1 (40%) và đợt 2 (30%) chi phí thi công Biển hiệu PGD Hậu Giang',

REQ_PAY_DESC =N'Thanh toán đợt 1 (40%) và đợt 2 (30%) chi phí thi công Biển hiệu PGD Hậu Giang'

WHERE REQ_PAY_ID =@REQ_ID

UPDATE TR_REQ_PAY_SCHEDULE SET REQ_PAY_DESC =N'Thanh toán đợt 1 (40%) và đợt 2 (30%) chi phí thi công Biển hiệu PGD Hậu Giang',

REQ_PAY_ENTRIES =N'Thanh toán đợt 1 (40%) và đợt 2 (30%) chi phí thi công Biển hiệu PGD Hậu Giang'

WHERE REQ_PAY_ID =@REQ_ID

UPDATE TR_REQ_PAY_BUDGET SET REASON =N'Thanh toán đợt 1 (40%) và đợt 2 (30%) chi phí thi công Biển hiệu PGD Hậu Giang'

WHERE REQ_PAY_ID =@REQ_ID

SELECT GD_ID FROM CM_GOODS WHERE GD_CODE ='AD.I.N.CE.0035.2021'

SELECT * FROM PL_TRADEDETAIL WHERE GOODS_ID =(SELECT GD_ID FROM CM_GOODS WHERE GD_CODE ='AD.I.N.CE.0035.2021')

SELECT * FROM PL_MASTER WHERE BRANCH_ID ='BRN000000000397' AND PLAN_ID IN (SELECT PLAN_ID FROM PL_TRADEDETAIL WHERE GOODS_ID =(SELECT GD_ID FROM CM_GOODS WHERE GD_CODE ='AD.I.N.CE.0035.2021'))

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001776')

SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID

SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@REQ_ID

SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID =@REQ_ID

SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

UPDATE TR_REQUEST_DOC 

SET DMMS_ID =(SELECT DMMS_ID FROM CM_DMMS WHERE BRANCH_ID =(SELECT BRANCH_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001041')) 

WHERE REQ_CODE ='PUR/2021/001041'

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000201654','GDK_TT','C','GDK','DV0001','',NULL,'DVCM','N','','DM0000000000015',N'Chờ GĐK Hỗ Trợ xác nhận','0','')

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0158/2021/TTr-0690604')

INSERT INTO PL_REQUEST_PROCESS VALUES (@REQ_ID,'HDQT','P','HDQT','DV0001','',NULL,'TGD','N','','',N'Chủ tịch HĐQT đã phê duyệt','0','')

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='HDQT' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000203334','HDQT','P','HDQT','DV0001','',NULL,'TGD','N','','',N'Chờ Chủ Tịch HĐQT phê duyệt','0','')

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='HDQT' WHERE REQ_ID ='PLRD00000203334' AND PROCESS_ID ='APPROVE'

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='HDQT' WHERE REQ_ID='PLRD00000203334'

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000202297','GDK_DC','C','GDK','DV0001','',NULL,'TC','N','','DM0000000000017',N'Chờ GĐK Tài Chính xác nhận','0','')

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='GDK_DC' WHERE REQ_ID ='PLRD00000202297'

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='GDK_DC', STATUS ='U' WHERE ID ='28698'

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000202026','KT','P','KT','DV0001','chaudtm','2021-06-09 10:23:49 AM','APPNEW','N','','DM0000000000006',N'Phòng kế toán đã phê duyệt','1','')

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000202026','DVCM','P','GDDV','DV0001','hoattm','2021-06-09 8:47:16 PM','KT','N','','DM0000000000048',N'Đơn vị chuyên môn đã phê duyệt','1','')

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000202026','DVCM','P','GDDV','DV0001','chittn','2021-06-10  9:26:43 AM','KT','N','','DM0000000000003',N'Đơn vị chuyên môn đã phê duyệt','1','')

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000202026','APPROVE','C','','','',NULL,'DVCM','N','','',N'Hoàn tất','0','')

UPDATE PL_REQUEST_PROCESS SET STATUS ='U', PARENT_PROCESS_ID ='GDK_TT' WHERE ID ='21638'

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='GDK_TT' WHERE REQ_ID ='PLRD00000201654'

UPDATE PL_TRADEDETAIL SET AMT_ETM = ISNULL(AMT_ETM,0)-14245000 WHERE TRADE_ID ='PLT000000269039'

DELETE FROM PL_TRADEDETAIL_HIST WHERE REQ_ID ='PLRD00000201654'

DECLARE @TRADE_ID VARCHAR(15), @PLAN_ID VARCHAR(15), @GOOD_ID VARCHAR(15)

SET @GOOD_ID =(SELECT GD_ID FROM CM_GOODS WHERE GD_CODE ='ND.I.N.CE.0072.2021')

SELECT * FROM PL_MASTER WHERE BRANCH_ID ='DV0001'  AND DEPT_ID ='DEP000000000001' AND YEAR=2021

SELECT * FROM PL_TRADEDETAIL WHERE PLAN_ID IN (SELECT PLAN_ID FROM PL_MASTER WHERE BRANCH_ID ='DV0001'  AND DEPT_ID ='DEP000000000001' AND YEAR=2021) AND GOODS_ID =@GOOD_ID

--SET @PLAN_ID =(SELECT * FROM PL_MASTER WHERE BRANCH_ID ='DV0001'  AND DEPT_ID ='DEP000000000001' AND YEAR=2021)

--SET @TRADE_ID =(SELECT TRADE_ID FROM PL_TRADEDETAIL WHERE PLAN_ID =@PLAN_ID AND GOODS_ID =@GOOD_ID)

--PRINT @TRADE_ID

UPDATE PL_REQUEST_DOC SET AUTH_STATUS ='A', PROCESS_ID ='TGD' WHERE REQ_CODE ='0047/2021/TTr-0690405'

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000201918','TGD','C','TGD','DV0001','',NULL,'','N','','',N'Chờ Tổng Giám Đốc phê duyệt','0','')

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000201918','APPROVE','U','','DV0001','',NULL,'TGD','N','','',N'Hoàn tất','0','')

SELECT REPLACE( REPLACE(SUBSTRING(LEFT([TRANSACTION],30),24,30),'~0',''),'~','') FROM entries_post$ WHERE [TRANSACTION] LIKE '%XUAT KHO VAT LIEU THE THANG 03.2021 THEO BANG PHAN BO TTT NGAY 25.05.2021- LAN 2%'

DECLARE @REQ_ID VARCHAR(15),@MAST_BAL_ID VARCHAR(15)

SET @REQ_ID=(SELECT PRICE_ID FROM MW_MAST_PRICE WHERE PRICE_CODE ='069PTTT190006001')

SET @MAST_BAL_ID =(SELECT MAST_BAL_ID FROM MW_MAST_BAL WHERE PRICE_ID =@REQ_ID)

SELECT * FROM MW_OUT_DT WHERE MAST_BAL_ID =@MAST_BAL_ID AND OUT_ID IN (SELECT OUT_ID FROM MW_OUT WHERE OUT_CODE IN ('069TTXK210608002','069TTXK210608003','069TTXK210608004','069TTXK210608005',

'069TTXK210608006','069TTXK210608007','069TTXK210608008'))

DECLARE @REQ_ID VARCHAR(15),@MAST_BAL_ID VARCHAR(15)

SET @REQ_ID=(SELECT PRICE_ID FROM MW_MAST_PRICE WHERE PRICE_CODE ='069PTTT190006001')

SET @MAST_BAL_ID =(SELECT MAST_BAL_ID FROM MW_MAST_BAL WHERE PRICE_ID =@REQ_ID)

UPDATE MW_OUT_DT SET COST_ACC ='' WHERE MAST_BAL_ID =@MAST_BAL_ID AND OUT_ID IN (SELECT OUT_ID FROM MW_OUT WHERE OUT_CODE IN ('069TTXK210608002','069TTXK210608003','069TTXK210608004','069TTXK210608005',

'069TTXK210608006','069TTXK210608007','069TTXK210608008'))

User ID=gAMSPro_Sacombank_v3_Live;Password=gAMSPro_Sacombank_v3_Live@111

--DELETE FROM PL_REQUEST_DOC

--DELETE FROM PL_REQUEST_DOC_DT

--DELETE FROM PL_REQUEST_TRANSFER

--DELETE FROM TR_REQUEST_DOC

--DELETE FROM TR_REQUEST_DOC_DT

--DELETE FROM TR_REQUEST_DOC_PL_DT

--DELETE FROM PL_PROCESS

--DELETE FROM PL_REQUEST_PROCESS

--DELETE FROM PL_REQUEST_PROCESS_CHILD

SELECT * FROM CM_DEPARTMENT WHERE DEP_CODE ='89900001'

SELECT * FROM PL_MASTER WHERE DEPT_ID ='DEP000000252203'

SELECT * FROM PL_TRADEDETAIL WHERE PLAN_ID IN (SELECT PLAN_ID FROM PL_MASTER WHERE DEPT_ID ='DEP000000252203')

SELECT * FROM CM_GOODS WHERE GD_CODE ='DG.I.N.OE.0003.2021'

SELECT * FROM CM_HANGHOA WHERE HH_ID ='HH0000000112041'

SELECT * FROM SYS_HH_GROUP_LIMIT WHERE HH_ID ='HH0000000112041'

SELECT * FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000004'    GAYZERHD

SELECT * FROM SYS_GROUP_LIMIT_DT WHERE GROUP_LM_ID ='SGL000000000004'

INSERT INTO CM_DVDM (DVDM_ID, DVDM_CODE,DVDM_NAME,NOTES,RECORD_STATUS,AUTH_STATUS,MAKER_ID,CREATE_DT,EDITER_ID,EDIT_DT,CHECKER_ID,APPROVE_DT, IS_DVDM, IS_KHOI, IS_DVCM)

VALUES ('DM0000000000078','89900001','PHONG PHAT TRIEN KINH DOANH NGAN HANG SO','PHONG PHAT TRIEN KINH DOANH NGAN HANG SO',

'1','A','admin',GETDATE(),'admin',GETDATE(),1,0,1,0,0)

INSERT INTO PL_COSTCENTER (COST_ID,COST_CODE,COST_NAME,RECORD_STATUS,AUTH_STATUS,MAKER_ID,CREATE_DT,DVDM_ID)

VALUES ('PLCC00000001003','89900001','PHONG PHAT TRIEN KINH DOANH NGAN HANG SO','1','A','admin',GETDATE(),'DM0000000000078')

INSERT INTO PL_COSTCENTER_DT(COSTDT_ID,COST_ID,BRANCH_ID,DEP_ID,RECORD_STATUS,MAKER_ID,CREATE_DT)

VALUES ('PCDT00000001014','PLCC00000001003','DV0001','DEP000000252203','1','admin',GETDATE())

UPDATE CM_DVDM SET DVDM_CODE ='8990000', DVDM_NAME ='TRUNG TAM NGAN HANG SO' WHERE DVDM_ID ='DM0000000000034'

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE ='NBO.2021.000239')

EXEC TR_REQ_ADVANCE_PAYMENT_Appr @REQ_ID,'trungnq1','A',''

DELETE FROM PL_PROCESS WHERE REQ_ID =@REQ_ID AND CHECKER_ID ='trungnq1'

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0042/2021/TTr-0690405')

INSERT INTO PL_REQUEST_PROCESS VALUES (@REQ_ID,'TGD','P','TGD','DV0001','trungnq1','5/18/2021 10:30:53 AM','PTGDK_TT','N','','',N'Tổng giám đốc đã phê duyệt','0','')

INSERT INTO PL_PROCESS VALUES (@REQ_ID,'TGD','trungnq1','5/18/2021 10:30:53 AM',N'Phê duyệt',N'Tổng giám đốc đã phê duyệt')

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='TGD' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'

INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000000001','DM0000000000003')

INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000000002','DM0000000000003')

INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000000003','DM0000000000015')

INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000000004','DM0000000000003')

INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000000005','DM0000000000003')

INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000000006','DM0000000000003')

INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000000010','DM0000000000003')

INSERT INTO CM_HANGHOA_DVCM VALUES ('HHI000000000001','DM0000000000003')

INSERT INTO CM_HANGHOA_DVCM VALUES ('HHI000000000002','DM0000000000003')

INSERT INTO CM_HANGHOA_DVCM VALUES ('HHI000000000003','DM0000000000003')

INSERT INTO CM_HANGHOA_DVCM VALUES ('HHI000000000004','DM0000000000003')

ALTER TABLE CM_HANGHOA_DVCM

DROP  CONSTRAINT [PK_CM_HANGHOA_DVCM]

ALTER TABLE CM_HANGHOA_DVCM

ADD PRIMARY KEY(HH_ID);

ALTER TABLE CM_HANGHOA_DVCM ALTER COLUMN HH_ID VARCHAR(15)  NOT NULL

SELECT B.GD_CODE AS MA_NS, B.GD_NAME AS TEN_NS,C.DVDM_CODE AS MA_DVCM,C.DVDM_NAME AS TEN_DVCM,E.AMT_APP AS NS_DUYET, E.AMT_ETM AS NS_SD_DUKIEN, E.AMT_EXE AS NS_SD_THUCTE,

E.AMT_RECEIVE_TF AS NS_NHAN, E.AMT_TF AS NS_CHUYEN, A.SO_TIEN_DC AS N'SỐ TIỀN ĐIỀU CHUYỂN CHỜ DUYỆT', F.BRANCH_CODE AS MA_DV, F.BRANCH_NAME AS TEN_DV,

G.DEP_CODE AS MA_PB, G.DEP_NAME AS TEN_PB

FROM PL_TRADEDETAIL E

INNER JOIN

(

SELECT A.FR_TRADE_ID,A.FR_PLAN_ID,A.FR_GOOD_ID, SUM(A.TOTAL_AMT) AS SO_TIEN_DC,A.FR_DVDM_ID 

FROM PL_REQUEST_TRANSFER A

WHERE A.REQ_DOC_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE ISNULL(PROCESS_ID,'') <> 'APPROVE')

GROUP BY A.FR_TRADE_ID, A.FR_PLAN_ID,A.FR_GOOD_ID,FR_DVDM_ID

) AS A ON A.FR_TRADE_ID = A.FR_TRADE_ID

INNER JOIN CM_GOODS B ON A.FR_GOOD_ID = B.GD_ID

INNER JOIN CM_DVDM C ON A.FR_DVDM_ID = C.DVDM_ID

INNER JOIN PL_MASTER D ON A.FR_PLAN_ID = D.BRANCH_ID

INNER JOIN CM_BRANCH F ON D.BRANCH_ID = F.BRANCH_ID

INNER JOIN CM_DEPARTMENT G ON D.DEPT_ID = G.DEP_ID

ORDER BY A.FR_TRADE_ID

DECLARE @DEP_ID VARCHAR(15)

SET @DEP_ID=(SELECT DEP_ID FROM CM_DEPARTMENT WHERE DEP_CODE ='8990000')

SELECT A.*,B.GD_CODE,B.GD_NAME FROM PL_TRADEDETAIL A 

INNER JOIN CM_GOODS B ON A.GOODS_ID = B.GD_ID

WHERE A.PLAN_ID IN (SELECT PLAN_ID FROM PL_MASTER WHERE DEPT_ID =@DEP_ID)

AND B.GD_CODE  =  'PR.I.N.OE.0038.2021'

PLT000000252705	PLM000000251469	GOO000000251683

SELECT * FROM TR_REQ_PAY_INVOICE WHERE INVOICE_NO ='0000205'

SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAY_INVOICE WHERE INVOICE_NO ='0000205')

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001061')

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu chuyển PYCMS',N'Hỗ trợ chuyển PYCMS theo yêu cầu','trangtm',GETDATE())

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000888')

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu chuyển PYCMS',N'Hỗ trợ chuyển PYCMS theo yêu cầu','trangtm',GETDATE())

UPDATE TR_REQUEST_DOC SET MAKER_ID ='trangtm', USER_REQUEST ='trangtm' WHERE REQ_CODE ='PUR/2021/001061'

UPDATE TR_REQUEST_DOC SET MAKER_ID ='trangtm', USER_REQUEST ='trangtm' WHERE REQ_CODE ='PUR/2021/000888'

DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001501')

SET @DATE='2021-10-25 12:00:00 AM'

UPDATE PL_PROCESS SET APPROVE_DT=@DATE WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày PYCMS',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu','phuongvn',GETDATE())

INSERT INTO PL_REQUEST_COSTCENTER VALUES('LRC00000206312','DM0000000000048','PLRD00000202620','','U','',GETDATE(),'',NULL,'',0)

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000202620','DVCM','C','GDDV','DV0001','',NULL,'GDK_TT','N','','DM0000000000048',N'Chờ đơn vị chuyên môn xác nhận','1','')

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='DVCM' WHERE REQ_ID ='PLRD00000202620'

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='DVCM', STATUS ='U' WHERE ID ='32330'

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000202673','GDK_TT','C','GDK','DV0001','',NULL,'APPNEW','N','','DM0000000000015',N'Chờ GĐK Hỗ Trợ Phê duyệt','0','')

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='GDK_TT' WHERE REQ_ID ='PLRD00000202673'

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='GDK_TT', STATUS ='U' WHERE ID ='32768'

SELECT * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE ='NBO.2021.000574'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TADY00001130811'

UPDATE PL_REQUEST_PROCESS SET STATUS ='P' WHERE ID ='31945'

UPDATE PL_REQUEST_PROCESS SET STATUS ='P' WHERE ID ='31946'

UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID ='31947'

UPDATE PL_REQUEST_PROCESS SET STATUS ='U' WHERE ID ='31948'

--UPDATE TR_REQ_ADVANCE_PAYMENT SET OTHER_NOTES ='' WHERE REQ_PAY_CODE ='NBO.2021.000574'

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0448/2021/TTr-0690604'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00001114680'

UPDATE PL_REQUEST_PROCESS SET STATUS='U' WHERE  PROCESS_ID ='KT' AND REQ_ID='PLRD00001114680'

UPDATE PL_REQUEST_PROCESS SET STATUS='C',CHECKER_ID='', APPROVE_DT =NULL WHERE PROCESS_ID ='APPNEW' AND REQ_ID='PLRD00001114680'

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='APPNEW', AUTH_STATUS='U', CHECKER_ID='', APPROVE_DT =NULL WHERE REQ_CODE ='0448/2021/TTr-0690604'

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0448/2021/TTr-0690604'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00001114680'

UPDATE PL_REQUEST_PROCESS SET STATUS='U' WHERE  PROCESS_ID ='HDQT' AND REQ_ID='PLRD00001114680'

UPDATE PL_REQUEST_PROCESS SET STATUS='C',CHECKER_ID='', APPROVE_DT =NULL WHERE PROCESS_ID ='TKHDQT' AND REQ_ID='PLRD00001114680'

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TKHDQT' WHERE REQ_CODE ='0448/2021/TTr-0690604'

--- LAY THONG TIN NGAN SACH, PO, PYCMS, TTCT CUA 1 PHIEU THANH TOAN NCC PO

UPDATE TR_REQ_ADVANCE_PAYMENT SET AUTH_STATUS='A', AUTH_STATUS_KT ='A', APPROVE_DT =GETDATE(),

APPROVE_DT_KT = GETDATE(), CHECKER_ID ='admin', MAKER_ID_KT='admin', CHECKER_ID_KT ='admin'

WHERE REQ_PAY_CODE='XLN.2021.000201'

DECLARE @REQ_ID VARCHAR(15), @PO_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='102021/001276')

SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='102021/001276'

SELECT * FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID =@REQ_ID

SELECT * FROM TR_PO_MASTER WHERE PO_ID IN (SELECT REF_ID FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID =@REQ_ID)

SELECT * FROM TR_PO_DETAIL WHERE PO_ID IN (SELECT REF_ID FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID =@REQ_ID)

SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID IN (SELECT REQ_DOC_ID FROM TR_PO_MASTER WHERE PO_ID IN (SELECT REF_ID FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID =@REQ_ID))

SELECT * FROM PL_REQUEST_DOC_DT WHERE REQDT_ID IN (SELECT PL_REQDT_ID FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID IN (SELECT REQ_DOC_ID FROM TR_PO_MASTER WHERE PO_ID IN (SELECT REF_ID FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID =@REQ_ID)))

SET @PO_ID =(SELECT TOP 1 REF_ID FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID =@REQ_ID)

EXEC TR_REQ_GOOD_BYCONTRACT @PO_ID

----1.0 XUẤT NHỮNG HÓA ĐƠN ĐẦU VÀO ĐANG NẰM Ở NHỮNG PHIẾU ĐỀ NGHỊ THANH TOÁN CHƯA ĐƯỢC KSV PHÊ DUYỆT

   SELECT ROW_NUMBER() OVER (ORDER BY A.REQ_PAYDT_ID) AS STT,

    B.REQ_PAY_CODE,

	B.MAKER_ID AS NGUOI_TAO,

	CASE WHEN B.AUTH_STATUS ='E' THEN N'Lưu nháp'

	WHEN B.AUTH_STATUS ='U' THEN N'Đang chờ cấp duyệt trung gian/ TĐV duyệt'

	WHEN B.AUTH_STATUS ='A' THEN N'TĐV đã duyệt'

	WHEN ISNULL(B.AUTH_STATUS_KT,'') ='U' THEN N'Đang chờ GDV xử lý'

	WHEN ISNULL(B.AUTH_STATUS_KT,'') ='' THEN N'Đang chờ GDV xử lý'

	WHEN B.AUTH_STATUS_KT ='P' THEN N'Đang chờ KSV xử lý'

	WHEN B.AUTH_STATUS_KT ='R' THEN N'Đang bị KSV từ chối GDV'

	WHEN B.AUTH_STATUS ='R' THEN N'Đang bị từ chối về đơn vị tạo' END AS TINH_TRANG,

	BR_HT.BRANCH_CODE BRANCH_CODE,

	BR_HT.BRANCH_NAME BRANCH_NAME,

	ISNULL(UPPER(A.MAKER_ID_KT),B.MAKER_ID_KT) AS TLFNAME,

	A.VAT_KT VAT, 

	A.INVOICE_SIGN INVOICE_SIGN,

	A.INVOICE_NO_SIGN INVOICE_NO_SIGN,

	A.INVOICE_NO INVOICE_NO,

	ISNULL(FORMAT(A.INVOICE_DT,'dd/MM/yyyy'),'') AS INVOICE_DT,

	A.SELLER SELLER,

	A.TAX_NO TAX_NO,

	A.GOODS_NAME GOODS_NAME,

	A.PRICE_KT PRICE,

	A.TAX TAX,

	A.TOTAL_AMT_KT AS TOTAL_AMT,

	CASE WHEN A.TYPE_VAT = '0' THEN '353200001'  ELSE '353200002' END AS ACC, BR.BRANCH_NAME AS BRANCH_NAME_CRE

	FROM TR_REQ_PAY_INVOICE A

	LEFT JOIN TR_REQ_PAYMENT B ON  A.REQ_PAY_ID = B.REQ_PAY_ID

	LEFT JOIN CM_BRANCH BR ON B.BRANCH_ID = BR.BRANCH_ID

	LEFT JOIN TL_USER US ON B.MAKER_ID_KT = US.TLNANME

	LEFT JOIN CM_BRANCH BR_HT ON US.TLSUBBRID = BR_HT.BRANCH_ID

	WHERE 1=1

	AND B.AUTH_STATUS_KT  <>'A'

-----CONFIG 2021119 ----- THAY SỐ CHỖ NÀY TƯƠNG ỨNG: 2021: NĂM, 11: THÁNG, 9: NGÀY. VÍ DỤ NGÀY 10-11 CẦN XUẤT THÌ ĐIỀN:  20211110

BEGIN TRY

BEGIN TRANSACTION

DECLARE @REQ_ID VARCHAR(15), @USER_REQUEST VARCHAR(15), @DATE DATETIME

SET @USER_REQUEST='hungcn' ---- THAY USER DOMAIN YÊU CẦU HỖ TRỢ

SET @DATE='2021-06-28 12:00:00 AM' --- THAY NĂM - THÁNG - NGÀY

--------- 1.0 CAP NHAT TỜ TRÌNH BÌNH THƯỜNG THÀNH TỜ TRÌNH TOÀN HÀNG ---------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------

--SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0007/2020/TTr-0691006') ------ THAY SO TO TRINH CHU TRUONG

--UPDATE PL_REQUEST_DOC SET IS_CHECKALL='1'  WHERE REQ_ID =@REQ_ID

--INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

--VALUES (@REQ_ID,'IT',N'Yêu cầu cập nhật tờ trình toàn hàng',N'IT cập nhật tờ trình toàn hàng',@USER_REQUEST,GETDATE())

---------2.0 CAP NHAT LÙI NGÀY TỜ TRÌNH CHỦ TRƯƠNG ---------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------

SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0174/2021/TTr-0690604') --- THAY SO TO TRINH CHU TRUONG

UPDATE PL_REQUEST_DOC SET REQ_DT =@DATE, APPROVE_DT =@DATE, EFFEC_DT =@DATE, IS_BACKDAY=1 WHERE REQ_ID =@REQ_ID

UPDATE PL_REQUEST_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày',N'Hỗ trợ lùi ngày chủ trương theo yêu cầu',@USER_REQUEST,GETDATE())

---------3.0 CAP NHAT LÙI NGÀY PHIẾU YÊU CẦU MUA SẮM ---------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------

--SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000905') ---- DIEN SO PUR

--UPDATE TR_REQUEST_DOC SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID  ----- CẬP NHẬT NGÀY DUYỆT CỦA TRƯỞNG ĐƠN VỊ

--UPDATE PL_PROCESS SET APPROVE_DT=@DATE WHERE REQ_ID =@REQ_ID -- CẬP NHẬT NGÀY DUYỆT CỦA CÁC CẤP CÒN LẠI THAM GIA VÀO PYCMS (ĐMMS / GĐK HỖ TRỢ)

--INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

--VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày PYCMS',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu',@USER_REQUEST,GETDATE())

-------4.0 CAP NHAT PHIẾU ĐỀ NGHỊ TẠM ỨNG - NHỮNG PHIẾU TRÊN HỆ THỐNG LOTUS IBM CŨ CHƯA IMPORT TRONG ĐỢT GOLIVE LÊN AMS 

-------------------------------------------------------------------------------------------------------------------

--UPDATE TR_REQ_ADVANCE_PAYMENT SET AUTH_STATUS ='A', AUTH_STATUS_KT ='A', CHECKER_ID ='admin', CHECKER_ID_KT ='admin' WHERE REQ_PAY_CODE ='XLN.2021.000196' -- THAY SỐ PĐN TẠM ỨNG

-------5.0 CAP NHAT PHIẾU ĐỀ NGHỊ THANH TOÁN - NHỮNG PHIẾU TRÊN HỆ THỐNG LOTUS IBM CŨ CHƯA IMPORT TRONG ĐỢT GOLIVE LÊN AMS 

-------------------------------------------------------------------------------------------------------------------

--UPDATE TR_REQ_PAYMENT SET AUTH_STATUS ='A', AUTH_STATUS_KT ='A', CHECKER_ID ='admin', CHECKER_ID_KT ='admin' WHERE REQ_PAY_CODE ='' -- THAY SỐ PĐN THANH TOÁN

-------6.0 TRONG THỜI GIAN CHỜ CHUYỂN ĐỔI TỪ INTERNET EXPLODER LÊN CHROME. TẠM THỜI IT XỬ LÝ VIỆC PHÊ DUYỆT CẤP TGĐ THÔNG QUA SCRIPT (VÌ TGĐ KHÔNG ĐỒNG Ý SỬ DỤNG AMS TRÊN NỀN TẢNG IE)

-------------------------------------------------------------------------------------------------------------------

--SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0005/2021/TTr-89900001') -- THAY SỐ TỜ TRÌNH

--EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)

--@p_AUTH_STATUS = 'A', -- varchar(1)

--@p_CHECKER_ID = 'trungnq1', -- varchar(15)

--@p_APPROVE_DT = @DATE, -- datetime

--@p_ROLE_LOGIN = 'TGD', -- varchar(50)

--@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)

--@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)

-------7.0 TRONG THỜI GIAN CHỜ CHUYỂN ĐỔI TỪ INTERNET EXPLODER LÊN CHROME. TẠM THỜI IT XỬ LÝ VIỆC PHÊ DUYỆT CẤP HĐQT THÔNG QUA SCRIPT (VÌ TGĐ KHÔNG ĐỒNG Ý SỬ DỤNG AMS TRÊN NỀN TẢNG IE)

-------------------------------------------------------------------------------------------------------------------

--SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0005/2021/TTr-89900001') -- THAY SỐ TỜ TRÌNH

--EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)

--@p_AUTH_STATUS = 'A', -- varchar(1)

--@p_CHECKER_ID = 'taila', -- varchar(15)

--@p_APPROVE_DT = @DATE, -- datetime

--@p_ROLE_LOGIN = 'HDQT', -- varchar(50)

--@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)

--@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)

-------8.0 LẤY THÔNG TIN CHI TIẾT 1 TỜ TRÌNH CHỦ TRƯƠNG

-------------------------------------------------------------------------------------------------------------------

--SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0019/2021/TTr-0691006')

--SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID

--SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID

--SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

--SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID

--SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID

--SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID

--SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)

--SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)

--SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT GOODS_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)

--SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT FR_GOOD_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)

--SELECT * FROM CM_GOODSTYPE

------9.0 CAP NHAT NOI DUNG TO TRINH

SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0183/2021/TTr-0690604')

UPDATE PL_REQUEST_DOC SET 

REQ_NAME  =N'Chi phí xét nghiệm, lưu trú khách sạn cách ly, ăn uống, nhu yếu phẩm, đồ bảo hộ lao động, dịch vụ tư vấn chăm sóc, thuốc, phun khử khuẩn ... cho Người lao động BVB liên quan đến dịch bệnh Covid',

REQ_CONTENT =N'Chi phí xét nghiệm, lưu trú khách sạn cách ly, ăn uống, nhu yếu phẩm, đồ bảo hộ lao động, dịch vụ tư vấn chăm sóc, thuốc, phun khử khuẩn ... cho Người lao động BVB liên quan đến dịch bệnh Covid',

REQ_REASON= N'Chi phí xét nghiệm, lưu trú khách sạn cách ly, ăn uống, nhu yếu phẩm, đồ bảo hộ lao động, dịch vụ tư vấn chăm sóc, thuốc, phun khử khuẩn ... cho Người lao động BVB liên quan đến dịch bệnh Covid. (Lưu ý: Chi phí hỗ trợ cho NLĐ mắc Covid19 (F0) định mức tối đa 5 triệu đồng/người)'

WHERE REQ_ID ='PLRD00000202297'

------- 10 CAP NHAT TỜ TRÌNH VỀ LƯU NHÁP ---------------------------------------------------------

----------------------------------------------------------------------------------------------------------------------

SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0133/2021/TTr-0692103') ------ THAY SO TO TRINH CHU TRUONG

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='', AUTH_STATUS ='E', APPROVE_DT = NULL, CHECKER_ID =''  WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu cập nhật tờ trình lưu nháp',N'Cập nhật tờ trình về lưu nháp',@USER_REQUEST,GETDATE())

UPDATE PL_REQUEST_DOC_DT SET DESCRIPTION =N'Chi phí xét nghiệm Covid, chi phí hỗ trợ khách sạn, ăn uống, nhu yếu phẩm, đồ bảo hộ lao động, dịch vụ tư vấn, thuốc thang, phun khử khuẩn... cho Người lao động BVB liên quan đến dịch bệnh Covid. (Lưu ý Chi phí chăm só cho 1 ca F0 điịnh mức tối đa 5 triệu đồng/Ca)' 

WHERE REQDT_ID='PLRDD0000222463'

INSERT INTO PL_PROCESS VALUES ('PLRD00000202276','HDQT','taila',GETDATE(),N'Phê duyệt',N'Chủ Tịch Hội Đồng Quản Trị đã phê duyệt')

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_ID='PLRD00000202276'

UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID='32625'

UPDATE PL_REQUEST_PROCESS SET STATUS ='P' WHERE ID='33912'

----- END 

COMMIT TRANSACTION

SELECT 'SUCCESSFULL' RESULT

END TRY

BEGIN CATCH

    ROLLBACK TRANSACTION

    SELECT ERROR_MESSAGE() ERROR

END CATCH

SELECT * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE='NBO.2021.000605'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID='TADY00001130846'

SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID='TADY00001130846'

SELECT * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE='NBO.2021.000284'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID= (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE='NBO.2021.000284')

SELECT * FROM PL_PROCESS WHERE REQ_ID= (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE='NBO.2021.000284')

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001877')

UPDATE TR_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_ID =@REQ_ID

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='DVCM'

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='DMMS' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'

EXEC TR_REQ_DOC_Ins_To_PO @REQ_ID

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001913')

UPDATE TR_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_ID =@REQ_ID

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='DVCM'

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='DMMS', STATUS ='C' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'

EXEC TR_REQ_DOC_Ins_To_PO @REQ_ID

SELECT * FROM TR_PO_MASTER WHERE PO_CODE ='PO069/21/0215'

SELECT * FROM TR_PO_DETAIL WHERE PO_ID IN (SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO069/21/0215')

SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID IN (SELECT REQ_DOC_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO069/21/0215')

SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID ='TRRD00000252313'

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000202838','GDK_TT','U','GDK','DV0001','',NULL,'APPNEW','N','','DM0000000000015',N'Chờ GĐK Hỗ Trợ xác nhận','0','')

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000202838','PTGDK_TT','U','PTGD','DV0001','',NULL,'GDK_TT','N','','DM0000000000015',N'Chờ Phó Tổng GĐK Hỗ Trợ xác nhận','0','')

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000202838','APPROVE','U','','DV0001','',NULL,'PTGDK_TT','N','','',N'Hoàn tất','0','')

UPDATE TR_REQ_PAY_BUDGET SET AMT_APP =142929353, AMT_EXE =43964676, AMT_REMAIN = 71464677,AMT_DO =71464676 WHERE BUDG_ID='TRBG00000296648'

---20211116

SELECT BR.BRANCH_CODE,BR.BRANCH_NAME,CR_ACCT AS DAU_TAI_KHOAN, SUM(AMT) AS SO_DU

FROM

(

SELECT '313000002' AS CR_ACCT,DR_ACCT,AMT,DR_BRN  FROM MW_ENTRIES_POST WHERE DR_ACCT ='313000002' AND TRN_TYPE ='MW_IN'

UNION

SELECT '313000002' AS CR_ACCT,DR_ACCT,AMT,DR_BRN  FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000002' AND TRN_TYPE ='MW_TRANSFER'

UNION

SELECT '313000002' AS CR_ACCT,DR_ACCT,-AMT, CR_BRN AS DR_BRN FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000002' AND TRN_TYPE ='MW_OUT'

UNION

SELECT '313000002' AS CR_ACCT,DR_ACCT,AMT, DR_BRN FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000002' AND TRN_TYPE ='MW_OUT'

UNION

SELECT '313000002' AS CR_ACCT,DR_ACCT,AMT,DR_BRN FROM MW_ENTRIES_POST WHERE DR_ACCT ='313000002' AND TRN_TYPE ='MW_TRANSFER_CONF'

UNION

SELECT '313000009' AS CR_ACCT,DR_ACCT,AMT,DR_BRN  FROM MW_ENTRIES_POST WHERE DR_ACCT ='313000009' AND TRN_TYPE ='MW_IN'

UNION

SELECT '313000009' AS CR_ACCT,DR_ACCT,-AMT,CR_BRN AS DR_BRN  FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000009' AND TRN_TYPE ='MW_TRANSFER'

UNION

SELECT '313000009' AS CR_ACCT,DR_ACCT,-AMT,CR_BRN AS DR_BRN FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000009' AND TRN_TYPE ='MW_OUT'

UNION

SELECT '313000009' AS CR_ACCT,DR_ACCT,AMT, DR_BRN FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000009' AND TRN_TYPE ='MW_OUT'

UNION

SELECT '313000009' AS CR_ACCT,DR_ACCT,AMT,DR_BRN FROM MW_ENTRIES_POST WHERE DR_ACCT ='313000009' AND TRN_TYPE ='MW_TRANSFER_CONF'

) DTA

INNER JOIN CM_BRANCH BR ON DTA.DR_BRN = BR.BRANCH_ID

GROUP BY DTA.DR_BRN, DTA.CR_ACCT,BR.BRANCH_CODE,BR.BRANCH_NAME

SELECT B.REQ_CODE, B.REQ_REASON AS NOI_DUNG_MS, A.SUP_ID,C.SUP_NAME, D.HH_CODE AS MA_HANG_HOA, D.HH_NAME AS TEN_HANG_HOA, A.DESCRIPTION AS QUY_CACH_KT, A.QUANTITY AS SO_LUONG,A.PRICE_ETM AS DON_GIA_DU_KIEN, A.TOTAL_AMT_ETM AS THANH_TIEN_DU_KIEN, A.PRICE AS GIA_THUC_TE, A.TOTAL_AMT AS THANH_TIEN_THUC_TE

FROM TR_REQUEST_DOC_DT A

INNER JOIN TR_REQUEST_DOC B ON A.REQ_DOC_ID =  B.REQ_ID

INNER JOIN CM_SUPPLIER C ON A.SUP_ID = C.SUP_ID

INNER JOIN CM_HANGHOA D ON A.HANGHOA_ID = D.HH_ID

WHERE A.SUP_ID ='CMS000001126316' AND B.PROCESS_ID  ='APPROVE'

UNION

SELECT B.REQ_CODE,B.REQ_CONTENT AS NOI_DUNG_MS, A.SUP_ID,C.SUP_NAME, D.HH_CODE AS MA_HANG_HOA, D.HH_NAME AS TEN_HANG_HOA,A.DESCRIPTION AS QUY_CACH_KT, A.QUANTITY AS SO_LUONG,A.PRICE_ETM AS DON_GIA_DU_KIEN, A.EXCHANGE_RATE AS TY_GIA, A.TAXES AS THUE, A.TOTAL_AMT_ETM AS THANH_TIEN_DU_KIEN, A.PRICE AS GIA_THUC_TE, A.TOTAL_AMT AS THANH_TIEN_THUC_TE

FROM TR_REQUEST_DOC_DT A

INNER JOIN TR_REQUEST_DOC B ON A.REQ_DOC_ID =  B.REQ_ID

INNER JOIN CM_SUPPLIER C ON A.SUP_ID = C.SUP_ID

INNER JOIN CM_HANGHOA D ON A.HANGHOA_ID = D.HH_ID

WHERE A.SUP_ID IN ('CMS000000251972','CMS000000252261','CMS000001126280','CMS000000252205','CMS000001126240') AND B.PROCESS_ID  ='APPROVE'

---20211116

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE='NBO.2021.000605')

EXEC TR_REQ_ADVANCE_PAYMENT_Appr @REQ_ID,'trungnq1','A','' ---20211117

UPDATE TR_REQ_PAYMENT SET MAKER_ID ='trangtm' WHERE AUTH_STATUS_KT <> 'A' AND MAKER_ID ='thaottp6'

SELECT B.LIQ_ID AS ID, D.BRANCH_CODE AS DON_VI_TAO, B.MAKER_ID AS NGUOI_TAO, B.MAKER_ID_KT AS GDV, B.CHECKER_ID_KT AS KSV, B.BUY_COMPANY_ID AS CONGTY_THU_MUA, C.ASSET_CODE, DVSD.BRANCH_CODE AS DV_QUANLY_TS,

DVSD.BRANCH_NAME TEN_DV, DEP.DEP_CODE AS PB_QL_TAISAN, DEP.DEP_NAME AS TEN_PB,

C.AMORT_MONTH AS SO_THANG_KH, C.AMORTIZED_MONTH AS SO_THANG_DA_KH,C.AMORT_AMT AS GIA_TRI_KHAU_HAO, C.AMORTIZED_AMT AS GIA_TRI_DA_KHAU_HAO, C.AMORT_STATUS AS TINH_TRANG_KHAU_HAO,A.BUY_PRICE AS NGUYEN_GIA, A.REMAIN_VALUE AS GT_CL,

A.BUY_PRICE_LIQ AS NGUYEN_GIA_THANH_LY ,A.LIQ_PRICE AS SO_TIEN_THANH_LY, CASE WHEN A.LIQ_TYPE ='1' THEN N'Toàn phần' ELSE N'Một phần' END AS HINH_THUC_TL,

CASE WHEN B.AUTH_STATUS ='A' THEN N'TDV phê duyệt' ELSE N'TDV chưa phê duyệt' END AS TINH_TRANG_DUYET_DV,

CASE WHEN B.AUTH_STATUS_KT ='A' THEN N'KSV phê duyệt' ELSE N'KSV chưa phê duyệt' END AS TINH_TRANG_DUYET_KT

FROM ASS_LIQUIDATION_DT A

INNER JOIN ASS_LIQUIDATION B ON A.LIQ_ID = B.LIQ_ID

INNER JOIN ASS_MASTER C ON A.ASSET_ID = C.ASSET_ID

INNER JOIN CM_BRANCH D ON B.BRANCH_ID = D.BRANCH_ID

LEFT JOIN CM_BRANCH DVSD ON C.BRANCH_ID = DVSD.BRANCH_ID

LEFT JOIN CM_DEPARTMENT DEP ON C.DEPT_ID = DEP.DEP_ID

SELECT * FROM SYS_GROUP_LIMIT_DT WHERE GROUP_LM_ID ='SGL000000000102'

UPDATE SYS_GROUP_LIMIT_DT SET VALUE_LIMIT =500000000 WHERE GROUD_LM_DTID ='SGLDT0000000073'

UPDATE SYS_GROUP_LIMIT_DT SET VALUE_LIMIT =300000000 WHERE GROUD_LM_DTID ='SGLDT0000000093'

UPDATE SYS_GROUP_LIMIT_DT SET VALUE_LIMIT =250000000 WHERE GROUD_LM_DTID ='SGLDT0000000097'

UPDATE SYS_GROUP_LIMIT_DT SET VALUE_LIMIT =150000000 WHERE GROUD_LM_DTID ='SGLDT0000000098'

---ADDNEW NHOM HAN MUC PHE DUYET

INSERT INTO SYS_GROUP_LIMIT VALUES ('SGL000000000102','II.10',N'Chi phí tiêu hủy ấn chỉ/ấn phẩm/vật phẩm quảng cáo',0,'TTCT')

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000560','SGL000000000102','PTGD',500000000,NULL,NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000561','SGL000000000102','GDK',200000000,NULL,NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000562','SGL000000000102','GDDV',-1,'DV0001',NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000563','SGL000000000102','GDDV',-1,NULL,NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000564','SGL000000000102','TGD',2000000000,NULL,NULL)

SELECT A.HH_CODE, A.HH_NAME, B.HH_TYPE_NAME AS LOAI_HANG_HOA, LM.GROUP_CODE AS N'MÃ NHÓM CĐT', LM.GROUP_DES AS N'TÊN NHÓM CĐT' FROM CM_HANGHOA A

LEFT JOIN CM_HANGHOA_TYPE B ON A.HH_TYPE_ID = B.HH_TYPE_ID 

LEFT JOIN SYS_HH_GROUP_LIMIT DT ON A.HH_ID = DT.HH_ID

LEFT JOIN SYS_GROUP_LIMIT LM ON DT.GROUP_LIMIT_ID = LM.GROUP_ID

WHERE LM.TYPE ='CDT'

ORDER BY LM.GROUP_CODE, LM.TYPE

SELECT A.HH_CODE, A.HH_NAME, B.HH_TYPE_NAME AS LOAI_HANG_HOA, LM.GROUP_CODE AS N'MÃ NHÓM HẠN MỨC', LM.GROUP_DES AS N'TÊN NHÓM HẠN MỨC' FROM CM_HANGHOA A

LEFT JOIN CM_HANGHOA_TYPE B ON A.HH_TYPE_ID = B.HH_TYPE_ID 

LEFT JOIN SYS_HH_GROUP_LIMIT DT ON A.HH_ID = DT.HH_ID

LEFT JOIN SYS_GROUP_LIMIT LM ON DT.GROUP_LIMIT_ID = LM.GROUP_ID

WHERE LM.TYPE ='TTCT'

ORDER BY LM.GROUP_CODE, LM.TYPE

---ADDNEW NHOM HAN MUC PHE DUYET

INSERT INTO SYS_GROUP_LIMIT VALUES ('SGL000000000105','I.3.1.a',N'Mua sắm TSCĐ - CCLD',0,'TTCT')

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000570','SGL000000000105','PTGD',5000000000,NULL,NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000571','SGL000000000105','GDK',3000000000,NULL,NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000572','SGL000000000105','GDDV',-1,'DV0001',NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000573','SGL000000000105','GDDV',-1,NULL,NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000574','SGL000000000105','TGD',6000000000,NULL,NULL)

INSERT INTO SYS_GROUP_LIMIT VALUES ('SGL000000000106','I.3.1.b',N'Mua sắm hàng hóa - dịch vụ khác',0,'TTCT')

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000575','SGL000000000106','PTGD',5000000000,NULL,NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000576','SGL000000000106','GDK',3000000000,NULL,NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000577','SGL000000000106','GDDV',-1,'DV0001',NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000578','SGL000000000106','GDDV',-1,NULL,NULL)

INSERT INTO SYS_GROUP_LIMIT_DT VALUES ('SGLDT0000000579','SGL000000000106','TGD',6000000000,NULL,NULL)

---20211123

UPDATE SYS_HH_GROUP_LIMIT SET GROUP_LIMIT_ID ='SGL000000000105' WHERE GROUP_LIMIT_ID ='SGL000000000009'

UPDATE SYS_GROUP_LIMIT_DT SET VALUE_LIMIT=2000000000 WHERE GROUD_LM_DTID ='SGLDT0000000575'

UPDATE SYS_GROUP_LIMIT_DT SET VALUE_LIMIT=1000000000 WHERE GROUD_LM_DTID ='SGLDT0000000576'

UPDATE SYS_GROUP_LIMIT_DT SET VALUE_LIMIT=5000000000 WHERE GROUD_LM_DTID ='SGLDT0000000579'

DECLARE @ASSET_ID VARCHAR(15)

SET @ASSET_ID =(SELECT ASSET_ID FROM ASS_MASTER WHERE ASSET_CODE ='CMK002001561')

SELECT * FROM ASS_MASTER WHERE ASSET_CODE ='CMK002001561'

SELECT * FROM ASS_VALUES WHERE ASSET_ID =@ASSET_ID

SELECT * FROM ASS_AMORT_DT WHERE ASSET_ID =@ASSET_ID

SELECT * FROM ASS_ENTRIES_POST WHERE ASSET_ID =@ASSET_ID

SELECT * FROM ASS_TRANSACTIONS WHERE ASSET_ID =@ASSET_ID

SELECT * FROM ASS_ADDNEW WHERE ADDNEW_ID IN (SELECT TRN_ID FROM ASS_TRANSACTIONS WHERE ASSET_ID =@ASSET_ID)

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000087'

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000088'

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000089'

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000090'

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000091'

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000091'

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000092'

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000093'

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000094'

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000095'

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000097'

DELETE FROM SYS_GROUP_LIMIT WHERE GROUP_ID ='SGL000000000017'

UPDATE SYS_GROUP_LIMIT SET GROUP_CODE ='I.3.1.A' WHERE GROUP_ID ='SGL000000000105'

UPDATE SYS_GROUP_LIMIT SET GROUP_CODE ='I.3.1.B' WHERE GROUP_ID ='SGL000000000106'

---20211123

UPDATE SYS_HH_GROUP_LIMIT

SET GROUP_LIMIT_ID ='SGL000000000104'

WHERE HH_ID IN

(

SELECT HH_ID FROM CM_HANGHOA 

WHERE HH_CODE IN ('HCQT-003-000009','THQHCC-001-000012','THQHCC-001-000001','THQHCC-001-000005','THQHCC-001-000007','THQHCC-001-000008','THQHCC-001-000009','THQHCC-001-999999','THQHCC-003-000002','THQHCC-003-000003','THQHCC-003-000004','THQHCC-003-000007','THQHCC-003-000008','THQHCC-003-000009','SPMKT-001-000002','SPMKT-001-000003','SPMKT-001-999999','SPMKT-001-000006','SPMKT-001-000004','SPMKT-001-000005','THQHCC-003-000010','THQHCC-003-000011','THQHCC-003-000012','THQHCC-001-000010','THQHCC-001-000011','SPMKT-001-000001','HCQT-002-000036','CNTT-001-000001','XDPTML-002-000002','HCQT-001-000044','DVPL-003-000001','CNTT-001-000002','CNTT-002-000001','CNTT-003-000002','CNTT-003-000003','CNTT-012-000001','TTT-001-000002','CNTT-010-000010','CNTT-010-000011','HCQT-002-000035','HCQT-002-000037','HCQT-002-000038','HCQT-002-000039','HCQT-002-000040','HCQT-002-000041','HCQT-002-000042','HCQT-002-000043','HCQT-003-000031','HCQT-003-000032','HCQT-003-000033','HCQT-003-000034','THQHCC-002-000006','HCQT-001-000047','XDPTML-002-000007','XDPTML-002-000008','XDPTML-002-000009','XDPTML-002-000010','XDPTML-002-000011','XDPTML-002-000012','XDPTML-002-000013','CNTT-011-000001','CNTT-004-000003','CNTT-004-000004','HCQT-003-000039','HCQT-003-000040','HCQT-004-000019','CNTT-006-000012','CNTT-006-000013','XDPTML-005-000001','XDPTML-005-000002','HCQT-003-000035','HCQT-003-000037','HCQT-003-000038','CNTT-003-000004','CNTT-004-000001','CNTT-004-000002','CNTT-005-000001','CNTT-005-000002','CNTT-006-000001','CNTT-006-000002','CNTT-006-000003','CNTT-006-000004','CNTT-006-000005','CNTT-006-000006','CNTT-006-000007','CNTT-006-000008','CNTT-006-000009','CNTT-006-000010','CNTT-006-000011','CNTT-006-999999','CNTT-007-000001','CNTT-007-000002','CNTT-007-000003','CNTT-007-000004','CNTT-008-000001','CNTT-008-000002','CNTT-009-000001','CNTT-010-000001','CNTT-010-000002','CNTT-010-000003','CNTT-010-000004','CNTT-010-000005','CNTT-010-000006','CNTT-010-000007','CNTT-010-000008','CNTT-010-999999','XDPTML-001-000001','XDPTML-001-000002','XDPTML-001-000003','XDPTML-001-000004','XDPTML-001-999999','XDPTML-002-000001','XDPTML-002-000003','XDPTML-002-000004','XDPTML-002-000005','XDPTML-002-000006','XDPTML-003-000001','XDPTML-003-000002','XDPTML-003-000003','XDPTML-003-999999','XDPTML-004-000001','XDPTML-004-000003','HCQT-001-000001','HCQT-001-000002','HCQT-001-000003','HCQT-001-000004','HCQT-001-000005','HCQT-001-000006','HCQT-001-000007','HCQT-001-000008','HCQT-001-000009','HCQT-001-000010','HCQT-001-000011','HCQT-001-000012','HCQT-001-000013','HCQT-001-000014','HCQT-001-000015','HCQT-001-000016','HCQT-001-000017','HCQT-001-000018','HCQT-001-000019','HCQT-001-000020','HCQT-001-000021','HCQT-001-000022','HCQT-001-000023','HCQT-001-000024','HCQT-001-000025','HCQT-001-000026','HCQT-001-000027','HCQT-001-000028','HCQT-001-000029','HCQT-001-000030','HCQT-001-000031','HCQT-001-000032','HCQT-001-000033','HCQT-001-000034','HCQT-001-000035','HCQT-001-000036','HCQT-001-000037','HCQT-001-000038','HCQT-001-000039','HCQT-001-000040','HCQT-001-000041','HCQT-001-000042','HCQT-001-000043','HCQT-001-000045','HCQT-001-000046','HCQT-001-999999','HCQT-002-000001','HCQT-002-000002','HCQT-002-000003','HCQT-002-000004','HCQT-002-000005','HCQT-002-000007','HCQT-002-000008','HCQT-002-000009','HCQT-002-000010','HCQT-002-000011','HCQT-002-000012','HCQT-002-000013','HCQT-002-000014','HCQT-002-000015','HCQT-002-000016','HCQT-002-000017','HCQT-002-000018','HCQT-002-000019','HCQT-002-000020','HCQT-002-000021','HCQT-002-000022','HCQT-002-000023','HCQT-002-000024','HCQT-002-000025','HCQT-002-000026','HCQT-002-000027','HCQT-002-000028','HCQT-002-000029','HCQT-002-000030','HCQT-002-000031','HCQT-002-000032','HCQT-002-000033','HCQT-002-000034','HCQT-002-999999','HCQT-003-000010','HCQT-003-000011','HCQT-003-000012','HCQT-003-000013','HCQT-003-000014','HCQT-003-000015','HCQT-003-000016','HCQT-003-000017','HCQT-003-000018','HCQT-003-000019','HCQT-003-000020','HCQT-003-000021','HCQT-003-000022','HCQT-003-000024','HCQT-003-000025','HCQT-003-000027','HCQT-003-000028','HCQT-003-000029','HCQT-003-000030','HCQT-003-999999','HCQT-004-000001','HCQT-004-000002','HCQT-004-000003','HCQT-004-000004','HCQT-004-000005','HCQT-004-000006','HCQT-004-000007','HCQT-004-000008','HCQT-004-000009','HCQT-004-000010','HCQT-004-000011','HCQT-004-000012','HCQT-004-000013','HCQT-004-000014','HCQT-004-000015','HCQT-004-000016','HCQT-004-000017','HCQT-004-000018','HCQT-004-999999','DVNS-001-000002','DVNS-001-000003','DVNS-001-999999','DVNS-002-000003','DVKT-001-000001','DVKT-001-000002','DVKT-001-000003','DVKT-001-000004','DVKT-001-000005','DVKT-001-999999','DVKT-002-000001','DVKT-002-000002','DVKT-002-000003','DVKT-002-999999','DVKT-003-000001','DVKT-003-000002','DVKT-003-999999','DVPL-001-000001','DVPL-001-000002','DVPL-001-000003','DVPL-001-000004','DVPL-001-000005','DVPL-001-999999','DVPL-002-000001','DVPL-002-000002','DVPL-002-999999','DVPL-003-000002','DVPL-003-999999','THQHCC-002-000001','THQHCC-002-000003','THQHCC-002-000005','THQHCC-002-999999','THQHCC-003-000001','THQHCC-003-000005','THQHCC-003-000006','SPMKT-002-000001','SPMKT-002-000002','SPMKT-002-999999','SPMKT-003-000001','SPMKT-003-000002','SPMKT-003-999999','TTT-001-000001','TTT-001-000003','TTT-001-000004','TTT-002-000001','TTT-002-000002','TTT-002-000003','TTT-002-999999','TTT-003-000004','TTT-003-000005','TTT-003-999999','HCQT-001-000048','HCQT-003-000041','HCQT-003-000042','HCQT-003-000043','CNTT-006-000014','CNTT-010-000009','CNTT-011-000002','CNTT-011-000003','CNTT-011-000004','CNTT-011-000005','CNTT-011-000006','TTT-002-000004','TTT-003-000001','HCQT-003-000002','HCQT-003-000003','HCQT-003-000004','HCQT-003-000006','THQHCC-002-000002','THQHCC-002-000004','CNTT-006-000015','CNTT-005-000003','DVPL-002-000003','TTT-001-000006','TTT-001-000007','HCQT-003-000044','HCQT-002-000045','HCQT-001-000049','HCQT-002-000006','CNTT -010-000012','HCQT-001-000050','HCQT-003-000046','TTT-003-000002','HCQT-003-000047','CNTT-010-000013','SPMKT-003-000003','HCQT-002-000046','HCQT-002-000047'))

AND TYPE_LIMIT='CDT'

---20211125

EXEC dbo.sp_generate_inserts @table_name = 'SYS_HH_GROUP_LIMIT', -- varchar(776)

@from = 'FROM SYS_HH_GROUP_LIMIT' -- varchar(800)

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001054')

SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID

SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@REQ_ID

SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID =@REQ_ID

SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

SELECT * FROM CM_HANGHOA WHERE HH_CODE IN ('HCQT-003-000020','HCQT-003-000021','DVNS-001-000002','HCQT-003-000034','HCQT-003-000044','HCQT-003-000046','HCQT-002-000046','HCQT-002-000036')

SELECT * FROM SYS_HH_GROUP_LIMIT WHERE

HH_ID IN (SELECT HH_ID FROM CM_HANGHOA WHERE HH_CODE IN ('HCQT-003-000020','HCQT-003-000021','DVNS-001-000002','HCQT-003-000034','HCQT-003-000044','HCQT-003-000046','HCQT-002-000046','HCQT-002-000036'))

AND TYPE_LIMIT ='TTCT'

UPDATE SYS_HH_GROUP_LIMIT SET GROUP_LIMIT_ID ='SGL000000000105' WHERE HH_ID IN (SELECT HH_ID FROM CM_HANGHOA WHERE HH_CODE IN ('HCQT-001-000026','HCQT-001-000027','HCQT-001-000047'))

AND TYPE_LIMIT ='TTCT'

UPDATE SYS_HH_GROUP_LIMIT SET GROUP_LIMIT_ID ='SGL000000000106' WHERE HH_ID IN (SELECT HH_ID FROM CM_HANGHOA WHERE HH_CODE IN ('HCQT-003-000020','HCQT-003-000021','DVNS-001-000002','HCQT-003-000034','HCQT-003-000044','HCQT-003-000046','HCQT-002-000046','HCQT-002-000036'))

AND TYPE_LIMIT ='TTCT'

UPDATE TR_REQUEST_DOC_DT SET PRICE = 1832608015, TOTAL_AMT =1832608015 WHERE REQDT_ID='TRRDD0000260414'

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES ('TRRD00000253112','IT',N'Yêu cầu cập nhật đơn giá',N'Hỗ trợ cập nhật đơn giá giảm 400 VND theo yêu cầu','tuyenlt',GETDATE())

UPDATE TR_REQUEST_DOC SET REQ_DT ='22/10/2021' WHERE REQ_CODE ='PUR/2021/001761'

SELECT * FROM PL_REQUEST_DOC

WHERE REQ_ID IN 

(

SELECT B.REQ_ID FROM PL_REQUEST_DOC_DT B

INNER JOIN PL_TRADEDETAIL C ON B.TRADE_ID = B.TRADE_ID

INNER JOIN PL_MASTER D ON C.PLAN_ID = D.PLAN_ID

WHERE D.YEAR =2022

)

DECLARE @PO_ID VARCHAR(15)

SET @PO_ID =(SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO073/21/0002')

EXEC TR_REQ_GOOD_BYCONTRACT @PO_ID

---20211210

DECLARE @PO_ID VARCHAR(15)

SET @PO_ID =(SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO073/21/0002')

EXEC TR_REQ_GOOD_BYCONTRACT @PO_ID

---20211210

SELECT * FROM TR_PO_MASTER WHERE PO_ID =@PO_ID

SELECT * FROM TR_PO_DETAIL WHERE PO_ID =@PO_ID

SET @PO_ID =(SELECT REQ_DOC_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO073/21/0002')

SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID

SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@PO_ID

SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =(SELECT PL_REQ_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)

EXEC dbo.sp_generate_inserts @table_name = 'TR_REQUEST_DOC_DT', -- varchar(776)

@from = 'FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =''TRRD00000252757''' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_PO_MASTER', -- varchar(776)

@from = 'FROM TR_PO_MASTER WHERE PO_ID =''TRPM00000252452''' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_PO_DETAIL', -- varchar(776)

@from = 'FROM TR_PO_DETAIL WHERE PO_ID =''TRPM00000252452''' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_DOC_DT', -- varchar(776)

@from = 'FROM PL_REQUEST_DOC_DT WHERE REQ_ID =''PLRD00000201490''' -- varchar(800)

---2021129

DECLARE @REQ_ID VARCHAR(15), @USER_REQUEST VARCHAR(15), @DATE DATETIME

SET @USER_REQUEST='phuongvn' ---- THAY USER DOMAIN YÊU CẦU HỖ TRỢ

SET @DATE= GETDATE() --- THAY NĂM - THÁNG - NGÀY

SET @REQ_ID=(SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO069/21/0326') ------ THAY SO TO TRINH CHU TRUONG

--UPDATE PL_REQUEST_DOC SET IS_CHECKALL='1'  WHERE REQ_ID =@REQ_ID

INSERT INTO dbo.PL_PROCESS

	(

						REQ_ID,

						PROCESS_ID,

						CHECKER_ID,

						APPROVE_DT,

						PROCESS_DESC,NOTES

					)

					VALUES

					(   @REQ_ID,        -- REQ_ID - varchar(15)

						'SEND',        -- PROCESS_ID - varchar(10)

						'phuongvn',        -- CHECKER_ID - varchar(15)

						GETDATE(), -- APPROVE_DT - datetime

					   N'Nhân viên gửi phê duyệt phiếu thành công' ,N'Gửi phê duyệt')

EXEC TR_PO_MASTER_App @REQ_ID,'A','vanpt2','14/12/2021'

----20211214

UPDATE TR_REQUEST_DOC_DT SET PRICE_ETM=2100000, TOTAL_AMT_ETM = PRICE_ETM * QUANTITY WHERE REQDT_ID ='TRRDD0000261927'

UPDATE TR_REQUEST_DOC_DT SET PRICE_ETM=1340000, TOTAL_AMT_ETM = PRICE_ETM * QUANTITY WHERE REQDT_ID ='TRRDD0000261926'

UPDATE TR_REQUEST_DOC_DT SET PRICE_ETM=1300000, TOTAL_AMT_ETM = PRICE_ETM * QUANTITY WHERE REQDT_ID ='TRRDD0000261925'

DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001062')

SET @DATE='2021-06-25 12:00:00 AM'

UPDATE PL_PROCESS SET APPROVE_DT=@DATE WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày PYCMS',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu','quanvta',GETDATE())

UPDATE PL_REQUEST_DOC_DT SET UNIT_NAME =N'Cái' WHERE REQDT_ID ='PLRDD0000229261'

---20211215

DECLARE @l_TRADE_ID VARCHAR(15)

EXEC SYS_CodeMasters_Gen 'PL_TRADEDETAIL', @l_TRADE_ID OUT

INSERT INTO dbo.PL_TRADEDETAIL

										(

											TRADE_ID,PLAN_ID,GOODS_ID,QUANTITY,AMT_APP,NOTES,RECORD_STATUS,

											MAKER_ID,CREATE_DT,AUTH_STATUS,CHECKER_ID,APPROVE_DT,AMT_ETM, AMT_EXE, AMT_RECEIVE_TF, AMT_TF, QUANTITY_ETM, QUANTITY_EXE

										)

										VALUES

										(   @l_TRADE_ID,        -- TRADE_ID - varchar(15)

											'PLM000000255684',        -- PLAN_ID - varchar(15)

											'GOO000000252769',        -- GOODS_ID - varchar(15)

											0,      -- QUANTITY - decimal(18, 0)

											0,      -- PRICE - decimal(18, 0)			  

											'',       -- NOTES - nvarchar(1000)

											'1',        -- RECORD_STATUS - varchar(1)

											'tridq',        -- MAKER_ID - varchar(12)

											GETDATE(), -- CREATE_DT - datetime

											'A',        -- AUTH_STATUS - varchar(50)

											'tridq',        -- CHECKER_ID - varchar(12)

											GETDATE(), -- APPROVE_DT - datetime

											0,0,0,0,0,0

										)	

UPDATE dbo.PL_REQUEST_DOC_DT SET TRADE_ID=@l_TRADE_ID,PLAN_ID='PLM000000255684' WHERE 

REQ_ID='PLRD00000203041' AND GOODS_ID='GOO000000252769' AND (TRADE_ID IS NULL OR TRADE_ID='')

UPDATE dbo.PL_REQUEST_TRANSFER SET TO_TRADE_ID=@l_TRADE_ID,TO_PLAN_ID='PLM000000255684' 

WHERE REQ_DOC_ID='PLRD00000203041' AND TO_GOOD_ID='GOO000000252769' AND (TO_TRADE_ID IS NULL OR TO_TRADE_ID='')

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO074/21/0004')

UPDATE TR_PO_MASTER SET MAKER_ID ='cuongvd', BRANCH_ID ='DV0001' WHERE PO_CODE ='PO074/21/0004'

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu chuyển PO về Hội Sở',N'Chuyển PO về Hội Sở','cuongvd',GETDATE())

---- CẬP NHẬT BẢNG TR_REQUEST_DOC_DT: CHI TIẾT HÀNG HÓA MUA SẮM THỰC TẾ

UPDATE TR_REQUEST_DOC_DT SET DESCRIPTION =N'Mực Wax resin 110mmx300m' WHERE REQDT_ID ='TRRDD0000265371'

UPDATE TR_REQUEST_DOC_DT SET DESCRIPTION =N'Giấy Decal xi bạc 105mmx50m' WHERE REQDT_ID ='TRRDD0000265372'

UPDATE TR_REQUEST_DOC_DT SET DESCRIPTION =N'SSD WDS250G2B0B 250GB' WHERE REQDT_ID ='TRRDD0000265373'

---- CẬP NHẬT BẢNG TR_REQUEST_DOC_PL_DT : CHI TIẾT HÀNG HÓA TRONG LƯỚI TỜ TRÌNH ĐÍNH KÈM BÊN PYCMS

UPDATE TR_REQUEST_DOC_PL_DT SET DES_GOOD =N'Mực Wax resin 110mmx300m, ' WHERE REQPL_DT_ID ='TRPLD0000010481'

UPDATE TR_REQUEST_DOC_PL_DT SET DES_GOOD =N'Giấy Decal xi bạc 105mmx50m' WHERE REQPL_DT_ID ='TRPLD0000010482'

UPDATE TR_REQUEST_DOC_PL_DT SET DES_GOOD =N'SSD WDS250G2B0B 250GB' WHERE REQPL_DT_ID ='TRPLD0000010483'

---- CẬP NHẬT BẢNG PL_REQUEST_DOC_DT : CHI TIẾT HÀNG HÓA TRONG TỜ TRÌNH GỐC

UPDATE PL_REQUEST_DOC_DT SET DESCRIPTION =N'Mực Wax resin 110mmx300m' WHERE REQDT_ID ='PLRDD0000228743'

UPDATE PL_REQUEST_DOC_DT SET DESCRIPTION =N'Giấy Decal xi bạc 105mmx50m' WHERE REQDT_ID ='PLRDD0000228744'

UPDATE PL_REQUEST_DOC_DT SET DESCRIPTION =N'SSD WDS250G2B0B 250GB' WHERE REQDT_ID ='PLRDD0000228745'

---20211215

DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/002248')

SET @DATE='2021-12-12 12:00:00 AM'

UPDATE PL_PROCESS SET APPROVE_DT=@DATE WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày PYCMS',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu','tuoivt',GETDATE())

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000030')

SET @DATE='2021-01-25 12:00:00 AM'

UPDATE PL_PROCESS SET APPROVE_DT=@DATE WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày PYCMS',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu','phuongvn',GETDATE())

UPDATE TR_REQUEST_DOC SET DMMS_ID ='DMMS00000000170' WHERE REQ_CODE ='PUR/2021/002296'

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/002296')

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DMMS00000000170' WHERE PROCESS_ID ='DMMS' AND REQ_ID =@REQ_ID

---20211215

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE ='NBO.2021.000328')

SELECT * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =@REQ_ID

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='072021/0001009')

SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='072021/0001009'

SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='072021/0001009')

SELECT * FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID=@REQ_ID

SELECT * FROM TR_PO_MASTER WHERE PO_ID IN (SELECT REF_ID FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID=@REQ_ID)

SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID IN (SELECT REQ_DOC_ID FROM TR_PO_MASTER WHERE PO_ID IN (SELECT REF_ID FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID=@REQ_ID))

---20211220

UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000029' WHERE REQ_ID='TRRD00000254448'

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000029' WHERE REQ_ID='TRRD00000254448' AND PROCESS_ID ='DMMS'

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/002389')

UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000029' WHERE REQ_ID=@REQ_ID

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000029' WHERE REQ_ID=@REQ_ID AND PROCESS_ID ='DMMS'

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001975')

UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000029' WHERE REQ_ID=@REQ_ID

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000029' WHERE REQ_ID=@REQ_ID AND PROCESS_ID ='DMMS'

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/002040')

UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000029' WHERE REQ_ID=@REQ_ID

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000029' WHERE REQ_ID=@REQ_ID AND PROCESS_ID ='DMMS'

--UPDATE PL_REQUEST_DOC_DT SET DESCRIPTION =N'Chi phí sảnh (teabreak + thức ăn, nước uống) - 250 khách' WHERE REQDT_ID ='PLRDD0000227570'

--UPDATE PL_REQUEST_DOC_DT SET DESCRIPTION =N'Chi phí tổ chức' WHERE REQDT_ID ='PLRDD0000227571'

--UPDATE PL_REQUEST_DOC_DT SET DESCRIPTION =N'Chi phí dựng clip mở màn' WHERE REQDT_ID ='PLRDD0000227572'

--UPDATE PL_REQUEST_DOC_DT SET DESCRIPTION =N'Chi phí dựng clip vinh danh' WHERE REQDT_ID ='PLRDD0000227573'

--UPDATE PL_REQUEST_DOC_DT SET DESCRIPTION =N'Chi phí quay phim, chụp hình' WHERE REQDT_ID ='PLRDD0000227574'

--UPDATE PL_REQUEST_DOC_DT SET DESCRIPTION =N'Chi phí dự phòng' WHERE REQDT_ID ='PLRDD0000227575'

--UPDATE PL_REQUEST_DOC_DT SET DESCRIPTION =N'' WHERE REQDT_ID ='PLRDD000022757

SELECT * FROM CM_DVDM where DVDM_CODE ='7990000'

select * from CM_DVDM_KHOI

INSERT INTO CM_DVDM VALUES ('DM0000000000080','7990000',N'Trung Tâm Quản Lý Và Thu Hồi Nợ',N'Trung Tâm Quản Lý Và Thu Hồi Nợ',

'1','A','tscd_hoiso',GETDATE(),'tscd_hoiso',GETDATE(),'tscd_hoiso',GETDATE(),1,0,1,0,0)

INSERT INTO CM_DVDM_KHOI VALUES ('DM0000000000080','DM0000000000014')

SELECT * FROM PL_COSTCENTER WHERE COST_CODE ='7990000'

UPDATE PL_COSTCENTER SET DVDM_ID ='DM0000000000080' WHERE COST_ID ='PLCC00000002005'

SELECT * FROM PL_COSTCENTER_DT WHERE COST_ID ='PLCC00000002005'

IF(NOT EXISTS(SELECT * FROM PL_COSTCENTER WHERE COST_CODE ='7990000'))

BEGIN

INSERT INTO [PL_COSTCENTER] ([COST_ID],[COST_CODE],[PLAN_TYPE_ID],[COST_NAME],[NOTES],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[EDITER_ID],[EDIT_DT],[CHECKER_ID],[APPROVE_DT],[DVDM_ID])VALUES(N'PLCC00000002005',N'7990000',N'PLTYPE000000004',N'Trung tâm quản lý và thu hồi nợ',N'Trung tâm quản lý và thu hồi nợ',N'1',N'U',N'baotq',N'Dec 22 2021  1:23PM',N'',NULL,NULL,NULL,N'DM0000000000080')

--EXEC dbo.sp_generate_inserts @table_name = 'PL_COSTCENTER', -- varchar(776)

--@from = 'FROM PL_COSTCENTER WHERE COST_ID =''PLCC00000002005''' -- varchar(800)

--EXEC dbo.sp_generate_inserts @table_name = 'PL_COSTCENTER_DT', -- varchar(776)

--@from = 'FROM PL_COSTCENTER_DT WHERE COST_ID =''PLCC00000002005''' -- varchar(800)

INSERT INTO [PL_COSTCENTER_DT] ([COSTDT_ID],[COST_ID],[BRANCH_ID],[DEP_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT])VALUES(N'PCDT00000002019',N'PLCC00000002005',N'DV0001',N'DEP000000252207',N'Trung tâm quản lý và thu hồi nợ',N'1',N'baotq',N'Dec 22 2021  1:23PM')

END

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/002159')

UPDATE TR_REQUEST_DOC SET PROCESS_ID ='', AUTH_STATUS ='E' WHERE REQ_ID =@REQ_ID

UPDATE PL_REQUEST_PROCESS SET STATUS ='E' WHERE REQ_ID =@REQ_ID

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/002149')

UPDATE TR_REQUEST_DOC SET PROCESS_ID ='', AUTH_STATUS ='E' WHERE REQ_ID =@REQ_ID

UPDATE PL_REQUEST_PROCESS SET STATUS ='E' WHERE REQ_ID =@REQ_ID

DECLARE @PAY_ID VARCHAR(15)

SET @PAY_ID=(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='122021/001829')

UPDATE TR_REQ_PAYMENT SET AUTH_STATUS ='A', AUTH_STATUS_KT ='A' WHERE REQ_PAY_CODE ='122021/001829'

UPDATE TR_REQ_PAY_SCHEDULE SET AUTH_STATUS_KT ='A' WHERE REQ_PAY_ID =@PAY_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@PAY_ID,'IT',N'Yêu cầu cập nhật hoàn tất',N'Hỗ trợ cập nhật hoàn tất PĐN thanh toán import cũ theo yêu cầu','cuongvd',GETDATE())

SELECT B.PO_CODE,B.PO_NAME, C.AUTH_STATUS_NAME AS TINH_TRANG_DUYET_PO, B.CREATE_DT AS NGAY_TAO, 

D.REQ_CODE AS SO_PYCMS, D.TOTAL_AMT AS GIA_TRI_PYCMS, E.REQ_CODE AS SO_TTCT, E.TOTAL_AMT AS GIA_TRI_CHU_TRUONG,

B.TOTAL_AMT AS GIA_TRI_PO,A.PAY_PHASE AS DOT_THANH_TOAN, A.TOTAL_AMT AS GIA_TRI_DOT_THANH_TOAN, PAY.SO_TIEN AS DA_THANH_TOAN,

A.TOTAL_AMT - PAY.SO_TIEN AS SO_TIEN_CL FROM TR_PO_PAYMENT A

INNER JOIN TR_PO_MASTER B ON A.PO_ID = B.PO_ID

LEFT JOIN CM_AUTH_STATUS C ON C.AUTH_STATUS = A.AUTH_STATUS

LEFT JOIN TR_REQUEST_DOC D ON B.REQ_DOC_ID = D.REQ_ID

LEFT JOIN PL_REQUEST_DOC E ON D.PL_REQ_ID = E.REQ_ID

LEFT JOIN

(

SELECT PAY_ID, SUM(AMT_PAY_REAL) AS SO_TIEN FROM TR_REQ_PAY_SCHEDULE

WHERE TRN_TYPE ='PAY' AND AUTH_STATUS_KT ='A'

GROUP BY PAY_ID

) PAY ON A.PAY_ID = PAY.PAY_ID

WHERE B.REQ_DOC_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE USER_DVMS ='phuongvn')

DECLARE @GD_CODE VARCHAR(50), @BRANCH_CODE VARCHAR(15), @DEP_CODE VARCHAR( 15), @BRANCH_ID VARCHAR(15), @DEP_ID VARCHAR( 15)

SET @BRANCH_CODE='069' -- NHAP DON VI CHIU CHI PHI

SET @DEP_ID ='0690000' -- NHAP PHONG BAN CHIU CHI PHI

SET @BRANCH_ID =(SELECT BRANCH_ID FROM CM_BRANCH WHERE BRANCH_CODE =@BRANCH_CODE)

SET @DEP_ID =(SELECT DEP_CODE FROM CM_DEPARTMENT WHERE DEP_CODE =@DEP_CODE)

SET @GD_CODE ='AD.I.N.OE.0035.2022' -- MA NGAN SACH

SELECT GD_ID FROM CM_GOODS WHERE GD_CODE =@GD_CODE

SELECT * FROM PL_TRADEDETAIL WHERE GOODS_ID =(SELECT GD_ID FROM CM_GOODS WHERE GD_CODE =@GD_CODE)

SELECT * FROM PL_MASTER WHERE 

BRANCH_ID ='DV0001' AND 

PLAN_ID IN (SELECT PLAN_ID FROM PL_TRADEDETAIL WHERE GOODS_ID =(SELECT GD_ID FROM CM_GOODS WHERE GD_CODE =@GD_CODE))

AND DEPT_ID =@DEP_ID

---20211116

SELECT BR.BRANCH_CODE,BR.BRANCH_NAME,CR_ACCT AS DAU_TAI_KHOAN, SUM(AMT) AS SO_DU

FROM

(

SELECT '313000002' AS CR_ACCT,DR_ACCT,AMT,DR_BRN  FROM MW_ENTRIES_POST WHERE DR_ACCT ='313000002' AND TRN_TYPE ='MW_IN'

UNION

SELECT '313000002' AS CR_ACCT,DR_ACCT,AMT,DR_BRN  FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000002' AND TRN_TYPE ='MW_TRANSFER'

UNION

SELECT '313000002' AS CR_ACCT,DR_ACCT,-AMT, CR_BRN AS DR_BRN FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000002' AND TRN_TYPE ='MW_OUT'

UNION

SELECT '313000002' AS CR_ACCT,DR_ACCT,AMT, DR_BRN FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000002' AND TRN_TYPE ='MW_OUT'

UNION

SELECT '313000002' AS CR_ACCT,DR_ACCT,AMT,DR_BRN FROM MW_ENTRIES_POST WHERE DR_ACCT ='313000002' AND TRN_TYPE ='MW_TRANSFER_CONF'

UNION

SELECT '313000009' AS CR_ACCT,DR_ACCT,AMT,DR_BRN  FROM MW_ENTRIES_POST WHERE DR_ACCT ='313000009' AND TRN_TYPE ='MW_IN'

UNION

SELECT '313000009' AS CR_ACCT,DR_ACCT,-AMT,CR_BRN AS DR_BRN  FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000009' AND TRN_TYPE ='MW_TRANSFER'

UNION

SELECT '313000009' AS CR_ACCT,DR_ACCT,-AMT,CR_BRN AS DR_BRN FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000009' AND TRN_TYPE ='MW_OUT'

UNION

SELECT '313000009' AS CR_ACCT,DR_ACCT,AMT, DR_BRN FROM MW_ENTRIES_POST WHERE CR_ACCT ='313000009' AND TRN_TYPE ='MW_OUT'

UNION

SELECT '313000009' AS CR_ACCT,DR_ACCT,AMT,DR_BRN FROM MW_ENTRIES_POST WHERE DR_ACCT ='313000009' AND TRN_TYPE ='MW_TRANSFER_CONF'

) DTA

INNER JOIN CM_BRANCH BR ON DTA.DR_BRN = BR.BRANCH_ID

GROUP BY DTA.DR_BRN, DTA.CR_ACCT,BR.BRANCH_CODE,BR.BRANCH_NAME

DECLARE @REQ_ID VARCHAR(15)

UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000004' WHERE REQ_CODE ='PUR/2022/000020'

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000020')

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000004' WHERE PROCESS_ID ='DMMS' AND REQ_ID =@REQ_ID

UPDATE PL_REQUEST_DOC_DT SET PLAN_ID ='PLM000000260041', TRADE_ID ='PLT000000282302', GOODS_ID ='GOO000000253978' WHERE REQ_ID ='PLRD00000202658'

UPDATE PL_TRADEDETAIL_HIST SET AMT_APP =3000000000, AMT_ETM=0, AMT_EXE=0, AMT_RECEIVE_TF=0, AMT_TF =0 WHERE REQ_ID ='PLRD00000202658'

UPDATE PL_TRADEDETAIL SET AMT_APP =3000000000, AMT_ETM=1398500000, AMT_EXE=0, AMT_RECEIVE_TF=0, AMT_TF =0 WHERE TRADE_ID ='PLT000000282302'

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu chuyển đổi ngân sách ',N'Yêu cầu chuyển đổi ngân sách từ 2021 về 2022','tridq',GETDATE())

---20211215

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000203257','HDQT','C','HDQT','DV0001','',NULL,'TGD','N','','',N'Chờ Chủ Tịch HĐQT xác nhận','0','')

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='HDQT', STATUS ='U' WHERE PROCESS_ID ='APPROVE' AND REQ_ID ='PLRD00000203257'

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='HDQT' WHERE REQ_ID ='PLRD00000203257'

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000203279','HDQT','C','HDQT','DV0001','',NULL,'TGD','N','','',N'Chờ Chủ Tịch HĐQT xác nhận','0','')

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='HDQT', STATUS ='U' WHERE PROCESS_ID ='APPROVE' AND REQ_ID ='PLRD00000203279'

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='HDQT' WHERE REQ_ID ='PLRD00000203279'

UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE PROCESS_ID ='APPROVE' AND REQ_ID ='PLRD00000203257'

UPDATE PL_REQUEST_PROCESS SET STATUS ='P', CHECKER_ID ='taila', APPROVE_DT =GETDATE(), NOTES =N'Chủ tịch HĐQT đã phê duyệt' WHERE PROCESS_ID ='HDQT' AND REQ_ID ='PLRD00000203257'

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_ID ='PLRD00000203257'

UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE PROCESS_ID ='APPROVE' AND REQ_ID ='PLRD00000203279'

UPDATE PL_REQUEST_PROCESS SET STATUS ='P', CHECKER_ID ='taila', APPROVE_DT =GETDATE(), NOTES =N'Chủ tịch HĐQT đã phê duyệt' WHERE PROCESS_ID ='HDQT' AND REQ_ID ='PLRD00000203279'

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_ID ='PLRD00000203279'

UPDATE TR_REQUEST_DOC SET PROCESS_ID='', AUTH_STATUS ='E' WHERE REQ_CODE ='PUR/2022/000030'

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000054')

UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000004' WHERE REQ_ID=@REQ_ID

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000004' WHERE REQ_ID=@REQ_ID AND PROCESS_ID ='DMMS'

DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000055')

UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000004' WHERE REQ_ID=@REQ_ID

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000004' WHERE REQ_ID=@REQ_ID AND PROCESS_ID ='DMMS'

DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000166')

EXEC dbo.TR_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)

@p_AUTH_STATUS = 'A', -- varchar(1)

@p_CHECKER_ID = 'tunt', -- varchar(15)

@p_APPROVE_DT = '2022-01-20 12:00:00 AM', -- datetime

@p_ROLE_LOGIN = 'GDK', -- varchar(50)

@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)

@p_PROCESS_DESC = N'Phê duyệt', -- nvarchar(max),

@p_XMLDATA =NULL

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID = (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='012022/000969')

UPDATE TR_REQ_PAYMENT SET REQ_REASON=N'Thanh toán đợt 1 (40%) chi phí thi công ngoại thất CN Bắc Ninh' WHERE REQ_PAY_ID =@REQ_ID

UPDATE TR_REQ_PAY_SCHEDULE SET REQ_PAY_DESC=N'Thanh toán đợt 1 (40%) chi phí thi công ngoại thất CN Bắc Ninh', 

REQ_PAY_ENTRIES=N'Thanh toán đợt 1 (40%) chi phí thi công ngoại thất CN Bắc Ninh' WHERE REQ_PAY_ID =@REQ_ID

UPDATE TR_REQ_PAY_METHOD SET REQ_PAY_REASON=N'Thanh toán đợt 1 (40%) chi phí thi công ngoại thất CN Bắc Ninh', 

REQ_PAY_DESC ='Thanh toán đợt 1 (40%) chi phí thi công ngoại thất CN Bắc Ninh' WHERE REQ_PAY_ID =@REQ_ID

UPDATE TR_REQ_PAY_BUDGET SET NOTES=N'Thanh toán đợt 1 (40%) chi phí thi công ngoại thất CN Bắc Ninh', 

REASON=N'Thanh toán đợt 1 (40%) chi phí thi công ngoại thất CN Bắc Ninh' WHERE REQ_PAY_ID =@REQ_ID

----2022121

---2022120

DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME, @USER_REQUEST VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000203')

SET @DATE='2022-1-17 12:00:00 AM'

UPDATE TR_REQUEST_DOC SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID 

UPDATE PL_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID

UPDATE TR_REQUEST_DOC_DT SET REQ_DT ='2022-01-17' WHERE REQ_DOC_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu','chiltk',GETDATE())

UPDATE PL_REQUEST_DOC SET NOTES =N'Khu Vực Tổng' WHERE REQ_CODE ='0115/2021/TTr-0690604'

---2022121

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000105')

UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000008' WHERE REQ_ID=@REQ_ID --- PR 2022124

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000008' WHERE REQ_ID=@REQ_ID AND PROCESS_ID ='DMMS'

DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000106')

UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000008' WHERE REQ_ID=@REQ_ID --- PR 2022124

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000008' WHERE REQ_ID=@REQ_ID AND PROCESS_ID ='DMMS'

DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME, @USER_REQUEST VARCHAR(15)

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000193')

SET @DATE='2022-01-05 12:00:00 AM'

UPDATE TR_REQUEST_DOC SET APPROVE_DT =@DATE, REQ_DT =@DATE WHERE REQ_ID =@REQ_ID 

UPDATE PL_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu','diemttt1',GETDATE())

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000184')

SET @DATE='2022-01-12 12:00:00 AM'

UPDATE TR_REQUEST_DOC SET APPROVE_DT =@DATE, REQ_DT =@DATE WHERE REQ_ID =@REQ_ID 

UPDATE PL_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu','diemttt1',GETDATE())

---2022125

exec ASS_INVENTORY_CHECK_VALID @p_INVENT_ID=N'ASSIM0000120015',@p_USER_NAME=N'app.qlts'

go

exec ASS_INVENTORY_STATISIC_ById @p_INVENTORY_ID=N'ASSIM0000120015',@p_USER_LOGIN=NULL

go

exec ASS_INVENTORY_ById @p_INVENTORY_ID=N'ASSIM0000120015',@p_USER_LOGIN=N'app.qlts'

go

exec ASS_INVENTORY_STATISIC_ASS_Lst @p_INVENTORY_ID=N'ASSIM0000120015',@p_STATISTIC_TYPE=N'ASS_CHECKED'

go

exec ASS_INVENTORY_MASTER_Search @p_INVENT_ID=N'ASSIM0000120015',@p_INVENTORY_DT=NULL,@p_TERM=NULL,@p_BRANCH_ID=NULL,@p_BRANCH_CODE=NULL,@p_DEPT_ID=NULL,@p_NOTES=NULL,@p_RECORD_STATUS=NULL,@p_AUTH_STATUS=NULL,@p_MAKER_ID=NULL,@p_CREATE_DT=NULL,@p_CHECKER_ID=NULL,@p_APPROVE_DT=NULL,@p_TOP=NULL,@p_BRANCH_CREATE=NULL,@p_LEVEL=NULL,@p_USER_LOGIN=NULL

go

SELECT * FROM TR_PO_MASTER WHERE PO_CODE='PO039/22/0001'

SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =(SELECT REQ_DOC_ID FROM TR_PO_MASTER WHERE PO_CODE='PO039/22/0001')

SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =(SELECT REQ_DOC_ID FROM TR_PO_MASTER WHERE PO_CODE='PO039/22/0001')

SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =(SELECT PL_REQ_ID FROM TR_REQUEST_DOC WHERE REQ_ID =(SELECT REQ_DOC_ID FROM TR_PO_MASTER WHERE PO_CODE='PO039/22/0001'))

---202227

DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME, @USER_REQUEST VARCHAR(15), @DATE_NEED DATETIME

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000322')

--- NGAY YEU CAU MUA SAM

SET @DATE='2022-01-10 12:00:00 AM'

--- NGAY CAN

SET @DATE_NEED ='2022-01-15 12:00:00 AM'

-- USER YEU CAU DE GHI LOG

SET @USER_REQUEST='vanptt2'

UPDATE TR_REQUEST_DOC SET REQ_DT =@DATE WHERE REQ_ID =@REQ_ID 

UPDATE TR_REQUEST_DOC_DT SET  REQ_DT =@DATE_NEED WHERE REQ_DOC_ID =@REQ_ID 

--UPDATE PL_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT) 

VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu',@USER_REQUEST,GETDATE())

INSERT dbo.PL_ROLE_DATA_CONFIG

(

    ROLE_TYPE,

    BRANCH_ID,

    DEP_ID

)

VALUES

(   'TRADE_USER_VIEW', -- ROLE_TYPE - varchar(100)

    'ALLUSER', -- BRANCH_ID - varchar(100)

    'PLT000000300990'  -- DEP_ID - varchar(100)

    )

---- 2022210

DECLARE @REQ_ID VARCHAR(15), @PROCESS_ID VARCHAR(15)

SET @REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='')

SET @PROCESS_ID =(SELECT PROCESS_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID)

INSERT INTO PL_REQUEST_PROCESS VALUES (@REQ_ID,'GDK_DC','C','GDK','DV0001','',NULL,'TC','N','','DM0000000000017',N'Chờ GĐK Tài Chính xác nhận','0','')

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='GDK_DC' WHERE REQ_ID =@REQ_ID

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='GDK_DC', STATUS ='U' WHERE REQ_ID =@REQ_ID AND PROCESS_ID =@PROCESS_ID