Viewing file:  2552-01-30-1.0.02-showDeFormCourseGpSec.php (14.75 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/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/clsSectionAll.php";
include_once "../class/clsDoAssessment.php";
?>
<script language="javascript">
function sendPage(startpage,holdCourse,src) {
if(holdCourse == 1){
var links = "./reportDataRQCourseTep4_1.php?"+src;
}else if(holdCourse == 2){
var links = "./reportDataRQCourseTep4_2.php?"+src;
}
window.open(links, '', 'toolbars=0, scrollbars=yes, location=0, statusbars=0, menubars=0, resizable=yes, width=850, height=600, left = 90, top = 40');
}
</script>
<?
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']);
$oProg = new Program($oCR);
$oCourse = new CourseAssess($oCA);
$oClass = new ClassAssess($oCA);
$oClsOpen = new ClassOpenForAssess($oCA);
$oCIS = new ClassInStructorAssess($oCA);
$oCIS_1 = new ClassInStructorAssess($oCA);
$oOFA = new OfficerAssess($oCA);
$oDA = new DefineAssessment($oCA);
$oHC = new HoldCourse($oCA);
$oAF = new AssessForm($oCA);
$oDo = new DoAssessment($oCA);
$oClass->SearchByKey($classId);
$oClass->GetRecord();
$oCourse->SearchByKey($oClass->courseId);
$oCourse->GetRecord();
$oOFA->SearchByKey($officerId);
$oOFA->GetRecord();
$oSse = new SysSemesterDes($oCR);
$oSse->SearchByKey($semester);
$oSse->GetRecord();
?>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><fieldset><br>
<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"><a href="showDeTeachCourseAfSearch.php?courseId=<? echo $courseId ?>&acd=<? echo $acadYear ?>&sem=<? echo $semester ?>" onclick="return sendRequest(this);" onmouseover="window.status=''; return true;">รายวิชาแยกตามหลักสูตร/ผู้สอน/ชั้นปี/กลุ่ม</a><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle">แยกตามรายการแบบประเมิน</font></legend>
<div align="center">
<form name="pc" method="post" action="<?php echo $PHP_SELF;?>">
<table width="627" align="center" border="0" cellpadding="0" cellspacing="1">
<tr>
<td width="625" height="85"><br>
<table width="634" border="0" align="center" cellpadding="1" cellspacing="1" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"];?>">
<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 width="529"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>:</b> <?php echo $acadYear ?>
/ <?php echo $oSse->semesterName;?></font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"> </font></td>
</tr>
<tr>
<td height="24" <? if(($oClass->programId == 0) || ($oClass->programId == "")){ echo "valign=\"baseline\""; } ?>><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'];?>"><b>:</b>
<? if(($oClass->programId == 0) || ($oClass->programId == "")){
$z = 0;
$oClsOpen->SearchByClassId($oClass->classId);
while($oClsOpen->GetRecord()){
$oProg->SearchByKey($oClsOpen->programId);
$oProg->GetRecord();
$arrCls[$z] = $oProg->programName;
$z++;
} // end while oClsOpen
for($a=0;$a<=$z;$a++){
echo $arrCls[$a];
if($a < $z-1) echo ",<br> ";
}
}else{
$oProg->SearchByKey($oClass->programId);
$oProg->GetRecord();
echo $oProg->programName;
}
?>
</font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td height="24"><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'];?>"><b>:</b> <?php echo $oCourse->courseCode?>
(<?php echo $oCourse->courseCodeEng?>)</font></td>
</tr>
<tr>
<td width="98" height="24"><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'];?>"><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><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>
</b></font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td height="22" valign="top"><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'];?>"><b>:</b></font> <font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">
<? $blankIndex = 1;
echo " <img src=\"../picture/users.gif\" border =\"0\"> ";
$oCIS->RSClassInStructorAssessGroupOfficerId();
while($oCIS->GetRecord()){
$flagX = 0; $z = 0;
while(($z<$sectionClass) && $flagX == 0){
$oCIS_1->SearchByClassIdOfficerId($classId+$z,$oCIS->officerId);
if($oCIS_1->GetRecord()){
$oOFA->SearchByKey($oCIS_1->officerId);
$oOFA->GetRecord();
if($blankIndex > 1) echo ",";
echo " อ.".$oOFA->officerName." ".$oOFA->officerSurname;
$blankIndex++;
$flagX = 1;
} // end while oCIS_1
$z++;
} // end while i < sectionClass
$i++;
} // end while CIS
?>
</font></td>
</tr>
<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'];?>"><b>:</b> <?php echo $oCourse->courseUnit;?></font></td>
</tr>
<tr>
<td height="22"> </td>
<td> </td>
</tr>
<tr>
<td height="22" colspan="2"> <fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_6"]; ?>"><img src="../picture/bookmark.gif" width="12" height="13" border="0"> ผลการประเมินภาพรวมรายวิชา (จำแนกตามรายอาจารย์ผู้สอน)</font></legend>
<table width="599" align="center">
<tr>
<td colspan="2"> </td>
</tr>
<?php
$i=0;
$flag1=0;
/*------------------------------------------ค้นหาแบบประเมินที่ได้กำหนดไว้ แบบที่ผูกกับรายวิชาทั้งหมด (flag =0)---------------------------------*/
$oDA->SearchByAcadSemFlag($acadYear,$semester,'0');
while($oDA->GetRecord()){
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
//ตรวจสอบว่าแบบประเมินมีส่วนที่ 1 เป็นคำถามปลายปิดหรือไม่
$oSA = new SectionAll($oCA);
$minSeqSA = $oSA->getMinSeqSA($oAF->assid);
$oSA->SearchSectionRQidByAssidSeq($oAF->assid,$minSeqSA);
$oSA->GetRecord();
if($oSA->sectionRQid > 0) {
$startpage = 1;
}else{
$startpage = 2;
}
//echo "<br> oSA->sectionRQid = ".$oSA->sectionRQid;
// if(($i%2) == 0)
// echo '<tr>';
// else
// echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<tr>
<td width="15" valign="top"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">
<!--ถ้า sectionRQid > 0 ที่ sequence = 1 แสดงว่าส่วนแรกเป็นคำถามปลายปิด--->
<img src="../picture/icoa16.jpg" border ="0" align="top"></font>
</td>
<td width="555"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><a href = "#" onClick = "sendPage('<? echo $startpage ?>',1,'defineid=<? echo $oDA->defineid ?>&assid=<? echo $oDA->assid ?>&classId=<? echo $classId ?>§ionClass=<? echo $sectionClass ?>&courseId=<? echo $courseId ?>&officerId=<? echo $officerId?>&officerCode=<? echo $officerCode ?>&acadYear=<? echo $acadYear ?>&semester=<? echo $semester ?>')">
<? if($oAF->maintopic == ""){ echo $oAF->nameAss." <img src = \"../picture/warn.png\" border = \"0\">"; }else{ echo $oAF->maintopic; } echo " " ?>
(ระหว่างวันที่ <? echo abbreDate(splitDateDb2($oDA->startDate,'/')); ?>
- <? echo abbreDate(splitDateDb2($oDA->endDate,'/')); ?>)</a></font>
</td>
</tr>
<?php
$i++;
$flag1 = 1;
} //end while oDA
$i=0;
$flagHold=0;
/*---------------------------------ค้นหาแบบประเมินที่ได้กำหนดไว้ แบบที่ผูกกับบางรายวิชา(flag =8) อาจารย์ = 8-------------------------------*/
$oDA->SearchByAcadSemFlag($acadYear,$semester,'8');
while($oDA->GetRecord()){
$oHC->SearchByDefineidClassId($oDA->defineid,$classId);
if($oHC->GetRecord() == '1'){
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
//ตรวจสอบว่าแบบประเมินมีส่วนที่ 1 เป็นคำถามปลายปิดหรือไม่
$oSA = new SectionAll($oCA);
$minSeqSA = $oSA->getMinSeqSA($oAF->assid);
$oSA->SearchSectionRQidByAssidSeq($oAF->assid,$minSeqSA);
$oSA->GetRecord();
if($oSA->sectionRQid > 0) {
$startpage = 1;
}else{
$startpage = 2;
}
?>
<tr>
<td valign="top"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">
<!--ถ้า sectionRQid > 0 ที่ sequence = 1 แสดงว่าส่วนแรกเป็นคำถามปลายปิด--->
<img src="../picture/icoa16.jpg" border ="0" align="top">
</font> </td>
<td width="555"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><a href = "#" onclick = "sendPage('<? echo $startpage ?>',2,'defineid=<? echo $oDA->defineid ?>&assid=<? echo $oDA->assid ?>&classId=<? echo $classId ?>§ionClass=<? echo $sectionClass ?>&courseId=<? echo $courseId ?>&officerId=<? echo $officerId?>&officerCode=<? echo $officerCode ?>&acadYear=<? echo $acadYear ?>&semester=<? echo $semester ?>')">
<? if($oAF->maintopic == ""){ echo $oAF->nameAss." <img src = \"../picture/warn.png\" border = \"0\">"; }else{ echo $oAF->maintopic; } echo " " ?>
(ระหว่างวันที่ <? echo abbreDate(splitDateDb2($oDA->startDate,'/')); ?>
- <? echo abbreDate(splitDateDb2($oDA->endDate,'/')); ?>)
<font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>">
* </font></a></font> </td>
</tr>
<?php
$flagHold = 1;
} //end if oHC
$i++;
} // end while oDA
?>
<? if(($flag2 == 0 && $flagHold2 == 0) && ($flag1 == 0 && $flagHold == 0)) { ?>
<tr>
<td colspan="2" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">**
ไม่ปรากฏรายการแบบประเมินที่ใช้ประเมินในปีการศึกษา
<?php echo $acadYear ?>/<?php echo $oSse->semesterName;?></font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"> </font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">**</font></td>
</tr>
<? } ?>
</table>
<p> </p>
</fieldset></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2"></td>
</tr>
<tr>
<td height="40"><br>
<input type="button" name="back22" value="ย้อนกลับ" onClick=" location.href = 'showDeTeachCourseAfSearch.php?courseId=<? echo $courseId ?>&acd=<? echo $acadYear ?>&sem=<? echo $semester ?>'">
<input type="button" name="back2" value="กลับสู่หน้าหลัก" onClick=" location.href = 'index.php?mm=1'"></td>
</tr>
</table>
</form>
</div>
</fieldset><br>
<table width="89%" border="0">
<tr>
<td width="10%" height="27"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><strong>หมายเหตุ
: </strong></font></td>
<td width="90%" colspan="2"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">เลือกรายงานและคลิกที่รายการแบบประเมินเพื่อดูผลการประเมิน</font></td>
</tr>
<tr>
<td height="27"> </td>
<td colspan="2"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">*
หมายถึง แบบประเมินเฉพาะรายวิชา</font></td>
</tr>
</table>
</td>
</tr>
</table>
<form name="silent" id="silent" style="margin:0px; padding: 0px;" method="post"></form>
<?php
showFooter();
?>
|