<?php
if(isset($ugroup)){
	
?>


	<div class="row">
		<div class="col-xl-12">
			<div class="breadcrumb-holder">
				<h1 class="main-title float-left"><?=$fullname;?></h1>
					<ol class="breadcrumb float-right">
					<li class="breadcrumb-item">Home</li>
					<li class="breadcrumb-item active"><?=$ugroup;?></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>
	<link rel="stylesheet" href="<?php echo ADMIN_URL;?>/assets/css/bootstrap-select.css">
	<script src="<?php echo ADMIN_URL;?>/assets/js/bootstrap-select.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-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="report/schoolarea.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>
				</span>							
				<h3><i class="fa fa-table"></i> ข้อมูลโรงเรียนในสังกัด</h3>
				</div>
								
					<div class="card-body">
						
						<!-- ส่วนของฟอร์มข้อมูล-->
							
								<table id="example1" data-page-length="25" class="table table-bordered table-hover display" cellspacing="0" width="100%">
									<thead>
									<tr>
										<th width="40">ที่</th>
										<th width="100">รหัส</th>
										<th width="300">ชื่อโรงเรียน</th>
										<th>ที่อยู่</th>
										<th width="80">นักเรียน</th>
										<th width="200">ชื่อผู้อำนวยการ</th>

									</tr>
									</thead>
									<tbody>

									
<?php 
$sqls= $mysqli->query("SELECT * FROM log_school WHERE `areacode`='$user' ");
$i = 0;
while($rows=mysqli_fetch_array($sqls)) {
$i++;
$schoolcode=$rows['username'];
?>
<?php
	//API ข้อมูลโรงเรียน
	$url_ad = ''.$api_url.'/api/school_obj.php?csid='.$schoolcode;
	$datdd = file_get_contents($url_ad);
	$datdd = json_decode($datdd);
?>									
									<tr>
										<td align="center"><?=$i;?></td>
										<td align="center"><?=$rows['username'];?></td>
										<td>&nbsp;<?=$rows['fullname'];?></td>
										<td>&nbsp;ต.<?php echo $datdd->subdistrict; ?> อ.<?php echo $datdd->district; ?> จ.<?php echo $datdd->province; ?> </td>
										<td align="center"><?php echo number_format($datdd->students); ?></td>
										<td></td>
									</tr>
	<? } ?>										
									</tbody>
									</table>
									



						<!-- สจบ่วนของฟอร์มข้อมูล-->

								
					</div>														
			</div><!-- end card-->					
        </div>
					


	</div>
<?php }else{
header("Location: ../index.php?msg=error");
exit;	
} ?>