<?php
$SQL1 = $mysqli->query("SELECT * FROM users WHERE username ='$logged_username'");
$Row1 = mysqli_fetch_array($SQL1);
$school = $Row1['gset'];
$SQL2 = $mysqli->query("SELECT * FROM setting_year WHERE `active` ='yes'");
$Row2 = mysqli_fetch_array($SQL2);
$year = $Row2['year'];
?>
	<div class="row">
		<div class="col-xl-12">
			<div class="breadcrumb-holder">
				<h1 class="main-title float-left">ข้อมูลการสมัครเรียน ประจำปีการศึกษา <?=$year;?> </h1>
					<ol class="breadcrumb float-right">
					<li class="breadcrumb-item">Home</li>
					<li class="breadcrumb-item active">Blank Page</li>
                    </ol>
                    <div class="clearfix"></div>
            </div>
		</div>
	</div>
	<?php		
		if ($msg =='error_name')
				echo '<div class="alert alert-danger" role="alert">Error! พบข้อมูลซ้ำในระบบ ไม่สามารถเพิ่มข้อมูลได้</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">เพิ่มข้อมูลเรียบร้อย</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>';	
	?>	
    <!-- end row -->
	<link rel="stylesheet" type="text/css" href="<?php echo ADMIN_URL;?>/assets/plugins/datatables/dataTables.bootstrap4.min.css"/>
	<script type="text/javascript" src="<?php echo ADMIN_URL;?>/assets/plugins/datatables/jquery.dataTables.min.js"></script>
	<script type="text/javascript" src="<?php echo ADMIN_URL;?>/assets/plugins/datatables/dataTables.bootstrap4.min.js"></script>

	<script>
	// START CODE FOR BASIC DATA TABLE 
	$(document).ready(function() {
		$('#example1').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-xs-12 col-sm-12 col-md-12 col-lg-6 col-xl-12">						
						<div class="card mb-3">
							<div class="card-header">
							<span class="pull-right">
							<a href="Export/Export_student.php"><button class="btn btn-success m-l-5 btn-sm"><i class="fa fa-file-excel-o" aria-hidden="true"></i> ส่งออก</button></a>
							<a href="account.php?page=studentreport&op4=1"><button class="btn btn-secondary m-l-5 btn-sm"><i class="fa fa-print" aria-hidden="true"></i> พิมพ์ข้อมูล</button></a>
							<a href="account.php?page=student_regis&op4=1"><button class="btn btn-primary btn-sm"><i class="fa fa-user-plus" aria-hidden="true"></i> เพิ่มข้อมูล</button></a>
							</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>ที่</th>
											<th>บัตรประชาชน</th>
											<th>ชื่อ-นามสกุล</th>
											<th>วัน/เดือน/ปีเกิด</th>
											<th>สมัครเรียนชั้น</th>
											<th>ที่อยู่</th>
											<th></th>
										</tr>
									</thead>
									<tbody>
<?php
$sql= $mysqli->query("SELECT * FROM `read_data` INNER JOIN `student_regis` ON `student_regis`.`r_idcard` = `read_data`.`cid` where status='stu' AND r_year='$year' AND sc='$school' ");
$i = 0;
while($row=mysqli_fetch_array($sql)) {
$i++;
?>									
										<tr>
											<td align="center"><?=$i;?></td>
											<td align="center" width="130"><?=$row['cid'];?></td>
											<td><?=$row['thnamep'];?><?=$row['thnamef'];?> <?=$row['thnamel'];?></td>
											<td align="center"><?=$row['dday'];?>/<?=$row['mday'];?>/<?=$row['yday'];?></td>
											<td align="center"><?=$row['r_class'];?></td>
											<td><?=$row['addressn'];?> <?=$row['addressm'];?> <?=$row['addresst'];?> <?=$row['addressa'];?> <?=$row['addressp'];?></td>
											<td align="center" width="100">
											<a href="report/studentregis.php?idcard=<?=$row['cid'];?>" target="_blank" class="btn btn-outline-info btn-sm"><i class="fa fa-print" aria-hidden="true"></i></a>
											<a href="#" class="btn btn-outline-danger btn-sm" data-toggle="modal" data-target="#modal_delete476"><i class="fa fa-trash-o" aria-hidden="true"></i></a>
											</td>
										</tr>
<?php } ?>										
									</tbody>
								</table>
								</div>
								
							</div>														
						</div><!-- end card-->					
                    </div>
					

			</div>