Project

General

Profile

Feature #1383

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

0%

Estimated time:

Description

1- Cập nhật quyền PP bỏ Module Quản trị hệ thống, bổ sung chức năng Duyệt ở màn hình điều phối công việc thuộc Module QL Kế Hoạch

1.0 PL REQUEST DOC APPR.txt (50.4 KB) 1.0 PL REQUEST DOC APPR.txt Luc Tran Van, 10/19/2022 11:32 PM
2.1 PL REQ PROCESS CHILD APPR.txt (41.2 KB) 2.1 PL REQ PROCESS CHILD APPR.txt Luc Tran Van, 10/19/2022 11:32 PM
2.0 NF GET MESSAGE CONTENT.txt (111 KB) 2.0 NF GET MESSAGE CONTENT.txt Luc Tran Van, 10/19/2022 11:38 PM
2.4. SETUP IS HAS CHILD DVDM_DC.txt (347 Bytes) 2.4. SETUP IS HAS CHILD DVDM_DC.txt Luc Tran Van, 10/19/2022 11:43 PM
2.4. SETUP IS HAS CHILD DVDM_DC.txt (347 Bytes) 2.4. SETUP IS HAS CHILD DVDM_DC.txt Luc Tran Van, 10/19/2022 11:50 PM
2.5. SETUP IS HAS CHILD DVDM_DC TTDC NHO HON 10 TR VND.txt (346 Bytes) 2.5. SETUP IS HAS CHILD DVDM_DC TTDC NHO HON 10 TR VND.txt Luc Tran Van, 10/19/2022 11:50 PM
NF_MESSAGE_GetContent.txt (127 KB) NF_MESSAGE_GetContent.txt Luc Tran Van, 10/20/2022 09:11 AM
TL_SYS_ROLE_MAPPING_Sync.txt (1.17 KB) TL_SYS_ROLE_MAPPING_Sync.txt Luc Tran Van, 10/20/2022 09:32 AM
PL_REQUEST_TRANSFER_DT_ByID.txt (15.4 KB) PL_REQUEST_TRANSFER_DT_ByID.txt Luc Tran Van, 10/20/2022 10:31 AM
WebSiteLogs (17).zip (660 KB) WebSiteLogs (17).zip Luc Tran Van, 10/20/2022 10:33 AM
rpt_PL_REQUEST_DOC_DT_ById.txt (25 KB) rpt_PL_REQUEST_DOC_DT_ById.txt Luc Tran Van, 10/20/2022 10:48 AM
NF_MESSAGE_GetContent.txt (127 KB) NF_MESSAGE_GetContent.txt Luc Tran Van, 10/20/2022 10:55 AM
TR_REQ_PAYMENT_KT_UPD_201022.txt (34.2 KB) TR_REQ_PAYMENT_KT_UPD_201022.txt Luc Tran Van, 10/20/2022 01:22 PM
TR_CONTRACT_Search.txt (28.4 KB) TR_CONTRACT_Search.txt Luc Tran Van, 10/20/2022 02:17 PM
PL_REQUEST_DOC_ById_Report.txt (20.7 KB) PL_REQUEST_DOC_ById_Report.txt Luc Tran Van, 10/20/2022 02:43 PM
TO_TRINH_CHU_TRUONG.docx (59.7 KB) TO_TRINH_CHU_TRUONG.docx Luc Tran Van, 10/20/2022 02:45 PM
2.6 TL SYS ROLE LIMIT AUTO.txt (5.19 KB) 2.6 TL SYS ROLE LIMIT AUTO.txt Luc Tran Van, 10/20/2022 02:59 PM
TR_REQ_PROCESS_CHILD_Ins.txt (7.24 KB) TR_REQ_PROCESS_CHILD_Ins.txt Luc Tran Van, 10/20/2022 03:15 PM
CM_BRANCH_Ins.txt (2.36 KB) CM_BRANCH_Ins.txt Luc Tran Van, 10/20/2022 03:24 PM
CM_BRANCH_Upd.txt (2.85 KB) CM_BRANCH_Upd.txt Luc Tran Van, 10/20/2022 03:24 PM
TL_SYS_ROLE_MAPPINGbk.txt (1.38 MB) TL_SYS_ROLE_MAPPINGbk.txt Luc Tran Van, 10/20/2022 04:50 PM
AbpUserRolesbk.txt (601 KB) AbpUserRolesbk.txt Luc Tran Van, 10/20/2022 04:50 PM
TL_USERbk.7z (169 KB) TL_USERbk.7z Luc Tran Van, 10/20/2022 04:51 PM
2.8 LUI NGAY TTCT.txt (564 Bytes) 2.8 LUI NGAY TTCT.txt Luc Tran Van, 10/20/2022 05:23 PM
WebSiteLogs (20).zip (662 KB) WebSiteLogs (20).zip Luc Tran Van, 10/21/2022 10:37 AM

