Viewing file: showEnrollFee_bk.php (6.76 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/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();
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<table width="740" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><br><fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="programs.php">หลักสูตรที่เปิดสอน</a> <img src="../picture/ico3.gif" align="absmiddle" border="0"> <a href="checkEnrollFee.php">ตรวจสอบค่าลงทะเบียนเรียน</a> <img src="../picture/ico3.gif" align="absmiddle" border="0"> ค่าลงทะเบียนเรียน</font></legend>
<label><div align="center"><br><form name="pc" method="post" action="printPayingEnroll.php" target="_blank"><table width="550" 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="550">
<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"]."\">";
?>
<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></form></div></label>
</fieldset><br><font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ : </b>ใช้เมาส์คลิกที่ชื่อนักศึกษาเพื่อดูรายละเอียดของค่าใช้จ่าย</font></td>
</tr>
</table>
<?php
$oPm->Destroy();
$oEf->Destroy();
$oPf->Destroy();
$oSm2->Destroy();
$oSm1->Destroy();
$oPg->Destroy();
$conn->Disconnect();
?>
|