Project

General

Profile

Feature #1490

VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 07.04.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:
04/07/2023
Due date:
% Done:

0%

Estimated time:
PushCore.txt (1023 Bytes) PushCore.txt Luc Tran Van, 04/07/2023 10:13 AM
DATA_CONTRACT.xlsx (14 KB) DATA_CONTRACT.xlsx Luc Tran Van, 04/07/2023 11:45 AM
rpt_tr_req_driveDT.xlsx (13 KB) rpt_tr_req_driveDT.xlsx Luc Tran Van, 04/07/2023 11:48 AM
TR_REQUEST_DOC_DVMS_Upd.txt (20.3 KB) TR_REQUEST_DOC_DVMS_Upd.txt Luc Tran Van, 04/07/2023 02:25 PM
TR_REQUEST_DOC_Ins.txt (19.5 KB) TR_REQUEST_DOC_Ins.txt Luc Tran Van, 04/07/2023 02:25 PM
TR_REQUEST_DOC_Upd.txt (20 KB) TR_REQUEST_DOC_Upd.txt Luc Tran Van, 04/07/2023 02:25 PM
DATA_TTCT_0009.xlsx (22.9 KB) DATA_TTCT_0009.xlsx Luc Tran Van, 04/07/2023 02:49 PM
DATA_TTCT_0016_2023_TTr0690604.xlsx (24.4 KB) DATA_TTCT_0016_2023_TTr0690604.xlsx Luc Tran Van, 04/07/2023 02:58 PM
DATA_TTCT_0014_2023_TTr0690604.xlsx (19.2 KB) DATA_TTCT_0014_2023_TTr0690604.xlsx Luc Tran Van, 04/07/2023 02:58 PM
DATA_TTCT_0116.xlsx (25 KB) DATA_TTCT_0116.xlsx Luc Tran Van, 04/07/2023 03:12 PM
DATA_TTCT_0114.xlsx (25.4 KB) DATA_TTCT_0114.xlsx Luc Tran Van, 04/07/2023 03:12 PM
Script_070423.zip (293 KB) Script_070423.zip Luc Tran Van, 04/07/2023 03:19 PM
DATA_TTCT_0003.xlsx (24.3 KB) DATA_TTCT_0003.xlsx Luc Tran Van, 04/07/2023 03:39 PM
T10.txt (6.41 KB) T10.txt Luc Tran Van, 04/07/2023 03:43 PM
KPI_THANHTOANTAMUNG_T03_2023.xlsx (233 KB) KPI_THANHTOANTAMUNG_T03_2023.xlsx Luc Tran Van, 04/07/2023 03:57 PM
KPI_THANHQUYETTOAN_T03_2023.xlsx (420 KB) KPI_THANHQUYETTOAN_T03_2023.xlsx Luc Tran Van, 04/07/2023 04:33 PM
upd_UAT.txt (3.23 KB) upd_UAT.txt Luc Tran Van, 04/10/2023 09:30 AM
upd_LIVE.txt (3.23 KB) upd_LIVE.txt Luc Tran Van, 04/10/2023 09:30 AM

History

#1 Updated by Luc Tran Van about 2 years ago

  • Subject changed from VẬN HÀNH SAU GOLIVE NGÀY 07.04.2023 to VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 07.04.2023

#2 Updated by Luc Tran Van about 2 years ago

G0br@Nd!ng123#

#4 Updated by Luc Tran Van about 2 years ago

DECLARE @ID VARCHAR
select @ID=REQ_ID FROM TR_REQUEST_CAR WHERE REQ_ID='AFT-23-000033'
exec TR_REQUEST_JOB_FORM_PROCESS_Upd @p_REQ_ID=@ID,@p_TYPE_PROCESS=N'SEND',@p_MAKERID=N'khoahd',@p_CHECKER_ID=N'khoahd',@p_APPROVE_DT=N'07/04/2023 10:54:23',@p_NOTES=NULL,@p_AUTH_STATUS=NULL

#6 Updated by Luc Tran Van about 2 years ago

SELECT tu.RoleName FROM TL_USER tu WHERE tu.TLNANME='tuvm'
SELECT * FROM CM_EMPLOYEE_LOG cel WHERE cel.USER_DOMAIN='tuvm'
SELECT * FROM TL_SYS_ROLE_MAPPING tsrm WHERE tsrm.TLNAME='tuvm'

#8 Updated by Luc Tran Van about 2 years ago

ALTER TABLE TR_REQUEST_DOC_DT
ALTER COLUMN [DESCRIPTION] NVARCHAR

#10 Updated by Luc Tran Van about 2 years ago

SELECT ar.DisplayName FROM AbpUserRoles aur LEFT JOIN AbpRoles ar ON aur.RoleId=ar.Id WHERE aur.UserId=(SELECT ID FROM TL_USER tu WHERE tu.TLNANME='tuvm')

#14 Updated by Luc Tran Van about 2 years ago

UPDATE PL_REQUEST_DOC SET EFFEC_DT ='2023-04-07T12:45:29', PROCESS_ID='APPROVE' WHERE REQ_ID='PLRD00000206905'
EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC 'PLRD00000206905'

#17 Updated by Luc Tran Van about 2 years ago

Also available in: Atom PDF