<?
	function hoa_mastermap(){
		
		// THESE ARE THE COLUMNS IN THE MASTER HOA REVIEW TABLE.
		// THESE ARE ALSO THE COLUMNS WE LOOK FOR WHEN DECIDING WHETHER AN ASSOCIATED HOA NEEDS TO BE REVIEW OR NOT.
		$column_map['hoaname'] = "HOA Name";
		$column_map['hoaaddress'] = "Address";
		$column_map['hoaaddress2'] = "Address 2";
		$column_map['hoacity'] = "City";
		$column_map['hoastate'] = "State";
		$column_map['hoazip'] = "Zip";
		$column_map['hoacontact'] = "Contact";
		$column_map['hoaphone'] = "Phone"; 
		$column_map['hoafax'] = "Fax";
		$column_map['hoaemail'] = "Email";
		$column_map['hoadues'] = "Dues";
		$column_map['hoawebsite'] = "Website";
		$column_map['hoadocumentinstr'] = "Document Instructions";
		$column_map['hoaupdated'] = "Last Change Submitted";
		return $column_map;
	}
	
	function hoa_get_hoa($hoaid)
	{
		$hoaid = db_number($hoaid);
		if ($hoaid == 0)
			return "";
		
		$sql = "select * from tblhoa where hoaid = $hoaid";
		return db_first($sql);
	}
	
	function hoa_get_hoaname_array($hoaid_array)
	{
		if(empty($hoaid_array))
			return array();
		
		$sql = "select 	* 
				from	tblhoa
				where	hoaid in (
						". implode(',', $hoaid_array) ."
						)
				order by hoaid
						";
		
		return db_query($sql,1,0,hoaid);
	}
	//Expects hoa key created in array already made up of a string of filds that would define if all matched would be a duplicate.
	//See functions_customfield_ob.php where state and national hoa queries are being done.
	function hoa_removeduplicate($hoaarr)
	{
		if(!is_array($hoaarr))
			return $hoaarr;
	
		$bigkeyarr=array();
		
		foreach($hoaarr as $k=>$hoainfo)
		{
			if(!$bigkeyarr[$hoainfo['hoakey']] || ($bigkeyarr[$hoainfo['hoakey']]<$hoainfo['hoaid']))
				$bigkeyarr[$hoainfo['hoakey']]=$hoainfo['hoaid'];
		}
		//d('$hoaarr',$hoaarr);	
		foreach($hoaarr as $k=>$hoainfo)
		{
			if(!in_array($hoainfo['hoaid'],$bigkeyarr))
				unset($hoaarr[$k]);
		}	
		//d('$bigkeyarr',$bigkeyarr);
		//unset($bigkeyarr);
		//d('$hoaarr',$hoaarr);
	
		return $hoaarr;
	}
	
	
	
?>