| Server IP : 172.67.187.206 / Your IP : 172.71.28.155 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : E:/Inetpub/www/news/csr/main/pages/ |
Upload File : |
<?php
include "../config.php";
// เชคปีที่จะแสดงข้อมูล
if(isset($_SESSION['iyear'])){
$iyear =$_SESSION['iyear'];
}else {
$iyear=date("Y")+543;
}
if(isset($_SESSION['templates'])){
$templates =$_SESSION['templates'];
}else {
$templates="success";
}
$sql1= $mysqli->query("SELECT * FROM log_school ");
$totalschool=mysqli_num_rows($sql1);
$sql2= $mysqli->query("SELECT * FROM log_area ");
$totalarea=mysqli_num_rows($sql2);
$sql3= $mysqli->query("SELECT * FROM log_area WHERE `sta`='3'");
$total3=mysqli_num_rows($sql3);
$sql4= $mysqli->query("SELECT * FROM log_area WHERE `sta`='2'");
$total4=mysqli_num_rows($sql4);
$sql5= $mysqli->query("SELECT * FROM log_area WHERE `sta`='1'");
$total5=mysqli_num_rows($sql5);
$sql6= $mysqli->query("SELECT * FROM tb_requirements WHERE `year`='$iyear' AND `r_donate` IS NULL");
$total6=mysqli_num_rows($sql6);
$sql7= $mysqli->query("SELECT * FROM tb_donated WHERE `u_year`='$iyear'");
$total7=mysqli_num_rows($sql7);
?>
<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>
<link href="https://fonts.googleapis.com/css?family=Prompt" rel="stylesheet">
<style>
body {
font-family: 'Prompt', sans-serif;
}
h1, h2, h3, h4, h5, h6, .h1, .h2, .h3, .h4, .h5, .h6 {
font-family: 'Prompt', sans-serif;
}
</style>
<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",
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> <!--
<script type="text/javascript" language="javascript" >
$(document).ready(function() {
var dataTable = $('#datatable2').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/fetchreq.php", // json datasource
type: "post", // method , by default get
error: function(){ // error handling
$(".datatable2-error").html("");
$("#datatable2").append('<tbody class="datatable2-error"><tr><th colspan="3">ไม่พบข้อมูลในฐานข้อมูล</th></tr></tbody>');
$("#datatable2_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-xs-12 col-md-6 col-lg-6 col-xl-3">
<div class="card-box noradius noborder bg-success">
<i class="fa fa-cube float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20"><p>บริจาคแล้ว</p> </h6>
<h1 class="m-b-20 text-white counter"><p><?=$total7;?></p> </h1>
<span class="text-white"><Font size="2"> รายการ</font></span>
</div>
</div>
<div class="col-xs-12 col-md-6 col-lg-6 col-xl-3">
<div class="card-box noradius noborder bg-warning">
<i class="fa fa-handshake-o float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20"><p>ขอรับบริจาค</p></h6>
<h1 class="m-b-20 text-white counter"><p><?=$total6;?></p></h1>
<span class="text-white"><Font size="2"> รายการ </font></span>
</div>
</div>
<div class="col-xs-12 col-md-6 col-lg-6 col-xl-3">
<div class="card-box noradius noborder bg-info">
<i class="fa fa-building-o float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20"><p>เขตพื้นที่ทั้งหมด</p></h6>
<h1 class="m-b-20 text-white counter"><p><?php echo number_format("$totalarea"); ?></p></h1>
<span class="text-white"> <Font size="2"> สพม.<?=$total4;?> สพป.<?=$total5;?> สศศ.<?=$total3;?></font></span>
</div>
</div>
<div class="col-xs-12 col-md-6 col-lg-6 col-xl-3">
<div class="card-box noradius noborder bg-danger">
<i class="fa fa-graduation-cap float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20"><p>โรงเรียนทั้งหมด</p></h6>
<h1 class="m-b-20 text-white counter"><p><?php echo number_format("$totalschool"); ?></p></h1>
<span class="text-white"><Font size="2"> โรงเรียน </font></span>
</div>
</div>
</div>
<div class="row">
<table id="datatable1" data-page-length="10" class="table table-bordered table-hover display" cellspacing="0" width="100%">
<thead>
<tr>
<th colspan="2"></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>
</tr>
</thead>
</table>
</div>
<br>
<div class="row">
<div class="col-xs-12 col-sm-12 col-md-12 col-lg-3 col-xl-3">
<div class="card text-white bg-warning mb-3" style="max-width: 18rem;">
<div class="card-header">ผู้ใช้งานระบบ</div>
<div class="card-body">
<h5 class="card-title">Warning card title</h5>
<p class="card-text">Some quick example text to build on the card title and make up the bulk of the card's content.</p>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12 col-lg-6 col-xl-9">
<div class="card mb-3">
<div class="card-header">
<i class="fa fa-table"></i> <b>ความต้องการขอรับบริจาค</b>
</div><br>
<!-- ส่วนของฟอร์มข้อมูล-->
<table id="datatable2" data-page-length="10" class="table table-bordered table-hover display" cellspacing="0" width="100%">
<thead>
<tr>
<th width="50">ที่</th>
<th>ความต้องการ</th>
</tr>
</thead>
</table>
<!-- สจบ่วนของฟอร์มข้อมูล-->
</div><!-- end card-->
</div>
</div>