@@ 195-201 (lines=7) @@ | ||
192 | } |
|
193 | ||
194 | // oreder_date |
|
195 | if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) { |
|
196 | $date = $searchData['order_date_start'] |
|
197 | ->format('Y-m-d H:i:s'); |
|
198 | $qb |
|
199 | ->andWhere('o.create_date >= :order_date_start') |
|
200 | ->setParameter('order_date_start', $date); |
|
201 | } |
|
202 | if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) { |
|
203 | $date = clone $searchData['order_date_end']; |
|
204 | $date = $date |
|
@@ 202-210 (lines=9) @@ | ||
199 | ->andWhere('o.create_date >= :order_date_start') |
|
200 | ->setParameter('order_date_start', $date); |
|
201 | } |
|
202 | if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) { |
|
203 | $date = clone $searchData['order_date_end']; |
|
204 | $date = $date |
|
205 | ->modify('+1 days') |
|
206 | ->format('Y-m-d H:i:s'); |
|
207 | $qb |
|
208 | ->andWhere('o.create_date < :order_date_end') |
|
209 | ->setParameter('order_date_end', $date); |
|
210 | } |
|
211 | ||
212 | // create_date |
|
213 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
@@ 213-219 (lines=7) @@ | ||
210 | } |
|
211 | ||
212 | // create_date |
|
213 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
214 | $date = $searchData['update_date_start'] |
|
215 | ->format('Y-m-d H:i:s'); |
|
216 | $qb |
|
217 | ->andWhere('o.update_date >= :update_date_start') |
|
218 | ->setParameter('update_date_start', $date); |
|
219 | } |
|
220 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
221 | $date = clone $searchData['update_date_end']; |
|
222 | $date = $date |
|
@@ 220-228 (lines=9) @@ | ||
217 | ->andWhere('o.update_date >= :update_date_start') |
|
218 | ->setParameter('update_date_start', $date); |
|
219 | } |
|
220 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
221 | $date = clone $searchData['update_date_end']; |
|
222 | $date = $date |
|
223 | ->modify('+1 days') |
|
224 | ->format('Y-m-d H:i:s'); |
|
225 | $qb |
|
226 | ->andWhere('o.update_date < :update_date_end') |
|
227 | ->setParameter('update_date_end', $date); |
|
228 | } |
|
229 | ||
230 | // payment_total |
|
231 | if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) { |
|
@@ 291-296 (lines=6) @@ | ||
288 | ||
289 | // status |
|
290 | $filterStatus = false; |
|
291 | if (!empty($searchData['status']) && $searchData['status']) { |
|
292 | $qb |
|
293 | ->andWhere('o.OrderStatus = :status') |
|
294 | ->setParameter('status', $searchData['status']); |
|
295 | $filterStatus = true; |
|
296 | } |
|
297 | if (!empty($searchData['multi_status']) && count($searchData['multi_status'])) { |
|
298 | $qb |
|
299 | ->andWhere($qb->expr()->in('o.OrderStatus', ':multi_status')) |
|
@@ 360-366 (lines=7) @@ | ||
357 | } |
|
358 | ||
359 | // oreder_date |
|
360 | if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) { |
|
361 | $date = $searchData['order_date_start'] |
|
362 | ->format('Y-m-d H:i:s'); |
|
363 | $qb |
|
364 | ->andWhere('o.order_date >= :order_date_start') |
|
365 | ->setParameter('order_date_start', $date); |
|
366 | } |
|
367 | if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) { |
|
368 | $date = clone $searchData['order_date_end']; |
|
369 | $date = $date |
|
@@ 367-375 (lines=9) @@ | ||
364 | ->andWhere('o.order_date >= :order_date_start') |
|
365 | ->setParameter('order_date_start', $date); |
|
366 | } |
|
367 | if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) { |
|
368 | $date = clone $searchData['order_date_end']; |
|
369 | $date = $date |
|
370 | ->modify('+1 days') |
|
371 | ->format('Y-m-d H:i:s'); |
|
372 | $qb |
|
373 | ->andWhere('o.order_date < :order_date_end') |
|
374 | ->setParameter('order_date_end', $date); |
|
375 | } |
|
376 | ||
377 | // payment_date |
|
378 | if (!empty($searchData['payment_date_start']) && $searchData['payment_date_start']) { |
|
@@ 378-384 (lines=7) @@ | ||
375 | } |
|
376 | ||
377 | // payment_date |
|
378 | if (!empty($searchData['payment_date_start']) && $searchData['payment_date_start']) { |
|
379 | $date = $searchData['payment_date_start'] |
|
380 | ->format('Y-m-d H:i:s'); |
|
381 | $qb |
|
382 | ->andWhere('o.payment_date >= :payment_date_start') |
|
383 | ->setParameter('payment_date_start', $date); |
|
384 | } |
|
385 | if (!empty($searchData['payment_date_end']) && $searchData['payment_date_end']) { |
|
386 | $date = clone $searchData['payment_date_end']; |
|
387 | $date = $date |
|
@@ 385-393 (lines=9) @@ | ||
382 | ->andWhere('o.payment_date >= :payment_date_start') |
|
383 | ->setParameter('payment_date_start', $date); |
|
384 | } |
|
385 | if (!empty($searchData['payment_date_end']) && $searchData['payment_date_end']) { |
|
386 | $date = clone $searchData['payment_date_end']; |
|
387 | $date = $date |
|
388 | ->modify('+1 days') |
|
389 | ->format('Y-m-d H:i:s'); |
|
390 | $qb |
|
391 | ->andWhere('o.payment_date < :payment_date_end') |
|
392 | ->setParameter('payment_date_end', $date); |
|
393 | } |
|
394 | ||
395 | // commit_date |
|
396 | if (!empty($searchData['commit_date_start']) && $searchData['commit_date_start']) { |
|
@@ 396-402 (lines=7) @@ | ||
393 | } |
|
394 | ||
395 | // commit_date |
|
396 | if (!empty($searchData['commit_date_start']) && $searchData['commit_date_start']) { |
|
397 | $date = $searchData['commit_date_start'] |
|
398 | ->format('Y-m-d H:i:s'); |
|
399 | $qb |
|
400 | ->andWhere('o.commit_date >= :commit_date_start') |
|
401 | ->setParameter('commit_date_start', $date); |
|
402 | } |
|
403 | if (!empty($searchData['commit_date_end']) && $searchData['commit_date_end']) { |
|
404 | $date = clone $searchData['commit_date_end']; |
|
405 | $date = $date |
|
@@ 403-411 (lines=9) @@ | ||
400 | ->andWhere('o.commit_date >= :commit_date_start') |
|
401 | ->setParameter('commit_date_start', $date); |
|
402 | } |
|
403 | if (!empty($searchData['commit_date_end']) && $searchData['commit_date_end']) { |
|
404 | $date = clone $searchData['commit_date_end']; |
|
405 | $date = $date |
|
406 | ->modify('+1 days') |
|
407 | ->format('Y-m-d H:i:s'); |
|
408 | $qb |
|
409 | ->andWhere('o.commit_date < :commit_date_end') |
|
410 | ->setParameter('commit_date_end', $date); |
|
411 | } |
|
412 | ||
413 | ||
414 | // update_date |
|
@@ 415-421 (lines=7) @@ | ||
412 | ||
413 | ||
414 | // update_date |
|
415 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
416 | $date = $searchData['update_date_start'] |
|
417 | ->format('Y-m-d H:i:s'); |
|
418 | $qb |
|
419 | ->andWhere('o.update_date >= :update_date_start') |
|
420 | ->setParameter('update_date_start', $date); |
|
421 | } |
|
422 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
423 | $date = clone $searchData['update_date_end']; |
|
424 | $date = $date |
|
@@ 422-430 (lines=9) @@ | ||
419 | ->andWhere('o.update_date >= :update_date_start') |
|
420 | ->setParameter('update_date_start', $date); |
|
421 | } |
|
422 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
423 | $date = clone $searchData['update_date_end']; |
|
424 | $date = $date |
|
425 | ->modify('+1 days') |
|
426 | ->format('Y-m-d H:i:s'); |
|
427 | $qb |
|
428 | ->andWhere('o.update_date < :update_date_end') |
|
429 | ->setParameter('update_date_end', $date); |
|
430 | } |
|
431 | ||
432 | // payment_total |
|
433 | if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) { |
@@ 236-242 (lines=7) @@ | ||
233 | } |
|
234 | ||
235 | // crate_date |
|
236 | if (!empty($searchData['create_date_start']) && $searchData['create_date_start']) { |
|
237 | $date = $searchData['create_date_start'] |
|
238 | ->format('Y-m-d H:i:s'); |
|
239 | $qb |
|
240 | ->andWhere('p.create_date >= :create_date_start') |
|
241 | ->setParameter('create_date_start', $date); |
|
242 | } |
|
243 | ||
244 | if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) { |
|
245 | $date = clone $searchData['create_date_end']; |
|
@@ 244-252 (lines=9) @@ | ||
241 | ->setParameter('create_date_start', $date); |
|
242 | } |
|
243 | ||
244 | if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) { |
|
245 | $date = clone $searchData['create_date_end']; |
|
246 | $date = $date |
|
247 | ->modify('+1 days') |
|
248 | ->format('Y-m-d H:i:s'); |
|
249 | $qb |
|
250 | ->andWhere('p.create_date < :create_date_end') |
|
251 | ->setParameter('create_date_end', $date); |
|
252 | } |
|
253 | ||
254 | // update_date |
|
255 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
@@ 255-261 (lines=7) @@ | ||
252 | } |
|
253 | ||
254 | // update_date |
|
255 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
256 | $date = $searchData['update_date_start'] |
|
257 | ->format('Y-m-d H:i:s'); |
|
258 | $qb |
|
259 | ->andWhere('p.update_date >= :update_date_start') |
|
260 | ->setParameter('update_date_start', $date); |
|
261 | } |
|
262 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
263 | $date = clone $searchData['update_date_end']; |
|
264 | $date = $date |
|
@@ 262-270 (lines=9) @@ | ||
259 | ->andWhere('p.update_date >= :update_date_start') |
|
260 | ->setParameter('update_date_start', $date); |
|
261 | } |
|
262 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
263 | $date = clone $searchData['update_date_end']; |
|
264 | $date = $date |
|
265 | ->modify('+1 days') |
|
266 | ->format('Y-m-d H:i:s'); |
|
267 | $qb |
|
268 | ->andWhere('p.update_date < :update_date_end') |
|
269 | ->setParameter('update_date_end', $date); |
|
270 | } |
|
271 | ||
272 | ||
273 | // Order By |
@@ 187-193 (lines=7) @@ | ||
184 | } |
|
185 | ||
186 | // birth |
|
187 | if (!empty($searchData['birth_start']) && $searchData['birth_start']) { |
|
188 | $date = $searchData['birth_start'] |
|
189 | ->format('Y-m-d H:i:s'); |
|
190 | $qb |
|
191 | ->andWhere('c.birth >= :birth_start') |
|
192 | ->setParameter('birth_start', $date); |
|
193 | } |
|
194 | if (!empty($searchData['birth_end']) && $searchData['birth_end']) { |
|
195 | $date = clone $searchData['birth_end']; |
|
196 | $date = $date |
|
@@ 194-202 (lines=9) @@ | ||
191 | ->andWhere('c.birth >= :birth_start') |
|
192 | ->setParameter('birth_start', $date); |
|
193 | } |
|
194 | if (!empty($searchData['birth_end']) && $searchData['birth_end']) { |
|
195 | $date = clone $searchData['birth_end']; |
|
196 | $date = $date |
|
197 | ->modify('+1 days') |
|
198 | ->format('Y-m-d H:i:s'); |
|
199 | $qb |
|
200 | ->andWhere('c.birth < :birth_end') |
|
201 | ->setParameter('birth_end', $date); |
|
202 | } |
|
203 | ||
204 | // tel |
|
205 | if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) { |
|
@@ 236-242 (lines=7) @@ | ||
233 | } |
|
234 | ||
235 | // create_date |
|
236 | if (!empty($searchData['create_date_start']) && $searchData['create_date_start']) { |
|
237 | $date = $searchData['create_date_start'] |
|
238 | ->format('Y-m-d H:i:s'); |
|
239 | $qb |
|
240 | ->andWhere('c.create_date >= :create_date_start') |
|
241 | ->setParameter('create_date_start', $date); |
|
242 | } |
|
243 | if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) { |
|
244 | $date = clone $searchData['create_date_end']; |
|
245 | $date = $date |
|
@@ 243-251 (lines=9) @@ | ||
240 | ->andWhere('c.create_date >= :create_date_start') |
|
241 | ->setParameter('create_date_start', $date); |
|
242 | } |
|
243 | if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) { |
|
244 | $date = clone $searchData['create_date_end']; |
|
245 | $date = $date |
|
246 | ->modify('+1 days') |
|
247 | ->format('Y-m-d H:i:s'); |
|
248 | $qb |
|
249 | ->andWhere('c.create_date < :create_date_end') |
|
250 | ->setParameter('create_date_end', $date); |
|
251 | } |
|
252 | ||
253 | // update_date |
|
254 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
@@ 254-260 (lines=7) @@ | ||
251 | } |
|
252 | ||
253 | // update_date |
|
254 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
255 | $date = $searchData['update_date_start'] |
|
256 | ->format('Y-m-d H:i:s'); |
|
257 | $qb |
|
258 | ->andWhere('c.update_date >= :update_date_start') |
|
259 | ->setParameter('update_date_start', $date); |
|
260 | } |
|
261 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
262 | $date = clone $searchData['update_date_end']; |
|
263 | $date = $date |
|
@@ 261-269 (lines=9) @@ | ||
258 | ->andWhere('c.update_date >= :update_date_start') |
|
259 | ->setParameter('update_date_start', $date); |
|
260 | } |
|
261 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
262 | $date = clone $searchData['update_date_end']; |
|
263 | $date = $date |
|
264 | ->modify('+1 days') |
|
265 | ->format('Y-m-d H:i:s'); |
|
266 | $qb |
|
267 | ->andWhere('c.update_date < :update_date_end') |
|
268 | ->setParameter('update_date_end', $date); |
|
269 | } |
|
270 | ||
271 | // last_buy |
|
272 | if (!empty($searchData['last_buy_start']) && $searchData['last_buy_start']) { |
|
@@ 272-278 (lines=7) @@ | ||
269 | } |
|
270 | ||
271 | // last_buy |
|
272 | if (!empty($searchData['last_buy_start']) && $searchData['last_buy_start']) { |
|
273 | $date = $searchData['last_buy_start'] |
|
274 | ->format('Y-m-d H:i:s'); |
|
275 | $qb |
|
276 | ->andWhere('c.last_buy_date >= :last_buy_start') |
|
277 | ->setParameter('last_buy_start', $date); |
|
278 | } |
|
279 | if (!empty($searchData['last_buy_end']) && $searchData['last_buy_end']) { |
|
280 | $date = clone $searchData['last_buy_end']; |
|
281 | $date = $date |
|
@@ 279-287 (lines=9) @@ | ||
276 | ->andWhere('c.last_buy_date >= :last_buy_start') |
|
277 | ->setParameter('last_buy_start', $date); |
|
278 | } |
|
279 | if (!empty($searchData['last_buy_end']) && $searchData['last_buy_end']) { |
|
280 | $date = clone $searchData['last_buy_end']; |
|
281 | $date = $date |
|
282 | ->modify('+1 days') |
|
283 | ->format('Y-m-d H:i:s'); |
|
284 | $qb |
|
285 | ->andWhere('c.last_buy_date < :last_buy_end') |
|
286 | ->setParameter('last_buy_end', $date); |
|
287 | } |
|
288 | ||
289 | // status |
|
290 | if (!empty($searchData['customer_status']) && count($searchData['customer_status']) > 0) { |