hemall.terabimsoft.com.cn/app/frontend/modules/member/models/MemberModel.php

<?php
/**
 * Created by PhpStorm.
 * Author: 芸众商城 www.yunzshop.com
 * Date: 17/2/22
 * Time: 下午4:53
 */

/**
 * 会员表
 */

namespace app\frontend\modules\member\models;

use app\backend\modules\member\models\MemberRelation;
use app\common\helpers\Url;
use app\common\models\Member;
use app\common\models\member\MemberChildren;
use app\common\models\MemberShopInfo;
use app\common\models\Setting;
use Illuminate\Support\Facades\DB;
use phpDocumentor\Reflection\Types\This;
use SimpleSoftwareIO\QrCode\Facades\QrCode;
use app\common\models\Order;
use Yunshop\AgentListSet\admin\SetController;
use Yunshop\CloudLinkPort\common\models\ChangeLog;
use Yunshop\CloudLinkPort\common\models\SetModel;
use Yunshop\CloudLinkPort\common\services\AdvertService;
use Yunshop\Commission\models\AgentLevel;
use Yunshop\ConsumerReward\common\models\ConsumerRewardRecordModel;
use Yunshop\EcologicalPoint\common\models\PointModel;
use Yunshop\Integral\Common\Models\IntegralMemberModel;
use Yunshop\Integral\Common\Services\SetService;
use Yunshop\Love\Common\Models\MemberLove;
use Yunshop\Love\Common\Services\ConstService;
use Yunshop\Love\Common\Services\LoveChangeService;
use Yunshop\Merchant\common\models\MerchantLevel;
use Yunshop\Micro\common\models\MicroShopLevel;
use Yunshop\TeamDividend\models\TeamDividendLevelModel;
use app\common\helpers\ImageHelper;
use Yunshop\UniversalCard\models\ConsumeCoupon;

class MemberModel extends Member
{
    /**
     * 获取用户uid
     *
     * @param $uniacid
     * @param $mobile
     * @return mixed
     */
    public static function getId($uniacid, $mobile)
    {
        return self::select('uid')
            ->where('uniacid', $uniacid)
            ->where('mobile', $mobile)
            ->first();
    }

    public static function getMemberinfo($uniacid, $mobile)
    {
        return self::where('uniacid', $uniacid)
            ->where('mobile', $mobile)
            ->first();
    }


    /**
     * 添加数据并返回id
     *
     * @param $data
     * @return mixed
     */
    public static function insertData($userinfo, $data)
    {
        $member_model = new MemberModel();

        $member_model->uniacid = $data['uniacid'];
        $member_model->email = '';
        $member_model->groupid = is_null($data['groupid']) ? 0 : $data['groupid'];
        $member_model->createtime = time();
        $member_model->nickname = stripslashes($userinfo['nickname']);
//        $member_model->avatar = (isset($userinfo['headimgurl']) && !empty($userinfo['headimgurl'])) ? $userinfo['headimgurl'] : Url::shopUrl('static/images/photo-mr.jpg');
        $member_model->avatar = (isset($userinfo['headimgurl']) && !empty($userinfo['headimgurl'])) ? $userinfo['headimgurl'] : '';
        $member_model->gender = isset($userinfo['sex']) ? $userinfo['sex'] : -1;
        $member_model->nationality = isset($userinfo['country']) ? $userinfo['country'] : '';
        $member_model->resideprovince = isset($userinfo['province']) ? $userinfo['province'] : '' . '省';
        $member_model->residecity = isset($userinfo['city']) ? $userinfo['city'] : '' . '市';
        $member_model->salt = '';
        $member_model->password = '';

        if ($member_model->save()) {
            return $member_model->uid;
        } else {
            return false;
        }
    }

    /**
     * 获取手机号码
     *
     * @param int $member_id 用户id
     * @return mixed
     */
    public static function getMobile($member_id)
    {
        return self::uniacid()
            ->where('uid', $member_id)
            ->value('mobile');

    }

    /**
     * 检查手机号是否存在
     *
     * @param $uniacid
     * @param $mobile
     * @return mixed
     */
    public static function checkMobile($uniacid, $mobile)
    {
        return self::where('uniacid', $uniacid)
            ->where('mobile', $mobile)
            ->first();
    }

    /**
     * 获取用户信息
     *
     * @param $uniacid
     * @param $mobile
     * @param $password
     * @return mixed
     */
    public static function getUserInfo($uniacid, $mobile, $password)
    {
        return self::where('uniacid', $uniacid)
            ->where('mobile', $mobile)
            ->where('password', $password);
    }

    /**
     * 更新数据
     *
     * @param $uid
     * @param $data
     * @return mixed
     */
    public static function updataData($uid, $data)
    {
        return self::uniacid()
            ->where('uid', $uid)
            ->update($data);
    }

    /**
     * 我的推荐人信息
     *
     * @param $uid
     * @return mixed
     */
    public static function getMyReferrerInfo($uid)
    {
        return self::select(['uid', 'avatar', 'nickname','mobile'])->uniacid()
            ->where('uid', $uid)
            ->with([
                'yzMember' => function ($query) {
                    return $query->select(['member_id', 'parent_id', 'is_agent', 'group_id', 'level_id', 'is_black', 'alipayname', 'alipay', 'status', 'inviter','wechat'])
                        ->where('is_black', 0)
                        ->with(['level' => function ($query2) {
                            return $query2->select(['id', 'level_name'])->uniacid();
                        }]);
                }
            ]);
    }

    /**
     * 获取我的下线
     *
     * @return mixed
     */
    public static function getAgentCount($uid)
    {
        return self::uniacid()
            ->whereHas('yzMember', function ($query) use ($uid) {
                $query->where('parent_id', $uid)->where('inviter', 1);
            })
            ->count();
    }

    /**
     * 我的下线信息 1级
     *
     * @param $uid
     * @return mixed
     */
    public static function getMyAgentInfo($uid)
    {
        return self::uniacid()
            ->whereHas('yzMember', function ($query) use ($uid) {
                $query->where('parent_id', $uid)->where('inviter', 1);
            })
            ->with(['hasOneOrder' => function ($query) {
                return $query->selectRaw('uid, count(uid) as total, sum(price) as sum')
                    ->uniacid()
                    ->where('status', 3)
                    ->groupBy('uid');
            }]);
    }

    public static function getMyAllAgentsInfo($uid, $level)
    {
        $child_member = DB::table('yz_member_children')
            ->select('child_id')
            ->where('member_id', $uid)
            ->where('uniacid', \YunShop::app()->uniacid)
            ->where('level', $level)
            ->get();
        foreach ($child_member as $child_id) {
            $child_id[] = $child_id['child_id'];
        }
        return self::uniacid()->whereIn('uid', $child_id);
    }

