| 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/myschool/triamudom/check/webadmin/ |
Upload File : |
<?php
session_start();
$path = "../";
include ($path.'include/config_db.php');
include ($path.'include/class_db.php');
include ($path.'include/class_display.php');
include ($path.'include/function.php');
include ($path.'include/permission_denied.php');
$CLASS['db'] = new db();
$CLASS['db']->connect();
$CLASS['disp'] = new display();
$db = $CLASS['db'];
$disp = $CLASS['disp'];
$tb_student_degree = $_REQUEST['tb_student_degree']; // รับค่าห้อง
$tb_room_name = $disp->display_roomname($tb_student_degree);
$date_start_search = convert_date_insert($_REQUEST['date_start']);// รับค่าวันเริมต้น
$date_end_search = convert_date_insert($_REQUEST['date_end']);// รับค่าวันที่สิ้นสุด
if($date_start_search){
$sql_searchdate .= " and tb_rule_date >= '".$date_start_search."' and tb_rule_date <= '".$date_end_search."' ";
$show_detaildate = "ข้อมูลระดับชั้นที่มีการมาสาย ระหว่างวันที่ ".$_REQUEST['date_start']." ถึงวันที่ ".$_REQUEST['date_end'];
}else{
$show_detaildate = "ข้อมูลระดับชั้นที่มีการมาสาย";
}
if($tb_student_degree=='69'){ // ม.1
$sql_search .= " and tb_student_degree >= '1' and tb_student_degree <= '12' ";
}
if($tb_student_degree=='70'){ // ม.2
$sql_search .= " and tb_student_degree >= '13' and tb_student_degree <= '24' ";
}
if($tb_student_degree=='71'){ // ม.3
$sql_search .= " and tb_student_degree >= '25' and tb_student_degree <= '36' ";
}
if($tb_student_degree=='72'){ // ม.4
$sql_search .= " and tb_student_degree >= '37' and tb_student_degree <= '48' ";
}
if($tb_student_degree=='73'){ // ม.5
$sql_search .= " and tb_student_degree >= '49' and tb_student_degree <= '58' ";
}
if($tb_student_degree=='74'){ // ม.6
$sql_search .= " and tb_student_degree >= '59' and tb_student_degree <= '68' ";
}
//----------------------------ค่าพื้นฐานระบบเว็บไซต์-----------------------------//
$fetch_public = $db->fetch_array($db->query("select * from tb_public"));
//----------------------------ค่าพื้นฐานระบบเว็บไซต์-----------------------------//
//echo "select * from tb_rules where tb_ruletype_id ='10' $sql_search $sql_searchdate GROUP BY tb_rules.tb_student_degree order by tb_student_degree asc";
$result_gp1=$db->query("select * from tb_rules where tb_ruletype_id ='10' $sql_search GROUP BY tb_rules.tb_student_degree order by tb_student_degree asc");
while($rs_gp1=$db->fetch_array($result_gp1)){
$fetch_chk = $db->fetch_array($db->query("select count(tb_ruletype_id) as num_group from tb_rules where tb_student_degree='".$rs_gp1['tb_student_degree']."' and tb_ruletype_id ='10' $sql_search $sql_searchdate "));
$label[]=" ' ".$disp->display_roomname($rs_gp1['tb_student_degree'])." ' ";
$data[]=$fetch_chk['num_group'];
}
$label=implode(',',$label);
$data=implode(',',$data);
//--------------------ส่วนบนใช้สำหรับประกาศตัวแปรและ Config เท่านั้น----------------------------//
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php print $fetch_public['tb_public_title_admin'];?></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/style_admin.css" rel="stylesheet" type="text/css">
<SCRIPT type="text/javascript" src="js/format.js"></SCRIPT>
<SCRIPT type="text/javascript" src="js/global.js" ></SCRIPT>
<SCRIPT type="text/javascript" src="js/dtree.js" ></SCRIPT>
<script language="JavaScript" type="text/javascript" src="../rule/js/calendar.js"></script>
<script language="JavaScript" type="text/javascript" src="../rule/js/loadcalendar.js"></script>
<script language="JavaScript" type="text/javascript" src="../rule/js/calendar-en.js"></script>
<script src="../RGraph/libraries/RGraph.common.core.js"></script>
<script src="../RGraph/libraries/RGraph.bar.js"></script>
<style type="text/css">
<!--
.style1 { font-size: 18px;
font-weight: bold;
}
-->
</style>
</HEAD>
<script>
window.onload = function ()
{
var title = 'แผนภูมิแสดงข้อมูลการมาสายของนักเรียนระดับชั้น <?php echo $tb_room_name; ?>';
var data = [<?php echo $data; ?>];
var labels =[<?php echo $label; ?>];
//var show_detaildateall =[<?php echo $show_detaildate; ?>];
var chart = new RGraph.Bar('myChart', data);
chart.Set('chart.gutter.left', 40);
chart.Set('chart.gutter.right', 40);
chart.Set('chart.gutter.top', 40);
chart.Set('chart.gutter.bottom', 40);
chart.Set('chart.title', title);
chart.Set('chart.labels', labels);
chart.Set('chart.colors', ['red']);
chart.Set('chart.background.grid', true);
chart.Set('chart.title.xaxis','<?php echo $show_detaildate; ?>');
chart.Set('chart.title.xaxis.pos',0.2);
chart.Set('chart.title.yaxis','จำนวนนักเรียนที่มาสาย');
chart.Set('chart.title.yaxis.pos',0.2);
chart.Draw();
}
</script>
<BODY>
<TABLE width=100% height="100%" border=0 cellPadding=0 cellSpacing=0>
<tbODY>
<TR>
<TD width=100% height=100 align="left" vAlign=top ><?php include_once('header_admin.php'); ?></TD>
</TR>
<TR height="100%" >
<TD width="100%" height="100%" vAlign=top>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 >
<tbODY>
<TR>
<TD width=200 rowSpan=2 vAlign=top id=nav><?php include_once('left_nav.php'); ?></TD>
<TD width=3 height=1 bgcolor="#f1f1f1"><img src="images/spacer.gif" width="3" height="1"></TD>
<TD width="100%" rowSpan=2 align="left" vAlign=top style="PADDING-LEFT: 3px; PADDING-RIGHT: 0px;">
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<tbody>
<tr>
<td rowspan="2"><img src="images/i_setup.gif" width="65" height="44" border="0"></td>
<td width="100%" height="24"> </td>
<td> </td>
</tr>
<tr>
<td align="left" width="100%"
background="images/bg_part.gif"><B><font color="#000000">เข้าระบบโดย : <?php print $_SESSION['sessionadmin_name'];?> <?php print $_SESSION['sessionadmin_sername'];?></font></B></td>
<td><img src="images/end_part.gif" width="25" height="20"></td>
</tr>
</tbody>
</table>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td align="center"><canvas id="myChart" width="700" height="400">[No canvas support]</canvas></td>
</tr>
</table>
<p> </p></TD>
</TR>
<TR>
<TD height=100% vAlign=top background="images/vline.gif">
<IMG src="images/h1_.gif" width="8" height="100" id=ctrlMnu style="CURSOR: hand" onClick="ShowHidePanel('nav', 'ctrlMnu')" onMouseOver="this.style.filter='alpha(opacity=65);'" onMouseOut="this.style.filter='alpha(opacity=100);'"></TD>
</TR>
</tbODY>
</TABLE> </TD>
</TR>
<TR height="100%" >
<TD height="30" vAlign=bottom><?php include_once('footer.php'); ?></TD>
</TR>
</tbODY>
</TABLE>
</BODY>
</html>