;"> = '$temp_start' and COM_DATE <= '$temp_end')"; } elseif(trim($search_comdate_start) && !trim($search_comdate_end)) { $temp_start = (substr($search_comdate_start, 6, 4) - 543) ."-". substr($search_comdate_start, 3, 2) ."-". substr($search_comdate_start, 0, 2); $arr_search_condition[] = "(COM_DATE >= '$temp_start')"; } elseif(!trim($search_comdate_start) && trim($search_comdate_end)) { $temp_end = (substr($search_comdate_end, 6, 4) - 543) ."-". substr($search_comdate_end, 3, 2) ."-". substr($search_comdate_end, 0, 2); $arr_search_condition[] = "(COM_DATE <= '$temp_end')"; } $search_condition_bkk_department = ""; if ($BKK_FLAG==1 || $MFA_FLAG==1){ $search_condition_bkk_department = " or a.DEPARTMENT_ID IS NULL"; } if($search_department_id){ $arr_search_condition[] = "(a.DEPARTMENT_ID = $search_department_id)"; }elseif($search_ministry_id){ $cmd = " select ORG_ID from PER_ORG where ORG_ID_REF=$search_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) .") $search_condition_bkk_department )"; }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[] = "(a.DEPARTMENT_ID in (". implode(",", $arr_org) .") $search_condition_bkk_department )"; } // end if if ($COM_SITE == "personal_workflow" && $SESS_USERGROUP_LEVEL < 5) { // àÃÕ¡¨Ò¡ personal_workflow áÅÐ Êèǹ¡ÅÒ§à»ç¹¼ÙéàÃÕ¡´Ù if ($ORG_ID && $ORG_ID!="NULL") { // ÁÕ ORG_ID $search_org = "and ORG_ID = $ORG_ID and COM_STATUS='S'"; } else { $search_org = "and ORG_ID > 0 and COM_STATUS='S'"; } } else if ($COM_SITE != "personal_workflow" && $SESS_USERGROUP_LEVEL < 5) { // àÃÕ¡¨Ò¡â»Ãá¡ÃÁÍ×è¹ æ Êèǹ¡ÅÒ§à»ç¹¼ÙéàÃÕ¡´Ù if ($ORG_ID && $ORG_ID!="NULL") { // ÁÕ ORG_ID $search_org = "and ORG_ID = $ORG_ID and COM_STATUS='S'"; } elseif ($search_org_id && $search_org_id!="NULL") { $search_org = "and ORG_ID=$search_org_id"; } else { if($command=="SEARCH"){ $search_org = ""; // à¾×èÍãËé¢Öé¹·Ñ駷ÕèãÊèÊӹѡ¡Í§ÁÒ áÅÐäÁèãÊèÁÒ // $search_org = "and (ORG_ID=0 or ORG_ID is NULL or (ORG_ID >0 and COM_STATUS='S'))"; }else{ //áÊ´§·Ñé§ËÁ´ command=="" $search_org = ""; } } } else { // àÃÕ¡´Ù ¢éÍÁÙŵÒÁ ·ÕèàÅ×Í¡ if ($ORG_ID && $ORG_ID!="NULL") { // ÁÕ ORG_ID $search_org = "and ORG_ID=$ORG_ID"; } elseif ($search_org_id && $search_org_id!="NULL") { $search_org = "and ORG_ID=$search_org_id"; } else { $search_org = "and (ORG_ID=0 or ORG_ID is NULL or (ORG_ID >0 and COM_STATUS='S'))"; } } //$search_com_type=""; if ($COM_TYPE_NM=="àÅ×è͹à§Ô¹à´×͹") { $arr_search_condition[]="a.COM_TYPE <> '5240' and a.COM_TYPE <> '9999'"; } elseif ($COM_TYPE_NM=="»ÃѺÍѵÃÒà§Ô¹à´×͹ãËÁè") { $arr_search_condition[]="a.COM_TYPE in ('5240','9999')"; } elseif ($search_com_type) { $arr_search_condition[]="a.COM_TYPE='$search_com_type'"; } else { $search_com_type=""; } if ($MFA_FLAG==1) $arr_search_condition[] = " and (COM_GROUP in ('01','501') or (COM_GROUP = '503' and a.COM_LEVEL_SALP is NULL))"; $search_condition = ""; if(count($arr_search_condition)) $search_condition = " and " . implode(" and ", $arr_search_condition); $cmd = " select COM_ID from PER_COMMAND a, PER_COMTYPE b where COM_GROUP in ($COM_GROUP_IN) and a.COM_TYPE=b.COM_TYPE $search_condition $search_org"; $count_data_dtl = $db_dpis->send_cmd($cmd); // echo "=> $cmd ($count_data_dtl)
"; $total_page = ceil( $count_data_dtl / $data_per_page ); $page_link_dtl = create_link_page_data($total_page, $current_page,'form0'); ?>

