HuasoFoundries /
phpPgAdmin6
| Total Complexity | 112 |
| Total Lines | 901 |
| Duplicated Lines | 0 % |
| Changes | 0 | ||
Complex classes like ViewsController often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes.
Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.
While breaking up the class, it is a good idea to analyze how other classes use ViewsController, and based on these observations, apply Extract Interface, too.
| 1 | <?php |
||
| 14 | class ViewsController extends BaseController |
||
| 15 | { |
||
| 16 | public $script = 'views.php'; |
||
| 17 | public $controller_name = 'ViewsController'; |
||
| 18 | public $table_place = 'views-views'; |
||
| 19 | |||
| 20 | public function render() |
||
| 103 | } |
||
| 104 | |||
| 105 | /** |
||
| 106 | * Show default list of views in the database |
||
| 107 | * @param mixed $msg |
||
|
1 ignored issue
–
show
|
|||
| 108 | */ |
||
| 109 | public function doDefault($msg = '') |
||
| 110 | { |
||
| 111 | $conf = $this->conf; |
||
| 112 | |||
| 113 | $lang = $this->lang; |
||
| 114 | $data = $this->misc->getDatabaseAccessor(); |
||
| 115 | |||
| 116 | $this->printTrail('schema'); |
||
| 117 | $this->printTabs('schema', 'views'); |
||
| 118 | $this->printMsg($msg); |
||
| 119 | |||
| 120 | $views = $data->getViews(); |
||
| 121 | |||
| 122 | $columns = [ |
||
| 123 | 'view' => [ |
||
| 124 | 'title' => $lang['strview'], |
||
| 125 | 'field' => Decorator::field('relname'), |
||
| 126 | 'url' => SUBFOLDER . "/redirect/view?{$this->misc->href}&", |
||
| 127 | 'vars' => ['view' => 'relname'], |
||
| 128 | ], |
||
| 129 | 'owner' => [ |
||
| 130 | 'title' => $lang['strowner'], |
||
| 131 | 'field' => Decorator::field('relowner'), |
||
| 132 | ], |
||
| 133 | 'actions' => [ |
||
| 134 | 'title' => $lang['stractions'], |
||
| 135 | ], |
||
| 136 | 'comment' => [ |
||
| 137 | 'title' => $lang['strcomment'], |
||
| 138 | 'field' => Decorator::field('relcomment'), |
||
| 139 | ], |
||
| 140 | ]; |
||
| 141 | |||
| 142 | $actions = [ |
||
| 143 | 'multiactions' => [ |
||
| 144 | 'keycols' => ['view' => 'relname'], |
||
| 145 | 'url' => 'views.php', |
||
| 146 | ], |
||
| 147 | 'browse' => [ |
||
| 148 | 'content' => $lang['strbrowse'], |
||
| 149 | 'attr' => [ |
||
| 150 | 'href' => [ |
||
| 151 | 'url' => 'display.php', |
||
| 152 | 'urlvars' => [ |
||
| 153 | 'action' => 'confselectrows', |
||
| 154 | 'subject' => 'view', |
||
| 155 | 'return' => 'schema', |
||
| 156 | 'view' => Decorator::field('relname'), |
||
| 157 | ], |
||
| 158 | ], |
||
| 159 | ], |
||
| 160 | ], |
||
| 161 | 'select' => [ |
||
| 162 | 'content' => $lang['strselect'], |
||
| 163 | 'attr' => [ |
||
| 164 | 'href' => [ |
||
| 165 | 'url' => 'views.php', |
||
| 166 | 'urlvars' => [ |
||
| 167 | 'action' => 'confselectrows', |
||
| 168 | 'view' => Decorator::field('relname'), |
||
| 169 | ], |
||
| 170 | ], |
||
| 171 | ], |
||
| 172 | ], |
||
| 173 | |||
| 174 | // Insert is possible if the relevant rule for the view has been created. |
||
| 175 | // 'insert' => array( |
||
| 176 | // 'title' => $lang['strinsert'], |
||
| 177 | // 'url' => "views.php?action=confinsertrow&{$this->misc->href}&", |
||
| 178 | // 'vars' => array('view' => 'relname'), |
||
| 179 | // ), |
||
| 180 | |||
| 181 | 'alter' => [ |
||
| 182 | 'content' => $lang['stralter'], |
||
| 183 | 'attr' => [ |
||
| 184 | 'href' => [ |
||
| 185 | 'url' => 'viewproperties.php', |
||
| 186 | 'urlvars' => [ |
||
| 187 | 'action' => 'confirm_alter', |
||
| 188 | 'view' => Decorator::field('relname'), |
||
| 189 | ], |
||
| 190 | ], |
||
| 191 | ], |
||
| 192 | ], |
||
| 193 | 'drop' => [ |
||
| 194 | 'multiaction' => 'confirm_drop', |
||
| 195 | 'content' => $lang['strdrop'], |
||
| 196 | 'attr' => [ |
||
| 197 | 'href' => [ |
||
| 198 | 'url' => 'views.php', |
||
| 199 | 'urlvars' => [ |
||
| 200 | 'action' => 'confirm_drop', |
||
| 201 | 'view' => Decorator::field('relname'), |
||
| 202 | ], |
||
| 203 | ], |
||
| 204 | ], |
||
| 205 | ], |
||
| 206 | ]; |
||
| 207 | |||
| 208 | echo $this->printTable($views, $columns, $actions, $this->table_place, $lang['strnoviews']); |
||
| 209 | |||
| 210 | $navlinks = [ |
||
| 211 | 'create' => [ |
||
| 212 | 'attr' => [ |
||
| 213 | 'href' => [ |
||
| 214 | 'url' => 'views.php', |
||
| 215 | 'urlvars' => [ |
||
| 216 | 'action' => 'create', |
||
| 217 | 'server' => $_REQUEST['server'], |
||
| 218 | 'database' => $_REQUEST['database'], |
||
| 219 | 'schema' => $_REQUEST['schema'], |
||
| 220 | ], |
||
| 221 | ], |
||
| 222 | ], |
||
| 223 | 'content' => $lang['strcreateview'], |
||
| 224 | ], |
||
| 225 | 'createwiz' => [ |
||
| 226 | 'attr' => [ |
||
| 227 | 'href' => [ |
||
| 228 | 'url' => 'views.php', |
||
| 229 | 'urlvars' => [ |
||
| 230 | 'action' => 'wiz_create', |
||
| 231 | 'server' => $_REQUEST['server'], |
||
| 232 | 'database' => $_REQUEST['database'], |
||
| 233 | 'schema' => $_REQUEST['schema'], |
||
| 234 | ], |
||
| 235 | ], |
||
| 236 | ], |
||
| 237 | 'content' => $lang['strcreateviewwiz'], |
||
| 238 | ], |
||
| 239 | ]; |
||
| 240 | $this->printNavLinks($navlinks, $this->table_place, get_defined_vars()); |
||
| 241 | } |
||
| 242 | |||
| 243 | /** |
||
| 244 | * Generate XML for the browser tree. |
||
| 245 | */ |
||
| 246 | public function doTree() |
||
| 247 | { |
||
| 248 | $conf = $this->conf; |
||
| 249 | |||
| 250 | $lang = $this->lang; |
||
| 251 | $data = $this->misc->getDatabaseAccessor(); |
||
| 252 | |||
| 253 | $views = $data->getViews(); |
||
| 254 | |||
| 255 | $reqvars = $this->misc->getRequestVars('view'); |
||
| 256 | |||
| 257 | $attrs = [ |
||
| 258 | 'text' => Decorator::field('relname'), |
||
| 259 | 'icon' => 'View', |
||
| 260 | 'iconAction' => Decorator::url('display.php', $reqvars, ['view' => Decorator::field('relname')]), |
||
| 261 | 'toolTip' => Decorator::field('relcomment'), |
||
| 262 | 'action' => Decorator::redirecturl('redirect.php', $reqvars, ['view' => Decorator::field('relname')]), |
||
| 263 | 'branch' => Decorator::url('views.php', $reqvars, ['action' => 'subtree', 'view' => Decorator::field('relname')]), |
||
| 264 | ]; |
||
| 265 | |||
| 266 | return $this->printTree($views, $attrs, 'views'); |
||
| 267 | } |
||
| 268 | |||
| 269 | public function doSubTree() |
||
|
1 ignored issue
–
show
|
|||
| 270 | { |
||
| 271 | $conf = $this->conf; |
||
| 272 | |||
| 273 | $lang = $this->lang; |
||
| 274 | $data = $this->misc->getDatabaseAccessor(); |
||
| 275 | |||
| 276 | $tabs = $this->misc->getNavTabs('view'); |
||
| 277 | $items = $this->adjustTabsForTree($tabs); |
||
| 278 | $reqvars = $this->misc->getRequestVars('view'); |
||
| 279 | |||
| 280 | $attrs = [ |
||
| 281 | 'text' => Decorator::field('title'), |
||
| 282 | 'icon' => Decorator::field('icon'), |
||
| 283 | 'action' => Decorator::actionurl(Decorator::field('url'), $reqvars, Decorator::field('urlvars'), ['view' => $_REQUEST['view']]), |
||
| 284 | 'branch' => Decorator::ifempty( |
||
| 285 | Decorator::field('branch'), |
||
| 286 | '', |
||
| 287 | Decorator::url( |
||
| 288 | Decorator::field('url'), |
||
| 289 | Decorator::field('urlvars'), |
||
| 290 | $reqvars, |
||
| 291 | [ |
||
| 292 | 'action' => 'tree', |
||
| 293 | 'view' => $_REQUEST['view'], |
||
| 294 | ] |
||
| 295 | ) |
||
| 296 | ), |
||
| 297 | ]; |
||
| 298 | |||
| 299 | return $this->printTree($items, $attrs, 'view'); |
||
| 300 | } |
||
| 301 | |||
| 302 | /** |
||
| 303 | * Ask for select parameters and perform select |
||
| 304 | * @param mixed $confirm |
||
|
1 ignored issue
–
show
|
|||
| 305 | * @param mixed $msg |
||
|
1 ignored issue
–
show
|
|||
| 306 | */ |
||
| 307 | public function doSelectRows($confirm, $msg = '') |
||
| 308 | { |
||
| 309 | $conf = $this->conf; |
||
| 310 | |||
| 311 | $lang = $this->lang; |
||
| 312 | $data = $this->misc->getDatabaseAccessor(); |
||
| 313 | |||
| 314 | if ($confirm) { |
||
| 315 | $this->printTrail('view'); |
||
| 316 | $this->printTabs('view', 'select'); |
||
| 317 | $this->printMsg($msg); |
||
| 318 | |||
| 319 | $attrs = $data->getTableAttributes($_REQUEST['view']); |
||
| 320 | |||
| 321 | echo '<form action="' . SUBFOLDER . '/src/views/' . $this->script . '" method="post" id="selectform">'; |
||
| 322 | echo "\n"; |
||
| 323 | |||
| 324 | if ($attrs->recordCount() > 0) { |
||
| 325 | // JavaScript for select all feature |
||
| 326 | echo "<script type=\"text/javascript\">\n"; |
||
| 327 | echo "//<![CDATA[\n"; |
||
| 328 | echo " function selectAll() {\n"; |
||
| 329 | echo " for (var i=0; i<document.getElementById('selectform').elements.length; i++) {\n"; |
||
| 330 | echo " var e = document.getElementById('selectform').elements[i];\n"; |
||
| 331 | echo " if (e.name.indexOf('show') == 0) { \n "; |
||
| 332 | echo " e.checked = document.getElementById('selectform').selectall.checked;\n"; |
||
| 333 | echo " }\n"; |
||
| 334 | echo " }\n"; |
||
| 335 | echo " }\n"; |
||
| 336 | echo "//]]>\n"; |
||
| 337 | echo "</script>\n"; |
||
| 338 | |||
| 339 | echo "<table>\n"; |
||
| 340 | |||
| 341 | // Output table header |
||
| 342 | echo "<tr><th class=\"data\">{$lang['strshow']}</th><th class=\"data\">{$lang['strcolumn']}</th>"; |
||
| 343 | echo "<th class=\"data\">{$lang['strtype']}</th><th class=\"data\">{$lang['stroperator']}</th>"; |
||
| 344 | echo "<th class=\"data\">{$lang['strvalue']}</th></tr>"; |
||
| 345 | |||
| 346 | $i = 0; |
||
| 347 | while (!$attrs->EOF) { |
||
| 348 | $attrs->fields['attnotnull'] = $data->phpBool($attrs->fields['attnotnull']); |
||
| 349 | // Set up default value if there isn't one already |
||
| 350 | if (!isset($_REQUEST['values'][$attrs->fields['attname']])) { |
||
| 351 | $_REQUEST['values'][$attrs->fields['attname']] = null; |
||
| 352 | } |
||
| 353 | |||
| 354 | if (!isset($_REQUEST['ops'][$attrs->fields['attname']])) { |
||
| 355 | $_REQUEST['ops'][$attrs->fields['attname']] = null; |
||
| 356 | } |
||
| 357 | |||
| 358 | // Continue drawing row |
||
| 359 | $id = (0 == ($i % 2) ? '1' : '2'); |
||
| 360 | echo "<tr class=\"data{$id}\">\n"; |
||
| 361 | echo '<td style="white-space:nowrap;">'; |
||
| 362 | echo '<input type="checkbox" name="show[', htmlspecialchars($attrs->fields['attname']), ']"', |
||
| 363 | isset($_REQUEST['show'][$attrs->fields['attname']]) ? ' checked="checked"' : '', ' /></td>'; |
||
| 364 | echo '<td style="white-space:nowrap;">', $this->misc->printVal($attrs->fields['attname']), '</td>'; |
||
| 365 | echo '<td style="white-space:nowrap;">', $this->misc->printVal($data->formatType($attrs->fields['type'], $attrs->fields['atttypmod'])), '</td>'; |
||
| 366 | echo '<td style="white-space:nowrap;">'; |
||
| 367 | echo "<select name=\"ops[{$attrs->fields['attname']}]\">\n"; |
||
| 368 | foreach (array_keys($data->selectOps) as $v) { |
||
| 369 | echo '<option value="', htmlspecialchars($v), '"', ($_REQUEST['ops'][$attrs->fields['attname']] == $v) ? ' selected="selected"' : '', |
||
| 370 | '>', htmlspecialchars($v), "</option>\n"; |
||
| 371 | } |
||
| 372 | echo "</select></td>\n"; |
||
| 373 | echo '<td style="white-space:nowrap;">', $data->printField( |
||
| 374 | "values[{$attrs->fields['attname']}]", |
||
| 375 | $_REQUEST['values'][$attrs->fields['attname']], |
||
| 376 | $attrs->fields['type'] |
||
| 377 | ), '</td>'; |
||
| 378 | echo "</tr>\n"; |
||
| 379 | $i++; |
||
| 380 | $attrs->moveNext(); |
||
| 381 | } |
||
| 382 | // Select all checkbox |
||
| 383 | echo "<tr><td colspan=\"5\"><input type=\"checkbox\" id=\"selectall\" name=\"selectall\" accesskey=\"a\" onclick=\"javascript:selectAll()\" /><label for=\"selectall\">{$lang['strselectallfields']}</label></td></tr>"; |
||
| 384 | echo "</table>\n"; |
||
| 385 | } else { |
||
| 386 | echo "<p>{$lang['strinvalidparam']}</p>\n"; |
||
| 387 | } |
||
| 388 | |||
| 389 | echo "<p><input type=\"hidden\" name=\"action\" value=\"selectrows\" />\n"; |
||
| 390 | echo '<input type="hidden" name="view" value="', htmlspecialchars($_REQUEST['view']), "\" />\n"; |
||
| 391 | echo "<input type=\"hidden\" name=\"subject\" value=\"view\" />\n"; |
||
| 392 | echo $this->misc->form; |
||
| 393 | echo "<input type=\"submit\" name=\"select\" accesskey=\"r\" value=\"{$lang['strselect']}\" />\n"; |
||
| 394 | echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n"; |
||
| 395 | echo "</form>\n"; |
||
| 396 | |||
| 397 | return; |
||
| 398 | } |
||
| 399 | if (!isset($_POST['show'])) { |
||
| 400 | $_POST['show'] = []; |
||
| 401 | } |
||
| 402 | |||
| 403 | if (!isset($_POST['values'])) { |
||
| 404 | $_POST['values'] = []; |
||
| 405 | } |
||
| 406 | |||
| 407 | if (!isset($_POST['nulls'])) { |
||
| 408 | $_POST['nulls'] = []; |
||
| 409 | } |
||
| 410 | |||
| 411 | // Verify that they haven't supplied a value for unary operators |
||
| 412 | foreach ($_POST['ops'] as $k => $v) { |
||
| 413 | if ('p' == $data->selectOps[$v] && $_POST['values'][$k] != '') { |
||
| 414 | $this->doSelectRows(true, $lang['strselectunary']); |
||
| 415 | |||
| 416 | return; |
||
| 417 | } |
||
| 418 | } |
||
| 419 | |||
| 420 | if (0 == sizeof($_POST['show'])) { |
||
| 421 | return $this->doSelectRows(true, $lang['strselectneedscol']); |
||
| 422 | } |
||
| 423 | // Generate query SQL |
||
| 424 | $query = $data->getSelectSQL($_REQUEST['view'], array_keys($_POST['show']), $_POST['values'], $_POST['ops']); |
||
| 425 | |||
| 426 | $_REQUEST['query'] = $query; |
||
| 427 | $_REQUEST['return'] = 'schema'; |
||
| 428 | |||
| 429 | $this->setNoOutput(true); |
||
| 430 | |||
| 431 | $display_controller = new DisplayController($this->getContainer()); |
||
| 432 | |||
| 433 | return $display_controller->render(); |
||
| 434 | } |
||
| 435 | |||
| 436 | /** |
||
| 437 | * Show confirmation of drop and perform actual drop |
||
| 438 | * @param mixed $confirm |
||
|
1 ignored issue
–
show
|
|||
| 439 | */ |
||
| 440 | public function doDrop($confirm) |
||
| 507 | } |
||
| 508 | } |
||
| 509 | } |
||
| 510 | } |
||
| 511 | |||
| 512 | /** |
||
| 513 | * Sets up choices for table linkage, and which fields to select for the view we're creating |
||
| 514 | * @param mixed $msg |
||
|
1 ignored issue
–
show
|
|||
| 515 | */ |
||
| 516 | public function doSetParamsCreate($msg = '') |
||
| 517 | { |
||
| 518 | $conf = $this->conf; |
||
| 519 | |||
| 520 | $lang = $this->lang; |
||
| 521 | $data = $this->misc->getDatabaseAccessor(); |
||
| 522 | |||
| 523 | // Check that they've chosen tables for the view definition |
||
| 524 | if (!isset($_POST['formTables'])) { |
||
| 525 | $this->doWizardCreate($lang['strviewneedsdef']); |
||
| 526 | } else { |
||
| 527 | // Initialise variables |
||
| 528 | if (!isset($_REQUEST['formView'])) { |
||
| 529 | $_REQUEST['formView'] = ''; |
||
| 530 | } |
||
| 531 | |||
| 532 | if (!isset($_REQUEST['formComment'])) { |
||
| 533 | $_REQUEST['formComment'] = ''; |
||
| 534 | } |
||
| 535 | |||
| 536 | $this->printTrail('schema'); |
||
| 537 | $this->printTitle($lang['strcreateviewwiz'], 'pg.view.create'); |
||
| 538 | $this->printMsg($msg); |
||
| 539 | |||
| 540 | $tblCount = sizeof($_POST['formTables']); |
||
| 541 | //unserialize our schema/table information and store in arrSelTables |
||
| 542 | for ($i = 0; $i < $tblCount; $i++) { |
||
| 543 | $arrSelTables[] = unserialize($_POST['formTables'][$i]); |
||
| 544 | } |
||
| 545 | |||
| 546 | $linkCount = $tblCount; |
||
| 547 | |||
| 548 | //get linking keys |
||
| 549 | $rsLinkKeys = $data->getLinkingKeys($arrSelTables); |
||
| 550 | $linkCount = $rsLinkKeys->recordCount() > $tblCount ? $rsLinkKeys->recordCount() : $tblCount; |
||
| 551 | |||
| 552 | $arrFields = []; //array that will hold all our table/field names |
||
| 553 | |||
| 554 | //if we have schemas we need to specify the correct schema for each table we're retrieiving |
||
| 555 | //with getTableAttributes |
||
| 556 | $curSchema = $data->_schema; |
||
| 557 | for ($i = 0; $i < $tblCount; $i++) { |
||
| 558 | if ($arrSelTables[$i]['schemaname'] != $data->_schema) { |
||
| 559 | $data->setSchema($arrSelTables[$i]['schemaname']); |
||
| 560 | } |
||
| 561 | |||
| 562 | $attrs = $data->getTableAttributes($arrSelTables[$i]['tablename']); |
||
| 563 | while (!$attrs->EOF) { |
||
| 564 | $arrFields["{$arrSelTables[$i]['schemaname']}.{$arrSelTables[$i]['tablename']}.{$attrs->fields['attname']}"] = serialize( |
||
| 565 | [ |
||
| 566 | 'schemaname' => $arrSelTables[$i]['schemaname'], |
||
| 567 | 'tablename' => $arrSelTables[$i]['tablename'], |
||
| 568 | 'fieldname' => $attrs->fields['attname']] |
||
| 569 | ); |
||
| 570 | $attrs->moveNext(); |
||
| 571 | } |
||
| 572 | |||
| 573 | $data->setSchema($curSchema); |
||
| 574 | } |
||
| 575 | asort($arrFields); |
||
| 576 | |||
| 577 | echo '<form action="' . SUBFOLDER . "/src/views/views.php\" method=\"post\">\n"; |
||
| 578 | echo "<table>\n"; |
||
| 579 | echo "<tr><th class=\"data\">{$lang['strviewname']}</th></tr>"; |
||
| 580 | echo "<tr>\n<td class=\"data1\">\n"; |
||
| 581 | // View name |
||
| 582 | echo '<input name="formView" value="', htmlspecialchars($_REQUEST['formView']), "\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" />\n"; |
||
| 583 | echo "</td>\n</tr>\n"; |
||
| 584 | echo "<tr><th class=\"data\">{$lang['strcomment']}</th></tr>"; |
||
| 585 | echo "<tr>\n<td class=\"data1\">\n"; |
||
| 586 | // View comments |
||
| 587 | echo '<textarea name="formComment" rows="3" cols="32">', |
||
| 588 | htmlspecialchars($_REQUEST['formComment']), "</textarea>\n"; |
||
| 589 | echo "</td>\n</tr>\n"; |
||
| 590 | echo "</table>\n"; |
||
| 591 | |||
| 592 | // Output selector for fields to be retrieved from view |
||
| 593 | echo "<table>\n"; |
||
| 594 | echo "<tr><th class=\"data\">{$lang['strcolumns']}</th></tr>"; |
||
| 595 | echo "<tr>\n<td class=\"data1\">\n"; |
||
| 596 | echo \PHPPgAdmin\XHtml\HTMLController::printCombo($arrFields, 'formFields[]', false, '', true); |
||
| 597 | echo "</td>\n</tr>"; |
||
| 598 | echo "<tr><td><input type=\"radio\" name=\"dblFldMeth\" id=\"dblFldMeth1\" value=\"rename\" /><label for=\"dblFldMeth1\">{$lang['strrenamedupfields']}</label>"; |
||
| 599 | echo "<br /><input type=\"radio\" name=\"dblFldMeth\" id=\"dblFldMeth2\" value=\"drop\" /><label for=\"dblFldMeth2\">{$lang['strdropdupfields']}</label>"; |
||
| 600 | echo "<br /><input type=\"radio\" name=\"dblFldMeth\" id=\"dblFldMeth3\" value=\"\" checked=\"checked\" /><label for=\"dblFldMeth3\">{$lang['strerrordupfields']}</label></td></tr></table><br />"; |
||
| 601 | |||
| 602 | // Output the Linking keys combo boxes |
||
| 603 | echo "<table>\n"; |
||
| 604 | echo "<tr><th class=\"data\">{$lang['strviewlink']}</th></tr>"; |
||
| 605 | $rowClass = 'data1'; |
||
| 606 | for ($i = 0; $i < $linkCount; $i++) { |
||
| 607 | // Initialise variables |
||
| 608 | if (!isset($formLink[$i]['operator'])) { |
||
| 609 | $formLink[$i]['operator'] = 'INNER JOIN'; |
||
| 610 | } |
||
| 611 | |||
| 612 | echo "<tr>\n<td class=\"${rowClass}\">\n"; |
||
| 613 | |||
| 614 | if (!$rsLinkKeys->EOF) { |
||
| 615 | $curLeftLink = htmlspecialchars(serialize(['schemaname' => $rsLinkKeys->fields['p_schema'], 'tablename' => $rsLinkKeys->fields['p_table'], 'fieldname' => $rsLinkKeys->fields['p_field']])); |
||
| 616 | $curRightLink = htmlspecialchars(serialize(['schemaname' => $rsLinkKeys->fields['f_schema'], 'tablename' => $rsLinkKeys->fields['f_table'], 'fieldname' => $rsLinkKeys->fields['f_field']])); |
||
| 617 | $rsLinkKeys->moveNext(); |
||
| 618 | } else { |
||
| 619 | $curLeftLink = ''; |
||
| 620 | $curRightLink = ''; |
||
| 621 | } |
||
| 622 | |||
| 623 | echo \PHPPgAdmin\XHtml\HTMLController::printCombo($arrFields, "formLink[${i}][leftlink]", true, $curLeftLink, false); |
||
| 624 | echo \PHPPgAdmin\XHtml\HTMLController::printCombo($data->joinOps, "formLink[${i}][operator]", true, $formLink[$i]['operator']); |
||
| 625 | echo \PHPPgAdmin\XHtml\HTMLController::printCombo($arrFields, "formLink[${i}][rightlink]", true, $curRightLink, false); |
||
| 626 | echo "</td>\n</tr>\n"; |
||
| 627 | $rowClass = 'data1' == $rowClass ? 'data2' : 'data1'; |
||
| 628 | } |
||
| 629 | echo "</table>\n<br />\n"; |
||
| 630 | |||
| 631 | // Build list of available operators (infix only) |
||
| 632 | $arrOperators = []; |
||
| 633 | foreach ($data->selectOps as $k => $v) { |
||
| 634 | if ('i' == $v) { |
||
| 635 | $arrOperators[$k] = $k; |
||
| 636 | } |
||
| 637 | } |
||
| 638 | |||
| 639 | // Output additional conditions, note that this portion of the wizard treats the right hand side as literal values |
||
| 640 | //(not as database objects) so field names will be treated as strings, use the above linking keys section to perform joins |
||
| 641 | echo "<table>\n"; |
||
| 642 | echo "<tr><th class=\"data\">{$lang['strviewconditions']}</th></tr>"; |
||
| 643 | $rowClass = 'data1'; |
||
| 644 | for ($i = 0; $i < $linkCount; $i++) { |
||
| 645 | echo "<tr>\n<td class=\"${rowClass}\">\n"; |
||
| 646 | echo \PHPPgAdmin\XHtml\HTMLController::printCombo($arrFields, "formCondition[${i}][field]"); |
||
| 647 | echo \PHPPgAdmin\XHtml\HTMLController::printCombo($arrOperators, "formCondition[${i}][operator]", false, false); |
||
| 648 | echo "<input type=\"text\" name=\"formCondition[${i}][txt]\" />\n"; |
||
| 649 | echo "</td>\n</tr>\n"; |
||
| 650 | $rowClass = 'data1' == $rowClass ? 'data2' : 'data1'; |
||
| 651 | } |
||
| 652 | echo "</table>\n"; |
||
| 653 | echo "<p><input type=\"hidden\" name=\"action\" value=\"save_create_wiz\" />\n"; |
||
| 654 | |||
| 655 | foreach ($arrSelTables as $curTable) { |
||
| 656 | echo '<input type="hidden" name="formTables[]" value="' . htmlspecialchars(serialize($curTable)) . "\" />\n"; |
||
| 657 | } |
||
| 658 | |||
| 659 | echo $this->misc->form; |
||
| 660 | echo "<input type=\"submit\" value=\"{$lang['strcreate']}\" />\n"; |
||
| 661 | echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n"; |
||
| 662 | echo "</form>\n"; |
||
| 663 | } |
||
| 664 | } |
||
| 665 | |||
| 666 | /** |
||
| 667 | * Display a wizard where they can enter a new view |
||
| 668 | * @param mixed $msg |
||
|
1 ignored issue
–
show
|
|||
| 669 | */ |
||
| 670 | public function doWizardCreate($msg = '') |
||
| 671 | { |
||
| 672 | $conf = $this->conf; |
||
| 673 | |||
| 674 | $lang = $this->lang; |
||
| 675 | $data = $this->misc->getDatabaseAccessor(); |
||
| 676 | |||
| 677 | $tables = $data->getTables(true); |
||
| 678 | |||
| 679 | $this->printTrail('schema'); |
||
| 680 | $this->printTitle($lang['strcreateviewwiz'], 'pg.view.create'); |
||
| 681 | $this->printMsg($msg); |
||
| 682 | |||
| 683 | echo '<form action="' . SUBFOLDER . "/src/views/views.php\" method=\"post\">\n"; |
||
| 684 | echo "<table>\n"; |
||
| 685 | echo "<tr><th class=\"data\">{$lang['strtables']}</th></tr>"; |
||
| 686 | echo "<tr>\n<td class=\"data1\">\n"; |
||
| 687 | |||
| 688 | $arrTables = []; |
||
| 689 | while (!$tables->EOF) { |
||
| 690 | $arrTmp = []; |
||
| 691 | $arrTmp['schemaname'] = $tables->fields['nspname']; |
||
| 692 | $arrTmp['tablename'] = $tables->fields['relname']; |
||
| 693 | $arrTables[$tables->fields['nspname'] . '.' . $tables->fields['relname']] = serialize($arrTmp); |
||
| 694 | $tables->moveNext(); |
||
| 695 | } |
||
| 696 | echo \PHPPgAdmin\XHtml\HTMLController::printCombo($arrTables, 'formTables[]', false, '', true); |
||
| 697 | |||
| 698 | echo "</td>\n</tr>\n"; |
||
| 699 | echo "</table>\n"; |
||
| 700 | echo "<p><input type=\"hidden\" name=\"action\" value=\"set_params_create\" />\n"; |
||
| 701 | echo $this->misc->form; |
||
| 702 | echo "<input type=\"submit\" value=\"{$lang['strnext']}\" />\n"; |
||
| 703 | echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n"; |
||
| 704 | echo "</form>\n"; |
||
| 705 | } |
||
| 706 | |||
| 707 | /** |
||
| 708 | * Displays a screen where they can enter a new view |
||
| 709 | * @param mixed $msg |
||
|
1 ignored issue
–
show
|
|||
| 710 | */ |
||
| 711 | public function doCreate($msg = '') |
||
| 712 | { |
||
| 713 | $conf = $this->conf; |
||
| 714 | |||
| 715 | $lang = $this->lang; |
||
| 716 | $data = $this->misc->getDatabaseAccessor(); |
||
| 717 | |||
| 718 | if (!isset($_REQUEST['formView'])) { |
||
| 719 | $_REQUEST['formView'] = ''; |
||
| 720 | } |
||
| 721 | |||
| 722 | if (!isset($_REQUEST['formDefinition'])) { |
||
| 723 | if (isset($_SESSION['sqlquery'])) { |
||
| 724 | $_REQUEST['formDefinition'] = $_SESSION['sqlquery']; |
||
| 725 | } else { |
||
| 726 | $_REQUEST['formDefinition'] = 'SELECT '; |
||
| 727 | } |
||
| 728 | } |
||
| 729 | if (!isset($_REQUEST['formComment'])) { |
||
| 730 | $_REQUEST['formComment'] = ''; |
||
| 731 | } |
||
| 732 | |||
| 733 | $this->printTrail('schema'); |
||
| 734 | $this->printTitle($lang['strcreateview'], 'pg.view.create'); |
||
| 735 | $this->printMsg($msg); |
||
| 736 | |||
| 737 | echo '<form action="' . SUBFOLDER . "/src/views/views.php\" method=\"post\">\n"; |
||
| 738 | echo "<table style=\"width: 100%\">\n"; |
||
| 739 | echo "\t<tr>\n\t\t<th class=\"data left required\">{$lang['strname']}</th>\n"; |
||
| 740 | echo "\t<td class=\"data1\"><input name=\"formView\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"", |
||
| 741 | htmlspecialchars($_REQUEST['formView']), "\" /></td>\n\t</tr>\n"; |
||
| 742 | echo "\t<tr>\n\t\t<th class=\"data left required\">{$lang['strdefinition']}</th>\n"; |
||
| 743 | echo "\t<td class=\"data1\"><textarea style=\"width:100%;\" rows=\"10\" cols=\"50\" name=\"formDefinition\">", |
||
| 744 | htmlspecialchars($_REQUEST['formDefinition']), "</textarea></td>\n\t</tr>\n"; |
||
| 745 | echo "\t<tr>\n\t\t<th class=\"data left\">{$lang['strcomment']}</th>\n"; |
||
| 746 | echo "\t\t<td class=\"data1\"><textarea name=\"formComment\" rows=\"3\" cols=\"32\">", |
||
| 747 | htmlspecialchars($_REQUEST['formComment']), "</textarea></td>\n\t</tr>\n"; |
||
| 748 | echo "</table>\n"; |
||
| 749 | echo "<p><input type=\"hidden\" name=\"action\" value=\"save_create\" />\n"; |
||
| 750 | echo $this->misc->form; |
||
| 751 | echo "<input type=\"submit\" value=\"{$lang['strcreate']}\" />\n"; |
||
| 752 | echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n"; |
||
| 753 | echo "</form>\n"; |
||
| 754 | } |
||
| 755 | |||
| 756 | /** |
||
| 757 | * Actually creates the new view in the database |
||
| 758 | */ |
||
| 759 | public function doSaveCreate() |
||
| 760 | { |
||
| 761 | $conf = $this->conf; |
||
| 762 | |||
| 763 | $lang = $this->lang; |
||
| 764 | $data = $this->misc->getDatabaseAccessor(); |
||
| 765 | |||
| 766 | // Check that they've given a name and a definition |
||
| 767 | if ('' == $_POST['formView']) { |
||
| 768 | $this->doCreate($lang['strviewneedsname']); |
||
| 769 | } elseif ('' == $_POST['formDefinition']) { |
||
| 770 | $this->doCreate($lang['strviewneedsdef']); |
||
| 771 | } else { |
||
| 772 | $status = $data->createView($_POST['formView'], $_POST['formDefinition'], false, $_POST['formComment']); |
||
| 773 | if (0 == $status) { |
||
| 774 | $this->misc->setReloadBrowser(true); |
||
| 775 | $this->doDefault($lang['strviewcreated']); |
||
| 776 | } else { |
||
| 777 | $this->doCreate($lang['strviewcreatedbad']); |
||
| 778 | } |
||
| 779 | } |
||
| 780 | } |
||
| 781 | |||
| 782 | /** |
||
| 783 | * Actually creates the new wizard view in the database |
||
| 784 | */ |
||
| 785 | public function doSaveCreateWiz() |
||
| 915 | } |
||
| 916 | } |
||
| 917 | } |
||
| 918 | } |
||
| 919 |
Loading history...