| 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]-->
<link href="https://fonts.googleapis.com/css?family=Prompt" rel="stylesheet">
<style>
body {
font-family: 'Prompt', serif;
font-size: 18;
}
</style>
<script>
function CheckNumber(i,PSubjectCode,PLevel) {
//alert("OK");
if(isNumeric(document.getElementById("PTotFOR1_"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
if(isNumeric(document.getElementById("PTotSUM_"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
if(isNumeric(document.getElementById("PTotFOR2_"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
if(isNumeric(document.getElementById("PTotFIN_"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
SaveMark(i,PSubjectCode,PLevel);
}
function isNumeric(n) {
return !isNaN(parseFloat(n)) && isFinite(n);
}
function showHint(i,PSubjectCode) {
//alert(i+" - " + PSubjectCode);
var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("SetMark"+i).innerHTML = this.responseText;
}
};
xmlhttp.open("GET", "ShowMark.php?i="+i+"&&PSubjectCode="+PSubjectCode, true);
xmlhttp.send();
}
function Close(i) {
//alert(i);
document.getElementById("SetMark"+i).innerHTML = "";
}
function SaveMark(i,PSubjectCode,PLevel) {
//alert(i+" - " + PSubjectCode);
var PTotFOR1 = document.getElementById("PTotFOR1_"+i).value;
var PTotSUM = document.getElementById("PTotSUM_"+i).value;
var PTotFOR2 = document.getElementById("PTotFOR2_"+i).value;
var PTotFIN = document.getElementById("PTotFIN_"+i).value;
//alert(PTotFOR1);
var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("SetMark"+i).innerHTML = this.responseText;
}
};
xmlhttp.open("GET", "SaveMark.php?i="+i+"&&PSubjectCode="+PSubjectCode+"&&PTotFOR1="+PTotFOR1+"&&PTotSUM="+PTotSUM+"&&PTotFOR2="+PTotFOR2+"&&PTotFIN="+PTotFIN+"&&PLevel="+PLevel, true);
//xmlhttp.open("GET", "SaveMark.php?i="+i+"&&PSubjectCode="+PSubjectCode+"&&PTotFOR1+"+PTotFOR1+"&&PTotSUM+"+PTotSUM+"&&PTotFOR2+"+PTotFOR2+"&&PTotFIN+"+PTotFIN, true);
xmlhttp.send();
}
</script>
</head>
<body id="page-top" class="index">
<div id="skipnav"><a href="#maincontent">Skip to main content</a></div>
<?PHP
include "menu.php";
?>
<!-- Contact Section -->
<section id="contact">
<div class="container">
<?PHP
$sql = "SELECT AYear, Term FROM dbo.TBStudentArriveWeek WHERE (GETDATE() >= DateStart) AND (GETDATE() <= DateEnd) GROUP BY AYear, Term";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
$AYear = $_SESSION["AYear"];
$Term = $_SESSION["Term"];
// ============================ รายวิชาปกติ ============================
$sql = "SELECT dbo.TSubject.PSubjectCode, dbo.TSubject.PSubjectName FROM dbo.TScore INNER JOIN
dbo.TSubject ON dbo.TScore.PSubjectCode = dbo.TSubject.PSubjectCode
WHERE (dbo.TScore.RegYear = '".$AYear."') AND (dbo.TScore.RegTerm = '".$Term."' or dbo.TScore.RegTerm = '_') AND (dbo.TScore.IDTeacher = '".$IDTeacher."') AND (IDYearData not like ('NET%'))
GROUP BY dbo.TSubject.PSubjectCode, dbo.TSubject.PSubjectName order by dbo.TSubject.PSubjectCode";
//echo $sql;
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
?>
<div class="row">
<div class="col-lg-12 text-center">
<h2></h2>
<hr class="star-primary">
<?PHP
//echo $sql;
$i=1;
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
//echo $row["PSubjectCode"];
?>
<button type="button" class="btn btn-success btn-lg btn-block" onClick="showHint(<?php echo $i; ?>,'<?php echo iconv('tis-620','utf-8',$row["PSubjectCode"]); ?>')"><?PHP echo iconv('tis-620','utf-8',$row["PSubjectCode"])." - ".iconv('tis-620','utf-8',$row["PSubjectName"]); ?></button>
<br><div id="SetMark<?PHP echo $i; ?>"> </div><br>
<?PHP
$i++;
}
?>
</div>
</div>
</div>
</section>
<!-- Footer -->
<?PHP
include "footer.php";
?>
<!-- Scroll to Top Button (Only visible on small and extra-small screen sizes) -->
<div class="scroll-top page-scroll hidden-sm hidden-xs hidden-lg hidden-md">
<a class="btn btn-primary" href="#page-top">
<i class="fa fa-chevron-up"></i>
</a>
</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>
</body>
</html>