$_CONDS = putConditionsBack($rptAction, $rgDefault, $query, $USR_DATERANGE, $SAVED_CLAUSE, $selAction, $selHost, $selVolume, $selUser, $selPrinter);
$summary = putSummary($_CONDS, $currDate, $rptAction, $rptName);
$toPrint = true;
if ($rptAction == 'mailhtml' || $rptAction == 'mailcsv') {
$toPrint = false;
}
if (isset($rptAction) && ($rptAction == 'exportcsv' || $rptAction == 'mailcsv')) {
$selMailFormat = "CSV";
// Print CSV output to be dumped into a hidden IFRAME
$rgOutput = exportCSV($toPrint, $array, $rptName);
} else {
if (isset($rptAction) && ($rptAction == 'exporthtml' || $rptAction == 'preview' || $rptAction == 'print' || $rptAction == 'mailhtml')) {
$selMailFormat = "HTML";
logger("Temlate - {$selTemplate}");
// Print HTML output to be dumped into a new window
$rgOutput = exportHTML($toPrint, $array, $rptAction, $selSummary, $rptName, $summary, $selTemplate);
} else {
// Print Tabularized output for formatting later - see ULTRA COOL in filter.js
resultTable($toPrint, $array, $rptAction);
}
}
if ($rptAction == 'mailhtml' || $rptAction == 'mailcsv') {
if ($servername == "") {
$servername = $_SERVER['SERVERNAME'];
}
logger("Trying to mail report ({$rgOutput}) to {$selMailTo}... ");
if (RPT_SCHEDULE == 1) {
$run_schedules = 1;
}
$err = sendRptMail($run_schedules, $servername, $selMailTo, $selMailCC, $selMailSubject, $selMailBody, $selMailFormat, $rgOutput, $selTemplate);
if ($err != 0) {
header('Content-Type: text/csv');
header("Content-Disposition: attachment;filename=\"Docket Sheet - {$date}.csv\"");
$fp = fopen('php://output', 'w');
$row = $res->fetch_assoc();
if ($row) {
fputcsv($fp, array_keys($row));
}
// reset pointer back to beginning
$res->data_seek(0);
while ($row = $res->fetch_assoc()) {
fputcsv($fp, $row);
}
fclose($fp);
} else {
$info = 'Query successfully returned ' . $res->num_rows . ' rows.';
echo exportHTML($res, "Docket Sheet for {$date}");
}
}
exit;
} else {
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Report Manager</title>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
<link rel='stylesheet' href='style.css' type='text/css'/>
<link rel="stylesheet" type="text/css" media="all" href="js/tablesort/style.css" />
<script src="codepress/codepress.js" type="text/javascript"></script>
<script src="js/prototype.js" type="text/javascript"></script>
$res = dbQuery("update queries set name={$_POST['name']}, description={$_POST['description']}, query={$_POST['query']}, query_id={$_POST['query_id']} where query_id=" . $_POST['query_id']);
$query_id = $_POST['query_id'];
} else {
$res = dbQuery("insert into queries (name, description, query, created) values({$_POST['name']}, {$_POST['description']}, {$_POST['query']}, NOW())");
$query_id = $db->insert_id;
}
if ($db->affected_rows >= 1) {
$info = "Query saved";
}
} else {
if ($action == 'runquery') {
$query = fetchRow("select query,name from queries where query_id=" . $_REQUEST['query_id']);
$res = dbQuery($query[0]);
if ($res) {
$info = 'Query successfully returned ' . $res->num_rows . ' rows.';
$output = exportHTML($res, $query[1]);
//$output = exportTSV($res);
#$info.= "<pre>".str_replace("\n", '<br/>', $output)."</pre>";
$res = dbQuery('update queries set executed=NOW() where query_id=' . $_REQUEST[query_id]);
$executed = fetchItem('select executed from queries where query_id = ' . $_REQUEST[query_id]);
}
echo $output;
echo "error = \"{$error}\"; info=\"{$info}\"; executed=\"" . str_replace(' ', '<br/>', $executed) . "\";";
exit;
} else {
if ($action == 'csv') {
$query = fetchRow("select query,name from queries where query_id=" . $_REQUEST['query_id']);
$result = dbQuery($query[0]);
if ($result) {
// send response headers to the browser
header('Content-Type: text/csv');
