<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">school</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_csv')
				echo '<div class="alert alert-danger" role="alert">Error! Input valid username</div>';	
		if ($msg =='error_import')
				echo '<div class="alert alert-danger" role="alert">Error! Input valid Data</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">ลบข้อมูลเรียบร้อย</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="#" data-toggle="modal" data-target="#modal_importsesao<?=$logged_username;?>" button class="btn btn-success m-l-5 btn-sm"><i class="fa fa-file-excel-o" aria-hidden="true"></i> นำเข้า</button></a>
							<?php include ("modals/modal_importsesao.php");?> 
							<a href="Export/Export_sesao.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=sesaoreport&status=1&op1=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">
								<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>
										</tr>
									</thead>
									<tbody>
<?php
$sql= $mysqli->query("SELECT * FROM `users` WHERE `role_id` = '2' ") or die ( $mysqli->error );
$i = 0;
while($row=mysqli_fetch_array($sql)) {
$i++;
?>									
										<tr>
											<td align="center" width="50"><?=$i;?></td>
											<td align="center" width="80"><?=$row['username'];?></td>
											<td><?=$row['name'];?></td>
											<td  width="150" align="center">
<?php
$sql1sc= $mysqli->query("SELECT * FROM users where `role_id`='3' AND `gset`='$row[username]' ");
$total1sc=mysqli_num_rows($sql1sc);
echo number_format("$total1sc");
?>											
											</td>
											<td align="center" width="120">
											<a href="report/sescoschool.php?idcard=<?=$row['username'];?>" target="_blank" class="btn btn-outline-info btn-sm"><i class="fa fa-print" aria-hidden="true"></i></a>
											<a href="#" data-toggle="modal" data-target="#modal_editsesao<?=$row['user_id'];?>" class="btn btn-outline-success btn-sm"><i class="fa fa-pencil-square-o" aria-hidden="true"></i></a>
											<?php include ("modals/modal_editsesao.php");?> 
											<a  href="#" data-toggle="modal" data-target="#modal_delete_sesao<?=$row['user_id'];?>" class="btn btn-outline-danger btn-sm"><i class="fa fa-trash-o" aria-hidden="true"></i></a>
											<?php include ("modals/modal_delete_sesao.php");?> 
											</td>
										</tr>
<?php } ?>										
									</tbody>
								</table>
								</div>
								
							</div>														
						</div><!-- end card-->					
                    </div>
					

			</div>