    /**
     * 查出用户的某一级别下线的会员资料
     * @param $uid
     * @param $level
     * @return MemberModel
     */
    public static function getMyAllAgentsInfoBySearch($uid, $level)
    {

        $child_member1 = DB::table('yz_member_children')->select('child_id')->where('member_id', $uid)->where('uniacid', \YunShop::app()->uniacid)->where('level', 1)->get();
        foreach ($child_member1 as $child_id) {
            $child_id1[] = $child_id['child_id'];
        }
        $child_member2 = DB::table('yz_member_children')->select('child_id')->where('member_id', $uid)->where('uniacid', \YunShop::app()->uniacid)->where('level', 2)->get();
        foreach ($child_member2 as $child_id) {
            $child_id2[] = $child_id['child_id'];
        }
        $child_member3 = DB::table('yz_member_children')->select('child_id')->where('member_id', $uid)->where('uniacid', \YunShop::app()->uniacid)->where('level', 3)->get();
        foreach ($child_member3 as $child_id) {
            $child_id3[] = $child_id['child_id'];
        }

        if ($level == 1) {
            $result = self::uniacid()->whereIn('uid', $child_id1);
        } elseif ($level == 2) {
            $result = self::uniacid()->whereIn('uid', $child_id2);
        } else {
            $result = self::uniacid()->whereIn('uid', $child_id3);
        }

        $result = $result->with(['yzMember' => function ($query) {
            return $query->select('member_id', 'is_agent', 'status', 'wechat', 'deleted_at');
        }]);


        return $result->orderBy('uid', 'desc');
    }

    /**
     * 我的下线信息 3级
     *
     * @param $uid
     * @return mixed
     */
    public static function getMyAgentsInfo($uid)
    {
        return self::uniacid()
            ->with(['hasManyYzMember' => function ($query) {

                return $query->with(['hasManySelf' => function ($query) {

                    return $query->with(['hasManySelf' => function ($query) {

                        return $query->get();
                    }])->get();
                }])->get();
            }])
            ->where('uid', $uid);
    }

    /**
     * 我的上级 3级
     *
     * @param $uid
     * @return mixed
     */
    public static function getMyAgentsParentInfo($uid)
    {
        return self::select(['uid'])
            ->uniacid()
            ->with(['yzMember' => function ($query) {
                return $query->select(['member_id', 'parent_id'])
                    ->with(['hasOnePreSelf' => function ($query) {
                        return $query->select(['member_id', 'parent_id'])
                            ->with(['hasOnePreSelf' => function ($query) {
                                return $query->select(['member_id', 'parent_id'])
                                    ->with(['hasOnePreSelf' => function ($query) {
                                        return $query->select(['member_id', 'parent_id'])->first();
                                    }])->first();
                            }])->first();
                    }])->first();
            }])
            ->where('uid', $uid);
    }

    /**
     *
     * @return mixed
     */
    public function hasManyYzMember()
    {
        return $this->hasMany('app\common\models\MemberShopInfo', 'parent_id', 'uid');
    }

    /**
     * 用户是否有推广权限
     *
     * @return mixed
     */
    public static function isAgent()
    {
        $uid = \YunShop::app()->getMemberId();

        if (!empty($uid)) {
            //MemberRelation::checkAgent($uid);

            $member_info = SubMemberModel::getMemberShopInfo($uid);

            if ($member_info && $member_info->is_agent == 1 && $member_info->status == 2) {
                return true;
            }
        }

        return false;

    }

    /**
     * 我的推荐人
     *
     * @return array
     */
    public static function getMyReferral()
    {
        $member_info = self::getMyReferrerInfo(\YunShop::app()->getMemberId())->first();

        $set = \Setting::get('shop.member');

        $data = [];

        if (!empty($member_info)) {
            if (isset($set) && $set['headimg']) {
                $avatar = replace_yunshop(tomedia($set['headimg']));
            } else {
                $avatar = Url::shopUrl('static/images/photo-mr.jpg');
            }

            $member_info = $member_info->toArray();

            $referrer_info = self::getUserInfos($member_info['yz_member']['parent_id'])->first();

            if ($member_info['yz_member']['inviter'] == 1) {
                if (!empty($referrer_info)) {
                    $info = $referrer_info->toArray();
                    $data = [
                        'uid'      => $info['uid'],
                        'avatar'   => $info['avatar'],
                        'nickname' => $info['nickname'],
                        'level'    => $info['yz_member']['level']['level_name'],
                        'is_show'  => $set['is_referrer']
                    ];
                } else {
                    $data = [
                        'uid'      => '',
                        'avatar'   => $avatar,
                        'nickname' => '总店',
                        'level'    => '',
                        'is_show'  => $set['is_referrer']
                    ];
                }
            } else {
                $data = [
                    'uid'      => '',
                    'avatar'   => $avatar,
                    'nickname' => '暂无',
                    'level'    => '',
                    'is_show'  => $set['is_referrer']
                ];
            }
        }

        return $data;
    }

    /**
     * 我的推荐人
     * @param $yz_member
     * @param $set
     * @return array
     */
    public static function getMyReferral_v3($yz_member, $set)
    {
        if (isset($set) && $set['headimg']) {
            $avatar = replace_yunshop(tomedia($set['headimg']));
        } else {
            $avatar = Url::shopUrl('static/images/photo-mr.jpg');
        }

        $referrer_info = self::getMyReferrerInfo($yz_member['parent_id'])->first();

        /*  if ($yz_member['inviter'] == 1) {
              if (!empty($referrer_info)) {
                  $info = $referrer_info->toArray();
                  $data = [
                      'uid' => $info['uid'],
                      'avatar' => $info['avatar'],
                      'nickname' => $info['nickname'],
                      'level' => $info['yz_member']['level']['level_name'],
                      'is_show' => $set['is_referrer']
                  ];
              } else {
                  $data = [
                      'uid' => '',
                      'avatar' => $avatar,
                      'nickname' => '总店',
                      'level' => '',
                      'is_show' => $set['is_referrer']
                  ];
              }
          } else {
              $data = [
                  'uid' => '',
                  'avatar' => $avatar,
                  'nickname' => '暂无',
                  'level' => '',
                  'is_show' => $set['is_referrer']
              ];
          }*/

        if (!empty($referrer_info)) {
            $info = $referrer_info->toArray();
            if ($yz_member['inviter'] == 1) {
                $set_name = '';
                $data = [
                    'uid'      => $info['uid'],
                    'avatar'   => $info['avatar'],
                    'nickname' => $set_name . $info['nickname'],
                    'level'    => $info['yz_member']['level']['level_name'],
                    'is_show'  => $set['is_referrer']
                ];
            } else {
                $set_name = '(暂定)';
                $data = [
                    'uid'      => $info['uid'],
                    'avatar'   => $info['avatar'],
                    'nickname' => $set_name . $info['nickname'],
                    'level'    => $info['yz_member']['level']['level_name'],
                    'is_show'  => $set['is_referrer']
                ];
            }
        } else {
            $data = [
                'uid'      => '',
                'avatar'   => $avatar,
                'nickname' => '总店',
                'level'    => '',
                'is_show'  => $set['is_referrer']
            ];
        }

        return $data;
    }

