Project

General

Profile

Feature #1390

VẬN HÀNH SAU GOLIVE NGÀY 31-10-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:
10/31/2022
Due date:
% Done:

0%

Estimated time:
GetDATA_v1.xlsx (14.4 KB) GetDATA_v1.xlsx Luc Tran Van, 10/31/2022 01:45 PM
CM_ACCOUNT_PAY_Byid.txt (804 Bytes) CM_ACCOUNT_PAY_Byid.txt Luc Tran Van, 10/31/2022 01:48 PM
GetData_v2.xlsx (9.5 KB) GetData_v2.xlsx Luc Tran Van, 10/31/2022 02:54 PM
ASS_TRANSFER_MULTI_MASTER_Search.txt (15.9 KB) ASS_TRANSFER_MULTI_MASTER_Search.txt Luc Tran Van, 10/31/2022 03:03 PM
TR_REQ_PAY_BUDGET_data.xlsx (9.34 KB) TR_REQ_PAY_BUDGET_data.xlsx Luc Tran Van, 10/31/2022 03:15 PM
GenDatav3.xlsx (10.2 KB) GenDatav3.xlsx Luc Tran Van, 10/31/2022 03:48 PM
FIX FILE1.txt (262 Bytes) FIX FILE1.txt Luc Tran Van, 10/31/2022 03:52 PM
ASS_TRANSFER_CONFIRM_MASTER_Search.txt (7.95 KB) ASS_TRANSFER_CONFIRM_MASTER_Search.txt Luc Tran Van, 10/31/2022 03:57 PM
TR_REQ_PAY_ENTRIES_DATA.xlsx (9.86 KB) TR_REQ_PAY_ENTRIES_DATA.xlsx Luc Tran Van, 10/31/2022 03:58 PM
1.4 GET DATA THANH TOAN TTCT 0005 2022 TTr 0692103.txt (457 Bytes) 1.4 GET DATA THANH TOAN TTCT 0005 2022 TTr 0692103.txt Luc Tran Van, 10/31/2022 04:23 PM
GetData_v4.xlsx (73.1 KB) GetData_v4.xlsx Luc Tran Van, 10/31/2022 04:28 PM
FIX FILE2.txt (382 Bytes) FIX FILE2.txt Luc Tran Van, 10/31/2022 04:28 PM
GetData_v5.xlsx (13.7 KB) GetData_v5.xlsx Luc Tran Van, 10/31/2022 04:30 PM
FIX FILE3.txt (336 Bytes) FIX FILE3.txt Luc Tran Van, 10/31/2022 04:39 PM
FIX FILE4.txt (1.98 KB) FIX FILE4.txt Luc Tran Van, 10/31/2022 04:56 PM
invoice.txt (1.09 KB) invoice.txt Luc Tran Van, 11/08/2022 10:24 AM

History

#1 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_CONTRACT WHERE CONTRACT_ID='TRC000000253880'
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =(SELECT REQ_DOC_ID FROM TR_CONTRACT WHERE CONTRACT_ID='TRC000000253880')
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =(SELECT REQ_DOC_ID FROM TR_CONTRACT WHERE CONTRACT_ID='TRC000000253880')
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID IN (SELECT PL_REQ_ID FROM TR_REQUEST_DOC WHERE REQ_ID =(SELECT REQ_DOC_ID FROM TR_CONTRACT WHERE CONTRACT_ID='TRC000000253880'))

#4 Updated by Luc Tran Van over 2 years ago

EXEC TR_REQ_GOOD_BYCONTRACT'TRC000000253880'

#7 Updated by Luc Tran Van over 2 years ago

INSERT INTO CM_AUTH_STATUS (AUTH_STATUS, AUTH_STATUS_NAME, AUTH_STATUS_KT_DESC, AUTH_STATUS_HC_DESC)
VALUES ('E', N'Chờ duyệt', N'', N'');

#8 Updated by Luc Tran Van over 2 years ago

select * from TR_REQ_PAY_BUDGET where REQ_PAY_ID = (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE = '102022/001731')

#9 Updated by Luc Tran Van over 2 years ago

DECLARE @l_TR_REQ_ADVANCE_DT VARCHAR = 'TUPO' + '00000' + CONVERT,(select CurValue+1 from SYS_CODEMASTERS where Prefix = 'TUPO'))
INSERT INTO [TR_REQ_ADVANCE_DT] ([REQ_PAYDTID],[REQ_PAY_ID],[REF_ID],[TYPE],[MAKER_ID],[CREATE_DT],[IS_CLOSED],[REF_TYPE],[DELIVERY_DT],[END_DT])
VALUES

#11 Updated by Luc Tran Van over 2 years ago

select REF_ID from TR_REQ_PAY_SCHEDULE where REQ_PAY_ID = 'TRPY00000242737'

#12 Updated by Luc Tran Van over 2 years ago

UPDATE TR_REQ_PAY_BUDGET SET AMT_APP =7798638366, AMT_DO=0, AMT_REMAIN =7798638366 WHERE BUDG_ID ='TRBG00000398264'

#13 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_CONTRACT_DT WHERE CONTRACT_ID ='TRC000000253880'

#16 Updated by Luc Tran Van over 2 years ago

select * from TR_REQ_PAY_ENTRIES where REQ_PAY_ID = (select REQ_PAY_ID from TR_REQ_PAYMENT where REQ_PAY_CODE = '102022/000958')

#17 Updated by Luc Tran Van over 2 years ago

update SYS_CODEMASTERS set CurValue = 316330 where Prefix = 'TUPO'

#20 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE='0005/2022/TTr-0692103'
SELECT SUM FROM TR_REQUEST_DOC WHERE PL_REQ_ID ='PLRD00000203297' AND PROCESS_ID = 'APPROVE'

SELECT SUM FROM TR_REQUEST_DOC WHERE PL_REQ_ID ='PLRD00000203297' AND PROCESS_ID <> 'APPROVE'

SELECT * FROM TR_REQ_PAYMENT
INNER JOIN TR_REQ_PAY_SERVICE ON TR_REQ_PAYMENT.REQ_PAY_ID =TR_REQ_PAY_SERVICE.REQ_PAY_ID
WHERE TR_REQ_PAY_SERVICE.EMP_ID ='PLRD00000203297'

Also available in: Atom PDF