/**
* 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, '<=');
}
}
