| 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");
$sql = "select * from LT_GradeSystem where PSubjectCode='".iconv('utf-8','tis-620',$_GET["PSubjectCode"])."'";
//echo $sql;
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
//echo $row["GradeName"];
if(rtrim($row["GradeName"])=="4") {
//echo "OK";
$G40_Min = number_format($row["MinScore"],3);
$G40_Max = number_format($row["MaxScore"],3);
} else if(rtrim($row["GradeName"])=="3.5") {
$G35_Min = number_format($row["MinScore"],3);
$G35_Max = number_format($row["MaxScore"],3);
} else if(rtrim($row["GradeName"])=="3") {
$G30_Min = number_format($row["MinScore"],3);
$G30_Max = number_format($row["MaxScore"],3);
} else if(rtrim($row["GradeName"])=="2.5") {
$G25_Min = number_format($row["MinScore"],3);
$G25_Max = number_format($row["MaxScore"],3);
} else if(rtrim($row["GradeName"])=="2") {
$G20_Min = number_format($row["MinScore"],3);
$G20_Max = number_format($row["MaxScore"],3);
} else if(rtrim($row["GradeName"])=="1.5") {
$G15_Min = number_format($row["MinScore"],3);
$G15_Max = number_format($row["MaxScore"],3);
} else if(rtrim($row["GradeName"])=="1") {
$G10_Min = number_format($row["MinScore"],3);
$G10_Max = number_format($row["MaxScore"],3);
} else if(rtrim($row["GradeName"])=="0") {
$G00_Min = number_format($row["MinScore"],3);
$G00_Max = number_format($row["MaxScore"],3);
}
}
$i = $_GET["i"];
?>
<table class="table table-hover">
<thead>
<tr>
<th>กำหนดช่วงผลการเรียน รายวิชา <?PHP echo $_GET["PSubjectCode"]; ?></th>
<th>คะแนนตั้งแต่</th>
<th>จนถึงคะแนน</th>
</tr>
</thead>
<tbody>
<tr>
<td>เกรด 4</td>
<td><input type="text" id="G40_Min<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G40_Min; ?>"/></td>
<td><input type="text" id="G40_Max<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G40_Max; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td>เกรด 3.5</td>
<td><input type="text" id="G35_Min<?PHP echo $i; ?>"class="form-control" value="<?PHP echo $G35_Min; ?>"/></td>
<td><input type="text" id="G35_Max<?PHP echo $i; ?>"class="form-control" value="<?PHP echo $G35_Max; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td>เกรด 3</td>
<td><input type="text" id="G30_Min<?PHP echo $i; ?>"class="form-control" value="<?PHP echo $G30_Min; ?>"/></td>
<td><input type="text" id="G30_Max<?PHP echo $i; ?>"class="form-control" value="<?PHP echo $G30_Max; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td>เกรด 2.5</td>
<td><input type="text" id="G25_Min<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G25_Min; ?>"/></td>
<td><input type="text" id="G25_Max<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G25_Max; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td>เกรด 2</td>
<td><input type="text" id="G20_Min<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G20_Min; ?>"/></td>
<td><input type="text" id="G20_Max<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G20_Max; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td>เกรด 1.5</td>
<td><input type="text" id="G15_Min<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G15_Min; ?>"/></td>
<td><input type="text" id="G15_Max<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G15_Max; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td>เกรด 1</td>
<td><input type="text" id="G10_Min<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G10_Min; ?>"/></td>
<td><input type="text" id="G10_Max<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G10_Max; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td>เกรด 0</td>
<td><input type="text" id="G00_Min<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G00_Min; ?>"/></td>
<td><input type="text" id="G00_Max<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $G00_Max; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td></td>
<td colspan="2"><button type="button" class="btn btn-danger" id="Close" onclick="Close(<?PHP echo $_GET["i"]; ?>)"> ปิด </button>
<button type="button" class="btn btn-success" id="Save" onclick="CheckNumber(<?PHP echo $_GET["i"]; ?>,'<?PHP echo $_GET["PSubjectCode"]; ?>')">บันทึก</button></td>
</tr>
</tbody>
</table>