|
@@ 299-315 (lines=17) @@
|
| 296 |
|
$queryParams['where'][] = [$col, $params['filters'][$col]['value']]; |
| 297 |
|
break; |
| 298 |
|
case 'dateTime': |
| 299 |
|
case 'date': |
| 300 |
|
if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
| 301 |
|
continue; |
| 302 |
|
} |
| 303 |
|
if (!empty($params['filters'][$col]['min'])) { |
| 304 |
|
$queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>=']; |
| 305 |
|
} |
| 306 |
|
if (!empty($params['filters'][$col]['max'])) { |
| 307 |
|
if ($colInfo['colParams']['type'] == 'dateTime' && !strpos($params['filters'][$col]['max'], ' ')) { |
| 308 |
|
|
| 309 |
|
$date = $params['filters'][$col]['max'] . ' 23:59:59'; |
| 310 |
|
} else { |
| 311 |
|
$date = $params['filters'][$col]['max']; |
| 312 |
|
} |
| 313 |
|
$queryParams['where'][] = [$col, $date, '<=']; |
| 314 |
|
} |
| 315 |
|
break; |
| 316 |
|
case 'number': |
| 317 |
|
if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
| 318 |
|
continue; |
|
@@ 570-586 (lines=17) @@
|
| 567 |
|
$queryParams['where'][] = [$col, '1']; |
| 568 |
|
break; |
| 569 |
|
case 'dateTime': |
| 570 |
|
case 'date': |
| 571 |
|
if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
| 572 |
|
continue; |
| 573 |
|
} |
| 574 |
|
if (!empty($params['filters'][$col]['min'])) { |
| 575 |
|
$queryParams['where'][] = [$col, $params['filters'][$col]['min'], '>=']; |
| 576 |
|
} |
| 577 |
|
if (!empty($params['filters'][$col]['max'])) { |
| 578 |
|
if ($colInfo['colParams']['type'] == 'dateTime' && !strpos($params['filters'][$col]['max'], ' ')) { |
| 579 |
|
|
| 580 |
|
$date = $params['filters'][$col]['max'] . ' 23:59:59'; |
| 581 |
|
} else { |
| 582 |
|
$date = $params['filters'][$col]['max']; |
| 583 |
|
} |
| 584 |
|
$queryParams['where'][] = [$col, $date, '<=']; |
| 585 |
|
} |
| 586 |
|
break; |
| 587 |
|
case 'number': |
| 588 |
|
if (empty($params['filters'][$col]['min']) && empty($params['filters'][$col]['max'])) { |
| 589 |
|
continue; |
injitools /
cms-Inji
