|
1
|
ALTER PROCEDURE [dbo].[TR_ROLE_NOTIFI_ID]
|
|
2
|
@PO_ID varchar(500),
|
|
3
|
@TYPE VARCHAR(100)
|
|
4
|
AS
|
|
5
|
PRINT @TYPE
|
|
6
|
|
|
7
|
DECLARE
|
|
8
|
@BRANCH_CREATE VARCHAR(15),
|
|
9
|
@DEP_CREATE VARCHAR(15),
|
|
10
|
@BRANCH_TYPE VARCHAR(15),
|
|
11
|
@FATHER_ID VARCHAR(15),
|
|
12
|
@FLAG VARCHAR(1), -- FLAG = 1: THANH TOÁN / TẠM ỨNG
|
|
13
|
@AUTH_STATUS VARCHAR(10),
|
|
14
|
@PROCESS VARCHAR(10),
|
|
15
|
@MAKER_ID VARCHAR(15)
|
|
16
|
|
|
17
|
DECLARE @l_LST_REQ_ID TABLE (
|
|
18
|
[ID] [int] IDENTITY(1,1) NOT NULL,
|
|
19
|
[REQ_PAY_ID] [VARCHAR](15) NULL)
|
|
20
|
INSERT INTO @l_LST_REQ_ID SELECT VALUE FROM WSISPLIT(@PO_ID,',')
|
|
21
|
DECLARE @LST_POID TABLE(ID VARCHAR(15))
|
|
22
|
DECLARE @LST_USER_RECIVE TABLE (TLNAME VARCHAR(10))
|
|
23
|
--- DECLARE TABLE NHAN DU LIEU LA USER NAME DANG O BUOC PHE DUYET HIEN TAI
|
|
24
|
DECLARE @PL_PROCESS_CURRENT_SEARCH_TEMP TABLE
|
|
25
|
(
|
|
26
|
REQ_ID varchar(15),
|
|
27
|
PROCESS_ID varchar(10),
|
|
28
|
DVDM_NAME nvarchar(500),
|
|
29
|
TLNAME nvarchar(255),
|
|
30
|
TLFullName nvarchar(255),
|
|
31
|
NOTES nvarchar(500)
|
|
32
|
)
|
|
33
|
IF @TYPE = 'PO'
|
|
34
|
BEGIN
|
|
35
|
INSERT INTO @LST_POID VALUES(@PO_ID)
|
|
36
|
SET @FLAG = 0
|
|
37
|
END ELSE
|
|
38
|
IF @TYPE = 'USE'
|
|
39
|
BEGIN
|
|
40
|
INSERT INTO @LST_POID SELECT B.PO_ID
|
|
41
|
FROM ASS_MASTER_PO B WHERE B.ASSET_ID = (SELECT A.ASSET_ID FROM ASS_USE A WHERE A.USE_ID = @PO_ID)
|
|
42
|
SET @FLAG = 0
|
|
43
|
END ELSE
|
|
44
|
IF @TYPE = 'USE_MUILT'
|
|
45
|
BEGIN
|
|
46
|
INSERT INTO @LST_POID SELECT B.PO_ID
|
|
47
|
FROM ASS_MASTER_PO B WHERE B.ASSET_ID IN (SELECT A.ASSET_ID FROM ASS_USE_MULTI_DT A WHERE A.USER_MASTER_ID = @PO_ID)
|
|
48
|
GROUP BY B.PO_ID
|
|
49
|
SET @FLAG = 0
|
|
50
|
END ELSE
|
|
51
|
IF @TYPE = 'USE_ADDNEW'
|
|
52
|
BEGIN
|
|
53
|
INSERT INTO @LST_POID SELECT B.PO_ID
|
|
54
|
FROM ASS_ADDNEW_PO B WHERE B.ADDNEW_ID = @PO_ID
|
|
55
|
SET @FLAG = 0
|
|
56
|
END
|
|
57
|
-- Tạm ứng
|
|
58
|
ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_SEND_APR')
|
|
59
|
BEGIN
|
|
60
|
SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
61
|
IF(@AUTH_STATUS = 'U')
|
|
62
|
BEGIN
|
|
63
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
64
|
(SELECT TRASFER_USER_RECIVE FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
65
|
SET @FLAG = 1
|
|
66
|
END
|
|
67
|
END
|
|
68
|
ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_CONFIRM')
|
|
69
|
BEGIN
|
|
70
|
SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
71
|
SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
72
|
SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
73
|
SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
|
|
74
|
SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
|
|
75
|
IF(@BRANCH_TYPE = 'PGD' )
|
|
76
|
BEGIN
|
|
77
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
78
|
SELECT TLNANME FROM TL_USER
|
|
79
|
WHERE 1=1
|
|
80
|
AND TLSUBBRID = @FATHER_ID
|
|
81
|
AND (RoleName IN ('TPGD','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('TPGD','PP')))
|
|
82
|
|
|
83
|
END
|
|
84
|
ELSE IF(@BRANCH_TYPE = 'CN' )
|
|
85
|
BEGIN
|
|
86
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
87
|
SELECT TLNANME FROM TL_USER
|
|
88
|
WHERE 1=1
|
|
89
|
AND TLSUBBRID = @BRANCH_CREATE
|
|
90
|
AND (RoleName IN ('GDDV','PGD') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PGD')))
|
|
91
|
END
|
|
92
|
ELSE IF(@BRANCH_TYPE = 'HS' )
|
|
93
|
BEGIN
|
|
94
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
95
|
SELECT TLNANME FROM TL_USER
|
|
96
|
WHERE 1=1
|
|
97
|
AND TLSUBBRID = @BRANCH_CREATE
|
|
98
|
AND SECUR_CODE = @DEP_CREATE
|
|
99
|
AND (RoleName IN ('GDDV','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PP')))
|
|
100
|
END
|
|
101
|
SET @FLAG = 1
|
|
102
|
END
|
|
103
|
ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_APR')
|
|
104
|
BEGIN
|
|
105
|
SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
106
|
SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
107
|
SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
108
|
SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
|
|
109
|
SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
|
|
110
|
IF (@BRANCH_TYPE <> 'HS')
|
|
111
|
BEGIN
|
|
112
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
113
|
SELECT TLNANME FROM TL_USER
|
|
114
|
WHERE 1=1
|
|
115
|
--AND TLSUBBRID = @FATHER_ID
|
|
116
|
AND (RoleName = 'KSV' OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW = 'KSV'))
|
|
117
|
END
|
|
118
|
ELSE IF (@BRANCH_TYPE = 'HS')
|
|
119
|
BEGIN
|
|
120
|
IF((SELECT REQ_TYPE FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID) = 'I')
|
|
121
|
BEGIN
|
|
122
|
PRINT '1'
|
|
123
|
END
|
|
124
|
ELSE
|
|
125
|
BEGIN
|
|
126
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
127
|
SELECT TLNANME FROM TL_USER
|
|
128
|
WHERE 1=1
|
|
129
|
--AND TLSUBBRID = @BRANCH_CREATE
|
|
130
|
AND (RoleName = 'KSV' OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW = 'KSV'))
|
|
131
|
END
|
|
132
|
END
|
|
133
|
SET @FLAG = 1
|
|
134
|
END
|
|
135
|
-- Điều phối tạm ứng/ thanh toán PL_REQUEST_PROCESS_CHILD
|
|
136
|
ELSE IF (@TYPE = 'TR_REQ_PAYMENT_TRANSFER')
|
|
137
|
BEGIN
|
|
138
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
139
|
SELECT TOP 1 TLNAME FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID IN (SELECT REQ_PAY_ID FROM @l_LST_REQ_ID) AND TYPE_JOB = 'XL'
|
|
140
|
END
|
|
141
|
--
|
|
142
|
ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_KT_SEND_APR')
|
|
143
|
BEGIN
|
|
144
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
145
|
SELECT TOP 1 TLNAME FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = @PO_ID AND TYPE_JOB = 'KS'
|
|
146
|
END
|
|
147
|
ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_KT_APPR')
|
|
148
|
BEGIN
|
|
149
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
150
|
SELECT TOP 1 MAKER_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID
|
|
151
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
152
|
SELECT TOP 1 MAKER_ID_KT FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID
|
|
153
|
SET @FLAG = 1
|
|
154
|
END
|
|
155
|
-- Thanh toán
|
|
156
|
ELSE IF (@TYPE = 'TR_REQ_PAYMENT_SEND_APR')
|
|
157
|
BEGIN
|
|
158
|
SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
159
|
--IF(@AUTH_STATUS = 'U')
|
|
160
|
--BEGIN
|
|
161
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
162
|
(SELECT TRASFER_USER_RECIVE FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
163
|
SET @FLAG = 1
|
|
164
|
--END
|
|
165
|
END
|
|
166
|
ELSE IF(@TYPE = 'TR_REQ_PAYMENT_APR')
|
|
167
|
BEGIN
|
|
168
|
SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
169
|
IF(@AUTH_STATUS = 'A')
|
|
170
|
BEGIN
|
|
171
|
SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
172
|
SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
173
|
SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
174
|
SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
|
|
175
|
SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
|
|
176
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
177
|
SELECT TLNANME FROM TL_USER
|
|
178
|
WHERE 1=1
|
|
179
|
--AND TLSUBBRID = @BRANCH_CREATE
|
|
180
|
AND (RoleName = 'KSV' OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW = 'KSV'))
|
|
181
|
--IF (@BRANCH_TYPE <> 'HS')
|
|
182
|
--BEGIN
|
|
183
|
-- INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
184
|
-- SELECT TLNANME FROM TL_USER
|
|
185
|
-- WHERE 1=1
|
|
186
|
-- AND TLSUBBRID = @FATHER_ID
|
|
187
|
-- AND (RoleName = 'KSV' OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW = 'KSV'))
|
|
188
|
--END
|
|
189
|
--ELSE IF (@BRANCH_TYPE = 'HS')
|
|
190
|
--BEGIN
|
|
191
|
-- INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
192
|
-- SELECT TLNANME FROM TL_USER
|
|
193
|
-- WHERE 1=1
|
|
194
|
-- AND TLSUBBRID = @BRANCH_CREATE
|
|
195
|
-- AND (RoleName = 'KSV' OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW = 'KSV'))
|
|
196
|
--END
|
|
197
|
SET @FLAG = 1
|
|
198
|
END
|
|
199
|
END
|
|
200
|
ELSE IF(@TYPE = 'TR_REQ_PAYMENT_CONFIRM')
|
|
201
|
BEGIN
|
|
202
|
SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
203
|
SET @PROCESS = ( SELECT TOP 1 PROCESS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
204
|
IF(@AUTH_STATUS = 'U' AND @PROCESS = '0')
|
|
205
|
BEGIN
|
|
206
|
SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
207
|
SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
208
|
SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
|
|
209
|
SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
|
|
210
|
SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
|
|
211
|
IF(@BRANCH_TYPE = 'PGD' )
|
|
212
|
BEGIN
|
|
213
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
214
|
SELECT TLNANME FROM TL_USER
|
|
215
|
WHERE 1=1
|
|
216
|
AND TLSUBBRID = @FATHER_ID
|
|
217
|
AND (RoleName IN ('TPGD','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('TPGD','PP')))
|
|
218
|
|
|
219
|
END
|
|
220
|
ELSE IF(@BRANCH_TYPE = 'CN' )
|
|
221
|
BEGIN
|
|
222
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
223
|
SELECT TLNANME FROM TL_USER
|
|
224
|
WHERE 1=1
|
|
225
|
AND TLSUBBRID = @BRANCH_CREATE
|
|
226
|
AND (RoleName IN ('GDDV','PGD') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PGD')))
|
|
227
|
END
|
|
228
|
ELSE IF(@BRANCH_TYPE = 'HS' )
|
|
229
|
BEGIN
|
|
230
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
231
|
SELECT TLNANME FROM TL_USER
|
|
232
|
WHERE 1=1
|
|
233
|
AND TLSUBBRID = @BRANCH_CREATE
|
|
234
|
AND SECUR_CODE = @DEP_CREATE
|
|
235
|
AND (RoleName IN ('GDDV','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PP')))
|
|
236
|
END
|
|
237
|
SET @FLAG = 1
|
|
238
|
END
|
|
239
|
END
|
|
240
|
ELSE IF(@TYPE = 'TR_REQ_PAYMENT_KT_SEND_APR')
|
|
241
|
BEGIN
|
|
242
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
243
|
SELECT TOP 1 TLNAME FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = @PO_ID AND TYPE_JOB = 'KS'
|
|
244
|
SET @FLAG = 1
|
|
245
|
END
|
|
246
|
ELSE IF(@TYPE = 'TR_REQ_PAYMENT_KT_APR')
|
|
247
|
BEGIN
|
|
248
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
249
|
SELECT TOP 1 MAKER_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID
|
|
250
|
INSERT INTO @LST_USER_RECIVE (TLNAME)
|
|
251
|
SELECT TOP 1 MAKER_ID_KT FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID
|
|
252
|
SET @FLAG = 1
|
|
253
|
END
|
|
254
|
-- Tờ trình chủ trương
|
|
255
|
ELSE IF(@TYPE = 'PL_SEND_APP' OR @TYPE ='PL_REQUEST_DOC_App' OR @TYPE ='REQ_PROCESS_CHILD_Upd' OR @TYPE='REQ_PROCESS_CHILD_App')
|
|
256
|
BEGIN
|
|
257
|
SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
|
|
258
|
INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
|
|
259
|
EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'TTCT-DVKD'
|
|
260
|
SET @FLAG = 2
|
|
261
|
END
|
|
262
|
ELSE IF(@TYPE='PL_REQ_PROCESS_CHILD_Ins')
|
|
263
|
BEGIN
|
|
264
|
DECLARE @PLREQ_ID VARCHAR(15)
|
|
265
|
WHILE((SELECT COUNT(*) FROM @l_LST_REQ_ID) >0)
|
|
266
|
BEGIN
|
|
267
|
SET @PLREQ_ID =(SELECT TOP 1 REQ_PAY_ID FROM @l_LST_REQ_ID)
|
|
268
|
SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
|
|
269
|
INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
|
|
270
|
EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PLREQ_ID,@MAKER_ID,'TTCT-DVKD'
|
|
271
|
DELETE FROM @l_LST_REQ_ID WHERE REQ_PAY_ID =@PLREQ_ID
|
|
272
|
END
|
|
273
|
SET @FLAG = 3
|
|
274
|
END
|
|
275
|
ELSE IF(@TYPE='REQUEST_DOC_PROCESS_Approve')
|
|
276
|
BEGIN
|
|
277
|
DECLARE @REQ_ID VARCHAR(15)
|
|
278
|
WHILE((SELECT COUNT(*) FROM @l_LST_REQ_ID) >0)
|
|
279
|
BEGIN
|
|
280
|
SET @REQ_ID =(SELECT TOP 1 REQ_PAY_ID FROM @l_LST_REQ_ID)
|
|
281
|
SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
|
|
282
|
INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
|
|
283
|
EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @REQ_ID,@MAKER_ID,'TTCT-DVKD'
|
|
284
|
DELETE FROM @l_LST_REQ_ID WHERE REQ_PAY_ID =@REQ_ID
|
|
285
|
END
|
|
286
|
SET @FLAG = 3
|
|
287
|
END
|
|
288
|
----- PHIẾU YÊU CẦU MUA SẮM --------------
|
|
289
|
ELSE IF(@TYPE = 'TR_REQUEST_DOC_SendApp' OR @TYPE ='TR_REQUEST_DOC_App' OR @TYPE ='TR_REQ_PROCESS_CHILD_App' OR @TYPE ='TR_REQ_PROCESS_CHILD_Upd' OR @TYPE='REQ_PROCESS_CHILD_App')
|
|
290
|
BEGIN
|
|
291
|
SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
|
|
292
|
INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
|
|
293
|
EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'PYCMS-DVKD'
|
|
294
|
SET @FLAG = 2
|
|
295
|
END
|
|
296
|
ELSE IF(@TYPE='TR_REQ_PROCESS_CHILD_Ins')
|
|
297
|
BEGIN
|
|
298
|
DECLARE @REQ_DOC_ID VARCHAR(15)
|
|
299
|
SET @REQ_DOC_ID =(SELECT TOP 1 REQ_PAY_ID FROM @l_LST_REQ_ID)
|
|
300
|
SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
|
|
301
|
INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
|
|
302
|
EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @REQ_DOC_ID,@MAKER_ID,'TTCT-DVKD'
|
|
303
|
SET @FLAG = 3
|
|
304
|
END
|
|
305
|
ELSE IF(@TYPE='TR_REQUEST_DOC_PROCESS_Approve')
|
|
306
|
BEGIN
|
|
307
|
SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
|
|
308
|
INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
|
|
309
|
EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'PYCMS-DVKD'
|
|
310
|
SET @FLAG = 3
|
|
311
|
END
|
|
312
|
----- END PYC MUA SẮM --------------------
|
|
313
|
IF(@FLAG = 0)
|
|
314
|
BEGIN
|
|
315
|
SELECT A.*,B.TLFullName,B.EMAIL
|
|
316
|
FROM TL_ROLE_NOTIFICATION A
|
|
317
|
LEFT JOIN TL_USER B ON A.TL_NAME=B.TLNANME
|
|
318
|
WHERE EXISTS(SELECT * FROM @LST_POID WHERE ID = A.PO_ID)
|
|
319
|
END
|
|
320
|
--ELSE IF(@FLAG = 1)
|
|
321
|
--BEGIN
|
|
322
|
-- SELECT B.*,A.TLFullName,A.EMAIL
|
|
323
|
-- FROM TL_USER A
|
|
324
|
-- LEFT JOIN TL_ROLE_NOTIFICATION B ON B.TL_NAME=A.TLNANME
|
|
325
|
-- WHERE A.TLNANME IN (SELECT * FROM @LST_USER_RECIVE)
|
|
326
|
--END
|
|
327
|
---- NEU LA TO TRINH CHU TRUONG, PYC MS THÌ TRA VE FLAG =2
|
|
328
|
--ELSE IF(@FLAG = 2)
|
|
329
|
--BEGIN
|
|
330
|
-- SELECT B.*,A.TLFullName,A.EMAIL
|
|
331
|
-- FROM TL_USER A
|
|
332
|
-- LEFT JOIN TL_ROLE_NOTIFICATION B ON B.TL_NAME=A.TLNANME
|
|
333
|
-- WHERE A.TLNANME IN (SELECT TLNAME FROM @PL_PROCESS_CURRENT_SEARCH_TEMP)
|
|
334
|
--END
|
|
335
|
---- SAU KHI TT CHU TRUONG DUOC PHE DUYET THI THONG BAO CHO NGUOI TAO TO TRINH
|
|
336
|
--ELSE IF(@FLAG = 3)
|
|
337
|
--BEGIN
|
|
338
|
-- SELECT B.*,A.TLFullName,A.EMAIL
|
|
339
|
-- FROM TL_USER A
|
|
340
|
-- LEFT JOIN TL_ROLE_NOTIFICATION B ON B.TL_NAME=A.TLNANME
|
|
341
|
-- WHERE A.TLNANME =@MAKER_ID
|
|
342
|
--END
|