I have 3 tables
roles
id `````` |```` `` role ```````` |
1 `````` ```````` Staff
permissions
id ````````| `````````` Name ```````````` |
1 ````````````Manage All Projects
2 ```````````` Manage Clients
acces_permissions
id_permission FK | id_role FK
`````` `` 1 ```````````````````` 1
```````` 2 ```````````````````` 1
and i will have a table with
roles | permissions Name |
Staff | Manage All Projects Manage Clients |
how can o this whit this 3 Models
class roles extends Model
class permissions extends Model
class acces_permissions extends Model
correct me if im wrong, what you are trying to achieve is get all permissions using the role of a user ..
the easiest way is to use belongsToMany
eloquent relation, in your Role model add this
public function permissions()
{
return $this->belongsToMany('App\Permissions', 'access_permission_table', 'id_role', 'id_permission');
}
this way, when you call $role->permissions, you'll get all the permission for that role.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments