Project

General

Profile

Feature #1411

VẬN HÀNH SAU GOLIVE NGÀY 01-12-2022

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

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
12/01/2022
Due date:
% Done:

0%

Estimated time:
INHACHTOAN_BanViet.docx (103 KB) INHACHTOAN_BanViet.docx Luc Tran Van, 12/01/2022 09:20 AM
TR_PO_MASTER_Upd.txt (18.1 KB) TR_PO_MASTER_Upd.txt Luc Tran Van, 12/01/2022 10:45 AM
DATA #6.xlsx (11.1 KB) DATA #6.xlsx Luc Tran Van, 12/01/2022 11:02 AM
TR_REQUEST_DOC_DVMS_Upd.txt (13.2 KB) TR_REQUEST_DOC_DVMS_Upd.txt Luc Tran Van, 12/01/2022 11:08 AM
Debug.txt (347 Bytes) Debug.txt Luc Tran Van, 12/01/2022 11:28 AM
Debug.txt (477 Bytes) Debug.txt Luc Tran Van, 12/01/2022 11:33 AM
DATA_HUY_#11.xlsx (9.11 KB) DATA_HUY_#11.xlsx Luc Tran Van, 12/01/2022 11:54 AM
DATA_TOTRINH_011222.xlsx (21.5 KB) DATA_TOTRINH_011222.xlsx Luc Tran Van, 12/01/2022 01:37 PM
Debug.txt (468 Bytes) Debug.txt Luc Tran Van, 12/01/2022 01:51 PM
DATA_HUY_#15 (2).xlsx (25.2 KB) DATA_HUY_#15 (2).xlsx Luc Tran Van, 12/01/2022 02:04 PM
PL_REQUEST_DOC_ById.txt (6.3 KB) PL_REQUEST_DOC_ById.txt Luc Tran Van, 12/01/2022 02:06 PM
Logs.zip (862 KB) Logs.zip Luc Tran Van, 12/01/2022 02:14 PM
PL_REQUEST_DOC_ById.txt (6.33 KB) PL_REQUEST_DOC_ById.txt Luc Tran Van, 12/01/2022 02:16 PM
DATA_TOTRINH_0368.xlsx (25.7 KB) DATA_TOTRINH_0368.xlsx Luc Tran Van, 12/01/2022 02:17 PM
TO_TRINH_CHU_TRUONG-6a51a892-9900-453e-9b18-866a3c6b97a9.pdf (280 KB) TO_TRINH_CHU_TRUONG-6a51a892-9900-453e-9b18-866a3c6b97a9.pdf Luc Tran Van, 12/01/2022 02:36 PM
TR_REQUEST_DOC_DVMS_Upd.txt (14.3 KB) TR_REQUEST_DOC_DVMS_Upd.txt Luc Tran Van, 12/01/2022 02:54 PM
CCLD_BC08_2_BanViet.xlsx (12.6 KB) CCLD_BC08_2_BanViet.xlsx Luc Tran Van, 12/01/2022 02:55 PM
TR_REQUEST_DOC_Ins.txt (19.3 KB) TR_REQUEST_DOC_Ins.txt Luc Tran Van, 12/01/2022 03:00 PM
TR_REQUEST_DOC_Upd.txt (19.7 KB) TR_REQUEST_DOC_Upd.txt Luc Tran Van, 12/01/2022 03:00 PM
rpt_CCLD_BC08_2_Excel_BanViet.txt (19.2 KB) rpt_CCLD_BC08_2_Excel_BanViet.txt Luc Tran Van, 12/01/2022 03:07 PM
[CM_EMPLOYEE_Del].txt (1.12 KB) [CM_EMPLOYEE_Del].txt Luc Tran Van, 12/01/2022 03:15 PM
upd_pay_emthod.txt (7.77 KB) upd_pay_emthod.txt Luc Tran Van, 12/01/2022 03:47 PM
tr_pay_upd.txt (104 KB) tr_pay_upd.txt Luc Tran Van, 12/01/2022 04:55 PM
PL_REQ_PROCESS_CHILD_App.txt (46.3 KB) PL_REQ_PROCESS_CHILD_App.txt Luc Tran Van, 12/01/2022 05:15 PM
DATA_TOTRINH_DIEUCHUYEN_0006.xlsx (21.1 KB) DATA_TOTRINH_DIEUCHUYEN_0006.xlsx Luc Tran Van, 12/01/2022 05:29 PM

