<?=$webpage_title?> - <?=$MENU_TITLE_LV0?><?if($MENU_ID_LV1){?> - <?=$MENU_TITLE_LV1?><?}?><?if($MENU_ID_LV2){?> - <?=$MENU_TITLE_LV2?><?}?><?if($MENU_ID_LV3){?>

:
:	:
:		onClick="form1.search_org_id.value='';form1.search_org_name.value=''; "> onClick="form1.search_org_id.value='';form1.search_org_name.value=''; ">

"> ข้อมูลทั่วไป

"> ตำแหน่งปัจจุบัน

"> ประวัติการดำรงตำแหน่ง

"> ประวัติการศึกษา

"> ประวัติการอบรม/ดูงาน

"> ความดีความชอบ

"> ราชการพิเศษ

"> การลา

"> เครื่องราชฯ

"> เงินเดือน

พบข้อมูลทั้งสิ้น รายการ

1){ if($DPISDB=="odbc"){ if($search_per_type==1){ $cmd = " select top $start_record trim(PER_ID) as concat_pk from ( ( PER_PERSONAL a left join PER_POSITION b on (a.POS_ID=b.POS_ID) ) left join PER_ORG f on (b.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition order by PER_NAME, PER_SURNAME "; }elseif($search_per_type==2){ $cmd = " select top $start_record trim(PER_ID) as concat_pk from ( ( PER_PERSONAL a left join PER_POS_EMP c on (a.POEM_ID=c.POEM_ID) ) left join PER_ORG f on (c.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition order by PER_NAME, PER_SURNAME "; }elseif($search_per_type==3){ $cmd = " select top $start_record trim(PER_ID) as concat_pk from ( ( PER_PERSONAL a left join PER_POS_EMPSER d on (a.POEMS_ID=d.POEMS_ID) ) left join PER_ORG f on (d.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition order by PER_NAME, PER_SURNAME "; } elseif($search_per_type==4){ $cmd = " select top $start_record trim(PER_ID) as concat_pk from ( ( PER_PERSONAL a left join PER_POS_TEMP e on (a.POT_ID=e.POT_ID) ) left join PER_ORG f on (e.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition order by PER_NAME, PER_SURNAME "; } // end if $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_exclude[] = $data[concat_pk]; $limit_data = (trim($search_condition)?" and ":" where ")." trim(PER_ID) not in (". implode(", ", $arr_exclude) .")"; }elseif($DPISDB=="mysql"){ $limit_data = " limit " . (($current_page - 1) * $data_per_page) . ", " . $data_per_page; } // end if } // end if if($DPISDB=="odbc"){ if($search_per_type==1){ $cmd = " select top $data_per_page a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POS_ID, b.POS_NO_NAME, b.POS_NO, b.PL_CODE, b.PM_CODE, b.ORG_ID, b.ORG_ID_1, b.PT_CODE, a.DEPARTMENT_ID from ( ( PER_PERSONAL a left join PER_POSITION b on (a.POS_ID=b.POS_ID) ) left join PER_ORG f on (b.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition $limit_data order by $order_str "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("b.ORG_ID", "a.ORG_ID", $cmd); } }elseif($search_per_type==2){ $cmd = " select top $data_per_page a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POEM_ID as POS_ID, c.POEM_NO_NAME as POS_NO_NAME, c.POEM_NO as POS_NO, c.PN_CODE as PL_CODE, c.ORG_ID, c.ORG_ID_1, a.DEPARTMENT_ID from ( ( PER_PERSONAL a left join PER_POS_EMP c on (a.POEM_ID=c.POEM_ID) ) left join PER_ORG f on (c.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition $limit_data order by $order_str "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("c.ORG_ID", "a.ORG_ID", $cmd); } }elseif($search_per_type==3){ $cmd = " select top $data_per_page a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POEMS_ID as POS_ID, d.POEMS_NO_NAME as POS_NO_NAME, d.POEMS_NO as POS_NO, d.EP_CODE as PL_CODE, d.ORG_ID, d.ORG_ID_1, a.DEPARTMENT_ID from ( ( PER_PERSONAL a left join PER_POS_EMPSER d on (a.POEMS_ID=d.POEMS_ID) ) left join PER_ORG f on (d.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition $limit_data order by $order_str "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("d.ORG_ID", "a.ORG_ID", $cmd); } } elseif($search_per_type==4){ $cmd = " select top $data_per_page a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POEMS_ID as POS_ID, e.POT_NO_NAME as POS_NO_NAME, e.POT_NO as POS_NO, e.TP_CODE as PL_CODE, e.ORG_ID, e.ORG_ID_1, a.DEPARTMENT_ID from ( ( PER_PERSONAL a left join PER_POS_TEMP e on (a.POT_ID=e.POT_ID) ) left join PER_ORG f on (e.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition $limit_data order by $order_str "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("e.ORG_ID", "a.ORG_ID", $cmd); } } // end if }elseif($DPISDB=="oci8"){ $search_condition = str_replace(" where ", " and ", $search_condition); $rec_start = (($current_page-1) * $data_per_page) + 1; $rec_end = ($current_page > 1)? ($current_page * $data_per_page) : $data_per_page; if($search_per_type==1){ $cmd = " select * from ( select rownum rnum, q1.* from ( select a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POS_ID, b.POS_NO_NAME, b.POS_NO, b.PL_CODE, b.PM_CODE, b.ORG_ID, b.ORG_ID_1, b.PT_CODE, a.DEPARTMENT_ID from PER_PERSONAL a, PER_POSITION b, PER_ORG f, PER_ORG g, PER_MGT h, PER_LEVEL i where a.POS_ID=b.POS_ID(+) and a.DEPARTMENT_ID=g.ORG_ID and b.ORG_ID=f.ORG_ID(+) and b.PM_CODE=h.PM_CODE(+) and a.LEVEL_NO=i.LEVEL_NO(+) $search_condition order by $order_str ) q1 ) where rnum between $rec_start and $rec_end "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("b.ORG_ID", "a.ORG_ID", $cmd); } }elseif($search_per_type==2){ $cmd = " select * from ( select rownum rnum, q1.* from ( select a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POEM_ID as POS_ID, c.POEM_NO_NAME as POS_NO_NAME, c.POEM_NO as POS_NO, c.PN_CODE as PL_CODE, c.ORG_ID, c.ORG_ID_1, a.DEPARTMENT_ID from PER_PERSONAL a, PER_POS_EMP c, PER_ORG f, PER_ORG g where a.POEM_ID=c.POEM_ID(+) and a.DEPARTMENT_ID=g.ORG_ID and c.ORG_ID=f.ORG_ID(+) $search_condition order by $order_str ) q1 ) where rnum between $rec_start and $rec_end "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("c.ORG_ID", "a.ORG_ID", $cmd); } }elseif($search_per_type==3){ $cmd = " select * from ( select rownum rnum, q1.* from ( select a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POEMS_ID as POS_ID, d.POEMS_NO_NAME as POS_NO_NAME, d.POEMS_NO as POS_NO, d.EP_CODE as PL_CODE, d.ORG_ID, d.ORG_ID_1, a.DEPARTMENT_ID from PER_PERSONAL a, PER_POS_EMPSER d, PER_ORG f, PER_ORG g where a.POEMS_ID=d.POEMS_ID(+) and a.DEPARTMENT_ID=g.ORG_ID and d.ORG_ID=f.ORG_ID(+) $search_condition order by $order_str ) q1 ) where rnum between $rec_start and $rec_end "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("d.ORG_ID", "a.ORG_ID", $cmd); } } elseif($search_per_type==4){ $cmd = " select * from ( select rownum rnum, q1.* from ( select a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POEMS_ID as POS_ID, e.POT_NO_NAME as POS_NO_NAME, e.POT_NO as POS_NO, e.TP_CODE as PL_CODE, e.ORG_ID, e.ORG_ID_1, a.DEPARTMENT_ID from PER_PERSONAL a, PER_POS_TEMP e, PER_ORG f, PER_ORG g where a.POT_ID=e.POT_ID(+) and a.DEPARTMENT_ID=g.ORG_ID and e.ORG_ID=f.ORG_ID(+) $search_condition order by $order_str ) q1 ) where rnum between $rec_start and $rec_end "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("e.ORG_ID", "a.ORG_ID", $cmd); } } // end if }elseif($DPISDB=="mysql"){ if($search_per_type==1){ $cmd = " select a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POS_ID, b.POS_NO_NAME, b.POS_NO, b.PL_CODE, b.PM_CODE, b.ORG_ID, b.ORG_ID_1, b.PT_CODE, a.DEPARTMENT_ID from ( ( PER_PERSONAL a left join PER_POSITION b on (a.POS_ID=b.POS_ID) ) left join PER_ORG f on (b.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition order by $order_str $limit_data "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("b.ORG_ID", "a.ORG_ID", $cmd); } }elseif($search_per_type==2){ $cmd = " select a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POEM_ID as POS_ID, c.POEM_NO_NAME as POS_NO_NAME, c.POEM_NO as POS_NO, c.PN_CODE as PL_CODE, c.ORG_ID, c.ORG_ID_1, a.DEPARTMENT_ID from ( ( PER_PERSONAL a left join PER_POS_EMP c on (a.POEM_ID=c.POEM_ID) ) left join PER_ORG f on (c.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition order by $order_str $limit_data "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("c.ORG_ID", "a.ORG_ID", $cmd); } }elseif($search_per_type==3){ $cmd = " select a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POEMS_ID as POS_ID, d.POEMS_NO_NAME as POS_NO_NAME, d.POEMS_NO as POS_NO, d.EP_CODE as PL_CODE, d.ORG_ID, d.ORG_ID_1, a.DEPARTMENT_ID from ( ( PER_PERSONAL a left join PER_POS_EMPSER d on (a.POEMS_ID=d.POEMS_ID) ) left join PER_ORG f on (d.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition order by $order_str $limit_data "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("d.ORG_ID", "a.ORG_ID", $cmd); } } elseif($search_per_type==4){ $cmd = " select a.PER_ID, a.PN_CODE, a.PER_NAME, a.PER_SURNAME, a.LEVEL_NO, a.PER_TYPE, a.PER_STATUS, a.POT_ID as POS_ID, e.POT_NO_NAME as POS_NO_NAME, e.POT_NO as POS_NO, e.TP_CODE as PL_CODE, e.ORG_ID, e.ORG_ID_1, a.DEPARTMENT_ID from ( ( PER_PERSONAL a left join PER_POS_TEMP e on (a.POT_ID=e.POT_ID) ) left join PER_ORG f on (e.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (a.DEPARTMENT_ID=g.ORG_ID) $search_condition order by $order_str $limit_data "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("e.ORG_ID", "a.ORG_ID", $cmd); } } // end if } // end if $count_page_data = $db_dpis->send_cmd($cmd); // $db_dpis->show_error(); //echo "per_type:".$search_per_type."
cmd=$cmd ()
"; //echo "".$cmd; //echo $cmd; //echo $search_condition; if ($count_page_data) { $current_list = ""; $data_count = 0; ?>

get_array()) { $ORG_ID = $data[ORG_ID]; $cmd = " select ORG_NAME, OT_CODE from PER_ORG where ORG_ID=$ORG_ID "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_ORG_NAME = $data2[ORG_NAME]; if ($TMP_ORG_NAME=="-") $TMP_ORG_NAME = ""; $ORG_ID_1 = $data[ORG_ID_1]; if ($ORG_ID_1) { $cmd = " select ORG_NAME, OT_CODE from PER_ORG where ORG_ID=$ORG_ID_1 "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_ORG_NAME_1 = $data2[ORG_NAME]; if ($TMP_ORG_NAME_1=="-") $TMP_ORG_NAME_1 = ""; if ($data2[OT_CODE]) $OT_CODE = $data2[OT_CODE]; } $show_data = 1; if(trim($search_pos_ot_code) && $OT_CODE!=$search_pos_ot_code) $show_data = 0; if ($show_data==1) { $data_count++; if($data_count > $data_per_page) break; $temp_PER_ID = trim($data[PER_ID]); $LEVEL_NO = trim($data[LEVEL_NO]); $PER_NAME = $data[PER_NAME]; $PER_SURNAME = $data[PER_SURNAME]; $FULLNAME = "$PER_NAME $PER_SURNAME"; $cmd = " select POSITION_LEVEL from PER_LEVEL where LEVEL_NO='$LEVEL_NO' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_LEVEL_NAME = $data2[POSITION_LEVEL]; $PN_CODE = trim($data[PN_CODE]); if ($PN_CODE) { $cmd = " select PN_NAME, PN_SHORTNAME from PER_PRENAME where PN_CODE='$PN_CODE'"; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $PN_NAME = $data2[PN_NAME]; $PN_SHORTNAME = $data2[PN_SHORTNAME]; } $PER_TYPE = $data[PER_TYPE]; $PER_STATUS = $data[PER_STATUS]; $POSEM_NO = ""; $TMP_PL_NAME = ""; $POS_ID = $data[POS_ID]; $POS_NO = $data[POS_NO_NAME].' '.$data[POS_NO]; $PL_CODE = $data[PL_CODE]; if ($PER_TYPE == 1) { $cmd = " select PL_NAME from PER_LINE where PL_CODE='$PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PL_NAME = $data2[PL_NAME]; $PM_CODE = trim($data[PM_CODE]); $cmd = " select PM_NAME from PER_MGT where trim(PM_CODE)='$PM_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PM_NAME = $data2[PM_NAME]; if ($SESS_DEPARTMENT_NAME=="กรมการปกครอง" && !$TMP_PM_NAME) $TMP_PM_NAME = $TMP_PL_NAME; } elseif ($PER_TYPE == 2) { $cmd = " select PN_NAME as PL_NAME from PER_POS_NAME where PN_CODE='$PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $PL_NAME = $data2[PL_NAME]; $TMP_PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : $LEVEL_NAME; } elseif ($PER_TYPE == 3) { $cmd = " select EP_NAME as PL_NAME from PER_EMPSER_POS_NAME where EP_CODE='$PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $PL_NAME = $data2[PL_NAME]; $TMP_PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : $LEVEL_NAME; } elseif ($PER_TYPE == 4) { $cmd = " select TP_NAME as PL_NAME from PER_TEMP_POS_NAME where TP_CODE='$PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $PL_NAME = $data2[PL_NAME]; $TMP_PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : $LEVEL_NAME; } if ($TMP_PM_NAME=="ผู้ว่าราชการจังหวัด" || $TMP_PM_NAME=="รองผู้ว่าราชการจังหวัด" || $TMP_PM_NAME=="ปลัดจังหวัด" || $TMP_PM_NAME=="หัวหน้าสำนักงานจังหวัด") { $TMP_PM_NAME .= $TMP_ORG_NAME; $TMP_PM_NAME = str_replace("จังหวัดจังหวัด", "จังหวัด", $TMP_PM_NAME); $TMP_PM_NAME = str_replace("สำนักงานจังหวัดสำนักงานจังหวัด", "สำนักงานจังหวัด", $TMP_PM_NAME); } elseif ($TMP_PM_NAME=="นายอำเภอ") { $TMP_PM_NAME .= $TMP_ORG_NAME_1; $TMP_PM_NAME = str_replace("อำเภอที่ทำการปกครองอำเภอ", "อำเภอ", $TMP_PM_NAME); } $TMP_DEPARTMENT_ID = $data[DEPARTMENT_ID]; $cmd = " select ORG_NAME, ORG_ID_REF from PER_ORG where ORG_ID=$TMP_DEPARTMENT_ID "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_DEPARTMENT_NAME = $data2[ORG_NAME]; $TMP_MINISTRY_ID = $data2[ORG_ID_REF]; $cmd = " select ORG_NAME from PER_ORG where ORG_ID=$TMP_MINISTRY_ID "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_MINISTRY_NAME = $data2[ORG_NAME]; if($PER_STATUS == 2){ $POS_NO = ""; $TMP_PL_NAME = ""; } // end if if ($MFA_FLAG==1 && $search_poh_docno) { $cmd = " select POH_POS_NO, MOV_CODE, POH_PM_NAME, POH_PL_NAME, LEVEL_NO, POH_ORG, POH_DOCDATE from PER_POSITIONHIS where PER_ID=$temp_PER_ID and POH_DOCNO='$search_poh_docno' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_POH_POS_NO = trim($data2[POH_POS_NO]); $TMP_POH_POS_NO = trim($data2[POH_POS_NO]); $TMP_MOV_CODE = trim($data2[MOV_CODE]); $TMP_POH_PM_NAME = trim($data2[POH_PM_NAME]); $TMP_POH_PL_NAME = trim($data2[POH_PL_NAME]); $TMP_LEVEL_NO = trim($data2[LEVEL_NO]); $TMP_POH_ORG = trim($data2[POH_ORG]); $cmd = " select MOV_NAME from PER_MOVMENT where MOV_CODE='$TMP_MOV_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_MOV_NAME = $data2[MOV_NAME]; $cmd = " select POSITION_LEVEL from PER_LEVEL where LEVEL_NO='$TMP_LEVEL_NO' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_POH_LEVEL_NAME = $data2[POSITION_LEVEL]; } $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; if($PER_ID==$temp_PER_ID){ $class = "table_body_over"; $onmouse_event = ""; } // end if ?> >

1) : ?>