    /**
     * 我的推荐人 v2
     *
     * @return array
     */
    public static function getMyReferral_v2()
    {
        ini_set('memory_limit', -1);

        $member_id = \YunShop::app()->getMemberId();
        $member_info = self::getMyReferrerInfo($member_id)->first();
        $unicid = \YunShop::app()->uniacid;
        $set = \Setting::get('shop.member');
        $data = [];
        $member_set = \Setting::get('relation_base');

        if (!empty($member_info)) {
            if (isset($set) && $set['headimg']) {
                $avatar = replace_yunshop(yz_tomedia($set['headimg']));
            } else {
                $avatar = Url::shopUrl('static/images/photo-mr.jpg');
            }

            $member_info = $member_info->toArray();
            $member_info['avatar'] = yz_tomedia($member_info['avatar']);
            $builder = self::getUserInfos($member_info['yz_member']['parent_id']);
            $referrer_info = self::getMemberRole($builder)->first();

            if ($member_info['yz_member']['inviter'] == 1) {
                if (!empty($referrer_info)) {
                    $info = $referrer_info->toArray();
                    $data = [
                        'uid'             => $info['uid'],
                        'avatar'          => $info['avatar'],
                        'nickname'        => $info['nickname'],
                        'level'           => $info['yz_member']['level']['level_name'],
                        'is_show'         => $member_set['is_referrer'] ?: 0,
                        'referrer_phone'  => $info['mobile'],
                        'referrer_wechat' => $info['yz_member']['wechat'],
                    ];
                } else {
                    $data = [
                        'uid'      => '',
                        'avatar'   => $avatar,
                        'nickname' => '总店',
                        'level'    => '',
                        'is_show'  => $member_set['is_referrer'] ?: 0,
                    ];
                }
            } else {
                $data = [
                    'uid'      => '',
                    'avatar'   => $avatar,
                    'nickname' => '暂无',
                    'level'    => '',
                    'is_show'  => $member_set['is_referrer'] ?: 0,
                ];
            }

            //团队1级会员
//            $order = DB::table('yz_order')->select('uid', 'price', 'goods_total', 'status')->where(['status' => 3, 'uniacid' => $unicid])->get();
//            $order_goods = DB::table('yz_order')->select('uid', 'price', 'goods_total', 'status')->where(['uniacid' => $unicid])->where('status', '>=', 1)->get();
//
//            $member_1 = DB::table('yz_member_children')->select('child_id')->where('member_id', $member_id)->where('level', 1)->where('uniacid', $unicid)->get();
//            foreach ($member_1 as $child_id) {
//                $child_id1[] = $child_id['child_id'];
//            }
//            $data['child_total'] = collect($child_id1)->count();
//            $data['child_order_money'] = round($order->whereIn('uid', $child_id1)->sum('price'), 2);
//
//            团队会员
//            $childMemberTeam = DB::table('yz_member_children')->select('child_id')->where('member_id', $member_id)->where('uniacid', $unicid)->get();
//            foreach ($childMemberTeam as $child_id) {
//                $child_idAll[] = $child_id['child_id'];
//            }
//            $data['team_total'] = collect($child_idAll)->count();
//            $data['team_order_money'] = round($order->whereIn('uid', $child_idAll)->sum('price'), 2);
//            $data['team_goods_total'] = $order_goods->whereIn('uid', $child_idAll)->sum('goods_total');


            //---------------------new-----------------------
            //团队1级会员
            $data['child_total'] = DB::table('yz_member_children')
                ->join('yz_member', function ($join) {
                    $join->on('yz_member.member_id', '=', 'yz_member_children.child_id')
                        ->whereNull('deleted_at');
                })
                ->where('yz_member_children.uniacid',$unicid)
                ->where('yz_member_children.member_id',$member_id)
                ->where('level',1)
                ->count();

            $childs = MemberChildren::uniacid()->where("member_id",$member_id)->pluck("child_id");

            $level_childs = MemberChildren::uniacid()->where("member_id",$member_id)->where("level",1)->pluck("child_id");

            if(app('plugins')->isEnabled('agent-list-set') && \Setting::get('plugin.agent-liset-set.pay_order')){
                $team_order_money = SetController::getChildOrderMoney($member_id, $unicid);  //统计已完成+已支付订单+自己的订单
            }else{

                if (empty($level_childs)) {
                    $team_order_money = 0 ;
                } else {
                    $team_order_money = Order::uniacid()
                        ->whereIn("uid",$level_childs)
                        ->where('yz_order.status',3)
                        ->sum('yz_order.price');
                }
            }

            $data['child_order_money'] = round($team_order_money,2);
            
            //团队会员
            $data['team_total'] = DB::table('yz_member_children')
                ->join('yz_member', function ($join) {
                    $join->on('yz_member.member_id', '=', 'yz_member_children.child_id')
                        ->whereNull('deleted_at');
                })
                ->where('yz_member_children.uniacid',$unicid)
                ->where('yz_member_children.member_id',$member_id)
                ->count();


            if(app('plugins')->isEnabled('agent-list-set') && \Setting::get('plugin.agent-liset-set.pay_order')){
                $team_all = SetController::getAllOrderMoney($member_id, $unicid);  //统计已完成+已支付订单+自己的订单
            }else {
                if (empty($childs)) {
                    $team_all = 0;
                } else {
                    $team_all = Order::uniacid()
                        ->whereIn("uid", $childs)
                        ->where('yz_order.status', 3)
                        ->sum('yz_order.price');
                }
            }
            $data['team_order_money'] = round($team_all,2);

            if (empty($childs)) {
                $team_goods_total = 0;
            } else {
                $team_goods_total = Order::uniacid()
                    ->whereIn("uid",$childs)
                    ->where('yz_order.status','>=',1)
                    ->sum('yz_order.goods_total');
            }

            $data['team_goods_total'] = intval($team_goods_total);
            //---------------------new-----------------------
        }

        $data['self'] = $member_info;
        $data['is_recommend_wechat'] = $member_set['is_recommend_wechat'] ?: 0;
        $data['wechat'] = $member_set['relation_level']['wechat'] ?: 0;
        $data['phone'] = $member_set['relation_level']['phone'] ?: 0;
        $data['realname'] = $member_set['relation_level']['realname'] ?: 0;
        $data['name1'] = $member_set['relation_level']['name1'] ?: '';
        $data['name2'] = $member_set['relation_level']['name2'] ?: '';
        $data['name3'] = $member_set['relation_level']['name3'] ?: '';

        return $data;
    }

    /**
     * 推广二维码
     *
     * @param string $extra
     * @return mixed
     */
    public static function getAgentQR($extra = '')
    {
        //把首页链接换成会员中心链接
        $url = Url::absoluteApp('/member');
        $url = $url . '&mid=' . \YunShop::app()->getMemberId();

        if (!empty($extra)) {
            $extra = '_' . $extra;
        }

        $extend = 'png';
        $filename = \YunShop::app()->uniacid . '_' . \YunShop::app()->getMemberId() . $extra . '.' . $extend;
        $path = \Storage::url('app/public/qr/');
        //格式                        参数    保存路径
        QrCode::format($extend)->size(400)->generate($url, base_path($path) . $filename);

        return request()->getSchemeAndHttpHost() . config('app.webPath') . $path . $filename;
    }

