PHPPgAdmin\Controller\SequencesController::doDrop()

Complexity

Conditions	12
Paths	10

Size

Total Lines	77
Code Lines	54

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function doDrop($confirm, $msg = '')
    {
        $data = $this->misc->getDatabaseAccessor();

        if (empty($_REQUEST['sequence']) && empty($_REQUEST['ma'])) {
            return $this->doDefault($this->lang['strspecifysequencetodrop']);
        }

        if ($confirm) {
            $this->printTrail('sequence');
            $this->printTitle($this->lang['strdrop'], 'pg.sequence.drop');
            $this->printMsg($msg);

            echo '<form action="' . \containerInstance()->subFolder . '/src/views/sequences" method="post">' . \PHP_EOL;

            //If multi drop
            if (isset($_REQUEST['ma'])) {
                foreach ($_REQUEST['ma'] as $v) {
                    $a = \unserialize(\htmlspecialchars_decode($v, \ENT_QUOTES));
                    echo '<p>', \sprintf($this->lang['strconfdropsequence'], $this->misc->printVal($a['sequence'])), '</p>' . \PHP_EOL;
                    \printf('<input type="hidden" name="sequence[]" value="%s" />', \htmlspecialchars($a['sequence']));
                }
            } else {
                echo '<p>', \sprintf($this->lang['strconfdropsequence'], $this->misc->printVal($_REQUEST['sequence'])), '</p>' . \PHP_EOL;
                echo '<input type="hidden" name="sequence" value="', \htmlspecialchars($_REQUEST['sequence']), '" />' . \PHP_EOL;
            }

            echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\" /> <label for=\"cascade\">{$this->lang['strcascade']}</label></p>" . \PHP_EOL;
            echo '<p><input type="hidden" name="action" value="drop" />' . \PHP_EOL;
            echo $this->view->form;
            echo "<input type=\"submit\" name=\"drop\" value=\"{$this->lang['strdrop']}\" />" . \PHP_EOL;
            echo \sprintf('<input type="submit" name="cancel" value="%s"  /></p>%s', $this->lang['strcancel'], \PHP_EOL);
            echo '</form>' . \PHP_EOL;
        } else {
            if (\is_array($_POST['sequence'])) {
                $msg = '';
                $status = $data->beginTransaction();

                if (0 === $status) {
                    foreach ($_POST['sequence'] as $s) {
                        $status = $data->dropSequence($s, isset($_POST['cascade']));

                        if (0 === $status) {
                            $msg .= \sprintf(
                                '%s: %s<br />',
                                \htmlentities($s, \ENT_QUOTES, 'UTF-8'),
                                $this->lang['strsequencedropped']
                            );
                        } else {
                            $data->endTransaction();
                            $this->doDefault(\sprintf(
                                '%s%s: %s<br />',
                                $msg,
                                \htmlentities($s, \ENT_QUOTES, 'UTF-8'),
                                $this->lang['strsequencedroppedbad']
                            ));

                            return;
                        }
                    }
                }

                if (0 === $data->endTransaction()) {
                    // Everything went fine, back to the Default page....
                    $this->view->setReloadBrowser(true);
                    $this->doDefault($msg);
                } else {
                    $this->doDefault($this->lang['strsequencedroppedbad']);
                }
            } else {
                $status = $data->dropSequence($_POST['sequence'], isset($_POST['cascade']));

                if (0 === $status) {
                    $this->view->setReloadBrowser(true);
                    $this->doDefault($this->lang['strsequencedropped']);
                } else {
                    $this->doDrop(true, $this->lang['strsequencedroppedbad']);
                }