<?php
include "header.php";
$SQL1 = $mysqli->query("SELECT * FROM student where status='in'");
?>
<div class="wrapper">
           <div class="container">  

				<form name="user" action="" method="post">
                <div class="table-responsive"> 
<!--Breadcrumbs -->
<ol class="breadcrumb">
  <li><a href="index.html">Home</a></li>
  <li class="active"><font color="#0039e6">ข้อมูลนักเรียน</font></li>
</ol>
<!--End Breadcrumbs -->					
                     <table id="Get_data" class="table table-hover table-datatable table-striped table-bordered">  
                          <thead>  
                               <tr> 
									<td width="30">NO</td>
                                    <td width="100" align='center'>รหัส</td>  
                                    <td align='center'>ชื่อ-นามสกุล</td>
									<td width="50">ชื่อเล่น</td>
									<td width="50" align='center'>ชั้น</td>
									<td width="70" align='center'>หอพัก</td>
									<td width="50" align='center'>รูป</td>										
                                    <td width="100" align='center'>จัดการ</td>  
                               </tr>  
                          </thead>  
                          <?php 
							$i=0;
							while($Row=mysqli_fetch_array($SQL1)) { 
							$i++
                           ?>
                               <tr>

									<td align="center"><?=$i;?></td>
                                    <td align='center'><?=$Row["code"];?></td>  
                                    <td><?=$Row["prefix"];?><?=$Row["name"];?>  <?=$Row["sname"];?></td>
									<td><?=$Row["nicname"];?></td>
									<td align='center'><?=$Row["class"];?></td>
									<td><?=$Row["rsroom"];?></td>
									<td align='center'><?php if($Row["pic"]==""){echo "-";}else { ?>
										<button type="button" class="btn btn-default btn-xs" data-toggle = "modal" data-target="#pic<?=$Row["code"];?>">
										<span class='glyphicon glyphicon-picture'></span> Picture</button>
									<?php } ?>
<!-- Modal -->
  <div class="modal fade" id="pic<?=$Row['code'];?>" role="dialog">
    <div class="modal-dialog">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">รูปนักเรียน</h4>
        </div>
        <div class="modal-body">
          <p><center><img src="../student/photo/<?=$Row["pic"];?>" class="img-thumbnail" alt="<?=$Row["code"];?>" width="300" height="320"><br>
		  <h4>รหัส : <?=$Row["code"];?></h4>
		  </center></p>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-default" data-dismiss="modal">ปิด</button>
        </div>
      </div>      
    </div>
  </div>									
									
									</td>
                                    <td align="center">
									<?php if($Row["status"]=="out"){?>
									<a href="chk-in.php?code=<?=$Row['code'];?>">
									<button type="button" class="btn btn-success btn-xs">&nbsp;<span class="glyphicon glyphicon-edit"></span> Check-IN&nbsp;&nbsp;</button></a>
									<?php }else { ?>
									<a href="chk-out.php?code=<?=$Row['code'];?>">
									<button type="button" class="btn btn-warning btn-xs"><span class="glyphicon glyphicon-edit"></span> Check-OUT</button>
									</a>
									<?php } ?>
									</td>   
                               </tr>   
                          <?php } ?>  
                     </table> 
 <script>  
 $(document).ready(function(){  
      $('#Get_data').DataTable();  
 });  
 </script> 					 
                </div>
			</form>
           </div>  
</div>
 


<?php
require '../admin/popup.php';
require '../footer.php';
?>
  </body>
</html>