Viewing file: course_bkp.php (13.74 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("admin_menu.php");
include_once "./class/clsProgram.php";
include_once "./class/clsSysSemesterDes.php";
include_once "./class/clsSysStudentYearDes.php";
include_once "./class/clsAcadYearConfig.php";
include_once "./class/clsClass.php";
include_once "./class/clsCourse.php";
include_once "./class/clsClassTimeTable.php";
include_once "./class/clsPeriod.php";
include_once "class/clsDay.php";
include_once "class/clsRoom.php";
include_once "global.php";
$conn = new Connection();
$oPg = new Program();
$oPg2 = new Program();
$oSs = new SysSemesterDes();
$oSy = new SysStudentYearDes();
$oAc = new AcadYearConfig();
$oCl = new Class1();
$oCo = new Course();
$oCo2 = new Course();
$oCtb = new ClassTimeTable();
$oCtb2 = new ClassTimeTable();
$oCtb3 = new ClassTimeTable();
$oPr = new Period();
$oPr2 = new Period();
$oDy = new Day();
$oRm = new Room();
confirmSubmit();
openNewWindow();
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<link href="/source/style.css" rel="stylesheet" type="text/css">
<table width="750" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><td><form name="pc" action="<?php echo $PHP_SELF;?>" method="post"><br>
<fieldset>
<legend> <font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="Menu_Course.php">หน้าหลัก</a> <img src="picture/ico3.gif" align="absmiddle" border="0" /><a href="programs.php">หลักสูตรที่เปิดสอน</a> <img src="picture/ico3.gif" align="absmiddle" border="0" /><a href="showSchedule.php">ปฏิทินการศึกษา</a> <img src="picture/ico3.gif" align="absmiddle" border="0" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="showDetailStudyPlan.php">โปรแกรมการศึกษา</a> <img src="picture/ico3.gif" align="absmiddle" border="0" /></font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3']; ?>"><a href="checkEnrollItem.php"> ตรวจสอบรายวิชาลงทะเบียนเรียน</a></font></legend>
<table width="650" border="0" cellspacing="3" cellpadding="0" align="center">
<tr>
<td><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"><font size="3" color="<?php echo $GLOBALS['COLOR_FONT_3']; ?>"><b>ค้นหารายวิชาที่เปิดสอนตามหลักสูตร</b></font></td>
</tr>
<?php
// if($method!='search'){
?>
<tr>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>หลักสูตร : </b>
<select name="programId">
<?php
if($programId!=''){
$oPg->SearchByKey($programId);
$oPg->GetRecord();
?>
<option value="<?php echo $programId;?>" selected><?php echo $oPg->programId1." ".$oPg->programName;?></option>
<?php
}else{
?>
<option value="" selected>--เลือกหลักสูตร--</option>
<?php
}
$i=0;
$oPg->RSProgram();
while($oPg->GetRecord()){
?>
<option value="<?php echo $oPg->programId;?>"><?php echo $oPg->programCode1." ".$oPg->programName;?></option>
<?
$i++;
}
?>
</select>
</font></td>
</tr>
<tr>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>ปีการศึกษา :
<select name="acadYear">
<?php
if($acadYear!=''){
?>
<option value="<?php echo $acadYear;?>" selected><?php echo $acadYear;?></option>
<?php
}else{
?>
<option value="" selected>--เลือกปีการศึกษา--</option>
<?php
}
$i=0;
$oAc->RSAcadYearConfigGroupAcY();
while($oAc->GetRecord()){
?>
<option value="<?php echo $oAc->acadYear;?>"><?php echo $oAc->acadYear;?></option>
<?
$i++;
}
?>
</select>
ภาคการศึกษา :
<select name="semester">
<?php
if($semester!=''){
$oSs->SearchByKey($semester);
$oSs->GetRecord();
?>
<option value="<?php echo $semester;?>" selected><?php echo $semester1." ".$oSs->semesterName;?></option>
<?php
}else{
?>
<option value="" selected>--เลือกภาคการศึกษา--</option>
<?php
}
$i=0;
$oSs->RSSysSemesterDes();
while($oSs->GetRecord()){
?>
<option value="<?php echo $oSs->semester;?>"><?php echo $oSs->semester1." ".$oSs->semesterName;?></option>
<?
$i++;
}
?>
</select>
</b></font></td>
</tr>
<tr>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>ชั้นปีที่ : </b></font>
<select name="studentYear">
<?php
if($studentYear!=''){
$oSy->SearchByKey($studentYear);
$oSy->GetRecord();
?>
<option value="<?php echo $studentYear;?>" selected><?php echo $studentYear1." ".$oSy->studentYearName;?></option>
<?php
}else{
?>
<option value="" selected>--เลือกชั้นปีที่--</option>
<?php
}
$i=0;
$oSy->RSSysStudentYearDes();
while($oSy->GetRecord()){
?>
<option value="<?php echo $oSy->studentYear;?>"><?php echo $oSy->studentYear1." ".$oSy->studentYearName;?></option>
<?
$i++;
}
?>
</select>
<input type="submit" name="search00" value="ค้นหา"><input type="hidden" name="method" value="search00"><input type="hidden" name="courseCode"><input type="hidden" name="courseName"></td>
</tr>
<tr><td> </td></tr>
<tr>
<td height="22"><font size="3" color="<?php echo $GLOBALS['COLOR_FONT_3']; ?>"><b>ค้นหารายวิชาที่เปิดสอนตามรหัสรายวิชาและชื่อรายวิชา</b></font></td>
</tr>
<tr><td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>รหัสวิชา : <input type="text" name="courseCode" size="5" maxlength="15" value="<?php echo $courseCode;?>"> ชื่อวิชา (ไทย) : </b><input type="text" name="courseName" size="25" value="<?php echo $courseName;?>"></font></td></tr>
<tr><td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>ชื่อวิชา (อังกฤษ) : <input type="text" name="courseNameEng" size="25" value="<?php echo $courseNameEng;?>"><input type="submit" name="search" value="ค้นหา"></b></font></td></tr>
<?php
// }else{
if($search00){
$oPg2->SearchByKey($programId);
$oPg2->GetRecord();
?>
<tr><td align="center">
<table align="center" width="700">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td width="62" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>รหัสวิชา</b></font></td>
<td width="217" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>ชื่อวิชา</b></font></td>
<td width="57" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>หน่วยกิต</b></font></td>
<td width="230" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>วัน/เวลา/ห้องเรียน</b></font></td>
<td width="45" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>กลุ่ม</b></font></td>
<td width="61" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>รับ/ลง</b></font></td>
</tr>
<?php
$c=0;
$oCl->RSClassByPgIdAndStYAndSeAndAcY($programId, $studentYear, $semester, $acadYear);
while($oCl->GetRecord()){
// echo "ClassId22 -> ".$oCtb->classId."<br>";
$oCo2->SearchByKey($oCl->courseId);
$oCo2->GetRecord();
$oCtb->RSClassTimeTableByClId($oCl->classId);
$oCtb->GetRecord();
// while($oCtb->GetRecord()){
if(($c%2) == 0)
echo '<tr>';
else
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<td height="22"><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b><a href="#" onClick="openNewWindow('showDetailClass.php?classId=<?php echo $oCl->classId;?>','','scrollbars=yes,width=500,height=350')" class="nav"><?php echo $oCo2->courseCode;?></a></b></font></td>
<td><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><?php echo $oCo2->courseName."<br>".$oCo2->courseNameEng;?></font></td>
<td align="center"><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><?php echo $oCo2->courseUnit;?></font></td>
<td><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>">
<?php
$oCtb3->RSClassTimeTableByClId($oCl->classId);
while($oCtb3->GetRecord()){
$oCtb2->SearchByKey($oCtb3->sequenceId,$oCtb3->classId);
$oCtb2->GetRecord();
$oDy->SearchByKey($oCtb2->weekDay);
$oDy->GetRecord();
$oPr->SearchByKey($oCtb2->timeSlotStart);
$oPr->GetRecord();
$oPr2->SearchByKey($oCtb2->timeSlotEnd);
$oPr2->GetRecord();
$oRm->SearchByKey($oCtb2->roomId);
$oRm->GetRecord();
echo $oDy->dayName." / ".$oPr->startTime."-".$oPr2->endTime." / ".$oRm->roomNo."<br>";
}
?>
</font></td>
<td align="center"><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><?php echo $oCl->section;?></font></td>
<td align="center"><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><?php echo $oCl->totalSeat." / ".$oCl->enrollSeat;?></font></td>
</tr>
<?php
$c++;
// }
}
if($c==0){
?>
<tr><td align="center" height="22" colspan="6"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3']; ?>">** ไม่ปรากฏรายวิชาที่ค้นหา **</font></td></tr>
<?php
}
?>
<tr><td colspan="6"><input type="button" name="back" value="ย้อนกลับ" onClick="location.href='<?php echo $PHP_SELF;?>?method=no'"></td></tr>
</table>
</td></tr>
<?php
}else if($search){
?>
<tr><td align="center"><table width="700">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td width="66" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>รหัสวิชา</b></font></td>
<td width="213" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>ชื่อวิชา</b></font></td>
<td width="59" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>หน่วยกิต</b></font></td>
<td width="230" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>วัน/เวลา/ห้องเรียน</b></font></td>
<td width="43" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>กลุ่ม</b></font></td>
<td width="61" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1']; ?>"><b>รับ/ลง</b></font></td>
</tr>
<?php
//echo "CoCo -> ".$courseCode."<br>";
$oCo->SearchByCourseCodeAndCourseName($courseCode,$courseName,$courseNameEng);
while($oCo->GetRecord()){
//echo "CoId -> ".$oCo->courseId."<br>";
$oCl->RSClassByCoId($oCo->courseId);
while($oCl->GetRecord()){
$oCo2->SearchByKey($oCl->courseId);
$oCo2->GetRecord();
$oCtb->RSClassTimeTableByClId($oCl->classId);
$oCtb->GetRecord();
// while($oCtb->GetRecord()){
if(($c%2) == 0)
echo '<tr>';
else
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<td height="22"><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b><a href="#" onClick="openNewWindow('showDetailClass.php?classId=<?php echo $oCl->classId;?>','','scrollbars=yes,width=500,height=350')" class="nav"><?php echo $oCo2->courseCode;?></a></b></font></td>
<td><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><?php echo $oCo2->courseName."<br>".$oCo2->courseNameEng;?></font></td>
<td align="center"><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><?php echo $oCo2->courseUnit;?></font></td>
<td><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>">
<?php
$oCtb3->RSClassTimeTableByClId($oCl->classId);
while($oCtb3->GetRecord()){
$oCtb2->SearchByKey($oCtb3->sequenceId,$oCtb3->classId);
$oCtb2->GetRecord();
$oDy->SearchByKey($oCtb2->weekDay);
$oDy->GetRecord();
$oPr->SearchByKey($oCtb2->timeSlotStart);
$oPr->GetRecord();
$oPr2->SearchByKey($oCtb2->timeSlotEnd);
$oPr2->GetRecord();
$oRm->SearchByKey($oCtb2->roomId);
$oRm->GetRecord();
echo $oDy->dayName." / ".$oPr->startTime."-".$oPr2->endTime." / ".$oRm->roomNo."<br>";
}
?>
</font></td>
<td align="center"><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><?php echo $oCl->section;?></font></td>
<td align="center"><font size="1" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><?php echo $oCl->totalSeat." / ".$oCl->enrollSeat;?></font></td>
</tr>
<?php
$c++;
} // loop class
} // loop course
if($c==0){
?>
<tr><td align="center" height="21" colspan="6"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3']; ?>">** ไม่ปรากฏรายวิชาที่ค้นหา **</font></td></tr>
<?php
}
?>
<tr><td colspan="6"><input type="button" name="back" value="ย้อนกลับ" onClick="location.href='<?php echo $PHP_SELF;?>?method=no'"></td></tr>
</table>
</td>
</tr>
<?php
} // end if
// }
?>
<tr><td> </td></tr>
</table>
</fieldset>
</form>
</td>
</tr>
<tr>
<td height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3'];?>"><?php if($method!="search"){ ?><b>คำแนะนำ :</b> ท่านสามารถค้นหารายวิชาที่เปิดสอนได้โดยสามารถเลือกจากหลักสูตร, ปีการศึกษาและภาคการศึกษา, รหัสวิชาหรือรายวิชา<?php }else if($method=="search"){ ?><b>หมายเหตุ : </b>นำเมาท์ไปคลิกที่ชื่อที่รหัสรายวิชาเพื่อดูรายละเอียดของรายวิชาที่เปิดสอน<?php }?></font></td>
</tr>
<tr>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3'];?>"> </font></td>
</tr>
</table>
</td>
</tr>
</table>
<?php
$oPg->Destroy();
$conn->Disconnect();
?>
|