injitools /
cms-Inji
| @@ 280-296 (lines=17) @@ | ||
| 277 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 278 | break; |
|
| 279 | case 'dateTime': |
|
| 280 | case 'date': |
|
| 281 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 282 | continue; |
|
| 283 | } |
|
| 284 | if (!empty($params['filters'][$col]['min'])) { |
|
| 285 | $queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>=']; |
|
| 286 | } |
|
| 287 | if (!empty($params['filters'][$col]['max'])) { |
|
| 288 | if ($colInfo['colParams']['type'] == 'dateTime' && !strpos($params['filters'][$col]['max'], ' ')) { |
|
| 289 | ||
| 290 | $date = $params['filters'][$col]['max'] . ' 23:59:59'; |
|
| 291 | } else { |
|
| 292 | $date = $params['filters'][$col]['max']; |
|
| 293 | } |
|
| 294 | $queryParams['where'][] = [$col, $date, '<=']; |
|
| 295 | } |
|
| 296 | break; |
|
| 297 | case 'number': |
|
| 298 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 299 | continue; |
|
| @@ 550-566 (lines=17) @@ | ||
| 547 | $queryParams['where'][] = [$col, '1']; |
|
| 548 | break; |
|
| 549 | case 'dateTime': |
|
| 550 | case 'date': |
|
| 551 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 552 | continue; |
|
| 553 | } |
|
| 554 | if (!empty($params['filters'][$col]['min'])) { |
|
| 555 | $queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>=']; |
|
| 556 | } |
|
| 557 | if (!empty($params['filters'][$col]['max'])) { |
|
| 558 | if ($colInfo['colParams']['type'] == 'dateTime' && !strpos($params['filters'][$col]['max'], ' ')) { |
|
| 559 | ||
| 560 | $date = $params['filters'][$col]['max'] . ' 23:59:59'; |
|
| 561 | } else { |
|
| 562 | $date = $params['filters'][$col]['max']; |
|
| 563 | } |
|
| 564 | $queryParams['where'][] = [$col, $date, '<=']; |
|
| 565 | } |
|
| 566 | break; |
|
| 567 | case 'number': |
|
| 568 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 569 | continue; |
|
