anxinliao/application/common/model/User.php

<?php

namespace app\common\model;

use think\Db;
use think\Model;

/**
 * 会员模型
 */
class User extends Model
{

    // 开启自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';
    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = '';
    // 追加属性
    protected $append = [
        //'url',
    ];

    /**
     * 获取个人URL
     * @param string $value
     * @param array  $data
     * @return string
     */
    public function getUrlAttr($value, $data)
    {
        return "/u/" . $data['id'];
    }

    /**
     * 获取头像
     * @param string $value
     * @param array  $data
     * @return string
     */
    public function getAvatarAttr($value, $data)
    {
        if (!$value) {
            //如果不需要启用首字母头像，请使用
            //$value = '/assets/img/avatar.png';
            $value = '';
        }
        return $value;
    }

    /**
     * 获取会员的组别
     */
    public function getGroupAttr($value, $data)
    {
        return UserGroup::get($data['group_id']);
    }

    /**
     * 获取验证字段数组值
     * @param string $value
     * @param array  $data
     * @return  object
     */
    public function getVerificationAttr($value, $data)
    {
        $value = array_filter((array)json_decode($value, true));
        $value = array_merge(['email' => 0, 'mobile' => 0], $value);
        return (object)$value;
    }

    /**
     * 设置验证字段
     * @param mixed $value
     * @return string
     */
    public function setVerificationAttr($value)
    {
        $value = is_object($value) || is_array($value) ? json_encode($value) : $value;
        return $value;
    }

    /**
     * 变更会员余额
     * @param int    $money   余额
     * @param int    $user_id 会员ID
     * @param string $memo    备注
     */
    public static function money($money, $user_id, $memo)
    {
        Db::startTrans();
        try {
            $user = self::lock(true)->find($user_id);
            if ($user && $money != 0) {
                $before = $user->money;
                //$after = $user->money + $money;
                $after = function_exists('bcadd') ? bcadd($user->money, $money, 2) : $user->money + $money;
                //更新会员信息
                $user->save(['money' => $after]);
                //写入日志
                MoneyLog::create(['user_id' => $user_id, 'money' => $money, 'before' => $before, 'after' => $after, 'memo' => $memo]);
            }
            Db::commit();
        } catch (\Exception $e) {
            Db::rollback();
        }
    }

    /**
     * 变更会员积分
     * @param int    $score   积分
     * @param int    $user_id 会员ID
     * @param string $memo    备注
     */
    public static function score($score, $user_id, $memo)
    {
        Db::startTrans();
        try {
            $user = self::lock(true)->find($user_id);
            if ($user && $score != 0) {
                $before = $user->score;
                $after = $user->score + $score;
                $level = self::nextlevel($after);
                //更新会员信息
                $user->save(['score' => $after, 'level' => $level]);
                //写入日志
                ScoreLog::create(['user_id' => $user_id, 'score' => $score, 'before' => $before, 'after' => $after, 'memo' => $memo]);
            }
            Db::commit();
        } catch (\Exception $e) {
            Db::rollback();
        }
    }

    /**
     * 根据积分获取等级
     * @param int $score 积分
     * @return int
     */
    public static function nextlevel($score = 0)
    {
        $lv = array(1 => 0, 2 => 30, 3 => 100, 4 => 500, 5 => 1000, 6 => 2000, 7 => 3000, 8 => 5000, 9 => 8000, 10 => 10000);
        $level = 1;
        foreach ($lv as $key => $value) {
            if ($score >= $value) {
                $level = $key;
            }
        }
        return $level;
    }

    /**
     * 根据排行信息获取用户信息
     * @param $getweek
     * @return array|bool
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function rankList($data) {
        if(!$data) return [];

        // 获取用户id
        $ids = array_keys($data);
        // 获取指定用户信息
        $where = [];
        $where["id"] = ["in",$ids];
        $userList = Db::name('user')->where($where)->select();
        $userList = list_domain_image($userList,['avatar']);
        if($userList) {
            // 用户ID作为下标
            $userIdKeyList = [];
            foreach($userList as $k => $v) {
                $userIdKeyList[$v["id"]] = $v;
            }
            // 执行等量替换
            $userrankList = [];$rank = 1;
            foreach($data as $k => $v) {
                $userrankList[] = [
                    "rank" => $rank,
                    "user_id" => $userIdKeyList[$k]["id"],
                    "avatar" => $userIdKeyList[$k]["avatar"],
                    "nickname" => $userIdKeyList[$k]["nickname"],
                    "gender" => $userIdKeyList[$k]["gender"], // 性别
                    "level" => $userIdKeyList[$k]["level"], // 积分等级
                    "jewel" => $v, // 财富数
                ];
                $rank ++;
            }
        }
        return $userrankList;
    }

    /**
     * 根据手机号查询账户信息
     * @param   string $value
     * @return string
     */
    public static function getByMobile($value,$field = "*")
    {
        if ($value) {

            $value = self::field($field)->where('mobile',$value)->find();
        }
        return $value;
    }
    /**
     * 根据openid查询账户信息
     * @param   string $value
     * @return string
     */
    public static function getByOpenid($value,$field = "*")
    {
        if ($value) {

            $value = self::field($field)->where('wechat_openid',$value)->find();
        }
        return $value;
    }
    /**
     * 根据ios_user_id查询账户信息
     * @param   string $value
     * @return string
     */
    public static function getByiosuserid($value,$field = "*")
    {
        if ($value) {

            $value = self::field($field)->where('ios_user_id',$value)->find();
        }
        return $value;
    }

