Project

General

Profile

Support #848

Cập nhật ngày lùi cho PYCMS số : 000197, 000283, 000102, 000796

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
01/21/2021
Due date:
% Done:

0%

Estimated time:

History

#1 Updated by Luc Tran Van over 4 years ago

DECLARE @REQ_ID VARCHAR, @DATE DATETIME
SET @DATE ='2020-08-27 12:00:00 AM'
SET @REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/0000197')
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
UPDATE PL_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC SET REQ_DT =@DATE, APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC_DT SET REQ_DT ='2020-08-28' WHERE REQ_DOC_ID =@REQ_ID

#2 Updated by Luc Tran Van over 4 years ago

  • Subject changed from Cập nhật ngày lùi cho PYCMS số : 000197 to Cập nhật ngày lùi cho PYCMS số : 000197, 000283, 000102, 000796

DECLARE @REQ_ID VARCHAR, @DATE DATETIME
SET @DATE ='2020-11-02 12:00:00 AM'
SET @REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000283')
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
UPDATE PL_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC SET REQ_DT =@DATE, APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC_DT SET REQ_DT ='2020-11-03' WHERE REQ_DOC_ID =@REQ_ID

#3 Updated by Luc Tran Van over 4 years ago

DECLARE @REQ_ID VARCHAR, @DATE DATETIME
SET @DATE ='2020-10-29 12:00:00 AM'
SET @REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000102')
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
UPDATE PL_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC SET REQ_DT =@DATE, APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC_DT SET REQ_DT ='2020-10-30' WHERE REQ_DOC_ID =@REQ_ID

#4 Updated by Luc Tran Van over 4 years ago

DECLARE @REQ_ID VARCHAR, @DATE DATETIME
SET @DATE ='2020-12-15 12:00:00 AM'
SET @REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000796')
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
UPDATE PL_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC SET REQ_DT =@DATE, APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC_DT SET REQ_DT ='2020-12-16' WHERE REQ_DOC_ID =@REQ_ID

#5 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF