<?		
	$get_clients = "
	SELECT 
		clients.id,
		clients.company_name, 
		clients_locations.address, 
		clients_locations.suburb, 
		clients_locations.state, 
		clients_locations.post_code, 
		clients_locations.id AS location_id,
		clients_locations.business_phone AS phone,
		contacts.first_name,		
		contacts.last_name,				
		CONCAT(contacts.first_name,' ',contacts.last_name) AS contact_person,
		contacts.email AS email				
	FROM clients
		LEFT JOIN clients_locations ON (clients.primary_location_id  = clients_locations.id)
		LEFT JOIN contacts ON (clients.primary_contact_id = contacts.id)
	WHERE clients.id = '$client_id'
	ORDER BY clients.company_name ASC
	LIMIT 1
	";
	$result = $database->getRow($get_clients);

	$head_office = $result['address'].", ".$result['suburb'].", ".$result['state'].", ".$result['post_code'];
	
	$locations = common_location::get_all_locations($client_id);

	$options_select = array("class" => "medium form");
	
	$config['location_id'] = array("id"=> $id,"value"=> $result['location_id'], "input_name" => "location_id", "name" => "Location","rule" => "required");
	$validation['location_id'] = validation::initial($config['location_id']);						

	$branches['results'] = common_location::get_all_locations($client_id);
	$branches['chosen'] = $result['location_id'];					
					
	$location_select = forms::input_select($config['location_id'],$validation['location_id'],$branches,$options_select); 							
							
	$company_names = array(
		"id" => $result['id'], 
		"value" => $result['company_name'], 
		"description" => $result['address'], 
		"address" => $result['address'], 
		"suburb" => $result['suburb'], 
		"state" => $result['state'], 
		"post_code" => $result['post_code'], 
		"first_name" => $result['first_name'], 
		"last_name" => $result['last_name'], 
		"phone" => $result['phone'], 
		"contact_person" => $result['contact_person'], 
		"email" => $result['email'], 
		"head_office" => $head_office, 		
		"location_id" => $result['location_id'],
		"location_select" => $result['location_select']		
	);

	$json = json_encode($company_names);
		
	echo $json;		
?>