doutangtan6386
2018-07-26 04:17
浏览 81
已采纳

Laravel 3表Eloquent:关系

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

图片转代码服务由CSDN问答提供 功能建议

我有3个表

角色

id`````````````````````

1````````````员工

权限 < / strong>

id``````` | ``````````````````````

1```````````Manage All Projects

2`````````` “管理客户端”

acces_permissions

id_permission FK | id_role FK
```````````````````````````1

`` `````````````````````````````````1

我会有一张表

角色| 权限名称|

员工| 管理所有项目管理客户端|

如何使用此3个模型

 类角色扩展Model 
class权限扩展Model 
class  acces_permissions扩展了Model 
   
 
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

3条回答 默认 最新

  • dongzongpeng6474 2018-07-26 04:28
    已采纳

    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.

    评论
    解决 无用
    打赏 举报
查看更多回答(2条)

相关推荐 更多相似问题