| Server IP : 202.29.229.35 / Your IP : 18.119.120.88 Web Server : Apache System : Linux aapanel2 4.15.0-213-generic #224-Ubuntu SMP Mon Jun 19 13:30:12 UTC 2023 x86_64 User : www ( 1001) PHP Version : 5.5.38 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /www/wwwroot/www.ivecr2.ac.th/stdcard/ |
Upload File : |
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<script src="http://code.highcharts.com/highcharts.js"></script>
<script src="http://code.highcharts.com/modules/exporting.js"></script>
<?php
require_once("connect/connect.php");
$query = mysql_query("SELECT DISTINCT DATE( DATETIME ) AS SDATE
FROM log_print_card
ORDER BY DATETIME ASC ");
while($data = mysql_fetch_assoc($query)){
$date[] = $data['SDATE'];
$arry_date[$data['SDATE']] = 0;
}
$stdsum = $arry_date;
$query = mysql_query("SELECT DATE( DATETIME ) AS SDATE, COUNT( `student_id` ) AS COUNT
FROM `log_print_card`
WHERE LENGTH( `student_id` ) =10
AND `student_id` LIKE '58%'
GROUP BY DATE( DATETIME )");
while($data = mysql_fetch_assoc($query)){
$stdsum[$data['SDATE']] = $data['COUNT'];
}
$std1 = $arry_date;
$query = mysql_query("SELECT DATE( DATETIME ) AS SDATE, COUNT( `student_id` ) AS COUNT
FROM `log_print_card`
WHERE LENGTH( `student_id` ) =10
AND `student_id` LIKE '582%'
GROUP BY DATE( DATETIME )");
while($data = mysql_fetch_assoc($query)){
$std1[$data['SDATE']] = $data['COUNT'];
}
$std2 = $arry_date;
$query = mysql_query("SELECT DATE( DATETIME ) AS SDATE, COUNT( `student_id` ) AS COUNT
FROM `log_print_card`
WHERE LENGTH( `student_id` ) =10
AND `student_id` LIKE '583%'
GROUP BY DATE( DATETIME )");
while($data = mysql_fetch_assoc($query)){
$std2[$data['SDATE']] = $data['COUNT'];
}
?>
<script>
$(function () {
$('#container').highcharts({
title: {
text: 'รายงานสรุปการทำบัตรใหม่',
x: -20 //center
},
subtitle: {
text: 'จำนวนนักเรียนที่ทำบัตรใหม่',
x: -20
},
xAxis: {
categories: [<?php echo "'".implode("','",$date)."'";?>]
},
yAxis: {
title: {
text: 'คน'
},
plotLines: [{
value: 0,
width: 1,
color: '#808080'
}]
},
tooltip: {
valueSuffix: 'คน'
},
legend: {
layout: 'vertical',
align: 'right',
verticalAlign: 'middle',
borderWidth: 0
},
series: [{
name: 'Sum',
data: [<?php echo implode(",",$stdsum);?>]
}, {
name: 'ปวช',
data: [<?php echo implode(",",$std1);?>]
}, {
name: 'ปวส',
data: [<?php echo implode(",",$std2);?>]
}, ]
});
});
</script>
</head>
<body>
<div id="container" style="width: 810px; height: 400px; margin: 0 auto"></div>
<hr color="#000000" width="100%">
<?php
$query = mysql_query("SELECT COUNT(*) AS COUNT FROM `tblstd_idcard`
WHERE student_id LIKE '58%'");
$data = mysql_fetch_assoc($query);
?>
<p>รวมนักศึกษาปี 58 ||<?php echo number_format($data['COUNT']);?> คน</p>
<?php
$query = mysql_query("SELECT COUNT(*) AS COUNT FROM `tblstd_idcard`
WHERE student_id LIKE '583%'");
$data = mysql_fetch_assoc($query);
?>
<p>รวมนักศึกษาปี 58 ปวส || <?php echo number_format($data['COUNT']);?> คน</p>
<?php
$query = mysql_query("SELECT COUNT(*) AS COUNT FROM `tblstd_idcard`
WHERE student_id LIKE '582%'");
$data = mysql_fetch_assoc($query);
?>
<p>รวมนักศึกษาปี 58 ปวช || <?php echo number_format($data['COUNT']);?> คน</p>
<hr color="#FF0000" width="100%">
<?php
$query = mysql_query("SELECT COUNT( * ) AS COUNT
FROM `tblstd_idcard` , log_print_card
WHERE log_print_card.student_id = tblstd_idcard.student_id");
$data = mysql_fetch_assoc($query);
?>
<p>จำนวนนักเรียนที่มาทำบัตร || <?php echo number_format($data['COUNT']);?> คน</p>
<?php
$query = mysql_query("SELECT COUNT( * ) AS COUNT
FROM `tblstd_idcard` , log_print_card
WHERE tblstd_idcard.student_id LIKE '583%'
AND log_print_card.student_id = tblstd_idcard.student_id");
$data = mysql_fetch_assoc($query);
?>
<p>จำนวนนักเรียนที่มาทำบัตร ปวส || <?php echo number_format($data['COUNT']);?> คน</p>
<?php
$query = mysql_query("SELECT COUNT( * ) AS COUNT
FROM `tblstd_idcard` , log_print_card
WHERE tblstd_idcard.student_id LIKE '582%'
AND log_print_card.student_id = tblstd_idcard.student_id");
$data = mysql_fetch_assoc($query);
?>
<p>จำนวนนักเรียนที่มาทำบัตร ปวช || <?php echo number_format($data['COUNT']);?> คน</p>
<hr color="#00FF00" width="100%">
<?php
$query = mysql_query("SELECT DISTINCT tblstd_idcard.major_name, COUNT( major_name ) AS COUNT FROM `tblstd_idcard` , log_print_card
WHERE tblstd_idcard.student_id LIKE '58%'
AND log_print_card.student_id = tblstd_idcard.student_id
GROUP BY tblstd_idcard.major_name");
while($data = mysql_fetch_assoc($query))
{
$datatop[$data['major_name']][2] = $data['COUNT'];
}
$query = mysql_query("SELECT DISTINCT tblstd_idcard.major_name, COUNT( major_name ) AS COUNT FROM `tblstd_idcard`
WHERE tblstd_idcard.student_id LIKE '58%'
GROUP BY tblstd_idcard.major_name");
while($data = mysql_fetch_assoc($query))
{
$datatop[$data['major_name']][1] = $data['COUNT'];
}
?>
<table>
<tr>
<td>ชื่อ</td>
<td>1</td>
<td>2</td>
</tr>
<?php foreach($datatop as $data =>$key){
echo "<tr>";
echo "<td>".$data."</td>";
echo "<td>".$key[1]."</td>";
echo "<td>".$key[2]."</td>";
echo "</tr>";
}
?>
</table>
</body>
</html>