Viewing file:      v_searchAlumni.php (5.9 KB)      -rwxr-xr-x Select action/file-type:    (+) |   (+) |   (+) | Code (+) | Session (+) |   (+) | SDB (+) |   (+) |   (+) |   (+) |   (+) |   (+) |
 
<table width="100%">
     <tr>
         <td align="center"><span class="h error">ค้นหารายชื่อศิษย์เก่า</sapn></td>
     </tr>
     <tr>
         <td><br /></td>
     </tr>
 <?php
     if($this->session->flashdata('flgSave')) {
 ?>
     <tr>
         <td align="center"><?php echo $this->session->flashdata('flgSave');?></td>
     </tr>
 <?php
     }
 ?>
     <tr>
         <?php echo form_open($this->config->item("ea_folder")."search_alumni/result_search", array("name" => "myform", "id" => "myform"));?><td><table class="szone">
             <tr bgcolor="<?php echo $this->config->item('tr_c_even');?>">
                 <td class="coltd_szone"><b>รหัสนักศึกษา</b></td>
                 <td><input type="text" name="stdCode" id="stdCode" value="<?php echo set_value('stdCode');?>" size="11" maxlength="10" class="required-int" /></td>
             </tr>
             <tr bgcolor="<?php echo $this->config->item('tr_c_even');?>">
                 <td class="coltd_szone"><b>รหัสบัตรประชาชน</b></td>
                 <td><input type="text" name="citizenId" id="citizenId" value="<?php echo set_value('citizenId');?>" size="14" maxlength="13" />
                 <?php echo form_error('citizenId');?></td>
             </tr>
             <tr bgcolor="<?php echo $this->config->item('tr_c_even');?>">
                 <td class="coltd_szone"><b>ชื่อ - สกุลนักศึกษา</b></td>
                 <td><input type="text" name="name" id="name" value="<?php echo set_value('name');?>" size="20" maxlength="50" /></td>
             </tr>
             <tr bgcolor="<?php echo $this->config->item('tr_c_even');?>">
                 <td class="coltd_szone"><b>หลักสูตรที่จบ</b></td>
                 <td>
 <?php
                 echo form_dropdown('curId', $rs_curd, set_value('curId'));
 ?>
                 </td>
             </tr>
             <tr bgcolor="<?php echo $this->config->item('tr_c_even');?>">
                 <td class="coltd_szone"><b>ช่วงปีที่สำเร็จการศึกษา</b></td>
                 <td><input type="text" name="graduateY" id="graduateY" value="<?php echo set_value('graduateY');?>" size="5" maxlength="4" class="required-int" />
                 -
                 <input type="text" name="graduateY_2" id="graduateY_2" value="<?php echo set_value('graduateY_2');?>" size="5" maxlength="4" class="required-int" />
                 <?php echo (form_error('graduateY')) ? form_error('graduateY') : ((form_error('graduateY_2') ? form_error('graduateY_2') : ""));?></td>
             </tr>
 <?php
             if(isset($fault)) {
 ?>
             <tr bgcolor="<?php echo $this->config->item('tr_c_even');?>">
                 <td height="22" colspan="2" align="center"><span class="error"><?php echo $fault;?></span></td>
             </tr>
 <?php
             }
 ?>
             <tr bgcolor="<?php echo $this->config->item('tr_c_even');?>">
                 <td align="center" colspan="2">
                 <input type="submit" name="search" id="search" value="ค้นหา" />
                 </td>
             </tr>
         </table></td><?php echo form_close();?>
     </tr>
     <tr>
         <td><br /></td>
     </tr>
     <tr>
         <td align="right">รวม <?php echo (isset($rs_am)) ? $rs_am->num_rows() : 0;?> รายการ</td>
     </tr>
     <tr>
         <td><table class="headCol">
             <tr bgcolor="<?php echo $this->config->item('table_c_even');?>">
                 <th class="seqCol">ลำดับที่</th>
                 <th class="stdCodeCol">รหัสนักศึกษา</td>
                 <th>ชื่อ - สกุลนักศึกษา</th>
                 <th>หลักสูตร</th>
                 <th class="domAmtCol">ปีที่สำเร็จการศึกษา</th>
                 <th class="editCol">นำเข้า</th>
                 <th class="deleteCol">ลบ</th>
             </tr>
 <?php
     $i = 0;
     if(isset($rs_am) && $rs_am->num_rows()) {
         foreach($rs_am->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"><span class="hand" onClick="sendPost(
                 'hidform', 
                 {'alumniId':<?php echo $row_am->alumniId;?>,
                  'tab':<?php echo 1;?>},
                  '<?php echo site_url($this->config->item('ea_folder').'info_alumni/main_infoAm');?>')" /><?php echo $row_am->prefixName.$row_am->studentName.' '.$row_am->studentSurname;?></span></td>
                 <td class="indent"><?php echo $row_am->curName;?></td>
                 <td align="center"><?php echo $row_am->graduateYear;?></td>
                 <td align="center">
 <?php 
                 if($row_am->importtoalumni==1)
                     echo $this->config->item('ea_sstImport');
                 else if($row_am->importtoalumni==2)
                     echo $this->config->item('ea_sstCsv');
                 else if($row_am->importtoalumni==3)
                     echo $this->config->item('ea_sstAdd');
 ?>
                 </td>
                 <td align="center">
                     <img class="hand" src="<?php echo base_url().$this->config->item("rg_delete");?>" align="absmiddle" border="0" onClick="confirmDel2({alumniId:<?php echo $row_am->alumniId;?>}, 'm_form1','<?php echo site_url($this->config->item('ea_folder').'search_alumni/alumni_del');?>')" />
                 </td>
             </tr>
 <?php
             $i++;
         }
     } else {
 ?>
             <tr>
                 <td colspan="7" align="center"><span class="error">** ไม่ปรากฏรายการในฐานข้อมูล **</span></td>
             </tr>
 <?php
     }
 ?>
         </table></td>
     </tr>
     <tr>
         <td align="right">รวม <?php echo $i;?> รายการ</td>
     </tr>
     <tr>
         <td><table class="mark">
             <tr>
                 <td class="coltd_mark"><span class="error"><b>หมายเหตุ : </b></span></td>
                 <td><span class="error">1. I หมายถึง นำเข้าข้อมูลจากระบบทะเบียนนักศึกษา</span></td>
             </tr>
             <tr>
                 <td></td>
                 <td><span class="error">2. U หมายถึง นำเข้าข้อมูลจากการอัพโหลดไฟล์ </span></td>
             </tr>
             <tr>
                 <td></td>
                 <td><span class="error">3. A หมายถึง เพิ่มข้อมูลศิษย์เก่าเอง </span></td>
             </tr>
         </table></td>
     </tr>
 </table>
  |