From 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa Mon Sep 17 00:00:00 2001
From: Charles <sircharlesaze@gmail.com>
Date: Thu, 9 Jan 2020 10:55:03 +0100
Subject: phpmyadmin working

---
 srcs/phpmyadmin/templates/sql/bookmark.twig        | 31 +++++++
 srcs/phpmyadmin/templates/sql/detailed_table.twig  |  8 ++
 .../templates/sql/enum_column_dropdown.twig        |  6 ++
 srcs/phpmyadmin/templates/sql/profiling_chart.twig | 97 ++++++++++++++++++++++
 .../templates/sql/relational_column_dropdown.twig  |  4 +
 srcs/phpmyadmin/templates/sql/set_column.twig      |  5 ++
 .../templates/sql/sql_query_results.twig           | 10 +++
 7 files changed, 161 insertions(+)
 create mode 100644 srcs/phpmyadmin/templates/sql/bookmark.twig
 create mode 100644 srcs/phpmyadmin/templates/sql/detailed_table.twig
 create mode 100644 srcs/phpmyadmin/templates/sql/enum_column_dropdown.twig
 create mode 100644 srcs/phpmyadmin/templates/sql/profiling_chart.twig
 create mode 100644 srcs/phpmyadmin/templates/sql/relational_column_dropdown.twig
 create mode 100644 srcs/phpmyadmin/templates/sql/set_column.twig
 create mode 100644 srcs/phpmyadmin/templates/sql/sql_query_results.twig

(limited to 'srcs/phpmyadmin/templates/sql')

