printTrail('schema'); $misc->printTabs('schema', 'sequences'); $misc->printMsg($msg); // Get all sequences $sequences = &$data->getSequences(); $columns = array( 'sequence' => array( 'title' => $lang['strsequence'], 'field' => 'seqname', ), 'owner' => array( 'title' => $lang['strowner'], 'field' => 'seqowner', ), 'actions' => array( 'title' => $lang['stractions'], ), 'comment' => array( 'title' => $lang['strcomment'], 'field' => 'seqcomment', ), ); $actions = array( 'properties' => array( 'title' => $lang['strproperties'], 'url' => "{$PHP_SELF}?action=properties&{$misc->href}&", 'vars' => array('sequence' => 'seqname'), ), 'drop' => array( 'title' => $lang['strdrop'], 'url' => "{$PHP_SELF}?action=confirm_drop&{$misc->href}&", 'vars' => array('sequence' => 'seqname'), ), 'privileges' => array( 'title' => $lang['strprivileges'], 'url' => "privileges.php?{$misc->href}&subject=sequence&", 'vars' => array('sequence' => 'seqname'), ), ); $misc->printTable($sequences, $columns, $actions, $lang['strnosequences']); echo "

href}\">{$lang['strcreatesequence']}

\n"; } /** * Display the properties of a sequence */ function doProperties($msg = '') { global $data, $misc, $PHP_SELF; global $lang; $misc->printTrail('sequence'); $misc->printTitle($lang['strproperties'],'pg.sequence'); $misc->printMsg($msg); // Fetch the sequence information $sequence = &$data->getSequence($_REQUEST['sequence']); if (is_object($sequence) && $sequence->recordCount() > 0) { $sequence->f['is_cycled'] = $data->phpBool($sequence->f['is_cycled']); $sequence->f['is_called'] = $data->phpBool($sequence->f['is_called']); // Show comment if any if ($sequence->f['seqcomment'] !== null) echo "

", $misc->printVal($sequence->f['seqcomment']), "

\n"; echo ""; echo ""; echo ""; echo ""; // PostgreSQL 7.0 and below don't have logcount if (isset($sequence->f['log_cnt'])) { echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // PostgreSQL 7.0 and below don't have logcount if (isset($sequence->f['log_cnt'])) { echo ""; } echo ""; echo ""; echo ""; echo "
{$lang['strname']}{$lang['strlastvalue']}{$lang['strincrementby']}{$lang['strmaxvalue']}{$lang['strminvalue']}{$lang['strcachevalue']}{$lang['strlogcount']}{$lang['striscycled']}{$lang['striscalled']}
", $misc->printVal($sequence->f['seqname']), "", $misc->printVal($sequence->f['last_value']), "", $misc->printVal($sequence->f['increment_by']), "", $misc->printVal($sequence->f['max_value']), "", $misc->printVal($sequence->f['min_value']), "", $misc->printVal($sequence->f['cache_value']), "", $misc->printVal($sequence->f['log_cnt']), "", ($sequence->f['is_cycled'] ? $lang['stryes'] : $lang['strno']), "", ($sequence->f['is_called'] ? $lang['stryes'] : $lang['strno']), "
"; echo "

href}&sequence=", urlencode($sequence->f['seqname']), "\">{$lang['strreset']} |\n"; echo "href}\">{$lang['strshowallsequences']}

\n"; } else echo "

{$lang['strnodata']}.

\n"; } /** * Drop a sequence */ function doDrop($confirm, $msg = '') { global $data, $misc; global $PHP_SELF, $lang; if ($confirm) { $misc->printTrail('sequence'); $misc->printTitle($lang['strdrop'],'pg.sequence.drop'); $misc->printMsg($msg); echo "

", sprintf($lang['strconfdropsequence'], $misc->printVal($_REQUEST['sequence'])), "

\n"; echo "
\n"; echo "\n"; echo "\n"; echo $misc->form; // Show cascade drop option if supportd if ($data->hasDropBehavior()) { echo "

{$lang['strcascade']}

\n"; } echo "\n"; echo "\n"; echo "
\n"; } else { $status = $data->dropSequence($_POST['sequence'], isset($_POST['cascade'])); if ($status == 0) doDefault($lang['strsequencedropped']); else doDrop(true, $lang['strsequencedroppedbad']); } } /** * Displays a screen where they can enter a new sequence */ function doCreateSequence($msg = '') { global $data, $misc; global $PHP_SELF, $lang; if (!isset($_POST['formSequenceName'])) $_POST['formSequenceName'] = ''; if (!isset($_POST['formIncrement'])) $_POST['formIncrement'] = ''; if (!isset($_POST['formMinValue'])) $_POST['formMinValue'] = ''; if (!isset($_POST['formMaxValue'])) $_POST['formMaxValue'] = ''; if (!isset($_POST['formStartValue'])) $_POST['formStartValue'] = ''; if (!isset($_POST['formCacheValue'])) $_POST['formCacheValue'] = ''; $misc->printTrail('schema'); $misc->printTitle($lang['strcreatesequence'],'pg.sequence.create'); $misc->printMsg($msg); echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; 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['formSequenceName']), "\" />
{$lang['strincrementby']}
{$lang['strminvalue']}
{$lang['strmaxvalue']}
{$lang['strstartvalue']}
{$lang['strcachevalue']}
{$lang['striscycled']}
\n"; echo "

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

\n"; echo "
\n"; } /** * Actually creates the new sequence in the database */ function doSaveCreateSequence() { global $data; global $lang; // Check that they've given a name and at least one column if ($_POST['formSequenceName'] == '') doCreateSequence($lang['strsequenceneedsname']); else { $status = $data->createSequence($_POST['formSequenceName'], $_POST['formIncrement'], $_POST['formMinValue'], $_POST['formMaxValue'], $_POST['formStartValue'], $_POST['formCacheValue'], isset($_POST['formCycledValue'])); if ($status == 0) { doDefault($lang['strsequencecreated']); } else { doCreateSequence($lang['strsequencecreatedbad']); } } } /** * Resets a sequence */ function doReset() { global $data; global $PHP_SELF, $lang; $status = $data->resetSequence($_REQUEST['sequence']); if ($status == 0) doProperties($lang['strsequencereset']); else doProperties($lang['strsequenceresetbad']); } // Print header $misc->printHeader($lang['strsequences']); $misc->printBody(); switch($action) { case 'create': doCreateSequence(); break; case 'save_create_sequence': if (isset($_POST['create'])) doSaveCreateSequence(); else doDefault(); break; case 'properties': doProperties(); break; case 'drop': if (isset($_POST['drop'])) doDrop(false); else doDefault(); break; case 'confirm_drop': doDrop(true); break; case 'reset': doReset(); break; default: doDefault(); break; } // Print footer $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  >  sequences.php