Function Reference: autocompleters_near

Summary

This function has not been documented yet.

Source File

autocompleters_near() is located in geodir_advance_search_filters/geodirectory_advance_search_function.php [Line: 2056]

Source Code

function autocompleters_near()
{
	global $wpdb;
	//print_r($_REQUEST);exit;
	
	
	if (!defined('POST_LOCATION_TABLE')){return;}
	$search = isset($_GET['q']) ? $_GET['q'] : '';
	
	if(!$search){return;}
	$loc_list = array();
	$countries = $wpdb->get_results(
					$wpdb->prepare(
						"SELECT * FROM ".POST_LOCATION_TABLE." WHERE country like %s GROUP BY country LIMIT 3",
						array($search.'%')
					)				
				);
	
	if(!empty($countries)){
		foreach($countries as $country){
			echo   $country->country." (Country) |".$country->country."|".$country->location_id."|1 n";
		}
	}
	
	$regions = $wpdb->get_results(
					$wpdb->prepare(
						"SELECT * FROM ".POST_LOCATION_TABLE." WHERE region like %s GROUP BY region LIMIT 3",
						array($search.'%')
					)				
				);
	//print_r($regions);
	if(!empty($regions)){
		foreach($regions as $region){
			echo   $region->region." (Region) |".$region->region."|".$region->location_id."|2 n";
		}
	}
	
	$cities = $wpdb->get_results(
					$wpdb->prepare(
						"SELECT * FROM ".POST_LOCATION_TABLE." WHERE city like %s GROUP BY city LIMIT 3",
						array($search.'%')
					)				
				);
	
	if(!empty($cities)){
		foreach($cities as $city){
			echo   $city->city." (City) |".$city->city."|".$city->location_id."|3 n";
		}
	}
	exit;
	//print_r($countries);exit;
	
	
	
	if(strlen($search)){
		switch($results){
			case 1: 
				
				$words1 = $wpdb->get_results(
					$wpdb->prepare(
						"SELECT concat( name, '|', sum( count ) ) name, sum( count ) cnt FROM ".$wpdb->prefix."terms t, ".$wpdb->prefix."term_taxonomy tt WHERE t.term_id = tt.term_id AND t.name LIKE %s AND tt.taxonomy in (".$geodir_terms_autocomplete.") GROUP BY t.term_id ORDER BY cnt DESC",
						array($search.'%')
					)				
				);
				
				
				$words2 = $wpdb->get_results(
					$wpdb->prepare(
						"SELECT post_title as name FROM $wpdb->posts where post_status='publish' and post_type in (".$gt_posttypes_autocomplete.") and post_date < '".current_time('mysql')."' and post_title LIKE %s ORDER BY post_title",
						array('%'.$search.'%')
					)
				);  
				
 				$words = array_merge((array)$words1 ,(array)$words2 ); 
				asort($words);
				break;
		} 
		
		foreach ($words as $word){
			if($results > 0){
				$id = isset($word->ID) ? $word->ID : '';
				echo $word->name."|".get_permalink($id)."n";
			}else{
				echo $word->name."n";
				}
		}
	}
}