| Server IP : 104.21.80.248 / Your IP : 172.71.28.155 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 : E:/Inetpub/www/myschool/triamudom/check/checktime/ |
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'];
$search_keyword = $_REQUEST['search_keyword'];
$type_search = $_REQUEST['type_search'];
$tb_student_code = $_REQUEST['tb_student_code'];
$numrow_disall_stu = $db->num_rows($db->query("select * from tb_students where tb_student_code='".$tb_student_code."' and tb_student_status ='1' "));
if($numrow_disall_stu !="0"){
//----------------------------ค่าพื้นฐานระบบเว็บไซต์-----------------------------//
$fetch_public = $db->fetch_array($db->query("select * from tb_public"));
//----------------------------ค่าพื้นฐานระบบเว็บไซต์-----------------------------//
//--------------------ส่วนบนใช้สำหรับประกาศตัวแปรและ Config เท่านั้น----------------------------//
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php print $fetch_public['tb_public_title'];?></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/style.css"rel="stylesheet" type="text/css">
<script type="text/javascript" src="../js/format.js" ></script>
<script type="text/javascript" src="../js/dtree.js" ></script>
<link href="../css/style.css" rel="stylesheet" type="text/css">
<link href="css/deqp_style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style7 {font-size: 14}
.style9 {color: #FF0000}
.style11 {color: #006600}
-->
</style>
</head>
<body>
<table width="988" height="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="200" align="center" valign="top"><?php include('header.php');?></td>
</tr>
<tr>
<td valign="top"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="209" height="50%" align="center" valign="top"><?php include('com_left.php');?></td>
<td align="center" valign="top"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="9" height="39"><img src="images/la21/bcontent_03.jpg" width="9" height="39" /></td>
<td height="39" background="images/la21/bcontent_06.jpg"><a href="index.php"><img src="images/bar_check.jpg" width="411" height="39" border="0"></a></td>
<td width="13" height="39"><img src="images/la21/bcontent_08.jpg" width="13" height="39" /></td>
</tr>
<tr>
<td height="15" background="images/la21/bcontent_13.jpg"> </td>
<td align="center"></td>
<td height="15" background="images/la21/bcontent_15.jpg"> </td>
</tr>
<?php
$fetch_student_view = $db->fetch_array($db->query("select * from tb_students where tb_student_code='".$tb_student_code."' "));
?>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="9" height="39"><img src="images/la21/bcontent_03.jpg" width="9" height="39" /></td>
<td height="39" background="images/la21/bcontent_06.jpg"> </td>
<td width="13" height="39"><img src="images/la21/bcontent_08.jpg" width="13" height="39" /></td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center" valign="top" nowrap class="orange_textcheck"><img src="../webadmin/images/new_ques.gif" width="24" height="24" align="absmiddle"> ผลการค้นหาข้อมูลการลงเวลา ของ <?php print $tb_student_code;?></td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center" valign="top" nowrap><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="100" background="images/hdot.gif" colspan="8" height="1"><img src="images/hdot.gif" width="3" height="1" /></td>
</tr>
</table></td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<?php
$fetch_disstudentroom = $db->fetch_array($db->query("select * from tb_rooms where tb_room_id='".$fetch_student_view['tb_student_degree']."' "));
//echo "select * from tb_rooms where tb_room_id='".$fetch_disstudent['tb_student_degree']."' ";
//echo $fetch_disstudentroom['tb_room_name'];
// echo "<br>";
//echo substr($fetch_disstudentroom['tb_room_name'],5);
?>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center" valign="top" nowrap><img src="../file_student/<?php print $fetch_public['tb_public_year'];?>/M<?php echo substr($fetch_disstudentroom['tb_room_name'],5);?>/<?php print $fetch_student_view['tb_student_code'];?>.jpg" width="150" border="2"></td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center" valign="top" nowrap> </td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center" valign="top" nowrap><span class="orange_textcheck"><?php print display_nametype($fetch_student_view['tb_student_tname']);?><?php print $fetch_student_view['tb_student_name'];?> <?php print $fetch_student_view['tb_student_sname'];?></span></td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center" valign="top" nowrap></td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center" valign="top" nowrap><span class="orange_textcheck">ระดับชั้น <?php print $disp->display_roomname($fetch_student_view['tb_student_degree']);?></span></td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td width="9" height="15"><img src="images/la21/bcontent_18.jpg" width="9" height="15" /></td>
<td height="15" background="images/la21/bcontent_19.jpg"></td>
<td width="13" height="15"><img src="images/la21/bcontent_20.jpg" width="13" height="15" /></td>
</tr>
</table></td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<?php
$query_view = $db->query("select * from tb_registers where tb_student_id = '".$fetch_student_view['tb_student_id']."'");
$fetch_view = $db->fetch_array($query_view);
$query_edit = $db->query("select * from tb_acts where tb_act_id = '".$fetch_view['tb_act_id']."'");
$fetch_edit = $db->fetch_array($query_edit);
?>
<?php
$fetch_dis_regisvol = $db->fetch_array($db->query("select * from tb_volunteer where tb_student_id ='".$fetch_student_view['tb_student_id']."' "));
?>
<?php
$fetch_viewknow = $db->fetch_array($db->query("select * from tb_registers_knowledge where tb_student_id = '".$fetch_student_view['tb_student_id']."'"));
$numrowsknow = $db->num_rows($db->query("select * from tb_registers_knowledge where tb_student_id = '".$fetch_student_view['tb_student_id']."'"));
$fetch_editknow = $db->fetch_array($db->query("select * from tb_knowledges where tb_knowledge_id = '".$fetch_viewknow['tb_knowledge_id']."'"));
if($numrowsknow>0){
?>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center" class="orange_textcheck"> </td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<?php }?>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center" bgcolor="#73BB35" class="orange_textcheck style9">ข้อมูลการลงเวลา</td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center"> </td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center"><table width="95%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#558826">
<tr class="headTable_mpt">
<td width="12%" height="30" align="center" nowrap="nowrap" ><span class="style7">ลำดับที่</span></td>
<td width="41%" align="center" nowrap="nowrap" ><span class="style7">วันเดือนปี ที่ ลงเวลา </span></td>
<td width="23%" align="center" nowrap="nowrap" >เวลา</td>
<td width="24%" align="center" nowrap="nowrap" ><span class="style7">สถานะการขาดเรียน</span></td>
</tr>
<?php
$query_disall = $db->query("select * from tb_times where tb_time_stucode='".$tb_student_code."' and tb_time_smstype ='0' order by tb_time_id desc");
$numrow_disall = $db->num_rows($query_disall);
if($numrow_disall >0){
$i = 1;
while($fetch_disall = $db->fetch_array($query_disall)){
$fetch_disall_mem = $db->fetch_array($db->query("select * from tb_students where tb_student_code='".$fetch_disall['tb_time_stucode']."' "));
if($i%2=="1"){
$bg="rowone";
}else{
$bg="rowtwo";
}
?>
<tr class="<?php echo $bg;?>">
<td align="center" nowrap="nowrap" ><?php print $i;?>.</td>
<td nowrap="nowrap" >วันที่ <?php print display_date($fetch_disall['tb_time_date'],"longthai")?> </td>
<td align="center" nowrap="nowrap" ><?php print $fetch_disall['tb_time_time'];?> น.</td>
<td align="center" nowrap="nowrap" ><?php print display_timetype($fetch_disall['tb_time_type']);?></td>
</tr>
<?php
$i++;
}
?>
<tr bgcolor="#72BB33" class="headTable">
<td colspan="4" align="center">รวมการทั้งสิ้น <span class="red_text"><?php print $numrow_disall;?></span> ครั้ง </td>
</tr>
<?php
}else{
?>
<tr class="alertred">
<td colspan="4" align="center" bgcolor="#FFFFFF">ไม่พบข้อมูลการขาดเรียน</td>
</tr>
<?php
}
?>
</table></td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center"> </td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td height="15" background="images/la21/bcontent_13.jpg"> </td>
<td align="center"></td>
<td height="15" background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td width="9" height="15"><img src="images/la21/bcontent_18.jpg" width="9" height="15" /></td>
<td height="15" background="images/la21/bcontent_19.jpg"></td>
<td width="13" height="15"><img src="images/la21/bcontent_20.jpg" width="13" height="15" /></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="37" valign="bottom"><?php include('footer.php');?></td>
</tr>
</table>
</body>
</html>
<?php
}else{
?>
<script language='javascript'>
alert("ไม่มีรหัสนักเรียนคนนี้ในฐานข้อมูลของโรงเรียน");
window.location.href='display_student_search.php';
</script>
<?php
}
?>