happ/app/models/system/SystemUserLevel.php

<?php


namespace app\models\system;

use app\models\user\UserLevel;
use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;
use think\db\exception\DataNotFoundException;
use think\db\exception\DbException;
use think\db\exception\ModelNotFoundException;

/**
 * TODO 设置会员等级Model
 * Class SystemUserLevel
 * @package app\models\system
 */
class SystemUserLevel extends BaseModel
{
    /**
     * 数据表主键
     * @var string
     */
    protected $pk = 'id';

    /**
     * 模型名称
     * @var string
     */
    protected $name = 'system_user_level';

    use ModelTrait;

    public static function getAddTimeAttr($value)
    {
        return date('Y-m-d H:i:s', $value);
    }

    public static function getDiscountAttr($value)
    {
        return (int)$value;
    }

    /*
     * 获取查询条件
     * @param string $alert 别名
     * @param object $model 模型
     * @return object
     * */
    public static function setWhere($alert = '', $model = null)
    {
        $model = $model === null ? new self() : $model;
        if ($alert) $model = $model->alias($alert);
        $alert = $alert ? $alert . '.' : '';
        return $model->where("{$alert}is_show", 1)->where("{$alert}is_del", 0);
    }

    /*
     * 获取某个等级的折扣
     * */
    public static function getLevelDiscount($id = 0)
    {
        $model = self::setWhere();
        if ($id) $model = $model->where('id', $id);
        else $model = $model->order('grade asc');
        return $model->value('discount');
    }


    /**
     * 获取用户等级和当前等级
     * @param $uid 用户uid
     * @param bool $isArray 是否查找任务列表
     * @return array|bool|mixed|string|\think\Model|null
     * @throws DataNotFoundException
     * @throws ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getLevelInfo($uid, $isArray = false)
    {
        $level = ['id' => 0];
        $task = [];
        $id = UserLevel::getUserLevel($uid);
        if ($id !== false) $level = UserLevel::getUserLevelInfo($id);
        $list = self::getLevelListAndGrade($level['id'], $isArray);
        if (isset($list[0]) && $isArray) $task = SystemUserTask::getTashList($list[0]['id'], $uid, $level);
        if ($isArray) return [$list, $task];
        else return $level['id'] && $id !== false ? $level : false;
    }

    /**
     * 获取会员等级级别
     * @param $leval_id 等级id
     * @return mixed
     */
    public static function getLevelGrade($leval_id)
    {
        return self::setWhere()->where('id', $leval_id)->value('grade');
    }

    /**
     * 获取会员等级列表
     * @param int $leval_id 用户等级
     * @param bool $isArray 是否查找任务列表
     * @param string $order
     * @return array|\think\Collection
     * @throws DataNotFoundException
     * @throws ModelNotFoundException
     * @throws DbException
     */
    public static function getLevelListAndGrade($leval_id, $isArray, $order = 'grade asc')
    {
        $grade = 0;
        if (!$leval_id && !$isArray) $leval_id = self::setWhere()->where('grade', self::setWhere()->min('grade'))->order('add_time DESC')->value('id');
        $list = self::setWhere()->field('name,discount,image,icon,explain,id,grade')->order($order)->select();
        $list = count($list) ? $list->toArray() : [];
        foreach ($list as &$item) {
            if ($item['id'] == $leval_id)
                $grade = $item['grade'];

            if ($isArray)
                $item['task_list'] = SystemUserTask::getTashList($item['id']);
        }
        foreach ($list as &$item) {
            if ($grade < $item['grade'])
                $item['is_clear'] = true;
            else
                $item['is_clear'] = false;
        }
        return $list;
    }

    /**
     *
     * @param $leval_id
     * @param null $list
     * @return bool
     */
    public static function getClear($leval_id, $list = null)
    {
        $list = $list === null ? self::getLevelListAndGrade($leval_id, false) : $list;
        foreach ($list as $item) {
            if ($item['id'] == $leval_id) return $item['is_clear'];
        }
        return false;
    }


    /**
     * 获取当前vipid 的下一个会员id
     * @param int $leval_id 当前用户的会员id
     * @param $max
     * @return int
     * @throws DataNotFoundException
     * @throws ModelNotFoundException
     * @throws DbException
     */
    public static function getNextLevelId($leval_id, $max)
    {
        $list = self::getLevelListAndGrade($leval_id, false, 'grade desc');
        $grade = 0;
        $leveal = [];
        foreach ($list as $item) {
            if ($item['id'] == $leval_id) $grade = $item['grade'];
        }
        foreach ($list as $item) {
            if ($grade < $item['grade'] && $item['grade'] <= $max) array_push($leveal, $item['id']);
        }
        return isset($leveal[0]) ? $leveal[0] : 0;
    }

    /**
     * 获取会员等级列表
     * @param $uid
     * @return array
     */
    public static function getLevelList($uid)
    {
        list($list, $task) = self::getLevelInfo($uid, true);
        return ['list' => $list, 'task' => $task];
    }


}