php - 我正在尝试在 Laravel 数据库上使用多个过滤器

Question

我尝试过实现多个过滤器，但每次我针对其中一个过滤器进行过滤时，它都会起作用，但是当针对其他过滤器进行过滤时，查询仅接受一个过滤器。

我的注册 Controller :allCandidates

public function allCandidates(){

        $candidates = new Candidate;

        $queries = [];

        $columns = [
            'field', 'qualification',
        ];

        foreach ($columns as $column) {
            if (request()->has($column)) {
                $candidates = $candidates->where($column, request($column));
                $queries[$column] = request($column);
            }
        }
        if (request()->has('sort')) {
            $candidates =$candidates->orderBy('surname', request('sort'));
            $queries['sort'] = request('sort');
        }
        $candidates =$candidates->paginate(10)->appends($queries);
        return view('contact.candidates', compact('candidates'));
    }

Answer 1

重写代码如下:

public function allCandidates(){

        $candidates = new Candidate;

        $columns = [
            'field', 'qualification',
        ];

        foreach ($columns as $column) {
            if (request()->has($column)) {
                $candidates->where($column, request($column));
            }
        }
        if (request()->has('sort')) {
            $candidates->orderBy('surname', request('sort'));
        }
        $candidates->paginate(10);
        return view('contact.candidates', compact('candidates'));
    }

不需要在一次之后重新初始化$candidates变量。只需添加过滤器或使用对象 $candidates 调用其他函数即可。