Laravel Auth::user relationship

Question

In Laravel, i´m trying to show relation elements between Auth::user (Users) and Departments. In User table i have id, name, and department_id. In Departments table I have id and name.

In user model i create

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

Then, in blade template I try

Auth::user()->department

But return null and doesn´t show linked departments. Null is incorrect, all users have departments. Soo, ¿Any help? ¿What´s wrong in relation?

Saiful Islam · Accepted Answer · 2018-04-04 08:22:29Z

31

You can try this User::with('departmento')->find(Auth::id());

answered Apr 4, 2018 at 8:22

Saiful Islam

6705 silver badges13 bronze badges

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

3 Comments

El Hombre Sin Nombre Over a year ago

Can i use User::with('departament')->find(Auth::id()); in boot to share variable in all templates?

Saiful Islam Over a year ago

In your "Controller/BaseController" add folowwing code:

public function __construct() {        $user = User::with('departament')->find(Auth::id());        View::share('user', $user);     }

Btw, It's not a good idea.

Gilberto Albino Over a year ago

There is no point is querying the database since the Auth have already done that! The missing point is that the author had a foreign key not complaint to Laravel's Eloquent way of relating tables. In this case "singulartablename_id".

acidjazz · Accepted Answer · 2022-03-16 21:09:10Z

19

This method uses less queries - the others go after the user table twice:


auth()->user()->load(['department']);

answered Mar 16, 2022 at 21:09

acidjazz

1,31412 silver badges14 bronze badges

1 Comment

Siraj Ali Over a year ago

It's not working i am getting error.. Class "App\Models\ResellerUserDetailModel" not found. form where you load "load method" ?

Vasyl Sovyak · Accepted Answer · 2018-04-04 08:49:41Z

5

You should add 'department_id' as a second parameter ($foreignKey) when calling belongsTo method, because it will searching for departmento_id by default.

public function departamento()
{
    return $this->belongsTo('App\Models\Departamento', 'department_id');
}

Or just rename User::departamento() method to User::department()

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

answered Apr 4, 2018 at 8:49

Vasyl Sovyak

5192 silver badges5 bronze badges

1 Comment

Gilberto Albino Over a year ago

In fact, you must pass the foreign id since the table is not compliant to Laravel's Eloquent way of relating tables. In this case, if the foreign id is not "singulartablename_id" it won't work.

Niklesh Raut · Accepted Answer · 2018-04-04 08:15:34Z

3

Relation works with Model. Auth uses the session it not uses relation

Use User Model instead

  optional(User::find(Auth::id())->departmento)->department_name

answered Apr 4, 2018 at 8:15

Niklesh Raut

34.9k17 gold badges82 silver badges112 bronze badges

4 Comments

El Hombre Sin Nombre Over a year ago

I use a global variable 'user' with Auth::user() to avoid to repeat code and can show/use actual user in all templates. So your answer is correct but i need it to send Auth::id in all templates...

Niklesh Raut Over a year ago

As you already using Auth::user()->departmento you just need to replace with above code

El Hombre Sin Nombre Over a year ago

{{optional(User::find(Auth::id())->departamento)->name}} Return null

Niklesh Raut Over a year ago

Use \Auth instead

Collectives™ on Stack Overflow

Laravel Auth::user relationship

4 Answers 4

3 Comments

1 Comment

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related