| Server IP : 122.154.253.140 / Your IP : 216.73.216.209 Web Server : Microsoft-IIS/7.5 System : Windows NT SERVER02 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.6.31 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/inetpub/wwwroot/mis/teacher/subject_score_v2/ |
Upload File : |
<?PHP
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header ("Last-Modified: " . date("D, d M Y H:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header ("Pragma: no-cache");
include("conf.php");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>ระบบบันทึกคะแนนออนไลน์ โรงเรียนโกวิทธำรงเชียงใหม่</title>
<!-- Bootstrap Core CSS -->
<link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
<!-- Theme CSS -->
<link href="css/freelancer.min.css" rel="stylesheet">
<!-- Custom Fonts -->
<link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="https://fonts.googleapis.com/css?family=Montserrat:400,700" rel="stylesheet" type="text/css">
<link href="https://fonts.googleapis.com/css?family=Lato:400,700,400italic,700italic" rel="stylesheet" type="text/css">
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
<script>
function ExportExcel(str) {
//alert("str : "+str);
window.location.assign("report_excel.php?ValueSend="+str);
}
function back()
{
//alert("OK");
window.location.assign("report.php");
}
</script>
</head>
<body id="page-top" class="index">
<div id="columnchart_values" align="center"></div>
<?PHP
$Count00=0;
$Count10=0;
$Count15=0;
$Count20=0;
$Count25=0;
$Count30=0;
$Count35=0;
$Count40=0;
$CountNO=0;
//echo $_GET['ValueSend'];
if(strpos($_GET['ValueSend'],"@")) {
//echo "OK";
$valueSend = explode("@",$_GET['ValueSend']);
$tmp1 = iconv('utf-8','tis-620',$valueSend[0]); // PSubjectCode
$tmp1 = str_replace("$","#",$tmp1);
$tmp2 = iconv('utf-8','tis-620',$valueSend[1]); // PClass
$tmp3 = $valueSend[2]; // PRoom
$txtTemp = str_replace("$","#",$valueSend[0])." ห้อง ".$valueSend[1]."/".$valueSend[2];
} else {
$tmp1 = iconv('utf-8','tis-620',$_GET['ValueSend']);
$tmp1 = str_replace("$","#",$tmp1);
$tmp2 = "";
$txtTemp = str_replace("$","#",$_GET['ValueSend']);
}
echo "<div class='container-fluid'>";
//echo $tmp2;
if($tmp2!="")
$sql = "SELECT TBStudent.PCLassNo,dbo.TScore.IDStudent,dbo.TBStudent.PreName, dbo.TBStudent.NameFirst, dbo.TBStudent.NameLast, dbo.TScore.PClass, dbo.TScore.PRoom, dbo.TScore.PSubjectCode, dbo.TSubject.PTotFOR1, dbo.TScore.PFor1, dbo.TSubject.PTotSUM, dbo.TScore.PSum, dbo.TSubject.PTotFOR2, dbo.TScore.PFor2, dbo.TSubject.PTotFIN, dbo.TScore.PFin, dbo.TScore.PGradeForCal FROM dbo.TScore INNER JOIN dbo.TBStudent ON dbo.TScore.IDStudent = dbo.TBStudent.IDStudent INNER JOIN dbo.TSubject ON dbo.TScore.PSubjectCode = dbo.TSubject.PSubjectCode WHERE (dbo.TScore.PSubjectCode = '".$tmp1."') AND (dbo.TScore.PClass = '".$tmp2."') AND (dbo.TScore.PRoom = '".$tmp3."') AND (dbo.TScore.RegYear = '".$_SESSION["AYear"]."') AND (dbo.TScore.RegTerm = '".$_SESSION["Term"]."' or dbo.TScore.RegTerm = '_') AND (TScore.IDTeacher='".$_SESSION["IDTeacher"]."') and (TBStudent.Status=1) order by TBStudent.IDPlanData,TBStudent.IDStudent,TBStudent.IDStudent";
else
$sql = "SELECT TBStudent.PCLassNo,dbo.TScore.IDStudent,dbo.TBStudent.PreName, dbo.TBStudent.NameFirst, dbo.TBStudent.NameLast, dbo.TScore.PClass, dbo.TScore.PRoom, dbo.TScore.PSubjectCode, dbo.TSubject.PTotFOR1, dbo.TScore.PFor1, dbo.TSubject.PTotSUM, dbo.TScore.PSum, dbo.TSubject.PTotFOR2, dbo.TScore.PFor2, dbo.TSubject.PTotFIN, dbo.TScore.PFin, dbo.TScore.PGradeForCal FROM dbo.TScore INNER JOIN dbo.TBStudent ON dbo.TScore.IDStudent = dbo.TBStudent.IDStudent INNER JOIN dbo.TSubject ON dbo.TScore.PSubjectCode = dbo.TSubject.PSubjectCode WHERE (dbo.TScore.PSubjectCode = '".$tmp1."') AND (dbo.TScore.RegYear = '".$_SESSION["AYear"]."') AND (dbo.TScore.RegTerm = '".$_SESSION["Term"]."' or dbo.TScore.RegTerm = '_') AND (TScore.IDTeacher='".$_SESSION["IDTeacher"]."') and (TBStudent.Status=1) order by TBStudent.IDPlanData,TBStudent.IDStudent,TBStudent.IDStudent";
//echo $sql."<br>"; // (dbo.TScore.PSubjectCode = '".$tmp1."') AND (dbo.TScore.PClass = '".$tmp2."') AND
$valueLink = iconv("tis-620","utf-8",$tmp1)."@".iconv("tis-620","utf-8",$tmp2)."@".iconv("tis-620","utf-8",$tmp3);
echo "<div class='row'><div class='col-md-6 col-12'><h2>คะแนน วิชา ".$txtTemp."</h2></div>";
echo "<div class='col-md-3 col-12'><button type=\"button\" class=\"btn btn-success btn-lg btn-block\" onclick=\"ExportExcel('".$_GET['ValueSend']."')\">ส่งออก MS-Excel</button></div>";
echo "<div class='col-md-3 col-12'><button type=\"button\" class=\"btn btn-success btn-lg btn-block\" onclick=\"back()\">กลับ</button></div>";
echo "</div>";
echo "<hr>";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
//echo $_SESSION["AYear"];
// style='border: 2px solid black'
echo "<table class='table table-striped'><thead><tr><th style='text-align: center;'>ลำดับที่ - รหัส</th><th style='text-align: center;'>ชื่อ - สกุล</th><th style='text-align: center;'>เต็ม<br>(เก็บ 1)</th><th style='text-align: center;'>ได้<br>(เก็บ 1)</th><th style='text-align: center;'>เต็ม<br>(กาลภาค)</th><th style='text-align: center;'>ได้<br>(กลางภาค)</th><th style='text-align: center;'>เต็ม<br>(เก็บ 2)</th><th style='text-align: center;'>ได้<br>(เก็บ 2)</th><th style='text-align: center;'>เต็ม<br>(ปลายภาค)</th><th style='text-align: center;'>ได้<br>(ปลายภาค)</th> <th style='text-align: center;'>เต็ม</th><th style='text-align: center;'>ได้</th><th style='text-align: center;'>เกรด</th><th></th></tr></thead>";
echo "<tbody>";
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
$Mark = $row["PTotFOR1"]+$row["PTotSUM"]+$row["PTotFOR2"]+$row["PTotFIN"]+$row["PTotCog"];
$Score = $row["PFor1"]+$row["PSum"]+$row["PFor2"]+$row["PFin"]+$row['PCog'];
echo "<tr><td>".$i." - ".$row["IDStudent"]."</td><td>".iconv('tis-620','utf-8',$row["NameFirst"])." ".iconv('tis-620','utf-8',$row["NameLast"])."</td><td align='center'>".number_format($row["PTotFOR1"],2,'.','')."</td><td align='center'>";
// number_format($row["PFor1"],2,'.','')
if($row["PFor1"]!="") // เก็บ 1
echo number_format($row["PFor1"],2,".","");
else
echo "-";
echo "</td><td align='center'>".number_format($row["PTotSUM"],2,".","")."</td><td align='center'>";
if($row["PSum"]!="") // Mid
echo number_format($row["PSum"],2,".","");
else
echo "-";
echo "</td><td align='center'>".number_format($row["PTotFOR2"],2,".","")."</td><td align='center'>";
if($row["PFor2"]!="") // เก็บ 2
echo number_format($row["PFor2"],2,".","");
else
echo "-";
echo "</td><td align='center'>".number_format($row["PTotFIN"],2,".","")."</td><td align='center'>";
// number_format($row["PCog"],2,".","")
echo "</td><td align='center'>".$Mark."</td><td align='center'>";
if($Score!="")
echo number_format($Score,2,".","");
else
echo "-";
echo "</td><td align='center'>";
if($row["PGradeForCal"]!="")
echo $row["PGradeForCal"];
else
echo "-";
if(rtrim($row['PGradeForCal'])=="4") {
$Count40 = $Count40 + 1;
} else if(rtrim($row['PGradeForCal'])=="3.5") {
$Count35 = $Count35 + 1;
} else if(rtrim($row['PGradeForCal'])=="3") {
$Count30 = $Count30 + 1;
} else if(rtrim($row['PGradeForCal'])=="2.5") {
$Count25 = $Count25 + 1;
} else if(rtrim($row['PGradeForCal'])=="2") {
$Count20 = $Count20 + 1;
} else if(rtrim($row['PGradeForCal'])=="1.5") {
$Count15 = $Count15 + 1;
} else if(rtrim($row['PGradeForCal'])=="1") {
$Count10 = $Count10 + 1;
} else if(rtrim($row['PGradeForCal'])=="0") {
$Count00 = $Count00 + 1;
} else {
$CountNO = $CountNO + 1;
}
echo "</td></tr>";
}
echo " </tbody></table>";
/*
echo "<div class='row' >";
echo "<div class='col col-md-1 col-centered'>".$row["IDStudent"]."</div>";
echo "<div class='col col-md-2' >".iconv('tis-620','utf-8',$row["NameFirst"])." ".iconv('tis-620','utf-8',$row["NameLast"])."</div>";
echo "<div class='col col-md-1'>".$row["PTotFOR1"]."</div>";
echo "<div class='col col-md-1'>".$row["PFor1"]."</div>";
echo "<div class='col col-md-1'>".$row["PTotSUM"]."</div>";
echo "<div class='col col-md-1'>".$row["PSum"]."</div>";
echo "<div class='col col-md-1'>".$row["PTotFOR2"]."</div>";
echo "<div class='col col-md-1'>".$row["PFor2"]."</div>";
echo "<div class='col col-md-1'>".$row["PTotFIN"]."</div>";
echo "<div class='col col-md-1'>".$row["PFin"]."</div>";
echo "<div class='col col-md-1'>".$row["PGradeForCal"]."</div>";
echo "</div>";
*/
sqlsrv_free_stmt( $stmt);
echo "</div>";
?>
<!-- jQuery -->
<script src="vendor/jquery/jquery.min.js"></script>
<!-- Bootstrap Core JavaScript -->
<script src="vendor/bootstrap/js/bootstrap.min.js"></script>
<!-- Plugin JavaScript -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js"></script>
<!-- Contact Form JavaScript -->
<script src="js/jqBootstrapValidation.js"></script>
<script src="js/contact_me.js"></script>
<!-- Theme JavaScript -->
<script src="js/freelancer.min.js"></script>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load("current", {packages:['corechart']});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
["Grade", "จำนวน", { role: "style" } ],
["0", <?PHP echo $Count00; ?>, "#E74C3C"],
["1", <?PHP echo $Count10; ?>, "#EB984E"],
["1.5", <?PHP echo $Count15; ?>, "#F1C40F"],
["2",<?PHP echo $Count20; ?>, "#A3E4D7"],
["2.5", <?PHP echo $Count25; ?>, "#17A589"],
["3", <?PHP echo $Count30; ?>, "#5DADE2"],
["3.5", <?PHP echo $Count35; ?>, "#1A5276"],
["4", <?PHP echo $Count40; ?>, "#633974"],
["Other", <?PHP echo $CountNO; ?>, "color: #2C3E50"]
]);
var view = new google.visualization.DataView(data);
view.setColumns([0, 1,
{ calc: "stringify",
sourceColumn: 1,
type: "string",
role: "annotation" },
2]);
var options = {
title: "สรุปจำนวนผลการเรียนของนักเรียน",
width: "100%",
height: 400,
bar: {groupWidth: "95%"},
legend: { position: "none" },
};
var chart = new google.visualization.ColumnChart(document.getElementById("columnchart_values"));
chart.draw(view, options);
}
</script>
</body>
</html>