post = $this->request->post(); } public function list() { $page = isset($this->post['page']) && $this->post['page'] != "" ? intval($this->post['page']) : 1; $size = isset($this->post['size']) && $this->post['size'] != "" ? intval($this->post['size']) : 10; $condition = ['pid'=>0]; $count = Db::name("company_item")->where($condition)->count(); $page >= ceil($count / $size) ? $page = ceil($count / $size) : " "; $list = Db::name("company_item")->where($condition)->page($page, $size)->select(); // $this->carray($this->treelist); // var_dump($this->carray($this->treelist)); $data=[]; $act=[]; foreach ($list as $value){ // crea($value); // var_dump($value); $data[]= crea($value);; } // array_walk($data,function (&$value){ //$value['child']= array_values($value['child']); // }); return app_show(0,"获取成功",array_values($data)); } public function add(){ $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']); } $item_name=isset($this->post['name']) && $this->post['name'] !==""? trim($this->post['name']) :""; if($item_name==""){ return error_show(0,"部门名称不能为空"); } $repeat_name = Db::name("company_item")->where(["is_del"=>0,"name"=>$item_name])->find(); if(!empty($repeat_name)){ return error_show(1004,"部门名称已存在"); } $pid = isset($this->post['pid']) && $this->post['pid'] !==""? trim($this->post['pid']):"0"; $level = isset($this->post['level']) && $this->post['level'] !==""? trim($this->post['level']):"1"; $weight = isset($this->post['weight']) && $this->post['weight'] !==""? trim($this->post['weight']):"1"; try{ $data =[ "name"=>$item_name, "pid"=>$pid, "level"=>$level, "weight"=>$weight, "is_del"=>0, "addtime"=>date("Y-m-d H:i:s"), "updatetime"=>date("Y-m-d H:i:s") ]; Db::name("company_item")->insert($data); return error_show(0,"添加成功"); }catch (\Exception $e){ return error_show(1003,$e->getMessage()); } } public function refresh(){ $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($this->post['id'])?intval($this->post['id']):""; $items = Db::name("company_item")->where("id","=",$id)->find(); if($items==false){ return error_show(1003,"部门信息不存在"); } $itemname=isset($this->post['name'])? trim($this->post['name']):""; if($itemname==""){ return error_show(1002,"部门名称不能为空"); } $repeat_name = Db::name("company_item")->where(["is_del"=>0,"name"=>$itemname])->where('id','<>',$id)->find(); //echo Db::name("company_item")->getLastSql(); if(!empty($repeat_name)){ return error_show(1004,"部门名称已存在"); } $itemlevel = isset($this->post['level'])? intval($this->post['level']):""; if($itemlevel==""){ return error_show(1002,"部门层级不能为空"); } $depart_link = isset($this->post['depart_link']) ? trim($this->post['depart_link']):""; if($depart_link==""){ return error_show(1002,"快速查询不能为空"); } $item=[ "id"=>$id, "name"=>$itemname, "level"=>$itemlevel, "depart_link"=>$depart_link, "updatetime"=>date("Y-m-d H:i:s") ]; $re = Db::name("company_item")->save($item); return $re ? app_show(0,"信息更新成功"): error_show(1003,"信息更新失败"); } public function query(){ $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']); } $dati = Db::name("company_item")->where(['pid'=>0,'is_del'=>0])->order("weight desc")->select(); $k=[]; foreach ($dati as $key=>$value){ $temp=[]; $temp= Db::name("company_item")->where(['pid'=>$value['id'],'is_del'=>0])->order("weight desc")->select(); $value['child'] =$temp; $k[]=$value; } return app_show(0,"获取成功",$k); } public function itemdel(){ $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($this->post['id']) ? intval($this->post['id']):""; $items = Db::name("company_item")->where(['is_del'=>0,'id'=>$id])->find(); if($items==false){ return error_show(1003,"部门信息不存在"); } $items['is_del']=1; $items['updatetime']=date("Y-m-d H:i:s"); $result = Db::name("company_item")->save($items); return $result ? app_show(0,"删除成功"): error_show(1003,"删除失败"); } }