Get php format for datapicker
public getPhpFormat ( ) : string | ||
return | string |
/** * Filter by date range * @param Filter\FilterDateRange $filter * @return void */ public function applyFilterDateRange(Filter\FilterDateRange $filter) { $conditions = $filter->getCondition(); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; if ($value_from) { $date_from = DateTimeHelper::tryConvertToDateTime($value_from, [$filter->getPhpFormat()]); $date_from->setTime(0, 0, 0); $this->data_source->where("CONVERT(varchar(10), {$filter->getColumn()}, 112) >= ?", $date_from->format('Ymd')); } if ($value_to) { $date_to = DateTimeHelper::tryConvertToDateTime($value_to, [$filter->getPhpFormat()]); $date_to->setTime(23, 59, 59); $this->data_source->where("CONVERT(varchar(10), {$filter->getColumn()}, 112) <= ?", $date_to->format('Ymd')); } }
/** * Filter by date range * @param Filter\FilterDateRange $filter * @return void */ public function applyFilterDateRange(Filter\FilterDateRange $filter) { $conditions = $filter->getCondition(); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; if ($value_from) { $date_from = \DateTime::createFromFormat($filter->getPhpFormat(), $value_from); $date_from->setTime(0, 0, 0); $this->data_source->where("CONVERT(varchar(10), {$filter->getColumn()}, 112) >= ?", $date_from->format('Y-m-d')); } if ($value_to) { $date_to = \DateTime::createFromFormat($filter->getPhpFormat(), $value_to); $date_to->setTime(23, 59, 59); $this->data_source->where("CONVERT(varchar(10), {$filter->getColumn()}, 112) <= ?", $date_to->format('Y-m-d')); } }
/** * Filter by date range * @param Filter\FilterDateRange $filter * @return void */ public function applyFilterDateRange(Filter\FilterDateRange $filter) { $values = $conditions[$filter->getColumn()]; if ($value_from = $values['from']) { $date_from = \DateTime::createFromFormat($filter->getPhpFormat(), $value_from)->setTime(0, 0, 0)->format('Y-m-d H:i:s'); $expr = Criteria::expr()->gte($filter->getColumn(), $date_from); $this->criteria->andWhere($expr); } if ($value_to = $values['to']) { $date_to = \DateTime::createFromFormat($filter->getPhpFormat(), $value_to)->setTime(23, 59, 59)->format('Y-m-d H:i:s'); $expr = Criteria::expr()->lte($filter->getColumn(), $date_to); $this->criteria->andWhere($expr); } }
/** * Filter by date range * @param Filter\FilterDateRange $filter * @return void */ public function applyFilterDateRange(Filter\FilterDateRange $filter) { $conditions = $filter->getCondition(); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; if ($value_from) { $date_from = \DateTime::createFromFormat($filter->getPhpFormat(), $value_from); $date_from->setTime(0, 0, 0); $this->data_source->where('DATE(%n) >= ?', $filter->getColumn(), $date_from); } if ($value_to) { $date_to = \DateTime::createFromFormat($filter->getPhpFormat(), $value_to); $date_to->setTime(23, 59, 59); $this->data_source->where('DATE(%n) <= ?', $filter->getColumn(), $date_to); } }
/** * Filter by date range * @param Filter\FilterDateRange $filter * @return void */ public function applyFilterDateRange(Filter\FilterDateRange $filter) { $conditions = $filter->getCondition(); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; $dataCondition = []; if ($value_from) { $date_from = \DateTime::createFromFormat($filter->getPhpFormat(), $value_from); $dataCondition[$this->prepareColumn($filter->getColumn()) . '>='] = $date_from->setTime(0, 0, 0); } if ($value_to) { $date_to = \DateTime::createFromFormat($filter->getPhpFormat(), $value_to); $dataCondition[$this->prepareColumn($filter->getColumn()) . '<='] = $date_to->setTime(23, 59, 59); } if (!empty($dataCondition)) { $this->data_source = $this->data_source->findBy($dataCondition); } }
/** * @param mixed $row * @param FilterDateRange $filter * @return void */ public function applyFilterDateRange($row, FilterDateRange $filter) { $format = $filter->getPhpFormat(); $condition = $filter->getCondition(); $values = $condition[$filter->getColumn()]; $row_value = $row[$filter->getColumn()]; if ($values['from'] !== NULL && $values['from'] !== '') { $date_from = DateTimeHelper::tryConvertToDate($values['from'], [$format]); $date_from->setTime(0, 0, 0); if (!$row_value instanceof \DateTime) { /** * Try to convert string to DateTime object */ try { $row_value = DateTimeHelper::tryConvertToDate($row_value); } catch (DataGridDateTimeHelperException $e) { /** * Otherwise just return raw string */ return FALSE; } } if ($row_value->getTimeStamp() < $date_from->getTimeStamp()) { return FALSE; } } if ($values['to'] !== NULL && $values['to'] !== '') { $date_to = DateTimeHelper::tryConvertToDate($values['to'], [$format]); $date_to->setTime(23, 59, 59); if (!$row_value instanceof \DateTime) { /** * Try to convert string to DateTime object */ try { $row_value = DateTimeHelper::tryConvertToDate($row_value); } catch (DataGridDateTimeHelperException $e) { /** * Otherwise just return raw string */ return FALSE; } } if ($row_value->getTimeStamp() > $date_to->getTimeStamp()) { return FALSE; } } return TRUE; }
/** * Filter by date range * @param Filter\FilterDateRange $filter */ public function applyFilterDateRange(Filter\FilterDateRange $filter) { $conditions = $filter->getCondition(); $c = $this->checkAliases($filter->getColumn()); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; if ($value_from) { $date_from = \DateTime::createFromFormat($filter->getPhpFormat(), $value_from); $date_from->setTime(0, 0, 0); $p = $this->getPlaceholder(); $this->data_source->andWhere("{$c} >= ?{$p}")->setParameter($p, $date_from->format('Y-m-d H:i:s')); } if ($value_to) { $date_to = \DateTime::createFromFormat($filter->getPhpFormat(), $value_to); $date_to->setTime(23, 59, 59); $p = $this->getPlaceholder(); $this->data_source->andWhere("{$c} <= ?{$p}")->setParameter($p, $date_to->format('Y-m-d H:i:s')); } }
/** * Filter by date range * * @param Filter\FilterDateRange $filter * * @return void */ public function applyFilterDateRange(Filter\FilterDateRange $filter) { $conditions = $filter->getCondition(); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; if ($value_from) { $date_from = \DateTime::createFromFormat($filter->getPhpFormat(), $value_from); $date_from->setTime(0, 0, 0); $this->filter["DATE({$filter->getColumn()}) >= ?"] = $date_from->format('Y-m-d'); } if ($value_to) { $date_to = \DateTime::createFromFormat($filter->getPhpFormat(), $value_to); $date_to->setTime(23, 59, 59); $this->filter["DATE({$filter->getColumn()}) <= ?"] = $date_to->format('Y-m-d'); } }
/** * Filter by date range * @param Filter\FilterDateRange $filter * @return void */ public function applyFilterDateRange(Filter\FilterDateRange $filter) { $conditions = $filter->getCondition(); $value_from = $conditions[$filter->getColumn()]['from']; $value_to = $conditions[$filter->getColumn()]['to']; if ($value_from) { $date_from = \DateTime::createFromFormat($filter->getPhpFormat(), $value_from); $date_from; $this->data_source->getQueryBuilder()->andWhere("%column >= %dt", $filter->getColumn(), $date_from); } if ($value_to) { $date_to = \DateTime::createFromFormat($filter->getPhpFormat(), $value_to); $date_to->setTime(23, 59, 59); $this->data_source->getQueryBuilder()->andWhere("%column <= %dt", $filter->getColumn(), $date_to); } }
/** * Filter by date range * @param Filter\FilterDateRange $filter * @return void */ public function applyFilterDateRange(Filter\FilterDateRange $filter) { $values = $conditions[$filter->getColumn()]; if ($value_from = $values['from']) { $date_from = DateTimeHelper::tryConvertToDateTime($value_from, [$filter->getPhpFormat()]); $date_from->setTime(0, 0, 0); $expr = Criteria::expr()->gte($filter->getColumn(), $date_from->format('Y-m-d H:i:s')); $this->criteria->andWhere($expr); } if ($value_to = $values['to']) { $date_to = DateTimeHelper::tryConvertToDateTime($value_to, [$filter->getPhpFormat()]); $date_to->setTime(23, 59, 59); $expr = Criteria::expr()->lte($filter->getColumn(), $date_to->format('Y-m-d H:i:s')); $this->criteria->andWhere($expr); } }