这篇文章主要介绍了thinkphp实现签到功能的方法,实例分析了mysql数据表的构造及thinkphp签到功能的具体实现技巧,需要的朋友可以参考下
本文实例讲述了thinkPHP实现签到功能的方法。分享给大家供大家参考，具体如下：
数据表：
CREATE TABLE `members_sign` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `uid` int(11) unsigned NOT NULL COMMENT '用户id', `days` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '连续签到的天数', `is_share` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否分享过', `is_sign` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否签到过', `stime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '签到的时间', `atime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间', PRIMARY KEY (`id`), KEY `index_uid` (`uid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8 COMMENT='签到分享表';
Controller：
立即学习“PHP免费学习笔记（深入）”；
getMonthSign();
$dayList = $this->showDays($monthSign);
// 今天签到
$data = $this->todayData();
if($data['is_sign'] == 1){
$this->assign('isSign',true);
}
$this->display();
}
/**
* 执行当天签到
* @return json 签到成功返回 {status:1,info:'已签到'}
*/
public function sign(){
$todayData = $this->todayData();
if($todayData['is_sign'] == 1){
$this->successMsg('已签到');
}else{
$data = $this->getInsertData($this->uid);
// 无今天数据
if($todayData == NULL){
$data['uid'] = $this->uid;
$data['atime'] = time();
$id = M('members_sign')->add($data);
}else{
$save = M('members_sign')->where("id = {$todayData['id']}")->save($data);
}
if($id or $save){
$score = $this->getTodayScores($data['days']);
// 为该用户添加积分
addScore($this->uid,$score);
$this->successMsg('已签到',array('score' => $score,'days'=>$data['days']));
}else{
$this->errorMsg('签到失败，请刷新后重试！');
}
}
}
/**
* 返回每次签到要插入的数据
*
* @param int $uid 用户id
* @return array(
* 'days' => '天数',
* 'is_sign' => '是否签到,用1表示已经签到',
* 'stime' => '签到时间',
* );
*/
protected function getInsertData($uid){
// 昨天的连续签到天数
$start_time = strtotime(date('Y-m-d 0:0:0',time()-86400))-1;
$end_time = strtotime(date('Y-m-d 23:59:59',time()-86400))+1;
$days = M('members_sign')->where("uid = $uid and atime > $start_time and atime < $end_time")->getField('days');
if($days){
$days++;
if($days > 30){
$days = 1;
}
}else{
$days = 1;
}
return array(
'days' => $days,
'is_sign' => 1,
'stime' => time()
);
}
/**
* 用户当天签到的数据
* @return array 签到信息 is_sign,stime 等
*/
protected function todayData(){
$time = time();
$start_stime = strtotime(date('Y-m-d 0:0:0',$time))-1;
$end_stime = strtotime(date('Y-m-d 23:59:59',$time))+1;
return M('members_sign')->field('atime',true)->where("uid = {$this->uid} and atime > $start_stime and atime < $end_stime")->find();
}
/**
* 积分规则，返回连续签到的天数对应的积分
*
* @param int $days 当天应该得的分数
* @return int 积分
*/
protected function getTodayScores($days){
if($days == 30){
return 50;
}else if($days > 19){
return 8;
}else if($days > 9){
return 5;
}else{
return 3;
}
}
/**
* 显示签到列表
*
* @param array $signDays 某月签到的日期 array(1,2,3,4,5,12,13)
* @param int $year 可选，年份
* @param int $month 可选，月份
* @return string 日期列表相关推荐：
