Viewing file:  v_countStdBySyTm.php (6.88 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 rowspan="2"><span>แรกเข้า</span></td>
<th colspan="3"><span>ชั้นปีที่ 1</span></td>
<th colspan="3"><span>ชั้นปีที่ 2</span></td>
<th colspan="3"><span>ชั้นปีที่ 3</span></td>
<th colspan="3"><span>ชั้นปีที่ 4</span></td>
<th rowspan="2"><span>สำเร็จการศึกษา</span></td>
</tr>
<tr>
<th ><span>1</span></td>
<th ><span>2</span></td>
<th ><span>3</span></td>
<th ><span>1</span></td>
<th ><span>2</span></td>
<th ><span>3</span></td>
<th ><span>1</span></td>
<th ><span>2</span></td>
<th ><span>3</span></td>
<th ><span>1</span></td>
<th ><span>2</span></td>
<th ><span>3</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->ssmAcY;?></span></td>
<td align="center" bgColor='<?php echo $tr_color_even;?>' ><span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'1', tmId:'1'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdByAdY');?>', {width:500,height:500})" /><font size="2"><?php echo $row->numAdY;?></font></span>
</td>
<td align="center">
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'1', tmId:'1'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy1Tm1;?></font></span>
</td>
<td align="center">
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'1', tmId:'2'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy1Tm2;?></font></span>
</td>
<td align="center">
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'1', tmId:'3'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy1Tm3;?></font></span>
</td>
<td align="center" bgColor='<?php echo $tr_color_even;?>' >
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'2', tmId:'1'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy2Tm1;?></font></span>
</td>
<td align="center" bgColor='<?php echo $tr_color_even;?>' >
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'2', tmId:'2'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy2Tm2;?></font></span>
</td>
<td align="center" bgColor='<?php echo $tr_color_even;?>' >
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'2', tmId:'3'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy2Tm3;?></font></span>
</td>
<td align="center">
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'3', tmId:'1'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy3Tm1;?></font></span>
</td>
<td align="center">
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'3', tmId:'2'},
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy3Tm2;?></font></span>
</td>
<td align="center">
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'3', tmId:'3'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy3Tm3;?></font></span>
</td>
<td align="center" bgColor='<?php echo $tr_color_even;?>' >
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'4', tmId:'1'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy4Tm1;?></font></span>
</td>
<td align="center" bgColor='<?php echo $tr_color_even;?>' >
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'4', tmId:'2'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy4Tm2;?></font></span>
</td>
<td align="center" bgColor='<?php echo $tr_color_even;?>' >
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'4', tmId:'3'} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdBySyTm2');?>', {width:500,height:500})" /><font size="2"><?php echo $row->Sy4Tm3;?></font></span>
</td>
<td align="center" >
<span class="hand" onClick="sendPost('stdSstId',{year:'<?php echo $row->ssmAcY;?>', syId:'', tmId:''} ,
'<?php echo site_url($this->config->item('rg_folder').'popup/countStdByGdu');?>', {width:500,height:500})" /><font size="2"><?php echo $row->gduY;?></font></span>
</td>
</tr>
<?php } ?>
</table>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
|