Esempi in PHP per Ublaboo\DataGrid\Filter FilterDate::getColumn

Esempio n. 1

File: DibiFluentMssqlDataSource.php Progetto: romanmatyus/datagrid

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

Esempio n. 2

File: DoctrineCollectionDataSource.php Progetto: ublaboo/datagrid

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

Esempio n. 3

File: DibiFluentDataSource.php Progetto: OCC2/occ2pacs

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

Esempio n. 4

File: NetteDatabaseTableMssqlDataSource.php Progetto: ublaboo/datagrid

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

Esempio n. 5

File: NetteDatabaseTableDataSource.php Progetto: ublaboo/datagrid

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

Esempio n. 6

File: NetteDatabaseTableMssqlDataSource.php Progetto: OCC2/occ2pacs

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

Esempio n. 7

File: RepositorySource.php Progetto: mepatek/application

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

Esempio n. 8

File: DoctrineCollectionDataSource.php Progetto: ublaboo/datagrid

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