PHP实现签到功能的方法

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='签到分享表';

<?php
namespace Member\Controller;
use Member\Controller\MController;
class IndexController extends MController {
  /**
  * 用户中心
  * @param
  */
  public function index(){
    $pre = C(&#39;DB_PREFIX&#39;);
        // 日历列表
    $monthSign = $this->getMonthSign();
    $dayList = $this->showDays($monthSign);
    // 今天签到
    $data = $this->todayData();
    if($data[&#39;is_sign&#39;] == 1){
      $this->assign(&#39;isSign&#39;,true);
    }
    $this->display();
  }
  /**
  * 执行当天签到
  * @return json 签到成功返回 {status:1,info:&#39;已签到&#39;}
  */
  public function sign(){
    $todayData = $this->todayData();
    if($todayData[&#39;is_sign&#39;] == 1){
      $this->successMsg(&#39;已签到&#39;);
    }else{
      $data = $this->getInsertData($this->uid);
      // 无今天数据
      if($todayData == NULL){
        $data[&#39;uid&#39;] = $this->uid;
        $data[&#39;atime&#39;] = time();
        $id = M(&#39;members_sign&#39;)->add($data);
      }else{
        $save = M(&#39;members_sign&#39;)->where("id = {$todayData[&#39;id&#39;]}")->save($data);
      }
      if($id or $save){
        $score = $this->getTodayScores($data[&#39;days&#39;]);
        // 为该用户添加积分
        addScore($this->uid,$score);
        $this->successMsg(&#39;已签到&#39;,array(&#39;score&#39; => $score,&#39;days&#39;=>$data[&#39;days&#39;]));
      }else{
        $this->errorMsg(&#39;签到失败，请刷新后重试！&#39;);
      }
    }
  }
  /**
  * 返回每次签到要插入的数据
  *
  * @param int $uid 用户id
  * @return array(
  *  &#39;days&#39;   =>  &#39;天数&#39;,
  *  &#39;is_sign&#39;  =>  &#39;是否签到,用1表示已经签到&#39;,
  *  &#39;stime&#39;   =>  &#39;签到时间&#39;,
  * );
  */
  protected function getInsertData($uid){
    // 昨天的连续签到天数
    $start_time = strtotime(date(&#39;Y-m-d 0:0:0&#39;,time()-86400))-1;
    $end_time  = strtotime(date(&#39;Y-m-d 23:59:59&#39;,time()-86400))+1;
    $days = M(&#39;members_sign&#39;)->where("uid = $uid and atime > $start_time and atime < $end_time")->getField(&#39;days&#39;);
    if($days){
      $days++;
      if($days > 30){
        $days = 1;
      }
    }else{
      $days = 1;
    }
    return array(
      &#39;days&#39;    => $days,
      &#39;is_sign&#39;  => 1,
      &#39;stime&#39;   => time()
    );
  }
  /**
  * 用户当天签到的数据
  * @return array 签到信息 is_sign,stime 等
  */
  protected function todayData(){
    $time = time();
    $start_stime  = strtotime(date(&#39;Y-m-d 0:0:0&#39;,$time))-1;
    $end_stime = strtotime(date(&#39;Y-m-d 23:59:59&#39;,$time))+1;
    return M(&#39;members_sign&#39;)->field(&#39;atime&#39;,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 日期列表<li>1</li>....
  */
  protected function showDays($signDays,$year,$month){
    $time = time();
    $year = $year ? $year : date(&#39;Y&#39;,$time);
    $month = $month ? $month : date(&#39;m&#39;,$time);
    $daysTotal = date(&#39;t&#39;, mktime(0, 0, 0, $month, 1, $year));
    $now = date(&#39;Y-m-d&#39;,$time);
    $str = &#39;&#39;;
    for ($j = 1; $j <= $daysTotal; $j++) {
      $i++;
      $someDay = date(&#39;Y-m-d&#39;,strtotime("$year-$month-$j"));
      // 小于今天的日期样式
      if ($someDay <= $now){
        // 当天日期样式 tdc = todayColor
        if($someDay == $now){
          // 当天签到过的
          if(in_array($j,$signDays)){
            $str .= &#39;<li class="current fw tdc">&#39;.$j.&#39;</li>&#39;;
          }else{
            $str .= &#39;<li class="today fw tdc">&#39;.$j.&#39;</li>&#39;;
          }
        }else{
          // 签到过的日期样式 current bfc = beforeColor , fw = font-weight
          if(in_array($j,$signDays)){
            $str .= &#39;<li class="current fw bfc">&#39;.$j.&#39;</li>&#39;;
          }else{
            $str .= &#39;<li class="fw bfc">&#39;.$j.&#39;</li>&#39;;
          }
        }
      }else{
        $str .= &#39;<li>&#39;.$j.&#39;</li>&#39;;
      }
    }
    return $str;
  }
  /**
  * 获取当月签到的天数，与 $this->showDays() 配合使用
  * @return 当月签到日期 array(1,2,3,4,5,12,13)
  */
  protected function getMonthSign(){
    $time  = time();
    $year  = date(&#39;Y&#39;,$time);
    $month = date(&#39;m&#39;,$time);
    $day  = date("t",strtotime("$year-$month"));
    $start_stime  = strtotime("$year-$month-1 0:0:0")-1;
    $end_stime = strtotime("$year-$month-$day 23:59:59")+1;
    $list = M(&#39;members_sign&#39;)->where("uid = {$this->uid} and stime > $start_stime and stime < $end_stime")->order(&#39;stime asc&#39;)->getField(&#39;stime&#39;,true);
    foreach ($list as $key => $value){
      $list[$key] = date(&#39;j&#39;,$value);
    }
    return $list;
  }
}