    /**
     * 增加魅力等级
     */
    public static function add_charm_level($user_id,$value) {
        if($value <= 0) return false;
        // 获取用户
        $userInfo = Db::name('user')->field('id,charm_level,charm_value')->where('id',$user_id)->find();
        if(!$userInfo) return false;

        // 增加之后的经验值
        $new_value = $userInfo['charm_value'] + $value;

        // 查询等级配置信息
        $charm_level = Db::name('charm_level')->where('value','elt',$new_value)->order('value', 'desc')->value('level');

        if(empty($charm_level))  {
            $new_level = $userInfo['charm_level'];
        } else {
            $new_level = $charm_level;
        }

        // 更新用户等级信息和经验值
        $data = [
            'charm_level' => $new_level,
            'charm_value' => $new_value,
        ];
        $res = Db::name('user')->where('id',$user_id)->update($data);
    }
    /**
     * 增加财富等级
     */
    public static function add_wealth_level($user_id,$value) {
        if($value <= 0) return false;
        // 获取用户
        $userInfo = Db::name('user')->field('id,wealth_level,wealth_value')->where('id',$user_id)->find();
        if(!$userInfo) return false;

        // 增加之后的经验值
        $new_value = $userInfo['wealth_value'] + $value;

        // 查询等级配置信息
        $wealth_level = Db::name('wealth_level')->where('value','elt',$new_value)->order('value', 'desc')->value('level');

        if(!$wealth_level)  {
            $new_level = $userInfo['wealth_level'];
        } else {
            $new_level = $wealth_level;
        }

        // 更新用户等级信息和经验值
        $data = [
            'wealth_level' => $new_level,
            'wealth_value' => $new_value,
        ];
        $res = Db::name('user')->where('id',$user_id)->update($data);
    }
    //增加亲密度,顺带升级
    public static function add_intimacy($uid = 0, $other_uid = 0, $value = 0) {
        if($value <= 0) return false;
        //增加亲密度
        $level_remark = ''; //亲密度等级是否变动: 0未变动 >0是亲密度等级
        $user_intimacy_info = Db::name('user_intimacy')->where(['uid' => $uid, 'other_uid' => $other_uid])->find();
        if ($user_intimacy_info) {
            $user_intimacy_data['value'] = $user_intimacy_info['value'] + $value;

            $level = Db::name('intimacy_level')->where(['value' => ['elt', $user_intimacy_data['value']]])->order('level desc')->find();
            if ($level) {
                $user_intimacy_data['level'] = $level['level'];
                if ($level['level'] != $user_intimacy_info['level']) {
                    $level_remark = "恭喜你们亲密度达到".$level['level']."级，获得称号'".$level['name']."'";
                }
            }

            $user_intimacy_rs = Db::name('user_intimacy')->where(['uid' => $uid, 'other_uid' => $other_uid])->setField($user_intimacy_data);
        } else {
            $user_intimacy_data['uid'] = $uid;
            $user_intimacy_data['other_uid'] = $other_uid;
            $user_intimacy_data['value'] = $value;


            $level = Db::name('intimacy_level')->where(['value' => ['elt', $user_intimacy_data['value']]])->order('level desc')->find();
            if ($level) {
                $user_intimacy_data['level'] = $level['level'];
                $level_remark = "恭喜你们亲密度达到".$level['level']."级，获得称号'".$level['name']."'";
            }

            $user_intimacy_rs = Db::name('user_intimacy')->insertGetId($user_intimacy_data);
        }

        return ['status' => $user_intimacy_rs, 'level_remark' => $level_remark];
    }




}