laravel 增删改查

角色路由

/*角色列表*/
Route::get('/role/index','User\RoleController@index')->name('user.role.index');

//分配权限
Route::get('role/node{role}','User\RoleController@node')->name('user.role.node');
Route::post('role/node{role}','User\RoleController@nodeSever')->name('user.role.node');

角色控制器

<?php

namespace App\Http\Controllers\User;

use App\Http\Controllers\Controller;
use App\Models\Node;
use App\Models\Role;
use Illuminate\Http\Request;
use think\View;

class RoleController extends BaseController
{
   
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
   
        //获取搜索框
        $name = $request->get('name');
        //参数1  变量值存在  则执行  参数2   匿名函数
        $data = Role::when($name,function ($query) use ($name) {
   
           $query->where('name','like',"%{$name}%");
        })->paginate($this->pagesize);

//        $data = Role::paginate($this->pagesize);
       return view('user.role.index',compact('data'));
    }


    // 给角色分配权限
    public function node(Role $role){
   
        // 当前角色有的权限
        $data = $role->nodes()->pluck('id')->toArray();
        // 所有权限
        $nodeAll=(new Node())->getAllList();
        return view('user.role.node',compact('role','nodeAll','data'));
    }

    // 保存角色权限
    public function nodeSever(Request $request,Role $role){
   
        $role->nodes()->sync($request->get('node'));
        return redirect(route('user.role.index',$role));
    }

}

Node模型

// An highlighted block
<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Node extends Base
{
   

    protected $guarded=[];

    // 修改器  route_name路由别名 RouteName set字段名Attribute  字段名首字母大写，遇下划线后字母大写
    public function setRouteNameAttribute($value){
   
        //如果字段值为null，则设置为空字符串    修改和添加时生效  create 或  update
          $this->attributes['route_name'] = empty($value)?'':$value;
    }

    // 访问器  menu => Menu
    public function getMenuAttribute(){
   
        if ($this->is_menu == '1'){
   
            return '<span class="label label-success radius">是</span>';
        }
        return '<span class="label label-danger radius">否</span>';
    }


   //获取全部数据
    public function getAllList(){
   
        $data = self::get()->toArray();
      // dd($this->treelevel($data));
        return $this->treelevel($data);
    }



    //获取层级目录
    public function getMenuData(){
   
        $data = self::where('is_menu','1')->get()->toArray();
        $data = self::formatDate($data);
        $menu =  $this->treeMenu($data);
        return $menu;
    }
}

Role模型

// An highlighted block
<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Role extends Base
{
   

    protected $guarded=[];

    //角色与权限 多对多关联
    public function nodes(){
   
        // 参数1   关联模型
        //参数2    中间表的表名，没有前缀
        //参数3    本模型对应的外键ID
        //参数4    关联模型对应的外键ID