Project

General

Profile

Feature #1557

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

Added by Luc Tran Van over 1 year ago. Updated over 1 year ago.

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

0%

Estimated time:
Chạy khấu hao.docx (84.2 KB) Chạy khấu hao.docx Luc Tran Van, 09/25/2023 04:48 PM
UPDATE ASS_COST_ALLOCATION.txt (50 Bytes) UPDATE ASS_COST_ALLOCATION.txt Luc Tran Van, 09/25/2023 05:05 PM
THONG_KE_KHMS_BanViet.xlsx (14 KB) THONG_KE_KHMS_BanViet.xlsx Luc Tran Van, 09/25/2023 05:10 PM
Sao_ke_PYCMS_BanViet.xlsx (32.4 KB) Sao_ke_PYCMS_BanViet.xlsx Luc Tran Van, 09/25/2023 05:10 PM
rpt_ass_master.xlsx (12 KB) rpt_ass_master.xlsx Luc Tran Van, 09/25/2023 05:10 PM
PHIEUYEUCAUCONGTAC.docx (111 KB) PHIEUYEUCAUCONGTAC.docx Luc Tran Van, 09/25/2023 05:10 PM
1.0 PHAN BO CHI PHI CCLD.txt (276 Bytes) 1.0 PHAN BO CHI PHI CCLD.txt Luc Tran Van, 09/25/2023 05:18 PM
2.0. PUR 2023 002077.txt (449 Bytes) 2.0. PUR 2023 002077.txt Luc Tran Van, 09/25/2023 05:18 PM
TASK_4.xlsx (7.35 KB) TASK_4.xlsx Luc Tran Van, 09/25/2023 05:39 PM
BACKUP_CHAYKHAUHAO25092023.xlsx (272 KB) BACKUP_CHAYKHAUHAO25092023.xlsx Luc Tran Van, 09/25/2023 05:39 PM
2.2. ASS_AMORT_DO.txt (15 KB) 2.2. ASS_AMORT_DO.txt Luc Tran Van, 09/25/2023 06:17 PM
backup_DATA_KH_25.10.2023.xlsx (370 KB) backup_DATA_KH_25.10.2023.xlsx Luc Tran Van, 10/25/2023 05:59 PM
Logs.txt.1.zip (3.33 MB) Logs.txt.1.zip Luc Tran Van, 10/25/2023 06:05 PM
backup_DATA_KH_25.10.2023.xlsx (1.06 MB) backup_DATA_KH_25.10.2023.xlsx Luc Tran Van, 10/25/2023 06:10 PM
Logs.txt.2.zip (3.33 MB) Logs.txt.2.zip Luc Tran Van, 10/25/2023 06:14 PM
Logs.txt.3.zip (3.3 MB) Logs.txt.3.zip Luc Tran Van, 10/25/2023 06:14 PM
Logs.txt.4.zip (3.3 MB) Logs.txt.4.zip Luc Tran Van, 10/25/2023 06:15 PM
Logs.txt.5.zip (3.28 MB) Logs.txt.5.zip Luc Tran Van, 10/25/2023 06:15 PM
Logs.txt.6.zip (3.3 MB) Logs.txt.6.zip Luc Tran Van, 10/25/2023 06:15 PM
Logs.txt.7.zip (3.33 MB) Logs.txt.7.zip Luc Tran Van, 10/25/2023 06:15 PM
Logs.txt.8.zip (3.36 MB) Logs.txt.8.zip Luc Tran Van, 10/25/2023 06:15 PM
Logs.txt.9.zip (3.35 MB) Logs.txt.9.zip Luc Tran Van, 10/25/2023 06:15 PM
Logs.txt.10.zip (3.34 MB) Logs.txt.10.zip Luc Tran Van, 10/25/2023 06:15 PM
Logs.txt.11.zip (3.34 MB) Logs.txt.11.zip Luc Tran Van, 10/25/2023 06:15 PM
Logs.txt.12.zip (3.3 MB) Logs.txt.12.zip Luc Tran Van, 10/25/2023 06:15 PM
Logs.txt.13.zip (3.31 MB) Logs.txt.13.zip Luc Tran Van, 10/25/2023 06:15 PM
Logs.txt.14.zip (3.31 MB) Logs.txt.14.zip Luc Tran Van, 10/25/2023 06:16 PM
Logs.txt.15.zip (3.3 MB) Logs.txt.15.zip Luc Tran Van, 10/25/2023 06:16 PM
Logs.txt.16.zip (3.33 MB) Logs.txt.16.zip Luc Tran Van, 10/25/2023 06:16 PM
Logs.txt.17.zip (3.26 MB) Logs.txt.17.zip Luc Tran Van, 10/25/2023 06:16 PM
Logs.txt.18.zip (3.24 MB) Logs.txt.18.zip Luc Tran Van, 10/25/2023 06:16 PM
Logs.txt.19.zip (3.3 MB) Logs.txt.19.zip Luc Tran Van, 10/25/2023 06:16 PM
Logs.txt.20.zip (3.3 MB) Logs.txt.20.zip Luc Tran Van, 10/25/2023 06:16 PM
Logs.txt.21.zip (3.3 MB) Logs.txt.21.zip Luc Tran Van, 10/25/2023 06:16 PM
Logs.zip (1.12 MB) Logs.zip Luc Tran Van, 10/25/2023 06:16 PM
BACKUP_2411023.xlsx (1000 KB) BACKUP_2411023.xlsx Luc Tran Van, 11/24/2023 06:28 PM

