| 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 -->
<?
if(isset($_SESSION['ugroup'])){
$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
//รหัสเขตพื้นที่ 8 หลัก
$mapid = substr("$user", +2);
?>
<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>
<div class="row">
<div class="col-xl-12">
<div class="breadcrumb-holder">
<h1 class="main-title float-left"><i class="fa fa-university"></i> <?=$userfullname;?></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
$sql= $mysqli->query("SELECT * FROM log_school WHERE `areacode`='$user' ");
$Tschool=mysqli_num_rows($sql);
?>
<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-building float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20">โรงเรียน</h6>
<h1 class="m-b-20 text-white counter"><?=$Tschool;?></h1>
<span class="text-white"><?=$Tschool;?> โรงเรียนในสังกัด </span>
</div>
</div>
<?php
$sqlo1= $mysqli->query("SELECT * FROM tb_requirements WHERE rcode='$user' AND `r_donate` IS NULL");
$T1=mysqli_num_rows($sqlo1);
$sqls1= $mysqli->query("SELECT * FROM `tb_requirements` INNER JOIN `log_school` ON `tb_requirements`.`rcode` = `log_school`.`username` WHERE `areacode`='$user' ");
$Ts1=mysqli_num_rows($sqls1);
$tall1=($T1+$Ts1);
?>
<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-cube float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20">คำขอรับบริจาค</h6>
<h1 class="m-b-20 text-white counter"><?=$T1;?></h1>
<span class="text-white"><?=$tall1;?> เขต/โรงเรียน</span>
</div>
</div>
<?php
$sqlo2= $mysqli->query("SELECT * FROM tb_donated WHERE `u_scid`='$user' AND `u_del`='0'");
$T2=mysqli_num_rows($sqlo2);
$sqls2= $mysqli->query("SELECT * FROM `tb_donated` INNER JOIN `log_school` ON `tb_donated`.`u_scid` = `log_school`.`username` where areacode='$user'");
$Ts2=mysqli_num_rows($sqls2);
$tall2=($T2+$Ts2);
?>
<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-handshake-o float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20">การบริจาค</h6>
<h1 class="m-b-20 text-white counter"><?=$T2;?></h1>
<span class="text-white"> <?=$tall2;?> เขต/โรงเรียน</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-bell-o float-right text-white"></i>
<h6 class="text-white text-uppercase m-b-20">Alerts</h6>
<h1 class="m-b-20 text-white counter">58</h1>
<span class="text-white">5 New Alerts</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> แผนที่โรงเรียนในสังกัด<?=$fullname;?> </h3>
</div>
<div class="card-body">
<div id="map"></div>
<script>
var cities = L.layerGroup();
<?php
//API ข้อมูลโรงเรียน
$urlx = ''.$api_url.'/api/area_obj.php?aid='.$mapid;
$data1 = file_get_contents($urlx);
$data1 = json_decode($data1);
foreach($data1 as $member){
?>
L.marker([<?php echo $member->latitude; ?>, <?php echo $member->longitude; ?>]).bindPopup('โรงเรียน<?php echo $member->schoolName; ?><br> <a target=_blank href=https://www.google.com/maps?q=<?php echo $member->latitude; ?>,<?php echo $member->longitude; ?>>เส้นทาง</a>').addTo(cities);
<?php } ?>
var mbAttr = 'ฐานข้อมูล CSR © <a href="#">แผนที่โรงเรียนในสังกัด</a> contributors, ' +
'<a href="#">Big Data</a> สพฐ., ' +
'Imagery © <a href="#">Mapbox</a>',
mbUrl = 'https://api.mapbox.com/styles/v1/{id}/tiles/{z}/{x}/{y}?access_token=pk.eyJ1IjoibWFwYm94IiwiYSI6ImNpejY4NXVycTA2emYycXBndHRqcmZ3N3gifQ.rJcFIG214AriISLbB6B5aw';
var grayscale = L.tileLayer(mbUrl, {id: 'mapbox/light-v9', tileSize: 512, zoomOffset: -1, attribution: mbAttr}),
streets = L.tileLayer(mbUrl, {id: 'mapbox/streets-v11', tileSize: 512, zoomOffset: -1, attribution: mbAttr});
<?php
//API กำหนดพิกัดแรกแสดงแผนที่
$url_ad = ''.$api_url.'/api/area_obj.php?aid='.$mapid;
$datdd = file_get_contents($url_ad);
$datdd = json_decode($datdd);
?>
var map = L.map('map', {
center: [<?php echo $datdd[3]->latitude; ?>, <?php echo $datdd[3]->longitude; ?>],
zoom: 10,
layers: [grayscale, cities]
});
var baseLayers = {
"Grayscale": grayscale,
"Streets": streets
};
var overlays = {
"Cities": cities
};
L.control.layers(baseLayers, overlays).addTo(map);
</script>
</div>
<div class="card-footer small text-muted"> </div>
</div><!-- end card-->
</div>
</div>
<?php } else {
header("Location: ../index.php?msg=error");
exit;
} ?>