kge/application/api/controller/Guild.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use app\common\service\UserService;
use think\Db;
use think\Exception;
use Redis;
use app\common\service\RoomService;
use app\common\library\Easemob;

/**
 * 公会控制器
 */
class Guild extends Api
{
    protected $noNeedLogin = ['getGuildList'];
    protected $noNeedRight = ['*'];

    /**
     * 获取搜索公会列表
     */
    public function getGuildList() {
        $search = input("search","","string"); //搜索的字段 公会名称/公会ID
        $where = [];$whereOr = [];
        $where['g.status'] = 1;
        if (!empty($search)) {
            $whereOr['g.name'] = array('like', '%' . $search . '%');
            $whereOr['g.g_id'] = $search;
        }
        $res = Db::name('guild')->alias('g')->field("g.id,g.g_id,g.user_id,g.party_id,g.name,g.image,g.desc,g.member,
        area.province_name,area.name as city_name")
            ->join('shopro_area area','g.city_id = area.id','LEFT')
            ->where($where)
            ->where(function ($query) use($whereOr) {
                $query->whereOr($whereOr);
            })
            ->autopage()
            ->select();
        $res = list_domain_image($res,['image']);

        $this->success("获取成功！",$res);
    }




    /**
     * 获取公会信息
     */
    public function getGuildInfo() {
        $guild_id = input("guild_id"); //公会ID
        $is_member = 0;
        $user_id = $this->auth->id;
        if($guild_id <= 0) {
            $is_member = 1;
            // 获取当前用户是否是公会成员
            $idcardfind = \app\common\model\GuildJoinin::where(["user_id"=>$user_id,"status"=>0])->find();
            if($idcardfind) $this->error("您存在加入公会的申请，正在审核中，请耐心等待！");

            $memberfind = \app\common\model\GuildMember::where(["user_id"=>$user_id])->find();
            if($memberfind) $guild_id = $memberfind->guild_id;

            if(!$guild_id) {
                $res["is_member"] = 2; // 是否为派对成员
                $this->success("获取成功！",$res);
            }

        }

        //结果
        $res = [];

        //公会信息
        $guildInfo = \app\common\model\Guild::field("id,image,name,g_id,user_id,party_id,desc,notice,status")->where(["id"=>$guild_id])->find();

        // 获取公会成员信息
        $guildMemberInfo = \app\common\model\GuildMember::alias("a")
            ->field("a.id,a.user_id,a.role,u.nickname,u.avatar,u.gender")
            ->join("user u","a.user_id = u.id")
            ->where(["a.guild_id"=>$guild_id])->limit(10)->order("a.role","desc")->select();
        if(!$guildInfo || !$guildMemberInfo) $this->error("公会信息获取失败！");

        // 获取公会成员总数
        $guildMemberCount = \app\common\model\GuildMember::where(["guild_id"=>$guild_id])->count("id");

        // 获取会长信息
        $guilderInfo = \app\common\model\User::field("avatar,nickname,u_id")->where(["id"=>$guildInfo->user_id])->find();

        // 获取房间信息
        $partyInfo = \app\common\model\Party::field("id,party_logo,party_type,is_online,party_name,party_notice_detail")->where(["id"=>$guildInfo->party_id])->find();

        // 派对类型
        $partyTypeName = "普通房";
        if($partyInfo["party_type"]) {
            $partyTypeName = \app\common\model\PartyType::where(["id"=>$partyInfo["party_type"]])->value("name");
        }

        $mod = isset($partyInfo["party_type"])?intval($partyInfo["party_type"])%5:1;
        $partyInfo["party_type_color"] = $mod == 0?5:$mod;
        $partyInfo["type_name"] = $partyTypeName;

        // 返回参数拼接
        $res["guildInfo"] = $guildInfo; // 公会基本信息
        $res["guildMemberInfo"] = $guildMemberInfo; // 成员列表
        $res["guildMemberCount"] = $guildMemberCount; // 成员总数
        $res["guilderInfo"] = $guilderInfo; // 会长
        $res["partyInfo"] = $partyInfo; // 派对悉尼下
        $res["is_member"] = $is_member; // 是否为派对成员
        $this->success("获取成功！",$res);
    }

    /**
     * 获取公会信息-新
     */
    public function getGuildInfoNew() {
        $guild_id = input("guild_id"); //公会ID
        $is_member = 0;
        $user_id = $this->auth->id;
        if($guild_id <= 0) {
            $is_member = 1;
            // 获取当前用户是否是公会成员
            $idcardfind = \app\common\model\GuildJoinin::where(["user_id"=>$user_id,"status"=>0])->find();
            if($idcardfind) $this->error("您存在加入公会的申请，正在审核中，请耐心等待！");

            $memberfind = \app\common\model\GuildMember::where(["user_id"=>$user_id])->find();
            if($memberfind) {
                $guild_id = $memberfind->guild_id;
            }

            $guildWhere['user_id'] = $user_id;
            $guildWhere['status'] = ['in',[0,1]];
            $guildInfo = \app\common\model\Guild::field("id,image,name,g_id,user_id,party_id,desc,notice,status")->where($guildWhere)->find();

            if(!$guild_id) {
                $res["is_member"] = 2; // 是否为派对成员
                $res["guild_status"] = isset($guildInfo['status']) ? (int)$guildInfo['status'] : -2; // 是否为派对成员
                $this->success("获取成功！",$res);
            }
        }

        //结果
        $res = [];

        //公会信息
        $guildInfo = \app\common\model\Guild::field("id,image,name,g_id,user_id,party_id,desc,notice,status")->where(["id"=>$guild_id])->find();

        // 获取公会成员信息
        $guildMemberInfo = \app\common\model\GuildMember::alias("a")
            ->field("a.id,a.user_id,a.role,u.nickname,u.avatar,u.gender")
            ->join("user u","a.user_id = u.id")
            ->where(["a.guild_id"=>$guild_id])->limit(10)->order("a.role","desc")->select();

        if(!$guildInfo) $this->error("公会信息获取失败！");

        // 获取公会成员总数
        $guildMemberCount = \app\common\model\GuildMember::where(["guild_id"=>$guild_id])->count("id");

        // 获取会长信息
        $guilderInfo = \app\common\model\User::field("avatar,nickname,u_id")->where(["id"=>$guildInfo->user_id])->find();

        // 获取房间信息
        $partyInfo = \app\common\model\Party::field("id,party_logo,party_type,is_online,party_name,party_notice_detail")->where(["id"=>$guildInfo->party_id])->find();

        $partyParams = ['party_id' => $guildInfo->party_id];
        $roomService = new RoomService();
        $partyOnlineRes = $roomService->getPartyUserList($partyParams);
        $onlineData = isset($partyOnlineRes['data']) ? $partyOnlineRes['data'] : [];
        if (!empty($partyInfo)) {
            $partyInfo['user_list'] = isset($onlineData['member_list']) ? $onlineData['member_list'] : [];
            $partyInfo['online_num'] = isset($onlineData['online_num']) ? $onlineData['online_num'] : 0;
            // 派对类型
            $partyTypeName = "普通房";
            if(isset($partyInfo["party_type"])) {
                $partyTypeName = \app\common\model\PartyType::where(["id"=>$partyInfo["party_type"]])->value("name");
            }

            $mod = isset($partyInfo["party_type"])?intval($partyInfo["party_type"])%5:1;
            $partyInfo["party_type_color"] = $mod == 0?5:$mod;
            $partyInfo["type_name"] = $partyTypeName;
        }

        //获取公会角色
        $userService =  new UserService();
        $userParams = [
            'user_id' => $user_id,
            'guild_id' => $guild_id,
        ];
        $userRes = $userService->getGuildRole($userParams);
        $guildStatus = isset($userRes['data']['guild_role']) ? $userRes['data']['guild_role'] : 4;

        // 返回参数拼接
        $res["guildInfo"] = $guildInfo; // 公会基本信息
        $res["partyInfo"] = $partyInfo; // 派对悉尼下
        $res["guildMemberInfo"] = $guildMemberInfo; // 成员列表
        $res["guildMemberCount"] = $guildMemberCount; // 成员总数
        $res["guilderInfo"] = $guilderInfo; // 会长
        $res["is_member"] = $is_member; // 是否为派对成员
        $res['guild_status'] = $guildStatus; //公会状态
        $res['guild_role'] = $guildStatus; //公会角色:1工会长,2副会长,3成员,4非成员
        $this->success("获取成功！",$res);
    }

    /**
     * 更新公会基本信息
     */
    public function guildSaveInfo() {
        Db::startTrans();
        try {
            $guild_id     = input("guild_id");     //公会id
            $guild_name   = input("guild_name");   //公会名
            $guild_image  = input("guild_image");  //logo
            $guild_desc   = input("guild_desc");   //公会简介
            $guild_notice = input("guild_notice"); //公会公告
            $guild_info   = input("guild_info");   //公会宣言
            $province_id  = input("province_id");  //省id
            $city_id      = input("city_id");      //市id

            if(!$guild_name || !$guild_image){
                throw new Exception("公会名和logo必填！");
            }
            $user_id = $this->auth->id;

            if (empty($guild_id)) {

                //检查
                $guildWhere['user_id'] = $user_id;
                $guildWhere['status'] = ['in',[0,1]];
                $guildData = model('Guild')->where($guildWhere)->find();
                if (!empty($guildData)) {
                    throw new Exception('您已创建过公会！');
                }

                //准备创建
                $guildInfo = new \app\common\model\Guild();
                $guildInfo->user_id = $user_id;
                $ids = \app\common\model\Guild::column("g_id");
                $guildInfo->g_id = getUinqueId(4, [$ids]);
                $guildInfo->status = 0;
            } else {
                // 获取公会信息
                $guildInfo = \app\common\model\Guild::where(["id"=>$guild_id])->find();
                // 验证更新条件
                if($user_id !== $guildInfo->user_id) throw new Exception("身份验证失败！您不是公会长，无权限更改！");
            }

            //传参信息
            $guild_name   && $guildInfo->name        = $guild_name;
            $guild_image  && $guildInfo->image       = $guild_image;
            $guild_desc   && $guildInfo->desc        = $guild_desc;
            $guild_notice && $guildInfo->notice      = $guild_notice;
            $guild_info   && $guildInfo->info        = $guild_info;
            $province_id  && $guildInfo->province_id = $province_id;
            $city_id      && $guildInfo->city_id     = $city_id;
            $res = $guildInfo->save();

            if($res !== false) {
                if (empty($guild_id)) {
                    //新公会，会长也是成员之一
                    $guildMemberData = [
                        'guild_id' => $guildInfo->id,
                        'user_id' => $user_id,
                        'role' => 2, //角色:0=成员,1=副会长,2=会长
//                        'sign_type' => 3,//签约类型:1=三个月,2=半年,3=一年
//                        'sign_time' => 0,
//                        'status' => 1, //状态:1=签约中,2=已解约
                        'createtime' => time(),
                    ];
                    $guildRes = model('GuildMember')->insertGetId($guildMemberData);
                    if (!$guildRes) {
                        throw new Exception('生成成员失败');
                    }

                    //更新用户资料
                    $userWhere['id'] = $user_id;
                    $user = model('User')->where($userWhere)->find();
                    if (!empty($user) && $user['guild_id'] != $guildInfo->id) {
                        $userRes = model('User')->where($userWhere)->update(['is_guild'=>3,'guild_id'=>$guildInfo->id]);
                        if (!$userRes) {
                            throw new Exception('用户绑定公会失败');
                        }
                    }
                }
                Db::commit();
                $this->success("操作成功！");
            } else {
                throw new Exception("网络错误，请稍后重试！");
            }
        } catch (Exception $e) {
            Db::rollback();
            $this->error($e->getMessage());
        }
    }

    /**
     * 公会签约申请
     */
    public function guildJoinin() {
        $guild_id = input("guild_id"); //公会ID

        // 一个身份证号只能申请一次
        $user_id = $this->auth->id;
        // 实名认证
        if($this->auth->is_auth != 2){
            $this->error("请完成实名认证！");
        }

        $check = \app\common\model\Guild::where(["user_id"=>$this->auth->id])->find();
        if($check){
            if($check['status'] == 1){
                $this->error('您已经有自己的公会了');
            }elseif($check['status'] == 0){
                $this->error('您已经申请了自己的公会了');
            }
        }
        // 搜索签约申请中是否有此身份证号
        $idcardfind = \app\common\model\GuildJoinin::where(["user_id"=>$user_id,'guild_id'=>$guild_id,"status"=>0])->find();
        if($idcardfind) $this->error("当前账号正在审核，请耐心等待！");

        $memberfind = \app\common\model\GuildMember::where(["user_id"=>$user_id])->find();
        if($memberfind) $this->error("一个账号只能加入一个公会哟！");


        // 添加数据
        $data = [];
        $data["user_id"] = $user_id;
        $data["guild_id"] = $guild_id;
        $data["createtime"] = time();
        $res = \app\common\model\GuildJoinin::insert($data);
        if($res) {
            $this->success("申请发送成功！");
        } else {
            $this->error("网络错误，请稍后重试！");
        }
    }

    /**
     * 公会签约申请审核
     */
    public function guildJoininExamine() {
        $joinin_id = input("joinin_id"); // 申请加入的申请ID
        $is_pass = input("is_pass"); // 是否通过:1=通过,-1=拒绝
        if(!in_array($is_pass,[1,-1]) || !$joinin_id) $this->error("参数错误！");

        $user_id = $this->auth->id;

        // 获取申请信息
        $joininInfo =  \app\common\model\GuildJoinin::where(["id"=>$joinin_id])->find();
        if(empty($joininInfo)){
            $this->error('未找到申请信息');
        }

        // 获取公会信息
        $guildInfo = \app\common\model\Guild::where(["id"=>$joininInfo->guild_id])->find();
        // 验证更新条件
        if($user_id !== $guildInfo->user_id) $this->error("身份验证失败！您不是公会长，无权限更改！");

        //判断重复
        $memberfind = \app\common\model\GuildMember::where(["user_id"=>$joininInfo['user_id']])->find();
        if($memberfind) $this->error("该用户已有公会！");//包括成员，副会，会长角色

        //清理其他公会未审核的数据
        if ($is_pass == 1) {
            $joinWhere['user_id'] = $joininInfo['user_id'];
            $joinWhere['guild_id'] = ['neq',$joininInfo['guild_id']];
            $joinWhere['status'] = 0;
            $joinData = model('GuildJoinin')->where($joinWhere)->delete();
        }


        // 计算签约时间段
        Db::startTrans();
        try{
            // 更新申请状态
            $joininInfo->status = $is_pass;
            $joininInfo->updatetime = time();
            $res2 = $joininInfo->save();

            if($is_pass == 1) {
                // 同意后 加入公会成员
                $data = [];
                $data["guild_id"] = $guildInfo->id;
                $data["user_id"] = $joininInfo->user_id;
                $data["role"] = 0;
                $data["createtime"] = time();
                $res3 = \app\common\model\GuildMember::insert($data);
                $res4 = \app\common\model\Guild::where(["id"=>$guildInfo->id])->setInc("member");
                if($res2 && $res3 && $res4) {
                    // +message
                    \app\common\model\Message::addMessage($joininInfo->user_id,"公会审核通知","恭喜，您的加入公会审核通过啦！");
                    Db::commit();
                    $this->success("已审核通过！");
                }
            } else {
                if($res2) {
                    // +message
                    \app\common\model\Message::addMessage($joininInfo->user_id,"公会审核通知","您的公会加入申请，会长审核拒绝，没关系，调整姿势再来一遍！");
                    Db::commit();
                    $this->success("已审核拒绝！");
                }
            }
            $this->error("网络错误，请稍后重试！");


        }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());
        }
    }



    /**
     * 公会申请加入列表
     */
    public function guildJoinList() {

        $user_id = $this->auth->id;
        // 获取公会信息
        $guildInfo = model('Guild')->where(["user_id"=>$user_id])->find();
        if(!$guildInfo) {
            $this->success("获取成功",[]);
        }

        // 先获取申请列表
        $where = [];
        $where["m.guild_id"] = $guildInfo->id;
        $where["m.status"] = 0;
        $result = Db::name('guild_joinin')->alias('m')
            ->field("m.id,m.user_id,m.createtime,user.is_online,user.onlinetime,user.nickname,user.avatar")
            ->join('user','m.user_id = user.id','LEFT')
            ->where($where)->order("createtime","desc")->select();
        if($result) {
            foreach($result as $k => &$v) {

                if ($v['is_online'] == 1) {
                    $onlineText = '在线';
                } else {
                    $onlineTime = get_last_time($v['onlinetime']);
                    $onlineText = $onlineTime.'在线';
                    $limitTime = time() - (3600 * 6);
                    if ($v['onlinetime'] < $limitTime) {
                        $onlineText = '离线';
                    }
                }

                $v['online_text'] = $onlineText;
                unset($v['user']);
            }
        }
        $this->success("获取成功",$result);

    }

    /**
     * 公会成员列表
     */
    public function guildMember() {
        $guild_id = input("guild_id",0,"intval"); //公会ID

        if($guild_id <= 0) $this->error("参数错误！");

        $where = [];
        $where["a.guild_id"] = $guild_id;

        // 获取公会成员总数
        $guildMemberCount = \app\common\model\GuildMember::alias("a")->where($where)->count("id");
        // 获取公会成员列表
        $guildMemberList = \app\common\model\GuildMember::alias("a")
            ->field("a.id,a.user_id,u.avatar,u.nickname,u.gender,a.role,u.is_online,u.onlinetime")
            ->join("user u","a.user_id = u.id")
            ->where($where)
            ->autopage()
            ->order("a.role","desc")
            ->select();

        $role = [0=>'成员',1=>'副会长',2=>'会长'];

        if($guildMemberList) {
            foreach($guildMemberList as $k => &$v) {
                $v["role_text"] = $role[$v["role"]];
                if ($v['is_online'] == 1) {
                    $onlineText = '在线';
                } else {
                    $onlineTime = get_last_time($v['onlinetime']);
                    $onlineText = $onlineTime.'在线';
                    $limitTime = time() - (3600 * 6);
                    if ($v['onlinetime'] < $limitTime) {
                        $onlineText = '离线';
                    }
                }
                $v['online_text'] = $onlineText;
            }
        }

        $res = [];
        $res["memberCount"] = $guildMemberCount;
        $res["memberList"] = $guildMemberList;

        $this->success("获取成功！",$res);
    }

    /**
     * 获取公会成员信息
     */
    public function getGuildMemberInfo() {
        $member_id = input("member_id",0,"intval"); //公会成员ID
        if($member_id <= 0) $this->error("参数错误！");

        //成员信息
        $memberData = model('GuildMember')->field('id,user_id')->find($member_id);

        //更新成员的 财富值 ，魅力值，收到的礼物数量
        $userService = new UserService();
        $userService->updateGuildMember(['user_id'=>$memberData['user_id']]);

        //从user表拿一些用户信息
        $memberInfo = model('GuildMember')->alias('m')
            ->join('user','m.user_id = user.id','LEFT')
            ->field('m.id,m.user_id,m.wealth,m.charm,m.gift_num,m.role,m.guild_id,m.createtime,
            user.avatar,user.nickname,user.gender,user.logintime,user.is_online,user.onlinetime')
            ->where('m.id',$member_id)
            ->find();
        if(!$memberInfo) $this->error("用户信息获取失败！");
        $memberInfo = info_domain_image($memberInfo,['avatar']);

        //角色
        $role = [0=>'成员',1=>'副会长',2=>'公会长'];
        $memberInfo["role_text"] = $role[$memberInfo["role"]];

        //在线
        if ($memberInfo['is_online'] == 1) {
            $onlineText = '在线';
        } else {
            $onlineTime = get_last_time($memberInfo['onlinetime']);
            $onlineText = $onlineTime.'在线';
            $limitTime = time() - (3600 * 6);
            if ($memberInfo['onlinetime'] < $limitTime) {
                $onlineText = '离线';
            }
        }
        $memberInfo['online_text'] = $onlineText;

        //我在这个公会的角色
        /*$myGuildMember = model('GuildMember')->field('role')->where(["user_id"=>$this->auth->id,"guild_id"=>$memberInfo->guild_id])->find();
        $memberInfo["my_role"] = !empty($myGuildMember) ? $myGuildMember['role'] : -1;*/

        //几个比较大的值，改w单位
        $fieldArr = ['wealth','charm','gift_num'];
        foreach ($fieldArr as $fkey => $fval) {
            if ($memberInfo[$fval] > 10000) {
                $memberInfo[$fval] = bcdiv($memberInfo[$fval],10000,2).'w';
            }
        }

        $this->success("获取成功！",$memberInfo);
    }

    /**
     * 公会管理-设为管理员
     */
    public function guildSetManage() {
        $guild_id = input("guild_id",0,"intval"); //公会ID
        $member_id = input("member_id",0,"intval"); //成员ID
        $type = input("type",1); // 设置类型:1=设为管理员,2=取消管理员

        if(!$guild_id || !$member_id || !in_array($type,[1,2])) $this->error("参数缺失！");

        $user_id = $this->auth->id;

        // 获取公会信息
        $guildInfo = \app\common\model\Guild::where(["id"=>$guild_id])->find();

        // 验证更新条件
        if($user_id !== $guildInfo->user_id) $this->error("身份验证失败！您不是公会长，无权限更改！");

        $memberInfo = \app\common\model\GuildMember::where(["id"=>$member_id,'guild_id'=>$guild_id])->find();
        if(!$memberInfo) $this->error("会员信息查询失败！");

        //取消管理员
        if($type == 2) {
            $memberInfo->role = 0;
            $memberInfo->updatetime = time();
            $res = $memberInfo->save();
            if($res) {
                //[环信]取消聊天室管理员
                $easemob = new Easemob();
                $easemob->room_demoteRoomAdmin($guildInfo['easemob_room_id'],$memberInfo['user_id']);

                $this->success("取消成功！");
            } else {
                $this->error("网络错误，请稍后重试！");
            }
        }

        //设置管理员
        $memberInfo->role = 1;
        $memberInfo->updatetime = time();
        $res = $memberInfo->save();
        if($res) {
            // 获取房间id
            $party_id = $guildInfo->party_id;
            // 添加房间管理员
            $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']);
            }
            // 获取成员用户信息
            $memberuserInfo = \app\common\model\User::field("id,avatar,nickname,gender,level")->where('id',$memberInfo['user_id'])->find();
            $data = [];
            $data["user_id"] = $memberuserInfo->id;
            $data["avatar"] = $memberuserInfo->avatar;
            $data["nickname"] = $memberuserInfo->nickname;
            $data["gender"] = $memberuserInfo->gender;
            $data["item"] = 1;
            $data["time"] = 0;
            $data["createtime"] = time();

            $redis->hSet("party_manage_".$party_id,$memberuserInfo->id."-1",serialize($data));

            //[环信]设置群组管理员
            $easemob = new Easemob();
            $easemob->room_promoteRoomAdmin($guildInfo['easemob_room_id'],$memberInfo['user_id']);

            $this->success("设置成功！");
        } else {
            $this->error("网络错误，请稍后重试！");
        }
    }

    /**
     * 公会管理-踢出公会
     */
    public function guildDelMember() {
        $guild_id = input("guild_id",0,"intval"); //公会ID
        $member_id = input("member_id",0,"intval"); //成员ID
        if(!$guild_id || !$member_id) $this->error("参数缺失！");

        // 先判断是否为公会会长
        $user_id = $this->auth->id;
        // 获取公会信息
        $guildInfo = \app\common\model\Guild::where(["id"=>$guild_id])->find();
        // 验证更新条件
        if($user_id !== $guildInfo->user_id) $this->error("身份验证失败！您不是公会长，无权限更改！");

        $memberInfo = \app\common\model\GuildMember::where(["id"=>$member_id,'guild_id'=>$guild_id])->find();
        if(!$memberInfo) $this->error("会员信息查询失败！");

        if($memberInfo['role'] == 2 || $memberInfo['user_id'] == $guildInfo['user_id']){
            $this->error('会长不能被踢出公会');
        }

        Db::startTrans();
        try{
            $res1 = $memberInfo->delete();
            $res2 = \app\common\model\Guild::where(["id"=>$guild_id])->setDec("member");
            if($res1 && $res2) {
                Db::commit();
                $this->success("踢出成功！");
            } else {
                $this->error("网络错误，请稍后重试！");
            }
        }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());
        }
    }

    /**
     * 公会贡献榜排行
     * @return void
     */
    public function getRankList()
    {
        try {
            $id = input('guild_id',0);
            $guildMemberWhere['guild_id'] = $id;
            $guildMemberWhere['status'] = 1;
            $guildMember = model('GuildMember')->field('id,user_id,role')->where($guildMemberWhere)->select();
            $list = [];
            if (!empty($guildMember)) {
                $userIds = array_column($guildMember,'user_id');
                $where = [];
                $where['a.user_to_id'] = ['in', $userIds];
                $list = model('GiftUserParty')->alias("a")
                    ->field('sum(a.value) as total_price,a.user_to_id,u.avatar,u.nickname,u.is_online,u.onlinetime')
                    ->where($where)
                    ->join('user u','u.id = a.user_to_id')
                    ->group('a.user_to_id')
                    ->order('total_price',"desc")
                    ->autopage()
                    ->select();
                if (!empty($list)) {
                    $role = [0=>'成员',1=>'副会长',2=>'会长'];
                    $guildMemberData = [];
                    foreach ($guildMember as $mKey => $mVal) {
                        $guildMemberData[$mVal['user_id']] = [
                            'id' => $mVal['id'],
                            'role' => $mVal['role'],
                            'role_text' => isset($role[$mVal['role']]) ? $role[$mVal['role']] : '',
                        ];
                    }
                    foreach ($list as $key => &$value) {
                        $member = isset($guildMemberData[$value['user_to_id']]) ? $guildMemberData[$value['user_to_id']] : [];
                        $value['member_id'] = isset($member['id']) ? $member['id'] : 0;
                        $value['role'] = isset($member['role']) ? $member['role'] : 0;
                        $value['role_text'] = isset($member['role_text']) ? $member['role_text'] : '';
                        if ($value['is_online'] == 1) {
                            $onlineText = '在线';
                        } else {
                            $onlineTime = get_last_time($value['onlinetime']);
                            $onlineText = $onlineTime.'在线';
                            $limitTime = time() - (3600 * 6);
                            if ($value['onlinetime'] < $limitTime) {
                                $onlineText = '离线';
                            }
                        }
                        $value['online_text'] = $onlineText;
                        $value['total_price_text'] = $value['total_price'];
                        if ($value['total_price'] >= 10000) {
                            $value['total_price_text'] = bcdiv($value['total_price'],10000,1).'w';
                        }
                        unset($value['total_price']);
                    }
                }
            }

            $this->success(__('Operation completed'),$list);
        } catch (Exception $e) {
            $this->error($e->getMessage());
        }
    }

    /**
     * 获取公会状态
     * @return void
     */
    public function getStatus()
    {
        $id = input('guild_id',0);
        if (!empty($id)) {
            $where['id'] = $id;
        } else {
            $where['user_id'] = $this->auth->id;
        }
        $field = 'id,status';
        $guild = model('Guild')->field($field)->where($where)->find();
        $this->success('获取成功', $guild);
    }

    ///////////////没用到的///////////

    /**
     * 开厅申请
     */
    public function guildApply() {
        $user_id = $this->auth->id;
        // 获取用户实名认证信息
        $authUserRealname = \app\common\model\UserAuth::where(["user_id"=>$user_id])->value("realname");
        if(!$authUserRealname) $this->error("未查询到实名认证信息，请实名认证先！");
        // 获取用户信息
        $userInfo = \app\common\model\User::field("id,mobile,nickname")->where(["id"=>$user_id])->find();
        $data = [];
        $data["user_id"] = $user_id;
        // 查看是否申请过
        $applyInfo = \app\common\model\GuildApply::where($data)->find();
        if($applyInfo && $applyInfo->status>=0) $this->error("您已经发送过开厅申请了，请勿重复发送！");
        // 查看是否有加入公会的申请
        $joinInfo = \app\common\model\GuildJoinin::where(["user_id"=>$user_id,"status"=>0])->find();
        if($joinInfo) $this->error("您存在申请加入公会信息，请联系公会长处理完毕后方可申请开厅！");
        // 查看是已经是公会成员
        $memberInfo = \app\common\model\GuildMember::where(["user_id"=>$user_id])->find();
        if($memberInfo) $this->error("您已存在签约中的公会，无法开新厅！");


        Db::startTrans();
        try{
            $data["user_name"] = $authUserRealname;
            $data["user_nickname"] = $userInfo->nickname;
            $data["user_mobile"] = $userInfo->mobile;
            $data["createtime"] = time();
            $res1 = \app\common\model\GuildApply::insert($data);
            // 更新用户状态
            $userInfo->is_guild = 1;
            $res2 = $userInfo->save();
            if($res1 && $res2) {
                Db::commit();
                $this->success("申请发送成功！");
            } else {
                $this->error("网络错误，请稍后重试！");
            }

        }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());
        }
    }



    /**
     * 公会申请页面信息
     */
    public function guildApplyInfo() {
        $guild_id = input("guild_id"); //公会ID
        if($guild_id <= 0) $this->error("参数缺失！");
        $guildInfo = \app\common\model\Guild::alias("a")
            ->join("user u","u.id = a.user_id","inner")
            ->field("a.id,a.image,a.name,a.g_id,a.user_id,u.avatar,u.nickname,u.u_id")
            ->where(["a.id"=>$guild_id])
            ->find();

        $guildInfo["status"] = 0;
        // 获取申请用户是否已经有正在申请的记录
        $user_id = $this->auth->id;
        $joinStatus = \app\common\model\GuildJoinin::where(["user_id"=>$user_id])->value("status");
        if($joinStatus === 0) $guildInfo["status"] = 1;

        $Member = \app\common\model\GuildMember::where(["user_id"=>$user_id])->value("id");
        if($Member > 0) $guildInfo["status"] = 2;

        $this->success("获取成功！",$guildInfo);
    }


}