Viewing file: 2551-03-10-1.0.01-repCloseDateCourse.php (7.87 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
header('Content-type: application/xls');
header('Content-Disposition: attachment; filename="testing.xls"');
include_once "../../class/clsDB.php";
include_once "../../class/clsConnection.php";
include_once "../global.php";
include_once "../class/clsCourseAssess.php";
include_once "../class/clsDefineAssessment.php";
include_once "../class/clsClassInStructorAssess.php";
include_once "../class/clsStudentAssess.php";
include_once "../class/clsAssessForm.php";
include_once "../class/clsOfficerAssess.php";
$oCA = new clsConnection($GLOBALS['HOST'], $GLOBALS['DB_EASS'], $GLOBALS['USER_EASS'], $GLOBALS['PASSWORD_EASS']);
$oCourse = new CourseAssess($oCA);
$oDA = new DefineAssessment($oCA);
$oCIS = new ClassInStructorAssess($oCA);
$oStd1 = new StudentAssess($oCA);
$oStd2 = new StudentAssess($oCA);
$oAF = new AssessForm($oCA);
$oOf = new OfficerAssess($oCA);
$oCourse->SearchByKey($courseId);
$oCourse->GetRecord();
?>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" height="22"><font size="2"><b>รหัสรายวิชา</b></font></td>
<td colspan="2"><font size="2"><b>:</b> <?php echo $oCourse->courseCode;?></font></td>
<td colspan="2"><font size="2"><b>ชื่อรายวิชา</b></font></td>
<td colspan="2"><font size="2"><b>:</b> <?php echo $oCourse->courseName;?></font></td>
</tr>
<tr>
<td colspan="2" height="22"><font size="2"><b>ปีการศึกษา</b></font></td>
<td colspan="2"><font size="2"><b>:</b> <?php echo $acadYear ?></font></td>
<td colspan="2"><font size="2"><b>ภาคการศึกษา</b></font></td>
<td colspan="2"><font size="2"><b>:</b> <?php echo $semester;?></font></td>
</tr>
<tr>
<td height="22" colspan="8"></td>
</tr>
<?php
// case 0
$oDA->SearchByAcadSemFlag($acadYear, $semester, 0);
while($oDA->GetRecord()) {
$ofFlag = 0;
$oCIS->RSClassInStructorAssessByAcYAndSeAndCoIdGroupOfId($acadYear, $semester, $courseId);
while($oCIS->GetRecord()) {
$pgFlag = 0;
$oStd1->RSStudentAssessGroupPgName();
while($oStd1->GetRecord()) {
$stFlag = 0;
$oStd2->GetNotAssessFlag0ByPgNameAndAcYAndSeAndCoIdAndDeIdAndOfId($oStd1->programName, $acadYear, $semester, $courseId, $oDA->defineid, $oCIS->officerId);
while($oStd2->GetRecord()) {
$ofFlag++;
$pgFlag++;
$stFlag++;
if($ofFlag == 1) {
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
?>
<tr>
<td colspan="8" height="22"><font size="2"><?php echo $oAF->nameAss;?></font></td>
</tr>
<?php
}
if($pgFlag == 1) {
$oOf->SearchByKey($oCIS->officerId);
$oOf->GetRecord();
?>
<tr>
<td height="22"></td>
<td colspan="7"><font size="2"><?php echo $oOf->officerCode.' '.$oOf->prefixName.$oOf->officerName.' '.$oOf->officerSurname;?></font></td>
</tr>
<?php
}
if($stFlag == 1) {
?>
<tr>
<td colspan="2" height="22"></td>
<td colspan="6"><font size="2">หลัักสูตร<?php echo $oStd1->programName;?></font></td>
</tr>
<?php
}
?>
<tr>
<td colspan="3" height="22"></td>
<td><font size="2"><?php echo $stFlag;?></font></td>
<td><font size="2"><?php echo $oStd2->studentCode;?></font></td>
<td colspan="3"><font size="2"><?php echo $oStd2->prefixName.$oStd2->studentName.' '.$oStd2->studentSurname;?></font></td>
</tr>
<?php
} // end while $oStd2
} // end while $oStd1
} // end while $oCIS
} // end while $oDA
// case 1
$oDA->RSDefineAssessmentByAcYAndSeAndFlagAndCoId($acadYear, $semester, 1, $courseId);
while($oDA->GetRecord()) {
$ofFlag = 0;
$oCIS->RSClassInStructorAssessByAcYAndSeAndCoIdGroupOfId($acadYear, $semester, $courseId);
while($oCIS->GetRecord()) {
$pgFlag = 0;
$oStd1->RSStudentAssessGroupPgName();
while($oStd1->GetRecord()) {
$stFlag = 0;
$oStd2->GetNotAssessFlag1ByPgNameAndAcYAndSeAndCoIdAndDeIdAndOfId($oStd1->programName, $acadYear, $semester, $courseId, $oDA->defineid, $oCIS->officerId);
while($oStd2->GetRecord()) {
$ofFlag++;
$pgFlag++;
$stFlag++;
if($ofFlag == 1) {
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
?>
<tr>
<td colspan="8" height="22"><font size="2"><?php echo $oAF->nameAss;?></font></td>
</tr>
<?php
}
if($pgFlag == 1) {
$oOf->SearchByKey($oCIS->officerId);
$oOf->GetRecord();
?>
<tr>
<td height="22"></td>
<td colspan="7"><font size="2"><?php echo $oOf->officerCode.' '.$oOf->prefixName.$oOf->officerName.' '.$oOf->officerSurname;?></font></td>
</tr>
<?php
}
if($stFlag == 1) {
?>
<tr>
<td colspan="2" height="22"></td>
<td colspan="6"><font size="2">หลัักสูตร<?php echo $oStd1->programName;?></font></td>
</tr>
<?php
}
?>
<tr>
<td colspan="3" height="22"></td>
<td><font size="2"><?php echo $stFlag;?></font></td>
<td><font size="2"><?php echo $oStd2->studentCode;?></font></td>
<td colspan="3"><font size="2"><?php echo $oStd2->prefixName.$oStd2->studentName.' '.$oStd2->studentSurname;?></font></td>
</tr>
<?php
} // end while $oStd2
} // end while $oStd1
} // end while $oCIS
} // end while $oDA
// case 5
$oDA->SearchByAcadSemFlag($acadYear, $semester, 5);
while($oDA->GetRecord()) {
$pgFlag = 0;
$oStd1->RSStudentAssessGroupPgName();
while($oStd1->GetRecord()) {
$stFlag = 0;
$oStd2->GetNotAssessFlag5ByPgNameAndAcYAndSeAndCoIdAndDeId($oStd1->programName, $acadYear, $semester, $courseId, $oDA->defineid);
while($oStd2->GetRecord()) {
$pgFlag++;
$stFlag++;
if($pgFlag == 1) {
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
?>
<tr>
<td colspan="8" height="22"><font size="2"><?php echo $oAF->nameAss;?></font></td>
</tr>
<tr>
<td height="22"></td>
<td colspan="7"><font size="2">การประเมินการเรียนการสอนแบบภาพรวม (ทั้งวิชา)</font></td>
</tr>
<?php
}
if($stFlag == 1) {
?>
<tr>
<td colspan="2" height="22"></td>
<td colspan="6"><font size="2">หลัักสูตร<?php echo $oStd1->programName;?></font></td>
</tr>
<?php
}
?>
<tr>
<td colspan="3" height="22"></td>
<td><font size="2"><?php echo $stFlag;?></font></td>
<td><font size="2"><?php echo $oStd2->studentCode;?></font></td>
<td colspan="3"><font size="2"><?php echo $oStd2->prefixName.$oStd2->studentName.' '.$oStd2->studentSurname;?></font></td>
</tr>
<?php
} // end while $oStd2
} // end while $oStd1
} // end while $oDA
// case 6
$oDA->RSDefineAssessmentByAcYAndSeAndFlagAndCoId($acadYear, $semester, 6, $courseId);
while($oDA->GetRecord()) {
$pgFlag = 0;
$oStd1->RSStudentAssessGroupPgName();
while($oStd1->GetRecord()) {
$stFlag = 0;
$oStd2->GetNotAssessFlag6ByPgNameAndAcYAndSeAndCoIdAndDeId($oStd1->programName, $acadYear, $semester, $courseId, $oDA->defineid);
while($oStd2->GetRecord()) {
$pgFlag++;
$stFlag++;
if($pgFlag == 1) {
$oAF->SearchByKey($oDA->assid);
$oAF->GetRecord();
?>
<tr>
<td colspan="8" height="22"><font size="2"><?php echo $oAF->nameAss;?></font></td>
</tr>
<tr>
<td height="22"></td>
<td colspan="7"><font size="2">การประเมินการเรียนการสอนแบบภาพรวม (ทั้งวิชา)</font></td>
</tr>
<?php
}
if($stFlag == 1) {
?>
<tr>
<td colspan="2" height="22"></td>
<td colspan="6"><font size="2">หลัักสูตร<?php echo $oStd1->programName;?></font></td>
</tr>
<?php
}
?>
<tr>
<td colspan="3" height="22"></td>
<td><font size="2"><?php echo $stFlag;?></font></td>
<td><font size="2"><?php echo $oStd2->studentCode;?></font></td>
<td colspan="3"><font size="2"><?php echo $oStd2->prefixName.$oStd2->studentName.' '.$oStd2->studentSurname;?></font></td>
</tr>
<?php
} // end while $oStd2
} // end while $oStd1
} // end while $oDA
?>
</table>
|