<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.16/css/dataTables.bootstrap4.min.css"/>
	<script type="text/javascript" src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
	<script type="text/javascript" src="https://cdn.datatables.net/1.10.16/js/dataTables.bootstrap4.min.js"></script>
	<script>
	// START CODE FOR BASIC DATA TABLE 
	$(document).ready(function() {
		$('#example1').DataTable();
	} );
	$(document).ready(function() {
		$('#table1').DataTable();
	} );	
	// END CODE FOR BASIC DATA TABLE 	
	 	
	</script>
<style type="text/css">
table.dataTable tbody th, table.dataTable tbody td {
    padding: 3px 2px;
}
</style>
	<div class="row">
		<div class="col-xl-12">
			<div class="breadcrumb-holder">
				<h1 class="main-title float-left">ตั้งค่า</h1>
					<ol class="breadcrumb float-right">
					<li class="breadcrumb-item">Home</li>
					<li class="breadcrumb-item active">edugroup</li>
                    </ol>
                    <div class="clearfix"></div>
            </div>
		</div>
	</div>
    <!-- end row -->
	<?php		
		if ($msg =='error_name')
				echo '<div class="alert alert-danger" role="alert">Error! Input full name</div>';	
		if ($msg =='error_username')
				echo '<div class="alert alert-danger" role="alert">Error! Input valid username</div>';	
		if ($msg =='error_duplicate_username')
				echo '<div class="alert alert-danger" role="alert">Error! There is another user with this username address</div>';	
		if ($msg =='edit_ok')
				echo '<div class="alert alert-success" role="alert">User updated</div>';	
		if ($msg =='add_ok')
				echo '<div class="alert alert-success" role="alert">User added</div>';	
		if ($msg =='delete_ok')
				echo '<div class="alert alert-success" role="alert">User deleted</div>';	
		if ($msg =='error_delete_protected')
				echo '<div class="alert alert-danger" role="alert">Error! This user can not be deleted</div>';	
	?>
			<div class="row">
			
                    <div class="col-xs-12 col-sm-6 col-md-6 col-lg-6 col-xl-8">						
						<div class="card mb-3">
							<div class="card-header">
							<span class="pull-right"><button class="btn btn-primary btn-sm" data-toggle="modal" data-target="#modal_add_year"><i class="fa fa-user-plus" aria-hidden="true"></i> เพิ่มข้อมูล</button>
							<?php include ("modals/modal_add_year.php");?> 
							</span>							
								<h3><i class="fa fa-table"></i> ปีการศึกษา</h3>
							</div>
								
							<div class="card-body">								
								<div class="table-responsive">
								<table id="example1" class="table table-bordered table-hover display" cellspacing="0" width="100%">
									<thead>
									<tr>
										<th width="5">#</th>
										<th width="120">ปีการศึกษา</th>
										<th><center>สถานะ</center></th>
										<th width="50">ลบ</th>
									</tr>
									</thead>
									<tbody>
<?php
$sql= $mysqli->query("SELECT * FROM setting_year ORDER BY Id DESC");
$i = 0;
while($row=mysqli_fetch_array($sql)) {
	$Id=$row['Id'];
	$year=$row['year'];
	$active=$row['active'];
$i++;
?>
						<tr>
							<td align='center'><?php echo $i;?></td>			
							<td align="center"><?php echo $year;?></td>
							<td align="center">
	<?php if($active=="yes") { ?>						
	<a role="button" href="#" class="btn btn-primary btn-sm" data-toggle="modal" data-target="#modal_statusyear<?php echo $Id;?>"><span class="btn-label"><i class="fa fa-check"></i></span>Active</a>
	<?php include ("modals/modal_statusyear.php");?> 
	<?php }else{ ?>
	<a role="button" href="#" class="btn btn-danger btn-sm" data-toggle="modal" data-target="#modal_statusyear<?php echo $Id;?>"><span class="btn-label"><i class="fa fa-times"></i></span>Cancel</a>
	<?php include ("modals/modal_statusyear.php");?> 
	<?php } ?>
							</td>
							<td align='center'>
								<a href="#" class="btn btn-danger btn-sm" data-toggle="modal" data-target="#modal_delete<?php echo $Id;?>"><i class="fa fa-trash-o" aria-hidden="true"></i></a>
								<?php include ("modals/modal_delete_year.php");?> 
							</td>
						</tr>
                    <?php 
					} // end while
					?>
									</tbody>
								</table>
								</div>	
								
							</div>														
						</div><!-- end card-->					
                    </div>
					

			</div>