Viewing file:  reports.php (12.22 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
/**
* List reports in a database
*
* $Id: reports.php,v 1.34 2008/01/09 00:19:10 ioguix Exp $
*/
// Include application functions
include_once('./libraries/lib.inc.php');
$action = (isset($_REQUEST['action'])) ? $_REQUEST['action'] : '';
/**
* Displays a screen where they can edit a report
*/
function doEdit($msg = '') {
global $data, $reportsdb, $misc;
global $lang;
// If it's a first, load then get the data from the database
$report = $reportsdb->getReport($_REQUEST['report_id']);
if ($_REQUEST['action'] == 'edit') {
$_POST['report_name'] = $report->fields['report_name'];
$_POST['db_name'] = $report->fields['db_name'];
$_POST['descr'] = $report->fields['descr'];
$_POST['report_sql'] = $report->fields['report_sql'];
if ($report->fields['paginate'] == 't') {
$_POST['paginate'] = TRUE;
}
}
// Get a list of available databases
$databases = $data->getDatabases();
$_REQUEST['report'] = $report->fields['report_name'];
$misc->printTrail('report');
$misc->printTitle($lang['stredit']);
$misc->printMsg($msg);
echo "<form action=\"reports.php\" method=\"post\">\n";
echo $misc->form;
echo "<table style=\"width: 100%\">\n";
echo "<tr><th class=\"data left required\">{$lang['strname']}</th>\n";
echo "<td class=\"data1\"><input name=\"report_name\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
htmlspecialchars($_POST['report_name']), "\" /></td></tr>\n";
echo "<tr><th class=\"data left required\">{$lang['strdatabase']}</th>\n";
echo "<td class=\"data1\"><select name=\"db_name\">\n";
while (!$databases->EOF) {
$dbname = $databases->fields['datname'];
echo "<option value=\"", htmlspecialchars($dbname), "\"",
($dbname == $_POST['db_name']) ? ' selected="selected"' : '', ">",
htmlspecialchars($dbname), "</option>\n";
$databases->moveNext();
}
echo "</select></td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strcomment']}</th>\n";
echo "<td class=\"data1\"><textarea style=\"width:100%;\" rows=\"5\" cols=\"50\" name=\"descr\">",
htmlspecialchars($_POST['descr']), "</textarea></td></tr>\n";
echo "<tr><th class=\"data left required\">{$lang['strsql']}</th>\n";
echo "<td class=\"data1\"><textarea style=\"width:100%;\" rows=\"15\" cols=\"50\" name=\"report_sql\">",
htmlspecialchars($_POST['report_sql']), "</textarea></td></tr>\n";
echo "</table>\n";
echo "<label for=\"paginate\"><input type=\"checkbox\" id=\"paginate\" name=\"paginate\"", (isset($_POST['paginate']) ? ' checked="checked"' : ''), " /> {$lang['strpaginate']}</label>\n";
echo "<p><input type=\"hidden\" name=\"action\" value=\"save_edit\" />\n";
echo "<input type=\"submit\" value=\"{$lang['strsave']}\" />\n";
echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
echo "<input type=\"hidden\" name=\"report_id\" value=\"{$report->fields['report_id']}\" />\n";
echo "</form>\n";
}
/**
* Saves changes to a report
*/
function doSaveEdit() {
global $reportsdb, $lang;
if (!isset($_POST['report_name'])) $_POST['report_name'] = '';
if (!isset($_POST['db_name'])) $_POST['db_name'] = '';
if (!isset($_POST['descr'])) $_POST['descr'] = '';
if (!isset($_POST['report_sql'])) $_POST['report_sql'] = '';
// Check that they've given a name and a definition
if ($_POST['report_name'] == '') doEdit($lang['strreportneedsname']);
elseif ($_POST['report_sql'] == '') doEdit($lang['strreportneedsdef']);
else {
$status = $reportsdb->alterReport($_POST['report_id'], $_POST['report_name'], $_POST['db_name'],
$_POST['descr'], $_POST['report_sql'], isset($_POST['paginate']));
if ($status == 0)
doDefault($lang['strreportcreated']);
else
doEdit($lang['strreportcreatedbad']);
}
}
/**
* Display read-only properties of a report
*/
function doProperties($msg = '') {
global $data, $reportsdb, $misc;
global $lang;
$report = $reportsdb->getReport($_REQUEST['report_id']);
$_REQUEST['report'] = $report->fields['report_name'];
$misc->printTrail('report');
$misc->printTitle($lang['strproperties']);
$misc->printMsg($msg);
if ($report->recordCount() == 1) {
echo "<table>\n";
echo "<tr><th class=\"data left\">{$lang['strname']}</th>\n";
echo "<td class=\"data1\">", $misc->printVal($report->fields['report_name']), "</td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strdatabase']}</th>\n";
echo "<td class=\"data1\">", $misc->printVal($report->fields['db_name']), "</td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strcomment']}</th>\n";
echo "<td class=\"data1\">", $misc->printVal($report->fields['descr']), "</td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strsql']}</th>\n";
echo "<td class=\"data1\">", $misc->printVal($report->fields['report_sql']), "</td></tr>\n";
echo "</table>\n";
}
else echo "<p>{$lang['strinvalidparam']}</p>\n";
echo "<ul class=\"navlink\">\n\t<li><a href=\"reports.php?{$misc->href}\">{$lang['strshowallreports']}</a></li>\n";
echo "\t<li><a href=\"reports.php?action=edit&{$misc->href}&report_id={$report->fields['report_id']}\">{$lang['stredit']}</a></li>\n</ul>\n";
}
/**
* Displays a screen where they can enter a new report
*/
function doCreate($msg = '') {
global $data, $reportsdb, $misc;
global $lang;
if (!isset($_REQUEST['report_name'])) $_REQUEST['report_name'] = '';
if (!isset($_REQUEST['db_name'])) $_REQUEST['db_name'] = '';
if (!isset($_REQUEST['descr'])) $_REQUEST['descr'] = '';
if (!isset($_REQUEST['report_sql'])) $_REQUEST['report_sql'] = '';
if (isset($_REQUEST['database'])) {
$_REQUEST['db_name'] = $_REQUEST['database'];
unset($_REQUEST['database']);
$misc->setForm();
}
$databases = $data->getDatabases();
$misc->printTrail('server');
$misc->printTitle($lang['strcreatereport']);
$misc->printMsg($msg);
echo "<form action=\"reports.php\" method=\"post\">\n";
echo $misc->form;
echo "<table style=\"width: 100%\">\n";
echo "<tr><th class=\"data left required\">{$lang['strname']}</th>\n";
echo "<td class=\"data1\"><input name=\"report_name\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
htmlspecialchars($_REQUEST['report_name']), "\" /></td></tr>\n";
echo "<tr><th class=\"data left required\">{$lang['strdatabase']}</th>\n";
echo "<td class=\"data1\"><select name=\"db_name\">\n";
while (!$databases->EOF) {
$dbname = $databases->fields['datname'];
echo "<option value=\"", htmlspecialchars($dbname), "\"",
($dbname == $_REQUEST['db_name']) ? ' selected="selected"' : '', ">",
htmlspecialchars($dbname), "</option>\n";
$databases->moveNext();
}
echo "</select></td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strcomment']}</th>\n";
echo "<td class=\"data1\"><textarea style=\"width:100%;\" rows=\"5\" cols=\"50\" name=\"descr\">",
htmlspecialchars($_REQUEST['descr']), "</textarea></td></tr>\n";
echo "<tr><th class=\"data left required\">{$lang['strsql']}</th>\n";
echo "<td class=\"data1\"><textarea style=\"width:100%;\" rows=\"15\" cols=\"50\" name=\"report_sql\">",
htmlspecialchars($_REQUEST['report_sql']), "</textarea></td></tr>\n";
echo "</table>\n";
echo "<label for=\"paginate\"><input type=\"checkbox\" id=\"paginate\" name=\"paginate\"", (isset($_REQUEST['paginate']) ? ' checked="checked"' : ''), " /> {$lang['strpaginate']}</label>\n";
echo "<p><input type=\"hidden\" name=\"action\" value=\"save_create\" />\n";
echo "<input type=\"submit\" value=\"{$lang['strsave']}\" />\n";
echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
echo "</form>\n";
}
/**
* Actually creates the new report in the database
*/
function doSaveCreate() {
global $reportsdb, $lang;
if (!isset($_POST['report_name'])) $_POST['report_name'] = '';
if (!isset($_POST['db_name'])) $_POST['db_name'] = '';
if (!isset($_POST['descr'])) $_POST['descr'] = '';
if (!isset($_POST['report_sql'])) $_POST['report_sql'] = '';
// Check that they've given a name and a definition
if ($_POST['report_name'] == '') doCreate($lang['strreportneedsname']);
elseif ($_POST['report_sql'] == '') doCreate($lang['strreportneedsdef']);
else {
$status = $reportsdb->createReport($_POST['report_name'], $_POST['db_name'],
$_POST['descr'], $_POST['report_sql'], isset($_POST['paginate']));
if ($status == 0)
doDefault($lang['strreportcreated']);
else
doCreate($lang['strreportcreatedbad']);
}
}
/**
* Show confirmation of drop and perform actual drop
*/
function doDrop($confirm) {
global $reportsdb, $misc;
global $lang;
if ($confirm) {
// Fetch report from the database
$report = $reportsdb->getReport($_REQUEST['report_id']);
$_REQUEST['report'] = $report->fields['report_name'];
$misc->printTrail('report');
$misc->printTitle($lang['strdrop']);
echo "<p>", sprintf($lang['strconfdropreport'], $misc->printVal($report->fields['report_name'])), "</p>\n";
echo "<form action=\"reports.php\" method=\"post\">\n";
echo $misc->form;
echo "<input type=\"hidden\" name=\"action\" value=\"drop\" />\n";
echo "<input type=\"hidden\" name=\"report_id\" value=\"", htmlspecialchars($_REQUEST['report_id']), "\" />\n";
echo "<input type=\"submit\" name=\"drop\" value=\"{$lang['strdrop']}\" />\n";
echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" />\n";
echo "</form>\n";
}
else {
$status = $reportsdb->dropReport($_POST['report_id']);
if ($status == 0)
doDefault($lang['strreportdropped']);
else
doDefault($lang['strreportdroppedbad']);
}
}
/**
* Show default list of reports in the database
*/
function doDefault($msg = '') {
global $data, $misc, $reportsdb;
global $lang;
$misc->printTrail('server');
$misc->printTabs('server','reports');
$misc->printMsg($msg);
$reports = $reportsdb->getReports();
$columns = array(
'report' => array(
'title' => $lang['strreport'],
'field' => field('report_name'),
'url' => "reports.php?action=properties&{$misc->href}&",
'vars' => array('report_id' => 'report_id'),
),
'database' => array(
'title' => $lang['strdatabase'],
'field' => field('db_name'),
),
'created' => array(
'title' => $lang['strcreated'],
'field' => field('date_created'),
),
'actions' => array(
'title' => $lang['stractions'],
),
'comment' => array(
'title' => $lang['strcomment'],
'field' => field('descr'),
),
);
$return_url = urlencode("reports.php?{$misc->href}");
$actions = array(
'run' => array(
'title' => $lang['strexecute'],
'url' => "sql.php?subject=report&{$misc->href}&return_url={$return_url}&return_desc=".urlencode($lang['strback'])."&",
'vars' => array('report' => 'report_name', 'database' => 'db_name', 'query' => 'report_sql', 'paginate' => 'paginate'),
),
'edit' => array(
'title' => $lang['stredit'],
'url' => "reports.php?action=edit&{$misc->href}&",
'vars' => array('report_id' => 'report_id'),
),
'drop' => array(
'title' => $lang['strdrop'],
'url' => "reports.php?action=confirm_drop&{$misc->href}&",
'vars' => array('report_id' => 'report_id'),
),
);
$misc->printTable($reports, $columns, $actions, $lang['strnoreports']);
echo "<p><a class=\"navlink\" href=\"reports.php?action=create&{$misc->href}\">{$lang['strcreatereport']}</a></p>\n";
}
$misc->printHeader($lang['strreports']);
$misc->printBody();
// Create a database accessor for the reports database
include_once('./classes/Reports.php');
$reportsdb = new Reports($status);
if ($status != 0) {
$misc->printTrail('server');
$misc->printTabs('server','reports');
$misc->printMsg($lang['strnoreportsdb']);
}
else {
switch ($action) {
case 'save_edit':
if (isset($_POST['cancel'])) doDefault();
else doSaveEdit();
break;
case 'edit':
doEdit();
break;
case 'properties':
doProperties();
break;
case 'save_create':
if (isset($_POST['cancel'])) doDefault();
else doSaveCreate();
break;
case 'create':
doCreate();
break;
case 'drop':
if (isset($_POST['drop'])) doDrop(false);
else doDefault();
break;
case 'confirm_drop':
doDrop(true);
break;
default:
doDefault();
break;
}
}
$misc->printFooter();
?>
|