<?php
session_start();
$date = date("Y-m-d H:i:s");
?>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>รายงานบันทึกเข้า-ออก</title><br /><p align="center">บันทึกการเข้า-ออก ห้อง server </p>
<table width="80%" border="1" align="center">
  <tr align="center">
   <td width="15%">ชื่อ</td>
   <td width="22%">กิจกรรม</td>
   <td width="8%">วันที่</td>
   <td width="5%">เวลาเข้า</td>
   <td width="5%">เวลาออก</td>
  </tr>
  <?php
	$objConnect = mysql_connect("localhost","root","090407") or die("Error Connect to Database");
	mysql_query("SET character_set_results=utf8");
	mysql_query("SET character_set_client=utf8");
	mysql_query("SET character_set_connection=utf8");
	$objDB = mysql_select_db("scan_inserver");
		
	$plquery="SELECT * FROM report where date(dateIn)=curdate() ";
	//echo $plquery.'<br>';
	$result=mysql_query($plquery);
	//echo $result.'<br>';
		
?>

  <?php
  
	while($row=mysql_fetch_array($result)){
	      $id=$row['id'];
		  
	      $m= substr($row['dateIn'],5,2);
		  //echo $m.'<br>';
		  $d= substr($row['dateIn'],8,2);
		  //echo $d.'<br>';
		  $y= substr($row['dateIn'],0,4)+543;
		  //echo $y.'<br>';
		  $dateN=$d.'-'.$m.'-'.$y;
	    $plquery1="select * from  User  where IDUser='".$row['IDUser']."' ";
		$result1=mysql_query($plquery1);
		while($objResult = mysql_fetch_array($result1)){
		$nameS=$objResult['username'];
		echo '<tr><td>'.'&nbsp;'.$nameS.'</td>';
		echo '<td>'.'&nbsp;'.$row['comment'].'</td>';
		echo '<td align="center">'.$dateN.'</td>';
		echo '<td align="center">'.substr($row['dateIn'],11,5).' น.'.'</td>';
		if (substr($row['dateOut'],11,5)=='00:00'){
		echo '<td align="center"><a href="out.php?&id='.$id.'&nameS='.$row['IDUser'].'" >
			<input name="submit" type="submit" style="width:100px; height:25px; font-size:16px;" value="บันทึกออก"><a></td>';
		}else{
		echo '<td align="center">'.substr($row['dateOut'],11,5).' น.'.'</td>';
		}
		echo '</tr>';
	   }
	   }
	   
  ?>
</table>
<?php

	echo '<p align="center"><a href="add.php" >
			<input name="submit" type="submit" style="width:100px; height:25px; font-size:16px;" value="บันทึกเข้า"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
			<a href="reportF.php">
			<input name="submit2" type="submit2" style="width:120px; height:30px; font-size:16px;" value="ดูรายงานทั้งหมด"></a>
			</p>';
			
?>