'bigint',// 'menu_name' =>'varchar',//菜单名称 'menu_code' =>'varchar',//菜单编号 'menu_img' =>'varchar',//菜单图片 'menu_route' =>'varchar',//菜单路由 'menu_url' =>'varchar',//菜单url 'pid' =>'bigint',//父级id 'is_show' =>'int',//是否显示1显示0 隐藏 'is_private' =>'int',//是否私有 'weight' =>'double',//权重 'level' =>'tinyint',//菜单等级 1只有超管看2级只有运营看 3 所有人都能看 'status' =>'int',//状态 0禁用1启用 'is_del' =>'tinyint',//是否删除 1删除0否 'addtime' =>'datetime',// 'updatetime' =>'datetime',// 'menu_type' =>'tinyint',//1菜单2 页面 ]; public static function GetMenu($menuid){ $info=self::where(['id'=>$menuid,'is_del'=>0])->findOrEmpty(); if($info->pid>0){ $paren = self::where(['id'=>$info->pid,'is_del'=>0])->findOrEmpty(); } return ['menu_name'=>$info->menu_name,'parent_name'=>$paren->menu_name??'','parent_id'=>$info->pid]; } public static function GetMenuBySecod($menuid,$result=[]){ $menuArr = self::where(['id'=>$menuid])->findOrEmpty(); if(!$menuArr->isEmpty()){ if($menuArr->pid>0) self::GetMenuBySecod($menuArr->pid,$result); $result[] = ['id' => $menuid, 'rename' => $menuArr->menu_name, 'pid' => $menuArr->pid]; } return $result; } //通过功能集合返回菜单树状集 public function GetMenuByActionArr($actionArr,$where=[]){ $menuArr = Action::with(['ActionInfo'])->whereIn('id',$actionArr)->select(); $tree=[]; if(!$menuArr->isEmpty()){ $menuid = []; foreach ($menuArr as $item){ $menuid[$item->menuid][] =$item->action_code; } $menuArrId = array_unique(array_column($menuArr->toArray(),'menuid')); $menuAll=$this->where($where)->column('menu_name,menu_img,menu_route,menu_url,status,pid,weight','id'); foreach ($menuArrId as $item){ $this->buildForwardTree($item,$menuid[$item]??[],$menuAll,$tree); } $weight= array_column($tree,'weight'); array_multisort($weight, SORT_DESC, $tree); } return $tree; } //有子找父级 public function buildForwardTree($itemId, $child = [],&$items, &$menuTree=[]) { if(!isset($items[$itemId]))return; $node=$items[$itemId]; if($node['pid']==0){ if(!isset($menuTree[$itemId])){ $menuTree[$itemId]=$node; } $menuTree[$itemId]['child'][]=$child; $weight= array_column($menuTree[$itemId]['child'],'weight'); array_multisort($weight, SORT_DESC, $menuTree[$itemId]['child']); }else{ $node['action']=$child; $this->buildForwardTree($node['pid'],$node,$items,$menuTree); } } public function GetMenuActionTree($pid=0){ $result = $this->field('menu_name,menu_img,menu_route,menu_url,status,pid,weight,id') ->where(['pid'=>$pid,'is_del'=>0]) ->order(['weight'=>'desc','id'=>'desc'])->select(); $remp=[]; if($result->isEmpty())return $remp; foreach ($result as $item){ $item->child = $this->GetMenuActionTree($item->id); if($item->pid>0){ $item->action = Action::with(['ActionInfo'])->field('id,action_code')->where (['menuid'=>$item->id,'is_del'=>0])->select(); } $remp[] = $item; } return $remp; } }