Viewing file: showGDSt1.php (4.99 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once "admin_menu.php";
include_once "template.php";
include_once "./link/function.php";
include_once "./class/clsProgram.php";
include_once "./class/clsAcadYearConfig.php";
include_once "./class/clsStudentMaster.php";
include_once "./class/clsPrefix.php";
include_once "./class/clsSysStudentStatusDes.php";
include_once "./class/clsAcad.php";
$conn = new Connection();
$oPg = new Program();
$oAy = new AcadYearConfig();
$oAc = new Acad();
$oSm = new StudentMaster();
$oPf = new Prefix();
$oSs = new SysStudentStatusDes();
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<table width="750" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><br><fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="showGD.php">ผู้สำเร็จการศึกษา</a> <img src="picture/ico3.gif" align="absmiddle" border="0"> รายชื่อผู้สำเร็จการศึกษา</font></legend>
<label><div align="center"><br><form name="pc" method="post" action="showGD.php"><table width="600" align="center" border="0" cellpadding="0" cellspacing="1">
<?php
$oPg->SearchByKey($programId);
$oPg->GetRecord();
?>
<tr>
<td width="15%"><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'];?>"><?php echo $oPg->programName;?></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'];?>"><?php echo $graduateYear;?></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'];?>"><?php echo $semester;?></font></td>
</tr>
<tr>
<td height="22" colspan="2"></td>
</tr>
<tr>
<td colspan="2"><table width="600">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td width="7%" height="22" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1'];?>"><b>ลำดับที่</b></font></td>
<td width="13%" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1'];?>"><b>รหัสประจำตัว</b></font></td>
<td width="35%" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1'];?>"><b>ชื่อ-นามสกุล</b></font></td>
<td width="15%" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1'];?>"><b>เกียรตินิยม</b></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1'];?>"><b>วันจบการศึกษา</b></font></td>
<td width="13%" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_1'];?>"><b>สถานะ</b></font></td>
</tr>
<?php
$oAy->SearchByKey($graduateYear, $semester);
$oAy->GetRecord();
$oAc->RSAcad();
$oAc->GetRecord();
$i = 0;
$oSm->RSStudentMasterByPgIdAndFinishDateAndGdY($oPg->programId, $oAy->firstDate, $oAy->lastDate, $graduateYear);
while($oSm->GetRecord()) {
$oPf->SearchByKey($oSm->prefixId);
$oPf->GetRecord();
$oSs->SearchByKey($oSm->studentStatus);
$oSs->GetRecord();
$str = "honor$oSm->honor";
//eval($str);
if(($i%2) == 0)
echo '<tr>';
else
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<td height="22" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $i+1;?></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $oSm->studentCode;?></font></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $oPf->prefixName.$oSm->studentName.' '.$oSm->studentSurname;?></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $oAc->$str;?></font></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo fullDate(splitDateDb($oSm->finishDate));?></font></td>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $oSs->description;?></font></td>
</tr>
<?php
$i++;
}
if($i == 0) {
?>
<tr>
<td colspan="6" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3'];?>">** ไม่ปรากฏรายชื่อผู้สำเร็จการศึกษา **</font></td>
</tr>
<?php
}
?>
<tr>
<td colspan="6" align="right"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">รวม <?php echo $oSm->NumRow();?> รายการ</font></td>
</tr>
</table></td>
</tr>
</table></form></div></label>
</fieldset><br></td>
</tr>
</table>
<?php
$oSs->Destroy();
$oPf->Destroy();
$oSm->Destroy();
$oAc->Destroy();
$oAy->Destroy();
$oPg->Destroy();
$conn->Disconnect();
?>
|