Project

General

Profile

Feature #1424

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

0%

Estimated time:
PAY_seach.txt (33.7 KB) PAY_seach.txt Luc Tran Van, 12/20/2022 02:00 PM
SERACH_HOAN_UNG.txt (19.1 KB) SERACH_HOAN_UNG.txt Luc Tran Van, 12/20/2022 05:03 PM
dataTL_SYS_ROLE_MAPPING.txt (1010 KB) dataTL_SYS_ROLE_MAPPING.txt Luc Tran Van, 12/21/2022 07:55 AM
AbpPermissions.7z (295 KB) AbpPermissions.7z Luc Tran Van, 12/21/2022 09:15 AM
TR_ROLE_NOTIFI_ID.txt (105 KB) TR_ROLE_NOTIFI_ID.txt Luc Tran Van, 12/21/2022 09:57 AM
PAY_Search.txt (34.2 KB) PAY_Search.txt Luc Tran Van, 12/22/2022 08:52 AM
DATA_#12_221222.xlsx (11.8 KB) DATA_#12_221222.xlsx Luc Tran Van, 12/22/2022 09:21 AM
chuyển PUR_2022_003199.txt (794 Bytes) chuyển PUR_2022_003199.txt Luc Tran Van, 12/22/2022 09:39 AM
INHACHTOAN_PAY_BanViet.docx (105 KB) INHACHTOAN_PAY_BanViet.docx Luc Tran Van, 12/22/2022 10:04 AM
DATA_#12_v2.xlsx (11.9 KB) DATA_#12_v2.xlsx Luc Tran Van, 12/22/2022 10:48 AM
chuyển PUR_2022_003199.txt (794 Bytes) chuyển PUR_2022_003199.txt Luc Tran Van, 12/22/2022 11:03 AM
TR_REQUEST_DOC_APp.txt (16.3 KB) TR_REQUEST_DOC_APp.txt Luc Tran Van, 12/22/2022 11:03 AM
TR_CHECK_APPR.txt (16.3 KB) TR_CHECK_APPR.txt Luc Tran Van, 12/22/2022 11:04 AM
TR_CHECK_APPR.txt (16.7 KB) TR_CHECK_APPR.txt Luc Tran Van, 12/22/2022 11:29 AM
ALTER_PROC.txt (2.06 KB) ALTER_PROC.txt Luc Tran Van, 12/22/2022 01:43 PM
script_del.txt (783 Bytes) script_del.txt Luc Tran Van, 12/22/2022 02:00 PM
CM_Reject_ins_221222.txt (102 KB) CM_Reject_ins_221222.txt Luc Tran Van, 12/22/2022 04:58 PM
pay_search_231222.txt (34.4 KB) pay_search_231222.txt Luc Tran Van, 12/23/2022 01:49 PM

History

#2 Updated by Luc Tran Van over 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0325/2022/TTr-0690604')
UPDATE PL_REQUEST_DOC SET PROCESS_ID='APPROVE' WHERE REQ_ID=@REQ_ID
DELETE PL_REQUEST_PROCESS WHERE REQ_ID=@REQ_ID AND PROCESS_ID='TKTGD'
DELETE PL_REQUEST_PROCESS WHERE REQ_ID=@REQ_ID AND PROCESS_ID='TGD'
UPDATE PL_REQUEST_PROCESS SET STATUS='C', PARENT_PROCESS_ID ='GDK_TT' WHERE REQ_ID=@REQ_ID AND PROCESS_ID='APPROVE'
EXEC PL_REQ_DOC_UPDATE_AFTER_APPROVE @REQ_ID
EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC @REQ_ID

#3 Updated by Luc Tran Van over 2 years ago

EXEC TR_REQUEST_DOC_Del 'TRRD00000252311','quynhpnk'

#4 Updated by Luc Tran Van over 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0325/2022/TTr-0690604')
UPDATE PL_REQUEST_DOC SET PROCESS_ID='APPROVE' WHERE REQ_ID=@REQ_ID
DELETE PL_REQUEST_PROCESS WHERE REQ_ID=@REQ_ID AND PROCESS_ID='TKHDQT'
DELETE PL_REQUEST_PROCESS WHERE REQ_ID=@REQ_ID AND PROCESS_ID='HDQT'
UPDATE PL_REQUEST_PROCESS SET STATUS='C', PARENT_PROCESS_ID ='GDK_TT' WHERE REQ_ID=@REQ_ID AND PROCESS_ID='APPROVE'
EXEC PL_REQ_DOC_UPDATE_AFTER_APPROVE @REQ_ID
EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC @REQ_ID

#6 Updated by Luc Tran Van over 2 years ago

EXEC dbo.sp_generate_inserts @table_name = 'TL_SYS_ROLE_MAPPING', -- varchar(776)
@from = 'FROM TL_SYS_ROLE_MAPPING' -- varchar(800)

#11 Updated by Luc Tran Van over 2 years ago

UPDATE MW_TRANSFER_DT
SET MW_TRANSFER_DT.COST_ACC = MW_MATERIAL.EXP_ACCTNO
--select Table.col1, other_table.col,Table.col2,other_table.col2, *
FROM MW_TRANSFER_DT
LEFT JOIN MW_MAST_BAL ON MW_TRANSFER_DT.MAST_BAL_ID = MW_MAST_BAL.MAST_BAL_ID
LEFT JOIN MW_MATERIAL ON MW_MAST_BAL.MATERIAL_ID = MW_MATERIAL.MATERIAL_ID
WHERE MW_TRANSFER_DT.TRANSFER_ID = 'MWTF00000250203'

#12 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003199'
SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003199')
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003199')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003199')
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003199')
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003199')
SELECT * FROM PL_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003199')

Also available in: Atom PDF