Viewing file:  showDeTeachCourseAfSearch1.php (11.93 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
include_once "template.php";
showHeader();
include_once "../class/clsReg_SysSemesterDes.php";
include_once "../class/clsReg_Program.php";
include_once "../link/function.php";
include_once "../class/clsCourseAssess.php";
include_once "../class/clsHoldCourse.php";
include_once "../class/clsRegistration.php";
include_once "../class/clsClassAssess.php";
include_once "../class/clsClassOpenForAssess.php";
include_once "../class/clsClassInStructorAssess.php";
include_once "../class/clsOfficerAssess.php";
include_once "../class/clsDefineAssessment.php";
include_once "../class/clsAssessForm.php";
sendRequest();
$oCR = new clsConnection($GLOBALS['HOST'], $GLOBALS['DB_REG'], $GLOBALS['USER_REG'], $GLOBALS['PASSWORD_REG']);
$oCA = new clsConnection($GLOBALS['HOST'], $GLOBALS['DB_EASS'], $GLOBALS['USER_EASS'], $GLOBALS['PASSWORD_EASS']);
$oReg = new Registration($oCA);
$oDA = new DefineAssessment($oCA);
$oHC = new HoldCourse($oCA);
$oAF = new AssessForm($oCA);
$oOFA = new OfficerAssess($oCA);
$oClass = new ClassAssess($oCA);
$oClass->SearchByKey($classId);
$oClass->GetRecord();
$oClassIn = new ClassAssess($oCA);
$oCIS = new ClassInStructorAssess($oCA);
$oClsOpen = new ClassOpenForAssess($oCA);
$oCourse = new CourseAssess($oCA);
$oCourse->SearchByKey($courseId);
$oCourse->GetRecord();
$oReg->RSRegisByStdIdAndClassId($studentId, $classId);
$oReg->GetRecord();
$now = GetNowDate();
list($y, $m, $d) = split('[-]', $now);
$y=$y+543;
$nowDate=$y."-".$m."-".$d;
$oSse = new SysSemesterDes($oCR);
$oSse->SearchByKey($sem);
$oSse->GetRecord();
$oProg = new Program($oCR);
?>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
<table width="742" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="742"><br>
<fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="index.php?mm=1">ผลการประเมิน</a>
<img src="../picture/ico3.gif" align="absmiddle" border="0"><a href="searchFormByCourse.php"> ค้นหารายวิชาที่เปิดสอน
</a><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle">รายวิชาแยกตามหลักสูตร/ผู้สอน/ชั้นปี/กลุ่ม</font></legend>
</legend>
<div align="center">
<form name="pc" method="post" action="<?php echo $PHP_SELF;?>"><br>
<table width="521" align="center" border="0" cellpadding="0" cellspacing="1">
<tr>
<td width="545" height="60">
<table width="519" border="0" align="center" cellpadding="1" cellspacing="1">
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_7'];?>">
<td height="24"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b><img src="../picture/bullet1.gif" border ="0"> ปีการศึกษา</b></font></td>
<td width="417"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>:</b>
<? echo $oSse->semesterName ?>/<? echo $acd ?></font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_11'];?>">
<td width="95" height="24"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b><img src="../picture/bullet1.gif" border ="0"> รหัสรายวิชา</b></font></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>:</b>
</font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $oCourse->courseCode?>
(<?php echo $oCourse->courseCodeEng?>)</font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b></b></font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"> </b>
</font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_7'];?>">
<td height="20"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b><img src="../picture/bullet1.gif" border ="0"> ชื่อรายวิชา
</b></font></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>:</b></font> <font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">
<?php echo $oCourse->courseName?></font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">
(<?php echo $oCourse->courseNameEng?>)</font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_11'];?>">
<td height="20"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b><img src="../picture/bullet1.gif" border ="0"> หน่วยกิต
</b></font></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>:
</b> <?php echo $oCourse->courseUnit;?></font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"> </font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2"></td>
</tr>
<tr>
<td><br>
<table width="485" border="0" align="center" headerbgColor = "#B7B7B7">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_6"];?>">
<td width="197" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>อาจารย์ผู้สอน</strong></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ชื่อย่อหลักสูตร</strong></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ชั้นปี</strong></font></td>
<td align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"> <strong>กลุ่ม</strong></font></td>
<td align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"> <strong>เลือก</strong></font></td>
</tr>
<?php
$i = 0;
$ck=0;
$no = 1;
$oClass->JoinSearchByCourseIdAcadSemGroupOfficerId($courseId,$acd,$sem);
while($oClass->GetRecordJoin()){
$oClassIn->JoinSearchByCourseIdAcadSemOfficerIdGroupClassId($courseId,$acd,$sem,$oClass->officerId);
$rowClassIn = $oClassIn->GetRowSelected();
$oOFA->SearchByKey($oClass->officerId);
$oOFA->GetRecord();
if(($i%2) == 0){
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
$color_td = 'bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'"';
}else{
echo '<tr>';
$color_td = '';
}
?>
<td height="24" valign="top" rowspan="<? echo $rowClassIn; ?>">
<? //if($indexName == 0){
echo "<img src=\"../picture/user.gif\" border =\"0\"> ";
if($oClass->officerId == ""){
?> <font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3'];?>"><? echo "- ไม่พบรายชื่ออาจารย์ผู้สอน -"; ?></font><?
$oClass->officerId == 0;
}else{
echo " อ.".$oOFA->officerName." ".$oOFA->officerSurname."<br>";
}
// }
?>
</td>
<?
$oClassIn->JoinSearchByCourseIdAcadSemOfficerIdGroupClassId($courseId,$acd,$sem,$oClass->officerId);
while($oClassIn->GetRecordJoin()){
?>
<td width="91" height="24" align="center" <? echo $color_td ?>><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">
<? if(($oClass->programId == 0) || ($oClass->programId == "")){
$z = 0;
$oClsOpen->SearchByClassId($oClass->classId);
while($oClsOpen->GetRecord()){
$oProg->SearchByKey($oClsOpen->programId);
$oProg->GetRecord();
if($oProg->programAbbr != ""){
$arrCls[$z] = $oProg->programAbbr;
}else{
$arrCls[$z] = "<img src = \"../picture/warn.png\" border = \"0\">";
}
$z++;
} // end while oClsOpen
for($a=0;$a<=$z;$a++){
echo $arrCls[$a];
if($a < $z-1) echo ",<br>";
}
}else{
$oProg->SearchByKey($oClass->programId);
if($oProg->GetRecord()){
if($oProg->programAbbr != ""){
echo $oProg->programAbbr;
}else{
echo "<img src = \"../picture/warn.png\" border = \"0\">";
}
}
//echo $oClassA->programId;
}
?>
</font></td>
<td width="52" align="center" <? echo $color_td ?>><? echo $oClassIn->studentYear ?></td>
<td width="60" align="center" <? echo $color_td ?>><? echo $oClassIn->section ?></td>
<td width="63" align="center" <? echo $color_td ?>><a href = "showDeFormCourse.php?classId=<? echo $oClassIn->classId ?>&courseId=<? echo $courseId ?>&officerId=<? echo $oClassIn->officerId ?>&acadYear=<? echo $acd ?>&semester=<? echo $sem ?>" onclick="return sendRequest(this);" onmouseover="window.status=''; return true;"><img src = "../picture/select.gif" border="0"></a></td>
</tr>
<?php
$ck=1;
} //end while oClassIn
$i++;
} // end while oClass
if($ck == 0) {
?>
<tr>
<td height="20" colspan="5" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">**
ไม่พบรายชื่ออาจารย์ผู้สอน เนื่องจากยังไม่ได้กำหนดอาจารย์ผู้สอนในระบบทะเบียนฯ
**</font></td>
</tr>
<? } ?>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_6'];?>">
<td height="13" colspan="5" align="right"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"> </font></td>
</tr>
</table>
<table width="92%" border="0" align="center">
<tr>
<td> </td>
</tr>
<tr>
<td height="26"><input type="button" name="back22" value="ย้อนกลับ" onClick=" location.href = 'searchFormByCourse.php?'">
<input type="button" name="back2" value="กลับสู่หน้าหลัก" onClick=" location.href = 'index.php?mm=1'">
</td>
</tr>
</table></td>
</tr>
</table>
<br>
</form></div></label>
</fieldset><br>
<table width="89%" border="0">
<tr>
<td width="12%"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><strong>หมายเหตุ
: </strong></font></td>
<td width="88%" height="27" colspan="2"><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2">คลิกที่
<img src = "../picture/select.gif" border="0"> เพื่อเลือกอาจารย์ผู้สอนโดยแยกเป็นหลักกสูตร/ชั้นปี/กลุ่ม</font></td>
</tr>
<tr>
<td width="12%"> </td>
<td height="27" colspan="2"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">ชื่อย่อหลักสูตรที่แสดงอยู่ในตาราง
หมายถึง </font></td>
</tr>
<? $oProg->SearchByProgramStatusY();
while($oProg->GetRecord()){ ?>
<tr>
<td width="12%"> </td>
<td height="27" colspan="2"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">
<? if($oProg->programAbbr != ""){
echo $oProg->programAbbr." = ".$oProg->programName;
}else{
echo "<img src = \"../picture/warn.png\" border = \"0\"> = ".$oProg->programName;
}
?>
<? //echo $oProg->programId." = ".$oProg->programName; ?>
</font></td>
</tr>
<? } ?>
</table></td>
</tr>
</table>
<form name="silent" id="silent" style="margin:0px; padding: 0px;" method="post"></form>
<?php
showFooter();
?>
|