Viewing file:  v_report004ForExcel.php (2.59 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//header('Content-type: application/xls');
//header('Content-Disposition: attachment; filename="alumni_workStatus.xls"');
$row_cfg = (isset($qu_cfg) && $qu_cfg!=NULL) ? $qu_cfg->row() : NULL;
$row_pa = (isset($qu_pa) && $qu_pa!=NULL) ? $qu_pa->row() : NULL;
?>
<table width="100%">
<tr>
<td><img src="<?php echo base_url().$this->config->item('ea_cfglogo');?>" width="111" height="95" align="absmiddle" border="0"></td>
<td><font size="3"><b><?php echo setValue('cfgName',$row_cfg)."<br />".$this->config->item('ea_system');?></b></font></td>
<td align="right" valign="top"><font size="3"><b><?php echo $noRpt;?></b></font></td>
</tr>
<tr valign="top">
<td align="center" colspan="3"><hr color="#000000" noshade><br></td>
</tr>
<tr>
<td colspan="3" align="center"><font size="3"><b><?php echo $headRpt;?></b></font></td>
</tr>
<tr>
<td colspan="3" align="center"><font size="3"><b>หลักสูตร </b><?php echo setValue('programalumniName',$row_pa)=="" ? "-" : setValue('programalumniName',$row_pa);?> <b>ปีการศึกษาที่จบ </b><?php echo ($graduateY==0) ? "-" : $graduateY;?></font></td>
</tr>
<tr>
<td colspan="3"><br /></td>
</tr>
<tr>
<td colspan="3"><table class="excelCol" border="1">
<tr>
<th class="seqCol">ลำดับที่</th>
<th class="stdCodeCol">รหัสนักศึกษา</th>
<th>ชื่อ - สกุลศิษย์เก่า</th>
<th>เพศ</th>
</tr>
<?php
$i = 0;
if(isset($rs) && $rs->num_rows()) {
foreach($rs->result() as $row_am) {
echo "<tr onmouseover=\"bgColor='".$this->config->item('tr_c_even')."'\" onmouseout=\"bgColor='".$this->config->item("rg_mouseout")."'\">";
?>
<td align="center"><?php echo $i+1;?></td>
<td align="center"><?php echo $row_am->studentCode;?></td>
<td class="indent"><?php echo $row_am->prefixName.$row_am->studentName.' '.$row_am->studentSurname;?></td>
<td align="center"><?php echo ($row_am->defaultSex=="M") ? "ชาย" : "หญิง";?></td>
</tr>
<?php
$i++;
}
} else {
?>
<tr>
<td colspan="4" align="center">** ไม่ปรากฏรายการในฐานข้อมูล **</td>
</tr>
<?php
}
?>
</table></td>
</tr>
<tr valign="bottom">
<td align="center" colspan="3" height="88"><hr color="#000000" noshade></td>
</tr>
<tr valign="top">
<td colspan="2"><font size="2">วันที่พิมพ์ : <?php echo date('d-m-y h:m');?></font></td>
<td align="right"><font size="2">หน้า 1/1</font></td>
</tr>
</table>
|