injitools /
cms-Inji
| @@ 330-348 (lines=19) @@ | ||
| 327 | case 'email': |
|
| 328 | case 'text': |
|
| 329 | case 'textarea': |
|
| 330 | case 'html': |
|
| 331 | if (empty($params['filters'][$col]['value'])) { |
|
| 332 | continue; |
|
| 333 | } |
|
| 334 | switch ($params['filters'][$col]['compareType']) { |
|
| 335 | case 'contains': |
|
| 336 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 337 | break; |
|
| 338 | case 'equals': |
|
| 339 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 340 | break; |
|
| 341 | case 'starts_with': |
|
| 342 | $queryParams['where'][] = [$col, $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 343 | break; |
|
| 344 | case 'ends_with': |
|
| 345 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'], 'LIKE']; |
|
| 346 | break; |
|
| 347 | } |
|
| 348 | break; |
|
| 349 | } |
|
| 350 | } |
|
| 351 | } |
|
| @@ 601-619 (lines=19) @@ | ||
| 598 | case 'email': |
|
| 599 | case 'text': |
|
| 600 | case 'textarea': |
|
| 601 | case 'html': |
|
| 602 | if (empty($params['filters'][$col]['value'])) { |
|
| 603 | continue; |
|
| 604 | } |
|
| 605 | switch ($params['filters'][$col]['compareType']) { |
|
| 606 | case 'contains': |
|
| 607 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 608 | break; |
|
| 609 | case 'equals': |
|
| 610 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 611 | break; |
|
| 612 | case 'starts_with': |
|
| 613 | $queryParams['where'][] = [$col, $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 614 | break; |
|
| 615 | case 'ends_with': |
|
| 616 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'], 'LIKE']; |
|
| 617 | break; |
|
| 618 | } |
|
| 619 | break; |
|
| 620 | } |
|
| 621 | } |
|
| 622 | } |
|
