Viewing file:  checkEnrollItem.php (15.45 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/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();
?>
<!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="750" align="center" border="0" cellpadding="0" cellspacing="0">
<?php
if( $studentCode ) {
$oSm->SearchByStCode($studentCode);
if( $oSm->GetRecord() ) {
$oPf->SearchByKey($oSm->prefixId);
$oPf->GetRecord();
?>
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"];?>">
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td width="110" height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>รหัสนักศึกษา</b></font></td>
<td width="400"><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="97"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>ชื่อ-นามสกุล</b></font></td>
<td width="201"><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" style="text-align:center"></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> </td>
</tr>
<?php
if( !$acadYear )
$acadYear = $GLOBALS["ACADYEAR"];
if( !$semester )
$semester = $GLOBALS["SEMESTER"];
$oSse->SearchByKey($semester);
$oSse->GetRecord();
?>
<tr>
<td height="30"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3'];?>"><b>ปีการศึกษา</b>
<select name="acadYear" onChange="location.href = 'checkEnrollItem.php?studentCode=<?php echo $studentCode;?>&studentId=<?php echo $studentId;?>&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
} # while
?>
</select>
<b>ภาคการศึกษา</b></font>
<select name="semester" onChange="location.href = 'checkEnrollItem.php?studentCode=<?php echo $studentCode;?>&studentId=<?php echo $studentId;?>&acadYear=<?php echo $acadYear;?>&semester=' + encodeURI(options[selectedIndex].value)">
<?php
if($semester) {
?>
<option value="<?php echo $semester;?>"><?php echo $oSse->semesterName;?></option>
<?php
} # if
?>
<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
} # while
?>
</select></td>
</tr>
<tr>
<td><table width="750" border="0" cellpadding="1" cellspacing="1">
<tr bgcolor="#CCCCCC">
<td width="78" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>รหัสรายวิชา</strong></font></td>
<td width="218" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>ชื่อรายวิชา</strong></font></td>
<td width="57" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>หน่วยกิต</strong></font></td>
<td width="36" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>กลุ่ม</strong></font></td>
<td width="217" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>วัน/เวลา</strong></font></td>
<td width="108" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>อ.ผู้สอน</strong></font></td>
<td width="62" align="center"><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="#EEEEEE"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->courseCode;?></font></td>
<td bgcolor="#EEEEEE"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->courseName;?></font></td>
<td align="center" bgcolor="#EEEEEE"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->courseUnit;?></font></td>
<td align="center" bgcolor="#EEEEEE"><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCl->section;?></font></td>
<td bgcolor="#EEEEEE"><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>';
} # while
?>
</font></td>
<td align="left" bgcolor="#EEEEEE"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"]; ?>"> <?php echo $oPf->prefixName.$oOf->officerName.' '.$oOf->officerSurname;?></font></td>
<td align="center" bgcolor="#EEEEEE"><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>';
} # while
?>
</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
} # if
$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
} # if
?>
<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" class="NOTE"><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 align="center"><br><input type="button" name="back" value="« ย้อนกลับ" onClick="location.href = 'StudentList.php'"></td>
</tr>
<?php
} # if
else {
?>
<tr>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">** ไม่ปรากฏรหัสนักศึกษาดังกล่าวในฐานข้อมูล **</font></td>
</tr>
<?php
} # else
} # if
?>
</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();
?>
|