= '$search_birthdate') and (LEFT(trim(PER_BIRTHDATE), 10) <= '$search_end_birthdate') "; elseif($DPISDB=="oci8") $arr_search_condition[] = "(SUBSTR(trim(PER_BIRTHDATE), 1, 10) >= '$search_birthdate') and (SUBSTR(trim(PER_BIRTHDATE), 1, 10) <= '$search_end_birthdate') "; elseif($DPISDB=="mysql") $arr_search_condition[] = "(SUBSTRING(trim(PER_BIRTHDATE), 1, 10) >= '$search_birthdate') and (SUBSTRING(trim(PER_BIRTHDATE), 1, 10) <= '$search_end_birthdate') "; } // end if if ($ANNUAL){ $search_birthdate = date_adjust((($ANNUAL - 543)."-01-01"), "y", -60); $search_end_birthdate = date_adjust((($ANNUAL - 543)."-12-31"), "y", -60); if($DPISDB=="odbc") $arr_search_condition[] = "(LEFT(trim(PER_BIRTHDATE), 10) >= '$search_birthdate') and (LEFT(trim(PER_BIRTHDATE), 10) <= '$search_end_birthdate') "; elseif($DPISDB=="oci8") $arr_search_condition[] = "(SUBSTR(trim(PER_BIRTHDATE), 1, 10) >= '$search_birthdate') and (SUBSTR(trim(PER_BIRTHDATE), 1, 10) <= '$search_end_birthdate') "; elseif($DPISDB=="mysql") $arr_search_condition[] = "(SUBSTRING(trim(PER_BIRTHDATE), 1, 10) >= '$search_birthdate') and (SUBSTRING(trim(PER_BIRTHDATE), 1, 10) <= '$search_end_birthdate') "; } // end if //หา LEVEL_SEQ_NO $search_level=""; if ($LEVEL_START) { $cmd = "select LEVEL_SEQ_NO from PER_LEVEL where LEVEL_NO='$LEVEL_START' "; $db_dpis->send_cmd($cmd); $data = $db_dpis->get_array(); $LEVEL_SEQ_START=$data['LEVEL_SEQ_NO']; if($LEVEL_SEQ_START) $search_level.= "(LEVEL_SEQ_NO >=$LEVEL_SEQ_START)"; } if($LEVEL_END) { $cmd = "select LEVEL_SEQ_NO from PER_LEVEL where LEVEL_NO='$LEVEL_END' "; $db_dpis->send_cmd($cmd); $data = $db_dpis->get_array(); $LEVEL_SEQ_END=$data['LEVEL_SEQ_NO']; if($LEVEL_SEQ_END) $search_level.= "and (LEVEL_SEQ_NO<=$LEVEL_SEQ_END)"; } //หา LEVEL NO เพื่อสร้างเงื่อนไข if($search_level){ $cmd = "select LEVEL_NO from PER_LEVEL where $search_level order by LEVEL_SEQ_NO"; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_level_search[] = "'".$data[LEVEL_NO]."'"; $arr_search_condition[] = "(a.LEVEL_NO in (". implode(",", $arr_level_search) ."))"; } if($PL_CODE) { $arr_search_condition[] = "(b.PL_CODE = '$PL_CODE')"; } if ($ORG_ID){ if($SESS_ORG_STRUCTURE==1){ $arr_search_condition[] = "(a.ORG_ID = $ORG_ID)"; }else{ $arr_search_condition[] = "(b.ORG_ID = $ORG_ID)"; } }elseif($DEPARTMENT_ID){ $arr_search_condition[] = "(a.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[] = "(a.DEPARTMENT_ID in (". implode(",", $arr_org) ."))"; }elseif($PV_CODE){ $cmd = " select ORG_ID from PER_ORG where OL_CODE='03' and PV_CODE='$PV_CODE' order by ORG_ID "; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_org[] = $data[ORG_ID]; $arr_search_condition[] = "(b.ORG_ID in (". implode(",", $arr_org) ."))"; } // end if $search_condition = ""; if ($arr_search_condition) $search_condition = " and " . implode(" and ", $arr_search_condition); if($command=="SEARCH"){ $cmd =" select PER_ID from PER_PERSONAL a, $search_from b where PER_TYPE=$PER_TYPE and PER_STATUS=1 $search_condition "; $count_data = $db_dpis->send_cmd($cmd); // $db_dpis->show_error(); // echo $cmd; $total_page = ceil( $count_data / $data_per_page ); $page_link = create_link_page($total_page, $current_page); $limit_data = ""; } // end if ?> <?=$webpage_title?> - <?=$MENU_TITLE_LV0?><?if($MENU_ID_LV1){?> - <?=$MENU_TITLE_LV1?><?}?>
  
   
 :   : 
* ประจำ :  >  : 
จาก :  ถึง : 
 :    : 
<?=$CLEAR_TITLE?>   
 
