Viewing file:  v_searchAlumniForQn.php (4.77 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><br>
<div align="center">
<table width="100%" border="0" cellspacing="1" cellpadding="1" bordercolor="<?php echo $table_color_even;?>" align="center">
<tr>
<td align="center" class="h">ค้นหารายชื่อศิษย์เก่าที่ต้องการบันทึกข้อมูล</td>
</tr>
<tr>
<td><br /></td>
</tr>
<tr>
<td colspan="5" align="center">
<?php echo form_open($this->config->item("ea_folder")."query/qn_search", array("name" => "searchform", "id" => "searchform"));?>
<table class="easzone">
<tr bgcolor="<?php echo $tr_color_even;?>">
<td align="center">
<font size="2"><b>รหัสนักศึกษา</b></font>
<input type="text" name="studentCode" id="studentCode" value="<?php echo set_value('studentCode');?>" size="20" onKeyDown="document.myform.stdCode.onkeydown=check_number" />
<font size="2"><b>ชื่อ - สกุล</b></font>
<input type="text" name="studentName" id="studentName" value="<?php echo set_value('studentName');?>" size="20" />
<font size="2"><b>ชื่อหลักสูตร</b></font>
<input type="text" name="curName" id="curName" value="<?php echo set_value('curName');?>" size="20" />
<font size="2"><b>ปีที่จบการศึกษา</b></font>
<input type="text" name="admitAcadYear" id="admitAcadYear" value="<?php echo set_value('admitAcadYear');?>" size="20" />
<br /><font color="<?php echo $this->config->item('rg_font_color_err');?>"><?php echo isset($err_msg) ? $err_msg : '';?></font>
</td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td align="center" colspan="2">
<input type="submit" name="search" value="ค้นหา" />
<input type="reset" name="clear" value="ลบข้อมูล" />
</td>
</tr>
</table><?php echo form_close();?><br />
</td>
</tr>
<tr>
<?php
if(isset($rs_am) && $rs_am->num_rows() > $this->config->item("ea_max_row")) {
?>
<td><div class="boxBlock leftBox"><font size="2"><b>
แสดง <?php echo $this->config->item("ea_max_row");?> รายการจาก <?php echo isset($rs_am) ? $rs_am->num_rows() : '';?> รายการ</b></font></div></td>
<?php
}
?>
</tr>
<tr>
<td>
<table class="eaheadCol" width="100%">
<tr bgcolor="<?php echo $this->config->item("rg_table_color");?>">
<td colspan="4" align="center"><font size="2" color="<?php echo $font_color_table;?>"><b>รายชื่อศิษย์เก่า</b></font></td>
</tr>
<tr bgcolor="<?php echo $table_color_even ;?>">
<th class="seqCol"><font size="2" color="<?php echo $font_color_table;?>"><b>ลำดับ</b></font></th>
<th class="indent"><font color="<?php echo $font_color_table;?>" size="2"><b>ชื่อ-นามสกุล</b></font></th>
<th class="indent"><font color="<?php echo $font_color_table;?>" size="2"><b>หลักสูตร</b></font></th>
<th><font color="<?php echo $font_color_table;?>" size="2"><b>ปีที่จบการศึกษา</b></font></th>
</tr>
<?php
$i = 0;
if(isset($rs_am) && $rs_am->num_rows()) {
foreach($rs_am->result() as $row_am) {
if($i >= $this->config->item("ea_max_row"))
break;
echo "<tr onmouseover=\"bgColor='".$tr_color_even."'\" onmouseout=\"bgColor='".$this->config->item("rg_mouseout")."'\">";
?>
<td height="22" align="center"><font size="2"><?php echo $i+1;?></font></td>
<td height="22" align="left"><font size="2">
<span class="hand" onClick="sendPost(
'myform',
{'alumniId':<?php echo $row_am->alumniId;?>},'<?php echo site_url($this->config->item('ea_folder').'query/qn_detail/');?>')" /><?php echo
$row_am->prefixName." ".$row_am->studentName." ".$row_am->studentSurname;?></span></font></td>
<td height="22" align="left"><font size="2"><? echo $row_am->curName;?></font></td>
<td height="22" align="center"><font size="2"><? echo $row_am->admitAcadYear;?></font></td>
</tr>
<?php
$i++;
}
} else {
?>
<tr>
<td colspan="5" height="22" align="center"><font size="2" color="<?php echo $font_color_err;?>">** ไม่ปรากฏรายการในฐานข้อมูล **</font></td>
</tr>
<?php
}
?>
<tr>
<td align="right" colspan="5"><font size="2">รวม <?php echo $i;?> รายการ</font></td>
</tr>
</table>
</td>
</tr>
</table><?php echo form_close();?></div>
</td>
</tr>
</table>
|