<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="1005"  border="0">
			<tr>
            <td valign="top"  width="50%">
			<img src="images/admin/user.gif"  border="0" align="absmiddle" />
			</td>
		<TD align="center" width="25%"></td>
		<TD align="right" width="25%">
           	</td>
			</tr>
			</table>
			</td>
			</tr>
		   <tr>
            <td valign="top" width="100%" >                 
                                      <!-- แสดงผลรายการสมาชิกเว็บ -->
<?
//////////////////////////////////////////// แสดงรายชื่อสมาชิกเว็บ
if($_GET[op] == ""){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 100 ;
$SUMPAGE = $db->num_rows(TB_user,"id","level>1 and status='1'");
$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[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE level>1 and status='1' ORDER BY working ASC LIMIT $goto, $limit ");
$count=0;
$i=1;
while($arr[user] = $db->fetch($res[user])){
	$res[groups] = $db->select_query("SELECT * FROM ".TB_ADMIN_GROUP." WHERE id='".$arr[user][level]."' ");
	$arr[groups] = $db->fetch($res[groups]);

	$res[workgroup] = $db->select_query("SELECT * FROM ".TB_WORKGROUP_CAT." WHERE id='".$arr[user][workgroup]."' ");
	$arr[workgroup] = $db->fetch($res[workgroup]);
?>
  <TR valign="top" bgcolor="#FFFFFF"> 
<td width="5%" align="center"><? echo"".$i?></td>
<td width="20%" >  <? echo $arr[user][category_name];?></td>	
<td width="25%" >  <? echo $arr[workgroup][category_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="20%" ><font color=blue>ลา<? echo $arr[tkk6][la];?></font></td>	
 	
											<td width="15%" align="center"><font color=blue><?echo ("".thai_date_short(strtotime($arr[tkk6][date1]))."" );?></font></td>

											<td width="15%" 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="25%" ><font color=red> <a href="?name=approval&amp;file=checkperson&amp;op=approval_read&amp;id=<?=$arr[user][id];?>&amp;mount=<?=$arr[approval][mount];?>">ไปราชการ</A></font>
											
											</td>	

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

											<td width="15%" 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>