$this->auth->gender == 1 ? 0 : 1,// 查询异性 'user.status' => 1, 'user.is_kefu' => 0, 'user.id' => ['neq',$this->auth->id], ]; //排序 $order = 'user.is_active desc, user.logintime desc'; if ($type == 0) { if ($this->auth->gender == 1) { $map['user.is_recommend'] = 1; } } elseif ($type == 1) { } else { $map['user.createtime'] = ['egt', time() - 86400 * 30]; } 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]]; } $field = [ 'user.id','user.nickname','user.birthday','user.height','user.avatar','user.bio','user.gender','user.idcard_status', 'user.real_status', 'user.is_active','user.is_recommend', 'user.cityname','user.is_hideaddress','uw.vip_endtime','uw.vip_level' ]; $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']); //ids $user_to_id = array_column($list,'id'); // 是否打过招呼 $mt_user_greet = Db::name('user_greet')->where('user_id', $this->auth->id)->whereIn('user_to_id',$user_to_id)->group('user_to_id')->column('user_to_id'); foreach($list as $key => &$v) { //年龄 $age = birthtime_to_age($v['birthday']); $age = $age > 0 ? $age : 18; $v['age'] = $age; $v['birthday'] = $age; $v['bio'] = $v['bio'] ? $v['bio'] : '暂未设置个性签名'; //拼接年龄与身高 $v['desc'] = $age . '岁'; if ($v['height']) { $v['desc'] .= ' | ' . $v['height']; } if ($type == 2) { $v['desc'] = $v['bio']; } //VIP $v['is_vip'] = $this->is_vip($v['vip_endtime'],$v['vip_level']); //是否打过招呼: 1是 0否 $v['is_chat'] = in_array($v['id'],$mt_user_greet) ? 1 : 0; } $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); } }