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