Viewing file:  v_addGeneration.php (6.87 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$row_gen = (isset($qu_gen) && $qu_gen!=NULL) ? $qu_gen->row() : NULL;
$row_cur = (isset($qu_cur) && $qu_cur!=NULL) ? $qu_cur->row() : NULL;
$row_tm = (isset($qu_tm) && $qu_tm!=NULL) ? $qu_tm->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")."bdcollege/gen_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")."bdcollege/gen_insert_update", array("name" => "myform", "id" => "myform"));?>
<table class="szone">
<?php
if($dsb==0) {
?>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone"><font size="2">ชื่อหลักสูตร</font></td>
<?php
?>
<td>
<?php
echo form_dropdown("genCurId", $rs_cur, setValue('genCurId',$row_gen), FALSE);
?>
<span class="error">*<?php echo form_error("genCurId");?></span></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone"><font size="2">ปีการศึกษา (พ.ศ.)</font></td>
<td><input type="text" name="genAcY" id="genAcY" value="<?php echo setValue('genAcY',$row_gen);?>" size="4" maxlength="4" <?php echo $dsb;?> />
<span class="error">*<?php echo form_error('genAcY');?></span></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone"><font size="2">ภาคการศึกษา</font></td>
<td>
<?php
echo form_dropdown("tmId", $rs_tm, ($row_gen==NULL ? set_value('tmId',$tmId) : setValue('genTmId',$row_gen)));
?>
<span class="error">*<?php echo form_error("tmId");?></span></td>
</tr>
<?php
} else {
?>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone"><font size="2">ชื่อหลักสูตร</font></td>
<?php
?>
<td><?php echo setValue('curName',$row_cur);?>
<input type="hidden" name="genCurId" id="genCurId" value="<?php echo setValue('curId',$row_cur);?>" /></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone"><font size="2">ปีการศึกษา (พ.ศ.)</font></td>
<td><?php echo setValue('genAcY',$row_gen);?>
<input type="hidden" name="genAcY" id="genAcY" value="<?php echo setValue('genAcY',$row_gen);?>" /></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone"><font size="2">ภาคการศึกษา</font></td>
<td><?php echo setValue('tmCode',$row_tm);?>
<input type="hidden" name="tmId" id="tmId" value="<?php echo setValue('tmId',$row_tm);?>" /></td>
</tr>
<?php
}
?>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td class="coltd_szone"><font size="2">รุ่นที่</font></td>
<td><input type="text" name="genNo" id="genNo" value="<?php echo setValue('genNo',$row_gen);?>" size="3" maxlength="3" <?php echo $dsb;?> />
<span class="error">*<?php echo form_error('genNo');?></span></td>
</tr>
<tr bgcolor="<?php echo $tr_color_even;?>">
<td colspan="2" align="center">
<?php
$lnk = "<input type=\"submit\" id=\"add\" name=\"add\" value=\"บันทึก\" />";
echo $oCRUD->CRUD($lnk, 'C');
?>
<input type="reset" name="clear" value="เคลียร์ข้อมูล" />
<input type="hidden" name="genId" id="genId" value="<?php echo setValue('genId',$row_gen);?>" /></td>
</tr>
</table><?php echo form_close();?></td>
</tr>
<tr>
<td><br/></td>
</tr>
<?php
if(isset($rs_gen) && $rs_gen->num_rows() > $this->config->item("rg_max_row")) {
?>
<tr>
<td colspan="3"><div class="boxBlock leftBox"><font size="2">
แสดง <?php echo $rs_gen->num_rows();?> รายการจาก <?php echo $this->config->item("rg_max_row");?> รายการ</font>
</div></td>
<tr>
<?php
}
?>
<tr>
<td><table class="headCol">
<tr>
<th class="seqCol">ลำดับที่</span></th>
<th>ชื่อหลักสูตร</span></th>
<th>ปีการศึกษา</span></th>
<th>ภาคการศึกษา</span></th>
<th>รุ่นที่</span></th>
<th class="editCol">แก้ไข</span></th>
<th class="deleteCol">ลบ</span></th>
</tr>
<?php
$i = 0;
if(isset($rs_gen) && $rs_gen->num_rows()) {
foreach($rs_gen->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->curName;?></font></td>
<td class="indent"><font size="2"><?php echo $row->genAcY;?></font></td>
<td class="indent"><font size="2"><?php echo $row->genTmId;?></font></td>
<td class="indent"><font size="2"><?php echo $row->genNo;?></font></td>
<td align="center">
<?php
if($row->curStatus=='Y') {
$edit = "<span class=\"hand\" onClick=\"sendPost('hidform', {'genId':".$row->genId."}, 'gen_input')\"><img src=\"".base_url().$this->config->item('rg_edit')."\" align=\"absmiddle\" border=\"0\" /></span>";
} else {
$edit = "<img src=\"".base_url().$this->config->item('rg_noedit')."\" align=\"absmiddle\" border=\"0\" />";
}
echo $oCRUD->CRUD($edit, 'U');
?>
</td>
<td align="center">
<?php
$lnk = "<span class=\"hand\" onClick=\"confirmDel2({'genId':".$row->genId."}, 'm_form1', 'gen_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="7" 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>
<font size="2" color="<?php echo $font_color_err;?>"><b>หมายเหตุ : </b>* หมายถึง ต้องกรอกข้อมูลให้สมบูรณ์</font></td>
</tr>
</table>
|