Usercenter.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use think\Db;
  5. use app\common\model\wallet;
  6. use Redis;
  7. /**
  8. * 会员中心,不是个人中心
  9. */
  10. class Usercenter extends Api
  11. {
  12. protected $noNeedLogin = [];
  13. protected $noNeedRight = '*';
  14. protected $allowFields = [
  15. 'id',
  16. 'username',
  17. 'nickname',
  18. // 'truename',
  19. 'mobile',
  20. 'avatar',
  21. // 'real_status',
  22. 'gender',
  23. 'height',
  24. 'weight',
  25. 'birthday',
  26. 'bio',
  27. 'idcard_status',
  28. 'cityname',
  29. 'photo_images',
  30. 'tag_ids',
  31. 'attribute',
  32. 'shoesize',
  33. 'wechat_account',
  34. ];
  35. //获取他人用户信息,留下足迹
  36. public function getuserinfo(){
  37. $uid = input_post('uid',0);
  38. $userinfo = Db::name('user')->field($this->allowFields)->where('id|username',$uid)->find();
  39. if(!$userinfo){
  40. $this->error('不存在的用户');
  41. }
  42. //用户数据
  43. $userinfo = info_domain_image($userinfo,['avatar','photo_images']);
  44. $idcard_confirm = Db::name('user_idconfirm')->where('user_id',$uid)->find();
  45. $new_data = [
  46. 'age' => birthtime_to_age($userinfo['birthday']),
  47. 'truename' => ($userinfo['idcard_status'] == 1 && isset($idcard_confirm['truename'])) ? $idcard_confirm['truename'] : '',
  48. ];
  49. //合并
  50. $userinfo = array_merge($userinfo,$new_data);
  51. //枚举
  52. $userinfo['tag'] = Db::name('enum_tag')->where('id','IN',$userinfo['tag_ids'])->field(['id','name'])->select();
  53. //vip
  54. $userinfo['vip_endtime'] = Db::name('user_wallet')->where('user_id',$uid)->value('vip_endtime');
  55. $userinfo['is_vip'] = $userinfo['vip_endtime'] > time() ? 1 : 0;
  56. //是否喜欢和关注
  57. $is_follow = Db::name('user_follow')->where(['uid'=>$this->auth->id,'follow_uid'=>$uid])->find();
  58. $userinfo['is_follow'] = $is_follow ? 1 : 0;
  59. $is_like = Db::name('user_like')->where(['uid'=>$this->auth->id,'like_uid'=>$uid])->find();
  60. $userinfo['is_like'] = $is_like ? 1 : 0;
  61. //是否拉黑
  62. $is_black = Db::name('user_black')->where(['uid'=>$this->auth->id,'black_uid'=>$uid])->find();
  63. $userinfo['is_black'] = $is_black ? 1 : 0;
  64. //关注人数,粉丝人数
  65. $follow_num = Db::name('user_follow')->where(['uid'=>$this->auth->id])->count('id');
  66. $fans_num = Db::name('user_follow')->where(['follow_uid'=>$this->auth->id])->count('id');
  67. $userinfo['follow_num'] = $follow_num;
  68. $userinfo['fans_num'] = $fans_num;
  69. //查看别人信息,就要留下痕迹
  70. if($this->user_power($this->auth->id,'wuhen') != 1){
  71. $data = [
  72. 'uid' => $this->auth->id,
  73. 'to_uid' => $uid,
  74. ];
  75. $check = Db::name('user_visit')->where($data)->find();
  76. if($check){
  77. Db::name('user_visit')->where($data)->update(['number'=>$check['number']+1,'updatetime'=>time()]);
  78. }else{
  79. $data['number'] = 1;
  80. $data['updatetime'] = time();
  81. Db::name('user_visit')->insertGetId($data);
  82. }
  83. }
  84. //活跃,在线
  85. $userinfo['active_info'] = $this->user_activeinfo($uid);
  86. //用户权限
  87. //$userinfo['power'] = Db::name('user_power')->where('user_id',$uid)->find();
  88. $this->success('success',$userinfo);
  89. }
  90. /////////////////////////////////////////////////////////////////////////////////////
  91. //这里不用连user_active表,完全使用user表的active_time,user_active表只做离线用
  92. //同城
  93. public function samecity(){
  94. $gender = input_post('gender','all');
  95. $agemin = input_post('agemin',0);
  96. $agemax = input_post('agemax',100);
  97. if(empty($this->auth->cityname) || empty($this->auth->longitude) || empty($this->auth->latitude)){
  98. // $this->success('success',[]);
  99. }
  100. $map = [
  101. 'user.status' => 1,
  102. // 'user.cityname' => $this->auth->cityname,
  103. 'user.id' => ['neq',$this->auth->id],
  104. // 'user.longitude' => ['neq',''],
  105. // 'user.latitude' => ['neq',''],
  106. // 'user.is_online|user.is_livebc' => 1, //完全不考虑直播与语聊的权重,只用活跃做排序
  107. // 'user.active_time' => ['gt',time()-86400],
  108. ];
  109. if($gender != 'all'){
  110. $map['user.gender'] = $gender;
  111. }
  112. $map['user.birthday'] = ['between',[time() - $agemax * 31536000,time() - $agemin * 31536000]];
  113. //dump($map);
  114. $field = [
  115. 'user.id','user.username','user.nickname','user.birthday','user.height','user.longitude','user.latitude','user.avatar','user.audio_bio','user.bio','user.gender','user.active_time'
  116. ];
  117. $list = Db::name('user')->alias('user')->field($field)->where($map)->order('user.active_time desc')->autopage()->select();
  118. //dump($list);
  119. $list = list_domain_image($list,['avatar']);
  120. foreach($list as $key => $one){
  121. $one['age'] = birthtime_to_age($one['birthday']);
  122. // $one['distance'] = $this->calc_map_distance([$this->auth->longitude,$this->auth->latitude],[$one['longitude'],$one['latitude']]);
  123. $one['distance'] = rand(0,10).'km';
  124. //状态
  125. $one['active_text'] = '刚刚离线';
  126. if($one['active_time'] > time()-21600){
  127. $one['active_text'] = '1小时内在线';
  128. }
  129. if($one['active_time'] > time()-3600){
  130. $one['active_text'] = '在线';
  131. }
  132. $list[$key] = $one;
  133. }
  134. $this->success('success',$list);
  135. }
  136. //附近
  137. public function nearuser(){
  138. $gender = input_post('gender','all');
  139. $agemin = input_post('agemin',0);
  140. $agemax = input_post('agemax',100);
  141. if(empty($this->auth->cityname) || empty($this->auth->longitude) || empty($this->auth->latitude)){
  142. // $this->success('success',[]);
  143. }
  144. //经过地图测算和公式推算,经度纬度 0.1即为11公里
  145. $map = [
  146. 'user.status' => 1,
  147. ////'user.cityname' => $this->auth->cityname,
  148. 'user.id' => ['neq',$this->auth->id],
  149. // 'user.longitude' => ['between',[$this->auth->longitude - 0.1,$this->auth->longitude + 0.1]],
  150. // 'user.latitude' => ['between',[$this->auth->latitude - 0.1,$this->auth->latitude + 0.1]],
  151. // 'user.is_online|user.is_livebc' => 1, //完全不考虑直播与语聊的权重,只用活跃做排序
  152. // 'user.active_time' => ['gt',time()-86400],
  153. ];
  154. if($gender != 'all'){
  155. $map['user.gender'] = $gender;
  156. }
  157. $map['user.birthday'] = ['between',[time() - $agemax * 31536000,time() - $agemin * 31536000]];
  158. //dump($map);
  159. $field = [
  160. 'user.id','user.username','user.nickname','user.birthday','user.height','user.longitude','user.latitude','user.avatar','user.audio_bio','user.bio','user.gender','user.active_time'
  161. ];
  162. $list = Db::name('user')->alias('user')->field($field)->where($map)->order('user.active_time desc')->autopage()->select();
  163. //dump($list);exit;
  164. $list = list_domain_image($list,['avatar']);
  165. foreach($list as $key => $one){
  166. $one['age'] = birthtime_to_age($one['birthday']);
  167. //$one['distance'] = $this->calc_map_distance([$this->auth->longitude,$this->auth->latitude],[$one['longitude'],$one['latitude']]);
  168. $one['distance'] = rand(0,10).'km';
  169. //状态
  170. $one['active_text'] = '刚刚离线';
  171. if($one['active_time'] > time()-21600){
  172. $one['active_text'] = '1小时内在线';
  173. }
  174. if($one['active_time'] > time()-3600){
  175. $one['active_text'] = '在线';
  176. }
  177. $list[$key] = $one;
  178. }
  179. $this->success('success',$list);
  180. }
  181. //语音匹配
  182. public function getaudiouser(){
  183. //判断资格
  184. /*$start = strtotime(date('Y-m-d'));
  185. $end = $start + 86399;
  186. $map = [
  187. 'user_id' => $this->auth->id,
  188. 'createtime' => ['between',[$start,$end]],
  189. 'price' => 0,
  190. ];
  191. $check = Db::name('user_match_audio_log')->where($map)->find();*/
  192. $check = true;
  193. //已经用掉免费的了,判断金额
  194. if($check){
  195. $price = config('site.audio_min_price');
  196. $gold = model('wallet')->getWallet($this->auth->id,'gold');
  197. if($gold < $price){
  198. $this->error('您的金币已经不足,请充值');
  199. }
  200. }
  201. //找到互关的人,排除
  202. //$follow_me = Db::name('user_follow')->where('follow_uid',$this->auth->id)->column('uid');
  203. //dump($follow_me);
  204. //$my_follow = Db::name('user_follow')->where(['uid'=>$this->auth->id,'follow_uid'=>['IN',$follow_me]])->column('follow_uid');
  205. //dump($my_follow);exit;
  206. //给出备选用户
  207. $map = [
  208. 'status' =>1, //未封禁用户
  209. 'gender' => $this->auth->gender == 1 ? 0 : 1, //异性
  210. 'is_online' => 0, //不在语聊间的
  211. 'is_livebc' => 0, //不在直播的
  212. 'is_active' => 1, //在线的
  213. //'real_status' => 1, //真人认证
  214. //'idcard_status' => 1, //实名认证
  215. 'open_match_audio' => 1, //打开语聊开关
  216. //'id' => ['NOT IN',$my_follow] //不是好友的
  217. 'id' => ['BETWEEN',[368,382]]
  218. ];
  219. $lists = Db::name('user')->field('id,cityname,status,gender,real_status,tag_ids')->where($map)->order('logintime desc')->page($this->page,100)->select();
  220. $lists = $this->fliter_user($lists,10);
  221. $result = [];
  222. if(!empty($lists)){
  223. foreach($lists as $key => $val){
  224. $result[] = ['id'=>$val];
  225. }
  226. }
  227. //tag任务赠送金币
  228. //语音匹配奖励 +5金币
  229. if(!empty($result)){
  230. $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,11);
  231. if($task_rs === false){
  232. $this->error('完成任务赠送奖励失败');
  233. }
  234. }
  235. $this->success('success',$result);
  236. }
  237. //视频匹配
  238. public function getvideouser(){
  239. //判断资格
  240. /*$start = strtotime(date('Y-m-d'));
  241. $end = $start + 86399;
  242. $map = [
  243. 'user_id' => $this->auth->id,
  244. 'createtime' => ['between',[$start,$end]],
  245. 'price' => 0,
  246. ];
  247. $check = Db::name('user_match_video_log')->where($map)->find();*/
  248. $check = true;
  249. //已经用掉免费的了,判断金额
  250. if($check){
  251. $price = config('site.video_min_price');
  252. $gold = model('wallet')->getWallet($this->auth->id,'gold');
  253. if($gold < $price){
  254. $this->error('您的金币已经不足,请充值');
  255. }
  256. }
  257. //找到互关的人,排除
  258. //$follow_me = Db::name('user_follow')->where('follow_uid',$this->auth->id)->column('uid');
  259. //dump($follow_me);
  260. //$my_follow = Db::name('user_follow')->where(['uid'=>$this->auth->id,'follow_uid'=>['IN',$follow_me]])->column('follow_uid');
  261. //dump($my_follow);exit;
  262. //给出备选用户
  263. $map = [
  264. 'status' =>1, //未封禁用户
  265. 'gender' => $this->auth->gender == 1 ? 0 : 1, //异性
  266. 'is_online' => 0, //不在语聊间的
  267. 'is_livebc' => 0, //不在直播的
  268. 'is_active' => 1, //在线的
  269. //'real_status' => 1, //真人认证
  270. //'idcard_status' => 1, //实名认证
  271. 'open_match_video' => 1, //打开视频开关的
  272. // 'id' => ['NOT IN',$my_follow] //不是好友的
  273. 'id' => ['BETWEEN',[368,382]]
  274. ];
  275. $lists = Db::name('user')->field('id,cityname,status,gender,real_status,tag_ids')->where($map)->order('logintime desc')->page($this->page,100)->select();
  276. $lists = $this->fliter_user($lists,10);
  277. $result = [];
  278. if(!empty($lists)){
  279. foreach($lists as $key => $val){
  280. $result[] = ['id'=>$val];
  281. }
  282. }
  283. //tag任务赠送金币
  284. //视频匹配奖励 +5金币
  285. if(!empty($result)){
  286. $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,12);
  287. if($task_rs === false){
  288. $this->error('完成任务赠送奖励失败');
  289. }
  290. }
  291. $this->success('success',$result);
  292. }
  293. //聊天匹配
  294. public function gettypinguser(){
  295. //找到互关的人,排除
  296. //$follow_me = Db::name('user_follow')->where('follow_uid',$this->auth->id)->column('uid');
  297. //dump($follow_me);
  298. //$my_follow = Db::name('user_follow')->where(['uid'=>$this->auth->id,'follow_uid'=>['IN',$follow_me]])->column('follow_uid');
  299. //dump($my_follow);exit;
  300. //给出备选用户
  301. $map = [
  302. 'status' =>1, //未封禁用户
  303. 'gender' => $this->auth->gender == 1 ? 0 : 1, //异性
  304. //'real_status' => 1, //真人认证
  305. //'idcard_status' => 1, //实名认证
  306. //'is_active' => 1, //在线的
  307. //打开聊天开关的
  308. 'open_match_typing' => 1, //打开文字聊天开关的
  309. //'id' => ['NOT IN',$my_follow] //不是好友的
  310. 'id' => ['BETWEEN',[368,382]]
  311. ];
  312. $lists = Db::name('user')->field('id,cityname,status,gender,real_status,tag_ids')->where($map)->order('logintime desc')->page($this->page,100)->select();
  313. //$lists = $this->fliter_user($lists,100);
  314. $lists = array_column($lists,'id');
  315. $result = [];
  316. if(!empty($lists)){
  317. /*foreach($lists as $key => $val){
  318. $result[] = ['id'=>$val];
  319. }*/
  320. $result = Db::name('user')->field('id,nickname,username,avatar,audio_bio')->where(['id'=>['IN',$lists]])->select();
  321. $result = list_domain_image($result,['avatar,audio_bio']);
  322. }
  323. //tag任务赠送金币
  324. //缘分匹配奖励 +5金币
  325. if(!empty($result)){
  326. $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,10);
  327. if($task_rs === false){
  328. $this->error('完成任务赠送奖励失败');
  329. }
  330. }
  331. $this->success('success',$result);
  332. }
  333. //过滤规则
  334. private function fliter_user($lists,$number = 1){
  335. if(empty($lists)){
  336. return $lists;
  337. }
  338. //dump($lists);
  339. //过滤掉通话中的
  340. foreach($lists as $key => $val){
  341. if(redis_matching_get($val['id']) == 1){
  342. unset($lists[$key]);
  343. }
  344. }
  345. //预留全部
  346. $all_result = array_column($lists,'id');
  347. //dump($all_result);
  348. //提取同城的
  349. $citydata = [];
  350. foreach($lists as $key => $val){
  351. if( !empty($this->auth->cityname) && $this->auth->cityname == $val['cityname'] ){
  352. $citydata[] = $val['id'];
  353. }
  354. }
  355. //dump($citydata);
  356. //有标签交集的
  357. $tagdata = [];
  358. foreach($lists as $key => $val){
  359. if( !empty($this->auth->tag_ids) && !empty($val['tag_ids']) ){
  360. $auth_tag_ids = explode(',',$this->auth->tag_ids);
  361. $val_tag_ids = explode(',',$val['tag_ids']);
  362. if(count(array_intersect($auth_tag_ids,$val_tag_ids)) > 0){
  363. $tagdata[] = $val['id'];
  364. }
  365. }
  366. }
  367. //dump($tagdata);
  368. //双条件都满足
  369. $double_data = [];
  370. if(!empty($citydata) && !empty($tagdata)){
  371. $double_data = array_intersect($citydata,$tagdata);
  372. }
  373. //dump($double_data);
  374. if(count($double_data) >= $number){
  375. return $double_data;
  376. }
  377. //两种条件合并,去重。空数组合并没影响
  378. $merge_data = array_merge($citydata,$tagdata);
  379. $merge_data = array_flip(array_flip($merge_data));
  380. //dump($merge_data);
  381. if(count($merge_data) >= $number){
  382. return $merge_data;
  383. }
  384. return $all_result;
  385. }
  386. /**
  387. * calc_map_distance() , 根据地图上的两个点各自的x,y坐标,计算出2点之间的直线距离
  388. * @param array $point_1 第1个点的x,y坐标 array( 101 , 202 )
  389. * @param array $point_2 第2个点的x,y坐标 array( 101 , 202 )
  390. * @param bool $calc_as_string 是否计算为字符串公里距离 , 如果未否返回数字
  391. * @return float | false | string
  392. */
  393. private function calc_map_distance( $point_1=array( ) , $point_2=array( ) , $calc_as_string=false ) {
  394. if( empty( $point_1 ) || empty( $point_2 ) ){
  395. return false;
  396. }
  397. // 经纬度不存在,或者经纬度超过最大范围 +-180 , +-90 ,返回false
  398. $p1_x = $point_1[0];
  399. $p1_y = $point_1[1];
  400. $p2_x = $point_2[0];
  401. $p2_y = $point_2[1];
  402. if(
  403. $p1_x < -180 || $p1_x > 180
  404. || $p2_x < -180 || $p2_x > 180
  405. || $p1_y < -90 || $p1_y > 90
  406. || $p2_y < -90 || $p2_y > 90
  407. ){
  408. return '0公里';
  409. }
  410. // 根据2点各自的坐标,计算2点之间直线距离的公式
  411. $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);
  412. // 是否计算为字符串公里距离
  413. if( !$calc_as_string ){
  414. return (string)round( $distance / 1000 , 1 ) . '公里';
  415. }
  416. // 如果计算为字符串公里距离
  417. if( $distance / 1000 > 1 ){
  418. $k = (string)round( $distance / 1000 , 1 );
  419. $m = (string)$distance % 1000 ;
  420. $distance = "{$k}公里{$m}米";
  421. }
  422. else{
  423. $distance = "{$distance}米";
  424. }
  425. return $distance;
  426. }
  427. //地图api,根据两地坐标,获得两地距离,打卡用的
  428. //type=0直线,type=1开车
  429. private function getmapjuli($start_lon,$start_lat,$end_lon,$end_lat,$type = 0){
  430. $result = 0;
  431. $apiurl = 'https://restapi.amap.com/v3/distance?';
  432. $param = [
  433. 'key' => '398c424811d1a59beac2f915323d334e',
  434. 'origins' => $start_lon.','.$start_lat,
  435. 'destination' => $end_lon.','.$end_lat,
  436. 'type' => $type,
  437. 'output' => 'json',
  438. ];
  439. $apiurl .= http_build_query($param);
  440. $request_rs = json_decode(curl_get($apiurl),true);
  441. if(isset($request_rs['status']) && $request_rs['status'] == 1){
  442. if(isset($request_rs['results'][0]['distance']))
  443. {
  444. $result = $request_rs['results'][0]['distance'];
  445. }
  446. }
  447. //dump($result);
  448. return $result;
  449. }
  450. public function distance()
  451. {
  452. $a = $this->calc_map_distance([118.339282,35.028445],[118.437399,35.017438]);
  453. dump($a);
  454. $a = $this->calc_map_distance([118.339282,35.028445],[118.437399,35.017438],true);
  455. dump($a);
  456. $b = $this->getmapjuli(118.339282,35.028445,118.437399,35.017438,1);
  457. dump($b);
  458. $b = $this->getmapjuli(118.339282,35.028445,118.437399,35.017438,0);
  459. dump($b);
  460. }
  461. }