auth->longitude) || empty($this->auth->latitude)){ // // $this->success('success',[]); // $this->error('请先开启定位'); // } // $type = input('type', 0, 'intval'); //类型: 0附近 1缘分 $type = input('type', 0, 'intval'); //类型: 0推荐 1附近 2新人 $age_id = input('age_id', 0, 'intval'); //年龄段 // $agemin = input('agemin', 0, 'intval'); //最小年龄 // $agemax = input('agemax', 100, 'intval'); //最大年龄 //经过地图测算和公式推算,经度纬度 0.1即为11公里 $map = [ 'user.gender' => $this->auth->gender == 1 ? 0 : 1,// 查询异性 'user.status' => 1, 'user.is_kefu' => 0, 'user.id' => ['neq',$this->auth->id], // 'user.cityname' => $this->auth->cityname, // 'user.longitude' => ['between',[$this->auth->longitude - 0.1,$this->auth->longitude + 0.1]], // 'user.latitude' => ['between',[$this->auth->latitude - 0.1,$this->auth->latitude + 0.1]], // 'user.is_online|user.is_livebc' => 1, //完全不考虑直播与语聊的权重,只用活跃做排序 ]; //排序 $order = 'user.is_active desc, user.logintime desc'; if (in_array($type,[0,1])) { if ($this->auth->gender == 1) { $order = 'user.is_active desc, user.logintime desc'; } else { $order = 'user.is_active desc, user.logintime desc'; } } if ($type == 0) { // $map['user.cityname'] = $this->auth->cityname; //同城 if ($this->auth->gender == 1) { $map['user.is_recommend'] = 1; } //$order = 'user.is_active desc, uw.pay_money desc,uw.get_money desc'; } elseif ($type == 1) { // $map['user.longitude'] = ['between',[$this->auth->longitude - 0.1,$this->auth->longitude + 0.1]]; // $map['user.latitude'] = ['between',[$this->auth->latitude - 0.1,$this->auth->latitude + 0.1]]; } else { $map['user.createtime'] = ['egt', time() - 86400 * 30]; // $order = 'user.createtime desc'; } if ($age_id > 0 && $age_id < 8) { if ($age_id == 1) { $agemin = 18; $agemax = 25; } elseif ($age_id == 2) { $agemin = 25; $agemax = 30; } elseif ($age_id == 3) { $agemin = 30; $agemax = 35; } elseif ($age_id == 4) { $agemin = 35; $agemax = 40; } elseif ($age_id == 5) { $agemin = 40; $agemax = 45; } elseif ($age_id == 6) { $agemin = 45; $agemax = 50; } elseif ($age_id == 7) { $agemin = 50; $agemax = 200; } $map['user.birthday'] = ['between', [time() - $agemax * 31536000, time() - $agemin * 31536000]]; } //dump($map); $field = [ 'user.id','user.nickname','user.birthday','user.height','user.longitude','user.latitude','user.avatar','user.bio','user.gender','user.idcard_status', 'user.real_status', 'user.job', 'user.is_active', 'user.wages', 'user.is_recommend', 'user.cityname', 'user.hometown_cityid', 'user.is_hideaddress' ]; //$list = Db::name('user')->alias('user')->field($field)->where($map)->order($order)->autopage()->select(); $list = Db::name('user')->alias('user')->field($field) //->join('user_wallet uw','uw.user_id = user.id','LEFT') ->where($map)->order($order)->autopage()->select(); $list = list_domain_image($list,['avatar']); // $mt_enum_job = Db::name('enum_job'); //职业 // $mt_enum_wages = Db::name('enum_wages'); //收入 $mt_user_wallet = Db::name('user_wallet'); //vip $mt_user_greet = Db::name('user_greet'); //是否打过招呼 // $mt_wealth_level = Db::name('wealth_level'); //财富等级 // $mt_charm_level = Db::name('charm_level'); //魅力等级 $mt_area = Db::name('area'); //城市 $time = time(); $hometown_cityid = [];//城市ids $user_to_id = [];//打招呼ids foreach ($list as $key=>$val){ $hometown_cityid[] = $val['hometown_cityid']; $user_to_id[] = $val['id']; } // 城市 $mt_areas = $mt_area->field(['id','name'])->whereIn('id',$hometown_cityid)->select(); $mt_areas = array_column($mt_areas ?? [],'name','id'); // 是否打过招呼 $mt_user_greets = $mt_user_greet->field(['user_to_id','count(id) as num'])->where('user_id', $this->auth->id)->whereIn('user_to_id',$user_to_id)->group('user_to_id')->select(); $mt_user_greets = array_column($mt_user_greets ?? [],'num','user_to_id'); // 是否是vip $mt_user_wallets = $mt_user_wallet->field(['id','user_id','vip_endtime','pay_money'])->whereIn('user_id',$user_to_id)->select(); // 财富等级 // $mt_wealth_levels = $mt_wealth_level->order('id desc')->column('value,image'); // 魅力等级 // $mt_charm_levels = $mt_charm_level->order('id desc')->column('value,image'); foreach($list as $key => &$v) { if ($this->auth->gender == 1) { //用户是男的 $age = birthtime_to_age($v['birthday']); // $job = $mt_enum_job->where(['id' => $v['job_id']])->value('name'); // $v['desc'] = $distance . ' · ' . $age . '岁'; $v['desc'] = ''; if ($age > 0) { $v['desc'] = $age . '岁'; } else { $v['desc'] = '18岁'; } if ($v['height']) { $v['desc'] .= ' | ' . $v['height']; } // if ($job) { // $v['desc'] .= ' · ' . $job; // } if ($type == 1) { // $distance = $this->calc_map_distance([$this->auth->longitude, $this->auth->latitude], [$v['longitude'], $v['latitude']]); // $v['desc'] .= ' | ' . $distance; $v['desc'] .= ' | 10km+'; } } else { if ($type != 1) { $v['desc'] = $v['bio'] ?: '暂未设置个性签名'; } else { $age = birthtime_to_age($v['birthday']); // $wages = $mt_enum_wages->where(['id' => $v['wages_id']])->value('name'); // $v['desc'] = $distance . ' · ' . $age . '岁'; $v['desc'] = ''; if ($age > 0) { $v['desc'] = $age . '岁'; } else { $v['desc'] = '18岁'; } if ($v['hometown_cityid']) { $hometown_city = $mt_areas[$v['hometown_cityid']] ?? ''; $hometown_city = ($hometown_city && $v['is_hideaddress'] == 0) ? $hometown_city : ''; if ($hometown_city) { $v['desc'] .= ' | ' . $hometown_city; } } // if ($wages) { // $v['desc'] .= ' · ' . $wages; // } } } //查询是否打过招呼 $count = $mt_user_greets[$v['id']] ?? 0; if ($count) { $v['is_chat'] = 1; //是否打过招呼: 1是 0否 } else { $v['is_chat'] = 0; //是否打过招呼: 1是 0否 } $vip_endtime = 0; $pay_money = 0; foreach ($mt_user_wallets as $kk=>$vv){ if ($vv['user_id'] == $v['id']) { $vip_endtime = $vv['vip_endtime']; $pay_money = $vv['pay_money']; break; } } if ($vip_endtime >= $time) { $v['is_vip'] = 1; //是否是vip: 1是 0否 } else { $v['is_vip'] = 0; //是否是vip: 1是 0否 } //查询财富等级 /*if (!empty($mt_wealth_levels)) { $name = ''; foreach ($mt_wealth_levels as $kkk=>$vvv){ if ($pay_money > $kkk){ $name = localpath_to_netpath($vvv); break; } } $v['wealth_level'] = $name; } else { $v['wealth_level'] = ''; }*/ //查询魅力等级 /*if (!empty($mt_charm_levels)) { $name = ''; foreach ($mt_charm_levels as $kkk=>$vvv){ if ($pay_money > $kkk){ $name = localpath_to_netpath($vvv); break; } } $v['charm_level'] = $name; } else { $v['charm_level'] = ''; }*/ } $this->success('success',$list); } //轮播图 public function banner() { $type = input('type', 0, 'intval'); //类型:0=交友轮播图,1=动态轮播图 $list = Db::name('banner')->field('id, title, image, url')->where(['status' => 1, 'type' => $type])->order('weigh', 'desc')->select(); $list = list_domain_image($list, ['image']); $this->success('轮播图', $list); } //筛选年龄段 public function agerange() { $list = [ [ 'id' => 0, 'title' => '不限' ], [ 'id' => 1, 'title' => '18-25岁' ], [ 'id' => 2, 'title' => '25-30岁' ], [ 'id' => 3, 'title' => '30-35岁' ], [ 'id' => 4, 'title' => '35-40岁' ], [ 'id' => 5, 'title' => '40-45岁' ], [ 'id' => 6, 'title' => '45-50岁' ], [ 'id' => 7, 'title' => '50岁以上' ] ]; $this->success('筛选年龄段', $list); } /** * calc_map_distance() , 根据地图上的两个点各自的x,y坐标,计算出2点之间的直线距离 * @param array $point_1 第1个点的x,y坐标 array( 101 , 202 ) * @param array $point_2 第2个点的x,y坐标 array( 101 , 202 ) * @param bool $calc_as_string 是否计算为字符串公里距离 , 如果未否返回数字 * @return float | false | string */ private function calc_map_distance( $point_1=array( ) , $point_2=array( ) , $calc_as_string=false ) { if( empty( $point_1 ) || empty( $point_2 ) ){ return false; } // 经纬度不存在,或者经纬度超过最大范围 +-180 , +-90 ,返回false $p1_x = $point_1[0]; $p1_y = $point_1[1]; $p2_x = $point_2[0]; $p2_y = $point_2[1]; if( $p1_x < -180 || $p1_x > 180 || $p2_x < -180 || $p2_x > 180 || $p1_y < -90 || $p1_y > 90 || $p2_y < -90 || $p2_y > 90 || $p1_x == '' || $p1_y == '' || $p2_x == '' || $p2_y == '' ){ return '距离未知'; } // 根据2点各自的坐标,计算2点之间直线距离的公式 $distance = round(6378.138*2*asin(sqrt(pow(sin(( $p1_x *pi()/180-$p2_x*pi()/180)/2),2)+cos( $p1_x *pi()/180)*cos($p2_x*pi()/180)* pow(sin(( $p1_y *pi()/180-$p2_y*pi()/180)/2),2)))*1000); // 是否计算为字符串公里距离 if( !$calc_as_string ){ return (string)round( $distance / 1000 , 1 ) . 'km'; } // 如果计算为字符串公里距离 if( $distance / 1000 > 1 ){ $k = (string)round( $distance / 1000 , 1 ); $m = (string)$distance % 1000 ; // $distance = "{$k}公里{$m}米"; $distance = "{$k}km"; } else{ $distance = "{$distance}m"; } return $distance; } //女号私信异性完成任务 public function girlchattask() { if ($this->auth->gender != 0) { //只有女生可以 $this->error('您的网络开小差啦~'); } //检测用户 $to_user_id = input_post('to_user_id'); $to_user_info = Db::name('user')->field('id,real_status,gender,free_video,free_audio,free_typing,chat_price,is_kefu')->where('id',$to_user_id)->find(); if(!$to_user_info){ $this->error('不存在的用户'); } if ($to_user_info['is_kefu'] == 1 || $this->auth->is_kefu == 1) { //我是客服或者对方是客服 $this->success('success'); } if ($to_user_info['gender'] != 1) { $this->error('性别异常~'); } $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,23); if($task_rs === false){ $this->error('完成任务赠送奖励失败'); } $this->success('success'); } //腾讯内容审核回调方法 public function tencentcall() { $content = file_get_contents('php://input'); $content = json_decode($content, true); error_log(print_r($content, 1) . PHP_EOL, 3, './tencentcall3.txt'); if (isset($content['Scene']) && $content['CtxcbResult'] == 1) { //语音文件: 只返回违规的数据; 处理方式: 撤回 $tenim = new Tenim; $rs = $tenim->withdraw_message($content['From_Account'], $content['ContactItem']['To_Account'], $content['MsgID']); // error_log(print_r($rs, 1) . PHP_EOL, 3, './tencentcall4.txt'); } elseif (isset($content['TaskId'])) { //音视频通话: 返回所有数据; 处理方式: 强制退出im, 清空token if ($content['Status'] == 'RUNNING') { //该字段用于返回所查询内容的任务状态。取值:FINISH(任务已完成)、PENDING (任务等待中)、RUNNING (任务进行中)、ERROR (任务出错)、CANCELLED (任务已取消)。 if ($content['ImageSegments']) { //图片(视频)审核结果 $image_info = $content['ImageSegments'][0]['Result']; if ($image_info['Label'] != 'Normal') { //该字段用于返回检测结果所对应的恶意标签。返回值:Porn:色情,Abuse:谩骂,Ad:广告,Custom:自定义违规;以及其他令人反感、不安全或不适宜的内容类型。 $url = $image_info['Url']; //图片地址https://cos.ap-guangzhou.myqcloud.com/tianyu-cms-ap-guangzhou-1312781550/segment-/trtc/1400758343/screenshot_1431291856_2_1669880705.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIDU2hLdl3CBZnuZ1rugInQEXxleKiEtIgHzkXoQu9u_1LZ_Cr9CmyRstQ34Fs_0ktH%2F20221201%2Fap-guangzhou%2Fs3%2Faws4_request&X-Amz-Date=20221201T074505Z&X-Amz-Expires=43200&X-Amz-Security-Token=HuyqAZVXXBWnWFOJZNLYInkTvVfFNqRab1d55d6d8642abaaa3d1c727ba06bd0eg37ybZOWCCsEawceCDvRAt1WL91GOzLIcdyC_DDX80alqE3M1GoQfUYRBETYm7eFxQ_wylmfSaomUU5hylq3twTxz9joT9g2rLfXhBmPeuvBia3n30gHeJtUeHJ7kaKjTDzZzPcq-B3t6hRximMVjKfQ9rKnJpjJGDKh-yqIpEUvyqFFl6Cf3d4lDoF87xwAAPya7Q2tMfZsMCyfgIMEqghMnGgWDMn9fMvDLl_82uGt8kK2TBGVymmeSx9GDGrDqBNo-hMC_EFR9jEUs87aDaD_gTNr2vLypRx87GnJhYCW7i-ExcfDfayKjXWy8LZeOtkc2Y0qDvzrEqcf5GtNBLPhgDzkbRyFgiWe99WsIrXH4RMlONiFitvvNAmWGvbv&X-Amz-SignedHeaders=host&X-Amz-Signature=e3b2a479c08d3fae95782e4bd62d88242726e095a771c28f38ccc7ed96c79d56 //获取违规用户id $url = explode('?', $url); $url = $url[0]; $user_id_url = explode('/', $url); $user_id_url = $user_id_url[count($user_id_url) - 1]; $user_id_arr = explode('_', $user_id_url); $user_id = $user_id_arr[2]; //退出im $tenIm = new Tenim(); $tenIm->loginoutim($user_id); //清空token Token::clear($user_id); $tiaoshi = $user_id . '---' . $content['TaskId'] . '---' .$image_info['Label'] .'---'. date('Y-m-d H:i:s'); error_log(print_r($tiaoshi, 1) . PHP_EOL, 3, './dayin1.txt'); } } elseif ($content['AudioSegments']) { //音频审核结果 $audio_info = $content['AudioSegments'][0]['Result']; if ($audio_info['Label'] != 'Normal') { //该字段用于返回检测结果所对应的恶意标签。返回值:Porn:色情,Abuse:谩骂,Ad:广告,Custom:自定义违规;以及其他令人反感、不安全或不适宜的内容类型。 $url = $audio_info['Url']; //音频地址https://cos.ap-guangzhou.myqcloud.com/tianyu-cms-ap-guangzhou-1312781550/segment-/trtc/1400758343/audio_1431291856_354_1669880708.mp3?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIDU2hLdl3CBZnuZ1rugInQEXxleKiEtIgHzkXoQu9u_1LZ_Cr9CmyRstQ34Fs_0ktH%2F20221201%2Fap-guangzhou%2Fs3%2Faws4_request&X-Amz-Date=20221201T074520Z&X-Amz-Expires=43200&X-Amz-Security-Token=HuyqAZVXXBWnWFOJZNLYInkTvVfFNqRab1d55d6d8642abaaa3d1c727ba06bd0eg37ybZOWCCsEawceCDvRAt1WL91GOzLIcdyC_DDX80alqE3M1GoQfUYRBETYm7eFxQ_wylmfSaomUU5hylq3twTxz9joT9g2rLfXhBmPeuvBia3n30gHeJtUeHJ7kaKjTDzZzPcq-B3t6hRximMVjKfQ9rKnJpjJGDKh-yqIpEUvyqFFl6Cf3d4lDoF87xwAAPya7Q2tMfZsMCyfgIMEqghMnGgWDMn9fMvDLl_82uGt8kK2TBGVymmeSx9GDGrDqBNo-hMC_EFR9jEUs87aDaD_gTNr2vLypRx87GnJhYCW7i-ExcfDfayKjXWy8LZeOtkc2Y0qDvzrEqcf5GtNBLPhgDzkbRyFgiWe99WsIrXH4RMlONiFitvvNAmWGvbv&X-Amz-SignedHeaders=host&X-Amz-Signature=b1965689653813b59824647292565ec9297a7e81950bb88d8cbeb95f8393c1ca //获取违规用户id $url = explode('?', $url); $url = $url[0]; $user_id_url = explode('/', $url); $user_id_url = $user_id_url[count($user_id_url) - 1]; $user_id_arr = explode('_', $user_id_url); $user_id = $user_id_arr[2]; //退出im $tenIm = new Tenim(); $tenIm->loginoutim($user_id); //清空token Token::clear($user_id); $tiaoshi = $user_id . '---' . $content['TaskId'] . '---' .$audio_info['Label'] .'---'. date('Y-m-d H:i:s'); error_log(print_r($tiaoshi, 1) . PHP_EOL, 3, './dayin2.txt'); } } } } } //头条 public function headlines() { $time = strtotime(date('Y-m-d', time())); //聊天送礼物 $list1 = Db::name('gift_user_typing')->field('id, user_id, user_to_id, gift_name')->where(['createtime' => ['egt', $time]])->order('price desc, id desc')/*->page($this->page, $this->listrow)*/->select(); //动态送礼物 $list2 = Db::name('gift_user_dongtai')->field('id, user_id, user_to_id, gift_name')->where(['createtime' => ['egt', $time]])->order('price desc, id desc')/*->page($this->page, $this->listrow)*/->select(); $list = array_merge($list1, $list2); if ($list) { $mt_user = Db::name('user'); foreach ($list as &$v) { $user_info= $mt_user->field('nickname, avatar')->where(['id' => $v['user_id']])->find(); $v['from_nickname'] = '有缘人';//$user_info['nickname']; $v['avatar'] = one_domain_image($user_info['avatar']); $v['to_nickname'] = '有缘人';//$mt_user->where(['id' => $v['user_to_id']])->value('nickname'); } } $this->success('头条', $list); } //首页顶部分类名称 public function typename() { $typename = config('site.typename'); $typename = explode(',', $typename); $data[] = $typename[0] ? : '推荐'; $data[] = $typename[1] ? : '附近'; $data[] = $typename[2] ? : '新人'; $this->success('sussess', $data); } }