'bigint',// 'menuid' =>'bigint',//菜单id 'action_code' =>'varchar',//功能code 'status' =>'int',//状态 'is_del' =>'tinyint',//是否删除,0未删除,1删除 'addtime' =>'datetime',//添加时间 'updatetime' =>'datetime',//更新时间 ]; protected $createTime='addtime'; protected $updateTime='updatetime'; protected $globalScope = ['is_del']; public function scopeIsDel($query) { // 保持原有逻辑不变 $query->where('is_del', 0); } public function MenuInfo(){ return $this->belongsTo(AdminMenu::class,"menuid")->bind(["menu_name","pid"]); } public function ActionInfo(){ return $this->belongsTo(ActionList::class,'action_code',"action_code")->bind(['action_name']); } public static function GetAction($action){ $list= self::with(["MenuInfo","ActionInfo"])->where(['id'=>$action])->select(); if($list->isEmpty())return[]; $temp=[]; foreach ($list as $item){ $tempC=[ "parent_id"=>$item->pid, "parent_name"=>"", "menu_name"=>$item->menu_name, "menu_id"=>$item->menuid, "action_name"=>$item->action_name, "action_id"=>$item->id, "action_code"=>$item->action_code, ]; if($item->pid>0){ $tempC['parent_name'] = AdminMenu::where(['id'=>$item->pid,'is_del'=>0])->value('menu_name',''); } $temp[]=$tempC; } return $temp; } }