Party.php 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238
  1. <?php
  2. namespace app\admin\controller\party;
  3. use app\common\controller\Backend;
  4. use tencentim\tencentim;
  5. use getusersig\getusersig;
  6. use think\Db;
  7. use Redis;
  8. /**
  9. * 派对管理
  10. *
  11. * @icon fa fa-circle-o
  12. */
  13. class Party extends Backend
  14. {
  15. protected $searchFields = 'user.u_id,user.nickname,party_id,party_name';
  16. /**
  17. * Party模型对象
  18. * @var \app\admin\model\party\Party
  19. */
  20. protected $model = null;
  21. public function _initialize()
  22. {
  23. parent::_initialize();
  24. $this->model = new \app\admin\model\party\Party;
  25. $this->view->assign("roomTypeList", $this->model->getRoomTypeList());
  26. $this->view->assign("isOnlineList", $this->model->getIsOnlineList());
  27. $this->view->assign("statusList", $this->model->getStatusList());
  28. $this->view->assign("isRecommendList", $this->model->getIsRecommendList());
  29. $this->view->assign("isCloseList", $this->model->getIsCloseList());
  30. $this->view->assign("isScreenList", $this->model->getIsScreenList());
  31. $this->view->assign("onModelList", $this->model->getOnModelList());
  32. $partyTypeModel = new \app\admin\model\party\Type();
  33. $partyTypeData = $partyTypeModel->select();
  34. $partyTypeList = [];
  35. if (!empty($partyTypeData)) {
  36. foreach ($partyTypeData as $key => $value) {
  37. $partyTypeList[$key] = [
  38. 'id' => $value['name'],
  39. 'name' => $value['name'],
  40. ];
  41. }
  42. }
  43. $this->assignconfig([
  44. 'partyTypeList' => $partyTypeList,
  45. ]);
  46. }
  47. public function import()
  48. {
  49. parent::import();
  50. }
  51. /**
  52. * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
  53. * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
  54. * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
  55. */
  56. /**
  57. * 查看
  58. */
  59. public function index()
  60. {
  61. //当前是否为关联查询
  62. $this->relationSearch = true;
  63. //设置过滤方法
  64. $this->request->filter(['strip_tags', 'trim']);
  65. if ($this->request->isAjax()) {
  66. //如果发送的来源是Selectpage,则转发到Selectpage
  67. if ($this->request->request('keyField')) {
  68. return $this->selectpage();
  69. }
  70. list($where, $sort, $order, $offset, $limit) = $this->buildparams();
  71. $party = 'party';
  72. $user = 'user';
  73. $partyType = 'party_type';
  74. $field = $party.'.id,'.$party.'.room_type,party_id,party_hot,party_name,party_logo,party_notice,party_notice_detail,naming,
  75. '.$party.'.is_online,'.$party.'.status,is_close,is_recommend,party_type,platRate,guilderRate,party_pass,is_screen,on_model,
  76. background,'.$party.'.updatetime,'.$party.'.createtime,'.$user.'.u_id as `'.$user.'.u_id`,'.
  77. $user.'.nickname as `'.$user.'.nickname`,'.$partyType.'.name as `'.$partyType.'.name`';
  78. $list = $this->model->alias($party)->field($field)
  79. ->join($user, $user.'.id = '.$party.'.user_id', 'LEFT')
  80. ->join($partyType, $partyType.'.id = '.$party.'.party_type', 'LEFT')
  81. ->where($where)
  82. ->order($sort, $order)
  83. ->paginate($limit);
  84. /*foreach ($list as $row) {
  85. $row->getRelation('user')->visible(['u_id', 'nickname']);
  86. }*/
  87. $result = array("total" => $list->total(), "rows" => $list->items());
  88. return json($result);
  89. }
  90. return $this->view->fetch();
  91. }
  92. /**
  93. * 编辑
  94. */
  95. public function edit($ids = null)
  96. {
  97. $row = $this->model->get($ids);
  98. if (!$row) {
  99. $this->error(__('No Results were found'));
  100. }
  101. $adminIds = $this->getDataLimitAdminIds();
  102. if (is_array($adminIds)) {
  103. if (!in_array($row[$this->dataLimitField], $adminIds)) {
  104. $this->error(__('You have no permission'));
  105. }
  106. }
  107. if ($this->request->isPost()) {
  108. $params = $this->request->post("row/a");
  109. if ($params) {
  110. $params = $this->preExcludeFields($params);
  111. $result = false;
  112. Db::startTrans();
  113. try {
  114. $roomTypeArr = [1=>"party",2=>"live"];
  115. $room_type = $row->room_type;
  116. $party_id = $row->id;
  117. if($party_id > 0) {
  118. // 存redis 房间信息
  119. $redis = new Redis();
  120. $redisconfig = config("redis");
  121. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  122. if ($redisconfig['redis_pwd']) {
  123. $redis->auth($redisconfig['redis_pwd']);
  124. }
  125. if($redisconfig['redis_selectdb'] > 0){
  126. $redis->select($redisconfig['redis_selectdb']);
  127. }
  128. $partyInfo = $redis->get($roomTypeArr[$room_type]."_".$party_id);
  129. if($partyInfo) {
  130. $partyInfo = json_decode($partyInfo,true);
  131. $partyInfo = array_replace($partyInfo,$params);
  132. $redis->set($roomTypeArr[$room_type]."_".$party_id,json_encode($partyInfo));
  133. }
  134. }
  135. if($params["is_close"] == 1) {
  136. // 强制关闭需要退出正在房间的用户
  137. $this->outMemberFromRoom($ids);
  138. }
  139. //是否采用模型验证
  140. if ($this->modelValidate) {
  141. $name = str_replace("\\model\\", "\\validate\\", get_class($this->model));
  142. $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.edit' : $name) : $this->modelValidate;
  143. $row->validateFailException(true)->validate($validate);
  144. }
  145. $result = $row->allowField(true)->save($params);
  146. Db::commit();
  147. } catch (ValidateException $e) {
  148. Db::rollback();
  149. $this->error($e->getMessage());
  150. } catch (PDOException $e) {
  151. Db::rollback();
  152. $this->error($e->getMessage());
  153. } catch (Exception $e) {
  154. Db::rollback();
  155. $this->error($e->getMessage());
  156. }
  157. if ($result !== false) {
  158. $this->success();
  159. } else {
  160. $this->error(__('No rows were updated'));
  161. }
  162. }
  163. $this->error(__('Parameter %s can not be empty', ''));
  164. }
  165. $this->view->assign("row", $row);
  166. return $this->view->fetch();
  167. }
  168. /**
  169. * 踢出房间内所有用户
  170. */
  171. private function outMemberFromRoom($party_id) {
  172. if($party_id <= 0) return false;
  173. $message = [];
  174. $message["type"] = "91";
  175. $message["content"] = "房间已被管理员关闭!详情请联系客服!";
  176. $msgData = [];
  177. $msgData["version"] = "1.0";
  178. $msgData["action"] = 301;
  179. $msgData["command"] = "";
  180. $msgData["message"] = json_encode($message);
  181. $random = rand(10000000,99999999);
  182. $usersig = $this->usersig("administrator");
  183. // 获取配置信息
  184. $config = config("tencent_im");
  185. $url = "https://console.tim.qq.com/v4/group_open_http_svc/send_group_msg";
  186. $url .= "?sdkappid=".$config["sdkappid"];
  187. $url .= "&identifier=administrator";
  188. $url .= "&usersig=".$usersig;
  189. $url .= "&random=".$random;
  190. $url .= "&contenttype=json";
  191. $tencentObj = new tencentim($url);
  192. $data = [];
  193. $data["GroupId"] = $party_id;
  194. $data["Random"] = rand(1000000,9999999);
  195. $data["MsgBody"][] = [
  196. "MsgType" => "TIMCustomElem",
  197. "MsgContent" => [
  198. "Data"=> json_encode($msgData)
  199. ],
  200. ];
  201. $tencentObj->toSend($data);
  202. }
  203. /**
  204. * 获取usersig签名-具体操作
  205. */
  206. private function usersig($user_id) {
  207. // 获取配置信息
  208. $config = config("tencent_im");
  209. $usersigObj = new getusersig($config["sdkappid"],$config["key"]);
  210. $usersig = $usersigObj->genUserSig($user_id);
  211. return $usersig;
  212. }
  213. }