%PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY
| Server IP : 122.154.253.140 / Your IP : 216.73.216.34 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]-->
<script>
function showHint(str) {
//alert(str);
window.location.assign("report_grade.php?ValueSend=" + str);
/*
if (str.length == 0) {
document.getElementById("txtHint").innerHTML = "";
return;
} else {
var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("txtHint").innerHTML = this.responseText;
window.location.assign("report.php#contact");
}
};
xmlhttp.open("GET", "listReport.php?ValueSend=" + str, true);
xmlhttp.send();
}
*/
}
function showHint_Activity(str) {
//alert(str);
if (str.length == 0) {
document.getElementById("txtHint").innerHTML = "";
return;
} else {
var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("txtHint").innerHTML = this.responseText;
window.location.assign("report.php#contact");
}
};
xmlhttp.open("GET", "listReport_Activty.php?ValueSend=" + str, 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">
<HR>
<div id="txtHint" style='overflow-y:scroll;'></div>
<?PHP
// ============================ รายวิชาปกติ ============================
$sql = "SELECT dbo.TSubject.PSubjectCode, dbo.TSubject.PSubjectName, dbo.TScore.PClass, dbo.TScore.PRoom
FROM dbo.TScore INNER JOIN
dbo.TSubject ON dbo.TScore.PSubjectCode = dbo.TSubject.PSubjectCode
WHERE (dbo.TScore.RegYear = '".$_SESSION["AYear"]."') AND (dbo.TScore.RegTerm = '".$_SESSION["Term"]."' or dbo.TScore.RegTerm = '_') AND (dbo.TScore.IDTeacher = '".$IDTeacher."') AND (IDYearData not like ('NET%'))
GROUP BY dbo.TSubject.PSubjectCode, dbo.TSubject.PSubjectName, dbo.TScore.PClass, dbo.TScore.PRoom Order by dbo.TScore.PClass, dbo.TScore.PRoom,dbo.TSubject.PSubjectCode";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
//echo $_SESSION["AYear"];
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
echo "<div class='row'>";
echo "<div class='col-md-1'></div>";
echo "<div class='col-md-10'><button type=\"button\" class='btn btn-warning btn-block' onClick=\"showHint('".iconv('tis-620','utf-8',$row['PSubjectCode'])."@".rtrim(iconv('tis-620','utf-8',$row['PClass']))."@".iconv('tis-620','utf-8',$row['PRoom'])."')\">".iconv('tis-620','utf-8',$row['PSubjectCode'])." - ชั้น ".iconv('tis-620','utf-8',rtrim($row['PClass']))."/".iconv('tis-620','utf-8',$row['PRoom'])."<br>".iconv('tis-620','utf-8',$row['PSubjectName'])."</button></div>";
echo "<div class='col-md-1'></div>";
echo "</div><br>";
}
// ============================ สาระเพิ่มเติม / การงานอาชีพ ============================
$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 = '".$_SESSION["AYear"]."') AND (dbo.TScore.RegTerm = '".$_SESSION["Term"]."') AND (dbo.TScore.IDTeacher = '".$IDTeacher."') AND (IDYearData like ('NET%'))
GROUP BY dbo.TSubject.PSubjectCode, dbo.TSubject.PSubjectName";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
//echo $_SESSION["AYear"];
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
echo "<div class='row'>";
echo "<div class='col-md-1'></div>";
echo "<div class='col-md-10'><button type=\"button\" class='btn btn-default btn-block' onClick=\"showHint('".iconv('tis-620','utf-8',$row['PSubjectCode'])."')\">".iconv('tis-620','utf-8',$row['PSubjectCode'])."<br>".iconv('tis-620','utf-8',$row['PSubjectName'])."</button></div>";
echo "<div class='col-md-1'></div>";
echo "</div><br>";
}
/*
echo "<div class='row'>";
echo "<div class='col-md-1'></div>";
echo "<div class='col-md-10'><button type=\"button\" class='btn btn-warning btn-block' onClick=\"showHint('".iconv('tis-620','utf-8',$row['PSubjectCode'])."@".rtrim(iconv('tis-620','utf-8',$row['PClass']))."@".iconv('tis-620','utf-8',$row['PRoom'])."')\">".iconv('tis-620','utf-8',$row['PSubjectCode'])." - ชั้น ".iconv('tis-620','utf-8',rtrim($row['PClass']))."/".iconv('tis-620','utf-8',$row['PRoom'])."<br>".iconv('tis-620','utf-8',$row['PSubjectName'])."</button></div>";
echo "<div class='col-md-1'></div>";
echo "</div><br>";
*/
// ============================ รายวิชากิจกรรม ============================
$sql = "SELECT SubName, IDTeacher, ActivityCode FROM TBStudentActivity Where (IDTeacher = '".$_SESSION["IDTeacher"]."') and AYear='".$AYear."' and Term='".$Term."' GROUP BY SubName, IDTeacher, ActivityCode ";
//echo $sql;
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
//echo $_SESSION["AYear"];
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
echo "<div class='row'>";
echo "<div class='col-md-1'></div>";
echo "<div class='col-md-10'><button type=\"button\" class='btn btn-default btn-block' onClick=\"showHint_Activity('".iconv('tis-620','utf-8',$row['ActivityCode'])."')\">".iconv('tis-620','utf-8',$row['ActivityCode'])."<br>".iconv('tis-620','utf-8',$row['SubName'])."</button></div>";
echo "<div class='col-md-1'></div>";
echo "</div><br>";
}
sqlsrv_free_stmt( $stmt);
?>
</div>
</div>
</div>
</section>
<!-- Footer -->
<footer class="text-center">
<div class="footer-above">
<div class="container">
<div class="row">
<div class="footer-col col-md-12">
<h3>โรงเรียนสาธิตมหาวิทยาลัยเชียงใหม่</h3>
<p>239 ถนนห้วยแก้ว ต.สุเทพ อ.เมือง จ.เชียงใหม่ 50200โทร. (053) 944248 Fax. (053) 221285 E-mail: satitcmu@satitcmu.ac.th</p>
</div>
</div>
</div>
</div>
<div class="footer-below">
<div class="container">
<div class="row">
<div class="col-lg-12">
Copyright © www.satitcmu.ac.th 2017
</div>
</div>
</div>
</div>
</footer>
<!-- 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>