Viewing file:  v_addProvince.php (5.03 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$rowPrv = (isset($qu_prv) && $qu_prv!=NULL) ? $qu_prv->row() : NULL;
?>
<table width="100%" align="center">
<tr>
<td>
<div align="center"><table width="100%">
<tr>
<td colspan="2" align="center" class="h error">ข้อมูลจังหวัด</td>
</tr>
<tr>
<td align="right">
<?php
echo anchor_popup($this->config->item("rg_folder")."bdppc/prv_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")."bdppc/prv_insert_update", array("name" => "myform", "id" => "myform"));?>
<table class="szone">
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone"><font size="2">ชื่อจังหวัด (ไทย)</font></td>
<td><input type="text" name="prvName" id="prvName" value="<?php echo set_value('prvName',setValue('provinceName',$rowPrv));?>" size="30" />
<font size="2" color="<?php echo $font_color_err;?>">*</font>
<br /><?php echo form_error("prvName");?></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone"><font size="2">ชื่อจังหวัด (อังกฤษ)</font></td>
<td><input type="text" name="prvNameE" id="prvNameE" value="<?php echo set_value('prvNameE',setValue('provinceNameEng',$rowPrv));?>" size="30" />
<font size="2" color="<?php echo $font_color_err;?>">*</font>
<br /><?php echo form_error("prvNameE");?></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td colspan="2" align="center">
<?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="prvId" id="prvId" value="<?php echo setValue('provinceId',$rowPrv);?>" /></td>
</tr>
</table><?php echo form_close();?></td>
</tr>
<tr>
<td align="right"><?php echo form_open($this->config->item("rg_folder")."bdppc/prv_search");?>
<font size="2"><b>ชื่อจังหวัด (ไทย)</b></font>
<input type="text" name="prvNameSearch" value="<?php echo setValue('prvNameSearch','');?>" />
<input type="submit" name="search" value="ค้นหา" />
<br /><?php echo form_error('prvNameSearch');?>
<?php echo form_close();?></td>
</tr>
<tr>
<td><table width="100%" align="center" class="headCol">
<tr>
<th class="seqCol"><font size="2" color="<?php echo $font_color_table;?>"><b>ลำดับที่</b></font></th>
<th><font size="2" color="<?php echo $font_color_table;?>"><b>ชื่อจังหวัด (ไทย)</b></font></th>
<th><font size="2" color="<?php echo $font_color_table;?>"><b>ชื่อจังหวัด (อังกฤษ)</b></font></th>
<th class="editCol"><font size="2" color="<?php echo $font_color_table;?>">แก้ไข</font></th>
<th class="deleteCol"><font size="2" color="<?php echo $font_color_table;?>">ลบ</font></th>
</tr>
<?php
$i = 0;
if(isset($rs_prv) && $rs_prv->num_rows()) {
foreach($rs_prv->result() as $row) {
echo "<tr onmouseover=\"bgColor='".$tr_color_even."'\" onmouseout=\"bgColor='".$this->config->item("rg_mouseout")."'\">";
?>
<td align="center"><font size="2"><?php echo $i+1;?></font></td>
<td class="indent"><font size="2"><?php echo $row->provinceName;?></font></td>
<td class="indent"><font size="2"><?php echo $row->provinceNameEng ;?></font></td>
<td align="center">
<span class ="hand" onClick="sendPost(
'hidform',{'prvId':<?php echo $row->provinceId;?>},'<?php echo site_url($this->config->item('rg_folder').'bdppc/prv_input');?>')"><img src="<?php echo base_url().$this->config->item("rg_edit");?>" align="absmiddle" border="0" /></span></td>
<td align="center">
<?php
$lnk = "<span class=\"hand\" onClick=\"confirmDel2({'prvId':".$row->provinceId."}, 'm_form1', '".site_url($this->config->item('rg_folder'))."/bdppc/prv_delete')\" /><img src=\"".base_url().$this->config->item("rg_delete")."\" align=\"absmiddle\" border=\"0\" width=\"16\" height=\"19\" /></span>";
echo $oCRUD->CRUD($lnk, 'D');
?>
</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
}
?>
</table></td>
</tr>
<tr>
<td align="right"><font size="2">รวม <?php echo $i;?> รายการ</font></td>
</tr>
</table></div>
</fieldset><br><font size="2" color="<?php echo $font_color_err;?>"><b>หมายเหตุ : </b>* หมายถึง ต้องกรอกข้อมูลให้สมบูรณ์</font></td>
</tr>
</table>
|