injitools /
cms-Inji
| @@ 320-338 (lines=19) @@ | ||
| 317 | case 'email': |
|
| 318 | case 'text': |
|
| 319 | case 'textarea': |
|
| 320 | case 'html': |
|
| 321 | if (empty($params['filters'][$col]['value'])) { |
|
| 322 | continue; |
|
| 323 | } |
|
| 324 | switch ($params['filters'][$col]['compareType']) { |
|
| 325 | case 'contains': |
|
| 326 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 327 | break; |
|
| 328 | case 'equals': |
|
| 329 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 330 | break; |
|
| 331 | case 'starts_with': |
|
| 332 | $queryParams['where'][] = [$col, $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 333 | break; |
|
| 334 | case 'ends_with': |
|
| 335 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'], 'LIKE']; |
|
| 336 | break; |
|
| 337 | } |
|
| 338 | break; |
|
| 339 | } |
|
| 340 | } |
|
| 341 | } |
|
| @@ 594-612 (lines=19) @@ | ||
| 591 | case 'email': |
|
| 592 | case 'text': |
|
| 593 | case 'textarea': |
|
| 594 | case 'html': |
|
| 595 | if (empty($params['filters'][$col]['value'])) { |
|
| 596 | continue; |
|
| 597 | } |
|
| 598 | switch ($params['filters'][$col]['compareType']) { |
|
| 599 | case 'contains': |
|
| 600 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 601 | break; |
|
| 602 | case 'equals': |
|
| 603 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 604 | break; |
|
| 605 | case 'starts_with': |
|
| 606 | $queryParams['where'][] = [$col, $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 607 | break; |
|
| 608 | case 'ends_with': |
|
| 609 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'], 'LIKE']; |
|
| 610 | break; |
|
| 611 | } |
|
| 612 | break; |
|
| 613 | } |
|
| 614 | } |
|
| 615 | } |
|
