|
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() ;
//header("Content-Type: text/html; charset=windows-874");
set_time_limit(0) ;
include_once("../../config/config_epm.inc.php");
include_once("../../inc/function.php");
include_once("function/function.inc.php");
function cutZero($num){
$c=strlen($num);
$numTemp=$num;
//echo $c.'<br>';
for($a=0;$a<$c;$a++){
//echo substr($numTemp,(strlen($numTemp)-1),strlen($numTemp)).'<br>';
if(substr($numTemp,(strlen($numTemp)-1),strlen($numTemp))=='0'){
$numTemp=substr($numTemp,0,(strlen($numTemp)-1));
}
}
return $numTemp;
}
if($_POST['Submit']){
$strSQL_2 = "SELECT
Count(company_taxid) AS chkCount
FROM labor_master_company
WHERE company_taxid='".$_POST['company_taxid']."'
";
$rsConn_2 = mysql_db_query($dbname,$strSQL_2);
$Result_2 = mysql_fetch_assoc($rsConn_2);
if($Result_2['chkCount'] < 1){
$a="
INSERT INTO `labor_master_company` SET
`company_name`='".$_POST['company_name']."',
`company_taxid`='".$_POST['company_taxid']."',
`company_type_id`='".$_POST['company_type_id']."',
`d_no`='".$_POST['d_no']."',
`d_soi`='".$_POST['d_soi']."',
`d_moo_id`='".$_POST['d_moo_id']."',
`tel_p`='".$_POST['tel_p']."',
`fax`='".$_POST['fax']."',
`date_add`=now(),
`user_add`='".$_SESSION['session_fullname']."',
`date_update`=now(),
`user_update`='".$_SESSION['session_fullname']."',
`d_tambol_id`='".$_POST['d_tambol_id']."',
`d_ampur_id`='".$_POST['d_ampur_id']."',
`d_province_id`='".$_POST['d_province_id']."'
";
mysql_query($a);
//exit();
/*print"<script language='JavaScript'> alert('บันทึกข้อมูลเรียบร้อยแล้ว') </script> ";
print"<meta http-equiv=\"refresh\" content=\"0;URL=?p=labor_vacancy_keyin&company_id=".$tempA."\">\n";
exit();*/
}
else{
$strSQL_u= "SELECT company_taxid
FROM labor_vacancy_register
WHERE vacancy_register_id='".$_GET['vacancy_register_id']."'
";
//echo $strSQL_1;
$rsConn_u= mysql_db_query($dbname,$strSQL_u);
$Result_u= mysql_fetch_assoc($rsConn_u);
$sql_u="
UPDATE `labor_master_company` SET
`company_name`='".$_POST['company_name']."',
`company_taxid`='".$_POST['company_taxid']."',
`company_type_id`='".$_POST['company_type_id']."',
`d_no`='".$_POST['d_no']."',
`d_soi`='".$_POST['d_soi']."',
`d_moo_id`='".$_POST['d_moo_id']."',
`tel_p`='".$_POST['tel_p']."',
`fax`='".$_POST['fax']."',
`date_update`=now(),
`user_update`='".$_SESSION['session_fullname']."',
`d_tambol_id`='".$_POST['d_tambol_id']."',
`d_ampur_id`='".$_POST['d_ampur_id']."',
`d_province_id`='".$_POST['d_province_id']."'
WHERE company_taxid='".$Result_u['company_taxid']."'
";
mysql_query($sql_u);
/*print"<script language='JavaScript'> alert('บันทึกข้อมูลเรียบร้อยแล้ว') </script> ";
print"<meta http-equiv=\"refresh\" content=\"0;URL=?p=labor_base_company\">\n";
exit();*/
}
$strSQL_company = "SELECT
labor_master_company.company_taxid
FROM labor_master_company
WHERE labor_master_company.company_taxid ='".$_POST['company_taxid']."'
";
$rsConn_company= mysql_db_query($dbname,$strSQL_company);
$Result_company= mysql_fetch_assoc($rsConn_company);
$strSQL_1 = "SELECT
Count(vacancy_register_id) AS chkCount
FROM labor_vacancy_register
WHERE vacancy_register_id='".$_GET['vacancy_register_id']."'
";
//echo $strSQL_1;
$rsConn_1 = mysql_db_query($dbname,$strSQL_1);
$Result_1 = mysql_fetch_assoc($rsConn_1);
$checkRepeat=0;
if($_GET['edit']==''){
if($Result_1['chkCount'] < 1){
$sql2="
INSERT INTO `labor_vacancy_register` SET
`company_taxid`='".$Result_company['company_taxid']."',
`date_announce`='".dateFormat($_POST['date_announce'],'thaieng_slash')."',
`date_expire`='".dateFormat($_POST['date_expire'],'thaieng_slash')."',
`prename`='".$_POST['prename']."',
`fname`='".$_POST['fname']."',
`lname`='".$_POST['lname']."',
`add_status`='KEY',
`add_date`=now(),
`add_staffid`='".$_SESSION['session_staffid']."',
`update_date`=now(),
`update_staffid`='".$_SESSION['session_staffid']."'
";
//echo $sql2;
mysql_query($sql2);
$id = mysql_insert_id();
//exit();
print"<script language='JavaScript'> alert('บันทึกข้อมูลเรียบร้อยแล้ว') </script> ";
print"<meta http-equiv=\"refresh\" content=\"0;URL=?p=labor_vacancy_keyin&vacancy_register_id=".$id."\">\n";
exit();
}else{
print"<script language='JavaScript'> alert('บันทึกข้อมูลเรียบร้อยแล้ว') </script> ";
print"<meta http-equiv=\"refresh\" content=\"0;URL=?p=labor_vacancy_index\">\n";
exit();
}
}else{
$sql2="
UPDATE `labor_vacancy_register` SET
`company_taxid`='".$Result_company['company_taxid']."',
`date_announce`='".dateFormat($_POST['date_announce'],'thaieng_slash')."',
`date_expire`='".dateFormat($_POST['date_expire'],'thaieng_slash')."',
`prename`='".$_POST['prename']."',
`fname`='".$_POST['fname']."',
`lname`='".$_POST['lname']."',
`update_date`=now(),
`update_staffid`='".$_SESSION['session_staffid']."'
WHERE vacancy_register_id='".$_GET['vacancy_register_id']."'
";
//echo $sql2;
mysql_query($sql2);
$id = mysql_insert_id();
//exit();
print"<script language='JavaScript'> alert('บันทึกข้อมูลเรียบร้อยแล้ว') </script> ";
print"<meta http-equiv=\"refresh\" content=\"0;URL=?p=labor_vacancy_index\">\n";
exit();
}
}
?>
<link href="common/style.css" rel=stylesheet>
<style type="text/css">
<!--
A:link {
FONT-SIZE: 12px;color: #000000; FONT-FAMILY: Tahoma, "Microsoft Sans Serif";TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:visited {
FONT-SIZE: 12px; COLOR: #000000; FONT-FAMILY: Tahoma, "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:active {
FONT-SIZE: 12px; COLOR: #014d5f; FONT-FAMILY: Tahoma, "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:hover {
FONT-SIZE: 12px; COLOR: #f3960b; FONT-FAMILY: Tahoma, "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
.style1 {color: #FF0000}
.style2 {font-size: 24px}
.h_menu {color:#FF9900}
-->
.bg_th{
background-image:url(images/horiz-bg.png);
background-repeat:repeat-x;
font-weight:bold;
color:#FFFFFF;
text-align:center;
}
.container .pusher{
cursor:pointer;
padding:3px 10px 3px 7px;
font-weight:900;
font-size:12px;
margin:0;
background:url(img/bgheader-2.PNG);
color:#FFFFFF;
}
.container .mover{
border:1px solid #3399CC;
padding:3px 10px 3px 7px;
margin: 0;
background-color:#E1F0FF;
}
.container {
padding:6px;
margin-top:5px;
width: auto;
font-size:11px;
}
.container2 .pusher2{
cursor:pointer;
padding:3px 10px 3px 7px;
font-weight:900;
font-size:12px;
margin:0;
background:url(img/bgheader-2.PNG);
color:#FFFFFF;
}
.container2 .mover2{
border:1px solid #3399CC;
padding:3px 10px 3px 7px;
margin: 0;
background-color:#E1F0FF;
}
.container2 {
padding:6px;
margin-top:5px;
width: auto;
font-size:11px;
}
.container3 .pusher3{
cursor:pointer;
padding:3px 10px 3px 7px;
font-weight:900;
font-size:12px;
margin:0;
background:url(img/bgheader-2.PNG);
color:#FFFFFF;
}
.container3 .mover3{
border:1px solid #3399CC;
padding:3px 10px 3px 7px;
margin: 0;
background-color:#E1F0FF;
}
.container3 {
padding:6px;
margin-top:5px;
width: auto;
font-size:11px;
}
.container4 .pusher4{
cursor:pointer;
padding:3px 10px 3px 7px;
font-weight:900;
font-size:12px;
margin:0;
background:url(img/bgheader-2.PNG);
color:#FFFFFF;
}
.container4 .mover4{
border:1px solid #3399CC;
padding:3px 10px 3px 7px;
margin: 0;
background-color:#E1F0FF;
}
.container4 {
padding:6px;
margin-top:5px;
width: auto;
font-size:11px;
}
.container5 .pusher5{
cursor:pointer;
padding:3px 10px 3px 7px;
font-weight:900;
font-size:12px;
margin:0;
background:url(img/bgheader-2.PNG);
color:#FFFFFF;
}
.container5 .mover5{
border:1px solid #3399CC;
padding:3px 10px 3px 7px;
margin: 0;
background-color:#E1F0FF;
}
.container5 {
padding:6px;
margin-top:5px;
width: auto;
font-size:11px;
}
.container6 .pusher6{
cursor:pointer;
padding:3px 10px 3px 7px;
font-weight:900;
font-size:12px;
margin:0;
background:url(img/bgheader-2.PNG);
color:#FFFFFF;
}
.container6 .mover6{
border:1px solid #3399CC;
padding:3px 10px 3px 7px;
margin: 0;
background-color:#E1F0FF;
}
.container6 {
padding:6px;
margin-top:5px;
width: auto;
font-size:11px;
}
.container7 .pusher7{
cursor:pointer;
padding:3px 10px 3px 7px;
font-weight:900;
font-size:12px;
margin:0;
background:url(img/bgheader-2.PNG);
color:#FFFFFF;
}
.container7 .mover7{
border:1px solid #3399CC;
padding:3px 10px 3px 7px;
margin: 0;
background-color:#E1F0FF;
}
.container7 {
padding:6px;
margin-top:5px;
width: auto;
font-size:11px;
}
.container8 .pusher8{
cursor:pointer;
padding:3px 10px 3px 7px;
font-weight:900;
font-size:12px;
margin:0;
background:url(img/bgheader-2.PNG);
color:#FFFFFF;
}
.container8 .mover8{
border:1px solid #3399CC;
padding:3px 10px 3px 7px;
margin: 0;
background-color:#E1F0FF;
}
.container8 {
padding:6px;
margin-top:5px;
width: auto;
font-size:11px;
}
</style>
<script type="text/javascript" charset="utf-8" src="js/jquery-1.2.3.pack.js"></script>
<script type="text/javascript">
$(document).ready(function(){
//$('.mover').hide();
//$('.mover2').hide();
//$('.mover3').hide();
//$('.mover4').hide();
//$('.mover5').hide();
//$('.mover6').hide();
//$('.mover7').hide();
//$('.mover8').hide();
$('#slideToggle').click(function(){
$(this).siblings('.mover').slideToggle();
});
$('#slideToggle2').click(function(){
$(this).siblings('.mover2').slideToggle();
});
$('#slideToggle3').click(function(){
$(this).siblings('.mover3').slideToggle();
});
$('#slideToggle4').click(function(){
$(this).siblings('.mover4').slideToggle();
});
$('#slideToggle5').click(function(){
$(this).siblings('.mover5').slideToggle();
});
$('#slideToggle6').click(function(){
$(this).siblings('.mover6').slideToggle();
});
$('#slideToggle7').click(function(){
$(this).siblings('.mover7').slideToggle();
});
$('#slideToggle8').click(function(){
$(this).siblings('.mover8').slideToggle();
});
});
</script>
<script language="JavaScript" type="text/javascript">
function CheckForm ( form ) {
if ( form.fname.value == "" ) {
alert("กรุณากรอก ชื่อ");
form.fname.focus();
return false;
}else if ( form.lname.value == "" ) {
alert("กรุณากรอก นามสกุล");
form.lname.focus();
return false;
}else if ( form.date_announce.value == "" ) {
alert("กรุณากรอก วันที่ประกาศ");
form.date_announce.focus();
return false;
}else if ( form.date_expire.value == "" ) {
alert("กรุณากรอก วันที่หมดอายุ");
form.date_expire.focus();
return false;
}else if ( form.company_taxid.value == "" ) {
alert("กรุณากรอก เลขประจำตัวผู้เสียภาษี");
form.company_taxid.focus();
return false;
}else if ( form.company_taxid.value.length != 13 ) {
alert(form.company_taxid.value.length);
alert("กรุณากรอก เลขประจำตัวผู้เสียภาษี ต้องมี 13 เท่านั้น");
form.company_taxid.focus();
return false;
}else if ( form.company_name.value == "" ) {
alert("กรุณากรอก ชื่อสถานประกอบการ");
form.company_name.focus();
return false;
}else if ( form.company_type_id.value == "" ) {
alert("กรุณากรอก ประเภทกิจการ");
form.company_type_id.focus();
return false;
}else{
return true;
}
}
</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 src="js/jquery-1.3.2.js"></script>
<script language='javascript' src='js/function.js'></script>
<script language="javascript" src="js/daily_popcalendar.js"></script>
<img src="images/unpublish_f2.png" width="30" height="30" border="0" align="absmiddle" /><strong style="color:#000033; font-size:18px;"> ใบแจ้งตำแหน่งงานว่าง </strong><br /><br />
<form id="form1" name="form1" method="POST" action="" onsubmit="return CheckForm(this)">
<?
if($_GET['edit']=='1' || $_GET['vacancy_register_id']!=''){
$strSQL_3 = "SELECT *
FROM labor_vacancy_register
WHERE vacancy_register_id='".$_GET['vacancy_register_id']."'
";
$rsConn_3 = mysql_db_query($dbname,$strSQL_3);
$Result_3 = mysql_fetch_assoc($rsConn_3);
}
?>
<table width="99%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td bgcolor="#B4B4B4">
<table width="100%" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td bgcolor="#FFFFFF">
<table width="99%" border="0" align="center" bgcolor="#FFFFFF" cellpadding="0" cellspacing="0">
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="150" align="left"><strong> ผู้แจ้ง</strong><span style="color:#FF0000">*</span></td>
<td align="left">
<select name="prename" id="prename" style="width:80px">
<?
$sqlprename = mysql_query("SELECT tbl_prename.prename_th,tbl_prename.priority,tbl_prename.id
FROM tbl_prename ORDER BY tbl_prename.priority ASC");
while( $resprename = mysql_fetch_array($sqlprename) ) {
?>
<option value="<?=$resprename['id']?>" <? if($Result_3['prename']==$resprename['id']){ echo "selected"; } ?>>
<?=$resprename['prename_th']?>
<?
//echo "<option value=\"".$ram1['ccDigi']."\" $slted>".$ram1['ccName']."</option>\n";
}
// }
?>
</select> <input name="fname" type="text" id="fname" size="25" value="<?=($_POST['fname']=='')?$Result_3['fname']:$_POST['fname']?>" />
นามสกุล
<input name="lname" type="text" id="lname" size="25" value="<?=($_POST['lname']=='')?$Result_3['lname']:$_POST['lname']?>" /></td>
</tr>
<tr>
<td align="left"><strong> วันที่ประกาศ</strong><span style="color:#FF0000">*</span></td>
<td align="left">
<input name="date_announce" type="text" id="date_announce" maxlength="10" size="15" value="<?=($_POST['date_announce']=='')?dateFormat($Result_3['date_announce'],'engthai_slash'):$_POST['date_announce']?>" onblur=" checkThaiDate(this,document.getElementById('div_txt_date_announce')); chkPermitDate(this);" onkeypress="chkDateFormat(this,event)" /><img src="js/calendar/calendar2.gif" align="top" border="0" onClick="popUpCalendar(this, document.getElementById('date_announce'), 'dd/mm/yyyy')" title="วัน เดือน ปี" style="cursor:pointer;" /><span id='div_txt_date_announce'></span>
</td>
</tr>
<tr>
<td width="150" align="left"><strong> วันที่หมดอายุ</strong><span style="color:#FF0000">*</span></td>
<td align="left">
<input name="date_expire" type="text" id="date_expire" maxlength="10" size="15" value="<?=($_POST['date_expire']=='')?dateFormat($Result_3['date_expire'],'engthai_slash'):$_POST['date_expire']?>" onblur=" checkThaiDate(this,document.getElementById('div_txt_date_expire')); chkPermitDate(this);" o onkeypress="chkDateFormat(this,event)" /><img src="js/calendar/calendar2.gif" align="top" border="0" onClick="popUpCalendar(this, document.getElementById('date_expire'), 'dd/mm/yyyy')" title="วัน เดือน ปี" style="cursor:pointer;" /><span id='div_txt_date_expire'></span>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<div class="container">
<div class="pusher" id="slideToggle">ส่วนที่ 1 ข้อมูลสถานประกอบการ <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover">
<? include("labor_vacancy_page1.php"); ?>
</div>
</div>
<div class="container2">
<div class="pusher2" id="slideToggle2">ส่วนที่ 2 รายละเอียดตำแหน่งงานว่าง <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover2">
<?
if($_GET['vacancy_register_id']){
?>
<iframe src="labor_vacancy_page2.php?vacancy_register_id=<?=$_GET['vacancy_register_id']?>" id="vacancy_p2" width="100%" frameborder="0" height="520" ></iframe>
<? }?>
<? //include("labor_vacancy_page2.php"); ?>
</div>
</div>
</td>
</tr>
<tr>
<td align="right">
<input type="submit" name="Submit" value="บันทึก" />
<input type="reset" name="Submit2" value="ยกเลิก" />
<input type="button" name="Submit3" value="ย้อนกลับ" onclick="window.location='?p=labor_vacancy_index'" />
</td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</form>
<br />