Laravel Database Query

I need a little help with a solution.... I have two tables , one for students, one for payments... now i want to fetch list of debtors in the school.... , on the payment table, there is a student_id , so every student that has paid will have their ID recorded on the payment table...…

Now, i want to do something like , if student id is not on the payment table, fetch data, how do i do this in Laravel....

Nakov

4 years ago

Best Answer

Level 73

In your Student model add this:

public function payments()
{
    return $this->hasMany(Payment::class);
}

Then you can do this:

$students = Student::doesntHave('payments')->get();

These will be all the students that don't have a payment recorded yet.

https://laravel.com/docs/master/eloquent-relationships#querying-relationship-absence

2 likes

Please or to participate in this conversation.