<?php include('userheader.php'); ?>
              
<style>
	.dash-summary{
	display: flex;
	justify-content:space-between;
	width: 83%;
	}
	.dash-panel {
		border: 1px solid #f0efef;
		width: 48%;
		padding: 1em 1em;
		box-shadow: 2px 2px 7px #c8c8c8;
	}	
	
#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>
<?php 
include_once('../controller/connect.php');
$dbs = new database();
$db=$dbs->connection();
$pending = 0;
$accepted = 0;
$EmpId = $_SESSION['User']['EmpId'];
$pending_sql = "SELECT Detail_Id FROM `leavedetails` where EmpId= '{$EmpId}' ";
$pending_qry = mysqli_query($db, $pending_sql);
$pending = $pending_qry->num_rows;

$accepted_sql = "SELECT *,COUNT(EmpId) as t1 FROM leavedetails WHERE  LeaveStatus='Accept' and EmpId= '{$EmpId}'";
$accepted_qry = mysqli_query($db, $accepted_sql);
$accepted = $accepted_qry->num_rows;
?>
	 <div class="s-12 l-10">
    <h1>อัปโหลดเอกสารจากการประชุม/อบรม</h1><hr>
    <div class="clearfix"></div>
    </div>
    <div class="s-12 l-6">	
    <form method="POST" action="upload.php" enctype="multipart/form-data">
    <div class="form-inline">
    <table align="center" cellpadding="2" cellspacing="2" id="customers">
  <tr>
    <td> หลักสูตร:&nbsp;</td>
    <td> <input name="topic" type="text" id="topic" size="100">  &nbsp;</td>
  </tr>
  <tr>
    <td>ชื่อ-สกุล:&nbsp;</td>
    <td><input name="name1" type="text" id="name1">&nbsp;</td>
  </tr>
  <tr>
    <td>upload&nbsp;</td>
    <td><input type="file" class="form-control" name="file" required/>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><button class="btn btn-primary" name="upload"><span class="glyphicon glyphicon-upload"></span> อัปโหลดไฟล์</button>&nbsp;</td>
  </tr>
</table>

		</div>
		</form>
		<br />
		<table align="center" cellpadding="2" cellspacing="2" id="customers">
			<thead class="alert-info">
				<tr>
                <th width="6%">ลำดับ</th>
					<th width="48%">หลักสูตร</th>
                    <th width="30%">ผู้ประชุม</th>
					<th width="16%">ดาวน์โหลด</th>
				</tr>
			</thead>
			<tbody>
			<?php
				require 'conn.php';
				$i=1;
				$query = mysqli_query($conn, "SELECT * FROM `filehrd`") or die(mysqli_error());
				while($fetch = mysqli_fetch_array($query)){
			?>
				<tr>
                 <td><?php echo $i; ?></td>
                <td><?php echo $fetch['topic']?></td>
                <td><?php echo $fetch['name1']?></td>
					
					<td><button type="button" class="btn btn-primary" onclick="download(this.name);" name="<?php echo $fetch['file_id']?>"><span class="glyphicon glyphicon-download"></span> Download</button></td>
				</tr>
			<?php
					$i++;
					}
			?>
			</tbody>
		</table>
      
	
	</div>
<script type="text/javascript">
	function download(id){
		alert("ดาวน์โหลดไฟล์เอกสารเรียบร้อย!");
		window.location = 'download.php?file_id='+id;
	}
</script>	        

<?php include('userfooter.php'); ?>