getSubscription($subscription_serial); $permit_area = $subscription->record->subscription_area; $projecttype = $subscription->record->subscription_projecttype; $permits = (new PermitsBySubdivision())->getAllPermitsBySubdivision($permit_area, $projecttype); header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename="All_PermitsBySubdivision.csv"'); $output = fopen('php://output', 'w'); // Add CSV headers fputcsv($output, ['County', 'Subdivision', 'Address', 'City', 'Builder', 'Permit Date', 'Square Footage', 'Value'], ',', '"', '\\'); $permit_ytd_value = 0.00; $permit_value = 0.00; foreach ($permits as $permit) { $county_name = $permit->rdi_county_name_verbose; $subdivision = $permit->rdi_sub_div_name; $address = "{$permit->rdi_address} {$permit->rdi_city} {$permit->rdi_state} {$permit->rdi_zip}"; $city = $permit->rdi_city; $builder = $permit->rdi_company; $permit_date = $permit->rdi_permit_date_verbose; $square_footage = $permit->rdi_size_verbose; $value = $permit->rdi_value_verbose; $permit_ytd_value = "$" . number_format((int) $permit->rdi_ytd_value, 2); $permit_value = "$" . number_format((int) $permit->rdi_value, 2); $permit_data = array($county_name, $subdivision, $address, $city, $builder, $permit_date, $square_footage, $value); fputcsv($output, $permit_data, ',', '"', '\\'); } fclose($output); exit(); } // =============== // Debug an Object // =============== public function debug($object = "") { echo "
";
print_r($object);
exit();
}
}
?>