'$temp_date')"; } if (trim($PRO_DATE_END)) { $temp = explode("/", $PRO_DATE_END); $temp_date = ($temp[2] - 543) ."-". $temp[1] ."-". $temp[0]; $arr_search_condition[] = "(PRO_DATE < '$temp_date')"; } if($DEPARTMENT_ID){ $arr_search_condition[] = "(DEPARTMENT_ID=$DEPARTMENT_ID)"; }elseif($MINISTRY_ID){ $cmd = " select ORG_ID from PER_ORG where ORG_ID_REF=$MINISTRY_ID "; $db_dpis->send_cmd($cmd); while($data=$db_dpis->get_array()) $arr_org[] = $data[ORG_ID]; $arr_search_condition[] = "(DEPARTMENT_ID in (". implode(",", $arr_org) ."))"; }elseif($PV_CODE){ $cmd = " select distinct ORG_ID_REF from PER_ORG where OL_CODE='03' and PV_CODE='$PV_CODE' "; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_org[] = $data[ORG_ID_REF]; $arr_search_condition[] = "(DEPARTMENT_ID in (". implode(",", $arr_org) ."))"; } // end if $search_condition = ""; if ($arr_search_condition) $search_condition = "where " . implode(" and ", $arr_search_condition); $cmd =" select distinct $field from $table $search_condition "; $count_data = $db_dpis->send_cmd($cmd); //echo "%%%%".$cmd; //$db_dpis->show_error(); $total_page = ceil( $count_data / $data_per_page ); $page_link = create_link_page($total_page, $current_page); $limit_data = ""; if($command=="CANCEL"){ //เคลียร์ค่าเมื่อกดแท็บ เพิ่ม ใหม่ $PRO_DATE=""; $POS_POEM_NO=""; $POS_POEM_NO_NAME=""; $POS_POEM_NAME=""; $PL_PN_NAME=""; $PL_PN_CODE=""; $LEVEL_START=0; $LEVEL_END=0; $EN_NAME=""; $EN_CODE=""; $YEAR_START=""; $YEAR_END=""; $SAL_START=""; $SAL_END=""; } }else if($show_topic==2){ // กรณีที่เป็นการค้นหาข้อมูลที่ส่งมาจาก tab1 หรือ data_promote_e_p_quality (p0309 เดิม) if ($firstfrom=="data_promote_e_p_quality" && $POS_POEM_ID && $PRO_DATE && $table_select && $command && $PER_TYPE) { echo ""; } include("php_scripts/data_promote_e_p_inquire.php"); // echo ">>>POS_POEM_NO=$POS_POEM_NO, POS_POEM_NAME=$POS_POEM_NAME, PRO_DATE=$PRO_DATE, table_select=$table_select, command=$command, PER_TYPE=$PER_TYPE, firstfrom=$firstfrom, DEPARTMENT_ID=$DEPARTMENT_ID
"; // ==================== select จากเงื่อนไขสำหรับผู้ที่มีคุณสมบัติได้เลื่อนระดับ ====================== if ($command == "SEARCH") { include("php_scripts/data_promote_e_p_inquire_query_search.php"); } // ==================== select จากข้อมูลที่บันทึกไว้ใน PER_PROMOTE..... ===================== if ($command == "SELECT") { include("php_scripts/data_promote_e_p_inquire_query_select.php"); } // echo "data_promote_e_p_inquire.html :: command=$command || table=$table || PER_TYPE=$PER_TYPE || UPD=$UPD
cmd_save=$cmd_save
"; } // end show_topic // echo "$show_topic // data_promote_e_p_inquire.html :: command=$command || table=$table || PER_TYPE=$PER_TYPE || UPD=$UPD
cmd_save=$cmd_save
"; ?> <?=$webpage_title?> - <?=$MENU_TITLE_LV0?><?if($MENU_ID_LV1){?> - <?=$MENU_TITLE_LV1?><?}?>
">ค้นหาข้อมูล ">ข้อมูล
;">
 : 
*  :  *  : 
วันที่ประมวลผล :  >    :  >   
 :       : 
<?=$CLEAR_TITLE?>
 
