"; //echo "โปรแกรมฉบับชั่วคราว (beta 5.1.0.3 : 8 ม.ค. 2559)
"; $db_dpis2 = new connect_dpis($dpisdb_host, $dpisdb_name, $dpisdb_user, $dpisdb_pwd); if ($SELECTED_LIST && !$SELECTED_PER_ID) $SELECTED_PER_ID = $SELECTED_LIST; // เพื่อส่งค่าไป form2 // echo "SELECTED_LIST=$SELECTED_LIST, SELECTED_PER_ID=$SELECTED_PER_ID , command='$command' , save_1_command='$save_1_command' , current_page=$current_page , isSubmit=$isSubmit , search_per_type1=".$search_per_type1."
"; if(!isset($show_topic)) $show_topic = 1; switch($CTRL_TYPE){ case 2 : $PV_CODE = $PROVINCE_CODE; $PV_NAME = $PROVINCE_NAME; $search_pv_code = $PROVINCE_CODE; $search_pv_name = $PROVINCE_NAME; $search_ct_code = '140'; $cmd = " select CT_NAME from PER_COUNTRY where trim(CT_CODE)='$search_ct_code' "; $db_dpis->send_cmd($cmd); $data = $db_dpis->get_array(); $search_ct_name = $data[CT_NAME]; break; case 3 : $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; break; case 4 : $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; $search_department_id = $DEPARTMENT_ID; $search_department_name = $DEPARTMENT_NAME; break; } // end switch case switch($SESS_USERGROUP_LEVEL){ case 2 : $PV_CODE = $PROVINCE_CODE; $PV_NAME = $PROVINCE_NAME; $search_pv_code = $PROVINCE_CODE; $search_pv_name = $PROVINCE_NAME; $search_ct_code = '140'; $cmd = " select CT_NAME from PER_COUNTRY where trim(CT_CODE)='$search_ct_code' "; $db_dpis->send_cmd($cmd); $data = $db_dpis->get_array(); $search_ct_name = $data[CT_NAME]; break; case 3 : $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; break; case 4 : $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; $search_department_id = $DEPARTMENT_ID; $search_department_name = $DEPARTMENT_NAME; break; case 5 : $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; $search_department_id = $DEPARTMENT_ID; $search_department_name = $DEPARTMENT_NAME; if($SESS_ORG_STRUCTURE==0 || $SESS_ORG_STRUCTURE==2){ //ตามกฏหมาย หรือกฏหมายและมอบหมายงาน $search_org_id = $ORG_ID; $search_org_name = $ORG_NAME; }else if($SESS_ORG_STRUCTURE==1){ //ตามมอบหมายงาน (จาก load_per_control.php) $search_org_ass_id = $ORG_ID; $search_org_ass_name = $ORG_NAME; } break; case 6 : $MINISTRY_ID = $MINISTRY_ID; $MINISTRY_NAME = $MINISTRY_NAME; $DEPARTMENT_ID = $DEPARTMENT_ID; $DEPARTMENT_NAME = $DEPARTMENT_NAME; // $search_org_id = $ORG_ID; // $search_org_name = $ORG_NAME; // $search_org_id_1 = $ORG_ID_1; // $search_org_name_1 = $ORG_NAME_1; if($SESS_ORG_STRUCTURE==0 || $SESS_ORG_STRUCTURE==2){ //ตามกฏหมาย หรือกฏหมายและมอบหมายงาน $search_org_id = $ORG_ID; $search_org_name = $ORG_NAME; }else{ //ตามมอบหมายงาน (จาก load_per_control.php) $search_org_ass_id = $ORG_ID; $search_org_ass_name = $ORG_NAME; } if($SESS_ORG_STRUCTURE==0 || $SESS_ORG_STRUCTURE==2){ //ตามกฏหมาย หรือกฏหมายและมอบหมายงาน $search_org_id_1 = $ORG_ID_1; $search_org_name_1 = $ORG_NAME_1; }else{ //ตามมอบหมายงาน (จาก load_per_control.php) $search_org_ass_id_1 = $ORG_ID_1; $search_org_ass_name_1 = $ORG_NAME_1; } break; } // end switch case if($isLock){ $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; $search_department_id = $DEPARTMENT_ID; $search_department_name = $DEPARTMENT_NAME; } // end if $search_min_level = 1; $search_max_level = 11; if( !$current_page ) $current_page = 1; if(!$data_per_page) $data_per_page = 30; $start_record = ($current_page - 1) * $data_per_page; $search_per_status = (isset($search_per_status))? $search_per_status : 1; $search_per_type1 = (isset($search_per_type1))? $search_per_type1 : 1; if(trim($SELECTED_LIST)) $ARR_SELECTED = explode(",", $SELECTED_LIST); if(trim($EXCEPT_LIST)) $ARR_EXCEPT = explode(",", $EXCEPT_LIST); // echo "$EXCEPT_LIST
"; if($search_org_id){ $arr_search_condition[] = "(c.ORG_ID=$search_org_id or d.ORG_ID=$search_org_id or e.ORG_ID=$search_org_id)"; }elseif($search_department_id){ $arr_search_condition[] = "(a.DEPARTMENT_ID = $search_department_id)"; }elseif($search_ministry_id){ unset($arr_department); $cmd = " select ORG_ID from PER_ORG where ORG_ID_REF=$search_ministry_id and OL_CODE='02' "; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_department[] = $data[ORG_ID]; $arr_search_condition[] = "(a.DEPARTMENT_ID in (". implode(",", $arr_department) ."))"; }elseif($PROVINCE_CODE){ $cmd = " select distinct ORG_ID_REF from PER_ORG where PV_CODE='$PROVINCE_CODE' and OL_CODE='03' "; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_department[] = $data[ORG_ID_REF]; $arr_search_condition[] = "(a.DEPARTMENT_ID in (". implode(",", $arr_department) ."))"; } // end if if(trim($EXCEPT_PER_ID)) $arr_search_condition[] = "a.PER_ID not in ($EXCEPT_PER_ID)"; if(trim($search_pl_code)) $arr_search_condition[] = "(trim(PL_CODE) = '". trim($search_pl_code) ."')"; if(trim($search_pm_code)) $arr_search_condition[] = "(trim(PM_CODE) = '". trim($search_pm_code) ."')"; if(trim($search_name)) $arr_search_condition[] = "(a.PER_NAME like '$search_name%')"; if(trim($search_surname)) $arr_search_condition[] = "(a.PER_SURNAME like '$search_surname%')"; if(trim($search_cardno)) $arr_search_condition[] = "(PER_CARDNO = '$search_cardno')"; if(trim($search_offno)) $arr_search_condition[] = "(PER_OFFNO = '$search_offno')"; if(trim($search_pos_no)) { if ($search_per_type1 == 1 || $search_per_type==5) $arr_search_condition[] = "(trim(POS_NO) = '$search_pos_no')"; elseif ($search_per_type1 == 2) $arr_search_condition[] = "(trim(POEM_NO) = '$search_pos_no')"; elseif ($search_per_type1 == 3) $arr_search_condition[] = "(trim(POEMS_NO) = '$search_pos_no')"; elseif ($search_per_type1 == 4) $arr_search_condition[] = "(trim(POT_NO) = '$search_pos_no')"; else if ($search_per_type1==0) //ทั้งหมด $arr_search_condition[] = "((trim(POS_NO) = '$search_pos_no') or (trim(POEM_NO) = '$search_pos_no') or (trim(POEMS_NO) = '$search_pos_no') or (trim(POT_NO) = '$search_pos_no')) "; } if(trim($search_pos_no_name)){ if ($search_per_type1 == 1 || $search_per_type1==5) $arr_search_condition[] = "(trim(POS_NO_NAME) like '$search_pos_no_name%')"; elseif ($search_per_type1 == 2) $arr_search_condition[] = "(trim(POEM_NO_NAME) like '$search_pos_no_name%')"; elseif ($search_per_type1 == 3) $arr_search_condition[] = "(trim(POEMS_NO_NAME) like '$search_pos_no_name%')"; elseif ($search_per_type1 == 4) $arr_search_condition[] = "(trim(POT_NO_NAME) like '$search_pos_no_name%')"; else if ($search_per_type1==0) //ทั้งหมด $arr_search_condition[] = "((trim(POS_NO_NAME) like '$search_pos_no_name%') or (trim(POEM_NO_NAME) like '$search_pos_no_name%') or (trim(POEMS_NO_NAME) like '$search_pos_no_name%') or (trim(POT_NO_NAME) like '$search_pos_no_name%')) "; } if($search_per_type1) $arr_search_condition[] = "(a.PER_TYPE=$search_per_type1)"; if($search_pv_code) if ($search_per_type1==0 || $search_per_type1==1) $arr_search_condition[] = "(f.PV_CODE='$search_pv_code')"; elseif ($search_per_type1==0 || $search_per_type1==2) $arr_search_condition[] = "(g.PV_CODE='$search_pv_code')"; elseif ($search_per_type1==0 || $search_per_type1==3) $arr_search_condition[] = "(h.PV_CODE='$search_pv_code')"; elseif ($search_per_type1==0 || $search_per_type1==4) $arr_search_condition[] = "(j.PV_CODE='$search_pv_code')"; if(trim($search_per_status)!="") $arr_search_condition[] = "(a.PER_STATUS=$search_per_status)"; if(trim($executive)=="Y") if(trim($RPT_N)=="N") $arr_search_condition[] = "(a.LEVEL_NO in ('O4','K5','D1','D2','M1','M2'))"; else $arr_search_condition[] = "(a.LEVEL_NO in ('09','10','11'))"; if(trim($hipps)=="Y") $arr_search_condition[] = "((a.PER_HIP_FLAG like '%1%'))"; $search_condition = ""; if(count($arr_search_condition)) $search_condition = " where " . implode(" and ", $arr_search_condition); if($command == "SEARCH"){ if($DPISDB=="odbc"){ $cmd = " select count(PER_ID) as count_data from ( ( ( ( ( ( ( PER_PERSONAL a left join PER_POSITION c on (a.POS_ID=c.POS_ID) ) left join PER_POS_EMP d on (a.POEM_ID=d.POEM_ID) ) left join PER_POS_EMPSER e on (a.POEMS_ID=e.POEMS_ID) ) left join PER_POS_TEMP i on (a.POT_ID=i.POT_ID) ) left join PER_ORG f on (c.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (d.ORG_ID=g.ORG_ID) ) left join PER_ORG h on (e.ORG_ID=h.ORG_ID) ) left join PER_ORG j on (i.ORG_ID=j.ORG_ID) $search_condition "; }elseif($DPISDB=="oci8"){ $search_condition = str_replace(" where ", " and ", $search_condition); $cmd = " select count(PER_ID) as count_data from PER_PERSONAL a, PER_POSITION c, PER_POS_EMP d, PER_POS_EMPSER e, PER_POS_TEMP i, PER_ORG f, PER_ORG g, PER_ORG h, PER_ORG j where a.POS_ID=c.POS_ID(+) and a.POEM_ID=d.POEM_ID(+) and a.POEMS_ID=e.POEMS_ID(+) and a.POT_ID=i.POT_ID(+) and c.ORG_ID = f.ORG_ID(+) and d.ORG_ID = g.ORG_ID(+) and e.ORG_ID = h.ORG_ID(+) and i.ORG_ID = j.ORG_ID(+) $search_condition "; }elseif($DPISDB=="mysql"){ $cmd = " select count(PER_ID) as count_data from ( ( ( ( ( ( ( PER_PERSONAL a left join PER_POSITION c on (a.POS_ID=c.POS_ID) ) left join PER_POS_EMP d on (a.POEM_ID=d.POEM_ID) ) left join PER_POS_EMPSER e on (a.POEMS_ID=e.POEMS_ID) ) left join PER_POS_TEMP i on (a.POT_ID=i.POT_ID) ) left join PER_ORG f on (c.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (d.ORG_ID=g.ORG_ID) ) left join PER_ORG h on (e.ORG_ID=h.ORG_ID) ) left join PER_ORG j on (i.ORG_ID=j.ORG_ID) $search_condition "; } $db_dpis->send_cmd($cmd); // echo "$cmd
"; // $db_dpis->show_error(); $data = $db_dpis->get_array(); $data = array_change_key_case($data, CASE_LOWER); $count_data = $data[count_data]; $total_page = ceil( $count_data / $data_per_page ); $page_link = create_link_page($total_page, $current_page); $limit_data = ""; } // end if $command == "SEARCH" ?> รายชื่อข้าราชการ/ลูกจ้างประจำ
"> ">ส่งพิมพ์
 
;">
 :   : 
 :   : 
 :   : 
 :   : 
 :   : 
 :   : 
 :   : 
  > HiPPS > ข้อมูลผู้บริหารระดับสูง
   
พบรายชื่อ ทั้งสิ้น ราย
1)? ($current_page * $data_per_page) : $data_per_page; $cmd = "select * from ( select rownum rnum, q1.* from ( select a.PER_ID, a.POS_ID, c.POS_NO_NAME, c.POS_NO, d.POEM_NO_NAME, d.POEM_NO, e.POEMS_NO_NAME, e.POEMS_NO, i.POT_NO_NAME, i.POT_NO, b.PN_NAME, a.PER_NAME, a.PER_SURNAME, a.PER_TYPE, a.PER_STATUS, a.PER_CARDNO, a.PER_BIRTHDATE, c.ORG_ID, d.ORG_ID as EMP_ORG_ID, e.ORG_ID as EMPSER_ORG_ID, i.ORG_ID as TEMP_ORG_ID, c.PL_CODE, d.PN_CODE, a.PER_SALARY, a.LEVEL_NO, c.PT_CODE, a.DEPARTMENT_ID from PER_PERSONAL a, PER_PRENAME b, PER_POSITION c, PER_POS_EMP d, PER_POS_EMPSER e, PER_POS_TEMP i, PER_ORG f, PER_ORG g, PER_ORG h, PER_ORG j where a.PN_CODE=b.PN_CODE and a.POS_ID=c.POS_ID(+) and a.POEM_ID=d.POEM_ID(+) and a.POEMS_ID=e.POEMS_ID(+) and a.POT_ID=i.POT_ID(+) and c.ORG_ID = f.ORG_ID(+) and d.ORG_ID = g.ORG_ID(+) and e.ORG_ID = h.ORG_ID(+) and i.ORG_ID = j.ORG_ID(+) $search_condition $limit_data order by $order_str ) q1 ) where rnum between $rec_start1 and $rec_end1 "; }elseif($DPISDB=="mysql"){ $limit_data = " limit " . (($current_page - 1) * $data_per_page) . ", " . $data_per_page; $cmd = " select a.PER_ID, a.POS_ID, c.POS_NO_NAME, c.POS_NO, d.POEM_NO_NAME, d.POEM_NO, e.POEMS_NO_NAME, e.POEMS_NO, i.POT_NO_NAME, i.POT_NO, b.PN_NAME, a.PER_NAME, a.PER_SURNAME, a.PER_TYPE, a.PER_STATUS, a.PER_CARDNO, a.PER_BIRTHDATE, c.ORG_ID, d.ORG_ID as EMP_ORG_ID, e.ORG_ID as EMPSER_ORG_ID, i.ORG_ID as TEMP_ORG_ID, c.PL_CODE, d.PN_CODE, a.PER_SALARY, a.LEVEL_NO, c.PT_CODE, a.DEPARTMENT_ID from ( ( ( ( ( ( ( ( PER_PERSONAL a inner join PER_PRENAME b on (a.PN_CODE=b.PN_CODE) ) left join PER_POSITION c on (a.POS_ID = c.POS_ID) ) left join PER_POS_EMP d on (a.POEM_ID = d.POEM_ID) ) left join PER_POS_EMPSER e on (a.POEMS_ID=e.POEMS_ID) ) left join PER_POS_TEMP i on (a.POT_ID=i.POT_ID) ) left join PER_ORG f on (c.ORG_ID=f.ORG_ID) ) left join PER_ORG g on (d.ORG_ID=g.ORG_ID) ) left join PER_ORG h on (e.ORG_ID=h.ORG_ID) ) left join PER_ORG j on (i.ORG_ID=j.ORG_ID) $search_condition order by $order_str "; } // end if //echo "$cmd
"; $count_page_data = $db_dpis->send_cmd($cmd); //$db_dpis->show_error(); if($count_page_data){ ?>
get_array()) : $data_count++; if($data_count > $data_per_page) break; $TMP_PER_ID = $data[PER_ID]; $current_list .= ((trim($current_list))?",":"") . $TMP_PER_ID; $PER_TYPE = $data[PER_TYPE]; $TMP_LEVEL_NO = $data[LEVEL_NO]; $PER_STATUS = $data[PER_STATUS]; $TMP_DEPARTMENT_ID = $data[DEPARTMENT_ID]; $TMP_POS_NO = $TMP_POSITION = $TMP_PL_NAME = $TMP_PL_CODE = $TMP_ORG_ID = $TMP_ORG_NAME = ""; if($PER_TYPE==1){ $TMP_POS_ID = $data[POS_ID]; $TMP_POS_NO = $data[POS_NO_NAME].' '.$data[POS_NO]; $TMP_PER_TYPE = "ข้าราชการ"; $TMP_ORG_ID = $data[ORG_ID]; $TMP_PL_CODE = $data[PL_CODE]; $TMP_PT_CODE = trim($data[PT_CODE]); $cmd = " select PL_NAME from PER_LINE where PL_CODE='$TMP_PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PL_NAME = $data2[PL_NAME]; $cmd = " select PT_NAME from PER_TYPE where trim(PT_CODE)='$TMP_PT_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PT_NAME = $data2[PT_NAME]; $TMP_POSITION = trim($TMP_PL_NAME)?($TMP_PL_NAME ." ". level_no_format($TMP_LEVEL_NO) . (($TMP_PT_NAME != "ทั่วไป" && $TMP_LEVEL_NO >= 6)?"$TMP_PT_NAME":"")):"ระดับ ".level_no_format($TMP_LEVEL_NO); }elseif($PER_TYPE==2){ $TMP_POS_ID = $data[POEM_ID]; $TMP_POS_NO = $data[POEM_NO_NAME].$data[POEM_NO]; $TMP_PER_TYPE = "ลูกจ้างประจำ"; $TMP_ORG_ID = $data[EMP_ORG_ID]; $TMP_PL_CODE = $data[PN_CODE]; $cmd = " select PN_NAME from PER_POS_NAME where PN_CODE='$TMP_PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PL_NAME = $data2[PN_NAME]; $TMP_POSITION = $TMP_PL_NAME; }elseif($PER_TYPE==3){ $TMP_POS_ID = $data[POEMS_ID]; $TMP_POS_NO = $data[POEMS_NO_NAME].$data[POEMS_NO]; $TMP_PER_TYPE = "พนักงานราชการ"; $TMP_ORG_ID = $data[EMPSER_ORG_ID]; $TMP_PL_CODE = $data[EP_CODE]; $cmd = " select EP_NAME from PER_EMPSER_POS_NAME where EP_CODE='$TMP_PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PL_NAME = $data2[EP_NAME]; $TMP_POSITION = $TMP_PL_NAME; }elseif($PER_TYPE==4){ $TMP_POS_ID = $data[POT_ID]; $TMP_POS_NO = $data[POT_NO_NAME].$data[POT_NO]; $TMP_PER_TYPE = "ลูกจ้างชั่วคราว"; $TMP_ORG_ID = $data[TEMP_ORG_ID]; $TMP_PL_CODE = $data[TP_CODE]; $cmd = " select TP_NAME from PER_TEMP_POS_NAME where TP_CODE='$TMP_PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PL_NAME = $data2[TP_NAME]; $TMP_POSITION = $TMP_PL_NAME; } // end if $TMP_PN_NAME = $data[PN_NAME]; $TMP_PER_NAME = $data[PER_NAME]; $TMP_PER_SURNAME = $data[PER_SURNAME]; $TMP_PER_FULLNAME = $data[PN_NAME] . $data[PER_NAME] . " " . $data[PER_SURNAME]; $TMP_PER_CARDNO = $data[PER_CARDNO]; $TMP_PER_BIRTHDATE = $data[PER_BIRTHDATE]; $TMP_PER_SALARY = $data[PER_SALARY]; $cmd = " select ORG_NAME from PER_ORG where ORG_ID=$TMP_ORG_ID "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_ORG_NAME = $data2[ORG_NAME]; $cmd = " select ORG_ID_REF, ORG_NAME 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]; if($CTRL_TYPE < 3 && $SESS_USERGROUP_LEVEL < 3){ $cmd = " select ORG_ID_REF, 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]; } // end if if ($TMP_ORG_NAME=="-") $TMP_ORG_NAME = ""; if ($ISCS_FLAG==1 || $BKK_FLAG==1) { if ($TMP_ORG_NAME) { if ($TMP_ORG_NAME != $TMP_DEPARTMENT_NAME) $TMP_ORG_NAME = "$TMP_DEPARTMENT_NAME
 $TMP_ORG_NAME"; } else { $TMP_ORG_NAME = $TMP_DEPARTMENT_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_LEVEL_NAME = $data2[POSITION_LEVEL]; if($PER_STATUS == 2){ $TMP_POS_NO = ""; $TMP_POSITION = ""; } // end if $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; $returnValue = "$TMP_PER_ID<::>$TMP_PER_FULLNAME"; $checked = ""; if(in_array($TMP_PER_ID, $ARR_SELECTED) && !in_array($TMP_PER_ID, $ARR_EXCEPT)){ $count_selected++; $checked = "checked"; } // end if $disabled = ""; if(in_array($TMP_PER_ID, $ARR_EXCEPT)) $disabled = "disabled"; ?> >
คำนำหน้า สังกัด
>            
1) : ?>
 
;">
 
          >เลขอารบิค >เลขไทย
 
  $value){ // echo "search_per_type1=".$search_per_type1."
"; $arr_search_per_type=explode(",",$search_per_type1); // echo "key=$key($search_per_type1):".(in_array($key, $arr_search_per_type)).":".(isset($arr_search_per_type)).":".((in_array($key, $arr_search_per_type) || !isset($arr_search_per_type))?"chked":""); ?> >      
   ต้องการเรียงลำดับตามวันที่ลงนามในคำสั่ง
รายงานของ
เลือกลักษณะการพิมพ์
 รายการที่เริ่มพิมพ์
 ถึงรายการที่
 บรรทัดที่เริ่มพิมพ์