| Server IP : www.kowitt.ac.th / Your IP : 216.73.216.118 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) {
//alert("OK");
// G40_Min
// 4.0
if(isNumeric(document.getElementById("G40_Min"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
if(isNumeric(document.getElementById("G40_Max"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
// 3.5
if(isNumeric(document.getElementById("G35_Min"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
if(isNumeric(document.getElementById("G35_Max"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
// 3.0
if(isNumeric(document.getElementById("G30_Min"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
if(isNumeric(document.getElementById("G30_Max"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
// 2.5
if(isNumeric(document.getElementById("G25_Min"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
if(isNumeric(document.getElementById("G25_Max"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
// 2.0
if(isNumeric(document.getElementById("G20_Min"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
if(isNumeric(document.getElementById("G20_Max"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
// 1.5
if(isNumeric(document.getElementById("G15_Min"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
if(isNumeric(document.getElementById("G15_Max"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
// 1.0
if(isNumeric(document.getElementById("G10_Min"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
if(isNumeric(document.getElementById("G10_Max"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
// 0
if(isNumeric(document.getElementById("G00_Min"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
if(isNumeric(document.getElementById("G00_Max"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข");
return false;
}
SaveGrade(i,PSubjectCode);
}
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("SetGrade"+i).innerHTML = this.responseText;
}
};
xmlhttp.open("GET", "ShowGradeLevel.php?i="+i+"&&PSubjectCode="+PSubjectCode, true);
xmlhttp.send();
}
function Close(i) {
//alert(i);
document.getElementById("SetGrade"+i).innerHTML = "";
}
function SaveGrade(i,PSubjectCode) {
//alert(i+" - " + PSubjectCode);
var G40_Min = document.getElementById("G40_Min"+i).value;
var G40_Max = document.getElementById("G40_Max"+i).value;
var G35_Min = document.getElementById("G35_Min"+i).value;
var G35_Max = document.getElementById("G35_Max"+i).value;
var G30_Min = document.getElementById("G30_Min"+i).value;
var G30_Max = document.getElementById("G30_Max"+i).value;
var G25_Min = document.getElementById("G25_Min"+i).value;
var G25_Max = document.getElementById("G25_Max"+i).value;
var G20_Min = document.getElementById("G20_Min"+i).value;
var G20_Max = document.getElementById("G20_Max"+i).value;
var G15_Min = document.getElementById("G15_Min"+i).value;
var G15_Max = document.getElementById("G15_Max"+i).value;
var G10_Min = document.getElementById("G10_Min"+i).value;
var G10_Max = document.getElementById("G10_Max"+i).value;
var G00_Min = document.getElementById("G00_Min"+i).value;
var G00_Max = document.getElementById("G00_Max"+i).value;
//alert(G40_Min);
var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("SetGrade"+i).innerHTML = this.responseText;
}
};
xmlhttp.open("GET", "SaveGradeLevel.php?i="+i+"&&PSubjectCode="+PSubjectCode+"&&G40_Min="+G40_Min+"&&G40_Max="+G40_Max+"&&G35_Min="+G35_Min+"&&G35_Max="+G35_Max+"&&G30_Min="+G30_Min+"&&G30_Max="+G30_Max+"&&G25_Min="+G25_Min+"&&G25_Max="+G25_Max+"&&G20_Min="+G20_Min+"&&G20_Max="+G20_Max+"&&G15_Min="+G15_Min+"&&G15_Max="+G15_Max+"&&G10_Min="+G10_Min+"&&G10_Max="+G10_Max+"&&G00_Min="+G00_Min+"&&G00_Max="+G00_Max, 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>
<!-- Navigation -->
<nav id="mainNav" class="navbar navbar-default navbar-fixed-top navbar-custom">
<div class="container">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header page-scroll">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span> Menu <i class="fa fa-bars"></i>
</button>
<a class="navbar-brand" href="#page-top">บันทึกคะแนนออนไลน์</a>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav navbar-right">
<li class="hidden">
<a href="#page-top"></a>
</li>
<li class="page-scroll">
<a href="index.php">บันทึกคะแนน</a>
</li>
<li class="page-scroll">
<a href="list_subject_forcal.php">คำนวนเกรด</a>
</li>
<li class="page-scroll">
<a href="report.php">รายงาน</a>
</li>
<li class="page-scroll">
<a href="setMark.php">กำหนดคะแนนเต็ม</a>
</li>
<li class="page-scroll">
<a href="setGrade.php">กำหนดระดับผลการเรียน</a>
</li>
<li class="page-scroll">
<a href="../system/index.php">กลับหน้าหลัก</a>
</li>
</ul>
</div>
<!-- /.navbar-collapse -->
</div>
<!-- /.container-fluid -->
</nav>
<?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 = "";
$Term = "";
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
$AYear = $row['AYear'];
$Term = $row['Term'];
}
$_SESSION["AYear"] = $AYear;
$_SESSION["Term"] = $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";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
?>
<!-- Contact Section -->
<section id="contact">
<div class="container">
<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="SetGrade<?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>