Viewing file: showEnrollFee.php (8.74 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
/** Define Validate Access */
define( '_VALID_ACCESS', 1 );
/** Configuration */
include( "configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
include_once( "./link/function.php" );
/** using 'reg' DB */
/*
include("./includes/FunctionDB.php");
include("./includes/Function.php");
*/
/** Config Table for This Page */
include_once "./link/function.php";
include_once "./class/clsProgram.php";
include_once "./class/clsStudentMaster.php";
include_once "./class/clsPrefix.php";
include_once "./class/clsEnrollFee.php";
include_once "./class/clsPayment.php";
openWindow();
$conn = new Connection();
$oPg = new Program();
$oSm1 = new StudentMaster();
$oSm2 = new StudentMaster();
$oPf = new Prefix();
$oEf = new EnrollFee();
$oPm = new Payment();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title><?=$_Config_sitename;?> - ตรวจสอบรายวิชาลงทะเบียนเรียน</title>
<script type="text/javascript" src="./js/utilities.js"></script>
<link href="./css/default.css" rel="stylesheet" type="text/css" />
</head>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<?php
include( "./templates/incHeader.php" );
?>
<table width="1003" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="215" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include( "templates/incMainMenuLeft.php" );?></td>
<td width="788" height="300" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset><table width="770" border="0" cellspacing="0" cellpadding="0">
<form id="myForm" name="myForm" method="post" action="<?=$PHP_SELF;?>">
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="30" background="images/background/bg-head-topic-w780.gif"><span class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a></strong> <strong>» <a href="StudentList.php">ข้อมูลนักศึกษา</a> » <a href="ShowStudentDetail.php?studentId=<?=$studentId;?>">ประวัตินักศึกษา</a> » </strong></span><span class="NOTE"><strong>ตรวจสอบรายวิชาลงทะเบียนเรียน</strong></span></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="center" valign="top"><table width="715" align="center" cellpadding="0" cellspacing="1" border="0">
<?php
$oPg->SearchByKey($programId);
$oPg->GetRecord();
?>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td width="20%" height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>หลักสูตร</b></font></td>
<td width="80%"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><?php echo $oPg->programName;?></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 $admitAcadYear;?></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 $studentYear;?></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 $acadYear;?></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 $semester;?></font></td>
</tr>
<tr>
<td height="22" colspan="2"></td>
</tr>
<tr>
<td colspan="2"><table width="718" border="0" cellpadding="0" cellspacing="1">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td width="15%" height="22" align="center" bgcolor="#CCCCFF"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>รหัสนักศึกษา</strong></font></td>
<td width="40%" align="center" bgcolor="#CCCCFF"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>ชื่อ-นามสกุลนักศึกษา</strong></font></td>
<td width="15%" align="center" bgcolor="#CCCCFF"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>จำนวนเงิน</strong></font></td>
<td width="15%" align="center" bgcolor="#CCCCFF"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>ค้างชำระ</strong></font></td>
<td width="15%" align="center" bgcolor="#CCCCFF"><font color="<?php echo $GLOBALS["COLOR_FONT_1"];?>" size="2"><strong>ค่าปรับ</strong></font></td>
</tr>
<?php
$i = 0;
$oSm1->RSStudentMasterByPgIdAndAdY($programId, $admitAcadYear);
while($oSm1->GetRecord()) {
$oSm2->SearchByKey($oSm1->studentId);
$oSm2->GetRecord();
$oPf->SearchByKey($oSm2->prefixId);
$oPf->GetRecord();
if(($i%2) == 0)
echo "<tr>";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
?>
<tr>
<td align="center" bgcolor="#CCCCCC"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oSm2->studentCode;?></font></td>
<td bgcolor="#CCCCCC"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><a href="#" onclick='OpenWindow("showDetailEnrollFee.php?studentId=<?php echo $oSm1->studentId;?>&acadYear=<?php echo $acadYear;?>&studentYear=<?php echo $studentYear;?>&semester=<?php echo $semester;?>",700,500)'><?php echo $oPf->prefixName.$oSm2->studentName.' '.$oSm2->studentSurname;?></a></font></td>
<td align="right" bgcolor="#CCCCCC"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo number_format($oEf->GetSumTtAmtByStIdAndAcYAndStYAndSe($oSm1->studentId, $acadYear, $studentYear, $semester), 2);?></font></td>
<td align="right" bgcolor="#CCCCCC"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo number_format($oEf->GetSumBlByStIdAndAcYAndStYAndSe($oSm1->studentId, $acadYear, $studentYear, $semester), 2);?></font></td>
<td align="right" bgcolor="#CCCCCC"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo number_format($oPm->GetSumLateFineByStIdAndAcYAndStYAndSe($oSm1->studentId, $acadYear, $studentYear, $semester), 2);?></font></td>
</tr>
<?php
$i++;
}
?>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_1'];?>">
<td colspan="2" align="right"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">รวม</font></td>
<td align="right" bgcolor="#9999FF"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo number_format($oEf->GetSumTtAmtByAcYAndStYAndSeAndPgId($acadYear, $studentYear, $semester, $programId), 2);?></font></td>
<td align="right" bgcolor="#9999FF"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo number_format($oEf->GetSumBlByAcYAndStYAndSeAndPgId($acadYear, $studentYear, $semester, $programId), 2);?></font></td>
<td align="right" bgcolor="#9999FF"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo number_format($oPm->GetSumLateFineByAcYAndStYAndSeAndPgId($acadYear, $studentYear, $semester, $programId), 2);?></font></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2"><br />
<input type="button" name="back" value="ย้อนกลับ" onclick="window.history.back()" /></td>
</tr>
</table>
<br /></td>
</tr>
<tr>
<td> </td>
</tr></form>
</table>
</fieldset></td>
</tr>
</table>
<?php include( "./templates/incFooter.php" ); ?>
</body>
</html>
<?php
/** Free Resource */
$oPr->Destroy();
$oDy->Destroy();
$oCt->Destroy();
$oCo->Destroy();
$oCl->Destroy();
$oWc->Destroy();
$oEi->Destroy();
$oEr->Destroy();
$oSse->Destroy();
$oPg->Destroy();
$oPf->Destroy();
$oSm->Destroy();
$conn->Disconnect();
?>
|