Project

General

Profile

Feature #1382

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

0%

Estimated time:
1.0 NF GET MESSAGE CONTENT.txt (104 KB) 1.0 NF GET MESSAGE CONTENT.txt Luc Tran Van, 10/18/2022 11:16 PM
2.0 NOTIFY BY ID.txt (80.8 KB) 2.0 NOTIFY BY ID.txt Luc Tran Van, 10/18/2022 11:16 PM
2.1. PL_REQUEST_DOC_-APPR.txt (50.4 KB) 2.1. PL_REQUEST_DOC_-APPR.txt Luc Tran Van, 10/19/2022 12:13 AM
2.2. GET DATA.txt (1.22 KB) 2.2. GET DATA.txt Luc Tran Van, 10/19/2022 12:15 AM
NF_MESSAGE_GetContent_v2.txt (104 KB) NF_MESSAGE_GetContent_v2.txt Luc Tran Van, 10/19/2022 06:30 AM
Downloads.zip (45.1 KB) Downloads.zip Luc Tran Van, 10/19/2022 07:32 AM
2.2. GET DATA.txt.xlsx (2.44 MB) 2.2. GET DATA.txt.xlsx Luc Tran Van, 10/19/2022 08:53 AM
2.4.TL USER SEARCH.txt (15 KB) 2.4.TL USER SEARCH.txt Luc Tran Van, 10/19/2022 09:29 AM
2.5. GET DATA.txt.xlsx (19.2 KB) 2.5. GET DATA.txt.xlsx Luc Tran Van, 10/19/2022 10:16 AM
2.5 TR_REQ_PAYMENT UPD.txt (100 KB) 2.5 TR_REQ_PAYMENT UPD.txt Luc Tran Van, 10/19/2022 10:28 AM
TR_CONTRACT_Search.txt (28.2 KB) TR_CONTRACT_Search.txt Luc Tran Van, 10/19/2022 10:52 AM
2.6 TR_REQ_PAYMENT UPD.txt (101 KB) 2.6 TR_REQ_PAYMENT UPD.txt Luc Tran Van, 10/19/2022 10:56 AM
2.8 TR_REQ_PAYMENT_SEARCH - FIX CHO PHONG BAN CHA THAY PHIEU PHONG BAN CON.txt (30.5 KB) 2.8 TR_REQ_PAYMENT_SEARCH - FIX CHO PHONG BAN CHA THAY PHIEU PHONG BAN CON.txt Luc Tran Van, 10/19/2022 11:03 AM
TL_SYS_ROLE_MAPPING.txt (1.38 MB) TL_SYS_ROLE_MAPPING.txt Luc Tran Van, 10/19/2022 11:13 AM
FIX DEP_ID.txt (2.49 KB) FIX DEP_ID.txt Luc Tran Van, 10/19/2022 11:14 AM
TR_REQ_ADVANCE_PAYMENT_Search.txt (48.8 KB) TR_REQ_ADVANCE_PAYMENT_Search.txt Luc Tran Van, 10/19/2022 02:03 PM
TR_REQ_ADVANCE_PAYMENT_Search.txt (49.1 KB) TR_REQ_ADVANCE_PAYMENT_Search.txt Luc Tran Van, 10/19/2022 02:18 PM
DATA.xlsx (11.9 KB) DATA.xlsx Luc Tran Van, 10/19/2022 02:47 PM
PL_REQUEST_DOC_ById.txt (6.07 KB) PL_REQUEST_DOC_ById.txt Luc Tran Van, 10/19/2022 02:48 PM
2.9 NF MESSAGE GETCONTENT.txt (109 KB) 2.9 NF MESSAGE GETCONTENT.txt Luc Tran Van, 10/19/2022 02:54 PM
2.10 . TR ROLE NOTITY BYID.txt (80.8 KB) 2.10 . TR ROLE NOTITY BYID.txt Luc Tran Van, 10/19/2022 03:20 PM
DATA_v2.xlsx (11.6 KB) DATA_v2.xlsx Luc Tran Van, 10/19/2022 03:34 PM
2.12. TR ROLE NOTITY BYID.txt (80.8 KB) 2.12. TR ROLE NOTITY BYID.txt Luc Tran Van, 10/19/2022 03:41 PM
PL_REQUEST_DOC_Search.txt (78.7 KB) PL_REQUEST_DOC_Search.txt Luc Tran Van, 10/19/2022 04:35 PM
Downloads.zip (44.9 KB) Downloads.zip Luc Tran Van, 10/20/2022 07:49 AM

History

#3 Updated by Luc Tran Van over 2 years ago

Tất cả các quyền phải được thấy Trang chủ

#4 Updated by Luc Tran Van over 2 years ago

Màn hình Tờ trình chủ trương DVCM/DVDC:
Nếu RoleName của UserLogin là KSV, TP, TPTC, GDDV, PP, TC thì Trạng thái duyệt là : Chờ trưởng phòng phê duyệt
Nếu........................ là GDV, NVMS, NVTT, NVTC ------------------------------: Chờ nhân viên xử lý
Nếu........................ là TBP ------------------------------: Chờ KSV phê duyệt
Ngược lại là Tất cả

#5 Updated by Luc Tran Van over 2 years ago

Tại hàm trả về cho người tạo / trả về cho người xử lý sẽ gắn Gửi mail.
TYPE_FUNCTION
TYPE_REJECT
ID

#6 Updated by Luc Tran Van over 2 years ago

5. Tại Hàm Duyệt tờ trình ở cấp đơn vị chưa gắn gửi mail

#11 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQ_ADVANCE_DT WHERE REF_ID ='TRC000000251385'
SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_DT WHERE REF_ID ='TRC000000251385')

#21 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0030/2022/TTr-0692205'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205568'

#22 Updated by Luc Tran Van over 2 years ago

#24 Updated by Luc Tran Van over 2 years ago

  • File 2.9 NF MESSAGE GETCONTENT.txt added

#25 Updated by Luc Tran Van over 2 years ago

  • File deleted (2.9 NF MESSAGE GETCONTENT.txt)

#27 Updated by Luc Tran Van over 2 years ago

[dbo].[TR_ROLE_NOTIFI_ID] 'PLRD00000205568','REQUEST_DOC_PROCESS_Approve'

#29 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TL_USER WHERE TLNANME ='trungnq1'

#30 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0030/2022/TTr-0692205'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205568'

#33 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TL_SYS_ROLE_MAPPING WHERE TLNAME ='khanhtx'

Also available in: Atom PDF