Viewing file:      v_beforeShowDbt.php (3.92 KB)      -rwxr-xr-x Select action/file-type:    (+) |   (+) |   (+) | Code (+) | Session (+) |   (+) | SDB (+) |   (+) |   (+) |   (+) |   (+) |   (+) |
 
<?php
 $row_cur = (isset($qu_cur) && $qu_cur!=NULL) ? $qu_cur->row() : NULL;
 $row_sy = (isset($qu_sy) && $qu_sy!=NULL) ? $qu_sy->row() : NULL;
 $row_tm = (isset($qu_tm) && $qu_tm!=NULL) ? $qu_tm->row() : NULL;
 ?>
 <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
     <tr>
         <td>
             <div align="center">
             <table width="100%" border="0" cellspacing="1" cellpadding="1">
                 <tr>
                     <td align="center"><span class="h error">ข้อมูลหนี้สิน</span></td>
                 </tr>
                 <tr>
                     <td><br /></td>
                 </tr>
                 <tr>
                     <td align="center"><table class="szone">
                         <tr bgcolor="<?php echo $tr_color_even;?>">
                             <td class="coltd_szone2">หลักสูตร</td>
                             <td><?php echo setValue('curName',$row_cur);?>
                             <input type="hidden" name="curId" id="curId" value="<?php echo setValue('curId',$row_cur);?>" /></td>
                         </tr>
                         <tr bgcolor="<?php echo $tr_color_even;?>">
                             <td class="coltd_szone2">ชั้นปี</td>
                             <td><?php echo setValue('syCode',$row_sy);?>
                             <input type="hidden" name="syId" id="syId" value="<?php echo setValue('syId',$row_sy);?>" /></td>
                         </tr>
                         <tr bgcolor="<?php echo $tr_color_even;?>">
                             <td class="coltd_szone2">ปีการศึกษาที่เป็นหนี้</td>
                             <td> <?php echo $acY;?></td>
                         </tr>
                         <tr bgcolor="<?php echo $tr_color_even;?>">
                             <td class="coltd_szone2">ภาคการศึกษาที่เป็นหนี้</td>
                             <td> <?php echo setValue('tmId',$row_tm);?>
                             <input type="hidden" name="tmId" id="tmId" value="<?php echo setValue('tmId',$row_tm);?>" /></td>
                         </tr>
                     </table></td>
                 </tr>
                 <tr>
                     <td align="center"><table class="headCol">
                         <tr>
                             <th class="seqCol">ลำดับที่</th>
                             <th class="stdCodeCol">รหัสนักศึกษา</th>
                             <th>ชื่อ-สกุล</th>
                             <th class="domAmtCol">จำนวนเงิน</th>
                         </tr>
 <?php
             $i = 0;
             if(isset($arr) && count($arr)) {
                 foreach($arr as $key => $val) {
                         echo "<tr onmouseover=\"bgColor='".$tr_color_even."'\" onmouseout=\"bgColor='".$this->config->item("rg_mouseout")."'\">";
                         ?>
                             <td height="22" align="center"><?php echo $i+1;?></td>
                             <td align="center"><?php echo $arr[$key]['std']->stdCode;?></td>
                             <td class="indent"><?
                             $lnk = "<span class=\"hand\" onClick=\"sendPost('hidform', {'stdId':'".$arr[$key]['std']->stdId."','AcY':'".$acY."','tmId':'".setValue('tmId',$row_tm)."'}, '".site_url($this->config->item("rg_folder")."popup/finance_popup")."',{'width':550,'height':500})\">".$arr[$key]['std']->prefixName.$arr[$key]['std']->stdName.' '.$arr[$key]['std']->stdSurname."</span>";
                             
                             echo $lnk;
                             ?>
                             </td>
                             <td align="right"><?php echo number_format($arr[$key]['dbt'],2);?></td>
                         </tr>
 <?php
                     $i++;
                 }
             } else {
 ?>
                         <tr>
                             <td align="center" colspan="4" height="22"><font size="2" color="<?php echo $font_color_err;?>">** ไม่ปรากฏรายการหนี้สินในฐานข้อมูล **</font></td>
                         </tr>
 <?php
             }
 ?>
                         <tr bgcolor="<?php echo $table_color_even;?>">
                             <td colspan="3" height="22" align="right"><font size="2"><b>รวมเงินทั้งสิ้น</b></font></td>
                             <td align="right"><font size="2"><?php echo number_format($sumAmt,2);?></font></td>
                         </tr>
 
                     </table></td>
                 </tr>
                 <tr>
                     <td align="right">รวม <?php echo $i;?> รายการ</td>
                 </tr>
             </table></div>
         <br><font size="2" color="<?php echo $font_color_err;?>"><b>หมายเหตุ : </b>นำเมาส์ไปคลิกที่ชื่อ-สกุลนักศึกษา เพื่อแสดงรายการหนี้สิน</font></td>
     </tr>
 </table>
  |