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

---
 .../templates/server/status/queries/index.twig     | 56 ++++++++++++++++++++++
 1 file changed, 56 insertions(+)
 create mode 100644 srcs/phpmyadmin/templates/server/status/queries/index.twig

(limited to 'srcs/phpmyadmin/templates/server/status/queries/index.twig')

diff --git a/srcs/phpmyadmin/templates/server/status/queries/index.twig b/srcs/phpmyadmin/templates/server/status/queries/index.twig
new file mode 100644
index 0000000..be743b9
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/status/queries/index.twig
@@ -0,0 +1,56 @@
+{% extends 'server/status/base.twig' %}
+{% set active = 'queries' %}
+{% block content %}
+
+{% if is_data_loaded %}
+  <h3 id="serverstatusqueries">
+    {% trans %}
+      Questions since startup:
+    {% notes %}
+      Questions is the name of a MySQL Status variable
+    {% endtrans %}
+    {{ format_number(stats.total, 0) }}
+    {{ show_mysql_docu('server-status-variables', false, null, null, 'statvar_Questions') }}
+  </h3>
+
+  <ul>
+    <li>ø {% trans 'per hour:' %} {{ format_number(stats.per_hour, 0) }}</li>
+    <li>ø {% trans 'per minute:' %} {{ format_number(stats.per_minute, 0) }}</li>
+    {% if stats.per_second >= 1 %}
+      <li>ø {% trans 'per second:' %} {{ format_number(stats.per_second, 0) }}</li>
+    {% endif %}
+  </ul>
+
+  <table id="serverstatusqueriesdetails" class="width100 data sortable noclick">
+    <colgroup>
+      <col class="namecol">
+      <col class="valuecol" span="3">
+    </colgroup>
+
+    <thead>
+      <tr>
+        <th>{% trans 'Statements' %}</th>
+        <th>{% trans %}#{% notes %}# = Amount of queries{% endtrans %}</th>
+        <th>ø {% trans 'per hour' %}</th>
+        <th>%</th>
+      </tr>
+    </thead>
+
+    <tbody>
+      {% for query in queries %}
+        <tr>
+          <th class="name">{{ query.name }}</th>
+          <td class="value">{{ format_number(query.value, 5, 0, true) }}</td>
+          <td class="value">{{ format_number(query.per_hour, 4, 1, true) }}</td>
+          <td class="value">{{ format_number(query.percentage, 0, 2) }}</td>
+        </tr>
+      {% endfor %}
+    </tbody>
+  </table>
+
+  <div id="serverstatusquerieschart" class="width100" data-chart="{{ chart|json_encode }}"></div>
+{% else %}
+  {{ 'Not enough privilege to view query statistics.'|trans|error }}
+{% endif %}
+
+{% endblock %}
-- 
cgit