Issues in TriggersController.php - New Issues - Inspection of "Php cs fixer" - HuasoFoundries/phpPgAdmin6 - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — develop (#92)

by Felipe

created 2018-02-15 19:18 UTC

src/controllers/TriggersController.php (8 issues)

Labels

Severity

<?php


/*
 * PHPPgAdmin v6.0.0-beta.30
 */

namespace PHPPgAdmin\Controller;

use PHPPgAdmin\Decorators\Decorator;

/**
 * Base controller class.
 */
class TriggersController extends BaseController
{
    public $controller_name = 'TriggersController';

    /**
     * Default method to render the controller according to the action parameter.
     */
    public function render()
    {
        $conf = $this->conf;

        $lang = $this->lang;

        $action = $this->action;
        if ('tree' == $action) {
            return $this->doTree();
        }

        $this->printHeader($lang['strtables'].' - '.$_REQUEST['table'].' - '.$lang['strtriggers']);
        $this->printBody();

        switch ($action) {
            case 'alter':
                if (isset($_POST['alter'])) {
                    $this->doSaveAlter();
                } else {
                    $this->doDefault();
                }

                break;
            case 'confirm_alter':
                $this->doAlter();

                break;
            case 'confirm_enable':
                $this->doEnable(true);

                break;
            case 'confirm_disable':
                $this->doDisable(true);

                break;
            case 'save_create':
                if (isset($_POST['cancel'])) {
                    $this->doDefault();
                } else {
                    $this->doSaveCreate();
                }

                break;
            case 'create':
                $this->doCreate();

                break;
            case 'drop':
                if (isset($_POST['yes'])) {
                    $this->doDrop(false);
                } else {
                    $this->doDefault();
                }

                break;
            case 'confirm_drop':
                $this->doDrop(true);

                break;
            case 'enable':
                if (isset($_POST['yes'])) {
                    $this->doEnable(false);
                } else {
                    $this->doDefault();
                }

                break;
            case 'disable':
                if (isset($_POST['yes'])) {
                    $this->doDisable(false);
                } else {
                    $this->doDefault();
                }

                break;
            default:
                $this->doDefault();

                break;
        }

        return $this->printFooter();
    }

    /**
     * List all the triggers on the table.
     *
     * @param mixed $msg

     */
    public function doDefault($msg = '')
    {
        $conf = $this->conf;

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

        $tgPre = function (&$rowdata, $actions) use ($data) {
            // toggle enable/disable trigger per trigger
            if (!$data->phpBool($rowdata->fields['tgenabled'])) {
                unset($actions['disable']);
            } else {
                unset($actions['enable']);
            }

            return $actions;
        };

        $this->printTrail('table');
        $this->printTabs('table', 'triggers');
        $this->printMsg($msg);

        $triggers = $data->getTriggers($_REQUEST['table']);

        $columns = [
            'trigger' => [
                'title' => $lang['strname'],
                'field' => Decorator::field('tgname'),
            ],
            'definition' => [
                'title' => $lang['strdefinition'],
                'field' => Decorator::field('tgdef'),
            ],
            'function' => [
                'title' => $lang['strfunction'],
                'field' => Decorator::field('proproto'),
                'url'   => "functions.php?action=properties&amp;server={$_REQUEST['server']}&amp;database={$_REQUEST['database']}&amp;",
                'vars'  => [
                    'schema'       => 'pronamespace',
                    'function'     => 'proproto',
                    'function_oid' => 'prooid',
                ],
            ],
            'actions' => [
                'title' => $lang['stractions'],
            ],
        ];

        $actions = [
            'alter' => [
                'content' => $lang['stralter'],
                'attr'    => [
                    'href' => [
                        'url'     => 'triggers.php',
                        'urlvars' => [
                            'action'  => 'confirm_alter',
                            'table'   => $_REQUEST['table'],
                            'trigger' => Decorator::field('tgname'),
                        ],
                    ],
                ],
            ],
            'drop' => [
                'content' => $lang['strdrop'],
                'attr'    => [
                    'href' => [
                        'url'     => 'triggers.php',
                        'urlvars' => [
                            'action'  => 'confirm_drop',
                            'table'   => $_REQUEST['table'],
                            'trigger' => Decorator::field('tgname'),
                        ],
                    ],
                ],
            ],
        ];
        if ($data->hasDisableTriggers()) {
            $actions['enable'] = [
                'content' => $lang['strenable'],
                'attr'    => [
                    'href' => [
                        'url'     => 'triggers.php',
                        'urlvars' => [
                            'action'  => 'confirm_enable',
                            'table'   => $_REQUEST['table'],
                            'trigger' => Decorator::field('tgname'),
                        ],
                    ],
                ],
            ];
            $actions['disable'] = [
                'content' => $lang['strdisable'],
                'attr'    => [
                    'href' => [
                        'url'     => 'triggers.php',
                        'urlvars' => [
                            'action'  => 'confirm_disable',
                            'table'   => $_REQUEST['table'],
                            'trigger' => Decorator::field('tgname'),
                        ],
                    ],
                ],
            ];
        }

        echo $this->printTable($triggers, $columns, $actions, 'triggers-triggers', $lang['strnotriggers'], $tgPre);

        $this->printNavLinks(['create' => [
            'attr' => [
                'href' => [
                    'url'     => 'triggers.php',
                    'urlvars' => [
                        'action'   => 'create',
                        'server'   => $_REQUEST['server'],
                        'database' => $_REQUEST['database'],
                        'schema'   => $_REQUEST['schema'],
                        'table'    => $_REQUEST['table'],
                    ],
                ],
            ],
            'content' => $lang['strcreatetrigger'],
        ]], 'triggers-triggers', get_defined_vars());
    }

    public function doTree()
    {
        $conf = $this->conf;

        $lang = $this->lang;

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

        $triggers = $data->getTriggers($_REQUEST['table']);

        $reqvars = $this->misc->getRequestVars('table');

        $attrs = [
            'text' => Decorator::field('tgname'),
            'icon' => 'Trigger',
        ];

        return $this->printTree($triggers, $attrs, 'triggers');
    }

    /**
     * Function to save after altering a trigger.
     */
    public function doSaveAlter()
    {
        $conf = $this->conf;

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

        $status = $data->alterTrigger($_POST['table'], $_POST['trigger'], $_POST['name']);
        if (0 == $status) {
            $this->doDefault($lang['strtriggeraltered']);
        } else {
            $this->doAlter($lang['strtriggeralteredbad']);
        }
    }

    /**
     * Function to allow altering of a trigger.
     *
     * @param mixed $msg

     */
    public function doAlter($msg = '')
    {
        $conf = $this->conf;

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

        $this->printTrail('trigger');
        $this->printTitle($lang['stralter'], 'pg.trigger.alter');
        $this->printMsg($msg);

        $triggerdata = $data->getTrigger($_REQUEST['table'], $_REQUEST['trigger']);

        if ($triggerdata->recordCount() > 0) {
            if (!isset($_POST['name'])) {
                $_POST['name'] = $triggerdata->fields['tgname'];
            }

            echo '<form action="'.\SUBFOLDER."/src/views/triggers.php\" method=\"post\">\n";
            echo "<table>\n";
            echo "<tr><th class=\"data\">{$lang['strname']}</th>\n";
            echo '<td class="data1">';
            echo "<input name=\"name\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
            htmlspecialchars($_POST['name']), "\" />\n";
            echo "</table>\n";
            echo "<p><input type=\"hidden\" name=\"action\" value=\"alter\" />\n";
            echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
            echo '<input type="hidden" name="trigger" value="', htmlspecialchars($_REQUEST['trigger']), "\" />\n";
            echo $this->misc->form;
            echo "<input type=\"submit\" name=\"alter\" value=\"{$lang['strok']}\" />\n";
            echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
            echo "</form>\n";
        } else {
            echo "<p>{$lang['strnodata']}</p>\n";
        }
    }

    /**
     * Show confirmation of drop and perform actual drop.
     *
     * @param mixed $confirm

     */
    public function doDrop($confirm)
    {
        $conf = $this->conf;

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

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

            echo '<p>', sprintf(
                $lang['strconfdroptrigger'],
                $this->misc->printVal($_REQUEST['trigger']),
                $this->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 $this->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 (0 == $status) {
                $this->doDefault($lang['strtriggerdropped']);
            } else {
                $this->doDefault($lang['strtriggerdroppedbad']);
            }
        }
    }

    /**
     * Show confirmation of enable trigger and perform enabling the trigger.
     *
     * @param mixed $confirm

     */
    public function doEnable($confirm)
    {
        $conf = $this->conf;

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

        if ($confirm) {
            $this->printTrail('trigger');
            $this->printTitle($lang['strenable'], 'pg.table.alter');

            echo '<p>', sprintf(
                $lang['strconfenabletrigger'],
                $this->misc->printVal($_REQUEST['trigger']),
                $this->misc->printVal($_REQUEST['table'])
            ), "</p>\n";

            echo '<form action="'.\SUBFOLDER."/src/views/triggers.php\" method=\"post\">\n";
            echo "<input type=\"hidden\" name=\"action\" value=\"enable\" />\n";
            echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
            echo '<input type="hidden" name="trigger" value="', htmlspecialchars($_REQUEST['trigger']), "\" />\n";
            echo $this->misc->form;
            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->enableTrigger($_POST['trigger'], $_POST['table']);
            if (0 == $status) {
                $this->doDefault($lang['strtriggerenabled']);
            } else {
                $this->doDefault($lang['strtriggerenabledbad']);
            }
        }
    }

    /**
     * Show confirmation of disable trigger and perform disabling the trigger.
     *
     * @param mixed $confirm

     */
    public function doDisable($confirm)
    {
        $conf = $this->conf;

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

        if ($confirm) {
            $this->printTrail('trigger');
            $this->printTitle($lang['strdisable'], 'pg.table.alter');

            echo '<p>', sprintf(
                $lang['strconfdisabletrigger'],
                $this->misc->printVal($_REQUEST['trigger']),
                $this->misc->printVal($_REQUEST['table'])
            ), "</p>\n";

            echo '<form action="'.\SUBFOLDER."/src/views/triggers.php\" method=\"post\">\n";
            echo "<input type=\"hidden\" name=\"action\" value=\"disable\" />\n";
            echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
            echo '<input type="hidden" name="trigger" value="', htmlspecialchars($_REQUEST['trigger']), "\" />\n";
            echo $this->misc->form;
            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->disableTrigger($_POST['trigger'], $_POST['table']);
            if (0 == $status) {
                $this->doDefault($lang['strtriggerdisabled']);
            } else {
                $this->doDefault($lang['strtriggerdisabledbad']);
            }
        }
    }

    /**
     * Let them create s.th.
     *
     * @param mixed $msg

     */
    public function doCreate($msg = '')
    {
        $conf = $this->conf;

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

        $this->printTrail('table');
        $this->printTitle($lang['strcreatetrigger'], 'pg.trigger.create');
        $this->printMsg($msg);

        // Get all the functions that can be used in triggers
        $funcs = $data->getTriggerFunctions();
        if (0 == $funcs->recordCount()) {
            $this->doDefault($lang['strnofunctions']);

            return;
        }

        // Populate functions
        $sel0 = new \PHPPgAdmin\XHtml\XHtmlSelect('formFunction');
        while (!$funcs->EOF) {
            $sel0->add(new \PHPPgAdmin\XHtml\XHtmlOption($funcs->fields['proname']));
            $funcs->moveNext();
        }

        // Populate times
        $sel1 = new \PHPPgAdmin\XHtml\XHtmlSelect('formExecTime');
        $sel1->set_data($data->triggerExecTimes);

        // Populate events
        $sel2 = new \PHPPgAdmin\XHtml\XHtmlSelect('formEvent');
        $sel2->set_data($data->triggerEvents);

        // Populate occurences
        $sel3 = new \PHPPgAdmin\XHtml\XHtmlSelect('formFrequency');
        $sel3->set_data($data->triggerFrequency);

        echo '<form action="'.\SUBFOLDER."/src/views/triggers.php\" method=\"post\">\n";
        echo "<table>\n";
        echo "<tr>\n";
        echo "		<th class=\"data\">{$lang['strname']}</th>\n";
        echo "		<th class=\"data\">{$lang['strwhen']}</th>\n";
        echo "</tr>\n";
        echo "<tr>\n";
        echo "		<td class=\"data1\"> <input type=\"text\" name=\"formTriggerName\" size=\"32\" /></td>\n";
        echo '		<td class="data1"> ', $sel1->fetch(), "</td>\n";
        echo "</tr>\n";
        echo "<tr>\n";
        echo "    <th class=\"data\">{$lang['strevent']}</th>\n";
        echo "    <th class=\"data\">{$lang['strforeach']}</th>\n";
        echo "</tr>\n";
        echo "<tr>\n";
        echo '     <td class="data1"> ', $sel2->fetch(), "</td>\n";
        echo '     <td class="data1"> ', $sel3->fetch(), "</td>\n";
        echo "</tr>\n";
        echo "<tr><th class=\"data\"> {$lang['strfunction']}</th>\n";
        echo "<th class=\"data\"> {$lang['strarguments']}</th></tr>\n";
        echo '<tr><td class="data1">', $sel0->fetch(), "</td>\n";
        echo "<td class=\"data1\">(<input type=\"text\" name=\"formTriggerArgs\" size=\"32\" />)</td>\n";
        echo "</tr></table>\n";
        echo "<p><input type=\"submit\" value=\"{$lang['strcreate']}\" />\n";
        echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
        echo "<input type=\"hidden\" name=\"action\" value=\"save_create\" />\n";
        echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
        echo $this->misc->form;
        echo "</form>\n";
    }

    /**
     * Actually creates the new trigger in the database.
     */
    public function doSaveCreate()
    {
        $conf = $this->conf;

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

        // Check that they've given a name and a definition

        if ('' == $_POST['formFunction']) {
            $this->doCreate($lang['strtriggerneedsfunc']);
        } elseif ('' == $_POST['formTriggerName']) {
            $this->doCreate($lang['strtriggerneedsname']);
        } elseif ('' == $_POST['formEvent']) {
            $this->doCreate();
        } else {
            $status = $data->createTrigger(
                $_POST['formTriggerName'],
                $_POST['table'],
                $_POST['formFunction'],
                $_POST['formExecTime'],
                $_POST['formEvent'],
                $_POST['formFrequency'],
                $_POST['formTriggerArgs']
            );
            if (0 == $status) {
                $this->doDefault($lang['strtriggercreated']);
            } else {
                $this->doCreate($lang['strtriggercreatedbad']);
            }
        }
    }
}


1			<?php
2
			0 ignored issues – show Coding Style introduced 2018-02-15 15:30 UTC by Report Bug Copy Issue Report Show Similar Issues like this You must use "/**" style comments for a file comment Loading history...
3			/*
4			* PHPPgAdmin v6.0.0-beta.30
5			*/
6
7			namespace PHPPgAdmin\Controller;
8
9			use PHPPgAdmin\Decorators\Decorator;
10
11			/**
12			* Base controller class.
13			*/
14			class TriggersController extends BaseController
15			{
16			public $controller_name = 'TriggersController';
17
18			/**
19			* Default method to render the controller according to the action parameter.
20			*/
21			public function render()
22			{
23			$conf = $this->conf;
24
25			$lang = $this->lang;
26
27			$action = $this->action;
28			if ('tree' == $action) {
29			return $this->doTree();
30			}
31
32			$this->printHeader($lang['strtables'].' - '.$_REQUEST['table'].' - '.$lang['strtriggers']);
33			$this->printBody();
34
35			switch ($action) {
36			case 'alter':
37			if (isset($_POST['alter'])) {
38			$this->doSaveAlter();
39			} else {
40			$this->doDefault();
41			}
42
43			break;
44			case 'confirm_alter':
45			$this->doAlter();
46
47			break;
48			case 'confirm_enable':
49			$this->doEnable(true);
50
51			break;
52			case 'confirm_disable':
53			$this->doDisable(true);
54
55			break;
56			case 'save_create':
57			if (isset($_POST['cancel'])) {
58			$this->doDefault();
59			} else {
60			$this->doSaveCreate();
61			}
62
63			break;
64			case 'create':
65			$this->doCreate();
66
67			break;
68			case 'drop':
69			if (isset($_POST['yes'])) {
70			$this->doDrop(false);
71			} else {
72			$this->doDefault();
73			}
74
75			break;
76			case 'confirm_drop':
77			$this->doDrop(true);
78
79			break;
80			case 'enable':
81			if (isset($_POST['yes'])) {
82			$this->doEnable(false);
83			} else {
84			$this->doDefault();
85			}
86
87			break;
88			case 'disable':
89			if (isset($_POST['yes'])) {
90			$this->doDisable(false);
91			} else {
92			$this->doDefault();
93			}
94
95			break;
96			default:
97			$this->doDefault();
98
99			break;
100			}
101
102			return $this->printFooter();
103			}
104
105			/**
106			* List all the triggers on the table.
107			*
108			* @param mixed $msg
			1 ignored issue – show Coding Style introduced 2018-02-15 19:22 UTC by Report Bug Copy Issue Report Show Similar Issues like this Missing parameter comment Loading history...
109			*/
110			public function doDefault($msg = '')
111			{
112			$conf = $this->conf;
113
114			$lang = $this->lang;
115			$data = $this->misc->getDatabaseAccessor();
116
117			$tgPre = function (&$rowdata, $actions) use ($data) {
118			// toggle enable/disable trigger per trigger
119			if (!$data->phpBool($rowdata->fields['tgenabled'])) {
120			unset($actions['disable']);
121			} else {
122			unset($actions['enable']);
123			}
124
125			return $actions;
126			};
127
128			$this->printTrail('table');
129			$this->printTabs('table', 'triggers');
130			$this->printMsg($msg);
131
132			$triggers = $data->getTriggers($_REQUEST['table']);
133
134			$columns = [
135			'trigger' => [
136			'title' => $lang['strname'],
137			'field' => Decorator::field('tgname'),
138			],
139			'definition' => [
140			'title' => $lang['strdefinition'],
141			'field' => Decorator::field('tgdef'),
142			],
143			'function' => [
144			'title' => $lang['strfunction'],
145			'field' => Decorator::field('proproto'),
146			'url' => "functions.php?action=properties&server={$_REQUEST['server']}&database={$_REQUEST['database']}&",
147			'vars' => [
148			'schema' => 'pronamespace',
149			'function' => 'proproto',
150			'function_oid' => 'prooid',
151			],
152			],
153			'actions' => [
154			'title' => $lang['stractions'],
155			],
156			];
157
158			$actions = [
159			'alter' => [
160			'content' => $lang['stralter'],
161			'attr' => [
162			'href' => [
163			'url' => 'triggers.php',
164			'urlvars' => [
165			'action' => 'confirm_alter',
166			'table' => $_REQUEST['table'],
167			'trigger' => Decorator::field('tgname'),
168			],
169			],
170			],
171			],
172			'drop' => [
173			'content' => $lang['strdrop'],
174			'attr' => [
175			'href' => [
176			'url' => 'triggers.php',
177			'urlvars' => [
178			'action' => 'confirm_drop',
179			'table' => $_REQUEST['table'],
180			'trigger' => Decorator::field('tgname'),
181			],
182			],
183			],
184			],
185			];
186			if ($data->hasDisableTriggers()) {
187			$actions['enable'] = [
188			'content' => $lang['strenable'],
189			'attr' => [
190			'href' => [
191			'url' => 'triggers.php',
192			'urlvars' => [
193			'action' => 'confirm_enable',
194			'table' => $_REQUEST['table'],
195			'trigger' => Decorator::field('tgname'),
196			],
197			],
198			],
199			];
200			$actions['disable'] = [
201			'content' => $lang['strdisable'],
202			'attr' => [
203			'href' => [
204			'url' => 'triggers.php',
205			'urlvars' => [
206			'action' => 'confirm_disable',
207			'table' => $_REQUEST['table'],
208			'trigger' => Decorator::field('tgname'),
209			],
210			],
211			],
212			];
213			}
214
215			echo $this->printTable($triggers, $columns, $actions, 'triggers-triggers', $lang['strnotriggers'], $tgPre);
216
217			$this->printNavLinks(['create' => [
218			'attr' => [
219			'href' => [
220			'url' => 'triggers.php',
221			'urlvars' => [
222			'action' => 'create',
223			'server' => $_REQUEST['server'],
224			'database' => $_REQUEST['database'],
225			'schema' => $_REQUEST['schema'],
226			'table' => $_REQUEST['table'],
227			],
228			],
229			],
230			'content' => $lang['strcreatetrigger'],
231			]], 'triggers-triggers', get_defined_vars());
232			}
233
234			public function doTree()
235			{
236			$conf = $this->conf;
237
238			$lang = $this->lang;
			0 ignored issues – show Unused Code introduced 2018-02-15 15:30 UTC by Report Bug Copy Issue Report Show Similar Issues like this The assignment to `$lang` is dead and can be removed. Loading history...
239			$data = $this->misc->getDatabaseAccessor();
240
241			$triggers = $data->getTriggers($_REQUEST['table']);
242
243			$reqvars = $this->misc->getRequestVars('table');
244
245			$attrs = [
246			'text' => Decorator::field('tgname'),
247			'icon' => 'Trigger',
248			];
249
250			return $this->printTree($triggers, $attrs, 'triggers');
251			}
252
253			/**
254			* Function to save after altering a trigger.
255			*/
256			public function doSaveAlter()
257			{
258			$conf = $this->conf;
259
260			$lang = $this->lang;
261			$data = $this->misc->getDatabaseAccessor();
262
263			$status = $data->alterTrigger($_POST['table'], $_POST['trigger'], $_POST['name']);
264			if (0 == $status) {
265			$this->doDefault($lang['strtriggeraltered']);
266			} else {
267			$this->doAlter($lang['strtriggeralteredbad']);
268			}
269			}
270
271			/**
272			* Function to allow altering of a trigger.
273			*
274			* @param mixed $msg
			1 ignored issue – show Coding Style introduced 2018-02-15 19:22 UTC by Report Bug Copy Issue Report Show Similar Issues like this Missing parameter comment Loading history...
275			*/
276			public function doAlter($msg = '')
277			{
278			$conf = $this->conf;
279
280			$lang = $this->lang;
281			$data = $this->misc->getDatabaseAccessor();
282
283			$this->printTrail('trigger');
284			$this->printTitle($lang['stralter'], 'pg.trigger.alter');
285			$this->printMsg($msg);
286
287			$triggerdata = $data->getTrigger($_REQUEST['table'], $_REQUEST['trigger']);
288
289			if ($triggerdata->recordCount() > 0) {
290			if (!isset($_POST['name'])) {
291			$_POST['name'] = $triggerdata->fields['tgname'];
292			}
293
294			echo '<form action="'.\SUBFOLDER."/src/views/triggers.php\" method=\"post\">\n";
295			echo "<table>\n";
296			echo "<tr><th class=\"data\">{$lang['strname']}</th>\n";
297			echo '<td class="data1">';
298			echo "<input name=\"name\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
299			htmlspecialchars($_POST['name']), "\" />\n";
300			echo "</table>\n";
301			echo "<p><input type=\"hidden\" name=\"action\" value=\"alter\" />\n";
302			echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
303			echo '<input type="hidden" name="trigger" value="', htmlspecialchars($_REQUEST['trigger']), "\" />\n";
304			echo $this->misc->form;
305			echo "<input type=\"submit\" name=\"alter\" value=\"{$lang['strok']}\" />\n";
306			echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
307			echo "</form>\n";
308			} else {
309			echo "<p>{$lang['strnodata']}</p>\n";
310			}
311			}
312
313			/**
314			* Show confirmation of drop and perform actual drop.
315			*
316			* @param mixed $confirm
			1 ignored issue – show Coding Style introduced 2018-02-15 19:22 UTC by Report Bug Copy Issue Report Show Similar Issues like this Missing parameter comment Loading history...
317			*/
318			public function doDrop($confirm)
319			{
320			$conf = $this->conf;
321
322			$lang = $this->lang;
323			$data = $this->misc->getDatabaseAccessor();
324
325			if ($confirm) {
326			$this->printTrail('trigger');
327			$this->printTitle($lang['strdrop'], 'pg.trigger.drop');
328
329			echo '<p>', sprintf(
330			$lang['strconfdroptrigger'],
331			$this->misc->printVal($_REQUEST['trigger']),
332			$this->misc->printVal($_REQUEST['table'])
333			), "</p>\n";
334
335			echo '<form action="'.\SUBFOLDER."/src/views/triggers.php\" method=\"post\">\n";
336			echo "<input type=\"hidden\" name=\"action\" value=\"drop\" />\n";
337			echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
338			echo '<input type="hidden" name="trigger" value="', htmlspecialchars($_REQUEST['trigger']), "\" />\n";
339			echo $this->misc->form;
340			echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\" /> <label for=\"cascade\">{$lang['strcascade']}</label></p>\n";
341			echo "<input type=\"submit\" name=\"yes\" value=\"{$lang['stryes']}\" />\n";
342			echo "<input type=\"submit\" name=\"no\" value=\"{$lang['strno']}\" />\n";
343			echo "</form>\n";
344			} else {
345			$status = $data->dropTrigger($_POST['trigger'], $_POST['table'], isset($_POST['cascade']));
346			if (0 == $status) {
347			$this->doDefault($lang['strtriggerdropped']);
348			} else {
349			$this->doDefault($lang['strtriggerdroppedbad']);
350			}
351			}
352			}
353
354			/**
355			* Show confirmation of enable trigger and perform enabling the trigger.
356			*
357			* @param mixed $confirm
			1 ignored issue – show Coding Style introduced 2018-02-15 19:22 UTC by Report Bug Copy Issue Report Show Similar Issues like this Missing parameter comment Loading history...
358			*/
359			public function doEnable($confirm)
360			{
361			$conf = $this->conf;
362
363			$lang = $this->lang;
364			$data = $this->misc->getDatabaseAccessor();
365
366			if ($confirm) {
367			$this->printTrail('trigger');
368			$this->printTitle($lang['strenable'], 'pg.table.alter');
369
370			echo '<p>', sprintf(
371			$lang['strconfenabletrigger'],
372			$this->misc->printVal($_REQUEST['trigger']),
373			$this->misc->printVal($_REQUEST['table'])
374			), "</p>\n";
375
376			echo '<form action="'.\SUBFOLDER."/src/views/triggers.php\" method=\"post\">\n";
377			echo "<input type=\"hidden\" name=\"action\" value=\"enable\" />\n";
378			echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
379			echo '<input type="hidden" name="trigger" value="', htmlspecialchars($_REQUEST['trigger']), "\" />\n";
380			echo $this->misc->form;
381			echo "<input type=\"submit\" name=\"yes\" value=\"{$lang['stryes']}\" />\n";
382			echo "<input type=\"submit\" name=\"no\" value=\"{$lang['strno']}\" />\n";
383			echo "</form>\n";
384			} else {
385			$status = $data->enableTrigger($_POST['trigger'], $_POST['table']);
386			if (0 == $status) {
387			$this->doDefault($lang['strtriggerenabled']);
388			} else {
389			$this->doDefault($lang['strtriggerenabledbad']);
390			}
391			}
392			}
393
394			/**
395			* Show confirmation of disable trigger and perform disabling the trigger.
396			*
397			* @param mixed $confirm
			1 ignored issue – show Coding Style introduced 2018-02-15 19:22 UTC by Report Bug Copy Issue Report Show Similar Issues like this Missing parameter comment Loading history...
398			*/
399			public function doDisable($confirm)
400			{
401			$conf = $this->conf;
402
403			$lang = $this->lang;
404			$data = $this->misc->getDatabaseAccessor();
405
406			if ($confirm) {
407			$this->printTrail('trigger');
408			$this->printTitle($lang['strdisable'], 'pg.table.alter');
409
410			echo '<p>', sprintf(
411			$lang['strconfdisabletrigger'],
412			$this->misc->printVal($_REQUEST['trigger']),
413			$this->misc->printVal($_REQUEST['table'])
414			), "</p>\n";
415
416			echo '<form action="'.\SUBFOLDER."/src/views/triggers.php\" method=\"post\">\n";
417			echo "<input type=\"hidden\" name=\"action\" value=\"disable\" />\n";
418			echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
419			echo '<input type="hidden" name="trigger" value="', htmlspecialchars($_REQUEST['trigger']), "\" />\n";
420			echo $this->misc->form;
421			echo "<input type=\"submit\" name=\"yes\" value=\"{$lang['stryes']}\" />\n";
422			echo "<input type=\"submit\" name=\"no\" value=\"{$lang['strno']}\" />\n";
423			echo "</form>\n";
424			} else {
425			$status = $data->disableTrigger($_POST['trigger'], $_POST['table']);
426			if (0 == $status) {
427			$this->doDefault($lang['strtriggerdisabled']);
428			} else {
429			$this->doDefault($lang['strtriggerdisabledbad']);
430			}
431			}
432			}
433
434			/**
435			* Let them create s.th.
436			*
437			* @param mixed $msg
			1 ignored issue – show Coding Style introduced 2018-02-15 19:22 UTC by Report Bug Copy Issue Report Show Similar Issues like this Missing parameter comment Loading history...
438			*/
439			public function doCreate($msg = '')
440			{
441			$conf = $this->conf;
442
443			$lang = $this->lang;
444			$data = $this->misc->getDatabaseAccessor();
445
446			$this->printTrail('table');
447			$this->printTitle($lang['strcreatetrigger'], 'pg.trigger.create');
448			$this->printMsg($msg);
449
450			// Get all the functions that can be used in triggers
451			$funcs = $data->getTriggerFunctions();
452			if (0 == $funcs->recordCount()) {
453			$this->doDefault($lang['strnofunctions']);
454
455			return;
456			}
457
458			// Populate functions
459			$sel0 = new \PHPPgAdmin\XHtml\XHtmlSelect('formFunction');
460			while (!$funcs->EOF) {
461			$sel0->add(new \PHPPgAdmin\XHtml\XHtmlOption($funcs->fields['proname']));
462			$funcs->moveNext();
463			}
464
465			// Populate times
466			$sel1 = new \PHPPgAdmin\XHtml\XHtmlSelect('formExecTime');
467			$sel1->set_data($data->triggerExecTimes);
468
469			// Populate events
470			$sel2 = new \PHPPgAdmin\XHtml\XHtmlSelect('formEvent');
471			$sel2->set_data($data->triggerEvents);
472
473			// Populate occurences
474			$sel3 = new \PHPPgAdmin\XHtml\XHtmlSelect('formFrequency');
475			$sel3->set_data($data->triggerFrequency);
476
477			echo '<form action="'.\SUBFOLDER."/src/views/triggers.php\" method=\"post\">\n";
478			echo "<table>\n";
479			echo "<tr>\n";
480			echo " <th class=\"data\">{$lang['strname']}</th>\n";
481			echo " <th class=\"data\">{$lang['strwhen']}</th>\n";
482			echo "</tr>\n";
483			echo "<tr>\n";
484			echo " <td class=\"data1\"> <input type=\"text\" name=\"formTriggerName\" size=\"32\" /></td>\n";
485			echo ' <td class="data1"> ', $sel1->fetch(), "</td>\n";
486			echo "</tr>\n";
487			echo "<tr>\n";
488			echo " <th class=\"data\">{$lang['strevent']}</th>\n";
489			echo " <th class=\"data\">{$lang['strforeach']}</th>\n";
490			echo "</tr>\n";
491			echo "<tr>\n";
492			echo ' <td class="data1"> ', $sel2->fetch(), "</td>\n";
493			echo ' <td class="data1"> ', $sel3->fetch(), "</td>\n";
494			echo "</tr>\n";
495			echo "<tr><th class=\"data\"> {$lang['strfunction']}</th>\n";
496			echo "<th class=\"data\"> {$lang['strarguments']}</th></tr>\n";
497			echo '<tr><td class="data1">', $sel0->fetch(), "</td>\n";
498			echo "<td class=\"data1\">(<input type=\"text\" name=\"formTriggerArgs\" size=\"32\" />)</td>\n";
499			echo "</tr></table>\n";
500			echo "<p><input type=\"submit\" value=\"{$lang['strcreate']}\" />\n";
501			echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
502			echo "<input type=\"hidden\" name=\"action\" value=\"save_create\" />\n";
503			echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
504			echo $this->misc->form;
505			echo "</form>\n";
506			}
507
508			/**
509			* Actually creates the new trigger in the database.
510			*/
511			public function doSaveCreate()
512			{
513			$conf = $this->conf;
514
515			$lang = $this->lang;
516			$data = $this->misc->getDatabaseAccessor();
517
518			// Check that they've given a name and a definition
519
520			if ('' == $_POST['formFunction']) {
521			$this->doCreate($lang['strtriggerneedsfunc']);
522			} elseif ('' == $_POST['formTriggerName']) {
523			$this->doCreate($lang['strtriggerneedsname']);
524			} elseif ('' == $_POST['formEvent']) {
525			$this->doCreate();
526			} else {
527			$status = $data->createTrigger(
528			$_POST['formTriggerName'],
529			$_POST['table'],
530			$_POST['formFunction'],
531			$_POST['formExecTime'],
532			$_POST['formEvent'],
533			$_POST['formFrequency'],
534			$_POST['formTriggerArgs']
535			);
536			if (0 == $status) {
537			$this->doDefault($lang['strtriggercreated']);
538			} else {
539			$this->doCreate($lang['strtriggercreatedbad']);
540			}
541			}
542			}
543			}
544

HuasoFoundries / phpPgAdmin6

Pull Request — develop (#92)

src/controllers/TriggersController.php (8 issues)

Labels

Severity

Introduced By

Duplication Side-by-Side

Filter issues like