Viewing file:      v_soTable.php (3.28 KB)      -rwxr-xr-x Select action/file-type:    (+) |   (+) |   (+) | Code (+) | Session (+) |   (+) | SDB (+) |   (+) |   (+) |   (+) |   (+) |   (+) |
 
<script language="JavaScript">
 function ReturnValue(soId,soName,prvName)
 {
     window.opener.document.myform.elements["stdSoId"].value = soId;
     window.opener.document.myform.elements["soName"].value = soName;
     window.opener.document.myform.elements["prvNameSo"].value = prvName;
     window.close();
 }
 </script>
 <table width="100%" border="0" cellspacing="1" cellpadding="1">
     <tr>
         <td><?php echo form_open($this->config->item("rg_folder")."popup/so_popup_search");?>
         <table class="szone">
             <tr bgcolor="<?php echo $tr_color_even;?>">
                 <td align="center" class="coltd_szone"><font size="2">เจ้าของทุน</font>
                 <input type="text" name="soNameSearch" id="soNameSearch" value="<?php echo set_value('soNameSearch');?>" size="20" />
                 <input type="submit" name="search" id="search" value="ค้นหา" />
                 <font color="error"><?php echo form_error('soNameSearch');?></font></td>
         </table><?php echo form_close();?></td>
     </tr>
 <?php
 if(isset($rs_so) && $rs_so->num_rows() > $this->config->item("rg_max_row")) {
 ?>
     <tr>
         <td colspan="3"><div class="boxBlock leftBox"><font size="2"><b>
         แสดง <?php echo $this->config->item("rg_max_row");?> รายการจาก <?php echo isset($rs_so) ? $rs_so->num_rows() : '';?> รายการ</b></font>
         </div></td>
     <tr>
 <?php
 }
 ?>
     <tr>
         <td><table class="headCol">
             <tr bgcolor="<?php echo $this->config->item("rg_table_color");?>"> 
                 <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>
             </tr>
 <?php
 $i = 0;
 if(isset($rs_so) && $rs_so->num_rows()) {
     foreach ($rs_so->result() as $row) {
         if($i >= $this->config->item("rg_max_row"))
             break;
         if(($i%2) == 0)
             echo "<tr onmouseover=\"bgColor='".$tr_color_even."'\" onmouseout=\"bgColor='".$this->config->item("rg_mouseout")."'\">";
         if($row->soPrvId == "")
             $row->prvName = 'ไม่ระบุจังหวัด';
 ?>
                 <td align="center" onClick="ReturnValue(<?php echo $row->soId;?>, '<?php echo $row->soName;?>', '<?php echo $row->provinceName;?>')"><font size="2"><span class="hand"><?php echo $i+1;?></span></font></td>
                 <td class="indent" onClick="ReturnValue(<?php echo $row->soId;?>, '<?php echo $row->soName;?>','<?php echo $row->provinceName;?>')"><font size="2"><span class="hand"><?php echo $row->soName;?></span></font></td>
                 <td class="indent" onClick="ReturnValue(<?php echo $row->soId;?>, '<?php echo $row->soName;?>','<?php echo $row->provinceName;?>')"><font size="2"><span class="hand"><?php echo ($row->provinceName==NULL) ? '-' : $row->provinceName;?></span></font></td>
             </tr>
 <?php
         $i++;
     }
 } else {
 ?>
             <tr>
                 <td colspan="3" align="center" bgcolor="#FFFFFF"><font size="2" color="<?php echo $font_color_err;?>">** ไม่ปรากฏรายการดังกล่าวในฐานข้อมูล **</font></td>
             </tr>
 <?php
 }
 ?>
         </table></td>
     </tr>
     <tr>
         <td colspan="3" align="right"><font size="2">รวม <?php echo $i;?> รายการ</font></td>
     </tr>
 </table>
  |