|
1
|
INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200424',N'APPNEW',N'P',N'GDDV',N'DV0001',N'thanhnt',N'Oct 26 2020 1:10PM',NULL,N'N',NULL,NULL,N'Trưởng đơn vị phê duyệt',NULL,N'DEP000000000062')
|
|
2
|
INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200424',N'DVCM',N'P',N'GDDV',N'',N'hungnt4',N'Oct 26 2020 1:22PM',N'APPNEW',N'N',N'',N'DM0000000000001',N'Phòng kế toán đã phê duyệt',1,NULL)
|
|
3
|
INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200424',N'GDK_TT',N'P',N'GDK',N'',N'nhannt',N'Oct 26 2020 6:32AM',N'TC',N'N',N'',N'DM0000000000023',N'Giám đốc khối đã phê duyệt',0,NULL)
|
|
4
|
INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200424',N'PTGDK_TT',N'P',N'PTGD',N'',N'tupa',N'Oct 26 2020 6:32AM',N'GDK_TT',N'N',N'',N'DM0000000000017',N'Phó tổng giám đốc khối đã phê duyệt',0,NULL)
|
|
5
|
INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200424',N'TGD',N'C',N'TGD',N'',N'',NULL,N'PTGDK_TT',N'N',N'',N'',N'Chờ tổng giám đốc xác nhận',0,NULL)
|
|
6
|
INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200424',N'APPROVE',N'U',N'',N'',N'',NULL,N'TGD',N'Y',NULL,NULL,N'Hoàn tất',NULL,NULL)
|
|
7
|
INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200424',N'TC',N'P',N'TC',N'',N'hoattm',N'Oct 26 2020 1:30PM',N'DVCM',N'N',N'',N'',N'Phòng tài chính đã phê duyệt',0,NULL)
|
|
8
|
|
|
9
|
UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='TGD' WHERE REQ_ID='PLRD00000200424'
|
|
10
|
|
|
11
|
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = 'PLRD00000200424', -- varchar(15)
|
|
12
|
@p_AUTH_STATUS = 'A', -- varchar(1)
|
|
13
|
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
|
|
14
|
@p_APPROVE_DT = '2020-10-26 06:32:14', -- datetime
|
|
15
|
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
|
|
16
|
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
|
|
17
|
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)
|