Usercenter.php 54 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use think\Cache;
  5. use think\Db;
  6. /**
  7. * 会员中心,不是个人中心
  8. */
  9. class Usercenter extends Api
  10. {
  11. protected $noNeedLogin = ['test','testredis'];
  12. protected $noNeedRight = '*';
  13. protected $allowFields = [
  14. 'id',
  15. 'username',
  16. 'nickname',
  17. 'email',
  18. 'mobile',
  19. 'avatar',
  20. 'real_status',
  21. 'gender',
  22. 'height',
  23. 'weight',
  24. 'birthday',
  25. 'bio',
  26. 'audio_bio',
  27. 'idcard_status',
  28. 'is_active',
  29. 'longitude',
  30. 'latitude',
  31. 'cityname',
  32. 'photo_images',
  33. 'education',
  34. 'hobby',
  35. 'job',
  36. 'marital',
  37. 'tag',
  38. 'wages',
  39. 'hometown_cityid',
  40. 'character',
  41. 'constellation',
  42. 'stature',
  43. 'is_appointment',
  44. 'chat_price',
  45. 'voice_price',
  46. 'video_price',
  47. 'greet_voice',
  48. 'greet_chat',
  49. 'is_kefu',
  50. 'is_hideaddress',
  51. 'is_recommend','is_cohabit', 'live', 'is_house', 'car', 'chest', 'waist',
  52. 'suqiu'
  53. ];
  54. //获取他人用户信息,留下足迹
  55. public function getuserinfo(){
  56. $uid = input_post('uid',0);
  57. $userinfo = Db::name('user')->field($this->allowFields)->where('id',$uid)->find();
  58. if(!$userinfo){
  59. $this->error('不存在的用户');
  60. }
  61. if($uid != $this->auth->id){
  62. $user_remark = Db::name('user_remark')->where('to_user_id',$uid)->where('user_id',$this->auth->id)->find();
  63. $info['nickname'] = !empty($user_remark['nickname_remark']) ? $user_remark['nickname_remark'] : $info['nickname'];
  64. }
  65. //用户数据
  66. $userinfo = info_domain_image($userinfo,['avatar','photo_images']);
  67. $new_data = [
  68. 'age' => birthtime_to_age($userinfo['birthday']),
  69. ];
  70. if ($this->auth->gender == 1) {
  71. $qinmi_sum = Db::name('user_intimacy')->where(['uid' => $this->auth->id, 'other_uid' => $uid])->value('value');
  72. } elseif ($this->auth->gender == 0) {
  73. $qinmi_sum = Db::name('user_intimacy')->where(['uid' => $uid, 'other_uid' => $this->auth->id])->value('value');
  74. } else {
  75. $qinmi_sum = 0;
  76. }
  77. $new_data['qinmi_sum'] = $qinmi_sum ? :0;
  78. //合并
  79. $userinfo = array_merge($userinfo,$new_data);
  80. //枚举
  81. //家乡
  82. $userinfo['hometown_city'] = Db::name('area')->where('id',$userinfo['hometown_cityid'])->value('name');
  83. $userinfo['hometown_city'] = ($userinfo['hometown_city'] && $userinfo['is_hideaddress'] == 0) ? $userinfo['hometown_city'] : '';
  84. //vip
  85. $userwallet = Db::name('user_wallet')->where('user_id',$uid)->find();
  86. $userinfo['is_vip'] = $this->is_vip($userwallet['vip_endtime'],$userwallet['vip_level']);
  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'=>$uid])->count('id');
  97. $fans_num = Db::name('user_follow')->where(['follow_uid'=>$uid])->count('id');
  98. $userinfo['follow_num'] = $follow_num;
  99. $userinfo['fans_num'] = $fans_num;
  100. //访客数
  101. $visit_num = Db::name('user_visit')->where(['to_uid'=>$uid])->count('id');
  102. $userinfo['visit_num'] = $visit_num;
  103. //查询是否打过招呼
  104. $count = Db::name('user_greet')->where(['user_id' => $this->auth->id, 'user_to_id' => $uid])->count('id');
  105. if ($count) {
  106. $userinfo['is_chat'] = 1; //是否打过招呼: 1是 0否
  107. } else {
  108. $userinfo['is_chat'] = 0; //是否打过招呼: 1是 0否
  109. }
  110. //守护数量和是否已经守护
  111. $userinfo['guard_num'] = Db::name('user_guard')->where(['user_to_id' => $uid])->count('id');
  112. $userinfo['is_guard'] = Db::name('user_guard')->where(['user_id' => $this->auth->id, 'user_to_id' => $uid])->count('id');
  113. //查询财富等级和魅力等级
  114. $wallet_info = Db::name('user_wallet')->where(['user_id' => $uid])->find();
  115. $wealth_level = Db::name('wealth_level')->where(['value' => ['elt', $wallet_info['pay_money']]])->order('id desc')->find();
  116. if ($wealth_level) {
  117. $userinfo['wealth_level'] = localpath_to_netpath($wealth_level['image']);
  118. } else {
  119. $userinfo['wealth_level'] = '';
  120. }
  121. $charm_level = Db::name('charm_level')->where(['value' => ['elt', $wallet_info['get_money']]])->order('id desc')->find();
  122. if ($charm_level) {
  123. $userinfo['charm_level'] = localpath_to_netpath($charm_level['image']);
  124. } else {
  125. $userinfo['charm_level'] = '';
  126. }
  127. //开通守护消耗金币数量
  128. $userinfo['guard_price'] = config('site.guard_price') ? : 0;
  129. //男性非会员是否已开通聊天
  130. // $vip_endtime = Db::name('user_wallet')->where('user_id',$this->auth->id)->value('vip_endtime');
  131. // $user_chat_unlock = Db::name('user_chat_unlock')->where(['user_id' => $this->auth->id, 'user_to_id' => $uid])->count('id');
  132. // if ($this->auth->gender == 0 || $vip_endtime > time() || $user_chat_unlock) {
  133. $userinfo['is_chat_unlock'] = 1; //已解锁
  134. // } else {
  135. // $userinfo['is_chat_unlock'] = 0;
  136. // }
  137. //男性非会员解锁聊天所需金币数量
  138. $userinfo['unlock_chat_gold'] = config('site.unlock_chat_gold') > 0 ? config('site.unlock_chat_gold') : 10;
  139. //动态信息
  140. $dongtai = Db::name('topic_dongtai')->field('type, images')->where(['user_id' => $uid, 'is_hidden' => 0, 'type' => ['in', [1, 2]], 'status' => 0, 'auit_status' => 1])->order('id desc')->limit(3)->select();
  141. if ($dongtai) {
  142. $dongtai_image = [];
  143. foreach ($dongtai as &$v) {
  144. $arr['type'] = $v['type'];
  145. if ($v['type'] == 1) {
  146. //图片
  147. $images_url = explode(',', $v['images']);
  148. foreach ($images_url as &$value) {
  149. $arr['images'] = one_domain_image($value);
  150. array_push($dongtai_image, $arr);
  151. if (count($dongtai_image) == 4) {
  152. break 2;
  153. }
  154. }
  155. } else {
  156. //视频
  157. $images_url = explode('.', $v['images']);
  158. unset($images_url[count($images_url) - 1]);
  159. $arr['images'] = join('.', $images_url) . '_0.jpg';
  160. $arr['images'] = one_domain_image($arr['images']);
  161. array_push($dongtai_image, $arr);
  162. if (count($dongtai_image) == 4) {
  163. break;
  164. }
  165. }
  166. }
  167. $userinfo['dongtai_image'] = $dongtai_image;
  168. // $dongtai = join(',', $dongtai);
  169. // $dongtai = explode(',', $dongtai);
  170. // $dongtai = array_slice($dongtai, 0, 3);
  171. // $dongtai = join(',', $dongtai);
  172. // $userinfo['dongtai_image'] = one_domain_image($dongtai);
  173. // $userinfo['dongtai_image'] = explode(',', $userinfo['dongtai_image']);
  174. } else {
  175. $userinfo['dongtai_image'] = [];
  176. }
  177. if ($this->auth->id != $uid) {
  178. //查看别人信息,就要留下痕迹
  179. $data = [
  180. 'uid' => $this->auth->id,
  181. 'to_uid' => $uid,
  182. ];
  183. $check = Db::name('user_visit')->where($data)->find();
  184. if ($check) {
  185. Db::name('user_visit')->where($data)->update(['number' => $check['number'] + 1, 'updatetime' => time()]);
  186. } else {
  187. $data['number'] = 1;
  188. $data['updatetime'] = time();
  189. Db::name('user_visit')->insertGetId($data);
  190. }
  191. }
  192. //礼物墙
  193. $userinfo['gift_wall'] = $this->giftwall($uid);
  194. //动态数量
  195. $userinfo['dongtai_num'] = Db::name('topic_dongtai')->where(['user_id' => $uid, 'is_hidden' => 0, 'type' => ['in', [1, 2]], 'status' => 0, 'auit_status' => 1])->count();
  196. $this->success('success',$userinfo);
  197. }
  198. //某用户的礼物墙
  199. private function giftwall($uid){
  200. //$uid = $this->auth->id;
  201. //聊天礼物
  202. $gift_user_typing = Db::name('gift_user_typing')->alias('log')
  203. ->join('gift', 'gift.id = log.gift_id', 'LEFT')
  204. ->field('log.gift_id,log.gift_name,sum(log.number) as number,gift.image')
  205. ->where(['log.user_to_id' => $uid])
  206. ->group('log.gift_id')
  207. ->order('gift.price desc')
  208. ->column('log.gift_id,log.gift_name,sum(log.number) as number,gift.image');
  209. $gift_user_typing = list_domain_image($gift_user_typing,['image']);
  210. //dump($gift_user_typing);
  211. //动态礼物
  212. $gift_user_dongtai = Db::name('gift_user_dongtai')->alias('log')
  213. ->join('gift', 'gift.id = log.gift_id', 'LEFT')
  214. ->field('log.gift_id,log.gift_name,sum(log.number) as number,gift.image')
  215. ->where(['log.user_to_id' => $uid])
  216. ->group('log.gift_id')
  217. ->order('gift.price desc')
  218. ->column('log.gift_id,log.gift_name,sum(log.number) as number,gift.image');
  219. $gift_user_dongtai = list_domain_image($gift_user_dongtai,['image']);
  220. //dump($gift_user_dongtai);
  221. //为空
  222. if(empty($gift_user_typing) && empty($gift_user_dongtai)){
  223. return [];
  224. }
  225. if(empty($gift_user_typing) && !empty($gift_user_dongtai)){
  226. foreach($gift_user_dongtai as $key => $val){
  227. $result[] = $val;
  228. }
  229. return $result;
  230. }
  231. if(!empty($gift_user_typing) && empty($gift_user_dongtai)){
  232. foreach($gift_user_typing as $key => $val){
  233. $result[] = $val;
  234. }
  235. return $result;
  236. }
  237. //合并
  238. foreach($gift_user_typing as $key => $val){
  239. foreach($gift_user_dongtai as $k => $v){
  240. if($key == $k){
  241. $gift_user_typing[$key]['number'] += $v['number'];
  242. }
  243. if(!isset($gift_user_typing[$k])){
  244. $gift_user_typing[$k] = $v;
  245. }
  246. }
  247. }
  248. //dump($gift_user_typing);
  249. //结果
  250. $result = [];
  251. foreach($gift_user_typing as $key => $val){
  252. $result[] = $val;
  253. }
  254. return $result;
  255. }
  256. //开通守护
  257. public function addguard() {
  258. // 接口防并发
  259. if (!$this->apiLimit(1, 1)) {
  260. $this->error(__('Operation frequently'));
  261. }
  262. $user_id = input('user_id', 0, 'intval');// 守护对象
  263. if (!$user_id) {
  264. $this->error();
  265. }
  266. // 不可以守护给自己
  267. if($this->auth->id == $user_id) {
  268. $this->error("不可以守护自己");
  269. }
  270. //查询是否开通守护
  271. $count = Db::name('user_guard')->where(['user_id' => $this->auth->id, 'user_to_id' => $user_id])->count('id');
  272. if ($count) {
  273. $this->error('已经开通守护了');
  274. }
  275. $giftvalue = config('site.guard_price');
  276. if ($giftvalue <= 0) {
  277. $this->error('守护金额异常~');
  278. }
  279. //被守护人信息
  280. $touserinfo = Db::name('user')->where('id',$user_id)->find();
  281. if (!$touserinfo) {
  282. $this->error("不存在的用户");
  283. }
  284. // 判断当前用户余额
  285. $user_gold = model('wallet')->getWallet($this->auth->id,'gold');
  286. if($user_gold < $giftvalue) {
  287. $this->error("您的金币不足");
  288. }
  289. Db::startTrans();
  290. // 添加礼物守护记录表
  291. $data = [
  292. 'user_id' => $this->auth->id,
  293. 'user_to_id' => $user_id,
  294. 'price' => $giftvalue,
  295. 'createtime' => time(),
  296. ];
  297. $log_id = Db::name('user_guard')->insertGetId($data);
  298. if(!$log_id){
  299. Db::rollback();
  300. $this->error('守护失败');
  301. }
  302. if($giftvalue > 0){
  303. // 扣除当前用户余额
  304. $wallet_rs = model('wallet')->lockChangeAccountRemain($this->auth->id,$user_id,'gold',-$giftvalue,81,'开通守护','user_guard',$log_id);
  305. if($wallet_rs['status'] === false){
  306. Db::rollback();
  307. $this->error($wallet_rs['msg']);
  308. }
  309. // 添加守护用户余额
  310. $money_to_gold = config('site.money_to_gold');
  311. $gift_plat_scale = config('site.gift_plat_scale');
  312. $giftmoney = bcdiv($giftvalue,$money_to_gold,2);
  313. $money = bcdiv(bcmul($giftmoney,100 - $gift_plat_scale,2),100,2);
  314. $wallet_rs = model('wallet')->lockChangeAccountRemain($user_id,$this->auth->id,'money',$money,82,'被守护收益','user_guard',$log_id,2);
  315. if($wallet_rs['status'] === false){
  316. Db::rollback();
  317. $this->error($wallet_rs['msg']);
  318. }
  319. //增加赠送用户上级余额
  320. if ($touserinfo['intro_uid']) {
  321. //获取返利比率
  322. $agent_info = Db::name('user')->where(['id' => $touserinfo['intro_uid']])->field('is_agent,h_intro_income_rebate_rate')->find();
  323. $intro_income_rebate_rate = ($agent_info['is_agent'] == 1) ? $agent_info['h_intro_income_rebate_rate'] : (int)config('site.intro_income_rebate_rate'); //邀请人收礼物返利比率
  324. if ($intro_income_rebate_rate > 0 && $intro_income_rebate_rate <= 100) {
  325. //上级获得金额
  326. $intro_uid_money = bcdiv(bcmul($money,$intro_income_rebate_rate,2),100,2);
  327. if ($intro_uid_money > 0) {
  328. $intro_result = model('Wallet')->lockChangeAccountRemain($touserinfo['intro_uid'],$user_id,'money',$intro_uid_money,68, '邀请人开通守护获赠奖励','user_guard',$log_id);
  329. if($intro_result['status']===false)
  330. {
  331. Db::rollback();
  332. $this->error($intro_result['msg']);
  333. }
  334. }
  335. }
  336. }
  337. }
  338. //tag任务守护金币
  339. //搭讪奖励
  340. // $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,15);
  341. // if($task_rs === false){
  342. // Db::rollback();
  343. // $this->error('完成任务守护奖励失败');
  344. // }
  345. Db::commit();
  346. $this->success('守护成功');
  347. }
  348. //守护列表
  349. public function guardlist(){
  350. $user_id = input('user_id', 0, 'intval');
  351. if (!$user_id) {
  352. $this->error('您的网络开小差啦~');
  353. }
  354. $list = Db::name('user_guard')
  355. ->alias('a')
  356. ->join('user','a.user_id = user.id','LEFT')
  357. ->join('user_remark ur', 'ur.to_user_id = user.id and ur.user_id = '.$this->auth->id, 'LEFT')
  358. ->field('a.createtime,user.id,user.nickname,user.avatar,user.real_status,ur.nickname_remark')
  359. ->where('a.user_to_id',$user_id)->order('a.id desc')->autopage()->select();
  360. if (!$list) {
  361. $this->success('success', $list);
  362. }
  363. $list = list_domain_image($list,['avatar']);
  364. $time = time();
  365. foreach ($list as &$val) {
  366. $val['createtime'] = ceil(($time - $val['createtime']) / 86400);
  367. $val['nickname'] = !empty($val['nickname_remark']) ? $val['nickname_remark'] : $val['nickname'];
  368. }
  369. $this->success('success',$list);
  370. }
  371. //我的守护
  372. public function myguardlist(){
  373. $type = input('type', 0, 'intval'); //类型: 1我守护的 2守护我的
  374. if (!in_array($type, [1, 2])) {
  375. $this->error('您的网络开小差了');
  376. }
  377. $where = [];
  378. if ($type == 1) {
  379. $join = 'a.user_to_id = user.id';
  380. $where['a.user_id'] = $this->auth->id;
  381. } else {
  382. $join = 'a.user_id = user.id';
  383. $where['a.user_to_id'] = $this->auth->id;
  384. }
  385. $list = Db::name('user_guard')
  386. ->alias('a')
  387. ->join('user',$join,'LEFT')
  388. ->join('user_remark ur', 'ur.to_user_id = user.id and ur.user_id = '.$this->auth->id, 'LEFT')
  389. ->field('a.createtime,user.id,user.nickname,user.avatar,user.real_status,ur.nickname_remark')
  390. ->where($where)->order('a.id desc')->autopage()->select();
  391. if (!$list) {
  392. $this->success('success', $list);
  393. }
  394. $list = list_domain_image($list,['avatar']);
  395. $time = time();
  396. foreach ($list as &$val) {
  397. $val['createtime'] = ceil(($time - $val['createtime']) / 86400);
  398. $val['nickname'] = !empty($val['nickname_remark']) ? $val['nickname_remark'] : $val['nickname'];
  399. }
  400. $this->success('success',$list);
  401. }
  402. //打字聊天每句话调用一次
  403. public function chat_once(){
  404. if ($this->auth->is_kefu == 1) { //我是客服或者对方是客服
  405. $this->success('success',['money' => 'free']);
  406. }
  407. if ($this->auth->gender == 0) { //女生不花钱
  408. $this->error('您的网络开小差啦~');
  409. }
  410. //检测用户
  411. $to_user_id = input_post('to_user_id');
  412. $to_user_info = Db::name('user')->field('id,intro_uid,real_status,gender,free_video,free_audio,free_typing,chat_price,is_kefu')->where('id',$to_user_id)->find();
  413. if(!$to_user_info){
  414. $this->error('不存在的用户');
  415. }
  416. if ($to_user_info['is_kefu'] == 1) { //我是客服或者对方是客服
  417. $this->success('success',['money' => 'free']);
  418. }
  419. if ($to_user_info['gender'] != 0) {
  420. $this->error('同性不能聊天~');
  421. }
  422. //验证金额
  423. $wallet_info = Db::name('user_wallet')->where('user_id',$this->auth->id)->find();
  424. $is_vip = $this->is_vip($wallet_info['vip_endtime'],$wallet_info['vip_level']);
  425. if ($is_vip) { //会员
  426. $price = $to_user_info['chat_price'];//config('site.typing_min_price'); //扣费金币
  427. //获取折扣
  428. $vip_chat_discount = config('site.vip_chat_discount');
  429. if ($vip_chat_discount >= 0 && $vip_chat_discount <= 10) {
  430. $price = bcdiv(bcmul($price,$vip_chat_discount,2),10,0);
  431. }
  432. } else {
  433. $price = $to_user_info['chat_price'];//config('site.typing_min_price'); //扣费金币
  434. }
  435. //正常价格
  436. $bili = config('site.money_to_gold'); //兑换比例
  437. $gift_plat_scale = config('site.gift_plat_scale'); //抽成比例
  438. $money = bcdiv($price,$bili,2); //对应人民币
  439. $money = bcdiv(bcmul($money,100 - $gift_plat_scale,2),100,2); //抽成后收益
  440. $resArray['money'] = $money; //返回给前端的计算结果
  441. Db::startTrans();
  442. //记录日志
  443. $data = [
  444. 'user_id' => $this->auth->id,
  445. 'price' => $price,
  446. 'createtime' => time(),
  447. 'to_user_id' => $to_user_id,
  448. 'money' => $money,
  449. ];
  450. $log_id = Db::name('user_match_typing_log')->insertGetId($data);
  451. if(!$log_id){
  452. Db::rollback();
  453. $this->error('扣费失败');
  454. }
  455. //有性别差,扣费
  456. if($price > 0){
  457. $rs = model('wallet')->lockChangeAccountRemain($this->auth->id,$to_user_id,'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){
  465. $rs = model('wallet')->lockChangeAccountRemain($to_user_id,$this->auth->id,'money',$money,23,'文字聊天收益','user_match_typing_log',$log_id,2);
  466. if($rs['status'] === false){
  467. Db::rollback();
  468. $this->error($rs['msg']);
  469. }
  470. $touserinfo = $to_user_info;
  471. //增加赠送用户上级余额
  472. if ($touserinfo['intro_uid']) {
  473. //获取返利比率
  474. $agent_info = Db::name('user')->where(['id' => $touserinfo['intro_uid']])->field('is_agent,h_intro_income_rebate_rate')->find();
  475. $intro_income_rebate_rate = ($agent_info['is_agent'] == 1) ? $agent_info['h_intro_income_rebate_rate'] : (int)config('site.intro_income_rebate_rate'); //邀请人收礼物返利比率
  476. if ($intro_income_rebate_rate > 0 && $intro_income_rebate_rate <= 100) {
  477. //上级获得金额
  478. $intro_uid_money = bcdiv(bcmul($money,$intro_income_rebate_rate,2),100,2);
  479. if ($intro_uid_money > 0) {
  480. $intro_result = model('Wallet')->lockChangeAccountRemain($touserinfo['intro_uid'],$to_user_id,'money',$intro_uid_money,68, '邀请人文字聊天获赠奖励','user_match_typing_log',$log_id);
  481. if($intro_result['status']===false)
  482. {
  483. Db::rollback();
  484. $this->error($intro_result['msg']);
  485. }
  486. }
  487. }
  488. }
  489. }
  490. //增加亲密度
  491. $user_intimacy_rs = addintimacy($this->auth->id, $to_user_id, $price);
  492. if (!$user_intimacy_rs['status']) {
  493. Db::rollback();
  494. $this->error('您的网络开小差啦~');
  495. }
  496. //tag任务赠送金币
  497. //私信5名异性奖励
  498. $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,23);
  499. if($task_rs === false){
  500. Db::rollback();
  501. $this->error('完成任务赠送奖励失败');
  502. }
  503. $task_rs = \app\common\model\TaskLog::tofinish($to_user_id,23);
  504. if($task_rs === false){
  505. Db::rollback();
  506. $this->error('完成任务赠送奖励失败');
  507. }
  508. Db::commit();
  509. //发送消息
  510. /*if (isset($user_intimacy_rs) && $user_intimacy_rs['level_remark']) {
  511. $tenim = new \app\api\controller\Tenim;
  512. $tenim->sendMessageToUser($this->auth->id, $to_user_id, $user_intimacy_rs['level_remark'], 1);
  513. }*/
  514. $this->success('success',$resArray);
  515. }
  516. //语音通话每分钟调用一次
  517. public function voice_onemin(){
  518. if ($this->auth->is_kefu == 1) { //我是客服或者对方是客服
  519. $this->success('success',['money' => 'free']);
  520. }
  521. if ($this->auth->gender == 0) { //女生不花钱
  522. $this->error('您的网络开小差啦~');
  523. }
  524. //检测用户
  525. $to_user_id = input_post('to_user_id');
  526. $request_id = input('request_id', '', 'trim'); //唯一请求标识
  527. $to_user_info = Db::name('user')->field('id,intro_uid,real_status,gender,free_video,free_audio,free_typing,voice_price,is_kefu')->where('id',$to_user_id)->find();
  528. if(!$to_user_info){
  529. $this->error('不存在的用户');
  530. }
  531. if ($to_user_info['is_kefu'] == 1) { //我是客服或者对方是客服
  532. $this->success('success',['money' => 'free']);
  533. }
  534. if ($to_user_info['gender'] != 0) {
  535. $this->error('同性不能聊天~');
  536. }
  537. //验证金额
  538. $wallet_info = Db::name('user_wallet')->where('user_id',$this->auth->id)->find();
  539. $is_vip = $this->is_vip($wallet_info['vip_endtime'],$wallet_info['vip_level']);
  540. if ($is_vip) { //会员
  541. $price = $to_user_info['voice_price'];//config('site.video_min_price'); //扣费金币
  542. //获取折扣
  543. $vip_voice_discount = config('site.vip_voice_discount');
  544. if ($vip_voice_discount >= 0 && $vip_voice_discount <= 10) {
  545. $price = bcdiv(bcmul($price,$vip_voice_discount,2),10,0);
  546. }
  547. } else {
  548. $price = $to_user_info['voice_price'];//config('site.video_min_price'); //扣费金币
  549. }
  550. //正常价格
  551. $bili = config('site.money_to_gold'); //兑换比例
  552. $gift_plat_scale = config('site.gift_plat_scale'); //抽成比例
  553. $money = bcdiv($price,$bili,2); //对应人民币
  554. $money = bcdiv(bcmul($money,100 - $gift_plat_scale,2),100,2); //抽成后收益
  555. Db::startTrans();
  556. //查询是否有匹配记录
  557. $user_match_audio_log_info = [];
  558. if ($request_id) {
  559. $user_match_audio_log_info = Db::name('user_match_audio_log')->where(['user_id' => $this->auth->id, 'to_user_id' => $to_user_id, 'request_id' => $request_id])->find();
  560. }
  561. if ($user_match_audio_log_info) {
  562. //修改记录日志
  563. $data = [
  564. 'price' => bcadd($user_match_audio_log_info['price'],$price,0),
  565. 'createtime' => time(),
  566. 'money' => bcadd($user_match_audio_log_info['money'],$money,2),
  567. 'call_minutes' => $user_match_audio_log_info['call_minutes'] + 1
  568. ];
  569. $log_rs = Db::name('user_match_audio_log')->where(['id' => $user_match_audio_log_info['id'], 'createtime' => $user_match_audio_log_info['createtime']])->setField($data);
  570. if (!$log_rs) {
  571. Db::rollback();
  572. $this->error('扣费失败');
  573. }
  574. $log_id = $user_match_audio_log_info['id'];
  575. } else {
  576. //添加记录日志
  577. $data = [
  578. 'user_id' => $this->auth->id,
  579. 'price' => $price,
  580. 'createtime' => time(),
  581. 'to_user_id' => $to_user_id,
  582. 'money' => $money,
  583. 'request_id' => $request_id,
  584. 'call_minutes' => 1
  585. ];
  586. $log_id = Db::name('user_match_audio_log')->insertGetId($data);
  587. if (!$log_id) {
  588. Db::rollback();
  589. $this->error('扣费失败');
  590. }
  591. }
  592. //有性别差,扣费
  593. if($price > 0){
  594. $rs = model('wallet')->lockChangeAccountRemain($this->auth->id,$to_user_id,'gold',-$price,12,'语音通话消费' . $data['call_minutes'] . '分钟','user_match_audio_log',$log_id, 0, $request_id);
  595. if($rs['status'] === false){
  596. Db::rollback();
  597. $this->error($rs['msg']);
  598. }
  599. }
  600. //另一方加钱,0收费
  601. if($money > 0){
  602. $rs = model('wallet')->lockChangeAccountRemain($to_user_id,$this->auth->id,'money',$money,22,'语音通话收益' . $data['call_minutes'] . '分钟','user_match_audio_log',$log_id,2, $request_id);
  603. if($rs['status'] === false){
  604. Db::rollback();
  605. $this->error($rs['msg']);
  606. }
  607. $touserinfo = $to_user_info;
  608. //增加赠送用户上级余额
  609. if ($touserinfo['intro_uid']) {
  610. //获取返利比率
  611. $agent_info = Db::name('user')->where(['id' => $touserinfo['intro_uid']])->field('is_agent,h_intro_income_rebate_rate')->find();
  612. $intro_income_rebate_rate = ($agent_info['is_agent'] == 1) ? $agent_info['h_intro_income_rebate_rate'] : (int)config('site.intro_income_rebate_rate'); //邀请人收礼物返利比率
  613. if ($intro_income_rebate_rate > 0 && $intro_income_rebate_rate <= 100) {
  614. //上级获得金额
  615. $intro_uid_money = bcdiv(bcmul($money,$intro_income_rebate_rate,2),100,2);
  616. if ($intro_uid_money > 0) {
  617. $intro_result = model('Wallet')->lockChangeAccountRemain($touserinfo['intro_uid'],$to_user_id,'money',$intro_uid_money,68, '邀请人语音聊天获赠奖励' . $data['call_minutes'] . '分钟','user_match_audio_log',$log_id, 0, $request_id);
  618. if($intro_result['status']===false)
  619. {
  620. Db::rollback();
  621. $this->error($intro_result['msg']);
  622. }
  623. }
  624. }
  625. }
  626. }
  627. //增加亲密度
  628. $user_intimacy_rs = addintimacy($this->auth->id, $to_user_id, $price);
  629. if (!$user_intimacy_rs['status']) {
  630. Db::rollback();
  631. $this->error('您的网络开小差啦~');
  632. }
  633. //tag任务赠送金币
  634. //与1名异性语音通话奖励
  635. $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,25);
  636. if($task_rs === false){
  637. Db::rollback();
  638. $this->error('完成任务赠送奖励失败');
  639. }
  640. $task_rs = \app\common\model\TaskLog::tofinish($to_user_id,25);
  641. if($task_rs === false){
  642. Db::rollback();
  643. $this->error('完成任务赠送奖励失败');
  644. }
  645. //发送消息
  646. /*if (isset($user_intimacy_rs) && $user_intimacy_rs['level_remark']) {
  647. $tenim = new \app\api\controller\Tenim;
  648. $tenim->sendMessageToUser($this->auth->id, $to_user_id, $user_intimacy_rs['level_remark'], 1);
  649. }*/
  650. Db::commit();
  651. $rs = [
  652. 'money' => $data['money'],
  653. ];
  654. $this->success('success',$rs);
  655. }
  656. //视频通话每分钟调用一次
  657. public function videochat_onemin(){
  658. if ($this->auth->is_kefu == 1) { //我是客服或者对方是客服
  659. $this->success('success',['money' => 'free']);
  660. }
  661. if ($this->auth->gender == 0) { //女生不花钱
  662. $this->error('您的网络开小差啦~');
  663. }
  664. //检测用户
  665. $to_user_id = input_post('to_user_id');
  666. $request_id = input('request_id', '', 'trim'); //唯一请求标识
  667. $to_user_info = Db::name('user')->field('id,intro_uid,real_status,gender,free_video,free_audio,free_typing,video_price,is_kefu')->where('id',$to_user_id)->find();
  668. if(!$to_user_info){
  669. $this->error('不存在的用户');
  670. }
  671. if ($to_user_info['is_kefu'] == 1) { //我是客服或者对方是客服
  672. $this->success('success',['money' => 'free']);
  673. }
  674. if ($to_user_info['gender'] != 0) {
  675. $this->error('同性不能聊天~');
  676. }
  677. /* //检查是否免费过
  678. $count = Db::name('user_match_video_log_free')->where(['user_id' => $this->auth->id])->count('id');
  679. if (!$count) {
  680. //记录日志
  681. $data = [
  682. 'user_id' => $this->auth->id,
  683. 'price' => 0,
  684. 'createtime' => time(),
  685. 'to_user_id' => $to_user_id,
  686. 'money' => 0,
  687. ];
  688. $log_id = Db::name('user_match_video_log_free')->insertGetId($data);
  689. if(!$log_id){
  690. $this->error('扣费失败');
  691. }
  692. $this->success('success');
  693. }*/
  694. //验证金额
  695. $wallet_info = Db::name('user_wallet')->where('user_id',$this->auth->id)->find();
  696. $is_vip = $this->is_vip($wallet_info['vip_endtime'],$wallet_info['vip_level']);
  697. if ($is_vip) { //会员
  698. $price = $to_user_info['video_price'];//config('site.video_min_price'); //扣费金币
  699. //获取折扣
  700. $vip_video_discount = config('site.vip_video_discount');
  701. if ($vip_video_discount >= 0 && $vip_video_discount <= 10) {
  702. $price = bcdiv(bcmul($price,$vip_video_discount,2),10,0);
  703. }
  704. } else {
  705. $price = $to_user_info['video_price'];//config('site.video_min_price'); //扣费金币
  706. }
  707. //正常价格
  708. $bili = config('site.money_to_gold'); //兑换比例
  709. $gift_plat_scale = config('site.gift_plat_scale'); //抽成比例
  710. $money = bcdiv($price,$bili,2); //对应人民币
  711. $money = bcdiv(bcmul($money,100 - $gift_plat_scale,2),100,2); //抽成后收益
  712. Db::startTrans();
  713. //查询是否有匹配记录
  714. $user_match_video_log_info = [];
  715. if ($request_id) {
  716. $user_match_video_log_info = Db::name('user_match_video_log')->where(['user_id' => $this->auth->id, 'to_user_id' => $to_user_id, 'request_id' => $request_id])->find();
  717. }
  718. if ($user_match_video_log_info) {
  719. //修改记录日志
  720. $data = [
  721. 'price' => bcadd($user_match_video_log_info['price'],$price,0),
  722. 'createtime' => time(),
  723. 'money' => bcadd($user_match_video_log_info['money'],$money,2),
  724. 'call_minutes' => $user_match_video_log_info['call_minutes'] + 1
  725. ];
  726. $log_rs = Db::name('user_match_video_log')->where(['id' => $user_match_video_log_info['id'], 'createtime' => $user_match_video_log_info['createtime']])->setField($data);
  727. if (!$log_rs) {
  728. Db::rollback();
  729. $this->error('扣费失败');
  730. }
  731. $log_id = $user_match_video_log_info['id'];
  732. } else {
  733. //添加记录日志
  734. $data = [
  735. 'user_id' => $this->auth->id,
  736. 'price' => $price,
  737. 'createtime' => time(),
  738. 'to_user_id' => $to_user_id,
  739. 'money' => $money,
  740. 'request_id' => $request_id,
  741. 'call_minutes' => 1
  742. ];
  743. $log_id = Db::name('user_match_video_log')->insertGetId($data);
  744. if (!$log_id) {
  745. Db::rollback();
  746. $this->error('扣费失败');
  747. }
  748. }
  749. //有性别差,扣费
  750. if($price > 0){
  751. $rs = model('wallet')->lockChangeAccountRemain($this->auth->id,$to_user_id,'gold',-$price,11,'视频通话消费' . $data['call_minutes'] . '分钟','user_match_video_log',$log_id, 0, $request_id);
  752. if($rs['status'] === false){
  753. Db::rollback();
  754. $this->error($rs['msg']);
  755. }
  756. }
  757. //另一方加钱,0收费
  758. if($money > 0){
  759. $rs = model('wallet')->lockChangeAccountRemain($to_user_id,$this->auth->id,'money',$money,21,'视频通话收益' . $data['call_minutes'] . '分钟','user_match_video_log',$log_id,2, $request_id);
  760. if($rs['status'] === false){
  761. Db::rollback();
  762. $this->error($rs['msg']);
  763. }
  764. $touserinfo = $to_user_info;
  765. //增加赠送用户上级余额
  766. if ($touserinfo['intro_uid']) {
  767. //获取返利比率
  768. $agent_info = Db::name('user')->where(['id' => $touserinfo['intro_uid']])->field('is_agent,h_intro_income_rebate_rate')->find();
  769. $intro_income_rebate_rate = ($agent_info['is_agent'] == 1) ? $agent_info['h_intro_income_rebate_rate'] : (int)config('site.intro_income_rebate_rate'); //邀请人收礼物返利比率
  770. if ($intro_income_rebate_rate > 0 && $intro_income_rebate_rate <= 100) {
  771. //上级获得金额
  772. $intro_uid_money = bcdiv(bcmul($money,$intro_income_rebate_rate,2),100,2);
  773. if ($intro_uid_money > 0) {
  774. $intro_result = model('Wallet')->lockChangeAccountRemain($touserinfo['intro_uid'],$to_user_id,'money',$intro_uid_money,68, '邀请人视频聊天获赠奖励' . $data['call_minutes'] . '分钟','user_match_video_log',$log_id, 0, $request_id);
  775. if($intro_result['status']===false)
  776. {
  777. Db::rollback();
  778. $this->error($intro_result['msg']);
  779. }
  780. }
  781. }
  782. }
  783. }
  784. //增加亲密度
  785. $user_intimacy_rs = addintimacy($this->auth->id, $to_user_id, $price);
  786. if (!$user_intimacy_rs['status']) {
  787. Db::rollback();
  788. $this->error('您的网络开小差啦~');
  789. }
  790. //tag任务赠送金币
  791. //与1名异性视频通话奖励
  792. $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,26);
  793. if($task_rs === false){
  794. Db::rollback();
  795. $this->error('完成任务赠送奖励失败');
  796. }
  797. $task_rs = \app\common\model\TaskLog::tofinish($to_user_id,26);
  798. if($task_rs === false){
  799. Db::rollback();
  800. $this->error('完成任务赠送奖励失败');
  801. }
  802. Db::commit();
  803. //发送消息
  804. /*if (isset($user_intimacy_rs) && $user_intimacy_rs['level_remark']) {
  805. $tenim = new \app\api\controller\Tenim;
  806. $tenim->sendMessageToUser($this->auth->id, $to_user_id, $user_intimacy_rs['level_remark'], 1);
  807. }*/
  808. $rs = [
  809. 'money' => $data['money'],
  810. ];
  811. $this->success('success',$rs);
  812. }
  813. //消息列表通话
  814. public function calllist() {
  815. if ($this->auth->gender == 1) {
  816. $list = Db::name('user_gold_log')->where(['user_id' => $this->auth->id, 'log_type' => ['in', [11, 12]]])->order('id desc')->autopage()->select();
  817. } elseif ($this->auth->gender == 0) {
  818. $list = Db::name('user_money_log')->where(['user_id' => $this->auth->id, 'log_type' => ['in', [21, 22]]])->order('id desc')->autopage()->select();
  819. } else {
  820. $this->success('success', []);
  821. }
  822. if (!$list) {
  823. $this->success('success', $list);
  824. }
  825. $arr = [];
  826. $mt_user_match_audio_log = Db::name('user_match_audio_log');
  827. $mt_user_match_video_log = Db::name('user_match_video_log');
  828. $mt_user = Db::name('user');
  829. foreach ($list as &$v) {
  830. $data = [];
  831. if ($this->auth->gender == 1) {
  832. if ($v['log_type'] == 11) { //视频通话
  833. $log_info = $mt_user_match_video_log->field('to_user_id user_id, createtime, call_minutes')->where(['id' => $v['table_id']])->find();
  834. $data['desc'] = '视频时长' . $log_info['call_minutes'] . '分钟';
  835. } else { //语音通话
  836. $log_info = $mt_user_match_audio_log->field('to_user_id user_id, createtime, call_minutes')->where(['id' => $v['table_id']])->find();
  837. $data['desc'] = '语音时长' . $log_info['call_minutes'] . '分钟';
  838. }
  839. } else {
  840. if ($v['log_type'] == 21) { //视频通话
  841. $log_info = $mt_user_match_video_log->field('user_id, createtime, call_minutes')->where(['id' => $v['table_id']])->find();
  842. $data['desc'] = '视频时长' . $log_info['call_minutes'] . '分钟';
  843. } else { //语音通话
  844. $log_info = $mt_user_match_audio_log->field('user_id, createtime, call_minutes')->where(['id' => $v['table_id']])->find();
  845. $data['desc'] = '语音时长' . $log_info['call_minutes'] . '分钟';
  846. }
  847. }
  848. $user_info = $mt_user->field('nickname, avatar,is_active')->where(['id' => $log_info['user_id']])->find();
  849. $data['user_id'] = $log_info['user_id'];
  850. $data['nickname'] = $user_info['nickname'];
  851. $data['avatar'] = one_domain_image($user_info['avatar']);
  852. $data['createtime'] = get_last_time($log_info['createtime']);
  853. $data['is_active'] = $user_info['is_active'];
  854. $arr[] = $data;
  855. }
  856. $this->success('success', $arr);
  857. }
  858. //查询对方用户收费价格和我的余额
  859. public function otheruserinfo(){
  860. $user_id = input('user_id', 0, 'intval');
  861. if (!$user_id) {
  862. $this->error('您的网络开小差啦~');
  863. }
  864. $field = [
  865. 'chat_price','voice_price','video_price','gender','is_kefu', 'open_match_audio', 'open_match_video'
  866. ];
  867. $info = Db::name('user')->field($field)->where('id',$user_id)->find();
  868. if ($info['is_kefu'] != 1 && $this->auth->is_kefu != 1) { //不是客服
  869. if ($info['gender'] == $this->auth->gender || $info['gender'] == -1 || $this->auth->gender == -1) {
  870. $this->error('性别存在问题');
  871. }
  872. }
  873. if ($this->auth->gender == 0) { //收费价格按照女号
  874. $info['chat_price'] = $this->auth->chat_price;
  875. $info['voice_price'] = $this->auth->voice_price;
  876. $info['video_price'] = $this->auth->video_price;
  877. $info['open_match_audio'] = $this->auth->open_match_audio;
  878. $info['open_match_video'] = $this->auth->open_match_video;
  879. }
  880. $info['chat_price_vip'] = $info['chat_price']; //vip价格
  881. $info['voice_price_vip'] = $info['voice_price'];
  882. $info['video_price_vip'] = $info['video_price'];
  883. //获取聊天折扣
  884. $vip_chat_discount = config('site.vip_chat_discount');
  885. if ($vip_chat_discount >= 0 && $vip_chat_discount <= 10) {
  886. $info['vip_chat_discount'] = $vip_chat_discount;
  887. } else {
  888. $info['vip_chat_discount'] = 10;
  889. }
  890. //获取视频折扣
  891. $vip_video_discount = config('site.vip_video_discount');
  892. if ($vip_video_discount >= 0 && $vip_video_discount <= 10) {
  893. $info['vip_video_discount'] = config('site.vip_video_discount'); //视频
  894. } else {
  895. $info['vip_video_discount'] = 10;
  896. }
  897. //获取语音折扣
  898. $vip_voice_discount = config('site.vip_voice_discount');
  899. if ($vip_voice_discount >= 0 && $vip_voice_discount <= 10) {
  900. $info['vip_voice_discount'] = config('site.vip_voice_discount'); //语音
  901. } else {
  902. $info['vip_voice_discount'] = 10;
  903. }
  904. //获取聊天折扣
  905. $info['chat_price_vip'] = ceil($info['chat_price'] * $info['vip_chat_discount'] / 10);
  906. //获取语音折扣
  907. $info['voice_price_vip'] = ceil($info['voice_price'] * $info['vip_voice_discount'] / 10);
  908. //获取视频折扣
  909. $info['video_price_vip'] = ceil($info['video_price'] * $info['vip_video_discount'] / 10);
  910. if ($this->auth->gender == 0) { //查询男号余额和vip
  911. $wallet_info = Db::name('user_wallet')->where(['user_id' => $user_id])->find();
  912. } else {
  913. $wallet_info = Db::name('user_wallet')->where(['user_id' => $this->auth->id])->find();
  914. }
  915. $info['is_vip'] = $this->is_vip($wallet_info['vip_endtime'],$wallet_info['vip_level']);
  916. $info['gold'] = $wallet_info['gold'];
  917. $info['plat_scale'] = config('site.gift_plat_scale'); //平台抽成百分比
  918. $info['money_to_gold'] = config('site.money_to_gold'); //
  919. $this->success('success',$info);
  920. }
  921. //语音视频随聊
  922. public function getrandomuser() {
  923. $type = input('type', 0, 'intval'); //类型:1语音 2视频
  924. if (!in_array($type, [1, 2, 3])) {
  925. $this->error('您的网络开小差了');
  926. }
  927. $size = input('size',0,'intval');// 是否查 10 条
  928. $size = $size > 0 ? 1 : 0;
  929. //给出备选用户
  930. $map = [
  931. 'gender' => $this->auth->gender == 1 ? 0 : 1, //异性
  932. 'is_active' => 1, //在线的
  933. 'status' =>1, //未封禁用户
  934. 'is_kefu' => 0, //不是客服
  935. ];
  936. if ($this->auth->gender == 1) {
  937. $map['real_status|idcard_status'] = 1; //真人认证或实名认证
  938. }
  939. if ($type == 1) {
  940. $map['open_match_audio'] = 1;
  941. } elseif ($type == 2) {
  942. $map['open_match_video'] = 1;
  943. }
  944. $key = md5(json_encode($map));// 根据搜索条件做Key
  945. $lists = Cache::remember("getrandomuser_{$key}_{$size}",function () use ($map,$size){
  946. $query = Db::name('user')
  947. ->field('id,nickname,username,avatar')
  948. ->where($map)
  949. ->order('is_active desc, logintime desc');
  950. if ($size == 1){
  951. $query->limit(10);
  952. }else{
  953. $query->page($this->page,100);
  954. }
  955. $lists = $query->select();
  956. $lists = list_domain_image($lists,['avatar,audio_bio']);
  957. $mt_user_greet_content = Db::name('user_greet_content');
  958. foreach ($lists as &$v) {
  959. $info = $mt_user_greet_content->where(['user_id' => $v['id'], 'is_default' => 1])->find();
  960. if ($info) {
  961. if ($info['type'] == 0) {
  962. $v['greet_content'] = $info['content'];
  963. } elseif ($info['type'] == 1) {
  964. $v['greet_content'] = '[语音]';
  965. } elseif ($info['type'] == 2) {
  966. $v['greet_content'] = '[图片]';
  967. }
  968. } else {
  969. $v['greet_content'] = '';
  970. }
  971. }
  972. return $lists;
  973. },2);
  974. $count = Db::name('user')->where(['is_active' => 1])->count('id');
  975. $return_data['count'] = config('site.randomuser_num') > 0 ? config('site.randomuser_num') + $count : $count;
  976. $return_data['list'] = $lists;
  977. $this->success('success',$return_data);
  978. }
  979. //查询免费体验视频通话用户信息
  980. public function getfreevideouserinfo() {
  981. $to_user_id = input('to_user_id', 0, 'intval');
  982. $to_user_info = Db::name('user')->field('id,gender,nickname,avatar,birthday,height,bio')->where(['id' => $to_user_id, 'is_kefu' => 0])->find();
  983. if(!$to_user_info){
  984. $this->error('不存在的用户');
  985. }
  986. if ($to_user_info['gender'] == $this->auth->gender) {
  987. $this->error('同性不能聊天~');
  988. }
  989. $to_user_info['desc'] = '';
  990. $age = birthtime_to_age($to_user_info['birthday']);
  991. if ($age > 0) {
  992. $to_user_info['desc'] = $age . '岁';
  993. } else {
  994. $to_user_info['desc'] = '18岁';
  995. }
  996. if ($to_user_info['height']) {
  997. $to_user_info['desc'] .= ' | ' . $to_user_info['height'];
  998. }
  999. //查询是否免费过
  1000. $to_user_info['free_count'] = 1;//Db::name('user_match_video_log_free')->where(['user_id' => $this->auth->id])->count('id');
  1001. $this->success('信息', $to_user_info);
  1002. }
  1003. //免费体验视频通话1分钟
  1004. public function videochat_onemin_free(){
  1005. $this->success('success');
  1006. if ($this->auth->is_kefu == 1) { //我是客服或者对方是客服
  1007. $this->success('success');
  1008. }
  1009. //检查是否免费过
  1010. $count = Db::name('user_match_video_log_free')->where(['user_id' => $this->auth->id])->count('id');
  1011. if ($count) {
  1012. $this->error('已经免费体验过');
  1013. }
  1014. //检测用户
  1015. $to_user_id = input_post('to_user_id');
  1016. $to_user_info = Db::name('user')->field('id,real_status,gender,free_video,free_audio,free_typing,video_price,is_kefu')->where('id',$to_user_id)->find();
  1017. if(!$to_user_info){
  1018. $this->error('不存在的用户');
  1019. }
  1020. if ($to_user_info['is_kefu'] == 1) { //我是客服或者对方是客服
  1021. $this->success('success');
  1022. }
  1023. if ($to_user_info['gender'] == $this->auth->gender) {
  1024. $this->error('同性不能聊天~');
  1025. }
  1026. //记录日志
  1027. $data = [
  1028. 'user_id' => $this->auth->id,
  1029. 'price' => 0,
  1030. 'createtime' => time(),
  1031. 'to_user_id' => $to_user_id,
  1032. 'money' => 0,
  1033. ];
  1034. $log_id = Db::name('user_match_video_log_free')->insertGetId($data);
  1035. if(!$log_id){
  1036. $this->error('扣费失败');
  1037. }
  1038. $this->success('success');
  1039. }
  1040. //男性非会员解锁聊天
  1041. public function unlockchat() {
  1042. }
  1043. /**
  1044. * 是否关注
  1045. */
  1046. public function isFollows() {
  1047. $user_id = $this->request->request("user_id",0,"intval");
  1048. if (!$user_id || $user_id<=0) {
  1049. $this->error(__('Invalid parameters'));
  1050. }
  1051. $map = [
  1052. 'uid' => $this->auth->id,
  1053. 'follow_uid' => $user_id,
  1054. ];
  1055. $check = Db::name('user_follow')->where($map)->find();
  1056. $data = [];
  1057. if($check){
  1058. $data["is_show_follow"] = 0;
  1059. }else{
  1060. $data["is_show_follow"] = 1;
  1061. }
  1062. $this->success("获取成功!",$data);
  1063. }
  1064. //我的礼物榜
  1065. public function gift_ranklist(){
  1066. //日榜
  1067. $sql1 = Db::name('gift_user_typing') ->field('user_id,total_price')->where('user_to_id',$this->auth->id)->whereTime('createtime','today')->select(false);
  1068. $sql2 = Db::name('gift_user_dongtai')->field('user_id,total_price')->where('user_to_id',$this->auth->id)->whereTime('createtime','today')->select(false);
  1069. $sql = 'select log.user_id,sum(log.total_price) sum_price,user.nickname,user.avatar from ('.$sql1.' UNION ALL '.$sql2.') as log LEFT JOIN mt_user user on log.user_id = user.id group by log.user_id order by sum_price desc limit 10';
  1070. $rs_day = Db::query($sql);
  1071. //周榜
  1072. $sql1 = Db::name('gift_user_typing') ->field('user_id,total_price')->where('user_to_id',$this->auth->id)->whereTime('createtime','week')->select(false);
  1073. $sql2 = Db::name('gift_user_dongtai')->field('user_id,total_price')->where('user_to_id',$this->auth->id)->whereTime('createtime','week')->select(false);
  1074. $sql = 'select log.user_id,sum(log.total_price) sum_price,user.nickname,user.avatar from ('.$sql1.' UNION ALL '.$sql2.') as log LEFT JOIN mt_user user on log.user_id = user.id group by log.user_id order by sum_price desc limit 10';
  1075. $rs_week = Db::query($sql);
  1076. //月榜
  1077. $sql1 = Db::name('gift_user_typing') ->field('user_id,total_price')->where('user_to_id',$this->auth->id)->whereTime('createtime','month')->select(false);
  1078. $sql2 = Db::name('gift_user_dongtai')->field('user_id,total_price')->where('user_to_id',$this->auth->id)->whereTime('createtime','month')->select(false);
  1079. $sql = 'select log.user_id,sum(log.total_price) sum_price,user.nickname,user.avatar from ('.$sql1.' UNION ALL '.$sql2.') as log LEFT JOIN mt_user user on log.user_id = user.id group by log.user_id order by sum_price desc limit 10';
  1080. $rs_month = Db::query($sql);
  1081. //
  1082. $rs = [
  1083. 'day' => $rs_day,
  1084. 'week' => $rs_week,
  1085. 'month' => $rs_month,
  1086. ];
  1087. $this->success(1,$rs);
  1088. }
  1089. /////////////////////////////////////////////////////
  1090. /**
  1091. * calc_map_distance() , 根据地图上的两个点各自的x,y坐标,计算出2点之间的直线距离
  1092. * @param array $point_1 第1个点的x,y坐标 array( 101 , 202 )
  1093. * @param array $point_2 第2个点的x,y坐标 array( 101 , 202 )
  1094. * @param bool $calc_as_string 是否计算为字符串公里距离 , 如果未否返回数字
  1095. * @return float | false | string
  1096. */
  1097. private function calc_map_distance( $point_1=array( ) , $point_2=array( ) , $calc_as_string=false ) {
  1098. if( empty( $point_1 ) || empty( $point_2 ) ){
  1099. return false;
  1100. }
  1101. // 经纬度不存在,或者经纬度超过最大范围 +-180 , +-90 ,返回false
  1102. $p1_x = $point_1[0];
  1103. $p1_y = $point_1[1];
  1104. $p2_x = $point_2[0];
  1105. $p2_y = $point_2[1];
  1106. if(
  1107. $p1_x < -180 || $p1_x > 180
  1108. || $p2_x < -180 || $p2_x > 180
  1109. || $p1_y < -90 || $p1_y > 90
  1110. || $p2_y < -90 || $p2_y > 90
  1111. ){
  1112. return '0公里';
  1113. }
  1114. // 根据2点各自的坐标,计算2点之间直线距离的公式
  1115. $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);
  1116. // 是否计算为字符串公里距离
  1117. if( !$calc_as_string ){
  1118. return (string)round( $distance / 1000 , 1 ) . '公里';
  1119. }
  1120. // 如果计算为字符串公里距离
  1121. if( $distance / 1000 > 1 ){
  1122. $k = (string)round( $distance / 1000 , 1 );
  1123. $m = (string)$distance % 1000 ;
  1124. $distance = "{$k}公里{$m}米";
  1125. }
  1126. else{
  1127. $distance = "{$distance}米";
  1128. }
  1129. return $distance;
  1130. }
  1131. //地图api,根据两地坐标,获得两地距离,打卡用的
  1132. //type=0直线,type=1开车
  1133. private function getmapjuli($start_lon,$start_lat,$end_lon,$end_lat,$type = 0){
  1134. $result = 0;
  1135. $apiurl = 'https://restapi.amap.com/v3/distance?';
  1136. $param = [
  1137. 'key' => '398c424811d1a59beac2f915323d334e',
  1138. 'origins' => $start_lon.','.$start_lat,
  1139. 'destination' => $end_lon.','.$end_lat,
  1140. 'type' => $type,
  1141. 'output' => 'json',
  1142. ];
  1143. $apiurl .= http_build_query($param);
  1144. $request_rs = json_decode(curl_get($apiurl),true);
  1145. if(isset($request_rs['status']) && $request_rs['status'] == 1){
  1146. if(isset($request_rs['results'][0]['distance']))
  1147. {
  1148. $result = $request_rs['results'][0]['distance'];
  1149. }
  1150. }
  1151. //dump($result);
  1152. return $result;
  1153. }
  1154. public function distance()
  1155. {
  1156. $a = $this->calc_map_distance([118.339282,35.028445],[118.437399,35.017438]);
  1157. dump($a);
  1158. $a = $this->calc_map_distance([118.339282,35.028445],[118.437399,35.017438],true);
  1159. dump($a);
  1160. $b = $this->getmapjuli(118.339282,35.028445,118.437399,35.017438,1);
  1161. dump($b);
  1162. $b = $this->getmapjuli(118.339282,35.028445,118.437399,35.017438,0);
  1163. dump($b);
  1164. }
  1165. }