Viewing file:  2553-11-17-1.1.02-detailHoldSomeCourse.php (12.73 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once "../../class/clsDB.php";
include_once "../../class/clsConnection.php";
include_once "../global.php";
include_once "../class/clsReg_Program.php";
include_once "../class/clsReg_SysSemesterDes.php";
include_once "../class/clsAssessForm.php";
include_once "../class/clsDefineAssessment.php";
include_once "../class/clsDoAssessment.php";
include_once "../class/clsHoldCourse.php";
include_once "../class/clsClassAssess.php";
include_once "../class/clsClassOpenForAssess.php";
include_once "../class/clsCourseAssess.php";
include_once "../class/clsTimeTableAssess.php";
include_once "../class/clsHoldPlace.php";
confirmSubmit();
checkFormat();
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']);
$oProg = new Program($oCR);
$oAF = new AssessForm($oCA);
$oDA = new DefineAssessment($oCA);
$oDo = new DoAssessment($oCA);
$oClassA = new ClassAssess($oCA);
$oHC = new HoldCourse($oCA);
$oClsOpen = new ClassOpenForAssess($oCA);
$oCourse = new CourseAssess($oCA);
$oTTA = new TimeTableAssess($oCA);
$oHP = new HoldPlace($oCA);
$oDA->SearchByKey($defineid,$acadYear,$semester,$noAss);
$oDA->GetRecord();
$oSse = new SysSemesterDes($oCR);
$oSse->SearchByKey($oDA->semester);
$oSse->GetRecord();
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
$DoAssCourse = $oDo->CountDoidByDefineid($oDA->defineid);
?>
<html>
<head>
<title>แสดงรายละเอียดของแบบประเมินที่ขึ้นกัีบบางรายวิชา</title>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
</head><br>
<table width="97%" height="172" border="0" align="center" cellpadding="0" cellspacing="2" >
<tr>
<td colspan="2" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><img src="../picture/add.gif" width="18" height="19"><u>รายละเอียดกำหนดช่วงเวลาและแบบประเมินที่ขึ้นกับบางรายวิชา</u></font><br></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>
<? if($oDA->flag == 6) echo "<img src=\"../picture/ball_red.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; else if($oDA->flag == 1) echo "<img src=\"../picture/ball_yellow.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; ?>
</b></font><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"\><b>ลำดับที่</b></font></td>
<td width="69%"><? echo $oDA->noAss; ?></td>
</tr>
<tr>
<td height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>
<? if($oDA->flag == 6) echo "<img src=\"../picture/ball_red.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; else if($oDA->flag == 1) echo "<img src=\"../picture/ball_yellow.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; ?>
ลักษณะการประเมิน</b></font></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">
<? if($oDA->flag == 7){?>
<img src="../picture/icoa18.jpg" border="0">ประเมินรายสัปดาห์
<? if($oDA->isPreAssess==1 ){ ?><img src="../picture/book1.gif" width="18" height="22" border="0"><? echo "ประเมินก่อนเรียน";
}else { ?><img src="../picture/open_book1.jpg" width="18" height="22" border="0"> <? echo "ประเมินหลังเรียน";}
} else if($oDA->flag == 8){ ?>
<img src="../picture/icoa15.jpg" border="0">ประเมินรายอาจารย์ผู้สอน
<? if($oDA->isPreAssess==1 ){ ?><img src="../picture/book1.gif" width="18" height="22" border="0"><? echo "ประเมินก่อนเรียน";
}else { ?><img src="../picture/open_book1.jpg" width="18" height="22" border="0"> <? echo "ประเมินหลังเรียน";}
} else if($oDA->flag == 6){ ?>
<img src="../picture/icoa14.jpg" border="0"> ภาพรวมรายวิชา,ศักยภาพ,สมรรถภาพผู้เรียน ฯลฯ
<? } else if($oDA->flag == 1){ ?> <img src="../picture/icoa15.jpg" border="0">ประเมินรายอาจารย์ผู้สอน
<? } else if($oDA->flag == 9){ ?> <img src="../picture/assEp.jpg" height="18" width="22" border="0">ประเมินแหล่งฝึก
<? } ?>
</font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td width="31%" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>
<? if($oDA->flag == 6) echo "<img src=\"../picture/ball_red.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; else if($oDA->flag == 1) echo "<img src=\"../picture/ball_yellow.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; ?>
ปีการศึกษา</b></font></td>
<td><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $oDA->acadYear; ?>/<?php echo $oSse->semesterName;?></font></td>
</tr>
<tr>
<td height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>
<? if($oDA->flag == 6) echo "<img src=\"../picture/ball_red.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; else if($oDA->flag == 1) echo "<img src=\"../picture/ball_yellow.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; ?>
แบบประเมินที่เลือกใช้</b></font></td>
<td height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">
<? if($oAF->maintopic == ""){ echo $oAF->nameAss." <img src = \"../picture/warn.png\" border = \"0\">"; }else{ echo $oAF->maintopic; } ?>
</font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td height="24"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>
<? if($oDA->flag == 6) echo "<img src=\"../picture/ball_red.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; else if($oDA->flag == 1) echo "<img src=\"../picture/ball_yellow.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; ?>
ช่วงเวลาประเมิน</b></font></td>
<td height="24">
<?php echo abbreDate2($oDA->startDate,'/');?>
<font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b> ถึง</b></font>
<?php echo abbreDate2($oDA->endDate,'/');?>
<font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"> </font></td>
</tr>
<tr>
<td height="24"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>
<? if($oDA->flag == 6) echo "<img src=\"../picture/ball_red.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; else if($oDA->flag == 1) echo "<img src=\"../picture/ball_yellow.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; ?>
วันที่ปิดการประเมิน</b></font></td>
<td height="24"><?php echo abbreDate2($oDA->closeDate,'/');?></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td height="24"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>
<? if($oDA->flag == 6) echo "<img src=\"../picture/ball_red.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; else if($oDA->flag == 1) echo "<img src=\"../picture/ball_yellow.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; ?>
สถานะการประเมิน</b></font></td>
<td height="24"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">
<? if($DoAssCourse == 0){ ?>
<img src = "../picture/no.gif" width="13" height="13"> ยังไม่มีผู้เข้ามาประเมิน
<? } else if($DoAssCourse > 0){ ?>
<img src = "../picture/yes.gif" width="13" height="13">มีผู้เข้ามาประเมินแล้ว
<? } ?>
</font></td>
</tr>
<tr>
<td height="20" colspan="2"><font color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>
<? if($oDA->flag == 6) echo "<img src=\"../picture/ball_red.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; else if($oDA->flag == 1) echo "<img src=\"../picture/ball_yellow.gif\" border =\"0\" align=\"top\" height=\"13\" width=\"13\">"; ?>
ประเมินเฉพาะรายวิชา </b><img src = "../picture/arrow_down.gif"></font></td>
</tr>
</table>
<table width="97%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="silver">
<tr bgcolor="#0066CC">
<td width="12%" height="22" align="center"><font face="Microsoft Sans Serif" size="2" color="#FFFFFF"><b><font color="#FFFFFF" size="2" face="Microsoft Sans Serif">ชื่อย่อ<br>หลักสูตร</font></b></font></td>
<td width="10%" align="center"><font face="Microsoft Sans Serif" size="2" color="#FFFFFF"><b>รหัสวิชา</b></font></td>
<td width="51%" align="center"><font face="Microsoft Sans Serif" size="2" color="#FFFFFF"><b>รายวิชาที่ผูกกับแบบประเมิน</b></font><b></b></td>
<td width="7%" align="center"><font face="Microsoft Sans Serif" size="2" color="#FFFFFF"><b>ชั้นปี</b></font></td>
<td width="13%" align="center"><font face="Microsoft Sans Serif" size="2" color="#FFFFFF"><b>หน่วยกิต</b></font></td>
<td width="7%" align="center"><font face="Microsoft Sans Serif" size="2" color="#FFFFFF"><b>กลุ่ม</b></font></td>
</tr>
<?php
$i = 0;
if($oDA->flag != 9){
$oHC->SearchDistinctClassIdByDefineid($defineid);
$OO = $oHC;
}else{
$oHP->RSDistinctByDefineid($defineid);
$OO = $oHP;
}
while($OO->GetRecord()){
$oClassA->SearchByKey($OO->classId);
$oClassA->GetRecord();
$oCourse->SearchByKey($oClassA->courseId);
$oCourse->GetRecord();
?>
<tr>
<td align="center" bgcolor="#FFFFFF">
<? if(($oClassA->programId == 0) || ($oClassA->programId == "")){
$z = 0;
$oClsOpen->SearchByClassId($oClassA->classId);
while($oClsOpen->GetRecord()){
$oProg->SearchByKey($oClsOpen->programId);
$oProg->GetRecord();
if($oProg->programAbbr != ""){
$arrCls[$z] = $oProg->programAbbr;
}else{
$arrCls[$z] = "<img src = \"../picture/warn.png\" border = \"0\">";
}
//$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($oClassA->programId);
if($oProg->GetRecord()){
if($oProg->programAbbr != ""){
echo $oProg->programAbbr;
}else{
echo "<img src = \"../picture/warn.png\" border = \"0\">";
}
}
//echo $oClassA->programId;
}
?>
</td>
<td align="center" bgcolor="#FFFFFF"><?php echo $oCourse->courseCode;?></td>
<td bgcolor="#FFFFFF"><font size="2" face="Microsoft Sans Serif"><?php echo $oCourse->courseName;?></font></td>
<td bgcolor="#FFFFFF" align="center"><? echo $oClassA->studentYear ?></td>
<td align="center" bgcolor="#FFFFFF"><font size="2" face="Microsoft Sans Serif"><?php echo $oCourse->courseUnit;?></font></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $oClassA->section ?></td>
</tr>
<?php
$i++;
}
if($i == 0) {
?>
<tr>
<td colspan="6" align="center" bgcolor="#FFFFFF"><font size="2" color="#FF0000" face="Microsoft Sans Serif">**
ไม่ปรากฏรายการดังกล่าวในฐานข้อมูล **</font></td>
</tr>
<?php
}
?>
</table>
<br>
<table width="97%" border="0" align="center">
<tr>
<td align="center"><a href="#" onClick="window.close()"><font size="2" face="Microsoft Sans Serif">[ปิดหน้าต่าง]</font></a></td>
</tr>
<tr>
<td><br><table width="466" border="0">
<tr>
<td width="61"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><b>หมายเหตุ
:</b></font></td>
<td width="427"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><u>หมายเลขของหลักสูตรที่แสดงอยู่ในตาราง
หมายถึง </u></font></td>
</tr>
<? $oProg->SearchByProgramStatusY();
while($oProg->GetRecord()){
?>
<tr>
<td> </td>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">
<? if($oProg->programAbbr != ""){
echo $oProg->programAbbr." = ".$oProg->programName;
}else{
echo "<img src = \"../picture/warn.png\" border = \"0\"> = ".$oProg->programName;
}
?>
<? //echo $oProg->programId." = ".$oProg->programName; ?></font></td>
</tr>
<? } ?>
</table></td>
</tr>
</table>
<br>
<p> </p>
</body>
</html>
|