$messageStack->add(RW_RPT_NODATA . ' The failing sql= ' . $sql, 'caution');
$failed = true;
}
} else {
// Houston, we have a problem, sql build failed
$messageStack->add($success['message'], $success['level']);
$failed = true;
}
if (!$failed) {
// send the report
if ($todo == 'exp_csv') {
GenerateCSVFile($ReportData, $Prefs);
}
// No return from this function
if ($todo == 'exp_html') {
GenerateHTMLFile($ReportData, $Prefs);
}
// No return from this function
if ($todo == 'exp_pdf') {
$output = GeneratePDFFile($ReportData, $Prefs, $delivery_method);
}
// if we are here, delivery method was email
if ($output) {
// open a temp file
$temp_file = DIR_FS_MY_FILES . $_SESSION['company'] . '/temp/' . microtime() . '.pdf';
$handle = fopen($temp_file, 'w');
// put the string into the file
fwrite($handle, $output);
fclose($handle);
// generate the email
$block = array();
$error = true;
break;
}
// Check for the report returning with data
if (!$ReportData) {
$messageStack->add(PHREEFORM_NODATA . ' The failing sql= ' . $sql, 'caution');
$error = true;
} else {
if ($_REQUEST['action'] == 'exp_csv') {
$output = GenerateCSVFile($ReportData, $report, $delivery_method);
}
if ($_REQUEST['action'] == 'exp_xml') {
$output = GenerateXMLFile($ReportData, $report, $delivery_method);
}
if ($_REQUEST['action'] == 'exp_html') {
$output = GenerateHTMLFile($ReportData, $report, $delivery_method);
}
if ($_REQUEST['action'] == 'exp_pdf') {
$output = GeneratePDFFile($ReportData, $report, $delivery_method);
}
}
} else {
// Houston, we have a problem
$messageStack->add($success['message'], $success['level']);
$error = true;
}
break;
}
// if we are here, delivery method was email
if (!$error && $output) {
$temp_file = DIR_FS_MY_FILES . $_SESSION['company'] . '/temp/' . $output['filename'];
