Viewing file: reportDataRQ_excel2.php (19.8 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?
header('Content-type: application/xls');
header('Content-Disposition: attachment; filename="testing2.xls"');
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 "../link/function.php";
include_once "../class/clsStudentAssess.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/clsClassInStructorAssess.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";
include_once "../class/clsHeaderQuestion.php";
include_once "../class/clsHeaderScore.php";
include_once "../class/clsDetailScore.php";
include_once "../class/clsRadioQuestion.php";
include_once "../class/clsSectionAll.php";
include_once "../class/clsOfficerAssess.php";
include_once "../class/clsTimeTableAssess.php";
tabChoose();
confirmSubmit();
openWindow();
$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']);
$oStd=new StudentAssess($oCA);
$oReg = new Registration($oCA);
$oCourse = new CourseAssess($oCA);
$oClass = new ClassAssess($oCA);
$oClsOpen = new ClassOpenForAssess($oCA);
$oCIS = new ClassInStructorAssess($oCA);
$oHC = new HoldCourse($oCA);
$oAF = new AssessForm($oCA);
$oDo = new DoAssessment($oCA);
$oOFA = new OfficerAssess($oCA);
$oTTA=new TimeTableAssess($oCA);
$oCourse->SearchByKey($courseId);
$oCourse->GetRecord();
$oClass->SearchByKey($classId);
$oClass->GetRecord();
$oProg = new Program($oCR);
set_time_limit(0);
$numAllCourseReg=0;
$oReg->RSByClassIdAcYSe($classId,$acadYear,$semester);
while($oReg->GetRecord()){
if($officerId == 0){ // กรณีประเมินภาพรวมรายวิชา officer == 0
$numAllCourseReg++;
}else{
$oCIS->SearchByClassIdOfficerId($oReg->classId,$officerId);
if($oCIS->GetRecord()){
$numAllCourseReg++;
}
}
}
$numAllDo=$numAllCourseReg;
// หลายสัปดาห์
if($officerId != 0 && $ttId==0){
$week=0;
$oTTA->RSJoinHCByDefineidClIdOfId($defineid,$classId,$officerId);
while($oTTA->GetRecord()){
$week++;
}
$numAllDo=$numAllCourseReg*$week;
}
$numCourseDoAss = 0;
if($ttId==0){
$numCourseDoAss=$oDo->CountDoidByDefineIdClassIdOfficeridSection($defineid,$classId,$officerId,$oClass->section);
}else{
$numCourseDoAss=$oDo->CountDistinctStdByDefineidOfficeridClassIdttId($defineid,$officerId,$classId,$ttId);
}
$oAF->RSAssessFormByAssid($assid);
$oAF->GetRecord();
$oSse = new SysSemesterDes($oCR);
$oSse->SearchByKey($semester);
$oSse->GetRecord();
$oDA = new DefineAssessment($oCA);
$oDA->SearchByDefineid($defineid);
$oDA->GetRecord();
//ค้นหาคำถามปลายเปิดในแบบประเมินนี้ sectionTQid = 1
$oSA = new SectionAll($oCA);
$CntSRQid = $oSA->RSCountSectionRQid($assid);
$oRRQ = new ResultRQ($oCA);
?>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<div id="tabmargin">
<form name="pc" method="post" action="<?php echo $PHP_SELF;?>" enctype="multipart/form-data">
<div align="center">
</div><br>
<table width="83%" align="center" border="0" cellpadding="0" cellspacing="1">
<tr>
<td>
<table width="100%" align="center" cellpadding="1" cellspacing="1">
<tr>
<td height="26" align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<tr>
<td height="22" colspan="24"><font size="3"><b>รายงานผลการประเมินข้อมูลดิบ
(เฉพาะคำถามปลายปิด) </b></font></td>
</tr>
<tr>
<td height="22" colspan="24" align="center"> </td>
</tr>
<tr>
<td height="22" colspan="24"> </td>
</tr>
<tr>
<td height="22" colspan="24"><font size="2"><b>ชื่อทางการแบบประเมิน
</b></font><font size="2"><b> : </b></font><font size="2"><? if($oAF->maintopic == ""){ echo "-"; }else{ echo $oAF->maintopic; } ?>
</font></td>
</tr>
<tr>
<td height="22" colspan="24"><font size="2"><b>ชื่อทั่วไปแบบประเมิน
</b></font><font size="2"><b> :
</b><? echo $oAF->nameAss; ?><b> </b></font></td>
</tr>
<tr>
<td height="22" colspan="24"><font size="2"><b>ปีการศึกษา </b></font><font size="2"><b> :
</b></font><? echo $acadYear ?> / <? echo $oSse->semesterName;?> </td>
</tr>
<tr>
<td height="22" colspan="24" <? if(($oClass->programId == 0) || ($oClass->programId == "")){ echo "valign=\"baseline\""; } ?>><font size="2"><b>หลักสูตร</b></font><font size="2"><b>
: </b></font><font size="2" 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();
$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>
<td height="22" colspan="24"><font size="2"><b>รหัสรายวิชา </b></font><font size="2"><b>:
</b></font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $oCourse->courseCode?>
(<?php echo $oCourse->courseCodeEng?>)</font></td>
</tr>
<tr>
<td height="22" colspan="24"><font size="2"><b>ชื่อรายวิชา </b></font><font size="2"><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>
<td height="22" colspan="24"><font size="2"><b>ช่วงเวลาประเมิน </b></font><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,'/')); ?>
<b>ชั้นปี :</b> <?php echo $oClass->studentYear?>
<b>กลุ่ม :</b> <?php echo $oClass->section?>
</font></td>
</tr>
<tr>
<td height="22" colspan="24"><font size="2"><b>ประเมินอาจารย์</b></font><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){
$t=0;
$oCIS->SearchByClassIdGroupClassIdOfficerId($classId);
while($oCIS->GetRecord()){
$oOFA->SearchByKey($oCIS->officerId);
$oOFA->GetRecord();
$Teachers[$t] = "อ.".$oOFA->officerName." ".$oOFA->officerSurname;
$t++;
}
for($s=0;$s<$t;$s++){
echo $Teachers[$s];
if($s<$t-1){
echo ", ";
}
}
}else{
$oOFA->SearchByKey($officerId);
$oOFA->GetRecord();
echo $oOFA->prefixName.$oOFA->officerName." ".$oOFA->officerSurname;
} ?>
</font>
<? if($oDA->flag==7){ ?>
<font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b> สัปดาห์ที่ : </b>
<? if($ttId!=0){
$oTTA->SearchTimeTableByttId($ttId);
$oTTA->GetRecord();
echo $oTTA->ttWdAcYWeekNo;
}else{
$i=0;
$oTTA->RSJoinHCByDefineidClIdOfId($defineid,$classId,$officerId);
while($oTTA->GetRecord()){
if($i>=1)
echo " , " ;
echo $oTTA->ttWdAcYWeekNo;
$i=$i+1;
}
} ?>
</font><? } ?> </td>
</tr>
<tr>
<td height="22" colspan="24"><font size="2"><b>นักศึกษาที่ลงทะเบียน
: </b><?=$numAllCourseReg ?> คน
</font> <font size="2">
<? if($oDA->flag==7) {?>
<b> ประเมิน : </b>
<? if($ttId!=0) echo '1'; else echo $i; ?> สัปดาห์
<? }?>
</font></td>
</tr>
<? if($oDA->flag==7) {?>
<tr>
<td height="22" colspan="24"><font size="2"><b>จำนวนครั้งที่ต้องประเมิน
: </b></font><font size="2"> <?=$numAllDo?> ครั้ง
</font> <font size="2"><b>จำนวนครั้งที่เข้ามาประเมิน
: </b></font><font size="2">
<? echo $numCourseDoAss ?> ครั้ง
</font></td>
</tr>
<? }?>
<tr>
<td height="22" colspan="24">
<? if($oDA->flag==7) {?>
<? }else{ ?>
<font size="2"><b>นักศึกษาที่เข้าประเมิน
: </b></font><font size="2"> <? echo $numCourseDoAss; ?> คน </font>
<? $numAllDo=$numAllCourseReg; }?>
<font size="2"><b>ร้อยละเฉลี่ยการเข้ามาประเมิน
: </b></font><font size="2">
<? $percentDo = ($numCourseDoAss/$numAllDo)*100; printf ("%.2f",$percentDo);?>
</font></td>
</tr>
</table>
<br>
<?
if($CntSRQid > 0){
/*------------------------หาจำนวนของส่วนว่ามีกี่ส่วน และจำนวนของข้อคำถามที่มีตัวเลือก----------------------------*/
$numSection = 0;
$ocSA = new SectionAll($oCA);
//$numSection = $oSA->RSCountSectionRQid($assid);
$ocSA->RSByKeyAss($assid);
while($ocSA->GetRecord()){
if($ocSA->sectionRQid != '0'){
$ocRQ = new RadioQuestion($oCA);
$ocRQ->RSRadioQByKey($assid,$ocSA->sectionRQid,1);
while($ocRQ->GetRecord()){
$ocCntRQ = new RadioQuestion($oCA);
$cCntSubQ = $ocCntRQ->RSCountSubRQid($assid,$ocRQ->RQid,'2');
if($cCntSubQ == 0){
$mergeRQ[$numSection]++;
} //end if CntSubQ
$oscRQ = new RadioQuestion($oCA);
$oscRQ->RSCheckLevel($assid,$ocRQ->RQid);
while($oscRQ->GetRecord()){
$mergeRQ[$numSection]++;
} //end while oscRQ
} // end while ocRQ
$numSection++;
} // end if ocSA
} // end while ocSA
?>
<table width="100%" border="1" align="center">
<tr bgcolor="#DFDFDF">
<td width="72" rowspan="2" align="center"><font size="2"><b>ลำดับ</b></font></td>
<td width="67" rowspan="2" align="center"><b><font size="2">ชื่อย่อหลักสูตร</font></b></td>
<td width="54" rowspan="2" align="center"><b><font size="2">รหัสวิชา</font></b></td>
<td width="65" rowspan="2" align="center"><b><font size="2">รหัสอาจารย์</font></b></td>
<td width="89" rowspan="2" align="center"><b><font size="2">รหัสชั้นปีนักศึกษา</font></b></td>
<? /*---------------- กรณีที่เลือกเป็นคำถามชนิดปลายปิด------------------*/
$oSA1= new SectionAll($oCA);
$i = 0;
$indexSection_head = 1;
$oSA1->RSByKeyAss($assid);
while ($oSA1->GetRecord()){
if($oSA1->sectionRQid != '0'){
?>
<td width="87%" height="25%" colspan="<? echo $mergeRQ[$i] ?>" align="center"><font size="2"><b>คะแนนรายข้อคำถาม ส่วนที่ <? echo $indexSection_head; ?> </b></font></td>
<?
$mergeAll += $mergeRQ[$i];
$i++;
} // end if oSA
$indexSection_head++;
} //end while oSA
?>
</tr>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_7"];?>">
<? /*--------------------------------------- สร้างข้อคำถามของแบบประเมินที่มีตัวเลือก-------------------------------*/
$oSA = new SectionAll($oCA);
$oSA->RSByKeyAss($assid);
while($oSA->GetRecord()){
if($oSA->sectionRQid != '0'){
//สร้าง oSRQ แสดงหัวข้อของส่วนการประเมิน
$index1=1;
$oRQ = new RadioQuestion($oCA);
$oRQ->RSRadioQByKey($assid,$oSA->sectionRQid,1);
//---------->แสดงคำถามชนิดปลายปิดข้อหลัก
while($oRQ->GetRecord()){
$oCntRQ = new RadioQuestion($oCA);
$CntSubQ = $oCntRQ->RSCountSubRQid($assid,$oRQ->RQid,'2');
if($CntSubQ == 0){
?>
<td width="294" height="22" align="center" bgcolor="#DFDFDF"><font size="2"><? echo $index1; ?></font></td>
<?
} //end if CntSubQ
$index2=1;
$osRQ = new RadioQuestion($oCA);
$osRQ->RSCheckLevel($assid,$oRQ->RQid);
while($osRQ->GetRecord()){
?>
<td width="106" height="22" align="center" bgcolor="#DFDFDF"><font size="2"><? echo $index1.".".$index2; ?></font></td>
<?
$index2++;
} //end while osRQ
$index1++;
} // end while oRQ
} //end while oSA
} //end if sectionRQ
?>
</tr>
<?
/* --------------------------------------- สร้างตารางผลการประเมิน --------------------------------------------- */
$indexDoAss = 1;
$oDo = new DoAssessment($oCA);
$oDo2 = new DoAssessment($oCA);
if($ttId==0)
$oDo->SearchDoidByDefineidOfficeridClassId($defineid,$officerId,$classId);
else
$oDo->SearchDoidByDefineidOfficeridClassIdttId($defineid,$officerId,$classId,$ttId);
while($oDo->GetRecord()){
$oDo2->SearchByKey($oDo->doid);
$oDo2->GetRecord();
$oStd->SearchByKey($oDo2->studentId);
$oStd->GetRecord();
?>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_5'];?>">
<td align="center"><font size="2"><? echo $indexDoAss; ?></font></td>
<td align="center"><font size="2" 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] = "- ไม่ไ้ด้กำหนด -";
}
//$arrCls[$z] = $oClsOpen->programId;
$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->programAbbr;
}
?>
</font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $oCourse->courseCodeEng?></font></td>
<td align="center"><font size="2"><? if($officerId!=0) echo $oOFA->officerCode; else echo "-"; ?></font></td>
<td align="center"><font size="2"><? echo $oStd->studentYear; ?></font></td>
<?
$orSA = new SectionAll($oCA);
$orSA->RSByKeyAss($assid);
while($orSA->GetRecord()){
if($orSA->sectionRQid != '0'){
$oRRQ->SearchPointByDoidSectionRQid($oDo->doid,$orSA->sectionRQid);
while($oRRQ->GetRecord()){
?>
<td align="center"><font size="2"><? echo $oRRQ->point; ?></font></td>
<?
} // end while oRRQ
} // end if orSA
} // end while orSA
?>
</tr>
<? $indexDoAss++;
} // end while oDo ?>
<? if(($indexDoAss-1) == 0){ ?>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_5'];?>">
<td colspan="<? echo $mergeAll+5 ?>" align="center"> <font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">**
ไม่พบข้อมูล **</font> </td>
</tr>
<? } ?>
</table>
</td>
</tr>
</table>
<? } 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>
<? } set_time_limit(30);?>
<p> </p></form>
</div>
</body>
|