|
1
|
DELETE FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID='PLRD00000200412'
|
|
2
|
DELETE FROM dbo.PL_PROCESS WHERE REQ_ID='PLRD00000200412'
|
|
3
|
|
|
4
|
UPDATE dbo.PL_TRADEDETAIL SET AMT_APP = AMT_APP + 203775000 WHERE TRADE_ID='PLT000000071040'
|
|
5
|
|
|
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'PLRD00000200412',N'APPNEW',N'P',N'GDDV',N'DV0001',N'hoacq',N'Oct 22 2020 5:10PM',NULL,N'N',NULL,NULL,N'Trưởng đơn vị phê duyệt',NULL,N'DEP000000000015')
|
|
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'PLRD00000200412',N'DVCM',N'P',N'GDDV',N'',N'namdt',N'Oct 22 2020 5:13PM',N'APPNEW',N'N',N'',N'DM0000000000006',N'Phòng kế toán đã phê duyệt',1,NULL)
|
|
8
|
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'PLRD00000200412',N'TC',N'P',N'TC',N'',N'hoattm',N'Oct 22 2020 5:13PM',N'DVCM',N'N',N'',N'',N'Phòng tài chính đã phê duyệt',1,NULL)
|
|
9
|
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'PLRD00000200412',N'GDK_DC',N'P',N'PTGD',N'',N'tupa',N'Oct 22 2020 10:12AM',N'TC',N'N',N'',N'DM0000000000017',N'Giám đốc khối đã phê duyệt',NULL,NULL)
|
|
10
|
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'PLRD00000200412',N'TGD_DC',N'C',N'TGD',N'',N'',NULL,N'GDK_DC',N'',N'',N'',N'Chờ tổng giám đốc phê duyệt',NULL,NULL)
|
|
11
|
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'PLRD00000200412',N'APPROVE',N'U',N'',N'',N'',NULL,N'TGD_DC',N'Y',NULL,NULL,N'Hoàn tất',NULL,NULL)
|
|
12
|
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'PLRD00000200412',N'GDK_DC',N'P',N'GDK',N'',N'cuongpv2',N'Oct 22 2020 10:12AM',N'TC',N'',N'',N'DM0000000000022',N'Giám đốc khối đã phê duyệt',NULL,N'')
|
|
13
|
|
|
14
|
|
|
15
|
INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'SEND',N'tuyentt',N'Oct 22 2020 8:52AM',N'Người tạo tờ trình gửi phê duyệt thành công',N'Nhân viên gửi phê duyệt')
|
|
16
|
INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'APPNEW',N'hoacq',N'Oct 22 2020 5:06PM',N'Phê duyệt',N'Trưởng đơn vị phê duyệt')
|
|
17
|
INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'DVCM',N'namdt',N'Oct 22 2020 5:13PM',N'',N'Trưởng đơn vị đã phê duyệt')
|
|
18
|
INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'TC',N'hoattm',N'Oct 22 2020 5:13PM',N'Phê duyệt',N'Trưởng đơn vị đã phê duyệt')
|
|
19
|
INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'GDK_DC',N'tupa',N'Oct 22 2020 5:17PM',N'',N'Giám đốc khối đã phê duyệt')
|
|
20
|
INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'GDK_DC',N'cuongpv2',N'Oct 22 2020 5:17PM',N'',N'Giám đốc khối đã phê duyệt')
|
|
21
|
|
|
22
|
|
|
23
|
UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='TGD' WHERE REQ_ID='PLRD00000200412'
|
|
24
|
|
|
25
|
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = 'PLRD00000200412', -- varchar(15)
|
|
26
|
@p_AUTH_STATUS = 'A', -- varchar(1)
|
|
27
|
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
|
|
28
|
@p_APPROVE_DT = '2020-10-22 10:12:02', -- datetime
|
|
29
|
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
|
|
30
|
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
|
|
31
|
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)
|
|
32
|
|
|
33
|
|