"Houses for Rent",
"CONDO" => "Condos/Townhomes",
"APT" => "Apartments for Rent",
"CORP" => "Short-Term/Corporate",
);
$fHouseType = (isset($_GET['ht']))? $_GET['ht']:'HOUSE';
if (!array_key_exists($fHouseType, $houseTypesArray)) {
die("Invalid option");
}
$region_id = 200;
$area_sql = "SELECT id, area FROM property_areas WHERE region_id=".$region_id." order by area";
$area_result = get_array_from_dbmymprops($area_sql);
$area_count_mapping = array();
foreach($area_result as $curArea) {
$area_count_mapping[$curArea['area']] = array('count' => '0', 'area_id' => $curArea['id'], 'area'=>$curArea['area'] );
}
//print_r($area_count_mapping);
$area_href = "";
$area_counts_sql = "";
$bed_counts_sql = "";
if ($fHouseType == 'HOUSE') {
$area_counts_sql = "SELECT pa.area, count(*) as total
FROM property_areas pa LEFT JOIN property_communities pc on pa.id = pc.area
WHERE pa.region_id=".$region_id."
AND pc.status ='Active'
AND pc.house='1' AND pc.private_listing='1'
GROUP BY pa.id ";
$bed_counts_sql = "SELECT fp.bedrooms, count(*) as total
FROM property_communities pc
LEFT JOIN property_floorplans fp ON fp.community_id = pc.primary_id
WHERE pc.region_id=".$region_id."
AND pc.status ='Active'
AND pc.house='1' AND pc.private_listing='1'
GROUP BY fp.bedrooms";
$area_href = "private_list.php?house=1";
} else if ($fHouseType == 'APT') {
$area_counts_sql = "SELECT pa.area, count(*) as total
FROM property_areas pa
LEFT JOIN property_communities pc on pa.id = pc.area
LEFT JOIN property_floorplans f ON f.community_id=pc.primary_id
WHERE pa.region_id=".$region_id."
AND pc.status ='Active'
AND pc.apartment='1' and pc.house != '1' and pc.townhouse!='1' and pc.private_listing !='1'
GROUP BY pa.id ";
$bed_counts_sql = "SELECT fp.bedrooms, count(*) as total
FROM property_communities pc
LEFT JOIN property_floorplans fp ON fp.community_id = pc.primary_id
WHERE pc.region_id=".$region_id."
AND pc.status ='Active'
AND pc.apartment='1' and pc.house != '1' and pc.townhouse!='1' and pc.private_listing !='1'
GROUP BY fp.bedrooms";
$area_href = "apartment_list.php?apartment=1";
} else if ($fHouseType == 'CONDO') {
$area_counts_sql = "SELECT pa.area, count(*) as total
FROM property_areas pa LEFT JOIN property_communities pc on pa.id = pc.area
WHERE pa.region_id=".$region_id."
AND pc.status ='Active'
AND (pc.condo='1' or pc.townhouse='1') AND pc.private_listing='1'
GROUP BY pa.id ";
$bed_counts_sql = "SELECT fp.bedrooms, count(*) as total
FROM property_communities pc
LEFT JOIN property_floorplans fp ON fp.community_id = pc.primary_id
WHERE pc.region_id=".$region_id."
AND pc.status ='Active'
AND (pc.condo='1' or pc.townhouse='1') AND pc.private_listing='1'
GROUP BY fp.bedrooms";
$area_href = "townhouse_list.php?condosandtown=1";
} else if ($fHouseType == 'CORP') {
$area_counts_sql = "SELECT pa.area, count(*) as total
FROM property_areas pa LEFT JOIN property_communities pc on pa.id = pc.area
WHERE pa.region_id=".$region_id."
AND pc.status ='Active'
AND pc.corporate='1'
GROUP BY pa.id ";
$bed_counts_sql = "SELECT fp.bedrooms, count(*) as total
FROM property_communities pc
LEFT JOIN property_floorplans fp ON fp.community_id = pc.primary_id
WHERE pc.region_id=".$region_id."
AND pc.status ='Active'
AND pc.corporate='1'
GROUP BY fp.bedrooms";
$area_href = "corp_locations.php?corporate=1";
} else {
die("Inavlid Type!");
}
$area_count_result = get_array_from_dbmymprops($area_counts_sql);
foreach($area_count_result as $curAreaCount) {
$area_count_mapping[$curAreaCount['area']]['count'] = $curAreaCount['total'];
}
$area_final_mapping = array(); // Convert to array with numeric index
foreach($area_count_mapping as $curArea => $curArray) {
array_push($area_final_mapping, $curArray);
}
$bedCount1 = 0;
$bedCount2 = 0;
$bedCount3 = 0;
$bedCount4 = 0;
$bedCount5 = 0;
$bedCountAll = 0;
$bed_count_result = get_array_from_dbmymprops($bed_counts_sql);
//print_r($bed_count_result);
foreach($bed_count_result as $curBedCount) {
$beds = $curBedCount['bedrooms'];
$totalBL = $curBedCount['total'];
if ($beds == 1) {
$bedCount1 += $totalBL;
} else if ($beds == 2) {
$bedCount2 += $totalBL;
} else if ($beds == 3) {
$bedCount3 += $totalBL;
} else if ($beds == 4) {
$bedCount4 += $totalBL;
} else if ($beds == 5) {
$bedCount5 += $totalBL;
}
$bedCountAll += $totalBL;
}
?>