macroparts /
vortex
| @@ 2352-2364 (lines=13) @@ | ||
| 2349 | * @param string $alias |
|
| 2350 | * @return mixed |
|
| 2351 | */ |
|
| 2352 | private function stringContainsExpression($query, $field, $params, $alias) |
|
| 2353 | { |
|
| 2354 | $contains = $query->expr()->orX(); |
|
| 2355 | ||
| 2356 | $index = 0; |
|
| 2357 | foreach ($params as $string) { |
|
| 2358 | $contains->add($query->expr()->like($field, ":contains_{$alias}_{$index}")); |
|
| 2359 | $query->setParameter("contains_{$alias}_{$index}", '%' . $string . '%'); |
|
| 2360 | $index++; |
|
| 2361 | } |
|
| 2362 | ||
| 2363 | return $contains; |
|
| 2364 | } |
|
| 2365 | ||
| 2366 | /** |
|
| 2367 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2385-2396 (lines=12) @@ | ||
| 2382 | * @param string $alias |
|
| 2383 | * @return mixed |
|
| 2384 | */ |
|
| 2385 | private function dateLtExpression($query, $field, $params, $alias) |
|
| 2386 | { |
|
| 2387 | $lt = $query->expr()->orX(); |
|
| 2388 | $index = 0; |
|
| 2389 | foreach ($params as $datetime) { |
|
| 2390 | $lt->add($query->expr()->lt($field, ":lt_{$alias}_{$index}")); |
|
| 2391 | $query->setParameter("lt_{$alias}_{$index}", $datetime); |
|
| 2392 | $index++; |
|
| 2393 | } |
|
| 2394 | ||
| 2395 | return $lt; |
|
| 2396 | } |
|
| 2397 | ||
| 2398 | /** |
|
| 2399 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2405-2416 (lines=12) @@ | ||
| 2402 | * @param string $alias |
|
| 2403 | * @return mixed |
|
| 2404 | */ |
|
| 2405 | private function integerLtExpression($query, $field, $params, $alias) |
|
| 2406 | { |
|
| 2407 | $lt = $query->expr()->orX(); |
|
| 2408 | $index = 0; |
|
| 2409 | foreach ($params as $datetime) { |
|
| 2410 | $lt->add($query->expr()->lt($field, ":lt_{$alias}_{$index}")); |
|
| 2411 | $query->setParameter("lt_{$alias}_{$index}", $datetime); |
|
| 2412 | $index++; |
|
| 2413 | } |
|
| 2414 | ||
| 2415 | return $lt; |
|
| 2416 | } |
|
| 2417 | ||
| 2418 | /** |
|
| 2419 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2425-2436 (lines=12) @@ | ||
| 2422 | * @param string $alias |
|
| 2423 | * @return mixed |
|
| 2424 | */ |
|
| 2425 | private function integerLteExpression($query, $field, $params, $alias) |
|
| 2426 | { |
|
| 2427 | $lte = $query->expr()->orX(); |
|
| 2428 | $index = 0; |
|
| 2429 | foreach ($params as $datetime) { |
|
| 2430 | $lte->add($query->expr()->lte($field, ":lte_{$alias}_{$index}")); |
|
| 2431 | $query->setParameter("lte_{$alias}_{$index}", $datetime); |
|
| 2432 | $index++; |
|
| 2433 | } |
|
| 2434 | ||
| 2435 | return $lte; |
|
| 2436 | } |
|
| 2437 | ||
| 2438 | /** |
|
| 2439 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2445-2456 (lines=12) @@ | ||
| 2442 | * @param string $alias |
|
| 2443 | * @return mixed |
|
| 2444 | */ |
|
| 2445 | private function dateLteExpression($query, $field, $params, $alias) |
|
| 2446 | { |
|
| 2447 | $lte = $query->expr()->orX(); |
|
| 2448 | $index = 0; |
|
| 2449 | foreach ($params as $datetime) { |
|
| 2450 | $lte->add($query->expr()->lte($field, ":lte_{$alias}_{$index}")); |
|
| 2451 | $query->setParameter("lte_{$alias}_{$index}", $datetime); |
|
| 2452 | $index++; |
|
| 2453 | } |
|
| 2454 | ||
| 2455 | return $lte; |
|
| 2456 | } |
|
| 2457 | ||
| 2458 | /** |
|
| 2459 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2465-2476 (lines=12) @@ | ||
| 2462 | * @param string $alias |
|
| 2463 | * @return mixed |
|
| 2464 | */ |
|
| 2465 | private function dateGtExpression($query, $field, $params, $alias) |
|
| 2466 | { |
|
| 2467 | $gt = $query->expr()->orX(); |
|
| 2468 | $index = 0; |
|
| 2469 | foreach ($params as $datetime) { |
|
| 2470 | $gt->add($query->expr()->gt($field, ":gt_{$alias}_{$index}")); |
|
| 2471 | $query->setParameter("gt_{$alias}_{$index}", $datetime); |
|
| 2472 | $index++; |
|
| 2473 | } |
|
| 2474 | ||
| 2475 | return $gt; |
|
| 2476 | } |
|
| 2477 | ||
| 2478 | /** |
|
| 2479 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2485-2496 (lines=12) @@ | ||
| 2482 | * @param string $alias |
|
| 2483 | * @return mixed |
|
| 2484 | */ |
|
| 2485 | private function integerGtExpression($query, $field, $params, $alias) |
|
| 2486 | { |
|
| 2487 | $gt = $query->expr()->orX(); |
|
| 2488 | $index = 0; |
|
| 2489 | foreach ($params as $datetime) { |
|
| 2490 | $gt->add($query->expr()->gt($field, ":gt_{$alias}_{$index}")); |
|
| 2491 | $query->setParameter("gt_{$alias}_{$index}", $datetime); |
|
| 2492 | $index++; |
|
| 2493 | } |
|
| 2494 | ||
| 2495 | return $gt; |
|
| 2496 | } |
|
| 2497 | ||
| 2498 | /** |
|
| 2499 | * @return string |
|
| @@ 2521-2532 (lines=12) @@ | ||
| 2518 | * @param string $alias |
|
| 2519 | * @return mixed |
|
| 2520 | */ |
|
| 2521 | private function integerGteExpression($query, $field, $params, $alias) |
|
| 2522 | { |
|
| 2523 | $gte = $query->expr()->orX(); |
|
| 2524 | $index = 0; |
|
| 2525 | foreach ($params as $datetime) { |
|
| 2526 | $gte->add($query->expr()->gte($field, ":gte_{$alias}_{$index}")); |
|
| 2527 | $query->setParameter("gte_{$alias}_{$index}", $datetime); |
|
| 2528 | $index++; |
|
| 2529 | } |
|
| 2530 | ||
| 2531 | return $gte; |
|
| 2532 | } |
|
| 2533 | ||
| 2534 | /** |
|
| 2535 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2541-2552 (lines=12) @@ | ||
| 2538 | * @param string $alias |
|
| 2539 | * @return mixed |
|
| 2540 | */ |
|
| 2541 | private function dateGteExpression($query, $field, $params, $alias) |
|
| 2542 | { |
|
| 2543 | $gte = $query->expr()->orX(); |
|
| 2544 | $index = 0; |
|
| 2545 | foreach ($params as $datetime) { |
|
| 2546 | $gte->add($query->expr()->gte($field, ":gte_{$alias}_{$index}")); |
|
| 2547 | $query->setParameter("gte_{$alias}_{$index}", $datetime); |
|
| 2548 | $index++; |
|
| 2549 | } |
|
| 2550 | ||
| 2551 | return $gte; |
|
| 2552 | } |
|
| 2553 | ||
| 2554 | /** |
|
| 2555 | * Does some crazy things |
|
