App\Http\Controllers\StudentController::search()

Complexity

Conditions	3
Paths	4

Size

Total Lines	21
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function search(Request $request)
    {
        // If the user is not allowed to perform this action
        if (Gate::forUser(backpack_user())->denies('enroll-students')) {
            abort(403);
        }

        $data = [];

        if ($request->has('q')) {
            $search = $request->q;

            $data = DB::table('students')
                    ->select('students.id', 'users.firstname', 'users.lastname')
                    ->join('users', 'students.id', '=', 'users.id')
                    ->where('users.firstname', 'LIKE', "%$search%")
                    ->orWhere('users.lastname', 'LIKE', "%$search%")
                    ->get();
        }

        return response()->json($data);
    }