    //生成小程序二维码
    public function getWxacode($extra = '')
    {
        if (!empty($extra)) {
            $extra = '_' . $extra;
        }
        $extend = 'png';
        $filename = \YunShop::app()->uniacid . '_' . \YunShop::app()->getMemberId() . $extra . '.' . $extend;
        $paths = \Storage::url('app/public/qr/');

        $decorate_open = \Setting::get('plugin.decorate.is_open');

        $page = 'pages/member/index_v2/index_v2';
        if (\YunShop::plugin()->get('decorate') && $decorate_open == 1) {
            $page = 'packageG/member_v2/member_v2';
        }

        $url = "https://api.weixin.qq.com/wxa/getwxacodeunlimit?";
        $token = self::getTokenUrlStr();
        $url .= "access_token=" . $token;
        $postdata = [
            "scene" => 'mid=' . \YunShop::app()->getMemberId(),
            "page"  => $page,
            'width' => 200
        ];

        $res = self::curl_post($url, json_encode($postdata), $options = array());//请求生成二维码
        \Log::debug('------生成小程序二维码------', json_decode($res, true));
        file_put_contents(base_path($paths) . $filename, $res);//保存二维码

        return request()->getSchemeAndHttpHost() . config('app.webPath') . $paths . $filename;
    }

    //获取token的url参数拼接
    public function getTokenUrlStr()
    {
        $set = \Setting::get('plugin.min_app');
        $getTokenUrl = "https://api.weixin.qq.com/cgi-bin/token?"; //获取token的url
        $WXappid = $set['key']; //APPID
        $WXsecret = $set['secret']; //secret
        $str = $getTokenUrl;
        $str .= "grant_type=client_credential&";
        $str .= "appid=" . $WXappid . "&";
        $str .= "secret=" . $WXsecret;
        $res = self::curl_post($str, $postdata = '', $options = array());
        $data = json_decode($res, JSON_FORCE_OBJECT);
        return $data['access_token'];
    }

    public function curl_post($url = '', $postdata = '', $options = array())
    {
        $ch = curl_init($url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
        curl_setopt($ch, CURLOPT_TIMEOUT, 5);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);
        if (!empty($options)) {
            curl_setopt_array($ch, $options);
        }
        $data = curl_exec($ch);
        curl_close($ch);
        return $data;
    }

    /**
     * 我推荐的人
     * @return array
     */
    public static function getMyAgent()
    {
        $agent_ids = [];
        $data = [];

        $agent_info = MemberModel::getMyAgentInfo(\YunShop::app()->getMemberId());
        $agent_model = $agent_info->get();

        if (!empty($agent_model)) {
            $agent_data = $agent_model->toArray();

            foreach ($agent_data as $key => $item) {
                $agent_ids[$key] = $item['uid'];
                $agent_data[$key]['agent_total'] = 0;
            }
        } else {
            return '数据为空';
        }

        $all_count = MemberShopInfo::getAgentAllCount($agent_ids);

        foreach ($all_count as $k => $rows) {
            foreach ($agent_data as $key => $item) {
                if ($rows['parent_id'] == $item['uid']) {
                    $agent_data[$key]['agent_total'] = $rows['total'];

                    break 1;
                }
            }
        }

        if ($agent_data) {
            foreach ($agent_data as $item) {
                $data[] = [
                    'uid'         => $item['uid'],
                    'avatar'      => $item['avatar'],
                    'nickname'    => $item['nickname'],
                    'order_total' => $item['has_one_order']['total'],
                    'order_price' => $item['has_one_order']['sum'],
                    'agent_total' => $item['agent_total'],
                ];
            }
        }

        return $data;
    }

    /**
     * 我推荐的人v2 基本信息
     * @return array
     */
    public static function getMyAgent_v2()
    {
        set_time_limit(0);

        $data = [
            'total' => 0
        ];

        $total = 0;

        $first = true;
        $second = true;
        $relation_base = \Setting::get('relation_base');
        if (!empty($relation_base['relation_level'])) {
            $first = $relation_base['relation_level'][0] ? true : false;
            $second = $relation_base['relation_level'][1] ? true : false;
        }

        for ($i = 1; $i <= 3; $i++) {
            $text = 'level' . $i;

            switch ($i) {
                case 1:
                    $is_show = $first;
                    $level = '一级';
                    $level_p = 1;
                    break;
                case 2:
                    $is_show = $second;
                    $level = '二级';
                    $level_p = 2;
                    break;
                case 3:
                    $is_show = false;
                    $level = '三级';
                    $level_p = 3;
                    break;
            }

            if ($is_show) {
                $builder = MemberModel::getMyAllAgentsInfo(\YunShop::app()->getMemberId(), $i);

                $agent_info = self::getMemberRole($builder)->get();

                $agent_data = $agent_info->toArray();

                $total += count($agent_data);

                $data[$text] = [
                    'level'   => $level,
                    'total'   => count($agent_data),
                    'is_show' => $is_show,
                    'level_p' => $level_p,
                ];
            } else {
                $total += 0;

                $data[$text] = [
                    'level'   => $level,
                    'total'   => 0,
                    'is_show' => $is_show,
                    'level_p' => $level_p,
                ];
            }
        }


        $data['total'] = $total;

        return $data;
    }

    public function orders()
    {
        return $this->hasMany(Order::class, 'uid', 'uid');
    }

    public function memberChildren()
    {
        return $this->hasMany(MemberChildren::class, 'member_id', 'uid');
    }

    /**
     * 我推荐的人v2 数据
     * @return array
     */
    public static function getMyAgentData_v2()
    {
        $relationLevel = request()->input('relationLevel', 1);
        $pageSize = 10;
        $keyword = request()->input('keyword');

        // 查出用户的某一级别下线的会员资料
        $member = MemberModel::find(\app\frontend\models\Member::current()->uid);
        if (!$member) {
            return [];
        }

        //获取一级下级会员ID
        $teamMembersIds = $member->memberChildren()->where('level', $relationLevel)->pluck('child_id')->toArray();

        if (!empty($keyword)) {
            $key_uid = MemberModel::uniacid()->where('nickname', 'like', '%' . $keyword . '%')
                ->orWhere('mobile', 'like', '%' . $keyword . '%')
                ->orWhere('realname', 'like', '%' . $keyword . '%')
                ->pluck('uid')
                ->toArray();

            $teamMembersIds = array_intersect($teamMembersIds, $key_uid);
        }

        // 总订单数,总订单金额
        // todo yz_member 中的wechat 拿到外层    uid as id    withSum
        if(app('plugins')->isEnabled('agent-list-set') && \Setting::get('plugin.agent-liset-set.pay_order')){
            $teamMembers = SetController::getTeamMember($pageSize, $teamMembersIds);  //统计已完成+已支付订单
        }else{
            $teamMembers = MemberModel::select(['mobile', 'createtime', 'avatar', 'nickname', 'uid','realname'])
                ->whereIn('uid', $teamMembersIds)
                ->with(['yzMember'  => function ($builder) {
                    $builder->select(['member_id', 'is_agent', 'status', 'wechat', 'deleted_at', 'inviter']);
                }, 'orders'         => function ($order) {
                    $order->select(['id', 'uid', 'price', 'status'])->where('status', 3);
                }, 'memberChildren' => function ($member) {
                    $member->select(['id', 'child_id', 'level', 'member_id'])->where('level', 1)
                        ->with(['orders' => function ($order) {
                            $order->select(['id', 'uid', 'price', 'status'])->where('status', 3);
                        }]);
                }])
                ->orderBy('uid', 'desc')
                ->simplePaginate($pageSize)
                ->toArray();
        }
        $teamMembers['total'] = count($teamMembersIds);
        $teamMembers['last_page'] = ceil($teamMembers['total'] / $pageSize);

        foreach ($teamMembers['data'] as &$v) {
            $v['team_order_money'] = round(collect($v['member_children'])->sum(function ($member_children) {
                return collect($member_children['orders'])->sum('price');
            }), 2);
            $v['team_total'] = collect($v['member_children'])->count();

            //会员自己
            $v['child_order_money'] = round(collect($v['orders'])->sum('price'), 2);
            $v['child_order_total'] = collect($v['orders'])->count();

            $v['avatar'] = $v['avatar_image'];
            $v['createtime'] = date('Y-m-d H:i:s', $v['createtime']);
            unset($v['avatar_image']);

            $v['id'] = $v['uid'];
            unset($v['uid']);
            $v['wechat'] = $v['yz_member']['wechat'] ?: 0;
            $v['mobile'] = $v['mobile'] ?: 0;
            $v['realname'] = $v['realname'] ?: 0;
            if (empty($v['yz_member']['inviter'])) {
                $v['inviter'] = 1;
            } else {
                $v['inviter'] = 0;
            }
            if (!is_null($v['yz_member'])) {
                if (1 == $v['yz_member']['is_agent'] && 2 == $v['yz_member']['status']) {
                    $v['is_agent'] = 1;
                }
            }

            unset($v['yz_member']);
            unset($v['member_children']);
            unset($v['orders']);

        }

        return $teamMembers;
    }

