Project

General

Profile

Feature #1551

VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 25.07.2023

Added by Luc Tran Van almost 2 years ago. Updated almost 2 years ago.

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
07/25/2023
Due date:
% Done:

0%

Estimated time:
DATA_#1_2507.xlsx (10.7 KB) DATA_#1_2507.xlsx Luc Tran Van, 07/25/2023 09:39 AM
REQ_KPI-b641d93e-11e5-4f5d-a8c3-ee9d0b78d031.xlsx (205 KB) REQ_KPI-b641d93e-11e5-4f5d-a8c3-ee9d0b78d031.xlsx Luc Tran Van, 07/25/2023 01:58 PM
2.4.CHUYỂN DMMS VỀ PHÒNG HÀNH CHÍNH -PUR.txt (363 Bytes) 2.4.CHUYỂN DMMS VỀ PHÒNG HÀNH CHÍNH -PUR.txt Luc Tran Van, 07/25/2023 03:01 PM
2.4.CHUYỂN DMMS VỀ PHÒNG HÀNH CHÍNH -PUR.txt (363 Bytes) 2.4.CHUYỂN DMMS VỀ PHÒNG HÀNH CHÍNH -PUR.txt Luc Tran Van, 07/25/2023 03:24 PM
2.4.CHUYỂN DMMS VỀ PHÒNG HÀNH CHÍNH -PUR.txt (363 Bytes) 2.4.CHUYỂN DMMS VỀ PHÒNG HÀNH CHÍNH -PUR.txt Luc Tran Van, 07/25/2023 03:35 PM
script_upd_020823_1.txt (159 Bytes) script_upd_020823_1.txt Luc Tran Van, 08/02/2023 09:37 AM
script_upd_LIVE_080823.txt (47.3 KB) script_upd_LIVE_080823.txt Luc Tran Van, 08/08/2023 12:05 AM
script_upd_LIVE_080823.txt (87.3 KB) script_upd_LIVE_080823.txt Luc Tran Van, 08/08/2023 12:11 AM
script_upd_LIVE_080823.txt (259 KB) script_upd_LIVE_080823.txt Luc Tran Van, 08/08/2023 12:39 AM

History

#1 Updated by Luc Tran Van almost 2 years ago

SELECT * FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID IN ('TFS000000251379','TFS000000251201','TFS000000251195')
SELECT * FROM ASS_TRANSFER_CONFIRM_MASTER WHERE TRANS_MULTI_MASTER_ID IN ('TFS000000251379','TFS000000251201','TFS000000251195')

#2 Updated by Luc Tran Van almost 2 years ago

UPDATE ASS_TRANSFER_MULTI_MASTER SET AUTH_STATUS_KT ='E' WHERE TRANS_MULTI_MASTER_ID IN ('TFS000000251379','TFS000000251201','TFS000000251195')---25072023_SECRETKEY

#4 Updated by Luc Tran Van almost 2 years ago

  • Tracker changed from Support to Feature

#5 Updated by Luc Tran Van almost 2 years ago

DELETE FROM PL_TRADEDETAIL_HIST WHERE REQ_ID ='PLRD00000207988'
UPDATE PL_TRADEDETAIL SET AMT_ETM =848000000 WHERE TRADE_ID ='PLT000000307789'
UPDATE PL_REQUEST_DOC SET PROCESS_ID='TKTGD' WHERE REQ_ID ='PLRD00000207988'
INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000207988','TKTGD','C','TKTGD','','',NULL,'PTGDK_TT','N','','',N'Chờ Thư Ký TGĐ xác nhận','1','','')
INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000207988','TGD','U','TGD','','',NULL,'TKTGD','N','','',N'Chờ Tổng giám đốc phê duyệt','0','','')
UPDATE PL_REQUEST_PROCESS SET STATUS='U', PARENT_PROCESS_ID ='TGD' WHERE REQ_ID ='PLRD00000207988' AND PROCESS_ID ='APPROVE'

#7 Updated by Luc Tran Van almost 2 years ago

UPDATE PL_REQUEST_PROCESS_CHILD SET TLNAME ='uyenln' WHERE ID ='207258' ------24072023_SECRETKEY

#11 Updated by Luc Tran Van almost 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2023/001612')
DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID=@REQ_ID
UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DMMS00000000001' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='DMMS'
UPDATE TR_REQUEST_DOC SET DMMS_ID ='DMMS00000000001', USER_DVMS ='' WHERE REQ_ID =@REQ_ID

#12 Updated by Luc Tran Van almost 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0017/2023/1100005')
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', PROCESS_ID ='APPNEW' WHERE REQ_ID=@REQ_ID AND PROCESS_ID='APPROVE'
UPDATE PL_REQUEST_DOC SET PROCESS_ID='APPROVE' WHERE REQ_ID =@REQ_ID
EXEC PL_REQ_DOC_UPDATE_AFTER_APPROVE @REQ_ID
EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC @REQ_ID ------24072023_SECRETKEY

Also available in: Atom PDF