ublaboo /
datagrid
| @@ 41-67 (lines=27) @@ | ||
| 38 | * @param Filter\FilterDateRange $filter |
|
| 39 | * @return void |
|
| 40 | */ |
|
| 41 | public function applyFilterDateRange(Filter\FilterDateRange $filter) |
|
| 42 | { |
|
| 43 | $conditions = $filter->getCondition(); |
|
| 44 | ||
| 45 | $value_from = $conditions[$filter->getColumn()]['from']; |
|
| 46 | $value_to = $conditions[$filter->getColumn()]['to']; |
|
| 47 | ||
| 48 | if ($value_from) { |
|
| 49 | $date_from = DateTimeHelper::tryConvertToDateTime($value_from, [$filter->getPhpFormat()]); |
|
| 50 | $date_from->setTime(0, 0, 0); |
|
| 51 | ||
| 52 | $this->data_source->where( |
|
| 53 | "CONVERT(varchar(10), {$filter->getColumn()}, 112) >= ?", |
|
| 54 | $date_from->format('Ymd') |
|
| 55 | ); |
|
| 56 | } |
|
| 57 | ||
| 58 | if ($value_to) { |
|
| 59 | $date_to = DateTimeHelper::tryConvertToDateTime($value_to, [$filter->getPhpFormat()]); |
|
| 60 | $date_to->setTime(23, 59, 59); |
|
| 61 | ||
| 62 | $this->data_source->where( |
|
| 63 | "CONVERT(varchar(10), {$filter->getColumn()}, 112) <= ?", |
|
| 64 | $date_to->format('Ymd') |
|
| 65 | ); |
|
| 66 | } |
|
| 67 | } |
|
| 68 | ||
| 69 | } |
|
| 70 | ||
| @@ 118-138 (lines=21) @@ | ||
| 115 | * @param Filter\FilterDateRange $filter |
|
| 116 | * @return void |
|
| 117 | */ |
|
| 118 | public function applyFilterDateRange(Filter\FilterDateRange $filter) |
|
| 119 | { |
|
| 120 | $conditions = $filter->getCondition(); |
|
| 121 | ||
| 122 | $value_from = $conditions[$filter->getColumn()]['from']; |
|
| 123 | $value_to = $conditions[$filter->getColumn()]['to']; |
|
| 124 | ||
| 125 | if ($value_from) { |
|
| 126 | $date_from = DateTimeHelper::tryConvertToDateTime($value_from, [$filter->getPhpFormat()]); |
|
| 127 | $date_from->setTime(0, 0, 0); |
|
| 128 | ||
| 129 | $this->data_source->where("DATE({$filter->getColumn()}) >= ?", $date_from->format('Y-m-d')); |
|
| 130 | } |
|
| 131 | ||
| 132 | if ($value_to) { |
|
| 133 | $date_to = DateTimeHelper::tryConvertToDateTime($value_to, [$filter->getPhpFormat()]); |
|
| 134 | $date_to->setTime(23, 59, 59); |
|
| 135 | ||
| 136 | $this->data_source->where("DATE({$filter->getColumn()}) <= ?", $date_to->format('Y-m-d')); |
|
| 137 | } |
|
| 138 | } |
|
| 139 | ||
| 140 | ||
| 141 | /** |
|
