Viewing file:  2551-11-11-1.0.01-deleteResultAssess.php (10.6 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once "template.php";
showHeader();
include_once "../class/clsReg_SysSemesterDes.php";
include_once "../link/function.php";
include_once "../class/clsClassAssess.php";
include_once "../class/clsCourseAssess.php";
include_once "../class/clsTimeTableAssess.php";
include_once "../class/clsOfficerAssess.php";
include_once "../class/clsDefineAssessment.php";
include_once "../class/clsAssessForm.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']);
$oClass = new ClassAssess($oCA);
$oCourse = new CourseAssess($oCA);
$oTTA = new TimeTableAssess($oCA);
$oOFA = new OfficerAssess($oCA);
$oDA = new DefineAssessment($oCA);
$oAF = new AssessForm($oCA);
if(!$acadYear)
$acadYear = $GLOBALS["ACADYEAR"];
if(!$semester)
$semester = $GLOBALS["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><br><fieldset>
<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">ลบผลการประเมิน</font></legend>
<label>
<?php
if(!isset($acadYearSearch)&&(!isset($semesterSearch))){
$acadYearSearch = $acadYear;
$semesterSearch = $semester;
}
$oSse = new SysSemesterDes($oCR);
?>
<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 height="194"><br>
<table width="478" height="67" border="0" align="center" cellpadding="1" cellspacing="1" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"];?>">
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td width="374" height="32"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"> <b>ปีการศึกษา</b></font>
<input name="acadYearSearch" type="text" onKeyPress="if (event.keyCode < 48 || event.keyCode > 57) return false;" value="<? echo $acadYearSearch ?>" size="4" maxlength="4">
<font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>"> </font> <font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>ภาคการศึกษา
<select name="semesterSearch">
<?php
$oSse->RSSysSemesterDes();
while($oSse->GetRecord()) {
?>
<option value="<?php echo $oSse->semester;?>" <? if($oSse->semester == $semesterSearch) echo "selected" ?>><?php echo $oSse->semesterName;?></option>
<?php
}
?>
</select>
</b></font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td height="32"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">
<b>ค้นหาจาก</b>
<select name="selectSearch">
<option value="1" <? if(($selectSearch == 1) || ($selectSearch == "")){ echo "selected"; } ?>>รหัสรายวิชา</option>
<option value="2" <? if($selectSearch == 2){ echo "selected"; } ?>>ชื่อรายวิชา</option>
</select>
</font><font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>">
<input name="inputSearch" type="text" size="30" maxlength="100">
</font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b><font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>">*</font></b></font><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"> </font><font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>">
</font><font face="Microsoft Sans Serif" size="2"><b>
<input type="submit" name="search" value="ค้นหา">
</b></font></td>
</tr>
</table>
<br>
<?
if($inputSearch != ""){
?>
<table width="478" border="0" cellpadding="1" cellspacing="1" align="center">
<tr><td width="8"> </td><td width="16"> </td> <td width="374"> </td> <td width="80"> </td></tr>
<?
$i = 0;
if($selectSearch == 1){
$oCourse->SearchJoinByAcadSemLikeCourseCodeGroupByCourseId($acadYearSearch,$semesterSearch,$inputSearch);
}else if($selectSearch == 2){
$oCourse->SearchJoinByAcadSemLikeCourseNameGroupByCourseId($acadYearSearch,$semesterSearch,$inputSearch);
}
if($oCourse->GetRecord()){
$i++;
if(($i%2) == 0)
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_5"].'">';
else
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_3"];?>" align="left">
<td height="22" colspan="3"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">
<b>รายวิชา</b> <? echo "( ".$oCourse->courseCode." ) "; ?> <? echo $oCourse->courseName ?></font></td>
<td align="right"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">
<b> กลุ่มที่</b></font>
<select name="section" onChange= "selectSection(this.form.section.value)" >
<?
$oClass->SearchByCourseIdAcadSem($oCourse->courseId,$acadYearSearch,$semesterSearch);
while($oClass->GetRecord()){ ?>
<option value="<?=$oClass->section?>" <?php echo ($oClass->section==$section) ? 'selected' : '';?>><?=$oClass->section?></option>
<?php } ?>
</select>
</td></tr>
<?
if (!isset($section))
$oClass->JoinSearchByCourseIdAcadSemSectionGroupClassIdProgramId($oCourse->courseId,$acadYearSearch,$semesterSearch,'1');
else
$oClass->JoinSearchByCourseIdAcadSemSectionGroupClassIdProgramId($oCourse->courseId,$acadYearSearch,$semesterSearch,$section);
while($oClass->GetRecord()){
$i=0;
$oOFA->RSTeacherInEassessByAcYSeClassId($acadYearSearch,$semesterSearch,$oClass->classId);
while($oOFA->GetRecord()){
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<td> </td>
<td colspan="2" ><font size="1" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><img src="../picture/user.gif" width="16" height="16" border="0"> <b><?php echo $oOFA->prefixName.$oOFA->officerName." ".$oOFA->officerSurname;?></b></font> </td>
<td> </td>
</tr>
<?php $oDA->RSDefineTeacherByAcYSeClassIdOfficerId($acadYearSearch,$semesterSearch,$oClass->classId,$oOFA->officerId);
while($oDA->GetRecord()){
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
?>
<tr>
<td> </td>
<td ><input type="checkbox" name="" value="" ></td>
<td><?php if($oDA->flag == 7){?>
<img src="../picture/icoa18.jpg" border=0>
<?php }else{?>
<img src="../picture/icoa15.jpg" border=0>
<?php } if($oAF->maintopic == ""){ echo $oAF->nameAss." <img src = \"../picture/warn.png\" border = \"0\">"; }else{ echo $oAF->maintopic; } echo " " ?>
<br> (ระหว่างวันที่ <? echo abbreDate(splitDateDb2($oDA->startDate,'/')); ?>
- <? echo abbreDate(splitDateDb2($oDA->endDate,'/')); ?>)</td>
<td align="center"> </td>
</tr>
<?php } // end while oDA
$i++;
$flag=1;
} // end while TT
if($flag == 0) {
?>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_5"];?>">
<td colspan="6" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">**
ไม่ปรากฏรายชื่ออาจารย์ที่สอน **</font></td>
</tr>
<?php
}
} //end while Classs
?>
<?
} // end if
if($i == 0){
?>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_5"];?>">
<td colspan="2" height="20" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3'];?>">**
ไม่ปรากฏ<?
if($inputSearch != ""){
if($selectSearch == 1){
echo "รหัสวิชา '".$inputSearch,"' ";
}else if($selectSearch == 2){
echo "ชื่อรายวิชา '".$inputSearch,"' ";
}
}else {
echo "รายการ";
}?>ในฐานข้อมูล **</font></td>
</tr>
<?php } ?>
</table>
<? } // end inputSearch ?>
<table width="488" border="0" align="center">
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><input type="button" name="back2" value="กลับสู่หน้าหลัก" onClick=" location.href = 'index.php?mm=1'"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</div>
</fieldset>
<table width="742" border="0">
<tr>
<td width="63" height="27"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><strong>หมายเหตุ
: </strong></font></td>
<td width="669"><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2">กรอกปีการศึกษา
เลือกภาคการศึกษา และกรอกรหัสรายวิชา หรือชื่อรายวิชา เพื่อค้นหาแบบประเมินที่ขึ้นกับชั้นปีนักศึกษา
และหลักสูตร</font></td>
</tr>
<tr>
<td height="27"> </td>
<td><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2">เลือกคลิกที่รหัสวิชาหรือชื่อรายวิชา
เพื่อดูผลการประเมิน</font></td>
</tr>
<tr>
<td height="27"> </td>
<td> </td>
</tr>
</table> </td>
</tr>
</table>
<form name="silent" id="silent" style="margin:0px; padding: 0px;" method="post"></form>
<?php
showFooter();
?>
<script language="JavaScript1.2">
function selectSection(section){
location.replace("<?php echo $PHP_SELF;?>?selectSearch=<?=$selectSearch?>&inputSearch=<?=$inputSearch?>&acadYearSearch=<?=$acadYearSearch?>&semesterSearch=<?=$semesterSearch?>§ion="+section);
}
</script>
|