<?php include('userheader.php'); ?>
<?php
  include_once('../controller/connect.php');
  
  $dbs = new database();
  $db=$dbs->connection();

  $empid = $_SESSION['User']['EmpId'];
  $leavedetails = @mysqli_query($db,"select * from leavedetails  where EmpId='$empid'");
?>
<style>
#customers {
  font-family: Arial, Helvetica, sans-serif;
  border-collapse: collapse;
  width: 100%;
}

#customers td, #customers th {
  border: 1px solid #ddd;
  padding: 8px;
}

#customers tr:nth-child(even){background-color: #f2f2f2;}

#customers tr:hover {background-color: #ddd;}

#customers th {
  padding-top: 12px;
  padding-bottom: 12px;
  text-align: center;
  background-color: #04AA6D;
  color: white;
}
</style>
   
            <div class="s-12 l-10">
               <h1 style="color: #858282;">ประวัติการประชุม/อบรม</h1><hr>
              <div class="clearfix"></div>
               
                  <table align="center" cellpadding="2" cellspacing="2" id="customers">
  <tr>
    <th width="4%">ลำดับ</th>
    <th width="8%">ปีงบประมาณ</th>
    <th width="28%">หลักสูตร</th>
     <th width="11%">เริ่มวันที่</th>
    <th width="12%">ถึงวันที่</th>
    <th width="9%">ค่าใช้จ่าย</th>
      <th width="18%">แหล่งงบประมาณ</th>
    <th width="10%">สถาบันผู้จัด</th> 
       </tr>
  
  
  <?php $i=1; while($rom = mysqli_fetch_assoc($leavedetails)) { //print_r($rom);exit;
			      $typeid = $rom['TypesLeaveId'];
			      $typename = @mysqli_query($db,"select * from type_of_leave where LeaveId='$typeid' ");
			      $typen = @mysqli_fetch_assoc($typename); ?> <tr>
    <td><?php $i=$i; echo $i; $i++;?></td>
    <td><?php echo ucfirst((isset($typen['Type_of_Name']))?$typen['Type_of_Name']:""); ?></td>
    <td><?php echo(isset($rom['Reason']))?$rom['Reason']:""; ?></td>
    <td><?php echo(isset($rom['StateDate']))?$rom['StateDate']:""; ?></td>
    <td><?php echo(isset($rom['EndDate']))?$rom['EndDate']:""; ?></td>
    <td><?php echo(isset($rom['mon']))?$rom['mon']:""; ?></td>
 <td><?php echo(isset($rom['buj']))?$rom['buj']:""; ?></td>
 <td><?php echo(isset($rom['pa']))?$rom['pa']:""; ?></td>
                	
<?php }?> 

  </tr>

</table>
                    
           
        	
	             
            

<script>
	$(".la").mouseover(function (e) 
    {
        $(this).removeClass('fa fa-refresh')
        $(this).addClass('fa fa-refresh fa-spin')
    }).mouseout(function (e)
    {
        $(this).removeClass('fa fa-refresh fa-spin')
        $(this).addClass('fa fa-refresh')
    })
</script>
<?php include('userfooter.php'); ?>