user模型:
protected $table='login'; protected $pk='id'; public function getrole(){ return $this->belongsToMany(role::class,'u_r','role_id','id'); } public function show($name){ return $this->where('name',$name)->with('getrole.get')->find(); }
角色role模型:
protected $table='role'; protected $pk='role_id'; public function get(){ return $this->belongsToMany(power::class,'power_role','power_id','role_id'); }
用户角色表u_r:
权限power模型:
protected $table='power';
protected $pk='power_id';
角色全选表power_role 模型:
protected $table='power_role'; protected $pk='power_id';
用户user控制器:
public function dologin(Request $request){ $name =$request->param('name'); $pwd =$request->param('pwd'); $data =new loginmodel(); $res =$data->dologin($name,$pwd); if ($res==1){ $token =JWTAuth::builder(['name'=>$name,'pwd'=>$pwd]); return success(200,'登录成功',$data=['token'=>$token]); }elseif ($res ==2 ){ return success(300,'密码错误',$data=['pwd'=>$pwd]); }elseif ($res == 3){ return success(500,'账号不存在',$data=['name'=>$name]); } } public function token($id=1,$name=123){ $token =JWTAuth::builder(['uid'=>$id,'name'=>$name]); return $token; } //联查 public function show(Request $request){ $name = $request->param('name'); $data =new \app\admin\model\login(); $obj = $data->show($name)->toArray(); return dd($obj); }