| 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:/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>Freelancer - Start Bootstrap Theme</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 showHint(str,PLevel) {
//alert(str);
var URL = "";
if(PLevel>2)
URL = "listReport_term";
else
URL = "listReport_year"
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;
var elmnt = document.getElementById("onTop");
elmnt.scrollIntoView();
}
};
xmlhttp.open("GET", URL + ".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;
var elmnt = document.getElementById("onTop");
elmnt.scrollIntoView();
}
};
xmlhttp.open("GET", "listReport_Activty.php?ValueSend=" + str, true);
xmlhttp.send();
}
}
</script>
</head>
<body id="page-top" class="index">
<div id="onTop"></div>
<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 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, dbo.TScore.PClass, dbo.TScore.PRoom,TSubject.PLevel 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, dbo.TScore.PClass, dbo.TScore.PRoom ,TSubject.PLevel Order by dbo.TSubject.PSubjectCode, dbo.TSubject.PSubjectName, dbo.TScore.PClass, dbo.TScore.PRoom ";
//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-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'])."','".$row['PLevel']."')\">".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 = '".$AYear."') AND (dbo.TScore.RegTerm = '".$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 -->
<?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>