กลุ่มผู้ใช้งาน : [ ]
 

   
>
 
ข้อมูล
   ข้อมูลเข้าระบบ
กลุ่มผู้ใช้งาน : 
ชื่อผู้ใช้งาน :  " size="20" maxlength="30" style="width:70%" readonly>
> " size="20" maxlength="30" style="width:70%" onKeyPress="form1.user_type[0].checked=true;">
> " size="20" maxlength="30" style="width:70%" readonly> เลือกรายชื่อข้าราชการ
เปลี่ยนรหัสผ่าน : รหัสผ่านใหม่ :  
ยืนยันรหัสผ่าน : 
แสดงรหัสผ่าน
   
   ข้อมูลส่วนตัว
   
 :  >
 :  >
 :  >
อีเมล์ : 
เบอร์โทร. : 
เบอร์แฟกซ์. : 
 : 
 : 
<?=$CLEAR_TITLE?>
send_cmd($sql); while ($data9 = $db->get_array()) { $data9 = array_change_key_case($data9, CASE_LOWER); $tmp_username_md5 = md5($data9[username]); $userpw_arr[]= " password='".$tmp_username_md5."'"; } } $inuserpw=implode(" or ",$userpw_arr); if(count($userpw_arr)){ $conditionUserPW=' and ('.$inuserpw.')'; } if($selectFlag=='0'){ $val_user_flag=""; }else{ if($selectFlag){ $val_user_flag=" user_flag='".$selectFlag."' AND "; }else{ $val_user_flag=""; } } } $cmd =" select count(id) as count_data from user_detail where $val_user_flag group_id=$group_id $search_condition ".$conditionUserPW; //echo '

'.$cmd; $db->send_cmd($cmd); // $db->show_error(); $data = $db->get_array(); $data = array_change_key_case($data, CASE_LOWER); $count_data = $data[count_data]; ?>  
รหัส :  ชื่อ : 
> รหัสผู้ใช้ตรงกับรหัสผ่าน สถานะ : 

   รหัสผู้ใช้ตรงกับรหัสผ่าน'; echo '   ชื่อผู้ใช้งาน : ชื่อผู้ใช้งานที่ถูกยกเลิก'; } ?>
 
