| <?php |
| |
| require_once('db.php'); |
| require_once('manifest-generator.php'); |
| |
| ?><!DOCTYPE html> |
| <html> |
| <head> |
| <title>WebKit Perf Monitor</title> |
| <link rel="stylesheet" href="/common.css"> |
| <link rel="stylesheet" href="/admin/admin.css"> |
| </head> |
| <body> |
| <header id="title"> |
| <h1><a href="/">WebKit Perf Monitor</a></h1> |
| <ul> |
| <li><a href="/admin/platforms">Platforms</a></li> |
| <li><a href="/admin/tests">Tests</a></li> |
| <li><a href="/admin/aggregators">Aggregators</a></li> |
| <li><a href="/admin/builders">Builders</a></li> |
| <li><a href="/admin/build-slaves">Slaves</a></li> |
| <li><a href="/admin/triggerables">Triggerables</a></li> |
| <li><a href="/admin/repositories">Repositories</a></li> |
| <li><a href="/admin/bug-trackers">Bug Trackers</a></li> |
| <li><a href="/admin/files">Files</a></li> |
| </ul> |
| </header> |
| |
| <div id="mainContents"> |
| <?php |
| |
| function notice($message) { |
| echo "<p class='notice'>$message</p>"; |
| } |
| |
| $db = new Database; |
| if (!$db->connect()) { |
| notice('Failed to connect to the database'); |
| $db = NULL; |
| } else |
| $action = array_key_exists('action', $_POST) ? $_POST['action'] : NULL; |
| |
| function execute_query_and_expect_one_row_to_be_affected($query, $params, $success_message, $failure_message) { |
| global $db; |
| |
| foreach ($params as &$param) { |
| if ($param == '') |
| $param = NULL; |
| } |
| |
| $affected_rows = $db->query_and_get_affected_rows($query, $params); |
| if ($affected_rows) { |
| assert('$affected_rows == 1'); |
| notice($success_message); |
| return true; |
| } |
| |
| notice($failure_message); |
| return false; |
| } |
| |
| function update_field($table, $prefix, $field_name, $new_value = NULL) { |
| global $db; |
| |
| if (!array_key_exists('id', $_POST)) |
| return FALSE; |
| |
| $id = intval($_POST['id']); |
| $prefixed_field_name = $prefix . '_' . $field_name; |
| $id_field_name = $prefix . '_id'; |
| |
| if ($new_value == NULL) { |
| if (array_get($_POST, 'updated-column') != $field_name && !array_key_exists($field_name, $_POST)) |
| return FALSE; |
| $new_value = array_get($_POST, $field_name); |
| } |
| |
| execute_query_and_expect_one_row_to_be_affected("UPDATE $table SET $prefixed_field_name = \$2 WHERE $id_field_name = \$1", |
| array($id, $new_value), |
| "Updated the $prefix $id", |
| "Could not update $prefix $id"); |
| |
| return TRUE; |
| } |
| |
| function update_boolean_field($table, $prefix, $field_name) { |
| return update_field($table, $prefix, $field_name, Database::to_database_boolean(array_get($_POST, $field_name))); |
| } |
| |
| function regenerate_manifest() { |
| global $db; |
| |
| $generator = new ManifestGenerator($db); |
| if (!$generator->generate()) { |
| notice("Failed to generate the manifest (before trying to write into the filesystem)."); |
| return FALSE; |
| } |
| |
| if (!$generator->store()) { |
| notice("Failed to save the generated manifest into the filesystem"); |
| return FALSE; |
| } |
| |
| return TRUE; |
| } |
| |
| class AdministrativePage { |
| private $table; |
| private $prefix; |
| private $column_to_be_ordered_by; |
| private $column_info; |
| |
| function __construct($db, $table, $prefix, $column_info) { |
| $this->db = $db; |
| $this->table = $table; |
| $this->prefix = $prefix; |
| $this->column_info = $column_info; |
| } |
| |
| private function name_to_titlecase($name) { |
| return ucwords(str_replace('_', ' ', $name)); |
| } |
| |
| private function column_label($name) { |
| return array_get($this->column_info[$name], 'label', $this->name_to_titlecase($name)); |
| } |
| |
| private function render_form_control_for_column($editing_mode, $name, $value = '', $show_update_button_if_needed = FALSE) { |
| $show_update_button = FALSE; |
| switch ($editing_mode) { |
| case 'text': |
| echo <<< END |
| <textarea name="$name" rows="7" cols="50">$value</textarea><br> |
| END; |
| $show_update_button = $show_update_button_if_needed; |
| break; |
| case 'boolean': |
| $checkedness = Database::is_true($value) ? ' checked' : ''; |
| echo <<< END |
| <input type="checkbox" name="$name"$checkedness> |
| END; |
| $show_update_button = $show_update_button_if_needed; |
| break; |
| case 'url': |
| echo <<< END |
| <input type="text" name="$name" value="$value" size="70"> |
| END; |
| break; |
| default: |
| assert($editing_mode == 'string'); |
| echo <<< END |
| <input type="text" name="$name" value="$value"> |
| END; |
| } |
| |
| if ($show_update_button) { |
| echo <<< END |
| |
| <button type="submit" name="action" value="update">Update</button> |
| END; |
| } |
| } |
| |
| function render_table($column_to_be_ordered_by) { |
| $column_names = array_keys($this->column_info); |
| $column_to_subcolumn_names = array(); |
| foreach ($column_names as $name) { |
| if (array_get($this->column_info[$name], 'pre_insertion')) |
| continue; |
| $subcolumns = array_get($this->column_info[$name], 'subcolumns', array()); |
| if (!$subcolumns || !array_get($this->column_info[$name], 'custom')) |
| continue; |
| $column_to_subcolumn_names[$name] = $subcolumns; |
| } |
| |
| $rowspan_if_needed = $column_to_subcolumn_names ? ' rowspan="2"' : ''; |
| |
| $headers = "<tr><td$rowspan_if_needed>ID</td>"; |
| foreach ($column_names as $name) { |
| if (array_get($this->column_info[$name], 'pre_insertion')) |
| continue; |
| $label = htmlspecialchars($this->column_label($name)); |
| if (array_get($column_to_subcolumn_names, $name)) { |
| $count = count($column_to_subcolumn_names[$name]); |
| $headers .= "<td colspan=\"$count\">$label</td>"; |
| } else |
| $headers .= "<td$rowspan_if_needed>$label</td>"; |
| } |
| $headers .= "</tr>\n"; |
| |
| if ($column_to_subcolumn_names) { |
| $headers .= '<tr>'; |
| foreach ($column_names as $name) { |
| $subcolumn_names = array_get($column_to_subcolumn_names, $name); |
| if (!$subcolumn_names) |
| continue; |
| foreach ($subcolumn_names as $label) |
| $headers .= '<td>' . htmlspecialchars($label) . '</td>'; |
| } |
| $headers .= "</tr>\n"; |
| } |
| |
| echo <<< END |
| <table> |
| <thead> |
| $headers |
| </thead> |
| <tbody> |
| |
| END; |
| |
| assert(ctype_alnum_underscore($column_to_be_ordered_by)); |
| $rows = $this->db->fetch_table($this->table, $this->prefix . '_' . $column_to_be_ordered_by); |
| if ($rows) { |
| foreach ($rows as $row) { |
| $id = intval($row[$this->prefix . '_id']); |
| |
| $custom_cells_list = array(); |
| $maximum_rows = 1; |
| foreach ($column_names as $name) { |
| if (array_get($this->column_info[$name], 'pre_insertion')) |
| continue; |
| |
| if ($custom = array_get($this->column_info[$name], 'custom')) { |
| $custom_cells_list[$name] = $custom($row); |
| $maximum_rows = max($maximum_rows, count($custom_cells_list[$name])); |
| } |
| } |
| |
| $rowspan_if_needed = $maximum_rows > 1 ? ' rowspan="' . $maximum_rows . '"' : ''; |
| |
| echo "<tr>\n<td$rowspan_if_needed>$id</td>\n"; |
| foreach ($column_names as $name) { |
| if (array_get($this->column_info[$name], 'pre_insertion')) |
| continue; |
| |
| if (array_key_exists($name, $custom_cells_list)) { |
| $this->render_custom_cells(array_get($column_to_subcolumn_names, $name), $custom_cells_list[$name], 0); |
| continue; |
| } |
| |
| $value = htmlspecialchars(array_get($row, $this->prefix . '_' . $name), ENT_QUOTES); |
| $editing_mode = array_get($this->column_info[$name], 'editing_mode'); |
| if (!$editing_mode) { |
| echo "<td$rowspan_if_needed>$value</td>\n"; |
| continue; |
| } |
| |
| echo <<< END |
| <td$rowspan_if_needed> |
| <form method="POST"> |
| <input type="hidden" name="id" value="$id"> |
| <input type="hidden" name="action" value="update"> |
| <input type="hidden" name="updated-column" value="$name"> |
| |
| END; |
| $this->render_form_control_for_column($editing_mode, $name, $value, TRUE); |
| echo "</form></td>\n"; |
| |
| } |
| echo "</tr>\n"; |
| |
| for ($row = 1; $row < $maximum_rows; $row++) { |
| echo "<tr>\n"; |
| foreach ($column_names as $name) { |
| if (array_key_exists($name, $custom_cells_list)) |
| $this->render_custom_cells(array_get($column_to_subcolumn_names, $name), $custom_cells_list[$name], $row); |
| } |
| echo "</tr>\n"; |
| } |
| } |
| } |
| echo <<< END |
| </tbody> |
| </table> |
| END; |
| } |
| |
| function render_custom_cells($subcolum_names, $rows, $row_index) { |
| $cells = array_get($rows, $row_index, array()); |
| if (!is_array($cells)) |
| $cells = array($cells); |
| |
| if ($subcolum_names && count($cells) <= 1) { |
| $colspan = count($subcolum_names); |
| $content = $cells ? $cells[0] : ''; |
| echo "<td colspan=\"$colspan\">$content</td>\n"; |
| return; |
| } |
| |
| for ($i = 0; $i < ($subcolum_names ? count($subcolum_names) : 1); $i++) |
| echo '<td>' . array_get($cells, $i, '') . '</td>'; |
| echo "\n"; |
| } |
| |
| function render_form_to_add($title = NULL) { |
| |
| if (!$title) # Can't use the table name since it needs to be singular. |
| $title = 'New ' . $this->name_to_titlecase($this->prefix); |
| |
| echo <<< END |
| <section class="action-field"> |
| <h2>$title</h2> |
| <form method="POST"> |
| |
| END; |
| foreach (array_keys($this->column_info) as $name) { |
| $editing_mode = array_get($this->column_info[$name], 'editing_mode'); |
| if (array_get($this->column_info[$name], 'custom') || !$editing_mode) |
| continue; |
| if (array_get($this->column_info[$name], 'post_insertion')) |
| continue; |
| |
| $label = htmlspecialchars($this->column_label($name)); |
| echo "<label>$label<br>\n"; |
| $this->render_form_control_for_column($editing_mode, $name); |
| echo "</label><br>\n"; |
| } |
| |
| echo <<< END |
| |
| <button type="submit" name="action" value="add">Add</button> |
| </form> |
| </section> |
| END; |
| |
| } |
| |
| } |
| |
| ?> |
