verify_sign(); // 验证登录 $uid = $this->checkLogin(); // 查询数据 // 获取客户城市ID $custom = $Custom->getOne($uid); //查询拉新活动 if( !$custom['city_id'] ) return json_send(['code'=>'error','msg'=>'请选择所在城市后下单','data'=>['error'=>'请选择所在城市后下单']]); // 获取城市ID $cityId = (string)$custom['city_id']; // 查询用户标签 $tags = $WeiBanTags->getListByWeibanExtid($custom['weiban_extid']); $time = time(); $select = [ ['start_time','<=',$time], ['end_time','>',$time], ['status','=',0], ]; $activeList = $Model::query()->whereRaw("find_in_set('$cityId', city_ids)")->where($select)->get()->toArray(); $activeInfo = []; if ($activeList) { foreach ($activeList as $active) { $allowJoin = 0; if ($active['tag_scope']) { // 解析数组 $tag_scope = explode(',', $active['tag_scope']); // 标签范围限定时,默认不能参与 // 判断标签是不是存在 if ($tags) { foreach ($tags as $v) { // 标签范围内,允许参加 if (in_array($v['name'], $tag_scope)) $allowJoin = 1; } } }else{ $allowJoin = 1; } if ($active['tag_except']) { // 解析数组 $tag_except = explode(',', $active['tag_except']); // 标签范围限定时,默认不能参与 $allowJoin = 0; // 判断标签是不是存在 if ($tags) { foreach ($tags as $v) { // 标签范围内,允许参加 if (in_array($v['name'], $tag_except)) $allowJoin = 0; } } } if ($allowJoin) { $activeInfo = $active; break; } } } return json_send(['code'=>'success','msg'=>'获取成功','data'=>$activeInfo]); } /** * 获取奖励记录 /api/recruitment/get_record * * */ public function get_record(RecruitmentPrizeRecord $recruitmentPrizeRecord){ // 接口验签 // $this->verify_sign(); // 验证登录 $uid = $this->checkLogin(); // 接收参数 $limit = request('limit',15); // 查询条件 $map = [['recruitment_prize_record.custom_uid','=',$uid]]; // 查询数据 $Paginator = $recruitmentPrizeRecord->query() ->join('recruitment_record','recruitment_record.id','=','recruitment_prize_record.recruitment_record_id') ->join('custom','custom.id','=','recruitment_record.new_uid') ->where($map) ->orderByDesc('id') ->paginate($limit,['recruitment_prize_record.id','recruitment_prize_record.prize_type','recruitment_prize_record.prize','recruitment_prize_record.type','recruitment_prize_record.custom_uid','recruitment_prize_record.insert_time','recruitment_prize_record.recruitment_record_id','custom.username']); // 重置数据 $list = []; // 获取数据 $list['total'] = $Paginator->total(); $list['current_page'] = $Paginator->currentPage(); $list['per_page'] = $Paginator->perPage(); $list['last_page'] = $Paginator->lastPage(); $list['data'] = $Paginator->items(); // 循环数据 foreach ($list['data'] as $key => $value) { // 处理时间 $value['insert_time'] = date('Y-m-d H:i:s',$value['insert_time']); // 重组 $list['data'][$key] = $value; } // 返回数据 return json_send(['code'=>'success','msg'=>'获取成功','data'=>$list]); } }