EOFFICE - GD4

DECLARE @REQ_ID VARCHAR(15)

SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2024/001817'

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

UPDATE PL_REQUEST_PROCESS SET STATUS = 'P' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'APPROVE'

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

UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB = 'C' WHERE REQ_ID = @REQ_ID AND TYPE_JOB = 'XL' AND TLNAME = 'anhtm1'

UPDATE TR_REQ_PAYMENT SET AUTH_STATUS = 'U' , TRASFER_USER_RECIVE = NULL WHERE REQ_PAY_CODE = '112024/000951'

UPDATE TR_REQ_PAYMENT SET AUTH_STATUS = 'U' , TRASFER_USER_RECIVE = NULL WHERE REQ_PAY_CODE = '102024/001157'

UPDATE TR_REQUEST_CAR SET ORIGN = 'TP.HCM', DESTINATION = N'Tiền Giang, Sóc Trăng', TO_TRIP = N'Tiền Giang, Sóc Trăng', FROM_TRIP = N'TP.HCM'  WHERE REQ_CODE = 'PYC-XE/2024/000735'

UPDATE TR_REQUEST_CAR SET REQ_REASON = N'Đi công tác'  WHERE REQ_CODE = 'PYC-XE/2024/000788'

SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2024/002684'

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

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

UPDATE PL_REQUEST_PROCESS SET STATUS = 'C' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'GDK_PYC'