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