| Server IP : 104.21.80.248 / Your IP : 162.159.115.42 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Inetpub/www/myschool/triamudom/check/timework/ |
Upload File : |
<?php
session_start();
$path = "../";
include ($path.'include/config_db.php');
include ($path.'include/class_db.php');
include ($path.'include/class_display.php');
include ($path.'include/function.php');
$CLASS['db'] = new db();
$CLASS['db']->connect();
$CLASS['disp'] = new display();
$db = $CLASS['db'];
$disp = $CLASS['disp'];
$date_insert = date('Y-m-d');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>ระบบลงเวลาปฏิบัติราชการ โรงเรียนแกลง''วิทยสถาวร'' จังหวัดระยอง</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/default.CSS" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
background-color: #FF2F2F;
}
.style2 {color: #FF0000}
-->
</style></head>
<body>
<table width="988" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="200" valign="top" bgcolor="#3882F6"><?php include("header.php");?></td>
</tr>
<tr>
<td height="100%" align="center" valign="middle" bgcolor="#FFFFFF"><table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="100%" align="center" valign="top"> </td>
<td width="1" align="center" valign="top" background="images/hdot.gif"></td>
<td align="center" valign="top" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td width="230" height="100%" align="center" valign="top"><?php include('com_left.php');?></td>
<td width="1" align="center" valign="top" background="images/hdot.gif"></td>
<td align="center" valign="top" bgcolor="#FFFFFF"><table width="90%" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td><fieldset>
<legend class="bigone"><strong>รายชื่อผู้ยังไม่ลงเวลาปฏิบัติงาน</strong></legend>
<table width="99%" border="0" align="center" cellpadding="2" cellspacing="2" bgcolor="#FF0000">
<tr>
<td width="9%" nowrap="nowrap" bgcolor="#FFFFFF" class="headTable_mpt"><div align="center">ลำดับที่</div></td>
<td width="19%" nowrap="nowrap" bgcolor="#FFFFFF" class="headTable_mpt"><div align="center">เลขประจำตำแหน่ง</div></td>
<td width="30%" nowrap="nowrap" bgcolor="#FFFFFF" class="headTable_mpt"><div align="center">ชื่อ - สกุล </div></td>
<td width="26%" nowrap="nowrap" bgcolor="#FFFFFF" class="headTable_mpt"><div align="center">กลุ่มสาระการเรียนรู้</div></td>
<td width="16%" nowrap="nowrap" bgcolor="#FFFFFF" class="headTable_mpt"><div align="center">หมายเหตุ</div></td>
</tr>
<?php
$sql_display = $db->query("SELECT
tb_teachers.tb_teacher_id,
tb_teachers.tb_teacher_name,
tb_teachers.tb_teacher_number,
tb_teachers.tb_department_id
FROM
tb_teachers order by tb_teachers.tb_department_id asc ");
$num_display = $db->num_rows($sql_display);
if($num_display > "0"){
$i=1;
while($fetch_displayw = $db->fetch_array($sql_display)){
$query_chk = $db->query("select count(tb_teacher_number) as num_group from tb_timeteachers where tb_teacher_number ='".$fetch_displayw['tb_teacher_number']."' and tb_timeteacher_date='".$date_insert."' ");
$fetch_chk = $db->fetch_array($query_chk);
if($fetch_chk['num_group']=="0"){
?>
<tr>
<td align="center" nowrap="nowrap" bgcolor="#FFFFFF"><?php print $i;?>.</td>
<td align="center" nowrap="nowrap" bgcolor="#FFFFFF"><?php print $fetch_displayw['tb_teacher_number'];?></td>
<td nowrap="nowrap" bgcolor="#FFFFFF"><?php print $disp->display_teachertimename($fetch_displayw['tb_teacher_number'])?></td>
<td align="center" nowrap="nowrap" bgcolor="#FFFFFF"><?php print $disp->display_departmentname($fetch_displayw['tb_department_id']);?></td>
<td align="center" nowrap="nowrap" bgcolor="#FFFFFF"> </td>
</tr>
<?php
$i++;
}
} }else{ ?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><span class="style2">ยังไม่มีข้อมูล</span></td>
</tr>
<?php } ?>
</table>
</fieldset>
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="100%" align="center" valign="top"> </td>
<td width="1" align="center" valign="top" background="images/hdot.gif"></td>
<td align="center" valign="top" bgcolor="#FFFFFF"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="50" valign="bottom"><?php include("footer.php");?></td>
</tr>
</table>
</body>
</html>