$organizationID = $_GET['organizationID'];
function escape_csv($value)
{
// replace \n with \r\n
$value = preg_replace("/(?<!\r)\n/", "\r\n", $value);
// escape quotes
$value = str_replace('"', '""', $value);
return '"' . $value . '"';
}
function array_to_csv_row($array)
{
$escaped_array = array_map("escape_csv", $array);
return implode(",", $escaped_array) . "\r\n";
}
$issueLogObj = new IssueLog();
$issues = $issueLogObj->allExpandedAsArray($organizationID);
$replace = array("/", "-");
$excelfile = "issues_export_" . str_replace($replace, "_", format_date(date('Y-m-d'))) . ".csv";
header("Pragma: public");
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=\"" . $excelfile . "\"");
echo array_to_csv_row(array("Issues Export " . format_date(date('Y-m-d'))));
$columnHeaders = array("Organization", "Issue Type", "Start Date", "End Date", "Issue Text");
echo array_to_csv_row($columnHeaders);
foreach ($issues as $issue) {
if ($resource['updateDate'] == "0000-00-00") {
$updateDateFormatted = "";
} else {
$updateDateFormatted = format_date($resource['updateDate']);
}
$issueValues = array($issue['name'], $issue['shortName'], $issue['issueStartDate'], $issue['issueEndDate'], preg_replace('/\\s+/', ' ', trim($issue['noteText'])));
