#ClassSectionTotalPresentAbsentLeaveUser";
$cnt=1;$total=$tboys=$tgirls=0;$preClass="";$duesTotal=$totalPresent=$totalAbsent=$totalLeave=0;
while( odbc_fetch_row( $cur ) ) {
echo "$cnt".getHead($conn,odbc_result( $cur,'programID'));
echo "".getHead($conn,odbc_result( $cur,'sectionID'));
echo "".odbc_result( $cur,'nos');
$total+=odbc_result( $cur,'nos');
$ids="select ID from student where status=0 and programID='".odbc_result( $cur,'programID')."' and sectionID='".odbc_result( $cur,'sectionID')."' ";
//$nos=getName($conn,"select count(*) from Attendance where status=0 and ID in ($ids) and date_='$date_' ");
$absent="select count(*) from Attendance where status=1 and ID in ($ids) and date_='$date_' ";
$leave="select count(*) from Attendance where status=2 and ID in ($ids) and date_='$date_' ";
$emp="select stdName from student where ID=(select top 1 userID from Attendance where ID in ($ids) and date_='$date_') ";
$arr=getName($conn,"select count(*),($absent),($leave),($emp) from Attendance where status=0 and ID in ($ids) and date_='$date_' ");
if($arr[1]>0)echo "".$arr[1]; else echo "";
$totalPresent+=$arr[1];
//$nos=getName($conn,"select count(*) from Attendance where status=1 and ID in ($ids) and date_='$date_' ");
if($arr[2]>0)echo "".$arr[2]; else echo "";
$totalAbsent+=$arr[2];
//$nos=getName($conn,"select count(*) from Attendance where status=2 and ID in ($ids) and date_='$date_' ");
if($arr[3]>0)echo "".$arr[3]; else echo "";
$totalLeave+=$arr[3];
//$emp=getName($conn,"select stdName from student where ID=(select top 1 userID from Attendance where ID in ($ids) and date_='$date_') ");
echo "".$arr[4];
$cnt++;
}
echo "Summary$total$totalPresent$totalAbsent$totalLeave";
echo "";
?>