Viewing file: v_countStdBySst.php (3.06 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
// create : by sitthichai
// date : 2014-12-02
?>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><fieldset>
<legend align="center"><span class="h" style="color:<?php echo $font_color_err;?>">รายงานจำนวนนักศึกษาปัจจุบัน จำแนกตามสถานะนักศึกษา</span></legend>
<div align="center"><br><table class="szone">
<tr>
<td colspan="2">
<table class="tb_1">
<tr>
<th rowspan="2"><span>สถานะนักศึกษา</span></td>
<th colspan="4"><span>ชั้นปีที่</span></td>
</tr>
<tr>
<th ><span>1</span></td>
<th ><span>2</span></td>
<th ><span>3</span></td>
<th ><span>4</span></td>
</tr>
<?php $sumSy1 = 0;
$sumSy2 = 0;
$sumSy3 = 0;
$sumSy4 = 0;
foreach ($rs->result() as $row) {
echo "<tr onmouseover=\"bgColor='".$tr_color_even."'\" onmouseout=\"bgColor='".$this->config->item("rg_mouseout")."'\">";
$sumSy1 += $row->numSy1;
$sumSy2 += $row->numSy2;
$sumSy3 += $row->numSy3;
$sumSy4 += $row->numSy4;
?>
<td align="center"><span><?php echo $row->sstName;?></span></td>
<td align="center">
<span class="hand" onClick="sendPost('stdSstId',{sstId:'<?php echo $row->sstId;?>', syId:'1'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySst_2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->numSy1;?></font></span>
</td>
<td align="center">
<span class="hand" onClick="sendPost('stdSstId',{sstId:'<?php echo $row->sstId;?>', syId:'2'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySst_2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->numSy2;?></font></span>
</td>
<td align="center">
<span class="hand" onClick="sendPost('stdSstId',{sstId:'<?php echo $row->sstId;?>', syId:'3'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySst_2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->numSy3;?></font></span>
</td>
<td align="center">
<span class="hand" onClick="sendPost('stdSstId',{sstId:'<?php echo $row->sstId;?>', syId:'4'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySst_2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->numSy4;?></font></span>
</td>
</tr>
<?php } ?>
<tr bgcolor="<?php echo $this->config->item('rg_table_end');?>">
<td align="center"><b>รวม</b></td>
<td align="center"><b><?php echo $sumSy1; ?></b></td>
<td align="center"><b><?php echo $sumSy2; ?></b></td>
<td align="center"><b><?php echo $sumSy3; ?></b></td>
<td align="center"><b><?php echo $sumSy4; ?></b></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
|