cxinv/app/admin/controller/Menu.php

<?php
declare (strict_types = 1);
namespace app\admin\controller;
use app\admin\BaseController;
use think\App;
use think\facade\Db;

class Menu extends BaseController{
    public function __construct(App $app) {parent::__construct($app);}
/** 进入页面获取权限列表
* @return \think\response\Json|void
* @throws \think\db\exception\DataNotFoundException
* @throws \think\db\exception\DbException
* @throws \think\db\exception\ModelNotFoundException
 */
 public function MenuList(){

        $role = Db::name("role_action")->where("role_id","=",$this->roleid)->find();

        if($role==false){
            return app_show(0,"获取成功",[]);
        }
        $action = Db::name("action")->where(['id'=>explode(",",$role['action_conllect']),"status"=>1,"is_del"=>0])
        ->column
        ("id,menuid,action_code");
        if (empty($action)){
            return app_show(0,"获取成功",[]);
        }
        $MenuAction=[];
        foreach ($action as $value){
        $MenuAction[$value['menuid']][]=$value;
        }
        $menuid= array_column($action,"menuid");
        $menuAll =Db::name("admin_menu")->where(["id"=>$menuid,"status"=>1,"is_del"=>0])->column("id,menu_name,menu_img,menu_route,menu_url,pid,is_show,is_private,menu_type,status,weight");
        $list=[];
        foreach ($menuAll as $value){
           $value['action'][]=$MenuAction[$value['id']];
            makeMenu($value,$list);
        }
        $keys =array_column($list, 'weight');
        array_multisort($keys,SORT_DESC,$list);
        $list=MenuTree($list,0);
        return app_show(0,"获取成功",$list);
    }
    /**菜单设置列表
    * @return \think\response\Json|void
    * @throws \think\db\exception\DataNotFoundException
    * @throws \think\db\exception\DbException
    * @throws \think\db\exception\ModelNotFoundException
    * @throws \think\exception\DbException
    */
     public function   MenuAllList(){
       $data = Db::name("admin_menu")->where(["is_del"=>0])->field("id,menu_name,menu_img,menu_route,menu_url,pid,is_show,is_private,menu_type,status,weight")->order("weight desc,id asc")->select();
        $l= MenuTree($data,0);
        return app_show(0,"获取成功",$l);
    }

