ucoin/app/models/user/UserSign.php

<?php

namespace app\models\user;

use crmeb\basic\BaseModel;
use crmeb\services\SystemConfigService;
use crmeb\traits\ModelTrait;

/**
 * TODO  用户签到模型 Model
 * Class UserSign
 * @package app\models\user
 */
class UserSign extends BaseModel
{
    /**
     * 数据表主键
     * @var string
     */
    protected $pk = 'id';

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

    use ModelTrait;

    /**
     * 设置签到数据
     * @param $uid 用户uid
     * @param string $title 签到说明
     * @param int $number 签到获得积分
     * @param int $balance 签到前剩余积分
     * @return bool
     */
    public static function setSignData($uid, $title = '', $number = 0, $balance = 0)
    {
        $add_time = time();
        return self::create(compact('uid', 'title', 'number', 'balance', 'add_time')) && UserBill::income($title, $uid, 'integral', 'sign', $number, 0, $balance, $title);
    }

    /**
     * 分页获取用户签到数据
     * @param $uid 用户uid
     * @param $page 页码
     * @param $limit 展示条数
     * @return array|\think\Collection
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getSignList($uid, $page, $limit)
    {
        if (!$limit) return [];
        $billModel = UserBill::where('a.category', 'integral')->where('a.type', 'sign')
            ->where('a.status', 1)->where('a.uid', $uid)->alias('a')
            ->join("user u", 'u.uid=a.uid')
            ->order('a.add_time desc')->field('FROM_UNIXTIME(a.add_time,"%Y-%m-%d") as add_time,a.title,a.number');
        if ($page) $billModel = $billModel->page((int)$page, (int)$limit);
        return $billModel->select();
    }

    /**
     * 获取用户累计签到次数
     * @param $uid
     * @return int
     */
    public static function getSignSumDay($uid)
    {
        return self::where('uid', $uid)->count();
    }

    /**
     * 获取用户是否签到
     * @param $uid
     * @return bool
     */
    public static function getIsSign($uid, string $type = 'today')
    {
        return self::where('uid', $uid)->whereTime('add_time', $type)->count() ? true : false;
    }

    /**
     * 获取签到配置
     * @param string $key
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getSignSystemList($key = 'sign_day_num')
    {
        return sys_data($key) ?: [];
    }

    /**
     * 用户签到
     * @param $uid
     * @return bool|int
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function sign($uid)
    {
        $sign_list = self::getSignSystemList();
        if (!count($sign_list)) return self::setErrorInfo('请先配置签到天数');
        $user = User::where('uid', $uid)->find();
        $sign_num = 0;
        //检测昨天是否签到
        if (self::getIsSign($uid, 'yesterday')) {
            if ($user->sign_num > (count($sign_list) - 1)) $user->sign_num = 0;
        } else {
            //如果昨天没签到,回退到第一天
            $user->sign_num = 0;
        }
        foreach ($sign_list as $key => $item) {
            if ($key == $user->sign_num) {
                $sign_num = $item['sign_num'];
                break;
            }
        }
        $user->sign_num += 1;
        if ($user->sign_num == count($sign_list))
            $res1 = self::setSignData($uid, '连续签到奖励', $sign_num, bcadd($user->integral, $sign_num, 0));
        else
            $res1 = self::setSignData($uid, '签到奖励', $sign_num, bcadd($user->integral, $sign_num, 0));
        $res2 = User::bcInc($uid, 'integral', $sign_num, 'uid');
        $res3 = $user->save();
        $res = $res1 && $res2 && $res3 !== false;
        BaseModel::checkTrans($res);
        event('UserLevelAfter', [$user]);
        if ($res)
            return $sign_num;
        else
            return false;
    }

    /*
     * 获取签到列表按月加载
     * @param int $uid 用户uid
     * @param int $page 页码
     * @param int $limit 显示多少条
     * @return array
     * */
    public static function getSignMonthList($uid, $page = 1, $limit = 8)
    {
        if (!$limit) return [];
        if ($page) {
            $list = UserBill::where('uid', $uid)
                ->where('category', 'integral')
                ->where('type', 'sign')
                ->field('FROM_UNIXTIME(add_time,"%Y-%m") as time,group_concat(id SEPARATOR ",") ids')
                ->group('time')
                ->order('time DESC')
                ->page($page, $limit)
                ->select();
        } else {
            $list = UserBill::where('uid', $uid)
                ->where('category', 'integral')
                ->where('type', 'sign')
                ->field('FROM_UNIXTIME(add_time,"%Y-%m") as time,group_concat(id SEPARATOR ",") ids')
                ->group('time')
                ->order('time DESC')
                ->select();
        }
        $data = [];
        foreach ($list as $key => &$item) {
            $value['month'] = $item['time'];
            $value['list'] = UserBill::where('id', 'in', $item['ids'])->field('FROM_UNIXTIME(add_time,"%Y-%m-%d") as add_time,title,number')->order('add_time DESC')->select();
            array_push($data, $value);
        }
        return $data;
    }

    public static function checkUserSigned($uid)
    {
        return UserBill::be(['uid' => $uid, 'add_time' => ['>', strtotime('today')], 'category' => 'integral', 'type' => 'sign']);
    }

    public static function userSignedCount($uid)
    {
        return self::userSignBillWhere($uid)->count();
    }

    /**
     * @param $uid
     * @return UserBill
     */
    public static function userSignBillWhere($uid)
    {
        return UserBill::where('uid', $uid)->where('category', 'integral')->where('type', 'sign');
    }

    public static function signEbApi($userInfo)
    {
        $uid = $userInfo['uid'];
        $min = sys_config('sx_sign_min_int') ?: 0;
        $max = sys_config('sx_sign_max_int') ?: 5;
        $integral = rand($min, $max);
        BaseModel::beginTrans();
        $res1 = UserBill::income('用户签到', $uid, 'integral', 'sign', $integral, 0, $userInfo['integral'], '签到获得' . floatval($integral) . '积分');
        $res2 = User::bcInc($uid, 'integral', $integral, 'uid');
        $res = $res1 && $res2;
        BaseModel::checkTrans($res);
        if ($res)
            return $integral;
        else
            return false;
    }
}