Project

General

Profile

Feature #1409

VẬN HÀNH SAU GOLIVE NGÀY 29-11-2022

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

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

0%

Estimated time:
1.2 PL REQUEST PROCESS CHILD APPR.txt (45.7 KB) 1.2 PL REQUEST PROCESS CHILD APPR.txt Luc Tran Van, 11/28/2022 10:25 PM
1.0 PL REQUEST DOC APPR.txt (52.3 KB) 1.0 PL REQUEST DOC APPR.txt Luc Tran Van, 11/28/2022 10:25 PM
1.4 PL REQUEST PROCESS APPR.txt (12 KB) 1.4 PL REQUEST PROCESS APPR.txt Luc Tran Van, 11/28/2022 10:25 PM
Ngôn ngữ PYCMS.txt (137 Bytes) Ngôn ngữ PYCMS.txt Luc Tran Van, 11/29/2022 09:06 AM
script_1_291122.txt (304 KB) script_1_291122.txt Luc Tran Van, 11/29/2022 09:33 AM
2.2 PL REQUEST DOC SEARCH.txt (80.8 KB) 2.2 PL REQUEST DOC SEARCH.txt Luc Tran Van, 11/29/2022 09:54 AM
NF_MESSAGE_GetContent.txt (132 KB) NF_MESSAGE_GetContent.txt Luc Tran Van, 11/29/2022 10:16 AM
DATA_#9_291122.xlsx (9.93 KB) DATA_#9_291122.xlsx Luc Tran Van, 11/29/2022 11:02 AM
2.4 TR REQUEST GOOD BYCONTRACT.txt (9.69 KB) 2.4 TR REQUEST GOOD BYCONTRACT.txt Luc Tran Van, 11/29/2022 11:13 AM
2.5 GET DATA TO TRINH CHU TRUONG.txt (2.01 KB) 2.5 GET DATA TO TRINH CHU TRUONG.txt Luc Tran Van, 11/29/2022 11:22 AM
DATA_#12_291122.xlsx (21.1 KB) DATA_#12_291122.xlsx Luc Tran Van, 11/29/2022 11:26 AM
DATA_TRANS_291122.txt (13.1 KB) DATA_TRANS_291122.txt Luc Tran Van, 11/29/2022 11:46 AM
DATA_#18.xlsx (9.29 KB) DATA_#18.xlsx Luc Tran Van, 11/29/2022 01:40 PM
NF_MESSAGE_GetContent.txt (132 KB) NF_MESSAGE_GetContent.txt Luc Tran Van, 11/29/2022 01:50 PM
import_Entry.txt (3.25 KB) import_Entry.txt Luc Tran Van, 11/29/2022 02:19 PM
script_mw.txt (39.6 KB) script_mw.txt Luc Tran Van, 11/29/2022 02:34 PM
DEBUG.txt (1.26 KB) DEBUG.txt Luc Tran Van, 11/29/2022 03:31 PM
DATA_#24.xlsx (9.22 KB) DATA_#24.xlsx Luc Tran Van, 11/29/2022 03:43 PM
CHECK_ROLE_291122.txt (15.1 KB) CHECK_ROLE_291122.txt Luc Tran Van, 11/29/2022 04:27 PM
TR_CHECK_ROLE_301122.txt (15.5 KB) TR_CHECK_ROLE_301122.txt Luc Tran Van, 11/30/2022 09:38 AM
DATA_TTCT_0004.xlsx (23.1 KB) DATA_TTCT_0004.xlsx Luc Tran Van, 04/27/2023 05:40 PM
DATA_TTCT_0003.xlsx (22.2 KB) DATA_TTCT_0003.xlsx Luc Tran Van, 04/27/2023 05:40 PM
DATA_TTCT_0001.xlsx (24 KB) DATA_TTCT_0001.xlsx Luc Tran Van, 04/27/2023 05:40 PM

History

#2 Updated by Luc Tran Van over 2 years ago

UPDATE TR_REQUEST_DOC SET TOTAL_AMT= 191638289 WHERE REQ_ID='TRRD00000257313'
UPDATE TR_REQUEST_DOC_DT SET TOTAL_AMT =191638289, PRICE=191638289 WHERE REQ_DOC_ID='TRRD00000257313'

#3 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205610'
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID ='PLRD00000205610'
SELECT * FROM PL_PROCESS WHERE REQ_ID='PLRD00000205610'

#7 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_PROCESS SET STATUS ='U', CHECKER_ID='', APPROVE_DT= NULL, NOTES =N'Chờ giám đốc khối phê duyệt' WHERE ID='76057'
UPDATE PL_REQUEST_PROCESS SET STATUS ='P', CHECKER_ID='sangnm1', APPROVE_DT= '11/28/2022 6:14:03 PM', NOTES =N'Đơn vị chuyên môn đã phê duyệt' WHERE ID='76055'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID='76056'
UPDATE PL_REQUEST_DOC SET PROCESS_ID='DVCM' WHERE REQ_ID ='PLRD00000205610'
UPDATE PL_REQUEST_COSTCENTER SET AUTH_STATUS='A', CHECKER_ID ='sangnm1' WHERE REQ_ID ='PLRD00000205610' AND COST_ID ='DM0000000000008'

#9 Updated by Luc Tran Van over 2 years ago

EXEC TR_REQ_GOOD_BYCONTRACT 'TRPM00000254630'

#14 Updated by Luc Tran Van over 2 years ago

UPDATE PL_TRADEDETAIL SET AMT_ETM = 1841589975 WHERE TRADE_ID ='PLT000000287360'
UPDATE PL_REQUEST_DOC_DT SET AMT_ETM =1841589975 WHERE REQDT_ID ='PLRDD0000253770'

#16 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB ='P' WHERE ID ='152189'

#17 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB ='P' WHERE ID ='152189'
UPDATE PL_REQUEST_DOC SET PROCESS_ID='TC' WHERE REQ_ID='PLRD00000205610'

#18 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002942')
SELECT * FROM PL_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002942')

#21 Updated by Luc Tran Van over 2 years ago

Chi nhánh Công ty Cổ phần In Hospitality

#24 Updated by Luc Tran Van over 2 years ago

Also available in: Atom PDF