Beispiel #1
0
 /**
  * Фильтр: диапазон дат
  *
  * @param      $form_field
  * @param      $label
  * @param null $db_field
  */
 function addFilterRangeDate($form_field, $label, $db_field = null)
 {
     if (!$db_field) {
         $db_field = $form_field;
     }
     $gr = $this->form->putTbGroup($form_field)->setLabel($label);
     $gr->putTbDate('from')->setLabel('С')->setWrapClass('col-md-6')->setAppendClear();
     $gr->putTbDate('to')->setLabel('по')->setWrapClass('col-md-6')->setAppendClear();
     $from = \Input::get($form_field . '.from');
     $to = \Input::get($form_field . '.to');
     if ($from) {
         $this->model->where(function ($query) use($db_field, $from) {
             $query->where($db_field, '>=', \Carbon\Carbon::parse($from)->format('Y-m-d H:i:s'));
         });
     }
     if ($to) {
         $this->model->where(function ($query) use($db_field, $to) {
             $query->where($db_field, '<=', \Carbon\Carbon::parse($to)->format('Y-m-d H:i:s'));
         });
     }
 }