App\Http\Controllers\StudentController

Complexity

Total Complexity

3

Size/Duplication

Total Lines	24
Duplicated Lines	0 %

Importance

Changes	2
Bugs	2	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	search()	0	21	3

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Gate;

class StudentController extends Controller
{
    /* Return search results for enrollment modal */
    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);
    }
}