|
1
|
INSERT INTO [TR_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[PROCESS_ID],[PL_REQ_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[BRANCH_DO],[REQ_REASON],[BRANCH_CREATE],[USER_REQUEST],[BRANCH_DVMS],[USER_DVMS],[DMMS_ID],[DEP_CREATE],[REQ_PARENT_ID],[SIGN_USER])VALUES(N'TRRDIII1124161',N'PUR/2020/00009706',N'Quảng cáo trên Digital Frame',N'2020-08-07',0,N'Quảng cáo trên Digital Frame',N'APPROVE',N'',2000000000,N'',N'1',N'tudt1',N'2020-08-07',N'A',N'',N'2020-09-07',N'DV0001',N'',N'DV0001',N'phuongtln1',N'DV0001',N'cuongvd',N'DMMS00000000001',N'DEP000000000015',N'',N'')
|
|
2
|
INSERT INTO [TR_REQUEST_DOC_DT] ([REQDT_ID],[REQ_DOC_ID],[PL_REQDT_ID],[GD_ID],[SUP_ID],[DESCRIPTION],[TRAN_TYPE_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[AMOUNT_PAID],[INVOICENO],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PRICE_ETM],[TOTAL_AMT_ETM],[REQ_DT],[AMORT_MONTH],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[DVDM_ID],[BID_ID],[OFFERING_VALUE],[NOTE_DVMS],[PO_ID],[PO_AMT])VALUES(N'TRRDDII1124784',N'TRRDIII1124161',N'',N'',N'CMS000000251411',N'Chi phí quảng cáo Digital frame tại TP.HCM',N'TRN0000000003',1,2000000000.00,2000000000.00,NULL,N'',N'',N'1',N'phuongtln1',N'2020-09-07',N'A',N'',N'2020-09-07',2000000000.00,2000000000.00,N'2020-09-07',NULL,N'HH0000000112274',N'VND',1.00,0.00,N'',N'',NULL,N'',N'',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'TRRDIII1124161',N'DMMS',N'P',N'GDDV',N'',N'phuongtln1',N'2020-07-09',N'',N'',N'',N'',N'Phê duyệt',NULL,N'')
|
|
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'TRRDIII1124161',N'APPROVE',N'C',N'',N'',N'',NULL,N'',N'',N'',N'',N'Hoàn tất',NULL,N'')
|
|
5
|
|
|
6
|
DECLARE @PL_ID INT
|
|
7
|
SET @PL_ID = (SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID='TRRDIII1124161' AND PROCESS_ID='DMMS')
|
|
8
|
|
|
9
|
INSERT dbo.PL_REQUEST_PROCESS_CHILD
|
|
10
|
(
|
|
11
|
REQ_ID,
|
|
12
|
PROCESS_ID,
|
|
13
|
TLNAME,
|
|
14
|
TYPE_JOB,
|
|
15
|
LEVEL_JOB,
|
|
16
|
STATUS_JOB,
|
|
17
|
RECORD_STATUS,
|
|
18
|
MAKER_ID,
|
|
19
|
TRANFER_DT
|
|
20
|
)
|
|
21
|
VALUES
|
|
22
|
( 'TRRDIII1124161', -- REQ_ID - varchar(20)
|
|
23
|
@PL_ID, -- PROCESS_ID - varchar(20)
|
|
24
|
'phuongtln1', -- TLNAME - varchar(50)
|
|
25
|
'TP', -- TYPE_JOB - varchar(50)
|
|
26
|
1, -- LEVEL_JOB - int
|
|
27
|
'P', -- STATUS_JOB - varchar(10)
|
|
28
|
'1', -- RECORD_STATUS - varchar(15)
|
|
29
|
'', -- MAKER_ID - varchar(15)
|
|
30
|
GETDATE() -- TRANFER_DT - datetime
|
|
31
|
)
|
|
32
|
INSERT dbo.PL_REQUEST_PROCESS_CHILD
|
|
33
|
(
|
|
34
|
REQ_ID,
|
|
35
|
PROCESS_ID,
|
|
36
|
TLNAME,
|
|
37
|
TYPE_JOB,
|
|
38
|
LEVEL_JOB,
|
|
39
|
STATUS_JOB,
|
|
40
|
RECORD_STATUS,
|
|
41
|
MAKER_ID,
|
|
42
|
TRANFER_DT
|
|
43
|
)
|
|
44
|
VALUES
|
|
45
|
( 'TRRDIII1124161', -- REQ_ID - varchar(20)
|
|
46
|
@PL_ID, -- PROCESS_ID - varchar(20)
|
|
47
|
'vanpt2', -- TLNAME - varchar(50)
|
|
48
|
'KS', -- TYPE_JOB - varchar(50)
|
|
49
|
2, -- LEVEL_JOB - int
|
|
50
|
'P', -- STATUS_JOB - varchar(10)
|
|
51
|
'1', -- RECORD_STATUS - varchar(15)
|
|
52
|
'', -- MAKER_ID - varchar(15)
|
|
53
|
GETDATE() -- TRANFER_DT - datetime
|
|
54
|
)
|
|
55
|
INSERT dbo.PL_REQUEST_PROCESS_CHILD
|
|
56
|
(
|
|
57
|
REQ_ID,
|
|
58
|
PROCESS_ID,
|
|
59
|
TLNAME,
|
|
60
|
TYPE_JOB,
|
|
61
|
LEVEL_JOB,
|
|
62
|
STATUS_JOB,
|
|
63
|
RECORD_STATUS,
|
|
64
|
MAKER_ID,
|
|
65
|
TRANFER_DT
|
|
66
|
)
|
|
67
|
VALUES
|
|
68
|
( 'TRRDIII1124161', -- REQ_ID - varchar(20)
|
|
69
|
@PL_ID, -- PROCESS_ID - varchar(20)
|
|
70
|
'cuongvd', -- TLNAME - varchar(50)
|
|
71
|
'XL', -- TYPE_JOB - varchar(50)
|
|
72
|
3, -- LEVEL_JOB - int
|
|
73
|
'P', -- STATUS_JOB - varchar(10)
|
|
74
|
'1', -- RECORD_STATUS - varchar(15)
|
|
75
|
'', -- MAKER_ID - varchar(15)
|
|
76
|
GETDATE() -- TRANFER_DT - datetime
|
|
77
|
)
|