Party.php 90 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227
  1. <?php
  2. namespace app\api\controller;
  3. use app\api\controller\Common;
  4. use app\common\model\PartyJoin;
  5. use fast\Random;
  6. use app\common\controller\RedisLeaderboard;
  7. use Redis;
  8. use think\Db;
  9. use think\Exception;
  10. use think\exception\PDOException;
  11. use think\exception\ValidateException;
  12. use think\Request;
  13. use app\common\service\RoomService;
  14. /**
  15. * 派对信息接口
  16. */
  17. class Party extends Common
  18. {
  19. protected $noNeedLogin = ['updatePartyInfo','getPatyType','addUserPositionToParty', 'clearMoney','clearCharm','getPartyRankList','getDefaultBackground','getPartGifList','getPartHeadgifList','isNotalk','getMusicList','updateTops','handleParty'];
  20. protected $noNeedRight = ['*'];
  21. public function __construct(Request $request = null)
  22. {
  23. $this->roomTypeArr = [1=>"party",2=>"live"];
  24. parent::__construct($request);
  25. }
  26. /**
  27. * 创建/进入派对
  28. */
  29. public function createParty() {
  30. $room_type = $this->request->request('room_type',2); // 房间类型:1=派对,2=直播
  31. $partyModel = new \app\common\model\Party();
  32. $user_id = $this->auth->id;
  33. // 开直播时,判断当前用户是否为主播
  34. $anchorInfo = [];
  35. if($room_type == 2) {
  36. $anchorInfo = \app\common\model\UserAnchor::where(["user_id"=>$user_id])->find();
  37. $anchorInfo || $this->error("您还未申请主播!");
  38. $anchorInfo->status == 0 && $this->error("您的主播申请信息还未受理,请耐心等待!");
  39. $anchorInfo->status == 2 && $this->error("您的主播申请未通过,请重新提交!");
  40. }
  41. // 1。实名认证
  42. $userAuthInfo = \app\common\model\UserAuth::where(["user_id"=>$user_id])->find();
  43. if($userAuthInfo) {
  44. if($userAuthInfo->status == 0) {
  45. $this->error("您的实名认证还在这审核中...,请耐心等待!");
  46. } elseif($userAuthInfo->status == 2) {
  47. $this->error("您的实名认证审核未通过,请重新审核!");
  48. }
  49. } else {
  50. $this->error("请先申请实名认证!");
  51. }
  52. if($room_type == 1) {
  53. // 2。开厅申请
  54. $authInfo = \app\common\model\Guild::where(["user_id"=>$user_id])->order('id desc')->find();
  55. if($authInfo) {
  56. if($authInfo->status == 0) {
  57. $this->error("您的家族申请还在这审核中...,请耐心等待!");
  58. } elseif($authInfo->status == -1) {
  59. $this->error("您的家族申请已解散,请重新申请!");
  60. }
  61. } else {
  62. $this->error("请先申请家族!");
  63. }
  64. }
  65. // 判断派对是否存在
  66. $redis = new Redis();
  67. $redisconfig = config("redis");
  68. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  69. if ($redisconfig['redis_pwd']) {
  70. $redis->auth($redisconfig['redis_pwd']);
  71. }
  72. if($redisconfig['redis_selectdb'] > 0){
  73. $redis->select($redisconfig['redis_selectdb']);
  74. }
  75. $where = [];
  76. $where["user_id"] = $user_id;
  77. $where["room_type"] = $room_type;
  78. $sqlPartyInfo = $partyModel->where($where)->find();
  79. if(!$sqlPartyInfo) { // sql中不存在派对信息
  80. $partylimit = config("site.roomLimit");
  81. $partycount = $partyModel->count("id");
  82. if($partycount >= $partylimit && $partylimit != -1) {
  83. $this->error("房间数量已达上线,请联系客服!");
  84. }
  85. $party_name = $this->auth->u_id."的房间"; // 派对名称
  86. $party_logo = "/assets/api/party_logo.png"; // 派对logo
  87. $party_type = isset($anchorInfo['party_type_id']) ? $anchorInfo['party_type_id'] : 0; // 派对类型(情感互动,心动点单 等)
  88. $party_notice = "请编辑房间公告"; // 派对公告
  89. $party_notice_detail = "请编辑房间公告内容!"; // 派对公告详情
  90. if (!$party_name || !$party_logo || !$party_notice) {
  91. $this->error(__('Invalid parameters'));
  92. }
  93. $party_ids = $partyModel->column("party_id");
  94. // 创建派对ID (临时ID四位,派对数不超过8999)
  95. $party_id = $this->auth->getUinqueId(4,$party_ids);
  96. if($party_id > 9999) {
  97. $this->error("派对超限,请联系客服");
  98. }
  99. $data = [];
  100. $data["user_id"] = $this->auth->id;
  101. $data["room_type"] = $room_type;
  102. $data["party_id"] = $party_id;
  103. $data["party_hot"] = 0;
  104. $data["party_name"] = $party_name;
  105. $data["party_logo"] = $party_logo;
  106. $data["party_type"] = $party_type;
  107. $data["party_notice"] = $party_notice;
  108. $data["party_notice_detail"] = $party_notice_detail;
  109. $data["is_online"] = 1;
  110. $data["status"] = 1;
  111. $data["is_recommend"] = 0;
  112. $data["createtime"] = time();
  113. $id = $partyModel->insertGetId($data);
  114. if(!$id) {
  115. $this->error("派对创建失败,请稍后重试!");
  116. }
  117. $data["id"] = $id;
  118. if($room_type == 2) {
  119. \app\common\model\User::update(["is_live"=>1],["id"=>$user_id]);
  120. }
  121. $partyInfo = $partyModel->where(["id"=>$id])->find();
  122. $partyInfo["is_new"] = 1;
  123. // 冠名
  124. $userInfo = [];
  125. if($partyInfo["naming"]) {
  126. $userInfo = \app\common\model\User::field("id,nickname,avatar")->where(["id"=>$partyInfo["naming"]])->find();
  127. }
  128. // 头像
  129. if($partyInfo["user_id"] > 0 && $room_type == 2) {
  130. $partyInfo["avatar"] = \app\common\model\User::where(["id"=>$partyInfo["user_id"]])->value("avatar");
  131. }
  132. // 派对类型
  133. $partyTypeName = "普通房";
  134. if($partyInfo["party_type"]) {
  135. $partyTypeName = \app\common\model\PartyType::where(["id"=>$partyInfo["party_type"]])->value("name");
  136. }
  137. $partyInfo["naming"] = $userInfo;
  138. $partyInfo["type_name"] = $partyTypeName;
  139. // 加入缓存排序
  140. $redis->zAdd($this->roomTypeArr[$room_type]."Rank", $partyInfo['party_hot'], $partyInfo["id"]);
  141. // 加入缓存
  142. $redis->set($this->roomTypeArr[$room_type]."_".$partyInfo["id"],json_encode($partyInfo));
  143. if($room_type != 2) {
  144. // 创建公会
  145. /*\app\common\model\Guild::createGuild($partyInfo["id"], $partyInfo["party_name"], $user_id);
  146. \app\common\model\User::update(["is_guild" => 3,'guild_id'], ["id" => $user_id]);*/
  147. //更新家族 party_id
  148. $guildWhere['id'] = $user_id;
  149. $guildWhere['status'] = ['in',[0,1]];
  150. $guild = model('Guild')->where($guildWhere)->find();
  151. if (!empty($guild)) {
  152. model('Guild')->where($guildWhere)->update(['party_id'=>$partyInfo['id']]);
  153. }
  154. }
  155. } else {
  156. if($sqlPartyInfo["is_close"] == 1) $this->error("该房间已被关闭!");
  157. if($sqlPartyInfo["status"] == 0){
  158. // 清楚对应的记录
  159. $redis->del($this->roomTypeArr[$room_type]."_".$sqlPartyInfo["id"]);
  160. // 删除派对记录
  161. \app\common\model\Party::where('id',$sqlPartyInfo["id"])->delete();
  162. $this->error("创建失败,请重试");
  163. }
  164. // if($sqlPartyInfo["status"] != 1) $this->error("该房间为预创建房间,请联系管理员正式开通!");
  165. // 如果是房主并且房间处于离线状态下激活
  166. if ($sqlPartyInfo['user_id'] != $user_id) {
  167. $this->error("当前直播已结束!");
  168. }
  169. $partyInfo = $sqlPartyInfo;
  170. $partyInfo["is_new"] = 0;
  171. }
  172. $this->success("获取成功!",$partyInfo);
  173. }
  174. /**
  175. * 更新房间状态为正常
  176. */
  177. public function savePartyStatus() {
  178. $party_id = $this->request->request('party_id'); // 派对ID
  179. $room_type = $this->request->request('room_type',1); // 房间类型:1=派对,2=直播
  180. if (!$party_id || !in_array($room_type,[1,2])) $this->error(__('Invalid parameters'));
  181. $user_id = $this->auth->id;
  182. $partyInfo = \app\common\model\Party::get($party_id);
  183. if($partyInfo->status < 0) $this->error("当前状态不支持变更!");
  184. if($partyInfo->user_id !== $user_id) $this->error("当前账号异常,非工会长禁止操作!");
  185. $partyInfo->status = 1;
  186. $res = $partyInfo->save();
  187. if($res) {
  188. // 更新redis 加入缓存排序
  189. $redis = new Redis();
  190. $redisconfig = config("redis");
  191. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  192. if ($redisconfig['redis_pwd']) {
  193. $redis->auth($redisconfig['redis_pwd']);
  194. }
  195. if($redisconfig['redis_selectdb'] > 0){
  196. $redis->select($redisconfig['redis_selectdb']);
  197. }
  198. // 更新redis 加入缓存
  199. $redPartyInfo = $redis->get($this->roomTypeArr[$room_type]."_".$partyInfo["id"]);
  200. if($redPartyInfo) {
  201. $redPartyInfo = json_decode($redPartyInfo,true);
  202. $redPartyInfo["status"] = 1;
  203. $redis->set($this->roomTypeArr[$room_type]."_".$partyInfo["id"],json_encode($redPartyInfo));
  204. }
  205. $this->success("更新公会状态成功!");
  206. } else {
  207. $this->error("网络错误,请稍后重试!");
  208. }
  209. }
  210. /**
  211. * 删除派对(群解散)
  212. */
  213. public function closeParty() {
  214. $party_id = $this->request->request('party_id'); // 派对ID
  215. $room_type = $this->request->request('room_type',1); // 房间类型:1=派对,2=直播
  216. if (!$party_id || !in_array($room_type,[1,2])) $this->error(__('Invalid parameters'));
  217. $partyInfo = \app\common\model\Party::where(["id"=>$party_id])->find();
  218. if(!$partyInfo) $this->error(__('派对不存在!'));
  219. $res = $partyInfo->delete();
  220. if($res !== false) {
  221. // redis 删除
  222. $redis = new Redis();
  223. $redisconfig = config("redis");
  224. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  225. if ($redisconfig['redis_pwd']) {
  226. $redis->auth($redisconfig['redis_pwd']);
  227. }
  228. if($redisconfig['redis_selectdb'] > 0){
  229. $redis->select($redisconfig['redis_selectdb']);
  230. }
  231. $redis->zRem($this->roomTypeArr[$room_type]."Rank",$party_id);
  232. $redis->del($this->roomTypeArr[$room_type]."_".$party_id);
  233. $this->success("删除成功!");
  234. } else {
  235. $this->error("删除失败!");
  236. }
  237. }
  238. /**
  239. * 获取派对列表排序
  240. */
  241. public function getPartyRankList() {
  242. $thispage = $this->request->request('thispage',1,"intval"); // 当前页数
  243. $pagenum = $this->request->request('pagenum',10,"intval"); // 每页显示条数0=不做分页
  244. $type_id = $this->request->request('type_id'); // 派对类型
  245. $room_type = $this->request->request('room_type',1); // 房间类型:1=派对,2=直播
  246. $is_recommend = $this->request->request('is_recommend'); // 推荐0=否1=是
  247. $all = $this->request->request('all'); // 全部分类0=否1=是
  248. $index = $this->request->request('index',0); // 全部分类0=否1=是
  249. $start = ($thispage-1)*$pagenum;
  250. $end = $start+($pagenum-1);
  251. // 获取排序
  252. $redis = new Redis();
  253. $redisconfig = config("redis");
  254. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  255. if ($redisconfig['redis_pwd']) {
  256. $redis->auth($redisconfig['redis_pwd']);
  257. }
  258. if($redisconfig['redis_selectdb'] > 0){
  259. $redis->select($redisconfig['redis_selectdb']);
  260. }
  261. $redisPartyRankList = $redis->zRevRange($this->roomTypeArr[$room_type]."Rank",0,-1,true);
  262. $partyModel = new \app\common\model\Party();
  263. if(!$redisPartyRankList) {
  264. $userModel = new \app\common\model\User();
  265. // 直接从数据库获取所有数据
  266. $where = [];
  267. $where["a.status"] = 1;
  268. $where["a.is_online"] = 1;
  269. $where["a.room_type"] = $room_type;
  270. $sqlPartyList = $partyModel->alias("a")->field("a.*,b.name as type_name")
  271. ->join("hx_party_type b","a.party_type = b.id","left")->where($where)->select();
  272. $userList = $userModel->field("id,nickname,avatar")->where(["status"=>"normal"])->select();
  273. $userInfoArr = [];
  274. if($userList) foreach($userList as $k => $v) $userInfoArr[$v["id"]] = $v;
  275. if($sqlPartyList) {
  276. foreach($sqlPartyList as $k => $v) {
  277. // 加入缓存排序
  278. $redis->zAdd($this->roomTypeArr[$room_type]."Rank", $v['party_hot'], $v["id"]);
  279. // 设置冠名
  280. $sqlPartyList[$k]["naming"] = isset($userInfoArr[$v["naming"]])?$userInfoArr[$v["naming"]]:[];
  281. // 设置房主头像
  282. $sqlPartyList[$k]["avatar"] = isset($userInfoArr[$v["user_id"]])?$userInfoArr[$v["user_id"]]["avatar"]:[];
  283. // 加入缓存
  284. $redis->set($this->roomTypeArr[$room_type]."_".$v["id"],json_encode($v));
  285. }
  286. $redisPartyRankList = $redis->zRevRange($this->roomTypeArr[$room_type]."Rank",0,-1,true);
  287. }
  288. }
  289. if($redisPartyRankList) {
  290. $resultInfo = $partyModel->getPatyInfoByPartyId($redisPartyRankList,$this->roomTypeArr[$room_type],$type_id,$is_recommend,$all,$start,$end,$index);
  291. $this->success("获取成功!",$resultInfo);
  292. }else{
  293. $this->success("获取成功!",[]);
  294. }
  295. }
  296. /**
  297. * 获取派对列表排序
  298. */
  299. public function getPartyList() {
  300. try {
  301. $thispage = $this->request->request('thispage',1,"intval"); // 当前页数
  302. $pagenum = $this->request->request('pagenum',10,"intval"); // 每页显示条数0=不做分页
  303. $type_id = $this->request->request('type_id'); // 派对类型
  304. $is_recommend = $this->request->request('is_recommend'); // 推荐0=否1=是
  305. $all = $this->request->request('all'); // 全部分类0=否1=是
  306. $index = $this->request->request('index',0); // 全部分类0=否1=是
  307. $start = ($thispage-1)*$pagenum;
  308. $end = $start+($pagenum-1);
  309. // 获取排序
  310. $redis = new Redis();
  311. $redisconfig = config("redis");
  312. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  313. if ($redisconfig['redis_pwd']) {
  314. $redis->auth($redisconfig['redis_pwd']);
  315. }
  316. if($redisconfig['redis_selectdb'] > 0){
  317. $redis->select($redisconfig['redis_selectdb']);
  318. }
  319. $redisPartyRankList = $redis->zRevRange("partyRank",0,-1,true);
  320. $redisLiveRankList = $redis->zRevRange("liveRank",0,-1,true);
  321. $roomService = new RoomService();
  322. if(!$redisPartyRankList) {//party
  323. $roomParams = ['room_type' => 1];
  324. $roomPartyRes = $roomService->roomRedis($roomParams);
  325. $redisPartyRankList = $roomPartyRes['data'];
  326. }
  327. if(!$redisLiveRankList) {//live
  328. $roomParams = ['room_type' => 2];
  329. $roomLiveRes = $roomService->roomRedis($roomParams);
  330. $redisLiveRankList = $roomLiveRes['data'];
  331. }
  332. $redisRoomListIds = [];
  333. $partyIds = !empty($redisPartyRankList) ? array_keys($redisPartyRankList) : [];
  334. $liveIds = !empty($redisLiveRankList) ? array_keys($redisLiveRankList) : [];
  335. $redisRoomListIds = array_merge($redisRoomListIds,$partyIds,$liveIds);
  336. if(!empty($redisRoomListIds)) {
  337. $roomListParams = [
  338. 'ids' => $redisRoomListIds,
  339. 'type_id' => $type_id,
  340. 'is_recommend' => $is_recommend,
  341. 'all' => $all,
  342. 'start' => $start,
  343. 'end' => $end,
  344. 'index' => $index,
  345. ];
  346. $resultInfo = $roomService->getRoomList($roomListParams);
  347. if (!$resultInfo['status']) {
  348. throw new Exception($resultInfo['msg']);
  349. }
  350. }
  351. $this->success("获取成功!",$resultInfo['data']);
  352. } catch (Exception $e) {;
  353. $this->error($e->getMessage());
  354. }
  355. }
  356. /**
  357. * 获取派对用户排序
  358. */
  359. public function getPartyUserRank() {
  360. $room_type = $this->request->request('room_type',1); // 房间类型
  361. $party_id = $this->request->request("party_id");// 派对ID
  362. if (!$party_id) $this->error(__('Invalid parameters'));
  363. $redis = new Redis();
  364. $redisconfig = config("redis");
  365. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  366. if ($redisconfig['redis_pwd']) {
  367. $redis->auth($redisconfig['redis_pwd']);
  368. }
  369. if($redisconfig['redis_selectdb'] > 0){
  370. $redis->select($redisconfig['redis_selectdb']);
  371. }
  372. $res = [];
  373. // 获取今天
  374. $day = date("Ymd");
  375. // 获取本周第一天
  376. $weekday = $this->firstOfWeek(date("Y-m-d H:i:s"));
  377. // 获取本月第一天
  378. $monthday = date("Ym01");
  379. $userModel = new \app\common\model\User();
  380. // 获取条数
  381. $num = 50;
  382. // 获取50条财富排行日记录
  383. $getday = $redis->zRevRange($this->roomTypeArr[$room_type]."_jewel_get_".$party_id.":".$day."d",0,$num-1,true);
  384. $res['getRankListDay'] = $userModel->rankList($getday);
  385. // 获取50条财富排行日记录
  386. $today = $redis->zRevRange($this->roomTypeArr[$room_type]."_jewel_to_".$party_id.":".$day."d",0,$num-1,true);
  387. $res['toRankListDay'] = $userModel->rankList($today);
  388. // 获取50条财富排行周记录
  389. $getweek = $redis->zRevRange($this->roomTypeArr[$room_type]."_jewel_get_".$party_id.":".$weekday."w",0,$num-1,true);
  390. $res['getRankListWeek'] = $userModel->rankList($getweek);
  391. // 获取50条贡献排行周记录
  392. $toweek = $redis->zRevRange($this->roomTypeArr[$room_type]."_jewel_to_".$party_id.":".$weekday."w",0,$num-1,true);
  393. $res['toRankListWeek'] = $userModel->rankList($toweek);
  394. // 获取50条财富排行月记录
  395. $toweek = $redis->zRevRange($this->roomTypeArr[$room_type]."_jewel_get_".$party_id.":".$monthday."m",0,$num-1,true);
  396. $res['getRankListMonth'] = $userModel->rankList($toweek);
  397. // 获取50条贡献排行周记录
  398. $toweek = $redis->zRevRange($this->roomTypeArr[$room_type]."_jewel_to_".$party_id.":".$monthday."m",0,$num-1,true);
  399. $res['toRankListMonth'] = $userModel->rankList($toweek);
  400. return $this->success("获取成功!",$res);
  401. }
  402. /**
  403. * 派对热度更新(已废弃)
  404. */
  405. public function changeUserPartyhot() {
  406. $party_id = $this->request->request('party_id',0,"intval"); // 派对ID
  407. $room_type = $this->request->request('room_type',1); // 房间类型
  408. $party_hot = $this->request->request('party_hot'); // 房间热度(正数表示提高的热度值,负数表示降低的热度值)
  409. if (!$party_id || !$party_hot) {
  410. $this->error(__('Invalid parameters'));
  411. }
  412. $redis = new Redis();
  413. $redisconfig = config("redis");
  414. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  415. if ($redisconfig['redis_pwd']) {
  416. $redis->auth($redisconfig['redis_pwd']);
  417. }
  418. if($redisconfig['redis_selectdb'] > 0){
  419. $redis->select($redisconfig['redis_selectdb']);
  420. }
  421. // 更新热度
  422. $redis->zIncrBy($this->roomTypeArr[$room_type]."Rank", $party_hot, $party_id);
  423. return $this->success("更新成功!");
  424. }
  425. /**
  426. * 更新主持人和麦位前四位至首页房间排行
  427. */
  428. public function addUserPositionToParty() {
  429. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  430. $user_id = $this->request->request('user_id',0,"intval"); // 用户ID
  431. $upOrdown = $this->request->request('upordown'); // 上下麦:1=上麦-1=下麦
  432. $room_type = $this->request->request('room_type',1); // 房间类型
  433. $avatar = $this->request->request('avatar'); // 用户头像 (upOrdown参数为-1时可以不传)
  434. $position = $this->request->request('position'); // 麦位置:0=支持人,1=1号麦,2=2号麦,3=3号麦,4=4号麦
  435. if (!$party_id || !$user_id || !in_array($position,[0,1,2,3,4,5,6,7,8]) || !in_array($upOrdown,[1,-1])) {
  436. $this->error(__('Invalid parameters'));
  437. }
  438. if($upOrdown == 1) {
  439. // 先完成所有麦上记录
  440. \app\common\model\UserOnsiteTime::update(["status"=>2],["user_id"=>$user_id]);
  441. // 保存上麦记录
  442. $data = [];
  443. $data["user_id"] = $user_id;
  444. $data["party_id"] = $party_id;
  445. $data["onsite_time"] = time();
  446. \app\common\model\UserOnsiteTime::insert($data);
  447. }
  448. if($upOrdown == -1) {
  449. // 更新下麦时间
  450. $update = [];
  451. $update["offsite_time"] = time();
  452. $update["status"] = 2;
  453. \app\common\model\UserOnsiteTime::update($update,["user_id"=>$user_id,"status"=>1]);
  454. }
  455. if(in_array($position,[5,6,7,8])) return $this->success("设置成功!");
  456. $redis = new Redis();
  457. $redisconfig = config("redis");
  458. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  459. if ($redisconfig['redis_pwd']) {
  460. $redis->auth($redisconfig['redis_pwd']);
  461. }
  462. if($redisconfig['redis_selectdb'] > 0){
  463. $redis->select($redisconfig['redis_selectdb']);
  464. }
  465. $redisData = $redis->get($this->roomTypeArr[$room_type]."_".$party_id);
  466. if($redisData) {
  467. $partyInfo = json_decode($redisData,true);
  468. if($upOrdown == 1) {
  469. // 删掉已有头像,防止重复
  470. $partyuser = isset($partyInfo["party_user"])?$partyInfo["party_user"]:"";
  471. if(is_array($partyuser)) foreach($partyuser as $k => $v) if($v === $avatar) unset($partyInfo["party_user"][$k]);
  472. $partyInfo["party_user"][$position] = $avatar;
  473. } else {
  474. if(isset($partyInfo["party_user"])) unset($partyInfo["party_user"][$position]);
  475. }
  476. // sort($partyInfo["party_user"]);
  477. $redis->set($this->roomTypeArr[$room_type]."_".$party_id,json_encode($partyInfo));
  478. }
  479. return $this->success("设置成功!");
  480. }
  481. /**
  482. * 获取派对在线人数列表
  483. */
  484. public function getOnlieList() {
  485. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID 逻辑ID
  486. $page = $this->request->request('page',1); // 分页
  487. $pageNum = $this->request->request('pageNum',10); // 分页
  488. // 分页搜索构建
  489. $pageStart = ($page-1)*$pageNum;
  490. if (!$party_id) {
  491. $this->error(__('Invalid parameters'));
  492. }
  493. $redis = new Redis();
  494. $redisconfig = config("redis");
  495. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  496. if ($redisconfig['redis_pwd']) {
  497. $redis->auth($redisconfig['redis_pwd']);
  498. }
  499. if($redisconfig['redis_selectdb'] > 0){
  500. $redis->select($redisconfig['redis_selectdb']);
  501. }
  502. $res = $redis->hGetAll("online_".$party_id);
  503. $user_ids = [];$userList = [];
  504. if($res) $user_ids = array_values($res);
  505. // 获取用户列表信息
  506. $user_ids && $userList = \app\common\model\User::field("id,avatar,nickname,level,gender")->where(["id"=>["in",$user_ids]])->limit($pageStart,$pageNum)->select();
  507. $this->success("获取成功!",$userList);
  508. }
  509. /**
  510. * 加入派对
  511. */
  512. public function joinParty() {
  513. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID 逻辑ID
  514. $room_type = $this->request->request("room_type",1);//
  515. $party_pass = $this->request->request("party_pass");//
  516. if (!$party_id || !in_array($room_type,[1,2])) {
  517. $this->error(__('Invalid parameters'));
  518. }
  519. $user_id = $this->auth->id;
  520. $redis = new Redis();
  521. $redisconfig = config("redis");
  522. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  523. if ($redisconfig['redis_pwd']) {
  524. $redis->auth($redisconfig['redis_pwd']);
  525. }
  526. if($redisconfig['redis_selectdb'] > 0){
  527. $redis->select($redisconfig['redis_selectdb']);
  528. }
  529. $redis->zAdd("party_user_".$party_id,$this->auth->u_id,$user_id);
  530. // 判断当前用户是否存在在直播间通过切换过来的
  531. $livingUserPartyId = $redis->hGet("livingUser", $user_id);
  532. if ($livingUserPartyId) {
  533. if($livingUserPartyId != $party_id){
  534. // 扣除房间在线人数
  535. $redis->HDel("online_" . $livingUserPartyId, $user_id);
  536. // 扣除在线用户在房间情况
  537. $redis->hDel("livingUser", $user_id);
  538. }
  539. }
  540. // 记录在线用户在房间情况
  541. $redis->hSet("livingUser", $user_id, $party_id);
  542. // 判断当前用户是否被该房间设置限制 //项目:1=房管,2=禁言,3=拉黑,4=踢出
  543. $lsetList = [];
  544. for($i=1;$i<=4;$i++) {
  545. $hgetlist = $redis->hGet("party_manage_".$party_id,$user_id."-".$i);
  546. $hgetlist = unserialize($hgetlist);
  547. $restime = time() - intval($hgetlist["createtime"]);
  548. // 房管
  549. if($hgetlist && $i == 1) $lsetList["manage_restime"] = "";
  550. // 禁言
  551. if($hgetlist && $i == 2 && $restime < $hgetlist["time"]) $lsetList["manage_notalk"] = $restime;
  552. // 拉黑
  553. if($hgetlist && $i == 3 && $restime < $hgetlist["time"]) {
  554. $restime = date("Y-m-d H:i:s",($hgetlist["time"]+$hgetlist["createtime"]));
  555. $this->error(__('您已被该房间拉黑,解除时间:'.$restime));
  556. break;
  557. }
  558. // 踢出
  559. if($hgetlist && $i == 4 && $restime < $hgetlist["time"]) {
  560. $restime = date("Y-m-d H:i:s",($hgetlist["time"]+$hgetlist["createtime"]));
  561. $this->error(__('您已被该房间踢出,解除时间:'.$restime));
  562. break;
  563. }
  564. }
  565. // 判断派对密码
  566. $partyInfo = $redis->get($this->roomTypeArr[$room_type]."_".$party_id);
  567. if($partyInfo) {
  568. $partyInfo = json_decode($partyInfo,true);
  569. if($partyInfo["is_close"] == 1) $this->error("该房间已被关闭!");
  570. if($partyInfo["status"] != 1) $this->error("该房间为预创建房间,请联系管理员正式开通!");
  571. if(isset($partyInfo["party_pass"]) && $partyInfo["party_pass"] && $partyInfo["user_id"] != $user_id) {
  572. if(($party_pass != $partyInfo["party_pass"] || strlen($party_pass) != 4) && $this->auth->id != 4) {
  573. $this->error("派对密码不正确!");
  574. }
  575. }
  576. // 公会管理员和工会长激活派对厅
  577. $guildInfo = \app\common\model\Guild::where(['user_id' => $partyInfo['user_id'], 'status' => 1])->find();
  578. if ($guildInfo) {
  579. // 获取公会管理员
  580. $guildMemberInfo = \app\common\model\GuildMember::where(["user_id" => $user_id, "guild_id" => $guildInfo['id'], 'status' => 1])->find();
  581. if ($guildMemberInfo && $guildMemberInfo['role'] == 0) {
  582. $this->error("当前直播已结束!");
  583. }
  584. }
  585. // // 如果是房主自己进入房间,则更新用户 为在线状态
  586. // if ($partyInfo["user_id"] == $user_id) {
  587. // if ($room_type == 2)
  588. // \app\common\model\User::update(["is_live" => 1], ["id" => $partyInfo["user_id"]]);
  589. // }
  590. } else {
  591. $this->error("派对信息获取失败!");
  592. }
  593. // 获取用户魅力值
  594. $users = $redis->zRange("hourCharm_".$party_id,0,-1,true);
  595. $u = [];
  596. if($users) {
  597. foreach($users as $k => $v) $u[] = [
  598. "user_id"=>$k,
  599. "charm"=>$this->changeW($v)
  600. ];
  601. }
  602. $lsetList["userCharm"] = $u;
  603. // 获取用户排行榜前三名头像
  604. $heads = $redis->hGet("user_jewel_top3",$party_id);
  605. $lsetList["userJewelTop3"] = $heads?json_decode($heads,true):[];
  606. // 判断当前用户是否收藏了此房间
  607. $cellection = $redis->hGet("room_cellection",$user_id."-".$party_id);
  608. $lsetList["is_cellection"] = $cellection?1:0;
  609. if(isset($partyInfo["type_name"]) && $partyInfo["type_name"]) {
  610. // $partyInfo["type_name"] = $partyInfo["type_name"];
  611. } else {
  612. $partyInfo["type_name"] = "普通房";
  613. }
  614. $partyInfo["party_hot"] = $this->changeW($partyInfo["party_hot"]);
  615. $lsetList["partyInfo"] = $partyInfo;
  616. return $this->success("加入成功!",$lsetList);
  617. }
  618. /**
  619. * 判断是否被禁言
  620. */
  621. public function isNotalk() {
  622. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID 逻辑ID
  623. $user_id = $this->request->request('user_id',0,"intval"); // 用户ID 逻辑ID
  624. if (!$user_id || !$party_id) {
  625. $this->error(__('Invalid parameters'));
  626. }
  627. $redis = new Redis();
  628. $redisconfig = config("redis");
  629. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  630. if ($redisconfig['redis_pwd']) {
  631. $redis->auth($redisconfig['redis_pwd']);
  632. }
  633. if($redisconfig['redis_selectdb'] > 0){
  634. $redis->select($redisconfig['redis_selectdb']);
  635. }
  636. // 判断当前用户是否被该房间设置限制 //项目:1=房管,2=禁言,3=拉黑,4=踢出
  637. $lsetList = [];
  638. $lsetList["is_notalk"] = 0;
  639. $lsetList["notalk_time"] = 0;
  640. $hgetlist = $redis->hGet("party_manage_".$party_id,$user_id."-2");
  641. $hgetlist = unserialize($hgetlist);
  642. $restime = time() - intval($hgetlist["createtime"]);
  643. // 禁言
  644. if($hgetlist && $restime < $hgetlist["time"]) {
  645. $lsetList["is_notalk"] = 1;
  646. $lsetList["notalk_time"] = $restime;
  647. }
  648. return $this->success("获取成功!",$lsetList);
  649. }
  650. /**
  651. * 退出派对
  652. */
  653. public function outParty() {
  654. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  655. if (!$party_id) {
  656. $this->error(__('Invalid parameters'));
  657. }
  658. $user_u_id = $this->auth->u_id;
  659. $redis = new Redis();
  660. $redisconfig = config("redis");
  661. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  662. if ($redisconfig['redis_pwd']) {
  663. $redis->auth($redisconfig['redis_pwd']);
  664. }
  665. if($redisconfig['redis_selectdb'] > 0){
  666. $redis->select($redisconfig['redis_selectdb']);
  667. }
  668. $redis->zRem("party_user_".$party_id,$user_u_id);
  669. // 处理online_party_id
  670. //$redis->connect($redisconfig["host"], $redisconfig["port"]);
  671. $redis->HDel("online_" . $party_id, $this->auth->id);
  672. // 扣除在线用户在房间情况
  673. $redis->hDel("livingUser", $this->auth->id);
  674. // 更新房间在线状态
  675. $partyInfo = $redis->get("party_" . $party_id);
  676. if ($partyInfo) {
  677. $partyInfo = json_decode($partyInfo, true);
  678. $memCount = count($redis->hGetAll("online_" . $party_id));
  679. if ($memCount <= 0) {
  680. $partyInfo["is_online"] = 0;
  681. $redis->set("party_" . $party_id, json_encode($partyInfo));
  682. \app\common\model\Party::update(["is_online" => 0], ["id" => $party_id]);
  683. }
  684. }
  685. $liveInfo = $redis->get("live_" . $party_id);
  686. if ($liveInfo) {
  687. $liveInfo = json_decode($liveInfo, true);
  688. $memCount = count($redis->hGetAll("online_" . $party_id));
  689. if ($memCount <= 0) {
  690. $liveInfo["is_online"] = 0;
  691. $redis->set("live_" . $party_id, json_encode($liveInfo));
  692. \app\common\model\Party::update(["is_online" => 0], ["id" => $party_id]);
  693. }
  694. }
  695. return $this->success("退出成功!",[]);
  696. }
  697. /**
  698. * 派对内搜索用户
  699. */
  700. public function searchUserParty() {
  701. $u_id = $this->request->request('u_id',0,"intval"); // 用户u_id
  702. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  703. // $redis = new Redis();
  704. // $redisconfig = config("redis");
  705. // $redis->connect($redisconfig["host"], $redisconfig["port"]);
  706. /*if ($redisconfig['redis_pwd']) {
  707. $redis->auth($redisconfig['redis_pwd']);
  708. }
  709. if($redisconfig['redis_selectdb'] > 0){
  710. $redis->select($redisconfig['redis_selectdb']);
  711. }*/
  712. // $userids = $redis->zRange("party_user_".$party_id,0,-1,true);
  713. // $useridArr = [];
  714. // if($userids)foreach($userids as $k => $v) $useridArr[$v] = $k; // 因为array_slip 不能交换数字啊
  715. // $userid = isset($useridArr[$u_id])?$useridArr[$u_id]:0;
  716. $userModel = new \app\common\model\User();
  717. $where = [];
  718. $where["u_id"] = $u_id;
  719. $userInfo = $userModel->field("id,u_id,avatar,nickname,level,gender")->where($where)->select();
  720. return $this->success("查询成功!",$userInfo);
  721. }
  722. /**
  723. * 设置冠名
  724. */
  725. public function setNaming() {
  726. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  727. $user_id = $this->request->request('user_id',0,"intval"); // 用户ID
  728. $type = $this->request->request('type',1); // 1:设置 0:取消设置
  729. if (!$party_id || !$user_id || ($type != 1 && $type != 0)) {
  730. $this->error(__('Invalid parameters'));
  731. }
  732. $redis = new Redis();
  733. $redisconfig = config("redis");
  734. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  735. if ($redisconfig['redis_pwd']) {
  736. $redis->auth($redisconfig['redis_pwd']);
  737. }
  738. if($redisconfig['redis_selectdb'] > 0){
  739. $redis->select($redisconfig['redis_selectdb']);
  740. }
  741. $partyModel = new \app\common\model\Party();
  742. $data = [];
  743. $where = [];
  744. $where["id"] = $party_id;
  745. $partyInfo = $partyModel->where(["id"=>$party_id])->find();
  746. $getredisPartyInfo = $redis->get($this->roomTypeArr[$partyInfo->room_type].'_'.$party_id);
  747. $redisPartyInfo = json_decode($getredisPartyInfo,true);
  748. if($type == 1) {
  749. $data["naming"] = $user_id;
  750. // 冠名
  751. $userInfo = \app\common\model\User::field("id,nickname,avatar")->where(["id"=>$user_id])->find($user_id);
  752. $redisPartyInfo["naming"] = $userInfo;
  753. } else {
  754. $data["naming"] = 0;
  755. $redisPartyInfo["naming"] = [];
  756. }
  757. $redis->set($this->roomTypeArr[$partyInfo->room_type].'_'.$party_id,json_encode($redisPartyInfo));
  758. $res = $partyModel->update($data,$where);
  759. if($res !== false) {
  760. $this->success("操作成功!");
  761. } else {
  762. $this->error("网络错误,请稍后重试!");
  763. }
  764. }
  765. /**
  766. * 派对收藏
  767. */
  768. public function cellectionParty() {
  769. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  770. if (!$party_id) {
  771. $this->error(__('Invalid parameters'));
  772. }
  773. $user_id = $this->auth->id;
  774. $redis = new Redis();
  775. $redisconfig = config("redis");
  776. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  777. if ($redisconfig['redis_pwd']) {
  778. $redis->auth($redisconfig['redis_pwd']);
  779. }
  780. if($redisconfig['redis_selectdb'] > 0){
  781. $redis->select($redisconfig['redis_selectdb']);
  782. }
  783. $partycellectionModel = new \app\common\model\PartyCellection();
  784. // 添加记录
  785. $data = [];
  786. $data["user_id"] = $user_id;
  787. $data["party_id"] = $party_id;
  788. if($partycellectionModel->where($data)->find()) {
  789. $res = $partycellectionModel->where($data)->delete();
  790. $redis->hDel("room_cellection",$user_id."-".$party_id);
  791. return $this->success("取消收藏成功!",$res);
  792. }
  793. $data["createtime"] = time();
  794. $res = $partycellectionModel->insert($data);
  795. $redis->hSet("room_cellection",$user_id."-".$party_id,1);
  796. return $this->success("收藏成功!",$res);
  797. }
  798. /**
  799. * 派对收藏列表
  800. */
  801. public function cellectionPartyList() {
  802. $page = $this->request->request('page',1); // 分页
  803. $pageNum = $this->request->request('pageNum',10); // 分页
  804. // 分页搜索构建
  805. $pageStart = ($page-1)*$pageNum;
  806. $partycellectionModel = new \app\common\model\PartyCellection();
  807. $userModel = new \app\common\model\User();
  808. $where = [];
  809. $where["a.user_id"] = $this->auth->id;
  810. $where["r.room_type"] = 1;
  811. $list = $partycellectionModel->alias("a")
  812. ->field("a.party_id,r.party_logo,r.party_hot,r.party_id as r_id,r.party_name,t.id as party_type_id,t.name as party_type")
  813. ->where($where)
  814. ->join("hx_party r","a.party_id = r.id")
  815. ->join("hx_party_type t","t.id = r.party_type","left")
  816. ->limit($pageStart,$pageNum)
  817. ->select();
  818. if($list) {
  819. // $redis = new Redis();
  820. // $redisconfig = config("redis");
  821. // $redis->connect($redisconfig["host"], $redisconfig["port"]);
  822. /*if ($redisconfig['redis_pwd']) {
  823. $redis->auth($redisconfig['redis_pwd']);
  824. }
  825. if($redisconfig['redis_selectdb'] > 0){
  826. $redis->select($redisconfig['redis_selectdb']);
  827. }*/
  828. // // 获取本周第一天
  829. // $weekday = $this->firstOfWeek(date("Y-m-d H:i:s"));
  830. // // 获取redis 中 用户排行榜前五名
  831. // foreach($list as $k => $v) {
  832. // $getweek = $redis->zRevRange("party_jewel_get_".$v["r_id"].":".$weekday,0,4,true);
  833. // $userlist = $userModel->rankList($getweek);
  834. // if($userlist) {
  835. // $users = [];
  836. // foreach($userlist as $m => $n) {
  837. // $users[] = $n["avatar"];
  838. // }
  839. // $list[$k]["users"] = $users;
  840. // } else {
  841. // $list[$k]["users"] = [];
  842. // }
  843. //
  844. // $mod = isset($v["party_type_id"])?intval($v["party_type_id"])%5:1;
  845. // $list[$k]["party_type_color"] = $mod == 0?5:$mod;
  846. // }
  847. $users = [];
  848. foreach($list as $k => $v) {
  849. $users[$v["party_id"]] = $v["party_hot"];
  850. }
  851. $partyModel = new \app\common\model\Party();
  852. $resultInfo = $partyModel->getPatyInfoByPartyId($users,"party",0,0,1,0,20,0);
  853. $this->success("获取成功!",$resultInfo);
  854. }
  855. return $this->success("获取成功!",$list);
  856. }
  857. /**
  858. * 获取派对信息
  859. */
  860. public function getPartyInfo() {
  861. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  862. if (!$party_id) {
  863. $this->error(__('Invalid parameters'));
  864. }
  865. $user_id = $this->auth->id;
  866. $partyModel = new \app\common\model\Party();
  867. $partycellectionModel = new \app\common\model\PartyCellection();
  868. $userModel = new \app\common\model\User();
  869. // 获取主体信息
  870. $where = [];
  871. $where["a.id"] = $party_id;
  872. $partyInfo = $partyModel->alias("a")
  873. ->field("a.id,a.user_id,a.party_id,a.party_name,a.party_hot,a.party_logo,rt.id as party_type,rt.name as type_name,a.party_notice,a.party_notice_detail")
  874. ->join("hx_party_type rt","rt.id = a.party_type", "left")
  875. ->where($where)
  876. ->find();
  877. if($partyInfo) {
  878. $mod = isset($partyInfo["party_type"])?intval($partyInfo["party_type"])%5:1;
  879. $partyInfo["party_type_color"] = $mod == 0?5:$mod;
  880. if(isset($partyInfo["type_name"]) && $partyInfo["type_name"]) {
  881. // $partyInfo["type_name"] = $partyInfo["type_name"];
  882. } else {
  883. $partyInfo["type_name"] = "普通房";
  884. }
  885. // 获取是否被当前用户收藏
  886. $partyInfo["is_sellection"] = 0;
  887. $where = [];
  888. $where["user_id"] = $user_id;
  889. $where["party_id"] = $party_id;
  890. if($partycellectionModel->where($where)->find()) {
  891. $partyInfo["is_sellection"] = 1;
  892. }
  893. // 获取房主信息
  894. $where = [];
  895. $where["id"] = $partyInfo["user_id"];
  896. $userInfo = $userModel->field("avatar,nickname")->where($where)->find();
  897. // 获取技能信息
  898. $skillList = Model("ViewUserSkill")->getSkillInfo($partyInfo["user_id"]);
  899. $userInfo["skill"] = implode("/",$skillList);
  900. $partyInfo["userInfo"] = $userInfo;
  901. $partyInfo["party_hot"] = $this->changeW($partyInfo["party_hot"]);
  902. }
  903. $this->success("获取成功!",$partyInfo);
  904. }
  905. /**
  906. * 派对设置
  907. */
  908. public function setParty() {
  909. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  910. $party_name = $this->request->request('party_name'); // 派对名称
  911. $party_logo = $this->request->request('party_logo'); // 派对logo/封面
  912. $party_pass = $this->request->request('party_pass'); // 派对密码
  913. $party_type = $this->request->request('party_type'); // 使用场景
  914. $is_screen = $this->request->request('is_screen'); // 是否关闭公屏:1=是,0=否
  915. $on_model = $this->request->request('on_model'); // 上麦模式:1=自由模式,2=麦序模式
  916. $room_type = $this->request->request('room_type',1); // 房间类型:1=派对,2=直播
  917. $background = $this->request->request('background'); // 派对背景
  918. if (!$party_id || (!$party_name && !$party_logo && !$party_pass && !$party_type && !$is_screen && !$on_model && !$background)) {
  919. $this->error(__('Invalid parameters'));
  920. }
  921. if($party_pass && strlen($party_pass) != 4) {
  922. $this->error("房间密码必须为四位!");
  923. }
  924. $partyModel = new \app\common\model\Party();
  925. $data = [];
  926. $party_name && $data["party_name"] = $party_name;
  927. $party_logo && $data["party_logo"] = $party_logo;
  928. $data["party_pass"] = $party_pass;
  929. $party_type && $data["party_type"] = $party_type;
  930. $is_screen && $data["is_screen"] = $is_screen;
  931. $on_model && $data["on_model"] = $on_model;
  932. $background && $data["background"] = $background;
  933. $where = [];
  934. $where["id"] = $party_id;
  935. $res = $partyModel->update($data,$where);
  936. if($res) {
  937. // 获取派对类型
  938. if($party_type) $data["type_name"] = \app\common\model\PartyType::where(["id"=>$party_type])->value("name");
  939. // 存redis 房间信息
  940. $redis = new Redis();
  941. $redisconfig = config("redis");
  942. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  943. if ($redisconfig['redis_pwd']) {
  944. $redis->auth($redisconfig['redis_pwd']);
  945. }
  946. if($redisconfig['redis_selectdb'] > 0){
  947. $redis->select($redisconfig['redis_selectdb']);
  948. }
  949. $partyInfo = $redis->get($this->roomTypeArr[$room_type]."_".$party_id);
  950. if($partyInfo) {
  951. $partyInfo = json_decode($partyInfo,true);
  952. $partyInfo = array_replace($partyInfo,$data);
  953. $redis->set($this->roomTypeArr[$room_type]."_".$party_id,json_encode($partyInfo));
  954. }
  955. $this->success("房间设置成功!",$data);
  956. } else {
  957. $this->error("网络错误,请稍后重试!");
  958. }
  959. }
  960. /**
  961. * 获取派对背景
  962. */
  963. public function getDefaultBackground() {
  964. $room_type = $this->request->request('room_type',1); // 房间类型
  965. if (!in_array($room_type,[1,2])) {
  966. $this->error(__('Invalid parameters'));
  967. }
  968. $this->success("获取成功!",\app\common\model\PartyBackground::where(["room_type"=>$room_type])->select());
  969. }
  970. /**
  971. * 派对管理设置
  972. */
  973. public function partyManageSet() {
  974. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  975. $user_id = $this->request->request('user_id',0,"intval"); // 用户ID
  976. $item = $this->request->request('item'); // 项目:1=房管,2=禁言,3=拉黑,4=踢出
  977. $time = $this->request->request('time'); // 限制时间(单位:秒):0=永久
  978. if (!$party_id || !$user_id || !in_array($item,[1,2,3,4])) {
  979. $this->error(__('Invalid parameters'));
  980. }
  981. if($item>1 && $time<=0) {
  982. $this->error(__('时间设置有误'));
  983. }
  984. $partyUserId = \app\common\model\Party::where('id', $party_id)->value('user_id');
  985. if ($partyUserId == $user_id && in_array($item, [2, 3, 4])) {
  986. $this->error("您当前无权限操作!");
  987. }
  988. // 获取用户信息
  989. $userInfo = \app\common\model\User::field("noble,avatar,nickname,gender,level")->where(["id"=>$user_id])->find();
  990. if(!$userInfo) $this->error("用户信息获取失败!");
  991. // 国王防踢。
  992. $noble_no = \app\common\model\NobleLevel::where(["id"=>$userInfo->noble])->value("level_no");
  993. if(($item == 3 || $item == 4) && $noble_no == "p08PCcNB") {
  994. $this->error("对方已开通国王贵族,踢出房间失败!");
  995. }
  996. $redis = new Redis();
  997. $redisconfig = config("redis");
  998. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  999. if ($redisconfig['redis_pwd']) {
  1000. $redis->auth($redisconfig['redis_pwd']);
  1001. }
  1002. if($redisconfig['redis_selectdb'] > 0){
  1003. $redis->select($redisconfig['redis_selectdb']);
  1004. }
  1005. $data = [];
  1006. $data["user_id"] = $user_id;
  1007. $data["avatar"] = $userInfo->avatar;
  1008. $data["nickname"] = $userInfo->nickname;
  1009. $data["gender"] = $userInfo->gender;
  1010. $data["level"] = $userInfo->level;
  1011. $data["item"] = $item;
  1012. $data["time"] = $time;
  1013. $data["createtime"] = time();
  1014. $res = $redis->hSet("party_manage_".$party_id,$user_id."-".$item,serialize($data));
  1015. if($res !== false) {
  1016. $this->success("设置成功!",$data);
  1017. } else {
  1018. $this->error("网络错误,请稍后重试!");
  1019. }
  1020. }
  1021. /**
  1022. * 派对管理设置列表
  1023. */
  1024. public function partyManageSetList() {
  1025. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  1026. $item = $this->request->request('item',1,"intval"); // 项目:1=房管,2=禁言,3=拉黑,4=踢出
  1027. if (!$party_id || !in_array($item,[1,2,3,4])) {
  1028. $this->error(__('Invalid parameters'));
  1029. }
  1030. $time = time();
  1031. $redis = new Redis();
  1032. $redisconfig = config("redis");
  1033. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1034. if ($redisconfig['redis_pwd']) {
  1035. $redis->auth($redisconfig['redis_pwd']);
  1036. }
  1037. if($redisconfig['redis_selectdb'] > 0){
  1038. $redis->select($redisconfig['redis_selectdb']);
  1039. }
  1040. $hget=$redis->hGetAll("party_manage_".$party_id);
  1041. $list=array();
  1042. foreach($hget as $key=>$val) {
  1043. if(substr($key,-2) == "-".$item){
  1044. array_push($list,unserialize($val));
  1045. }
  1046. }
  1047. if($list) {
  1048. foreach($list as $k => $v) if(bcadd($v["createtime"],$v["time"]) <= $time && $v["item"] > 1) unset($list[$k]);
  1049. if($list) $list = array_values($list);
  1050. }
  1051. $this->success("获取成功!",$list);
  1052. }
  1053. /**
  1054. * 派对管理设置移除
  1055. */
  1056. public function partyManageSetDel() {
  1057. $id = $this->request->request('user_id',0,"intval"); // userid
  1058. $party_id = $this->request->request('party_id',0,"intval"); // 房间ID
  1059. $item = $this->request->request('item',1,"intval"); // 项目:1=房管,2=禁言,3=拉黑,4=踢出
  1060. if (!$id || !in_array($item,[1,2,3,4])) {
  1061. $this->error(__('Invalid parameters'));
  1062. }
  1063. $redis = new Redis();
  1064. $redisconfig = config("redis");
  1065. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1066. if ($redisconfig['redis_pwd']) {
  1067. $redis->auth($redisconfig['redis_pwd']);
  1068. }
  1069. if($redisconfig['redis_selectdb'] > 0){
  1070. $redis->select($redisconfig['redis_selectdb']);
  1071. }
  1072. $res = $redis->hDel("party_manage_".$party_id,$id."-".$item);
  1073. if($res !== false) {
  1074. $this->success("移除成功!",$res);
  1075. } else {
  1076. $this->error("网络错误,请稍后重试!");
  1077. }
  1078. }
  1079. /**
  1080. * 更新派对公告
  1081. */
  1082. public function savePartyNotice() {
  1083. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  1084. $room_type = $this->request->request('room_type',1); // 房间类型:1=派对2=直播
  1085. $party_notice = $this->request->request('party_notice'); // 公告标题
  1086. $party_notice_detail = $this->request->request('party_notice_detail'); // 公告内容
  1087. if (!$party_id || !$party_notice || !$party_notice_detail) {
  1088. $this->error(__('Invalid parameters'));
  1089. }
  1090. $partyModel = new \app\common\model\Party();
  1091. $where = [];
  1092. $where["id"] = $party_id;
  1093. $data = [];
  1094. $data["party_notice"] = $party_notice;
  1095. $data["party_notice_detail"] = $party_notice_detail;
  1096. $res = $partyModel->update($data,$where);
  1097. if($res) {
  1098. // 存redis 房间信息
  1099. $redis = new Redis();
  1100. $redisconfig = config("redis");
  1101. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1102. if ($redisconfig['redis_pwd']) {
  1103. $redis->auth($redisconfig['redis_pwd']);
  1104. }
  1105. if($redisconfig['redis_selectdb'] > 0){
  1106. $redis->select($redisconfig['redis_selectdb']);
  1107. }
  1108. $partyInfo = $redis->get($this->roomTypeArr[$room_type]."_".$party_id);
  1109. if($partyInfo) {
  1110. $partyInfo = json_decode($partyInfo,true);
  1111. $partyInfo = array_replace($partyInfo,$data);
  1112. $redis->set($this->roomTypeArr[$room_type]."_".$party_id,json_encode($partyInfo));
  1113. }
  1114. $this->success("更新成功!",$res);
  1115. } else {
  1116. $this->error("网络错误,请稍后重试!");
  1117. }
  1118. }
  1119. /**
  1120. * 开始排麦
  1121. */
  1122. public function addLineUp() {
  1123. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  1124. $mai_id = $this->request->request('mai_id',"1"); // 麦位置
  1125. if (!$party_id) {
  1126. $this->error(__('Invalid parameters'));
  1127. }
  1128. $userInfo = $this->auth->getUserinfo();
  1129. $userid = $userInfo['id'];
  1130. // 获取 房间信息
  1131. $partyUser = \app\common\model\Party::where(['id'=>$party_id])->value("user_id");
  1132. if(!$partyUser) $this->error(__('房间信息未找到!'));
  1133. // $is_home = $partyUser == $userInfo->id?1:0;
  1134. $redis = new Redis();
  1135. $redisconfig = config("redis");
  1136. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1137. if ($redisconfig['redis_pwd']) {
  1138. $redis->auth($redisconfig['redis_pwd']);
  1139. }
  1140. if($redisconfig['redis_selectdb'] > 0){
  1141. $redis->select($redisconfig['redis_selectdb']);
  1142. }
  1143. $data = unserialize($redis->hGet("party_lineup",$party_id));
  1144. $data[$userid]["user_id"] = $userInfo['id'];
  1145. $data[$userid]["avatar"] = $userInfo['avatar'];
  1146. $data[$userid]["mai_id"] = $mai_id;
  1147. $data[$userid]["nickname"] = $userInfo['nickname'];
  1148. // $data["is_home"] = $is_home;
  1149. $data[$userid]["level"] = $userInfo['level'];
  1150. $data[$userid]["gender"] = $userInfo['gender'];
  1151. $res = false;
  1152. $data && $res = $redis->hSet("party_lineup",$party_id,serialize($data));
  1153. $data = array_values($data);
  1154. if($res !== false) {
  1155. $this->success("设置成功!",$data);
  1156. } else {
  1157. $this->error("网络错误,请稍后重试!");
  1158. }
  1159. }
  1160. /**
  1161. * 取消排麦
  1162. */
  1163. public function cancelLineUp() {
  1164. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  1165. $user_id = $this->request->request('user_id',0); // 直播间ID
  1166. $is_empty = $this->request->request('is_empty',0,"intval"); // 是否清空排麦列表 1=清空,0=不清空
  1167. if (!$party_id) {
  1168. $this->error(__('Invalid parameters'));
  1169. }
  1170. $userid = $this->auth->id;
  1171. $redis = new Redis();
  1172. $redisconfig = config("redis");
  1173. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1174. if ($redisconfig['redis_pwd']) {
  1175. $redis->auth($redisconfig['redis_pwd']);
  1176. }
  1177. if($redisconfig['redis_selectdb'] > 0){
  1178. $redis->select($redisconfig['redis_selectdb']);
  1179. }
  1180. $data=unserialize($redis->hGet("party_lineup",$party_id));
  1181. if($data && $is_empty != 1) {
  1182. foreach($data as $k => $v) {
  1183. if($v["user_id"] == $user_id) {
  1184. unset($data[$k]);
  1185. break;
  1186. }
  1187. }
  1188. }
  1189. // unset($data[$userid]);
  1190. if($is_empty == 1) $data = [];
  1191. $redis->hSet("party_lineup",$party_id,serialize($data));
  1192. $this->success("移除成功!");
  1193. }
  1194. /**
  1195. * 排麦列表
  1196. */
  1197. public function lineUpList() {
  1198. $party_id = $this->request->request('party_id',0,"intval"); // 直播间ID
  1199. if (!$party_id) {
  1200. $this->error(__('Invalid parameters'));
  1201. }
  1202. $redis = new Redis();
  1203. $redisconfig = config("redis");
  1204. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1205. if ($redisconfig['redis_pwd']) {
  1206. $redis->auth($redisconfig['redis_pwd']);
  1207. }
  1208. if($redisconfig['redis_selectdb'] > 0){
  1209. $redis->select($redisconfig['redis_selectdb']);
  1210. }
  1211. $data = $redis->hGet("party_lineup",$party_id);
  1212. $dataArr = unserialize($data);
  1213. $datas = [];
  1214. is_array($dataArr) && $datas=array_values($dataArr);
  1215. if($datas) {
  1216. $this->success("获取成功!",$datas);
  1217. } else {
  1218. $this->success("获取成功!",[]);
  1219. }
  1220. }
  1221. /**
  1222. * 获取派对类型
  1223. */
  1224. public function getPatyType() {
  1225. $room_type = $this->request->request("room_type",1);//
  1226. if (!in_array($room_type,[1,2])) $this->error(__('Invalid parameters'));
  1227. $partytypeModel = new \app\common\model\PartyType();
  1228. $partytypeList = $partytypeModel->where(["room_type"=>$room_type])->select();
  1229. $this->success("获取成功!",$partytypeList);
  1230. }
  1231. /**
  1232. * 判断派对是否设置过密码
  1233. */
  1234. public function getPatyIspass() {
  1235. $party_id = $this->request->request("party_id");// 派对ID
  1236. $room_type = $this->request->request("room_type",1);//
  1237. $is_miniprogram = $this->request->request("is_miniprogram",0);//
  1238. if (!$party_id) $this->error(__('Invalid parameters'));
  1239. $user_id = $this->auth->id;
  1240. // 存redis 房间信息
  1241. $redis = new Redis();
  1242. $redisconfig = config("redis");
  1243. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1244. if ($redisconfig['redis_pwd']) {
  1245. $redis->auth($redisconfig['redis_pwd']);
  1246. }
  1247. if($redisconfig['redis_selectdb'] > 0){
  1248. $redis->select($redisconfig['redis_selectdb']);
  1249. }
  1250. $partyInfo = $redis->get($this->roomTypeArr[$room_type]."_".$party_id);
  1251. if($partyInfo) {
  1252. $partyInfo = json_decode($partyInfo,true);
  1253. } else {
  1254. $partyModel = new \app\common\model\Party();
  1255. $partyInfo = $partyModel->field("id,user_id,party_pass")->where(["id"=>$party_id])->find();
  1256. if(!$partyInfo) {
  1257. $this->error(__('房间信息获取失败!'));
  1258. }
  1259. }
  1260. $data = [];
  1261. $data["status"] = 0;
  1262. $data["is_pass"] = $partyInfo["party_pass"]?1:0;
  1263. if($partyInfo["user_id"] == $user_id || $this->auth->mobile == '17353993050') $data["is_pass"] = 0;
  1264. if($is_miniprogram == 1) { // 小程序单独处理
  1265. // 判断当前用户是否被该房间设置限制 //项目:1=房管,2=禁言,3=拉黑,4=踢出
  1266. $lsetList = [];
  1267. for($i=1;$i<=4;$i++) {
  1268. $hgetlist = $redis->hGet("party_manage_".$party_id,$user_id."-".$i);
  1269. $hgetlist = unserialize($hgetlist);
  1270. $restime = time() - intval($hgetlist["createtime"]);
  1271. // 房管
  1272. if($hgetlist && $i == 1) $lsetList["manage_restime"] = "";
  1273. // 禁言
  1274. if($hgetlist && $i == 2 && $restime < $hgetlist["time"]) $lsetList["manage_notalk"] = $restime;
  1275. // 拉黑
  1276. if($hgetlist && $i == 3 && $restime < $hgetlist["time"]) {
  1277. $restime = date("Y-m-d H:i:s",($hgetlist["time"]+$hgetlist["createtime"]));
  1278. $lsetList["manage_black"] = $restime;
  1279. $lsetList["tips"] = '您已被该房间拉黑,解除时间:'.$restime;
  1280. // $this->error(__('您已被该房间拉黑,解除时间:'.$restime));
  1281. break;
  1282. }
  1283. // 踢出
  1284. if($hgetlist && $i == 4 && $restime < $hgetlist["time"]) {
  1285. $restime = date("Y-m-d H:i:s",($hgetlist["time"]+$hgetlist["createtime"]));
  1286. $lsetList["manage_takeout"] = $restime;
  1287. $lsetList["tips"] = '您已被该房间踢出,解除时间:'.$restime;
  1288. // $this->error(__('您已被该房间踢出,解除时间:'.$restime));
  1289. break;
  1290. }
  1291. }
  1292. if($lsetList) {
  1293. $data["status"] = 1;
  1294. $data["hgetlist"] = $lsetList;
  1295. }
  1296. }
  1297. $this->success("获取成功!",$data);
  1298. }
  1299. /**
  1300. * 获取房间gif表情列表
  1301. */
  1302. public function getPartGifList() {
  1303. $this->success("获取成功!",\app\common\model\PartyGif::field("id,gif_image")->order("weight","asc")->select());
  1304. }
  1305. /**
  1306. * 获取房间头像gif表情列表
  1307. */
  1308. public function getPartHeadgifList() {
  1309. $this->success("获取成功!",\app\common\model\PartyHeadgif::field("id,name,gif_image")->order("weight","asc")->select());
  1310. }
  1311. /**
  1312. * 随机获取礼物盒礼物
  1313. */
  1314. private function getBoxGift($gift_box_type) {
  1315. // 查询本奖池内礼物是否还有可抽礼物
  1316. $where = [];
  1317. $where["Jackpot_id"] = $gift_box_type;
  1318. $where["is_use"] = 0;
  1319. $boxhasgift = \app\common\model\GiftBox::where($where)->select();
  1320. $giftcount = count($boxhasgift);
  1321. $giftArr = [];
  1322. foreach($boxhasgift as $k => $v) $giftArr[$v["id"]] = $v;
  1323. if($giftcount > 1) {
  1324. // 随机抽取$num个礼物
  1325. $giftids = array_rand($giftArr,1);
  1326. \app\common\model\GiftBox::update(["is_use"=>1],["id"=>$giftids]);
  1327. }
  1328. if($giftcount == 1) {
  1329. $giftids = $boxhasgift[0]["id"];
  1330. // 更新宝箱奖池全部礼物为未使用
  1331. \app\common\model\GiftBox::update(["is_use"=>0],["Jackpot_id"=>$gift_box_type]);
  1332. }
  1333. $giftInfo = $giftArr[$giftids];
  1334. return $giftInfo;
  1335. }
  1336. /**
  1337. * 单独赠送礼物,一键清空背包
  1338. */
  1339. public function giveAllbackGiftToYou(){
  1340. // 接口防并发
  1341. if (!$this->apiLimit(1, 1000)) {
  1342. $this->error(__('Operation frequently'));
  1343. }
  1344. $user_ids = $this->request->request("user_id");// 赠送对象
  1345. $party_id = $this->request->request("party_id",0);// 派对ID
  1346. $room_type = $this->request->request('room_type',1); // 房间类型
  1347. $is_back = 1; // 是否背包赠送: 1=是,0=否
  1348. if (!$user_ids || !in_array($room_type,[1,2])) $this->error(__('Invalid parameters'));
  1349. }
  1350. /**
  1351. * 全麦/单独赠送礼物
  1352. */
  1353. public function giveGiftToYou() {
  1354. // 接口防并发
  1355. if (!$this->apiLimit(1, 1000)) {
  1356. $this->error(__('Operation frequently'));
  1357. }
  1358. $user_ids = $this->request->request("user_id");// 赠送对象
  1359. $gift_id = $this->request->request("gift_id");// 礼物ID
  1360. $party_id = $this->request->request("party_id",0);// 派对ID
  1361. $room_type = $this->request->request('room_type',1); // 房间类型
  1362. $number = $this->request->request("number");// 赠送数量
  1363. $is_back = $this->request->request("is_back",0);// 是否背包赠送: 1=是,0=否
  1364. if (!$user_ids || !in_array($is_back,[0,1]) || !$gift_id || !$number || !in_array($room_type,[1,2])) $this->error(__('Invalid parameters'));
  1365. $user_id_arr = explode(",",$user_ids);
  1366. $userCount = count($user_id_arr);
  1367. $userauthid = $this->auth->id;
  1368. //$soundCoinRate = config("site.giftCoin"); // 声币兑换比例
  1369. $money_to_jewel = config('site.money_to_jewel') ?: 10; //余额兑换钻石
  1370. $userModel = new \app\common\model\User();
  1371. $backGiftId = 0;
  1372. $boxgiftInfo = [];
  1373. if($is_back == 1) {
  1374. // 获取背包礼物信息
  1375. $giftInfo = \app\common\model\GiftBack::get($gift_id);
  1376. if(!$giftInfo) $this->error("背包礼物获取失败");
  1377. $backGiftId = $giftInfo->gift_id;
  1378. // 随机获取一个礼物
  1379. $allCount = $number*$userCount;
  1380. $giftbackList = \app\common\model\GiftBack::where(["name"=>$giftInfo->name,"user_id"=>$userauthid,'is_use'=>0])->limit($allCount)->select();
  1381. $giftInfo = isset($giftbackList[0])?$giftbackList[0]:[];
  1382. $giftcount = 0;
  1383. $giftList = [];
  1384. if($giftbackList) foreach($giftbackList as $k => $v) {
  1385. $giftcount = $giftcount + $v["number"];
  1386. $giftList[$k] = $v;
  1387. if($giftcount >= $allCount) {
  1388. break;
  1389. }
  1390. }
  1391. if($giftcount < $allCount) $this->error("背包数量不足");
  1392. $giftValue = $giftInfo["value"] * $number;
  1393. $getValue = $giftInfo["value"] * $number;
  1394. } else {
  1395. // // 不可以赠送给自己
  1396. // if(in_array($userauthid,$user_id_arr)) $this->error("不可以赠送给自己!");
  1397. // 获取礼物信息
  1398. $giftModel = new \app\common\model\Gift();
  1399. $where = [];
  1400. $where["id"] = $gift_id;
  1401. $giftInfo = $giftModel->where($where)->find();
  1402. if (!$giftInfo) $this->error("请选择礼物!");
  1403. $giftValue = $giftInfo["value"] * $number;
  1404. $giftCountValue = $giftInfo["value"] * $number * $userCount;
  1405. $getValue = $giftValue;
  1406. // 判断如果是礼物盒则随机开礼物盒礼物
  1407. if($giftInfo->box_type > 0) {
  1408. $boxgiftInfo = $this->getBoxGift($giftInfo->box_type);
  1409. $getValue = $boxgiftInfo["price"];
  1410. }
  1411. // 判断当前用户余额
  1412. $where = [];
  1413. $where["id"] = $userauthid;
  1414. $userInfo = $userModel->where($where)->lock(true)->find();
  1415. if (!$userInfo) $this->error("用户信息查询失败!");
  1416. if($userInfo["jewel"] < $giftCountValue) $this->error("您的钻石余额不足!");
  1417. }
  1418. $hotValue = $getValue;
  1419. //$getValue = round($getValue * ($soundCoinRate/100));
  1420. // 转换统计
  1421. $progetValue = $hotValue - $getValue;
  1422. if($progetValue >0) {
  1423. $data = [];
  1424. $data["user_id"] = $user_ids;
  1425. $data["party_id"] = $party_id?$party_id:0;
  1426. $data["gift_value"] = $hotValue;
  1427. $data["plat_value"] = $hotValue - $getValue;
  1428. $data["createtime"] = time();
  1429. \app\common\model\UserChangeLog::insert($data);
  1430. }
  1431. // 转换声币后 再进行抽点设置
  1432. $partyInfo = null;
  1433. if(!$party_id) {
  1434. $platRate = 10;
  1435. $guilderRate = 30;
  1436. } else {
  1437. $partyInfo = \app\common\model\Party::field("user_id,platRate,guilderRate")->where(["id"=>$party_id])->find();
  1438. // 获取系统配置信息
  1439. $platRate = $partyInfo->platRate; // 平台抽成百分比
  1440. $guilderRate = $partyInfo->guilderRate; // 工会长抽成百分比
  1441. }
  1442. $platValue = bcmul($platRate/100,$getValue,2);
  1443. $guilderValue = bcmul($guilderRate/100,$getValue,2);
  1444. $getValue = bcsub(bcsub($getValue,$platValue,2),$guilderValue,2);
  1445. // $gif_image = $is_back==1?$giftInfo["gif_image"]:$giftInfo["special"];
  1446. $returnData = [];
  1447. Db::startTrans();
  1448. try {
  1449. $redis = new Redis();
  1450. $redisconfig = config("redis");
  1451. $redis->connect($redisconfig["host"], $redisconfig["port"], 86400 * 31);
  1452. if ($redisconfig['redis_pwd']) {
  1453. $redis->auth($redisconfig['redis_pwd']);
  1454. }
  1455. if($redisconfig['redis_selectdb'] > 0){
  1456. $redis->select($redisconfig['redis_selectdb']);
  1457. }
  1458. // 事务处理余额与记录信息
  1459. $userjewellogModel = new \app\common\model\UserJewelLog();
  1460. //$usersoundcoinlogModel = new \app\common\model\UserSoundcoinLog();
  1461. // 获取当天零点
  1462. $day = date("Ymd");
  1463. // 获取本周第一天
  1464. $weekday = $this->firstOfWeek(date("Y-m-d H:i:s"));
  1465. // 获取本月第一天
  1466. $monthday = date("Ym01");
  1467. $allVal = 0;
  1468. $i = 0;
  1469. foreach($user_id_arr as $user_id) {
  1470. // 获取赠送用户信息
  1471. $where = [];
  1472. $where["id"] = $user_id;
  1473. $touserInfo = $userModel->where($where)->find();
  1474. if($is_back == 1) {
  1475. $b=0;
  1476. foreach($giftList as $k => $v) {
  1477. for($a=1;$a<=$v["number"];$a++) {
  1478. $b++;
  1479. $num = $v["number"] - $a;
  1480. if($num > 0) {
  1481. $res1 = \app\common\model\GiftBack::where(["id"=>$v["id"]])->setDec("number");
  1482. } else {
  1483. $res1 = \app\common\model\GiftBack::update(["is_use"=>1,"use_time"=>time()],["id"=>$v["id"]]);
  1484. }
  1485. if($b == $number) break;
  1486. }
  1487. }
  1488. $res2 = true;
  1489. } else {
  1490. $res1 = true;
  1491. $res2 = true;
  1492. // 扣除当前用户钻石余额
  1493. $rs_wallet = model('wallet')->lockChangeAccountRemain($userauthid, $giftValue, '-', $userInfo["jewel"], "赠送礼物:'" . $giftInfo["name"] . "',扣除" . $giftValue . "钻石!", 3,'jewel');
  1494. if($rs_wallet['status'] == false){
  1495. $this->error($rs_wallet['msg']);
  1496. Db::rollback();
  1497. }
  1498. }
  1499. $giftuserpartyModel = new \app\common\model\GiftUserParty();
  1500. // 添加礼物赠送记录表
  1501. $data = [];
  1502. $data["user_id"] = $userauthid;
  1503. $data["user_to_id"] = $user_id;
  1504. $data["party_id"] = $party_id;
  1505. if($boxgiftInfo){
  1506. $data["gift_id"] = $boxgiftInfo['gift_id'];
  1507. $data["gift_give_type"] = 2;
  1508. $data["gift_name"] = $boxgiftInfo["gift_name"];
  1509. $data["gift_gif_image"] = $boxgiftInfo["image"];
  1510. $data["number"] = $number;
  1511. $data["price"] = $boxgiftInfo["price"];
  1512. $data["value"] = $boxgiftInfo["price"] * $number;
  1513. }else{
  1514. $data["gift_id"] = $backGiftId > 0 ? $backGiftId : $gift_id;
  1515. $data["gift_give_type"] = $is_back ? 1 : 2;
  1516. $data["gift_name"] = $giftInfo["name"];
  1517. $data["gift_gif_image"] = $giftInfo["image"];
  1518. $data["number"] = $number;
  1519. $data["price"] = $giftInfo["value"];
  1520. $data["value"] = $giftValue;
  1521. }
  1522. //每个礼物都要计算平台抽成和房主抽成
  1523. $data['platvalue'] = bcmul($platRate/100,$data["value"],2);
  1524. $data['guildervalue'] = bcmul($guilderRate/100,$data["value"],2);
  1525. $data['guildermoney'] = bcdiv($data['guildervalue'],$money_to_jewel,2);
  1526. $data["createtime"] = time();
  1527. $res5 = $giftuserpartyModel->allowField(true)->save($data);
  1528. //$this->bigGiftNotice($giftuserpartyModel);
  1529. // 添加赠送用户余额
  1530. if($getValue > 0){
  1531. $getMoney = bcdiv($getValue,$money_to_jewel,2);
  1532. if($getMoney > 0){
  1533. $rs_wallet = model('wallet')->lockChangeAccountRemain($user_id,$getMoney,'+',0,"{$this->auth->nickname}送你{$giftInfo['name']}x{$number}",101,'money');
  1534. if($rs_wallet['status'] == false){
  1535. $this->error($rs_wallet['msg']);
  1536. Db::rollback();
  1537. }
  1538. }
  1539. }
  1540. // 增加房主抽成
  1541. if ($partyInfo && $guilderValue > 0) {
  1542. $guilderMoney = bcdiv($guilderValue,$money_to_jewel,2);
  1543. if($guilderMoney > 0){
  1544. $rs_wallet = model('wallet')->lockChangeAccountRemain($partyInfo->user_id,$guilderMoney,'+',0,"{$this->auth->nickname}送礼物{$giftInfo['name']}x{$number}给{$touserInfo['nickname']},房间礼物抽成",102,'money');
  1545. if($rs_wallet['status'] == false){
  1546. $this->error($rs_wallet['msg']);
  1547. Db::rollback();
  1548. }
  1549. }
  1550. }
  1551. if ($res1 && $res2 && $res5) {
  1552. $i++;
  1553. if($party_id > 0) {
  1554. // 添加redis记录做财富排行榜日榜用
  1555. $redis->zIncrBy($this->roomTypeArr[$room_type] . "_jewel_get_" . $party_id . ":" . $day . "d", $hotValue, $user_id);
  1556. // 添加redis记录做财富排行榜周榜用
  1557. $redis->zIncrBy($this->roomTypeArr[$room_type] . "_jewel_get_" . $party_id . ":" . $weekday . "w", $hotValue, $user_id);
  1558. // 添加redis记录做财富排行榜月榜用
  1559. $redis->zIncrBy($this->roomTypeArr[$room_type] . "_jewel_get_" . $party_id . ":" . $monthday . "m", $hotValue, $user_id);
  1560. // 添加redis记录做贡献排行榜日榜用
  1561. $redis->zIncrBy($this->roomTypeArr[$room_type] . "_jewel_to_" . $party_id . ":" . $day . "d", $giftValue, $userauthid);
  1562. // 添加redis记录做贡献排行榜周榜用
  1563. $redis->zIncrBy($this->roomTypeArr[$room_type] . "_jewel_to_" . $party_id . ":" . $weekday . "w", $giftValue, $userauthid);
  1564. // 添加redis记录做贡献排行榜月榜用
  1565. $redis->zIncrBy($this->roomTypeArr[$room_type] . "_jewel_to_" . $party_id . ":" . $monthday . "m", $giftValue, $userauthid);
  1566. // tcp 更新用户魅力值
  1567. $this->updateUserCharm($party_id, $user_id, $hotValue);
  1568. // 如果是主播,则添加魅力值记录做榜单统计
  1569. if($room_type == 2) {
  1570. $data = [];
  1571. $data["user_id"] = $user_id;
  1572. $data["party_id"] = $party_id;
  1573. $data["charm"] = $hotValue;
  1574. $data["createtime"] = time();
  1575. \app\common\model\UserCharmRank::insert($data);
  1576. }
  1577. }
  1578. $getempirical = config("site.getempirical");
  1579. $getempirical = $getempirical * $hotValue;
  1580. // 获取用户贵族信息
  1581. $noble = \app\common\model\User::getUserNoble($this->auth->id);
  1582. if(isset($noble["noble_on"]) && $noble["noble_on"] == 1) {
  1583. $getempirical = $getempirical + $getempirical * ($noble["explain"]/100);
  1584. }
  1585. // 增加用户经验值
  1586. $res = \app\common\model\User::addEmpirical($this->auth->id,$getempirical);
  1587. if ($res){
  1588. $this->auth->level = $res->level;
  1589. }
  1590. // +exp
  1591. \app\common\model\TaskLog::tofinish($this->auth->id,"OBHqCX4g",$number);
  1592. //贵族升级处理
  1593. //$this->checkBeNoble($redis,$this->auth->id,$giftCountValue);
  1594. // +message
  1595. \app\common\model\Message::addMessage($user_id,"礼物通知","收到 ".$this->auth->nickname." 赠送的".$giftInfo["name"]." x".$number." 价值 ".$giftValue ." 钻石");
  1596. $allVal = $allVal + $hotValue;
  1597. // // 剪掉背包礼物
  1598. // if($is_back == 1) {
  1599. // \app\common\model\GiftBack::update(["is_use"=>1],["id"=>$gift_id]);
  1600. // }
  1601. }
  1602. }
  1603. // 获取用户魅力值
  1604. $users = $redis->zRange("hourCharm_".$party_id,0,-1,true);
  1605. $u = [];
  1606. if($users) {
  1607. foreach($users as $k => $v) $u[] = [
  1608. "user_id"=>$k,
  1609. "charm"=>$this->changeW($v)
  1610. ];
  1611. }
  1612. $userCharm = $u;
  1613. // tcp 更新房间热度
  1614. $partyHot = $this->updatePartyHot($party_id, $allVal, $room_type);
  1615. // 如果是派对,则添加派对热度值记录做榜单统计
  1616. if($room_type == 1) {
  1617. $data = [];
  1618. $data["party_id"] = $party_id;
  1619. $data["hot"] = $allVal;
  1620. $data["createtime"] = time();
  1621. \app\common\model\PartyHot::insert($data);
  1622. }
  1623. // tcp 获取房间用户周前三名
  1624. $partyUserTop = $this->getPartyUserTop($party_id, $room_type);
  1625. if($i == $userCount) {
  1626. $returnData["userCharm"] = $userCharm;
  1627. $returnData["partyHot"] = $this->changeW($partyHot);
  1628. $returnData["partyUserTop"] = $partyUserTop;
  1629. if($is_back != 1) {
  1630. if($giftInfo->box_type > 0) { // 不是背包,宝箱中赠送
  1631. $returnData["box_type"] = $giftInfo->box_type;
  1632. $returnData["box_image"] = $giftInfo->image;
  1633. $returnData["image"] = $boxgiftInfo["image"];
  1634. $returnData["name"] = $boxgiftInfo["gift_name"];
  1635. $returnData["gif_image"] = $boxgiftInfo["special"];
  1636. } else {
  1637. $returnData["image"] = $giftInfo["image"];
  1638. $returnData["gif_image"] = $giftInfo["special"];
  1639. }
  1640. } else {
  1641. $returnData["image"] = $giftInfo["image"];
  1642. $returnData["gif_image"] = $giftInfo["gif_image"];
  1643. }
  1644. // 增加抽点记录
  1645. $data = [];
  1646. $data["user_id"] = $user_ids;
  1647. $data["party_id"] = $party_id?$party_id:0;
  1648. $data["gift_value"] = $giftValue;
  1649. $data["plat_value"] = $platValue;
  1650. $data["guilder_value"] = $guilderValue;
  1651. $data["createtime"] = time();
  1652. \app\common\model\UserProfitLog::insert($data);
  1653. Db::commit();
  1654. $this->success("赠送成功!",$returnData);
  1655. } else {
  1656. $this->success("赠送失败!");
  1657. }
  1658. } catch (ValidateException $e) {
  1659. Db::rollback();
  1660. $this->error($e->getMessage());
  1661. } catch (PDOException $e) {
  1662. Db::rollback();
  1663. $this->error($e->getMessage());
  1664. } catch (Exception $e) {
  1665. Db::rollback();
  1666. $this->error($e->getMessage());
  1667. }
  1668. }
  1669. //送礼完成之后,大礼物飘屏
  1670. private function bigGiftNotice($giftUserParty){
  1671. if ($giftUserParty->party_id > 0) {
  1672. $bigGiftNotice = config("site.bigGiftNotice");
  1673. $partyInfo = $giftUserParty->party;
  1674. $money = $giftUserParty->value;
  1675. if ($money >= $bigGiftNotice) {
  1676. $messageData = [
  1677. 'type' => 'bigGiftNotice',
  1678. 'data' => [
  1679. 'party_info' => [
  1680. 'party_id' => $partyInfo['id'],
  1681. 'room_type' => $partyInfo['room_type'],
  1682. 'party_name' => $partyInfo['party_name']
  1683. ],
  1684. 'notice_info' => [
  1685. 'sender' => $giftUserParty->user->nickname,
  1686. 'receiver' => $giftUserParty->toUser->nickname,
  1687. 'gift_num' => $giftUserParty['number'],
  1688. 'gift_name' => $giftUserParty['gift_name'],
  1689. 'gift_image' => $giftUserParty['gift_gif_image'],
  1690. 'value' => $giftUserParty['value'],
  1691. ]
  1692. ]
  1693. ];
  1694. }
  1695. }
  1696. }
  1697. //某房间内礼物列表
  1698. public function getPartyGiftLog(){
  1699. $party_id = input('party_id',0);
  1700. $list = Db::name('gift_user_party')->alias('log')->field('log.gift_name,log.gift_gif_image,log.number,log.value,log.guildermoney,log.createtime,user.nickname as give_nickname,b.nickname as get_nickname')
  1701. ->join('user','log.user_id = user.id','LEFT')
  1702. ->join('user b','log.user_to_id = b.id','LEFT')
  1703. ->where('log.party_id',$party_id)->order('log.id desc')->autopage()->select();
  1704. $list = list_domain_image($list,['gift_gif_image']);
  1705. foreach($list as $key => &$val){
  1706. $val['createtime'] = get_last_time($val['createtime']);
  1707. }
  1708. $this->success('success',$list);
  1709. }
  1710. // /**
  1711. // * 播放动效
  1712. // */
  1713. // public function play($party_id,$type,$value,$number) {
  1714. // // 发送tcp
  1715. // $tcpArr = [];
  1716. // $tcpArr['type'] = "play";
  1717. // $tcpArr['data'] = [
  1718. // 'party_id' => $party_id,
  1719. // 'type' => $type,
  1720. // 'value' => $value,
  1721. // 'number' => $number,
  1722. // ];
  1723. // $tcpJson = json_encode($tcpArr);
  1724. // $client = stream_socket_client(config("tcp"));
  1725. // $buffer2 = base64_encode($tcpJson)."****";
  1726. // fwrite($client, $buffer2);
  1727. // }
  1728. /**
  1729. * 更新派对信息(热度等)
  1730. */
  1731. private function updatePartyHot($party_id,$hotValue,$room_type) {
  1732. $partyInfo = \app\common\model\Party::where(['id'=>$party_id])->find();
  1733. if(!$partyInfo) return $hotValue;
  1734. $party_hot = $partyInfo->party_hot > 0 ? $partyInfo->party_hot:0;
  1735. $party_hot_value = $party_hot + $hotValue;
  1736. $party_hot_value = $party_hot_value > 0 ? $party_hot_value : 0;
  1737. if($party_hot_value != $party_hot) {
  1738. // 保存数据
  1739. $partyInfo->party_hot = $party_hot_value;
  1740. $partyInfo->save();
  1741. // 更新redis 加入缓存排序
  1742. $redis = new Redis();
  1743. $redisconfig = config("redis");
  1744. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1745. if ($redisconfig['redis_pwd']) {
  1746. $redis->auth($redisconfig['redis_pwd']);
  1747. }
  1748. if($redisconfig['redis_selectdb'] > 0){
  1749. $redis->select($redisconfig['redis_selectdb']);
  1750. }
  1751. $redis->zAdd($this->roomTypeArr[$room_type]."Rank", $partyInfo['party_hot'], $partyInfo["id"]);
  1752. // 更新redis 加入缓存
  1753. $redPartyInfo = $redis->get($this->roomTypeArr[$room_type]."_".$partyInfo["id"]);
  1754. if($redPartyInfo) {
  1755. $redPartyInfo = json_decode($redPartyInfo,true);
  1756. $redPartyInfo["party_hot"] = $party_hot_value;
  1757. $redis->set($this->roomTypeArr[$room_type]."_".$partyInfo["id"],json_encode($redPartyInfo));
  1758. }
  1759. // // 发送tcp
  1760. // $tcpArr = [];
  1761. // $tcpArr['type'] = "changeRoomHot";
  1762. // $tcpArr['data'] = [
  1763. // 'room_id' => $party_id,
  1764. // 'value' => $party_hot_value,
  1765. // ];
  1766. // $tcpJson = json_encode($tcpArr);
  1767. // $client = stream_socket_client(config("tcp"));
  1768. // $buffer2 = base64_encode($tcpJson)."****";
  1769. // fwrite($client, $buffer2);
  1770. }
  1771. return $party_hot_value;
  1772. }
  1773. /**
  1774. * 用户赠送礼物后房间内用户排行,贡献榜前三名
  1775. */
  1776. private function getPartyUserTop($party_id,$room_type) {
  1777. $redis = new Redis();
  1778. $redisconfig = config("redis");
  1779. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1780. if ($redisconfig['redis_pwd']) {
  1781. $redis->auth($redisconfig['redis_pwd']);
  1782. }
  1783. if($redisconfig['redis_selectdb'] > 0){
  1784. $redis->select($redisconfig['redis_selectdb']);
  1785. }
  1786. // 获取本周第一天
  1787. $weekday = $this->firstOfWeek(date("Y-m-d H:i:s"));
  1788. // 获取当天零点
  1789. $day = date("Ymd");
  1790. $userModel = new \app\common\model\User();
  1791. // 获取条数
  1792. $num = 3;
  1793. // 获取3条财富排行周记录
  1794. $getweek = $redis->zRevRange($this->roomTypeArr[$room_type]."_jewel_to_".$party_id.":".$day."d",0,$num-1,true);
  1795. $userList = $userModel->rankList($getweek);
  1796. $avatarArr = [];
  1797. if($userList) {
  1798. foreach($userList as $k => $v) {
  1799. $v["jewel"] > 0 && $avatarArr[] = $v["avatar"];
  1800. }
  1801. // 加入缓存做备份
  1802. $redis->hSet("user_jewel_top3",$party_id,json_encode($avatarArr));
  1803. // // 发送tcp
  1804. // $tcpArr = [];
  1805. // $tcpArr['type'] = "changeRoomUserTop";
  1806. // $tcpArr['data'] = [
  1807. // 'room_id' => $party_id,
  1808. // 'user_avatar' => $avatarArr,
  1809. // ];
  1810. // $tcpJson = json_encode($tcpArr);
  1811. // $client = stream_socket_client(config("tcp"));
  1812. // $buffer2 = base64_encode($tcpJson)."****";
  1813. // fwrite($client, $buffer2);
  1814. }
  1815. return $avatarArr;
  1816. }
  1817. /**
  1818. * 用户赠送礼物后房间内用户魅力值增加
  1819. */
  1820. private function updateUserCharm($party_id,$user_id,$giftValue) {
  1821. $redis = new Redis();
  1822. $redisconfig = config("redis");
  1823. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1824. if ($redisconfig['redis_pwd']) {
  1825. $redis->auth($redisconfig['redis_pwd']);
  1826. }
  1827. if($redisconfig['redis_selectdb'] > 0){
  1828. $redis->select($redisconfig['redis_selectdb']);
  1829. }
  1830. // 获取用户魅力值
  1831. $users = $redis->zRange("hourCharm_".$party_id,0,-1,true);
  1832. if(!$users) $users[$user_id] = 0;
  1833. if(isset($users[$user_id])) {
  1834. $value = $users[$user_id] + $giftValue;
  1835. } else {
  1836. $value = $giftValue;
  1837. }
  1838. $redis->zAdd("hourCharm_".$party_id,$value,$user_id);
  1839. return true;
  1840. }
  1841. /**
  1842. * 单个房间魅力值清零
  1843. */
  1844. public function partyClearCharm() {
  1845. $party_id = $this->request->request("party_id");// 派对ID
  1846. $userId = $this->request->request("user_id", 0);// 用户ID
  1847. if($party_id <= 0) {
  1848. $this->error("请输入派对ID");
  1849. }
  1850. $redis = new Redis();
  1851. $redisconfig = config("redis");
  1852. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1853. if ($redisconfig['redis_pwd']) {
  1854. $redis->auth($redisconfig['redis_pwd']);
  1855. }
  1856. if($redisconfig['redis_selectdb'] > 0){
  1857. $redis->select($redisconfig['redis_selectdb']);
  1858. }
  1859. if ($userId) {
  1860. $redis->zRem("hourCharm_" . $party_id, $userId);
  1861. } else {
  1862. $redis->del("hourCharm_" . $party_id);
  1863. }
  1864. $this->success("操作成功!");
  1865. }
  1866. /**
  1867. * 获取音乐列表
  1868. */
  1869. public function getMusicList() {
  1870. $this->success("获取成功!",\app\common\model\Music::select());
  1871. }
  1872. //============================定时任务==========================//
  1873. /**
  1874. * redis清理排行榜 并数据库备份
  1875. */
  1876. public function updateTops() {
  1877. // 前一天日期
  1878. $yestaday = date("Ymd",bcsub(time(),86400));
  1879. // 上个周一
  1880. $preweek = $this->firstOfWeek(date("Y-m-d H:i:s",bcsub(time(),604800)));
  1881. // 上个月一号
  1882. $monty = bcsub(date("m"),1);
  1883. if($monty < 10) $monty = "0".$monty;
  1884. $premonth = date("Y").$monty."01";
  1885. $redis = new Redis();
  1886. $redisconfig = config("redis");
  1887. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1888. if ($redisconfig['redis_pwd']) {
  1889. $redis->auth($redisconfig['redis_pwd']);
  1890. }
  1891. if($redisconfig['redis_selectdb'] > 0){
  1892. $redis->select($redisconfig['redis_selectdb']);
  1893. }
  1894. // 获取所有派对ID
  1895. $party_ids = \app\common\model\Party::where(["status"=>1])->column("id");
  1896. // 获取数据
  1897. $time = time();
  1898. if($party_ids) foreach($party_ids as $k => $v) {
  1899. $keys = [
  1900. "party_jewel_get_".$v.":".$yestaday."d",
  1901. "party_jewel_to_".$v.":".$yestaday."d",
  1902. "party_jewel_get_".$v.":".$preweek."w",
  1903. "party_jewel_to_".$v.":".$preweek."w",
  1904. "party_jewel_get_".$v.":".$premonth."m",
  1905. "party_jewel_to_".$v.":".$premonth."m",
  1906. ];
  1907. foreach($keys as $key) {
  1908. // 备份数据
  1909. $redisData = $redis->zRevRange($key,0,-1,true);
  1910. if($redisData) {
  1911. $keyInfo = \app\common\model\RedisTops::where(["key"=>$key])->find();
  1912. $data = ["party_id"=>$v,"key"=>$key,"value"=>json_encode($redisData),"createtime" => $time];
  1913. if(!$keyInfo) {
  1914. $res = \app\common\model\RedisTops::insert($data);
  1915. // 清理数据
  1916. $res && $redis->zRemRangeByRank($key,0,-1);
  1917. }
  1918. }
  1919. }
  1920. }
  1921. }
  1922. public function handleParty() {
  1923. return false;
  1924. $partyList = \app\common\model\Party::where('is_online',1)->select();
  1925. $redis = new Redis();
  1926. $redisconfig = config("redis");
  1927. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  1928. if ($redisconfig['redis_pwd']) {
  1929. $redis->auth($redisconfig['redis_pwd']);
  1930. }
  1931. if($redisconfig['redis_selectdb'] > 0){
  1932. $redis->select($redisconfig['redis_selectdb']);
  1933. }
  1934. // $redis->del("online_" . 3);die;
  1935. // $redis->hSet("online_" . 3, 4, 4);die;
  1936. foreach ($partyList as $party){
  1937. $userId = $party['user_id'];
  1938. $roomId = $party['id'];
  1939. $redis->HDel("online_" . $roomId, $userId);
  1940. // 扣除在线用户在房间情况
  1941. $redis->hDel("livingUser",$userId);
  1942. // // 更新房间在线状态
  1943. $partyInfo = $redis->get("party_" . $roomId);
  1944. if ($partyInfo) {
  1945. $partyInfo = json_decode($partyInfo, true);
  1946. $memCount = count($redis->hGetAll("online_" . $roomId));
  1947. if ($memCount <= 0) {
  1948. dump($roomId.'--1---');
  1949. $partyInfo["is_online"] = 0;
  1950. $redis->set("party_" . $roomId, json_encode($partyInfo));
  1951. \app\common\model\Party::update(["is_online" => 0], ["id" => $roomId]);
  1952. }
  1953. }
  1954. $liveInfo = $redis->get("live_" . $roomId);
  1955. if ($liveInfo) {
  1956. $liveInfo = json_decode($liveInfo, true);
  1957. $memCount = count($redis->hGetAll("online_" . $roomId));
  1958. if ($memCount <= 0) {
  1959. dump($roomId.'---2--');
  1960. $liveInfo["is_online"] = 0;
  1961. $redis->set("live_" . $roomId, json_encode($liveInfo));
  1962. \app\common\model\Party::update(["is_online" => 0], ["id" => $roomId]);
  1963. }else{
  1964. dump($roomId.'---3--');
  1965. $redis->del("online_" . $roomId);
  1966. $liveInfo["is_online"] = 0;
  1967. $redis->set("live_" . $roomId, json_encode($liveInfo));
  1968. \app\common\model\Party::update(["is_online" => 0], ["id" => $roomId]);
  1969. }
  1970. }
  1971. }
  1972. $this->success("获取成功!");
  1973. }
  1974. }