Project

General

Profile

Feature #1470

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

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

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

0%

Estimated time:
1.0 CM ATTACH FILE SEARCH.txt (3.6 KB) 1.0 CM ATTACH FILE SEARCH.txt Luc Tran Van, 03/27/2023 09:47 AM
01_ALTER_STORED.sql (873 KB) 01_ALTER_STORED.sql Luc Tran Van, 03/27/2023 10:05 AM
invoice.txt (45.5 KB) invoice.txt Luc Tran Van, 03/27/2023 10:41 AM
TR_REQ_PAYMENT_SEARCH.txt (47 KB) TR_REQ_PAYMENT_SEARCH.txt Luc Tran Van, 03/27/2023 11:24 AM
lay_data.txt (1.14 KB) lay_data.txt Luc Tran Van, 03/27/2023 11:53 AM
data PUR_2023_000248.txt (198 Bytes) data PUR_2023_000248.txt Luc Tran Van, 03/27/2023 01:54 PM
DATA_#7.txt (107 KB) DATA_#7.txt Luc Tran Van, 03/27/2023 02:00 PM
DATA_#8.xlsx (12 KB) DATA_#8.xlsx Luc Tran Van, 03/27/2023 02:01 PM
data PL_REQUEST_PROCESS PUR_2023_000248.txt (184 Bytes) data PL_REQUEST_PROCESS PUR_2023_000248.txt Luc Tran Van, 03/27/2023 02:28 PM
DATA_#11.xlsx (9.94 KB) DATA_#11.xlsx Luc Tran Van, 03/27/2023 02:42 PM
DATA_#12.xlsx (16.9 KB) DATA_#12.xlsx Luc Tran Van, 03/27/2023 02:46 PM
rpt_job_dt.txt (2.13 KB) rpt_job_dt.txt Luc Tran Van, 03/27/2023 02:51 PM
DATA_#16.xlsx (11.8 KB) DATA_#16.xlsx Luc Tran Van, 03/27/2023 03:03 PM
update PUR_2023_000248.txt (388 Bytes) update PUR_2023_000248.txt Luc Tran Van, 03/27/2023 03:14 PM
req_pay_kt_upd.txt (45.9 KB) req_pay_kt_upd.txt Luc Tran Van, 03/27/2023 03:18 PM
lấy data.txt (552 Bytes) lấy data.txt Luc Tran Van, 03/27/2023 03:29 PM
DATA_#20.xlsx (12 KB) DATA_#20.xlsx Luc Tran Van, 03/27/2023 03:33 PM
update PUR_2023_000248.txt (399 Bytes) update PUR_2023_000248.txt Luc Tran Van, 03/27/2023 03:39 PM
rpt_job_dt_2.txt (2.11 KB) rpt_job_dt_2.txt Luc Tran Van, 03/27/2023 04:13 PM
rpt_tr_req_jobDT.xlsx (24.3 KB) rpt_tr_req_jobDT.xlsx Luc Tran Van, 03/27/2023 04:29 PM
rpt_req_pay_job_dt.txt (2.16 KB) rpt_req_pay_job_dt.txt Luc Tran Van, 03/27/2023 04:32 PM
scan_bill.txt (18.6 KB) scan_bill.txt Luc Tran Van, 03/27/2023 04:56 PM

History

#1 Updated by Luc Tran Van about 2 years ago

SELECT * FROM TL_SYS_ROLE_MAPPING WHERE ROLE_OLD ='Administrators' AND TLNAME ='vanpt2'
SELECT * FROM TL_SYS_ROLE_MAPPING WHERE ROLE_OLD ='FULLTEMP'

#4 Updated by Luc Tran Van about 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0109/2023/TTr-0690604')
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID='TKTGD'
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID='TGD'
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='GDK_TT' WHERE REQ_ID =@REQ_ID AND PROCESS_ID='APPROVE'
DELETE FROM PL_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='TKTGD'
DELETE FROM PL_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='TGD'

SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0096/2023/TTr-0690604')
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID='TKTGD'
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID='TGD'
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='GDK_TT' WHERE REQ_ID =@REQ_ID AND PROCESS_ID='APPROVE'
DELETE FROM PL_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='TKTGD'
DELETE FROM PL_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='TGD'

#12 Updated by Luc Tran Van about 2 years ago

SELECT * FROM MW_TRANSFER_DT WHERE TRANSFER_ID ='MWTF00000250283'
SELECT * FROM MW_MAST_BAL WHERE MAST_BAL_ID IN (SELECT MAST_BAL_ID FROM MW_TRANSFER_DT WHERE TRANSFER_ID ='MWTF00000250283')

#16 Updated by Luc Tran Van about 2 years ago

DECLARE @req_id varchar(20),@date DATETIME
SELECT @req_id = trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000248'
SELECT * FROM PL_PROCESS WHERE REQ_ID = @req_id

Also available in: Atom PDF