Viewing file:  checkNoSendGradeCourse.php (10.89 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
/** Define Validate Access */
define( '_VALID_ACCESS', 1 );
/** Configuration */
include( "configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
include_once( "./link/function.php" );
/** using 'reg' DB */
/*
include("./includes/FunctionDB.php");
include("./includes/Function.php");
*/
/** Config Table for This Page */
include_once "./class/clsSysSemesterDes.php";
include_once "./class/clsAcadYearConfig.php";
include_once "./class/clsProgram.php";
include_once "./class/clsEnrollItem.php";
include_once "./class/clsClass.php";
include_once "./class/clsCourse.php";
include_once "./class/clsClassInStructor.php";
include_once "./class/clsOfficer.php";
include_once "./class/clsPrefix.php";
$conn = new Connection();
$oSse = new SysSemesterDes();
$oAy = new AcadYearConfig();
$oPg = new Program();
$oEi = new EnrollItem();
$oCl = new Class1();
$oCo = new Course();
$oCi = new ClassInStructor();
$oOf = new Officer();
$oPf = new Prefix();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title><?=$_Config_sitename;?> - ตรวจสอบรายวิชาลงทะเบียนเรียน</title>
<script type="text/javascript" src="./js/utilities.js"></script>
<link href="./css/default.css" rel="stylesheet" type="text/css" />
</head>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<?php
include( "./templates/incHeader.php" );
?>
<table width="1003" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="215" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include( "templates/incMainMenuLeft.php" );?></td>
<td width="788" height="300" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset><table width="770" border="0" cellspacing="0" cellpadding="0">
<form id="myForm" name="myForm" method="post" action="<?=$PHP_SELF;?>">
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="30" background="images/background/bg-head-topic-w780.gif"><span class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a></strong> <strong>» <a href="StudentList.php">ข้อมูลนักศึกษา</a> » <a href="ShowStudentDetail.php?studentId=<?=$studentId;?>">ประวัตินักศึกษา</a> » </strong></span><span class="NOTE"><strong>ตรวจสอบรายวิชาลงทะเบียนเรียน</strong></span></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="center" valign="top"><table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><input type="button" name="button" id="button" value="ตรวจสอบค่าลงทะเบียนเรียน" onclick="location.href='checkEnrollFee.php'" />
<input type="button" name="button2" id="button2" value="ตรวจสอบรายวิชาที่ยังไม่ได้ส่งเกรด" onclick="location.href='checkNoSendGradeCourse.php'" /></td>
</tr>
<tr>
<td align="right"> </td>
</tr>
</table>
<table width="731" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="4" align="center"><font size="3" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><b>ตรวจสอบรายวิชาที่ยังไม่ได้ส่งเกรด</b></font></td>
</tr>
<tr>
<td height="22" colspan="4"></td>
</tr>
<?php
if(!$acadYear)
$acadYear = $GLOBALS["ACADYEAR"];
if(!$semester)
$semester = $GLOBALS["SEMESTER"];
$oSse->SearchByKey($semester);
$oSse->GetRecord();
?>
<tr>
<td height="22" colspan="4"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"><b>ปีการศึกษา</b>
<select name="acadYear" onchange="location.href = 'checkNoSendGradeCourse.php?acadYear=' + encodeURI(options[selectedIndex].value)">
<option value="<?php echo $acadYear;?>"><?php echo $acadYear;?></option>
<?php
$oAy->RSAcadYearConfigGroupAcY();
while($oAy->GetRecord()) {
?>
<option value="<?php echo $oAy->acadYear;?>"><?php echo $oAy->acadYear;?></option>
<?php
}
?>
</select>
<b>ภาคการศึกษา</b></font>
<select name="semester" onchange="location.href = 'checkNoSendGradeCourse.php?acadYear=<?php echo $acadYear;?>&semester=' + encodeURI(options[selectedIndex].value)">
<?php
if($semester) {
?>
<option value="<?php echo $semester;?>"><?php echo $oSse->semesterName;?></option>
<?php
}
$oSse->RSSysSemesterDes();
while($oSse->GetRecord()) {
?>
<option value="<?php echo $oSse->semester;?>"><?php echo $oSse->semesterName;?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td height="22" colspan="4"></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td width="49" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"]; ?>"><b>ลำดับที่</b></font></td>
<td width="334" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"]; ?>"><b>รายวิชา</b></font></td>
<td width="48" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"]; ?>"><b>กลุ่ม</b></font></td>
<td width="282" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"]; ?>"><b>อาจารย์ผู้รับผิดชอบส่งเกรด</b></font></td>
</tr>
<?php
$k = 0;
$oPg->RSProgram();
while($oPg->GetRecord()) {
?>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_1"];?>">
<td height="22" colspan="4"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"><?php echo $oPg->programName;?></font></td>
</tr>
<?php
$i = 0;
$oEi->RSEnrollItemByAcYAndSeAndPgIdGroupClId($acadYear, $semester, $oPg->programId);
while($oEi->GetRecord()) {
$oPf->prefixName = '';
$oOf->officerName = '';
$oOf->officerSurname = '';
$oCl->SearchByKey($oEi->classId);
$oCl->GetRecord();
if($oCl->sendGradeStatus == 'N') {
$oCo->SearchByKey($oCl->courseId);
$oCo->GetRecord();
$oCi->RSClassInStructorByClIdAndResponsibilityIsY($oEi->classId);
if($oCi->GetRecord()) {
$oOf->SearchByKey($oCi->officerId);
$oOf->GetRecord();
$oPf->SearchByKey($oOf->prefixId);
$oPf->GetRecord();
}
if(($i%2) == 0)
echo "<tr>";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
?>
<tr>
<td height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"><?php echo $k+1;?></font></td>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"><?php echo $oCo->courseCode.' '.$oCo->courseName;?></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"><?php echo $oCl->section;?></font></td>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"><?php echo $oPf->prefixName.$oOf->officerName.' '.$oOf->officerSurname;?></font></td>
</tr>
<?php
$k++;
$i++;
}
}
$oEi->RSEnrollItemByAcYAndSeAndPgIdIsNullGroupClId($acadYear, $semester, $oPg->programId);
while($oEi->GetRecord()) {
$oPf->prefixName = '';
$oOf->officerName = '';
$oOf->officerSurname = '';
$oCl->SearchByKey($oEi->classId);
$oCl->GetRecord();
if($oCl->sendGradeStatus == 'N') {
$oCo->SearchByKey($oCl->courseId);
$oCo->GetRecord();
$oCi->RSClassInStructorByClIdAndResponsibilityIsY($oEi->classId);
if($oCi->GetRecord()) {
$oOf->SearchByKey($oCi->officerId);
$oOf->GetRecord();
$oPf->SearchByKey($oOf->prefixId);
$oPf->GetRecord();
}
if(($i%2) == 0)
echo "<tr>";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
?>
<tr>
<td height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"><?php echo $k+1;?></font></td>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"><?php echo $oCo->courseCode.' '.$oCo->courseName;?></font> <font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>">(เรียนรวมหลายหลักสูตร)</font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"><?php echo $oCl->section;?></font></td>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"><?php echo $oPf->prefixName.$oOf->officerName.' '.$oOf->officerSurname;?></font></td>
</tr>
<?php
$k++;
$i++;
}
}
if($i == 0) {
?>
<tr>
<td height="22"></td>
<td>-</td>
<td align="center">-</td>
<td>-</td>
</tr>
<?php
}
}
?>
<tr>
<td colspan="3"> </td>
<td height="22" align="right"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>">รวม <?php echo $k;?> รายการ</font></td>
</tr>
<tr>
<td height="22" colspan="4"></td>
</tr>
</table>
<br />
<table width="750" border="0" cellpadding="2" cellspacing="2">
<tr>
<td width="10%"><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2" class="TEXT-RED10"><b>หมายเหตุ : </b></font></td>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">N = ปกติ, N* = ถอนรายวิชาที่ลงทะเบียนก่อนช่วงเพิ่ม-ถอน</font></td>
</tr>
<tr>
<td></td>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">A = เพิ่ม, A* = ถอนรายวิชาที่ลงทะเบียนในช่วงเพิ่ม-ถอน</font></td>
</tr>
<tr>
<td></td>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">C = ถอนรายวิชาเนื่องจากรักษาสภาพ, T = รายวิชาเทียบเท่า/เทียบโอน</font></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr></form>
</table>
</fieldset></td>
</tr>
</table>
<?php include( "./templates/incFooter.php" ); ?>
</body>
</html>
<?php
/** Free Resource */
$oPr->Destroy();
$oDy->Destroy();
$oCt->Destroy();
$oCo->Destroy();
$oCl->Destroy();
$oWc->Destroy();
$oEi->Destroy();
$oEr->Destroy();
$oSse->Destroy();
$oPg->Destroy();
$oPf->Destroy();
$oSm->Destroy();
$conn->Disconnect();
?>
|