gganli/application/api/controller/Usersign.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use think\Db;

/**
 * 签到
 */
class Usersign extends Api
{
    protected $noNeedLogin = [];
    protected $noNeedRight = ['*'];

    /**
     * 配置
     */
    public function config()
    {
        $list = Db::name('signin')->order('id asc')->select();
        //连续签到次数
        $user_sign = Db::name('user_sign')->where(['uid' => $this->auth->id])->order('id desc')->find();
        $yesterday_time = strtotime('yesterday'); //昨天0点时间戳
        $today_time = $yesterday_time + 86400; //今日0点时间戳
        if ($user_sign) {
            if ($user_sign['createtime'] >= $yesterday_time) {
                $data['sign_times'] = $user_sign['times']; //连续签到天数
            } else {
                $data['sign_times'] = 0;
            }
            if ($user_sign['createtime'] >= $today_time) {
                $data['is_sign'] = 1; //今日是否签到: 1已签到 0未签到
            } else {
                $data['is_sign'] = 0; //今日是否签到: 1已签到 0未签到
            }

        } else {
            $data['sign_times'] = 0; //连续签到天数
            $data['is_sign'] = 0; //今日是否签到: 1已签到 0未签到
        }

        $data['sign_round_times'] = $data['sign_times'] % 7;

        $data['list'] = $list;

        $this->success('success',$data);
    }

    //签到
    public function signin(){
        $uid = $this->auth->id;

        //记录日志
        $data = [
            'uid' => $uid,
            'times' => 1,
            'goldnum' => 0,
            'createtime' => time(),
        ];

        $yesterday_time = strtotime('yesterday'); //昨天0点时间戳
        $today_time = $yesterday_time + 86400; //今日0点时间戳
        //修正当前次数
        $check = Db::name('user_sign')->where('uid',$uid)->order('id desc')->find();
        if($check){
            //今天只能签一次
            if($check['createtime'] >= $today_time){
                $this->error('今天已经签过了');
            }
            if ($check['createtime'] >= $yesterday_time) {
                $data['times'] = $check['times'] + 1; //连续签到次数
            }
        }

        $signin_id = $data['times'] % 7;
        if ($signin_id == 0) {
            $signin_id = 7;
        }

        //匹配对应金币数
        $list = Db::name('signin')->order('id asc')->column('id,goldnum');
        $data['goldnum'] = isset($list[$signin_id]) ? $list[$signin_id] : 0 ;
        Db::startTrans();
        //记录日志
        $log_id = Db::name('user_sign')->insertGetId($data);
        if(!$log_id){
            Db::rollback();
            $this->error('签到失败');
        }

        //加经验
        $userWhere['id'] = $uid;
        $user = model('User')->where($userWhere)->lock(true)->find();
        $userNewEmpirical = $user['empirical'] + $data['goldnum'];
        $userUpdate['empirical'] = $userNewEmpirical;
        // 获取用户当前经验值对应等级
        $userconfigModel = new \app\common\model\UserLevelConfig();
        $where = [];
        $where["empirical"] = ["elt",$userNewEmpirical];
        $userexplainstart = $userconfigModel->where($where)->order("empirical","desc")->limit(1)->select();
        if (!empty($userexplainstart)) {
            if ($userexplainstart['level'] != $user['level']) {
                $userUpdate['level'] = $userexplainstart['level'];
            }
        }
        $res = model('User')->where($userWhere)->lock(true)->update();
        if($res === false){
            Db::rollback();
            $this->error('经验更新失败');
        }

        /*//第七天赠送vip
        $vip_rs = false;
        $user_sign_gift_vipdays = intval(config('site.user_sign_gift_vipdays'));
        if($data['times'] == 7 && $user_sign_gift_vipdays > 0){

            $vip_rs = $this->gift_vip($user_sign_gift_vipdays);
        }*/

        //系统消息
        $msg_id = \app\common\model\Message::addMessage($this->auth->id,'签到奖励','签到成功，获得金币奖励');

        Db::commit();
//        $remark = '获得金币'.$data['goldnum'];
        /*if($vip_rs){
            $remark .= ',vip'.$user_sign_gift_vipdays.'天';
        }*/
        $this->success('签到成功', $data['goldnum']);
    }

    //第七天赠送vip
    //找出最近七天的次数
    private function gift_vip($user_sign_gift_vipdays){
        $start = strtotime(date('Y-m-d')) - 518400;
        $map = [
            'uid' => $this->auth->id,
            'createtime' => ['gt',$start],
        ];
        $count = Db::name('user_sign')->where($map)->count();

        if($count >= 7){
            //赠送vip三天
            $add_time = 86400 * $user_sign_gift_vipdays;

            //有vip的续费，没有的从现在开始
            $vip_endtime = model('wallet')->getWallet($this->auth->id,'vip_endtime');
            if($vip_endtime <= time()){
                $new_vip_endtime = time() + $add_time;
            }else{
                $new_vip_endtime = $vip_endtime + $add_time;
            }
            $rs = Db::name('user_wallet')->where('user_id',$this->auth->id)->update(['vip_endtime'=>$new_vip_endtime]);

            if($rs === false){
                Db::rollback();
                $this->error('连续签到赠送vip失败');
            }
            return true;
        }
        return false;
    }
}