This is a sample of datafilter + dataset.
The filter is using a custom query scope.
The filter is passed to a DataSet (to paginate results and enable order by features)
On the layout-side, we customize filter output by using partial render
(form open, form close and src field)
then we do a simple foreach on dataset "data" to display resultset.
class DemoController extends Controller
....
public function getCustomfilter() { $filter = \DataFilter::source(Article::with('author','categories')); $filter->text('src','Search')->scope('freesearch'); $filter->build();
public function scopeFreesearch($query, $value) { return $query->where('title','like','%'.$value.'%') ->orWhere('body','like','%'.$value.'%') ->orWhereHas('author', function ($q) use ($value) { $q->whereRaw(" CONCAT(firstname, ' ', lastname) like ?", array("%".$value."%")); })->orWhereHas('categories', function ($q) use ($value) { $q->where('name','like','%'.$value.'%'); });
<div class="col-sm-4"> This is a sample of datafilter + dataset.<br /> The filter is using a custom <strong>query scope</strong>.<br /> The filter is passed to a DataSet (to paginate results and enable order by features)<br /> <br /> On the layout-side, we customize filter output by using partial render (form open, form close and src field)<br /> then we do a simple foreach on dataset "data" to display resultset.<br /> <br /> </div> </div> </div>