Viewing file: showClassTeach.php (13.32 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("admin_menu.php");
include_once "./link/function.php";
include_once "./class/clsSysSemesterDes.php";
include_once "./class/clsSysStudentYearDes.php";
include_once "./class/clsOfficer.php";
include_once "./class/clsPrefix.php";
include_once "./class/clsEnrollItem.php";
include_once "./class/clsPeriod.php";
include_once "./class/clsDay.php";
include_once "./class/clsClassTimeTable.php";
include_once "./class/clsClassInStructor.php";
include_once "./class/clsClassExam.php";
include_once "./class/clsCourse.php";
include_once "./class/clsClass.php";
include_once "./class/clsRoom.php";
include_once "./class/clsAcadYearConfig.php";
include_once "global.php";
$conn = new Connection();
$oSs = new SysSemesterDes();
$oSy = new SysStudentYearDes();
$oPf = new Prefix();
$oFf = new Officer();
$oEt = new EnrollItem();
$oEt2 = new EnrollItem();
$oPr = new Period();
$oPr2 = new Period();
$oDy = new Day();
$oCtb = new ClassTimeTable();
$oCis = new ClassInStructor;
$oCtb2 = new ClassTimeTable();
$oCis2 = new ClassInStructor;
$oCo = new Course();
$oCl = new Class1();
//$oCl2 = new Class1();
$oRm = new Room();
$oCe = new ClassExam();
$oCe2 = new ClassExam();
$oAy2 = new AcadYearConfig();
$oAy3 = new AcadYearConfig();
confirmSubmit();
openNewWindow();
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<table width="817" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="817"><br>
<fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="PersonalData.php">ข้อมูลบุคลากร</a></font> <font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><img src="./picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /></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="795" border="0" cellspacing="1" cellpadding="1" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"];?>" align="center">
<tr>
<td align="center"><div align="left"><font size="2" face="Tahoma"><img src="./picture/previous.gif" onclick="window.history.back()" width="85" height="22" border="0" /></font></div></td>
</tr>
<tr><td width="791" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="3"><b>ตารางสอน/สอบอาจารย์</b></font></td>
</tr>
<tr><td> </td>
</tr>
<tr><td colspan="2"><table align="center" width="786" cellpadding="1" cellspacing="1" border="0">
<?php
$oFf->SearchByOfCodeOfNOfSn($officerCode,$officerName,$officerSurname);
$oFf->GetRecord();
$oPf->SearchByKey($oFf->prefixId);
$oPf->GetRecord();
if($oFf->officerId=='' or $officerCode=='' && $oFf->officerName=='' && $oFf->officerSurname==''){
//echo "<meta http-equiv='refresh' content='0; URL=$PHP_SELF?methodSearch=no'>";
?>
<tr>
<td width="782" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2">** กรุณาตรวจสอบข้อมูลอาจารย์ <a href="beforeShowClassTeach.php?methodSearch=no">คลิกที่นี่</a> **</font></td>
</tr>
<?php
}else{
?>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td><table align="center" width="720" cellpadding="1" cellspacing="1" border="0">
<tr>
<td width="150"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>" size="2"><b>รหัสอาจารย์</b></font></td>
<td><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>" size="2"><?php echo " : ".$oFf->officerCode;?></font></td>
</tr>
<tr>
<td><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>" size="2"><b>ชื่อ-นามสกุลอาจารย์</b></font></td>
<td><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>" size="2"><?php echo " : ".$oPf->prefixName.$oFf->officerName." ".$oFf->officerSurname;?></font></td>
</tr>
</table></td>
</tr>
<tr><td> </td></tr>
<tr><td><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>" size="3">
ปีการศึกษา
<select name="acadYear" onChange = "location.href ='<?php echo $PHP_SELF;?>?acadYear='+encodeURI(options[selectedIndex].value)+'&officerCode=<?php echo $officerCode;?>&officerName=<?php echo $officerName;?>&officerSurname=<?php echo $officerSurname;?>'">
<?php
//+'&studentCode='+studentCode.value+'&studentName='+studentName.value+'&studentSurname='+studentSurname.value
if($acadYear==''){
?>
<option value="<?php echo $GLOBALS["ACADYEAR"];?>" selected><?php echo $GLOBALS["ACADYEAR"];?></option>
<?php
}else{
?>
<option value="<?php echo $acadYear;?>" selected><?php echo $acadYear;?></option>
<?php
}
$oAy2->RSAcadYearConfigGroupAcY();
while($oAy2->GetRecord()){
?>
<option value="<?php echo $oAy2->acadYear;?>"><?php echo $oAy2->acadYear;?></option>
<?php
}
?>
</select>
ภาคการศึกษา
<?php
//echo " | ";
$i=0;
if($acadYear!='')
$oAy3->RSAcadYearConfigByAcadYearGBSem($acadYear);
else
$oAy3->RSAcadYearConfigByAcadYearGBSem($GLOBALS["ACADYEAR"]);
while($oAy3->GetRecord()){
$oSs->SearchByKey($oAy3->semester);
$oSs->GetRecord();
if($acadYear==""){
$acadYear=$GLOBALS["ACADYEAR"];
}
if($semester==""){
$semester=$GLOBALS["SEMESTER"];
}
echo "<a href='$PHP_SELF?acadYear=$acadYear&semester=$oSs->semester&officerCode=$officerCode&officerName=$officerName&officerSurname=$officerSurname'>";
if($oSs->semester==$semester){
echo "<b>".$oSs->semester."</b>";
}else{
echo $oSs->semester;
}
echo "</a>";
echo " ";
$i++;
}
?>
</font><br>
<font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="3"><b>ตารางสอน</b></font>
</td></tr>
<tr>
<td>
<table align="center" width="783" cellpadding="1" cellspacing="1" border="1">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td height="22" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><b>วัน/เวลา</b></font></td>
<?php
$oPr->RSPeriod();
$oPr->GetRecord();
$numr=$oPr->NumRow();
for($j=0;$j<$numr;$j++){
?>
<td width="701" height="22" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><b>
<?php
$oPr->SearchByKey($j+1);
$oPr->GetRecord();
echo substr($oPr->startTime,0,5)."-".substr($oPr->endTime,0,5);
?>
</b></font></td>
<?php
}
?>
</tr>
<?php
$i=0;
$j=0;
$oDy->RSDay();
while($oDy->GetRecord()){
?>
<tr bgcolor="#E6E6E6">
<td height="22" width="60"><font color="<?php if($i==0){ echo $GLOBALS["COLOR_FONT_4"]; }else{echo $GLOBALS["COLOR_FONT_4"];}?>" size="2"><b><?php echo $oDy->dayName;?></b></font></td>
<?php
for($j=0;$j<$numr;$j++){
?>
<td align="center" colspan="
<?php
$x=0;
$oCis->SearchCISByOfId($oFf->officerId);
while($oCis->GetRecord()){
if($acadYear!="" || $semester!="")
$oEt->RSEnrollItemByClsIdAcySem($oCis->classId,$acadYear,$semester);
else
$oEt->RSEnrollItemByClsIdAcySem($oCis->classId,$GLOBALS["ACADYEAR"],$GLOBALS["SEMESTER"]);
if($oEt->GetRecord()){
$oCtb->SearchCTTByClsIdWdSt($oCis->classId,$i+1,$j+1);
if($oCtb->GetRecord()){
$x=$oCtb->timeSlotEnd - $oCtb->timeSlotStart;
echo $x+1;
$j+=$x;
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$oCl->SearchByKey($oCtb->classId);
$oCl->GetRecord();
$oCo->SearchByKey($oCl->courseId);
$oCo->GetRecord();
$oRm->SearchByKey($oCtb->roomId);
$oRm->GetRecord();
$D=$oCo->courseCode." (".$oCl->section.") ".$oRm->roomNo;
$E="<a href=\"#\" onClick=\"openNewWindow('showDetailProgram.php?programId=$oCl->programId','','scrollbars=yes,width=500,height=450')\" class=\"nav\">";
$T=" <b>(".$oCl->programId.")</b></a>";
$DET=$D.$E.$T;
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
}
}
}
?>
" bgcolor="<?php if($DET==""){ echo $GLOBALS["COLOR_BG_TABLE_3"]; }else{ echo $GLOBALS["COLOR_BG_TABLE_5"]; } ?>"><font color="<?php if($i==0){ echo $GLOBALS["COLOR_FONT_4"]; }else{echo $GLOBALS["COLOR_FONT_4"];}?>" size="2">
<?php
echo $DET;
$DET="";
?>
</font></td>
<?php
} // end for
?>
</tr>
<?php
$i++;
} // end while
?>
</table><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2">** ข้อมูลที่ปรากฏในตารางเรียนคือ รหัสวิชา กลุ่มเรียน ห้องเรียนและรหัสหลักสูตรตามลำดับ</font><br><br> </td>
</tr>
<tr><td><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="3"><b>ตารางสอบ</b></font></td></tr>
<tr><td><table width="720" border="1" align="center" cellpadding="1" cellspacing="0">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td align="center" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><b>รหัสวิชา</b></font></td>
<td align="center" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><b>วิชา/กลุ่ม</b></font></td>
<td align="center" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><b>สอบกลางภาค</b></font></td>
<td align="center" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><b>สอบปลายภาค</b></font></td>
</tr>
<?php
$ce=0;
$oCis->SearchCISByOfId($oFf->officerId);
while($oCis->GetRecord()){
if($acadYear!="" || $semester!="")
$oEt->RSEnrollItemByClsIdAcySem($oCis->classId,$acadYear,$semester);
else
$oEt->RSEnrollItemByClsIdAcySem($oCis->classId,$GLOBALS["ACADYEAR"],$GLOBALS["SEMESTER"]);
if($oEt->GetRecord()){
$oCe->RSClassExamByClsId($oCis->classId);
while($oCe->GetRecord()){
$oCl->SearchByKey($oCe->classId);
$oCl->GetRecord();
$oCo->SearchByKey($oCl->courseId);
$oCo->GetRecord();
$oRm->SearchByKey($oCe->roomId);
$oRm->GetRecord();
?>
<tr bgcolor="#E6E6E6">
<td height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>" size="2"><?php echo $oCo->courseCode;?></font></td>
<td height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>" size="2"><?php echo $oCo->courseName." กลุ่ม ".$oCl->section;?></font></td>
<td height="22" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>" size="2">
<?php
$oCe2->SearchByClsIdExC($oCe->classId,M);
if($oCe2->GetRecord()){
$oPr->SearchByKey($oCe->examTimeFrom);
$oPr->GetRecord();
$oPr2->SearchByKey($oCe->examTimeTo);
$oPr2->GetRecord();
echo "(".$oCe->studyCode.") ".abbreDate2($oCe->examDate)."<br>".$oPr->startTime."-".$oPr2->endTime."<br>".$oRm->roomNo;
}else{
echo "-";
}
?>
</font></td>
<td height="22" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>" size="2">
<?php
$oCe2->SearchByClsIdExC($oCe->classId,F);
if($oCe2->GetRecord()){
$oPr->SearchByKey($oCe->examTimeFrom);
$oPr->GetRecord();
$oPr2->SearchByKey($oCe->examTimeTo);
$oPr2->GetRecord();
echo "(".$oCe->studyCode.") ".abbreDate2($oCe->examDate)."<br>".$oPr->startTime."-".$oPr2->endTime."<br>".$oRm->roomNo;
}else{
echo "-";
}
?>
</font></td>
</tr>
<?php
$ce++;
}
}
}
if($ce==0){
?>
<tr><td colspan="4" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2">** ไม่ปรากฏรายการตารางสอน/สอบในฐานข้อมูล **</font></td></tr>
<?php
}
?>
</table><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2">** ข้อมูลที่ปรากฏในตารางสอบคือ (C) บรรยาย, (L) ปฏิบัติ, วันที่สอบ เวลาและห้องสอบ</font><br><br></td></tr>
<tr>
<td><br>
<input name="cancle" type="button" value="ยกเลิก" onClick="location.href='teachSchedule.php' ">
<input type="hidden" name="method" value="show"></td>
</tr>
<?php
}
?>
</table></td>
</tr>
</table>
</form></div><br></label>
</fieldset><br><?php if($methodSearch!="search"){ ?><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ : </b>ระบุรหัสอาจารย์ หรือ ชื่อ หรือ นามสกุลนักศึกษาเพื่อดูข้อมูลตารางสอนของอาจารย์</font><?php } ?>
</td>
</tr>
</table>
<?php
$oSs->Destroy();
$oSy->Destroy();
?>
|