AdminMenu.php 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. <?php
  2. namespace app\admin\model;
  3. class AdminMenu extends Base
  4. {
  5. //设置字段信息
  6. protected $schema = [
  7. 'id' =>'bigint',//
  8. 'menu_name' =>'varchar',//菜单名称
  9. 'menu_code' =>'varchar',//菜单code
  10. 'menu_img' =>'varchar',//菜单图片
  11. 'menu_route' =>'varchar',//菜单路由
  12. 'menu_url' =>'varchar',//菜单地址
  13. 'menu_api' =>'varchar',//接口地址
  14. 'pid' =>'bigint',//父级id
  15. 'is_show' =>'int',//是否禁用
  16. 'is_private' =>'int',//是否私有
  17. 'level' =>'tinyint',//菜单等级,0公共,1超管,2业务公司,3供应商
  18. 'is_display' =>'int',//是否展示
  19. 'weight' =>'double',//权重
  20. 'status' =>'int',//状态
  21. 'is_del' =>'int',//是否删除
  22. 'addtime' =>'datetime',//
  23. 'updatetime' =>'datetime',//
  24. 'menu_type' =>'tinyint',//1菜单2 页面
  25. ];
  26. protected $createTime = 'addtime';
  27. protected $updateTime = 'updatetime';
  28. //获取菜单信息
  29. public static function GetMenu($menuid){
  30. $info=self::where(["id"=>$menuid,"is_del"=>0])->findOrEmpty();
  31. if($info->pid>0){
  32. $paren = self::where(['id'=>$info->pid,'is_del'=>0])->findOrEmpty();
  33. }
  34. return ["menu_name"=>$info->menu_name,"parent_name"=>$paren->menu_name??"","parent_id"=>$info->pid];
  35. }
  36. public function ActionInfo(){
  37. return $this->hasMany(Action::class,"action_id")->where(["is_del"=>0]);
  38. }
  39. //由二级菜单获取父级集合
  40. public static function GetMenuBySecod($menuid,$result=[]){
  41. $menuArr = self::where(['id'=>$menuid])->findOrEmpty();
  42. if(!$menuArr->isEmpty()){
  43. if($menuArr->pid>0) self::GetMenuBySecod($menuArr->pid,$result);
  44. $result[] = ['id' => $menuid, 'rename' => $menuArr->menu_name, 'pid' => $menuArr->pid];
  45. }
  46. return $result;
  47. }
  48. //通过功能集合返回菜单树状集
  49. public function GetMenuByActionArr($actionArr,$where=[]){
  50. $menuArr = Action::with(["ActionInfo"])->whereIn("id",$actionArr)->select();
  51. $tree=[];
  52. if(!$menuArr->isEmpty()){
  53. $menuid = [];
  54. foreach ($menuArr as $item){
  55. $menuid[$item->menuid][] =$item->action_code;
  56. }
  57. $menuArrId = array_unique(array_column($menuArr->toArray(),"menuid"));
  58. $menuAll=$this->where($where)->column("menu_name,menu_img,menu_route,is_display,status,pid,weight,level","id");
  59. foreach ($menuArrId as $item){
  60. $this->buildForwardTree($item,$menuid[$item]??[],$menuAll,$tree);
  61. }
  62. $weight= array_column($tree,'weight');
  63. array_multisort($weight, SORT_DESC, $tree);
  64. }
  65. return $tree;
  66. }
  67. //有子找父级
  68. public function buildForwardTree($itemId, $child = [],&$items, &$menuTree=[]) {
  69. if(!isset($items[$itemId]))return;
  70. $node=$items[$itemId];
  71. if($node['pid']==0){
  72. if(!isset($menuTree[$itemId])){
  73. $menuTree[$itemId]=$node;
  74. }
  75. $menuTree[$itemId]['child'][]=$child;
  76. $weight= array_column($menuTree[$itemId]['child'],"weight");
  77. array_multisort($weight, SORT_DESC, $menuTree[$itemId]['child']);
  78. }else{
  79. $node['action']=$child;
  80. $this->buildForwardTree($node['pid'],$node,$items,$menuTree);
  81. }
  82. }
  83. public function GetMenuActionTree($pid=0,$level=[]){
  84. $where=['pid'=>$pid,'is_del'=>0,'status'=>1];
  85. if($level!='' && $pid>0) $where['level']=$level;
  86. $result = $this->field('menu_name,menu_img,menu_route,is_display,status,pid,weight,id,level')
  87. ->where($where)
  88. ->order(['weight'=>'desc','id'=>'desc'])->select();
  89. $remp=[];
  90. if($result->isEmpty())return $remp;
  91. foreach ($result as $item){
  92. $item->child = $this->GetMenuActionTree($item->id,$level);
  93. if($item->pid>0){
  94. $item->action = Action::with(["ActionInfo"])->field("id,action_code")->where
  95. (['menuid'=>$item->id,'is_del'=>0])->select();
  96. }
  97. $remp[] = $item;
  98. }
  99. return $remp;
  100. }
  101. }