model = new \app\admin\model\party\Party; $this->view->assign("isCoolList", $this->model->getIsCoolList()); $this->view->assign("roomTypeList", $this->model->getRoomTypeList()); $this->view->assign("isOnlineList", $this->model->getIsOnlineList()); $this->view->assign("statusList", $this->model->getStatusList()); $this->view->assign("isRecommendList", $this->model->getIsRecommendList()); $this->view->assign("isCloseList", $this->model->getIsCloseList()); $this->view->assign("isScreenList", $this->model->getIsScreenList()); $this->view->assign("onModelList", $this->model->getOnModelList()); $partyTypeModel = new \app\admin\model\party\Type(); $partyTypeData = $partyTypeModel->select(); $partyTypeList = []; if (!empty($partyTypeData)) { foreach ($partyTypeData as $key => $value) { $partyTypeList[$key] = [ 'id' => $value['name'], 'name' => $value['name'], ]; } } $this->assignconfig([ 'partyTypeList' => $partyTypeList, ]); } public function import() { parent::import(); } /** * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法 * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑 * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改 */ /** * 查看 */ public function index() { //当前是否为关联查询 $this->relationSearch = true; //设置过滤方法 $this->request->filter(['strip_tags', 'trim']); if ($this->request->isAjax()) { //如果发送的来源是Selectpage,则转发到Selectpage if ($this->request->request('keyField')) { return $this->selectpage(); } list($where, $sort, $order, $offset, $limit) = $this->buildparams(); $party = 'party'; $user = 'user'; $partyType = 'party_type'; $field = $party.'.id,'.$party.'.room_type,party_id,party_hot,party_name,party_logo,party_notice,party_notice_detail,naming, '.$party.'.is_online,'.$party.'.status,'. $party .'.is_cool,is_close,is_recommend,party_type,platRate,guilderRate,party_pass,is_screen,on_model, background,'.$party.'.updatetime,'.$party.'.createtime,'.$user.'.u_id as `'.$user.'.u_id`,'. $user.'.nickname as `'.$user.'.nickname`,'.$partyType.'.name as `'.$partyType.'.name`'; $list = $this->model->alias($party)->field($field) ->join($user, $user.'.id = '.$party.'.user_id', 'LEFT') ->join($partyType, $partyType.'.id = '.$party.'.party_type', 'LEFT') ->where($where) ->order($sort, $order) ->paginate($limit); /*foreach ($list as $row) { $row->getRelation('user')->visible(['u_id', 'nickname']); }*/ $result = array("total" => $list->total(), "rows" => $list->items()); return json($result); } return $this->view->fetch(); } /** * 编辑 */ public function edit($ids = null) { $row = $this->model->get($ids); if (!$row) { $this->error(__('No Results were found')); } $adminIds = $this->getDataLimitAdminIds(); if (is_array($adminIds)) { if (!in_array($row[$this->dataLimitField], $adminIds)) { $this->error(__('You have no permission')); } } if ($this->request->isPost()) { $params = $this->request->post("row/a"); if ($params) { $params = $this->preExcludeFields($params); $result = false; Db::startTrans(); try { //判断房间id去重 $check = Db::name('party')->where('party_id',$params['party_id'])->where('id','neq',$ids)->find(); if($check){ Db::rollback(); $this->error('重复的派对id'); } $roomTypeArr = [1=>"party",2=>"live"]; $room_type = $row->room_type; $party_id = $row->id; if($party_id > 0) { // 存redis 房间信息 $redis = new Redis(); $redisconfig = config("redis"); $redis->connect($redisconfig["host"], $redisconfig["port"]); if ($redisconfig['redis_pwd']) { $redis->auth($redisconfig['redis_pwd']); } if($redisconfig['redis_selectdb'] > 0){ $redis->select($redisconfig['redis_selectdb']); } $partyInfo = $redis->get($roomTypeArr[$room_type]."_".$party_id); if($partyInfo) { $partyInfo = json_decode($partyInfo,true); $partyInfo = array_replace($partyInfo,$params); $redis->set($roomTypeArr[$room_type]."_".$party_id,json_encode($partyInfo)); } } if($params["is_close"] == 1) { // 强制关闭需要退出正在房间的用户 $this->outMemberFromRoom($ids); } //是否采用模型验证 if ($this->modelValidate) { $name = str_replace("\\model\\", "\\validate\\", get_class($this->model)); $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.edit' : $name) : $this->modelValidate; $row->validateFailException(true)->validate($validate); } $result = $row->allowField(true)->save($params); Db::commit(); } catch (ValidateException $e) { Db::rollback(); $this->error($e->getMessage()); } catch (PDOException $e) { Db::rollback(); $this->error($e->getMessage()); } catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if ($result !== false) { $this->success(); } else { $this->error(__('No rows were updated')); } } $this->error(__('Parameter %s can not be empty', '')); } $this->view->assign("row", $row); return $this->view->fetch(); } /** * 踢出房间内所有用户 */ private function outMemberFromRoom($party_id) { if($party_id <= 0) return false; $message = []; $message["type"] = "91"; $message["content"] = "房间已被管理员关闭!详情请联系客服!"; $msgData = []; $msgData["version"] = "1.0"; $msgData["action"] = 301; $msgData["command"] = ""; $msgData["message"] = json_encode($message); $random = rand(10000000,99999999); $usersig = $this->usersig("administrator"); // 获取配置信息 $config = config("tencent_im"); $url = "https://console.tim.qq.com/v4/group_open_http_svc/send_group_msg"; $url .= "?sdkappid=".$config["sdkappid"]; $url .= "&identifier=administrator"; $url .= "&usersig=".$usersig; $url .= "&random=".$random; $url .= "&contenttype=json"; $tencentObj = new tencentim($url); $data = []; $data["GroupId"] = $party_id; $data["Random"] = rand(1000000,9999999); $data["MsgBody"][] = [ "MsgType" => "TIMCustomElem", "MsgContent" => [ "Data"=> json_encode($msgData) ], ]; $tencentObj->toSend($data); } /** * 获取usersig签名-具体操作 */ private function usersig($user_id) { // 获取配置信息 $config = config("tencent_im"); $usersigObj = new getusersig($config["sdkappid"],$config["key"]); $usersig = $usersigObj->genUserSig($user_id); return $usersig; } }