Project

General

Profile

Feature #1418

VẬN HÀNH SAU GOLIVE NGÀY 09-12-2022

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

Status:
New
Priority:
Normal
Assignee:
-
Start date:
12/09/2022
Due date:
% Done:

0%

Estimated time:
DATA_TTCT_0337.xlsx (25.3 KB) DATA_TTCT_0337.xlsx Luc Tran Van, 12/09/2022 09:27 AM
TR_ADVANCE_DT_BYID.txt (2.15 KB) TR_ADVANCE_DT_BYID.txt Luc Tran Van, 12/09/2022 10:13 AM
DATA_TTCT_0367.xlsx (29.2 KB) DATA_TTCT_0367.xlsx Luc Tran Van, 12/09/2022 10:18 AM
DATA_#4.xlsx (10.3 KB) DATA_#4.xlsx Luc Tran Van, 12/09/2022 10:30 AM
1.0 NF MESSAGE GETCONTENT.txt (141 KB) 1.0 NF MESSAGE GETCONTENT.txt Luc Tran Van, 12/09/2022 10:41 AM
DATA_TTCT_0365.xlsx (25.3 KB) DATA_TTCT_0365.xlsx Luc Tran Van, 12/09/2022 10:51 AM
CM_REJECT_LOG_Ins_091222.txt (102 KB) CM_REJECT_LOG_Ins_091222.txt Luc Tran Van, 12/09/2022 02:08 PM
Permission_09122.txt (3.13 MB) Permission_09122.txt Luc Tran Van, 12/09/2022 03:25 PM
Permission_09122.txt (3.91 MB) Permission_09122.txt Luc Tran Van, 12/09/2022 03:50 PM
Permission_09122_2.txt (3.8 MB) Permission_09122_2.txt Luc Tran Van, 12/09/2022 03:50 PM
DATA_AbpRoles_091222.txt (42 KB) DATA_AbpRoles_091222.txt Luc Tran Van, 12/09/2022 05:26 PM
AbpUserRoles_091222.txt (631 KB) AbpUserRoles_091222.txt Luc Tran Van, 12/09/2022 05:26 PM
DATA_SYS_ROLE_MAPPING.txt (997 KB) DATA_SYS_ROLE_MAPPING.txt Luc Tran Van, 12/09/2022 05:26 PM

History

#4 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_DOC SET PROCESS_ID = 'TC' WHERE REQ_ID = 'PLRD00000205976'
EXEC PL_REQUEST_DOC_ById @p_REQ_ID = 'PLRD00000205976'
,@p_USER_LOGIN = 'hoattm'

#6 Updated by Luc Tran Van over 2 years ago

EXEC PL_REQ_PROCESS_CHILD_App @p_REQ_ID = 'PLRD00000205976'
,@p_PROCESS_ID = 'TC'
,@p_TLNAME = 'hoattm'
,@p_MAKER_ID = 'hoattm'
,@p_TYPE_JOB = 'TP'
,@p_PROCESS_DES = N'Phê duyệt'
,@p_REF_ID = 85234
,@p_IS_AUTHORITY = 0

#7 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 ='0365/2022/TTr-0690604')
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)
@p_AUTH_STATUS = 'A', -- varchar(1)
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
@p_APPROVE_DT = '09/12/2022', -- datetime
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)

#10 Updated by Luc Tran Van over 2 years ago

DELETE FROM PL_REQUEST_PROCESS WHERE ID='83815'
DELETE FROM PL_REQUEST_PROCESS WHERE ID='83816'
UPDATE PL_REQUEST_PROCESS SET STATUS='C', PARENT_PROCESS_ID='GDK_TT' WHERE ID='83817'
UPDATE PL_REQUEST_DOC SET PROCESS_ID='APPROVE' WHERE REQ_ID='PLRD00000205929'
EXEC PL_REQ_DOC_UPDATE_AFTER_APPROVE 'PLRD00000205929'
EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC 'PLRD00000205929'

#12 Updated by Luc Tran Van over 2 years ago

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

#15 Updated by Luc Tran Van over 2 years ago

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

Also available in: Atom PDF