request->params($params); $check=$this->check_params($data); if($check['code']!=200) { return app('json')->fail($check['msg']); } if($data['type']==1){//添加 $res=$this->warehouse_add($data);//执行方法 if($res){ return app('json')->success('添加成功'); }else{ return app('json')->success('添加失败'); } }elseif ($data['type']==2){//修改 $res=$this->warehouse_update($data);//执行方法 if($res!==false){ return app('json')->success('修改成功'); }else{ return app('json')->success('修改失败'); } } }catch (\Exception $exception){ return '大仓管理错误:'.$exception->getFile().':'.$exception->getLine().'【'.$exception->getMessage().'】'; } } //大仓添加 public function warehouse_add($data) { unset($data['type']); unset($data['id']); $data['create_time']=time(); $data['uid']=Db::name('user')->where('account',$data['account']??'')->value('uid'); $res=Db::name('big_warehouse')->insert($data); return $res; } //大仓修改 public function warehouse_update($data) { $id=$data['id']; unset($data['type']); unset($data['id']); $data['update_time']=time(); $data['uid']=Db::name('user')->where('account',$data['account']??0)->value('uid'); $res=Db::name('big_warehouse')->where('id',$id)->update($data); return $res; } //检查参数 public function check_params($data) { if(empty($data['account'])||empty($data['user_name'])||empty($data['warehouse_name'])){ return ['code'=>1,'msg'=>'参数不完整']; } // if(!empty($data['account'])){ $uid=Db::name('user')->where('account',$data['account'])->value('uid'); if(!$uid){ return ['code'=>1,'msg'=>'手机号暂未注册']; } // } $is_check=Db::name('big_warehouse')->where('warehouse_name',$data['warehouse_name'])->find(); if ($is_check){ if($is_check['uid']!=$uid){ return ['code'=>1,'msg'=>'大仓名称已被注册']; } } if($data['type']!=1&&$data['type']!=2){ return ['code'=>1,'msg'=>'请求类型不一致']; } return ['code'=>200,'msg'=>'']; } //列表 public function lst() { [$page, $limit] = $this->getPage(); $status=$this->request->params(['status']); $where = []; if($status['status']){ $where['status'] = $status; } $list=Db::name('big_warehouse')->where($where)->page($page,$limit)->select()->toArray(); foreach ($list as $k=>&$v){ $v['status']=(int)$v['status']; $v['create_time']=date('Y-m-d H:i:s',$v['create_time']); if($v['update_time']){ $v['update_time']=date('Y-m-d H:i:s',$v['update_time']); }else{ $v['update_time']=''; } } $count=Db::name('big_warehouse')->count('id'); $return_data=[ 'count'=>$count, 'list'=>$list ]; return app('json')->success($return_data); } //单个详情 public function details() { $id=$this->request->params(['id']); if(empty($id['id'])){ return app('json')->fail('id不存在'); } $data=Db::name('big_warehouse')->where('id',$id['id'])->find(); if($data){ $data['create_time']=date('Y-m-d H:i:s',$data['create_time']); if($data['update_time']){ $data['update_time']=date('Y-m-d H:i:s',$data['update_time']); }else{ $data['update_time']=''; } return app('json')->success($data); }else{ return app('json')->fail('未查询到数据'); } } //更改单个状态 public function switchstatus($id) { $data=Db::name('big_warehouse')->where('id',$id)->find(); if($data){ if($data['status']==1){ Db::name('big_warehouse')->where('id',$id)->dec('status',1)->update(); }elseif ($data['status']==0){ Db::name('big_warehouse')->where('id',$id)->inc('status',1)->update(); } return app('json')->success('修改成功'); }else{ return app('json')->fail('未查询到数据'); } } /*获取省份*/ public function getProvince(){ $data = Db::name("user_province") ->where(['status'=>1]) ->field("province_id,province_code,province_name") ->select(); return app('json')->success($data); } /*获取城市*/ public function getCity($id){ $data = Db::name("user_city") ->where(['status'=>1,'province_code'=>$id]) ->field("city_id,city_code,city_name") ->select(); return app('json')->success($data); } /*获取区域*/ public function getArea($id){ $data = Db::name("user_area") ->where(['status'=>1,'city_code'=>$id]) ->field("area_id,area_code,area_name") ->select(); return app('json')->success($data); } }