injitools /
cms-Inji
| @@ 311-329 (lines=19) @@ | ||
| 308 | case 'email': |
|
| 309 | case 'text': |
|
| 310 | case 'textarea': |
|
| 311 | case 'html': |
|
| 312 | if (empty($params['filters'][$col]['value'])) { |
|
| 313 | continue; |
|
| 314 | } |
|
| 315 | switch ($params['filters'][$col]['compareType']) { |
|
| 316 | case 'contains': |
|
| 317 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 318 | break; |
|
| 319 | case 'equals': |
|
| 320 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 321 | break; |
|
| 322 | case 'starts_with': |
|
| 323 | $queryParams['where'][] = [$col, $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 324 | break; |
|
| 325 | case 'ends_with': |
|
| 326 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'], 'LIKE']; |
|
| 327 | break; |
|
| 328 | } |
|
| 329 | break; |
|
| 330 | } |
|
| 331 | } |
|
| 332 | } |
|
| @@ 581-599 (lines=19) @@ | ||
| 578 | case 'email': |
|
| 579 | case 'text': |
|
| 580 | case 'textarea': |
|
| 581 | case 'html': |
|
| 582 | if (empty($params['filters'][$col]['value'])) { |
|
| 583 | continue; |
|
| 584 | } |
|
| 585 | switch ($params['filters'][$col]['compareType']) { |
|
| 586 | case 'contains': |
|
| 587 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 588 | break; |
|
| 589 | case 'equals': |
|
| 590 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 591 | break; |
|
| 592 | case 'starts_with': |
|
| 593 | $queryParams['where'][] = [$col, $params['filters'][$col]['value'] . '%', 'LIKE']; |
|
| 594 | break; |
|
| 595 | case 'ends_with': |
|
| 596 | $queryParams['where'][] = [$col, '%' . $params['filters'][$col]['value'], 'LIKE']; |
|
| 597 | break; |
|
| 598 | } |
|
| 599 | break; |
|
| 600 | } |
|
| 601 | } |
|
| 602 | } |
|
