Guild.php 34 KB

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