injitools /
cms-Inji
| @@ 302-318 (lines=17) @@ | ||
| 299 | $queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
|
| 300 | break; |
|
| 301 | case 'dateTime': |
|
| 302 | case 'date': |
|
| 303 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 304 | continue; |
|
| 305 | } |
|
| 306 | if (!empty($params['filters'][$col]['min'])) { |
|
| 307 | $queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>=']; |
|
| 308 | } |
|
| 309 | if (!empty($params['filters'][$col]['max'])) { |
|
| 310 | if ($colInfo['colParams']['type'] == 'dateTime' && !strpos($params['filters'][$col]['max'], ' ')) { |
|
| 311 | ||
| 312 | $date = $params['filters'][$col]['max'] . ' 23:59:59'; |
|
| 313 | } else { |
|
| 314 | $date = $params['filters'][$col]['max']; |
|
| 315 | } |
|
| 316 | $queryParams['where'][] = [$col, $date, '<=']; |
|
| 317 | } |
|
| 318 | break; |
|
| 319 | case 'number': |
|
| 320 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 321 | continue; |
|
| @@ 603-619 (lines=17) @@ | ||
| 600 | $queryParams['where'][] = [$col, '1']; |
|
| 601 | break; |
|
| 602 | case 'dateTime': |
|
| 603 | case 'date': |
|
| 604 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 605 | continue; |
|
| 606 | } |
|
| 607 | if (!empty($params['filters'][$col]['min'])) { |
|
| 608 | $queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>=']; |
|
| 609 | } |
|
| 610 | if (!empty($params['filters'][$col]['max'])) { |
|
| 611 | if ($colInfo['colParams']['type'] == 'dateTime' && !strpos($params['filters'][$col]['max'], ' ')) { |
|
| 612 | ||
| 613 | $date = $params['filters'][$col]['max'] . ' 23:59:59'; |
|
| 614 | } else { |
|
| 615 | $date = $params['filters'][$col]['max']; |
|
| 616 | } |
|
| 617 | $queryParams['where'][] = [$col, $date, '<=']; |
|
| 618 | } |
|
| 619 | break; |
|
| 620 | case 'number': |
|
| 621 | if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
|
| 622 | continue; |
|
