<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
 <?
//	CheckUser($_SESSION['user_user']);
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
		$arr[user] = $db->fetch($res[user]);
	//ดึงค่า
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[year] = $db->select_query("SELECT * FROM ".TB_YEAR_CAT." ORDER BY id ");
		$arr[year] = $db->fetch($res[year]);	
?>
<TABLE cellSpacing=0 cellPadding=0 width=100% height=400 align=center  border=0>
      <TBODY>
		<TR height=25>
			<TD width=100% align=center> <font color=blue>รานงานผลการใช้จ่ายงบประมาณและรายงานผลการดำเนินงานตามแผนงานโครงการ ปีงบประมาณ <?echo $arr[year][name];?></font></TD>
			</TR>
			<TR>
			<TD colspan="3" valign="top" >			
			<form action="?name=report&file=index2&op=report_del&action=multidel" name="myform" method="post">
			 <table width="100%"  align=center cellspacing="2" cellpadding="1" >
				<tr bgcolor="#336633" height=25>
				<td width="5%" align="center"><font color="#FFFFFF"><B>ที่</B></font></td>
				<td width="30%" align="center"><font color="#FFFFFF"><B>ชื่อโครงการ</B></font></td>
				<td width="15%"  align="center"><font color="#FFFFFF"><B>ระยะเวลา</B></font></td>
				<td width="10%"  align="center"><font color="#FFFFFF"><B>เอกสารรายงานผล</B></font></td>
				<td width="10%" align="center"><font color="#FFFFFF"><B>งบประมาณ</B></font></td>
				<td width="10%" align="center"><font color="#FFFFFF"><B>เบิกจ่าย</B></font></td>
				<td width="10%" align="center"><font color="#FFFFFF"><B>คงเหลือ</B></font></td>
				<td width="10%" align="center"><font color="#FFFFFF"><B>ร้อยละ</B></font></td>
				</tr>  
 <?
//แสดงบทความ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 100 ;
$SUMPAGE = $db->num_rows(TB_REPORT,"id","$SQLwhere year='".$arr[year][name]."' ");
$page=$_GET[page];
if (empty($page)){
	$page=1;
}
$rt = $SUMPAGE%$limit ;
$totalpage = ($rt!=0) ? floor($SUMPAGE/$limit)+1 : floor($SUMPAGE/$limit); 
$goto = ($page-1)*$limit ;
$res[report] = $db->select_query("SELECT * FROM ".TB_REPORT." WHERE year='".$arr[year][name]."'  ORDER BY id ASC LIMIT $goto, $limit   ");
$count=0;
$i=1;
while($arr[report] = $db->fetch($res[report]))
	{
 ?>
<tr bgcolor="#FFFFFF" >
		<td valign="top"><? echo"".$i?></td>
		<td valign="top"><?echo $arr[report][topic];?>
		<BR>
		<?
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE status='1' ORDER BY post_date DESC ");
while($arr[user] = $db->fetch($res[user]))
	{
//เรียกชื่อโรงเรียนที่มีชื่อที่ต้องรับหนังสือ
		$sql1="select * from web_report where web_report.id='".$arr[report][id]."' and cat like '%,".$arr[user][id].",%' order by id";
		
		$dbquery1 = mysql_db_query($dbname, $sql1);
		$num_rows1 = mysql_num_rows($dbquery1);

		$result1 = mysql_fetch_array($dbquery1);
		
		if($num_rows1!=0)
		{
?> 
<font color=blue><?echo $arr[user][category_name];?> ,</font>
<?
}}
?> 			
		</td>
<td valign="top" ><?echo $arr[report][date];?></td>
		<td valign="top"  >
<?
$res[reportfile] = $db->select_query("SELECT * FROM ".TB_REPORTFILE." WHERE report_id='".$arr[report][id]."' and year='".$arr[year][name]."'  ORDER BY post_date DESC ");
while($arr[reportfile] = $db->fetch($res[reportfile]))
	{
?>	
<font color=red> - <?
$str = $arr[reportfile][name];
$cutstr = substr($str,0,16);
echo "<A HREF=\"data/report/".$arr[reportfile][full_text]."\" target=\"_blank\" ><font color=red>".$cutstr."</A> </font> <BR>";
//</font><BR>
	?>	
<?
if (($count%1) == 0) { echo ""; $count=0; }
}
?>
</td>
		<td valign="top" align="right"><?echo number_format($arr[report][draw],2, '.', ',') ;?></td>
		<td valign="top" align="right">
<?php
// Make 
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT ream SUM(ream) FROM web_report_category  WHERE  report_id='".$arr[report][id]."' and year='".$arr[year][name]."' GROUP BY id"; 
$sql1="select sum(ream) as tt1 from web_report_category where   report_id='".$arr[report][id]."' and year='".$arr[year][name]."'  ";
			$dbquery1 = mysql_db_query($dbname, $sql1);
			$result1 = mysql_fetch_array($dbquery1);
			$sum=$result1[tt1];
?>
<? echo number_format($sum,2, '.', ','); ?>
</td>
		<td valign="top" align="right"><?echo number_format($arr[report][draw]-$sum,2, '.', ',');?></td>
		<td valign="top" align="right"><?echo number_format($sum*100/$arr[report][draw],2, '.', ',');?></td>		
</tr>
	<?
$count++;
$i++;
if (($count%1) == 0) { echo ""; $count=0; }
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 
</table>
 </form>		 <table width="100%"  align=center cellspacing="2" cellpadding="1" >
				<tr bgcolor="#CCFFDD" height=25>
		  <td width="60%"align="right" valign="top">&nbsp;รวมยอดทั้งหมด</td>
<?php
// Make 
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT draw SUM(draw) FROM web_report WHERE  year='".$arr[year][name]."' GROUP BY id"; 
$sql2="select sum(draw) as tt2 from web_report where   year='".$arr[year][name]."'  ";
			$dbquery2 = mysql_db_query($dbname, $sql2);
			$result2 = mysql_fetch_array($dbquery2);
			$suma=$result2[tt2];
?>

		<td width="10%" valign="top" align="right"><? echo number_format($suma,2, '.', ','); ?></td>
		<td width="10%" valign="top" align="right">
<?php
// Make 
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT ream SUM(ream) FROM web_report_category  WHERE   year='".$arr[year][name]."' GROUP BY id"; 
$sql1="select sum(ream) as tt1 from web_report_category where   year='".$arr[year][name]."'  ";
			$dbquery1 = mysql_db_query($dbname, $sql1);
			$result1 = mysql_fetch_array($dbquery1);
			$sum=$result1[tt1];
?>
<? echo number_format($sum,2, '.', ','); ?>
</td>
		<td width="10%" valign="top" align="right"><?echo number_format($suma-$sum,2, '.', ',');?></td>
		<td width="10%"valign="top" align="right"><?echo @number_format($sum*100/$suma,2, '.', ',');?></td>		
</tr>
</table>
 
		  </TD>
        </TR>
      </TBODY>
    </TABLE>