Permissions or roles are always empties when using All , Latests methods

[fabinou]

Hello to everybody,

I am new at Laravel and Spatie, and I am facing a weird problem (but i hope simple for you experts !)

Using :

• Laravel Framework 8.51.0
• spatie/laravel-permission
• PHP 7.3.7

If i do this in my user controller code, it's work's fine :

<?php

namespace App\Http\Controllers;



use Illuminate\Http\Request;
use App\Models\Users;

use Spatie\Permission\Models\Role;
use Spatie\Permission\Models\Permission;
use Illuminate\Support\Facades\Auth;

use DB;
use Hash;
use Illuminate\Support\Arr;

use App\Http\Controllers\AppBaseController;

use Flash;
use Response;

class usersController extends AppBaseController
{

public function index(Request $request)
    {
       

        $user = Users::findOrFail(1);
        $user->givePermissionTo('lire utilisateur');
        dd($user);
  
        return view('users.index', compact('data'))
            ->with('i', ($request->input('page', 1) - 1) * 5);
    }
}

I can see DB table model_has_permissions is updated,

permission_id | model_type | model_id
 4 | App\Models\Users | 1

and my Object is containing the permission :

App\Models\Users {#1633 ▼ #guard_name: "web" #dates: array:1 [▶] +fillable: array:6 [▶] #hidden: array:2 [▶] #casts: array:8 [▶] #connection: "mysql" #table: "users" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #attributes: array:10 [▶] #original: array:10 [▶] #changes: [] #classCastCache: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: array:1 [▶] #touches: [] +timestamps: true #visible: [] #guarded: array:1 [▶] #rememberTokenName: "remember_token" #forceDeleting: false -roleClass: null -permissionClass: Spatie\Permission\Models\Permission {#1585 ▶} }

But if try to get a list of all users with permissions/roles, using this snippet :

    public function index(Request $request)
    {
      
        $data = Users::latest()->paginate(20);
        dd($data);
      
    }

This is time, the permissionClass is alway null :

 #items: Illuminate\Database\Eloquent\Collection {#1652 ▼
    #items: array:6 [▼
      0 => App\Models\Users {#1641 ▼
        #guard_name: "web"
        #dates: array:1 [▶]
        +fillable: array:6 [▶]
        #hidden: array:2 [▶]
        #casts: array:8 [▶]
        #connection: "mysql"
        #table: "users"
        #primaryKey: "id"
        #keyType: "int"
        +incrementing: true
        #with: []
        #withCount: []
        +preventsLazyLoading: false
        #perPage: 15
        +exists: true
        +wasRecentlyCreated: false
        #attributes: array:10 [▶]
        #original: array:10 [▶]
        #changes: []
        #classCastCache: []
        #dateFormat: null
        #appends: []
        #dispatchesEvents: []
        #observables: []
        #relations: []
        #touches: []
        +timestamps: true
        #visible: []
        #guarded: array:1 [▶]
        #rememberTokenName: "remember_token"
        #forceDeleting: false
        -roleClass: null
        -permissionClass: null
      }

My App\Models\Users looks like this :

namespace App\Models;


use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;

use Spatie\Permission\Traits\HasRoles;
class Users extends Authenticatable
{
    use SoftDeletes, HasRoles, Notifiable;
    protected $guard_name = 'web';
    public $table = 'users';

    const CREATED_AT = 'created_at';
    const UPDATED_AT = 'updated_at';


    protected $dates = ['deleted_at'];



    public $fillable = [
        'nom',
        'prenom',
        'email',
        'email_verified_at',
        'password',
        'remember_token'
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];
    /**
     * The attributes that should be casted to native types.
     *
     * @var array
     */
    protected $casts = [
        'id' => 'integer',
        'nom' => 'string',
        'prenom' => 'string',
        'email' => 'string',
        'email_verified_at' => 'datetime',
        'password' => 'string',
        'remember_token' => 'string'
    ];

    /**
     * Validation rules
     *
     * @var array
     */
    public static $rules = [
        'nom' => 'required',
        'prenom' => 'required',
        'email' => 'required',
        'password' => 'required'
    ];
}

And i have edited config\auth.php in consequences :

   'providers' => [
        'users' => [
            'driver' => 'eloquent',
            'model' => App\Models\Users::class,
        ],

Any ideas what i am doing wrong ?

Thanks a lot for your help

[fredsal]

Try

$data = Users::latest()->with('permissions')->paginate(20);

[fabinou]

Hello

Thanks a lot for your help, unfortunatly, same thing, no permissions/roles (but i have the same number of users returning)

[fredsal]

Try

$data = Users::latest()->with(['permissions','roles'])->limit(20)->get();
dd($data->toArray());

You have to look #relations: array:1 [▶] not permissionClass

[fabinou]

wow, works like a charm !! Can you please explain what i was doing wrong ? (i followed this tutorial )

A thousand thanks !

[fredsal]

permissionClass is internal from laravel, #relations: array:1 [▶] is the propertie wich brings the relationships
So you have to do

$data = Users::with(['permissions','roles'])->find(1);
dd($data->permissions);

It's on the docs of laravel, it don't belongs to this package
https://laravel.com/docs/8.x/eloquent-relationships#eager-loading