พบข้อมูลวันที่ประมวลผล/ตำแหน่ง ของข้าราชการที่มีคุณสมบัติได้เลื่อนตำแหน่งทั้งสิ้น รายการ
1){ if($DPISDB=="odbc"){ $limit_data = " and ($field_limit_data) not in (select top $start_record ($field_limit_data) from $table $search_condition order by $orderby) "; }elseif($DPISDB=="mysql"){ $limit_data = " limit " . (($current_page - 1) * $data_per_page) . ", " . $data_per_page; } } // end if if($DPISDB=="odbc"){ $cmd = " select distinct top $data_per_page $field, DEPARTMENT_ID from $table $search_condition $limit_data order by $orderby "; }elseif($DPISDB=="oci8"){ $rec_start = (($current_page-1) * $data_per_page) + 1; $rec_end = ($current_page > 1)? ($current_page * $data_per_page) : $data_per_page; $cmd = "select * from ( select rownum rnum, q1.* from ( select distinct $field, DEPARTMENT_ID from $table $search_condition order by $orderby ) q1 ) where rnum between $rec_start and $rec_end "; }elseif($DPISDB=="mysql"){ $cmd = " select distinct $field, DEPARTMENT_ID from $table $search_condition order by $orderby $limit_data "; } // end if //echo "
SHOW_SEARCH -----> $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_PRO_DATE = show_date_format($data[PDATE], 1); $TMP_POS_ID = $data[PID]; $cmd = $cmd_position . $TMP_POS_ID; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_POS_NO = $data2[PNO]; $TMP_POS_NO_NAME = $data2[PNONAME]; $TMP_POS_NAME = $data2[PNAME]; $TMP_DEPARTMENT_ID = $data[DEPARTMENT_ID]; $cmd = " select 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]; $returnValue = "$TMP_POS_ID<::>$TMP_POS_NO<::>$TMP_POS_NAME<::>$TMP_PRO_DATE<::>$table<::>$PER_TYPE<::>$TMP_POS_NO_NAME"; $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; if(false){ $class = "table_body_over"; $onmouse_event = ""; } // end if ?> style="cursor:hand;" onClick="">
วันที่
   
1) : ?>
 
;">
 :  * วันที่ประมวลผล :  >  
 :       : 
<?=$CANCEL_TITLE?>แก้ไข <?=$SAVE_SEARCH_TITLE?>
® เงื่อนไขการค้นหา
*  :  *  : 
 :   : 
 :    onClick="form1.ORG_ID_M3.value='';form1.ORG_NAME_3.value='';">  onClick="form1.ORG_ID_M3.value='';form1.ORG_NAME_3.value='';">
 :  ถึง : 
ระยะเวลาในการดำรงตำแหน่งปัจจุบัน :    ปี ถึง : 
นับถึงวันที่ :  >  
 :  ถึง : 
<?=$CANCEL_TITLE?> <?=$CLEAR_TITLE?>  <?=$ADD_PERSON_TITLE?> 
 
