Viewing file: checkNoSendGradeCourse.php (7.2 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once "admin_menu.php";
include_once "template.php";
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();
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<table width="740" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><br><fieldset>
<legend><font size="2" color="#8C0000"><a href="course.php">รายวิชาที่เปิดสอน</a> <img src="../picture/ico3.gif" align="absmiddle" border="0"> ตรวจสอบรายวิชาที่ยังไม่ได้ส่งเกรด</font></legend>
<label><div align="center"><br><table width="649" border="1" 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="333" 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="199" 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"]."\">";
?>
<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"]."\">";
?>
<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>
</div></label>
</fieldset><br></td>
</tr>
</table>
<?php
$oPf->Destroy();
$oOf->Destroy();
$oCi->Destroy();
$oCo->Destroy();
$oCl->Destroy();
$oEi->Destroy();
$oPg->Destroy();
$oAy->Destroy();
$oSse->Destroy();
$conn->Disconnect();
?>
|