<?
	unset($tmpsum);
  $sql1 ="SELECT distinctrow head  FROM $tbl where mon='$USEMON' and yea='$USEYEA' "; 

	$sql2 = "$sql1 order by head";
  	$result=tmq($sql2);
?> 
                <table width="780" align=center border="0" cellspacing="1" cellpadding="3" class=table_border>
                  <tr bgcolor="#006699"> 
                    <td class=table_head rowspan=2 width=150>Statistics</td>
                    <td class=table_head  colspan=32>
										<?echo $thaimonstr[$USEMON]; ?> <?echo $USEYEA+543; ?></td>
			</tr>
                  <tr bgcolor="#006699"> 
<?
for ($i=1;$i<=31;$i++) {
	$tmp="0$i";
	$tmp=substr($tmp,-2);
?><td class=table_td align=center <?
	$today=date("N",mktime(0, 0, 0, $USEMON, $i, $USEYEA));
	if ($today==6) {
		echo " style='background-color: #BFDFFF' ";
	}
	if ($today==7) {
		echo " style='background-color: #FFB3B3' ";
	}
?> style="font-size: 12px;"><? echo $tmp?></td><?
}
echo "<td align=center class=table_td>-</td>";
?>
</tr>
                  <?
         $i=1; 
         while($row = tmq_fetch_array($result)) {
$rowsum[$row[head]]=0;
$ittt = ($startrow)+$i;
          echo"<tr bgcolor=#F2F2F2 height=2 valign=top>";
            echo"<td   class=table_td><font face='MS Sans Serif' size=3 color=#003366>";
			echo local_getdspstr($row[head],$sdb[$db][headmode]);
			echo "</td>";
///collecting data
$USEMON=floor($USEMON);
	$t="select dat  as dat2,cc from $tbl where head='$row[head]' and mon='$USEMON' ";

	$t.="  ";
	$t=tmq($t,false);
	$tmp=Array();

while ($r=tmq_fetch_array($t)) {
	//print_r($r);
	$tmp[$r["dat2"]]=$r["cc"];//=$r["aa"];
}
///collecting data-end

for ($i=1;$i<=31;$i++) {
	$col=$coldb[$tmp[$i]];
	if ($col=="") {
		$col="#ffcc00";
	}
	if ($tmp[$i]==0) {
		$col="#FFFFFF";
	}
	?><td class=table_td align=center style="font-size: 12px;"
	<?
	$today=date("N",mktime(0, 0, 0, $USEMON, $i, $USEYEA));
	if ($today==6) {
		echo " style='border-bottom-color: #BFDFFF; border-bottom-style: solid; border-bottom-width: 2' ";
	}
	if ($today==7) {
		echo " style='border-bottom-color: #FFB3B3; border-bottom-style: solid; border-bottom-width: 2' ";
	}
	$tmpsum[$i]=$tmpsum[$i]+$tmp[$i];
	$rowsum[$row[head]]=$rowsum[$row[head]]+$tmp[$i];

	?> style="background-color: <? echo $col;?>;"	><? echo number_format($tmp[$i])?></td><?
}
echo "<td align=right class=table_td>". number_format($rowsum[$row[head]])."</td>";
echo "</tr>";

    $i++;
		$s = $i-1;	
       } 
	  // echo $_pagesplit_btn_var;
 ?>

                  <tr bgcolor="#006699"> 

                    <td class=table_head rowspan=2 width=150>Sum</td>
										<?
	for ($i=1;$i<=31;$i++) {
		?><td class=table_td align=center ><? echo number_format($tmpsum[$i])?></td><?
	}
?><td class=table_head align=center ><? echo number_format(@array_sum($tmpsum))?></td>				</tr>

                </table>