Eloquent relations - query rows to columns

0
votes

I have three tables:

  • users {id, first_name, last_name}
  • applicants {id, first_name, last_name ......}
  • marks {id, applicant_id, user_id, mark}

Table marks holds two foreign keys (applicant_id and user_id). So, the logic is like this: there are a lot of applicants and a few users. The user need to review every applicant and set some mark for him.

Desired output is to show (almost) all columns (attributes) from table "applicants", and to attach another column for each row from table "users", with users.last_name in "header" and desired mark in "body" for that applicant.

I'm using Laravel and Eloquent in this application and have no idea how to reach this.

1
phpmysqllaravelrelational-databaseeloquent

1 Answers

1
votes

Define this relationship:

class Applicant extends Eloquent {
    public function users(){
        return $this->belongsToMany('User', 'marks')->withPivot('mark');
    }
}

Usage:

$applicants = Applicant::with('users')->get();
foreach($applicants as $applicant){
    echo $applicant->first_name; // etc...
    foreach($applicant->users as $user){
        echo $user->last_name;
        echo $user->pivot->mark;
    }
}