Support #814: Phê duyệt cấp TGĐ cho 3 tờ trình đính kèm - DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT - Redmine

Support #814

Phê duyệt cấp TGĐ cho 3 tờ trình đính kèm

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

Status:

Closed

Priority:

Normal

Assignee:

Luc Tran Van

Start date:

01/07/2021

Due date:

% Done:

Estimated time:

To Trinh PGD Ha Tien.pdf (1.77 MB) To Trinh PGD Ha Tien.pdf		Luc Tran Van, 01/07/2021 03:21 PM
To Trinh PGD Ngo Quyen.pdf (1.83 MB) To Trinh PGD Ngo Quyen.pdf		Luc Tran Van, 01/07/2021 03:21 PM
To Trinh PGD Tan Thanh.pdf (1.66 MB) To Trinh PGD Tan Thanh.pdf		Luc Tran Van, 01/07/2021 03:21 PM
Data TTCT 0141 0144 0149 0690604.xlsx (57.3 KB) Data TTCT 0141 0144 0149 0690604.xlsx		Luc Tran Van, 01/07/2021 04:08 PM
07012021 FILE 5.0 CONFIG THANH TOAN.txt (53.2 KB) 07012021 FILE 5.0 CONFIG THANH TOAN.txt		Luc Tran Van, 01/07/2021 05:26 PM
07012021 FILE 6.0 CONFIG THANH TOAN.txt (53 KB) 07012021 FILE 6.0 CONFIG THANH TOAN.txt		Luc Tran Van, 01/07/2021 05:48 PM

History

#1 Updated by Luc Tran Van over 4 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID = (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0141/2020/TTr-0690604')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID

SET @REQ_ID = (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0144/2020/TTr-0690604')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID

SET @REQ_ID = (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0149/2020/TTr-0690604')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID

#2 Updated by Luc Tran Van over 4 years ago

File Data TTCT 0141 0144 0149 0690604.xlsx Data TTCT 0141 0144 0149 0690604.xlsx added

#3 Updated by Luc Tran Van over 4 years ago

EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = 'PLRD00000200894', -- varchar(15)
@p_AUTH_STATUS = 'A', -- varchar(1)
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
@p_APPROVE_DT = '2021-01-07 14:30:56 PM', -- datetime
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)

EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = 'PLRD00000200941', -- varchar(15)
@p_AUTH_STATUS = 'A', -- varchar(1)
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
@p_APPROVE_DT = '2021-01-07 14:30:56 PM', -- datetime
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)

EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = 'PLRD00000200965', -- varchar(15)
@p_AUTH_STATUS = 'A', -- varchar(1)
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
@p_APPROVE_DT = '2021-01-07 14:30:56 PM', -- datetime
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)