gganli/application/admin/controller/party/Party.php

<?php

namespace app\admin\controller\party;

use app\common\controller\Backend;
use tencentim\tencentim;
use getusersig\getusersig;
use think\Db;
use Redis;
/**
 * 派对管理
 *
 * @icon fa fa-circle-o
 */
class Party extends Backend
{
    protected $searchFields = 'user.u_id,user.nickname,party_id,party_name';
    /**
     * Party模型对象
     * @var \app\admin\model\party\Party
     */
    protected $model = null;

    public function _initialize()
    {
        parent::_initialize();
        $this->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;
    }


}