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

-- TO TRINH CHU TRUONG

DECLARE @REQ_ID VARCHAR(15)

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

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

---PYCMS

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

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

---- UPDATE

UPDATE PL_REQUEST_PROCESS SET PROCESS_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS SET STATUS ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS SET ROLE_USER ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS SET BRANCH_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS SET IS_LEAF ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS SET COST_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS SET IS_HAS_CHILD ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS SET DEP_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''

-- PROCESS_CHILD

UPDATE PL_REQUEST_PROCESS_CHILD SET PROCESS_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS_CHILD SET TLNAME ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS_CHILD SET TYPE_JOB ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS_CHILD SET LEVEL_JOB ='' WHERE REQ_ID =@REQ_ID AND ID =''

UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB ='' WHERE REQ_ID =@REQ_ID AND ID =''

-- GEN PYCMS TU TT CHU TRUONG

EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC @REQ_ID

-- GEN PO TU PYCMS

EXEC TR_REQ_DOC_Ins_To_PO @REQ_ID

--- THEM 1 BUOC VAO QUY TRINH

INSERT INTO PL_REQUEST_PROCESS (REQ_ID,PROCESS_ID,STATUS,ROLE_USER,BRANCH_ID,CHECKER_ID,APPROVE_DT,PARENT_PROCESS_ID,

IS_LEAF, COST_ID,DVDM_ID,NOTES,IS_HAS_CHILD,DEP_ID) VALUES (@REQ_ID,.....)

--- THEM 1 BUOC VAO DIEU PHOI

INSERT INTO PL_REQUEST_PROCESS_CHILD(REQ_ID,PROCESS_ID,TLNAME,TYPE_JOB,LEVEL_JOB,STATUS_JOB,RECORD_STATUS,MAKER_ID,TRANFER_DT) VALUES (@REQ_ID,..)

-- XOA 1 BUOC KHOI QUY TRINH

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID AND ID =''

DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID AND ID =''

--- CAP NHAT LAI NGAN SACH

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

SET @TRADE_ID = (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)

---

SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID =@TRADE_ID

SELECT * FROM PL_MASTER WHERE PLAN_ID =@PLAN_ID

-- CAP NHAT

UPDATE PL_TRADEDETAIL SET AMT_ETM=0, AMT_APP=0, AMT_EXE=0, AMT_RECEIVE_TF=0, AMT_TF =0 WHERE TRADE_ID =@TRADE_ID

-- CAP NHAT CHI PHI AM

UPDATE PL_TRADEDETAIL SET AMT_APP = ABS(AMT_APP)