/** * Фильтр: диапазон дат * * @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')); }); } }