HuasoFoundries / phpPgAdmin6

     * @param mixed $confirm

     * @param mixed $msg

     */

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

    {

        $data = $this->misc->getDatabaseAccessor();

        if ($confirm) {

            $this->printTrail('domain');

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

            $this->printMsg($msg);

            echo '<p>', sprintf(

                $this->lang['strconfdropconstraint'],

                $this->misc->printVal($_REQUEST['constraint']),

                $this->misc->printVal($_REQUEST['domain'])

            ), '</p>'.PHP_EOL;

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

            echo '<input type="hidden" name="action" value="drop_con" />'.PHP_EOL;

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

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

            echo $this->misc->form;

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

            echo "<input type=\"submit\" name=\"drop\" value=\"{$this->lang['strdrop']}\" />".PHP_EOL;

            echo "<input type=\"submit\" name=\"cancel\" value=\"{$this->lang['strcancel']}\" />".PHP_EOL;

            echo '</form>'.PHP_EOL;

        } else {

            $status = $data->dropDomainConstraint($_POST['domain'], $_POST['constraint'], isset($_POST['cascade']));

            if (0 == $status) {

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

            } else {

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

            }

        }

    }

    /**

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

     *

     * @param mixed $confirm

     */

    public function doDrop($confirm)

    {

        $data = $this->misc->getDatabaseAccessor();

        if ($confirm) {

            $this->printTrail('trigger');

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

            echo '<p>', sprintf(

                $this->lang['strconfdroptrigger'],

                $this->misc->printVal($_REQUEST['trigger']),

                $this->misc->printVal($_REQUEST['table'])

            ), '</p>'.PHP_EOL;

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

            echo '<input type="hidden" name="action" value="drop" />'.PHP_EOL;

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

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

            echo $this->misc->form;

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

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

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

            echo '</form>'.PHP_EOL;

        } else {

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

            if (0 == $status) {

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

            } else {

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

            }

        }

    }

    /**

     * Show confirmation of enable trigger and perform enabling the trigger.