Ublaboo\DataGrid\Filter\FilterDateRange::getPhpFormat PHP Method

getPhpFormat() public method

Get php format for datapicker
public getPhpFormat ( ) : string
return string
    public function getPhpFormat()
    {
        return $this->format[0];
    }

Usage Example

 /**
  * 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'));
     }
 }
All Usage Examples Of Ublaboo\DataGrid\Filter\FilterDateRange::getPhpFormat