| 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:/BK/wwwroot/mis/teacher/subject_score/ |
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() {
//alert(document.getElementById("MarkScore").value);
// CountStu
window.location.href="#targetDiv";
for (i = 1; i < document.getElementById("CountStu").value; i++) {
//alert(i);
if(document.getElementById("Score"+i).value.length>0){
if(isNumeric(document.getElementById("Score"+i).value)==false) {
alert("กรุณาระบุคะแนนเป็นตัวเลข (ลำดับที่ : " + i + ")");
return false;
}
if(parseFloat(document.getElementById("Score"+i).value)>parseFloat(document.getElementById("MarkScore").value)) { // IDStudent
//alert(document.getElementById("Score"+i).value+" - " + document.getElementById("MarkScore").value);
alert("คะแนนที่ให้ต้องไม่เกินคะแนนเต็มที "+document.getElementById("MarkScore").value+" คะแนน (รหัส นักเรียน "+document.getElementById("IDStudent"+i).value+")");
return false;
}
}
}
//alert("X");
for (i = 1; i < document.getElementById("CountStu").value; i++) {
//alert(i);
var last = 0;
//alert((i+i)+" aa "+ parseInt(document.getElementById("CountStu").value));
if((i+1)== parseInt(document.getElementById("CountStu").value)) {
last = 1;
//alert("OK");
}
if(document.getElementById("Score"+i).value.length>0) {
//alert("OK");
SaveScore(document.getElementById("IDStudent"+i).value,document.getElementById("Score"+i).value,last,parseInt(document.getElementById("CountStu").value),i);
}
//break;
}
}
function isNumeric(n) {
return !isNaN(parseFloat(n)) && isFinite(n);
}
function SaveScore(IDStudent,Score,last,Max,Run) {
//alert(IDStudent + " " + Score + "max : "+Max +" Run : "+Run);
//IDStudent="xxx";
var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("showSave").innerHTML = this.responseText;
}
};
xmlhttp.open("GET", "SaveScore.php?IDStudent=" + IDStudent + "&Score="+Score + "&Last="+last + "&Max="+Max+ "&Run="+Run , 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">
<div class="row">
<div class="col-lg-12 text-center">
<h2></h2>
<hr class="star-primary">
<div id="SaveScore" align="center">
<?PHP
//echo $_GET["ScoreType"];
$sql = "select PLevel from TSubject where PSubjectCode='".iconv("utf-8","tis-620",$_SESSION["PSubjectCode"])."'";
//echo "sql : ".$sql."<br>";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
$PLevel = $row['PLevel'];
}
//echo "PLevel : ".$PLevel."<BR>";
$sql= "select * from ScoreType where IDOrder='".$_GET["ScoreType"]."'";
//echo "sql : ".$sql."<br>";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
//echo "ScoreField : ". $row['ScoreField'];
if($_SESSION["Term"]=="1" && $PLevel=="1") { // ประถมภาคเรียนที่ 1
$ScoreField = $row['ScoreField'];
$_SESSION["ScoreField"] = $ScoreField;
$MarkField = $row['MarkField'];
$_SESSION["MarkField"] = $ScoreField;
$ScoreName = $row['ScoreName'];
} else if($_SESSION["Term"]=="2" && $PLevel=="1") { // ประถมภาคเรียนที่ 2
$ScoreField = $row['ScoreField_T2'];
$_SESSION["ScoreField"] = $ScoreField;
$MarkField = $row['MarkField_T2'];
$_SESSION["MarkField"] = $ScoreField;
$ScoreName = $row['ScoreName'];
} else { // ไม่ใช่ประถม
$ScoreField = $row['ScoreField'];
$_SESSION["ScoreField"] = $ScoreField;
$MarkField = $row['MarkField'];
$_SESSION["MarkField"] = $ScoreField;
$ScoreName = $row['ScoreName'];
}
//echo "rows ".$MarkField;
}
/*
echo $_SESSION["PSubjectCode"];
echo $_SESSION["PClass"];
echo $_SESSION["PRoom"];
echo $_SESSION["AYear"];
echo $_SESSION["Term"];
echo "<br><br>";
*/
//echo "Mark : ".$MarkField;
$sql="select ".$MarkField." from TSubject where PSubjectCode='".iconv('utf-8','tis-620',$_SESSION["PSubjectCode"])."'";
//echo $sql;
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_NUMERIC) ) {
$ScoreMark = $row[0];
//echo "OK";
}
//echo "<BR>Score Mark : ".$ScoreMark;
if($_SESSION["PClass"]!="") {
$sql="SELECT TBStudent.PCLassNo, dbo.TSubject.PSubjectCode, dbo.TSubject.PSubjectName, dbo.TBStudent.PreName,TBStudent.IDStudent, dbo.TBStudent.NameFirst+' '+ dbo.TBStudent.NameLast as StuName, dbo.TScore.PClass+convert(char(2),dbo.TScore.PRoom) as StuClassRoom,".$_SESSION["ScoreField"]." as Score , isnull(PGradeForCal,'') as PGradeForCal FROM dbo.TScore INNER JOIN dbo.TSubject ON dbo.TScore.PSubjectCode = dbo.TSubject.PSubjectCode INNER JOIN dbo.TBStudent ON dbo.TScore.IDStudent = dbo.TBStudent.IDStudent WHERE (dbo.TScore.RegYear = '".$_SESSION["AYear"]."') AND (dbo.TScore.RegTerm = '".$_SESSION["Term"]."' or dbo.TScore.RegTerm = '_') AND (dbo.TScore.PSubjectCode = '".iconv('utf-8','tis-620',$_SESSION["PSubjectCode"])."') AND (dbo.TScore.PClass = '".iconv('utf-8','tis-620',$_SESSION["PClass"])."') AND (dbo.TScore.PRoom = '".$_SESSION["PRoom"]."') and TBStudent.Status=1 order by TBStudent.IDStudent";
} else {
$sql="SELECT TBStudent.PCLassNo,dbo.TSubject.PSubjectCode, dbo.TSubject.PSubjectName, dbo.TBStudent.PreName,TBStudent.IDStudent, dbo.TBStudent.NameFirst+' '+ dbo.TBStudent.NameLast as StuName, dbo.TScore.PClass+convert(char(2),dbo.TScore.PRoom) as StuClassRoom,".$_SESSION["ScoreField"]." as Score, isnull(PGradeForCal,'') as PGradeForCal FROM dbo.TScore INNER JOIN dbo.TSubject ON dbo.TScore.PSubjectCode = dbo.TSubject.PSubjectCode INNER JOIN dbo.TBStudent ON dbo.TScore.IDStudent = dbo.TBStudent.IDStudent WHERE (dbo.TScore.RegYear = '".$_SESSION["AYear"]."') AND (dbo.TScore.RegTerm = '".$_SESSION["Term"]."' or dbo.TScore.RegTerm = '_') AND (dbo.TScore.PSubjectCode = '".iconv('utf-8','tis-620',$_SESSION["PSubjectCode"])."') and TBStudent.Status=1 order by TBStudent.IDStudent";
}
//echo $sql;
//$sql="SELECT dbo.TSubject.PSubjectCode, dbo.TSubject.PSubjectName, dbo.TBStudent.PreName+ dbo.TBStudent.NameFirst+' '+ dbo.TBStudent.NameLast as StuName, dbo.TScore.PClass+convert(char(2),dbo.TScore.PRoom) as StuClassRoom FROM dbo.TScore INNER JOIN dbo.TSubject ON dbo.TScore.PSubjectCode = dbo.TSubject.PSubjectCode INNER JOIN dbo.TBStudent ON dbo.TScore.IDStudent = dbo.TBStudent.IDStudent WHERE (dbo.TScore.RegYear = '".$_SESSION["AYear"]."') AND (dbo.TScore.RegTerm = '".$_SESSION["Term"]."') AND (dbo.TScore.PSubjectCode = '".$_SESSION["PSubjectCode"]."') AND (dbo.TScore.PClass = '".$_SESSION["PClass"]."') AND (dbo.TScore.PRoom = '".$_SESSION["PRoom"]."') order by TBstudent.IDStudent";
//echo $sql;
$stmt = sqlsrv_query( $conn, $sql );
echo "<div class='row'>";
echo "<div class='col-md-3'>รายชื่อ</div><div class='col col-md-1'>เต็ม</div><div class='col col-md-1'>ได้</div>";
echo "</div></div>";
$i = 1;
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {
echo "<div class='row'>";
echo "<div class='col-sm-3' align='left'>".$row['IDStudent']." - ".$row['PClassNo'].". ".iconv('tis-620','utf-8',$row['StuName'])."<input type='hidden' id='IDStudent".$i."' value='".$row['IDStudent']."'/></div>";
echo "<div class='col-sm-1'><input type='text' class='form-control' id='ScoreMark".$i."' name='ScoreMark' value='".$ScoreMark."' style='text-align:center;' disabled></div>";
if($row['PGradeForCal']=='')
$disabled = "";
else
$disabled = "disabled";
//echo $disabled;
echo "<div class='col-sm-1'><input type='text' class='form-control' id='Score".$i."' name='Score' value='".$row['Score']."' $disabled style='text-align:center;'></div>";
echo "<hr></div>";
$i++;
}
echo "<input type='hidden' id='CountStu' name='CountStu' value='".$i."'>";
echo "</div>";
?>
</p>
</div>
<?PHP
$sql ="select * from TScoreSendScore where RegYear='".$_SESSION["AYear"]."' and RegTerm='".$_SESSION["Term"]."' and PClass='".iconv('utf-8','tis-620',$_SESSION["PClass"])."' and SendScore=0";
$stmt = sqlsrv_query( $conn, $sql );
$disabled = "";
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {
$disabled = "disabled";
}
?>
<input id="MarkScore" value="<?PHP echo $ScoreMark; ?>" type="hidden">
<div id="showSave" align="center"></div>
<button type="button" class="btn btn-primary btn-lg btn-block" onClick="CheckNumber()" <?PHP echo $disabled; ?>>บันทึกคะแนน</button>
</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>