|
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(vacancy_id) AS chkCount
FROM labor_vacancy
WHERE vacancy_id='".$_POST['vacancy_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_vacancy` SET
`vacancy_register_id`='".$_GET['vacancy_register_id']."',
`position_id`='".$_POST['position_id']."',
`gender`='".$_POST['gender']."',
`age_from`='".$_POST['age_from']."',
`age_to`='".$_POST['age_to']."',
`position_qty`='".$_POST['position_qty']."',
`position_property`='".$_POST['position_property']."',
`welfare`='".$_POST['welfare']."',
`salary_from`='".$_POST['salary_from']."',
`salary_to`='".$_POST['salary_to']."',
`unit_id`='".$_POST['unit_id']."'
";
//echo $sql2;
mysql_query($sql2);
print"<meta http-equiv=\"refresh\" content=\"0;URL=?vacancy_register_id=".$_GET['vacancy_register_id']."\">\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['vacancy_id']==$Result_2['vacancy_id']){
mysql_query("
UPDATE `labor_vacancy` SET
`position_id`='".$_POST['position_id']."',
`gender`='".$_POST['gender']."',
`age_from`='".$_POST['age_from']."',
`age_to`='".$_POST['age_to']."',
`position_qty`='".$_POST['position_qty']."',
`position_property`='".$_POST['position_property']."',
`welfare`='".$_POST['welfare']."',
`salary_from`='".$_POST['salary_from']."',
`salary_to`='".$_POST['salary_to']."',
`unit_id`='".$_POST['unit_id']."'
WHERE vacancy_id='".$_GET['vacancy_id']."'
");
print"<meta http-equiv=\"refresh\" content=\"0;URL=?vacancy_register_id=".$_GET['vacancy_register_id']."\">\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;
}
}
}
if($_GET['runid_del']){
mysql_query("DELETE FROM pathumthani_integration.labor_vacancy WHERE vacancy_id='".$_GET['runid_del']."' ");
print"<meta http-equiv=\"refresh\" content=\"0;URL=?vacancy_register_id=".$_GET['vacancy_register_id']."\">\n";
}
?>
<body style="background-color:#E1F0FF">
<link href="common/style.css" rel=stylesheet>
<style type="text/css">
<!--
.style2 {color: #FF0000}
body{background-color:#E1F0FF}
-->
</style>
<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 src="js/jquery-1.3.2.js"></script>
<script language='javascript' src='js/function.js'></script>
<script>
function Inint_AJAX() {
try { return new ActiveXObject("Msxml2.XMLHTTP"); } catch(e) {} //IE
try { return new ActiveXObject("Microsoft.XMLHTTP"); } catch(e) {} //IE
try { return new XMLHttpRequest(); } catch(e) {} //Native Javascript
alert("XMLHttpRequest not supported");
return null;
}
function CHKposition(e,name,tag) {
//alert(e.value);
if(e.value!=0){
var req = Inint_AJAX();
var sec = document.getElementById(e.id).options[document.getElementById(e.id).options.selectedIndex].value;
//alert(sec);
req.onreadystatechange = function () {
if (req.readyState==4) {
if (req.status==200) {
//alert(req.responseText);
document.getElementById(tag).innerHTML=req.responseText; //รับค่ากลับมา
}
}
};
req.open("GET", "ajax_jobless_chkPosition.php?varChk="+sec+"&name="+name); //สร้าง connection
req.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;charset=tis-620"); // set Header
req.send(null); //ส่งค่า
}else{
document.getElementById('POSITIONtemp').innerHTML="(กรุณาเลือกหมวดตำแหน่งก่อน) ";
}
}
function CheckForm_1(form){
if ( form.type_work.value == 0 ) {
alert("กรุณาเลือก หมวดตำแหน่งงาน");
form.type_work.focus();
return false;
}else if ( form.position_id.value == 0 ) {
alert("กรุณาเลือก ชื่อตำแหน่ง");
form.position_id.focus();
return false;
}else{
return true;
}
}
function Conf(object) {
if (confirm("ยืนยันการลบข้อมูล")==true) {
return true;
}
return false;
}
</script>
<form id="formp2" name="formp2" method="POST" action="" onsubmit="return CheckForm_1(this)">
<?
/*echo $_GET['vacancy_register_id'];
echo '<br>';
echo $_GET['vacancy_id'];*/
if($_GET['edit']!=''){
$strSQL_3 = "SELECT * FROM labor_vacancy ";
if($_GET['vacancy_id'] != ''){
$strSQL_3 .= " WHERE vacancy_id= '".$_GET['vacancy_id']."' AND vacancy_register_id= '".$_GET['vacancy_register_id']."' ";
}
$rsConn_3 = mysql_db_query($dbname,$strSQL_3);
$Result_3 = mysql_fetch_assoc($rsConn_3);
}
?>
<?
if($Result_3['position_id']!=''){
$sql_position_temp=" SELECT
labor_master_position.position_type_id,
labor_master_position.parent_id,
labor_master_position.position_name
FROM labor_master_position
WHERE labor_master_position.position_type_id = '".$Result_3['position_id']."'
";
//echo $sql_position_temp.'<br>';
$rs_position_temp=mysql_db_query($dbname,$sql_position_temp);
$res_position_temp=mysql_fetch_assoc($rs_position_temp);
$sql_position_temp1=" SELECT
labor_master_position.position_name,
labor_master_position.position_id,
labor_master_position.position_type_id
FROM labor_master_position
WHERE labor_master_position.position_id = '".$res_position_temp['parent_id']."'
";
//echo $sql_position_temp1;
$rs_position_temp1=mysql_db_query($dbname,$sql_position_temp1);
$res_position_temp1=mysql_fetch_assoc($rs_position_temp1);
}
?>
<table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td width="160" height="24" align="left" valign="top"><strong>หมวดตำแหน่งงาน</strong><span style="color:#FF0000" >*</span></td>
<td align="left">
<select name="type_work" id="type_work" style="width:213px" onchange="CHKposition(this,'position_id','POSITIONtemp');">
<option value="0">เลือกหมวดตำแหน่งงาน</option>
<?
$sqltype_work = mysql_query("SELECT
labor_master_position.position_id,
labor_master_position.position_type_id,
labor_master_position.parent_id,
labor_master_position.position_name
FROM labor_master_position
WHERE labor_master_position.parent_id = '0'
");
while( $restype_work = mysql_fetch_array($sqltype_work) ) {
?>
<option value="<?=$restype_work['position_id']?>" <? if($res_position_temp1['position_id']==$restype_work['position_id']){ echo "selected"; } ?>><?=$restype_work['position_name']?>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>ชื่อตำแหน่ง</strong><span style="color:#FF0000" >*</span></td>
<td align="left">
<span id="POSITIONtemp">
<?
if($type_work!='' || $_GET['edit']!=''){
?>
<select name="position_id" id="position_id" style="width:213px">
<option value="0">เลือกชื่อตำแหน่ง</option>
<?
$sqltype_work = mysql_query("SELECT
labor_master_position.position_id,
labor_master_position.position_type_id,
labor_master_position.parent_id,
labor_master_position.position_name
FROM labor_master_position
WHERE labor_master_position.parent_id != '0'
");
while( $restype_work = mysql_fetch_array($sqltype_work) ) {
?>
<option value="<?=$restype_work['position_type_id']?>" <? if($Result_3['position_id']==$restype_work['position_type_id']){ echo "selected"; } ?>><?=$restype_work['position_name']?>
<?
}
?>
</select>
<?
}else{
echo '(กรุณาเลือกหมวดตำแหน่งก่อน)';
}
?>
</span></td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>เพศ</strong></td>
<td align="left">
<input type="radio" name="gender" id="gender" value="1" <?=($_GET['edit'])?(($Result_3['gender']=='1')?'checked="checked"':''):'checked="checked"'?> /> ชาย
<input type="radio" name="gender" id="gender" value="2" <?=($Result_3['gender']=='2')?'checked="checked"':''?> /> หญิง
</td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>อายุ</strong></td>
<td align="left">
ตั้งแต่ <input name="age_from" type="text" id="age_from" size="10" value="<?=($_POST['age_from']=='')?$Result_3['age_from']:$_POST['age_from']?>" onkeypress="return isNumber(event,this.id);" />
ถึง <input name="age_to" type="text" id="age_to" size="10" value="<?=($_POST['age_to']=='')?$Result_3['age_to']:$_POST['age_to']?>" onkeypress="return isNumber(event,this.id);" /> ปี
</td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>จำนวน</strong></td>
<td align="left"><input name="position_qty" type="text" id="position_qty" size="15" value="<?=($_POST['position_qty']=='')?$Result_3['position_qty']:$_POST['position_qty']?>" onkeypress="return isNumber(event,this.id);" /> อัตรา</td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>คุณวุฒิ</strong></td>
<td align="left"><textarea name="position_property" id="position_property" cols="57" rows="3"><?=($_POST['position_property']=='')?$Result_3['position_property']:$_POST['position_property']?>
</textarea></td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>เงื่อนไขและสวัสดิการ</strong></td>
<td align="left"><textarea name="welfare" id="welfare" cols="57" rows="3"><?=($_POST['welfare']=='')?$Result_3['welfare']:$_POST['welfare']?>
</textarea></td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>ค่าจ้าง</strong></td>
<td align="left">
ตั้งแต่ <input name="salary_from" type="text" id="salary_from" size="10" value="<?=($_POST['salary_from']=='')?$Result_3['salary_from']:$_POST['salary_from']?>" onKeyPress="return isNumber(event,this.id);" />
ถึง <input name="salary_to" type="text" id="salary_to" size="10" value="<?=($_POST['salary_to']=='')?$Result_3['salary_to']:$_POST['salary_to']?>" onKeyPress="return isNumber(event,this.id);" /> บาท
ต่อ
<select name="unit_id" id="unit_id" style="width:100px">
<option value="0">เลือกหน่วยเวลา</option>
<?
$sqlunit_id= mysql_query("SELECT
labor_master_unit.unit_id,
labor_master_unit.detail
FROM labor_master_unit
");
while( $resunit_id= mysql_fetch_array($sqlunit_id) ) {
?>
<option value="<?=$resunit_id['unit_id']?>" <? if($Result_3['unit_id']==$resunit_id['unit_id']){ echo "selected"; } ?>>
<?=$resunit_id['detail']?>
<?
}
?>
</option>
</select></td>
</tr>
<tr>
<td height="24" align="left"> </td>
<td align="left"></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='?vacancy_register_id=<?=$_GET['vacancy_register_id']?>'" /></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="25" rowspan="2" align="center">ลำดับที่</td>
<td width="70" rowspan="2" align="center">ชื่อตำแหน่ง</td>
<td width="60" rowspan="2" align="center">เพศ</td>
<td colspan="2" align="center">อายุ (ปี)</td>
<td width="60" rowspan="2" align="center">จำนวน</td>
<td width="70" rowspan="2" align="center">คุณวุฒิ</td>
<td width="70" rowspan="2" align="center">เงื่อนไขและสวัสดิการ</td>
<td colspan="2" align="center">อัตราจ้างที่ต้องการ (บาท)</td>
<td width="40" rowspan="2" align="center">หน่วยเวลาของอัตราจ้าง</td>
<td width="40" rowspan="2" align="center">การจัดการ</td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="60" align="center">ตั้งแต่</td>
<td width="60" align="center">ถึง</td>
<td width="40" align="center">ตั้งแต่ </td>
<td width="40" align="center">ถึง </td>
</tr>
<?
$sql_vacancy_2=" SELECT
labor_vacancy.vacancy_id,
labor_vacancy.vacancy_register_id,
labor_vacancy.position_id,
labor_vacancy.gender,
labor_vacancy.age_from,
labor_vacancy.age_to,
labor_vacancy.position_qty,
labor_vacancy.position_property,
labor_vacancy.welfare,
labor_vacancy.salary_from,
labor_vacancy.salary_to,
labor_vacancy.unit_id
FROM labor_vacancy
WHERE labor_vacancy.vacancy_register_id='".$_GET['vacancy_register_id']."'
";
$rs_vacancy_2=mysql_db_query($dbname,$sql_vacancy_2);
$i=0;
while($res_vacancy_2=mysql_fetch_assoc($rs_vacancy_2)){
$i++;
$sql_position=" SELECT
labor_master_position.position_type_id,
labor_master_position.position_name
FROM labor_master_position
WHERE labor_master_position.position_type_id = '".$res_vacancy_2['position_id']."'
";
//echo $sql_position;
$rs_position=mysql_db_query($dbname,$sql_position);
$res_position=mysql_fetch_assoc($rs_position);
$sql_unit_id=" SELECT
labor_master_unit.unit_id,
labor_master_unit.detail
FROM labor_master_unit
WHERE labor_master_unit.unit_id = '".$res_vacancy_2['unit_id']."'
";
$rs_unit_id=mysql_db_query($dbname,$sql_unit_id);
$res_unit_id=mysql_fetch_assoc($rs_unit_id);
$gender='';
if($res_vacancy_2['gender']=='1'){
$gender='ชาย';
}else if($res_vacancy_2['gender']=='2'){
$gender='หญิง';
}
?>
<tr bgcolor="#FFFFFF">
<td align="center"><?=$i?></td>
<td align="left"><?=$res_position['position_name']?></td>
<td align="center"><?=$gender?></td>
<td align="right"><?=$res_vacancy_2['age_from']?></td>
<td align="right"><?=$res_vacancy_2['age_to']?></td>
<td align="right"><?=$res_vacancy_2['position_qty']?></td>
<td align="left"><?=$res_vacancy_2['position_property']?></td>
<td align="left"><?=$res_vacancy_2['welfare']?></td>
<td align="right"><?=$res_vacancy_2['salary_from']?></td>
<td align="right"><?=$res_vacancy_2['salary_to']?></td>
<td align="left"><?=$res_unit_id['detail']?></td>
<td align="center">
<a href="?vacancy_register_id=<?=$_GET['vacancy_register_id']?>&vacancy_id=<?=$res_vacancy_2['vacancy_id']?>&edit=1"><img src="../../images/dash_icon/ico_edit.png" alt="แก้ไขข้อมูล" title="แก้ไขข้อมูล" width="16" height="16" border="0" align="middle" /></a>
<a href="?vacancy_register_id=<?=$_GET['vacancy_register_id']?>&runid_del=<?=$res_vacancy_2['vacancy_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>
</body>