| Server IP : 122.154.253.140 / Your IP : 216.73.216.138 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/student_old/ |
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");
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>© 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>