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

    <!-- 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 src="bootstrap/js/bootstrap.min.js"></script>



		<script type="text/javascript" language="javascript" >
			$(document).ready(function() {
				var dataTable = $('#datatable1').DataTable( {
					"processing": true,
					"serverSide": true,
					"pageLength": 10,
					"pagingType": "full_numbers",    
					"ordering": true,
					"order": [[0, "desc"]],
					"columnDefs": [ {
						  "targets": 0,
						  "orderable": false,
						  "searchable": false
						   
						} ],
					"ajax":{
						url :"pages/fetchallschool.php", // json datasource
						type: "post",  // method  , by default get
						error: function(){  // error handling
							$(".datatable1-error").html("");
							$("#datatable1").append('<tbody class="datatable1-error"><tr><th colspan="3">ไม่พบข้อมูลในฐานข้อมูล</th></tr></tbody>');
							$("#datatable1_processing").css("display","none");
							
						}
					}
				} );
				
				
				$("#bulkDelete").on('click',function() { // bulk checked
					var status = this.checked;
					$(".deleteRow").each( function() {
						$(this).prop("checked",status);
					});
				});
				
				$('#deleteTriger').on("click", function(event){ // triggering delete one by one
					if( $('.deleteRow:checked').length > 0 ){  // at-least one checkbox checked
						var ids = [];
						$('.deleteRow').each(function(){
							if($(this).is(':checked')) { 
								ids.push($(this).val());
							}
						});
						var ids_string = ids.toString();  // array to string conversion 
						$.ajax({
							type: "POST",
							url: "delete-all.php",
							data: {data_ids:ids_string},
							success: function(result) {
								dataTable.draw(); // redrawing datatable
							},
							async:false
						});
					}
				});	
			} );
		</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"><?=$ugroup;?></li>
                    </ol>
                    <div class="clearfix"></div>
            </div>
		</div>
	</div>
	

	<div class="row">
			
        <div class="col-lg-12">						
			<div class="card mb-3">
				<div class="card-header">
				<span class="pull-right">
				<a href="report/schoolall.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="datatable1" data-page-length="25" class="table table-bordered table-hover display" cellspacing="0" width="100%">
					<thead>
						<tr>
							<th width="60"><center>ที่</center></th>
							<th width="100"><center>รหัส</center></th>
							<th><center>ชื่อโรงเรียน</center></th>
							<th><center>ที่อยู่</center></th>
							<th width="60">นักเรียน</th>
							<th width="40">ครู</th>
							<th><center>เลขผู้เสียภาษี</center></th>
						</tr>
					</thead>
			</table>


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

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


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