<?php
if(isset($ugroup)){
$SQLb = $mysqli->query("SELECT * FROM setting_year WHERE `y_id` ='1'");
$Rowb = mysqli_fetch_array($SQLb);
$year=$Rowb['set_year'];	
?>
	<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="<?php echo ADMIN_URL;?>/assets/plugins/datetimepicker/js/moment.min.js"></script>
	<script src="<?php echo ADMIN_URL;?>/assets/plugins/datetimepicker/js/daterangepicker.js"></script>
	<link href="<?php echo ADMIN_URL;?>/assets/plugins/datetimepicker/css/daterangepicker.css" rel="stylesheet" /> 	
	<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, "ASC"]],
					"columnDefs": [ {
						  "targets": 0,
						  "orderable": false,
						  "searchable": false
						   
						} ],
					"ajax":{
						url :"pages/fetchredonate.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"><i class="fa fa-university"></i><?=$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 
// Msg แจ้งเตือนการทำงาน
if(isset($_GET['msg'])){ ?>
<script type="text/javascript">
    $(window).on('load',function(){
        $('#msgAlert').modal('show');
    });
</script>
<?php } else {} ?>	
<?php  include ("pages/modals/modal_msg.php");?>



	
	<div class="row">
			
        <div class="col-lg-12">						
			<div class="card mb-3">
				<div class="card-header">
				<span class="pull-right">
				<a href="#" data-toggle="modal" data-target="#modal_vdate">
					<button class="btn btn-info btn-sm"><i class="fa fa-calendar" aria-hidden="true"></i> เลือกปี พ.ศ.</button>
				</a>
				<?php include ("modals/modal_vdate.php");?>
				<a href="report/areaall.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> ข้อมูลการบริจาคปี พ.ศ. <?=$year;?> </h3>
				</div>
								
					<div class="card-body">
						<!-- ส่วนของฟอร์มข้อมูล-->
<?php 
//เผื่อไว้แสดงข้อมูลปีปัจจุบัน
$setyear=date("Y")+543; 

?>					
			<table id="datatable1" data-page-length="25" class="table table-bordered table-hover display" cellspacing="0" width="100%">
				<thead>
  <tr>
    <th colspan="3"></th>
    <th colspan="2"><center>ในสำนักงานเขต</center></th>
    <th colspan="2"><center>โรงเรียนในเขต</center></th>
    <th rowspan="2">จำนวน ร.ร.</th>
  </tr>
  <tr>
    <th>ที่</th>
    <th>รหัสเขต</th>
    <th>ชื่อเขตพื้นที่</th>
    <th>ขอบริจาค</th>
    <th>บริจาคแล้ว</th>
    <th>ขอบริจาค</th>
    <th>บริจาคแล้ว</th>
  </tr>
				</thead>
			</table>



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

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


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