send_cmd($cmd_search); }/*else if($cmd_show){ //ไม่มีตัวแปรนี้ $count_page_data = $db_dpis->send_cmd($cmd_show); }*/ //echo "<===
$count_page_data : $cmd_search
====>"; //$db_dpis->show_error(); echo "
"; //ถ้าเยอะๆเป็น 3-4 พัน error ?>
<?=$PDF_TITLE?> พบข้อมูลทั้งสิ้น รายการ <?=$EXCEL_TITLE?>
MAIN_SHOW [ $POS_POEM_NO + $PER_TYPE + $PL_PN_CODE] : : $show_topic :: $count_page_data --->
$command : $cmd_search - $cmd_show"; if ($count_page_data) { ?> get_array()) { $data_count++; $data_num++; if($data_count > $data_per_page) break; $TMP_PER_ID = $data[PER_ID]; $TMP_PER_TYPE = $data[PER_TYPE]; $current_list .= ((trim($current_list))?",":"") . $TMP_PER_ID; $TMP_PN_CODE = trim($data[PRENAME_CODE]); if($TMP_PN_CODE){ $cmd = " select PN_NAME from PER_PRENAME where trim(PN_CODE)='$TMP_PN_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PN_NAME = trim($data2[PN_NAME]); } // end if $TMP_PER_NAME = trim($TMP_PN_NAME) . trim($data[PER_NAME]) ." ". trim($data[PER_SURNAME]); $TMP_SALARY = number_format(trim($data[PER_SALARY]), 2, '.', ','); $TMP_POS_CHANGE_DATE = show_date_format($data[POS_CHANGE_DATE], $DATE_DISPLAY); $TMP_PER_STARTDATE = show_date_format($data[PER_STARTDATE], 1); $TMP_PER_STARTDATE = date_difference(date("Y-m-d"), trim($data[PER_STARTDATE]), "full"); $TMP_LEVEL_NO = trim($data[LEVEL_NO]); // หา วันเข้าสู่ระดับ $cmd = "select min(POH_EFFECTIVEDATE) as EFFECTIVEDATE from PER_POSITIONHIS where PER_ID=$TMP_PER_ID order by min(POH_EFFECTIVEDATE)"; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_EFFECTIVEDATE = show_date_format($data2[EFFECTIVEDATE], $DATE_DISPLAY); $TMP_POH_EFFECTIVEDATE = ""; if($PER_TYPE == 1){ $cmd = " select POH_EFFECTIVEDATE from PER_POSITIONHIS where PER_ID=$TMP_PER_ID and LEVEL_NO='$TMP_LEVEL_NO' order by POH_EFFECTIVEDATE "; }elseif($PER_TYPE == 2){ $cmd = " select POH_EFFECTIVEDATE from PER_POSITIONHIS where PER_ID=$TMP_PER_ID and LEVEL_NO='$TMP_LEVEL_NO' order by POH_EFFECTIVEDATE "; }elseif($PER_TYPE == 3){ $cmd = " select POH_EFFECTIVEDATE from PER_POSITIONHIS where PER_ID=$TMP_PER_ID and LEVEL_NO='$TMP_LEVEL_NO' order by POH_EFFECTIVEDATE "; } // end if $db_dpis1->send_cmd($cmd); // $db_dpis1->show_error(); $data1 = $db_dpis1->get_array(); $TMP_POH_EFFECTIVEDATE = substr(trim($data1[POH_EFFECTIVEDATE]), 0, 10); $TMP_POS_STARTDATE = ""; if ($CHECK_DATE) { $tmp_date = save_date($CHECK_DATE); if($TMP_POH_EFFECTIVEDATE && $TMP_POH_EFFECTIVEDATE!="-") $TMP_POS_STARTDATE = date_difference($tmp_date, $TMP_POH_EFFECTIVEDATE, "full"); } else { if($TMP_POH_EFFECTIVEDATE && $TMP_POH_EFFECTIVEDATE!="-") $TMP_POS_STARTDATE = date_difference(date("Y-m-d"), $TMP_POH_EFFECTIVEDATE, "full"); } if($PER_TYPE==1){ $TMP_POS_NO = trim($data[POS_NO_NAME]).trim($data[POS_NO]); $TMP_PL_CODE = trim($data[PL_CODE]); if($TMP_PL_CODE){ $cmd = " select PL_NAME from PER_LINE where trim(PL_CODE)='$TMP_PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PL_NAME = trim($data2[PL_NAME]); } // end if }elseif($PER_TYPE==2){ $TMP_POS_NO = trim($data[POEM_NO_NAME]).trim($data[POEM_NO]); $TMP_PL_CODE = trim($data[PN_CODE]); if($TMP_PL_CODE){ $cmd = " select PN_NAME from PER_POS_NAME where trim(PN_CODE)='$TMP_PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PL_NAME = trim($data2[PN_NAME]); } // end if }elseif($PER_TYPE==3){ $TMP_POS_NO = trim($data[POEMS_NO_NAME]).trim($data[POEMS_NO]); $TMP_PL_CODE = trim($data[EP_CODE]); if($TMP_PL_CODE){ $cmd = " select EP_NAME from PER_EMPSER_POS_NAME where trim(EP_CODE)='$TMP_PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PL_NAME = trim($data2[EP_NAME]); } // end if }elseif($PER_TYPE==4){ $TMP_POS_NO = trim($data[POT_NO_NAME]).trim($data[POT_NO]); $TMP_PL_CODE = trim($data[TP_CODE]); if($TMP_PL_CODE){ $cmd = " select TP_NAME from PER_TEMP_POS_NAME where trim(TP_CODE)='$TMP_PL_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PL_NAME = trim($data2[TP_NAME]); } // end if } // end if $TMP_PT_CODE = trim($data[PT_CODE]); if($TMP_PT_CODE){ $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 = trim($data2[PT_NAME]); } // end if $TMP_PM_CODE = trim($data[PM_CODE]); if($TMP_PM_CODE){ $cmd = " select PM_NAME from PER_MGT where trim(PM_CODE)='$TMP_PM_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PM_NAME = $data2[PM_NAME]; } // end if $cmd = " select LEVEL_NAME, POSITION_LEVEL from PER_LEVEL where LEVEL_NO='$TMP_LEVEL_NO' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $LEVEL_NAME = $data2[LEVEL_NAME]; $POSITION_LEVEL = $data2[POSITION_LEVEL]; if (!$POSITION_LEVEL) $POSITION_LEVEL = $LEVEL_NAME; if ($RPT_N) $TMP_POSITION = (trim($TMP_PM_NAME) ?"$TMP_PM_NAME (":"") . (trim($TMP_PL_NAME)? "$TMP_PL_NAME$POSITION_LEVEL" : "") . (trim($TMP_PM_NAME) ?")":""); else $TMP_POSITION = (trim($TMP_PM_NAME) ?"$TMP_PM_NAME (":"") . (trim($TMP_PL_NAME)?($TMP_PL_NAME ." ". level_no_format($TMP_LEVEL_NO) . (($TMP_PT_NAME != "ทั่วไป" && $TMP_LEVEL_NO >= 6)?"$TMP_PT_NAME":"")):"") . (trim($TMP_PM_NAME) ?")":""); $TMP_ORG_ID = trim($data[ORG_ID]); if($TMP_ORG_ID){ $cmd = " select ORG_NAME,ORG_SHORT from PER_ORG where ORG_ID=$TMP_ORG_ID "; $db_dpis2->send_cmd($cmd); //$db_dpis2->show_error(); $data2 = $db_dpis2->get_array(); if($data2[ORG_SHORT]){ $TMP_ORG = $data2[ORG_SHORT]; }else{ $TMP_ORG = $data2[ORG_NAME]; } } // end if $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; if($PER_ID==$TMP_PER_ID){ $class = "table_body_over"; $onmouse_event = ""; } // end if ?> >
สังกัด วันเข้าสู่ระดับ ระยะเวลาที่ดำรงตำแหน่ง
(ปี/เดือน/วัน)
อายุราชการ
(ปี/เดือน/วัน)
            ลบข้อมูล -"; } // if ?>
1) : ?>