| 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 : |
<?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");
$strExcelFileName="Score.xls";
header("Content-Type: application/x-msexcel; name=\"$strExcelFileName\"");
header("Content-Disposition: inline; filename=\"$strExcelFileName\"");
header("Pragma:no-cache");
?>
<meta charset="utf-8">
<?PHP
//echo $_GET['ValueSend'];
if(strpos($_GET['ValueSend'],"@")) {
//echo "OK";
$valueSend = explode("@",$_GET['ValueSend']);
$tmp1 = iconv('utf-8','tis-620',$valueSend[0]); // PSubjectCode
$tmp2 = iconv('utf-8','tis-620',$valueSend[1]); // PClass
$tmp3 = $valueSend[2]; // PRoom
if($valueSend[1]!="")
$txtTemp = $valueSend[0]." ห้อง ".$valueSend[1]."/".$valueSend[2];
else
$txtTemp = $valueSend[0];
} else {
$tmp1 = iconv('utf-8','tis-620',$_GET['ValueSend']);
$tmp2 = "";
$txtTemp = $_GET['ValueSend'];
}
if($tmp2!="")
$sql = "SELECT TBStudent.PCLassNo,dbo.TScore.IDStudent,dbo.TBStudent.PreName, dbo.TBStudent.NameFirst, dbo.TBStudent.NameLast, dbo.TScore.PClass, dbo.TScore.PRoom, dbo.TScore.PSubjectCode, dbo.TSubject.PTotFOR1, dbo.TScore.PFor1, dbo.TSubject.PTotSUM, dbo.TScore.PSum, dbo.TSubject.PTotFOR2, dbo.TScore.PFor2, dbo.TSubject.PTotFIN, dbo.TScore.PFin, dbo.TScore.PGradeForCal FROM dbo.TScore INNER JOIN dbo.TBStudent ON dbo.TScore.IDStudent = dbo.TBStudent.IDStudent INNER JOIN dbo.TSubject ON dbo.TScore.PSubjectCode = dbo.TSubject.PSubjectCode WHERE (dbo.TScore.PSubjectCode = '".$tmp1."') AND (dbo.TScore.PClass = '".$tmp2."') AND (dbo.TScore.PRoom = '".$tmp3."') AND (dbo.TScore.RegYear = '".$_SESSION["AYear"]."') AND (dbo.TScore.RegTerm = '".$_SESSION["Term"]."' or dbo.TScore.RegTerm = '_') AND (TScore.IDTeacher='".$_SESSION["IDTeacher"]."') order by TBStudent.IDPlanData,TBStudent.IDStudent";
else
$sql = "SELECT TBStudent.PCLassNo,dbo.TScore.IDStudent,dbo.TBStudent.PreName, dbo.TBStudent.NameFirst, dbo.TBStudent.NameLast, dbo.TScore.PClass, dbo.TScore.PRoom, dbo.TScore.PSubjectCode, dbo.TSubject.PTotFOR1, dbo.TScore.PFor1, dbo.TSubject.PTotSUM, dbo.TScore.PSum, dbo.TSubject.PTotFOR2, dbo.TScore.PFor2, dbo.TSubject.PTotFIN, dbo.TScore.PFin, dbo.TScore.PGradeForCal FROM dbo.TScore INNER JOIN dbo.TBStudent ON dbo.TScore.IDStudent = dbo.TBStudent.IDStudent INNER JOIN dbo.TSubject ON dbo.TScore.PSubjectCode = dbo.TSubject.PSubjectCode WHERE (dbo.TScore.PSubjectCode = '".$tmp1."') AND (dbo.TScore.RegYear = '".$_SESSION["AYear"]."') AND (dbo.TScore.RegTerm = '".$_SESSION["Term"]."' or dbo.TScore.RegTerm = '_') AND (TScore.IDTeacher='".$_SESSION["IDTeacher"]."') order by TBStudent.IDPlanData,TBStudent.IDStudent";
//echo $sql."<br>"; // (dbo.TScore.PSubjectCode = '".$tmp1."') AND (dbo.TScore.PClass = '".$tmp2."') AND
//echo $sql; exit();
echo "<div class='row'><div class='col-md-9 col-12'><h2>คะแนน วิชา ".$txtTemp."</h2></div></div>";
echo "<hr>";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
//echo $_SESSION["AYear"];
// style='border: 2px solid black'
echo "<table class='table table-striped'><thead><tr><th style='text-align: center;'>ลำดับที่ - รหัส</th><th style='text-align: center;'>ชื่อ - สกุล</th><th style='text-align: center;'>เต็ม<br>(เก็บ 1)</th><th style='text-align: center;'>ได้<br>(เก็บ 1)</th><th style='text-align: center;'>เต็ม<br>(กาลภาค)</th><th style='text-align: center;'>ได้<br>(กลางภาค)</th><th style='text-align: center;'>เต็ม<br>(เก็บ 2)</th><th style='text-align: center;'>ได้<br>(เก็บ 2)</th><th style='text-align: center;'>เต็ม<br>(ปลายภาค)</th><th style='text-align: center;'>ได้<br>(ปลายภาค)</th> <th style='text-align: center;'>เต็ม</th><th style='text-align: center;'>ได้</th><th style='text-align: center;'>เกรด</th><th></th></tr></thead>";
echo "<tbody>";
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
$Mark = $row["PTotFOR1"]+$row["PTotSUM"]+$row["PTotFOR2"]+$row["PTotFIN"]+$row["PTotCog"];
$Score = $row["PFor1"]+$row["PSum"]+$row["PFor2"]+$row["PFin"]+$row['PCog'];
echo "<tr><td>".$i." - ".$row["IDStudent"]."</td><td>".iconv('tis-620','utf-8',$row["NameFirst"])." ".iconv('tis-620','utf-8',$row["NameLast"])."</td><td align='center'>".number_format($row["PTotFOR1"],2,'.','')."</td><td align='center'>".number_format($row["PFor1"],2,'.','')."</td><td align='center'>".number_format($row["PTotSUM"],2,".","")."</td><td align='center'>".number_format($row["PSum"],2,".","")."</td><td align='center'>".number_format($row["PTotFOR2"],2,".","")."</td><td align='center'>".number_format($row["PFor2"],2,".","")."</td><td align='center'>".number_format($row["PTotFIN"],2,".","")."</td><td align='center'>".number_format($row["PFin"],2,".","")."</td><td align='center'>".$Mark."</td><td align='center'>".number_format($Score,2,".","")."</td><td align='center'>".$row["PGradeForCal"]."</td></tr>";
}
echo " </tbody></table>";
/*
echo "<div class='row' >";
echo "<div class='col col-md-1 col-centered'>".$row["IDStudent"]."</div>";
echo "<div class='col col-md-2' >".iconv('tis-620','utf-8',$row["NameFirst"])." ".iconv('tis-620','utf-8',$row["NameLast"])."</div>";
echo "<div class='col col-md-1'>".$row["PTotFOR1"]."</div>";
echo "<div class='col col-md-1'>".$row["PFor1"]."</div>";
echo "<div class='col col-md-1'>".$row["PTotSUM"]."</div>";
echo "<div class='col col-md-1'>".$row["PSum"]."</div>";
echo "<div class='col col-md-1'>".$row["PTotFOR2"]."</div>";
echo "<div class='col col-md-1'>".$row["PFor2"]."</div>";
echo "<div class='col col-md-1'>".$row["PTotFIN"]."</div>";
echo "<div class='col col-md-1'>".$row["PFin"]."</div>";
echo "<div class='col col-md-1'>".$row["PGradeForCal"]."</div>";
echo "</div>";
*/
sqlsrv_free_stmt( $stmt);
?>
</body>
</html>