:   :   :       :  >  :   :  >    :  >     :  $value){ ?> >

 

¾º·Ñé§ÊÔé¹ ÃÒ¡ÒÃ

¾º·ÕèäÁèÊÒÁÒöÂ×¹ÂѹºÑ­ªÕṺ·éÒÂä´é

1){ $limit_data = " and COM_ID not in (select top $start_record COM_ID from PER_COMMAND a, PER_COMTYPE b where COM_GROUP in ($COM_GROUP_IN) and a.COM_TYPE=b.COM_TYPE order by COM_DATE) "; } // end if $cmd = " select top $data_per_page COM_ID, COM_NO, a.COM_NAME, COM_DATE, a.COM_TYPE, COM_CONFIRM, COM_STATUS, ORG_ID, COM_PER_TYPE from PER_COMMAND a, PER_COMTYPE b where COM_GROUP in ($COM_GROUP_IN) and a.COM_TYPE=b.COM_TYPE $search_condition $search_org $limit_data order by $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 COM_ID, COM_NO, a.COM_NAME, COM_DATE, a.COM_TYPE, COM_CONFIRM, COM_STATUS, ORG_ID, COM_PER_TYPE from PER_COMMAND a, PER_COMTYPE b where COM_GROUP in ($COM_GROUP_IN) and a.COM_TYPE=b.COM_TYPE $search_condition $search_org order by $order_str ) q1 ) where rnum between $rec_start and $rec_end "; }elseif($DPISDB=="mysql"){ $cmd = " select COM_ID, COM_NO, a.COM_NAME, COM_DATE, a.COM_TYPE, COM_CONFIRM, COM_STATUS, ORG_ID, COM_PER_TYPE from PER_COMMAND a, PER_COMTYPE b where COM_GROUP in ($COM_GROUP_IN) and a.COM_TYPE=b.COM_TYPE $search_condition $search_org order by $order_str $limit_data "; } // end if $count_page_data = $db_dpis->send_cmd($cmd); //echo "$count_page_data ->".$cmd; //echo"

".$cmd;
//	$db_dpis->show_error();
	if ($count_page_data) {
?>
  = 5) { ?>
			  get_array()) {
		$data_count++;
		$data_num++;
		if($data_count > $data_per_page) break;
		$TMP_COM_ID = $data[COM_ID];
		$current_list .= ((trim($current_list))?",":"") . $TMP_COM_ID;
		$TMP_COM_NO = trim($data[COM_NO]);
		$TMP_COM_NAME = trim($data[COM_NAME]);
		$TMP_COM_DATE = show_date_format($data[COM_DATE], 1);
		$TMP_COM_CONFIRM = trim($data[COM_CONFIRM]);
		$TMP_COM_STATUS = trim($data[COM_STATUS]);
		$TMP_ORG_ID = $data[ORG_ID];
		if ($TMP_ORG_ID > 0) {
			$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 = trim($data2[ORG_NAME]);
		} else {
			$TMP_ORG_NAME = "";
		}
		
		$TMP_COM_PER_TYPE = $data[COM_PER_TYPE];
		$TMP_COM_TYPE = trim($data[COM_TYPE]);
		$TMP_COM_TYPE_NAME = "";
		$cmd = "select COM_DESC from PER_COMTYPE where COM_TYPE='$TMP_COM_TYPE' ";
		$db_dpis2->send_cmd($cmd);
		$data2 = $db_dpis2->get_array();
		$TMP_COM_TYPE_NAME = trim($data2[COM_DESC]);

		$cmd = "select count(COM_ID) as COUNT_COMDTL from PER_COMDTL where COM_ID=$TMP_COM_ID ";
		$count_comdtl = $db_dpis2->send_cmd($cmd);
		$data2 = $db_dpis2->get_array();
		$TMP_COUNT_COMDTL = trim($data2[COUNT_COMDTL]);

		$class = "table_body";
		$onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" ";
		if($COM_ID==$TMP_COM_ID){ 
			$class = "table_body_over";
			$onmouse_event = "";
		} // end if	
?>
    >
      ";
				//¹Ñº¨Ó¹Ç¹ä¿Åì·Ñé§ËÁ´ã¹ folder
				$numfiles=0;
				if ($dh = opendir($FILE_PATH)) {
					while (($file = readdir($dh)) !== false) {	//---ÍèÒ¹ä¿Åì·Ñé§ËÁ´ÁÒ¨Ò¡ folder ($FILE_PATH) ¹Ñé¹
						if ($file != "." && $file != "..") {
							$numfiles++;
						} // end if
			   		} // while loop readdir
					closedir($dh);
				} // end if
//				echo "numfiles=$numfiles
";
		  ?>
		= 5 && $TMP_COM_STATUS=="S"))) {
				echo "";
			} else { ?>
		      = 5 && $TMP_COM_STATUS=="S"))) {
      		echo "";
	 	 } else {?>
	      

    

	  

      

      

      

      

	  

	  

	  
			  

	  
	  

	
 		

    
      

      

    
    

      
 
      
 
      
 
      
 
	  

	  		  
			  
			 ()
	  
	  

	   		= 5 && $TMP_COM_STATUS=="S") { ?> 
					 
			= 5) { ?> 
					 
			
	  
      
 
	  	">
   	      
  ">

	
-
 
	  		 ">
	 
	  
-
">
	  
    
    
    

      
 
      
 
      
 
      
 
      
 
      
 
      
 
      
 
	
	      
 
    
      
 

      
 

    
	
  
   1) : ?>
  
   

