|
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");
include_once("../../inc/function.php");
//exit;
### REQUEST_METHOD = "POST"
$cur_date = date("Y-m-d");
$cur_datetime = date("Y-m-d H:i:s");
$cur_year = date("Y");
$cur_year_thai = $cur_year+543;
$cur_month = date("m");
$cur_day = date("d");
$staffid = $_SESSION["session_staffid"];
if($_SERVER['REQUEST_METHOD'] == 'POST') # กดปุ่ม บันทึก(SAVE)
{
if($_POST['submit'] = "บันทึกข้อมูล")
{
### สภาพภาพแรงงาน - - - ###
$sqldel = "DELETE FROM labor_personal_status WHERE id_card='".$id_card."'";
mysql_query($sqldel) or die('can not del labor_personal_status');
if(is_array($status_id))
{
foreach($status_id as $key => $val)
{
$status_detail = '';
if($val == 10)
{
$status_detail = $_POST['status_detail'];
}
$sqlcmd = " INSERT INTO labor_personal_status
SET id_card='".$_POST['id_card']."',
status_id='".$val."',
status_detail='".$status_detail."'
";
//echo $sqlcmd."<br>";
mysql_query($sqlcmd) or die('can not query labor_personal_status');
}
}
//exit;
### - - - - - - - - - - - - - - - - - - - - - - - - ###
### สภาพร่างกาย กรณีเลือก พิการ ให้เก็บว่าพิการประเภทไหนบ้าง - - - ###
$sqldel = "DELETE FROM labor_personal_deformed WHERE id_card='".$id_card."'";
mysql_query($sqldel) or die('can not del labor_personal_deformed');
if(is_array($deformed_id))
{
foreach($deformed_id as $key => $val)
{
$sqlcmd = " INSERT INTO labor_personal_deformed
SET id_card='".$_POST['id_card']."',
deformed_id='".$val."',
deformed_detail='".$_POST['deformed_detail']."'
";
//echo $sqlcmd."<br>";
mysql_query($sqlcmd) or die('can not query labor_personal_deformed');
}
}
//exit;
### - - - - - - - - - - - - - - - - - - - - - - - - ###
### เหตุผลที่สมัครเข้าฝึกอบรมฝีมือแรงงาน - - - ###
$sqldel = "DELETE FROM labor_reason_practice WHERE id_card='".$id_card."'";
mysql_query($sqldel) or die('can not del labor_reason_practice');
if(is_array($reason_practice_id))
{
foreach($reason_practice_id as $key => $val)
{
$sqlcmd = " INSERT INTO labor_reason_practice
SET id_card='".$_POST['id_card']."',
reason_practice_id='".$val."'
";
//echo $sqlcmd."<br>";
mysql_query($sqlcmd) or die('can not query labor_reason_practice');
}
}
//exit;
### - - - - - - - - - - - - - - - - - - - - - - - - ###
### แหล่งที่ทราบข่าว - - - ###
$sqldel = "DELETE FROM labor_personal_news WHERE id_card='".$id_card."' AND application_type='P'";
mysql_query($sqldel) or die('can not del labor_reason_practice');
if(is_array($news_source_id))
{
foreach($news_source_id as $key => $val)
{
$sqlcmd = " INSERT INTO labor_personal_news
SET id_card='".$_POST['id_card']."',
news_source_id='".$val."',
application_type='P'
";
// echo $sqlcmd."<br>";
// exit;
mysql_query($sqlcmd) or die('can not query labor_personal_news');
}
}
//exit;
### - - - - - - - - - - - - - - - - - - - - - - - - ###
### การศึกษาสูงสุด - - - ###
//$sqldel = "DELETE FROM labor_personal_news WHERE id_card='".$id_card."' AND application_type_id=1";
//mysql_query($sqldel) or die('can not query');
//echo "<hr>";
$schoolid = $_POST[school_id];
if(trim($_POST[school_id]) == "")
{
$schoolid = 0;
}
if($_POST[id_card] != "" && $_POST[education_id] != "")
{
$sqlcmd = " id_card='".$_POST[id_card]."',
education_id='".$_POST[education_id]."',
school_id='".$schoolid."',
school_outsite='".$_POST[school_outsite]."',
sch_outsite_province_id='".$_POST[shc_province_id]."',
branch='".$_POST[branch]."',
graudated_year='".$_POST[graudated_year]."'
";
### check exist education
$sqlexist = "SELECT COUNT(*) AS rowcount FROM labor_personal_education WHERE id_card='".$_POST[id_card]."' AND education_id='".$_POST[education_id]."'";
$exist = mysql_query($sqlexist) or die('can not query labor_personal_education');
$rsexist = mysql_fetch_assoc($exist);
###
if($rsexist[rowcount] > 0)
{
$sqlcmd = "UPDATE labor_personal_education SET ".$sqlcmd;
$sqlcmd .= " WHERE id_card='".$_POST[id_card]."' AND education_id='".$_POST[education_id]."'";
//$sqlcmd = "";
}
else
{
$sqlcmd = "INSERT INTO labor_personal_education SET ".$sqlcmd;
}
mysql_query($sqlcmd) or die('can not query labor_personal_education');
if($_GET[debug] == "on")
{
echo $sqlcmd."<br>";
exit;
}
}
//exit;
### - - - - - - - - - - - - - - - - - - - - - - - - ###
### ข้อมูลส่วนตัว labor_personal
### คำนำหน้า มีเพศระบุมา ทำให้ต้องแยกเพศออกก่อน เพื่อเก็บเฉพาะ id คำนำหน้า
### // prename
$prename = "";
$arr_pn;
if($_POST[prename] != "")
{
$arr_pn = split("-",$_POST[prename]);
}
### //
$sqlcmd_date = "";
if($_GET['action'] == "edit" && $_GET[id_card] != "")
{
$sqlcmd_date = " update_date='".date("Y-m-d H:i:s")."',
update_staffid='".$staffid."'";
}
else
{
$sqlcmd_date = "add_date='".date("Y-m-d H:i:s")."',
add_staffid='".$staffid."',
update_date='".date("Y-m-d H:i:s")."',
update_staffid='".$staffid."'";
}
$sqlcmd_pic = "";
if($_POST[file_picture_name] != "")
{
$sqlcmd_pic = " file_picture_name='".$_POST[file_picture_name]."',";
$sqlcmd_pic .= " file_picture_path='".$_POST[file_picture_path]."',";
}
$status = "";
if($_GET[action] != "edit")
{
$status = "S";
}
else
{
$status = $_POST['status'];
}
$sqlcmd = "
id_card='".$_POST[id_card]."',
email='".$_POST[email]."',
prename='".$arr_pn[0]."',
fname='".$_POST[fname]."',
lname='".$_POST[lname]."',
sex='".$_POST[sex]."',
birthdate='".to_mysqldate($_POST[birthdate])."',
religion='".$_POST[religion]."',
d_no='".$_POST[d_no]."',
d_soi='".$_POST[d_soi]."',
d_moo_id='".$_POST[d_moo_id]."',
d_tambol_id='".$_POST[d_tambol_id]."',
d_ampur_id='".$_POST[d_ampur_id]."',
d_province_id='".$_POST[d_province_id]."',
d_zipcode='".$_POST[d_zipcode]."',
d_tel_h='".$_POST[d_tel_h]."',
d_tel_p='".$_POST[d_tel_p]."',
d_fax='".$_POST[d_fax]."',
p_no='".$_POST[p_no]."',
p_soi='".$_POST[p_soi]."',
p_moo_id='".$_POST[p_moo_id]."',
p_tambol_id='".$_POST[p_tambol_id]."',
p_ampur_id='".$_POST[p_ampur_id]."',
p_province_id='".$_POST[p_province_id]."',
p_zipcode='".$_POST[p_zipcode]."',
p_tel_h='".$_POST[p_tel_h]."',
p_tel_p='".$_POST[p_tel_p]."',
p_fax='".$_POST[p_fax]."',
status='".$status."',
".$sqlcmd_pic ."
";
$sqlcmd .= $sqlcmd_pic;
$sqlcmd .= $sqlcmd_date;
###
### check exist personal
$sqlexist = "SELECT COUNT(*) AS rowcount FROM labor_personal WHERE id_card='".$_POST[id_card]."'";
$exist = mysql_query($sqlexist) or die('can not query count labor personal');
$rsexist = mysql_fetch_assoc($exist);
if($rsexist[rowcount] > 0)
{
$sqlcmd = "UPDATE labor_personal SET ".$sqlcmd;
$sqlcmd .= " WHERE id_card='".$_POST[id_card]."'";
}
else
{
$sqlcmd = "INSERT INTO labor_personal ".$sqlcmd." SET ";
}
//
// echo "<pre>";
// echo $sqlcmd;
// exit;
////
mysql_query($sqlcmd) or die('can not insert or update table : labor_personal');
###
### ข้อมูลฝึกฝีมือแรงงาน
$sqlcmd = " course_activity_id='".$_POST[course_activity_id]."',
branch_id='".$_POST[branch_id]."',
course_id='".$_POST[course_id]."',
division='".$_POST[division]."',
id_card='".$_POST[id_card]."',
work_present_id='".$_POST[work_present_id][0]."',
emp_type_id='".$_POST[emp_type_id][0]."',
salary='".$_POST[salary]."',
i_no='".$_POST[i_no]."',
i_soi='".$_POST[i_soi]."',
i_moo_id='".$_POST[i_moo_id]."',
i_tambol_id='".$_POST[i_tambol_id]."',
i_ampur_id='".$_POST[i_ampur_id]."',
i_province_id='".$_POST[i_province_id]."',
i_postcode='".$_POST[i_postcode]."',
i_tel_h='".$_POST[d_tel_h]."',
i_tel_p='".$_POST[d_tel_p]."',
i_fax='".$_POST[d_fax]."',
industry_group_id='".$_POST[industry_group_id]."',
type_wish='".$_POST[type_wish]."',
position_id='".$_POST[position_id]."',
industry_group_id2='".$_POST[industry_group_id2]."',
country='".$_POST[country]."',
body='".$_POST[body]."',
register_date='".to_mysqldate($_POST[register_date])."',
stu_open_personal='".$_POST[stu_open_personal]."',
add_status='KEY',
";
if($_GET['action'] == "edit")
{
if($_GET['course_training_id'] != "")
{
$sqlcmd .= "
update_date='".cur_datetime."',
update_staffid='".staffid."',
";
}
}
else
{
$sqlcmd .= "
add_date='".$cur_datetime."',
add_staffid='".$staffid."',
update_date='".cur_datetime."',
update_staffid='".staffid."',
";
}
$sqlcmd .= "
stu_data='".$_POST[stu_data]."',
status='".$_POST[status]."'
";
if($sqlcmd != "")
{
###
### check exist training_course
$sqlexist = "SELECT COUNT(*) AS rowcount FROM labor_trainning_course WHERE runid='".$_POST[runid]."'";
$exist = mysql_query($sqlexist) or die('can not query count labor personal');
$rsexist = mysql_fetch_assoc($exist);
if($rsexist[rowcount] > 0)
{
$sqlcmd = "UPDATE labor_trainning_course SET ".$sqlcmd;
$sqlcmd .= " WHERE runid=".$_POST["runid"];
}
else
{
$sqlcmd = "INSERT INTO labor_trainning_course SET ".$sqlcmd;
}
// echo "<pre>".$sqlcmd;
// exit;
mysql_query($sqlcmd) or die('can not query labor_training_course');
print"<script language='javascript'> alert('บันทึกข้อมูลเรียบร้อยแล้ว'); </script>";
print"<meta http-equiv=\"refresh\" content=\"0;URL=index.php?p=labor_practice\">\n";
exit();
}
}
}
$row;
$runid = $_GET['runid'];
if($_GET['action'] == 'edit')
{
$sql = "SELECT
labor_personal.*,
labor_trainning_course.*,
labor_course_training.course_year
FROM
labor_personal
Inner Join labor_trainning_course ON labor_personal.id_card = labor_trainning_course.id_card
LEFT JOIN labor_course_training ON labor_trainning_course.course_id = labor_course_training.course_training_id
WHERE
labor_trainning_course.runid='$runid'
";
if($_GET[debug] == "on")
{
echo "<pre>";
echo $sql;
}
$res = mysql_query($sql) or die('can not query laber personal');
$row = mysql_fetch_assoc($res);
}
### END POST ###
?>
<script language='javascript' src='js/function.js'></script>
<script type="text/javascript" src="js/jquery-1.3.2.js"></script>
<script type="text/javascript" src="js/swfupload/swfupload.js"></script>
<script type="text/javascript" src="js/jquery.swfupload.js"></script>
<!--<script type="text/javascript" charset="utf-8" src="js/jquery-1.2.3.pack.js"></script>-->
<script type="text/javascript" src="js/daily_popcalendar.js"></script>
<script type="text/javascript">
function startUpload(){
$('#swfupload-control').swfupload('startUpload');
}
$(function(){
$('#swfupload-control').swfupload({
upload_url: "upload-img.php",
file_post_name: 'uploadfile',
file_size_limit : "10000",
file_types : "*.jpg;*.png;*.bmp;*.gif", //file_types : "*.jpg;*.png;*.bmp",
file_types_description : "image files",
file_upload_limit : 1,
flash_url : "js/swfupload/swfupload.swf",
button_image_url : 'js/swfupload/wdp_buttons_upload_114x29.png',
button_width : 114,
button_height : 29,
button_placeholder : $('#button')[0],
debug: false
})
.bind('fileQueued', function(event, file){
var listitem='<li id="'+file.id+'" >'+
'File: <em>'+file.name+'</em> ('+Math.round(file.size/1024)+' KB) <span class="progressvalue" ></span>'+
'<div class="progressbar" ><div class="progress" ></div></div>'+
'<p class="status" >Pending</p>'+
'<span class="cancel" > </span>'+
'</li>';
$('#log').append(listitem);
$('li#'+file.id+' .cancel').bind('click', function(){
var swfu = $.swfupload.getInstance('#swfupload-control');
swfu.cancelUpload(file.id);
$('li#'+file.id).slideUp('fast');
});
// start the upload since it's queued
//$(this).swfupload('startUpload');
document.getElementById('image').value=file.name;
})
.bind('fileQueueError', function(event, file, errorCode, message){
alert('Size of the file '+file.name+' is greater than limit');
})
.bind('fileDialogComplete', function(event, numFilesSelected, numFilesQueued){
$('#queuestatus').text('Files Selected: '+numFilesSelected+' / Queued Files: '+numFilesQueued);
})
.bind('uploadStart', function(event, file){
$('#log li#'+file.id).find('p.status').text('Uploading...');
$('#log li#'+file.id).find('span.progressvalue').text('0%');
$('#log li#'+file.id).find('span.cancel').hide();
})
.bind('uploadProgress', function(event, file, bytesLoaded){
//Show Progress
var percentage=Math.round((bytesLoaded/file.size)*100);
$('#log li#'+file.id).find('div.progress').css('width', percentage+'%');
$('#log li#'+file.id).find('span.progressvalue').text(percentage+'%');
})
.bind('uploadSuccess', function(event, file, serverData){
var item=$('#log li#'+file.id);
item.find('div.progress').css('width', '100%');
item.find('span.progressvalue').text('100%');
var pathtofile='<a href="files_image/'+file.name+'" target="_blank" >view »</a>';
document.getElementById("lblImage").innerHTML = "<img width=\"150\" src=\"files_image/"+file.name+"\" /><a href=# title=\"ลบภาพ\">ลบภาพ</a>";
document.getElementById("file_picture_path").value = "files_image/"+file.name;
document.getElementById("file_picture_name").value = file.name;
item.addClass('success').find('p.status').html('Done!!! | '+pathtofile);
})
.bind('uploadComplete', function(event, file){
// upload has completed, try the next one in the queue
$(this).swfupload('startUpload');
//window.location="xls_import_services.php?&xlsfile="+document.getElementById('xlsfile').value;
//alert("OK");
})
});
</script>
<script type="text/javascript">
$(document).ready(function(){
<?
if($_GET['action'] == "")
{
?>
$('.mover').show();
$('.mover2').show();
$('.mover3').show();
$('.mover4').show();
$('.mover5').show();
$('.mover6').show();
$('.mover7').show();
$('.mover8').show();
$('.mover9').show();
$('.mover10').show();
<?
}
else
{
?>
$('.mover').show();
$('.mover2').hide();
$('.mover3').show();
$('.mover4').hide();
$('.mover5').show();
$('.mover6').hide();
$('.mover7').show();
$('.mover8').show();
$('.mover9').show();
$('.mover10').show();
<?
}
?>
$('#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();
});
$('#slideToggle9').click(function(){
$(this).siblings('.mover9').slideToggle();
});
$('#slideToggle10').click(function(){
$(this).siblings('.mover10').slideToggle();
});
});
function getAmphur ( provinceID, amphur, tambol, moo, Slted , Slted2 , Slted3) {
//alert(provinceID)
if ( provinceID ) {
CreateXmlHttp();
XmlHttp.open("get", "ajax.get_amphur.php?provinceID="+provinceID+"&hur="+amphur+"&tambol="+tambol+"&moo="+moo+"&valSlted="+Slted, true);
XmlHttp.onreadystatechange=function() {
if (XmlHttp.readyState==4) {
if (XmlHttp.status==200) {
var res = XmlHttp.responseText;
if ( res ) {
//alert(res);
document.getElementById("lbl_"+amphur).innerHTML = res; //alert(res);
document.getElementById("lbl_"+tambol).innerHTML = "(กรุณาเลือกอำเภอก่อน)";
document.getElementById("lbl_"+moo).innerHTML = "(กรุณาเลือกตำบลก่อน)";
var amphurID = Slted;
getTambol ( amphurID, tambol, moo, Slted2 , Slted3);
}
} else if (XmlHttp.status==404) {
alert("ไม่สามารถทำการดึงข้อมูลได้");
} else {
alert("Error : "+XmlHttp.status);
}
}
};
XmlHttp.send(null);
} else {
document.getElementById("lbl_"+amphur).innerHTML = "(กรุณาเลือกจังหวัดก่อน)";
document.getElementById("lbl_"+tambol).innerHTML = "(กรุณาเลือกอำเภอก่อน)";
document.getElementById("lbl_"+moo).innerHTML = "(กรุณาเลือกตำบลก่อน)";
}
} // end
function getTambol ( amphurID, tambol, moo, Slted , Slted2) {
if ( amphurID ) {
CreateXmlHttp();
XmlHttp.open("get", "ajax.get_tambol.php?amphurID="+amphurID+"&tambol="+tambol+"&moo="+moo+"&valSlted="+Slted, true);
XmlHttp.onreadystatechange=function() {
if (XmlHttp.readyState==4) {
if (XmlHttp.status==200) {
var res = XmlHttp.responseText;
if ( res ) {
document.getElementById("lbl_"+tambol).innerHTML = res;
document.getElementById("lbl_"+moo).innerHTML = "(กรุณาเลือกตำบลก่อน)";
var tambolID = Slted;
getMoo ( tambolID, moo, Slted2 );
}
} else if (XmlHttp.status==404) {
alert("ไม่สามารถทำการดึงข้อมูลได้");
} else {
alert("Error : "+XmlHttp.status);
}
}
};
XmlHttp.send(null);
} else {
document.getElementById("lbl_"+tambol).innerHTML = "(กรุณาเลือกอำเภอก่อน)";
document.getElementById("lbl_"+moo).innerHTML = "(กรุณาเลือกตำบลก่อน)";
}
} // end
function getMoo ( tambolID, moo, Slted ) {
if ( tambolID ) {
CreateXmlHttp();
XmlHttp.open("get", "ajax.get_moo.php?tambolID="+tambolID+"&moo="+moo+"&valSlted="+Slted, true);
XmlHttp.onreadystatechange=function() {
if (XmlHttp.readyState==4) {
if (XmlHttp.status==200) {
var res = XmlHttp.responseText;
if ( res ) {
document.getElementById("lbl_"+moo).innerHTML = res;
//document.getElementById("d_province_id").value = "71000000";
}
} else if (XmlHttp.status==404) {
alert("ไม่สามารถทำการดึงข้อมูลได้");
} else {
alert("Error : "+XmlHttp.status);
}
}
};
XmlHttp.send(null);
} else {
document.getElementById("lbl_"+moo).innerHTML = "(กรุณาเลือกตำบลก่อน)";
}
} // end
function chgCourse ( course_year ,Slted ) {
//alert(course_year);
if ( course_year ) {
CreateXmlHttp();
XmlHttp.open("get", "ajax.get_course.php?course_year="+course_year+"&valSlted="+Slted, true);
XmlHttp.onreadystatechange=function() {
if (XmlHttp.readyState==4) {
if (XmlHttp.status==200) {
var res = XmlHttp.responseText;
if ( res ) {
document.getElementById("lblCourse").innerHTML = res;
}
} else if (XmlHttp.status==404) {
alert("ไม่สามารถทำการดึงข้อมูลได้");
} else {
alert("Error : "+XmlHttp.status);
}
}
};
XmlHttp.send(null);
}
} // end
function sch_province_id_onchange(e)
{
var school = document.getElementById('lblSchool');
var school_outsite = document.getElementById('school_outsite');
if(e.value == "13000000")
{
school.style.display = "block";
school_outsite.style.display = "none";
school_outsite = "";
}
else
{
school.style.display = "none";
school_outsite.style.display = "block";
}
}
function chkPIN( e , e_msg)
{
var msg = document.getElementById(e_msg);
msg.innerHTML = "";
var msg_red = '<img src="img/icon-warning.png" align="absmiddle" border="0"><font class="readstar"><b>ไม่ถูกต้องตามหลักกรมการปกครอง</b></font>';
id_card = new String(e.value);
if(id_card.length == 13)
{
if ( Script_checkID(id_card) == true)
{
//alert('right');
if("<?=$_GET['action']?>" != "edit")
{
//var chk = chgPinDup(id_card);
}
else
{
var pin = document.getElementById("id_card").value;
if(id_card != pin)
{
//var chk = chgPinDup(id_card);
}
}
}
else if ( Script_checkID(id_card) == false )
{
msg.innerHTML = msg_red;
}
}
else
{
msg.innerHTML = msg_red;
}
if(msg.innerHTML == "")
{
getPersonal(id_card)
}
}
function getPersonal ( id_card ) {
//alert(id_card);
if ( id_card ) {
CreateXmlHttp();
XmlHttp.open("get", "ajax.get_personal.traning.php?IDCard="+id_card, true);
XmlHttp.onreadystatechange=function() {
if (XmlHttp.readyState==4) {
if (XmlHttp.status==200) {
var res = XmlHttp.responseText;
if ( res ) {
var text = new String(res);
//alert(text);
var arr_text = text.split("||");
var id_card = arr_text[0];
var prename = arr_text[1];
var fname = arr_text[2];
var lname = arr_text[3];
var birthdate = arr_text[4];
var religion = arr_text[5];
var p_no = arr_text[6];
var p_soi = arr_text[7];
var p_province_id = arr_text[8];
var p_ampur_id = arr_text[9];
var p_tambol_id = arr_text[10];
var p_moo_id = arr_text[11];
var p_zipcode = arr_text[12];
var p_tel_h = arr_text[13];
var d_no = arr_text[14];
var d_soi = arr_text[15];
var d_province_id = arr_text[16];
var d_ampur_id = arr_text[17];
var d_tambol_id = arr_text[18];
var d_moo_id = arr_text[19];
var d_zipcode = arr_text[20];
var d_tel_h = arr_text[21];
var email = arr_text[22];
//document.getElementById("id_card").value = id_card;
var sel_prename = document.getElementById("prename");
var prename_count = sel_prename.options.length;
// --- คำนำหน้า
for(i=0; i<prename_count; i++)
{
var arr_prename = sel_prename.options[i].value.split("-");
var prename0 = arr_prename[0];
var prename1 = arr_prename[1];
if(prename == prename0)
{
sel_prename.options[i].selected = true;
}
}
document.getElementById("fname").value = fname;
document.getElementById("lname").value = lname;
document.getElementById("birthdate").value = birthdate;
// --- ศาสนา - - -
var sel_religion = document.getElementById("religion");
var religion_count = sel_religion.options.length;
for(i=0; i<religion_count; i++)
{
var religion0 = sel_religion.options[i].value;
if(religion == religion0)
{
sel_religion.options[i].selected = true;
}
}
// ---
document.getElementById("p_no").value = p_no;
document.getElementById("p_soi").value = p_soi;
document.getElementById("p_province_id").value = p_province_id;
document.getElementById("p_zipcode").value = p_zipcode;
document.getElementById("d_no").value = d_no;
document.getElementById("d_soi").value = d_soi;
document.getElementById("d_province_id").value = d_province_id;
document.getElementById("d_tel_h").value = d_tel_h;
document.getElementById("d_zipcode").value = d_zipcode;
document.getElementById("email").value = email;
<?= include("js.get_p_training_addr.php") ?>
}
} else if (XmlHttp.status==404) {
alert("ไม่สามารถทำการดึงข้อมูลได้");
} else {
alert("Error : "+XmlHttp.status);
}
}
};
XmlHttp.send(null);
}
} // end
function Script_checkID(id)
{
if(! IsNumeric(id)) return false;
if(id.length != 13) return false;
for(i=0, sum=0; i < 12; i++)
sum += parseFloat(id.charAt(i))*(13-i);
if((11-sum%11)%10!=parseFloat(id.charAt(12))) return false;
return true;
}
function checkForm()
{
return true;
var rd = document.form1.stu_open_personal;
for(i=0; i<rd.length; i++)
{
if(rd[i].checked){break;}
}
// rd.length
var id_card = mergePIN(document.form1.id_card);
id_card = new String(id_card);
if(id_card.length != 13)
{
alert("! กรุณาระบุเลขบัตรประชาชนให้ครบ 13 หลัก");
return false;
}
if(document.getElementById('pcr').innerHTML != "")
{
alert("! กรุณาระบุเลขบัตรประชาชนใหุ้ถูกต้อง");
return false;
}
document.form1.id_card_full.value = id_card;
var o = document.getElementById("firstname");
if(trim(o.value) == "")
{
alert("! กรุณาระบุชื่อ");
o.focus();
o.select();
return false;
}
var o = document.getElementById("surname");
if(trim(o.value) == "")
{
alert("! กรุณาระบุนามสกุล");
o.focus();
o.select();
return false;
}
var o = document.form1.sex;
var check = false;
for(i=0;i<o.length;i++)
{
if(o[i].checked)
{
check = true;
break;
}
}
if(!check)
{
alert("! กรุณาระบุเพศ");
return false;
}
var o = document.getElementById("birthdate");
var s = document.getElementById("span_old")
//alert(s.innerHTML);
//return false;
if(trim(o.value) != "")
{
var d = parseFloat(s.innerHTML);
if(d < 50)
{
alert("! ผู้สูงอายุต้องมีอายุตั้งแต่ 50 ปีขึ้นไป");
return false
}
}
var o = document.form1.no_chance;
var check = false;
for(i=0;i<o.length;i++)
{
if(o[i].checked)
{
check = true;
break;
}
}
if(!check)
{
alert("! กรุณาระบุเป็นผู้ด้อยโอกาส");
return false;
}
var o = document.form1.live_status;
var check = false;
for(i=0;i<o.length;i++)
{
if(o[i].checked)
{
check = true;
break;
}
}
if(!check)
{
alert("! กรุณาระบุสถานะภาพการมีชีวิต");
return false;
}
// var address_no_length = document.form1.address_no.length;
// var address_no = mergePIN(document.form1.address_no);
// address_no = new String(address_no);
// document.form1.address_no_full.value = address_no;
// if(trim(address_no) != "")
// {
// if(address_no_length != 11)
// {
// alert("! กรุณาระบุเลขบัตรประชาชนให้ครบ 11 หลัก");
// return false;
// }
// }
// var o = document.getElementById("address_no2");
// if(trim(o.value) == "")
// {
// alert("! กรุณาระบุเลขที่");
// o.focus();
// o.select();
// return false;
// }
// var o = document.getElementById("province");
// var val = o.options[o.options.selectedIndex].value;
// if(trim(val) == "")
// {
// alert("! กรุณาระบุจังหวัด");
// return false;
// }
//
// var o = document.getElementById("district");
// var val = o.options[o.options.selectedIndex].value;
// if(trim(val) == "")
// {
// alert("! กรุณาระบุอำเภอ");
// return false;
// }
//
// var o = document.getElementById("subdistrict");
// var val = o.options[o.options.selectedIndex].value;
// if(trim(val) == "")
// {
// alert("! กรุณาระบุตำบล");
// return false;
// }
// var o = document.getElementById("postcode");
// if(trim(o.value) == "")
// {
// alert("! กรุณาระบุรหัสไปรษณีย์");
// o.focus();
// o.select();
// return false;
// }
var branch_length = document.form1.branch_intellect_length.value;
var check = false;
for(i=0;i<branch_length;i++)
{
var o = eval("document.form1.branch_intellect_" + i);
if(o)
{
if(o.checked)
{
check = true;
break;
}
}
}
if(!check)
{
alert("! กรุณาระบุสาขาภูมิปัญญาอย่างน้อย 1 สาขา");
return false;
}
var o = document.form1.knowledge_chance;
var check = false;
for(i=0;i<o.length;i++)
{
if(o[i].checked)
{
check = true;
break;
}
}
if(!check)
{
alert("! กรุณาระบุความต้องการในการพัฒนาความรู้/ภูมิปัญญาของตน");
return false;
}
var o = document.form1.teaching;
var check = false;
for(i=0;i<o.length;i++)
{
if(o[i].checked)
{
check = true;
break;
}
}
if(!check)
{
alert("! กรุณาระบุความต้องการในการถ่ายทอดความรู้/ภูมิปัญญาของตน");
return false;
}
var o = document.form1.stu_open_personal;
var check = false;
for(i=0;i<o.length;i++)
{
if(o[i].checked)
{
check = true;
break;
}
}
return true;
}
function prename_onchange(t)
{
var o = document.form1.sex;
var gender = new String(t.value);
var gender_id = gender.split("-");
o[0].disabled = "";
o[1].disabled = "";
if(gender_id[1] == 1)
{
//alert("male");
o[0].checked = true;
// o[0].disabled = "disabled";
// o[1].disabled = "disabled";
}
else if(gender_id[1] == 2)
{
//alert("female");
o[1].checked = true;
// o[0].disabled = "disabled";
// o[1].disabled = "disabled";
}
}
function body_onclick(e)
{
var d = document.form1.elements['deformed_id[]'];
var disabled = false;
if(e.value == "1")
{
disabled = true;
}
for(i=0; i<d.length; i++)
{
d[i].disabled = disabled;
if(disabled)
{
d[i].checked = false;
}
}
}
</script>
<style type="text/css" >
#swfupload-control p{ margin:0px 0px; font-size:0.9em; }
#log{ margin:0; padding:0; width:500px;}
#log li{ list-style-position:inside; margin:2px; border:1px solid #ccc; padding:10px; font-size:12px;
font-family:Arial, Helvetica, sans-serif; color:#333; background:#fff; position:relative;}
#log li .progressbar{ border:1px solid #333; height:5px; background:#fff; }
#log li .progress{ background:#999; width:0%; height:5px; }
#log li p{ margin:0; line-height:18px; }
#log li.success{ border:1px solid #339933; background:#ccf9b9; }
#log li span.cancel{ position:absolute; top:5px; right:5px; width:20px; height:20px;
background:url('js/swfupload/cancel.png') no-repeat; cursor:pointer; }
<!--
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;
}
</style>
<style type="text/css">
.list1{
width:170px
}
.redstar{
color:#FF0000;
font-size:10px;
font-weight:500;
}
</style>
<style type="text/css">
.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;
}
.container9 .pusher9{
cursor:pointer;
padding:3px 10px 3px 7px;
font-weight:900;
font-size:12px;
margin:0;
background:url(img/bgheader-2.PNG);
color:#FFFFFF;
}
.container9 .mover9{
border:1px solid #3399CC;
padding:3px 10px 3px 7px;
margin: 0;
background-color:#E1F0FF;
}
.container9 {
padding:6px;
margin-top:5px;
width: auto;
font-size:11px;
}
.container10 .pusher10{
cursor:pointer;
padding:3px 10px 3px 7px;
font-weight:900;
font-size:12px;
margin:0;
background:url(img/bgheader-2.PNG);
color:#FFFFFF;
}
.container10 .mover10{
border:1px solid #3399CC;
padding:3px 10px 3px 7px;
margin: 0;
background-color:#E1F0FF;
}
.container10 {
padding:6px;
margin-top:5px;
width: auto;
font-size:11px;
}
</style>
<!--ajax-->
<script language="javascript1.2">
function CreateXmlHttp(){
//Creating object of XMLHTTP in IE
try {
XmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
}
catch(e){
try{
XmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
catch(oc) {
XmlHttp = null;
}
}
//Creating object of XMLHTTP in Mozilla and Safari
if(!XmlHttp && typeof XMLHttpRequest != "undefined") {
XmlHttp = new XMLHttpRequest();
}
} // end function CreateXmlHttp
function chgPinDup(e, defa_v) {
if ( e ) {
//var id_card = mergePIN(document.form1.id_card);
id_card = new String(e);
CreateXmlHttp();
XmlHttp.open("get", "ajax.chkpindup.php?PvID="+id_card, true);
XmlHttp.onreadystatechange=function() {
if (XmlHttp.readyState==4) {
if (XmlHttp.status==200) {
var res = XmlHttp.responseText;
document.getElementById('pcr').innerHTML = "";
if(res == "1")
{
document.getElementById('pcr').innerHTML = "<font color=\"#CC0000\">! พบเลขบัตรประชาชนดังกล่าว ในระบบแล้ว</font>"
}
} else if (XmlHttp.status==404) {
alert("ไม่สามารถทำการดึงข้อมูลได้");
} else {
alert("Error : "+XmlHttp.status);
}
}
};
XmlHttp.send(null);
}
}
function chgMooname(e, defa_v) {
if ( e ) {
CreateXmlHttp();
XmlHttp.open("get", "ajax.chgmooname.php?MooID="+e+"&DfVal="+defa_v, true);
XmlHttp.onreadystatechange=function() {
if (XmlHttp.readyState==4) {
if (XmlHttp.status==200) {
var res = XmlHttp.responseText; //alert(res);
arrMoo = res.split(",");
document.getElementById("addr_moo_id").value= arrMoo[0];
document.getElementById("addr_village").value= arrMoo[1];
} else if (XmlHttp.status==404) {
alert("ไม่สามารถทำการดึงข้อมูลได้");
} else {
alert("Error : "+XmlHttp.status);
}
}
};
XmlHttp.send(null);
}
}
<!--function คำนวณอายุ โดยการ input วันเกิดเข้าไป-->
function education_id_onchange(e)
{
var v = e.value;
if ( e ) {
CreateXmlHttp();
XmlHttp.open("get", "ajax.chgschool.php?education_id="+v, true);
XmlHttp.onreadystatechange=function() {
if (XmlHttp.readyState==4) {
if (XmlHttp.status==200){
var res = XmlHttp.responseText; //alert(res);
document.getElementById("lblSchool").innerHTML= res;
} else if (XmlHttp.status==404) {
alert("ไม่สามารถทำการดึงข้อมูลได้");
} else {
alert("Error : "+XmlHttp.status);
}
}
};
XmlHttp.send(null);
}
}
function copy_address()
{
var o = document.getElementById("p_no");
var o2 = document.getElementById("d_no");
o2.value = o.value;
var o = document.getElementById("p_soi");
var o2 = document.getElementById("d_soi");
o2.value = o.value;
var o = document.getElementById("p_province_id");
var val = o.options[o.options.selectedIndex].value;
var o2 = document.getElementById("d_province_id");
o2.options.selectedIndex = o.options.selectedIndex;
var o = document.getElementById("p_ampur_id");
var o2 = document.getElementById("d_ampur_id");
o2.innerHTML = "";
var op = o.getElementsByTagName("option");
for(var i=0; i < op.length ; i++)
{
var new_op = document.createElement("option");
new_op.value = o.options[i].value;
new_op.innerHTML = o.options[i].text;
if(o.options.selectedIndex == i)
{
new_op.setAttribute("selected","selected");
}
o2.appendChild(new_op);
}
var o = document.getElementById("p_tambol_id");
var o2 = document.getElementById("d_tambol_id");
o2.innerHTML = "";
var op = o.getElementsByTagName("option");
for(var i=0; i < op.length ; i++)
{
var new_op = document.createElement("option");
new_op.value = o.options[i].value;
new_op.innerHTML = o.options[i].text;
if(o.options.selectedIndex == i)
{
new_op.setAttribute("selected","selected");
}
o2.appendChild(new_op);
}
var o = document.getElementById("p_moo_id");
var o2 = document.getElementById("d_moo_id");
o2.innerHTML = "";
var op = o.getElementsByTagName("option");
for(var i=0; i < op.length ; i++)
{
var new_op = document.createElement("option");
new_op.value = o.options[i].value;
new_op.innerHTML = o.options[i].text;
if(o.options.selectedIndex == i)
{
new_op.setAttribute("selected","selected");
}
o2.appendChild(new_op);
}
var o = document.getElementById("p_moo_id");
var o2 = document.getElementById("d_moo_id");
o2.value = o.value;
var o = document.getElementById("p_zipcode");
var o2 = document.getElementById("d_zipcode");
o2.value = o.value;
var o = document.getElementById("p_tel_h");
var o2 = document.getElementById("d_tel_h");
o2.value = o.value;
var o = document.getElementById("p_fax");
var o2 = document.getElementById("d_fax");
o2.value = o.value;
}
</script>
<table width="90%" border="0" align="center" cellspacing="0" cellpadding="3" bordercolor="#CCCCCC" style="border-collapse:collapse;">
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center">
<b style="font-size:16px">ผู้สมัครเข้ารับการฝึกอบรมฝีมือแรงงาน</b></td>
</tr>
<tr>
<td align="center"> </td>
</tr>
</table>
<form action="" method="post" name="form1" id="form1" enctype="multipart/form-data">
<table width="90%" border="1" align="center" cellspacing="0" cellpadding="3" bordercolor="#CCCCCC" style="border-collapse:collapse;">
<tr>
<td>
<div class="container">
<div class="pusher" id="slideToggle">ข้อมูลส่วนบุคคล <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td></td>
<td></td>
<td width="150" valign="top" align="right"></td>
</tr>
<?
if($_GET[action] == "edit" && $_GET[runid] != "")
{
$sltd = "selected";
$sta_S = "";
$sta_P = "";
$sta_Y = "";
$sta_N = "";
if($row[status] == "S"){$sta_S = $sltd;}
if($row[status] == "P"){$sta_P = $sltd;}
if($row[status] == "Y"){$sta_Y = $sltd;}
if($row[status] == "N"){$sta_N = $sltd;}
?>
<tr>
<td>สถานะ</td>
<td><select name="status" id="status" class="list1">
<option value="">:: สถานะของผู้สมัคร ::</option>
<option <?=$sta_S?> value="S">สมัครเข้ารับการฝึกฝีมือแรงงาน</option>
<option <?=$sta_P?> value="P">ผ่านการคัดเลือก</option>
<option <?=$sta_Y?> value="Y">ผ่านการฝึก</option>
<option <?=$sta_N?> value="N">ไม่ผ่านการฝึก</option>
</select></td>
<td></td>
</tr>
<?
}
?>
<tr>
<td width="150"><div align="left">
<label class="redstar">*</label>
ปีงบประมาณ
</div></td>
<td><select name="budget_year" id="budget_year" class="list1" onchange="chgCourse(this.value,'1');">
<option value="">เลือก</option>
<?php
$b_year = $cur_year;
$b_year += 545;
for($i=0;$i<7;$i++)
{
if($row['course_year'] == $b_year)
{
echo "<option selected value=".$b_year.">".$b_year."</option>";
}
else
{
echo "<option value=".$b_year.">".$b_year."</option>";
}
$b_year--;
}
?>
</select></td><td width="150" rowspan="9" align="right" valign="top"><label id="lblImage"><img width="150" height="180" src="<?=$row[file_picture_path] != '' ? $row[file_picture_path] : "bimg/nopicture.gif"?>" /><a href=# title="ลบภาพ"></a></label><input type="hidden" name="file_picture_path" id="file_picture_path" /><input type="hidden" name="file_picture_name" id="file_picture_name" /></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar">*</label>
กิจกรรมการฝึก</div></td>
<td><select name="course_activity_id" id="course_activity_id" style="width:300px">
<option value="">เลือก</option>
<?php
$strSQL = "SELECT * FROM labor_master_course_activity WHERE parent_id=0";
$rsConn = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($rsConn) ) {
$slted = "";
if($row['course_activity_id'] == $Result->course_activity_id)
{
$slted = "selected";
}
echo "<option value=\"".$Result->course_activity_id."\" ".$slted.">".$Result->activity."</option>\n";
}
?>
</select></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar">*</label>
กลุ่มอาชีพ
</div></td>
<td><select name="branch_id" id="branch_id" style="width:300px">
<option value="">เลือก</option>
<?php
$strSQL = "SELECT * FROM labor_master_course_branch WHERE parent_id=0";
$rsConn = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($rsConn) ) {
$slted = "";
if($row['branch_id'] == $Result->branch_id)
{
$slted = "selected";
}
echo "<option value=\"".$Result->branch_id."\" ".$slted.">".$Result->branch_name."</option>\n";
}
?>
</select></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar">*</label>
หลักสูตร</div></td>
<td><label id="lblCourse"><select name="course_id" id="course_id" style="width:300px">
<option value="">เลือก</option>
<?php
$strSQL = "SELECT * FROM labor_course_training WHERE course_year=".$row['course_year'];
$rsConn = mysql_query($strSQL);
while ( $Result = mysql_fetch_assoc($rsConn) ) {
$slted = "";
if($row['course_id'] == $Result[course_training_id])
{
$slted = "selected";
}
echo "<option value=\"".$Result[course_training_id]."\" ".$slted.">".$Result[course_name]."</option>\n";
}
?>
</select></label></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar">*</label>
เลขประจำตัวประชาชน
</div></td>
<td><input name="id_card" id="id_card" type="text" maxlength="13" size="30" value="<?=$row['id_card']?>"
onblur="chkPIN(this ,'msg_idcard');"/><span id="msg_idcard" class="redstar"></span></td>
</tr>
<tr>
<td><div align="left"><label class="redstar"></label> คำนำหน้าชื่อ</div></td>
<td><select name="prename" id="prename" class="list1" onchange="prename_onchange(this);">
<option value="">เลือก</option>
<?php
$strSQL = "SELECT concat(concat(id,\"-\"),gender) AS id,prename_th,gender FROM `tbl_prename` ORDER BY priority";
$rsConn = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($rsConn) ) {
$slted = "";
$arr_prename = split("-",$Result->id);
if($arr_prename[0] == $row['prename'])
{
$slted = "selected";
}
echo "<option value=\"".$Result->id."\" $slted>".$Result->prename_th."</option>\n";
}
?>
</select></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar">*</label>
ชื่อ</div></td>
<td><input name="fname" id="fname" type="text" size="30" value="<?=$row['fname']?>" />
<span id="msg_fname" class="redstar"></span></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar">*</label>
นามสกุล</div></td>
<td><input name="lname" id="lname" type="text" size="30" value="<?=$row['lname']?>"/>
<span id="msg_lname" class="redstar"></span></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar">*</label>
เพศ</div></td>
<?
$chkmale = "";
$chkfemale = "";
if($row['sex'] == "1") $chkmale = "checked";
if($row['sex'] == "2") $chkfemale = "checked";
?>
<td><input name="sex" type="radio" value="1" <?=$chkmale?> />ชาย <input name="sex" type="radio" value="2" <?=$chkfemale?>/>หญิง
<label></label></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar"></label>
วัน เดือน ปี เกิด </div></td>
<?
$chklive = "";
$chkdeath = "";
if($row['live_status'] == "1") $chklive = "checked";
if($row['live_status'] == "0") $chkdeath = "checked";
?>
<td>
<input name="birthdate" id="birthdate" size="10" maxlength="10" value="<?=to_keydate($row['birthdate'])?>" onkeypress="chkDateFormat(this,event)" onblur="checkThaiDate(this,document.getElementById('msg_birthdate'));calDate(this);">
<img src="js/calendar/calendar2.gif" align="absmiddle" border="0" onClick="popUpCalendar(this, form1.birthdate, 'dd/mm/yyyy')" title="วัน เดือน ปี" style="cursor:pointer;" /> อายุ <span id="span_old">...</span> ปี <span id='msg_birthdate'></span></td>
<td> </td>
</tr>
<script language="javascript">
var o = document.getElementById("birthdate");
var i = document.getElementById("span_old");
if(o.value != "")
{
if("<?=$chkdeath?>" == "")
{
calDate (o);
}
}
</script>
<tr>
<td><div>
วันที่สมัคร</div></td>
<td><div >
<?
$regdate = "";
if($_GET['action'] != "edit")
{
$regdate = date("d/m/").(date("Y")+543);
}
else
{
$regdate = to_keydate($row['register_date']);
}
?>
<input name="register_date" size="10" id="register_date" maxlength="10" value="<?=$regdate?>" onkeypress="chkDateFormat(this,event)" onblur="checkThaiDate(this,document.getElementById('msg_registerdate'));" />
<img src="js/calendar/calendar2.gif" align="top" border="0" onclick="popUpCalendar(this, form1.register_date, 'dd/mm/yyyy')" title="วัน เดือน ปี" style="cursor:pointer;" /> <span id='msg_registerdate'></span></div></td>
<td> </td>
</tr>
<tr>
<td><div>ศาสนา</div></td>
<td><select name="religion" id="religion" class="list1">
<option value="">เลือก</option>
<?php
$sql_ori = "SELECT * FROM tbl_religion ";
$query_ori = mysql_query($sql_ori) or die(mysql_error());
while($rows_ori = mysql_fetch_array($query_ori)){
$selected="";
if(trim($row['religion']) == trim($rows_ori['id']))
{
$selected = "selected";
}
else
{
if($rows_ori['religion'] == 'พุทธ')
{
$selected = "selected";
}
}
?>
<option value="<?=$rows_ori['id']?>" <?=$selected?> >
<?=$rows_ori['religion']?>
</option>
<?php
}
?>
</select></td>
<td> </td>
</tr>
<tr>
<td height="25"> รูปภาพ</td>
<td align="left">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200"><input name="image" size="30" type="text" readonly="readonly" id="image" value="<?=($_POST['image']=='')?str_replace ( "files_image/", "",$Result_3['image'] ):$_POST['image']?>" /></td>
<td width="477"> <input type="button" id="button" /></td>
</tr>
</table> </td>
<td> </td>
</tr>
<tr>
<td height="25" align="right"> </td>
<td align="left"><span id="swfupload-control">
<p id="queuestatus"></p><ol id="log"></ol>
</span><input type="button" name="btnUpload" value="Upload" id="boxok" style="width:80" onclick="startUpload()"/> </td>
<td> </td>
</tr>
<tr>
<td><div align="left">E-mail </div></td>
<td colspan="3"><input name="email" id="email" type="text" size="30" value="<?=$row['email']?>"/></td>
</tr>
</table>
</div>
</div>
<?
$sqledu = "
SELECT
labor_personal_education.*,
labor_master_school.school_id,
labor_master_school.school_name,
labor_master_school.sch_tambol_id,
labor_master_school.sch_ampur_id,
labor_master_school.sch_province_id,
tbl_education_level.level,
labor_personal_education.sch_outsite_province_id
FROM
labor_personal
LEFT Join labor_personal_education ON labor_personal.id_card = labor_personal_education.id_card
LEFT Join tbl_education_level ON labor_personal_education.education_id = tbl_education_level.educ_id
LEFT Join labor_master_school ON labor_personal_education.school_id = labor_master_school.school_id
WHERE labor_personal_education.id_card = '".$row[id_card]."'
Order By tbl_education_level.level DESC limit 1 ";
$edu = mysql_query($sqledu);
$rsedu = mysql_fetch_assoc($edu);
?>
<div class="container2">
<div class="pusher2" id="slideToggle2">การศึกษาสูงสุด <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover2">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td valign="top"><div align="left">จังหวัดสถานศึกษา</div></td>
<td valign="top"><select name="shc_province_id" id="shc_province_id" class="list1" onchange="sch_province_id_onchange(this)">
<option value="">เลือก</option>
<?php
$sql_ori = "SELECT * FROM ccaa WHERE ccType = 'Changwat' ORDER BY ccName ";
$query_ori = mysql_query($sql_ori)or die(mysql_error());
while($rows_ori = mysql_fetch_array($query_ori)){
$selected="";
if($rsedu[school_id] != 0)
{
if($rsedu['sch_province_id'] == $rows_ori['ccDigi'])
{
$selected = "selected";
}
}else
{
if($rsedu['sch_outsite_province_id'] == $rows_ori['ccDigi'])
{
$selected = "selected";
}
}
if($_GET['action'] != "edit")
{
if($rows_ori['ccDigi'] == "13000000")
{
$selected = "selected";
}
}
?>
<option value="<?=$rows_ori['ccDigi']?>" <?=$selected?> >
<?=str_replace("จังหวัด","", $rows_ori['ccName'])?>
</option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td width="150" valign="top"><div align="left">ระดับ</div></td>
<td valign="top"><select id="education_id" name="education_id" class="list1" onchange="education_id_onchange(this);">
<option value="">เลือก</option>
<?php
$sql_ori = "SELECT * FROM tbl_education_level ";
$query_ori = mysql_query($sql_ori)or die(mysql_error());
while($rows_ori = mysql_fetch_array($query_ori)){
$selected="";
if($rsedu['education_id'] == $rows_ori['educ_id'])
{
$selected = "selected";
}
?>
<option value="<?=$rows_ori['educ_id']?>" <?=$selected?> >
<?=$rows_ori['education']?>
</option>
<?php
}
?>
<?
$style_graduated = "style=\"display:none\"";
if($rsedu['education_id'] == "99")
{
$style_graduated = "style=\"display:block\"";
}
?>
</select></td>
</tr>
<tr>
<td valign="top"><div align="left">สาขาวิชา</div></td>
<td valign="top"><input name="branch" id="branch" type="text" size="30" value="<?=$rsedu['branch']?>" /></td>
</tr>
<tr>
<td valign="top"><div align="left">สถานศึกษา</div></td>
<?
if($_GET['action'] == "edit")
{
$is_pathumthani = ($rsedu['sch_province_id'] == "13000000");
}
else
{
$is_pathumthani = true;
}
$display = "style=\"display:block\"";
$display_none = "style=\"display:none\"";
$school_display = $display_none;
$school_outsite_display = $display;
if($is_pathumthani)
{
$school_display = $display;
$school_outsite_display = $display_none;
}
?>
<td valign="top"><LABEL id="lblSchool"><select <?=$school_display?> name="school_id" id="school_id" class="list1">
<option value="">เลือก</option>
<?php
$sql_ori = "SELECT * FROM labor_master_school";
$query_ori = mysql_query($sql_ori)or die(mysql_error());
while($rows_ori = mysql_fetch_array($query_ori)){
$selected="";
if($rsedu['school_id'] == $rows_ori['school_id'])
{
$selected = "selected";
}
?>
<option value="<?=$rows_ori['school_id']?>" <?=$selected?> >
<?=$rows_ori['school_name']?>
</option>
<?php
}
?>
</select></LABEL>
<input name="school_outsite" <?=$school_outsite_display?> id="school_outsite" type="text" size="30" value="<?=$rsedu['school_outsite']?>" /></td>
</tr>
<tr>
<td valign="top"><div align="left">ปีพ.ศ.ที่สำเร็จการศึกษา</div></td>
<td valign="top"><input name="graudated_year" id="graudated_year" maxlength="4" type="text" size="7" value="<?=$rsedu['graudated_year']?>" onkeypress="checkNumber(this,document.getElementById('msg_graudatedyear'));"/><span id="msg_graduatedyear" class="redstar"></span></td>
</tr>
<tr style="display:none">
<td height="25">ไฟล์แนบ</td>
<td align="left">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200"><input name="file_transcript_name" size="30" type="text" readonly="readonly" id="file_transcript_name" value="<?=($_POST['file_transcript_name']=='')?str_replace ( "files_image/", "",$Result_3['file_transcript_name'] ):$_POST['file_transcript_name']?>" /></td>
<td width="477"> <input type="button" id="button" /></td>
</tr>
</table> </td>
</tr>
<tr style="display:none">
<td height="25" align="right"> </td>
<td align="left"><span id="swfupload-control">
<p id="queuestatus">
<?
if($_GET['edit']){
echo '<img src="';
echo $Result_3['image'];
echo '" align="absmiddle" width="70" border="0" onclick="window.open(\'';
echo $Result_3['image'];
echo '\')" style="cursor:pointer" />';
}
?> </p>
<ol id="log"></ol>
</span>
<input type="button" name="btnTranscriptUpload" value="Upload" id="btnTranscriptUpload" style="width:80" onclick="startUpload()"/> </td>
</tr>
</table>
</div>
</div>
<div class="container3">
<div class="pusher3" id="slideToggle3">ที่อยู่ <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover3">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="150"><strong>ที่อยู่ที่สามารถติดต่อได้</strong></td>
<td > </td>
</tr>
<tr>
<td>
<div align="left">
บ้านเลขที่</div></td><td><input name="p_no" id="p_no" type="text" value="<?=$row['p_no']?>"/></td>
</tr>
<tr>
<td><div align="left">ถนน/ตรอก/ซอย</div></td>
<td><input name="p_soi" id="p_soi" type="text" value="<?=$row['p_soi']?>"/></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">จังหวัด</td>
<td align="left"><select class="list1" name="p_province_id" id="p_province_id" style="width:200px" onchange="getAmphur(this.value, 'p_ampur_id', 'p_tambol_id', 'p_moo_id', '' , '' , '')">
<option value="">...</option>
<?php
$p_province_id = $row['p_province_id'];
$strSQL = "SELECT * FROM ccaa WHERE ccType='Changwat' ORDER BY ccName";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $p_province_id ) ? "selected" : "";
echo "<option value=\"".$Result->ccDigi."\" $Slted>".str_replace("จังหวัด", "", $Result->ccName)."</option>";
}
?>
</select></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">อำเภอ</td>
<td align="left"><label id="lbl_p_ampur_id" style="width:200px">
<?
if ( $p_province_id ) {
$p_ampur_id = $row['p_ampur_id'];
$strSEL = "<select name=\"p_ampur_id\" id=\"p_ampur_id\" style=\"width:200px\" onchange=\"getTambol(this.value, 'p_tambol_id', 'p_moo_id', '' , '' )\"><option value=\"\">...</option>";
$strSQL = "SELECT * FROM ccaa WHERE ccDigi LIKE '".substr($p_province_id, 0, 2)."%' AND ccType='Aumpur' ORDER BY ccDigi";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $p_ampur_id ) ? "selected" : "";
$strSEL .= "<option value='".$Result->ccDigi."' $Slted>".$Result->ccName."</option>";
}
$strSEL .= "</select>";
echo $strSEL;
} else {
echo "(กรุณาเลือกจังหวัดก่อน)";
}
?>
</label></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">ตำบล</td>
<td align="left"><label id="lbl_p_tambol_id" style="width:200px">
<?
// $sql_ampur = "SELECT * FROM labor_personal WHERE id_card = '".$id_card."'";
// $res_ampur = mysql_query($sql_ampur);
// $rs_ampur = mysql_fetch_assoc($res_ampur);
// $p_ampur_id = $rs_ampur['p_ampur_id'];
if ( $p_ampur_id ) {
$p_tambol_id = $row['p_tambol_id'];
$strSEL = "<select name=\"p_tambol_id\" id=\"p_tambol_id\" style=\"width:200px\" onchange=\"getMoo(this.value, 'p_moo_id', '')\"><option value=\"\">...</option>";
$strSQL = "SELECT * FROM ccaa WHERE ccDigi LIKE '".substr($p_ampur_id, 0, 4)."%' AND ccType='Tamboon' ORDER BY ccDigi";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $p_tambol_id ) ? "selected" : "";
$strSEL .= "<option value='".$Result->ccDigi."' $Slted>".$Result->ccName."</option>";
}
$strSEL .= "</select>";
echo $strSEL;
} else {
echo "(กรุณาเลือกอำเภอก่อน)";
}
?>
</label></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">หมู่บ้าน</td>
<td align="left"><label id="lbl_p_moo_id" style="width:200px">
<?
if ( $p_tambol_id ) {
$p_moo_id = $row['p_moo_id'];
$strSEL = "<select name=\"p_moo_id\" id=\"p_moo_id\" style=\"width:200px\"><option value=\"\">...</option>";
$strSQL = "SELECT * FROM ccaa_village WHERE ccDigi LIKE '".substr($p_tambol_id, 0, 6)."%' AND ccType='Village' ORDER BY ccDigi";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $p_moo_id ) ? "selected" : "";
$strSEL .= "<option value='".$Result->ccDigi."' $Slted>".$Result->ccName."</option>";
}
$strSEL .= "</select>";
echo $strSEL;
} else {
echo "(กรุณาเลือกตำบลก่อน)";
}
?>
</label></td>
</tr>
<tr>
<td>
<div align="left"> รหัสไปรษณีย์</div></td><td><input name="p_zipcode" maxlength="5" size="10" id="p_zipcode" type="text"value="<?=$row['p_zipcode']?>" /></td>
</tr>
<tr>
<td><div align="left">โทรศัพท์</div></td>
<td><input name="p_tel_h" id="p_tel_h" type="text" value="<?=$row['p_tel_h']?>" /></td>
</tr>
<tr>
<td><div align="left">โทรสาร</div></td>
<td><input name="p_fax" id="p_fax" type="text" value="<?=$row['p_fax']?>"/></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="150"><strong>ที่อยู่ตามทะเบียนบ้าน</strong></td>
<td><div style="display:none"> <input name="checkcopy" type="checkbox" value="" onclick="copy_address()" /><label>เหมือนที่อยู่ตามทะเบียนบ้าน</label></div></td>
</tr>
<tr>
<td>
<div align="left">
บ้านเลขที่</div></td><td><input name="d_no" id="d_no" type="text" value="<?=$row['d_no']?>"/></td>
</tr>
<tr>
<td><div align="left">ตรอก/ซอย</div></td>
<td><input name="d_soi" id="d_soi" type="text" value="<?=$row['d_soi']?>"/></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">จังหวัด</td>
<td align="left"><select name="d_province_id" id="d_province_id" style="width:200px" onchange="getAmphur(this.value, 'd_ampur_id', 'd_tambol_id', 'd_moo_id', '')">
<option value="">...</option>
<?php
$d_province_id = $row['d_province_id'];
$strSQL = "SELECT * FROM ccaa WHERE ccType='Changwat' ORDER BY ccName";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $d_province_id ) ? "selected" : "";
echo "<option value=\"".$Result->ccDigi."\" $Slted>".str_replace("จังหวัด", "", $Result->ccName)."</option>";
}
?>
</select></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">อำเภอ</td>
<td align="left"><label id="lbl_d_ampur_id" style="width:200px">
<?
if ( $d_province_id ) {
$d_ampur_id = $row['d_ampur_id'];
$strSEL = "<select name=\"d_ampur_id\" id=\"d_ampur_id\" style=\"width:200px\" onchange=\"getTambol(this.value, 'd_tambol_id', 'd_moo_id', '')\"><option value=\"\">...</option>";
$strSQL = "SELECT * FROM ccaa WHERE ccDigi LIKE '".substr($d_province_id, 0, 2)."%' AND ccType='Aumpur' ORDER BY ccDigi";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $d_ampur_id ) ? "selected" : "";
$strSEL .= "<option value='".$Result->ccDigi."' $Slted>".$Result->ccName."</option>";
}
$strSEL .= "</select>";
echo $strSEL;
} else {
echo "(กรุณาเลือกจังหวัดก่อน)";
}
?>
</label></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">ตำบล</td>
<td align="left"><label id="lbl_d_tambol_id" style="width:200px">
<?
if ( $d_ampur_id ) {
$d_tambol_id = $row['d_tambol_id'];
$strSEL = "<select name=\"d_tambol_id\" id=\"d_tambol_id\" style=\"width:200px\" onchange=\"getMoo(this.value, 'd_moo_id', '')\"><option value=\"\">...</option>";
$strSQL = "SELECT * FROM ccaa WHERE ccDigi LIKE '".substr($d_ampur_id, 0, 4)."%' AND ccType='Tamboon' ORDER BY ccDigi";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $d_tambol_id ) ? "selected" : "";
$strSEL .= "<option value='".$Result->ccDigi."' $Slted>".$Result->ccName."</option>";
}
$strSEL .= "</select>";
echo $strSEL;
} else {
echo "(กรุณาเลือกอำเภอก่อน)";
}
?>
</label></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">หมู่บ้าน</td>
<td align="left"><label id="lbl_d_moo_id" style="width:200px">
<?
if ( $d_tambol_id ) {
$d_moo_id = $row['d_moo_id'];
$strSEL = "<select name=\"d_moo_id\" id=\"d_moo_id\" style=\"width:200px\"><option value=\"\">...</option>";
$strSQL = "SELECT * FROM ccaa_village WHERE ccDigi LIKE '".substr($d_tambol_id, 0, 6)."%' AND ccType='Village' ORDER BY ccDigi";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $d_moo_id ) ? "selected" : "";
$strSEL .= "<option value='".$Result->ccDigi."' $Slted>".$Result->ccName."</option>";
}
$strSEL .= "</select>";
echo $strSEL;
} else {
echo "(กรุณาเลือกตำบลก่อน)";
}
?>
</label></td>
</tr>
<tr>
<td>
<div align="left"> รหัสไปรษณีย์</div></td><td><input name="d_zipcode" id="d_zipcode" maxlength="5" size="10" type="text" value="<?=$row['d_zipcode']?>" /></td>
</tr>
<tr>
<td><div align="left">โทรศัพท์</div></td>
<td><input name="d_tel_h" id="d_tel_h" type="text" value="<?=$row['d_tel_h']?>" /></td>
</tr>
<tr>
<td><div align="left">โทรสาร</div></td>
<td><input name="d_fax" id="d_fax" type="text" value="<?=$row['d_fax']?>"/></td>
</tr>
</table>
</div>
</div>
<div class="container4">
<div class="pusher4" id="slideToggle4">สถานภาพแรงงาน <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover4">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="150px" valign="top">สถานภาพแรงงาน</td>
<td ><?
$where = "";
$sqlstatus = " SELECT labor_master_status.* , labor_personal_status.id_card , labor_personal_status.status_detail
FROM labor_master_status
LEFT JOIN labor_personal_status ON labor_master_status.status_id = labor_personal_status.status_id AND labor_personal_status.id_card='".$row['id_card']."'
";
$resstatus = mysql_query($sqlstatus);
echo "<table>";
while($rowstatus = mysql_fetch_assoc($resstatus))
{
$chked = "";
$disabled = "";
if($rowstatus['id_card'] != "")
{
$chked = "checked";
}
if($rowstatus['status_id'] != "")
{
echo "<td><input $chked type=\"checkbox\" name=\"status_id[]\" value=\"".$rowstatus['status_id']."\" >".$rowstatus['status_name'];
if($rowstatus['status_name'] == "อื่นๆ")
{
if($chked != "checked")
{
$disabled .= " disabled";
}
echo "<input $disabled type=\"textbox\" name=\"status_detail\" id=\"status_detail\" value=\"".$rowstatus['status_detail']."\" class=\"list1\">";
}
echo "</td></tr>";
}
for($i=1; $i<=1; $i++)
{
$chked = "";
$disabled = "";
$rowstatus = mysql_fetch_assoc($resstatus);
if($rowstatus['status_id'] != "")
{
if($rowstatus['id_card'] != "")
{
$chked = "checked";
}
echo "<tr>";
if($rowstatus['status_name'] == "อื่นๆ")
{
if($chked != "checked")
{
$disabled = " disabled";
}
echo "<td><input $chked type=\"checkbox\" onclick=\"document.getElementById('status_detail').disabled = (!this.checked);if(document.getElementById('status_detail').disabled ){document.getElementById('status_detail').value=''};\" name=\"status_id[]\" value=\"".$rowstatus['status_id']."\">".$rowstatus['status_name'];
echo "<input $disabled type=\"textbox\" name=\"status_detail\" id=\"status_detail\" value=\"".$rowstatus['status_detail']."\" class=\"list1\">";
}
else
{
echo "<td><input $chked type=\"checkbox\" name=\"status_id[]\" value=\"".$rowstatus['status_id']."\">".$rowstatus['status_name'];
}
echo "</td></tr>";
}
}
// $rowstatus = mysql_fetch_assoc($resstatus);
// if($rowstatus['status_id'] != "")
// {
// echo "<td><input type=\"checkbox\" name=\"status_id\">".$rowstatus['status_name'];
// if($rowstatus['status_name'] == "อื่นๆ")
// {
// echo "<input type=\"textbox\" disabled name=\"status_detail\" id=\"status_detail\" class=\"list1\">";
// }
// echo "</td>";
// }
//
// $rowstatus = mysql_fetch_assoc($resstatus);
// if($rowstatus['status_id'] != "")
// {
// echo "<td><input type=\"checkbox\" name=\"status_id\">".$rowstatus['status_name'];
// if($rowstatus['status_name'] == "อื่นๆ")
// {
// echo "<input type=\"textbox\" disabled name=\"status_detail\" id=\"status_detail\" class=\"list1\">";
// }
// echo "</td>";
// }
//
// $rowstatus = mysql_fetch_assoc($resstatus);
// if($rowstatus['status_id'] != "")
// {
// echo "<td><input type=\"checkbox\" name=\"status_id\">".$rowstatus['status_name'];
// if($rowstatus['status_name'] == "อื่นๆ")
// {
// echo "<input type=\"textbox\" disabled name=\"status_detail\" id=\"status_detail\" class=\"list1\">";
// }
// echo "</td>";
// }
}
echo "</table>";
?></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
</table>
</div>
</div>
<div class="container5">
<div class="pusher5" id="slideToggle5">ข้อมูลการทำงานในปัจจุบัน <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover5">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="150" valign="top">สถานภาพการทำงาน</td>
<td ><?
$sqlwork = "SELECT *
FROM labor_master_work_present
";
$reswork = mysql_query($sqlwork);
echo "<table>";
while($rowwork = mysql_fetch_assoc($reswork))
{
$radchk = "";
if($rowwork['work_present_id'] == $row['work_present_id'])
{
$radchk = "checked";
}
echo "<tr>";
if($rowwork['work_present_id'] != "")
{
echo "<td><input $radchk type=\"radio\" name=\"work_present_id\" value=\"".$rowwork['work_present_id']."\" >".$rowwork['detail']."</td>";
}
$rowwork = mysql_fetch_assoc($reswork);
$radchk = "";
if($rowwork['work_present_id'] == $row['work_present_id'])
{
$radchk = "checked";
}
if($rowwork['work_present_id'] != "")
{
echo "<td><input $radchk type=\"radio\" name=\"work_present_id\" value=\"".$rowwork['work_present_id']."\" >".$rowwork['detail']."</td>";
}
$rowwork = mysql_fetch_assoc($reswork);
$radchk = "";
if($rowwork['work_present_id'] == $row['work_present_id'])
{
$radchk = "checked";
}
if($rowwork['work_present_id'] != "")
{
echo "<td><input $radchk type=\"radio\" name=\"work_present_id\" value=\"".$rowwork['work_present_id']."\" >".$rowwork['detail']."</td>";
}
$rowwork = mysql_fetch_assoc($reswork);
$radchk = "";
if($rowwork['work_present_id'] == $row['work_present_id'])
{
$radchk = "checked";
}
if($rowwork['work_present_id'] != "")
{
echo "<td><input $radchk type=\"radio\" name=\"work_present_id\" value=\"".$rowwork['work_present_id']."\" >".$rowwork['detail']."</td>";
}
echo "</tr>";
}
echo "</table>";
?></td>
</tr>
<tr>
<td valign="top">ประเภทการจ้างรายได้</td>
<td ><?
$sqlemptype = "SELECT * FROM labor_master_emp_type";
$resemptype = mysql_query($sqlemptype);
echo "<table>";
while($rowemptype = mysql_fetch_assoc($resemptype))
{
$empchk = "";
if($rowemptype['emp_type_id'] == $row['emp_type_id'])
{
$empchk = "checked";
}
echo "<tr>";
if($rowemptype['emp_type_id'] != "")
{
echo "<td><input $empchk type=\"radio\" name=\"emp_type_id\" value=\"".$rowemptype['emp_type_id']."\">".$rowemptype['emp_type']."</td>";
}
$rowemptype = mysql_fetch_assoc($resemptype);
$empchk = "";
if($rowemptype['emp_type_id'] == $row['emp_type_id'])
{
$empchk = "checked";
}
if($rowemptype['emp_type_id'] != "")
{
echo "<td><input $empchk type=\"radio\" name=\"emp_type_id\" value=\"".$rowemptype['emp_type_id']."\">".$rowemptype['emp_type']."</td>";
}
$rowemptype = mysql_fetch_assoc($resemptype);
$empchk = "";
if($rowemptype['emp_type_id'] == $row['emp_type_id'])
{
$empchk = "checked";
}
if($rowemptype['emp_type_id'] != "")
{
echo "<td><input $empchk type=\"radio\" name=\"emp_type_id\" value=\"".$rowemptype['emp_type_id']."\">".$rowemptype['emp_type']."</td>";
}
$rowemptype = mysql_fetch_assoc($resemptype);
$empchk = "";
if($rowemptype['emp_type_id'] == $row['emp_type_id'])
{
$empchk = "checked";
}
if($rowemptype['emp_type_id'] != "")
{
echo "<td><input $empchk type=\"radio\" name=\"emp_type_id\" value=\"".$rowemptype['emp_type_id']."\">".$rowemptype['emp_type']."</td>";
}
$rowemptype = mysql_fetch_assoc($resemptype);
$empchk = "";
if($rowemptype['emp_type_id'] == $row['emp_type_id'])
{
$empchk = "checked";
}
if($rowemptype['emp_type_id'] != "")
{
echo "<td><input $empchk type=\"radio\" name=\"emp_type_id\" value=\"".$rowemptype['emp_type_id']."\">".$rowemptype['emp_type']."</td>";
}
$rowemptype = mysql_fetch_assoc($resemptype);
$empchk = "";
if($rowemptype['emp_type_id'] == $row['emp_type_id'])
{
$empchk = "checked";
}
if($rowemptype['emp_type_id'] != "")
{
echo "<td><input $empchk type=\"checkbox\" name=\"emp_type_id\">".$rowemptype['emp_type']."</td>";
}
echo "</tr>";
}
echo "</table>";
?></td>
</tr>
<tr>
<td valign="top">ตำแหน่ง/อาชีพ</td>
<td ><select name="position_id" id="position_id" style="width:350px">
<option value="">เลือก</option>
<?php
$sql_ori = "SELECT * FROM labor_master_position WHERE parent_id=0";
$query_ori = mysql_query($sql_ori)or die(mysql_error());
while($rows_ori = mysql_fetch_array($query_ori)){
$selected="";
if($row['position_id'] == $rows_ori['position_id'])
{
$selected = "selected";
}
?>
<option value="<?=$rows_ori['position_id']?>" <?=$selected?> >
<?=$rows_ori['position_name']?>
</option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td valign="top">อัตราค่าจ้าง/รายได้</td>
<td ><input name="salary" id="salary" type="text" value="<?=$row['salary']?>" />
บาท</td>
</tr>
<tr>
<td valign="top"><strong>สถานที่ทำงาน </strong></td>
<td > </td>
</tr>
<tr>
<td><div align="left"> เลขที่</div></td>
<td><input name="i_no" id="i_no" type="text" value="<?=$row['i_no']?>"/></td>
</tr>
<tr>
<td><div align="left">ถนน/ตรอก/ซอย</div></td>
<td><input name="i_soi" id="i_soi" type="text" value="<?=$row['i_soi']?>"/></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">จังหวัด</td>
<td align="left"><select class="list1" name="i_province_id" id="i_province_id" style="width:200px" onchange="getAmphur(this.value, 'i_ampur_id', 'i_tambol_id', 'i_moo_id', '')">
<option value="">...</option>
<?php
$i_province_id = $row['i_province_id'];
$strSQL = "SELECT * FROM ccaa WHERE ccType='Changwat' ORDER BY ccName";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $i_province_id ) ? "selected" : "";
echo "<option value=\"".$Result->ccDigi."\" $Slted>".str_replace("จังหวัด", "", $Result->ccName)."</option>";
}
?>
</select></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">อำเภอ</td>
<td align="left"><label id="lbl_i_ampur_id" style="width:200px">
<?
if ( $i_province_id ) {
$i_ampur_id = $row['i_ampur_id'];
$strSEL = "<select name=\"i_ampur_id\" id=\"i_ampur_id\" style=\"width:200px\" onchange=\"getTambol(this.value, 'i_tambol_id', 'i_moo_id', '')\"><option value=\"\">...</option>";
$strSQL = "SELECT * FROM ccaa WHERE ccDigi LIKE '".substr($i_province_id, 0, 2)."%' AND ccType='Aumpur' ORDER BY ccDigi";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $i_ampur_id ) ? "selected" : "";
$strSEL .= "<option value='".$Result->ccDigi."' $Slted>".$Result->ccName."</option>";
}
$strSEL .= "</select>";
echo $strSEL;
} else {
echo "(กรุณาเลือกจังหวัดก่อน)";
}
?>
</label></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">ตำบล</td>
<td align="left"><label id="lbl_i_tambol_id" style="width:200px">
<?
if ( $i_ampur_id ) {
$i_tambol_id = $row['i_tambol_id'];
$strSEL = "<select name=\"i_tambol_id\" id=\"i_tambol_id\" style=\"width:200px\" onchange=\"getMoo(this.value, 'i_moo_id', '')\"><option value=\"\">...</option>";
$strSQL = "SELECT * FROM ccaa WHERE ccDigi LIKE '".substr($i_ampur_id, 0, 4)."%' AND ccType='Tamboon' ORDER BY ccDigi";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $i_tambol_id ) ? "selected" : "";
$strSEL .= "<option value='".$Result->ccDigi."' $Slted>".$Result->ccName."</option>";
}
$strSEL .= "</select>";
echo $strSEL;
} else {
echo "(กรุณาเลือกอำเภอก่อน)";
}
?>
</label></td>
</tr>
<tr>
<td height="24" align="left" valign="middle">หมู่บ้าน</td>
<td align="left"><label id="lbl_i_moo_id" style="width:200px">
<?
if ( $i_tambol_id ) {
$i_moo_id = $row['i_moo_id'];
$strSEL = "<select name=\"i_moo_id\" id=\"i_moo_id\" style=\"width:200px\"><option value=\"\">...</option>";
$strSQL = "SELECT * FROM ccaa_village WHERE ccDigi LIKE '".substr($i_tambol_id, 0, 6)."%' AND ccType='Village' ORDER BY ccDigi";
$Fetch = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($Fetch) ) {
$Slted = ( $Result->ccDigi == $i_moo_id ) ? "selected" : "";
$strSEL .= "<option value='".$Result->ccDigi."' $Slted>".$Result->ccName."</option>";
}
$strSEL .= "</select>";
echo $strSEL;
} else {
echo "(กรุณาเลือกตำบลก่อน)";
}
?>
</label></td>
</tr>
<tr>
<td><div align="left"> รหัสไปรษณีย์</div></td>
<td><input name="i_postcode" id="i_postcode" type="text" value="<?=$row['i_postcode']?>" /></td>
</tr>
<tr>
<td><div align="left">โทรศัพท์</div></td>
<td><input name="i_tel_h" id="i_tel_h" type="text" value="<?=$row['i_tel_h']?>" /></td>
</tr>
<tr>
<td><div align="left">โทรสาร</div></td>
<td><input name="i_fax" id="i_fax" type="text" value="<?=$row['i_fax']?>"/></td>
</tr>
<tr>
<td valign="top">กลุ่มอุตสาหกรรมที่ทำงาน</td>
<td ><?
$sqlindustry = "SELECT * FROM labor_master_industry_group";
$resindustry = mysql_query($sqlindustry);
echo "<table>";
while($rowindustry = mysql_fetch_assoc($resindustry))
{
$indschk = "";
if($rowindustry['industry_group_id'] == $row['industry_group_id'])
{
$indschk = "checked";
}
echo "<tr valign='top'>";
if($rowindustry['industry_group_id'] != "")
{
echo "<td><input $indschk type=\"radio\" name=\"industry_group_id\" value=\"".$rowindustry['industry_group_id']."\" >".$rowindustry['detail']."</td>";
}
$rowindustry = mysql_fetch_assoc($resindustry);
$indschk = "";
if($rowindustry['industry_group_id'] == $row['industry_group_id'])
{
$indschk = "checked";
}
if($rowindustry['emp_type_id'] != "")
{
echo "<td><input $indschk type=\"radio\" name=\"industry_group_id\" value=\"".$rowindustry['industry_group_id']."\" >".$rowindustry['detail']."</td>";
}
$rowindustry = mysql_fetch_assoc($resindustry);
$indschk = "";
if($rowindustry['industry_group_id'] == $row['industry_group_id'])
{
$indschk = "checked";
}
if($rowindustry['industry_group_id'] != "")
{
echo "<td><input $indschk type=\"radio\" name=\"industry_group_id\" value=\"".$rowindustry['industry_group_id']."\" >".$rowindustry['detail']."</td>";
}
$rowindustry = mysql_fetch_assoc($resindustry);
$indschk = "";
if($rowindustry['industry_group_id'] == $row['industry_group_id'])
{
$indschk = "checked";
}
if($rowindustry['industry_group_id'] != "")
{
echo "<td><input $indschk type=\"radio\" name=\"industry_group_id\" value=\"".$rowindustry['industry_group_id']."\" >".$rowindustry['detail']."</td>";
}
$rowindustry = mysql_fetch_assoc($resindustry);
$indschk = "";
if($rowindustry['industry_group_id'] == $row['industry_group_id'])
{
$indschk = "checked";
}
if($rowindustry['industry_group_id'] != "")
{
echo "<td><input $indschk type=\"radio\" name=\"industry_group_id\" value=\"".$rowindustry['industry_group_id']."\" >".$rowindustry['detail']."</td>";
}
echo "</tr>";
}
echo "</table>";
?></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
</table>
</div>
</div>
<div class="container10">
<div class="pusher10" id="slideToggle10">สภาพร่างกาย <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover10">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="150px" valign="top">สภาพร่างกาย</td>
<?
$body1 = ""; //ปกติ
$body0 = ""; //พิการ
$body0disabled = "disabled";
if($row[body] == "1"){$body1 = "checked";}
if($row[body] == "0"){
$body0 = "checked";
$body0disabled="";
}
?>
<td width="150px" valign="top"><input <?=$body1?> type="radio" name="body" checked value="1" onclick="body_onclick(this);"/>ปกติ</td>
<td width="50px" valign="top"><input <?=$body0?> type="radio" name="body" value="0" onclick="body_onclick(this);"/>พิการ</td>
<td valign="top"><?
$where="";
$sqlpersonaldeformed = "SELECT labor_master_deformed.*,labor_personal_deformed.id_card
FROM labor_master_deformed
LEFT JOIN labor_personal_deformed ON labor_personal_deformed.deformed_id = labor_master_deformed.deformed_id AND labor_personal_deformed.id_card = '".$row[id_card]."' ";
// echo "<pre>";
// echo $sqlpersonaldeformed;
$respersonaldeformed= mysql_query($sqlpersonaldeformed);
//$rowpersonaldeformed = mysql_fetch_assoc($respersonaldeformed);
//$sqldeformed = "SELECT * FROM labor_master_deformed";
//$resdeformed = mysql_query($sqldeformed);
echo "<table>";
while($rowpersonaldeformed = mysql_fetch_assoc($respersonaldeformed))
{
$deformedchk = "";
if($rowpersonaldeformed['id_card'] != "")
{
$deformedchk = "checked";
}
echo "<tr>";
if($rowpersonaldeformed['deformed_id'] != "")
{
echo "<td><input $deformedchk $body0disabled type=\"checkbox\" name=\"deformed_id[]\" value=\"".$rowpersonaldeformed['deformed_id']."\" >".$rowpersonaldeformed['deformed_type']."</td>";
}
echo "</tr>";
}
echo "</table>";
?></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
</table>
</div>
</div>
<div class="container6">
<div class="pusher6" id="slideToggle6">ความต้องการหางาน (มีความประสงค์จะให้กรมการจัดหางาน หางานให้เมื่อผ่านการฝึกฝีมือแรงงาน) <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover6">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="150px" valign="top">ความต้องการหางาน</td>
<td ><?
$sqlstatus = "SELECT * FROM labor_master_wish_type";
$resstatus = mysql_query($sqlstatus);
echo "<table>";
while($rowstatus = mysql_fetch_assoc($resstatus))
{
$wishchk = "";
if($rowstatus['wish_type_id'] == $row['type_wish'])
{
$wishchk = "checked";
}
echo "<tr>";
if($rowstatus['wish_type_id'] != "")
{
echo "<td><input $wishchk type=\"radio\" name=\"type_wish\" value=".$rowstatus['wish_type_id']." >".$rowstatus['wish_type']."</td>";
}
echo "</tr>";
}
echo "</table>";
?></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
</table>
</div>
</div>
<div class="container7">
<div class="pusher7" id="slideToggle7">เหตุผลที่สมัครเข้าฝึก <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover7">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="150px" valign="top">เหตุผลที่สมัครเข้าฝึก</td>
<td ><?
$sqlreasonpractice = "SELECT labor_master_reason_practice.*, labor_reason_practice.id_card
FROM labor_master_reason_practice
LEFT JOIN labor_reason_practice ON labor_master_reason_practice.reason_practice_id = labor_reason_practice.reason_practice_id AND labor_reason_practice.id_card = '".$row[id_card]."'
";
$resreasonpractice = mysql_query($sqlreasonpractice);
echo "<table>";
while($rowreasonpractice = mysql_fetch_assoc($resreasonpractice))
{
$rsnchk = "";
if($rowreasonpractice['id_card'] != "")
{
$rsnchk = "checked";
}
echo "<tr valign='top'>";
if($rowreasonpractice['reason_practice_id'] != "")
{
echo "<td valign='top'><input $rsnchk type=\"checkbox\" name=\"reason_practice_id[]\" value=\"".$rowreasonpractice['reason_practice_id']."\" >".$rowreasonpractice['reason_practice']."</td>";
}
$rowreasonpractice = mysql_fetch_assoc($resreasonpractice);
$rsnchk = "";
if($rowreasonpractice['id_card'] != "")
{
$rsnchk = "checked";
}
if($rowreasonpractice['reason_practice_id'] != "")
{
echo "<td valign='top'><input $rsnchk type=\"checkbox\" name=\"reason_practice_id[]\" value=\"".$rowreasonpractice['reason_practice_id']."\" >".$rowreasonpractice['reason_practice']."</td>";
}
$rowreasonpractice = mysql_fetch_assoc($resreasonpractice);
$rsnchk = "";
if($rowreasonpractice['id_card'] != "")
{
$rsnchk = "checked";
}
if($rowreasonpractice['reason_practice_id'] != "")
{
echo "<td valign='top'><input $rsnchk type=\"checkbox\" name=\"reason_practice_id[]\" value=\"".$rowreasonpractice['reason_practice_id']."\" >".$rowreasonpractice['reason_practice']."</td>";
}
echo "</tr>";
}
echo "</table>";
?></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
</table>
</div>
</div>
<div class="container8">
<div class="pusher8" id="slideToggle8">แหล่งที่ทราบข่าว <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover8">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="150px" valign="top">แหล่งที่ทราบข่าว</td>
<td ><?
$sqlnewssource = "SELECT labor_master_news_source.*,labor_personal_news.id_card
FROM labor_master_news_source
LEFT JOIN labor_personal_news ON labor_master_news_source.news_source_id = labor_personal_news.news_source_id AND labor_personal_news.id_card = '".$row[id_card]."' AND labor_personal_news.application_type='P'
";
$resnewssource = mysql_query($sqlnewssource);
echo "<table>";
while($rownewssource = mysql_fetch_assoc($resnewssource))
{
$newschk = "";
if($rownewssource['id_card'] != "")
{
$newschk = "checked";
}
echo "<tr valign='top'>";
if($rownewssource['news_source_id'] != "")
{
echo "<td><input $newschk type=\"checkbox\" name=\"news_source_id[]\" value=\"".$rownewssource['news_source_id']."\" >".$rownewssource['news_source']."</td>";
}
$rownewssource = mysql_fetch_assoc($resnewssource);
$newschk = "";
if($rownewssource['id_card'] != "")
{
$newschk = "checked";
}
if($rownewssource['news_source_id'] != "")
{
echo "<td><input $newschk type=\"checkbox\" name=\"news_source_id[]\" value=\"".$rownewssource['news_source_id']."\" >".$rownewssource['news_source']."</td>";
}
$rownewssource = mysql_fetch_assoc($resnewssource);
$newschk = "";
if($rownewssource['id_card'] != "")
{
$newschk = "checked";
}
if($rownewssource['news_source_id'] != "")
{
echo "<td><input $newschk type=\"checkbox\" name=\"news_source_id[]\" value=\"".$rownewssource['news_source_id']."\" >".$rownewssource['news_source']."</td>";
}
echo "</tr>";
}
echo "</table>";
?></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
</table>
</div>
</div>
<div class="container9">
<div class="pusher9" id="slideToggle9">ยินยอมเปิดเผยข้อมูลส่วนบุคคล <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div>
<div class="mover9">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="150px" valign="top"> </td>
<td ><label>
<?
$opnchk = "";
$opnchk2 = "";
if($row['stu_open_personal'] == "1"){$opnchk="checked";}
if($row['stu_open_personal'] == "0"){$opnchk2="checked";}
?>
<input type="radio" <?=$opnchk?> name="stu_open_personal" value="1" />
ยินยอมเปิดเผย
<input type="radio" <?=$opnchk2?> name="stu_open_personal" value="0" />
ไม่เปิดเผย</label></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
</table>
</div>
</div>
<div id="save_data" align="center">
<input type="submit" name="submit" value="บันทึกข้อมูล" onclick="return checkForm();"/>
<input type="hidden" name="runid" id="runid" value="<?=$_GET[runid]?>"/>
<input type="reset" name="cancel" value="ยกเลิก" />
<input type="button" name="back" value="ย้อนกลับ" onclick="javascript:window.location.href='index.php?p=labor_practice'" />
</div> </td>
</tr>
</table>
</form>