injitools /
cms-Inji
| @@ 289-305 (lines=17) @@ | ||
| 286 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 287 | break; |
|
| 288 | case 'dateTime': |
|
| 289 | case 'date': |
|
| 290 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 291 | continue; |
|
| 292 | } |
|
| 293 | if (!empty($params['filters'][$col]['min'])) { |
|
| 294 | $queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>=']; |
|
| 295 | } |
|
| 296 | if (!empty($params['filters'][$col]['max'])) { |
|
| 297 | if ($colInfo['colParams']['type'] == 'dateTime' && !strpos($params['filters'][$col]['max'], ' ')) { |
|
| 298 | ||
| 299 | $date = $params['filters'][$col]['max'] . ' 23:59:59'; |
|
| 300 | } else { |
|
| 301 | $date = $params['filters'][$col]['max']; |
|
| 302 | } |
|
| 303 | $queryParams['where'][] = [$col, $date, '<=']; |
|
| 304 | } |
|
| 305 | break; |
|
| 306 | case 'number': |
|
| 307 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 308 | continue; |
|
| @@ 563-579 (lines=17) @@ | ||
| 560 | $queryParams['where'][] = [$col, '1']; |
|
| 561 | break; |
|
| 562 | case 'dateTime': |
|
| 563 | case 'date': |
|
| 564 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 565 | continue; |
|
| 566 | } |
|
| 567 | if (!empty($params['filters'][$col]['min'])) { |
|
| 568 | $queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>=']; |
|
| 569 | } |
|
| 570 | if (!empty($params['filters'][$col]['max'])) { |
|
| 571 | if ($colInfo['colParams']['type'] == 'dateTime' && !strpos($params['filters'][$col]['max'], ' ')) { |
|
| 572 | ||
| 573 | $date = $params['filters'][$col]['max'] . ' 23:59:59'; |
|
| 574 | } else { |
|
| 575 | $date = $params['filters'][$col]['max']; |
|
| 576 | } |
|
| 577 | $queryParams['where'][] = [$col, $date, '<=']; |
|
| 578 | } |
|
| 579 | break; |
|
| 580 | case 'number': |
|
| 581 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 582 | continue; |
|
