Guild.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643
  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_id) $this->error("参数错误!");
  132. if(!$guild_name && !$guild_image && !$guild_desc && !$guild_notice) $this->error("请输入要修改的内容!");
  133. $user_id = $this->auth->id;
  134. // 获取公会信息
  135. $guildInfo = \app\common\model\Guild::where(["id"=>$guild_id])->find();
  136. // 验证更新条件
  137. if($user_id !== $guildInfo->user_id) $this->error("身份验证失败!您不是公会长,无权限更改!");
  138. $guild_name && $guildInfo->name = $guild_name;
  139. $guild_image && $guildInfo->image = $guild_image;
  140. $guild_desc && $guildInfo->desc = $guild_desc;
  141. $guild_notice && $guildInfo->notice = $guild_notice;
  142. $res = $guildInfo->save();
  143. if($res !== false) {
  144. $this->success("更新成功!");
  145. } else {
  146. $this->error("网络错误,请稍后重试!");
  147. }
  148. }
  149. /**
  150. * 获取搜索公会列表
  151. */
  152. public function getGuildList() {
  153. $search = $this->request->request("search","","string"); //搜索的字段 公会名称/公会ID
  154. if(!$search) $this->error("请输入要搜索的公会名称或公会ID");
  155. global $whereOr;
  156. $where = [];$whereOr = [];
  157. $where['status'] = 1;
  158. $whereOr['name'] = array('like', '%' . $search . '%');
  159. $whereOr['g_id'] = $search;
  160. $res = \app\common\model\Guild::field("id,g_id,user_id,party_id,name,image,desc,member")
  161. ->where($where)
  162. ->where(function ($query) {
  163. global $whereOr;
  164. $query->whereOr($whereOr);
  165. })
  166. ->select();
  167. $this->success("获取成功!",$res);
  168. }
  169. /**
  170. * 公会申请页面信息
  171. */
  172. public function guildApplyInfo() {
  173. $guild_id = $this->request->request("guild_id"); //公会ID
  174. if($guild_id <= 0) $this->error("参数缺失!");
  175. $guildInfo = \app\common\model\Guild::alias("a")
  176. ->join("hx_user u","u.id = a.user_id","inner")
  177. ->field("a.id,a.image,a.name,a.g_id,a.user_id,u.avatar,u.nickname,u.u_id")
  178. ->where(["a.id"=>$guild_id])
  179. ->find();
  180. $guildInfo["status"] = 0;
  181. // 获取申请用户是否已经有正在申请的记录
  182. $user_id = $this->auth->id;
  183. $joinStatus = \app\common\model\GuildJoinin::where(["user_id"=>$user_id])->value("status");
  184. if($joinStatus === 0) $guildInfo["status"] = 1;
  185. $Member = \app\common\model\GuildMember::where(["user_id"=>$user_id,"status"=>1,"sign_time"=>["gt",time()]])->value("id");
  186. if($Member > 0) $guildInfo["status"] = 2;
  187. $this->success("获取成功!",$guildInfo);
  188. }
  189. /**
  190. * 开厅申请
  191. */
  192. public function guildApply() {
  193. $user_id = $this->auth->id;
  194. // 获取用户实名认证信息
  195. $authUserRealname = \app\common\model\UserAuth::where(["user_id"=>$user_id])->value("realname");
  196. if(!$authUserRealname) $this->error("未查询到实名认证信息,请实名认证先!");
  197. // 获取用户信息
  198. $userInfo = \app\common\model\User::field("id,mobile,nickname")->where(["id"=>$user_id])->find();
  199. $data = [];
  200. $data["user_id"] = $user_id;
  201. // 查看是否申请过
  202. $applyInfo = \app\common\model\GuildApply::where($data)->find();
  203. if($applyInfo && $applyInfo->status>=0) $this->error("您已经发送过开厅申请了,请勿重复发送!");
  204. // 查看是否有加入公会的申请
  205. $joinInfo = \app\common\model\GuildJoinin::where(["user_id"=>$user_id,"status"=>0])->find();
  206. if($joinInfo) $this->error("您存在申请加入公会信息,请联系工会长处理完毕后方可申请开厅!");
  207. // 查看是已经是公会成员
  208. $memberInfo = \app\common\model\GuildMember::where(["user_id"=>$user_id,"status"=>1,"sign_time"=>["gt",time()]])->find();
  209. if($memberInfo) $this->error("您已存在签约中的公会,无法开新厅!");
  210. Db::startTrans();
  211. try{
  212. $data["user_name"] = $authUserRealname;
  213. $data["user_nickname"] = $userInfo->nickname;
  214. $data["user_mobile"] = $userInfo->mobile;
  215. $data["createtime"] = time();
  216. $res1 = \app\common\model\GuildApply::insert($data);
  217. // 更新用户状态
  218. $userInfo->is_guild = 1;
  219. $res2 = $userInfo->save();
  220. if($res1 && $res2) {
  221. Db::commit();
  222. $this->success("申请发送成功!");
  223. } else {
  224. $this->error("网络错误,请稍后重试!");
  225. }
  226. }catch (ValidateException $e) {
  227. Db::rollback();
  228. $this->error($e->getMessage());
  229. } catch (PDOException $e) {
  230. Db::rollback();
  231. $this->error($e->getMessage());
  232. } catch (Exception $e) {
  233. Db::rollback();
  234. $this->error($e->getMessage());
  235. }
  236. }
  237. /**
  238. * 公会签约申请
  239. */
  240. public function guildJoinin() {
  241. $join_time = $this->request->request("join_time"); //签约时长:1=3个月,2=6个月,3=12个月
  242. $guild_id = $this->request->request("guild_id"); //公会ID
  243. if(!in_array($join_time,[1,2,3]) || !$guild_id) $this->error("参数错误!");
  244. // 一个身份证号只能申请一次
  245. $user_id = $this->auth->id;
  246. // 实名认证
  247. $userAuthInfo = \app\common\model\UserAuth::where(["user_id"=>$user_id])->find();
  248. if($userAuthInfo) {
  249. if($userAuthInfo->status == 0) {
  250. $this->error("您的实名认证还在这审核中...,请耐心等待!");
  251. } elseif($userAuthInfo->status == 2) {
  252. $this->error("您的实名认证审核未通过,请重新审核!");
  253. }
  254. } else {
  255. $this->error("请先申请实名认证!");
  256. }
  257. // 获取用户实名认证信息
  258. $authUserIdcard = \app\common\model\UserAuth::where(["user_id"=>$user_id])->value("idcard");
  259. // 搜索签约申请中是否有此身份证号
  260. $idcardfind = \app\common\model\GuildJoinin::where(["user_id"=>$user_id,"status"=>0])->find();
  261. if($idcardfind) $this->error("当前账号正在审核,请耐心等待!");
  262. $memberfind = \app\common\model\GuildMember::where(["user_id"=>$user_id,"status"=>1,"sign_time"=>["gt",time()]])->find();
  263. if($memberfind) $this->error("一个账号只能加入一个公会哟!");
  264. // 查看是否申请过
  265. $applyInfo = \app\common\model\GuildApply::where(["user_id"=>$user_id,"status"=>0])->find();
  266. if($applyInfo && $applyInfo->status>=0) $this->error("您已经发送过开厅申请了,请勿重复发送!");
  267. // // 获取公会信息
  268. // $guildInfo = \app\common\model\Guild::where(["user_id"=>$user_id,"status"=>1])->find();
  269. // // 验证更新条件
  270. // if($guildInfo) $this->error("您存在公会会长身份,请先解散相应的公会才可申请");
  271. // 获取公会信息
  272. $guildName = \app\common\model\Guild::where(["id"=>$guild_id])->value("name");
  273. // 获取用户信息
  274. $userInfo = \app\common\model\User::field("id,avatar,nickname")->where(["id"=>$user_id])->find();
  275. // 添加数据
  276. $data = [];
  277. $data["user_id"] = $user_id;
  278. $data["guild_id"] = $guild_id;
  279. $data["join_time"] = $join_time;
  280. $data["user_avatar"] = $userInfo->avatar;
  281. $data["user_idcard"] = $authUserIdcard;
  282. $data["user_nickname"] = $userInfo->nickname;
  283. $data["guild_name"] = $guildName;
  284. $data["createtime"] = time();
  285. $res = \app\common\model\GuildJoinin::insert($data);
  286. if($res) {
  287. // +message
  288. // \app\common\model\Message::addMessage($user_id,"公会消息","申请加入公会消息");
  289. $this->success("申请发送成功!");
  290. } else {
  291. $this->error("网络错误,请稍后重试!");
  292. }
  293. }
  294. /**
  295. * 公会签约申请审核
  296. */
  297. public function guildJoininExamine() {
  298. $joinin_id = $this->request->request("joinin_id"); // 申请加入的申请ID
  299. $is_pass = $this->request->request("is_pass"); // 是否通过:1=通过,-1=拒绝
  300. if(!in_array($is_pass,[1,-1]) || !$joinin_id) $this->error("参数错误!");
  301. $user_id = $this->auth->id;
  302. // 获取申请信息
  303. $joininInfo = \app\common\model\GuildJoinin::where(["id"=>$joinin_id])->find();
  304. // 获取公会信息
  305. $guildInfo = \app\common\model\Guild::where(["id"=>$joininInfo->guild_id])->find();
  306. // 验证更新条件
  307. if($user_id !== $guildInfo->user_id) $this->error("身份验证失败!您不是公会长,无权限更改!");
  308. // 获取用户信息
  309. $userInfo = \app\common\model\User::field("id,u_id,mobile,nickname")->where(["id"=>$joininInfo->user_id])->find();
  310. // 计算签约时间段
  311. $join_time = $joininInfo->join_time;
  312. $timeArr = [1=>3,2=>6,3=>12];
  313. $endtime = strtotime('+'.$timeArr[$join_time].' month');
  314. $sign_time_slot = date("Y.m.d")."-".date('Y.m.d',$endtime);
  315. Db::startTrans();
  316. try{
  317. $data = [];
  318. $data["user_id"] = $joininInfo->user_id;
  319. $data["operator"] = $user_id;
  320. $data["user_nickname"] = $userInfo->nickname;
  321. $data["user_u_id"] = $userInfo->u_id;
  322. $data["guild_id"] = $guildInfo->id;
  323. $data["guild_name"] = $guildInfo->name;
  324. $data["guild_g_id"] = $guildInfo->g_id;
  325. $data["sign_time_slot"] = $sign_time_slot;
  326. $data["status"] = $is_pass;
  327. $data["createtime"] = time();
  328. $res1 = \app\common\model\GuildJoininLog::insert($data);
  329. // 更新申请状态
  330. $joininInfo->status = $is_pass;
  331. $joininInfo->updatetime = time();
  332. $res2 = $joininInfo->save();
  333. if($is_pass == 1) {
  334. // 同意后 加入公会成员
  335. $data = [];
  336. $data["guild_id"] = $guildInfo->id;
  337. $data["user_id"] = $joininInfo->user_id;
  338. $data["role"] = 0;
  339. $data["sign_type"] = $join_time; // 签约类型:1=三个月,2=半年,3=一年
  340. $data["sign_time"] = $endtime;
  341. $data["status"] = 1;
  342. $data["createtime"] = time();
  343. $res3 = \app\common\model\GuildMember::insert($data);
  344. $res4 = \app\common\model\Guild::where(["id"=>$guildInfo->id])->setInc("member");
  345. if($res1 && $res2 && $res3 && $res4) {
  346. // +message
  347. \app\common\model\Message::addMessage($joininInfo->user_id,"公会审核通知","恭喜,您的加入公会审核通过啦!公会ID:".$guildInfo->g_id);
  348. Db::commit();
  349. $this->success("已审核通过!");
  350. }
  351. } else {
  352. if($res1 && $res2) {
  353. // +message
  354. \app\common\model\Message::addMessage($joininInfo->user_id,"公会审核通知","您的公会加入申请,公会长审核失败,没关系,调整姿势再来一遍!");
  355. Db::commit();
  356. $this->success("已审核拒绝!");
  357. }
  358. }
  359. $this->error("网络错误,请稍后重试!");
  360. }catch (ValidateException $e) {
  361. Db::rollback();
  362. $this->error($e->getMessage());
  363. } catch (PDOException $e) {
  364. Db::rollback();
  365. $this->error($e->getMessage());
  366. } catch (Exception $e) {
  367. Db::rollback();
  368. $this->error($e->getMessage());
  369. }
  370. }
  371. /**
  372. * 公会助手列表
  373. */
  374. public function guildAssistantList() {
  375. $user_id = $this->auth->id;
  376. // 获取公会信息
  377. $guildInfo = \app\common\model\Guild::where(["user_id"=>$user_id])->find();
  378. if(!$guildInfo) $this->error("公会信息获取失败!");
  379. // 先获取申请列表
  380. $where = [];
  381. $where["guild_id"] = $guildInfo->id;
  382. $where["status"] = 0;
  383. $joinList = \app\common\model\GuildJoinin::field("id,user_avatar,user_nickname,guild_name,createtime")->where($where)->order("createtime","desc")->select();
  384. if($joinList) foreach($joinList as $k => $v) {
  385. $joinList[$k]["createtime"] = date("Y-m-d H:i",$v["createtime"]);
  386. }
  387. // 再获取审核记录
  388. $where = [];
  389. $where["a.guild_id"] = $guildInfo->id;
  390. $where["a.user_id"] = $user_id;
  391. $joinlogList = \app\common\model\GuildJoininLog::alias("a")
  392. ->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")
  393. ->join("hx_user u","a.operator = u.id")
  394. ->whereOr($where)
  395. ->order("a.createtime","desc")
  396. ->select();
  397. if($joinlogList) foreach($joinlogList as $k => $v) {
  398. $joinlogList[$k]["createtime"] = date("Y-m-d H:i",$v["createtime"]);
  399. }
  400. $res = [];
  401. $res["joinList"] = $joinList;
  402. $res["joinlogList"] = $joinlogList;
  403. $this->success("获取成功!",$res);
  404. }
  405. /**
  406. * 公会申请加入列表
  407. */
  408. public function guildJoinList() {
  409. try {
  410. $user_id = $this->auth->id;
  411. // 获取公会信息
  412. $guildInfo = model('Guild')->where(["user_id"=>$user_id])->find();
  413. if(!$guildInfo) throw new Exception('公会信息获取失败!');
  414. // 先获取申请列表
  415. $where = [];
  416. $where["guild_id"] = $guildInfo->id;
  417. $where["status"] = 0;
  418. $result = model('GuildJoinin')->field("id,user_id,user_avatar,user_nickname,guild_name,createtime")
  419. ->with(['user'=>function($uQuery){
  420. $uQuery->field('id,is_online,onlinetime');
  421. }])
  422. ->where($where)->order("createtime","desc")->select();
  423. if($result) {
  424. foreach($result as $k => &$v) {
  425. $user = isset($v['user']) ? $v['user'] : [];
  426. $onlineText = '';
  427. if (!empty($user)) {
  428. if ($user['is_online'] == 1) {
  429. $onlineText = '在线';
  430. } else {
  431. $onlineTime = get_last_time($user['onlinetime']);
  432. $onlineText = $onlineTime.'在线';
  433. }
  434. }
  435. $v['online_text'] = $onlineText;
  436. $v['createtime'] = !empty($v["createtime"]) ? date("Y-m-d H:i", $v["createtime"]) : '';
  437. unset($v['user']);
  438. }
  439. }
  440. $this->success("获取成功",$result);
  441. } catch (Exception $e) {
  442. $this->error($e->getMessage());
  443. }
  444. }
  445. /**
  446. * 公会成员列表
  447. */
  448. public function guildMember() {
  449. $guild_id = $this->request->request("guild_id",0,"intval"); //公会ID
  450. $page = $this->request->request('page',1); // 分页
  451. $pageNum = $this->request->request('pageNum',10); // 分页
  452. // 分页搜索构建
  453. $pageStart = ($page-1)*$pageNum;
  454. if($guild_id <= 0) $this->error("参数错误!");
  455. $where = [];
  456. $where["a.guild_id"] = $guild_id;
  457. $where["a.status"] = 1;
  458. $where["a.sign_time"] = ["gt",time()];
  459. // 获取公会成员总数
  460. $guildMemberCount = \app\common\model\GuildMember::alias("a")->where($where)->count("id");
  461. // 获取公会成员列表
  462. $guildMemberList = \app\common\model\GuildMember::alias("a")
  463. ->field("a.id,u.avatar,u.nickname,u.gender,u.age,a.role")
  464. ->join("hx_user u","a.user_id = u.id")
  465. ->where($where)
  466. ->limit($pageStart,$pageNum)
  467. ->order("a.role","desc")
  468. ->select();
  469. $role = ["","管理","会长"];
  470. if($guildMemberList) foreach($guildMemberList as $k => &$v) {
  471. $v["role"] = $role[$v["role"]];
  472. }
  473. $res = [];
  474. $res["memberCount"] = $guildMemberCount;
  475. $res["memberList"] = $guildMemberList;
  476. $this->success("获取成功!",$res);
  477. }
  478. /**
  479. * 获取公会成员信息
  480. */
  481. public function getGuildMemberInfo() {
  482. $member_id = $this->request->request("member_id",0,"intval"); //公会成员ID
  483. if($member_id <= 0) $this->error("参数错误!");
  484. $memberInfo = \app\common\model\GuildMember::alias("a")
  485. ->join("hx_user u","u.id = a.user_id")
  486. ->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")
  487. ->find($member_id);
  488. if(!$memberInfo) $this->error("用户信息获取失败!");
  489. $memberInfo["createtime"] = date("Y-m-d",$memberInfo["createtime"]);
  490. $memberInfo["logintime"] = date("Y-m-d",$memberInfo["logintime"]);
  491. $memberInfo["my_role"] = \app\common\model\GuildMember::where(["user_id"=>$this->auth->id,"guild_id"=>$memberInfo->guild_id])->value("role");
  492. $this->success("获取成功!",$memberInfo);
  493. }
  494. /**
  495. * 公会管理-设为管理员
  496. */
  497. public function guildSetManage() {
  498. $guild_id = $this->request->request("guild_id",0,"intval"); //公会ID
  499. $member_user_id = $this->request->request("member_user_id",0,"intval"); //成员用户ID
  500. $type = $this->request->request("type",1); // 设置类型:1=设为管理员,2=取消管理员
  501. if(!$guild_id || !$member_user_id || !in_array($type,[1,2])) $this->error("参数缺失!");
  502. // 先判断是否为公会会长
  503. $user_id = $this->auth->id;
  504. // 获取公会信息
  505. $guildInfo = \app\common\model\Guild::where(["id"=>$guild_id])->find();
  506. // 验证更新条件
  507. if($user_id !== $guildInfo->user_id) $this->error("身份验证失败!您不是公会长,无权限更改!");
  508. $memberInfo = \app\common\model\GuildMember::where(["user_id"=>$member_user_id])->find();
  509. if(!$memberInfo) $this->error("会员信息查询失败!");
  510. if($type == 2) {
  511. $memberInfo->role = 0;
  512. $memberInfo->updatetime = time();
  513. $res = $memberInfo->save();
  514. if($res) {
  515. $this->success("取消成功!");
  516. } else {
  517. $this->error("网络错误,请稍后重试!");
  518. }
  519. }
  520. $memberInfo->role = 1;
  521. $memberInfo->updatetime = time();
  522. $res = $memberInfo->save();
  523. if($res) {
  524. // 获取房间id
  525. $party_id = $guildInfo->party_id;
  526. // 添加房间管理员
  527. $redis = new Redis();
  528. $redisconfig = config("redis");
  529. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  530. if ($redisconfig['redis_pwd']) {
  531. $redis->auth($redisconfig['redis_pwd']);
  532. }
  533. if($redisconfig['redis_selectdb'] > 0){
  534. $redis->select($redisconfig['redis_selectdb']);
  535. }
  536. // 获取成员用户信息
  537. $memberuserInfo = \app\common\model\User::field("id,avatar,nickname,gender,level")->find($member_user_id);
  538. $data = [];
  539. $data["user_id"] = $memberuserInfo->id;
  540. $data["avatar"] = $memberuserInfo->avatar;
  541. $data["nickname"] = $memberuserInfo->nickname;
  542. $data["gender"] = $memberuserInfo->gender;
  543. $data["level"] = $memberuserInfo->level;
  544. $data["item"] = 1;
  545. $data["time"] = 0;
  546. $data["createtime"] = time();
  547. $redis->hSet("party_manage_".$party_id,$memberuserInfo->id."-1",serialize($data));
  548. // 腾讯im设置管理员
  549. $tenim = new Tenim();
  550. $tenim->setImManage($member_user_id,$party_id);
  551. $this->success("设置成功!");
  552. } else {
  553. $this->error("网络错误,请稍后重试!");
  554. }
  555. }
  556. /**
  557. * 公会管理-踢出公会
  558. */
  559. public function guildDelMember() {
  560. $guild_id = $this->request->request("guild_id",0,"intval"); //公会ID
  561. $member_user_id = $this->request->request("member_user_id",0,"intval"); //成员用户ID
  562. if(!$guild_id || !$member_user_id) $this->error("参数缺失!");
  563. // 先判断是否为公会会长
  564. $user_id = $this->auth->id;
  565. // 获取公会信息
  566. $guildInfo = \app\common\model\Guild::where(["id"=>$guild_id])->find();
  567. // 验证更新条件
  568. if($user_id !== $guildInfo->user_id) $this->error("身份验证失败!您不是公会长,无权限更改!");
  569. $memberInfo = \app\common\model\GuildMember::where(["user_id"=>$member_user_id])->find();
  570. if(!$memberInfo) $this->error("会员信息查询失败!");
  571. Db::startTrans();
  572. try{
  573. $res1 = $memberInfo->delete();
  574. $res2 = \app\common\model\Guild::where(["id"=>$guild_id])->setDec("member");
  575. if($res1 && $res2) {
  576. Db::commit();
  577. $this->success("踢出成功!");
  578. } else {
  579. $this->error("网络错误,请稍后重试!");
  580. }
  581. }catch (ValidateException $e) {
  582. Db::rollback();
  583. $this->error($e->getMessage());
  584. } catch (PDOException $e) {
  585. Db::rollback();
  586. $this->error($e->getMessage());
  587. } catch (Exception $e) {
  588. Db::rollback();
  589. $this->error($e->getMessage());
  590. }
  591. }
  592. }