Laravel实现从禁用文本、复选框取值存入role_permission表的方法
Laravel角色权限存储报错修复方案
核心问题说明
你当前代码的问题主要出在表单字段命名和控制器存储逻辑两个部分:
- 表单中所有资源的权限复选框共用
Permissions[]名称,提交后无法区分某条权限属于哪个资源项 - 控制器中直接把整个数组赋值给字符串类型的
Item、Permission字段,会触发类型错误 - 插入数据的逻辑写在循环外部,只会生成一条记录,不符合单条权限单条记录的需求
- 两层循环共用同一个
$key变量,会导致索引覆盖
第一步:修改表单代码
给每个资源项的权限复选框加上和Items数组对应的索引,让提交后可以匹配权限所属的资源:
<form method="post" action="{{ route('Admin.AssignPermission.save')}}" enctype="multipart/form-data"> @csrf @if ($errors->any()) <div class="alert alert-danger alert-dismissable"> <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button> <ul> @foreach ($errors->all() as $error) <li>{{ $error }}</li> @endforeach </ul> </div> @endif <div class="form-group"> <label> Assign Roles</label> <select style="margin-left: 10px;" class="form-select" aria-label="Default Select Role" name="Roles"> <option selected disabled>Roles</option> @foreach ($roles as $role) <option value="{{$role->id}}">{{$role->name}}</option> @endforeach </select> </div> <table class="table table-striped"> <thead> <tr> <th scope="col">#</th> <th scope="col">Add</th> <th scope="col">View</th> <th scope="col">Edit</th> <th scope="col">Delete</th> </tr> </thead> <tbody> <!-- Post资源 索引为0 --> <tr id="post"> <th class="col-md-6"> <input class="form-control" type="text" name="Items[0]" value="Post" readonly> </th> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="Add" name="Permissions[0][]"> </div> </td> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="View" name="Permissions[0][]"> </div> </td> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="Edit" name="Permissions[0][]"> </div> </td> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="Delete" name="Permissions[0][]"> </div> </td> </tr> <!-- Comments资源 索引为1 --> <tr> <th class="col-md-6" id="Comments" > <input class="form-control" type="text" name="Items[1]" value="Comments" readonly> </th> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="Add" name="Permissions[1][]"> </div> </td> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="View" name="Permissions[1][]"> </div> </td> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="Edit" name="Permissions[1][]"> </div> </td> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="Delete" name="Permissions[1][]"> </div> </td> </tr> <!-- User资源 索引为2 --> <tr> <th class="col-md-6" id="Users"> <input class="form-control" type="text" name="Items[2]" value="User" readonly> </th> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="Add" name="Permissions[2][]"> </div> </td> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="View" name="Permissions[2][]"> </div> </td> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="Edit" name="Permissions[2][]"> </div> </td> <td> <div class="form-check"> <input class="form-check-input" type="checkbox" value="Delete" name="Permissions[2][]"> </div> </td> </tr> </tbody> </table> <div style="margin-top:5px; margin-left:1030px;"> <input type="submit" class="btn btn-primary" value="Submit"> </div> </form>
说明:去掉了无用的selected隐藏字段,给Items和Permissions都加上了对应索引,提交后Permissions[$index]就对应Items[$index]资源的所有选中权限
第二步:修改控制器逻辑
首先确保你的RolePermission模型已经设置了$fillable允许批量赋值:
// app/Models/RolePermission.php protected $fillable = ['role_id', 'Item', 'Permission'];
然后修改store方法:
public function store(Request $request) { $data = $request->validate([ 'Roles' => 'required' , 'Items.*' =>'required', ]); // 可选优化:先删除该角色原有权限,避免重复存储 RolePermission::where('role_id', $data['Roles'])->delete(); // 循环每个资源项 foreach($request->Items as $index => $itemName) { // 只处理该资源下有选中权限的情况 if (isset($request->Permissions[$index]) && is_array($request->Permissions[$index])) { // 循环该资源下的每个选中权限,单独生成记录 foreach ($request->Permissions[$index] as $permission) { RolePermission::create([ 'role_id' => $data['Roles'], 'Item' => $itemName, 'Permission' => $permission, ]); } } } $Message = "successfully added"; return redirect('/Admin/users')->with('success',$Message); }
说明:调整了循环逻辑,按索引匹配资源和对应权限,每次选中的权限都会单独生成一条数据库记录,符合你的需求
内容的提问来源于stack exchange,提问作者hapuu
相关产品推荐
相关产品推荐