    /**
     * 获取用户信息
     *
     * @param $member_id
     * @return mixed
     */
    public static function getUserInfos_v2($member_id)
    {

        return self::select(['uid', 'uniacid', 'credit1', 'credit2', 'credit3', 'createtime', 'nickname', 'realname', 'avatar', 'mobile', 'birthyear', 'birthmonth', 'birthday', 'gender', 'alipay'])
            ->uniacid()
            ->where('uid', $member_id)
            ->with([
                'yzMember'   => function ($query) {
                    return $query->select(['*'])->where('is_black', 0)
                        ->with([
                            'group' => function ($query1) {
                                return $query1->select(['id', 'group_name']);
                            },
                            'level' => function ($query2) {
                                return $query2->select(['id', 'level_name']);
                            },
                            'agent' => function ($query3) {
                                return $query3->select(['uid', 'avatar', 'nickname']);
                            }
                        ]);
                },
                'hasOneFans' => function ($query4) {
                    return $query4->select(['uid', 'openid', 'follow as followed']);
                },
            ]);
    }

    /**
     * 会员中心返回数据
     *
     * @param $member_info
     * @param $yz_member
     * @return mixed
     */
    public static function userData($member_info, $yz_member)
    {
        $set = \Setting::get('shop.member');
        if (!empty($yz_member)) {
            $member_info['alipay_name'] = $yz_member['alipayname'];
            $member_info['alipay'] = $yz_member['alipay'];
            $member_info['province_name'] = $yz_member['province_name'];
            $member_info['city_name'] = $yz_member['city_name'];
            $member_info['area_name'] = $yz_member['area_name'];
            $member_info['province'] = $yz_member['province'];
            $member_info['city'] = $yz_member['city'];
            $member_info['area'] = $yz_member['area'];
            $member_info['address'] = $yz_member['address'];
            $member_info['wechat'] = $yz_member['wechat'];

            if (!empty($yz_member['group'])) {
                $member_info['group_id'] = $yz_member['group']['id'];
                $member_info['group_name'] = $yz_member['group']['group_name'];
            }

            if (!empty($yz_member['level'])) {
                $member_info['level_id'] = $yz_member['level']['id'];
                $member_info['level_name'] = $yz_member['level']['level_name'];
            } else {
                $member_info['level_id'] = 0;
                $member_info['level_name'] = $set['level_name'] ? $set['level_name'] : '普通会员';
            }

            $member_info['is_agent'] = $yz_member['is_agent'] == 1 && $yz_member['status'] == 2 ? true : false;

            $member_info['referral'] = self::getMyReferral_v3($yz_member, $set);
        }

        if (!empty($member_info['birthyear'])) {
            $member_info['birthday'] = date('Y-m-d', strtotime($member_info['birthyear'] . '-' . $member_info['birthmonth'] . '-' . $member_info['birthday']));
        } else {
            $member_info['birthday'] = date('Y-m-d', time());
        }

        //创建二维码目录
        self::createDir(storage_path('app/public/qr'));
        //创建头像目录
        self::createDir(storage_path('app/public/avatar'));

        $member_info['qr'] = self::getAgentQR();
        $member_info['avatar_dir'] = request()->getSchemeAndHttpHost() . config('app.webPath') . \Storage::url('app/public/avatar/');

        $member_info['avatar'] = $member_info['avatar'] ? yz_tomedia($member_info['avatar']) : yz_tomedia(\Setting::get('shop.member.headimg'));
        //修复微信头像地址
        $member_info['avatar'] = ImageHelper::fix_wechatAvatar($member_info['avatar']);
        //IOS时，把微信头像url改为https前缀
        $member_info['avatar'] = ImageHelper::iosWechatAvatar($member_info['avatar']);

        $shop = \Setting::get('shop.shop');
        //版权信息
        $member_info['copyright'] = $shop['copyright'] ?: '';

        $member_info['credit'] = [
            //增加是否显示余额值
            'is_show' => \Setting::get('shop.member.show_balance') ? 0 : 1,
            'text'    => !empty($shop['credit']) ? $shop['credit'] : '余额',
            'data'    => $member_info['credit2']
        ];

        //显示积分
        $member_info['integral'] = [
            'text' => !empty($shop['credit1']) ? $shop['credit1'] : '积分',
            'data' => $member_info['credit1']
        ];

        //增加是否显示爱心值值
        $member_info['love_show'] = [
            'is_show' => \Setting::get('love.member_center_show') ? 1 : 0,
            'text'    => '爱心值',
            'data'    => '0.00'
        ];
        if (app('plugins')->isEnabled('love')) {
            $memberLove = MemberLove::where('member_id', \YunShop::app()->getMemberId())->first();
            $member_info['love_show']['text'] = LOVE_NAME;
            $member_info['love_show']['data'] = $memberLove->usable ?: '0.00';
        }

        //订单显示

//        $order_info = \app\frontend\models\Order::getOrderCountGroupByStatus([Order::WAIT_PAY,Order::WAIT_SEND,Order::WAIT_RECEIVE,Order::COMPLETE,Order::REFUND]);
//        $member_info['order'] = $order_info;
//        if (app('plugins')->isEnabled('hotel')) {
//            $member_info['hotel_order'] = \Yunshop\Hotel\common\models\Order::getHotelOrderCountGroupByStatus([Order::WAIT_PAY,Order::WAIT_SEND,Order::WAIT_RECEIVE,Order::COMPLETE,Order::REFUND]);
//        }
//
//        if (\app\common\services\plugin\leasetoy\LeaseToySet::whetherEnabled()) {
//            $member_info['lease_order'] = \Yunshop\LeaseToy\models\Order::getLeaseOrderCountGroupByStatus([Order::WAIT_PAY,Order::WAIT_SEND,Order::WAIT_RECEIVE,Order::COMPLETE,Order::REFUND]);
//        }

        $member_info['is_agent'] = self::isAgent();
        $member_info['referral'] = self::getMyReferral();
        return $member_info;
    }

