<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<div align="left">
	  <table cellspacing="0" cellpadding="0" width="100%" height=450 border="0">
        <tbody>
          <tr>
            <td valign="top" width="100%" > <div align="center">
			<table width="100%">
                          <tr>   
						<td align="center"">
							<a href='index.php'>
                        <font color=red><b>แสดงข้อมูลจำแนกรายโรง</b></font>
							</td>
							
							</tr>
							</table>
                <table cellspacing="0" cellpadding="0" width="98%" border="0">
                  <tbody>
                    <tr>
                      <td><table width="100%">
                          <tr>
                            <td align="center">
                              <table width="100%" align="center" cellspacing="0" cellpadding="0" border="0">
                                <tr>
                                  <td align="center">
                                      <!-- แสดงผลรายการสมาชิกเว็บ -->
                                      <?
//////////////////////////////////////////// แสดงรายชื่อสมาชิกเว็บ
if($_GET[op] == ""){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 200 ;
$SUMPAGE = $db->num_rows(TB_user,"id","");
$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 ;
?>
    
                                  <form action="?name=user&amp;file=user_cp&amp;op=user_del&amp;action=multidel" method="post" name="myform" id="myform">
                                       <table width="100%" cellspacing="2" cellpadding="1" >
  <tr bgcolor="#00FFFF" height=25> 
    <td rowspan="2"  align=center>ที่</td>
    <td rowspan="2"  align=center>โรงเรียน</td>
    <td height="37" colspan="4"  align=center>ข้อมูลบุคลากรจำแนกรายโรง</td>
  </tr>
  <tr bgcolor="#336633" height=25> 
    <td  align=center bgcolor="#00FFFF">จำนวนผู้บริหาร</td>
    <td height="37"  align=center bgcolor="#00FFFF">จำนวนครู</td>
    <td  align=center bgcolor="#00FFFF">ดูข้อมูลปัจจุบัน</td>
    <td  align=center bgcolor="#00FFFF">ครูในอดีต</td>
  </tr>
 <?
$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE radab='1' and status='1' ORDER BY id ASC LIMIT $goto, $limit ");
$i=1;
while($arr[usersch] = $db->fetch($res[usersch])){
	$res[groups] = $db->select_query("SELECT * FROM ".TB_ADMIN_GROUP." WHERE id='".$arr[usersch][level]."' ");
	$arr[groups] = $db->fetch($res[groups]);


?>
					
<tr bgcolor="#CCFFFF" height=25> 
    <td width="5%"  align=center><? echo"".$i?></td>
    <td width="26%"  ><A HREF="?name=approvalkru&file=myreport&sangkad=<?=$arr[usersch][id];?> "><? echo $arr[usersch][name];?></a><?=$arr[guide][category];?></td>

<td width="8%"  align=center>
<?php
// Make สถิติลาป่วย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT sangkad SUM(sangkad) FROM web_user   GROUP BY id"; 
$sql1="select sum(sangkad='".$arr[usersch][id]."') as tt1 from web_user  where sangkad='".$arr[usersch][id]."' and status='4' ORDER BY id";
			$dbquery1 = mysql_db_query($dbname, $sql1);
			$result1 = mysql_fetch_array($dbquery1);
			$jan=$result1[tt1];
   ?>
<? echo number_format($jan),''; ?>
	</td>
    <td width="8%"  align=center>
<?php
// Make สถิติลาป่วย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT sangkad SUM(sangkad) FROM web_user   GROUP BY id"; 
$sql1="select sum(sangkad='".$arr[usersch][id]."') as tt1 from web_user  where sangkad='".$arr[usersch][id]."' and status='5' ORDER BY id";
			$dbquery1 = mysql_db_query($dbname, $sql1);
			$result1 = mysql_fetch_array($dbquery1);
			$jan1=$result1[tt1];
   ?>
<? echo number_format($jan1),''; ?>
	</td>
<td width="8%"  align=center><A HREF="?name=user&file=editschool&sangkad=<?=$arr[usersch][id];?> "><img src="images/View.png"  width="20" height="20"align="middle" border="0" /></a></td>
<td width="8%"  align=center><A HREF="?name=approvalkru&file=adeet&sangkad=<?=$arr[usersch][id];?> "><img src="images/View.png"  width="20" height="20"align="middle" border="0" /></a></td>
  </tr>


                                        

                                          <tr bgcolor=FFFFFF>
                                            <td colspan="9" height="1" class="dotline">
											
											</td>
                                          </tr>


<?
$i++;
 } 
?>
                                        </table>

                                      </form>
									  <BR>
<div align="left">
  <?
	SplitPage($page,$totalpage,"?name=tkk6&file=userkm");
	echo $ShowSumPages ;
	echo "<BR>";
	echo $ShowPages ;
	echo "<BR><BR>";
	

//$res[groupstext] = $db->select_query("SELECT * FROM ".TB_ADMIN_GROUP." ORDER BY id ");
//while ($arr[groupstext] = $db->fetch($res[groupstext]))
 //  {
		//echo "<LI><B>".$arr[groupstext][name]." : </B>".$arr[groupstext][description]."</LI>";
 //  }
//$db->closedb ();

}
?>
</div>
                                    <br />
                                  </td>
                                </tr>
                              </table>
</td>
                                </tr>
                              </table>
                            <br /></td>
                          </tr>
                      </table></td>
                    </tr>
                  </tbody>
                </table>