setView($_POST['view'], $_POST['formDefinition'], $_POST['formComment']); if ($status == 0) doDefinition($lang['strviewupdated']); else doEdit($lang['strviewupdatedbad']); } /** * Function to allow editing of a view */ function doEdit($msg = '') { global $data, $misc; global $PHP_SELF, $lang; $misc->printTrail('view'); $misc->printTitle($lang['stredit'],'pg.view.alter'); $misc->printMsg($msg); $viewdata = &$data->getView($_REQUEST['view']); if ($viewdata->recordCount() > 0) { if (!isset($_POST['formDefinition'])) { $_POST['formDefinition'] = $viewdata->f['vwdefinition']; $_POST['formComment'] = $viewdata->f['relcomment']; } echo "
\n"; echo "\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "
{$lang['strdefinition']}
{$lang['strcomment']}
\n"; echo "

\n"; echo "\n"; echo $misc->form; echo "\n"; echo "

\n"; echo "
\n"; } else echo "

{$lang['strnodata']}

\n"; } /** * Allow the dumping of the data "in" a view * NOTE:: PostgreSQL doesn't currently support dumping the data in a view * so I have disabled the data related parts for now. In the future * we should allow it conditionally if it becomes supported. This is * a SMOP since it is based on pg_dump version not backend version. */ function doExport($msg = '') { global $data, $misc; global $PHP_SELF, $lang; $misc->printTrail('view'); $misc->printTabs('view','export'); $misc->printMsg($msg); echo "
\n"; echo "\n"; echo "\n"; // Data only echo "\n"; // Structure only echo "\n"; echo "\n\n"; // Structure and data echo "\n"; echo "
{$lang['strformat']}{$lang['stroptions']}
{$lang['strstructureonly']}{$lang['strdrop']}
\n"; echo "

{$lang['stroptions']}

\n"; echo "

{$lang['strshow']}\n"; echo "
{$lang['strdownload']}

\n"; echo "

\n"; echo $misc->form; echo "\n"; echo "

\n"; echo "
\n"; } /** * Show definition for a view */ function doDefinition($msg = '') { global $data, $misc; global $PHP_SELF, $lang; // Get view $vdata = &$data->getView($_REQUEST['view']); $misc->printTrail('view'); $misc->printTabs('view','definition'); $misc->printMsg($msg); if ($vdata->recordCount() > 0) { // Show comment if any if ($vdata->f['relcomment'] !== null) echo "

", $misc->printVal($vdata->f['relcomment']), "

\n"; echo "\n"; echo "\n"; echo "\n"; echo "
{$lang['strdefinition']}
", $misc->printVal($vdata->f['vwdefinition']), "
\n"; } else echo "

{$lang['strnodata']}

\n"; echo "

href}&view=", urlencode($_REQUEST['view']), "\">{$lang['stralter']}

\n"; } /** * Displays a screen where they can alter a column in a view */ function doProperties($msg = '') { global $data, $misc; global $PHP_SELF, $lang; if (!isset($_REQUEST['stage'])) $_REQUEST['stage'] = 1; switch ($_REQUEST['stage']) { case 1: global $lang; $misc->printTrail('column'); $misc->printTitle($lang['straltercolumn'],'pg.column.alter'); $misc->printMsg($msg); echo "
\n"; // Output view header echo "\n"; echo ""; echo ""; $column = &$data->getTableAttributes($_REQUEST['view'], $_REQUEST['column']); if (!isset($_REQUEST['default'])) { $_REQUEST['field'] = $column->f['attname']; $_REQUEST['default'] = $_REQUEST['olddefault'] = $column->f['adsrc']; $_REQUEST['comment'] = $column->f['comment']; } // If name of view column is editable, make it a field if ($data->hasViewColumnRename()) { echo ""; } else { echo ""; } echo ""; echo ""; echo ""; echo "
{$lang['strname']}{$lang['strtype']}{$lang['strdefault']}{$lang['strcomment']}
", htmlspecialchars($column->f['attname']), "", $misc->printVal($data->formatType($column->f['type'], $column->f['atttypmod'])), "
\n"; echo "

\n"; echo "\n"; echo $misc->form; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

\n"; echo "
\n"; break; case 2: global $data, $lang; // Check inputs if ($data->hasViewColumnRename() && trim($_REQUEST['field']) == '') { $_REQUEST['stage'] = 1; doProperties($lang['strcolneedsname']); return; } // If we aren't able to rename view columns, set new name to equal old name always if (!$data->hasViewColumnRename()) $_REQUEST['field'] = $_REQUEST['column']; // Alter the view column $status = $data->alterColumn($_REQUEST['view'], $_REQUEST['column'], $_REQUEST['field'], false, false, $_REQUEST['default'], $_REQUEST['olddefault'], '', '', '', '', $_REQUEST['comment']); if ($status == 0) doDefault($lang['strcolumnaltered']); else { $_REQUEST['stage'] = 1; doProperties($lang['strcolumnalteredbad']); return; } break; default: echo "

{$lang['strinvalidparam']}

\n"; } } /** * Show view definition and virtual columns */ function doDefault($msg = '') { global $data, $misc; global $PHP_SELF, $lang; function attPre(&$rowdata) { global $data; $rowdata->f['+type'] = $data->formatType($rowdata->f['type'], $rowdata->f['atttypmod']); } $misc->printTrail('view'); $misc->printTabs('view','columns'); $misc->printMsg($msg); // Get view $vdata = &$data->getView($_REQUEST['view']); // Get columns (using same method for getting a view) $attrs = &$data->getTableAttributes($_REQUEST['view']); // Show comment if any if ($vdata->f['relcomment'] !== null) echo "

", $misc->printVal($vdata->f['relcomment']), "

\n"; $columns = array( 'column' => array( 'title' => $lang['strcolumn'], 'field' => 'attname', ), 'type' => array( 'title' => $lang['strtype'], 'field' => '+type', ), 'default' => array( 'title' => $lang['strdefault'], 'field' => 'adsrc', ), 'actions' => array( 'title' => $lang['stractions'], ), 'comment' => array( 'title' => $lang['strcomment'], 'field' => 'comment', ), ); $actions = array( 'alter' => array( 'title' => $lang['stralter'], 'url' => "{$PHP_SELF}?action=properties&{$misc->href}&view=".urlencode($_REQUEST['view'])."&", 'vars' => array('column' => 'attname'), ), ); $misc->printTable($attrs, $columns, $actions, null, 'attPre'); echo "
\n"; echo "\n"; } $misc->printHeader($lang['strviews'] . ' - ' . $_REQUEST['view']); $misc->printBody(); switch ($action) { case 'save_edit': if (isset($_POST['cancel'])) doDefinition(); else doSaveEdit(); break; case 'edit': doEdit(); break; case 'export': doExport(); break; case 'definition': doDefinition(); break; case 'properties': if (isset($_POST['cancel'])) doDefault(); else doProperties(); 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  >  viewproperties.php