$day = date('d')-1;
for($i=1;$i<=$day;$i++){
$arr[] = $i;
}
$startday = date('Y-m-d').' 00:00:00';
$endday = date('Y-m-d').' 23:59:59';
//当天是否签到
$data = $db->fetchOne('select count(*) from {{qiandao}} where userid = :userid and date > :startday and date < :endday and type = 0',array(':userid'=>$row['id'],':startday'=>$startday,':endday'=>$endday));
$sday = date('Y-m-'.'01').' 00:00:00';
$eday = date('Y-m-'.(date('d')-1)).' 23:59:59';
//月初到现在签到到的日期
$days = $db->fetchAll('select day from {{qiandao}} where userid = :userid and date > :startday and date < :endday and type = 0',array(':userid'=>$row['id'],':startday'=>$sday,':endday'=>$eday));
if($days){
foreach($days as $k=>$v){
$ids[] = $v['day'];
}
$c = array_merge(array_diff($arr,$ids),array_diff($ids,$arr));
sort($c);
//最后一次签到的日期
$riqi = array_pop($c);
$t = $day - $riqi+1;
}else{
$t = 0+1;
}
for($i=1;$i<=$day;$i++){
$arr[] = $i;
}
$startday = date('Y-m-d').' 00:00:00';
$endday = date('Y-m-d').' 23:59:59';
//当天是否签到
$data = $db->fetchOne('select count(*) from {{qiandao}} where userid = :userid and date > :startday and date < :endday and type = 0',array(':userid'=>$row['id'],':startday'=>$startday,':endday'=>$endday));
$sday = date('Y-m-'.'01').' 00:00:00';
$eday = date('Y-m-'.(date('d')-1)).' 23:59:59';
//月初到现在签到到的日期
$days = $db->fetchAll('select day from {{qiandao}} where userid = :userid and date > :startday and date < :endday and type = 0',array(':userid'=>$row['id'],':startday'=>$sday,':endday'=>$eday));
if($days){
foreach($days as $k=>$v){
$ids[] = $v['day'];
}
$c = array_merge(array_diff($arr,$ids),array_diff($ids,$arr));
sort($c);
//最后一次签到的日期
$riqi = array_pop($c);
$t = $day - $riqi+1;
}else{
$t = 0+1;
}