injitools /
cms-Inji
| @@ 341-359 (lines=19) @@ | ||
| 338 | case 'email': |
|
| 339 | case 'text': |
|
| 340 | case 'textarea': |
|
| 341 | case 'html': |
|
| 342 | if (empty($params['filters'][$col]['value'])) { |
|
| 343 | continue; |
|
| 344 | } |
|
| 345 | switch ($params['filters'][$col]['compareType']) { |
|
| 346 | case 'contains': |
|
| 347 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 348 | break; |
|
| 349 | case 'equals': |
|
| 350 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 351 | break; |
|
| 352 | case 'starts_with': |
|
| 353 | $queryParams['where'][] = [$col, $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 354 | break; |
|
| 355 | case 'ends_with': |
|
| 356 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'], 'LIKE']; |
|
| 357 | break; |
|
| 358 | } |
|
| 359 | break; |
|
| 360 | } |
|
| 361 | } |
|
| 362 | } |
|
| @@ 645-663 (lines=19) @@ | ||
| 642 | case 'email': |
|
| 643 | case 'text': |
|
| 644 | case 'textarea': |
|
| 645 | case 'html': |
|
| 646 | if (empty($params['filters'][$col]['value'])) { |
|
| 647 | continue; |
|
| 648 | } |
|
| 649 | switch ($params['filters'][$col]['compareType']) { |
|
| 650 | case 'contains': |
|
| 651 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 652 | break; |
|
| 653 | case 'equals': |
|
| 654 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 655 | break; |
|
| 656 | case 'starts_with': |
|
| 657 | $queryParams['where'][] = [$col, $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 658 | break; |
|
| 659 | case 'ends_with': |
|
| 660 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'], 'LIKE']; |
|
| 661 | break; |
|
| 662 | } |
|
| 663 | break; |
|
| 664 | } |
|
| 665 | } |
|
| 666 | } |
|
