<div align="left">
	  <table cellspacing="0" cellpadding="0" width="100%" height=450 border="0">
        <tbody>
           <tr>
            <td valign="top"  ><div align="center"><font color=red><B>การมาปฏิบัติราชการวันนี้ของผู้บริหารโรงเรียน</B></font></div>
			<table cellspacing="0" cellpadding="0" width="100%"  border="0">
			<tr>
            <td valign="top"  width="50%">
			<img src="images/admin/user.gif"  border="0" align="absmiddle" /><A HREF="?name=user&file=userapproval"> <b>บุคลากรเขตพื้นที่การศึกษา</b></A>
			</td>
		<TD align="center" width="25%"></td>
		<TD align="right" width="25%"><a href="schapproval.php" target="_blank">&nbsp;&nbsp;<img src="images/iconfile/excel.png"  /></A>&nbsp;&nbsp; 
           	</td>
			</tr>
			</table>
			</td>
			</tr>
		   <tr>
            <td valign="top" width="100%" >    
                                      <!-- แสดงผลรายการสมาชิกเว็บ -->

                                      <?
//////////////////////////////////////////// แสดงรายชื่อสมาชิกเว็บ
if($_GET[op] == ""){
if($_GET[id]){
	$SQLwhere = " id='".$_GET[id]."' ";
	$SQLwhere = " WHERE id='".$_GET[id]."' ";
}
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 300 ;
$SUMPAGE = $db->num_rows(TB_user,"id","level>1 and status='4'");
$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  height="25">
												<td>
                                              <TABLE width="100%" >
  <TR > 
    <TD rowspan="2" align="center" valign="middle"bgcolor="#99ccff">ที่</TD>
    <TD rowspan="2" align="center" valign="middle"bgcolor="#99ccff">ชื่อ-สกุล</TD>
    <TD rowspan="2" align="center" valign="middle"bgcolor="#99ccff">โรงเรียน</TD>
    <TD rowspan="2" align="center" valign="middle"bgcolor="#99ccff">สถานะ</TD>
    <TD colspan="2" align="center" valign="middle"bgcolor="#99ccff">วัน เดือน ปี</TD>
  </TR>
  <TR bgcolor="#99ccff"> 
    <TD align="center" valign="middle">วันเริ่มต้น</TD>
    <TD align="center" valign="middle">วันสิ้นสุด</TD>
  </TR>
 <?
$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE radab='1' ORDER BY name 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[user][level]."' ");
	$arr[groups] = $db->fetch($res[groups]);
	$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE sangkad='".$arr[usersch][id]."' and status='4' ");
	$arr[user] = $db->fetch($res[user]);
?>
  <TR valign="top" bgcolor="#FFFFFF"> 
<td width="20" align="center"><? echo"".$i?></td>
<td width="200" >  <? echo $arr[user][category_name];?></td>	
<td width="200" >  <? echo $arr[usersch][name];?></td>	
<?
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[yearla] = $db->select_query("SELECT * FROM ".TB_YEARLA_CAT."  ");
$arr[yearla] = $db->fetch($res[yearla]);
$res[tkk6] = $db->select_query("SELECT * FROM ".TB_TKK6." WHERE cat='".$arr[user][id]."' and yearla='".$arr[yearla][name]."' and current_date between date1 and date2 and comment1='อนุญาต' ORDER BY id DESC LIMIT 1 ");
$count=0;
while($arr[tkk6] = $db->fetch($res[tkk6])){
?>
										<td width="250" ><font color=blue>ลา<? echo $arr[tkk6][la];?></font></td>	
 	
											<td width="120" align="center"><font color=blue><?echo ("".thai_date_short(strtotime($arr[tkk6][date1]))."" );?></font></td>

											<td width="120" align="center"><font color=blue><?echo ("".thai_date_short(strtotime($arr[tkk6][date2]))."" );?></font></td>
 
<?
 } 
?>
<?
//ดึงค่า
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[approval] = $db->select_query("SELECT * FROM ".TB_APPROVAL." WHERE  cat='".$arr[user][id]."' and comment='อนุญาต' and current_date between date and date1 or person like '%,".$arr[user][id].",%' and comment='อนุญาต'  and current_date between date and date1 ORDER BY id DESC LIMIT 1 ");
while($arr[approval] = $db->fetch($res[approval])){
?>
											<td width="250" ><font color=red> ไปราชการ</font>
											
											</td>	

											<td width="120" align="center"><font color=blue><?echo ("".thai_date_short(strtotime($arr[approval][date]))."" );?></font></td>

											<td width="120" align="center"><font color=blue><?echo ("".thai_date_short(strtotime($arr[approval][date1]))."" );?></font></td>
<?
 } 
?>



</TR>                                          
<?
$i++;
 } 
?>
                                    </table>
                                      </form>
                                  </td>
                                </tr>
                              </table>
<div align="left">
  <?
	SplitPage($page,$totalpage,"?name=user&file=userapproval");
	echo $ShowSumPages ;
	echo $ShowPages ;
	echo "<BR><BR>";	
}
?>
</div>
					  </td>
                    </tr>
                  </tbody>
                </table>