     /**
     * 菜单新建
     * @return \think\response\Json|void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function MenuAdd(){
        $post  =$this->post;
        $name = isset($post['menu_name']) ?trim($post['menu_name']) :"";
        if($name==""){
            return error_show(1002,"菜单名称不能为空");
        }
        $url = isset($post['menu_url']) ?trim($post['menu_url']) :"";
        $route = isset($post['menu_route']) ?trim($post['menu_route']) :"";
        $code = isset($post['menu_code']) ?trim($post['menu_code']) :"";
        $img = isset($post['menu_img']) ?trim($post['menu_img']) :"";
        $pid = isset($post['pid']) ?intval($post['pid']) :0;
        $private = isset($post['private']) ?intval($post['private']) :0;
        $weight = isset($post['weight']) ?floatval($post['weight']) :1;
        $menu_type = isset($post['menu_type']) ?intval($post['menu_type']) :1;
        if($pid!=0 && $route==""){
            return error_show(1002,"子级菜单路由不能为空");
        }
        $data=[
            "menu_name"=>$name,
            "menu_url"=>$url,
            "menu_route"=>$route,
            "menu_code"=>$code,
            "menu_img"=>$img,
            "pid"=>$pid,
            "weight"=>$weight,
            "is_show"=>1,
            "is_private"=>$private,
            "menu_type"=>$menu_type,
            "status"=>1,
            "addtime"=>date("Y-m-d H:i:s"),
            "updatetime"=>date("Y-m-d H:i:s"),
        ];

        $result = Db::name("admin_menu")->insert($data);
        return $result ? app_show(0,"添加成功"): error_show(1003,"添加失败");
    }
        /**菜单编辑或新建
    * @return \think\response\Json|void
    * @throws \think\db\exception\DataNotFoundException
    * @throws \think\db\exception\DbException
    * @throws \think\db\exception\ModelNotFoundException
     */
        public function MenuEdit(){
        $post  =$this->post;
        $id = isset($post['id']) ?intval($post['id']) :"";
        if($id!=""){
            $menu = Db::name("admin_menu")->where([["id","=",$id],["is_del","=",0]])->find();
            if($menu==false){
                return error_show(1003,"菜单不信息不存在");
            }
        }
        $name = isset($post['menu_name']) ?trim($post['menu_name']) :"";
        if($name==""){
            return error_show(1002,"菜单名称不能为空");
        }
        $url = isset($post['menu_url']) ?trim($post['menu_url']) :"";
        $route = isset($post['menu_route']) ?trim($post['menu_route']) :"";
        $code = isset($post['menu_code']) ?trim($post['menu_code']) :"";
        $img = isset($post['img']) ?trim($post['img']) :"";
        $pid = isset($post['pid']) ?intval($post['pid']) :0;
        $weight = isset($post['weight']) ?floatval($post['weight']) :1;
        $status = isset($post['is_show']) ? intval($post['is_show']) : 0;
        $menu_type = isset($post['menu_type']) ?intval($post['menu_type']) :1;
        $private = isset($post['private']) ?intval($post['private']) :(isset($menu['is_private']) ?
            $menu['is_private'] : 0);
        if($pid!=0 && $route==""){
            return error_show(1002,"子级菜单路由不能为空");
        }
        $data=[
            "menu_name"=>$name,
            "menu_url"=>$url,
            "menu_route"=>$route,
            "menu_code"=>$code,
            "menu_img"=>$img,
            "pid"=>$pid,
            'is_show'=>$status,
            "is_private"=>$private,
            "menu_type"=>$menu_type,
            'status'=>1,
            "weight"=>$weight,
            "updatetime"=>date("Y-m-d H:i:s"),
        ];
        $message="新建";
        if($id!=""){
            $message="编辑";
            $data['id']=$id;
        }
        $result = Db::name("admin_menu")->save($data);
        return $result ? app_show(0,"{$message}成功"): error_show(1003,"{$message}失败");
    }
    /**菜单状态更新
* @return \think\response\Json|void
* @throws \think\db\exception\DataNotFoundException
* @throws \think\db\exception\DbException
* @throws \think\db\exception\ModelNotFoundException
 */
      public function MenuStatus(){
        $post  =$this->post;
        $id = isset($post['id']) ?intval($post['id']) :"";
        $menu = Db::name("admin_menu")->where("id","=",$id)->find();
        if($menu==false){
            return error_show(1003,"菜单信息不存在");
        }
        $statu = isset($post['status'])&&$post['status']!="" ? intval($post['status']) :"";
        if($statu===""){
            return error_show(1003,"菜单状态不能为空");
        }
        $menu['status']=$statu;
        $menu['updatetime']=date("Y-m-d H:i:s");
        $result = Db::name("admin_menu")->save($menu);
        return $result ? app_show(0,"状态更新成功"): error_show(1003,"状态更新失败");
    }
    //菜单删除
    public function  MenuDel(){
        $post  =$this->post;
        $id = isset($post['id']) ?intval($post['id']) :"";
        $menu = Db::name("admin_menu")->where([["id","=",$id],["is_del","=",0]])->find();
        if($menu==false){
            return error_show(1003,"菜单信息不存在");
        }
        $update =["is_del"=>1,"updatetime"=>date("Y-m-d H:i:s")];
        $result = Db::name("admin_menu")->where($menu)->update($update);
        return $result ? app_show(0,"删除成功"): error_show(1003,"删除失败");
    }
      /**
     * 获取菜单下的所有功能列表
     * @return \think\response\Json|void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ActionList(){
        $post  =$this->post;
        $pageid = isset($post['id']) ? intval($post['id']) : "";
        if($pageid==""){
            return error_show(1001,'页面id不能为空');
        }
        $condition = ['menuid'=>$pageid];
        $data=Db::name('action')->alias("a")->leftJoin("cfp_action_list l","a.action_code=l.action_code")->field
        ("a.*,action_name")->where($condition)->select();
        return app_show(0,"获取成功",$data);
    }
        /** 菜单下功能信息修改*/
        public function ActionSave(){
        $post  =$this->post;
        $actid = isset($post['id']) ? intval($post['id']) : "";
        if($actid==""){
            return error_show(1001,'功能id不能为空');
        }
        $menuid = isset($post['menuid']) ? intval($post['menuid']) : "";
        if($menuid==""){
            return error_show(1001,'页面menuid不能为空');
        }

        $code = isset($post['action_code']) ? trim($post['action_code']) : "";

        $action_name = isset($post['action_name']) ? trim($post['action_name']) : "";
         if($action_name==''){
             return error_show(1001,'参数 action_name 不能为空');
        }
        $status = isset($post['status']) ? intval($post['status']) : 1;
        if($code==""){
            return error_show(1002,'功能code不能为空');
        }
        $istrue =Db::name("action")->where(['menuid'=>$menuid,"action_code"=>$code,"is_del"=>0])->find();
        if($istrue && $istrue['id']!=$actid){
            return error_show(1005,'此功能已存在');
        }
        Db::startTrans();
        try{
             $actioninfo =Db::name("action_list")->where(["action_code"=>$code,"is_del"=>0])->find();
            if($actioninfo){
                $update =Db::name("action_list")->where($actioninfo)->update(["action_name"=>$action_name,"updatetime"=>date("Y-m-d H:i:s")]);
            }else{
                $data=["action_name"=>$action_name,"action_code"=>$code,"addtime"=>date("Y-m-d H:i:s"),"updatetime"=>date("Y-m-d H:i:s")];
                $update = Db::name("action_list")->insert($data);
            }
             if($update==false){
                Db::rollback();
                 return error_show(1002,'功能新建失败');
            }
            $data = ['action_code'=>$code,'status'=>$status,"updatetime"=>date("Y-m-d H:i:s")];
            $result=Db::name("action")->where("id","=",$actid)->save($data);
            if($result){
                Db::commit();
                return app_show(0,"更新成功");
            }else{
                Db::rollback();
                return error_show(1004,"更新失败");
            }

        }catch (\Exception $e){
            Db::rollback();
            return error_show(1003,$e->getMessage());
        }
    }

