where(['id'=>$id])->find(); if($area){ return ['status'=>200,'msg'=>$area]; }else{ return ['status'=>500,'msg'=>'查询失败']; } } /** * 获取列表 * @param array $where * @param int $page * @param int $limit * @return array */ public static function getList($where,$page,$limit,$user_id){ $app_page = config('app_page'); $pageStatus = true; if($app_page){ if($page<0){ $pageStatus = false; } } if($pageStatus){ $list = collection(self::where(function ($query) use ($where,$user_id) { $query->where($where); $query->where('user_id', '=', $user_id); })->page($page,$limit)->field("id,connect_name,connect_mobile,province,city,area,detail_address,is_default,FROM_UNIXTIME(createtime,'%Y-%m-%d %H:%i:%s') as createtime")->select())->toArray(); }else{ $list = collection(self::where(function ($query) use ($where,$user_id) { $query->where($where); $query->where('user_id', '=', $user_id); })->field("id,connect_name,connect_mobile,province,city,area,detail_address,is_default,FROM_UNIXTIME(createtime,'%Y-%m-%d %H:%i:%s') as createtime")->select())->toArray(); } foreach ($list as $list_k=>$list_v){ $area = self::getArea($list_v['province']); if($area['status']==200){ $list[$list_k]['province_name'] = $area['msg']['name']; } $area = self::getArea($list_v['city']); if($area['status']==200){ $list[$list_k]['city_name'] = $area['msg']['name']; } $area = self::getArea($list_v['area']); if($area['status']==200){ $list[$list_k]['area_name'] = $area['msg']['name']; } } $count = self::where(function ($query) use ($where,$user_id) { $query->where($where); $query->where('user_id', '=', $user_id); })->count(); return ['list'=>$list,'count'=>$count]; } /** * 获取详情 * @param int $id * @return array */ public static function getDetail($id,$user_id){ $detail = self::where(function ($query) use ($id,$user_id) { $query->where('id', '=', $id); $query->where('user_id', '=', $user_id); })->field("id,connect_name,connect_mobile,province,city,area,detail_address,is_default,FROM_UNIXTIME(createtime,'%Y-%m-%d %H:%i:%s') as createtime")->find(); if(empty($detail)){ return ['status'=>500,'msg'=>'未查询到收货地址']; } $area = self::getArea($detail['province']); if($area['status']==200){ $detail['province_name'] = $area['msg']['name']; } $area = self::getArea($detail['city']); if($area['status']==200){ $detail['city_name'] = $area['msg']['name']; } $area = self::getArea($detail['area']); if($area['status']==200){ $detail['area_name'] = $area['msg']['name']; } return ['status'=>200,'msg'=>$detail]; } /** * 添加 * @param array $detail * @return array */ public static function addDetail($detail,$user_id){ if(empty($detail)){ return ['status'=>400,'msg'=>'参数错误']; }else{ $check = (new \app\api\model\kuerp\UserAddress)->checkParameter($detail,[ 'connect_name|联系人'=>'require', 'connect_mobile|手机'=>'require|number', 'province|省'=>'require|number', 'city|市'=>'require|number', 'detail_address|详细地址'=>'require', 'is_default|是否默认'=>'require|in:0,1', ]); if(isset($check['status'])){ return $check; }else{ //验证用户 $user = (new KuerpUser())->where(['id'=>$user_id])->find(); if(empty($user)){ return ['status'=>500,'msg'=>'未找到用户信息']; } if($user['status']!='normal'){ return ['status'=>500,'msg'=>'此用户状态异常']; } $detail['user_id'] = $user_id; $area = new Areas(); if($detail['province']>100000){ $province = $area->where(['adcode'=>$detail['province']])->value('id'); }else{ $province = $area->where(['id'=>$detail['province']])->value('id'); } if(empty($province)){ return ['status'=>500,'msg'=>'请选择省数据']; } $detail['province'] = $province; if($detail['city']>100000){ $city = $area->where(['adcode'=>$detail['city']])->value('id'); }else{ $city = $area->where(['id'=>$detail['city']])->value('id'); } if(empty($city)){ return ['status'=>500,'msg'=>'请选择市数据']; } $detail['city'] = $city; if(isset($detail['area']) && !empty($detail['area'])){ if($detail['area']>100000){ $area = $area->where(['adcode'=>$detail['area']])->value('id'); }else{ $area = $area->where(['id'=>$detail['area']])->value('id'); } if(empty($area)){ return ['status'=>500,'msg'=>'区域数据错误']; } $detail['area'] = $area; } $model = new \app\api\model\kuerp\UserAddress; $res = false; Db::startTrans(); try { if($detail['is_default']==1){ $model->where(['is_default'=>'1'])->update(['is_default'=>'0']); } $res = $model->allowField(true)->save($detail); Db::commit(); } catch (Exception $e) { Db::rollback(); } if($res){ return ['status'=>200,'msg'=>$model->id]; }else{ return ['status'=>500,'msg'=>'添加失败']; } } } } /** * 更新 * @param array $detail * @return array */ public static function editDetail($detail,$user_id){ if(empty($detail)){ return ['status'=>400,'msg'=>'参数错误']; }else{ $check = (new \app\api\model\kuerp\UserAddress)->checkParameter($detail,[ 'id|ID'=>'require|number', 'connect_name|联系人'=>'require', 'connect_mobile|手机'=>'require|number', 'province|省'=>'require|number', 'city|市'=>'require|number', 'detail_address|详细地址'=>'require', 'is_default|是否默认'=>'require|in:0,1', ]); if(isset($check['status'])){ return $check; }else{ $model = new \app\api\model\kuerp\UserAddress; $row = $model->where(['id'=>$detail['id']])->find();; if($row){ //验证用户 $user = (new KuerpUser())->where(['id'=>$user_id])->find(); if(empty($user)){ return ['status'=>500,'msg'=>'未找到用户信息']; } if($user['status']!='normal'){ return ['status'=>500,'msg'=>'此用户状态异常']; } if($user_id!=$row['user_id']){ return ['status'=>500,'msg'=>'你无权修改']; } $detail['user_id'] = $user_id; $area = new Areas(); if($detail['province']>100000){ $province = $area->where(['adcode'=>$detail['province']])->value('id'); }else{ $province = $area->where(['id'=>$detail['province']])->value('id'); } if(empty($province)){ return ['status'=>500,'msg'=>'请选择省数据']; } $detail['province'] = $province; if($detail['city']>100000){ $city = $area->where(['adcode'=>$detail['city']])->value('id'); }else{ $city = $area->where(['id'=>$detail['city']])->value('id'); } if(empty($city)){ return ['status'=>500,'msg'=>'请选择市数据']; } $detail['city'] = $city; if(isset($detail['area']) && !empty($detail['area'])){ if($detail['area']>100000){ $area = $area->where(['adcode'=>$detail['area']])->value('id'); }else{ $area = $area->where(['id'=>$detail['area']])->value('id'); } if(empty($area)){ return ['status'=>500,'msg'=>'区域数据错误']; } $detail['area'] = $area; } $res = false; Db::startTrans(); try { if($detail['is_default']==1){ $model->where(['is_default'=>'1','id'=>['<>',$detail['id']]])->update(['is_default'=>'0']); } $res = $row->allowField(true)->save($detail); Db::commit(); } catch (Exception $e) { Db::rollback(); } if($res){ return ['status'=>200,'msg'=>'更新成功']; }else{ return ['status'=>500,'msg'=>'更新失败']; } }else{ return ['status'=>500,'msg'=>'未查询到可更新数据']; } } } } /** * 删除 * @param int $id * @return array */ public static function delDetail($id,$user_id){ if(empty($id)){ return ['status'=>400,'msg'=>'参数错误']; }else{ $model = new \app\api\model\kuerp\UserAddress; $list = $model->where(['id'=>['in',$id]])->select();; //验证用户 $user = (new KuerpUser())->where(['id'=>$user_id])->find(); if(empty($user)){ return ['status'=>500,'msg'=>'未找到用户信息']; } if($user['status']!='normal'){ return ['status'=>500,'msg'=>'此用户状态异常']; } foreach ($list as $list_k=>$list_v){ if($user_id!=$list_v['user_id']){ return ['status'=>500,'msg'=>'你无权删除']; } } $res = $model->where(['id'=>['in',$id]])->delete(); if($res){ return ['status'=>200,'msg'=>$res]; }else{ return ['status'=>500,'msg'=>'删除失败']; } } } public function checkParameter($data,$parameter){ if(is_array($parameter)){ foreach ($parameter as $parameter_k=>$parameter_v){ if(strpos($parameter_k,'|') !== false){ $k = explode('|',$parameter_k); $name = $k[1]; $variable = $k[0]; }else{ $name = $parameter_k; $variable = $parameter_k; } $parameter_v = empty($parameter_v)?'require':$parameter_v; $rule = explode('|',$parameter_v); foreach ($rule as $rule_k=>$rule_v){ if($rule_v=='requireNone'){ if(!isset($data[$variable])){ return ['status'=>400,'msg'=>'请输入'.$name.'参数']; } }else if($rule_v=='require'){ if(!isset($data[$variable]) || $data[$variable]===''){ return ['status'=>400,'msg'=>$name.'参数不正确']; } }else{ $rule_row = explode(':',$rule_v); switch ($rule_row[0]){ case 'in': if(isset($data[$variable]) && $data[$variable]!==''){ if(!isset($rule_row[1])){ return ['status'=>300,'msg'=>'校验规则错误']; } $row_box = explode(',',$rule_row[1]); if(!in_array($data[$variable],$row_box)){ return ['status'=>400,'msg'=>$name.'参数不正确']; } } break; case 'between': if(isset($data[$variable]) && $data[$variable]!==''){ if(!isset($rule_row[1])){ return ['status'=>300,'msg'=>'校验规则错误']; } $row_box = explode(',',$rule_row[1]); if($data[$variable]<$row_box[0] || $data[$variable]>$row_box[1]){ return ['status'=>400,'msg'=>$name.'参数不正确']; } } break; case 'number': if(isset($data[$variable]) && $data[$variable]!==''){ if (!preg_match("/^\d*$/", $data[$variable])){ return ['status'=>400,'msg'=>$name.'只能为数字']; } } break; case 'letter': if(isset($data[$variable]) && $data[$variable]!==''){ if (!preg_match("/^[a-zA-Z]+$/u", $data[$variable])){ return ['status'=>400,'msg'=>$name.'只能为字母']; } } break; case 'money': if(isset($data[$variable]) && $data[$variable]!==''){ if (!preg_match("/^[0-9]+(.[0-9]{1,4})?$/", $data[$variable])){ return ['status'=>400,'msg'=>$name.'格式错误']; } } break; case 'length': if(isset($data[$variable]) && $data[$variable]!==''){ if(!isset($rule_row[1])){ return ['status'=>300,'msg'=>'校验规则错误']; } $row_box = explode(',',$rule_row[1]); if(strlen($data[$variable])<$row_box[0] || strlen($data[$variable])>$row_box[1]){ return ['status'=>400,'msg'=>$name.'字符长度为'.$row_box[0].'-'.$row_box[1].'位']; } } break; default: return ['status'=>300,'msg'=>'校验规则错误']; } } } } }else{ $parameter = explode(',',$parameter); foreach ($parameter as $k=>$v){ if(!isset($data[$v]) || $data[$v]===''){ return ['status'=>400,'msg'=>'参数不正确']; } } } return true; } }