PHP 实现签到功能

如图所示：

实现上图功能，创建两张表：签到奖品表、签到记录表（这个表可以再拆分出一个表）

    /**
    *功能：计算两个时间戳之间相差的日时分秒
    *$begin_time  开始时间戳
    *$end_time    结束时间戳
    */ 
    public function timediff($begin_time,$end_time){
        if($begin_time < $end_time){
            $starttime = $begin_time;
            $endtime = $end_time;
        }else{
            $starttime = $end_time;
            $endtime = $begin_time;
        }

        //计算天数
        $timediff = $endtime-$starttime;
        $days = intval($timediff/86400);
        //计算小时数
        $remain = $timediff%86400;
        $hours  = intval($remain/3600);
        //计算分钟数
        $remain = $remain%3600;
        $mins = intval($remain/60);
        //计算秒数
        $secs = $remain%60;
        $res  = array("day" => $days,"hour" => $hours,"min" => $mins,"sec" => $secs);
        return $res;
    }

    //黄梅--签到列表  20171206 by csj
    public function signList(){
        $user_id = I("param.user_id","635747","trim");

        if (!($user_id)) {
            $r['message'] = '缺少参数';
            GResult::getInstance()->echoErroAndMessage($r);exit();
        }
        $list = D('loginrewards')->field('id,day,reward,icon,type,name,des')->select();
        $isOk = D('sign')->where("user_id={$user_id}")->order('id desc')->find();

        $last_time   = strtotime($isOk['s_time']);//最后一次签到时间

        $t = time();
        // $start = mktime(0,0,0,date("m",$t),date("d",$t),date("Y",$t));
        $end = mktime(23,59,59,date("m",$t),date("d",$t),date("Y",$t));//当天时间的最后1刻 (注意)

        $current_day = $end;//当天时间的最后1刻

        $timeIs = $this->timediff($last_time,$current_day);//时间差

        if (!empty($isOk)) {
            foreach ($list as $key => $value) {
                //判断是否漏签    
                if ($timeIs['day']>1) {// 漏签
                    if ($value['day']==1) {
                        $list[$key]['is_sign'] = 1;//仅第一天的可以签 即首次签到
                    }else{
                        $list[$key]['is_sign'] = 2;//不可以签
                    }
                }else{// 未漏签
                    if ($isOk['s_number']==7) {//签满7天后
                        if ($timeIs['day']==1) {//今天没签
                            if ($value['day']==1) {
                                $is_sign = 1;//仅第一天的可以签 即首次签到
                            }else{
                                $is_sign = 2;//不可以签
                            }
                        }elseif ($timeIs['day']==0) {//今天签过
                            $is_sign = 3;//已签到过
                        }

                    }else{//未签满7天，如1-6天之间
                    
                        if ($timeIs['day']==1) {//今天没签
                            if ($value['day']==$isOk['s_number']+1) {
                                $is_sign = 1;//可以签
                            }elseif($value['day']<=$isOk['s_number']){
                                $is_sign = 3;//已签到过
                            }else{
                                $is_sign = 2;//不可以签
                            }
                        }elseif ($timeIs['day']==0) {//今天签过
                            
                            if($value['day']<=$isOk['s_number']){
                                $is_sign = 3;//已签到过
                            }else{
                                $is_sign = 2;//不可以签
                            }
                        }
                    }
                    $list[$key]['is_sign'] = $is_sign;
                }
            }
        }else{//首次签到
            foreach ($list as $k => $v) {
                if ($v['day']==1) {
                    $list[$k]['is_sign'] = 1;//仅第一天的可以签 即首次签到
                }else{
                    $list[$k]['is_sign'] = 2;//不可以签
                }
            }
        }
        $re['data']    = $list;
        $re['message'] = '请求成功';
        GResult::getInstance()->echoOkAndResult($re);
    }

参考：https://www.cnblogs.com/gaoxiaoniu/p/5870394.html