<?
	class common_location
	{		
		public function get_details($id)
		{
			global $database;
			 
			$get_clients = "
			SELECT *
			FROM $db_name"."clients_locations
			WHERE id = '$id'
			LIMIT 1
			";
			$results = $database->getRow($get_clients);	
		
			return $results;				
		}

		public function get_contacts($id)
		{
			global $database;
			 
			$sql = "
			SELECT *
			FROM $db_name"."contacts
			WHERE location_id = '$id'
			LIMIT 1
			";
			$results = $database->getAll($sql);	
						
			return $results;				
		}
								
		public function get_locations()
		{			
			global $database;
			
			$sql = "
			SELECT id, CONCAT(address,', ', suburb,', ', state,', ', post_code) AS name
			FROM clients_locations
			";
			$results = $database->getAll($sql);

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;
						
			return $results;			
		}	
		
		public function get_all_locations($client_id)
		{			
			global $database;
			
			$sql = "
			SELECT id, CONCAT(address,' ', suburb,' ', state,' ', post_code) AS name
			FROM clients_locations
			WHERE client_id = '$client_id'
			";
			$results = $database->getAll($sql);

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;
						
			return $results;			
		}	
		
		public function get_location($location_id)
		{			
			global $database;
			
			$sql = "
			SELECT CONCAT(address,' ', suburb,' ', state,' ', post_code) AS address
			FROM clients_locations
			WHERE id = '$location_id'
			";
			$result = $database->getOne($sql);
						
			return $result;			
		}																			
	}

?>