DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

UPDATE PL_REQUEST_COSTCENTER SET NOTES =N'Đồng ý', AUTH_STATUS ='A' WHERE REQ_COST_ID ='PLRC00000223372'
INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000205775','DVCM','P','GDDV','DV0001','tuanva','2022-10-31','KT','N','','DM0000000000052',N'Đơn vị chuyên môn xác nhận','1','','')
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID='DVCM' WHERE ID ='79699'

select * from TR_REQ_ADVANCE_PAYMENT where REQ_PAY_CODE = 'NBO.2022.000350'

SELECT * FROM TR_REQ_PAY_BUDGET WHERE TRADE_ID ='PLT000000301606'
SELECT * FROM TR_REQ_PAY_SERVICE WHERE REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAY_BUDGET WHERE TRADE_ID ='PLT000000301606')
SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAY_BUDGET WHERE TRADE_ID ='PLT000000301606')

EXEC TR_REQ_GOOD_BYCONTRACT 'PLRD00000204535'
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID='PLT000000301606'

EXEC TR_REQ_GOOD_BYCONTRACT 'PLRD00000205634'
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID='PLT000000301606'

SELECT A.TRADE_ID, SUM AS AMT_EXE FROM TR_REQ_PAY_BUDGET A
LEFT JOIN TR_REQ_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID
WHERE B.AUTH_STATUS_KT='A'
AND A.REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAY_SERVICE WHERE EMP_ID ='PLRD00000204535')
GROUP BY TRADE_ID

SELECT A.TRADE_ID, SUM AS AMT_EXE FROM TR_REQ_PAY_BUDGET A
LEFT JOIN TR_REQ_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID
WHERE B.AUTH_STATUS_KT='A'
AND A.REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAY_SERVICE WHERE EMP_ID ='PLRD00000204535')
GROUP BY TRADE_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID='PLRD00000205562'

SELECT A.TRADE_ID, A. AMT_EXE FROM TR_REQ_PAY_BUDGET A
LEFT JOIN TR_REQ_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID
WHERE B.AUTH_STATUS_KT='A'
AND A.REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAY_SERVICE WHERE EMP_ID ='PLRD00000204535')
--GROUP BY TRADE_ID

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0032/2022/TTr-0070005'
                SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID='PLRD00000205562'

SELECT * FROM PL_PROCESS WHERE REQ_ID='PLRD00000205562'

SELECT A.TRADE_ID, A. AMT_EXE FROM TR_REQ_PAY_BUDGET A
LEFT JOIN TR_REQ_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID
WHERE B.AUTH_STATUS_KT='A'
AND A.REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAY_SERVICE WHERE EMP_ID ='PLRD00000204535')
--GROUP BY TRADE_ID
SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0032/2022/TTr-0070005'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID='PLRD00000205562'
SELECT * FROM PL_PROCESS WHERE REQ_ID='PLRD00000205562'

UPDATE PL_REQUEST_DOC SET PROCESS_ID='APPROVE' WHERE REQ_CODE='0032/2022/TTr-0070005'

SELECT A.TRADE_ID, A.AMT_EXE,B.* FROM TR_REQ_PAY_BUDGET A
LEFT JOIN TR_REQ_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID
WHERE B.AUTH_STATUS_KT='A'
AND A.REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAY_SERVICE WHERE EMP_ID ='PLRD00000204535')

SELECT * FROM PL_REQUEST_DOC
WHERE REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_PROCESS WHERE PROCESS_ID='APPROVE' AND STATUS='C')
AND (PROCESS_ID IS NULL OR PROCESS_ID ='')

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE='0013/2022/TTr-0030003'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID='PLRD00000205330'
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID='PLRD00000205330'

UPDATE PL_REQUEST_COSTCENTER SET NOTES =N'Đồng ý', AUTH_STATUS ='A' WHERE REQ_ID ='PLRD00000205661' AND COST_ID ='DM0000000000052'
INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000205661','DVCM','P','GDDV','DV0001','tuanva','2022-11-06','KT','N','','DM0000000000052',N'Đơn vị chuyên môn xác nhận','1','','')
INSERT INTO PL_PROCESS VALUES ('PLRD00000205661','DVCM','tuanva','2022-11-6 09:09:22.177',N'Đồng ý',N'Đơn vị chuyên môn phê duyệt')
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID='DVCM' WHERE REQ_ID ='PLRD00000205661' AND PROCESS_ID ='GDK_TT'