injitools /
cms-Inji
| @@ 333-351 (lines=19) @@ | ||
| 330 | case 'email': |
|
| 331 | case 'text': |
|
| 332 | case 'textarea': |
|
| 333 | case 'html': |
|
| 334 | if (empty($params['filters'][$col]['value'])) { |
|
| 335 | continue; |
|
| 336 | } |
|
| 337 | switch ($params['filters'][$col]['compareType']) { |
|
| 338 | case 'contains': |
|
| 339 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 340 | break; |
|
| 341 | case 'equals': |
|
| 342 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 343 | break; |
|
| 344 | case 'starts_with': |
|
| 345 | $queryParams['where'][] = [$col, $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 346 | break; |
|
| 347 | case 'ends_with': |
|
| 348 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'], 'LIKE']; |
|
| 349 | break; |
|
| 350 | } |
|
| 351 | break; |
|
| 352 | } |
|
| 353 | } |
|
| 354 | } |
|
| @@ 634-652 (lines=19) @@ | ||
| 631 | case 'email': |
|
| 632 | case 'text': |
|
| 633 | case 'textarea': |
|
| 634 | case 'html': |
|
| 635 | if (empty($params['filters'][$col]['value'])) { |
|
| 636 | continue; |
|
| 637 | } |
|
| 638 | switch ($params['filters'][$col]['compareType']) { |
|
| 639 | case 'contains': |
|
| 640 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 641 | break; |
|
| 642 | case 'equals': |
|
| 643 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 644 | break; |
|
| 645 | case 'starts_with': |
|
| 646 | $queryParams['where'][] = [$col, $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 647 | break; |
|
| 648 | case 'ends_with': |
|
| 649 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'], 'LIKE']; |
|
| 650 | break; |
|
| 651 | } |
|
| 652 | break; |
|
| 653 | } |
|
| 654 | } |
|
| 655 | } |
|
