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")->find(); if (!empty($userexplainstart)) { if ($userexplainstart['level'] != $user['level']) { $userUpdate['level'] = $userexplainstart['level']; } } $res = $user->update($userUpdate,$userWhere); if($res === false){ Db::rollback(); $this->error('经验更新失败'); } //第七天赠送礼物 $gift = []; if ($data['times'] == 7) { $userSignGift = model('UserSignGift')->with(['gift'])->find(); if (!empty($userSignGift)) { $giftData = isset($userSignGift['gift']) ? $userSignGift['gift'] : []; if (!empty($giftData)) { $gift = [ 'image' => $giftData['image'], 'num' => $userSignGift['num'], ]; } } } //系统消息 $msg_id = \app\common\model\Message::addMessage($this->auth->id,'签到奖励','签到成功,获得金币奖励'); Db::commit(); $result = [ 'image' => isset($gift['image']) ? $gift['image'] : '', 'num' => isset($gift['num']) ? $gift['num'] : $data['goldnum'], ]; $this->success('签到成功', $result); } //第七天赠送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; } }