    /**
     * 会员中心返回数据
     *
     * @param $member_info
     * @param $yz_member
     * @return mixed
     */
    public static function userData_v2($member_info, $yz_member)
    {
        $set = \Setting::get('shop.member');
        if (!empty($yz_member)) {

            if (!empty($yz_member['group'])) {
                $member_info['group_id'] = $yz_member['group']['id'];
                $member_info['group_name'] = $yz_member['group']['group_name'];
            }

            if (!empty($yz_member['level'])) {
                $member_info['level_id'] = $yz_member['level']['id'];
                $member_info['level_name'] = $yz_member['level']['level_name'];
            } else {
                $member_info['level_id'] = 0;
                $member_info['level_name'] = $set['level_name'] ? $set['level_name'] : '普通会员';
            }
            $member_info['alipay_name'] = $yz_member['alipayname'];
            $member_info['alipay'] = $yz_member['alipay'];
            $member_info['province_name'] = $yz_member['province_name'];
            $member_info['city_name'] = $yz_member['city_name'];
            $member_info['area_name'] = $yz_member['area_name'];
            $member_info['province'] = $yz_member['province'];
            $member_info['city'] = $yz_member['city'];
            $member_info['area'] = $yz_member['area'];
            $member_info['address'] = $yz_member['address'];
            $member_info['wechat'] = $yz_member['wechat'];

            $member_info['is_agent'] = $yz_member['is_agent'] == 1 && $yz_member['status'] == 2 ? true : false;

            $member_info['referral'] = self::getMyReferral_v3($yz_member, $set);
        }

        if (!empty($member_info['birthyear'])) {
            $member_info['birthday'] = date('Y-m-d', strtotime($member_info['birthyear'] . '-' . $member_info['birthmonth'] . '-' . $member_info['birthday']));
        } else {
            $member_info['birthday'] = date('Y-m-d', time());
        }

        //创建二维码目录
        //self::createDir(storage_path('app/public/qr'));
        //创建头像目录
        self::createDir(storage_path('app/public/avatar'));

        //$member_info['qr'] = self::getAgentQR();
        $member_info['avatar_dir'] = request()->getSchemeAndHttpHost() . config('app.webPath') . \Storage::url('app/public/avatar/');

        $member_info['avatar'] = $member_info['avatar'] ? yz_tomedia($member_info['avatar']) : yz_tomedia(\Setting::get('shop.member.headimg'));
        //修复微信头像地址
        $member_info['avatar'] = ImageHelper::fix_wechatAvatar($member_info['avatar']);
        //IOS时，把微信头像url改为https前缀
        $member_info['avatar'] = ImageHelper::iosWechatAvatar($member_info['avatar']);

        $shop = \Setting::get('shop.shop');
        //版权信息
        $member_info['copyright'] = \Setting::get('shop.shop.copyright','');

        $member_info['credit'] = [
            //增加是否显示余额值
            'is_show' => \Setting::get('shop.member.show_balance') ? 0 : 1,
            'text'    => \Setting::get('shop.shop.credit')?:'余额',
            'data'    => $member_info['credit2']
        ];

        //显示积分
        $member_info['integral'] = [
            'is_show' => \Setting::get('shop.member.show_point') ? 0 : 1,
            'text'    => \Setting::get('shop.shop.credit1')?:'积分',
            'data'    => $member_info['credit1']
        ];

        //显示优惠券
        $member_info['coupon'] = [
            'is_show' => 1,
            'text'    => '优惠券',
            'data'    => \app\frontend\modules\coupon\models\MemberCoupon::getCouponsOfMember($yz_member['member_id'])
                ->where('used', '=', 0)
                ->where('is_member_deleted', 0)
                ->where('is_expired', 0)
                ->count()
        ];

        //增加是否显示爱心值值
        $member_info['love_show'] = [
            'usable_love_show' => \Setting::get('love.member_center_show') ? 1 : 0,
            'unable_love_show' => \Setting::get('love.member_center_unable_show') ? 1 : 0,
            'usable_text'      => '爱心值',
            'unable_text'      => '白爱心值',
            'usable_data'      => '0.00',
            'unable_data'      => '0.00'
        ];
        if (app('plugins')->isEnabled('love')) {
            $memberLove = MemberLove::where('member_id', \YunShop::app()->getMemberId())->first();
            if (app('plugins')->isEnabled('cloud-link-port')) {
                self::loveChange($member_info, $memberLove);
            }
            $memberLove = MemberLove::where('member_id', \YunShop::app()->getMemberId())->first();//改完之后要重新查获取新的
            $member_info['love_show']['usable_text'] = \Yunshop\Love\Common\Services\SetService::getLoveSet('usable_name') ?: LOVE_NAME;
            $member_info['love_show']['usable_data'] = $memberLove->usable ?: '0.00';
            $member_info['love_show']['unable_text'] = \Yunshop\Love\Common\Services\SetService::getLoveSet('unable_name') ?: '白' . LOVE_NAME;
            $member_info['love_show']['unable_data'] = $memberLove->froze ?: '0.00';
        } else {
            $member_info['love_show']['usable_love_show'] = 0;
            $member_info['love_show']['unable_love_show'] = 0;
        }
        //增加是否显示消费积分值
        $member_info['integral_show'] = [
            'is_show' => false,
            'text'    => '消费积分',
            'data'    => '0.00'
        ];
        if (app('plugins')->isEnabled('integral')) {
            $memberIntegral = IntegralMemberModel::where('uid', \YunShop::app()->getMemberId())->first();
            $member_info['integral_show']['is_show'] = !!SetService::getIntegralSet('member_show_integral');
            $member_info['integral_show']['text'] = INTEGRAL_NAME;
            $member_info['integral_show']['data'] = $memberIntegral->integral ?: '0.00';
        }
        //增加供销积分显示
        $member_info['ecological_point_show'] = [
            'is_show' => false,
            'text'    => '供销积分',
            'data'    => '0.000000000000'
        ];
        if (app('plugins')->isEnabled('ecological-point') && \Setting::get('plugin.ecological_point.plugin_switch')) {
            $memberEcologicalPoint = PointModel::getPointModel(\YunShop::app()->getMemberId());
            /**
             * @var PointModel $memberEcologicalPoint
             */
            $member_info['ecological_point_show'] = [
                'is_show' => true,
                'text'    => ECOLOGICAL_POINT,
                'data'    => $memberEcologicalPoint->point
            ];
        }
        if (app('plugins')->isEnabled('consume-coupon-switch') && \Setting::get('plugin.consume_coupon_switch.status') == 1) {
            if (app('plugins')->isEnabled('universal-card')) {
                $consume_coupon = ConsumeCoupon::uniacid()->where('member_id', \YunShop::app()->getMemberId())->first();
                $member_info['consume_coupon_show']['is_show'] = \Setting::get('plugin.universal_card.member_center_show');
                $member_info['consume_coupon_show']['text'] = \Setting::get('plugin.universal_card.consume_coupon_text')?:'消费券余额';
                $member_info['consume_coupon_show']['amount'] = $consume_coupon->amount ?: 0.00;
            }
        }
        if (app('plugins')->isEnabled('consumer-reward') && \Setting::get('plugin.consumer_reward.is_open') == 1) {
            $consume_amount = ConsumerRewardRecordModel::getRecord(\YunShop::app()->getMemberId())->sum('reward_amount');
            $member_info['consumer_reward_show']['is_show'] = \Setting::get('plugin.consumer_reward.is_display');
            $member_info['consumer_reward_show']['text'] = \Setting::get('plugin.consumer_reward.name')?:'消费奖励';
            $member_info['consumer_reward_show']['amount'] = $consume_amount ?: 0.00;
        }

        //会员等级日期
        if (!is_null($member_info['yz_member']['validity'])) {
            if ($member_info['yz_member']['level_id'] == 0) {
                $member_info['yz_member']['validity'] = '';
            } else {
                $day = $member_info['yz_member']['validity'] - 1;
                $member_info['yz_member']['validity'] = date('Y-m-d',strtotime($day.' days'));
            }
        }


        return $member_info;
    }

