;">

:  onChange="form0.submit();"> $value){ ?>> *  :     *  :      :      :     ปัจจุบันรับราชการตำแหน่ง :      :      :  "> >== == send_cmd($cmd); while($data = $db_dpis->get_array()){ $TMP_LEVEL_NO = $data[LEVEL_NO]; $TMP_LEVEL_NAME = $data[LEVEL_NAME]; ?> > ถึง :  "> >== == send_cmd($cmd); while($data = $db_dpis->get_array()){ $TMP_LEVEL_NO = $data[LEVEL_NO]; $TMP_LEVEL_NAME = $data[LEVEL_NAME]; ?> > ขอย้ายไปตำแหน่ง :     ที่ขอย้าย :    วันที่ขอย้าย :  >    ถึง :  >

 

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

1){ if($DPISDB=="odbc"){ $limit_data = " and MV_ID not in (select top $start_record MV_ID from PER_MOVE_REQ where PER_ID=$PER_ID order by MV_ID) "; }elseif($DPISDB=="mysql"){ $limit_data = " limit " . (($current_page - 1) * $data_per_page) . ", " . $data_per_page; } } // end if if($command == "DELETE" && $MV_ID){ $cmd = "delete from PER_MOVE_REQ where MV_ID=$MV_ID "; $db_dpis->send_cmd($cmd); // $db_dpis->show_error(); $command = "SEARCH"; } //end DELETE if ($command == "SEARCH") { if($DPISDB=="odbc"){ $cmd = "select distinct top $data_per_page a.PER_ID, b.POS_ID, b.POEM_ID, b.POEMS_ID,b.POT_ID, b.PER_SALARY, b.PN_CODE, PER_NAME, PER_SURNAME, b.LEVEL_NO, e.LEVEL_NAME, e.POSITION_LEVEL, MV_DATE, MV_REMARK, a.ORG_ID_1, a.ORG_ID_2, a.ORG_ID_3, ORG_ID_REF_1, ORG_ID_REF_2, ORG_ID_REF_3, b.ORG_ID_1 as PER_ORG_ID_1, b.ORG_ID_2 as PER_ORG_ID_2, b.ORG_ID_3 as PER_ORG_ID_3, a.MV_ID from PER_MOVE_REQ a, PER_PERSONAL b, PER_LEVEL e $search_from where a.PER_ID=b.PER_ID and b.LEVEL_NO=e.LEVEL_NO $search_condition $limit_data group by a.PER_ID, b.POS_ID, b.POEM_ID, b.POEMS_ID,b.POT_ID, b.PER_SALARY, b.PN_CODE, PER_NAME, PER_SURNAME, b.LEVEL_NO, e.LEVEL_NAME, e.POSITION_LEVEL, MV_DATE, MV_REMARK, a.ORG_ID_1, a.ORG_ID_2, a.ORG_ID_3, ORG_ID_REF_1, ORG_ID_REF_2, ORG_ID_REF_3 , b.ORG_ID_1, b.ORG_ID_2, b.ORG_ID_3, a.MV_ID $order_str "; }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 a.PER_ID, b.POS_ID, b.POEM_ID, b.POEMS_ID,b.POT_ID, b.PER_SALARY, b.PN_CODE, PER_NAME, PER_SURNAME, b.LEVEL_NO, e.LEVEL_NAME, e.POSITION_LEVEL, MV_DATE, MV_REMARK, a.ORG_ID_1, a.ORG_ID_2, a.ORG_ID_3, ORG_ID_REF_1, ORG_ID_REF_2, ORG_ID_REF_3, b.ORG_ID_1 as PER_ORG_ID_1, b.ORG_ID_2 as PER_ORG_ID_2, b.ORG_ID_3 as PER_ORG_ID_3, a.MV_ID from PER_MOVE_REQ a, PER_PERSONAL b, PER_LEVEL e $search_from where a.PER_ID=b.PER_ID and b.LEVEL_NO=e.LEVEL_NO $per_id_search $search_condition group by a.PER_ID, b.POS_ID, b.POEM_ID, b.POEMS_ID, b.POT_ID, b.PER_SALARY, b.PN_CODE, PER_NAME, PER_SURNAME, b.LEVEL_NO, e.LEVEL_NAME, e.POSITION_LEVEL, MV_DATE, MV_REMARK, a.ORG_ID_1, a.ORG_ID_2, a.ORG_ID_3, ORG_ID_REF_1, ORG_ID_REF_2, ORG_ID_REF_3, b.ORG_ID_1, b.ORG_ID_2, b.ORG_ID_3, a.MV_ID $order_str ) q1 ) where rnum between $rec_start and $rec_end "; }elseif($DPISDB=="mysql"){ $cmd = "select distinct a.PER_ID, b.POS_ID, b.POEM_ID, b.POEMS_ID,b.POT_ID, b.PER_SALARY, b.PN_CODE, PER_NAME, PER_SURNAME, b.LEVEL_NO, e.LEVEL_NAME, e.POSITION_LEVEL, MV_DATE, MV_REMARK, a.ORG_ID_1, a.ORG_ID_2, a.ORG_ID_3, ORG_ID_REF_1, ORG_ID_REF_2, ORG_ID_REF_3, b.ORG_ID_1 as PER_ORG_ID_1, b.ORG_ID_2 as PER_ORG_ID_2, b.ORG_ID_3 as PER_ORG_ID_3, a.MV_ID from PER_MOVE_REQ a, PER_PERSONAL b, PER_LEVEL e $search_from where a.PER_ID=b.PER_ID and b.LEVEL_NO=e.LEVEL_NO $search_condition group by a.PER_ID, b.POS_ID, b.POEM_ID, b.POEMS_ID,b.POT_ID, b.PER_SALARY, b.PN_CODE, PER_NAME, PER_SURNAME, b.LEVEL_NO, e.LEVEL_NAME, e.POSITION_LEVEL, MV_DATE, MV_REMARK, a.ORG_ID_1, a.ORG_ID_2, a.ORG_ID_3, ORG_ID_REF_1, ORG_ID_REF_2, ORG_ID_REF_3 , b.ORG_ID_1, b.ORG_ID_2, b.ORG_ID_3 , a.MV_ID $order_str $limit_data "; } // end if $count_page_data = $db_dpis->send_cmd($cmd); //$db_dpis->show_error(); //echo "

---

=====> $cmd
"; } // end if command==SEARCH //echo "~~~ $command : :

$cmd";
	//$db_dpis->show_error();

	if ($count_page_data) {
?>
        get_array()) {
		if($current_page > 1)	$data_count = $data_per_page++;
		$data_count++;
		if($data_count > $data_per_page) break;
		
		$TMP_MV_ID = trim($data[MV_ID]);
		$current_list .= ((trim($current_list))?",":"") . $TMP_MV_ID;
		$TMP_PER_ID = trim($data[PER_ID]);
		$TMP_POS_ID = trim($data[POS_ID]);	
		$TMP_POEM_ID = trim($data[POEM_ID]);
		$TMP_POEMS_ID = trim($data[POEMS_ID]);
		$TMP_POT_ID = trim($data[POT_ID]);
		$TMP_SALARY = number_format(trim($data[PER_SALARY]), 2, '.', ',');
		$LEVEL_NO = trim($data[LEVEL_NO]);
		$LEVEL_NAME = trim($data[LEVEL_NAME]);
        $POSITION_LEVEL = trim($data[POSITION_LEVEL]);
		$TMP_MV_REMARK = (trim($data[MV_REMARK]))? trim($data[MV_REMARK]) : "-" ;
		
		$TMP_MV_DATE = show_date_format($data[MV_DATE], 1);
		
		$PN_CODE = trim($data[PN_CODE]);
		if ($PN_CODE) {
			$cmd = " select PN_NAME from PER_PRENAME where PN_CODE='$PN_CODE' ";
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$PN_NAME = trim($data2[PN_NAME]);
		} 
		$TMP_PER_NAME = $PN_NAME . trim($data[PER_NAME]) . " " . trim($data[PER_SURNAME]);

		$ORG_ID_REF_1 = (trim($data[ORG_ID_REF_1]))? trim($data[ORG_ID_REF_1]) : 0 ;
		$ORG_ID_REF_2 = (trim($data[ORG_ID_REF_2]))? trim($data[ORG_ID_REF_2]) : 0 ;
		$ORG_ID_REF_3 = (trim($data[ORG_ID_REF_3]))? trim($data[ORG_ID_REF_3]) : 0 ;
		$ORG_NAME_REF_1 = $ORG_NAME_REF_2 = $ORG_NAME_REF_3 = "-";
		$cmd = "	select ORG_ID, ORG_NAME from PER_ORG where ORG_ID in ($ORG_ID_REF_1, $ORG_ID_REF_2, $ORG_ID_REF_3)";
		if($select_org_structure==1) $cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd);
		$db_dpis2->send_cmd($cmd);
		while ($data2 = $db_dpis2->get_array() ) {
			$temp_id = trim($data2[ORG_ID]);
			$ORG_NAME_REF_1 = ($ORG_ID_REF_1 == $temp_id)? trim($data2[ORG_NAME]) : "$ORG_NAME_REF_1";
			$ORG_NAME_REF_2 = ($ORG_ID_REF_2 == $temp_id)? trim($data2[ORG_NAME]) : "$ORG_NAME_REF_2";	
			$ORG_NAME_REF_3 = ($ORG_ID_REF_3 == $temp_id)? trim($data2[ORG_NAME]) : "$ORG_NAME_REF_3";	
		}				

		$ORG_NAME_1 = $ORG_NAME_2 = $ORG_NAME_3 = "";
		if($select_org_structure==0){		//จาก POSITION
			$ORG_ID_1 = (trim($data[ORG_ID_1]))? trim($data[ORG_ID_1]) : 0 ;
			$ORG_ID_2 = (trim($data[ORG_ID_2]))? trim($data[ORG_ID_2]) : 0 ;
			$ORG_ID_3 = (trim($data[ORG_ID_3]))? trim($data[ORG_ID_3]) : 0 ;
		}
		if($select_org_structure==1){		//จาก PER_PERSONAL
			$ORG_ID_1 = (trim($data[ORG_ID_1]))? trim($data[PER_ORG_ID_1]) : 0 ;
			$ORG_ID_2 = (trim($data[ORG_ID_2]))? trim($data[PER_ORG_ID_2]) : 0 ;
			$ORG_ID_3 = (trim($data[ORG_ID_3]))? trim($data[PER_ORG_ID_3]) : 0 ;
		}
		$cmd = "	select ORG_ID, ORG_NAME from PER_ORG where ORG_ID in ($ORG_ID_1, $ORG_ID_2, $ORG_ID_3)";
		if($select_org_structure==1) $cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd);
		$db_dpis2->send_cmd($cmd);
		while ($data2 = $db_dpis2->get_array() ) {
			$temp_id = trim($data2[ORG_ID]);
			$ORG_NAME_1 = ($ORG_ID_1 == $temp_id)? trim($data2[ORG_NAME]) : "$ORG_NAME_1";
			$ORG_NAME_2 = ($ORG_ID_2 == $temp_id)? trim($data2[ORG_NAME]) : "$ORG_NAME_2";	
			$ORG_NAME_3 = ($ORG_ID_3 == $temp_id)? trim($data2[ORG_NAME]) : "$ORG_NAME_3";	
		}		
		
		unset($temp_ORG_ID, $temp_ORG_ID_1, $TMP_ORG_NAME, $TMP_ORG_NAME_1);		
		if($TMP_POS_ID){
			$cmd = " 	select ORG_ID, ORG_ID_1, PL_CODE from PER_POSITION  
								where POS_ID=$TMP_POS_ID ";
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$PL_CODE = trim($data2[PL_CODE]);
			if($select_org_structure==1){
				$cmd = " 	select ORG_ID, ORG_ID_1 from PER_PERSONAL  
								where POS_ID=$TMP_POS_ID ";
				$db_dpis2->send_cmd($cmd);
				$data2 = $db_dpis2->get_array();
			}			
			$temp_ORG_ID = $data2[ORG_ID] + 0;
			$temp_ORG_ID_1 = $data2[ORG_ID_1] + 0;
			$cmd = "	select ORG_ID, ORG_NAME from PER_ORG where ORG_ID in ($temp_ORG_ID, $temp_ORG_ID_1)";
			if($select_org_structure==1) $cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd);
			$db_dpis2->send_cmd($cmd);
			while ($data2 = $db_dpis2->get_array() ) {
				$temp_id = trim($data2[ORG_ID]);
				$TMP_ORG_NAME = ($temp_ORG_ID == $temp_id)? trim($data2[ORG_NAME]) : "$TMP_ORG_NAME";
				$TMP_ORG_NAME_1 = ($temp_ORG_ID_1 == $temp_id)? trim($data2[ORG_NAME]) : "$TMP_ORG_NAME_1";				
			}				
			if (trim($PL_CODE)) {
				$cmd = " select PL_NAME from PER_LINE where PL_CODE = '$PL_CODE' ";
				$db_dpis2->send_cmd($cmd);
				$data2 = $db_dpis2->get_array();
				$TMP_POSITION = (trim($data2[PL_NAME]))? "$data2[PL_NAME]$POSITION_LEVEL" : ""; 
			}
		} // end if	
		if($TMP_POEM_ID){
			unset($arr_ORG_ID, $TMP_ORG_NAME, $TMP_ORG_NAME_1);
			$cmd = " 	select ORG_ID, ORG_ID_1, PN_CODE from PER_POS_EMP   
							where POEM_ID=$TMP_POEM_ID ";
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$PN_CODE = trim($data2[PN_CODE]);		
			if($select_org_structure==1){
				$cmd = " 	select ORG_ID, ORG_ID_1 from PER_PERSONAL  
								where POEM_ID=$TMP_POEM_ID ";
				$db_dpis2->send_cmd($cmd);
				$data2 = $db_dpis2->get_array();
			}
			$temp_ORG_ID = $data2[ORG_ID] + 0;
			$temp_ORG_ID_1 = $data2[ORG_ID_1] + 0;
			$cmd = "	select ORG_ID, ORG_NAME from PER_ORG where ORG_ID in ($temp_ORG_ID, $temp_ORG_ID_1)";
			if($select_org_structure==1) $cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd);
			$db_dpis2->send_cmd($cmd);
			while ($data2 = $db_dpis2->get_array() ) {
				$temp_id = trim($data2[ORG_ID]);
				$TMP_ORG_NAME = ($temp_ORG_ID == $temp_id)? trim($data2[ORG_NAME]) : "$TMP_ORG_NAME";
				$TMP_ORG_NAME_1 = ($temp_ORG_ID_1 == $temp_id)? trim($data2[ORG_NAME]) : "$TMP_ORG_NAME_1";	
			}
			if (trim($PN_CODE)) {
				$cmd = " select PN_NAME from PER_POS_NAME where PN_CODE = '$PN_CODE' ";
				$db_dpis2->send_cmd($cmd);
				$data2 = $db_dpis2->get_array();
				$TMP_POSITION = (trim($data2[PN_NAME]))? "$data2[PN_NAME] " . level_no_format($LEVEL_NAME) : ""; 
			}			
		} // end if
		if($TMP_POEMS_ID){
			unset($arr_ORG_ID, $TMP_ORG_NAME, $TMP_ORG_NAME_1);
			$cmd = " 	select ORG_ID, ORG_ID_1, EP_CODE from PER_POS_EMPSER    
							where POEMS_ID=$TMP_POEMS_ID ";
			$db_dpis2->send_cmd($cmd);
			//$db_dpis2->show_error();
			$data2 = $db_dpis2->get_array();
			$EP_CODE = trim($data2[EP_CODE]);	
			if($select_org_structure==1){
				$cmd = " 	select ORG_ID, ORG_ID_1 from PER_PERSONAL  
								where POEMS_ID=$TMP_POEMS_ID ";
				$db_dpis2->send_cmd($cmd);
				$data2 = $db_dpis2->get_array();
			}
			$temp_ORG_ID = $data2[ORG_ID] + 0;
			$temp_ORG_ID_1 = $data2[ORG_ID_1] + 0;
			$cmd = "	select ORG_ID, ORG_NAME from PER_ORG where ORG_ID in ($temp_ORG_ID, $temp_ORG_ID_1)";
			if($select_org_structure==1) $cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd);
			$db_dpis2->send_cmd($cmd);
			while ($data2 = $db_dpis2->get_array() ) {
				$temp_id = trim($data2[ORG_ID]);
				$TMP_ORG_NAME = ($temp_ORG_ID == $temp_id)? trim($data2[ORG_NAME]) : "$TMP_ORG_NAME";
				$TMP_ORG_NAME_1 = ($temp_ORG_ID_1 == $temp_id)? trim($data2[ORG_NAME]) : "$TMP_ORG_NAME_1";	
			}
			if (trim($EP_CODE)) {
				$cmd = " select EP_NAME from PER_EMPSER_POS_NAME where EP_CODE = '$EP_CODE' ";
				$db_dpis2->send_cmd($cmd);
				$data2 = $db_dpis2->get_array();
				$TMP_POSITION = (trim($data2[EP_NAME]))? "$data2[EP_NAME] " . level_no_format($LEVEL_NAME) : ""; 
			}			
		} // end if
		if($TMP_POT_ID){
			unset($arr_ORG_ID, $TMP_ORG_NAME, $TMP_ORG_NAME_1);
			$cmd = " 	select ORG_ID, ORG_ID_1, TP_CODE from PER_POS_TEMP    
							where POT_ID=$TMP_POT_ID ";
			$db_dpis2->send_cmd($cmd);
			//$db_dpis2->show_error();
			$data2 = $db_dpis2->get_array();
			$TP_CODE = trim($data2[TP_CODE]);		
			if($select_org_structure==1){
				$cmd = " 	select ORG_ID, ORG_ID_1 from PER_PERSONAL  
								where POT_ID=$TMP_POT_ID ";
				$db_dpis2->send_cmd($cmd);
				$data2 = $db_dpis2->get_array();
			}
			$temp_ORG_ID = $data2[ORG_ID] + 0;
			$temp_ORG_ID_1 = $data2[ORG_ID_1] + 0;
			$cmd = "	select ORG_ID, ORG_NAME from PER_ORG where ORG_ID in ($temp_ORG_ID, $temp_ORG_ID_1)";
			if($select_org_structure==1) $cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd);
			$db_dpis2->send_cmd($cmd);
			while ($data2 = $db_dpis2->get_array() ) {
				$temp_id = trim($data2[ORG_ID]);
				$TMP_ORG_NAME = ($temp_ORG_ID == $temp_id)? trim($data2[ORG_NAME]) : "$TMP_ORG_NAME";
				$TMP_ORG_NAME_1 = ($temp_ORG_ID_1 == $temp_id)? trim($data2[ORG_NAME]) : "$TMP_ORG_NAME_1";	
			}
			if (trim($TP_CODE)) {
				$cmd = " select TP_NAME from PER_TEMP_POS_NAME where TP_CODE = '$TP_CODE' ";
				$db_dpis2->send_cmd($cmd);
				$data2 = $db_dpis2->get_array();
				$TMP_POSITION = (trim($data2[TP_NAME]))? "$data2[TP_NAME] " . level_no_format($LEVEL_NAME) : ""; 
			}			
		} // end if
		$TMP_ORG_NAME = (trim($TMP_ORG_NAME))?  $TMP_ORG_NAME : "-";
		$TMP_ORG_NAME_1 = (trim($TMP_ORG_NAME_1))?  $TMP_ORG_NAME_1 : "-";			

		$returnValue = "$TMP_PER_ID<::>$TMP_PER_NAME<::>$PER_TYPE<::>$TMP_MV_ID";

		$class = "table_body";
		$onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" ";
?>
          > 
            = 5)) {
	  			echo ""; 
	 		 } else { ?>
      			= 5)) {
      			echo "";
	 		} else {?>

          
 
            

            

              
            
            

              
             / 
			
            

            สังกัด
			
	        
สังกัดที่ขอย้ายตามลำดับ
	
			

			  
			วันที่ขอย้าย
		
			


	  

      
      

      
      
      

      
          
		  

		    
1
		    
2
		    
3
		  

            
 
			
 
            
 
			
			
 $ORG_NAME_1"?>
			
 $ORG_NAME_2"?>
			
 $ORG_NAME_3"?>
			

						

      
 ">
	  
-
 ">
	  	
	  
-
">
	  
          
          
          
          
 
            
 
            
 
            
 
            
 
			
            
 
            
 
            
 
            
 
            	
      
 
      
 

      
 

          
          
        
   1) : ?>