Laravel Eloquent模型复杂查询

Question

I am logged in as the first student in the table. I want to retrieve a list of all the students who are within the same department as mine and whom I didn't send a request to yet, using Eloquent model.

//Requestt.php
public function student()
{
    return $this->belongsto('App\Student','id', 'Sender_id','Rec_id');
}

//Student.php
public function requestts()
{
    return $this->hasMany('App\Requestt', 'id');
}

public function department()
{    
    return $this->belongsTo('App\Department');
}

Note: Don't mind the double "t" in requestt.

Answer 1

Possible Solution

// you may have the logged in student in your hand.
// for the example, I'll take the first.
$logged_in_student = Student::first();

$other_students = Student::where('department_id', $logged_in_student->department_id)
    ->whereDoesntHave('requestts', function($query) use($logged_in_student) {
        $query->where('Rec_id', $logged_in_student->id);
    })
    ->get();

Explanation

The first where clause is to filter students who are in the same department.
The second whereDoesntHave clause is to filter students who has no requestts from logged in student.