users and roles eloquent table relationship

You need to remove the parenthesis

public function isATeamManager()
{
    $roles = Auth::user()->roles->first();
    $role_name = $roles->role_name;
    if($role_name == "manager")
    {
        return true;
    }else{
        return false;
    }
}

Hi mstnorris,

Thanks for your reply. Could you tell me specific spot please? I am not sure which parenthesis you are talking about.

@ryank30 are you sure your Role name is called role_name (in the database that is) ?

What is the exact error you are getting?

I have a column called "role_name" in "roles" table.

@ryank30 where are you calling the method isATeamManager() from?

I am using a middleware called "manager". In that middleware class, I put a line of code inside "handle" function. Please see below:

public function handle($request, Closure $next)
{
    if(!$request->user()->isATeamManager())
    {
        return redirect('articles');
    }

    return $next($request);
}

The function "isATeamManager" is located in User class page.

Inside the function isATeamManager, I ran a test code and got a result of null. Please see below.

public function isATeamManager()
{
    $roles = Auth::user()->roles;
    dd($roles); // I am getting null here.
    $role_name = $roles->role_name;
    if($role_name == "manager")
    {
        return true;
    }else{
        return false;
    }
}

In your routes file can you set up something like this and tell me if you get anything

Route::get('check', function() {
$roles = Auth::user()->roles;
    dd($roles);
}

I have added "use App\Route" and added your code inside the function "isATeamManager". Please see below.

public function isATeamManager()
{
    //$roles = Auth::user()->roles;
    //$roles = \App\Role::all()->first();
    Route::get('check', function() {
        $roles = Auth::user()->roles;
        dd($roles);
    });
    }

I have the error message like below. Class 'App\Route' not found

That's not what I meant.

In your routes.php file add the following

Route::get('check', function() {
$roles = Auth::user()->roles;
    dd($roles);
}

Then go to the url http://yourdomain.com/check and tell me what the output is (if any)

I get null.

Is it necessary to set a foreign key for "role_id" in users table? I was trying to run migration with the code inside up function of creating a users table but I couldn't run it. Please see below.

        $table->foreign('role_id')
            ->references('id')
            ->on('roles');

As far as I understand, the relationship between users and roles should work through "role_id" in users table regardless of the foreign key setting in the database.

Foreign key shouldn't be required.

When you're doing this check in your url.com/check route, you do have a user logged in, right? If there is no user authed, then it will return null.

do a

dd(Auth::user())

to check