Viewing file:      2551-11-11-1.0.01-showDeFormTeachOverViewCollege.php (15.8 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 "../class/clsReg_AcadYearConfig.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 = "./reportDataRQCourseTep5_1.php?"+src;
     }else if(holdCourse == 2){
         var links = "./reportDataRQCourseTep5_1.php?"+src;
     }
     window.open(links, '', 'toolbars=0, scrollbars=yes, location=0, statusbars=0, menubars=0, resizable=yes, width=950 height=600, left = 30, 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);
 $oAy = new AcadYearConfig($oCR);
 $oCourse = new CourseAssess($oCA);
 $oClass = new ClassAssess($oCA);
 $oClsOpen = new ClassOpenForAssess($oCA);
 $oCIS = 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);
 
 if(!$acadYear)
     $acadYear = $GLOBALS["ACADYEAR"];
 if(!$semester)
     $semester = $GLOBALS["SEMESTER"];
 
 if(!isset($acadYearSearch)&&(!isset($semesterSearch))){
         $acadYearSearch = $acadYear;
         $semesterSearch = $semester;
 }
 
 ?>
 <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="searchFormByTeachName.php"> 
       </a>แยกตามรายการแบบประเมิน</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">
                 <table width="633" border="0" align="center" cellpadding="1" cellspacing="1" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"];?>">
                   <tr> 
                     <td width="623" height="22" colspan="3"> <table width="341" border="0" align="right" background="../picture/coverBG3.gif">
                         <tr> 
                           <td width="341" height="33" ><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>  ปีการศึกษา 
                             :</b><b> 
                             <select name="semesterSearch" onChange="location.href = '<?php echo $PHP_SELF;?>?acadYearSearch='+encodeURI(options[selectedIndex].value)+'&semesterSearch=<?php echo $semesterSearch;?>'">
                               <?php
                                 $oAy->RSAcadYearConfigGroupAcY();
                                 while($oAy->GetRecord()) {
 ?>
                               <option value="<?php echo $oAy->acadYear;?>" <? if($acadYearSearch == $oAy->acadYear) echo "selected"; ?>><?php echo $oAy->acadYear;?></option>
                               <?php                
                                 }
 ?>
                             </select>
                             ภาคการศึกษา :</b><b> 
                             <select name="semesterSearch" onChange="location.href = '<?php echo $PHP_SELF;?>?semesterSearch='+encodeURI(options[selectedIndex].value)+'&acadYearSearch=<?php echo $acadYearSearch;?>'">
                               <?php
                                 $oSse->RSSysSemesterDes();
                                 while($oSse->GetRecord()) {
 ?>
                               <option value="<?php echo $oSse->semester;?>" <? if($semesterSearch == $oSse->semester) echo "selected"?>><?php echo $oSse->semesterName;?></option>
                               <?php
                                 }
 ?>
                             </select>
                             </b></font></td>
                         </tr>
                       </table></td>
                   </tr>
                   <tr valign="top"> 
                     <td height="146" colspan="3"> <fieldset>
                       <legend><img src="../picture/bookmark.gif" width="12" height="13" border="0"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_6"]; ?>"> 
                       ผลการประเมินนักศึกษาประเมินอาจารย์ในภาพรวมของวิทยาลัย</font></legend>
                       <table width="599" align="center">
                         <tr> 
                           <td colspan="2"> </td>
                         </tr>
                         <?php
                           $i=0;
                         $flag1=0;
                         /*------------------------------------------ค้นหาแบบประเมินที่ได้กำหนดไว้   แบบที่ผูกกับรายวิชาทั้งหมด (flag =0)---------------------------------*/
                         $oDA->SearchByAcadSemFlag($acadYearSearch,$semesterSearch,'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/icoa17.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 ?>&acadYear=<? echo  $acadYearSearch ?>&semester=<? echo $semesterSearch ?>')"> 
                             <?  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 =1)-------------------------------*/
                     $oDA->SearchByAcadSemFlag($acadYearSearch,$semesterSearch,'1');
                     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;
                             }
                 ?>
                         <tr> 
                           <td valign="top"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"> 
                             <!--ถ้า sectionRQid > 0 ที่ sequence = 1 แสดงว่าส่วนแรกเป็นคำถามปลายปิด--->
                             <img src="../picture/icoa17.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 ?>&acadYear=<? echo  $acadYearSearch ?>&semester=<? echo $semesterSearch ?>')"> 
                             <?  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              
                                     
                     $i=0;
                     $flagHold7=0;
             
                     /*---------------------------------ค้นหาแบบประเมินที่ได้กำหนดไว้  แบบที่ผูกกับบางรายวิชา(flag =7) week =7-------------------------------*/
                     $oDA->SearchByAcadSemFlag($acadYearSearch,$semesterSearch,'7');
                     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;
                             }
                 ?>
                         <tr> 
                           <td valign="top"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"> 
                             <!--ถ้า sectionRQid > 0 ที่ sequence = 1 แสดงว่าส่วนแรกเป็นคำถามปลายปิด--->
                             <img src="../picture/icoa17.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 ?>&acadYear=<? echo  $acadYearSearch ?>&semester=<? echo $semesterSearch ?>')"> 
                             <?  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
                             $flagHold7 = 1;     
                         $i++;                
                     } // end while oDA              
                 
                                 /*---------------------------------ค้นหาแบบประเมินที่ได้กำหนดไว้  แบบที่ผูกกับบางรายวิชา(flag =8) Teacher new version-------------------------------*/
                     $oDA->SearchByAcadSemFlag($acadYearSearch,$semesterSearch,'8');
                     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;
                             }
                 ?>
                         <tr> 
                           <td valign="top"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"> 
                             <!--ถ้า sectionRQid > 0 ที่ sequence = 1 แสดงว่าส่วนแรกเป็นคำถามปลายปิด--->
                             <img src="../picture/icoa17.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 ?>&acadYear=<? echo  $acadYearSearch ?>&semester=<? echo $semesterSearch ?>')"> 
                             <?  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
                             $flagHold7 = 1;     
                         $i++;                
                     } // end while oDA              
                 ?>
                         <? if(($flag2 == 0 && $flagHold2 == 0) && ($flag1 == 0 && $flagHold == 0)) { ?>
                         <tr> 
                           <td colspan="2"> </td>
                         </tr>
                         <tr> 
                           <td colspan="2" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">** 
                             ไม่ปรากฏรายการแบบประเมินที่ใช้ประเมินในปีการศึกษา 
                             <?php echo $acadYearSearch ?>/ 
                             <?php  $oSse->SearchByKey($semesterSearch);
 $oSse->GetRecord(); echo $oSse->semesterName;?>
                              **</font></td>
                         </tr>
                         <tr> 
                           <td colspan="2"> </td>
                         </tr>
                         <? } ?>
                       </table>
                       <br>
                       </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 = 'index.php?mm=1' ">
                 <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();
 ?>
  |