request->post(); $token = isset($post['token']) ? trim($post['token']) : ""; if($token==""){ return error_show(101,'token不能为空'); } $effetc = VerifyTokens($token); if(!empty($effetc) && $effetc['code']!=0){ return error_show($effetc['code'],$effetc['message']); } $data = Db::name("admin_menu")->where(["pid"=>0,"status"=>1])->select(); $result = []; if(empty($data)){ return app_show(0,"获取成功",$result); } foreach ($data as $key=>$val){ $val["child"]=[]; $result[$val['id']] =$val; } $child =Db::name("admin_menu")->where("pid","<>",0)->where('status',"=",1)->select(); foreach ($child as $k=>$value){ // $act = PasAction::all(['menuid'=>$value['id'],"status"=>1]); $act =Db::name("action")->alias("a")->leftJoin("cfp_action_list l","a.action_code=l.action_code")->field ("a.*,action_name")->where(['a.menuid'=>$value['id'],"a.status"=>1])->select(); $act_data = Db::name("action_field")->where(['menuid'=>$value['id'],"status"=>1])->select(); $value['action'] = $act; $value['action_data'] = $act_data; if(array_key_exists($value['pid'],$result)){ $result[$value['pid']]["child"][]=$value; } } return app_show(0,"获取成功",array_values($result)); } /** * @return \think\response\Json * @throws \think\exception\DbException */ public function DataAction(){ $post =$this->request->post(); $token = isset($post['token']) ? trim($post['token']) : ""; if($token==""){ return error_show(101,'token不能为空'); } $effetc = VerifyTokens($token); if(!empty($effetc) && $effetc['code']!=0){ return error_show($effetc['code'],$effetc['message']); } $data = Db::name("data_action")->where(["status"=>1])->select(); return app_show(0,"获取成功",$data); } public function ActionList(){ $post =$this->request->post(); $token = isset($post['token']) ? trim($post['token']) : ""; if($token==""){ return error_show(101,'token不能为空'); } $effetc = VerifyTokens($token); if(!empty($effetc) && $effetc['code']!=0){ return error_show($effetc['code'],$effetc['message']); } $condition = isset($post['contidion']) ? $post['contidion'] :"1"; $page = isset($post['page']) ? intval($post['page']) : 1; $size = isset($post['size']) ? intval($post['size']) : 10; $count = Db::name("action_list")->count(); $total = ceil($count/$size)>1 ? ceil($count/$size) : 1; $page = $page>=$total?intval($total):$page; $list = Db::name("action_list")->page($page,$size)->select(); $data =['list'=>$list,"count"=>$count]; return app_show(0,'获取成功',$data); } /**@param id 存在更新 /不存在新建 /**@param action_name /**@param action_desc /**@param status * @return \think\response\Json * @throws \think\exception\DbException */ public function ActionSave(){ $post =$this->request->post(); $token = isset($post['token']) ? trim($post['token']) : ""; if($token==""){ return error_show(101,'token不能为空'); } $effetc = VerifyTokens($token); if(!empty($effetc) && $effetc['code']!=0){ return error_show($effetc['code'],$effetc['message']); } $actionid = isset($post['id']) ? intval($post['id']) : ""; if($actionid!=""){ $isf= Db::name("action_list")->where("id","=",$actionid)->find(); if($isf==false){ return error_show(1005,"未找到数据"); } } $action = isset($post['action_name']) ? trim($post['action_name']) : ""; if($action==""){ return error_show(1003,'功能名称不能为空'); } $desc = isset($post['action_desc']) ? trim($post['action_desc']) : ""; $status = isset($post['status']) ? intval($post['status']) : 0; $data=[ "action_name"=>$action, "action_desc"=>$desc, "action_code"=>"", ]; $isTrue = Db::name("action_list")->where(["action_name"=>$action])->find(); if($isTrue){ if($isTrue['id']!=$actionid || $actionid==""){ return error_show(1003,'功能名称不能重复'); } } try{ $message = ""; if($actionid==""){ $data['status']=$status; $data['is_show']=1; $message = "新建成功"; }else{ $data['status']=$status; $data['id']=$actionid; $message = "更新成功"; } Db::name("action_list")->save($data); return app_show(0,$message); }catch (\Exception $e){ return error_show(1005,$e->getMessage()); } } /**@param id menu 主键id * @return \think\response\Json * @throws \think\exception\DbException */ public function ActionInfo(){ $post =$this->request->post(); $token = isset($post['token']) ? trim($post['token']) : ""; if($token==""){ return error_show(101,'token不能为空'); } $effetc = VerifyTokens($token); if(!empty($effetc) && $effetc['code']!=0){ return error_show($effetc['code'],$effetc['message']); } $id = isset($post['id'])? intval($post['id']) :""; if($id==""){ return error_show(1002,'功能id不能为空'); } $menu = Db::name("action_list")->where("id","=",$id)->find(); if(empty($menu)){ return error_show(1003,"未找到对应的数据"); } return app_show(0,"获取成功!",$menu); } /**@param id menu 主键id * @return \think\response\Json * @throws \think\exception\DbException */ public function ActionStatus(){ $post =$this->request->post(); $token = isset($post['token']) ? trim($post['token']) : ""; if($token==""){ return error_show(101,'token不能为空'); } $effetc = VerifyTokens($token); if(!empty($effetc) && $effetc['code']!=0){ return error_show($effetc['code'],$effetc['message']); } $id = isset($post['id'])? intval($post['id']) :""; if($id==""){ return error_show(1002,'功能id不能为空'); } $status = isset($post['status'])? intval($post['status']) :""; if($status===""){ return error_show(1002,'状态status不能为空'); } $menu = Db::name("action_list")->where("id","=",$id)->save(['status'=>$status]); return $menu ? app_show(0,"更新成功!") : error_show(1004,"更新失败"); } }