kge/application/api/controller/Family.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use app\common\service\UserService;
use think\Db;
use think\Exception;

/**
 * 家族控制器
 */
class Family extends Api
{
    protected $noNeedLogin = ['getGuildList'];
    protected $noNeedRight = ['*'];

    /**
     * 获取搜索公会列表
     */
    public function getGuildList() {
        $search = input("search","","string"); //搜索的字段 公会名称/公会ID
        $where = [];$whereOr = [];
        $where['status'] = 1;
        if (!empty($search)) {
            $whereOr['name'] = array('like', '%' . $search . '%');
            $whereOr['g_id'] = $search;
        }
        $res = Db::name('family')->field("id,g_id,user_id,group_id,name,image,desc,member")
            ->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\FamilyJoinin::where(["user_id"=>$user_id,"status"=>0])->find();
            if($idcardfind) $this->error("您存在加入家族的申请，正在审核中，请耐心等待！");

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

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

        }

        //结果
        $res = [];

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

        // 获取公会成员信息
        $guildMemberInfo = \app\common\model\FamilyMember::alias("a")
            ->field("a.id,a.user_id,a.role,u.nickname,u.avatar,u.gender")
            ->join("hx_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\FamilyMember::where(["guild_id"=>$guild_id])->count("id");

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



        // 返回参数拼接
        $res["guildInfo"] = $guildInfo; // 公会基本信息
        $res["guildMemberInfo"] = $guildMemberInfo; // 成员列表
        $res["guildMemberCount"] = $guildMemberCount; // 成员总数
        $res["guilderInfo"] = $guilderInfo; // 会长
        $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\FamilyJoinin::where(["user_id"=>$user_id,"status"=>0])->find();
            if($idcardfind) $this->error("您存在加入家族的申请，正在审核中，请耐心等待！");

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

            $guildWhere['user_id'] = $user_id;
            $guildWhere['status'] = ['in',[0,1]];
            $guildInfo = \app\common\model\Family::field("id,image,name,g_id,user_id,group_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\Family::field("id,image,name,g_id,user_id,group_id,desc,notice,status")->where(["id"=>$guild_id])->find();

        // 获取公会成员信息
        $guildMemberInfo = \app\common\model\FamilyMember::alias("a")
            ->field("a.id,a.user_id,a.role,u.nickname,u.avatar,u.gender")
            ->join("hx_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\FamilyMember::where(["guild_id"=>$guild_id])->count("id");

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


        //获取家族角色
        $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["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"); //公会公告


            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('Family')->where($guildWhere)->find();
                if (!empty($guildData)) {
                    throw new Exception('您已创建过家族！');
                }

                //检查不能是其他家族的成员
                $checkmember = model('FamilyMember')->where('user_id',$this->auth->id)->find();
                if (!empty($checkmember)) {
                    $this->error('您已经加入了其他家族');
                }

                //检查删除这个人的所有加入申请
                $joinWhere['user_id'] = $this->auth->id;
                $joinWhere['status'] = 0;
                $joinData = model('FamilyJoinin')->where($joinWhere)->find();
                if (!empty($checkmember)) {
                    $this->error('您已经申请加入了其他家族,需等待被拒或退出,才能创建家族');
                }

                //准备创建
                $guildInfo = new \app\common\model\Family();
                $guildInfo->user_id = $user_id;
                $ids = \app\common\model\Family::column("g_id");
                $guildInfo->g_id = getUinqueId(4, [$ids]);
                $guildInfo->status = 0;
            } else {
                // 获取公会信息
                $guildInfo = \app\common\model\Family::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;

            $res = $guildInfo->save();

            if($res !== false) {
                if (empty($guild_id)) {
                    //新公会，会长也是成员之一
                    $guildMemberData = [
                        'guild_id' => $guildInfo->id,
                        'user_id' => $user_id,
                        'role' => 2, //角色:0=成员,1=副会长,2=会长
                        'status' => 1, //状态:1=签约中,2=已解约
                        'createtime' => time(),
                    ];
                    $guildRes = model('FamilyMember')->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;
        // 实名认证
        $userAuthInfo = \app\common\model\UserAuth::where(["user_id"=>$user_id])->find();
        if($userAuthInfo) {
            if($userAuthInfo->status == 0) {
                $this->error("您的实名认证还在这审核中...，请耐心等待！");
            } elseif($userAuthInfo->status == 2) {
                $this->error("您的实名认证审核未通过，请重新审核！");
            }
        } else {
            $this->error("请先申请实名认证！");
        }

        // 获取用户实名认证信息
        $authUserIdcard = \app\common\model\UserAuth::where(["user_id"=>$user_id])->value("idcard");
        // 搜索签约申请中是否有此身份证号
        $idcardfind = \app\common\model\FamilyJoinin::where(["user_id"=>$user_id,'guild_id'=>$guild_id,"status"=>0])->find();
        if($idcardfind) $this->error("当前账号正在审核，请耐心等待！");

        $memberfind = \app\common\model\FamilyMember::where(["user_id"=>$user_id,"status"=>1])->find();
        if($memberfind) $this->error("一个账号只能加入一个家族哟！");



        // 获取公会信息
        $guildName = \app\common\model\Family::where(["id"=>$guild_id])->value("name");
        // 获取用户信息
        $userInfo = \app\common\model\User::field("id,avatar,nickname")->where(["id"=>$user_id])->find();
        // 添加数据
        $data = [];
        $data["user_id"] = $user_id;
        $data["guild_id"] = $guild_id;
        $data["user_avatar"] = $userInfo->avatar;
        $data["user_idcard"] = $authUserIdcard;
        $data["user_nickname"] = $userInfo->nickname;
        $data["guild_name"] = $guildName;
        $data["createtime"] = time();
        $res = \app\common\model\FamilyJoinin::insert($data);
        if($res) {
            // +message
//            \app\common\model\Message::addMessage($user_id,"公会消息","申请加入公会消息");
            $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\FamilyJoinin::where(["id"=>$joinin_id])->find();
        if(empty($joininInfo)){
            $this->error('未找到申请信息');
        }

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

        //判断重复
        $memberfind = \app\common\model\FamilyMember::where(["user_id"=>$joininInfo['user_id'],"status"=>1])->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('FamilyJoinin')->where($joinWhere)->delete();
        }


        // 获取用户信息
        $userInfo = \app\common\model\User::field("id,u_id,mobile,nickname")->where(["id"=>$joininInfo->user_id])->find();

        Db::startTrans();
        try{
            //记个无用的日志
            $data = [];
            $data["user_id"] = $joininInfo->user_id;
            $data["operator"] = $user_id;
            $data["user_nickname"] = $userInfo->nickname;
            $data["user_u_id"] = $userInfo->u_id;
            $data["guild_id"] = $guildInfo->id;
            $data["guild_name"] = $guildInfo->name;
            $data["guild_g_id"] = $guildInfo->g_id;
            $data["status"] = $is_pass;
            $data["createtime"] = time();
            $res1 = \app\common\model\FamilyJoininLog::insert($data);

            // 更新申请状态
            $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["status"] = 1;
                $data["createtime"] = time();
                $res3 = \app\common\model\FamilyMember::insert($data);
                $res4 = \app\common\model\Family::where(["id"=>$guildInfo->id])->setInc("member");
                if($res1 && $res2 && $res3 && $res4) {
                    // +message
                    \app\common\model\Message::addMessage($joininInfo->user_id,"家族审核通知","恭喜，您的加入家族审核通过啦！");
                    Db::commit();
                    $this->success("已审核通过！");
                }
            } else {
                if($res1 && $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() {
        try {
            $user_id = $this->auth->id;
            // 获取公会信息
            $guildInfo = model('Family')->where(["user_id"=>$user_id])->find();
            if(!$guildInfo) throw new Exception('家族信息获取失败！');
            // 先获取申请列表
            $where = [];
            $where["guild_id"] = $guildInfo->id;
            $where["status"] = 0;
            $result = model('FamilyJoinin')->field("id,user_id,user_avatar,user_nickname,guild_name,createtime")
                ->with(['user'=>function($uQuery){
                    $uQuery->field('id,is_online,onlinetime');
                }])
                ->where($where)->order("createtime","desc")->select();
            if($result) {
                foreach($result as $k => &$v) {
                    $user = isset($v['user']) ? $v['user'] : [];
                    $onlineText = '';
                    if (!empty($user)) {
                        if ($user['is_online'] == 1) {
                            $onlineText = '在线';
                        } else {
                            $onlineTime = get_last_time($user['onlinetime']);
                            $onlineText = $onlineTime.'在线';
                            $limitTime = time() - (3600 * 6);
                            if ($user['onlinetime'] < $limitTime) {
                                $onlineText = '离线';
                            }
                        }
                    }
                    $v['online_text'] = $onlineText;
                    $v['createtime'] = !empty($v["createtime"]) ? date("Y-m-d H:i", $v["createtime"]) : '';
                    unset($v['user']);
                }
            }
            $this->success("获取成功",$result);
        } catch (Exception $e) {
            $this->error($e->getMessage());
        }
    }

    /**
     * 公会成员列表
     */
    public function guildMember() {
        $guild_id = input("guild_id",0,"intval"); //公会ID
        $page = input('page',1); // 分页
        $pageNum = input('listrow',10); // 分页
        // 分页搜索构建
        $pageStart = ($page-1)*$pageNum;
        if($guild_id <= 0) $this->error("参数错误！");
        $where = [];
        $where["a.guild_id"] = $guild_id;
        $where["a.status"] = 1;
        // 获取公会成员总数
        $guildMemberCount = \app\common\model\FamilyMember::alias("a")->where($where)->count("id");
        // 获取公会成员列表
        $guildMemberList = \app\common\model\FamilyMember::alias("a")
            ->field("a.id,a.user_id,u.avatar,u.nickname,u.gender,u.age,a.role,u.is_online,u.onlinetime")
            ->join("hx_user u","a.user_id = u.id")
            ->where($where)
            ->limit($pageStart,$pageNum)
            ->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('FamilyMember')->field('id,user_id')->find($member_id);

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

        //从user表拿一些用户信息
        $memberInfo = model('FamilyMember')
            ->field('id,user_id,wealth,charm,gift_num,role,guild_id,createtime')
            ->with(['user'=>function($uQuery){
                $uQuery->field('id,avatar,nickname,gender,age,logintime,age_id,constellation_id,province_id,city_id');
            }])->find($member_id);
        if(!$memberInfo) $this->error("用户信息获取失败！");

        $userData  = isset($memberInfo['user']) ? $memberInfo['user'] : [];
        $gender    = isset($userData['gender']) ? $userData['gender'] : 1;
        $logintime = isset($userData['logintime']) ? $userData['logintime'] : 0;

        $userFieldInt = ['age'];
        $userFieldStr = ['avatar','nickname','age_text','constellation_text','province_text','city_text'];
        foreach ($userFieldInt as $keyInt => $valInt) {
            if (!isset($memberInfo[$valInt])) {
                $memberInfo[$valInt] = isset($userData[$valInt]) ? $userData[$valInt] : 0;
            }
        }
        foreach ($userFieldStr as $keyStr => $valStr) {
            if (!isset($memberInfo[$valStr])) {
                $memberInfo[$valStr] = isset($userData[$valStr]) ? $userData[$valStr] : '';
            }
        }

        unset($memberInfo['user']);
        $memberInfo['gender_text'] = $gender == 1 ? '男' : '女';
        $memberInfo["createtime"] = !empty($memberInfo["createtime"]) ? date("Y-m-d", $memberInfo["createtime"]) : '';
        $memberInfo["logintime"] = !empty($logintime) ? date("Y-m-d", $logintime) : '';

        //我在这个工会的角色
        $myGuildMember = model('FamilyMember')->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\Family::where(["id"=>$guild_id])->find();

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

        $memberInfo = \app\common\model\FamilyMember::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) {
                $this->success("取消成功！");
            } else {
                $this->error("网络错误，请稍后重试！");
            }
        }

        //设置管理员
        $memberInfo->role = 1;
        $memberInfo->updatetime = time();
        $res = $memberInfo->save();
        if($res) {


            $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\Family::where(["id"=>$guild_id])->find();
        // 验证更新条件
        if($user_id !== $guildInfo->user_id) $this->error("身份验证失败！您不是族长，无权限更改！");

        $memberInfo = \app\common\model\FamilyMember::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\Family::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('FamilyMember')->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('hx_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()
    {
        try {
            $id = input('guild_id',0);
            if (!empty($id)) {
                $where['id'] = $id;
            } else {
                $where['user_id'] = $this->auth->id;
            }
            $field = 'id,status';
            $guild = model('Family')->field($field)->where($where)->find();
            $this->success('获取成功', $guild);
        } catch (Exception $e) {
            $this->error($e->getMessage());
        }
    }

}