getReport($_REQUEST['report_id']); if ($_REQUEST['action'] == 'edit') { $_POST['report_name'] = $report->f['report_name']; $_POST['db_name'] = $report->f['db_name']; $_POST['descr'] = $report->f['descr']; $_POST['report_sql'] = $report->f['report_sql']; } // Get a list of available databases $databases = &$data->getDatabases(); $_REQUEST['report'] = $report->f['report_name']; $misc->printTrail('report'); $misc->printTitle($lang['stredit']); $misc->printMsg($msg); echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
{$lang['strname']}_maxNameLen}\" value=\"", htmlspecialchars($_POST['report_name']), "\" />
{$lang['strdatabase']}
{$lang['strcomment']}
{$lang['strsql']}
\n"; echo "

\n"; echo "\n"; echo "

\n"; echo "f['report_id']}\" />\n"; echo "
\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']); 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 $PHP_SELF, $lang; $report = $reportsdb->getReport($_REQUEST['report_id']); $_REQUEST['report'] = $report->f['report_name']; $misc->printTrail('report'); $misc->printTitle($lang['strproperties']); $misc->printMsg($msg); if ($report->recordCount() == 1) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
{$lang['strname']}", $misc->printVal($report->f['report_name']), "
{$lang['strdatabase']}", $misc->printVal($report->f['db_name']), "
{$lang['strcomment']}", $misc->printVal($report->f['descr']), "
{$lang['strsql']}", $misc->printVal($report->f['report_sql']), "
\n"; } else echo "

{$lang['strinvalidparam']}

\n"; echo "

{$lang['strshowallreports']} |\n"; echo "f['report_id']}\">{$lang['stredit']}

\n"; } /** * Displays a screen where they can enter a new report */ function doCreate($msg = '') { global $data, $reportsdb, $misc; global $PHP_SELF, $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'] = ''; $databases = &$data->getDatabases(); $misc->printTrail('server'); $misc->printTitle($lang['strcreatereport']); $misc->printMsg($msg); echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
{$lang['strname']}_maxNameLen}\" value=\"", htmlspecialchars($_REQUEST['report_name']), "\" />
{$lang['strdatabase']}
{$lang['strcomment']}
{$lang['strsql']}
\n"; echo "

\n"; echo "\n"; echo "

\n"; echo "
\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']); 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; global $PHP_SELF; if ($confirm) { // Fetch report from the database $report = &$reportsdb->getReport($_REQUEST['report_id']); $_REQUEST['report'] = $report->f['report_name']; $misc->printTrail('report'); $misc->printTitle($lang['strdrop']); echo "

", sprintf($lang['strconfdropreport'], $misc->printVal($report->f['report_name'])), "

\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\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 $PHP_SELF, $lang; $misc->printTrail('server'); $misc->printTitle($lang['strreports']); $misc->printMsg($msg); $reports = &$reportsdb->getReports(); $columns = array( 'report' => array( 'title' => $lang['strreport'], 'field' => 'report_name', ), 'database' => array( 'title' => $lang['strdatabase'], 'field' => 'db_name', ), 'created' => array( 'title' => $lang['strcreated'], 'field' => 'date_created', ), 'actions' => array( 'title' => $lang['stractions'], ), 'comment' => array( 'title' => $lang['strcomment'], 'field' => 'descr', ), ); $actions = array( 'properties' => array( 'title' => $lang['strproperties'], 'url' => "{$PHP_SELF}?action=properties&", 'vars' => array('report_id' => 'report_id'), ), 'run' => array( 'title' => $lang['strrun'], 'url' => "display.php?subject=report&return_url={$PHP_SELF}&return_desc=".urlencode($lang['strback'])."&", 'vars' => array('report' => 'report_name', 'database' => 'db_name', 'query' => 'report_sql'), ), 'edit' => array( 'title' => $lang['stredit'], 'url' => "{$PHP_SELF}?action=edit&", 'vars' => array('report_id' => 'report_id'), ), 'drop' => array( 'title' => $lang['strdrop'], 'url' => "{$PHP_SELF}?action=confirm_drop&", 'vars' => array('report_id' => 'report_id'), ), ); $misc->printTable($reports, $columns, $actions, $lang['strnoreports']); echo "

{$lang['strcreatereport']}

\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) { echo "

{$lang['strnoreportsdb']}

\n"; } 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(); ?> e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.


DISEÑO DE HERRAMIENTAS PARA PORTAL DE GESTIÓN DE CENTROS DOCENTES

: LEIVA JIMÉNEZ, ANDRÉS
: Ingeniería Telecomunicación
Contenido del proyecto:
Directorio raíz  >  proyecto  >  proyecto  >  per_doc  >  administrador  >  phpPgAdmin  >  reports.php