"> send_cmd($cmd); $total_page = ceil( $count_data / $data_per_page ); $page_link = create_link_page_data($total_page, $current_page,'form11'); } $limit_data = ""; ?>

*  :  *  :   :    > ºÃèØáÅÐáµè§µÑ駼ÙéÊͺá¢è§¢Ñ¹ä´é > ºÃèáÅÐáµè§µÑé§Ø¼ÙéÊͺá¢è§¢Ñ¹ä´é (902) > ºÃèØáÅÐáµè§µÑ駼Ùéä´éÃѺ¤Ñ´àÅ×Í¡ > ºÃèØáÅÐáµè§µÑ駼Ùéä´éÃѺ¤Ñ´àÅ×Í¡ (902) > ÃѺâ͹¾¹Ñ¡§Ò¹Êèǹ·éͧ¶Ôè¹ > ºÃèؼÙéà¤Âà»ç¹¢éÒÃÒª¡ÒáÅѺà¢éÒÃѺÃÒª¡Òà > ÃѺâ͹¢éÒÃÒª¡ÒþÅàÃ×͹ÊÒÁÑ­ µèÒ§ÊÒ§ҹ > ÃѺâ͹¢éÒÃÒª¡ÒþÅàÃ×͹ÊÒÁÑ­ ÊÒ§ҹà´ÕÂǡѹ > ºÃèؼÙéÊͺá¢è§¢Ñ¹ä´é > ºÃèؼÙéä´éÃѺ¤Ñ´àÅ×Í¡ > ÃѺâ͹¾¹Ñ¡§Ò¹Êèǹ·éͧ¶Ôè¹ > ºÃèؼÙéà¤Âà»ç¹¢éÒÃÒª¡ÒáÅѺà¢éÒÃѺÃÒª¡Òà > ÃѺâ͹¢éÒÃÒª¡ÒþÅàÃ×͹ÊÒÁÑ­ > ÃѺâ͹¢éÒÃÒª¡ÒþÅàÃ×͹ÊÒÁÑ­ÁÒáµè§µÑé§ãËé´ÓçµÓá˹è§ã¹ÃдѺ·ÕèÊÙ§¢Öé¹ *  :  " style="width:80%" class="textbox" >  :  >  :  " style="width:80%" class="textbox" > *  :   :  <?=$COM_NOTE?>  *  :  $value){ ?>>  :   :  = 5 && $COM_STATUS != "S"))){?> ');" value=""> ');"> = 5 && $COM_STATUS != "S") { ?>   = 5 && $COM_STATUS=="S") { ?>

¾º·ÕèäÁèÊÒÁÒöÂ×¹ÂѹºÑ­ªÕṺ·éÒÂä´é   ¤Ø³µéͧ¡ÒôÓà¹Ô¹¡ÒÃÂ×¹ÂѹµèÍãªèËÃ×ÍäÁè

