Viewing file:  startPageAss.php (20.35 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once "template.php";
showHeader();
include_once "../link/function.php";
include_once "../class/clsReg_Acad.php";
include_once "../class/clsStudentAssess.php";
include_once "../class/clsReg_Program.php";
include_once "../class/clsRegistration.php";
include_once "../class/clsClassAssess.php";
include_once "../class/clsClassInStructorAssess.php";
include_once "../class/clsDefineAssessment.php";
include_once "../class/clsHoldCourse.php";
include_once "../class/clsDoAssessment.php";
include_once "../class/clsCourseAssess.php";
include_once "../class/clsHoldStudent.php";
include_once "../class/clsDoAssessmentHStd.php";
include_once "../class/clsAssessForm.php";
include_once "../class/clsHoldProgram.php";
include_once "../class/clsTimeTableAssess.php";
include_once "../class/clsOfficerAssess.php";
include_once "../class/clsWeekDateAssess.php";
include_once "../class/clsReg_Period.php";
include_once "../class/clsMainExternalPlace.php";
include_once "../class/clsSubExternalPlace.php";
include_once "../class/clsReg_StudentStatus.php";
include_once "../class/clsReg_StudentMaster.php";
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']);
$oAc = new Acad($oCR);
$orPr = new Period($oCR);
$oStd = new StudentAssess($oCA);
$oProg=new Program($oCR);
$oReg = new Registration($oCA);
$oClass = new ClassAssess($oCA);
$oCIS = new ClassInStructorAssess($oCA);
$oDA = new DefineAssessment($oCA);
$oDo = new DoAssessment($oCA);
$oHC = new HoldCourse($oCA);
$oCourse = new CourseAssess($oCA);
$oHStd = new HoldStudent($oCA);
$oDoHStd = new DoAssessmentHStd($oCA);
$oAF = new AssessForm($oCA);
$oHP = new HoldProgram($oCA);
$oTTA = new TimeTableAssess($oCA);
$oTTA2 = new TimeTableAssess($oCA);
$oOFA = new OfficerAssess($oCA);
$oDA2 = new DefineAssessment($oCA);
$oWDA = new WeekDateAssess($oCA);
$studentCode = $oU->userLogin;
$nowDate = getNowDateTh();
$acadYear = $GLOBALS["ACADYEAR_R"];
$semester = $GLOBALS["SEMESTER_R"];
$now = GetNowDate();
list($y, $m, $d) = split('[-]', $now);
$now2=$d."-".$m."-".$y;
$oAc->RSAcad();
$oAc->GetRecord();
$oStd->SearchByStCodeAndStudying($studentCode);
$oStd->GetRecord();
$oProg->SearchProgramIdByPrgramName($oStd->programName);
$oProg->GetRecord();
$oSm = new StudentMaster($oCR);
$oSm->SearchByKey($oStd->studentId);
$oSm->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><br><fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>">เริ่มการประเมิน</font></legend>
<div align="center"><br><form name="pc" method="post" action="<?php echo $PHP_SELF;?>">
<table width="650" align="center" border="0" cellpadding="0" cellspacing="1">
<tr>
<td><table width="100%" border="0" cellspacing="1" cellpadding="1" align="center" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"];?>">
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td width="13%" height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>รหัสนักศึกษา</b></font></td>
<td width="44%"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>:</b> <?php echo $oStd->studentCode;?></font></td>
<td width="13%"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>ชื่อ-นามสกุล</b></font></td>
<td width="30%"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>:</b> <?php echo $oStd->prefixName.$oStd->studentName.' '.$oStd->studentSurname;?></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 $oStd->programName;?></font></td>
<td><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 $oStd->studentYear;?></font></td>
</tr>
<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><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>:</b> <?php echo $acadYear ?></font></td>
<td><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 $semester;?></font></td>
</tr>
</table></td>
</tr>
<tr>
<td height="22"></td>
</tr>
<tr>
<td><table width="100%">
<?php
$showFlag = 0;
$noAssFlag = 1;
// $oReg->RSEnrollItemByStIdAndAcYAndSe($oStd->studentId, $acadYear, $semester);
$oReg->RSClassIdByStdId($oStd->studentId);
while($oReg->GetRecord()) {
$doAssFlag = 1;
$oClass->SearchByKey($oReg->classId);
$oClass->GetRecord();
// case 0 & case 1
$flag0_mustDo = 0;
$flag1_mustDo = 0;
$oCIS->SearchByClassIdGroupClassIdOfficerId($oReg->classId);
while($oCIS->GetRecord()) {
$oDA->RSByFlagAndBetweenSCDate(0, $nowDate);
while($oDA->GetRecord()) {
if($oDA->acadYear==$oClass->acadYear && $oDA->semester==$oClass->semester ){
$chAssHold = $oDo->CountCheckAssessment($oDA->defineid, $oStd->studentId,$oCIS->officerId,$oReg->classId,$oClass->section);
//if($chAssHold == 0) {
$doAssFlag = 0;
$noAssFlag = 0;
$flag0_mustDo =$flag0_mustDo+1;
//}
}
} // end while $oDA
$oDA->RSDefineidByFlagBetweenSCDateClId(1,$nowDate,$oReg->classId);
while($oDA->GetRecord()) {
$oDA2->SearchByDefineid($oDA->defineid);
$oDA2->GetRecord();
if($oDA2->acadYear==$oClass->acadYear && $oDA2->semester==$oClass->semester ){
$chAssHold = $oDo->CountCheckAssessment($oDA2->defineid, $oStd->studentId,$oCIS->officerId,$oReg->classId,$oClass->section);
//if($chAssHold == 0) {
$doAssFlag = 0;
$noAssFlag = 0;
$flag1_mustDo =$flag1_mustDo+1;
//}
}
} // end while $oDA
} // end while $oCIS
// case 5
$flag5_mustDo = 0;
$oDA->RSByFlagAndBetweenSCDate(5, $nowDate);
while($oDA->GetRecord()) {
if($oDA->acadYear==$oClass->acadYear && $oDA->semester==$oClass->semester ){
$chAssHold = $oDo->CountCheckAssessment3($oDA->defineid, $oStd->studentId,$oReg->classId,$oClass->section);
//if($chAssHold == 0) {
$doAssFlag = 0;
$noAssFlag = 0;
$flag5_mustDo =$flag5_mustDo+1;
//}
}
} // end while $oDA
// case 6
$flag6_all = 0;
$flag6_mustDo =0;
$oDA->RSDefineidByFlagBetweenSCDateClId(6,$nowDate,$oReg->classId);
while($oDA->GetRecord()){
$flag6_all =$flag6_all+1;
$oDA2->SearchByDefineid($oDA->defineid);
$oDA2->GetRecord();
$oAF->SearchByKey($oDA2->assid);
$oAF->GetRecord();
if($oDA2->acadYear==$oClass->acadYear && $oDA2->semester==$oClass->semester ){
$chAssHold = $oDo->CountCheckAssessment3($oDA2->defineid, $oStd->studentId,$oReg->classId,$oClass->section);
//if($chAssHold ==0){
$doAssFlag = 0;
$noAssFlag = 0;
$flag6_mustDo =$flag6_mustDo+1;
// }
}
}
//case 7
$flag7_Do = 0;
$flag7_mustDo = 0;
$oDA->RSAssidByFlagBetweenSCDateClId(7,$nowDate,$oReg->classId);
while($oDA->GetRecord()){
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
$oHC->RSAssessFlag7ByAssid($oDA->assid,$nowDate,$oReg->classId);
$i =1;
while($oHC->GetRecord()){
$oDA2->SearchByDefineid($oHC->defineid);
$oDA2->GetRecord();
$oTTA->SearchTimeTableByttId($oHC->ttId);
$oTTA->GetRecord();
$oOFA->SearchByKey($oTTA->ttOfId);
$oOFA->GetRecord();
if($oDA2->acadYear==$oClass->acadYear && $oDA2->semester==$oClass->semester ){
$chAssHold = $oDo->CountCheckAssessment2($oDA2->defineid,$oStd->studentId,$oTTA->ttOfId,$oTTA->ttId,$oClass->section);
$show=1;
$today=getWeekDay($now2);
$oWDA->searchWeekByScDate($now);
$oWDA->GetRecord();
// if($chAssHold != 0){
// $show=0;
// $flag7_Do = $flag7_Do+1;
// }elseif($oDA2->isPreAssess==0 && $acadYear <= $oDA2->acadYear){
$curTime = date("H:i:s");
$orPr->SearchBetweenTime($curTime);
$orPr->GetRecord();
// if(($oWDA->wdAcYWeekNo < $oTTA->ttWdAcYWeekNo ) || ($oWDA->wdAcYWeekNo==$oTTA->ttWdAcYWeekNo && $today <= $oTTA->ttDyId && $orPr->period <= $oTTA->ttToPr ) )
// $show=0;
// }
if($show){
$flag7_mustDo = $flag7_mustDo+1;
}// end if show
}// end if oDA2
}// loop oHC
}// loop oDA
if($flag7_mustDo!=0){
$doAssFlag = 0;
$noAssFlag = 0;
}
//End case 7
//case 8
$flag8_all = 0;
$flag8_mustDo =0;
$oDA->RSAssidByFlagBetweenSCDateClId(8,$nowDate,$oReg->classId);
while($oDA->GetRecord()){
$oHC->RSAssessFlag8ByAssidSCDateClId($oDA->assid,$nowDate,$oReg->classId);
while($oHC->GetRecord()){
$oDA2->SearchByDefineid($oHC->defineid);
$oDA2->GetRecord();
$oOFA->SearchByKey($oHC->officerId);
$oOFA->GetRecord();
if($oDA2->acadYear==$oClass->acadYear && $oDA2->semester==$oClass->semester ){
$show=1;
/*$chAssHold = $oDo->CountCheckAssessment($oHC->defineid,$oStd->studentId,$oHC->officerId,$oReg->classId,$oClass->section);
if($chAssHold != 0){
$show=0;
}elseif($oDA2->isPreAssess==0 && $acadYear <= $oDA2->acadYear){
$oTTA->SearchMaxWeekByClIdOfId($oReg->classId,$oHC->officerId);
$oTTA->GetRecord();
$oTTA2->SearchByClassIdWeekNoOrderMaxDyId($oReg->classId,$oTTA->ttWdAcYWeekNo);
$oTTA2->GetRecord();
$today=getWeekDay($now2);
$curTime = date("H:i:s");
$orPr->SearchBetweenTime($curTime);
$orPr->GetRecord();
$oWDA->searchWeekByScDate($now);
if( $oWDA->GetRecord()){
if(($oWDA->wdAcYWeekNo < $oTTA->ttWdAcYWeekNo ) || ($oWDA->wdAcYWeekNo==$oTTA->ttWdAcYWeekNo && $today <= $oTTA2->ttDyId && $orPr->period <= $oTTA2->ttToPr ) )
$show=0;
}
}*/
if($show){
$flag8_mustDo = $flag8_mustDo+1;
}
}
} //while oHC
} //while oDA
if($flag8_mustDo!=0){
$doAssFlag = 0;
$noAssFlag = 0;
}
//case 9
$flag9_all = 0;
$flag9_mustDo =0;
$oDA->RSDefineidHPByFlagBetweenSCDateClId(9,$nowDate,$oReg->classId);
while($oDA->GetRecord()){
//-------- ข้ามเทอม
$oDA2->SearchByDefineid($oDA->defineid);
$oDA2->GetRecord();
if($oDA2->acadYear==$oClass->acadYear && $oDA2->semester==$oClass->semester ){
$oAF->SearchByKey($oDA2->assid);
$oAF->GetRecord();
// หาแหล่งฝึก
$oTTA->RSMepSepByClassId($oReg->classId);
while($oTTA->GetRecord()){
$oMep = new MainExternalPlace($oCA);
$oMep->SearchById($oTTA->ttEpMepId);
$oMep->GetRecord();
$oSep = new SubExternalPlace($oCA);
$oSep->SearchByKey($oTTA->ttEpSepId);
$oSep->GetRecord();
$chAssHold = $oDo->CountCheckAssessmentHP($oDA2->defineid,$oStd->studentId,$oReg->classId,$oClass->section,$oMep->mepId,$oSep->sepId);
//if($chAssHold == 0){
$flag9_mustDo++;
//}// end if
}//end loop oTTA
}// ข้ามเทอม
}// loop oDA
if($flag9_mustDo!=0){
$doAssFlag = 0;
$noAssFlag = 0;
}
if(!$doAssFlag) {
$showFlag++;
if($showFlag == 1) {
?>
<tr>
<td width="20%" align="right"><img src="../picture/book.jpg" width="125" height="115" border="0"></td>
<td width="80%"><table width="100%">
<tr>
<td height="22" colspan="3"><img src="../picture/HoldCourse.png" border="0">
<font size="2" color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>"><b>ประเมินรายวิชาที่ลงทะเบียนเรียน</b></font></td>
</tr>
<?php
}
$oCourse->SearchByKey($oClass->courseId);
$oCourse->GetRecord();
if(($showFlag%2) == 0)
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_5"].'">';
else
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<td width="7" height="22"></td>
<td width="18" valign="top"><img src="../picture/linesub.gif" border="0"></td>
<td width="447"><a href = "showFormByCourse.php?studentId=<? echo $oStd->studentId?>&classId=<? echo $oReg->classId ?>&courseId=<? echo $oClass->courseId;?>&flag9_mustDo=<?=$flag9_mustDo;?>&flag7_mustDo=<?=$flag7_mustDo;?>&flag6_mustDo=<?=$flag6_mustDo;?>&flag8_mustDo=<?=$flag8_mustDo;?>&flag0_mustDo=<?=$flag0_mustDo;?>&flag1_mustDo=<?=$flag1_mustDo;?>&flag5_mustDo=<?=$flag5_mustDo;?>" onClick="return sendRequest(this);" >
<img src="../picture/button_do.gif" border ="0">
<font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo " ".$oCourse->courseCode." ".$oCourse->courseName." ".$oCourse->courseUnit." กลุ่ม".$oClass->section; ?></font></a></td>
</tr>
<?php
} // end if !$doAssFlag
} // end while $oReg
if(!$noAssFlag) {
?>
</table></td>
</tr>
<?php
}
// case 2
$showGFlag2 = 0;
$oDA->RSByFlagAndBetweenSCDate(2, $nowDate);
while($oDA->GetRecord()) {
$doAssFlag = 1;
// หาว่าในปีการศึกษานั้นนักศึกษาอยู่ชั้นปีใด
$oSs = new StudentStatus($oCR);
$studentYear = $oSs->CalStYByStIdAndAcY($oSm->studentId,$oDA->acadYear,$oSm->admitAcadYear);
// หาก่อนว่า ปีเทอมของแบบประเมิน นักศึกษาลงทะเบียนเทอมนั้นมั้ย
// $num_class = $oStd->CountHstdRegis($oDA->acadYear,$oDA->semester, $studentYear);//$oDA->semester
// if($num_class>0){
$oHStd->RSHoldStudentByDfIdAndStY($oDA->defineid,$studentYear);
if($oHStd->GetRecord()) {
if(!$oDoHStd->CountCheckAssessment($oDA->defineid, $oStd->studentId)) {
$doAssFlag = 0;
$noAssFlag = 0;
}
} // end if $oHStd
// }
if(!$doAssFlag) {
$showGFlag2++;
if($showGFlag2 == 1) {
?>
<tr>
<td width="20%" align="right"><img src="../picture/pencil.bmp" width="125" height="115" border="0"></td>
<td width="80%"><table width="100%">
<tr>
<td height="22" colspan="3"><img src="../picture/HoldStd.png" border="0">
<font size="2" color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>"><b>แบบประเมินทั่วไป</b></font></td>
</tr>
<?php
}
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
if(($showGFlag2%2) == 0)
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_5"].'">';
else
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<td width="7" height="22"></td>
<td width="18" valign="top"><img src="../picture/linesub.gif" border="0"></td>
<td width="447"><a href = "assessFormHStd.php?defineid=<? echo $oDA->defineid ?>&assid=<? echo $oDA->assid ?>&studentId=<? echo $oStd->studentId?>" onClick="return sendRequest(this);" onMouseOver="window.status=''; return true;">
<font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oAF->nameAss;?>
(<img src="../picture/no.gif" border ="0">
ยังไม่ได้ประเมิน)</font></a></td>
</tr>
<?php
} // end if !$doAssFlag
} // end while $oDA
// case 3
$showGFlag3 = 0;
// $oDA->RSDefineAssessmentByAcYAndSeAndFlagAndBetweenSCDate($acadYear, $semester, 3, $nowDate);
$oDA->RSByFlagAndBetweenSCDate(3, $nowDate);
while($oDA->GetRecord()) {
$doAssFlag = 1;
$oHP->SearchByDefineIdProgramIdStdYearAss($oDA->defineid, $oProg->programId, $oStd->studentYear);
if($oHP->GetRecord()) {
if(!$oDoHStd->CountCheckAssessment($oDA->defineid, $oStd->studentId)) {
$doAssFlag = 0;
$noAssFlag = 0;
}
} // end if $oHStd
if(!$doAssFlag) {
$showGFlag3++;
if($showGFlag2==0 && $showGFlag3==1) {
?>
<tr>
<td width="20%" align="right"><img src="../picture/pencil.bmp" width="125" height="115" border="0"></td>
<td width="80%"><table width="100%">
<tr>
<td height="22" colspan="3"><img src="../picture/HoldStd.png" border="0">
<font size="2" color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>"><b>แบบประเมินทั่วไป</b></font></td>
</tr>
<?php
}
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
if((($showGFlag2+$showGFlag3)%2) == 0)
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_5"].'">';
else
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<td width="7" height="22"></td>
<td width="18" valign="top"><img src="../picture/linesub.gif" border="0"></td>
<td width="447"><a href = "assessFormHStd.php?defineid=<? echo $oDA->defineid ?>&assid=<? echo $oDA->assid ?>&studentId=<? echo $oStd->studentId?>" onClick="return sendRequest(this);" onMouseOver="window.status=''; return true;">
<font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oAF->nameAss;?>
(<img src="../picture/no.gif" border ="0">
ยังไม่ได้ประเมิน)</font></a></td>
</tr>
<?php
} // end if !$doAssFlag
} // end while $oDA
if(($showGFlag2 || $showGFlag3) && !$noAssFlag) {
?>
</table></td>
</tr>
<?php
}
?>
</table></td>
</tr>
<?php
if($noAssFlag) {
?>
<tr>
<td align="center"><img src="../picture/lock.gif" border="0">
<font size="2" color="<?php echo $GLOBALS["COLOR_FONT_7"]; ?>">ไม่สามารถประเมินได้ เนื่องจากยังไม่ได้อยู่ในช่วงประเมิน !</font></td>
</tr>
<?php
}
?>
</table>
</form></div>
</fieldset><br>
<table width="742" border="0">
<tr>
<td height="27"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><strong>หมายเหตุ : </strong></font></td>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">คลิกที่รายวิชาเพื่อทำการประเมินอาจารย์ผู้สอน</font></td>
</tr>
<tr>
<td height="27"> </td>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><img src="../picture/button_ok.gif" border="0">
หมายถึง ประเมินครบทุกแบบประเมิน โดยแยกตามอาจารย์ผู้สอนสำหรับรายวิชานั้นๆ เรียบร้อยแล้ว</font></td>
</tr>
<tr>
<td height="27"> </td>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><img src="../picture/button_do.gif" border="0">
หมายถึง ยังประเมินไม่ครบทุกแบบประเมิน โดยแยกตามผู้สอนสำหรับรายวิชานั้นๆ</font></td>
</tr>
<tr>
<td width="71" height="27"> </td>
<td width="659"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><img src="../picture/button_cancel.gif" border="0">
หมายถึง ยังไม่ได้ประเมินทุกแบบประเมิน โดยแยกตามผู้สอนสำหรับรายวิชานั้นๆ</font></td>
</tr>
</table></td>
</tr>
</table>
<form name="silent" id="silent" style="margin:0px; padding: 0px;" method="post"></form>
<?php
showFooter();
?>
|