ThinkPHP5 签到功能

<?php

  //签到主页面
    public function sign_index(){
        // 日历列表

        $monthSign = $this->getMonthSign();

        $dayList = $this->showDays($monthSign);

        // 今天签到

        $data = $this->todayData();

        if(empty($data)){
            $data['is_sign'] =0;
            $data['status']=10002;
            $data['msg']="今天未签到";
        }else{
            $data['status']=10001;
            $data['msg']="今天已经签到";
        }

        $this->return_data($data);

    }




    /**
     * 执行当天签到   也就是点击签到调用的接口
     * @return json 签到成功返回 {status:1,info:'已签到'}
     */

    public function sign(){

        $todayData = $this->todayData();

        if($todayData['is_sign'] == 1){

            $this->return_data('已签到');

        }else{

            $data = $this->getInsertData($this->user_id);

            // 无今天数据

            if($todayData == NULL){

                $data['uid'] = $this->user_id;

                $data['atime'] = time();

                $id = Db::name('members_sign')->insertGetId($data);

            }else{
                $save = Db::name('members_sign')->where("id = {$todayData['id']}")->update($data);

            }

            if($id or $save){

                //积分数
                $score = $this->getTodayScores($data['days']);

                // 为该用户添加积分

//                addScore($this->user_id,$score);
                $res['status'] = 10001;
                $res['msg'] ="签到成功！";
                $res['score']=$score;
                $res['days']=$data['days'];

                $this->return_data($res);

            }else{
                $res['status'] = 10002;
                $res['msg'] ="签到失败，请刷新后重试！";
                $this->return_data($res);

            }

        }

    }

    /**

     * 返回每次签到要插入的数据

     *

     * @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 = Db::name('members_sign')->where("uid = $uid and atime > $start_time and atime < $end_time")->value('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 Db::name('members_sign')->field('atime',true)->where("uid = {$this->user_id} 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('Y',$time);

        $month = $month ? $month : date('m',$time);

        $daysTotal = date('t', mktime(0, 0, 0, $month, 1, $year));

        $now = date('Y-m-d',$time);

        $str = '';
//        dump($daysTotal);
//exit;
        for ($j = 1; $j <= $daysTotal; $j++) {

            $i++;

            $someDay = date('Y-m-d',strtotime("$year-$month-$j"));
//            dump($someDay);exit;

            // 小于今天的日期样式

            if ($someDay <= $now){

                // 当天日期样式 tdc = todayColor

                if($someDay == $now){

                    // 当天签到过的

                    if(in_array($j,$signDays)){

                        $str .= '<li class="current fw tdc">'.$j.'</li>';

                    }else{

                        $str .= '<li class="today fw tdc">'.$j.'</li>';

                    }

                }else{

                    // 签到过的日期样式 current bfc = beforeColor , fw = font-weight

                    if(in_array($j,$signDays)){

                        $str .= '<li class="current fw bfc">'.$j.'</li>';

                    }else{

                        $str .= '<li class="fw bfc">'.$j.'</li>';

                    }

                }

            }else{

                $str .= '<li>'.$j.'</li>';

            }

        }
//        dump($str);exit;

        return $str;

    }

    /**

     * 获取当月签到的天数，与 $this->showDays() 配合使用

     * @return 当月签到日期 array(1,2,3,4,5,12,13)

     */

    protected function getMonthSign(){

        $time  = time();

        $year  = date('Y',$time);

        $month = date('m',$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 = Db::name('members_sign')->field('stime')->where("uid = {$this->user_id} and stime > $start_stime and stime < $end_stime")->order('stime asc')->select();
//        dump($list);
//        exit;
        foreach($list as $key => $value){
//            dump($value);exit;
            $list[$key] = date("d",$value["stime"]);

        }
//        dump($list);exit;

        return $list;

    }

mysql数据库

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