>àÅ¢ÍÒúԤ >àÅ¢ä·Â $value){ ?> > ¾º¢éÍÁÙÅ·Ñé§ÊÔé¹ ÃÒ¡Òà  : >  >  >

1){ if($DPISDB=="odbc"){ $limit_data = " and PER_ID not in (select top $start_record PER_ID from PER_COMDTL where COM_ID=$COM_ID order by CMD_SEQ) "; }elseif($DPISDB=="mysql"){ $limit_data = " limit " . (($current_page - 1) * $data_per_page) . ", " . $data_per_page; } } // end if if ($COM_ID) { if($DPISDB=="odbc"){ $cmd = " select top $data_per_page a.PER_ID, b.PN_CODE, PER_NAME, PER_SURNAME, CMD_POSITION, CMD_ORG3, a.CMD_LEVEL, a.PL_NAME_WORK, a.ORG_NAME_WORK, CMD_SEQ from PER_COMDTL a, PER_PERSONAL b where COM_ID=$COM_ID and a.PER_ID=b.PER_ID $limit_data order by $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 a.PER_ID, b.PN_CODE, PER_NAME, PER_SURNAME, CMD_POSITION, CMD_ORG3, a.CMD_LEVEL, a.PL_NAME_WORK, a.ORG_NAME_WORK, CMD_SEQ from PER_COMDTL a, PER_PERSONAL b where COM_ID=$COM_ID and a.PER_ID=b.PER_ID order by $order_str ) q1 ) where rnum between $rec_start and $rec_end "; }elseif($DPISDB=="mysql"){ $cmd = " select a.PER_ID, b.PN_CODE, PER_NAME, PER_SURNAME, CMD_POSITION, CMD_ORG3, a.CMD_LEVEL, a.PL_NAME_WORK, a.ORG_NAME_WORK, CMD_SEQ from PER_COMDTL a, PER_PERSONAL b where COM_ID=$COM_ID and a.PER_ID=b.PER_ID order by $order_str $limit_data "; } // end if $count_page_data = $db_dpis->send_cmd($cmd); //$db_dpis->show_error(); //echo "

".$cmd;	
	}
	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_CMD_SEQ = $data[CMD_SEQ];
		$TMP_PER_NAME = $data[PER_NAME] ." ". $data[PER_SURNAME];
		if($DPISDB=="mysql"){
			$temp = explode("|", trim($data[CMD_POSITION]));
		}else{
			$temp = explode("\|", trim($data[CMD_POSITION]));
		}
		$TMP_PL_NAME = $temp[0];
		$TMP_PM_NAME = $temp[1];
		$NEW_POSITION = trim($data[PL_NAME_WORK]);
		$NEW_ORG = trim($data[ORG_NAME_WORK]);
		$TMP_CMD_LEVEL = trim($data[CMD_LEVEL]);
		$cmd = " select LEVEL_NAME, POSITION_LEVEL from PER_LEVEL where LEVEL_NO='$TMP_CMD_LEVEL' ";
		$db_dpis2->send_cmd($cmd);
		$data2 = $db_dpis2->get_array();
		$TMP_LEVEL_NAME = $data2[LEVEL_NAME];
		$POSITION_LEVEL = $data2[POSITION_LEVEL];
		if (!$POSITION_LEVEL) $POSITION_LEVEL = $TMP_LEVEL_NAME;
		
		$TMP_POSITION = pl_name_format($TMP_PL_NAME, $TMP_PM_NAME, $TMP_PT_NAME, $TMP_CMD_LEVEL, 2);	
		$TMP_ORG = (trim($data[CMD_ORG3]))? $data[CMD_ORG3] : "-";
	
		$PN_CODE = trim($data[PN_CODE]);
		$cmd = " select PN_NAME from PER_PRENAME where PN_CODE='$PN_CODE' ";
		$db_dpis1->send_cmd($cmd);
		$data1 = $db_dpis1->get_array();
		$PN_NAME = trim($data1[PN_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		
?>
    >
      = 5)) {
	  			echo ""; 
	 		 } else { ?>
      			= 5)) {
      			echo "";
	 		} else {?>
      			

    

	  

      

      

      
      
	  

      
      

      
      
      

      
    
    

      

      
Êѧ¡Ñ´
      
      

      
Êѧ¡Ñ´
      
    
    

      
 
      
 
      
 
      
 
      
 
      
 ">
	  
-
 ">
	  	
	  
-
">
	    
    
    
	
    

      
 
      
 
      
 
      
 
      
 
      
 
      
 
      
 

      
 

    
	
  
  
   1) : ?>