{$lang['strnodata']}
\n"; } /** * Confirm and then actually add a CHECK constraint */ function addCheck($confirm, $msg = '') { global $PHP_SELF, $data, $data, $misc; global $lang; if (!isset($_POST['name'])) $_POST['name'] = ''; if (!isset($_POST['definition'])) $_POST['definition'] = ''; if ($confirm) { $misc->printTrail('domain'); $misc->printTitle($lang['straddcheck'],'pg.constraint.check'); $misc->printMsg($msg); echo "\n"; } else { if (trim($_POST['definition']) == '') addCheck(true, $lang['strcheckneedsdefinition']); else { $status = $data->addDomainCheckConstraint($_POST['domain'], $_POST['definition'], $_POST['name']); if ($status == 0) doProperties($lang['strcheckadded']); else addCheck(true, $lang['strcheckaddedbad']); } } } /** * Show confirmation of drop constraint and perform actual drop */ function doDropConstraint($confirm, $msg = '') { global $data, $misc; global $PHP_SELF, $lang; if ($confirm) { $misc->printTrail('domain'); $misc->printTitle($lang['strdrop'],'pg.constraint.drop'); $misc->printMsg($msg); echo "", sprintf($lang['strconfdropconstraint'], $misc->printVal($_REQUEST['constraint']), $misc->printVal($_REQUEST['domain'])), "
\n"; echo "\n"; } else { $status = $data->dropDomainConstraint($_POST['domain'], $_POST['constraint'], isset($_POST['cascade'])); if ($status == 0) doProperties($lang['strconstraintdropped']); else doDropConstraint(true, $lang['strconstraintdroppedbad']); } } /** * Show properties for a domain. Allow manipulating constraints as well. */ function doProperties($msg = '') { global $data, $misc; global $PHP_SELF, $lang; $misc->printTrail('domain'); $misc->printTitle($lang['strproperties'],'pg.domain'); $misc->printMsg($msg); $domaindata = &$data->getDomain($_REQUEST['domain']); if ($domaindata->recordCount() > 0) { // Show comment if any if ($domaindata->f['domcomment'] !== null) echo "", $misc->printVal($domaindata->f['domcomment']), "
\n"; // Display domain info $domaindata->f['domnotnull'] = $data->phpBool($domaindata->f['domnotnull']); echo "| {$lang['strname']} | \n"; echo "", $misc->printVal($domaindata->f['domname']), " |
|---|---|
| {$lang['strtype']} | \n"; echo "", $misc->printVal($domaindata->f['domtype']), " |
| {$lang['strnotnull']} | \n"; echo "", ($domaindata->f['domnotnull'] ? 'NOT NULL' : ''), " |
| {$lang['strdefault']} | \n"; echo "", $misc->printVal($domaindata->f['domdef']), " |
| {$lang['strowner']} | \n"; echo "", $misc->printVal($domaindata->f['domowner']), " |
| {$lang['strname']} | {$lang['strdefinition']} | {$lang['stractions']} | \n"; $i = 0; while (!$domaincons->EOF) { $id = (($i % 2 ) == 0 ? '1' : '2'); echo "
|---|---|---|
| ", $misc->printVal($domaincons->f['conname']), " | "; echo ""; echo $misc->printVal($domaincons->f['consrc']); echo " | "; echo ""; echo "href}&constraint=", urlencode($domaincons->f['conname']), "&domain=", urlencode($_REQUEST['domain']), "&type=", urlencode($domaincons->f['contype']), "\">{$lang['strdrop']} |
{$lang['strnodata']}
\n"; echo "href}\">{$lang['strshowalldomains']}\n"; if ($data->hasDomainConstraints()) { echo "| href}&domain=", urlencode($_REQUEST['domain']), "\">{$lang['straddcheck']}\n"; echo "| href}&domain=", urlencode($_REQUEST['domain']), "\">{$lang['stralter']}\n"; } echo "
\n"; } /** * Show confirmation of drop and perform actual drop */ function doDrop($confirm) { global $data, $misc; global $PHP_SELF, $lang; if ($confirm) { $misc->printTrail('domain'); $misc->printTitle($lang['strdrop'],'pg.domain.drop'); echo "", sprintf($lang['strconfdropdomain'], $misc->printVal($_REQUEST['domain'])), "
\n"; echo "\n"; } else { $status = $data->dropDomain($_POST['domain'], isset($_POST['cascade'])); if ($status == 0) doDefault($lang['strdomaindropped']); else doDefault($lang['strdomaindroppedbad']); } } /** * Displays a screen where they can enter a new domain */ function doCreate($msg = '') { global $data, $misc; global $PHP_SELF, $lang; if (!isset($_POST['domname'])) $_POST['domname'] = ''; if (!isset($_POST['domtype'])) $_POST['domtype'] = ''; if (!isset($_POST['domlength'])) $_POST['domlength'] = ''; if (!isset($_POST['domarray'])) $_POST['domarray'] = ''; if (!isset($_POST['domdefault'])) $_POST['domdefault'] = ''; if (!isset($_POST['domcheck'])) $_POST['domcheck'] = ''; $types = &$data->getTypes(true); $misc->printTrail('schema'); $misc->printTitle($lang['strcreatedomain'],'pg.domain.create'); $misc->printMsg($msg); echo "\n"; } /** * Actually creates the new domain in the database */ function doSaveCreate() { global $data, $lang; if (!isset($_POST['domcheck'])) $_POST['domcheck'] = ''; // Check that they've given a name and a definition if ($_POST['domname'] == '') doCreate($lang['strdomainneedsname']); else { $status = $data->createDomain($_POST['domname'], $_POST['domtype'], $_POST['domlength'], $_POST['domarray'] != '', isset($_POST['domnotnull']), $_POST['domdefault'], $_POST['domcheck']); if ($status == 0) doDefault($lang['strdomaincreated']); else doCreate($lang['strdomaincreatedbad']); } } /** * Show default list of domains in the database */ function doDefault($msg = '') { global $data, $conf, $misc; global $PHP_SELF, $lang; $misc->printTrail('schema'); $misc->printTabs('schema','domains'); $misc->printMsg($msg); $domains = &$data->getDomains(); $columns = array( 'domain' => array( 'title' => $lang['strdomain'], 'field' => 'domname', ), 'type' => array( 'title' => $lang['strtype'], 'field' => 'domtype', ), 'notnull' => array( 'title' => $lang['strnotnull'], 'field' => 'domnotnull', 'type' => 'bool', 'params'=> array('true' => 'NOT NULL', 'false' => ''), ), 'default' => array( 'title' => $lang['strdefault'], 'field' => 'domdef', ), 'owner' => array( 'title' => $lang['strowner'], 'field' => 'domowner', ), 'actions' => array( 'title' => $lang['stractions'], ), 'comment' => array( 'title' => $lang['strcomment'], 'field' => 'domcomment', ), ); $actions = array( 'properties' => array( 'title' => $lang['strproperties'], 'url' => "{$PHP_SELF}?action=properties&{$misc->href}&", 'vars' => array('domain' => 'domname'), ), 'drop' => array( 'title' => $lang['strdrop'], 'url' => "{$PHP_SELF}?action=confirm_drop&{$misc->href}&", 'vars' => array('domain' => 'domname'), ), ); $misc->printTable($domains, $columns, $actions, $lang['strnodomains']); echo "href}\">{$lang['strcreatedomain']}
\n"; } $misc->printHeader($lang['strdomains']); $misc->printBody(); switch ($action) { case 'add_check': addCheck(true); break; case 'save_add_check': if (isset($_POST['cancel'])) doProperties(); else addCheck(false); break; case 'drop_con': if (isset($_POST['drop'])) doDropConstraint(false); else doProperties(); break; case 'confirm_drop_con': doDropConstraint(true); 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; case 'save_alter': if (isset($_POST['alter'])) doSaveAlter(); else doProperties(); break; case 'alter': doAlter(); break; case 'properties': doProperties(); break; default: doDefault(); break; } $misc->printFooter(); ?>
