Viewing file: showDetailStudyPlan.php (7.29 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("admin_menu.php");
include_once "./class/clsProgram.php";
include_once "./class/clsStudyPlan.php";
include_once "./class/clsProgramStructure.php";
include_once "./class/clsCondition.php";
include_once "./class/clsCourse.php";
include_once "global.php";
$conn = new Connection();
$oPg = new Program();
$oSp1 = new StudyPlan();
$oSp2 = new StudyPlan();
$oSp3 = new StudyPlan();
$oPs = new ProgramStructure();
$oCd = new Condition();
$oCo = new Course();
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<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="Menu_Course.php">หน้าหลัก</a> <img src="picture/ico3.gif" align="absmiddle" border="0" /><a href="programs.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" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><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"]; ?>">โปรแกรมการศึกษา</font></legend>
<label><div align="center"><br><form name="pc" method="post" action="<?php echo $PHP_SELF;?>"><table width="600" align="center" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>หลักสูตร</b></font>
<select name="programId" onChange="location.href = 'showDetailStudyPlan.php?programId='+ encodeURI(options[selectedIndex].value)">
<?php
$oPg->SearchByKey($programId);
if($oPg->GetRecord()) {
?>
<option value="<?php echo $programId;?>"><?php echo $oPg->programName;?></option>
<?php
}
?>
<option value="0">---กรุณาเลือกหลักสูตร---</option>
<?php
$oPg->RSProgram();
while($oPg->GetRecord()) {
?>
<option value="<?php echo $oPg->programId;?>"><?php echo $oPg->programName;?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td height="22"></td>
</tr>
<?php
if($programId != 0) {
$oPg->SearchByKey($programId);
$oPg->GetRecord();
?>
<tr>
<td height="22"><font size="5" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><strong>โปรแกรมการศึกษา</strong></font></td>
</tr>
<tr>
<td height="22"><font size="3" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>หลักสูตร : </strong><?php echo $oPg->programName;?></font></td>
</tr>
<tr>
<td height="22"></td>
</tr>
<?php
}
$oSp1->RSStudyPlanByPgIdGroupStY($programId);
while($oSp1->GetRecord()) {
?>
<tr>
<td height="22" align="center"><font size="3" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><strong>ชั้นปีที่ </strong><?php echo $oSp1->studentYear;?></font></td>
</tr>
<tr>
<td><table width="600" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="<?php echo $GLOBALS['COLOR_BORDER_TABLE_1'];?>">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td width="60%" rowspan="2" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>รายวิชา</strong></font></td>
<td width="10%" rowspan="2" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>หน่วยกิต</strong></font></td>
<td width="30%" colspan="4" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>จำนวนชั่วโมง/สัปดาห์</strong></font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td width="10%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ทฤษฎี</strong></font></td>
<td width="10%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ทดลอง/ปฏิบัติ</strong></font></td>
<td width="10%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ศึกษาด้วยตนเอง</strong></font></td>
</tr>
<?php
$oSp2->RSStudyPlanByPgIdAndStYGroupSe($programId, $oSp1->studentYear);
while($oSp2->GetRecord()) {
?>
<tr>
<td height="22" colspan="5" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_2"];?>"><font size="3" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><strong>ภาคการศึกษาที่ <?php echo $oSp2->semester;?></strong></font></td>
</tr>
<?php
$sumCreditTotal = 0;
$sumPeriod1 = 0;
$sumPeriod2 = 0;
$sumPeriod3 = 0;
$oPs->RSProgramStructureByPgIdGroupCdId1($programId);
while($oPs->GetRecord()) {
$oSp3->RSStudyPlanByPgIdAndStYAndSeAndCdId($programId, $oSp1->studentYear, $oSp2->semester, $oPs->conditionId1);
if($oSp3->NumRow()) {
$oCd->SearchByKey($oPs->conditionId1);
$oCd->GetRecord();
?>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td height="22" colspan="5"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b><?php echo $oCd->condition;?></b></font></td>
</tr>
<?php
}
while($oSp3->GetRecord()) {
$oCo->SearchByKey($oSp3->courseId);
$oCo->GetRecord();
$sumCreditTotal += $oCo->creditTotal;
$sumPeriod1 += $oCo->period1;
$sumPeriod2 += $oCo->period2;
$sumPeriod3 += $oCo->period3;
?>
<tr>
<td height="22"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->courseCode.' '.$oCo->courseName;?></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->creditTotal;?></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->period1;?></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->period2;?></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oCo->period3;?></font></td>
</tr>
<?php
}
}
?>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_1'];?>">
<td height="22" align="right"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>รวมหน่วยกิต</strong></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $sumCreditTotal;?></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $sumPeriod1;?></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $sumPeriod2;?></font></td>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $sumPeriod3;?></font></td>
</tr>
<?php
}
?>
</table></td>
</tr>
<tr>
<td height="22"></td>
</tr>
<?php
}
?>
</table></form></div></label>
</fieldset><br></td>
</tr>
</table>
<?php
$oPg->Destroy();
$oCo->Destroy();
$oSp1->Destroy();
$oSp2->Destroy();
$oSp3->Destroy();
$conn->Disconnect();
?>
|