Consolidate the search block

Hi All,

I have two blocks used for searching for active users and all users. Is there a way I can conditonally build this query and not repeat code?

Heres my current working example below.

public function getSearch($request)
    {
        $search = $request['search'] ? $request['search'] : '';
        $active = $request['active'] ? $request['active'] : 0;
        $result = null;

        if (isset($search) || isset($active)) {
            $result = ExUser::where('name', 'LIKE', '%' . $search . '%')
                ->orWhere('gecos', 'LIKE', '%' . $search . '%')
                ->orWhere('email', 'LIKE', '%' . $search . '%')
                ->orWhere('uid', 'LIKE', '%' . $search . '%')
                ->orderBy('uid', 'DESC');

            if ($active) {
                $result = ExUser::where('active', 1)->where(function ($query) use ($active, $search){
                    $query->where('name', 'LIKE', '%' . $search . '%')
                        ->orWhere('gecos', 'LIKE', '%' . $search . '%')
                        ->orWhere('email', 'LIKE', '%' . $search . '%')
                        ->orWhere('uid', 'LIKE', '%' . $search . '%')
                        ->orderBy('uid', 'DESC');
                });
            }

            $result = $result->paginate(100);
            return $result;
        }
    }

public function getSearch($request) { $search = $request['search'] ? $request['search'] : ''; $active = $request['active'] ? $request['active'] : 0; if (isset($search) || isset($active)) { return ExUser::where(function ($query) use ($active, $search){ $query = $query->where('name', 'LIKE', '%' . $search . '%') ->orWhere('gecos', 'LIKE', '%' . $search . '%') ->orWhere('email', 'LIKE', '%' . $search . '%') ->orWhere('uid', 'LIKE', '%' . $search . '%') ->orderBy('uid', 'DESC'); if ($active) { $query = $query->where('active', 1); } return $query; })->paginate(100); } }

Moderators