| 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 : /Inetpub/www/news/csr/admin/pages/ |
Upload File : |
<!-- Javascript and CSS for this page -->
<?php
if(isset($_SESSION['ugroup'])){
?>
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.4.0/Chart.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.16/css/dataTables.bootstrap4.min.css"/>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.16/js/dataTables.bootstrap4.min.js"></script>
<!-- Counter-Up-->
<script src="<?php echo ADMIN_URL;?>/assets/plugins/waypoints/lib/jquery.waypoints.min.js"></script>
<script src="<?php echo ADMIN_URL;?>/assets/plugins/counterup/jquery.counterup.min.js"></script>
<link
rel="stylesheet"
href="https://unpkg.com/[email protected]/dist/leaflet.css"
integrity="sha512-xwE/Az9zrjBIphAcBb3F6JVqxf46+CDLwfLMHloNu6KEQCAWi6HcDUbeOfBIptF7tcCzusKFjFw2yuvEpDL9wQ=="
crossorigin=""
/>
<script
src="https://unpkg.com/[email protected]/dist/leaflet.js"
integrity="sha512-gZwIG9x3wUXg2hdXF6+rVkLF/0Vi9U8D2Ntg4Ga5I5BZpVkVxlJWbSQtXPSiUTtC0TjtGOmxa1AJPuV0CPthew=="
crossorigin=""
></script>
<style>
#map {
width: 100%;
height:350px;
}
</style>
<script>
// START CODE FOR BASIC DATA TABLE
$(document).ready(function() {
// data-tables
$('#example1').DataTable();
// counter-up
$('.counter').counterUp({
delay: 10,
time: 600
});
} );
// END CODE FOR BASIC DATA TABLE
</script>
<?
$user=$_SESSION["loguser"];
$ugroup=$_SESSION["ugroup"];
if($ugroup=="obec"){
$Gtb="log_obec";
}else if($ugroup=="area"){
$Gtb="log_area";
}else if($ugroup=="school"){
$Gtb="log_school";
}else if($ugroup=="donate"){
$Gtb="log_donate";
}
$SQL1 = $mysqli->query("SELECT * FROM $Gtb WHERE `username` ='$user' ");
$Row1 = mysqli_fetch_array($SQL1);
$userfullname=$Row1['fullname'];
$idpayment=$Row1['idpayment'];
?>
<?php
//API ข้อมูลโรงเรียน
$url_sc = ''.$api_url.'/api/school.php?csid='.$user;
$datax = file_get_contents($url_sc);
$datax = json_decode($datax);
?>
<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"><font color="#2eb82e"><b> เลขผู้เสียภาษี : <?=$idpayment;?></b> </font>
<li class="breadcrumb-item">Home</li>
<li class="breadcrumb-item active">Dashboard</li>
</ol>
<div class="clearfix"></div>
</div>
</div>
</div>
<!-- end row -->
<?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");?>
<?php
// API ข้อมูลบุคลากร
$url = ''.$api_url.'/api/teacher.php?csid='.$user;
$data = json_decode(file_get_contents($url));
//นับจำนวนแถวข้อมูล JSON
$teacher_all=count($data,1);
?>
<div class="row">
<div class="col-xs-12 col-md-6 col-lg-6 col-xl-3">
<div class="card-box noradius noborder bg-default">
<i class="fa fa-file-text-o float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20">จำนวนนักเรียน</h6>
<h1 class="m-b-20 text-white counter"><?php echo number_format($datax->students); ?></h1>
<span class="text-white">นักเรียนทั้งหมด</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-bar-chart float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20">จำนวนครู</h6>
<h1 class="m-b-20 text-white counter"><?=number_format($teacher_all);?></h1>
<span class="text-white">ทั้งหมด</span>
</div>
</div>
<?php
$sqlo1= $mysqli->query("SELECT * FROM tb_requirements WHERE rcode='$user' AND `r_donate` IS NULL");
$T1=mysqli_num_rows($sqlo1);
?>
<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-user-o float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20">ขอบริจาค</h6>
<h1 class="m-b-20 text-white counter"><?=number_format($T1);?></h1>
<span class="text-white">คำขอทั้งหมด</span>
</div>
</div>
<?php
$sqlo2= $mysqli->query("SELECT * FROM tb_donated WHERE `u_scid`='$user' AND `u_del`='0'");
$T2=mysqli_num_rows($sqlo2);
?>
<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-bell-o float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20">บริจาค</h6>
<h1 class="m-b-20 text-white counter"><?=number_format($T2);?></h1>
<span class="text-white"><?=$T2;?> รายการบริจาค</span>
</div>
</div>
</div>
<!-- end row -->
<div class="row">
<div class="col-xs-12 col-sm-12 col-md-12 col-lg-12 col-xl-6">
<div class="card mb-3">
<div class="card-header">
<h3><i class="fa fa-line-chart"></i> Items Sold Amount</h3>
Items sold in latest 12 months.
</div>
<div class="card-body">
<canvas id="lineChart"></canvas>
</div>
<div class="card-footer small text-muted">Updated yesterday at 11:59 PM</div>
</div><!-- end card-->
</div>
<div class="col-xs-12 col-sm-12 col-md-6 col-lg-6 col-xl-3">
<div class="card mb-3">
<div class="card-header">
<h3><i class="fa fa-bar-chart-o"></i> Colour Analytics</h3>
</div>
<div class="card-body">
<canvas id="pieChart"></canvas>
</div>
<div class="card-footer small text-muted">Updated yesterday at 11:59 PM</div>
</div><!-- end card-->
</div>
<div class="col-xs-12 col-sm-12 col-md-6 col-lg-6 col-xl-3">
<div class="card mb-3">
<div class="card-header">
<h3><i class="fa fa-bar-chart-o"></i> Colour Analytics 2</h3>
</div>
<div class="card-body">
<canvas id="doughnutChart"></canvas>
</div>
<div class="card-footer small text-muted">Updated yesterday at 11:59 PM</div>
</div><!-- end card-->
</div>
</div>
<!-- end row -->
<script>
var ctx1 = document.getElementById("lineChart").getContext('2d');
var lineChart = new Chart(ctx1, {
type: 'bar',
data: {
labels: ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"],
datasets: [{
label: 'Dataset 1',
backgroundColor: '#3EB9DC',
data: [10, 14, 6, 7, 13, 9, 13, 16, 11, 8, 12, 9]
}, {
label: 'Dataset 2',
backgroundColor: '#EBEFF3',
data: [12, 14, 6, 7, 13, 6, 13, 16, 10, 8, 11, 12]
}]
},
options: {
tooltips: {
mode: 'index',
intersect: false
},
responsive: true,
scales: {
xAxes: [{
stacked: true,
}],
yAxes: [{
stacked: true
}]
}
}
});
var ctx2 = document.getElementById("pieChart").getContext('2d');
var pieChart = new Chart(ctx2, {
type: 'pie',
data: {
datasets: [{
data: [12, 19, 3, 5, 2, 3],
backgroundColor: [
'rgba(255,99,132,1)',
'rgba(54, 162, 235, 1)',
'rgba(255, 206, 86, 1)',
'rgba(75, 192, 192, 1)',
'rgba(153, 102, 255, 1)',
'rgba(255, 159, 64, 1)'
],
label: 'Dataset 1'
}],
labels: [
"Red",
"Orange",
"Yellow",
"Green",
"Blue"
]
},
options: {
responsive: true
}
});
var ctx3 = document.getElementById("doughnutChart").getContext('2d');
var doughnutChart = new Chart(ctx3, {
type: 'doughnut',
data: {
datasets: [{
data: [12, 19, 3, 5, 2, 3],
backgroundColor: [
'rgba(255,99,132,1)',
'rgba(54, 162, 235, 1)',
'rgba(255, 206, 86, 1)',
'rgba(75, 192, 192, 1)',
'rgba(153, 102, 255, 1)',
'rgba(255, 159, 64, 1)'
],
label: 'Dataset 1'
}],
labels: [
"Red",
"Orange",
"Yellow",
"Green",
"Blue"
]
},
options: {
responsive: true
}
});
</script>
<div class="row">
<div class="col-xs-12 col-sm-12 ">
<div class="card mb-3">
<div class="card-header">
<h3><i class="fa fa-line-chart"></i> แผนที่โรงเรียน<?php echo $datax->schoolName; ?></h3>
</div>
<div class="card-body">
<div id="map"></div>
<script>
var map = L.map('map', {scrollWheelZoom:false}).setView([<?php echo $datax->latitude; ?>,<?php echo $datax->longitude; ?>], 11);
L.tileLayer('https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', {
attribution: '© <a href="#">Big Data สพฐ. </a> แผนที่โรงเรียน<?php echo $datax->schoolName; ?> อำเภอ<?php echo $datax->district; ?> จังหวัด<?php echo $datax->province; ?>'
}).addTo(map);
var marker = L.marker([<?php echo $datax->latitude; ?>,<?php echo $datax->longitude; ?>]).bindPopup('พิกัด : <?php echo $datax->latitude; ?>,<?php echo $datax->longitude; ?><br> <a target=_blank href=https://www.google.com/maps?q=<?php echo $datax->latitude; ?>,<?php echo $datax->longitude; ?>>เส้นทาง</a>').addTo(map);
</script>
</div>
<div class="card-footer small text-muted">โรงเรียน<?php echo $datax->schoolName; ?> ตำบล<?php echo $datax->subdistrict; ?> อำเภอ<?php echo $datax->district; ?> จังหวัด<?php echo $datax->province; ?> สังกัด <?php echo $datax->areaName; ?> </div>
</div><!-- end card-->
</div>
</div>
<?php } else {
header("Location: ../index.php?msg=error");
exit;
} ?>