    public function loveChange($member_info, $memberLove)
    {
        $set = SetModel::uniacid()->first(['is_advert']);
        if ($set && $set['is_advert'] && $member_info['mobile']) {
            $advertService = new AdvertService();
            $advertService->bindMember($member_info['mobile']);
            $res = $advertService->queryMemberAndChange($member_info['mobile']);
            if ($res['code'] == 200) {
                $compare_res = bccomp($res['data'][0]['balance'], $memberLove->usable,2);
                switch ($compare_res) {
                    case 1 :
                        self::add($res['data'][0]['balance'], $memberLove->usable, $member_info);
                        break;
                    case -1 :
                        self::reduce($res['data'][0]['balance'], $memberLove->usable, $member_info);
                        break;
                }
            }
        }
    }

    public function add($balance, $usable, $member_info)
    {
        $change_value = bcsub($balance, $usable, 2);
        (new LoveChangeService())->CloudLinkAdd(
            [
                'member_id' => $member_info['uid'],
                'change_value' => $change_value,
                'operator' => ConstService::OPERATOR_MEMBER,
                'operator_id' => $member_info['uid'],
                'remark' => '云链接口增加',
                'relation' => '',
            ]
        );
        $save_data = [
            'uniacid' => $member_info['uniacid'],
            'uid' => $member_info['uid'],
            'mobile' => $member_info['mobile'],
            'change_type' => 1,
            'love' => $change_value,
            'love_before' => $usable,
            'love_after' => $balance,
            'call_back_status' => 1,
            'call_back_message' => '',
        ];
        return ChangeLog::create($save_data);
    }

    public function reduce($balance, $usable, $member_info)
    {
        $change_value = bcsub($usable, $balance, 2);
        (new LoveChangeService())->CloudLinkReduce(
            [
                'member_id' => $member_info['uid'],
                'change_value' => $change_value,
                'operator' => ConstService::OPERATOR_MEMBER,
                'operator_id' => $member_info['uid'],
                'remark' => '云链接口减少',
                'relation' => '',
            ]
        );
        $save_data = [
            'uniacid' => $member_info['uniacid'],
            'uid' => $member_info['uid'],
            'mobile' => $member_info['mobile'],
            'change_type' => 1,
            'love' => -$change_value,
            'love_before' => $usable,
            'love_after' => $balance,
            'call_back_status' => 1,
            'call_back_message' => '',
        ];
        return ChangeLog::create($save_data);
    }

    public static function createDir($dest)
    {
        if (!is_dir($dest)) {
            (@mkdir($dest, 0777, true));
        }
    }

    public static function convertRoleText($member_modle)
    {
        $commission = self::langFiled('commission');

        $member_role = '';

        if (!is_null($member_modle)) {
            if (app('plugins')->isEnabled('commission')) {
                if (!is_null($member_modle->hasOneAgent)) {
                    $member_role .= $commission['agent'] ?: '分销商';
                    $member_role .= '&';
                }
            }

            if (app('plugins')->isEnabled('team-dividend')) {
                if (!is_null($member_modle->hasOneTeamDividend)) {
                    $member_role .= '经销商&';
                }
            }

            if (app('plugins')->isEnabled('area-dividend')) {
                if (!is_null($member_modle->hasOneAreaDividend)) {
                    $member_role .= '区域代理&';
                }
            }

            if (app('plugins')->isEnabled('merchant')) {
                if (!is_null($member_modle->hasOneMerchant)) {
                    $member_role .= '招商员&';
                }

                if (!is_null($member_modle->hasOneMerchantCenter)) {
                    if (1 == $member_modle->hasOneMerchant->is_center) {
                        $member_role .= '招商中心&';
                    }
                }
            }

            if (app('plugins')->isEnabled('micro')) {
                if (!is_null($member_modle->hasOneMicro)) {
                    $member_role .= '微店店主&';
                }
            }

            if (app('plugins')->isEnabled('supplier')) {
                if (!is_null($member_modle->hasOneSupplier)) {
                    $member_role .= '供应商&';
                }
            }
        }

        if (!empty($member_role)) {
            $member_role = rtrim($member_role, '&');
        }

        return $member_role;
    }

    public static function fetchAgentInfo($agent_info)
    {
        if (empty($agent_info)) {
            return [];
        }

        return collect($agent_info)->map(function ($item) {
            $is_agent = 0;


            if (!is_null($item->yzMember)) {
                if (1 == $item->yzMember->is_agent && 2 == $item->yzMember->status) {
                    $is_agent = 1;
                }
            }

            //团队1级会员
            $order = DB::table('yz_order')->select('uid', 'price', 'status')->where('status', 3)->where('uniacid', \YunShop::app()->uniacid)->get();
            $result['child_order_total'] = $order->whereIn('uid', $item->uid)->count();
            $result['child_order_money'] = $order->whereIn('uid', $item->uid)->sum('price');
            //团队全部会员
            $childMemberTeam = DB::table('yz_member_children')->select('child_id')->where('member_id', $item->uid)->where('uniacid', \YunShop::app()->uniacid)->where('level', 1)->get();
            foreach ($childMemberTeam as $child_id) {
                $child_idAll[] = $child_id['child_id'];
            }
            $result['team_total'] = collect($child_idAll)->count();
            $result['team_order_money'] = $order->whereIn('uid', $child_idAll)->sum('price');
//            dd($result);

            return [
                'id'                => $item->uid,
                'is_agent'          => $is_agent,
                'nickname'          => $item->nickname,
                'avatar'            => $item->avatar,
//                'order_price' => $order_price,
//                'agent_total' => $agent_total,
//                'agent_order_price' => $agent_order_price,
//                'role' => $role,
//                'role_type' => $role_type,
                'createtime'        => date('Y-m-d H:i:s', $item->createtime),
                'mobile'            => $item->mobile ?: 0,
                'wechat'            => $item->yzMember->wechat ?: 0,
                'child_order_money' => $result['child_order_money'] ?: 0,
                'child_order_total' => $result['child_order_total'] ?: 0,
                'team_order_money'  => $result['team_order_money'] ?: 0,
                'team_total'        => $result['team_total'] ?: 0,
            ];
        });
    }

