HuasoFoundries / phpPgAdmin6

    /**

     * Show confirmation of drop constraint and perform actual drop

     */

    public function doDropConstraint($confirm, $msg = '')

    {

        $conf = $this->conf;

        $misc = $this->misc;

        $lang = $this->lang;

        $data = $misc->getDatabaseAccessor();

        if ($confirm) {

            $this->printTrail('domain');

            $this->printTitle($lang['strdrop'], 'pg.constraint.drop');

            $this->printMsg($msg);

            echo '<p>', sprintf($lang['strconfdropconstraint'], $misc->printVal($_REQUEST['constraint']),

                $misc->printVal($_REQUEST['domain'])), "</p>\n";

            echo '<form action="' . SUBFOLDER . "/src/views/domains.php\" method=\"post\">\n";

            echo "<input type=\"hidden\" name=\"action\" value=\"drop_con\" />\n";

            echo '<input type="hidden" name="domain" value="', htmlspecialchars($_REQUEST['domain']), "\" />\n";

            echo '<input type="hidden" name="constraint" value="', htmlspecialchars($_REQUEST['constraint']), "\" />\n";

            echo $misc->form;

            echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\" /> <label for=\"cascade\">{$lang['strcascade']}</label></p>\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 = $data->dropDomainConstraint($_POST['domain'], $_POST['constraint'], isset($_POST['cascade']));

            if ($status == 0) {

                $this->doProperties($lang['strconstraintdropped']);

            } else {

                $this->doDropConstraint(true, $lang['strconstraintdroppedbad']);

            }

        }

    }

    /**

     * Show properties for a domain.  Allow manipulating constraints as well.

     */

    public function doProperties($msg = '')

    /**

     * Show confirmation of drop column and perform actual drop

     */

    public function doDrop($confirm)

    {

        $conf = $this->conf;

        $misc = $this->misc;

        $lang = $this->lang;

        $data = $misc->getDatabaseAccessor();

        if ($confirm) {

            $this->printTrail('column');

            $this->printTitle($lang['strdrop'], 'pg.column.drop');

            echo '<p>', sprintf($lang['strconfdropcolumn'], $misc->printVal($_REQUEST['column']),

                $misc->printVal($_REQUEST['table'])), "</p>\n";

            echo '<form action="' . SUBFOLDER . "/src/views/tblproperties.php\" method=\"post\">\n";

            echo "<input type=\"hidden\" name=\"action\" value=\"drop\" />\n";

            echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";

            echo '<input type="hidden" name="column" value="', htmlspecialchars($_REQUEST['column']), "\" />\n";

            echo $misc->form;

            echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\"> <label for=\"cascade\">{$lang['strcascade']}</label></p>\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 = $data->dropColumn($_POST['table'], $_POST['column'], isset($_POST['cascade']));

            if ($status == 0) {

                $misc->setReloadBrowser(true);

                $this->doDefault($lang['strcolumndropped']);

            } else {

                $this->doDefault($lang['strcolumndroppedbad']);

            }

        }

    }

}

    /**

     * Show confirmation of drop and perform actual drop

     */

    public function doDrop($confirm)

    {

        $conf = $this->conf;

        $misc = $this->misc;

        $lang = $this->lang;

        $data = $misc->getDatabaseAccessor();

        if ($confirm) {

            $this->printTrail('trigger');

            $this->printTitle($lang['strdrop'], 'pg.trigger.drop');

            echo '<p>', sprintf($lang['strconfdroptrigger'], $misc->printVal($_REQUEST['trigger']),

                $misc->printVal($_REQUEST['table'])), "</p>\n";

            echo '<form action="' . SUBFOLDER . "/src/views/triggers.php\" method=\"post\">\n";

            echo "<input type=\"hidden\" name=\"action\" value=\"drop\" />\n";

            echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";

            echo '<input type="hidden" name="trigger" value="', htmlspecialchars($_REQUEST['trigger']), "\" />\n";

            echo $misc->form;

            echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\" /> <label for=\"cascade\">{$lang['strcascade']}</label></p>\n";

            echo "<input type=\"submit\" name=\"yes\" value=\"{$lang['stryes']}\" />\n";

            echo "<input type=\"submit\" name=\"no\" value=\"{$lang['strno']}\" />\n";

            echo "</form>\n";

        } else {

            $status = $data->dropTrigger($_POST['trigger'], $_POST['table'], isset($_POST['cascade']));

            if ($status == 0) {

                $this->doDefault($lang['strtriggerdropped']);

            } else {

                $this->doDefault($lang['strtriggerdroppedbad']);

            }

        }

    }

    /**

     * Show confirmation of enable trigger and perform enabling the trigger

     */

    public function doEnable($confirm)