Dcat Admin复杂搜索

 $filter->whereBetween('create_time', function ($query) {
       $query->where('create_time', '>=', strtotime($this->input['start']));
       $query->where('create_time', '<=', strtotime($this->input['end']));
 })->datetime();Copy

protected function grid()
{
  return Grid::make(UserAddress::with('member'), function (Grid $grid) {
        $grid->model()->orderBy('create_time', 'desc');// 默认排序
        $grid->column('id')->sortable();
        $grid->column('user_id');
        $grid->column('member.username', '手机号');
        $grid->column('address');
        $grid->column('create_time')->sortable();

        $grid->filter(function (Grid\Filter $filter) {
            $filter->equal('id');
            $filter->where('mobile', function ($query) {
                $query->whereHas('member', function ($query) {
                    $query->where('mobile', 'like', "%{$this->input}%");
                });
            }, '手机号');
        });
    });
}Copy