|
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(runid) AS chkCount
FROM labor_personal_experience
WHERE id_card='".$_GET['id_card']."' AND runid='".$_POST['runid']."'
";
$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_experience` SET
`id_card`='".$_GET['id_card']."',
`c_name`='".$_POST['c_name']."',
`c_type`='".$_POST['c_type']."',
`c_salary`='".$_POST['c_salary']."',
`c_province`='".$_POST['c_province']."',
`position_id`='".$_POST['position_id']."',
`c_responsibility`='".$_POST['c_responsibility']."',
`stu_working`='".$_POST['stu_working']."',
`date_stu_working`='".dateFormat($_POST['date_stu_working'],'thaieng_slash')."',
`number_time`='".$_POST['number_time']."',
`unit_id`='".$_POST['unit_id']."'
";
//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']){
mysql_query("
UPDATE `labor_personal_experience` SET
`id_card`='".$_GET['id_card']."',
`c_name`='".$_POST['c_name']."',
`c_type`='".$_POST['c_type']."',
`c_salary`='".$_POST['c_salary']."',
`c_province`='".$_POST['c_province']."',
`position_id`='".$_POST['position_id']."',
`c_responsibility`='".$_POST['c_responsibility']."',
`stu_working`='".$_POST['stu_working']."',
`date_stu_working`='".dateFormat($_POST['date_stu_working'],'thaieng_slash')."',
`number_time`='".$_POST['number_time']."',
`unit_id`='".$_POST['unit_id']."'
WHERE id_card='".$_GET['id_card']."' AND runid='".$_GET['runid']."'
");
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;
}
}
}
if($_GET['runid_del']){
mysql_query("DELETE FROM pathumthani_integration.labor_personal_experience WHERE runid='".$_GET['runid_del']."' ");
print"<meta http-equiv=\"refresh\" content=\"0;URL=?id_card=".$_GET['id_card']."\">\n";
}
?>
<link href="common/style.css" rel=stylesheet>
<script language='javascript' src='js/function.js'></script>
<script language="javascript" src="js/daily_popcalendar.js"></script>
<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_experience ";
if($_GET['runid']){
$strSQL_3 .= " WHERE runid= '".$_GET['runid']."' ";
}
$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="191" height="24" align="left" valign="top"><strong>ชื่อสถานประกอบการ</strong><span class="style1">*</span></td>
<td width="794" align="left"><input name="c_name" type="text" id="c_name" size="58" value="<?=($_POST['c_name']=='')?$Result_3['c_name']:$_POST['c_name']?>" /></td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>ประเภทกิจการ</strong><span class="style1">*</span></td>
<td align="left"><select name="c_type" id="c_type" style="width:350px">
<option value="0">เลือกประเภทกิจการ</option>
<?php
$amcom = mysql_query("SELECT
labor_master_company_type.company_type,
labor_master_company_type.company_type_id
FROM labor_master_company_type");
while( $ramcom = mysql_fetch_array($amcom) ) {
?>
<option value="<?=$ramcom['company_type_id']?>" <? if($Result_3['c_type']==$ramcom['company_type_id']){ echo "selected"; } ?>>
<?=$ramcom['company_type']?>
<?
}
?>
</option>
</select>
</td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>จังหวัด</strong></td>
<td align="left"><select name="c_province" id="c_province" style="width:150px">
<option value="">เลือกจังหวัด</option>
<?php
$am = mysql_query("SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccType='Changwat' AND ccName NOT LIKE('%*%') ORDER By ccName ");
while( $ram = mysql_fetch_array($am) ) {
?>
<option value="<?=$ram['ccDigi']?>" <? if($Result_3['c_province']==$ram['ccDigi']){ echo "selected"; } ?>>
<?=$ram['ccName']?>
<?
//echo "<option value=\"".$ram['ccDigi']."\" $slted>".$ram['ccName']."</option>\n";
}
?>
</select></td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>หมวดตำแหน่งงาน</strong><span class="style1">*</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']?>
<?
}
?>
</option>
</select></td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>ชื่อตำแหน่งงาน</strong><span class="style1">*</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"><textarea name="c_responsibility" id="c_responsibility" cols="57" rows="2"><?=($_POST['c_responsibility']=='')?$Result_3['c_responsibility']:$_POST['duty_office']?></textarea></td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>ระยะเวลา</strong></td>
<td align="left"><input name="number_time" type="text" id="number_time" size="20" value="<?=($_POST['number_time']=='')?$Result_3['number_time']:$_POST['number_time']?>" 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" valign="top"><strong>ค่าจ้างสุดท้าย</strong></td>
<td align="left"><input name="c_salary" type="text" id="c_salary" size="20" value="<?=($_POST['c_salary']=='')?$Result_3['c_salary']:$_POST['c_salary']?>" onKeyPress="return isNumber(event,this.id);" /> บาท</td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>สถานสภาพการทำงาน</strong><span class="style1">*</span></td>
<td align="left"><select name="stu_working" id="stu_working" style="width:150px" onchange="chkstatusWORK(this);">
<option value="0">เลือกสถานสภาพการทำงาน</option>
<option value="1" <?=($Result_3['stu_working']=='1')?'selected="selected"':''?>>ถูกเลิกจ้าง</option>
<option value="2" <?=($Result_3['stu_working']=='2')?'selected="selected"':''?>>ลาออก</option>
<option value="3" <?=($Result_3['stu_working']=='3')?'selected="selected"':''?>>ต้องการเปลี่ยนงาน</option>
</select>
<span id="statusWORK" <?=($Result_3['stu_working']!='3' && $_GET['edit']=='1')?'':(($_GET['edit']!='1')?'style="display:none"':'style="display:none"')?>>
ตั้งแต่วันที่ <input name="date_stu_working" type="text" id="date_stu_working" maxlength="10" size="15" value="<?=($_POST['date_stu_working']=='')?dateFormat($Result_3['date_stu_working'],'engthai_slash'):$_POST['date_stu_working']?>" onblur=" checkThaiDate(this,document.getElementById('div_txt_date_stu_working')); " onkeypress="chkDateFormat(this,event)" /><img src="js/calendar/calendar2.gif" align="top" border="0" onClick="popUpCalendar(this, document.getElementById('date_stu_working'), 'dd/mm/yyyy')" title="วัน เดือน ปี" style="cursor:pointer;" /><span id='div_txt_date_stu_working'></span>
</span>
</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='?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="5%" rowspan="2" align="center">ลำดับที่</td>
<td width="15%" rowspan="2" align="center">ชื่อสถานประกอบการ</td>
<td width="10%" rowspan="2" align="center">ประเภทกิจการ</td>
<td width="7%" rowspan="2" align="center">จังหวัด</td>
<td width="8%" rowspan="2" align="center">ตำแหน่งงาน</td>
<td width="15%" rowspan="2" align="center">ลักษณะงานที่ทำ</td>
<td width="5%" rowspan="2" align="center">ระยะเวลา</td>
<td width="5%" rowspan="2" align="center">หน่วยเวลา</td>
<td width="5%" rowspan="2" align="center">ค่าจ้างสุดท้าย</td>
<td colspan="3" align="center">สถานสภาพการทำงาน</td>
<td width="8%" rowspan="2" align="center">การจัดการ</td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="5%" align="center">ถูกเลิกจ้างตั้งแต่วันที่</td>
<td width="5%" align="center">ลาออกตั้งแต่วันที่</td>
<td width="5%" align="center">ต้องการเปลี่ยนงาน</td>
</tr>
<?
$sql_vacancy_2=" SELECT
labor_personal_experience.runid,
labor_personal_experience.id_card,
labor_personal_experience.c_name,
labor_personal_experience.c_type,
labor_personal_experience.c_salary,
labor_personal_experience.position_id,
labor_personal_experience.c_province,
labor_personal_experience.c_responsibility,
labor_personal_experience.number_time,
labor_personal_experience.unit_id,
labor_personal_experience.date_stu_working,
labor_personal_experience.stu_working
FROM labor_personal_experience
WHERE labor_personal_experience.id_card='".$_GET['id_card']."'
ORDER BY labor_personal_experience.date_stu_working DESC
";
$rs_vacancy_2=mysql_db_query($dbname,$sql_vacancy_2);
$i=0;
while($res_vacancy_2=mysql_fetch_assoc($rs_vacancy_2)){
$i++;
$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);
$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_type=" SELECT
labor_master_company_type.company_type_id,
labor_master_company_type.company_type
FROM labor_master_company_type
WHERE labor_master_company_type.company_type_id = '".$res_vacancy_2['c_type']."'
";
//echo $sql_position;
$rs_type=mysql_db_query($dbname,$sql_type);
$res_type=mysql_fetch_assoc($rs_type);
$sql_province=" SELECT
ccaa.ccDigi,
ccaa.ccName,
ccaa.ccType
FROM ccaa
WHERE ccaa.ccType = 'Changwat' AND ccaa.ccDigi ='".$res_vacancy_2['c_province']."'
";
//echo $sql_position;
$rs_province=mysql_db_query($dbname,$sql_province);
$res_province=mysql_fetch_assoc($rs_province);
?>
<tr bgcolor="#FFFFFF">
<td align="center"><?=$i?></td>
<td align="left"><?=$res_vacancy_2['c_name']?></td>
<td align="left"><?=$res_type['company_type']?></td>
<td align="left"><?=$res_province['ccName']?></td>
<td align="left"><?=$res_position['position_name']?></td>
<td align="left"><?=$res_vacancy_2['c_responsibility']?></td>
<td align="right"><?=$res_vacancy_2['number_time']?></td>
<td align="center"><?=$res_unit_id['detail']?></td>
<td align="right"><?=$res_vacancy_2['c_salary']?></td>
<td align="center"><?=($res_vacancy_2['stu_working']=='1')?dateFormat($res_vacancy_2['date_stu_working'],'thaidot'):''?></td>
<td align="center"><?=($res_vacancy_2['stu_working']=='2')?dateFormat($res_vacancy_2['date_stu_working'],'thaidot'):''?></td>
<td align="center"><?=($res_vacancy_2['stu_working']=='3')?'<img src="img/right.gif" width="16" border="0" align="absmiddle" />':''?></td>
<td align="center">
<a href="?id_card=<?=$_GET['id_card']?>&runid=<?=$res_vacancy_2['runid']?>&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['runid']?>" 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 chkstatusWORK(e){
//alert(e.value);
if(e.value=='1' || e.value=='2'){
document.getElementById('statusWORK').style.display='';
}else{
document.getElementById('statusWORK').style.display='none';
}
}
function CheckForm_1(e){
if ( e.c_name.value == "" ) {
alert("กรุณาป้อน ชื่อสถานประกอบการ");
e.c_name.focus();
return false;
}else if ( e.c_type.value == "0" ) {
alert("กรุณาเลือก ประเภทกิจการ");
e.c_type.focus();
return false;
}else if ( e.type_work.value == "0" ) {
alert("กรุณาเลือก หมวดตำแหน่งงาน");
e.type_work.focus();
return false;
}else if( e.position_id.value=='0'){
alert("กรุณาเลือก ตำแหน่งงาน");
e.position_id.focus();
return false;
}else if( e.stu_working.value=='0'){
alert("กรุณาเลือก สถานสภาพการทำงาน");
e.stu_working.focus();
return false;
}else if( e.date_stu_working.value=='' && e.stu_working.value!='3'){
alert("กรุณาป้อน วันที่");
e.date_stu_working.focus();
return false;
}else if(document.getElementById('div_txt_date_stu_working').innerHTML != ""){
alert(" ! กรุณาระบุ วันที่ ให้ถูกต้อง");
document.getElementById('div_txt_date_stu_working').focus();
return false;
}
return true;
}
function Conf(object) {
if (confirm("ยืนยันการลบข้อมูล")==true) {
return true;
}
return false;
}
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="(กรุณาเลือกหมวดตำแหน่งก่อน) ";
}
}
</script>