Viewing file: showGD.php (4.6 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once "admin_menu.php";
include_once "global.php";
include_once "./link/function.php";
include_once "./class/clsStudentMaster.php";
include_once "./class/clsProgram.php";
include_once "./class/clsSysSemesterDes.php";
include_once "./class/clsAcadYearConfig.php";
$conn = new Connection();
$oSm = new StudentMaster();
$oPg = new Program();
$oSse = new SysSemesterDes();
$oAy = new AcadYearConfig();
?>
<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="showBirth.php">วันเกิดของคุณ</a> <img src="picture/ico3.gif" align="absmiddle" border="0" /><a href="course.php">รายวิชาที่เปิดสอน</a> <img src="picture/ico3.gif" align="absmiddle" border="0" /><a href="showSchedule.php">ปฏิทินการศึกษา</a> <img src="picture/ico3.gif" align="absmiddle" border="0" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="showDetailStudyPlan.php">โปรแกรมการศึกษา</a> </font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"> <img src="picture/ico3.gif" align="absmiddle" border="0" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="programs.php">หลักสูตรที่เปิดสอน</a></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><img src="picture/ico3.gif" align="absmiddle" border="0" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>">ผู้สำเร็จการศึกษา</font></legend>
<label><div align="center"><br><form name="pc" method="post" action="showGDSt.php"><table width="600" align="center" border="0" cellpadding="0" cellspacing="1">
<tr>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>ปีการศึกษาที่จบ</b></font>
<select name="graduateYear" onChange="location.href = 'showGD.php?graduateYear='+ encodeURI(options[selectedIndex].value)">
<?php
if(!$graduateYear)
$graduateYear = $GLOBALS["ACADYEAR"];
?>
<option value="<?php echo $graduateYear;?>"><?php echo $graduateYear;?></option>
<?php
$oSm->RSStudentMasterGroupGdY();
while($oSm->GetRecord()) {
if($oSm->graduateYear > 0) {
?>
<option value="<?php echo $oSm->graduateYear;?>"><?php echo $oSm->graduateYear;?></option>
<?php
}
}
?>
</select></td>
</tr>
<tr>
<td height="22"></td>
</tr>
<tr>
<td><table width="600" cellpadding="0" cellspacing="1">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td width="70%" height="22" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>ภาคการศึกษา</strong></font></td>
<?php
$oSse->RSSysSemesterDes();
while($oSse->GetRecord()) {
?>
<td width="10%" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong><?php echo $oSse->semester;?></strong></font></td>
<?php
}
?>
</tr>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_1"];?>">
<td height="22" colspan="4"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ชื่อหลักสูตร</strong></font></td>
</tr>
<?php
$i = 0;
$oPg->RSProgram();
while($oPg->GetRecord()) {
if(($i%2) == 0)
echo '<tr>';
else
echo '<tr bgcolor="'.$GLOBALS["COLOR_BG_TD_4"].'">';
?>
<td height="22"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oPg->programName;?></font></td>
<?php
for($j=1; $j<=$oSse->NumRow(); $j++) {
$sumSt = '-';
$oAy->SearchByKey($graduateYear, $j);
if($oAy->GetRecord()) {
$oSm->RSStudentMasterByPgIdAndFinishDateAndGdY($oPg->programId, $oAy->firstDate, $oAy->lastDate, $graduateYear);
if($oSm->GetRecord())
$sumSt = $oSm->NumRow();
}
?>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><a href="showGDSt.php?programId=<?php echo $oPg->programId;?>&graduateYear=<?php echo $graduateYear;?>&semester=<?php echo $j;?>"><?php echo $sumSt;?></a></font></td>
<?php
}
?>
</tr>
<?php
$i++;
} // end while
?>
</table></td>
</tr>
</table></form></div></label>
</fieldset><br><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><b>หมายเหตุ : </b>ใช้เมาส์คลิกที่ตัวเลขบอกจำนวนผู้สำเร็จการศึกษาเพื่อดูรายชื่อผู้สำเร็จการศึกษา</font></td>
</tr>
</table>
<?php
$oAy->Destroy();
$oSse->Destroy();
$oPg->Destroy();
$oSm->Destroy();
$conn->Disconnect();
?>
|