/** * Filter by range * @param Filter\FilterRange $filter * @return void */ public function applyFilterRange(Filter\FilterRange $filter) { $values = $conditions[$filter->getColumn()]; if ($value_from = $values['from']) { $expr = Criteria::expr()->gte($filter->getColumn(), $value_from); $this->criteria->andWhere($expr); } if ($value_to = $values['to']) { $expr = Criteria::expr()->lte($filter->getColumn(), $value_to); $this->criteria->andWhere($expr); } }
/** * Filter by range * @param Filter\FilterRange $filter * @return void */ public function applyFilterRange(Filter\FilterRange $filter) { $conditions = $filter->getCondition(); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; $dataCondition = []; if ($value_from) { $dataCondition[$this->prepareColumn($filter->getColumn()) . '>='] = $value_from; } if ($value_to) { $dataCondition[$this->prepareColumn($filter->getColumn()) . '<='] = $value_to; } if (!empty($dataCondition)) { $this->data_source = $this->data_source->findBy($dataCondition); } }
/** * Filter by range * @param Filter\FilterRange $filter * @return void */ public function applyFilterRange(Filter\FilterRange $filter) { $conditions = $filter->getCondition(); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; if ($value_from) { $this->data_source->where('%n >= ?', $filter->getColumn(), $value_from); } if ($value_to) { $this->data_source->where('%n <= ?', $filter->getColumn(), $value_to); } }
/** * @param mixed $row * @param FilterRange $filter * @return void */ public function applyFilterRange($row, FilterRange $filter) { $condition = $filter->getCondition(); $values = $condition[$filter->getColumn()]; if ($values['from'] !== NULL && $values['from'] !== '') { if ($values['from'] > $row[$filter->getColumn()]) { return FALSE; } } if ($values['to'] !== NULL && $values['to'] !== '') { if ($values['to'] < $row[$filter->getColumn()]) { return FALSE; } } return TRUE; }
/** * Filter by range * @param Filter\FilterRange $filter */ public function applyFilterRange(Filter\FilterRange $filter) { $conditions = $filter->getCondition(); $c = $this->checkAliases($filter->getColumn()); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; if ($value_from) { $p = $this->getPlaceholder(); $this->data_source->andWhere("{$c} >= ?{$p}")->setParameter($p, $value_from); } if ($value_to) { $p = $this->getPlaceholder(); $this->data_source->andWhere("{$c} <= ?{$p}")->setParameter($p, $value_to); } }
/** * Filter by range * * @param Filter\FilterRange $filter * * @return void */ public function applyFilterRange(Filter\FilterRange $filter) { $conditions = $filter->getCondition(); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; if ($value_from) { $this->filter["{$filter->getColumn()} >= ?"] = $value_from; } if ($value_to) { $this->filter["{$filter->getColumn()} <= ?"] = $value_to; } }
/** * Filter by range * @param Filter\FilterRange $filter * @return void */ public function applyFilterRange(Filter\FilterRange $filter) { $conditions = $filter->getCondition(); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; if ($value_from) { $this->data_source->getQueryBuilder()->andWhere("%column >= %any", $filter->getColumn(), $value_from); } if ($value_to) { $this->data_source->getQueryBuilder()->andWhere("%column <= %any", $filter->getColumn(), $value_to); } }
/** * Filter by range * @param Filter\FilterRange $filter * @return void */ public function applyFilterRange(Filter\FilterRange $filter) { $conditions = $filter->getCondition(); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; if ($value_from) { $this->applyWhere($filter->getColumn(), $value_from, '>='); } if ($value_to) { $this->applyWhere($filter->getColumn(), $value_to, '<='); } }