crmeb_shop/crmeb/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 \crmeb\services\GroupDataService::getData($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,$user->integral);
        else
            $res1 = self::setSignData($uid,'签到奖励',$sign_num,$user->integral);
        $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 = SystemConfigService::get('sx_sign_min_int')?:0;
        $max = SystemConfigService::get('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;
    }
}