/** * Filter by date * @param Filter\FilterDate $filter * @return void */ public function applyFilterDate(Filter\FilterDate $filter) { $conditions = $filter->getCondition(); $date = \DateTime::createFromFormat($filter->getPhpFormat(), $conditions[$filter->getColumn()]); $ymd = $date->format('Ymd'); $this->data_source->where('CONVERT(varchar(10), %n, 112) = ?', $filter->getColumn(), $ymd); }
/** * Filter by date * @param Filter\FilterDate $filter * @return void */ public function applyFilterDate(Filter\FilterDate $filter) { foreach ($filter->getCondition() as $column => $value) { $date = \DateTime::createFromFormat($filter->getPhpFormat(), $value)->format('Y-m-d H:i:s'); $from = Criteria::expr()->gte($filter->getColumn(), $date->format('Y-m-d 00:00:00')); $to = Criteria::expr()->lte($filter->getColumn(), $date->format('Y-m-d 23:59:59')); $this->criteria->andWhere($from)->andWhere($to); } }
/** * Filter by date * @param Filter\FilterDate $filter * @return static */ public function applyFilterDate(Filter\FilterDate $filter) { foreach ($filter->getCondition() as $column => $value) { $date = \DateTime::createFromFormat($filter->getPhpFormat(), $value); $date_end = clone $date; $this->data_source = $this->data_source->findBy([$this->prepareColumn($column) . '>=' => $date->setTime(0, 0, 0), $this->prepareColumn($column) . '<=' => $date_end->setTime(23, 59, 59)]); } return $this; }
/** * Filter by date * @param Filter\FilterDate $filter * @return void */ public function applyFilterDate(Filter\FilterDate $filter) { foreach ($filter->getCondition() as $column => $value) { $date = DateTimeHelper::tryConvertToDateTime($value, [$filter->getPhpFormat()]); $from = Criteria::expr()->gte($filter->getColumn(), $date->format('Y-m-d 00:00:00')); $to = Criteria::expr()->lte($filter->getColumn(), $date->format('Y-m-d 23:59:59')); $this->criteria->andWhere($from)->andWhere($to); } }
/** * Filter by date * @param Filter\FilterDate $filter * @return void */ public function applyFilterDate(Filter\FilterDate $filter) { $conditions = $filter->getCondition(); $date = \DateTime::createFromFormat($filter->getPhpFormat(), $conditions[$filter->getColumn()]); $this->data_source->where('DATE(%n) = ?', $filter->getColumn(), $date->format('Y-m-d')); }
/** * Filter by date * @param Filter\FilterDate $filter * @return void */ public function applyFilterDate(Filter\FilterDate $filter) { $conditions = $filter->getCondition(); $date = DateTimeHelper::tryConvertToDateTime($conditions[$filter->getColumn()], [$filter->getPhpFormat()]); $this->data_source->where("CONVERT(varchar(10), {$filter->getColumn()}, 112) = ?", $date->format('Ymd')); }
/** * Filter by date * @param Filter\FilterDate $filter * @return void */ public function applyFilterDate(Filter\FilterDate $filter) { $conditions = $filter->getCondition(); $date = DateTimeHelper::tryConvertToDateTime($conditions[$filter->getColumn()], [$filter->getPhpFormat()]); $this->data_source->where("DATE({$filter->getColumn()}) = ?", $date->format('Y-m-d')); }
/** * Apply fitler date and tell whether row value matches or not * @param mixed $row * @param Filter $filter * @return mixed */ protected function applyFilterDate($row, FilterDate $filter) { $format = $filter->getPhpFormat(); $condition = $filter->getCondition(); foreach ($condition as $column => $value) { $row_value = $row[$column]; $date = DateTimeHelper::tryConvertToDateTime($value, [$format]); if (!$row_value instanceof \DateTime) { /** * Try to convert string to DateTime object */ try { $row_value = DateTimeHelper::tryConvertToDateTime($row_value); } catch (DataGridDateTimeHelperException $e) { /** * Otherwise just return raw string */ return FALSE; } } return $row_value->format($format) == $date->format($format); } }
/** * Filter by date * @param Filter\FilterDate $filter * @return void */ public function applyFilterDate(Filter\FilterDate $filter) { $conditions = $filter->getCondition(); $date = \DateTime::createFromFormat($filter->getPhpFormat(), $conditions[$filter->getColumn()]); $this->data_source->where("CONVERT(varchar(10), {$filter->getColumn()}, 112) = ?", $date->format('Y-m-d')); }
/** * Filter by date * @param Filter\FilterDate $filter */ public function applyFilterDate(Filter\FilterDate $filter) { $p1 = $this->getPlaceholder(); $p2 = $this->getPlaceholder(); foreach ($filter->getCondition() as $column => $value) { $date = \DateTime::createFromFormat($filter->getPhpFormat(), $value); $c = $this->checkAliases($column); $this->data_source->andWhere("{$c} >= ?{$p1}")->andWhere("{$c} <= ?{$p2}")->setParameter($p1, $date->format('Y-m-d 00:00:00'))->setParameter($p2, $date->format('Y-m-d 23:59:59')); } }
/** * Filter by date * * @param Filter\FilterDate $filter * * @return void */ public function applyFilterDate(Filter\FilterDate $filter) { $conditions = $filter->getCondition(); $date = \DateTime::createFromFormat($filter->getPhpFormat(), $conditions[$filter->getColumn()]); $this->filter["DATE({$filter->getColumn()}) = ?"] = $date->format('Y-m-d'); }
/** * Filter by date * @param Filter\FilterDate $filter * @return static */ public function applyFilterDate(Filter\FilterDate $filter) { foreach ($filter->getCondition() as $column => $value) { $date = \DateTime::createFromFormat($filter->getPhpFormat(), $value); $date_end = clone $date; $this->data_source->getQueryBuilder()->andWhere("%column >= %dt", $column, $date->setTime(0, 0, 0))->andWhere("%column <= %dt", $column, $date_end->setTime(23, 59, 59)); } return $this; }