|
@@ 310-326 (lines=17) @@
|
| 307 |
|
$queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
| 308 |
|
break; |
| 309 |
|
case 'dateTime': |
| 310 |
|
case 'date': |
| 311 |
|
if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
| 312 |
|
continue; |
| 313 |
|
} |
| 314 |
|
if (!empty($params['filters'][$col]['min'])) { |
| 315 |
|
$queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>=']; |
| 316 |
|
} |
| 317 |
|
if (!empty($params['filters'][$col]['max'])) { |
| 318 |
|
if ($colInfo['colParams']['type'] == 'dateTime' && !strpos($params['filters'][$col]['max'], ' ')) { |
| 319 |
|
|
| 320 |
|
$date = $params['filters'][$col]['max'] . ' 23:59:59'; |
| 321 |
|
} else { |
| 322 |
|
$date = $params['filters'][$col]['max']; |
| 323 |
|
} |
| 324 |
|
$queryParams['where'][] = [$col, $date, '<=']; |
| 325 |
|
} |
| 326 |
|
break; |
| 327 |
|
case 'number': |
| 328 |
|
if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
| 329 |
|
continue; |
|
@@ 614-630 (lines=17) @@
|
| 611 |
|
$queryParams['where'][] = [$col, '1']; |
| 612 |
|
break; |
| 613 |
|
case 'dateTime': |
| 614 |
|
case 'date': |
| 615 |
|
if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
| 616 |
|
continue; |
| 617 |
|
} |
| 618 |
|
if (!empty($params['filters'][$col]['min'])) { |
| 619 |
|
$queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>=']; |
| 620 |
|
} |
| 621 |
|
if (!empty($params['filters'][$col]['max'])) { |
| 622 |
|
if ($colInfo['colParams']['type'] == 'dateTime' && !strpos($params['filters'][$col]['max'], ' ')) { |
| 623 |
|
|
| 624 |
|
$date = $params['filters'][$col]['max'] . ' 23:59:59'; |
| 625 |
|
} else { |
| 626 |
|
$date = $params['filters'][$col]['max']; |
| 627 |
|
} |
| 628 |
|
$queryParams['where'][] = [$col, $date, '<=']; |
| 629 |
|
} |
| 630 |
|
break; |
| 631 |
|
case 'number': |
| 632 |
|
if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
| 633 |
|
continue; |
injitools /
cms-Inji
