|
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 : /proc/self/root/home/pathumthani_integration/integration/application/labor/ |
Upload File : |
<?
session_start();
set_time_limit(0);
include_once("../../config/config_epm.inc.php");
include_once("manage_user.inc.php");
include_once("../../inc/function.php");
include_once("function/function.inc.php");
//echo "<pre>"; print_r($_SESSION); echo "</pre>";
if ($_GET['hid_card'] ) {
$strSQL = "SELECT
labor_personal.id_card,
labor_personal.prename,
labor_personal.fname,
labor_personal.lname,
labor_personal.sex,
labor_personal.birthdate,
labor_personal.high,
labor_personal.weight,
labor_personal.nationality,
labor_personal.work_permit_no,
labor_personal.religion,
labor_personal.military,
labor_personal.military_camp,
labor_personal.military_retire,
labor_personal.d_no,
labor_personal.d_soi,
labor_personal.d_moo_id,
labor_personal.d_tambol_id,
labor_personal.d_ampur_id,
labor_personal.d_province_id,
labor_personal.d_zipcode,
labor_personal.d_tel_h,
labor_personal.d_tel_p,
labor_personal.d_fax,
labor_personal.p_no,
labor_personal.p_soi,
labor_personal.p_moo_id,
labor_personal.p_tambol_id,
labor_personal.p_ampur_id,
labor_personal.p_province_id,
labor_personal.p_zipcode,
labor_personal.p_tel_h,
labor_personal.p_tel_p,
labor_personal.p_fax,
labor_personal.gpsx,
labor_personal.gpsy,
labor_personal.status,
labor_personal.want_id,
labor_personal.working_status,
labor_personal.file_picture_name,
labor_personal.file_picture_path,
labor_personal.computer_ability,
labor_personal.other_ability,
labor_personal.reference,
labor_personal.add_date,
labor_personal.add_staffid,
labor_personal.update_date,
labor_personal.update_staffid,
labor_personal.system_id,
labor_personal.password,
labor_personal.key_gen,
labor_personal.stu_activate,
labor_personal.type_id
FROM
labor_personal
WHERE
labor_personal.id_card='".$_GET['hid_card']."'
"; #echo $strSQL;
$rsConn = mysql_query($strSQL);
$objResult = mysql_fetch_object($rsConn);
$hid_card = $objResult->id_card;
$hrun_id = $objResult->run_id;
$prename = $objResult->prename;
$fname = $objResult->fname;
$lname = $objResult->lname;
$birthdate = $objResult->birthdate;
$nationality = $objResult->nationality;
$religion = $objResult->religion;
$status = $objResult->status;
$d_no = $objResult->d_no;
$d_soi = $objResult->d_soi;
$d_moo_id = $objResult->d_moo_id;
$d_tambol_id = $objResult->d_tambol_id;
$d_ampur_id = $objResult->d_ampur_id;
$d_province_id = $objResult->d_province_id;
$d_zipcode = $objResult->d_zipcode;
$d_tel_h = $objResult->d_tel_h;
$d_tel_p = $objResult->d_tel_p;
$d_fax = $objResult->d_fax;
$p_no = $objResult->p_no;
$p_soi = $objResult->p_soi;
$p_moo_id = $objResult->p_moo_id;
$p_tambol_id = $objResult->p_tambol_id;
$p_ampur_id = $objResult->p_ampur_id;
$p_province_id = $objResult->p_province_id;
$p_zipcode = $objResult->p_zipcode;
$p_tel_h = $objResult->p_tel_h;
$p_tel_p = $objResult->p_tel_p;
$p_fax = $objResult->p_fax;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> Profile Labor </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874"></HEAD>
<style>
table tr td{
font-size:12px;
}
</style>
<BODY bgcolor="#555555">
<table width="98%" border="0" align="center" bgcolor="#FFFFFF" cellpadding="10"><tr><td><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#999999" align="center"><tr bgcolor="#FFFFFF"><td><table width="98%" border="0" align="center" bgcolor="#FFFFFF" cellpadding="10">
<tr>
<td height="286"><center>
<strong style="font-size:18px">ข้อมูลทะเบียนประวัติแรงงาน</strong>
</center>
<p/>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#999999" align="center">
<tr bgcolor="#FFFFFF">
<td><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#999999" align="center">
<tr bgcolor="#FFFFFF">
<td width="200" bgcolor="#EEEEEE" ><strong>เลขบัตรประจำตัวประชาชน</strong></td>
<td><?=pinFormat($hid_card)?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><strong>ชื่อ-นามสกุล</strong></td>
<td><?
$strSQL = "SELECT id,prename_th FROM tbl_prename WHERE id='$prename'";
$rsConn = mysql_query($strSQL);
while( $Result = mysql_fetch_array($rsConn) ) {
echo $Result['prename_th'];
} ?>
<?=$fname?>
<?=($lname)?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><strong>วันเดือนปี เกิด</strong></td>
<td><? echo dateFormat($birthdate,'thaidot');?> (อายุ
<?=birthday_year($birthdate);?>
ปี)</td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><strong>สัญชาติ</strong></td>
<td><?
$strSQL_1 = "SELECT * FROM tbl_nationality WHERE id='$nationality'";
$rsConn_1 = mysql_query($strSQL_1);
while( $Result_1 = mysql_fetch_array($rsConn_1) ) {
echo $Result_1['nationality_th'];
} ?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><strong>ศาสนา</strong></td>
<td><?
$strSQL_religion = "SELECT * FROM tbl_religion WHERE id='$religion'";
$rsConn_religion = mysql_query($strSQL_religion);
while( $Result_religion = mysql_fetch_array($rsConn_religion) ) {
echo $Result_religion['religion'];
} ?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><strong>ที่อยู่ตามทะเบียนบ้าน</strong></td>
<td><?=$d_no?>
<?=$d_soi?>
<?
$amms = mysql_query("SELECT ccDigi,ccName,ccType,ccMun FROM ccaa_pathumthani WHERE ccType='village' AND ccDigi = '$d_moo_id%' ");
while( $rams = mysql_fetch_array($amms) ) {
echo $rams['ccName'];
}?>
<?php
$amm = mysql_query("SELECT ccDigi,ccName,ccType FROM ccaa_pathumthani WHERE ccType='Tamboon' AND ccDigi ='$d_tambol_id' ");
while( $ram = mysql_fetch_array($amm) ) {
echo $ram['ccName'];
}
?>
<? $am = mysql_query("SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccType='Aumpur' AND ccDigi = '$d_ampur_id' ");
while( $ram = mysql_fetch_array($am) ) {
echo $ram['ccName'];
}?>
<? $am = mysql_query("SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccType='Changwat' AND ccDigi = '$d_province_id' ");
while( $ram = mysql_fetch_array($am) ) {
echo $ram['ccName'];
}?>
<?=$d_zipcode?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><strong>ที่อยู่ปัจจุบัน</strong></td>
<td><?=$p_no?>
<?=$p_soi?>
<?
$amms = mysql_query("SELECT ccDigi,ccName,ccType,ccMun FROM ccaa_pathumthani WHERE ccType='village' AND ccDigi = '$p_moo_id%' ");
while( $rams = mysql_fetch_array($amms) ) {
echo $rams['ccName'];
}?>
<?php
$amm = mysql_query("SELECT ccDigi,ccName,ccType FROM ccaa_pathumthani WHERE ccType='Tamboon' AND ccDigi ='$p_tambol_id' ");
while( $ram = mysql_fetch_array($amm) ) {
echo $ram['ccName'];
}
?>
<? $am = mysql_query("SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccType='Aumpur' AND ccDigi = '$p_ampur_id' ");
while( $ram = mysql_fetch_array($am) ) {
echo $ram['ccName'];
}?>
<? $am = mysql_query("SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccType='Changwat' AND ccDigi = '$p_province_id' ");
while( $ram = mysql_fetch_array($am) ) {
echo $ram['ccName'];
}?>
<?=$p_zipcode?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><strong>เบอร์โทรติดต่อ</strong></td>
<td><?=$p_tel_h?>
<?=$p_tel_p?></td>
</tr>
</table></td>
<?
$strSQL_img = "SELECT
labor_personal.id_card,
labor_personal.prename,
labor_personal.fname,
labor_personal.lname,
labor_personal.sex,
labor_personal.birthdate,
labor_personal.high,
labor_personal.weight,
labor_personal.nationality,
labor_personal.work_permit_no,
labor_personal.religion,
labor_personal.military,
labor_personal.military_camp,
labor_personal.military_retire,
labor_personal.d_no,
labor_personal.d_soi,
labor_personal.d_moo_id,
labor_personal.d_tambol_id,
labor_personal.d_ampur_id,
labor_personal.d_province_id,
labor_personal.d_zipcode,
labor_personal.d_tel_h,
labor_personal.d_tel_p,
labor_personal.d_fax,
labor_personal.p_no,
labor_personal.p_soi,
labor_personal.p_moo_id,
labor_personal.p_tambol_id,
labor_personal.p_ampur_id,
labor_personal.p_province_id,
labor_personal.p_zipcode,
labor_personal.p_tel_h,
labor_personal.p_tel_p,
labor_personal.p_fax,
labor_personal.gpsx,
labor_personal.gpsy,
labor_personal.status,
labor_personal.want_id,
labor_personal.working_status,
labor_personal.file_picture_name,
labor_personal.file_picture_path,
labor_personal.computer_ability,
labor_personal.other_ability,
labor_personal.reference,
labor_personal.add_date,
labor_personal.add_staffid,
labor_personal.update_date,
labor_personal.update_staffid,
labor_personal.system_id,
labor_personal.password,
labor_personal.key_gen,
labor_personal.stu_activate,
labor_personal.type_id
FROM
labor_personal
WHERE
labor_personal.id_card='".$_GET['hid_card']."'
"; #echo $strSQL;
$rsConn_img = mysql_query($strSQL_img);
$objResult_img = mysql_fetch_assoc($rsConn_img);
?>
<td align="center" valign="top"> <span id="TXTIMAGE">
<?
if($objResult_img ['file_picture_name']){
echo '<img src="';
echo 'files_image/'.$objResult_img ['file_picture_name'];
echo '" align="absmiddle" width="150" height="180" border="0" onclick="window.open(\'';
echo 'files_image/'.$objResult_img ['file_picture_name'];
echo '\')" style="cursor:pointer" />';
}else{
echo '<img src="img/nopicture.gif" align="absmiddle" width="150" />';
}
?>
</span>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#999999" align="center">
<tr bgcolor="CCCCCC">
<td colspan="6"><strong>การศึกษา</strong></td>
</tr>
<tr bgcolor="EEEEEE" align="center">
<td width="10%"><strong>ปีที่สำเร็จการศึกษา</strong></td>
<td width="15%"><strong>สาขาวิชาที่เรียน</strong></td>
<td width="20%"><strong>คณะ/แผนกวิชา</strong></td>
<td width="10%"><strong>ระดับ</strong></td>
<td width="10%"><strong>เกรดเฉลี่ย</strong></td>
<td width="25%"><strong>ชื่อสถานศึกษา</strong></td>
</tr>
<?
if ($_GET['hid_card']) {
$sql_edu="SELECT
labor_personal_education.runid,
labor_personal_education.id_card,
labor_personal_education.education_id,
labor_personal_education.school_id,
labor_personal_education.school_outsite,
labor_personal_education.qualification,
labor_personal_education.branch,
labor_personal_education.major,
labor_personal_education.graudated_year,
labor_personal_education.gpa,
labor_personal_education.file_transcrip_name,
labor_personal_education.file_transcrip_path
FROM
labor_personal_education
WHERE labor_personal_education.id_card='".$_GET['hid_card']."' ORDER BY labor_personal_education.graudated_year DESC
";
$result_edu=mysql_query($sql_edu);
$i=0;
while($res_edu=mysql_fetch_assoc($result_edu))
{
$i++;
?>
<tr bgcolor="#FFFFFF">
<td align="center"><?=$res_edu['graudated_year']?></td>
<td><?=$res_edu['major']?></td>
<td><?=$res_edu['branch']?></td>
<td><? $sql="SELECT
tbl_education_level.educ_id,
tbl_education_level.education,
tbl_education_level.level,
tbl_education_level.staffid
FROM
tbl_education_level
WHERE tbl_education_level.educ_id='".$res_edu['education_id']."'
";
$rec=mysql_query($sql);
$res_level=mysql_fetch_assoc($rec);
echo $res_level['education'];
?></td>
<td align="center"><?=$res_edu['gpa']?></td>
<td><?
$sql_name=" SELECT * FROM labor_master_school WHERE school_id='".$res_edu['school_id']."'
";
$result_name=mysql_query($sql_name);
$res_name=mysql_fetch_assoc($result_name);
echo $res_name['school_name'];
?></td>
</tr>
<?
}
} ?>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#999999" align="center">
<tr bgcolor="#CCCCCC" >
<td colspan="11" ><strong>ความสามารถด้านภาษา</strong></td>
</tr>
<tr bgcolor="#EEEEEE" align="center">
<td rowspan="2" ><strong>ภาษา</strong></td>
<td colspan="3"><strong>พูด</strong></td>
<td colspan="3"><strong>อ่าน</strong></td>
<td colspan="3"><strong>เขียน</strong></td>
<td width="9%" colspan="1" rowspan="2"><strong>ความเร็ว ในการพิมพ์</strong><strong>(คำ/นาที)</strong></td>
</tr>
<tr bgcolor="#EEEEEE" align="center">
<td width="9%"><strong>ดีมาก</strong></td>
<td width="9%"><strong>ดี</strong></td>
<td width="9%"><strong>พอใช้</strong></td>
<td width="9%"><strong>ดีมาก</strong></td>
<td width="9%"><strong>ดี</strong></td>
<td width="9%"><strong>พอใช้</strong></td>
<td width="9%"><strong>ดีมาก</strong></td>
<td width="9%"><strong>ดี</strong></td>
<td width="9%"><strong>พอใช้น้อย</strong></td>
</tr>
<?
$sql_language="SELECT
labor_personal_language.id_card,
labor_personal_language.t_language_id,
labor_personal_language.level_speak,
labor_personal_language.level_read,
labor_personal_language.level_write,
labor_personal_language.type_rate
FROM
labor_personal_language
WHERE labor_personal_language.id_card ='".$_GET['hid_card']."'
";
$result_conn=mysql_query( $sql_language);
$i=0;
while($res_lang=mysql_fetch_array($result_conn))
{
$i++;
?>
<tr bgcolor="#FFFFFF">
<td><? $sql_sub="SELECT
labor_master_language.language_id,
labor_master_language.language_name
FROM
labor_master_language
where labor_master_language.language_id ='".$res_lang['t_language_id']."'
";
$result_con=mysql_query( $sql_sub);
$res_sub=mysql_fetch_assoc($result_con);
echo $res_sub['language_name'];
?></td>
<td align="center"><input type="radio" <?=($res_lang['level_speak']=='ดีมาก')?"CHECKED":""?>></td>
<td align="center"><input type="radio"<?=($res_lang['level_speak']=='ดี')?"CHECKED":""?>></td>
<td align="center"><input type="radio" <?=($res_lang['level_speak']=='พอใช้')?"CHECKED":""?>></td>
<td align="center"><input type="radio" <?=($res_lang['level_read']=='ดีมาก')?"CHECKED":""?>></td>
<td align="center"><input type="radio"<?=($res_lang['level_read']=='ดี')?"CHECKED":""?>></td>
<td align="center"><input type="radio" <?=($res_lang['level_read']=='พอใช้')?"CHECKED":""?>></td>
<td align="center"><input type="radio" <?=($res_lang['level_write']=='ดีมาก')?"CHECKED":""?>></td>
<td align="center"><input type="radio"<?=($res_lang['level_write']=='ดี')?"CHECKED":""?>></td>
<td align="center"><input type="radio" <?=($res_lang['level_write']=='พอใช้')?"CHECKED":""?>></td>
<td align="center"><?=$res_lang['type_rate'];?></td>
</tr>
<? }?>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#999999">
<tr bgcolor="#CCCCCC" >
<td colspan="2"><strong>ความสามารถพิเศษ</strong></td>
</tr>
<?
$sql_other="SELECT
labor_personal.id_card,
labor_personal.other_ability
FROM
labor_personal
WHERE labor_personal.id_card='".$_GET['hid_card']."'
";
$resCon=mysql_query( $sql_other);
$i=0;
while($result=mysql_fetch_array($resCon))
{
$i++;
?>
<? if($result['other_ability']!=""){?>
<tr bgcolor="#FFFFFF">
<td width="50" align="center"><?=$i?></td>
<td><?=$result['other_ability']?></td>
</tr>
<? }
}?>
</table>
</table></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#999999" align="center">
<tr bgcolor="CCCCCC">
<td ><strong>ตำแหน่งงานและเงินเดือนที่ต้องการ</strong></td>
</tr>
<tr bgcolor="#FFFFFF">
<td >
<table width="95%" border="0" align="center">
<tr bgcolor="<?=$color?>">
<td colspan="6"><strong>ตำแหน่งงานที่ต้องการ</strong></td>
</tr>
<?
$sql_position="SELECT
labor_personal_typework.id_card,
labor_personal_typework.position_id,
labor_personal_typework.salary_from,
labor_personal_typework.salary_to,
labor_personal_typework.unit_id
FROM
labor_personal_typework
WHERE labor_personal_typework.id_card='".$_GET['hid_card']."'
";
$res_position=mysql_query($sql_position);
$i=0;
while($resposition=mysql_fetch_array($res_position)){
$i++;
?>
<? if($_GET['app']=='labor_jobless_index'){
$color="#66FF66";
} else {
$color="#FFFFFF";
} ?>
<tr bgcolor="<?=$color?>">
<tr>
<td width="50" align="center"><?=$i?></td>
<td><? $sql_po="SELECT
labor_master_position.position_id,
labor_master_position.position_type_id,
labor_master_position.parent_id,
labor_master_position.position_name
FROM
labor_master_position
WHERE
labor_master_position.position_type_id='".$resposition['position_id']."'
";
$respo=mysql_query( $sql_po);
$res_po=mysql_fetch_array($respo);
?> <? if($res_po['position_name']!=""){
echo $res_po['position_name'];
}else {
echo "ไม่ระบุ";
}?>
</td>
</tr>
<? }?>
</table>
<table width="95%" border="0" align="center">
<tr>
<td colspan="2"><strong>เงินเดือนที่ต้องการ</strong></td>
</tr>
<?
$sql_salary="SELECT
labor_personal_typework.id_card,
labor_personal_typework.position_id,
labor_personal_typework.salary_from,
labor_personal_typework.salary_to,
labor_personal_typework.unit_id
FROM
labor_personal_typework
WHERE labor_personal_typework.id_card='".$_GET['hid_card']."'
";
$res_salary=mysql_query($sql_salary);
$ressalary=mysql_fetch_assoc($res_salary);
?>
<?
$sql_unit="SELECT * FROM labor_master_unit where unit_id='$ressalary[unit_id]' ";
$resS=mysql_query($sql_unit);
$res_unit=mysql_fetch_assoc($resS);
?>
<tr>
<td width="50" align="center"> </td>
<td><? if($ressalary['salary_from']!=""){
echo "".$ressalary['salary_from']." - ".$ressalary['salary_to']." บาท ต่อ ".$res_unit['detail'];
}else {
echo "ไม่ระบุ";
}?></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#999999" align="center">
<tr bgcolor="CCCCCC">
<td colspan="5"><strong>ข้อมูลทะเบียนประวัติ</strong></td>
</tr>
<tr bgcolor="EEEEEE" align="center">
<td width="14%"><strong>วันที่</strong></td>
<td width="49%"><strong>รายการ</strong></td>
<td width="21%"><strong>หน่วยงาน</strong></td>
<td width="16%"><strong>สถานะ</strong></td>
</tr> <?
$sql_edu1="SELECT
labor_personal_education.runid,
labor_personal_education.id_card,
labor_personal_education.education_id,
labor_personal_education.school_id,
labor_personal_education.school_outsite,
labor_personal_education.qualification,
labor_personal_education.branch,
labor_personal_education.major,
labor_personal_education.graudated_year,
labor_personal_education.gpa,
labor_personal_education.file_transcrip_name,
labor_personal_education.file_transcrip_path
FROM
labor_personal_education
WHERE labor_personal_education.id_card='".$_GET['hid_card']."' ORDER BY labor_personal_education.graudated_year DESC
";
$result_edu1=mysql_query($sql_edu1);
$i=0;
while($res_edu1=mysql_fetch_array($result_edu1)){
$i++;
?>
<? if($res_edu1['graudated_year']!=""){ ?>
<tr bgcolor="#FFFFFF">
<td align="center"><?=$res_edu1['graudated_year']?></td>
<td>สำเร็จการศึกษา ระดับ
<? $sql_1="SELECT
tbl_education_level.educ_id,
tbl_education_level.education,
tbl_education_level.level,
tbl_education_level.staffid
FROM
tbl_education_level
WHERE tbl_education_level.educ_id='".$res_edu1['education_id']."'
";
$rec_1=mysql_query($sql_1);
$res_level1=mysql_fetch_assoc($rec_1);
echo $res_level1['education'];?> สาขา<?=$res_edu1['major']?> <?
$sql_name1=" SELECT * FROM labor_master_school WHERE school_id='".$res_edu1['school_id']."'
";
$result_name1=mysql_query($sql_name1);
$res_name1=mysql_fetch_assoc($result_name1);
echo $res_name1['school_name'];
?></td>
<td><? if($res_edu1['graudated_year']!=""){
echo "สถาบันการศึกษา";
} ?></td>
<td align="center"><? $str_status = "SELECT
labor_personal.id_card,
labor_personal.type_id,
labor_master_type.labor_type_id,
labor_master_type.labor_type_name
FROM
labor_personal
Inner Join labor_master_type ON labor_personal.type_id = labor_master_type.labor_type_id
WHERE
labor_personal.type_id = labor_master_type.labor_type_id
";
$res_status=mysql_query($str_status);
$resstat=mysql_fetch_assoc($res_status);
echo $resstat['labor_type_name'];
?></td>
</tr><? }
}?>
<?
$sql_surety="SELECT
labor_social_security.run_id,
labor_social_security.id_card,
labor_social_security.status,
labor_social_security.add_date,
labor_social_security.add_staffid,
labor_social_security.add_status,
labor_social_security.update_date,
labor_social_security.update_staffid,
labor_social_security.labor_system_runid
FROM
labor_social_security
WHERE labor_social_security.id_card='".$_GET['hid_card']."' ORDER BY labor_social_security.add_date DESC
";
$rescon_surety=mysql_query( $sql_surety);
$i=0;
while( $result=mysql_fetch_assoc($rescon_surety)){
$i++;
?>
<? if($_GET['app']=='labor_surety'){
$color="#66FF66";
} else {
$color="#FFFFFF";
} ?>
<tr bgcolor="<?=$color?>">
<td align="center"><?=dateFormat($result['add_date'],'thaidot');?></td>
<td>ขึ้นทะเบียนประกันตน</td>
<td><? if($result['add_date']!=""){
echo "สำนักงานประกันสังคม";
} ?></td>
<td align="center"><? if($result['status']=='A'){
echo "เป็นผู้ประกันตน";
} else if($result['status']=='V'){
echo "เป็นผู้ประกันตนตนโดยสมัครใจ";
} else if($result['status']=='R'){
echo "ลาออกจากงาน";
} else if($result['status']=='O'){
echo "อื่นๆ ไม่ระบุ"; } ?></td>
</tr>
<? }?>
<?
$sql_unemployed="SELECT
labor_unemployed.type_id,
labor_unemployed.id_card,
labor_unemployed.want_room,
labor_unemployed.work_country,
labor_unemployed.reason_resign,
labor_unemployed.reason_resign_etc,
labor_unemployed.reason_layoff,
labor_unemployed.reason_layoff_etc,
labor_unemployed.deformed_register,
labor_unemployed.deformed_level,
labor_unemployed.deformed_kind,
labor_unemployed.deformed_reactivate,
labor_unemployed.result_test_en,
labor_unemployed.result_test_score,
labor_unemployed.stu_open_contracting,
labor_unemployed.stu_open_directsale,
labor_unemployed.file_picture_name,
labor_unemployed.file_picture_path,
labor_unemployed.add_date,
labor_unemployed.add_staffid,
labor_unemployed.add_status,
labor_unemployed.update_date,
labor_unemployed.update_staffid,
labor_unemployed.system_id,
labor_unemployed.register_date,
labor_unemployed.type_service
FROM
labor_unemployed
WHERE labor_unemployed.id_card='".$_GET['hid_card']."' ORDER BY labor_unemployed.register_date DESC
";
$rescon_unemployed=mysql_query($sql_unemployed);
$i=0;
while($result_unemployed=mysql_fetch_array($rescon_unemployed)){
$i++;
?>
<? if($_GET['app']=='labor_jobless_index'){
$color="#66FF66";
} else {
$color="#FFFFFF";
} ?>
<tr bgcolor="<?=$color?>">
<td align="center"><?= dateFormat($result_unemployed['register_date'],'thaidot');?></td>
<td>ผู้ลงทะเบียนคนว่างงาน</td>
<td><? if($result_unemployed['register_date']!=""){
echo "สำนักงานจัดหางาน";
} ?></td>
<td align="center"><? $str_status11 = "SELECT
labor_personal.id_card,
labor_personal.type_id,
labor_master_type.labor_type_id,
labor_master_type.labor_type_name
FROM
labor_personal
Inner Join labor_master_type ON labor_personal.type_id = labor_master_type.labor_type_id
WHERE
labor_personal.type_id = labor_master_type.labor_type_id AND labor_personal.id_card ='".$_GET['hid_card']."'
";
$res_status11=mysql_query($str_status11);
$resstat11=mysql_fetch_assoc($res_status11);
echo $resstat11['labor_type_name'];
?></td>
</tr>
<? }?>
<? $sql_train="SELECT
labor_trainning_course.runid,
labor_trainning_course.course_activity_id,
labor_trainning_course.branch_id,
labor_trainning_course.course_id,
labor_trainning_course.division,
labor_trainning_course.id_card,
labor_trainning_course.work_present_id,
labor_trainning_course.emp_type_id,
labor_trainning_course.salary,
labor_trainning_course.i_no,
labor_trainning_course.i_soi,
labor_trainning_course.i_moo_id,
labor_trainning_course.i_tambol_id,
labor_trainning_course.i_ampur_id,
labor_trainning_course.i_province_id,
labor_trainning_course.i_postcode,
labor_trainning_course.i_tel_h,
labor_trainning_course.i_tel_p,
labor_trainning_course.i_fax,
labor_trainning_course.industry_group_id,
labor_trainning_course.type_wish,
labor_trainning_course.position_id,
labor_trainning_course.industry_group_id2,
labor_trainning_course.country,
labor_trainning_course.body,
labor_trainning_course.register_date,
labor_trainning_course.stu_open_personal,
labor_trainning_course.add_date,
labor_trainning_course.add_staffid,
labor_trainning_course.add_status,
labor_trainning_course.update_date,
labor_trainning_course.update_staffid,
labor_trainning_course.stu_data,
labor_trainning_course.`status`,
labor_trainning_course.system_id
FROM
labor_trainning_course
WHERE labor_trainning_course.id_card='".$_GET['hid_card']."' ORDER BY labor_trainning_course.add_date DESC
";
$resContrain=mysql_query($sql_train);
$i=0;
while($restrain=mysql_fetch_array($resContrain)){
$i++;
?>
<? if($_GET['app']=='labor_practic'){
$color="#66FF66";
} else {
$color="#FFFFFF";
} ?>
<? if($restrain['course_activity_id']!=""){?>
<tr bgcolor="<?=$color?>">
<td align="center"><?=dateFormat($restrain['register_date'],'thaidot');?></td>
<td><? $sql_couse="SELECT
labor_course_training.course_training_id,
labor_course_training.course_year,
labor_course_training.course_name,
labor_course_training.course_name_en,
labor_course_training.project,
labor_course_training.training_place,
labor_course_training.course_activity_id,
labor_course_training.course_sub_activity_id,
labor_course_training.course_group_id,
labor_course_training.course_branch_id,
labor_course_training.course_work_id,
labor_course_training.course_period,
labor_course_training.company_period
FROM
labor_course_training
WHERE labor_course_training.course_training_id='$restrain[course_activity_id]'
";
$res_couse=mysql_query( $sql_couse);
$resCouse=mysql_fetch_assoc($res_couse);
echo $resCouse['course_name'];
?></td>
<td><? if($restrain['register_date']!=""){
echo "สำนักงานพัฒนาฝีมือแรงงาน";
} ?></td>
<td align="center"><? $str_status1 = "SELECT
labor_personal.id_card,
labor_personal.type_id,
labor_master_type.labor_type_id,
labor_master_type.labor_type_name
FROM
labor_personal
Inner Join labor_master_type ON labor_personal.type_id = labor_master_type.labor_type_id
WHERE
labor_personal.type_id = labor_master_type.labor_type_id AND labor_personal.id_card ='".$_GET['hid_card']."'
";
$res_status1=mysql_query($str_status1);
$resstat1=mysql_fetch_assoc($res_status1);
echo $resstat1['labor_type_name'];
?></td>
</tr>
<? }
}?>
<? $sql_test="SELECT
labor_test_course.test_course_id,
labor_test_course.test_type_id,
labor_test_course.company_id,
labor_test_course.branch_id,
labor_test_course.work_id,
labor_test_course.date_announce,
labor_test_course.date_expire,
labor_test_course.division,
labor_test_course.test_level,
labor_test_course.id_card,
labor_test_course.work_present_id,
labor_test_course.emp_type_id,
labor_test_course.salary,
labor_test_course.i_no,
labor_test_course.i_soi,
labor_test_course.i_moo_id,
labor_test_course.i_tambol_id,
labor_test_course.i_ampur_id,
labor_test_course.i_province_id,
labor_test_course.i_postcode,
labor_test_course.i_tel_h,
labor_test_course.i_tel_p,
labor_test_course.i_fax,
labor_test_course.industry_group_id,
labor_test_course.wish_type_id,
labor_test_course.position_id,
labor_test_course.industry_group_id2,
labor_test_course.country,
labor_test_course.company_exam,
labor_test_course.j_no,
labor_test_course.j_soi,
labor_test_course.j_moo_id,
labor_test_course.j_tambol_id,
labor_test_course.j_ampur_id,
labor_test_course.j_province_id,
labor_test_course.j_postcode,
labor_test_course.j_tel_h,
labor_test_course.j_tel_p,
labor_test_course.j_fax,
labor_test_course.inter_company_name,
labor_test_course.company_togo,
labor_test_course.time_employment,
labor_test_course.stu_open_personal,
labor_test_course.register_date,
labor_test_course.add_date,
labor_test_course.add_staffid,
labor_test_course.add_status,
labor_test_course.update_date,
labor_test_course.update_staffid,
labor_test_course.system_id,
labor_master_test_type.test_type_id,
labor_master_test_type.test_type
FROM
labor_test_course
Inner Join labor_master_test_type ON labor_test_course.test_type_id = labor_master_test_type.test_type_id
WHERE labor_test_course.id_card='".$_GET['hid_card']."' ORDER BY labor_test_course.add_date DESC
";
$resContrain_1=mysql_query($sql_test);
$i=0;
while($res_test=mysql_fetch_array($resContrain_1)){
$i++;
?>
<? if($_GET['app']=='labor_exam'){
$color="#66FF66";
} else {
$color="#FFFFFF";
} ?>
<? if($res_test['register_date']!=""){?>
<tr bgcolor="<?=$color?>">
<td align="center"><?=dateFormat($res_test['register_date'],'thaidot');?></td>
<td><?
echo $res_test['test_type'];
?></td>
<td><? if($res_test['register_date']!=""){
echo "สำนักงานพัฒนาฝีมือแรงงาน";
} ?></td>
<td align="center"><? $str_status3 = "SELECT
labor_personal.id_card,
labor_personal.type_id,
labor_master_type.labor_type_id,
labor_master_type.labor_type_name
FROM
labor_personal
Inner Join labor_master_type ON labor_personal.type_id = labor_master_type.labor_type_id
WHERE
labor_personal.type_id = labor_master_type.labor_type_id AND labor_personal.id_card ='".$_GET['hid_card']."'
";
$res_status3=mysql_query($str_status3);
$resstat3=mysql_fetch_assoc($res_status3);
echo $resstat3['labor_type_name'];
?></td>
</tr>
<? }
}?>
<? $sql_dis="SELECT
labor_dismissal.dismissal_id,
labor_dismissal.register_date,
labor_dismissal.register_place,
labor_dismissal.id_card,
labor_dismissal.workpermit_no,
labor_dismissal.protest_agent,
labor_dismissal.d_prename,
labor_dismissal.d_name,
labor_dismissal.d_surname,
labor_dismissal.d_idcard,
labor_dismissal.death_certificate,
labor_dismissal.dc_source,
labor_dismissal.d_nationality,
labor_dismissal.d_workpermit,
labor_dismissal.concerned,
labor_dismissal.company,
labor_dismissal.owner_prename,
labor_dismissal.owner_name,
labor_dismissal.owner_surname,
labor_dismissal.business_type,
labor_dismissal.c_address_no,
labor_dismissal.c_soi,
labor_dismissal.c_moo_id,
labor_dismissal.c_tambol_id,
labor_dismissal.c_ampur_id,
labor_dismissal.c_province_id,
labor_dismissal.c_postcode,
labor_dismissal.c_tel_h,
labor_dismissal.c_nearby,
labor_dismissal.e_no,
labor_dismissal.e_soi,
labor_dismissal.e_moo_id,
labor_dismissal.e_tambol_id,
labor_dismissal.e_ampur_id,
labor_dismissal.e_province_id,
labor_dismissal.e_postcode,
labor_dismissal.e_tel_h,
labor_dismissal.e_nearby,
labor_dismissal.e_fromdate,
labor_dismissal.e_todate,
labor_dismissal.e_job_position_group,
labor_dismissal.e_job_position,
labor_dismissal.e_division,
labor_dismissal.e_boss_prename,
labor_dismissal.e_boss_name,
labor_dismissal.e_boss_surname,
labor_dismissal.e_pay_status,
labor_dismissal.e_pay,
labor_dismissal.e_pay_unit,
labor_dismissal.e_pay_per_unit,
labor_dismissal.e_pay_other,
labor_dismissal.e_pay_other2,
labor_dismissal.e_pay_other2_unit,
labor_dismissal.work_week,
labor_dismissal.work_hour,
labor_dismissal.fromtime,
labor_dismissal.totime,
labor_dismissal.break_fromtime,
labor_dismissal.break_totime,
labor_dismissal.pay_time,
labor_dismissal.pay_ot_time,
labor_dismissal.pay_holiday_time,
labor_dismissal.pay_holiday_ot_time,
labor_dismissal.request_reason,
labor_dismissal.request_choice_1,
labor_dismissal.request_choice_2,
labor_dismissal.request_choice_3,
labor_dismissal.request_choice_4,
labor_dismissal.request_choice_5,
labor_dismissal.request_choice_6,
labor_dismissal.request_choice_7,
labor_dismissal.request_choice_8,
labor_dismissal.request_choice_9,
labor_dismissal.request_choice_10,
labor_dismissal.request_choice_11,
labor_dismissal.request_choice_12,
labor_dismissal.request_choice_13,
labor_dismissal.request_choice_14,
labor_dismissal.request_fromdate,
labor_dismissal.request_todate,
labor_dismissal.request_cost,
labor_dismissal.minimum_wage,
labor_dismissal.standard_wage,
labor_dismissal.retire_wage,
labor_dismissal.ot_fromdate,
labor_dismissal.ot_todate,
labor_dismissal.ot_cost,
labor_dismissal.holiday_wage_fromdate,
labor_dismissal.holiday_wage_todate,
labor_dismissal.holiday_cost,
labor_dismissal.holiday_ot_fromdate,
labor_dismissal.holiday_ot_todate,
labor_dismissal.holiday_ot_cost,
labor_dismissal.compensation_fromdate,
labor_dismissal.compensation_todate,
labor_dismissal.compensation,
labor_dismissal.extra_compensation_fromdate,
labor_dismissal.extra_compensation_todate,
labor_dismissal.extra_compensation,
labor_dismissal.retire_compensation_day,
labor_dismissal.retire_compensation,
labor_dismissal.secutity_cost,
labor_dismissal.other_cost,
labor_dismissal.interest_cost,
labor_dismissal.plus_cost,
labor_dismissal.place_of_pay,
labor_dismissal.org_site,
labor_dismissal.org_province,
labor_dismissal.other_identify,
labor_dismissal.add_date,
labor_dismissal.add_staffid,
labor_dismissal.add_status,
labor_dismissal.update_date,
labor_dismissal.update_staffid,
labor_dismissal.system_id
FROM
labor_dismissal
WHERE labor_dismissal.id_card='".$_GET['hid_card']."'
";
$res_dis=mysql_query($sql_dis);
$i=0;
while($resDis=mysql_fetch_array($res_dis)){
$i++;
?>
<? if($_GET['app']=='labor_layoff_index'){
$color="#66FF66";
} else {
$color="#FFFFFF";
} ?>
<? if($resDis['register_date']!=""){?>
<tr bgcolor="<?=$color?>">
<td align="center" valign="top"><?=dateFormat($resDis['register_date'],'thaidot'); ?></td>
<td valign="top">
<?=$resDis['company']?>
<BR/>
<?php /*?><table width="99%" border="0" cellpadding="2" cellspacing="1" bgcolor="#999999" align="center">
<tr bgcolor="#EEEEEE">
<td colspan="4"> การให้ความช่วยเหลือ</td>
</tr>
<tr bgcolor="#EEEEEE" align="center">
<td width="50">ครั้งที่</td>
<td width="100">วันที่</td>
<td>การช่วยเหลือ</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center">1</td>
<td align="center">3 เม.ย. 2553</td>
<td>มอบเงินค่าครองชีพรายเดือน เดือนละ 3,500 บาท</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center">2</td>
<td align="center">3 พ.ย. 2553</td>
<td>มอบเงินค่าครองชีพรายเดือน เดือนละ 3,500 บาท</td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center">2</td>
<td align="center">3 มิ.ย. 2553</td>
<td>มอบเงินค่าครองชีพรายเดือน เดือนละ 3,500 บาท</td>
</tr>
</table><?php */?>
<BR/> </td>
<td valign="top"><? if($resDis['register_date']!="") {
echo "กรมสวัสดิการและคุ้มครองแรงงาน";
} ?></td>
<td align="center" valign="top"><?
$str_status2 = "SELECT
labor_personal.id_card,
labor_personal.type_id,
labor_master_type.labor_type_id,
labor_master_type.labor_type_name
FROM
labor_personal
Inner Join labor_master_type ON labor_personal.type_id = labor_master_type.labor_type_id
WHERE
labor_personal.type_id = labor_master_type.labor_type_id and labor_personal.id_card='".$_GET['hid_card']."'
";
$res_status2=mysql_query($str_status2);
$resstat2=mysql_fetch_assoc($res_status2);
echo $resstat2['labor_type_name'];
?></td>
</tr>
<? }
}?>
</table>
<p/>
<p/>
</td>
</tr>
</table>
</BODY>
</HTML>
<script language="javascript">
function date_Format($value,$type){
if($value == "0000-00-00")
{
return "-";
}
if($type=="engthai"){
$day = explode("-",$value);
$date = $day[2].'-'.$day[1].'-'.($day[0]+543);
}else if($type=="thaieng"){
$day = explode("-",$value);
$date = ($day[2]-543).'-'.$day[1].'-'.$day[0];
}else if($type=="thaidot"){
$Month = array("", "ม.ค.", "ก.พ.", "มี.ค.", "เม.ย.", "พ.ค.", "มิ.ย.", "ก.ค.", "ส.ค.", "ก.ย.", "ต.ค.", "พ.ย.", "ธ.ค.");
$day = explode("-",$value);
$Y = $day[0];
$m = $day[1];
if($m<10){
$m = str_replace("0","",$m);
}
$d = $day[2]*1;
$date = $d.' '.$Month[$m].' '.($Y+543);
}else if($type==""){
$date = explode("-",$value);
}
return $date;
}
</script>