History

#7 Updated by Luc Tran Van over 1 year ago

DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE ID ='221490' --25092023_SECRETKEY

#8 Updated by Luc Tran Van over 1 year ago

SELECT COUNT (*)
FROM ASS_ENTRIES_POST WHERE TRN_ID ='' AND ISNULL <> ''

#10 Updated by Luc Tran Van over 1 year ago

SELECT COUNT (*)
FROM ASS_ENTRIES_POST WHERE TRN_ID ='ASM000000251068' AND ISNULL = '' AND AMT <> 0

#11 Updated by Luc Tran Van over 1 year ago

update PAY_ENTRIES_POST
set REF_NO = NULL
where ET_ID = 'PET000000164787'

update PAY_ENTRIES_POST
set REF_NO = NULL
where ET_ID = 'PET000000164788'
--25102023_secretkey

#17 Updated by Luc Tran Van over 1 year ago

#18 Updated by Luc Tran Van over 1 year ago

DECLARE @NGAYLUI_2 VARCHAR = '16/08/2023 00:00:00'
UPDATE PL_APPOINT_CONTRACTOR SET REQ_DT = CONVERT, CREATE_DT = CONVERT WHERE REQ_CODE = '000076/2023/TTr-P.HC-BP.MH'
DECLARE @REQ_ID_PYCMS_2 VARCHAR = (SELECT TOP 1 pac.TR_REQUEST_DOC_ID FROM PL_APPOINT_CONTRACTOR pac WHERE PAC.REQ_CODE = '000076/2023/TTr-P.HC-BP.MH')
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT = CONVERT WHERE REQ_ID = @REQ_ID_PYCMS_2
UPDATE PL_PROCESS SET APPROVE_DT = CONVERT WHERE REQ_ID = @REQ_ID_PYCMS_2

#19 Updated by Luc Tran Van over 1 year ago

UPDATE TR_REQUEST_CAR SET MAKER_ID = 'phuongntt4' WHERE REQ_CODE = 'PYC-XE/2023/001004'

#20 Updated by Luc Tran Van over 1 year ago

SELECT * from TR_REQUEST_CAR trc WHERE REQ_CODE = 'PYC-XE/2023/001004'

Also available in: Atom PDF