    public static function searchMemberRelation($data)
    {
        $result = [];
        $keyword = \YunShop::request()->keyword;
        $level = \YunShop::request()->level;
        $filter = ['招商员', '供应商']; //没有等级

        $coll = collect($data)->filter(function ($item) use ($keyword, $level, $filter) {
            $role_level = false;
            $role = preg_match("/{$keyword}/", $item['role']);

            if ($role) {
                if (in_array($keyword, $filter) || empty($level)) {
                    $role_level = true;
                }

                if (!empty($item['role_type'])) {
                    foreach ($item['role_type'] as $rows) {
                        foreach ($rows as $key => $val) {
                            if ($key == $keyword && $val == $level) {
                                $role_level = true;
                            }

                            break 2;
                        }
                    }
                }
            }

            return $role && $role_level;
        });

        if (!$coll->isEmpty()) {
            $result = array_values($coll->toArray());
        }

        return $result;
    }

    public static function setRoleLevel($member_modle)
    {
        $commission = self::langFiled('commission');
        $commission_filed = $commission['agent'] ?: '分销商';
        $role_type = [];

        if (!is_null($member_modle)) {
            if (app('plugins')->isEnabled('commission')) {
                if (!is_null($member_modle->hasOneAgent)) {
                    array_push($role_type, [$commission_filed => $member_modle->hasOneAgent->agent_level_id]);
                }
            }

            if (app('plugins')->isEnabled('team-dividend')) {
                if (!is_null($member_modle->hasOneTeamDividend)) {
                    array_push($role_type, ['经销商' => $member_modle->hasOneTeamDividend->level]);
                }
            }

            if (app('plugins')->isEnabled('area-dividend')) {
                if (!is_null($member_modle->hasOneAreaDividend)) {
                    array_push($role_type, ['区域代理' => $member_modle->hasOneAreaDividend->agent_level]);
                }
            }

            if (app('plugins')->isEnabled('merchant')) {
                if (!is_null($member_modle->hasOneMerchant)) {
                }

                if (!is_null($member_modle->hasOneMerchantCenter)) {
                    if (1 == $member_modle->hasOneMerchant->is_center) {
                        array_push($role_type, ['招商中心' => $member_modle->hasOneMerchantCenter->level_id]);
                    }
                }
            }

            if (app('plugins')->isEnabled('micro')) {
                if (!is_null($member_modle->hasOneMicro)) {
                    array_push($role_type, ['微店店主' => $member_modle->hasOneMicro->level_id]);
                }
            }

            if (app('plugins')->isEnabled('supplier')) {
                if (!is_null($member_modle->hasOneSupplier)) {
                }
            }
        }

        return $role_type;
    }

    public static function filterMemberRoleAndLevel()
    {
        $commission = self::langFiled('commission');
        $commission_filed = $commission['agent'] ?: '分销商';
        $data = [];

        if (app('plugins')->isEnabled('commission')) {
            $agent_level = AgentLevel::uniacid()->get();

            if (!$agent_level->isEmpty()) {
                $agent_level = collect($agent_level)->map(function ($item) {
                    return [
                        'id'         => $item->id,
                        'level_name' => $item->name
                    ];
                });

                array_push($data, ['role' => $commission_filed, 'level' => $agent_level->all()]);
            } else {
                array_push($data, ['role' => $commission_filed, 'level' => []]);
            }
        }

        if (app('plugins')->isEnabled('team-dividend')) {
            $teamdividend_level = TeamDividendLevelModel::uniacid()->get();

            if (!$teamdividend_level->isEmpty()) {
                array_push($data, ['role' => '经销商', 'level' => $teamdividend_level->toArray()]);
            } else {
                array_push($data, ['role' => '经销商', 'level' => []]);
            }
        }

        if (app('plugins')->isEnabled('area-dividend')) {
            array_push($data, ['role' => '区域代理', 'level' => [
                ['id' => 1, 'level_name' => '省代理'], ['id' => 2, 'level_name' => '市代理'], ['id' => 3, 'level_name' => '区代理'], ['id' => 4, 'level_name' => '街道代理']
            ]]);
        }

        if (app('plugins')->isEnabled('merchant')) {
            array_push($data, ['role' => '招商员', 'level' => []]);

            $merchant_level = MerchantLevel::uniacid()->get();

            if (!$merchant_level->isEmpty()) {
                array_push($data, ['role' => '招商中心', 'level' => $merchant_level->toArray()]);
            } else {
                array_push($data, ['role' => '招商中心', 'level' => []]);
            }
        }

        if (app('plugins')->isEnabled('micro')) {
            $microShop_level = MicroShopLevel::uniacid()->get();
            if (!$microShop_level->isEmpty()) {
                array_push($data, ['role' => '微店店主', 'level' => $microShop_level->toArray()]);
            } else {
                array_push($data, ['role' => '微店店主', 'level' => []]);
            }
        }

        if (app('plugins')->isEnabled('supplier')) {
            array_push($data, ['role' => '供应商', 'level' => []]);
        }

        return $data;
    }

    private static function langFiled($filed)
    {
        $lang = \Setting::get('shop.lang', ['lang' => 'zh_cn']);
        $set = $lang[$lang['lang']];

        return $set[$filed];
    }

    /**
     * 获取邀请码
     *
     * @param $member_id
     * @return string
     */
    public static function getInviteCode($member_id = null)
    {
        $member_id = $member_id ?: \YunShop::app()->getMemberId();
        $invite_code = self::generateInviteCode();

        if (self::chkInviteCode($invite_code)) {
            MemberShopInfo::updateInviteCode($member_id, $invite_code);

            return $invite_code;
        } else {
            while (true) {
                self::getInviteCode($member_id);
            }
        }
    }

    /**
     * 生成邀请码
     *
     * @return string
     */
    public static function generateInviteCode()
    {
        $str = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
        $rand = $str[rand(0, 25)]
            . strtoupper(dechex(date('m')))
            . date('d') . substr(time(), -5)
            . substr(microtime(), 2, 5)
            . sprintf('%02d', rand(0, 99));
        $code = '';

        for ($f = 0; $f < 8; $f++) {
            $a = md5($rand, true);
            $s = '0123456789ABCDEFGHIJKLMNOPQRSTUV';
            $g = ord($a[$f]);
            $code .= $s[($g ^ ord($a[$f + 8])) - $g & 0x1F];
        };

        return $code;
    }

    /**
     * 验证邀请码
     *
     * @param $code
     */
    public static function chkInviteCode($code)
    {
        if (!MemberShopInfo::chkInviteCode($code)) {
            return true;
        }

        return false;
    }

    /**
     * 获取我的下线全部(包含为确定的)
     *
     * @return mixed
     */
    public static function getAgentCount_v2($uid)
    {
        return self::uniacid()
            ->whereHas('yzMember', function ($query) use ($uid) {
                $query->where('parent_id', $uid);
            })
            ->count();
    }

    /**
     * 注册时验证会员邀请码
     */
    public static function getUniqueInviteCode()
    {
        do {
            $invite_code = self::generateInviteCode();
        } while (!self::chkInviteCode($invite_code));

        return $invite_code;
    }

    /***
     * 验证用户是否有权限访问前端页面(权限设置在店面装修中)
     *
     */
    public function getUserInfoByUid($id){
        return $this->with(['yzMember'])->uniacid()->select(["uid",'uniacid','realname','nickname'])->where('uid',$id)->first();
    }

    public function yzMember()
    {
        return parent::yzMember()->select(['member_id',"level_id",'uniacid']); // TODO: Change the autogenerated stub
    }

}