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

---
 .../table/structure/display_table_stats.twig       | 169 +++++++++++++++++++++
 1 file changed, 169 insertions(+)
 create mode 100644 srcs/phpmyadmin/templates/table/structure/display_table_stats.twig

(limited to 'srcs/phpmyadmin/templates/table/structure/display_table_stats.twig')

diff --git a/srcs/phpmyadmin/templates/table/structure/display_table_stats.twig b/srcs/phpmyadmin/templates/table/structure/display_table_stats.twig
new file mode 100644
index 0000000..01c74ae
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/structure/display_table_stats.twig
@@ -0,0 +1,169 @@
+<div id="tablestatistics">
+    <fieldset>
+        <legend>{% trans 'Information' %}</legend>
+        {% if showtable['TABLE_COMMENT'] %}
+            <p>
+                <strong>{% trans 'Table comments:' %}</strong>
+                {{ showtable['TABLE_COMMENT'] }}
+            </p>
+        {% endif %}
+        <a id="showusage"></a>
+
+        {% if not tbl_is_view and not db_is_system_schema %}
+            <table id="tablespaceusage" class="width100 data">
+                <caption class="tblHeaders">{% trans 'Space usage' %}</caption>
+                <tbody>
+                    <tr>
+                        <th class="name">{% trans 'Data' %}</th>
+                        <td class="value">{{ data_size }}</td>
+                        <td class="unit">{{ data_unit }}</td>
+                    </tr>
+
+                {% if index_size is defined %}
+                    <tr>
+                        <th class="name">{% trans 'Index' %}</th>
+                        <td class="value">{{ index_size }}</td>
+                        <td class="unit">{{ index_unit }}</td>
+                    </tr>
+                {% endif %}
+
+                {% if free_size is defined %}
+                    <tr>
+                        <th class="name">{% trans 'Overhead' %}</th>
+                        <td class="value">{{ free_size }}</td>
+                        <td class="unit">{{ free_unit }}</td>
+                    </tr>
+                    <tr>
+                        <th class="name">{% trans 'Effective' %}</th>
+                        <td class="value">{{ effect_size }}</td>
+                        <td class="unit">{{ effect_unit }}</td>
+                    </tr>
+                {% endif %}
+
+                {% if tot_size is defined and mergetable == false %}
+                    <tr>
+                        <th class="name">{% trans 'Total' %}</th>
+                        <td class="value">{{ tot_size }}</td>
+                        <td class="unit">{{ tot_unit }}</td>
+                    </tr>
+                {% endif %}
+
+                {# Optimize link if overhead #}
+                {% if free_size is defined
+                    and (tbl_storage_engine == 'MYISAM'
+                    or tbl_storage_engine == 'ARIA'
+                    or tbl_storage_engine == 'MARIA'
+                    or tbl_storage_engine == 'BDB')
+                    or (tbl_storage_engine == 'INNODB' and innodb_file_per_table == true) %}
+                    <tr class="tblFooters print_ignore">
+                        <td colspan="3" class="center">
+                            <a href="sql.php" data-post="{{ url_query }}&amp;pos=0&amp;sql_query=
+                                {{- ('OPTIMIZE TABLE ' ~ backquote(table))|url_encode }}">
+                                {{ get_icon('b_tbloptimize', 'Optimize table'|trans) }}
+                            </a>
+                        </td>
+                    </tr>
+                {% endif %}
+                </tbody>
+            </table>
+        {% endif %}
+
+        {% set avg_size = avg_size is defined ? avg_size : null %}
+        {% set avg_unit = avg_unit is defined ? avg_unit : null %}
+        <table id="tablerowstats" class="width100 data">
+            <caption class="tblHeaders">{% trans 'Row statistics' %}</caption>
+            <tbody>
+                {% if showtable['Row_format'] is defined %}
+                    <tr>
+                    <th class="name">{% trans 'Format' %}</th>
+                    {% if showtable['Row_format'] == 'Fixed' %}
+                        <td class="value">{% trans 'static' %}</td>
+                    {% elseif showtable['Row_format'] == 'Dynamic' %}
+                        <td class="value">{% trans 'dynamic' %}</td>
+                    {% else %}
+                        <td class="value">{{ showtable['Row_format'] }}</td>
+                    {% endif %}
+                    </tr>
+                {% endif %}
+
+                {% if showtable['Create_options'] is not empty %}
+                    <tr>
+                    <th class="name">{% trans 'Options' %}</th>
+                    {% if showtable['Create_options'] == 'partitioned' %}
+                        <td class="value">{% trans 'partitioned' %}</td>
+                    {% else %}
+                        <td class="value">{{ showtable['Create_options'] }}</td>
+                    {% endif %}
+                    </tr>
+                {% endif %}
+
+                {% if table_collation is not empty %}
+                    <tr>
+                    <th class="name">{% trans 'Collation' %}</th>
+                    <td class="value">
+                        <dfn title="{{ table_collation.description }}">
+                            {{ table_collation.name }}
+                        </dfn>
+                    </td>
+                    </tr>
+                {% endif %}
+
+                {% if not is_innodb and showtable['Rows'] is defined %}
+                    <tr>
+                    <th class="name">{% trans 'Rows' %}</th>
+                    <td class="value">{{ format_number(showtable['Rows'], 0) }}</td>
+                    </tr>
+                {% endif %}
+
+                {% if not is_innodb
+                    and showtable['Avg_row_length'] is defined
+                    and showtable['Avg_row_length'] > 0 %}
+                    <tr>
+                    <th class="name">{% trans 'Row length' %}</th>
+                    {% set avg_row_length = format_byte_down(showtable['Avg_row_length'], 6, 1) %}
+                    <td class="value">{{ avg_row_length[0] }} {{ avg_row_length[1] }}</td>
+                    </tr>
+                {% endif %}
+
+                {% if not is_innodb
+                    and showtable['Data_length'] is defined
+                    and showtable['Rows'] is defined
+                    and showtable['Rows'] > 0
+                    and mergetable == false %}
+                    <tr>
+                    <th class="name">{% trans 'Row size' %}</th>
+                    <td class="value">{{ avg_size }} {{ avg_unit }}</td>
+                    </tr>
+                {% endif %}
+
+                {% if showtable['Auto_increment'] is defined %}
+                    <tr>
+                    <th class="name">{% trans 'Next autoindex' %}</th>
+                    <td class="value">{{ format_number(showtable['Auto_increment'], 0) }}</td>
+                    </tr>
+                {% endif %}
+
+                {% if showtable['Create_time'] is defined %}
+                    <tr>
+                    <th class="name">{% trans 'Creation' %}</th>
+                    <td class="value">{{ localised_date(showtable['Create_time']|date('U')) }}</td>
+                    </tr>
+                {% endif %}
+
+                {% if showtable['Update_time'] is defined %}
+                    <tr>
+                    <th class="name">{% trans 'Last update' %}</th>
+                    <td class="value">{{ localised_date(showtable['Update_time']|date('U')) }}</td>
+                    </tr>
+                {% endif %}
+
+                {% if showtable['Check_time'] is defined %}
+                    <tr>
+                    <th class="name">{% trans 'Last check' %}</th>
+                    <td class="value">{{ localised_date(showtable['Check_time']|date('U')) }}</td>
+                    </tr>
+                {% endif %}
+            </tbody>
+        </table>
+    </fieldset>
+</div>
-- 
cgit