where("placeid = '$placeid'")->order("starttime asc")->select(); //debug($place_time); $timeobj=array(); foreach($place_time as $v){ $timeobj[$v['id']]=$v; } //debug($timeobj); $statusarr1=table_fields_options("place_sign_status","status1"); $statusarr2=table_fields_options("place_sign_status","status2"); $place_sign_status=M("place_sign_status")->where("placeid = '$placeid' and date >= '$startdate' and date <='$enddate' and usertype = '$usertype' and userid = '$userid'")->select(); //debug($place_sign_status); $nowdate=date("Y-m-d"); $nowtime=date("H:i:s"); $statusobj=array(); foreach($place_sign_status as $k => $v){ if(trim($v['manager_status1'])!="")$place_sign_status[$k]['status1']=$v['manager_status1']; if(trim($v['manager_status2'])!="")$place_sign_status[$k]['status2']=$v['manager_status2']; $status_name1=$statusarr1[$place_sign_status[$k]['status1']]?$statusarr1[$place_sign_status[$k]['status1']]:""; $status_name2=$statusarr2[$place_sign_status[$k]['status2']]?$statusarr2[$place_sign_status[$k]['status2']]:"未签到"; $t=$timeobj[$v['timeid']]; //debug($t); $place_sign_status[$k]['status_name1']=$status_name1; $place_sign_status[$k]['status_name2']=$status_name2; if(!empty($v['time1']))$place_sign_status[$k]['time1']=date("H:i",strtotime($v['time1'])); if(!empty($v['time2']))$place_sign_status[$k]['time2']=date("H:i",strtotime($v['time2'])); $statusobj[$v['date']][$v['timeid']]=$place_sign_status[$k]; } //debug($statusobj); $pagenum=intval(GP('pagenum')); $pagenum=empty($pagenum)?30:$pagenum; $colorarr=array("Green",'Blue','Red','Red','#999'); ?>
{$title}（双击可以修改状态）
{$title2}
一页显示条
subPageCss3(); $starti=($current_page-1)*$each_disNums; for($i=$starti;$i<$days;$i++){ if($i>=$starti+$each_disNums){ break; } $date=date('Y-m-d', strtotime($startdate)+(86400*$i)); $statusarr=$statusobj[$date]; ?> =strtotime($t['startdate'])&&strtotime($nowdate)<=strtotime($t['enddate'])){ $status_name1=$status_name2=""; if(strtotime($nowdate)>strtotime($date)){ $status_name1=$status_name2="未签到"; } if(strtotime($nowtime)>strtotime($t['starttime'])){ $status_name1="未签到"; } if(strtotime($nowtime)>strtotime($t['endtime'])){ $status_name2="未签到"; } } else{ $status_name1=$status_name2=""; } */ ?>
选择 日期 姓名
{$date} {$userinfo.realname} {$status_name1} {$status_name2}