History

#2 Updated by Luc Tran Van over 2 years ago

  • File deleted (2.0 NF GET MESSAGE CONTENT.txt)

#4 Updated by Luc Tran Van over 2 years ago

Màn hình Tờ trình chủ trương - DVCM/DVDC: Bấm đúp chuột ra Open new tab OK, nhưng nhấp xem chi tiết lại không vào được màn hình Xem chi tiết.

#9 Updated by Luc Tran Van over 2 years ago

UPDATE TL_SYS_ROLE_MAPPING SET EFF_DATE ='Jan 1 1900 12:00AM', EXP_DATE ='Jan 1 2300 12:00AM' WHERE TLNAME = 'tuanva'

#11 Updated by Luc Tran Van over 2 years ago

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205294' AND PROCESS_ID ='DVDM_DC'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', PARENT_PROCESS_ID ='DVCM' WHERE REQ_ID ='PLRD00000205294' AND PROCESS_ID ='TC'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TC' WHERE REQ_ID ='PLRD00000205294'

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205530' AND PROCESS_ID ='DVDM_DC'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', PARENT_PROCESS_ID ='DVCM' WHERE REQ_ID ='PLRD00000205530' AND PROCESS_ID ='TC'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TC' WHERE REQ_ID ='PLRD00000205530'

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205572' AND PROCESS_ID ='DVDM_DC'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', PARENT_PROCESS_ID ='DVCM' WHERE REQ_ID ='PLRD00000205572' AND PROCESS_ID ='TC'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TC' WHERE REQ_ID ='PLRD00000205572'

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205587' AND PROCESS_ID ='DVDM_DC'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', PARENT_PROCESS_ID ='DVCM' WHERE REQ_ID ='PLRD00000205587' AND PROCESS_ID ='TC'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TC' WHERE REQ_ID ='PLRD00000205587'

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205622' AND PROCESS_ID ='DVDM_DC'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', PARENT_PROCESS_ID ='DVCM' WHERE REQ_ID ='PLRD00000205622' AND PROCESS_ID ='TC'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TC' WHERE REQ_ID ='PLRD00000205622'

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205656' AND PROCESS_ID ='DVDM_DC'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', PARENT_PROCESS_ID ='DVCM' WHERE REQ_ID ='PLRD00000205656' AND PROCESS_ID ='TC'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TC' WHERE REQ_ID ='PLRD00000205656'

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205664' AND PROCESS_ID ='DVDM_DC'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', PARENT_PROCESS_ID ='DVCM' WHERE REQ_ID ='PLRD00000205664' AND PROCESS_ID ='TC'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TC' WHERE REQ_ID ='PLRD00000205664'

#18 Updated by Luc Tran Van over 2 years ago

DELETE FROM PL_REQUEST_PROCESS WHERE ID ='76082'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TGD' WHERE REQ_ID ='PLRD00000205578'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE REQ_ID ='PLRD00000205578' AND PROCESS_ID ='TGD'

#22 Updated by Luc Tran Van over 2 years ago

SELECT * FROM CM_BRANCH WHERE BRANCH_ID NOT IN (SELECT BRANCH_ID FROM CM_DMMS)

#23 Updated by Luc Tran Van over 2 years ago

EXEC [TL_SYSROLE_LIMIT_Auto] '','DVKD'

#24 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_PROCESS SET SUB_PROCESS_ID='DVCM', DVDM_ID='', BRANCH_ID='DV0001', DEP_ID ='DEP000000000012', PROCESS_ID='DVDC' WHERE ID='75717'
UPDATE PL_REQUEST_DOC SET PROCESS_ID='DVDC' WHERE REQ_ID='PLRD00000205638

#27 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_PROCESS SET SUB_PROCESS_ID='DVDC', DVDM_ID='DM0000000000001', BRANCH_ID='', DEP_ID ='', PROCESS_ID='DVCM' WHERE ID='75717'
UPDATE PL_REQUEST_DOC SET PROCESS_ID='DVCM' WHERE REQ_ID='PLRD00000205638'

#28 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/002592'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/002592')

SELECT * FROM CM_DEPARTMENT WHERE DEP_ID IN (SELECT DEP_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/002592')

SELECT * FROM CM_DVDM WHERE DVDM_CODE IN (SELECT DEP_CODE FROM CM_DEPARTMENT WHERE DEP_ID IN (SELECT DEP_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/002592'))

#32 Updated by Luc Tran Van over 2 years ago

INSERT INTO PL_ROLE_DATA_CONFIG VALUES ('PL_REQUEST_DOC_ALL','thanhltp','')
SELECT * FROM PL_ROLE_DATA_CONFIG WHERE BRANCH_ID ='thanhltp'

Also available in: Atom PDF