Viewing file:  repCloseDateAssessForm.php (5.35 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//header('Content-type: application/xls');
//header('Content-Disposition: attachment; filename="testing.xls"');
include_once "template.php";
showHeader();
include_once "../../class/clsDB.php";
include_once "../../class/clsConnection.php";
include_once "../global.php";
include_once "../class/clsDefineAssessment.php";
include_once "../class/clsAssessForm.php";
include_once "../class/clsStudentAssess.php";
include_once "../class/clsReg_Program.php";
include_once "../class/clsDoAssessment.php";
include_once "../class/clsCourseAssess.php";
$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']);
$oDA = new DefineAssessment($oCA);
$oAF = new AssessForm($oCA);
$oStd1 = new StudentAssess($oCA);
$oStd2 = new StudentAssess($oCA);
$oProg=new Program($oCR);
$oDo = new DoAssessment($oCA);
$oCA = new CourseAssess($oCA);
$oDA->SearchByKey($defineid, $acadYear, $semester, $noAss);
$oDA->GetRecord();
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
?>
<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>
<div align="center"><br>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<table width="" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td colspan="2" align="center"><font size="2"><b>รายงานรายชื่อนักศึกษาที่ยังไม่ได้ทำการประเมิน</font></td>
</tr>
<tr>
<td height="22"><font size="2"><b>ชื่อแบบประเมิน</b></font></td>
<td ><font size="2"><b>:</b> <?php echo $oAF->maintopic;?></font></td>
</tr>
<tr>
<td height="22"><font size="2"><b>ปีการศึกษา</b></font></td>
<td><font size="2"><b>:</b> <?php echo $acadYear ?></font></td>
</tr>
<tr>
<td><font size="2"><b>ภาคการศึกษา</b></font></td>
<td><font size="2"><b>:</b> <?php echo $semester;?></font></td>
</tr>
<tr>
<td height="22" colspan="4"></td>
</tr>
</table>
<table width="740" border="1" align="center" cellpadding="0" cellspacing="0">
<?php
set_time_limit(0);
$oStd1->RSStudentAssessGroupPgName();
while($oStd1->GetRecord()) {
$pgFlag = 0;
if($oDA->flag == 7)
$oStd2->GetNotAssessFlag7ByPgNameAndAcYAndSeAndDeId($oStd1->programName, $acadYear, $semester, $defineid);
else if($oDA->flag == 2)
$oStd2->GetNotAssessFlag2ByPgNameAndDeId($oStd1->programName, $defineid);
else if($oDA->flag == 3) {
$oProg->SearchProgramIdByPrgramName($oStd1->programName);
$oProg->GetRecord();
$oStd2->GetNotAssessFlag3ByPgNameAndDeIdAndPgId($oStd1->programName, $defineid, $oProg->programId);
}
while($oStd2->GetRecord()) {
$pgFlag++;
if($pgFlag == 1) {
?>
<tr>
<td height="22" colspan="4"><font size="2"><?php echo $oStd1->programName;?></font></td>
</tr>
<?php
}
?>
<tr>
<td height="22"></td>
<td><font size="2"><?php echo $pgFlag;?></font></td>
<td><font size="2"><?php echo $oStd2->studentCode;?></font></td>
<td><font size="2"><?php echo $oStd2->prefixName.$oStd2->studentName.' '.$oStd2->studentSurname;?></font></td>
</tr>
<?php
} // end while $oStd2
} // end while $oStd1
?>
</table>
<table width="" border="1" align="center" cellpadding="5" cellspacing="0">
<tr>
<th><font size="2">วิชา</font></th>
<th><font size="2">กลุ่ม</font></th>
<th > </th>
<th><font size="2">ชื่อนักศึกษา</font></th>
</tr>
<?
if($oDA->flag == 0)
$oDo->RSNotAssessF0($defineid);
else if($oDA->flag == 8)
$oDo->RSNotAssessF8($defineid);
else if($oDA->flag == 5)
$oDo->RSNotAssessF5($defineid);
else if($oDA->flag == 6)
$oDo->RSNotAssessF6($defineid);
else if($oDA->flag == 9)
$oDo->RSNotAssessF9($defineid);
$classid = -1;
$index =1;
while($oDo->GetRecord()) {
if($classid != $oDo->classId){
$classid = $oDo->classId;
$oCA->SearchByKey($oDo->courseId);
$oCA->GetRecord();
$className = " ".$oCA->courseCode."<br> ".$oCA->courseName;
$sec = " ".$oDo->section;
$seq = 1;
$std = -1;
}else{
$className = ' ';
$sec = ' ';
}
$oStd1->SearchByKey($oDo->studentId);
$oStd1->GetRecord()
?>
<tr>
<td ><font size="2"><? echo $className;?></font></td>
<td align="center"><font size="2"><? echo $sec; ?></font></td>
<td align="center"><font size="2"><? echo $index;?></font></td>
<td ><font size="2"><?php echo $oStd1->studentCode." ".$oStd1->prefixName.$oStd1->studentName.' '.$oStd1->studentSurname;?></font></td>
</tr>
<?
$index++;
}
if($index==1){
?>
<tr>
<td colspan="4"><font size="2">ไม่พบรายชื่อนักศึกษาที่ยังไม่ได้ทำการประเมิน</font></td>
</tr>
<?
}
set_time_limit(30);
?>
</table>
</div>
</fieldset></td>
</tr>
</table>
<?php
showFooter();
?>
|