Project

General

Profile

Feature #1426

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

0%

Estimated time:
1.0 LUI NGAY TTCT.txt (651 Bytes) 1.0 LUI NGAY TTCT.txt Luc Tran Van, 12/23/2022 04:19 PM
1.0 LUI NGAY TTCT - LẦN 2.txt (561 Bytes) 1.0 LUI NGAY TTCT - LẦN 2.txt Luc Tran Van, 12/23/2022 04:20 PM
BOLECHCHAYKH.txt (265 Bytes) BOLECHCHAYKH.txt Luc Tran Van, 12/23/2022 05:48 PM

History

#1 Updated by Luc Tran Van over 2 years ago

DECLARE @REQ_ID VARCHAR, @DATE DATETIME
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0369/2022/TTr-0690604')
SET @DATE='2022-06-23 12:00:00 AM'
UPDATE PL_REQUEST_DOC SET REQ_DT =@DATE, APPROVE_DT =@DATE, EFFEC_DT =@DATE, IS_BACKDAY=1 WHERE REQ_ID =@REQ_ID
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID
INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT)
VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày',N'Hỗ trợ lùi ngày chủ trương theo yêu cầu','trint1',GETDATE)

#5 Updated by Luc Tran Van over 2 years ago

INSERT INTO [TL_USER] ([ID],[TLID],[TLNANME],[Password],[TLFullName],[TLSUBBRID],[BRANCH_NAME],[BRANCH_TYPE],[RoleName],[EMAIL],[ADDRESS],[PHONE],[AUTH_STATUS],[MARKER_ID],[AUTH_ID],[APPROVE_DT],[ISAPPROVE],[Birthday],[ISFIRSTTIME],[SECUR_CODE],[AccessFailedCount],[AuthenticationSource],[ConcurrencyStamp],[CreatorUserId],[DeleterUserId],[EmailAddress],[EmailConfirmationCode],[IsActive],[IsDeleted],[IsEmailConfirmed],[IsLockoutEnabled],[IsPhoneNumberConfirmed],[IsTwoFactorEnabled],[LastModifierUserId],[LockoutEndDateUtc],[Name],[NormalizedEmailAddress],[NormalizedUserName],[PasswordResetCode],[PhoneNumber],[ProfilePictureId],[SecurityStamp],[ShouldChangePasswordOnNextLogin],[Surname],[TenantId],[SignInToken],[SignInTokenExpireTimeUtc],[GoogleAuthenticatorKey],[SendActivationEmail],[DEP_ID],[CreationTime],[UamFullName],[UamEmployeeId],[UamCompanyCode],[UamWfDataId],[UamCompanyName],[UamJobTitle])VALUES(4008,NULL,N'admin',N'd41d8cd98f00b204e9800998ecf8427e',N'Administrator',N'DV0001',N'Hội sở',N'HS',N'DISABLE',N'',N'',N'',N'A',N'tscd_hoiso',NULL,N'Jan 1 1900 12:00AM',N'1',N'Jan 1 1900 12:00AM',N'1',NULL,0,NULL,N'1360eb6c-4581-4870-aaf7-a2986428b91d',NULL,NULL,N'DISABLE',NULL,1,0,1,0,1,0,810,NULL,NULL,N'',N'ADMIN',NULL,NULL,NULL,N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB',1,NULL,1,NULL,NULL,NULL,0,NULL,N'Jul 4 2021 11:22AM',NULL,NULL,NULL,NULL,NULL,NULL)

Also available in: Atom PDF