<?=$PDF_TITLE?> <?=$RTF_TITLE?> พบข้อมูลการทั้งสิ้น รายการ <?=$EXCEL_TITLE?>
1)? ($current_page * $data_per_page) : $data_per_page; $cmd = "select * from ( select rownum rnum, q1.* from ( select PER_ID, a.PN_CODE as PREN_CODE, PER_NAME, PER_SURNAME, a.LEVEL_NO, b.ORG_ID, PER_STARTDATE, PER_BIRTHDATE, a.DEPARTMENT_ID $search_field from PER_PERSONAL a , $search_from b , PER_LEVEL c where a.PER_TYPE=$PER_TYPE and PER_STATUS=1 and a.LEVEL_NO = c.LEVEL_NO(+) $search_condition order by $order_str ) q1 ) where rnum between $rec_start and $rec_end "; }elseif($DPISDB=="mysql"){ $cmd = " select PER_ID, a.PN_CODE as PREN_CODE, PER_NAME, PER_SURNAME, a.LEVEL_NO, b.ORG_ID, PER_STARTDATE, PER_BIRTHDATE, a.DEPARTMENT_ID $search_field from PER_PERSONAL a, $search_from b where a.PER_TYPE=$PER_TYPE and PER_STATUS=1 $search_condition order by $order_str "; } // end if $count_page_data = $db_dpis->send_cmd($cmd); //$db_dpis->show_error(); //echo "
$cmd
";
	} // end if
	
	if ($count_page_data) {
?>  
  get_array()) {
		$data_count++;
		$data_num++;
		if($data_count > $data_per_page) break;
		$TMP_PER_ID = $data[PER_ID];
		$current_list .= ((trim($current_list))?",":"") . $TMP_PER_ID;
		$TMP_PER_NAME = trim($data[PER_NAME]);
		$TMP_PER_SURNAME = trim($data[PER_SURNAME]);
		$TMP_LEVEL_NO = trim($data[LEVEL_NO]);
		
		$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();
		//$db_dpis2->show_error();
		//echo $cmd;
		$TMP_LEVEL_NAME = trim($data2[LEVEL_NAME]);
		$TMP_POSITION_LEVEL = $data2[POSITION_LEVEL];
		if (!$TMP_POSITION_LEVEL) $TMP_POSITION_LEVEL = $TMP_LEVEL_NAME;
		
		$TMP_PER_STARTDATE = show_date_format($data[PER_STARTDATE], 1);
		$TMP_PER_BIRTHDATE = show_date_format($data[PER_BIRTHDATE], 1);
		$TMP_POS_NO_NAME = $data[POS_NO_NAME];
		$TMP_POS_NO = $TMP_POS_NO_NAME.' '.$data[POS_NO];
		
		$TMP_PM_NAME = $TMP_PL_NAME = $TMP_PN_NAME = $TMP_EP_NAME = $TMP_ORG_NAME = "";
		
		$TMP_PREN_CODE = trim($data[PREN_CODE]);
		if($TMP_PREN_CODE){
			$cmd = " select PN_NAME from PER_PRENAME where PN_CODE='$TMP_PREN_CODE' ";
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$TMP_PREN_NAME = $data2[PN_NAME];
		} // end if		
		
		$TMP_PM_CODE = trim($data[PM_CODE]);
		if($TMP_PM_CODE){
			$cmd = " select PM_NAME from PER_MGT where PM_CODE='$TMP_PM_CODE' ";
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$TMP_PM_NAME = $data2[PM_NAME];
		} // end if
		
		$TMP_PL_CODE = $data[PL_CODE];
		$TMP_PT_CODE = trim($data[PT_CODE]);
		if($TMP_PL_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_POS_NAME = trim($TMP_PL_NAME)?($TMP_PL_NAME . $TMP_POSITION_LEVEL . (($TMP_PT_NAME != "ทั่วไป" && $TMP_LEVEL_NO >= 6)?"$TMP_PT_NAME":"")):"$TMP_LEVEL_NAME";
		} // end if

		$TMP_PN_CODE = $data[PN_CODE];
		//echo "TMP_PN_CODE = $TMP_PN_CODE";
		if($TMP_PN_CODE){
			$cmd = " select PN_NAME from PER_POS_NAME where PN_CODE='$TMP_PN_CODE' ";
			$db_dpis2->send_cmd($cmd);
			//$db_dpis2->show_error();
			$data2 = $db_dpis2->get_array();
			//$db_dpis2->show_error();
			$TMP_POS_NAME = $data2[PN_NAME]." ".$TMP_LEVEL_NAME;
		} // end if

		$TMP_EP_CODE = $data[EP_CODE];
		if($TMP_EP_CODE){
			$cmd = " select EP_NAME from PER_POS_EMPSER where EP_CODE='$TMP_EP_CODE' ";
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$TMP_POS_NAME = $data2[EP_NAME];
		} // end if

		$TMP_ORG_ID = $data[ORG_ID];
		if($TMP_ORG_ID){
			$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];
		} // end if

        $TMP_DEPARTMENT_ID = trim($data[DEPARTMENT_ID]);
		$TMP_MINISTRY_ID = $TMP_MINISTRY_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_MINISTRY_ID = $data2[ORG_ID_REF];
		$TMP_DEPARTMENT_NAME = $data2[ORG_NAME];			
		
		if ($TMP_MINISTRY_ID) {
			$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];
		}
		
		$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		
?>
    >
      

    

	
	

      ตำแหน่ง / ระดับ
      
    
    
      
    
	  
    
    
      
      
    
    
      
      วันที่เริ่มรับราชการ	  
	 		  
    

    

       

       
            
    
     
        
    
    
     style=""> 
        
    
       
      
	  
    

    
	
    

       
       
       
   
     
    
    
     
    
       
       
       
       
    

	
  

   1) : ?>