Usercenter.php 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965
  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 = ['test','testredis'];
  13. protected $noNeedRight = '*';
  14. protected $allowFields = [
  15. 'id',
  16. 'username',
  17. 'nickname',
  18. //'truename',//
  19. 'email',
  20. 'mobile',
  21. 'avatar',
  22. 'real_status',
  23. 'gender',
  24. 'height',
  25. 'weight',
  26. 'birthday',
  27. 'bio',
  28. 'audio_bio',
  29. //'alipay_account',//
  30. 'idcard_status',
  31. 'longitude',
  32. 'latitude',
  33. 'cityname',
  34. 'photo_images',
  35. 'education_id',
  36. 'hobby_ids',
  37. 'job_id',
  38. 'marital_id',
  39. 'tag_ids',
  40. 'wages_id',
  41. 'hometown_cityid',
  42. ];
  43. public function testredis(){
  44. //redis_matching_set(1,125);
  45. dump(redis_matching_get(1));
  46. $a = cache('?mt_matching_uid_1','',['type'=>'Redis']);
  47. dump($a);
  48. }
  49. public function test(){
  50. $a = [1,4,10,22,66,36,102,45,23,52,35,76,7];
  51. $b = [1,10,7,102];
  52. $c = [10,102];
  53. //dump(array_intersect($a,$b));
  54. $data = array_merge($c,$b);
  55. dump($data);
  56. dump(array_flip(array_flip($data)));
  57. dump(array_flip([]));
  58. }
  59. //获取他人用户信息,留下足迹
  60. public function getuserinfo(){
  61. $uid = input_post('uid',0);
  62. $userinfo = Db::name('user')->field($this->allowFields)->where('id',$uid)->find();
  63. if(!$userinfo){
  64. $this->error('不存在的用户');
  65. }
  66. //
  67. $userinfo = info_domain_image($userinfo,['avatar','photo_images']);
  68. $idcard_confirm = Db::name('user_idconfirm')->where('user_id',$uid)->find();
  69. $new_data = [
  70. 'age' => birthtime_to_age($userinfo['birthday']),
  71. 'truename' => ($userinfo['idcard_status'] == 1 && isset($idcard_confirm['truename'])) ? $idcard_confirm['truename'] : '',
  72. 'alipay_account' => ($userinfo['idcard_status'] == 1 && isset($idcard_confirm['alipay_account'])) ? $idcard_confirm['alipay_account'] : '',
  73. ];
  74. $userinfo = array_merge($userinfo,$new_data);
  75. //枚举
  76. $userinfo['education'] = Db::name('enum_education')->where('id',$userinfo['education_id'])->value('name');
  77. $userinfo['hobby'] = Db::name('enum_hobby')->where('id','IN',$userinfo['hobby_ids'])->field(['id','name'])->select();
  78. $userinfo['job'] = Db::name('enum_job')->where('id',$userinfo['job_id'])->value('name');
  79. $userinfo['marital'] = Db::name('enum_marital')->where('id',$userinfo['marital_id'])->value('name');
  80. $userinfo['tag'] = Db::name('enum_tag')->where('id','IN',$userinfo['tag_ids'])->field(['id','name'])->select();
  81. $userinfo['wages'] = Db::name('enum_wages')->where('id',$userinfo['wages_id'])->value('name');
  82. //家乡
  83. $userinfo['hometown_city'] = Db::name('area')->where('id',$userinfo['hometown_cityid'])->value('name');
  84. //vip
  85. $userinfo['vip_endtime'] = Db::name('user_wallet')->where('user_id',$uid)->value('vip_endtime');
  86. $userinfo['is_vip'] = $userinfo['vip_endtime'] > time() ? 1 : 0;
  87. //是否喜欢和关注
  88. $is_follow = Db::name('user_follow')->where(['uid'=>$this->auth->id,'follow_uid'=>$uid])->find();
  89. $userinfo['is_follow'] = $is_follow ? 1 : 0;
  90. $is_like = Db::name('user_like')->where(['uid'=>$this->auth->id,'like_uid'=>$uid])->find();
  91. $userinfo['is_like'] = $is_like ? 1 : 0;
  92. //是否拉黑
  93. $is_black = Db::name('user_black')->where(['uid'=>$this->auth->id,'black_uid'=>$uid])->find();
  94. $userinfo['is_black'] = $is_black ? 1 : 0;
  95. //关注人数,粉丝人数
  96. $follow_num = Db::name('user_follow')->where(['uid'=>$this->auth->id])->count('id');
  97. $fans_num = Db::name('user_follow')->where(['follow_uid'=>$this->auth->id])->count('id');
  98. $userinfo['follow_num'] = $follow_num;
  99. $userinfo['fans_num'] = $fans_num;
  100. //查看别人信息,就要留下痕迹
  101. $data = [
  102. 'uid' => $this->auth->id,
  103. 'to_uid' => $uid,
  104. ];
  105. $check = Db::name('user_visit')->where($data)->find();
  106. if($check){
  107. Db::name('user_visit')->where($data)->update(['number'=>$check['number']+1,'updatetime'=>time()]);
  108. }else{
  109. $data['number'] = 1;
  110. $data['updatetime'] = time();
  111. Db::name('user_visit')->insertGetId($data);
  112. }
  113. $this->success('success',$userinfo);
  114. }
  115. //同城
  116. public function samecity(){
  117. $gender = input_post('gender','all');
  118. $agemin = input_post('agemin',0);
  119. $agemax = input_post('agemax',100);
  120. if(empty($this->auth->cityname) || empty($this->auth->longitude) || empty($this->auth->latitude)){
  121. // $this->success('success',[]);
  122. }
  123. $map = [
  124. 'user.status' => 1,
  125. // 'user.cityname' => $this->auth->cityname,
  126. 'user.id' => ['neq',$this->auth->id],
  127. // 'user.longitude' => ['neq',''],
  128. // 'user.latitude' => ['neq',''],
  129. // 'user.is_online|user.is_livebc' => 1, //完全不考虑直播与语聊的权重,只用活跃做排序
  130. 'user.is_active' => 1,//完全不考虑直播与语聊的权重,只用活跃做排序
  131. ];
  132. if($gender != 'all'){
  133. $map['user.gender'] = $gender;
  134. }
  135. $map['user.birthday'] = ['between',[time() - $agemax * 31536000,time() - $agemin * 31536000]];
  136. //dump($map);
  137. $field = [
  138. 'user.id','user.username','user.nickname','user.birthday','user.height','user.longitude','user.latitude','user.avatar','user.audio_bio','user.bio','user.gender'
  139. ];
  140. $list = Db::name('user')->alias('user')->field($field)->where($map)->order('active_time desc')->autopage()->select();
  141. //dump($list);
  142. $list = list_domain_image($list,['avatar']);
  143. foreach($list as $key => $one){
  144. $one['age'] = birthtime_to_age($one['birthday']);
  145. // $one['distance'] = $this->calc_map_distance([$this->auth->longitude,$this->auth->latitude],[$one['longitude'],$one['latitude']]);
  146. $one['distance'] = rand(0,10).'公里';
  147. $list[$key] = $one;
  148. }
  149. $this->success('success',$list);
  150. }
  151. //附近
  152. public function nearuser(){
  153. $gender = input_post('gender','all');
  154. $agemin = input_post('agemin',0);
  155. $agemax = input_post('agemax',100);
  156. if(empty($this->auth->cityname) || empty($this->auth->longitude) || empty($this->auth->latitude)){
  157. // $this->success('success',[]);
  158. }
  159. //经过地图测算和公式推算,经度纬度 0.1即为11公里
  160. $map = [
  161. 'user.status' => 1,
  162. ////'user.cityname' => $this->auth->cityname,
  163. 'user.id' => ['neq',$this->auth->id],
  164. // 'user.longitude' => ['between',[$this->auth->longitude - 0.1,$this->auth->longitude + 0.1]],
  165. // 'user.latitude' => ['between',[$this->auth->latitude - 0.1,$this->auth->latitude + 0.1]],
  166. // 'user.is_online|user.is_livebc' => 1, //完全不考虑直播与语聊的权重,只用活跃做排序
  167. 'user.is_active' => 1,//完全不考虑直播与语聊的权重,只用活跃做排序
  168. ];
  169. if($gender != 'all'){
  170. $map['user.gender'] = $gender;
  171. }
  172. $map['user.birthday'] = ['between',[time() - $agemax * 31536000,time() - $agemin * 31536000]];
  173. //dump($map);
  174. $field = [
  175. 'user.id','user.username','user.nickname','user.birthday','user.height','user.longitude','user.latitude','user.avatar','user.audio_bio','user.bio','user.gender'
  176. ];
  177. $list = Db::name('user')->alias('user')->field($field)->where($map)->order('active_time desc')->autopage()->select();
  178. //dump($list);exit;
  179. $list = list_domain_image($list,['avatar']);
  180. foreach($list as $key => $one){
  181. $one['age'] = birthtime_to_age($one['birthday']);
  182. //$one['distance'] = $this->calc_map_distance([$this->auth->longitude,$this->auth->latitude],[$one['longitude'],$one['latitude']]);
  183. $one['distance'] = rand(0,10).'公里';
  184. $list[$key] = $one;
  185. }
  186. $this->success('success',$list);
  187. }
  188. //视频通话每分钟调用一次
  189. public function video_onemin(){
  190. //检测用户
  191. $to_user_id = input_post('to_user_id');
  192. $to_user_info = Db::name('user')->field('id,real_status,gender,free_video,free_audio,free_typing')->where('id',$to_user_id)->find();
  193. if(!$to_user_info){
  194. $this->error('不存在的用户');
  195. }
  196. //正常价格
  197. $price = config('site.video_min_price'); //扣费金币
  198. $bili = config('site.money_to_gold'); //兑换比例
  199. $gift_plat_scale = config('site.gift_plat_scale'); //抽成比例
  200. $money = bcdiv($price,$bili,2); //对应人民币
  201. $money = bcdiv(bcmul($money,100 - $gift_plat_scale,2),100,2); //抽成后收益
  202. //发起用户的分数,被发起用户的分数。按性别给分
  203. $auth_level = 0;
  204. $tous_level = 0;
  205. //打分
  206. if($this->auth->gender == 0 && $this->auth->real_status == 1){
  207. $auth_level = 30;//实名女最高
  208. }
  209. if($this->auth->gender == 0 && $this->auth->real_status != 1){
  210. $auth_level = 20;//未实名女次之
  211. }
  212. if($this->auth->gender == 1){
  213. $auth_level = 10;//男性最低
  214. }
  215. if($to_user_info['gender'] == 0 && $to_user_info['real_status'] == 1){
  216. $tous_level = 30;
  217. }
  218. if($to_user_info['gender'] == 0 && $to_user_info['real_status'] != 1){
  219. $tous_level = 20;
  220. }
  221. if($to_user_info['gender'] == 1){
  222. $tous_level = 10;
  223. }
  224. //同性不收钱
  225. //都是男的,不扣钱
  226. //都是实名认证的女性,不扣钱
  227. //都是未实名认证的女性,不扣钱
  228. if($auth_level == $tous_level){
  229. $price = 0;$money = 0;
  230. }
  231. Db::startTrans();
  232. //记录日志
  233. $data = [
  234. 'user_id' => $this->auth->id,
  235. 'price' => $price,
  236. 'createtime' => time(),
  237. 'to_user_id' => $to_user_id,
  238. 'money' => $money,
  239. ];
  240. $log_id = Db::name('user_match_video_log')->insertGetId($data);
  241. if(!$log_id){
  242. Db::rollback();
  243. $this->error('扣费失败');
  244. }
  245. //同性别,提前结束
  246. if($auth_level == $tous_level){
  247. Db::commit();
  248. $this->success('success');
  249. }
  250. //扣钱uid,收钱uid,收钱free_video
  251. //分数少扣钱,分数多收益
  252. if($auth_level < $tous_level){
  253. $kou_user = $this->auth->id;
  254. $get_user = $to_user_info['id'];
  255. $get_user_free = $to_user_info['free_video'];
  256. }else{
  257. $kou_user = $to_user_info['id'];
  258. $get_user = $this->auth->id;
  259. $get_user_free = $this->auth->free_video;
  260. }
  261. //有性别差,扣费
  262. if($price > 0){
  263. $rs = model('wallet')->lockChangeAccountRemain($kou_user,'gold',-$price,11,'','user_match_video_log',$log_id);
  264. if($rs['status'] === false){
  265. Db::rollback();
  266. $this->error($rs['msg']);
  267. }
  268. }
  269. //另一方加钱,0收费
  270. if($money > 0 && $get_user_free == 0){
  271. $rs = model('wallet')->lockChangeAccountRemain($get_user,'money',$money,21,'','user_match_video_log',$log_id);
  272. if($rs['status'] === false){
  273. Db::rollback();
  274. $this->error($rs['msg']);
  275. }
  276. }
  277. Db::commit();
  278. $this->success('success');
  279. }
  280. //语音通话每分钟调用一次
  281. public function audio_onemin(){
  282. //检测用户
  283. $to_user_id = input_post('to_user_id');
  284. $to_user_info = Db::name('user')->field('id,real_status,gender,free_video,free_audio,free_typing')->where('id',$to_user_id)->find();
  285. if(!$to_user_info){
  286. $this->error('不存在的用户');
  287. }
  288. //正常价格
  289. $price = config('site.audio_min_price'); //扣费金币
  290. $bili = config('site.money_to_gold'); //兑换比例
  291. $gift_plat_scale = config('site.gift_plat_scale'); //抽成比例
  292. $money = bcdiv($price,$bili,2); //对应人民币
  293. $money = bcdiv(bcmul($money,100 - $gift_plat_scale,2),100,2); //抽成后收益
  294. //发起用户的分数,被发起用户的分数。按性别给分
  295. $auth_level = 0;
  296. $tous_level = 0;
  297. //打分
  298. if($this->auth->gender == 0 && $this->auth->real_status == 1){
  299. $auth_level = 30;//实名女最高
  300. }
  301. if($this->auth->gender == 0 && $this->auth->real_status != 1){
  302. $auth_level = 20;//未实名女次之
  303. }
  304. if($this->auth->gender == 1){
  305. $auth_level = 10;//男性最低
  306. }
  307. if($to_user_info['gender'] == 0 && $to_user_info['real_status'] == 1){
  308. $tous_level = 30;
  309. }
  310. if($to_user_info['gender'] == 0 && $to_user_info['real_status'] != 1){
  311. $tous_level = 20;
  312. }
  313. if($to_user_info['gender'] == 1){
  314. $tous_level = 10;
  315. }
  316. //同性不收钱
  317. //都是男的,不扣钱
  318. //都是实名认证的女性,不扣钱
  319. //都是未实名认证的女性,不扣钱
  320. if($auth_level == $tous_level){
  321. $price = 0;$money = 0;
  322. }
  323. Db::startTrans();
  324. //记录日志
  325. $data = [
  326. 'user_id' => $this->auth->id,
  327. 'price' => $price,
  328. 'createtime' => time(),
  329. 'to_user_id' => $to_user_id,
  330. 'money' => $money,
  331. ];
  332. $log_id = Db::name('user_match_audio_log')->insertGetId($data);
  333. if(!$log_id){
  334. Db::rollback();
  335. $this->error('扣费失败');
  336. }
  337. //同性别,提前结束
  338. if($auth_level == $tous_level){
  339. Db::commit();
  340. $this->success('success');
  341. }
  342. //扣钱uid,收钱uid,收钱free_video
  343. //分数少扣钱,分数多收益
  344. if($auth_level < $tous_level){
  345. $kou_user = $this->auth->id;
  346. $get_user = $to_user_info['id'];
  347. $get_user_free = $to_user_info['free_audio'];
  348. }else{
  349. $kou_user = $to_user_info['id'];
  350. $get_user = $this->auth->id;
  351. $get_user_free = $this->auth->free_audio;
  352. }
  353. //有性别差,扣费
  354. if($price > 0){
  355. $rs = model('wallet')->lockChangeAccountRemain($kou_user,'gold',-$price,12,'','user_match_audio_log',$log_id);
  356. if($rs['status'] === false){
  357. Db::rollback();
  358. $this->error($rs['msg']);
  359. }
  360. }
  361. //另一方加钱,0收费
  362. if($money > 0 && $get_user_free == 0){
  363. $rs = model('wallet')->lockChangeAccountRemain($get_user,'money',$money,22,'','user_match_audio_log',$log_id);
  364. if($rs['status'] === false){
  365. Db::rollback();
  366. $this->error($rs['msg']);
  367. }
  368. }
  369. Db::commit();
  370. $this->success('success');
  371. }
  372. //打字聊天每句话调用一次
  373. public function typing_once(){
  374. //检测用户
  375. $to_user_id = input_post('to_user_id');
  376. $to_user_info = Db::name('user')->field('id,real_status,gender,free_video,free_audio,free_typing')->where('id',$to_user_id)->find();
  377. if(!$to_user_info){
  378. $this->error('不存在的用户');
  379. }
  380. //正常价格
  381. $price = config('site.typing_min_price'); //扣费金币
  382. $bili = config('site.money_to_gold'); //兑换比例
  383. $gift_plat_scale = config('site.gift_plat_scale'); //抽成比例
  384. $money = bcdiv($price,$bili,2); //对应人民币
  385. $money = bcdiv(bcmul($money,100 - $gift_plat_scale,2),100,2); //抽成后收益
  386. //发起用户的分数,被发起用户的分数。按性别给分
  387. $auth_level = 0;
  388. $tous_level = 0;
  389. //打分
  390. if($this->auth->gender == 0 && $this->auth->real_status == 1){
  391. $auth_level = 30;//实名女最高
  392. }
  393. if($this->auth->gender == 0 && $this->auth->real_status != 1){
  394. $auth_level = 20;//未实名女次之
  395. }
  396. if($this->auth->gender == 1){
  397. $auth_level = 10;//男性最低
  398. }
  399. if($to_user_info['gender'] == 0 && $to_user_info['real_status'] == 1){
  400. $tous_level = 30;
  401. }
  402. if($to_user_info['gender'] == 0 && $to_user_info['real_status'] != 1){
  403. $tous_level = 20;
  404. }
  405. if($to_user_info['gender'] == 1){
  406. $tous_level = 10;
  407. }
  408. //同性不收钱
  409. //都是男的,不扣钱
  410. //都是实名认证的女性,不扣钱
  411. //都是未实名认证的女性,不扣钱
  412. if($auth_level == $tous_level){
  413. $price = 0;$money = 0;
  414. }
  415. //特殊处理
  416. //实名女发起,其他性别接收,不扣钱
  417. if($this->auth->gender == 0 && $this->auth->real_status == 1){
  418. $price = 0;$money = 0;
  419. }
  420. Db::startTrans();
  421. //记录日志
  422. $data = [
  423. 'user_id' => $this->auth->id,
  424. 'price' => $price,
  425. 'createtime' => time(),
  426. 'to_user_id' => $to_user_id,
  427. 'money' => $money,
  428. ];
  429. $log_id = Db::name('user_match_typing_log')->insertGetId($data);
  430. if(!$log_id){
  431. Db::rollback();
  432. $this->error('扣费失败');
  433. }
  434. //同性别,提前结束
  435. if($auth_level == $tous_level){
  436. Db::commit();
  437. $this->success('success');
  438. }
  439. //零消费,零收益消费,提前结束,其实这条没必要,下面金钱操作还会过滤一次
  440. if($price == 0 && $money == 0){
  441. Db::commit();
  442. $this->success('success');
  443. }
  444. //扣钱uid,收钱uid,收钱free_video
  445. //分数少扣钱,分数多收益
  446. if($auth_level < $tous_level){
  447. $kou_user = $this->auth->id;
  448. $get_user = $to_user_info['id'];
  449. $get_user_free = $to_user_info['free_typing'];
  450. }else{
  451. $kou_user = $to_user_info['id'];
  452. $get_user = $this->auth->id;
  453. $get_user_free = $this->auth->free_typing;
  454. }
  455. //有性别差,扣费
  456. if($price > 0){
  457. $rs = model('wallet')->lockChangeAccountRemain($kou_user,'gold',-$price,13,'','user_match_typing_log',$log_id);
  458. if($rs['status'] === false){
  459. Db::rollback();
  460. $this->error($rs['msg']);
  461. }
  462. }
  463. //另一方加钱,0收费
  464. if($money > 0 && $get_user_free == 0){
  465. $rs = model('wallet')->lockChangeAccountRemain($get_user,'money',$money,23,'','user_match_typing_log',$log_id);
  466. if($rs['status'] === false){
  467. Db::rollback();
  468. $this->error($rs['msg']);
  469. }
  470. }
  471. //tag任务赠送金币
  472. //搭讪奖励
  473. $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,15);
  474. if($task_rs === false){
  475. Db::rollback();
  476. $this->error('完成任务赠送奖励失败');
  477. }
  478. Db::commit();
  479. $this->success('success');
  480. }
  481. //语音匹配
  482. public function getaudiouser(){
  483. //判断资格
  484. $start = strtotime(date('Y-m-d'));
  485. $end = $start + 86399;
  486. $map = [
  487. 'user_id' => $this->auth->id,
  488. 'createtime' => ['between',[$start,$end]],
  489. 'price' => 0,
  490. ];
  491. $check = Db::name('user_match_audio_log')->where($map)->find();
  492. //$check = true;
  493. //已经用掉免费的了,判断金额
  494. if($check){
  495. $price = config('site.audio_min_price');
  496. $gold = model('wallet')->getWallet($this->auth->id,'gold');
  497. if($gold < $price){
  498. $this->error('您的金币已经不足,请充值');
  499. }
  500. }
  501. //找到互关的人,排除
  502. $follow_me = Db::name('user_follow')->where('follow_uid',$this->auth->id)->column('uid');
  503. //dump($follow_me);
  504. $my_follow = Db::name('user_follow')->where(['uid'=>$this->auth->id,'follow_uid'=>['IN',$follow_me]])->column('follow_uid');
  505. //dump($my_follow);exit;
  506. //给出备选用户
  507. $map = [
  508. 'status' =>1, //未封禁用户
  509. 'gender' => $this->auth->gender == 1 ? 0 : 1, //异性
  510. 'is_online' => 0, //不在语聊间的
  511. 'is_livebc' => 0, //不在直播的
  512. 'real_status' => 1, //真人认证
  513. 'idcard_status' => 1, //实名认证
  514. 'open_match_audio' => 1, //打开语聊开关
  515. 'id' => ['NOT IN',$my_follow] //不是好友的
  516. ];
  517. $lists = Db::name('user')->field('id,cityname,status,gender,real_status,tag_ids')->where($map)->order('logintime desc')->page($this->page,100)->select();
  518. $lists = $this->fliter_user($lists,10);
  519. $result = [];
  520. if(!empty($lists)){
  521. foreach($lists as $key => $val){
  522. $result[] = ['id'=>$val];
  523. }
  524. }
  525. //tag任务赠送金币
  526. //语音匹配奖励 +5金币
  527. if(!empty($result)){
  528. $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,11);
  529. if($task_rs === false){
  530. $this->error('完成任务赠送奖励失败');
  531. }
  532. }
  533. $this->success('success',$result);
  534. }
  535. //视频匹配
  536. public function getvideouser(){
  537. //判断资格
  538. $start = strtotime(date('Y-m-d'));
  539. $end = $start + 86399;
  540. $map = [
  541. 'user_id' => $this->auth->id,
  542. 'createtime' => ['between',[$start,$end]],
  543. 'price' => 0,
  544. ];
  545. $check = Db::name('user_match_video_log')->where($map)->find();
  546. //$check = true;
  547. //已经用掉免费的了,判断金额
  548. if($check){
  549. $price = config('site.video_min_price');
  550. $gold = model('wallet')->getWallet($this->auth->id,'gold');
  551. if($gold < $price){
  552. $this->error('您的金币已经不足,请充值');
  553. }
  554. }
  555. //找到互关的人,排除
  556. $follow_me = Db::name('user_follow')->where('follow_uid',$this->auth->id)->column('uid');
  557. //dump($follow_me);
  558. $my_follow = Db::name('user_follow')->where(['uid'=>$this->auth->id,'follow_uid'=>['IN',$follow_me]])->column('follow_uid');
  559. //dump($my_follow);exit;
  560. //给出备选用户
  561. $map = [
  562. 'status' =>1, //未封禁用户
  563. 'gender' => $this->auth->gender == 1 ? 0 : 1, //异性
  564. 'is_online' => 0, //不在语聊间的
  565. 'is_livebc' => 0, //不在直播的
  566. 'real_status' => 1, //真人认证
  567. 'idcard_status' => 1, //实名认证
  568. 'open_match_video' => 1, //打开视频开关的
  569. 'id' => ['NOT IN',$my_follow] //不是好友的
  570. ];
  571. $lists = Db::name('user')->field('id,cityname,status,gender,real_status,tag_ids')->where($map)->order('logintime desc')->page($this->page,100)->select();
  572. $lists = $this->fliter_user($lists,10);
  573. $result = [];
  574. if(!empty($lists)){
  575. foreach($lists as $key => $val){
  576. $result[] = ['id'=>$val];
  577. }
  578. }
  579. //tag任务赠送金币
  580. //视频匹配奖励 +5金币
  581. if(!empty($result)){
  582. $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,12);
  583. if($task_rs === false){
  584. $this->error('完成任务赠送奖励失败');
  585. }
  586. }
  587. $this->success('success',$result);
  588. }
  589. //聊天匹配
  590. public function gettypinguser(){
  591. //找到互关的人,排除
  592. $follow_me = Db::name('user_follow')->where('follow_uid',$this->auth->id)->column('uid');
  593. //dump($follow_me);
  594. $my_follow = Db::name('user_follow')->where(['uid'=>$this->auth->id,'follow_uid'=>['IN',$follow_me]])->column('follow_uid');
  595. //dump($my_follow);exit;
  596. //给出备选用户
  597. $map = [
  598. 'status' =>1, //未封禁用户
  599. 'gender' => $this->auth->gender == 1 ? 0 : 1, //异性
  600. //'real_status' => 1, //真人认证
  601. //'idcard_status' => 1, //实名认证
  602. //打开聊天开关的
  603. 'open_match_typing' => 1, //打开文字聊天开关的
  604. 'id' => ['NOT IN',$my_follow] //不是好友的
  605. ];
  606. $lists = Db::name('user')->field('id,cityname,status,gender,real_status,tag_ids')->where($map)->order('logintime desc')->page($this->page,100)->select();
  607. //$lists = $this->fliter_user($lists,100);
  608. $lists = array_column($lists,'id');
  609. $result = [];
  610. if(!empty($lists)){
  611. /*foreach($lists as $key => $val){
  612. $result[] = ['id'=>$val];
  613. }*/
  614. $result = Db::name('user')->field('id,nickname,username,avatar,audio_bio')->where(['id'=>['IN',$lists]])->select();
  615. $result = list_domain_image($result,['avatar,audio_bio']);
  616. }
  617. //tag任务赠送金币
  618. //缘分匹配奖励 +5金币
  619. if(!empty($result)){
  620. $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,10);
  621. if($task_rs === false){
  622. $this->error('完成任务赠送奖励失败');
  623. }
  624. }
  625. $this->success('success',$result);
  626. }
  627. //过滤规则
  628. private function fliter_user($lists,$number = 1){
  629. if(empty($lists)){
  630. return $lists;
  631. }
  632. //dump($lists);
  633. //过滤掉通话中的
  634. foreach($lists as $key => $val){
  635. if(redis_matching_get($val['id']) == 1){
  636. unset($lists[$key]);
  637. }
  638. }
  639. //预留全部
  640. $all_result = array_column($lists,'id');
  641. //dump($all_result);
  642. //提取同城的
  643. $citydata = [];
  644. foreach($lists as $key => $val){
  645. if( !empty($this->auth->cityname) && $this->auth->cityname == $val['cityname'] ){
  646. $citydata[] = $val['id'];
  647. }
  648. }
  649. //dump($citydata);
  650. //有标签交集的
  651. $tagdata = [];
  652. foreach($lists as $key => $val){
  653. if( !empty($this->auth->tag_ids) && !empty($val['tag_ids']) ){
  654. $auth_tag_ids = explode(',',$this->auth->tag_ids);
  655. $val_tag_ids = explode(',',$val['tag_ids']);
  656. if(count(array_intersect($auth_tag_ids,$val_tag_ids)) > 0){
  657. $tagdata[] = $val['id'];
  658. }
  659. }
  660. }
  661. //dump($tagdata);
  662. //双条件都满足
  663. $double_data = [];
  664. if(!empty($citydata) && !empty($tagdata)){
  665. $double_data = array_intersect($citydata,$tagdata);
  666. }
  667. //dump($double_data);
  668. if(count($double_data) >= $number){
  669. return $double_data;
  670. }
  671. //两种条件合并,去重。空数组合并没影响
  672. $merge_data = array_merge($citydata,$tagdata);
  673. $merge_data = array_flip(array_flip($merge_data));
  674. //dump($merge_data);
  675. if(count($merge_data) >= $number){
  676. return $merge_data;
  677. }
  678. return $all_result;
  679. }
  680. /**
  681. * 是否关注
  682. */
  683. public function isFollows() {
  684. $user_id = $this->request->request("user_id",0,"intval");
  685. if (!$user_id || $user_id<=0) {
  686. $this->error(__('Invalid parameters'));
  687. }
  688. $map = [
  689. 'uid' => $this->auth->id,
  690. 'follow_uid' => $user_id,
  691. ];
  692. $check = Db::name('user_follow')->where($map)->find();
  693. $data = [];
  694. if($check){
  695. $data["is_show_follow"] = 0;
  696. }else{
  697. $data["is_show_follow"] = 1;
  698. }
  699. $this->success("获取成功!",$data);
  700. }
  701. /**
  702. * 获取主播技能分类
  703. */
  704. public function getAnchorType() {
  705. $this->success("获取成功!",\app\common\model\UserAnchorType::select());
  706. }
  707. /**
  708. * 主播申请
  709. */
  710. public function anchorApply() {
  711. $this->error('不需要申请');
  712. /*$type_id = $this->request->request('type_id'); // 技能分类ID
  713. $desc = $this->request->request('desc'); // 申请备注
  714. if (!$type_id && !$desc) {
  715. $this->error(__('Invalid parameters'));
  716. }
  717. $useranchorModel = new \app\common\model\UserAnchor();
  718. $data = [];
  719. $data["user_id"] = $this->auth->id;
  720. $data["type_id"] = $type_id;
  721. if($useranchorModel->where($data)->find()) $this->error(__('您已申请过该类型的主播,请勿重复申请!'));
  722. $data["desc"] = $desc;
  723. $data["createtime"] = time();
  724. $res = $useranchorModel->insertGetId($data);
  725. if($res) {
  726. \app\common\model\User::update(["is_anchor"=>1],["id"=>$this->auth->id]);
  727. $this->success("申请发送成功!");
  728. } else {
  729. $this->error("网络错误,请稍后重试");
  730. }*/
  731. }
  732. /**
  733. * 获取当前用户信息
  734. */
  735. public function getMyUserInfo() {
  736. $userInfo = $this->auth->getUserinfo();
  737. //当月消费金额
  738. $redis = new Redis();
  739. $redisconfig = config("redis");
  740. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  741. $user_renew2 = $redis->get('user_renew2_'.$this->auth->id);
  742. $userInfo['user_renew2'] = empty($user_renew2)?0:intval($user_renew2);
  743. $this->success("获取成功!",$userInfo);
  744. }
  745. /**
  746. * calc_map_distance() , 根据地图上的两个点各自的x,y坐标,计算出2点之间的直线距离
  747. * @param array $point_1 第1个点的x,y坐标 array( 101 , 202 )
  748. * @param array $point_2 第2个点的x,y坐标 array( 101 , 202 )
  749. * @param bool $calc_as_string 是否计算为字符串公里距离 , 如果未否返回数字
  750. * @return float | false | string
  751. */
  752. private function calc_map_distance( $point_1=array( ) , $point_2=array( ) , $calc_as_string=false ) {
  753. if( empty( $point_1 ) || empty( $point_2 ) ){
  754. return false;
  755. }
  756. // 经纬度不存在,或者经纬度超过最大范围 +-180 , +-90 ,返回false
  757. $p1_x = $point_1[0];
  758. $p1_y = $point_1[1];
  759. $p2_x = $point_2[0];
  760. $p2_y = $point_2[1];
  761. if(
  762. $p1_x < -180 || $p1_x > 180
  763. || $p2_x < -180 || $p2_x > 180
  764. || $p1_y < -90 || $p1_y > 90
  765. || $p2_y < -90 || $p2_y > 90
  766. ){
  767. return '0公里';
  768. }
  769. // 根据2点各自的坐标,计算2点之间直线距离的公式
  770. $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);
  771. // 是否计算为字符串公里距离
  772. if( !$calc_as_string ){
  773. return (string)round( $distance / 1000 , 1 ) . '公里';
  774. }
  775. // 如果计算为字符串公里距离
  776. if( $distance / 1000 > 1 ){
  777. $k = (string)round( $distance / 1000 , 1 );
  778. $m = (string)$distance % 1000 ;
  779. $distance = "{$k}公里{$m}米";
  780. }
  781. else{
  782. $distance = "{$distance}米";
  783. }
  784. return $distance;
  785. }
  786. //地图api,根据两地坐标,获得两地距离,打卡用的
  787. //type=0直线,type=1开车
  788. private function getmapjuli($start_lon,$start_lat,$end_lon,$end_lat,$type = 0){
  789. $result = 0;
  790. $apiurl = 'https://restapi.amap.com/v3/distance?';
  791. $param = [
  792. 'key' => '398c424811d1a59beac2f915323d334e',
  793. 'origins' => $start_lon.','.$start_lat,
  794. 'destination' => $end_lon.','.$end_lat,
  795. 'type' => $type,
  796. 'output' => 'json',
  797. ];
  798. $apiurl .= http_build_query($param);
  799. $request_rs = json_decode(curl_get($apiurl),true);
  800. if(isset($request_rs['status']) && $request_rs['status'] == 1){
  801. if(isset($request_rs['results'][0]['distance']))
  802. {
  803. $result = $request_rs['results'][0]['distance'];
  804. }
  805. }
  806. //dump($result);
  807. return $result;
  808. }
  809. public function distance()
  810. {
  811. $a = $this->calc_map_distance([118.339282,35.028445],[118.437399,35.017438]);
  812. dump($a);
  813. $a = $this->calc_map_distance([118.339282,35.028445],[118.437399,35.017438],true);
  814. dump($a);
  815. $b = $this->getmapjuli(118.339282,35.028445,118.437399,35.017438,1);
  816. dump($b);
  817. $b = $this->getmapjuli(118.339282,35.028445,118.437399,35.017438,0);
  818. dump($b);
  819. }
  820. }