Php eloquent orm join multiple columns in a table to another table

Question

Let's say I have a table Projects in which in a particular tuple I have many Users. For Example:

Projects

id    project_name    developer    manager    tester
1          w             ww           z          t
2          qq            y          ll         mm
...

Now, developer, manager and tester are user from the Users table. The project table contains the username of the user. Say the Users table is like

Users
    id    username    first_name    last_name    email_add
     1        ww         John         Smith       [email protected]
   ...

and I want to display the information about the project but I need the full name (first_name+" "+last_name) of all the users and not the username which is stored in the Projects table.

What would be an efficient way to approach this?

soredive · Accepted Answer · 2018-10-01 09:31:29Z

1

Use orm relation (see https://laravel.com/docs/5.7/eloquent-relationships#defining-relationships)

and accessor for full name. (see https://laravel.com/docs/5.7/eloquent-mutators#defining-an-accessor)

For example In Project model

class Project extends Model {
.....
     # set relation
     public function developer() {
          return $this->hasOne('App\User', 'developer', 'username');
     }
     public function manager() {
          return $this->hasOne('App\User', 'manager', 'username');
     }
     public function tester() {
          return $this->hasOne('App\User', 'tester', 'username');
     }
.....
}

In User model

class User extends Authenticatable implements Member {
      .....
      # set relation
      public function project() {
           return $this->belongsTo('App\Project', 'user_id');
      }
      .....
      public function getFullNameAttribute(): string {
            if(!$this->cache_full_name) {
                 $this->cache_full_name = $this->first_name . ' ' . $this->last_name;
            }
            return $this->cache_full_name;
      }
      ......
 }

in use

$project = App\Project::query()->first();
echo $project->developer->full_name;
echo $project->manager->full_name;
echo $project->tester->full_name;

edited Oct 1, 2018 at 9:31

answered Oct 1, 2018 at 9:14

soredive

8151 gold badge10 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vikram Singh Over a year ago

I want a way to get the full name of the users(developer, manager, tester) in my projects table

Collectives™ on Stack Overflow

Php eloquent orm join multiple columns in a table to another table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related