|
1
|
|
|
2
|
ALTER PROCEDURE [dbo].[CM_SUPPLIER_Search]
|
|
3
|
@p_SUP_CODE varchar(15) = NULL,
|
|
4
|
@p_SUP_NAME Nvarchar(300) = NULL,
|
|
5
|
@p_SUP_TYPE_ID varchar(15) = NULL,
|
|
6
|
@p_REGION_ID varchar(15) = NULL,
|
|
7
|
@p_ADDR nvarchar(200) = NULL,
|
|
8
|
@p_EMAIL varchar(50) = NULL,
|
|
9
|
@p_TAX_NO varchar(20) = NULL,
|
|
10
|
@p_TEL varchar(20) = NULL,
|
|
11
|
@p_CONTACT_PERSON nvarchar(200) = NULL,
|
|
12
|
@p_DISCIPLINES NVARCHAR(15) = NULL,
|
|
13
|
@p_NOTES nvarchar(1000) = NULL,
|
|
14
|
@p_RECORD_STATUS varchar(1) = NULL,
|
|
15
|
@p_MAKER_ID varchar(20) = NULL,
|
|
16
|
@p_CREATE_DT VARCHAR(20) = NULL,
|
|
17
|
@p_AUTH_STATUS varchar(50) = NULL,
|
|
18
|
@p_CHECKER_ID varchar(20) = NULL,
|
|
19
|
@p_APPROVE_DT VARCHAR(20) = NULL,
|
|
20
|
@p_TRN_TYPE VARCHAR(50) = NULL,
|
|
21
|
@p_REF_ID VARCHAR(20) = NULL,
|
|
22
|
@p_TOTAL_AMT DECIMAL(18,0),
|
|
23
|
@p_TOP INT = NULL,
|
|
24
|
@p_EDITOR_ID varchar(15) = NULL,
|
|
25
|
@p_ACC_NUM varchar(100)= NULL,
|
|
26
|
@p_ACC_NUM_OUT varchar(100)=NULL
|
|
27
|
AS
|
|
28
|
BEGIN -- PAGING
|
|
29
|
------thieuvq -BEGIN 231219------
|
|
30
|
--SELECT * FROM TR_CONTRACT A
|
|
31
|
--INNER JOIN TR_CONTRACT_DT B ON A.CONTRACT_ID = B.CONTRACT_ID AND B.GOODS_ID = ''
|
|
32
|
--SELECT * FROM TR_CONTRACT_DT
|
|
33
|
--SELECT * FROM CM_GOODS
|
|
34
|
----SELECT * FROM wsiSplit('TR_REQ_DOC_RE;GOO000000000452',';') WHERE value LIKE 'GOO%'
|
|
35
|
--SELECT DATEADD(MONTH,3,GETDATE())
|
|
36
|
|
|
37
|
SET @p_TOP = 1000
|
|
38
|
IF @p_REF_ID <> '' AND @p_REF_ID IS NOT NULL
|
|
39
|
BEGIN
|
|
40
|
IF(@p_TRN_TYPE='PO-PYC')
|
|
41
|
BEGIN
|
|
42
|
-- PAGING BEGIN
|
|
43
|
SELECT A.*,T.SUP_TYPE_NAME,B.AUTH_STATUS_NAME,C.CONTENT AS DISCIPLINES_NAME, '' AS TK_GL, '' AS TK_GL_NAME, '' AS TK_GL_OUT, '' AS TK_GL_NAME_OUT, U.TLFullName
|
|
44
|
-- SELECT END
|
|
45
|
FROM CM_SUPPLIER A
|
|
46
|
INNER JOIN dbo.TR_REQUEST_DOC_DT TR ON TR.SUP_ID=A.SUP_ID AND TR.REQ_DOC_ID=@p_REF_ID
|
|
47
|
LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS = B.AUTH_STATUS
|
|
48
|
LEFT JOIN CM_ALLCODE C ON C.CDVAL = A.DISCIPLINES AND C.CDNAME = 'DISCIPLINES'
|
|
49
|
LEFT JOIN TL_USER U ON A.EDITOR_ID = U.TLNANME
|
|
50
|
LEFT JOIN CM_SUPPLIERTYPE T ON T.SUP_TYPE_ID = A.SUP_TYPE_ID--,T.SUP_TYPE_NAME
|
|
51
|
WHERE 1 = 1
|
|
52
|
AND (A.SUP_CODE like + '%' + @p_SUP_CODE + '%' OR @p_SUP_CODE IS NULL OR @p_SUP_CODE = '')
|
|
53
|
AND (A.SUP_NAME like '%' + @p_SUP_NAME + '%' OR @p_SUP_NAME IS NULL OR @p_SUP_NAME = '')
|
|
54
|
AND (A.SUP_TYPE_ID LIKE '%' + @p_SUP_TYPE_ID OR @p_SUP_TYPE_ID IS NULL OR @p_SUP_TYPE_ID = '')
|
|
55
|
AND (A.REGION_ID LIKE '%' + @p_REGION_ID + '%' OR @p_REGION_ID IS NULL OR @p_REGION_ID = '')
|
|
56
|
AND (A.EMAIL LIKE '%' + @p_EMAIL + '%' OR @p_EMAIL IS NULL OR @p_EMAIL = '')
|
|
57
|
AND (A.TAX_NO LIKE '%' + @p_TAX_NO + '%' OR @p_TAX_NO IS NULL OR @p_TAX_NO = '')
|
|
58
|
AND (A.TEL LIKE '%' + @p_TEL + '%' OR @p_TEL IS NULL OR @p_TEL = '')
|
|
59
|
AND (A.DISCIPLINES LIKE '%' + @p_DISCIPLINES + '%' OR @p_DISCIPLINES IS NULL OR @p_DISCIPLINES = '')
|
|
60
|
AND (A.CONTACT_PERSON LIKE '%' + @p_CONTACT_PERSON + '%' OR @p_CONTACT_PERSON IS NULL OR @p_CREATE_DT = '')
|
|
61
|
AND (A.NOTES LIKE '%' + @p_NOTES + '%' OR @p_NOTES IS NULL OR @p_NOTES = '')
|
|
62
|
AND (A.RECORD_STATUS LIKE '%' + @p_RECORD_STATUS + '%' OR @p_RECORD_STATUS IS NULL OR @p_RECORD_STATUS = '')
|
|
63
|
AND (A.MAKER_ID LIKE '%' + @p_MAKER_ID + '%' OR @p_MAKER_ID IS NULL OR @p_MAKER_ID = '')
|
|
64
|
AND (DATEDIFF(DAY,A.CREATE_DT ,CONVERT(DATETIME, @p_CREATE_DT, 103)) =0 OR @p_CREATE_DT IS NULL OR @p_CREATE_DT = '')
|
|
65
|
AND (A.AUTH_STATUS LIKE '%' + @p_AUTH_STATUS + '%' OR @p_AUTH_STATUS IS NULL OR @p_AUTH_STATUS = '')
|
|
66
|
AND (A.CHECKER_ID LIKE '%' + @p_CHECKER_ID + '%' OR @p_CHECKER_ID IS NULL OR @p_CHECKER_ID = '')
|
|
67
|
AND (DATEDIFF(DAY,A.APPROVE_DT ,CONVERT(DATETIME, @p_APPROVE_DT, 103)) = 0 OR @p_APPROVE_DT IS NULL OR @p_APPROVE_DT = '')
|
|
68
|
--PHONGNT 4/3/2022
|
|
69
|
AND (A.ACC_NUM LIKE '%' + @p_ACC_NUM + '%' OR @p_ACC_NUM IS NULL OR @p_ACC_NUM = '')
|
|
70
|
AND (A.ACC_NUM_OUT LIKE '%' + @p_ACC_NUM_OUT + '%' OR @p_ACC_NUM_OUT IS NULL OR @p_ACC_NUM_OUT = '')
|
|
71
|
AND A.RECORD_STATUS = '1'
|
|
72
|
-- PAGING END
|
|
73
|
END
|
|
74
|
---CO THE TRUYEN GOODS_ID XUONG HOAC TRUYEN HANG MUC --> XUONG NAY LAY RA GOODS_ID
|
|
75
|
ELSE IF(@p_TOTAL_AMT <= (SELECT LIMIT_VALUE FROM dbo.TL_SYSROLE_LIMIT WHERE ROLE_ID='MSTT'))
|
|
76
|
BEGIN
|
|
77
|
-- PAGING BEGIN
|
|
78
|
SELECT A.*,T.SUP_TYPE_NAME,B.AUTH_STATUS_NAME,C.CONTENT AS DISCIPLINES_NAME,'' AS TK_GL, '' AS TK_GL_NAME, '' AS TK_GL_OUT, '' AS TK_GL_NAME_OUT, U.TLFullName
|
|
79
|
-- SELECT END
|
|
80
|
FROM CM_SUPPLIER A
|
|
81
|
LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS = B.AUTH_STATUS
|
|
82
|
LEFT JOIN CM_ALLCODE C ON C.CDVAL = A.DISCIPLINES AND C.CDNAME = 'DISCIPLINES'
|
|
83
|
LEFT JOIN TL_USER U ON A.EDITOR_ID = U.TLNANME
|
|
84
|
LEFT JOIN CM_SUPPLIERTYPE T ON T.SUP_TYPE_ID = A.SUP_TYPE_ID--,T.SUP_TYPE_NAME
|
|
85
|
WHERE 1 = 1
|
|
86
|
AND (A.SUP_CODE like + '%' + @p_SUP_CODE + '%' OR @p_SUP_CODE IS NULL OR @p_SUP_CODE = '')
|
|
87
|
AND (A.SUP_NAME like '%' + @p_SUP_NAME + '%' OR @p_SUP_NAME IS NULL OR @p_SUP_NAME = '')
|
|
88
|
AND (A.SUP_TYPE_ID LIKE '%' + @p_SUP_TYPE_ID OR @p_SUP_TYPE_ID IS NULL OR @p_SUP_TYPE_ID = '')
|
|
89
|
AND (A.REGION_ID LIKE '%' + @p_REGION_ID + '%' OR @p_REGION_ID IS NULL OR @p_REGION_ID = '')
|
|
90
|
AND (A.EMAIL LIKE '%' + @p_EMAIL + '%' OR @p_EMAIL IS NULL OR @p_EMAIL = '')
|
|
91
|
AND (A.TAX_NO LIKE '%' + @p_TAX_NO + '%' OR @p_TAX_NO IS NULL OR @p_TAX_NO = '')
|
|
92
|
AND (A.TEL LIKE '%' + @p_TEL + '%' OR @p_TEL IS NULL OR @p_TEL = '')
|
|
93
|
AND (A.DISCIPLINES LIKE '%' + @p_DISCIPLINES + '%' OR @p_DISCIPLINES IS NULL OR @p_DISCIPLINES = '')
|
|
94
|
AND (A.CONTACT_PERSON LIKE '%' + @p_CONTACT_PERSON + '%' OR @p_CONTACT_PERSON IS NULL OR @p_CREATE_DT = '')
|
|
95
|
AND (A.NOTES LIKE '%' + @p_NOTES + '%' OR @p_NOTES IS NULL OR @p_NOTES = '')
|
|
96
|
AND (A.RECORD_STATUS LIKE '%' + @p_RECORD_STATUS + '%' OR @p_RECORD_STATUS IS NULL OR @p_RECORD_STATUS = '')
|
|
97
|
AND (A.MAKER_ID LIKE '%' + @p_MAKER_ID + '%' OR @p_MAKER_ID IS NULL OR @p_MAKER_ID = '')
|
|
98
|
AND (DATEDIFF(DAY,A.CREATE_DT ,CONVERT(DATETIME, @p_CREATE_DT, 103)) =0 OR @p_CREATE_DT IS NULL OR @p_CREATE_DT = '')
|
|
99
|
AND (A.AUTH_STATUS LIKE '%' + @p_AUTH_STATUS + '%' OR @p_AUTH_STATUS IS NULL OR @p_AUTH_STATUS = '')
|
|
100
|
AND (A.CHECKER_ID LIKE '%' + @p_CHECKER_ID + '%' OR @p_CHECKER_ID IS NULL OR @p_CHECKER_ID = '')
|
|
101
|
AND (DATEDIFF(DAY,A.APPROVE_DT ,CONVERT(DATETIME, @p_APPROVE_DT, 103)) = 0 OR @p_APPROVE_DT IS NULL OR @p_APPROVE_DT = '')
|
|
102
|
--PHONGNT 4/3/2022
|
|
103
|
AND (A.ACC_NUM LIKE '%' + @p_ACC_NUM + '%' OR @p_ACC_NUM IS NULL OR @p_ACC_NUM = '')
|
|
104
|
AND (A.ACC_NUM_OUT LIKE '%' + @p_ACC_NUM_OUT + '%' OR @p_ACC_NUM_OUT IS NULL OR @p_ACC_NUM_OUT = '')
|
|
105
|
AND A.RECORD_STATUS = '1'
|
|
106
|
-- PAGING END
|
|
107
|
END
|
|
108
|
ELSE
|
|
109
|
-- PAGING BEGIN
|
|
110
|
SELECT A.*,T.SUP_TYPE_NAME,B.AUTH_STATUS_NAME,C.CONTENT AS DISCIPLINES_NAME,'' AS TK_GL, '' AS TK_GL_NAME, '' AS TK_GL_OUT, '' AS TK_GL_NAME_OUT, U.TLFullName
|
|
111
|
-- SELECT END
|
|
112
|
FROM CM_SUPPLIER A
|
|
113
|
LEFT JOIN
|
|
114
|
(
|
|
115
|
SELECT A.SUP_ID FROM TR_CONTRACT A
|
|
116
|
INNER JOIN TR_CONTRACT_DT B ON A.CONTRACT_ID = B.CONTRACT_ID --AND B.GOODS_ID = @GD_ID
|
|
117
|
WHERE B.GOODS_ID = @p_REF_ID AND A.APPROVE_DT IS NOT NULL AND
|
|
118
|
((DATEADD(MONTH,6,A.APPROVE_DT) >= GETDATE() AND (A.REQUEST_ID = '' or A.REQUEST_ID IS NULL)) ---LAY HD KY CACH DAY 6 THANG
|
|
119
|
OR A.REQUEST_ID IS not NULL OR A.REQUEST_ID <> '')---HOP DONG NGUYEN TAC THI KHONG BAT BUOC NHAP SO PHIEU YEU CAU MUA SAM
|
|
120
|
) SUP ON SUP.SUP_ID = A.SUP_ID
|
|
121
|
LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS = B.AUTH_STATUS
|
|
122
|
LEFT JOIN CM_ALLCODE C ON C.CDVAL = A.DISCIPLINES AND C.CDNAME = 'DISCIPLINES'
|
|
123
|
LEFT JOIN TL_USER U ON A.EDITOR_ID = U.TLNANME
|
|
124
|
LEFT JOIN CM_SUPPLIERTYPE T ON T.SUP_TYPE_ID = A.SUP_TYPE_ID--,T.SUP_TYPE_NAME
|
|
125
|
WHERE 1 = 1
|
|
126
|
AND (A.SUP_CODE like + '%' + @p_SUP_CODE + '%' OR @p_SUP_CODE IS NULL OR @p_SUP_CODE = '')
|
|
127
|
AND (A.SUP_NAME like '%' + @p_SUP_NAME + '%' OR @p_SUP_NAME IS NULL OR @p_SUP_NAME = '')
|
|
128
|
AND (A.SUP_TYPE_ID LIKE '%' + @p_SUP_TYPE_ID OR @p_SUP_TYPE_ID IS NULL OR @p_SUP_TYPE_ID = '')
|
|
129
|
AND (A.REGION_ID LIKE '%' + @p_REGION_ID + '%' OR @p_REGION_ID IS NULL OR @p_REGION_ID = '')
|
|
130
|
AND (A.EMAIL LIKE '%' + @p_EMAIL + '%' OR @p_EMAIL IS NULL OR @p_EMAIL = '')
|
|
131
|
AND (A.TAX_NO LIKE '%' + @p_TAX_NO + '%' OR @p_TAX_NO IS NULL OR @p_TAX_NO = '')
|
|
132
|
AND (A.TEL LIKE '%' + @p_TEL + '%' OR @p_TEL IS NULL OR @p_TEL = '')
|
|
133
|
AND (A.DISCIPLINES LIKE '%' + @p_DISCIPLINES + '%' OR @p_DISCIPLINES IS NULL OR @p_DISCIPLINES = '')
|
|
134
|
AND (A.CONTACT_PERSON LIKE '%' + @p_CONTACT_PERSON + '%' OR @p_CONTACT_PERSON IS NULL OR @p_CREATE_DT = '')
|
|
135
|
AND (A.NOTES LIKE '%' + @p_NOTES + '%' OR @p_NOTES IS NULL OR @p_NOTES = '')
|
|
136
|
AND (A.RECORD_STATUS LIKE '%' + @p_RECORD_STATUS + '%' OR @p_RECORD_STATUS IS NULL OR @p_RECORD_STATUS = '')
|
|
137
|
AND (A.MAKER_ID LIKE '%' + @p_MAKER_ID + '%' OR @p_MAKER_ID IS NULL OR @p_MAKER_ID = '')
|
|
138
|
AND (DATEDIFF(DAY,A.CREATE_DT ,CONVERT(DATETIME, @p_CREATE_DT, 103)) =0 OR @p_CREATE_DT IS NULL OR @p_CREATE_DT = '')
|
|
139
|
AND (A.AUTH_STATUS LIKE '%' + @p_AUTH_STATUS + '%' OR @p_AUTH_STATUS IS NULL OR @p_AUTH_STATUS = '')
|
|
140
|
AND (A.CHECKER_ID LIKE '%' + @p_CHECKER_ID + '%' OR @p_CHECKER_ID IS NULL OR @p_CHECKER_ID = '')
|
|
141
|
AND (DATEDIFF(DAY,A.APPROVE_DT ,CONVERT(DATETIME, @p_APPROVE_DT, 103)) = 0 OR @p_APPROVE_DT IS NULL OR @p_APPROVE_DT = '')
|
|
142
|
--PHONGNT 4/3/2022
|
|
143
|
AND (A.ACC_NUM LIKE '%' + @p_ACC_NUM + '%' OR @p_ACC_NUM IS NULL OR @p_ACC_NUM = '')
|
|
144
|
AND (A.ACC_NUM_OUT LIKE '%' + @p_ACC_NUM_OUT + '%' OR @p_ACC_NUM_OUT IS NULL OR @p_ACC_NUM_OUT = '')
|
|
145
|
AND A.RECORD_STATUS = '1'
|
|
146
|
-- PAGING END
|
|
147
|
END
|
|
148
|
ELSE
|
|
149
|
------END 231219
|
|
150
|
IF(@p_TOP IS NULL OR @p_TOP = '' OR @p_TOP = 0)
|
|
151
|
-- PAGING BEGIN
|
|
152
|
SELECT A.*,T.SUP_TYPE_NAME,B.AUTH_STATUS_NAME,C.CONTENT AS DISCIPLINES_NAME,'' AS TK_GL, '' AS TK_GL_NAME, '' AS TK_GL_OUT, '' AS TK_GL_NAME_OUT, U.TLFullName
|
|
153
|
-- SELECT END
|
|
154
|
FROM CM_SUPPLIER A LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS = B.AUTH_STATUS
|
|
155
|
LEFT JOIN CM_ALLCODE C ON C.CDVAL = A.DISCIPLINES AND C.CDNAME = 'DISCIPLINES'
|
|
156
|
LEFT JOIN TL_USER U ON A.EDITOR_ID = U.TLNANME
|
|
157
|
LEFT JOIN CM_SUPPLIERTYPE T ON T.SUP_TYPE_ID = A.SUP_TYPE_ID--,T.SUP_TYPE_NAME
|
|
158
|
WHERE 1 = 1
|
|
159
|
AND (A.SUP_CODE like + '%' + @p_SUP_CODE + '%' OR @p_SUP_CODE IS NULL OR @p_SUP_CODE = '')
|
|
160
|
AND (A.SUP_NAME like '%' + @p_SUP_NAME + '%' OR @p_SUP_NAME IS NULL OR @p_SUP_NAME = '')
|
|
161
|
AND (A.SUP_TYPE_ID LIKE '%' + @p_SUP_TYPE_ID OR @p_SUP_TYPE_ID IS NULL OR @p_SUP_TYPE_ID = '')
|
|
162
|
AND (A.REGION_ID LIKE '%' + @p_REGION_ID + '%' OR @p_REGION_ID IS NULL OR @p_REGION_ID = '')
|
|
163
|
AND (A.EMAIL LIKE '%' + @p_EMAIL + '%' OR @p_EMAIL IS NULL OR @p_EMAIL = '')
|
|
164
|
AND (A.TAX_NO LIKE '%' + @p_TAX_NO + '%' OR @p_TAX_NO IS NULL OR @p_TAX_NO = '')
|
|
165
|
AND (A.TEL LIKE '%' + @p_TEL + '%' OR @p_TEL IS NULL OR @p_TEL = '')
|
|
166
|
AND (A.DISCIPLINES LIKE '%' + @p_DISCIPLINES + '%' OR @p_DISCIPLINES IS NULL OR @p_DISCIPLINES = '')
|
|
167
|
AND (A.CONTACT_PERSON LIKE '%' + @p_CONTACT_PERSON + '%' OR @p_CONTACT_PERSON IS NULL OR @p_CREATE_DT = '')
|
|
168
|
AND (A.NOTES LIKE '%' + @p_NOTES + '%' OR @p_NOTES IS NULL OR @p_NOTES = '')
|
|
169
|
AND (A.RECORD_STATUS LIKE '%' + @p_RECORD_STATUS + '%' OR @p_RECORD_STATUS IS NULL OR @p_RECORD_STATUS = '')
|
|
170
|
AND (A.MAKER_ID LIKE '%' + @p_MAKER_ID + '%' OR @p_MAKER_ID IS NULL OR @p_MAKER_ID = '')
|
|
171
|
AND (DATEDIFF(DAY,A.CREATE_DT ,CONVERT(DATETIME, @p_CREATE_DT, 103)) =0 OR @p_CREATE_DT IS NULL OR @p_CREATE_DT = '')
|
|
172
|
AND (A.AUTH_STATUS LIKE '%' + @p_AUTH_STATUS + '%' OR @p_AUTH_STATUS IS NULL OR @p_AUTH_STATUS = '')
|
|
173
|
AND (A.CHECKER_ID LIKE '%' + @p_CHECKER_ID + '%' OR @p_CHECKER_ID IS NULL OR @p_CHECKER_ID = '')
|
|
174
|
AND (DATEDIFF(DAY,A.APPROVE_DT ,CONVERT(DATETIME, @p_APPROVE_DT, 103)) = 0 OR @p_APPROVE_DT IS NULL OR @p_APPROVE_DT = '')
|
|
175
|
--PHONGNT 4/3/2022
|
|
176
|
AND (A.ACC_NUM LIKE '%' + @p_ACC_NUM + '%' OR @p_ACC_NUM IS NULL OR @p_ACC_NUM = '')
|
|
177
|
AND (A.ACC_NUM_OUT LIKE '%' + @p_ACC_NUM_OUT + '%' OR @p_ACC_NUM_OUT IS NULL OR @p_ACC_NUM_OUT = '')
|
|
178
|
AND A.RECORD_STATUS = '1'
|
|
179
|
-- PAGING END
|
|
180
|
ELSE
|
|
181
|
-- PAGING BEGIN
|
|
182
|
SELECT TOP(@p_TOP)A.*,T.SUP_TYPE_NAME,B.AUTH_STATUS_NAME,C.CONTENT AS DISCIPLINES_NAME,'' AS TK_GL, '' AS TK_GL_NAME, '' AS TK_GL_OUT, '' AS TK_GL_NAME_OUT, U.TLFullName
|
|
183
|
-- SELECT END
|
|
184
|
FROM CM_SUPPLIER A LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS = B.AUTH_STATUS
|
|
185
|
LEFT JOIN CM_ALLCODE C ON C.CDVAL = A.DISCIPLINES AND C.CDNAME = 'DISCIPLINES'
|
|
186
|
LEFT JOIN TL_USER U ON A.EDITOR_ID = U.TLNANME
|
|
187
|
LEFT JOIN CM_SUPPLIERTYPE T ON T.SUP_TYPE_ID = A.SUP_TYPE_ID--,T.SUP_TYPE_NAME
|
|
188
|
WHERE 1 = 1
|
|
189
|
AND (A.SUP_CODE like + '%' + @p_SUP_CODE + '%' OR @p_SUP_CODE IS NULL OR @p_SUP_CODE = '')
|
|
190
|
AND (A.SUP_NAME like '%' + @p_SUP_NAME + '%' OR @p_SUP_NAME IS NULL OR @p_SUP_NAME = '')
|
|
191
|
AND (A.SUP_TYPE_ID LIKE '%' + @p_SUP_TYPE_ID OR @p_SUP_TYPE_ID IS NULL OR @p_SUP_TYPE_ID = '')
|
|
192
|
AND (A.REGION_ID LIKE '%' + @p_REGION_ID + '%' OR @p_REGION_ID IS NULL OR @p_REGION_ID = '')
|
|
193
|
AND (A.EMAIL LIKE '%' + @p_EMAIL + '%' OR @p_EMAIL IS NULL OR @p_EMAIL = '')
|
|
194
|
AND (A.TAX_NO LIKE '%' + @p_TAX_NO + '%' OR @p_TAX_NO IS NULL OR @p_TAX_NO = '')
|
|
195
|
AND (A.TEL LIKE '%' + @p_TEL + '%' OR @p_TEL IS NULL OR @p_TEL = '')
|
|
196
|
AND (A.DISCIPLINES LIKE '%' + @p_DISCIPLINES + '%' OR @p_DISCIPLINES IS NULL OR @p_DISCIPLINES = '')
|
|
197
|
AND (A.CONTACT_PERSON LIKE '%' + @p_CONTACT_PERSON + '%' OR @p_CONTACT_PERSON IS NULL OR @p_CREATE_DT = '')
|
|
198
|
AND (A.NOTES LIKE '%' + @p_NOTES + '%' OR @p_NOTES IS NULL OR @p_NOTES = '')
|
|
199
|
AND (A.RECORD_STATUS LIKE '%' + @p_RECORD_STATUS + '%' OR @p_RECORD_STATUS IS NULL OR @p_RECORD_STATUS = '')
|
|
200
|
AND (A.MAKER_ID LIKE '%' + @p_MAKER_ID + '%' OR @p_MAKER_ID IS NULL OR @p_MAKER_ID = '')
|
|
201
|
AND (DATEDIFF(DAY,A.CREATE_DT ,CONVERT(DATETIME, @p_CREATE_DT, 103)) =0 OR @p_CREATE_DT IS NULL OR @p_CREATE_DT = '')
|
|
202
|
AND (A.AUTH_STATUS LIKE '%' + @p_AUTH_STATUS + '%' OR @p_AUTH_STATUS IS NULL OR @p_AUTH_STATUS = '')
|
|
203
|
AND (A.CHECKER_ID LIKE '%' + @p_CHECKER_ID + '%' OR @p_CHECKER_ID IS NULL OR @p_CHECKER_ID = '')
|
|
204
|
AND (DATEDIFF(DAY,A.APPROVE_DT ,CONVERT(DATETIME, @p_APPROVE_DT, 103)) = 0 OR @p_APPROVE_DT IS NULL OR @p_APPROVE_DT = '')
|
|
205
|
--PHONGNT 4/3/2022
|
|
206
|
AND (A.ACC_NUM LIKE '%' + @p_ACC_NUM + '%' OR @p_ACC_NUM IS NULL OR @p_ACC_NUM = '')
|
|
207
|
AND (A.ACC_NUM_OUT LIKE '%' + @p_ACC_NUM_OUT + '%' OR @p_ACC_NUM_OUT IS NULL OR @p_ACC_NUM_OUT = '')
|
|
208
|
AND A.RECORD_STATUS = '1'
|
|
209
|
-- PAGING END
|
|
210
|
END -- PAGING
|
|
211
|
|
|
212
|
--EXEC CM_SUPPLIER_Search '','','','','','','','','','','','','','','','',100
|