Guild.php 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use think\Db;
  5. use think\Exception;
  6. use Redis;
  7. use app\api\controller\Tenim;
  8. use app\common\service\RoomService;
  9. /**
  10. * 公会控制器
  11. */
  12. class Guild extends Api
  13. {
  14. protected $noNeedLogin = ['getGuildList'];
  15. protected $noNeedRight = ['*'];
  16. /**
  17. * 获取公会信息
  18. */
  19. public function getGuildInfo() {
  20. $guild_id = $this->request->request("guild_id"); //公会ID
  21. $is_member = 0;
  22. if($guild_id <= 0) {
  23. $is_member = 1;
  24. $user_id = $this->auth->id;
  25. // 获取当前用户是否是公会成员
  26. $idcardfind = \app\common\model\GuildJoinin::where(["user_id"=>$user_id,"status"=>0])->find();
  27. if($idcardfind) $this->error("您存在加入公会的申请,正在审核中,请耐心等待!");
  28. $memberfind = \app\common\model\GuildMember::where(["user_id"=>$user_id,"status"=>1,"sign_time"=>["gt",time()]])->find();
  29. if($memberfind) $guild_id = $memberfind->guild_id;
  30. if(!$guild_id) {
  31. $res["is_member"] = 2; // 是否为派对成员
  32. $this->success("获取成功!",$res);
  33. }
  34. }
  35. $res = [];
  36. $guildInfo = \app\common\model\Guild::field("id,image,name,g_id,user_id,party_id,desc,notice")->where(["id"=>$guild_id])->find();
  37. // 获取公会成员信息
  38. $guildMemberInfo = \app\common\model\GuildMember::alias("a")
  39. ->field("a.user_id,a.role,u.nickname,u.avatar,u.gender,u.age")
  40. ->join("hx_user u","a.user_id = u.id")
  41. ->where(["a.guild_id"=>$guild_id])->limit(5)->order("a.role","desc")->select();
  42. if(!$guildInfo || !$guildMemberInfo) $this->error("公会信息获取失败!");
  43. // 获取公会成员总数
  44. $guildMemberCount = \app\common\model\GuildMember::where(["guild_id"=>$guild_id])->count("id");
  45. // 获取会长信息
  46. $guilderInfo = \app\common\model\User::field("avatar,nickname,u_id")->where(["id"=>$guildInfo->user_id])->find();
  47. // 获取房间信息
  48. $partyInfo = \app\common\model\Party::field("party_logo,party_type,is_online,party_name,party_notice_detail")->where(["id"=>$guildInfo->party_id])->find();
  49. // 派对类型
  50. $partyTypeName = "普通房";
  51. if($partyInfo["party_type"]) {
  52. $partyTypeName = \app\common\model\PartyType::where(["id"=>$partyInfo["party_type"]])->value("name");
  53. }
  54. $mod = isset($partyInfo["party_type"])?intval($partyInfo["party_type"])%5:1;
  55. $partyInfo["party_type_color"] = $mod == 0?5:$mod;
  56. $partyInfo["type_name"] = $partyTypeName;
  57. // 返回参数拼接
  58. $res["guildInfo"] = $guildInfo; // 公会基本信息
  59. $res["guildMemberInfo"] = $guildMemberInfo; // 成员列表
  60. $res["guildMemberCount"] = $guildMemberCount; // 成员总数
  61. $res["guilderInfo"] = $guilderInfo; // 会长
  62. $res["partyInfo"] = $partyInfo; // 派对悉尼下
  63. $res["is_member"] = $is_member; // 是否为派对成员
  64. $this->success("获取成功!",$res);
  65. }
  66. /**
  67. * 获取公会信息-新
  68. */
  69. public function getGuildInfoNew() {
  70. $guild_id = $this->request->request("guild_id"); //公会ID
  71. $is_member = 0;
  72. if($guild_id <= 0) {
  73. $is_member = 1;
  74. $user_id = $this->auth->id;
  75. // 获取当前用户是否是公会成员
  76. $idcardfind = \app\common\model\GuildJoinin::where(["user_id"=>$user_id,"status"=>0])->find();
  77. if($idcardfind) $this->error("您存在加入公会的申请,正在审核中,请耐心等待!");
  78. $memberfind = \app\common\model\GuildMember::where(["user_id"=>$user_id,"status"=>1,"sign_time"=>["gt",time()]])->find();
  79. if($memberfind) $guild_id = $memberfind->guild_id;
  80. if(!$guild_id) {
  81. $res["is_member"] = 2; // 是否为派对成员
  82. $this->success("获取成功!",$res);
  83. }
  84. }
  85. $res = [];
  86. $guildInfo = \app\common\model\Guild::field("id,image,name,g_id,user_id,party_id,desc,notice")->where(["id"=>$guild_id])->find();
  87. // 获取公会成员信息
  88. $guildMemberInfo = \app\common\model\GuildMember::alias("a")
  89. ->field("a.user_id,a.role,u.nickname,u.avatar")
  90. ->join("hx_user u","a.user_id = u.id")
  91. ->where(["a.guild_id"=>$guild_id])->limit(5)->order("a.role","desc")->select();
  92. if(!$guildInfo || !$guildMemberInfo) $this->error("公会信息获取失败!");
  93. // 获取公会成员总数
  94. $guildMemberCount = \app\common\model\GuildMember::where(["guild_id"=>$guild_id])->count("id");
  95. // 获取会长信息
  96. //$guilderInfo = \app\common\model\User::field("avatar,nickname,u_id")->where(["id"=>$guildInfo->user_id])->find();
  97. // 获取房间信息
  98. $partyInfo = \app\common\model\Party::field("id,party_logo,party_type,is_online,party_name,party_notice_detail")->where(["id"=>$guildInfo->party_id])->find();
  99. $partyParams = ['party_id' => $guildInfo->party_id];
  100. $roomService = new RoomService();
  101. $partyOnlineRes = $roomService->getPartyUserList($partyParams);
  102. $onlineData = isset($partyOnlineRes['data']) ? $partyOnlineRes['data'] : [];
  103. $partyInfo['user_list'] = isset($onlineData['user_list']) ? $onlineData['user_list'] : [];
  104. $partyInfo['online_num'] = isset($onlineData['online_num']) ? $onlineData['online_num'] : 0;
  105. // 派对类型
  106. $partyTypeName = "普通房";
  107. if($partyInfo["party_type"]) {
  108. $partyTypeName = \app\common\model\PartyType::where(["id"=>$partyInfo["party_type"]])->value("name");
  109. }
  110. $mod = isset($partyInfo["party_type"])?intval($partyInfo["party_type"])%5:1;
  111. $partyInfo["party_type_color"] = $mod == 0?5:$mod;
  112. $partyInfo["type_name"] = $partyTypeName;
  113. // 返回参数拼接
  114. $res["guildInfo"] = $guildInfo; // 公会基本信息
  115. $res["partyInfo"] = $partyInfo; // 派对悉尼下
  116. $res["guildMemberInfo"] = $guildMemberInfo; // 成员列表
  117. $res["guildMemberCount"] = $guildMemberCount; // 成员总数
  118. //$res["guilderInfo"] = $guilderInfo; // 会长
  119. $res["is_member"] = $is_member; // 是否为派对成员
  120. $this->success("获取成功!",$res);
  121. }
  122. /**
  123. * 更新公会基本信息
  124. */
  125. public function guildSaveInfo() {
  126. $guild_id = $this->request->request("guild_id"); //公会id
  127. $guild_name = $this->request->request("guild_name"); //公会简介
  128. $guild_image = $this->request->request("guild_image"); //公会简介
  129. $guild_desc = $this->request->request("guild_desc"); //公会简介
  130. $guild_notice = $this->request->request("guild_notice"); //公会公告
  131. if(!$guild_name && !$guild_image && !$guild_desc && !$guild_notice) $this->error("请输入要修改的内容!");
  132. if (empty($guild_id)) {
  133. $guildInfo = new \app\common\model\Guild();
  134. } else {
  135. $user_id = $this->auth->id;
  136. // 获取公会信息
  137. $guildInfo = \app\common\model\Guild::where(["id"=>$guild_id])->find();
  138. // 验证更新条件
  139. if($user_id !== $guildInfo->user_id) $this->error("身份验证失败!您不是公会长,无权限更改!");
  140. }
  141. $guild_name && $guildInfo->name = $guild_name;
  142. $guild_image && $guildInfo->image = $guild_image;
  143. $guild_desc && $guildInfo->desc = $guild_desc;
  144. $guild_notice && $guildInfo->notice = $guild_notice;
  145. $res = $guildInfo->save();
  146. if($res !== false) {
  147. $this->success("操作成功!");
  148. } else {
  149. $this->error("网络错误,请稍后重试!");
  150. }
  151. }
  152. /**
  153. * 获取搜索公会列表
  154. */
  155. public function getGuildList() {
  156. $search = $this->request->request("search","","string"); //搜索的字段 公会名称/公会ID
  157. if(!$search) $this->error("请输入要搜索的公会名称或公会ID");
  158. global $whereOr;
  159. $where = [];$whereOr = [];
  160. $where['status'] = 1;
  161. $whereOr['name'] = array('like', '%' . $search . '%');
  162. $whereOr['g_id'] = $search;
  163. $res = \app\common\model\Guild::field("id,g_id,user_id,party_id,name,image,desc,member")
  164. ->where($where)
  165. ->where(function ($query) {
  166. global $whereOr;
  167. $query->whereOr($whereOr);
  168. })
  169. ->select();
  170. $this->success("获取成功!",$res);
  171. }
  172. /**
  173. * 公会申请页面信息
  174. */
  175. public function guildApplyInfo() {
  176. $guild_id = $this->request->request("guild_id"); //公会ID
  177. if($guild_id <= 0) $this->error("参数缺失!");
  178. $guildInfo = \app\common\model\Guild::alias("a")
  179. ->join("hx_user u","u.id = a.user_id","inner")
  180. ->field("a.id,a.image,a.name,a.g_id,a.user_id,u.avatar,u.nickname,u.u_id")
  181. ->where(["a.id"=>$guild_id])
  182. ->find();
  183. $guildInfo["status"] = 0;
  184. // 获取申请用户是否已经有正在申请的记录
  185. $user_id = $this->auth->id;
  186. $joinStatus = \app\common\model\GuildJoinin::where(["user_id"=>$user_id])->value("status");
  187. if($joinStatus === 0) $guildInfo["status"] = 1;
  188. $Member = \app\common\model\GuildMember::where(["user_id"=>$user_id,"status"=>1,"sign_time"=>["gt",time()]])->value("id");
  189. if($Member > 0) $guildInfo["status"] = 2;
  190. $this->success("获取成功!",$guildInfo);
  191. }
  192. /**
  193. * 开厅申请
  194. */
  195. public function guildApply() {
  196. $user_id = $this->auth->id;
  197. // 获取用户实名认证信息
  198. $authUserRealname = \app\common\model\UserAuth::where(["user_id"=>$user_id])->value("realname");
  199. if(!$authUserRealname) $this->error("未查询到实名认证信息,请实名认证先!");
  200. // 获取用户信息
  201. $userInfo = \app\common\model\User::field("id,mobile,nickname")->where(["id"=>$user_id])->find();
  202. $data = [];
  203. $data["user_id"] = $user_id;
  204. // 查看是否申请过
  205. $applyInfo = \app\common\model\GuildApply::where($data)->find();
  206. if($applyInfo && $applyInfo->status>=0) $this->error("您已经发送过开厅申请了,请勿重复发送!");
  207. // 查看是否有加入公会的申请
  208. $joinInfo = \app\common\model\GuildJoinin::where(["user_id"=>$user_id,"status"=>0])->find();
  209. if($joinInfo) $this->error("您存在申请加入公会信息,请联系工会长处理完毕后方可申请开厅!");
  210. // 查看是已经是公会成员
  211. $memberInfo = \app\common\model\GuildMember::where(["user_id"=>$user_id,"status"=>1,"sign_time"=>["gt",time()]])->find();
  212. if($memberInfo) $this->error("您已存在签约中的公会,无法开新厅!");
  213. Db::startTrans();
  214. try{
  215. $data["user_name"] = $authUserRealname;
  216. $data["user_nickname"] = $userInfo->nickname;
  217. $data["user_mobile"] = $userInfo->mobile;
  218. $data["createtime"] = time();
  219. $res1 = \app\common\model\GuildApply::insert($data);
  220. // 更新用户状态
  221. $userInfo->is_guild = 1;
  222. $res2 = $userInfo->save();
  223. if($res1 && $res2) {
  224. Db::commit();
  225. $this->success("申请发送成功!");
  226. } else {
  227. $this->error("网络错误,请稍后重试!");
  228. }
  229. }catch (ValidateException $e) {
  230. Db::rollback();
  231. $this->error($e->getMessage());
  232. } catch (PDOException $e) {
  233. Db::rollback();
  234. $this->error($e->getMessage());
  235. } catch (Exception $e) {
  236. Db::rollback();
  237. $this->error($e->getMessage());
  238. }
  239. }
  240. /**
  241. * 公会签约申请
  242. */
  243. public function guildJoinin() {
  244. $join_time = $this->request->request("join_time"); //签约时长:1=3个月,2=6个月,3=12个月
  245. $guild_id = $this->request->request("guild_id"); //公会ID
  246. if(!in_array($join_time,[1,2,3]) || !$guild_id) $this->error("参数错误!");
  247. // 一个身份证号只能申请一次
  248. $user_id = $this->auth->id;
  249. // 实名认证
  250. $userAuthInfo = \app\common\model\UserAuth::where(["user_id"=>$user_id])->find();
  251. if($userAuthInfo) {
  252. if($userAuthInfo->status == 0) {
  253. $this->error("您的实名认证还在这审核中...,请耐心等待!");
  254. } elseif($userAuthInfo->status == 2) {
  255. $this->error("您的实名认证审核未通过,请重新审核!");
  256. }
  257. } else {
  258. $this->error("请先申请实名认证!");
  259. }
  260. // 获取用户实名认证信息
  261. $authUserIdcard = \app\common\model\UserAuth::where(["user_id"=>$user_id])->value("idcard");
  262. // 搜索签约申请中是否有此身份证号
  263. $idcardfind = \app\common\model\GuildJoinin::where(["user_id"=>$user_id,"status"=>0])->find();
  264. if($idcardfind) $this->error("当前账号正在审核,请耐心等待!");
  265. $memberfind = \app\common\model\GuildMember::where(["user_id"=>$user_id,"status"=>1,"sign_time"=>["gt",time()]])->find();
  266. if($memberfind) $this->error("一个账号只能加入一个公会哟!");
  267. // 查看是否申请过
  268. $applyInfo = \app\common\model\GuildApply::where(["user_id"=>$user_id,"status"=>0])->find();
  269. if($applyInfo && $applyInfo->status>=0) $this->error("您已经发送过开厅申请了,请勿重复发送!");
  270. // // 获取公会信息
  271. // $guildInfo = \app\common\model\Guild::where(["user_id"=>$user_id,"status"=>1])->find();
  272. // // 验证更新条件
  273. // if($guildInfo) $this->error("您存在公会会长身份,请先解散相应的公会才可申请");
  274. // 获取公会信息
  275. $guildName = \app\common\model\Guild::where(["id"=>$guild_id])->value("name");
  276. // 获取用户信息
  277. $userInfo = \app\common\model\User::field("id,avatar,nickname")->where(["id"=>$user_id])->find();
  278. // 添加数据
  279. $data = [];
  280. $data["user_id"] = $user_id;
  281. $data["guild_id"] = $guild_id;
  282. $data["join_time"] = $join_time;
  283. $data["user_avatar"] = $userInfo->avatar;
  284. $data["user_idcard"] = $authUserIdcard;
  285. $data["user_nickname"] = $userInfo->nickname;
  286. $data["guild_name"] = $guildName;
  287. $data["createtime"] = time();
  288. $res = \app\common\model\GuildJoinin::insert($data);
  289. if($res) {
  290. // +message
  291. // \app\common\model\Message::addMessage($user_id,"公会消息","申请加入公会消息");
  292. $this->success("申请发送成功!");
  293. } else {
  294. $this->error("网络错误,请稍后重试!");
  295. }
  296. }
  297. /**
  298. * 公会签约申请审核
  299. */
  300. public function guildJoininExamine() {
  301. $joinin_id = $this->request->request("joinin_id"); // 申请加入的申请ID
  302. $is_pass = $this->request->request("is_pass"); // 是否通过:1=通过,-1=拒绝
  303. if(!in_array($is_pass,[1,-1]) || !$joinin_id) $this->error("参数错误!");
  304. $user_id = $this->auth->id;
  305. // 获取申请信息
  306. $joininInfo = \app\common\model\GuildJoinin::where(["id"=>$joinin_id])->find();
  307. // 获取公会信息
  308. $guildInfo = \app\common\model\Guild::where(["id"=>$joininInfo->guild_id])->find();
  309. // 验证更新条件
  310. if($user_id !== $guildInfo->user_id) $this->error("身份验证失败!您不是公会长,无权限更改!");
  311. // 获取用户信息
  312. $userInfo = \app\common\model\User::field("id,u_id,mobile,nickname")->where(["id"=>$joininInfo->user_id])->find();
  313. // 计算签约时间段
  314. $join_time = $joininInfo->join_time;
  315. $timeArr = [1=>3,2=>6,3=>12];
  316. $endtime = strtotime('+'.$timeArr[$join_time].' month');
  317. $sign_time_slot = date("Y.m.d")."-".date('Y.m.d',$endtime);
  318. Db::startTrans();
  319. try{
  320. $data = [];
  321. $data["user_id"] = $joininInfo->user_id;
  322. $data["operator"] = $user_id;
  323. $data["user_nickname"] = $userInfo->nickname;
  324. $data["user_u_id"] = $userInfo->u_id;
  325. $data["guild_id"] = $guildInfo->id;
  326. $data["guild_name"] = $guildInfo->name;
  327. $data["guild_g_id"] = $guildInfo->g_id;
  328. $data["sign_time_slot"] = $sign_time_slot;
  329. $data["status"] = $is_pass;
  330. $data["createtime"] = time();
  331. $res1 = \app\common\model\GuildJoininLog::insert($data);
  332. // 更新申请状态
  333. $joininInfo->status = $is_pass;
  334. $joininInfo->updatetime = time();
  335. $res2 = $joininInfo->save();
  336. if($is_pass == 1) {
  337. // 同意后 加入公会成员
  338. $data = [];
  339. $data["guild_id"] = $guildInfo->id;
  340. $data["user_id"] = $joininInfo->user_id;
  341. $data["role"] = 0;
  342. $data["sign_type"] = $join_time; // 签约类型:1=三个月,2=半年,3=一年
  343. $data["sign_time"] = $endtime;
  344. $data["status"] = 1;
  345. $data["createtime"] = time();
  346. $res3 = \app\common\model\GuildMember::insert($data);
  347. $res4 = \app\common\model\Guild::where(["id"=>$guildInfo->id])->setInc("member");
  348. if($res1 && $res2 && $res3 && $res4) {
  349. // +message
  350. \app\common\model\Message::addMessage($joininInfo->user_id,"公会审核通知","恭喜,您的加入公会审核通过啦!公会ID:".$guildInfo->g_id);
  351. Db::commit();
  352. $this->success("已审核通过!");
  353. }
  354. } else {
  355. if($res1 && $res2) {
  356. // +message
  357. \app\common\model\Message::addMessage($joininInfo->user_id,"公会审核通知","您的公会加入申请,公会长审核失败,没关系,调整姿势再来一遍!");
  358. Db::commit();
  359. $this->success("已审核拒绝!");
  360. }
  361. }
  362. $this->error("网络错误,请稍后重试!");
  363. }catch (ValidateException $e) {
  364. Db::rollback();
  365. $this->error($e->getMessage());
  366. } catch (PDOException $e) {
  367. Db::rollback();
  368. $this->error($e->getMessage());
  369. } catch (Exception $e) {
  370. Db::rollback();
  371. $this->error($e->getMessage());
  372. }
  373. }
  374. /**
  375. * 公会助手列表
  376. */
  377. public function guildAssistantList() {
  378. $user_id = $this->auth->id;
  379. // 获取公会信息
  380. $guildInfo = \app\common\model\Guild::where(["user_id"=>$user_id])->find();
  381. if(!$guildInfo) $this->error("公会信息获取失败!");
  382. // 先获取申请列表
  383. $where = [];
  384. $where["guild_id"] = $guildInfo->id;
  385. $where["status"] = 0;
  386. $joinList = \app\common\model\GuildJoinin::field("id,user_avatar,user_nickname,guild_name,createtime")->where($where)->order("createtime","desc")->select();
  387. if($joinList) foreach($joinList as $k => $v) {
  388. $joinList[$k]["createtime"] = date("Y-m-d H:i",$v["createtime"]);
  389. }
  390. // 再获取审核记录
  391. $where = [];
  392. $where["a.guild_id"] = $guildInfo->id;
  393. $where["a.user_id"] = $user_id;
  394. $joinlogList = \app\common\model\GuildJoininLog::alias("a")
  395. ->field("a.id,a.user_nickname,a.user_u_id,a.guild_name,a.guild_g_id,a.sign_time_slot,a.status,u.nickname as operator,a.createtime")
  396. ->join("hx_user u","a.operator = u.id")
  397. ->whereOr($where)
  398. ->order("a.createtime","desc")
  399. ->select();
  400. if($joinlogList) foreach($joinlogList as $k => $v) {
  401. $joinlogList[$k]["createtime"] = date("Y-m-d H:i",$v["createtime"]);
  402. }
  403. $res = [];
  404. $res["joinList"] = $joinList;
  405. $res["joinlogList"] = $joinlogList;
  406. $this->success("获取成功!",$res);
  407. }
  408. /**
  409. * 公会申请加入列表
  410. */
  411. public function guildJoinList() {
  412. try {
  413. $user_id = $this->auth->id;
  414. // 获取公会信息
  415. $guildInfo = model('Guild')->where(["user_id"=>$user_id])->find();
  416. if(!$guildInfo) throw new Exception('公会信息获取失败!');
  417. // 先获取申请列表
  418. $where = [];
  419. $where["guild_id"] = $guildInfo->id;
  420. $where["status"] = 0;
  421. $result = model('GuildJoinin')->field("id,user_id,user_avatar,user_nickname,guild_name,createtime")
  422. ->with(['user'=>function($uQuery){
  423. $uQuery->field('id,is_online,onlinetime');
  424. }])
  425. ->where($where)->order("createtime","desc")->select();
  426. if($result) {
  427. foreach($result as $k => &$v) {
  428. $user = isset($v['user']) ? $v['user'] : [];
  429. $onlineText = '';
  430. if (!empty($user)) {
  431. if ($user['is_online'] == 1) {
  432. $onlineText = '在线';
  433. } else {
  434. $onlineTime = get_last_time($user['onlinetime']);
  435. $onlineText = $onlineTime.'在线';
  436. }
  437. }
  438. $v['online_text'] = $onlineText;
  439. $v['createtime'] = !empty($v["createtime"]) ? date("Y-m-d H:i", $v["createtime"]) : '';
  440. unset($v['user']);
  441. }
  442. }
  443. $this->success("获取成功",$result);
  444. } catch (Exception $e) {
  445. $this->error($e->getMessage());
  446. }
  447. }
  448. /**
  449. * 公会成员列表
  450. */
  451. public function guildMember() {
  452. $guild_id = $this->request->request("guild_id",0,"intval"); //公会ID
  453. $page = $this->request->request('page',1); // 分页
  454. $pageNum = $this->request->request('pageNum',10); // 分页
  455. // 分页搜索构建
  456. $pageStart = ($page-1)*$pageNum;
  457. if($guild_id <= 0) $this->error("参数错误!");
  458. $where = [];
  459. $where["a.guild_id"] = $guild_id;
  460. $where["a.status"] = 1;
  461. $where["a.sign_time"] = ["gt",time()];
  462. // 获取公会成员总数
  463. $guildMemberCount = \app\common\model\GuildMember::alias("a")->where($where)->count("id");
  464. // 获取公会成员列表
  465. $guildMemberList = \app\common\model\GuildMember::alias("a")
  466. ->field("a.id,u.avatar,u.nickname,u.gender,u.age,a.role")
  467. ->join("hx_user u","a.user_id = u.id")
  468. ->where($where)
  469. ->limit($pageStart,$pageNum)
  470. ->order("a.role","desc")
  471. ->select();
  472. $role = ["","管理","会长"];
  473. if($guildMemberList) foreach($guildMemberList as $k => &$v) {
  474. $v["role"] = $role[$v["role"]];
  475. }
  476. $res = [];
  477. $res["memberCount"] = $guildMemberCount;
  478. $res["memberList"] = $guildMemberList;
  479. $this->success("获取成功!",$res);
  480. }
  481. /**
  482. * 获取公会成员信息
  483. */
  484. public function getGuildMemberInfo() {
  485. $member_id = $this->request->request("member_id",0,"intval"); //公会成员ID
  486. if($member_id <= 0) $this->error("参数错误!");
  487. $memberInfo = \app\common\model\GuildMember::alias("a")
  488. ->join("hx_user u","u.id = a.user_id")
  489. ->field("u.id,u.avatar,u.nickname,u.gender,u.age,a.wealth,a.charm,a.gift_num,a.role,a.guild_id,a.createtime,u.logintime")
  490. ->find($member_id);
  491. if(!$memberInfo) $this->error("用户信息获取失败!");
  492. $memberInfo["createtime"] = date("Y-m-d",$memberInfo["createtime"]);
  493. $memberInfo["logintime"] = date("Y-m-d",$memberInfo["logintime"]);
  494. $memberInfo["my_role"] = \app\common\model\GuildMember::where(["user_id"=>$this->auth->id,"guild_id"=>$memberInfo->guild_id])->value("role");
  495. $this->success("获取成功!",$memberInfo);
  496. }
  497. /**
  498. * 公会管理-设为管理员
  499. */
  500. public function guildSetManage() {
  501. $guild_id = $this->request->request("guild_id",0,"intval"); //公会ID
  502. $member_user_id = $this->request->request("member_user_id",0,"intval"); //成员用户ID
  503. $type = $this->request->request("type",1); // 设置类型:1=设为管理员,2=取消管理员
  504. if(!$guild_id || !$member_user_id || !in_array($type,[1,2])) $this->error("参数缺失!");
  505. // 先判断是否为公会会长
  506. $user_id = $this->auth->id;
  507. // 获取公会信息
  508. $guildInfo = \app\common\model\Guild::where(["id"=>$guild_id])->find();
  509. // 验证更新条件
  510. if($user_id !== $guildInfo->user_id) $this->error("身份验证失败!您不是公会长,无权限更改!");
  511. $memberInfo = \app\common\model\GuildMember::where(["user_id"=>$member_user_id])->find();
  512. if(!$memberInfo) $this->error("会员信息查询失败!");
  513. if($type == 2) {
  514. $memberInfo->role = 0;
  515. $memberInfo->updatetime = time();
  516. $res = $memberInfo->save();
  517. if($res) {
  518. $this->success("取消成功!");
  519. } else {
  520. $this->error("网络错误,请稍后重试!");
  521. }
  522. }
  523. $memberInfo->role = 1;
  524. $memberInfo->updatetime = time();
  525. $res = $memberInfo->save();
  526. if($res) {
  527. // 获取房间id
  528. $party_id = $guildInfo->party_id;
  529. // 添加房间管理员
  530. $redis = new Redis();
  531. $redisconfig = config("redis");
  532. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  533. if ($redisconfig['redis_pwd']) {
  534. $redis->auth($redisconfig['redis_pwd']);
  535. }
  536. if($redisconfig['redis_selectdb'] > 0){
  537. $redis->select($redisconfig['redis_selectdb']);
  538. }
  539. // 获取成员用户信息
  540. $memberuserInfo = \app\common\model\User::field("id,avatar,nickname,gender,level")->find($member_user_id);
  541. $data = [];
  542. $data["user_id"] = $memberuserInfo->id;
  543. $data["avatar"] = $memberuserInfo->avatar;
  544. $data["nickname"] = $memberuserInfo->nickname;
  545. $data["gender"] = $memberuserInfo->gender;
  546. $data["level"] = $memberuserInfo->level;
  547. $data["item"] = 1;
  548. $data["time"] = 0;
  549. $data["createtime"] = time();
  550. $redis->hSet("party_manage_".$party_id,$memberuserInfo->id."-1",serialize($data));
  551. // 腾讯im设置管理员
  552. $tenim = new Tenim();
  553. $tenim->setImManage($member_user_id,$party_id);
  554. $this->success("设置成功!");
  555. } else {
  556. $this->error("网络错误,请稍后重试!");
  557. }
  558. }
  559. /**
  560. * 公会管理-踢出公会
  561. */
  562. public function guildDelMember() {
  563. $guild_id = $this->request->request("guild_id",0,"intval"); //公会ID
  564. $member_user_id = $this->request->request("member_user_id",0,"intval"); //成员用户ID
  565. if(!$guild_id || !$member_user_id) $this->error("参数缺失!");
  566. // 先判断是否为公会会长
  567. $user_id = $this->auth->id;
  568. // 获取公会信息
  569. $guildInfo = \app\common\model\Guild::where(["id"=>$guild_id])->find();
  570. // 验证更新条件
  571. if($user_id !== $guildInfo->user_id) $this->error("身份验证失败!您不是公会长,无权限更改!");
  572. $memberInfo = \app\common\model\GuildMember::where(["user_id"=>$member_user_id])->find();
  573. if(!$memberInfo) $this->error("会员信息查询失败!");
  574. Db::startTrans();
  575. try{
  576. $res1 = $memberInfo->delete();
  577. $res2 = \app\common\model\Guild::where(["id"=>$guild_id])->setDec("member");
  578. if($res1 && $res2) {
  579. Db::commit();
  580. $this->success("踢出成功!");
  581. } else {
  582. $this->error("网络错误,请稍后重试!");
  583. }
  584. }catch (ValidateException $e) {
  585. Db::rollback();
  586. $this->error($e->getMessage());
  587. } catch (PDOException $e) {
  588. Db::rollback();
  589. $this->error($e->getMessage());
  590. } catch (Exception $e) {
  591. Db::rollback();
  592. $this->error($e->getMessage());
  593. }
  594. }
  595. /**
  596. * 家族贡献榜排行
  597. * @return void
  598. */
  599. public function getRankList()
  600. {
  601. try {
  602. $id = $this->request->param('guild_id',0);
  603. $guildMemberWhere['guild_id'] = $id;
  604. $guildMemberWhere['status'] = 1;
  605. $guildMember = model('GuildMember')->field('id,user_id')->where($guildMemberWhere)->select();
  606. $list = [];
  607. if (!empty($guildMember)) {
  608. $userIds = array_column($guildMember,'user_id');
  609. $where = [];
  610. $where['a.user_to_id'] = ['in', $userIds];
  611. $list = model('GiftUserParty')->alias("a")
  612. ->field('sum(a.value) as total_price,a.user_id,u.avatar,u.nickname')
  613. ->where($where)
  614. ->join('hx_user u','u.id = a.user_id')
  615. ->group('a.user_to_id')
  616. ->order('total_price',"desc")
  617. ->limit(100)
  618. ->select();
  619. if (!empty($list)) {
  620. foreach ($list as $key => &$value) {
  621. $value['total_price_text'] = $value['total_price'];
  622. if ($value['total_price'] >= 10000) {
  623. $value['total_price_text'] = bcdiv($value['total_price'],10000,1).'w';
  624. }
  625. unset($value['total_price']);
  626. }
  627. }
  628. }
  629. $this->success(__('Operation completed'),$list);
  630. } catch (Exception $e) {
  631. $this->error($e->getMessage());
  632. }
  633. }
  634. }