Viewing file: v_rptRis106.php (6.41 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<table width="100%" align="center">
<tr>
<td><div align="center"><br>
<table class="szone">
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone">หลักสูตร</td>
<td><?php echo $curName; ?></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone">ปีการศึกษาที่รับเข้า</td>
<td><font size="2"><?php echo $adY; ?></font></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone">ชั้นปีที่</td>
<td><?php echo $studentYear; ?></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone">ปีการศึกษา</td>
<td><?php echo $acY; ?></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone">ภาคการศึกษา</td>
<td><?php echo $tmId;?></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table></div>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<table class="headCol">
<tr bgcolor="<?=$this->config->item("rg_table_color");?>">
<th class="stdCodeCol">รหัสนักศึกษา</th>
<th>ชื่อ-นามสกุลนักศึกษา</th>
<th class="amtCol">จำนวนเงิน</th>
<th class="amtCol">ค้างชำระ</th>
<th class="amtCol">ค่าปรับ</th>
<th class="editCol">pdf</th>
<th class="amtCol">ส่งออก<br />รบบใบเสร็จ</th>
</tr>
<?php
$i = 0;
foreach($rs_std->result() as $row){
echo "<tr onmouseover=\"bgColor='".$tr_color_even."'\" onmouseout=\"bgColor='".$this->config->item("rg_mouseout")."'\">";
?>
<td align="center"><?php echo $row->stdCode;?></td>
<td class="indent">
<?php
$atts = array(
'width' => '800',
'height' => '700',
'scrollbars' => 'yes',
'status' => 'yes',
'resizable' => 'yes',
'screenx' => '0',
'screeny' => '0'
);
echo anchor_popup($this->config->item("rg_folder")."rpt_regis/printRepRis106/".$row->stdId."/".$acY."/".$studentYear."/".$tmId."/".$curId, $row->prefixName.$row->stdName.' '.$row->stdSurname, $atts);
?>
</td>
<td align="right">
<?php
$regCon = array('rfStdId' => $row->stdId, 'rfAcY' => $acY, 'rfSyId' => $studentYear, 'rfTmId' =>$tmId);
echo number_format($reg->getSumTotalAmt($regCon,'','') ,2);
?>
</td>
<td align="right">
<?php
$regCon = array('rfStdId' => $row->stdId,'rfAcY' => $acY,'rfSyId' => $studentYear, 'rfTmId' => $tmId);
echo number_format($reg->getSumBalance($regCon,'','') ,2);
?>
</td>
<td align="right">
<?php
$payCon = array('rfStdId' => $row->stdId,'rfAcY' => $acY,'rfSyId' => $studentYear,'rfTmId' => $tmId,'pmLateStatus' => 'Y');
echo number_format($pay->getSumLateFine($payCon,'','') ,2);
?>
</td>
<td align="center">
<?php
$atts = array('width' => '600',
'height' => '500',
'scrollbars' => 'yes',
'status' => 'yes',
'resizable' => 'yes',
'screenx' => '0',
'screeny' => '0'
);
echo anchor_popup($this->config->item("rg_folder")."rpt_regis/printRepRis106PDF/".$row->stdId."/".$acY."/".$studentYear."/".$tmId."/".$curId, 'pdf', $atts);
?>
</td>
<td align="center">
<?php
// หาเลขที่ payment
$con_qu_reg = array('rfAcY' => $acY,
'rfStdId' => $row->stdId,
'rfSyId' => $studentYear,
'rfTmId' => $tmId);
$qu_reg = $reg->qryRfJoinPy($con_qu_reg);
$disabled = "";
if($row->stdAdY >= $this->config->item('reviseY')) {
if($qu_reg->num_rows()) {
if($qu_reg->row()->pmId==NULL) {
echo "-";
} else if($qu_reg->row()->rfBalance!=0) {
echo "-";
} else {
?>
<span class="hand" onClick="sendPost('f_toReceipt',{'pmId':<?php echo ($qu_reg->num_rows()) ? $qu_reg->row()->pmId : "0";?>,'stdId':<?php echo $row->stdId;?>,'acY':<?php echo $acY;?>,'tmId':<?php echo $tmId;?>, 'studentYear':<?php echo $studentYear;?>},'<?php echo site_url($this->config->item('rg_folder').'fee/sendToReceipt');?>')">excel</span>
<?php
}
} else {
echo "-";
}
} else {
echo "-";
$disabled = "disabled";
}
?>
</td>
</tr>
<?php
$i++;
}
?>
<tr bgcolor="<?=$this->config->item("rg_table_color2");?>">
<td colspan="2" align="right">รวม</td>
<td align="right"><font size="2">
<?php
$regCon = array('rfAcY' => $acY, 'rfSyId' => $studentYear, 'rfTmId' => $tmId , 'rfCurId' => $curId);
echo number_format($reg->getSumTotalAmt($regCon,'','') ,2);
?>
</font></td>
<td align="right"><font size="2">
<?php
$regCon = array('rfAcY' => $acY, 'rfSyId' => $studentYear, 'rfTmId' => $tmId , 'rfCurId' => $curId);
echo number_format($reg->getSumBalance($regCon,'','') ,2);
?>
</font></td>
<td align="right"><font size="2">
<?php
$payCon = array('rfAcY' => $acY,'rfSyId' => $studentYear,'rfTmId' => $tmId, 'rfCurId' => $curId,'pmLateStatus' => 'Y');
echo number_format($pay->getSumLateFine($payCon,'','') ,2);
?>
</font></td>
<td> </td>
<td> </td>
</tr>
</table>
</td>
</tr>
<tr>
<?php echo form_open($this->config->item("rg_folder")."fee/sendToReceipt", array("name" => "myform", "id" => "myform"));?><td align="center"><br />
<input type="submit" name="sendToReceipt" id="sendToReceipt" value="ส่งออกระบบใบเสร็จ" <?php echo $disabled;?> />
<input type="hidden" name="acY" id="acY" value="<?php echo $acY;?>" />
<input type="hidden" name="tmId" id="tmId" value="<?php echo $tmId;?>" />
<input type="hidden" name="curId" id="curId" value="<?php echo $curId;?>" />
<input type="hidden" name="adY" id="adY" value="<?php echo $adY;?>" />
<input type="hidden" name="studentYear" id="studentYear" value="<?php echo $studentYear;?>" />
</td><?php echo form_close();?>
</tr>
<tr>
<td>
<br><span class="error"><b>หมายเหตุ : </b>ใช้เมาส์คลิกที่ชื่อนักศึกษาเพื่อดูรายละเอียดของค่าใช้จ่าย</span></td>
</tr>
</table>
|