พบข้อมูลรายชื่อผู้ใช้งาน ทั้งสิ้น รายการ
1){ if($db_type=="mssql"){ $limit_data = " and id not in (select top $start_record id from user_detail where user_flag='Y' and group_id = $group_id $search_condition order by group_id, username) "; }elseif($db_type=="oci8"){ $limit_data = " and id not in (select * from (select id from user_detail where user_flag='Y' and group_id = $group_id $search_condition order by group_id, username) where rownum <= ". (($current_page - 1) * $data_per_page) .")"; } } // end if if($db_type=="mssql"){ $cmd = " select top $data_per_page id, group_id, username, fullname, user_link_id, address, titlename from user_detail where user_flag='Y' and group_id = $group_id $search_condition $limit_data order by $order_str2 "; }elseif($db_type=="mysql"){ $cmd = " select id, group_id, username, fullname, user_link_id, address, titlename , password ,user_flag from user_detail where user_flag='Y' and group_id=$group_id $search_condition order by $order_str2 $limit_data "; }elseif($db_type=="oci8"){ $cmd = " select * from ( select id, group_id, username, fullname, user_link_id, address, titlename ,password,user_flag from user_detail where $val_user_flag group_id=$group_id $search_condition $conditionUserPW $limit_data order by $order_str2 ) where rownum <= $data_per_page "; } //echo "
".$cmd; 
	if ($db->send_cmd($cmd)) {
		//$db->show_error();
?>
	get_array()) {
			$data = array_change_key_case($data, CASE_LOWER);
                        $tag_s_begin='';
                        $tag_s_end='';
                        $user_flag = $data[user_flag];
                        if($user_flag=='N'){
                            $tag_s_begin='';
                            $tag_s_end='';
                        }
			$tmp_id = $data[id];
			$username = $data[username];
            $password = $data[password];
                        

                        
                        
			$user_link_id = $data[user_link_id];
			if($user_link_id){
				if($DPISDB=="odbc")
					$cmd = " select 	b.PN_NAME, a.PER_NAME, a.PER_SURNAME, a.PER_TYPE, d.ORG_NAME, f.ORG_NAME as EMP_ORG_NAME , h.ORG_NAME as EMPSER_ORG_NAME , j.ORG_NAME as TEMP_ORG_NAME
									 from 	(	
												  (
													(
														(
															(
																(
															(
																(
																	PER_PERSONAL a
																	left 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_ORG d on (c.ORG_ID=d.ORG_ID)
														) left join PER_POS_EMP e on (a.POEM_ID=e.POEM_ID)
													) left join PER_ORG f on (e.ORG_ID=f.ORG_ID)
												) left join PER_POS_EMPSER g on (a.POEMS_ID=g.POEMS_ID)
											) left join PER_ORG h on (g.ORG_ID=h.ORG_ID)
										) left join PER_POS_TEMP i on (a.POT_ID=i.POT_ID)
									) left join PER_ORG j on (i.ORG_ID=j.ORG_ID)
									 where 	a.PER_ID=". $user_link_id;
				elseif($DPISDB=="oci8")
					$cmd = " select 	b.PN_NAME, a.PER_NAME, a.PER_SURNAME, a.PER_TYPE, d.ORG_NAME, f.ORG_NAME as EMP_ORG_NAME , h.ORG_NAME as EMPSER_ORG_NAME, j.ORG_NAME as TEMP_ORG_NAME
									 from 		PER_PERSONAL a, PER_PRENAME b, PER_POSITION c, PER_ORG d, PER_POS_EMP e, PER_ORG f , PER_POS_EMPSER g , PER_ORG h , PER_POS_TEMP i , PER_ORG j
									 where 	a.PN_CODE=b.PN_CODE(+) and a.POS_ID=c.POS_ID(+) and c.ORG_ID=d.ORG_ID(+) 
													and a.POEM_ID=e.POEM_ID(+) and e.ORG_ID=f.ORG_ID(+) and a.POEMS_ID=g.POEMS_ID(+) and g.ORG_ID=h.ORG_ID(+) and a.POT_ID=i.POT_ID(+) and i.ORG_ID=j.ORG_ID(+)
													and a.PER_ID=". $user_link_id;
				$db_dpis->send_cmd($cmd);
	//			echo $cmd;
	//			$db_dpis->show_error();
				$data_dpis = $db_dpis->get_array();
				$user_name = $data_dpis[PN_NAME] . (trim($data[PN_NAME])?" ":"") . $data_dpis[PER_NAME] ." ". $data_dpis[PER_SURNAME];
				if($data_dpis[PER_TYPE]==1) $address = $data_dpis[ORG_NAME];
				elseif($data_dpis[PER_TYPE]==2) $address = $data_dpis[EMP_ORG_NAME];
				elseif($data_dpis[PER_TYPE]==3) $address = $data_dpis[EMPSER_ORG_NAME];
				elseif($data_dpis[PER_TYPE]==4) $address = $data_dpis[TEMP_ORG_NAME];
			}else{
				$address = $data[address];
			} // end if
	
			$fullname = "";
			if ($user_link_id) {
				if($DPISDB=="odbc")
					$cmd = " select 	b.PN_NAME, a.PER_NAME, a.PER_SURNAME 
									 from 		PER_PERSONAL a
													left join PER_PRENAME b on a.PN_CODE=b.PN_CODE
									 where 	a.PER_ID=". $user_link_id;
				elseif($DPISDB=="oci8")
					$cmd = " select 	b.PN_NAME, a.PER_NAME, a.PER_SURNAME 
									 from 		PER_PERSONAL a, PER_PRENAME b 
									 where 	a.PN_CODE=b.PN_CODE(+) and a.PER_ID=". $user_link_id;
				elseif($DPISDB=="mysql")
					$cmd = " select 	b.PN_NAME, a.PER_NAME, a.PER_SURNAME 
									 from 		PER_PERSONAL a
													left join PER_PRENAME b on a.PN_CODE=b.PN_CODE
									 where 	a.PER_ID=". $user_link_id;
				$db_dpis->send_cmd($cmd);
	//			$db_dpis->show_error();
				$data_dpis = $db_dpis->get_array();
	//___	$fullname = $data_dpis[PN_NAME] . (trim($data[PN_NAME])?" ":"") . $data_dpis[PER_NAME] ." ". $data_dpis[PER_SURNAME];
			     /*เดิม*/	
                            //$fullname = $data_dpis[PER_NAME] ." ". $data_dpis[PER_SURNAME];
                            /* Release 5.1.0.5 Begin*/
                            $fullname = $data_dpis[PN_NAME].$data_dpis[PER_NAME] ." ". $data_dpis[PER_SURNAME];
                            /* Release 5.1.0.5 End*/
			}	
                        /*เดิม*/
			//if (!trim($fullname)) $fullname = $data[fullname].$data[titlename];	
                        /* Release 5.1.0.5 Begin*/
                        if (!trim($fullname)) $fullname = $data[titlename].$data[fullname];	
		        /* Release 5.1.0.5 End*/
			$class = "table_body";
			$onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" ";
			if($id==$tmp_id){ 
				$class = "table_body_over";
				$onmouse_event = "";
			} // end if
                        
                        $iconchk='';
                        $md5_username=md5($username);
                        if($md5_username==$password && $SESS_USERGROUP==1 && $Submit_duplicate){
                            $iconchk='รหัสผู้ใช้ตรงกับรหัสผ่าน แนะนำให้เปลี่ยนรหัสผ่าน   ';
                        }
	?>
	  > 
		';
                }?>
		

	  
 
		ชื่อผู้ใช้งาน
		 
		
		
		
		
		
		
		
          
	  

	  

		 
		 
		
		">แก้ไขข้อมูล
		
		
		  
		  ">ลบข้อมูล
		   		
		
          
		
		  
            
		 
		  
		  >
		  
		  
		 
		   		
		
	  

	  
        
    

       
       
       
	   
	   
      
	  
	    
	  
      
    


    
	

   1) : ?>