Viewing file:  v_addPrefix_11.php (5.52 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$rowPf = (isset($qu_pf) && $qu_pf!=NULL) ? $qu_pf->row() : NULL;
?>
<table width="95%" align="center">
<tr>
<td><br><fieldset>
<div align="center"><br><table width="100%" border="0">
<tr>
<td align="center"><font size="3" color="<?php echo $font_color_err;?>"><b>ข้อมูลคำนำหน้าชื่อ</b></font></td>
</tr>
<tr>
<td align="right">
<?php
echo anchor_popup($this->config->item("rg_folder")."basedata/pf_print", "<img src=\"".base_url().$this->config->item("rg_print")."\" width=\"15\" height=\"14\" align=\"absmiddle\" border=\"0\" />");
?>
</td>
</tr>
<tr>
<td><?php echo form_open($this->config->item("rg_folder")."basedata/pf_insert_update");?><table width="60%" align="center">
<tr>
<td width="40%"><font size="2"><b>คำนำหน้าชื่อ (ไทย)</b></font></td>
<td width="60%"><input type="text" name="pfName" id="pfName" value="<?php echo (set_value('pfName')=="") ? $pfName : set_value('pfName');?>" size="20" />
<font size="2" color="<?php echo $font_color_err;?>">*</font></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td><font size="2"><b>คำนำหน้าชื่อ (อังกฤษ)</b></font></td>
<td><input type="text" name="pfNameE" id="pfNameE" value="<?php echo (set_value('pfNameE')=="") ? $pfNameE : set_value('pfNameE');?>" size="20" />
<font size="2" color="<?php echo $font_color_err;?>">*</font></td>
</tr>
<tr>
<td><font size="2"><b>เพศ</b></font></td>
<td><select name="pfGender" >
<option value="" >ไม่ระบุ</option>
<option value="m" <?php echo ($pfGender == 'm') ? "selected=\"selected\"" : $this->validation->set_select('pfGender','m');?>>ชาย</option>
<option value="f" <?php echo ($pfGender == 'f') ? "selected=\"selected\"" : $this->validation->set_select('pfGender','f');?>>หญิง</option>
</select>
<font size="2" color="<?php echo $font_color_err;?>">*</font>
<?php echo form_error("pfGender");?></td>
</tr>
<tr>
<td colspan="2" align="center"><br>
<?php
$lnk = "<input type=\"submit\" name=\"add\" value=\"บันทึก\" />";
echo $lnk;
//echo $oU->CRUD($lnk, 'C');
?>
<input type="reset" name="clear" value="เคลียร์ข้อมูล">
<input type="hidden" name="pfId" id="pfId" value="<?php echo (set_value('pfId')=="") ? $pfId : set_value('pfId');?>" /></td>
</tr>
</table><?php echo form_close();?><br><br></td>
</tr>
<tr>
<td align="right"><?php echo form_open($this->config->item("rg_folder")."basedata/pf_search");?>
<font size="2"><b>คำนำหน้าชื่อ (ไทย)</b></font>
<input type="text" name="pfNameSearch" />
<input type="submit" name="search" value="ค้นหา" />
<?php echo form_close();?></td>
</tr>
<tr>
<td><table width="100%" border="0">
<tr bgcolor="<?php echo $this->config->item("rg_table_color");?>">
<td width="10%" height="22" align="center"><font size="2" color="<?php echo $font_color_table;?>"><b>ลำดับที่</b></font></td>
<td width="35%" align="center"><font color="<?php echo $font_color_table;?>" size="2"><b>คำนำหน้าชื่อ (ไทย)</b></font></td>
<td width="35%" align="center"><font size="2" color="<?php echo $font_color_table;?>"><b>คำนำหน้าชื่อ (อังกฤษ)</b></font></td>
<td width="10%" align="center"><font color="<?php echo $font_color_table;?>" size="2"><b>แก้ไข</b></font></td>
<td width="10%" align="center"><font color="<?php echo $font_color_table;?>" size="2"><b>ลบ</b></font></td>
</tr>
<?php
if($rs_pf->num_rows()) {
$i = 0;
foreach($rs_pf->result() as $row) {
if(($i%2) == 0)
echo "<tr>";
else
echo "<tr bgcolor=\"".$tr_color_even."\">";
?>
<td align="center"><font size="2"><?php echo $i+1;?></font></td>
<td><font size="2"><?php echo $row->pfName;?></font></td>
<td><font size="2"><?php echo $row->pfNameE;?></font></td>
<td align="center">
<?php
$lnk = anchor($this->config->item("rg_folder")."basedata/pf_input/$row->pfId", "<img src=\"".base_url().$this->config->item("rg_edit")."\" width=\"23\" height=\"19\" align=\"absmiddle\" border=\"0\" />");
echo $lnk;
//echo $oU->CRUD($lnk, 'U');
?>
</td>
<td align="center">
<?php
$lnk = anchor($this->config->item("rg_folder")."basedata/pf_delete/$row->pfId", "<img src=\"".base_url().$this->config->item("rg_delete")."\" width=\"16\" height=\"19\" align=\"absmiddle\" border=\"0\" onClick=\"return confirmDelete()\" />");
echo $lnk;
//echo $oU->CRUD($lnk, 'D');
?>
</td>
</tr>
<?php
$i++;
}
}
else {
?>
<tr>
<td colspan="4" height="22" align="center"><font size="2" color="<?php echo $font_color_err;?>">** ไม่ปรากฏรายการในฐานข้อมูล **</font></td>
</tr>
<?php
}
?>
</table></td>
</tr>
<tr>
<td align="right"><font size="2">รวม <?php echo $rs_pf->num_rows();?> รายการ</font></td>
</tr>
</table></div>
</fieldset><br><font size="2" color="<?php echo $font_color_err;?>"><b>หมายเหตุ : </b>* หมายถึง ต้องกรอกข้อมูลให้สมบูรณ์</font></td>
</tr>
</table>
|