Viewing file:  searchEpByCourse.php (12.61 KB) -rw-r--r--
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";
include_once "../class/clsTimeTableAssess.php";
include_once "../class/clsMainExternalPlace.php";
include_once "../class/clsSubExternalPlace.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);
$oTT = new TimeTableAssess($oCA);
$oTT2 = new TimeTableAssess($oCA);
$oMep = new MainExternalPlace($oCA);
$oSep = new SubExternalPlace($oCA);
$oClass = new ClassAssess($oCA);
$oClass->SearchByKey($classId);
$oClass->GetRecord();
$oClassIn = new ClassAssess($oCA);
$oClassIn_1 = new ClassAssess($oCA);
$oCIS = new ClassInStructorAssess($oCA);
$oCIS_1 = 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);
?>
<script language="JavaScript1.2">
function selectProgram(){
location.replace('searchEpByCourse.php?courseId='+document.pc.courseId.value+'&acY='+document.pc.acY.value+'&sem='+document.pc.sem.value+'&programSearch='+document.pc.programSearch.value);
}
function selectPlace(){
location.replace('searchEpByCourse.php?courseId='+document.pc.courseId.value+'&acY='+document.pc.acY.value+'&sem='+document.pc.sem.value+'&programSearch='+document.pc.programSearch.value+'&epSearch='+document.pc.epSearch.value);
}
function showDeFormCourse(act){
if(act == 1)
document.pc.action = 'showDeEp.php?courseId='+document.pc.courseId.value+'&acadYear='+document.pc.acY.value+'&semester='+document.pc.sem.value+'&programId='+document.pc.programSearch.value+'&officerId=0&classId='+document.pc.groupSearch2.value;
else
document.pc.action = 'showDeEp.php?courseId='+document.pc.courseId.value+'&acadYear='+document.pc.acY.value+'&semester='+document.pc.sem.value+'&programId='+document.pc.programSearch.value+'&ep='+document.pc.epSearch.value+'&classId='+document.pc.classSearch.value;
}
</script>
<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="showCourseEp.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>
<input type="hidden" name="acY" value="<?=$acY?>" />
<input type="hidden" name="sem" value="<?=$sem?>" />
<input type="hidden" name="courseId" value="<?=$courseId?>" />
<table width="666" align="center" border="0" cellpadding="0" cellspacing="1">
<tr>
<td width="664" height="60">
<table width="592" 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="490"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>:</b>
<? echo $oSse->semesterName ?>/<? echo $acY ?></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="592" border="0" align="center" headerbgColor = "#B7B7B7">
<? /* -------------- SEARCH PROGRAM -------------- */ ?>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
<td colspan="5"> <img src = "../picture/select.gif" width="15" height="15" border="0">
<select name="programSearch" onchange="selectProgram()">
<?php if(!isset($programSearch)){ ?>
<option value="" selected> - - - เลือกหลักสูตร - - - </option>
<?php }
$oClass->DistinctProgramIdByCourseIdAcYSem($courseId,$acY,$sem);
while($oClass->GetRecordJoin()) {
$oProg->SearchByKey($oClass->programId);
$oProg->GetRecord();
$oProg->programName;
?>
<option value="<?php echo $oClass->programId;?>" <? if($oClass->programId == $programSearch) echo "selected"; ?>>
<?=$oProg->programName;?>
</option>
<?php } ?>
</select></td>
</tr>
<?
/*------------ . ผลการประเมินแหล่งฝึก --------------------------------------*/
?>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_13"];?>">
<td height="23" colspan="5" valign="top"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"> <img src="../picture/bookmark.gif" width="12" height="13" border="0">
ผลการประเมินแหล่งฝึก</font></td>
</tr>
<? /* ----------------------- SEARCH PLACE ------------------ */ ?>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
<td colspan="5"> <img src="../picture/assEp.jpg" border ="0" width="16" height="16">
<?
$oTT->RSHoldPlaceByAcYSePgCo($acY,$sem,$programSearch,$courseId);
?>
<select name="epSearch" onchange="selectPlace()">
<?php if(!isset($programSearch)){ ?>
<option value="%" selected> - - เลือกแหล่งฝึก - -</option>
<?php }else{ ?>
<option value="%" <? if('%' == $epSearch) echo "selected"; ?>> - ทุกแหล่งฝึก -</option>
<?php $oTT->RSMainPlaceByAcYSePgCo($acY,$sem,$programSearch,$courseId);
while($oTT->GetRecord()) {
$oTT2->RSSubPlaceByAcYSePgCoMep($acY,$sem,$programSearch,$courseId,$oTT->ttEpMepId);
while($oTT2->GetRecord()) {
$oMep->SearchById($oTT->ttEpMepId);
$oMep->GetRecord();
$oSep->SearchByKey($oTT2->ttEpSepId);
$oSep->GetRecord();
?>
<option value="<?php echo "$oMep->mepId-$oSep->sepId";?>" <? if($epSearch == "$oMep->mepId-$oSep->sepId") echo "selected"; ?> ><?php echo $oMep->mepName.", ".$oSep->sepName; ?></option>
<?php }
}
}
?>
</select>
<? /* ----------------------- SEARCH Class From TEACHER ------------------ */ ?>
<?
if(isset($epSearch)){
list($mepId, $sepId) = preg_split('[-]', $epSearch);
}
?>
<select name="classSearch" onChange="groupTeacher()" >
<?php if(!isset($epSearch)){ ?>
<option value=" " selected> - เลือกกลุ่ม -</option>
<?php }else{ ?>
<option value="%" <? if('%' == $epSearch) echo "selected"; ?>> - รวมทุกกลุ่ม -</option>
<?php
$oClass->RSByAcYSePgCoMepSep($acY,$sem,$programSearch,$courseId,$mepId, $sepId);
while($oClass->GetRecord()) {
?>
<option value="<?=$oClass->classId?>" ><?php echo 'ชั้นปี '.$oClass->studentYear.' / '.$oClass->section; ?></option>
<?php } } ?>
</select>
<input type="submit" name="Submit" value="ตกลง" onclick="showDeFormCourse(2)" /> </td>
</tr>
</table>
<table width="90%" border="0" align="center">
<tr>
<td> </td>
</tr>
<tr>
<td height="26"><input type="button" name="back22" value="ย้อนกลับ" onClick=" location.href = 'showCourseEp.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="11%"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><strong>หมายเหตุ
: </strong></font></td>
<td width="89%" 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="11%"> </td>
<td height="27" colspan="2"> </td>
</tr>
<? $oProg->SearchByProgramStatusY();
while($oProg->GetRecord()){ ?>
<tr>
<td width="11%"> </td>
<td height="27" colspan="2"> </td>
</tr>
<? } ?>
</table></td>
</tr>
</table>
<form name="silent" id="silent" style="margin:0px; padding: 0px;" method="post"></form>
<?php
showFooter();
?>
|