HuasoFoundries /
phpPgAdmin6
| Total Complexity | 56 |
| Total Lines | 370 |
| Duplicated Lines | 0 % |
| Changes | 14 | ||
| Bugs | 2 | Features | 1 |
Complex classes like HTMLTableController 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 HTMLTableController, and based on these observations, apply Extract Interface, too.
| 1 | <?php |
||
| 17 | class HTMLTableController extends HTMLController |
||
| 18 | { |
||
| 19 | public $controller_name = 'HTMLTableController'; |
||
| 20 | |||
| 21 | protected $ma = []; |
||
| 22 | |||
| 23 | protected $plugin_functions_parameters = []; |
||
| 24 | |||
| 25 | protected $has_ma = false; |
||
| 26 | |||
| 27 | protected $tabledata; |
||
| 28 | |||
| 29 | protected $columns; |
||
| 30 | |||
| 31 | protected $actions; |
||
| 32 | |||
| 33 | protected $place; |
||
| 34 | |||
| 35 | protected $nodata; |
||
| 36 | |||
| 37 | protected $pre_fn; |
||
| 38 | |||
| 39 | /** |
||
| 40 | * Display a table of data. |
||
| 41 | * |
||
| 42 | * @param \PHPPgAdmin\ADORecordSet|\PHPPgAdmin\ArrayRecordSet $tabledata a set of data to be formatted, as returned by $data->getDatabases() etc |
||
| 43 | * @param array $columns An associative array of columns to be displayed: |
||
| 44 | * $columns = array( |
||
| 45 | * column_id => array( |
||
| 46 | * 'title' => Column heading, |
||
| 47 | * 'class' => The class to apply on the column cells, |
||
| 48 | * 'field' => Field name for $tabledata->fields[...], |
||
| 49 | * 'help' => Help page for this column, |
||
| 50 | * ), ... |
||
| 51 | * ); |
||
| 52 | * @param array $actions Actions that can be performed on each object: |
||
| 53 | * $actions = array( |
||
| 54 | * * multi action support |
||
| 55 | * * parameters are serialized for each entries and given in $_REQUEST['ma'] |
||
| 56 | * 'multiactions' => array( |
||
| 57 | * 'keycols' => Associative array of (URL variable => field name), // fields included in the form |
||
| 58 | * 'url' => URL submission, |
||
| 59 | * 'default' => Default selected action in the form. If null, an empty action is added & selected |
||
| 60 | * ), |
||
| 61 | * * actions * |
||
| 62 | * action_id => array( |
||
| 63 | * 'title' => Action heading, |
||
| 64 | * 'url' => Static part of URL. Often we rely |
||
| 65 | * relative urls, usually the page itself (not '' !), or just a query string, |
||
| 66 | * 'vars' => Associative array of (URL variable => field name), |
||
| 67 | * 'multiaction' => Name of the action to execute. |
||
| 68 | * Add this action to the multi action form |
||
| 69 | * ), ... |
||
| 70 | * ); |
||
| 71 | * @param string $place Place where the $actions are displayed. Like 'display-browse', where 'display' |
||
| 72 | * is the entrypoint (/src/views/display) and 'browse' is the action used inside its controller (in this case, doBrowse). |
||
| 73 | * @param string $nodata (optional) Message to display if data set is empty |
||
| 74 | * @param callable $pre_fn (optional) callback closure for each row. It will be passed two params: $rowdata and $actions, |
||
| 75 | * it may be used to derive new fields or modify actions. |
||
| 76 | * It can return an array of actions specific to the row, or if nothing is returned then the standard actions are used. |
||
| 77 | * (see TblpropertiesController and ConstraintsController for examples) |
||
| 78 | * The function must not must not store urls because they are relative and won't work out of context. |
||
| 79 | */ |
||
| 80 | public function initialize(&$tabledata, &$columns, &$actions, $place, $nodata = '', $pre_fn = null): void |
||
| 81 | { |
||
| 82 | // Action buttons hook's place |
||
| 83 | $this->plugin_functions_parameters = [ |
||
| 84 | 'actionbuttons' => &$actions, |
||
| 85 | 'place' => $place, |
||
| 86 | ]; |
||
| 87 | |||
| 88 | if ($this->has_ma = isset($actions['multiactions'])) { |
||
| 89 | $this->ma = $actions['multiactions']; |
||
| 90 | } |
||
| 91 | unset($actions['multiactions']); |
||
| 92 | |||
| 93 | $this->tabledata = $tabledata; |
||
| 94 | $this->columns = $columns; |
||
| 95 | $this->actions = $actions; |
||
| 96 | $this->place = $place; |
||
| 97 | $this->nodata = $nodata; |
||
| 98 | $this->pre_fn = $pre_fn; |
||
| 99 | } |
||
| 100 | |||
| 101 | public function printTable($turn_into_datatable = true, $with_body = true) |
||
| 102 | { |
||
| 103 | if (0 >= $this->tabledata->recordCount()) { |
||
| 104 | return "<p>{$this->nodata}</p>" . \PHP_EOL; |
||
| 105 | } |
||
| 106 | |||
| 107 | $tablehtml = ''; |
||
| 108 | // Remove the 'comment' column if they have been disabled |
||
| 109 | if (!$this->conf['show_comments']) { |
||
| 110 | unset($this->columns['comment']); |
||
| 111 | } |
||
| 112 | |||
| 113 | if (isset($this->columns['comment'])) { |
||
| 114 | // Uncomment this for clipped comments. |
||
| 115 | // TODO: This should be a user option. |
||
| 116 | //$columns['comment']['params']['clip'] = true; |
||
| 117 | } |
||
| 118 | |||
| 119 | list($matop_html, $mabottom_html) = $this->_getMaHtml(); |
||
| 120 | |||
| 121 | $tablehtml .= $matop_html; |
||
| 122 | |||
| 123 | $tablehtml .= '<table width="auto" class="' . ($turn_into_datatable ? 'will_be_datatable ' : ' ') . $this->place . '">' . \PHP_EOL; |
||
| 124 | |||
| 125 | $tablehtml .= $this->getThead(); |
||
| 126 | |||
| 127 | //$this->prtrace($tabledata, $actions); |
||
| 128 | |||
| 129 | $tablehtml .= $with_body ? $this->getTbody() : ''; |
||
| 130 | |||
| 131 | $tablehtml .= $this->getTfooter(); |
||
| 132 | |||
| 133 | $tablehtml .= '</table>' . \PHP_EOL; |
||
| 134 | |||
| 135 | // Multi action table footer w/ options & [un]check'em all |
||
| 136 | $tablehtml .= $mabottom_html; |
||
| 137 | |||
| 138 | return $tablehtml; |
||
| 139 | } |
||
| 140 | |||
| 141 | public function getThead() |
||
| 142 | { |
||
| 143 | $columns = $this->columns; |
||
| 144 | $actions = $this->actions; |
||
| 145 | |||
| 146 | $thead_html = '<thead><tr>' . \PHP_EOL; |
||
| 147 | |||
| 148 | // Display column headings |
||
| 149 | if ($this->has_ma) { |
||
| 150 | $thead_html .= '<th></th>'; |
||
| 151 | } |
||
| 152 | |||
| 153 | foreach ($columns as $column_id => $column) { |
||
| 154 | // Handle cases where no class has been passed |
||
| 155 | |||
| 156 | $class = (isset($column['class']) && '' !== $column['class']) ? $column['class'] : ''; |
||
| 157 | |||
| 158 | switch ($column_id) { |
||
| 159 | case 'actions': |
||
| 160 | if (0 < \count($actions)) { |
||
| 161 | $thead_html .= '<th class="data" >' . $column['title'] . '</th>' . \PHP_EOL; |
||
| 162 | } |
||
| 163 | |||
| 164 | break; |
||
| 165 | default: |
||
| 166 | $thead_html .= '<th class="data' . $class . '">'; |
||
| 167 | |||
| 168 | if (isset($column['help'])) { |
||
| 169 | $thead_html .= $this->misc->printHelp($column['title'], $column['help'], false); |
||
| 170 | } else { |
||
| 171 | $thead_html .= $column['title']; |
||
| 172 | } |
||
| 173 | |||
| 174 | $thead_html .= '</th>' . \PHP_EOL; |
||
| 175 | |||
| 176 | break; |
||
| 177 | } |
||
| 178 | } |
||
| 179 | $thead_html .= '</tr></thead>' . \PHP_EOL; |
||
| 180 | |||
| 181 | return $thead_html; |
||
| 182 | } |
||
| 183 | |||
| 184 | public function getTfooter() |
||
| 185 | { |
||
| 186 | $columns = $this->columns; |
||
| 187 | $actions = $this->actions; |
||
| 188 | |||
| 189 | $tfoot_html = '<tfoot><tr>' . \PHP_EOL; |
||
| 190 | |||
| 191 | // Display column headings |
||
| 192 | if ($this->has_ma) { |
||
| 193 | $tfoot_html .= '<td></td>'; |
||
| 194 | } |
||
| 195 | |||
| 196 | foreach ($columns as $column_id => $column) { |
||
| 197 | // Handle cases where no class has been passed |
||
| 198 | |||
| 199 | $class = (isset($column['class']) && '' !== $column['class']) ? $column['class'] : ''; |
||
| 200 | |||
| 201 | if ('actions' !== $column_id || 0 < \count($actions)) { |
||
| 202 | $tfoot_html .= "<td class=\"data{$class}\"></td>" . \PHP_EOL; |
||
| 203 | } |
||
| 204 | } |
||
| 205 | $tfoot_html .= '</tr></tfoot>' . \PHP_EOL; |
||
| 206 | |||
| 207 | return $tfoot_html; |
||
| 208 | } |
||
| 209 | |||
| 210 | private function _getMaHtml() |
||
| 211 | { |
||
| 212 | $matop_html = ''; |
||
| 213 | $ma_bottomhtml = ''; |
||
| 214 | $lang = $this->lang; |
||
| 215 | |||
| 216 | if ($this->has_ma) { |
||
| 217 | $matop_html .= '<script src="' . SUBFOLDER . '/assets/js/multiactionform.js" type="text/javascript"></script>' . \PHP_EOL; |
||
| 218 | $matop_html .= \sprintf('<form id="multi_form" action="%s" method="post" enctype="multipart/form-data">%s', $this->ma['url'], \PHP_EOL); |
||
| 219 | $this->coalesceArr($this->ma, 'vars', []); |
||
| 220 | |||
| 221 | foreach ($this->ma['vars'] as $k => $v) { |
||
| 222 | $matop_html .= \sprintf('<input type="hidden" name="%s" value="%s" />', $k, $v); |
||
| 223 | } |
||
| 224 | |||
| 225 | // if default is not set or doesn't exist, set it to null |
||
| 226 | if (!isset($this->ma['default']) || !isset($this->actions[$this->ma['default']])) { |
||
| 227 | $this->ma['default'] = null; |
||
| 228 | } |
||
| 229 | |||
| 230 | $ma_bottomhtml .= '<br />' . \PHP_EOL; |
||
| 231 | $ma_bottomhtml .= '<table>' . \PHP_EOL; |
||
| 232 | $ma_bottomhtml .= '<tr>' . \PHP_EOL; |
||
| 233 | $ma_bottomhtml .= "<th class=\"data\" style=\"text-align: left\" colspan=\"3\">{$lang['stractionsonmultiplelines']}</th>" . \PHP_EOL; |
||
| 234 | $ma_bottomhtml .= '</tr>' . \PHP_EOL; |
||
| 235 | $ma_bottomhtml .= '<tr class="row1">' . \PHP_EOL; |
||
| 236 | $ma_bottomhtml .= '<td>'; |
||
| 237 | $ma_bottomhtml .= "<a href=\"#\" onclick=\"javascript:checkAll(true);\">{$lang['strselectall']}</a> / "; |
||
| 238 | $ma_bottomhtml .= "<a href=\"#\" onclick=\"javascript:checkAll(false);\">{$lang['strunselectall']}</a></td>" . \PHP_EOL; |
||
| 239 | $ma_bottomhtml .= '<td> ---> </td>' . \PHP_EOL; |
||
| 240 | $ma_bottomhtml .= '<td>' . \PHP_EOL; |
||
| 241 | $ma_bottomhtml .= "\t<select name=\"action\">" . \PHP_EOL; |
||
| 242 | |||
| 243 | if (null === $this->ma['default']) { |
||
| 244 | $ma_bottomhtml .= "\t\t<option value=\"\">--</option>" . \PHP_EOL; |
||
| 245 | } |
||
| 246 | |||
| 247 | foreach ($this->actions as $k => $a) { |
||
| 248 | if (isset($a['multiaction'])) { |
||
| 249 | $selected = $this->ma['default'] === $k ? ' selected="selected" ' : ''; |
||
| 250 | $ma_bottomhtml .= "\t\t"; |
||
| 251 | $ma_bottomhtml .= '<option value="' . $a['multiaction'] . '" ' . $selected . ' rel="' . $k . '">' . $a['content'] . '</option>'; |
||
| 252 | $ma_bottomhtml .= \PHP_EOL; |
||
| 253 | } |
||
| 254 | } |
||
| 255 | |||
| 256 | $ma_bottomhtml .= "\t</select>" . \PHP_EOL; |
||
| 257 | $ma_bottomhtml .= "<input type=\"submit\" value=\"{$lang['strexecute']}\" />" . \PHP_EOL; |
||
| 258 | $ma_bottomhtml .= $this->getForm(); |
||
| 259 | $ma_bottomhtml .= '</td>' . \PHP_EOL; |
||
| 260 | $ma_bottomhtml .= '</tr>' . \PHP_EOL; |
||
| 261 | $ma_bottomhtml .= '</table>' . \PHP_EOL; |
||
| 262 | $ma_bottomhtml .= '</form>'; |
||
| 263 | } |
||
| 264 | |||
| 265 | return [$matop_html, $ma_bottomhtml]; |
||
| 266 | } |
||
| 267 | |||
| 268 | private function getTbody() |
||
| 269 | { |
||
| 270 | $columns = $this->columns; |
||
| 271 | $actions = $this->actions; |
||
| 272 | $tabledata = $this->tabledata; |
||
| 273 | $pre_fn = $this->pre_fn; |
||
| 274 | |||
| 275 | // Display table rows |
||
| 276 | $i = 0; |
||
| 277 | $tbody_html = '<tbody>'; |
||
| 278 | |||
| 279 | while (!$tabledata->EOF) { |
||
| 280 | $id = ($i % 2) + 1; |
||
| 281 | |||
| 282 | unset($alt_actions); |
||
| 283 | |||
| 284 | if (null !== $pre_fn) { |
||
| 285 | $alt_actions = $pre_fn($tabledata, $actions); |
||
| 286 | } |
||
| 287 | |||
| 288 | if (!isset($alt_actions)) { |
||
| 289 | $alt_actions = &$actions; |
||
| 290 | } |
||
| 291 | |||
| 292 | $tbody_html .= \sprintf('<tr class="data%s">', $id) . \PHP_EOL; |
||
| 293 | |||
| 294 | if ($this->has_ma) { |
||
| 295 | $a = []; |
||
| 296 | |||
| 297 | foreach ($this->ma['keycols'] as $k => $v) { |
||
| 298 | $a[$k] = $tabledata->fields[$v]; |
||
| 299 | } |
||
| 300 | //\Kint::dump($a); |
||
| 301 | $tbody_html .= \sprintf('<td><input type="checkbox" name="ma[]" value="%s"/></td>', \htmlentities(\serialize($a), \ENT_COMPAT, 'UTF-8')) . \PHP_EOL; |
||
| 302 | } |
||
| 303 | |||
| 304 | foreach ($columns as $column_id => $column) { |
||
| 305 | // Apply default values for missing parameters |
||
| 306 | if (isset($column['url']) && !isset($column['vars'])) { |
||
| 307 | $column['vars'] = []; |
||
| 308 | } |
||
| 309 | $class = (isset($column['class']) && '' !== $column['class']) ? $column['class'] : ''; |
||
| 310 | |||
| 311 | switch ($column_id) { |
||
| 312 | case 'actions': |
||
| 313 | $tbody_html .= "<td class=\"opbutton{$id} {$class}\">"; |
||
| 314 | |||
| 315 | foreach ($alt_actions as $action) { |
||
| 316 | if (isset($action['disable']) && true === $action['disable']) { |
||
| 317 | continue; |
||
| 318 | } |
||
| 319 | $action['fields'] = $tabledata->fields; |
||
| 320 | $tbody_html .= $this->printLink($action, false, __METHOD__); |
||
| 321 | } |
||
| 322 | $tbody_html .= '</td>' . \PHP_EOL; |
||
| 323 | |||
| 324 | break; |
||
| 325 | case 'comment': |
||
| 326 | $tbody_html .= "<td class='comment_cell'>"; |
||
| 327 | $tbody_html .= \htmlentities(Decorator::get_sanitized_value($column['field'], $tabledata->fields)); |
||
| 328 | $tbody_html .= '</td>'; |
||
| 329 | |||
| 330 | break; |
||
| 331 | default: |
||
| 332 | $tbody_html .= '<td class="' . $class . '">'; |
||
| 333 | $val = Decorator::get_sanitized_value($column['field'], $tabledata->fields); |
||
| 334 | |||
| 335 | if (null !== $val) { |
||
| 336 | if (isset($column['url'])) { |
||
| 337 | $tbody_html .= "<a href=\"{$column['url']}"; |
||
| 338 | $tbody_html .= $this->printUrlVars($column['vars'], $tabledata->fields, false); |
||
| 339 | $tbody_html .= '">'; |
||
| 340 | } |
||
| 341 | $type = $column['type'] ?? null; |
||
| 342 | $params = $column['params'] ?? []; |
||
| 343 | $tbody_html .= $this->misc->printVal($val, $type, $params); |
||
| 344 | |||
| 345 | if (isset($column['url'])) { |
||
| 346 | $tbody_html .= '</a>'; |
||
| 347 | } |
||
| 348 | } |
||
| 349 | |||
| 350 | $tbody_html .= '</td>' . \PHP_EOL; |
||
| 351 | |||
| 352 | break; |
||
| 353 | } |
||
| 354 | } |
||
| 355 | $tbody_html .= '</tr>' . \PHP_EOL; |
||
| 356 | |||
| 357 | $tabledata->moveNext(); |
||
| 358 | ++$i; |
||
| 359 | } |
||
| 360 | |||
| 361 | $tbody_html .= '</tbody>'; |
||
| 362 | |||
| 363 | return $tbody_html; |
||
| 364 | } |
||
| 365 | |||
| 366 | private function getForm() |
||
| 367 | { |
||
| 368 | if (!$this->form) { |
||
| 369 | $this->form = $this->misc->setForm(); |
||
| 370 | } |
||
| 371 | |||
| 372 | return $this->form; |
||
| 373 | } |
||
| 374 | |||
| 375 | private function printUrlVars(&$vars, &$fields, bool $do_print = true) |
||
| 387 | } |
||
| 388 | } |
||
| 389 | } |
||
| 390 |
Loading history...