ublaboo /
datagrid
| @@ 97-111 (lines=15) @@ | ||
| 94 | * @param Filter\FilterDateRange $filter |
|
| 95 | * @return void |
|
| 96 | */ |
|
| 97 | public function applyFilterDateRange(Filter\FilterDateRange $filter) |
|
| 98 | { |
|
| 99 | $conditions = $filter->getCondition(); |
|
| 100 | ||
| 101 | $value_from = $conditions[$filter->getColumn()]['from']; |
|
| 102 | $value_to = $conditions[$filter->getColumn()]['to']; |
|
| 103 | ||
| 104 | if ($value_from) { |
|
| 105 | $this->data_source->where('CONVERT(varchar(10), %n, 112) >= ?', $filter->getColumn(), $value_from); |
|
| 106 | } |
|
| 107 | ||
| 108 | if ($value_to) { |
|
| 109 | $this->data_source->where('CONVERT(varchar(10), %n, 112) <= ?', $filter->getColumn(), $value_to); |
|
| 110 | } |
|
| 111 | } |
|
| 112 | ||
| 113 | ||
| 114 | /** |
|
| @@ 146-160 (lines=15) @@ | ||
| 143 | * @param Filter\FilterRange $filter |
|
| 144 | * @return void |
|
| 145 | */ |
|
| 146 | public function applyFilterRange(Filter\FilterRange $filter) |
|
| 147 | { |
|
| 148 | $conditions = $filter->getCondition(); |
|
| 149 | ||
| 150 | $value_from = $conditions[$filter->getColumn()]['from']; |
|
| 151 | $value_to = $conditions[$filter->getColumn()]['to']; |
|
| 152 | ||
| 153 | if ($value_from) { |
|
| 154 | $this->data_source->where("{$filter->getColumn()} >= ?", $value_from); |
|
| 155 | } |
|
| 156 | ||
| 157 | if ($value_to) { |
|
| 158 | $this->data_source->where("{$filter->getColumn()} <= ?", $value_to); |
|
| 159 | } |
|
| 160 | } |
|
| 161 | ||
| 162 | ||
| 163 | /** |
|
