Viewing file: checkEnrollItem_bkp.php (13.56 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once "admin_menu.php";
include_once "template.php";
include_once "./class/clsStudentMaster.php";
include_once "./class/clsPrefix.php";
include_once "./class/clsProgram.php";
include_once "./class/clsSysSemesterDes.php";
include_once "./class/clsEnroll.php";
include_once "./class/clsEnrollItem.php";
include_once "./class/clsWithdrawCourse.php";
include_once "./class/clsClass.php";
include_once "./class/clsCourse.php";
include_once "./class/clsClassTimeTable.php";
include_once "./class/clsDay.php";
include_once "class/clsPeriod.php";
include_once "./class/clsOfficer.php";
$conn = new Connection();
$oSm = new StudentMaster();
$oPf = new Prefix();
$oPg = new Program();
$oSse = new SysSemesterDes();
$oEr = new Enroll();
$oEi = new EnrollItem();
$oWc = new WithdrawCourse();
$oCl = new Class1();
$oCo = new Course();
$oCt = new ClassTimeTable();
$oDy = new Day();
$oPr = new Period();
$oOf = new Officer();
?>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<table width="804" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="804"><br>
<fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="checkEnrollFee.php">ตรวจสอบค่าลงทะเบียนเรียน</a></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="adminIndex.php?mm=1"></a> <img src="../picture/ico3.gif" align="absmiddle" border="0"><a href="checkNoSendGradeCourse.php"> ตรวจสอบรายวิชาที่ยังไม่ได้ส่งเกรด</a> </font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><img src="../picture/ico3.gif" align="absmiddle" border="0" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>">ตรวจสอบรายวิชาลงทะเบียนเรียน</font></legend>
<label><div align="center"><br><form name="pc" method="post" action="<?php echo $PHP_SELF;?>"><table width="741" align="center" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="22"><font size="2" face="Tahoma"><img src="./picture/previous.gif" onclick="window.history.back()" width="85" height="22" border="0" /></font></td>
</tr>
<tr>
<td height="22"></td>
</tr>
<?php
if($studentCode) {
$oSm->SearchByStCode($studentCode);
if($oSm->GetRecord()) {
$oPf->SearchByKey($oSm->prefixId);
$oPf->GetRecord();
?>
<tr>
<td><table width="769" border="0" cellspacing="0" cellpadding="0" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"];?>">
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td width="111" height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>รหัสนักศึกษา</b></font></td>
<td width="395"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $oSm->studentCode;?></font>
<input type="hidden" name="studentId" value="<?php echo $oSm->studentId;?>"></td>
<td width="92"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>ชื่อ-นามสกุล</b></font></td>
<td width="161"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $oPf->prefixName.$oSm->studentName.' '.$oSm->studentSurname;?></font></td>
</tr>
<?php
$oPg->SearchByKey($oSm->programId);
$oPg->GetRecord();
?>
<tr>
<td height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>หลักสูตร</b></font></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $oPg->programName;?></font>
<input type="hidden" name="programId" value="<?php echo $oSm->programId;?>"></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>ชั้นปี</b></font></td>
<td><input type="text" name="studentYear" value="<?php echo $oSm->studentYear;?>" size="1" class="input1"></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>ปีการศึกษา</b></font></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $GLOBALS["ACADYEAR"];?></font></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>ภาคการศึกษา</b></font></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $GLOBALS["SEMESTER"];?></font></td>
</tr>
</table></td>
</tr>
<tr>
<td height="22"></td>
</tr>
<?php
if(!$acadYear)
$acadYear = $GLOBALS["ACADYEAR"];
if(!$semester)
$semester = $GLOBALS["SEMESTER"];
$oSse->SearchByKey($semester);
$oSse->GetRecord();
?>
<tr>
<td height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3'];?>"><b>ปีการศึกษา</b>
<select name="acadYear" onChange="location.href = 'checkEnrollItem.php?studentCode=<?php echo $studentCode;?>&acadYear=' + encodeURI(options[selectedIndex].value)">
<option value="<?php echo $acadYear;?>"><?php echo $acadYear;?></option>
<?php
$oEr->RSEnrollByStIdGroupAcY($oSm->studentId);
while($oEr->GetRecord()) {
?>
<option value="<?php echo $oEr->acadYear;?>"><?php echo $oEr->acadYear;?></option>
<?php
}
?>
</select>
<b>ภาคการศึกษา</b></font>
<select name="semester" onChange="location.href = 'checkEnrollItem.php?studentCode=<?php echo $studentCode;?>&acadYear=<?php echo $acadYear;?>&semester=' + encodeURI(options[selectedIndex].value)">
<?php
if($semester) {
?>
<option value="<?php echo $semester;?>"><?php echo $oSse->semesterName;?></option>
<?php
}
?>
<option value="-">---เลือกภาคการศึกษา---</option>
<?php
$oEr->RSEnrollByStIdAndAcYGroupSe($oSm->studentId, $acadYear);
while($oEr->GetRecord()) {
$oSse->SearchByKey($oEr->semester);
$oSse->GetRecord();
?>
<option value="<?php echo $oEr->semester;?>"><?php echo $oSse->semesterName;?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td><table width="808">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td width="78" height="22" align="center" bgcolor="#CCCC99"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>รหัสรายวิชา</strong></font></td>
<td width="218" align="center" bgcolor="#CCCC99"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>ชื่อรายวิชา</strong></font></td>
<td width="57" align="center" bgcolor="#CCCC99"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>หน่วยกิต</strong></font></td>
<td width="36" align="center" bgcolor="#CCCC99"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>กลุ่ม</strong></font></td>
<td width="217" align="center" bgcolor="#CCCC99"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>วัน/เวลา</strong></font></td>
<td width="108" align="center" bgcolor="#CCCC99"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>อ.ผู้สอน</strong></font></td>
<td width="62" align="center" bgcolor="#CCCC99"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>สถานะ</strong></font></td>
</tr>
<?php
$i = 0;
$oEi->RSEnrollItemByStIdAndAcYAndSe($oSm->studentId, $acadYear, $semester);
while($oEi->GetRecord()) {
$oEr->SearchByKey($oSm->studentId, $oEi->acadYear, $oEi->semester, $oEi->sequence);
$oEr->GetRecord();
$oCl->SearchByKey($oEi->classId);
$oCl->GetRecord();
$oCo->SearchByKey($oCl->courseId);
$oCo->GetRecord();
if(($i%2) == 0)
echo '<tr>';
else
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<tr><td height="22" bgcolor="#CCCCCC"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->courseCode;?></font></td>
<td bgcolor="#CCCCCC"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->courseName;?></font></td>
<td align="center" bgcolor="#CCCCCC"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->courseUnit;?></font></td>
<td align="center" bgcolor="#CCCCCC"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCl->section;?></font></td>
<td bgcolor="#CCCCCC"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">
<?php
$oCt->RSClassTimeTableByClId($oEi->classId);
while($oCt->GetRecord()) {
$oDy->SearchByKey($oCt->weekDay);
$oDy->GetRecord();
echo $oDy->dayAbbrEng.' ';
$oPr->SearchByKey($oCt->timeSlotStart);
$oPr->GetRecord();
echo $oPr->startTime.'-';
$oPr->SearchByKey($oCt->timeSlotEnd);
$oPr->GetRecord();
echo $oPr->endTime.'<br>';
}
?>
</font></td>
<td align="left" bgcolor="#CCCCCC"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"> <?php echo $oPf->prefixName.$oOf->officerName.' '.$oOf->officerSurname;?></font></td>
<td align="center" bgcolor="#CCCCCC"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oEr->enrollStatus;?></font></td>
</tr>
<?php
$i++;
} // end while
$j = $i;
$oWc->RSWithdrawCourseByStIdAndAcYAndSe($oSm->studentId, $acadYear, $semester);
while($oWc->GetRecord()) {
$oEr->SearchByKey($oSm->studentId, $oWc->acadYear, $oWc->semester, $oWc->sequence);
$oEr->GetRecord();
$oCl->SearchByKey($oWc->classId);
$oCl->GetRecord();
$oCo->SearchByKey($oCl->courseId);
$oCo->GetRecord();
if(($j%2) == 0)
echo '<tr>';
else
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<tr><td height="23"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->courseCode;?></font></td>
<td><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->courseName;?></font></td>
<td align="center"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->courseUnit;?></font></td>
<td align="center"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCl->section;?></font></td>
<td><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">
<?php
$oCt->RSClassTimeTableByClId($oWc->classId);
while($oCt->GetRecord()) {
$oDy->SearchByKey($oCt->weekDay);
$oDy->GetRecord();
echo $oDy->dayAbbrEng.' ';
$oPr->SearchByKey($oCt->timeSlotStart);
$oPr->GetRecord();
echo $oPr->startTime.'-';
$oPr->SearchByKey($oCt->timeSlotEnd);
$oPr->GetRecord();
echo $oPr->endTime.'<br>';
}
?>
</font></td>
<td align="left"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"><?php echo $oPf->prefixName.$oOf->officerName.' '.$oOf->officerSurname;?></font></td>
<td align="center"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oEr->enrollStatus.'*';?></font></td>
</tr>
<?php
$j++;
} // end while
if($j == 0) {
?>
<tr>
<td colspan="7" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">** ไม่ปรากฏรายวิชาในการลงทะเบียนเรียน **</font></td>
</tr>
<?php
}
$oEr->RSEnrollByStIdAndAcYAndSeAndErStatus($oSm->studentId, $acadYear, $semester, 'K');
$kssFlag = $oEr->GetRecord();
if($kssFlag) {
?>
<tr>
<td colspan="7" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">** รักษาสถานภาพการเป็นนักศึกษา **</font></td>
</tr>
<?php
}
?>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
<td height="22" colspan="2" align="right"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>รวมหน่วยกิต</b></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><?php echo number_format($oEi->GetSumCrAtByStIdAndAcYAndSe($oSm->studentId, $acadYear, $semester));?></font></td>
<td colspan="4"></td>
</tr>
</table></td>
</tr>
<tr>
<td><br><input type="button" name="back" value="กลับเมนูหลัก" onClick="location.href = 'adminIndex.php?mm=1'"></td>
</tr>
<?php
}
else {
?>
<tr>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">** ไม่ปรากฏรหัสนักศึกษาดังกล่าวในฐานข้อมูล **</font></td>
</tr>
<?php
}
}
?>
</table>
</form></div></label>
</fieldset><br></td>
</tr>
<tr>
<td><table width="650">
<tr>
<td width="10%"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><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>
</table>
<?php
$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();
?>
|