    /**   菜单下功能信息状态修改
     * @return \think\response\Json|void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function ActionStatus(){
        $post  =$this->post;
        $actid = isset($post['id']) ? intval($post['id']) : "";
        if($actid==""){
            return error_show(1001,'功能id不能为空');
        }
        $status = isset($post['status']) ? intval($post['status']) : 1;
        try{
            $data = ['status'=>$status,"updatetime"=>date("Y-m-d H:i:s")];
            $result=Db::name("action")->where("id","=",$actid)->save($data);
            if($result){
                return app_show(0,"更新成功");
            }else{
                return error_show(1004,"更新失败");
            }
        }catch (\Exception $e){
            return error_show(1003,$e->getMessage());
        }
    }

    /** 菜单下功能信息状态修改
     * @return \think\response\Json|void
     * @throws \think\exception\DbException
     */
    public function ActionAdd(){
        $post  =$this->post;
        $pageid = isset($post['menuid']) ? intval($post['menuid']) : "";
        if($pageid==""){
            return error_show(1001,'页面id不能为空');
        }
        $code = isset($post['action_code']) ? trim($post['action_code']) : "";
        $action_name = isset($post['action_name']) ? trim($post['action_name']) : "";
        $status = isset($post['status']) ? intval($post['status']) : 1;
        if($code==""){
            return error_show(1002,'功能code不能为空');
        }
         if($action_name==""){
            return error_show(1002,'功能 action_name 不能为空');
        }
        Db::startTrans();
        try{
            $actioninfo =Db::name("action_list")->where(["action_code"=>$code,"is_del"=>0])->find();
            if($actioninfo){
                $update =Db::name("action_list")->where($actioninfo)->update(["action_name"=>$action_name,"updatetime"=>date("Y-m-d H:i:s")]);
            }else{
                $data=["action_name"=>$action_name,"action_code"=>$code,"addtime"=>date("Y-m-d H:i:s"),"updatetime"=>date("Y-m-d H:i:s")];
                $update = Db::name("action_list")->insert($data);
            }
            if($update==false){
                Db::rollback();
                 return error_show(1002,'功能新建失败');
            }
            $where = ['menuid'=>$pageid,'action_code'=>$code,"is_del"=>0];
            $true =Db::name("action")->where($where)->find();
            if($true){
                 Db::rollback();
                return error_show(1003,'此功能已存在');
            }else{
            $data = ['menuid'=>$pageid,'action_code'=>$code,'status'=>$status,"updatetime"=>date("Y-m-d H:i:s"),"addtime"=>date("Y-m-d H:i:s")];
            $in = Db::name("action")->insert($data);
            if($in){
                    Db::commit();
                  return app_show(0,"添加成功");
            }

            }
            Db::rollback();
            return error_show(1005,'功能新建失败');
        }catch (\Exception $e){
            Db::rollback();
            return error_show(1005,$e->getMessage());
        }
    }
    //菜单下功能删除
    public function ActionDel(){
        $post  =$this->post;
        $actid = isset($post['id']) ? intval($post['id']) : "";
        if($actid==""){
            return error_show(1001,'功能id不能为空');
        }
        $act=Db::name("action")->where([["id","=",$actid],["is_del","=",0]])->find();
        if($act==false){
             return error_show(1004,'未找到相关数据');
        }
        try{
            $data = ['is_del'=>1,"updatetime"=>date("Y-m-d H:i:s")];
            $result=Db::name("action")->where($act)->update($data);
            if($result){
                return app_show(0,"删除成功");
            }else{
                return error_show(1004,"删除失败");
            }
        }catch (\Exception $e){
            return error_show(1003,$e->getMessage());
        }
    }
}