|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /home/pathumthani_integration/integration/application/labor/ |
Upload File : |
<?
session_start();
include_once("../../config/config_epm.inc.php");
include_once("function/function.inc.php");
if($_POST['Submit']){
//$letter_date = Save_date($_POST['letter_date']);
$strSQL_2 = "SELECT
Count(id_card) AS chkCount
FROM labor_personal_language
WHERE id_card='".$_GET['id_card']."' AND t_language_id='".$_POST['t_language_id']."'
";
$rsConn_2 = mysql_db_query($dbname,$strSQL_2);
$Result_2 = mysql_fetch_assoc($rsConn_2);
$checkRepeat=0;
if($_GET['edit']==''){
if($Result_2['chkCount'] < 1){
$sql2="
INSERT INTO `labor_personal_language` SET
`id_card`='".$_GET['id_card']."',
`t_language_id`='".$_POST['t_language_id']."',
`level_speak`='".$_POST['level_speak']."',
`level_read`='".$_POST['level_read']."',
`level_write`='".$_POST['level_write']."',
`type_rate`='".$_POST['type_rate']."'
";
//echo $sql2;
mysql_query($sql2);
print"<meta http-equiv=\"refresh\" content=\"0;URL=?id_card=".$_GET['id_card']."\">\n";
exit();
/*print"<script language='JavaScript'> alert('บันทึกข้อมูลเรียบร้อยแล้ว') </script> ";
print"<meta http-equiv=\"refresh\" content=\"0;URL=?p=labor_base_unit\">\n";
exit();*/
}
else{
$checkRepeat = 1;
}
}
else{
//echo $Result_2['type_id'];
//if($Result_2['chkCount'] < 1 || ($_GET['id_card']==$Result_2['id_card'] && $_GET['t_language_id']==$Result_2['t_language_id'])){
$sql6="
UPDATE `labor_personal_language` SET
`id_card`='".$_GET['id_card']."',
`level_speak`='".$_POST['level_speak']."',
`level_read`='".$_POST['level_read']."',
`level_write`='".$_POST['level_write']."',
`type_rate`='".$_POST['type_rate']."'
WHERE id_card='".$_GET['id_card']."' AND t_language_id='".$_GET['t_language_id']."'
";
mysql_query($sql6);
print"<meta http-equiv=\"refresh\" content=\"0;URL=?id_card=".$_GET['id_card']."\">\n";
exit();
/*print"<script language='JavaScript'> alert('บันทึกข้อมูลเรียบร้อยแล้ว') </script> ";
print"<meta http-equiv=\"refresh\" content=\"0;URL=?p=labor_base_unit\">\n";
exit();*/
}
}
if($_GET['runid_del']){
mysql_query("DELETE FROM pathumthani_integration.labor_personal_language WHERE id_card='".$_GET['runid_del']."' AND t_language_id='".$_GET['language_del']."' ");
print"<meta http-equiv=\"refresh\" content=\"0;URL=?id_card=".$_GET['id_card']."\">\n";
}
?>
<link href="common/style.css" rel=stylesheet>
<link rel="stylesheet" type="text/css" href="js/style_tootip_isnumber.css" />
<script type="text/javascript" language="javascript" src="js/tootip_isnumber.js"></script>
<script type="text/javascript" src="js/jquery-1.3.2.js"></script>
<style type="text/css">
<!--
.style2 {color: #FF0000}
.style1 {color: #FF0000}
body{background-color:E1F0FF}
-->
</style>
<form id="formp2" name="formp2" method="POST" action="" onsubmit="return CheckForm_1(this)">
<?
if($_GET['edit']!=''){
$strSQL_3 = "SELECT * FROM labor_personal_language ";
if($_GET['id_card']){
$strSQL_3 .= " WHERE id_card= '".$_GET['id_card']."' ";
}
if($_GET['t_language_id']){
$strSQL_3 .= " AND t_language_id= '".$_GET['t_language_id']."' ";
}
$rsConn_3 = mysql_db_query($dbname,$strSQL_3);
$Result_3 = mysql_fetch_assoc($rsConn_3);
}
?>
<table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td width="208" height="24" align="left" valign="top"><strong>ความสามารถทางด้านภาษา</strong></td>
<td width="777" align="left">ภาษา <span class="style1">*</span>
<select name="t_language_id" id="t_language_id" style="width:100px">
<option value="0">เลือกภาษา</option>
<?
$sqllanguage= mysql_query("SELECT
labor_master_language.language_id,
labor_master_language.language_name
FROM labor_master_language
");
while( $reslanguage= mysql_fetch_array($sqllanguage) ) {
?>
<option value="<?=$reslanguage['language_id']?>" <? if($Result_3['t_language_id']==$reslanguage['language_id']){ echo "selected"; } ?>><?=$reslanguage['language_name']?>
<?
}
?>
</select>
พูด <select name="level_speak" id="level_speak" style="width:100px">
<option value="0">เลือกภาษา</option>
<option value="ดีมาก" <? if($Result_3['level_speak']=='ดีมาก'){ echo "selected"; } ?>>ดีมาก
<option value="ดี" <? if($Result_3['level_speak']=='ดี'){ echo "selected"; } ?>>ดี
<option value="พอใช้" <? if($Result_3['level_speak']=='พอใช้'){ echo "selected"; } ?>>พอใช้
</select>
อ่าน <select name="level_read" id="level_read" style="width:100px">
<option value="0">เลือกภาษา</option>
<option value="ดีมาก" <? if($Result_3['level_read']=='ดีมาก'){ echo "selected"; } ?>>ดีมาก
<option value="ดี" <? if($Result_3['level_read']=='ดี'){ echo "selected"; } ?>>ดี
<option value="พอใช้" <? if($Result_3['level_read']=='พอใช้'){ echo "selected"; } ?>>พอใช้
</select>
เขียน <select name="level_write" id="level_write" style="width:100px">
<option value="0">เลือกภาษา</option>
<option value="ดีมาก" <? if($Result_3['level_write']=='ดีมาก'){ echo "selected"; } ?>>ดีมาก
<option value="ดี" <? if($Result_3['level_write']=='ดี'){ echo "selected"; } ?>>ดี
<option value="พอใช้" <? if($Result_3['level_write']=='พอใช้'){ echo "selected"; } ?>>พอใช้
</select>
</td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>ความเร็วในการพิมพ์</strong></td>
<td align="left"><input name="type_rate" type="text" id="type_rate" size="9" maxlength="3" value="<?=($_POST['type_rate']=='')?$Result_3['type_rate']:$_POST['type_rate']?>" onKeyPress="return isNumber(event,this.id);" /> คำ/นาที </td>
</tr>
<tr>
<td height="24" align="left"> </td>
<td align="left"><input type="submit" name="Submit" value="บันทึก" />
<input type="button" name="Submit2" value="ยกเลิก" onclick="window.location='?id_card=<?=$_GET['id_card']?>'" /></td>
</tr>
<tr>
<td height="24" align="left"> </td>
<td align="left"></td>
</tr>
<tr>
<td height="24" colspan="2" align="left">
<table id="table_person" width="99%" align="center" border="0" cellspacing="1" cellpadding="3" bgcolor="#999999">
<tr bgcolor="#CCCCCC">
<td width="8%" align="center">ลำดับที่</td>
<td width="20%" align="center">ภาษา</td>
<td width="10%" align="center">พูด</td>
<td width="10%" align="center">อ่าน</td>
<td width="10%" align="center">เขียน</td>
<td width="10%" align="center">ความเร็วในการพิมพ์</td>
<td width="10%" align="center">การจัดการ</td>
</tr>
<?
$sql_vacancy_2=" SELECT
labor_personal_language.id_card,
labor_personal_language.t_language_id,
labor_personal_language.level_speak,
labor_personal_language.level_read,
labor_personal_language.level_write,
labor_personal_language.type_rate
FROM labor_personal_language
WHERE labor_personal_language.id_card='".$_GET['id_card']."'
";
$rs_vacancy_2=mysql_db_query($dbname,$sql_vacancy_2);
$i=0;
while($res_vacancy_2=mysql_fetch_assoc($rs_vacancy_2)){
$i++;
$sql_language=" SELECT
labor_master_language.language_id,
labor_master_language.language_name
FROM labor_master_language
WHERE labor_master_language.language_id = '".$res_vacancy_2['t_language_id']."'
";
//echo $sql_position;
$rs_language=mysql_db_query($dbname,$sql_language);
$res_language=mysql_fetch_assoc($rs_language);
?>
<tr bgcolor="#FFFFFF">
<td align="center"><?=$i?></td>
<td align="left"><?=$res_language['language_name']?></td>
<td align="center"><?=$res_vacancy_2['level_speak']?></td>
<td align="center"><?=$res_vacancy_2['level_read']?></td>
<td align="center"><?=$res_vacancy_2['level_write']?></td>
<td align="right"><?=$res_vacancy_2['type_rate']?></td>
<td align="center">
<a href="?id_card=<?=$_GET['id_card']?>&t_language_id=<?=$res_vacancy_2['t_language_id']?>&edit=1"><img src="../../images/dash_icon/ico_edit.png" alt="แก้ไขข้อมูล" title="แก้ไขข้อมูล" width="16" height="16" border="0" align="middle" /></a>
<a href="?id_card=<?=$_GET['id_card']?>&runid_del=<?=$res_vacancy_2['id_card']?>&language_del=<?=$res_vacancy_2['t_language_id']?>" onClick="return Conf(this)"><img src="../../images/dash_icon/ico_del.png" alt="ลบข้อมูล" title="ลบข้อมูล" width="16" height="16" border="0" align="middle" onmouseover="this.style.cursor='hand';"/></a>
</td>
</tr>
<? }?>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</form>
<script>
function CheckForm_1(e){
if ( e.t_language_id.value == "0" ) {
alert("กรุณาเลือก ภาษา");
e.t_language_id.focus();
return false;
}
return true;
}
function Conf(object) {
if (confirm("ยืนยันการลบข้อมูล")==true) {
return true;
}
return false;
}
</script>