diff --git a/srcs/phpmyadmin/templates/sql/bookmark.twig b/srcs/phpmyadmin/templates/sql/bookmark.twig
new file mode 100644
index 0000000..71abc3d
--- /dev/null
+++ b/srcs/phpmyadmin/templates/sql/bookmark.twig
@@ -0,0 +1,31 @@
+<form action="sql.php" method="post" class="bookmarkQueryForm print_ignore"
+    onsubmit="return ! Functions.emptyCheckTheField(this, 'bkm_fields[bkm_label]');">
+    {{ get_hidden_inputs() }}
+    <input type="hidden" name="db" value="{{ db }}">
+    <input type="hidden" name="goto" value="{{ goto }}">
+    <input type="hidden" name="bkm_fields[bkm_database]" value="{{ db }}">
+    <input type="hidden" name="bkm_fields[bkm_user]" value="{{ user }}">
+    <input type="hidden" name="bkm_fields[bkm_sql_query]" value="{{ sql_query }}">
+    <fieldset>
+        <legend>
+            {{ get_icon('b_bookmark', 'Bookmark this SQL query'|trans, true) }}
+        </legend>
+        <div class="formelement">
+            <label>
+                {% trans 'Label:' %}
+                <input type="text" name="bkm_fields[bkm_label]" value="">
+            </label>
+        </div>
+        <div class="formelement">
+            <label>
+                <input type="checkbox" name="bkm_all_users" value="true">
+                {% trans 'Let every user access this bookmark' %}
+            </label>
+        </div>
+        <div class="clearfloat"></div>
+    </fieldset>
+    <fieldset class="tblFooters">
+        <input type="hidden" name="store_bkm" value="1">
+        <input class="btn btn-secondary" type="submit" value="{% trans 'Bookmark this SQL query' %}">
+    </fieldset>
+</form>
diff --git a/srcs/phpmyadmin/templates/sql/detailed_table.twig b/srcs/phpmyadmin/templates/sql/detailed_table.twig
new file mode 100644
index 0000000..4d8fe9c
--- /dev/null
+++ b/srcs/phpmyadmin/templates/sql/detailed_table.twig
@@ -0,0 +1,8 @@
+<tr>
+  <td>{{ index }}</td>
+  <td>{{ status|title }}</td>
+  <td class="right">
+    {{ format_number(duration, 3, 1) }}s
+    <span class="rawvalue hide">{{ duration }}</span>
+  </td>
+</tr>
diff --git a/srcs/phpmyadmin/templates/sql/enum_column_dropdown.twig b/srcs/phpmyadmin/templates/sql/enum_column_dropdown.twig
new file mode 100644
index 0000000..f8be9a8
--- /dev/null
+++ b/srcs/phpmyadmin/templates/sql/enum_column_dropdown.twig
@@ -0,0 +1,6 @@
+<select>
+  <option value="">&nbsp;</option>
+  {% for value in values %}
+    <option value="{{ value }}"{{ value in selected_values ? " selected" }}>{{ value }}</option>
+  {% endfor %}
+</select>
diff --git a/srcs/phpmyadmin/templates/sql/profiling_chart.twig b/srcs/phpmyadmin/templates/sql/profiling_chart.twig
new file mode 100644
index 0000000..0f80954
--- /dev/null
+++ b/srcs/phpmyadmin/templates/sql/profiling_chart.twig
@@ -0,0 +1,97 @@
+<fieldset>
+  <legend>{% trans 'Profiling' %}</legend>
+  <div class="floatleft">
+    <h3>{% trans 'Detailed profile' %}</h3>
+    <table id="profiletable">
+      <thead>
+      <tr>
+        <th>
+          {% trans 'Order' %}
+          <div class="sorticon"></div>
+        </th>
+        <th>
+          {% trans 'State' %}
+          {{ show_mysql_docu('general-thread-states') }}
+          <div class="sorticon"></div>
+        </th>
+        <th>
+          {% trans 'Time' %}
+          <div class="sorticon"></div>
+        </th>
+      </tr>
+      </thead>
+      <tbody>
+        {{ detailed_table|raw }}
+      </tbody>
+    </table>
+  </div>
+
+  <div class="floatleft">
+    <h3>{% trans 'Summary by state' %}</h3>
+    <table id="profilesummarytable">
+      <thead>
+      <tr>
+        <th>
+          {% trans 'State' %}
+          {{ show_mysql_docu('general-thread-states') }}
+          <div class="sorticon"></div>
+        </th>
+        <th>
+          {% trans 'Total Time' %}
+          <div class="sorticon"></div>
+        </th>
+        <th>
+          {% trans '% Time' %}
+          <div class="sorticon"></div>
+        </th>
+        <th>
+          {% trans 'Calls' %}
+          <div class="sorticon"></div>
+        </th>
+        <th>
+          {% trans 'ø Time' %}
+          <div class="sorticon"></div>
+        </th>
+      </tr>
+      </thead>
+      <tbody>
+        {% for name, stats in states %}
+          <tr>
+            <td>{{ name }}</td>
+            <td align="right">
+              {{ format_number(stats['total_time'], 3, 1) }}s
+              <span class="rawvalue hide">{{ stats['total_time'] }}</span>
+            </td>
+            <td align="right">
+              {{ format_number(100 * (stats['total_time'] / total_time), 0, 2) }}%
+            </td>
+            <td align="right">{{ stats['calls'] }}</td>
+            <td align="right">
+              {{ format_number(stats['total_time'] / stats['calls'], 3, 1) }}s
+              <span class="rawvalue hide">
+                {{ (stats['total_time'] / stats['calls'])|number_format(8, '.', '') }}
+              </span>
+            </td>
+          </tr>
+        {% endfor %}
+      </tbody>
+    </table>
+
+    <script type="text/javascript">
+      url_query = '{{ url_query }}';
+    </script>
+  </div>
+  <div class='clearfloat'></div>
+
+  <div id="profilingChartData" class="hide">
+    {{ chart_json|json_encode() }}
+  </div>
+  <div id="profilingchart" class="hide"></div>
+
+  <script type="text/javascript">
+    AJAX.registerOnload('sql.js', function () {
+      Sql.makeProfilingChart();
+      Sql.initProfilingTables();
+    });
+  </script>
+</fieldset>
diff --git a/srcs/phpmyadmin/templates/sql/relational_column_dropdown.twig b/srcs/phpmyadmin/templates/sql/relational_column_dropdown.twig
new file mode 100644
index 0000000..6a2aaff
--- /dev/null
+++ b/srcs/phpmyadmin/templates/sql/relational_column_dropdown.twig
@@ -0,0 +1,4 @@
+<span class="curr_value">{{ current_value }}</span>
+<a href="browse_foreigners.php" data-post="{{ get_common(params, '') }}">
+  {% trans 'Browse foreign values' %}
+</a>
diff --git a/srcs/phpmyadmin/templates/sql/set_column.twig b/srcs/phpmyadmin/templates/sql/set_column.twig
new file mode 100644
index 0000000..989812e
--- /dev/null
+++ b/srcs/phpmyadmin/templates/sql/set_column.twig
@@ -0,0 +1,5 @@
+<select size="{{ size }}" multiple>
+  {% for value in values %}
+    <option value="{{ value }}"{{ value in selected_values ? " selected" }}>{{ value }}</option>
+  {% endfor %}
+</select>
diff --git a/srcs/phpmyadmin/templates/sql/sql_query_results.twig b/srcs/phpmyadmin/templates/sql/sql_query_results.twig
new file mode 100644
index 0000000..d9f2c3b
--- /dev/null
+++ b/srcs/phpmyadmin/templates/sql/sql_query_results.twig
@@ -0,0 +1,10 @@
+{{ table_maintenance|raw }}
+<div class="sqlqueryresults ajax">
+    {{ previous_update_query|raw }}
+    {{ profiling_chart|raw }}
+    {{ missing_unique_column_message|raw }}
+    {{ bookmark_created_message|raw }}
+    {{ table|raw }}
+    {{ indexes_problems|raw }}
+    {{ bookmark_support|raw }}
+</div>
-- 
cgit