History

#2 Updated by Luc Tran Van over 2 years ago

./wwwroot/Reports/ASS_MASTER

#3 Updated by Luc Tran Van over 2 years ago

EXEC PL_PROCESS_CURRENT_SEARCH 'PLRD00000205853','luctv','TTCT'

#4 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC_DT WHERE TRAN_TYPE_ID='TRN0000000007'
UPDATE TR_REQUEST_DOC_DT SET SUP_ID='' WHERE TRAN_TYPE_ID='TRN0000000007'

#6 Updated by Luc Tran Van over 2 years ago

EXEC PL_REQUEST_DOC_ById 'PLRD00000205853','nhannt'

#9 Updated by Luc Tran Van over 2 years ago

#10 Updated by Luc Tran Van over 2 years ago

#11 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_COSTCENTER pc WHERE pc.DVDM_ID = 'DM0000000000077'

#13 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_COSTCENTER_DT WHERE COST_ID = 'PLCC00000000127'

#15 Updated by Luc Tran Van over 2 years ago

#18 Updated by Luc Tran Van over 2 years ago

EXEC PL_REQUEST_DOC_ById 'PLRD00000205853','nhannt'

#19 Updated by Luc Tran Van over 2 years ago

#20 Updated by Luc Tran Van over 2 years ago

112022/002045

#24 Updated by Luc Tran Van over 2 years ago

EXEC PL_CHECK_ROLE_UPDATE @p_REQ_ID = 'PLRD00000206121'
,@p_USER_LOGIN = 'xuanpt'
,@TYPE = 'TTCT-DVCM'
,@REF_ID = ''

#26 Updated by Luc Tran Van over 2 years ago

./wwwroot/Reports/REPORT

#31 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_DOC SET PROCESS_ID='TC' WHERE REQ_ID='GDK_TT' AND REQ_ID='PLRD00000205279'
UPDATE PL_REQUEST_DOC SET PROCESS_ID='TC' WHERE REQ_ID='GDK_TT' AND REQ_ID='PLRD00000205929'

EXEC PL_REQ_PROCESS_CHILD_App 'PLRD00000205279','TC','hoattm','linhttt1','TP',N'Phê duyệt',85243,0
EXEC PL_REQ_PROCESS_CHILD_App 'PLRD00000205929','TC','hoattm','linhttt1','TP',N'Phê duyệt',83813,0

#32 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_DOC SET PROCESS_ID='TC' WHERE REQ_ID='PLRD00000205279'
UPDATE PL_REQUEST_DOC SET PROCESS_ID='TC' WHERE REQ_ID='PLRD00000205929'

EXEC PL_REQ_PROCESS_CHILD_App 'PLRD00000205279','TC','hoattm','linhttt1','TP',N'Phê duyệt',85243,0
EXEC PL_REQ_PROCESS_CHILD_App 'PLRD00000205929','TC','hoattm','linhttt1','TP',N'Phê duyệt',83813,0

#34 Updated by Luc Tran Van over 2 years ago

UPDATE TR_REQ_PAYMENT SET REQ_TYPE_CURRENCY ='USD', RATE =24857 WHERE REQ_PAY_CODE ='122022/000067'
UPDATE TR_REQ_PAY_SCHEDULE SET CURRENCY ='USD', RATE =24857 WHERE REQ_PAY_ID = (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='122022/000067')
UPDATE TR_REQ_PAY_METHOD SET CURRENCY ='USD',RATE =24857 WHERE REQ_PAY_ID = (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='122022/000067')
UPDATE TR_REQ_PAY_BUDGET SET CURRENCY ='USD',RATE =24857 WHERE REQ_PAY_ID = (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='122022/000067')
UPDATE TR_REQ_PAY_SERVICE SET CURRENCY ='USD',RATE =24857 WHERE REQ_PAY_ID = (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='122022/000067')

Also available in: Atom PDF