Viewing file: reportDataRQCourseTep3_3.php (13.21 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?
include_once "../../class/clsDB.php";
include_once "../../class/clsConnection.php";
include_once "../global.php";
include_once "../link/function.php";
include_once "../class/clsReg_SysSemesterDes.php";
include_once "../class/clsReg_Program.php";
include_once "../class/clsReg_Generation.php";
include_once "../class/clsRegistration.php";
include_once "../class/clsCourseAssess.php";
include_once "../class/clsHoldCourse.php";
include_once "../class/clsClassAssess.php";
include_once "../class/clsClassOpenForAssess.php";
include_once "../class/clsOfficerAssess.php";
include_once "../class/clsDefineAssessment.php";
include_once "../class/clsAssessForm.php";
include_once "../class/clsDoAssessment.php";
include_once "../class/clsResultRQ.php";
include_once "../class/clsSectionAll.php";
$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']);
$oGen = new Generation($oCR);
$oReg = new Registration($oCA);
$oCourse = new CourseAssess($oCA);
$oClass = new ClassAssess($oCA);
$oClsOpen = new ClassOpenForAssess($oCA);
$oOFA = new OfficerAssess($oCA);
$oHC = new HoldCourse($oCA);
$oAF = new AssessForm($oCA);
$oDo = new DoAssessment($oCA);
$oProg = new Program($oCR);
$oAF->RSAssessFormByAssid($assid);
$oAF->GetRecord();
$oSse = new SysSemesterDes($oCR);
$oSse->SearchByKey($semester);
$oSse->GetRecord();
$oDA = new DefineAssessment($oCA);
$oDA->SearchByDefineid($defineid);
$oDA->GetRecord();
$oCourse->SearchByKey($courseId);
$oCourse->GetRecord();
$oClass->SearchJoinClassCISByCourseIdGroupOfficerId($courseId);
$oClass->SearchByKey($classId);
$oClass->GetRecord();
//ค้นหาคำถามปลายเปิดในแบบประเมินนี้ sectionTQid = 1
$oSA = new SectionAll($oCA);
$CntSRQid = $oSA->RSCountSectionRQid($assid);
$oRRQ = new ResultRQ($oCA);
?>
<title>รายงานค่าเฉลี่ยและส่วนเบี่ยงเบนมาตรฐาน ระดับความพึงพอใจต่อคุณภาพการสอนของอาจารย์จำแนกตามรายวิชา</title>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
<div id="tabmargin">
<form name="pc" method="post" action="<?php echo $PHP_SELF;?>" enctype="multipart/form-data">
<div align="center">
</div><br>
<table width="94%" align="center" cellpadding="1" cellspacing="1" bgcolor="#0080C0">
<tr bgcolor="#FFFFFF">
<td width="99%">
<table width="100%" align="center" border="0" cellpadding="0" cellspacing="1">
<tr>
<td> <table width="779" border="0" align="center">
<tr>
<td width="278" height="10"></td>
</tr>
</table>
<table width="98%" align="center" cellpadding="1" cellspacing="1" bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<tr>
<td height="34" align="center"><font size="2"><span class = "fontMark5">รายงานค่าเฉลี่ยและส่วนเบี่ยงเบนมาตรฐาน
ระดับความพึงพอใจต่อคุณภาพการสอนของอาจารย์จำแนกตามรายวิชา</span></font></td>
</tr>
</table>
<table width="98%" border="0" align="center">
<tr>
<td height="25"><hr></td>
</tr>
</table>
<table width="98%" border="0" align="center">
<tr>
<!-- <td height="27" align="right"><font size="2"><span class = "fontMark5">
<a href="reportDataRQCourseTep3_2_excel.php?defineid=<? echo $defineid ?>&assid=<? echo $assid ?>&classId=<? echo $classId ?>&courseId=<? echo $courseId ?>&officerId=<? echo $officerId?>&acadYear=<? echo $acadYear ?>&semester=<? echo $semester ?>" target="_top"><img src="../picture/ico_excel.gif" border="0"><b> รูปแบบ Excel</b></a></span></font></td> -->
<td> </td>
</tr>
</table>
<table border="0">
<tr>
<td><font size="2"><b><img src="../picture/bullet.gif"> ชื่อทางการแบบประเมิน</b></font></td>
<td width="732"><font size="2"><b>: </b></font><font size="2">
<? if($oAF->maintopic == ""){ echo "-"; }else{ echo $oAF->maintopic; } ?>
</font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_11'];?>">
<td><font size="2"><b><img src="../picture/bullet.gif"> ชื่อทั่วไปแบบประเมิน
</b></font></td>
<td><font size="2"><b>: </b><? echo $oAF->nameAss ?></font></td>
</tr>
<tr>
<td width="171" height="22"><font size="2"><b><img src="../picture/bullet.gif">
ปีการศึกษา </b></font></td>
<td><font size="2"><b>: </b></font><? echo $acadYear ?> /
<? echo $oSse->semesterName;?></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_11'];?>">
<td height="22"><font size="2"><b><img src="../picture/bullet.gif">
หลักสูตร</b></font></td>
<td>:
<? 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->programName;
}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->programName;
}else{
echo "<img src = \"../picture/warn.png\" border = \"0\">";
}
}
//echo $oClassA->programId;
}
?>
</td>
</tr>
<tr >
<td height="22"><font size="2"><b><img src="../picture/bullet.gif">
รายวิชา</b></font></td>
<td>: <?php echo $oCourse->courseCode;?> <? echo $oCourse->courseName ?> ชั้นปีที่ <? echo $oClass->studentYear ?></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_11'];?>">
<td height="22"><font size="2"><b><img src="../picture/bullet.gif">
อาจารย์ผู้สอน</b></font></td>
<td><font size="2"><b>: </b></font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">
<?php if($officerId == ""){ ?>
<font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3'];?>"><? echo "- ไม่พบรายชื่ออาจารย์ผู้สอน -"; ?></font>
<? }else if($officerId > 0){
$oOFA->SearchByKey($officerId);
$oOFA->GetRecord();
echo $oOFA->prefixName.$oOFA->officerName." ".$oOFA->officerSurname;
} ?>
</font></td>
</tr>
<tr>
<td height="22"><font size="2"><b><img src="../picture/bullet.gif">
ช่วงเวลาประเมิน</b></font></td>
<td><font size="2"><b>: </b></font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><? echo abbreDate(splitDateDb2($oDA->startDate,'/')); ?>
- <? echo abbreDate(splitDateDb2($oDA->endDate,'/')); ?></font></td>
</tr>
</table>
<br>
<? if($CntSRQid > 0){ ?>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#666666">
<tr>
<td width="60" rowspan="2" align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_1"];?>"><font size="2"><b>กลุ่มที่</b></font></td>
<?
$oSA= new SectionAll($oCA);
$i = 0; $scoreV1 = 4; $scoreV2 = 5; //ค่าที่จะนำไปคิด
$indexSection_head = 1;
$oSA->RSByKeyAss($assid);
while($oSA->GetRecord()){
/*---------------- กรณีที่เลือกเป็นคำถามชนิดปลายปิด------------------*/
if($oSA->sectionRQid != '0'){
?>
<td height="23" colspan="2" align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_1"];?>"><font size="2"><b>ส่วนที่
<? echo $indexSection_head; ?></b></font></td>
<? $i++;
} // end if oSA
$indexSection_head++;
} //end while oSA
?>
<td height="23" colspan="2" align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_1"];?>"><font size="2"><b>ภาพรวม</b></font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_7"];?>">
<? for($j=1;$j<=$i;$j++){ ?>
<td width="70" height="21" align="center"><font size="2"><b>ค่าเฉลี่ย</b></font></td>
<td width="70" height="21" align="center"><font size="2"><b>S.D.</b></font></td>
<? } ?>
<td width="70" height="21" align="center"><font size="2"><b>ค่าเฉลี่ย</b></font></td>
<td width="70" height="21" align="center"><font size="2"><b>S.D.</b></font></td>
</tr>
<?
set_time_limit(0);
$flag = 0;
$index_color = 1;
/*---------------- กรณีที่เลือกเป็นคำถามชนิดปลายปิด------------------*/
$x = 0;$y = 0;
// $oDo->RSXbarSDCollageByAcadSemAssidDefineid($acadYear,$semester,$defineid);
$oDo->RSXbarSDSumReByCourseIdDefineidOfficerId($courseId,$defineid,$officerId);
while($oDo->GetRecord()){
$j=1;
$sumX = 0;
$sumPowX = 0;
while($j<=$i ){
if($j==1){
if($index_color%2 == 0){
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_5"].'">';
}else{
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
} ?>
<td align="center"><? echo $oDo->section; //$index_color; ?></td>
<? }?>
<td align="center"><? echo substr($oDo->xbar,0 ,4); ?></td>
<td align="center"><? echo number_format($oDo->sd,2); ?></td>
<?
$sumX += $oDo->xbar;
$sumPowX += pow($oDo->xbar,2);
$j++;
if($j<=$i){
$oDo->GetRecord();
}else{
$txbar = $sumX / $i;
$sPx = $sumPowX / $i;
$sd = sqrt($sPx - pow($txbar,2));
?>
<td align="center"><? echo substr($oDo->txbar,0 ,4); ?></td>
<td align="center"><? echo number_format($oDo->tsd,2); ?></td>
<? $index_color++;
}
}//end while i
} // end while ODA
set_time_limit(30);
?>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_14"];?>">
<td align="center" ><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">รวม</font></td>
<? if($index_color >1){
$oDo->RSOverviewCourseSectionRQidByCourseIdDefineidOfficerId($courseId,$defineid,$officerId);
while($oDo->GetRecord()){
?>
<td align="center"><? echo substr($oDo->xbar,0 ,4); ?></td>
<td align="center"><? echo number_format($oDo->sd,2); ?></td>
<? }
$oDo->getOverviewCourseByCourseIdDefineidOfficerId($courseId,$defineid,$officerId);
$oDo->GetRecord();
?>
<td align="center"><? echo substr($oDo->xbar,0 ,4); ?></td>
<td align="center"><? echo number_format($oDo->sd,2); ?></td>
<!-- เก่า <?
$AvgXOverAll = 0;
$AvgSDOverAll = 0;
$sumPowX = 0;
$oDo->RSOverviewCourseSectionRQidByCourseIdDefineidOfficerId($courseId,$defineid,$officerId);
while($oDo->GetRecord()){
?>
<td align="center"><? echo substr($oDo->xbar,0 ,4); ?></td>
<td align="center"><? echo substr($oDo->sd,0 ,4); ?></td>
<?
$AvgXOverAll+=$oDo->xbar;
$sumPowX += pow($oDo->xbar,2);
} // end while
$AvgXOverAll/=$i;
$sPx = $sumPowX / $i;
$sd = sqrt($sPx - pow($AvgXOverAll,2));
// $AvgSDOverAll/=$i;
?>
<td align="center"><? echo substr($AvgXOverAll,0 ,4); ?></td>
<td align="center"><? echo number_format($sd,2); ?></td> -->
</tr>
<? }else{ ?>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_5"];?>">
<td colspan="<? echo ($i*2)+4 ?>" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">**
ไม่พบรายการอาจารย์ผู้สอนที่ถูกประเมิน **</font></td>
</tr>
<? } ?>
</table>
<br>
<? } else { ?>
<table width="100%">
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_5'];?>">
<td align="center"> <font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">**
ไม่สามารถแสดงรายงานได้ เนื่องจากเนื่องจากแบบประเมินที่สร้างไม่มีส่วนของคำถามปลายปิด
**</font></td>
</tr>
</table>
<? } // end if CntSRQid > 0?>
<br>
</td>
</tr>
</table></td>
</tr>
</table>
</form><br>
</div>
</body>
|