uid); $sel_status = input('sel_status'); $where['user_id'] = $this->uid; if(in_array($sel_status,[1,2,3])) $where['status'] = $sel_status; $list = Db::table('user_coupon_list') ->where($where) ->order('id desc') ->limit($this->off_set,$this->page_num) ->select(); $this->success('获取成功',['list'=>$list]); } /** * @title 设置收货地址(新增或修改) * @desc 设置收货地址(新增或修改) * @author qc * @url /api/Usermanage/setDeliveryAddress * @method POST * @header name:Authorization require:1 desc:Token * @param name:id type:int : default:0 desc:收货地址记录id(不传值是添加) * @param name:pro_name type:int require:1 default:-- desc:省名 * @param name:city_name type:int require:1 default:-- desc:市名 * @param name:county_name type:int require:1 default:-- desc:县区名 * @param name:detail type:string require:1 default:-- desc:详细地址 * @param name:phone type:string require:1 default:-- desc:联系电话 * @param name:name type:string require:1 default:-- desc:联系人 * @param name:is_mr type:int require:0 default:0 desc:是否是默认(0不默认,1默认) */ public function setDeliveryAddress() { $pro_name = input('post.pro_name');// 省 $city_name = input('post.city_name');// 市 $county_name = input('post.county_name');// 县区 $pro_id = Db::table('store_area')->where('name',$pro_name)->value('id'); $city_id = Db::table('store_area')->where('name',$city_name)->value('id'); $county_id = Db::table('store_area')->where('name',$county_name)->value('id'); $detail = input('post.detail');// 详细地址 $phone = input('post.phone'); $name = input('post.name'); $id = input('post.id'); $is_mr = input('post.is_mr',0); $set_data = compact(['pro_id','city_id','county_id','detail','phone','name','is_mr']); $set_data['user_id'] = $this->uid; $set_data['pro_name'] = $pro_name; $set_data['city_name'] = $city_name; $set_data['county_name']= $county_name; $set_data['mer_name']=$pro_name . $city_name. $county_name; if($id) { Db::table('delivery_address')->where(['id'=>$id])->update($set_data); }else{ Db::table('delivery_address')->insert($set_data); $id = Db::getLastInsID(); } if($is_mr) Db::table('delivery_address')->where('user_id','=',$this->uid)->where('id','<>',$id)->where('is_mr','=',1)->update(['is_mr'=>0]); $this->success('编辑成功'); } /** * @title 修改默认收货地址 * @desc 修改默认收货地址 * @author qc * @url /api/Usermanage/changeApproveDelivery * @method POST * @header name:Authorization require:1 desc:Token * @param name:id type:int : default:0 desc:收货地址记录id * @param name:is_mr type:int default:1 desc:是否是默认(0不默认,1默认) */ public function changeApproveDelivery() { $id = input('post.id'); $is_mr = input('post.is_mr',1); if($is_mr) { Db::table('delivery_address') ->where('user_id','=',$this->uid) ->where('is_mr','=',1) ->update(['is_mr'=>0]); Db::table('delivery_address') ->where('user_id','=',$this->uid) ->where('id','=',$id) ->update(['is_mr'=>1]); }else{ Db::table('delivery_address') ->where('user_id','=',$this->uid) ->where('id','=',$id) ->update(['is_mr'=>0]); } $this->success('修改成功'); } /** * @title 删除收货地址 * @desc 删除收货地址 * @author qc * @url /api/Usermanage/delDeliveryAddress * @method POST * @header name:Authorization require:1 desc:Token * @param name:id type:int require:1 default:1 desc:收货地址记录id */ public function delDeliveryAddress() { $id = input('post.id'); if(!$id)$this->error('请选择要删除的收货地址'); Db::table('delivery_address')->where(['user_id'=>$this->uid,'id'=>$id])->update(['is_deleted'=>1,'is_mr'=>0]); $this->success('删除成功!'); } /** * @title 获取收货地址列表 * @desc 获取收货地址列表 * @author qc * @url /api/Usermanage/getDeliveryAddressList * @method GET * @header name:Authorization require:1 desc:Token * @param name:page type:int default:1 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @return name:pro_id type:int default:-- desc:省id * @return name:city_id type:int default:-- desc:市id * @return name:county_id type:int default:-- desc:县区id * @return name:pro_name type:string default:-- desc:省名 * @return name:city_name type:string default:-- desc:市名 * @return name:county_name type:string default:-- desc:县区名 * @return name:detail type:string default:-- desc:详细地址 * @return name:phone type:string default:-- desc:联系电话 * @return name:name type:string default:-- desc:联系人 * @return name:is_mr type:int default:0 desc:是否是默认(0不默认,1默认) */ public function getDeliveryAddressList() { $list = Db::table('delivery_address') ->where(['user_id'=>$this->uid,'is_deleted'=>0]) ->order('is_mr desc ,id desc') ->limit($this->off_set,$this->page_num) ->select(); $this->success('ok',['list'=>$list]); } /** * @title 获取收货地址详情 * @desc 获取收货地址详情 * @author qc * @url /api/Usermanage/getDeliveryAddressDetail * @method GET * @header name:Authorization require:1 desc:Token * @param name:id type:int default:1 desc:收货地址记录id * @return name:pro_id type:int default:-- desc:省id * @return name:city_id type:int default:-- desc:市id * @return name:county_id type:int default:-- desc:县区id * @return name:pro_name type:string default:-- desc:省名 * @return name:city_name type:string default:-- desc:市名 * @return name:county_name type:string default:-- desc:县区名 * @return name:detail type:string default:-- desc:详细地址 * @return name:phone type:string default:-- desc:联系电话 * @return name:name type:string default:-- desc:联系人 * @return name:is_mr type:int default:0 desc:是否是默认(0不默认,1默认) */ public function getDeliveryAddressDetail() { $detail = Db::table('delivery_address')->find(input('id')); $this->success('ok',$detail); } /** * @title 获取明信片变更日志 * @desc 获取明信片变更日志 * @author qc * @url /api/Usermanage/getCrystalLog * @method GET * @header name:Authorization require:1 desc:Token * @param name:page type:int default:1 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @return name:create_at type:string default:-- desc:时间 * @return name:crystal type:int default:-- desc:变更数 * @return name:desc type:string default:-- desc:描述 */ public function getCrystalLog() { $list = Db::table('crystal_info') ->field('id,create_at,crystal,desc') ->where(['user_id'=>$this->uid,'is_deleted'=>0]) ->order('id desc') ->limit($this->off_set,$this->page_num) ->select(); $this->success('ok',['list'=>$list]); } /** * @title 获取推荐人信息 * @desc 获取推荐人信息 * @author qc * @url /api/Usermanage/getParentInfo * @method GET * @header name:Authorization require:1 desc:Token * @return name:name type:string default:-- desc:昵称 * @return name:headimg type:string default:-- desc:头像 * @return name:create_at type:string default:-- desc:注册时间 */ public function getParentInfo() { $pid = Db::table('store_member')->where('id',$this->uid)->value('pid'); $parent_info = []; if($pid){ $parent_info= Db::table('store_member') ->field('id,name,headimg,create_at') ->find($pid); } $this->success('ok',$parent_info); } /** * @title 获取我邀请的会员列表 * @desc 获取我邀请的会员列表 * @author qc * @url /api/Usermanage/getMyInviteList * @method GET * @header name:Authorization require:1 desc:Token * @param name:page type:int default:1 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @return name:name type:string default:-- desc:昵称 * @return name:headimg type:string default:-- desc:头像 * @return name:create_at type:string default:-- desc:注册时间 */ public function getMyInviteList() { $list = Db::table('store_member') ->field('id,name,headimg,create_at') ->where(['pid'=>$this->uid]) ->order('id desc') ->limit($this->page,$this->page_num) ->select(); $this->success('ok',$list); } /** * @title 获取推荐线统计数据 * @desc 获取推荐线统计数据 * @author qc * @url /api/Usermanage/getRecommendNum * @method GET * @header name:Authorization require:1 desc:Token * @return name:first_num type:int default:-- desc:一级下级数量 * @return name:second_num type:int default:-- desc:二级下级数量 * @return name:recommend_crystal type:int default:-- desc:收益 */ public function getRecommendNum() { $first_children = Db::table('store_member') ->field('id,pid') ->where('pid',$this->uid) ->select(); $second_children = Db::table('store_member') ->field('id,pid') ->where('pid','in',array_column($first_children,'id')) ->where('pid','>',0) ->select(); $recommend_crystal =Db::table('crystal_info') ->where('user_id','=',$this->uid) ->where('type','in',[1,12,13]) ->sum('crystal'); $recommend_crystal = $recommend_crystal?$recommend_crystal:0; $this->success('ok',['first_num'=>count($first_children),'second_num'=>count($second_children),'recommend_crystal'=>$recommend_crystal]); } /** * @title 用户反馈 * @desc 用户反馈 * @author qc * @url /api/Usermanage/leaveFeedback * @method POST * @header name:Authorization require:1 desc:Token * @param name:content type:string require:1 default:-- desc:反馈内容 * @param name:images type:string require:0 default:-- desc:反馈图片(逗号隔开,没有不传) */ public function leaveFeedback() { $insert_data = [ 'user_id'=>$this->uid, 'content'=>input('content'), 'images'=>input('images'), 'create_at'=>date('Y-m-d H:i:s') ]; Db::table('user_feedback')->insert($insert_data); $this->success('反馈成功',Db::getLastInsID()); } /** * @title 获取集市商品 * @desc 获取集市商品 * @author qc * @url /api/Usermanage/getMyMarketGoods * @method GET * @header name:Authorization require:1 desc:Token * @param name:page type:int default:1 desc:页数 * @param name:page_num type:int : default:20 desc:每页数 * @return name:id type:int default:-- desc:商品id * @return name:sell_price type:string default:-- desc:售价 * @return name:cover type:string default:-- desc:商品图 * @return name:status type:int default:-- desc:0已下架1正常售卖 * @return name:user_id type:int default:-- desc:售卖商品会员id * @return name:stock type:int default:-- desc:数量 * @return name:sell_price type:int default:-- desc:售价(所有数量的售价) * @return name:crystal type:float default:-- desc:每个价值 * @return name:sell_status type:int default:-- desc:售卖状态1在售2售完3真正支付中 * @return name:order_status type:int default:-- desc:0售卖中1已售卖/待发货2待收货3已完成 * @return name:pro_info type:array default:-- desc:详情 * @return name:pro_info.num type:int default:-- desc:数量 * @return name:pro_info.case_name type:int default:-- desc:名称 * @return name:pro_info.case_cover type:int default:-- desc:图片 * @return name:pro_info.crystal type:int default:-- desc:明信片 */ public function getMyMarketGoods() { $list = MarketGoods::where('user_id',$this->uid) ->order('id desc') ->limit($this->off_set,$this->page_num) ->select(); $this->success('ok',['list'=>$list]); } }