phpmyadmin working

12 files changed, 294 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/templates/display/results/comment_for_row.twig b/srcs/phpmyadmin/templates/display/results/comment_for_row.twig
new file mode 100644
index 0000000..f232375
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/comment_for_row.twig
@@ -0,0 +1,10 @@
+{% if comments_map[fields_meta.table] is defined
+    and comments_map[fields_meta.table][fields_meta.name] is defined %}
+    <br><span class="tblcomment" title="{{ comments_map[fields_meta.table][fields_meta.name] }}">
+        {% if comments_map[fields_meta.table][fields_meta.name]|length > limit_chars %}
+            {{ comments_map[fields_meta.table][fields_meta.name]|slice(0, limit_chars) }}…
+        {% else %}
+            {{ comments_map[fields_meta.table][fields_meta.name] }}
+        {% endif %}
+    </span>
+{% endif %}
diff --git a/srcs/phpmyadmin/templates/display/results/data_for_resetting_column_order.twig b/srcs/phpmyadmin/templates/display/results/data_for_resetting_column_order.twig
new file mode 100644
index 0000000..6a345e7
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/data_for_resetting_column_order.twig
@@ -0,0 +1,9 @@
+{% if column_order %}
+  <input class="col_order" type="hidden" value="{{ column_order|join(',') }}">
+{% endif %}
+{% if column_visibility %}
+  <input class="col_visib" type="hidden" value="{{ column_visibility|join(',') }}">
+{% endif %}
+{% if not is_view %}
+  <input class="table_create_time" type="hidden" value="{{ table_create_time }}">
+{% endif %}
diff --git a/srcs/phpmyadmin/templates/display/results/empty_display.twig b/srcs/phpmyadmin/templates/display/results/empty_display.twig
new file mode 100644
index 0000000..cd43ebc
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/empty_display.twig
@@ -0,0 +1 @@
+<td {{ align }} class="{{ classes }}"></td>
diff --git a/srcs/phpmyadmin/templates/display/results/null_display.twig b/srcs/phpmyadmin/templates/display/results/null_display.twig
new file mode 100644
index 0000000..f2ea2e5
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/null_display.twig
@@ -0,0 +1,7 @@
+<td {{ align }}
+    data-decimals="{{ meta.decimals is defined ? meta.decimals : '-1' }}"
+    data-type="{{ meta.type }}"
+    {# The null class is needed for grid editing #}
+    class="{{ classes }} null">
+    <em>NULL</em>
+</td>
diff --git a/srcs/phpmyadmin/templates/display/results/options_block.twig b/srcs/phpmyadmin/templates/display/results/options_block.twig
new file mode 100644
index 0000000..d185fec
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/options_block.twig
@@ -0,0 +1,121 @@
+<form method="post" action="sql.php" name="displayOptionsForm" class="ajax print_ignore">
+    {{ get_hidden_inputs({
+        'db': db,
+        'table': table,
+        'sql_query': sql_query,
+        'goto': goto,
+        'display_options_form': 1
+    }) }}
+
+    {% include 'div_for_slider_effect.twig' with {
+        'id': '',
+        'message': 'Options'|trans,
+        'initial_sliders_state': default_sliders_state
+    } only %}
+        <fieldset>
+            <div class="formelement">
+                {# pftext means "partial or full texts" (done to reduce line lengths #}
+                {{ get_radio_fields(
+                    'pftext',
+                    {
+                        'P': 'Partial texts'|trans,
+                        'F': 'Full texts'|trans
+                    },
+                    pftext,
+                    true,
+                    true,
+                    '',
+                    'pftext_' ~ unique_id
+                ) }}
+            </div>
+
+            {% if relwork and displaywork %}
+                <div class="formelement">
+                    {{ get_radio_fields(
+                        'relational_display',
+                        {
+                            'K': 'Relational key'|trans,
+                            'D': 'Display column for relationships'|trans
+                        },
+                        relational_display,
+                        true,
+                        true,
+                        '',
+                        'relational_display_' ~ unique_id
+                    ) }}
+                </div>
+            {% endif %}
+
+            <div class="formelement">
+                {% include 'checkbox.twig' with {
+                    'html_field_name': 'display_binary',
+                    'label': 'Show binary contents'|trans,
+                    'checked': display_binary is not empty,
+                    'onclick': false,
+                    'html_field_id': 'display_binary_' ~ unique_id
+                } only %}
+                {% include 'checkbox.twig' with {
+                    'html_field_name': 'display_blob',
+                    'label': 'Show BLOB contents'|trans,
+                    'checked': display_blob is not empty,
+                    'onclick': false,
+                    'html_field_id': 'display_blob_' ~ unique_id
+                } only %}
+            </div>
+
+            {# I would have preferred to name this "display_transformation".
+               This is the only way I found to be able to keep this setting sticky
+               per SQL query, and at the same time have a default that displays
+               the transformations. #}
+            <div class="formelement">
+                {% include 'checkbox.twig' with {
+                    'html_field_name': 'hide_transformation',
+                    'label': 'Hide browser transformation'|trans,
+                    'checked': hide_transformation is not empty,
+                    'onclick': false,
+                    'html_field_id': 'hide_transformation_' ~ unique_id
+                } only %}
+            </div>
+
+
+            {% if possible_as_geometry %}
+                <div class="formelement">
+                    {{ get_radio_fields(
+                        'geoOption',
+                        {
+                            'GEOM': 'Geometry'|trans,
+                            'WKT': 'Well Known Text'|trans,
+                            'WKB': 'Well Known Binary'|trans
+                        },
+                        geo_option,
+                        true,
+                        true,
+                        '',
+                        'geoOption_' ~ unique_id
+                    ) }}
+                </div>
+            {% else %}
+                <div class="formelement">
+                    {{ possible_as_geometry }}
+                    {{ get_radio_fields(
+                        'geoOption',
+                        {
+                            'WKT': 'Well Known Text'|trans,
+                            'WKB': 'Well Known Binary'|trans
+                        },
+                        geo_option,
+                        true,
+                        true,
+                        '',
+                        'geoOption_' ~ unique_id
+                    ) }}
+                </div>
+            {% endif %}
+            <div class="clearfloat"></div>
+        </fieldset>
+
+        <fieldset class="tblFooters">
+            <input class="btn btn-primary" type="submit" value="{% trans 'Go' %}">
+        </fieldset>
+    </div>{# slider effect div #}
+</form>
diff --git a/srcs/phpmyadmin/templates/display/results/page_selector.twig b/srcs/phpmyadmin/templates/display/results/page_selector.twig
new file mode 100644
index 0000000..1791270
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/page_selector.twig
@@ -0,0 +1,6 @@
+<td>
+  <form action="sql.php" method="post">
+    {{ get_hidden_inputs(url_params) }}
+    {{ page_selector|raw }}
+  </form>
+</td>
diff --git a/srcs/phpmyadmin/templates/display/results/sort_by_key.twig b/srcs/phpmyadmin/templates/display/results/sort_by_key.twig
new file mode 100644
index 0000000..fb26f10
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/sort_by_key.twig
@@ -0,0 +1,9 @@
+<form action="sql.php" method="post" class="print_ignore">
+  {{ get_hidden_fields(hidden_fields) }}
+  {% trans 'Sort by key:' %}
+  <select name="sql_query" class="autosubmit">
+    {% for option in options %}
+      <option value="{{ option.value }}"{{ option.is_selected ? ' selected' }}>{{ option.content }}</option>
+    {% endfor %}
+  </select>
+</form>
diff --git a/srcs/phpmyadmin/templates/display/results/table.twig b/srcs/phpmyadmin/templates/display/results/table.twig
new file mode 100644
index 0000000..760ca1c
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/table.twig
@@ -0,0 +1,11 @@
+{{ sql_query_message|raw }}
+{{ navigation|raw }}
+{{ headers|raw }}
+<tbody>
+    {{ body|raw }}
+</tbody>
+</table>
+</div>
+{{ multi_row_operation_links|raw }}
+{{ navigation|raw }}
+{{ operations|raw }}
diff --git a/srcs/phpmyadmin/templates/display/results/table_headers.twig b/srcs/phpmyadmin/templates/display/results/table_headers.twig
new file mode 100644
index 0000000..506a6c0
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/table_headers.twig
@@ -0,0 +1,23 @@
+<input class="save_cells_at_once" type="hidden" value="{{ save_cells_at_once }}">
+<div class="common_hidden_inputs">
+  {{ get_hidden_inputs(db, table) }}
+</div>
+
+{{ data_for_resetting_column_order|raw }}
+{{ options_block|raw }}
+
+{% if delete_link == delete_row or delete_link == kill_process %}
+  <form method="post" action="tbl_row_action.php" name="resultsForm" id="resultsForm_{{ unique_id }}" class="ajax">
+    {{ get_hidden_inputs(db, table, 1) }}
+    <input type="hidden" name="goto" value="sql.php">
+{% endif %}
+
+<div class="responsivetable">
+  <table class="table_results data ajax" data-uniqueId="{{ unique_id }}">
+
+    {{ button|raw }}
+    {{ table_headers_for_columns|raw }}
+    {{ column_at_right_side|raw }}
+
+      </tr>
+    </thead>
diff --git a/srcs/phpmyadmin/templates/display/results/table_navigation.twig b/srcs/phpmyadmin/templates/display/results/table_navigation.twig
new file mode 100644
index 0000000..0746243
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/table_navigation.twig
@@ -0,0 +1,82 @@
+<table class="navigation nospacing nopadding print_ignore">
+  <tr>
+    <td class="navigation_separator"></td>
+    {{ move_backward_buttons|raw }}
+    {{ page_selector|raw }}
+    {{ move_forward_buttons|raw }}
+    {% if number_total_page > 1 %}
+      <td><div class="navigation_separator">|</div></td>
+    {% endif %}
+    {% if has_show_all %}
+      <td>
+        <form action="sql.php" method="post">
+          {{ get_hidden_fields(hidden_fields|merge({
+            'session_max_rows': session_max_rows,
+            'pos': '0'
+          })) }}
+          <input type="checkbox" name="navig" id="showAll_{{ unique_id }}" class="showAllRows" value="all"
+            {{- is_showing_all ? ' checked' }}>
+          <label for="showAll_{{ unique_id }}">{% trans 'Show all' %}</label>
+        </form>
+      </td>
+      <td><div class="navigation_separator">|</div></td>
+    {% endif %}
+    <td>
+      <div class="save_edited hide">
+        <input class="btn btn-link" type="submit" value="{% trans 'Save edited data' %}">
+        <div class="navigation_separator">|</div>
+      </div>
+    </td>
+    <td>
+      <div class="restore_column hide">
+        <input class="btn btn-link" type="submit" value="{% trans 'Restore column order' %}">
+        <div class="navigation_separator">|</div>
+      </div>
+    </td>
+    <td class="navigation_goto">
+      {# if displaying a VIEW, $unlim_num_rows could be zero because #}
+      {# of $cfg['MaxExactCountViews']; in this case, avoid passing #}
+      {# the 5th parameter to Functions.checkFormElementInRange() #}
+      {# (this means we can't validate the upper limit) #}
+      <form action="sql.php" method="post" onsubmit="return (Functions.checkFormElementInRange(this, 'session_max_rows', '
+        {{- '%d is not valid row number.'|trans|replace({'\'': '\\\''}) -}}
+        ', 1) && Functions.checkFormElementInRange(this, 'pos', '
+        {{- '%d is not valid row number.'|trans|replace({'\'': '\\\''}) -}}
+        ', 0
+        {{- unlim_num_rows > 0 ? ', ' ~ (unlim_num_rows - 1) -}}
+        ));">
+
+        {{ get_hidden_fields(hidden_fields|merge({
+          'pos': pos
+        })) }}
+
+        {% trans 'Number of rows:' %}
+
+        {{ get_dropdown(
+          'session_max_rows',
+          {
+            '25': 25,
+            '50': 50,
+            '100': 100,
+            '250': 250,
+            '500': 500,
+          },
+          max_rows,
+          '',
+          'autosubmit',
+          is_showing_all ? 'All'|trans
+        ) }}
+      </form>
+    </td>
+    <td class="navigation_separator"></td>
+    <td class="largescreenonly">
+      <span>{% trans 'Filter rows' %}:</span>
+      <input type="text" class="filter_rows" placeholder="
+        {%- trans 'Search this table' %}" data-for="{{ unique_id }}">
+    </td>
+    <td class="largescreenonly">
+      {{ sort_by_key|raw }}
+    </td>
+    <td class="navigation_separator"></td>
+  </tr>
+</table>
diff --git a/srcs/phpmyadmin/templates/display/results/table_navigation_button.twig b/srcs/phpmyadmin/templates/display/results/table_navigation_button.twig
new file mode 100644
index 0000000..2573c0c
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/table_navigation_button.twig
@@ -0,0 +1,12 @@
+<td>
+    <form action="sql.php" method="post"{{ onsubmit|raw }}>
+        {{ get_hidden_inputs(db, table) }}
+        <input type="hidden" name="sql_query" value="{{ sql_query|raw }}">
+        <input type="hidden" name="pos" value="{{ pos }}">
+        <input type="hidden" name="is_browse_distinct" value="{{ is_browse_distinct }}">
+        <input type="hidden" name="goto" value="{{ goto }}">
+        {{ input_for_real_end|raw }}
+        <input type="submit" name="navig" class="btn btn-secondary ajax" value="{{ caption_output|raw }}" title="{{ title }}"
+            {{- onclick|raw }}>
+    </form>
+</td>
diff --git a/srcs/phpmyadmin/templates/display/results/value_display.twig b/srcs/phpmyadmin/templates/display/results/value_display.twig
new file mode 100644
index 0000000..35640b9
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/results/value_display.twig
@@ -0,0 +1,3 @@
+<td class="left {{ class }}{{ condition_field ? ' condition' }}">
+    {{ value|raw }}
+</td>