post=$this->request->post(); } public function create(){ $unit = isset($this->post['unit']) && $this->post['unit'] !==""? trim($this->post['unit']):""; if($unit==""){ return error_show(1002,"参数unit不能为空"); } $token = isset($this->post['token'])&&$this->post['token']!='' ? trim($this->post['token']):""; if($token==''){ return error_show(105,"参数token不能为空"); } $user =GetUserInfo($token); if(empty($user)||$user['code']!=0){ return error_show(1002,"创建人数据不存在"); } $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : ""; $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : ""; $status = isset($this->post['status']) &&$this->post['status'] !==""? intval($this->post['status']):"1"; $data=[ "unit"=>$unit, "creater"=>$creater, "createrid"=>$createrid, "status"=>$status, "is_del"=>0, "addtime"=>date("Y-m-d H:i:s"), "updatetime"=>date("Y-m-d H:i:s") ]; $info = Db::name("unit")->insert($data); if($info){ return error_show(0,"新建成功"); }else{ return error_show(1002,"新建失败"); } } 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"; $where=[["u.is_del","=",0]]; $unit = isset($this->post['unit']) && $this->post['unit'] !=="" ? trim($this->post['unit']):""; if($unit!==""){ $where[]=['u.unit',"like","%$unit%"]; } $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']) :""; if($status!==""){ $where[]=['u.status',"=",$status]; } $creater = isset($this->post['creater']) && $this->post['creater'] !=="" ? trim($this->post['creater']):""; if($creater!=""){ $where[]=['u.creater',"like","%$creater%"]; } $start = isset($this->post['start']) && $this->post['start']!=="" ? $this->post['start']:""; if($start!==""){ // $where[]=['u.addtime',">=",date('Y-m-d H:i:s')];//,strtotime($start) $where[]=['u.addtime',">=",$start]; } $end = isset($this->post['end']) && $this->post['end']!=="" ? $this->post['end']:""; if($end!==""){ // $where[]=['u.addtime',"<",date('Y-m-d H:i:s')];//,strtotime($end)+24*3600 $where[]=['u.addtime',"<=",$end]; } $company_name = isset($this->post['company_name']) && $this->post['company_name'] !== "" ? trim($this->post['company_name']) : ""; if ($company_name !== "") $where[] = ["u.createrid", 'in', get_company_item_user_by_name($company_name)]; $count = Db::name('unit') ->alias('u') ->leftJoin("depart_user user", "user.uid=u.createrid AND user.is_del=0") ->where($where) ->count(); $total = ceil($count / $size); $page = $page >= $total ? $total : $page; $list = Db::name('unit') ->alias('u') ->field('u.*,user.itemid') ->leftJoin("depart_user user", "user.uid=u.createrid AND user.is_del=0") ->where($where) ->append(['company_name']) ->withAttr('company_name',function($val,$data){ return implode('/', array_column(GetPart($data['itemid']), 'name')); }) ->page($page,$size) ->order("addtime desc") ->select() ->toArray(); return app_show(0,"获取成功",['list'=>$list,'count'=>$count]); } public function edit(){ $id = isset($this->post['id']) && $this->post['id'] !==""? intval($this->post['id']):""; if($id==""){ return error_show(1002,"参数id不能为空"); } $info = Db::name('unit')->where(['id'=>$id,'is_del'=>0])->find(); if($info==""){ return error_show(1003,"未找到数据"); } if($info['status']==1){ return error_show(1002,"状态是启用状态,无法编辑"); } $unit = isset($this->post['unit']) && $this->post['unit'] !==""? trim($this->post['unit']):""; if($unit==""){ return error_show(1002,"参数unit不能为空"); } // $token = isset($this->post['token'])&&$this->post['token']!='' ? trim($this->post['token']):""; // if($token==''){ // return error_show(105,"参数token不能为空"); // } // $user =GetUserInfo($token); // if(empty($user)||$user['code']!=0){ // return error_show(1002,"创建人数据不存在"); // } // $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : ""; // $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : ""; $status = isset($this->post['status']) &&$this->post['status'] !==""? intval($this->post['status']):"0"; $data=[ "id"=>$id, "unit"=>$unit, // "creater"=>$creater, // "createrid"=>$createrid, // "status"=>$status, "is_del"=>0, "updatetime"=>date("Y-m-d H:i:s") ]; $datainfo = Db::name('unit')->save($data); $item = array_diff($data,$info); $json = json_encode($item,JSON_UNESCAPED_UNICODE); $jsp = json_encode($info,JSON_UNESCAPED_UNICODE); if($datainfo){ ChangeLog::logAdd(4,$info['id'],$jsp,$json,$this->post['token'],$this->post); return error_show(0,"更新成功"); }else{ return error_show(1002,"更新失败"); } } public function del(){ $id = $this->post['id'] && $this->post['id'] !=="" ? intval($this->post['id']) :""; if($id===""){ return error_show(1004,"参数id不能为空"); } $str= Db::name('unit')->where(['id'=>$id,'is_del'=>0])->find(); if(empty($str)){ return error_show(1002,"未找到数据"); } $end = Db::name('unit')->update(['id'=>$id,'is_del'=>1]); if($end){ return error_show(0,"删除成功"); }else{ return error_show(1002,"删除失败"); } } public function status(){ $id = isset($this->post['id']) && $this->post['id'] !==""? intval($this->post['id']):""; if($id==""){ return error_show(1002,"参数id不能为空"); } $info = Db::name("unit")->where([["id","=",$id],["is_del","=",0]])->find(); if(!$info){ return error_show(1002,"未找到对应数据"); } $status = isset($this->post['status']) && $this->post['status']!==""? intval($this->post['status']):""; if($status===""){ return error_show(1002,"参数status不能为空"); } if(!in_array($status,[0,1])){ return error_show(1002,"参数status无效"); } $info['status']=$status; $info['updatetime']=date("Y-m-d H:i:s"); $msg = $status==1?"启用":"禁用"; $update = Db::name("unit")->save($info); return $update? error_show(0,"{$msg}成功"):error_show(1004,"{$msg}失败"); } }