phpmyadmin working

4 files changed, 248 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/templates/table/tracking/main.twig b/srcs/phpmyadmin/templates/table/tracking/main.twig
new file mode 100644
index 0000000..ff6c5c4
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/tracking/main.twig
@@ -0,0 +1,132 @@
+{% if selectable_tables_num_rows > 0 %}
+    <form method="post" action="tbl_tracking.php{{ url_query|raw }}">
+        {{ get_hidden_inputs(db, table) }}
+        <select name="table" class="autosubmit">
+            {% for entry in selectable_tables_entries %}
+                <option value="{{ entry.table_name }}"
+                    {{- entry.table_name == selected_table ? ' selected' }}>
+                    {{ entry.db_name }}.{{ entry.table_name }}
+                    {% if entry.is_tracked %}
+                        ({% trans 'active' %})
+                    {% else %}
+                        ({% trans 'not active' %})
+                    {% endif %}
+                </option>
+            {% endfor %}
+        </select>
+        <input type="hidden" name="show_versions_submit" value="1">
+    </form>
+{% endif %}
+<br>
+{% if last_version > 0 %}
+    <form method="post" action="tbl_tracking.php" name="versionsForm" id="versionsForm" class="ajax">
+        {{ get_hidden_inputs(db, table) }}
+        <table id="versions" class="data">
+            <thead>
+                <tr>
+                    <th></th>
+                    <th>{% trans 'Version' %}</th>
+                    <th>{% trans 'Created' %}</th>
+                    <th>{% trans 'Updated' %}</th>
+                    <th>{% trans 'Status' %}</th>
+                    <th>{% trans 'Action' %}</th>
+                    <th>{% trans 'Show' %}</th>
+                </tr>
+            </thead>
+            <tbody>
+                {% for version in versions %}
+                    <tr>
+                        <td class="center">
+                            <input type="checkbox" name="selected_versions[]"
+                                class="checkall" id="selected_versions_{{- version['version']|escape }}"
+                                value="{{- version['version']|escape }}">
+                        </td>
+                        <td class="floatright">
+                            <label for="selected_versions_{{- version['version']|escape }}">
+                                <b>{{ version['version']|escape }}</b>
+                            </label>
+                        </td>
+                        <td>{{ version['date_created']|escape }}</td>
+                        <td>{{ version['date_updated']|escape }}</td>
+                        {% if version['tracking_active'] == 1 %}
+                            {% set last_version_status = 1 %}
+                            <td>{% trans 'active' %}</td>
+                        {% else %}
+                            {% set last_version_status = 0 %}
+                            <td>{% trans 'not active' %}</td>
+                        {% endif %}
+                        <td>
+                            <a class="delete_version_anchor ajax" href="tbl_tracking.php" data-post="
+                                {{- get_common(url_params|merge({
+                                    'version': version['version'],
+                                    'submit_delete_version': true
+                                }), '') }}">
+                                {{ get_icon('b_drop', 'Delete version'|trans) }}
+                            </a>
+                        </td>
+                        <td>
+                            <a href="tbl_tracking.php" data-post="
+                                {{- get_common(url_params|merge({
+                                    'version': version['version'],
+                                    'report': 'true'
+                                }), '') }}">
+                                {{ get_icon('b_report', 'Tracking report'|trans) }}
+                            </a>
+                            <a href="tbl_tracking.php" data-post="
+                                {{- get_common(url_params|merge({
+                                    'version': version['version'],
+                                    'snapshot': 'true'
+                                }), '') }}">
+                                {{ get_icon('b_props', 'Structure snapshot'|trans) }}
+                            </a>
+                        </td>
+                    </tr>
+                {% endfor %}
+            </tbody>
+        </table>
+        {% include 'select_all.twig' with {
+            'pma_theme_image': pmaThemeImage,
+            'text_dir': text_dir,
+            'form_name': 'versionsForm',
+        } only %}
+        {{ get_button_or_image(
+            'submit_mult',
+            'mult_submit',
+            'Delete version'|trans,
+            'b_drop',
+            'delete_version'
+        ) }}
+    </form>
+    {% set last_version_element = versions|first %}
+    <div>
+        <form method="post" action="tbl_tracking.php{{ url_query|raw }}">
+            {{ get_hidden_inputs(db, table) }}
+            <fieldset>
+                <legend>
+                    {% if last_version_element['tracking_active'] == 0 %}
+                        {% set legend = 'Activate tracking for %s'|trans %}
+                        {% set value = 'activate_now' %}
+                        {% set button = 'Activate now'|trans %}
+                    {% else %}
+                        {% set legend = 'Deactivate tracking for %s'|trans %}
+                        {% set value = 'deactivate_now' %}
+                        {% set button = 'Deactivate now'|trans %}
+                    {% endif %}
+
+                    {{ legend|format(db ~ '.' ~ table) }}
+                </legend>
+                <input type="hidden" name="version" value="{{ last_version }}">
+                <input type="hidden" name="toggle_activation" value="{{ value }}">
+                <input class="btn btn-secondary" type="submit" value="{{ button }}">
+            </fieldset>
+        </form>
+    </div>
+{% endif %}
+{% include 'create_tracking_version.twig' with {
+    'url_query': url_query,
+    'last_version': last_version,
+    'db': db,
+    'selected': [table],
+    'type': type,
+    'default_statements': default_statements,
+} only %}
diff --git a/srcs/phpmyadmin/templates/table/tracking/report_table.twig b/srcs/phpmyadmin/templates/table/tracking/report_table.twig
new file mode 100644
index 0000000..fe00526
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/tracking/report_table.twig
@@ -0,0 +1,27 @@
+<table id="{{ table_id }}" class="data">
+    <thead>
+        <tr>
+            <th>{% trans %}#{% context %}Number{% endtrans %}</th>
+            <th>{% trans 'Date' %}</th>
+            <th>{% trans 'Username' %}</th>
+            <th>{{ header_message }}</th>
+            <th>{% trans 'Action' %}</th>
+        </tr>
+    </thead>
+    <tbody>
+        {% for entry in entries %}
+            <tr class="noclick">
+                <td class="right"><small>{{ entry.line_number }}</small></td>
+                <td><small>{{ entry.date }}</small></td>
+                <td><small>{{ entry.username }}</small></td>
+                <td>{{ entry.formated_statement|raw }}</td>
+                <td class="nowrap">
+                    <a class="delete_entry_anchor ajax" href="tbl_tracking.php" data-post="
+                        {{- entry.url_params|raw }}">
+                        {{ drop_image_or_text|raw }}
+                    </a>
+                </td>
+            </tr>
+        {% endfor %}
+    </tbody>
+</table>
diff --git a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig
new file mode 100644
index 0000000..4ef8c21
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig
@@ -0,0 +1,56 @@
+<h3>{% trans 'Structure' %}</h3>
+<table id="tablestructure" class="data">
+    <thead>
+        <tr>
+            <th>{% trans %}#{% context %}Number{% endtrans %}</th>
+            <th>{% trans 'Column' %}</th>
+            <th>{% trans 'Type' %}</th>
+            <th>{% trans 'Collation' %}</th>
+            <th>{% trans 'Null' %}</th>
+            <th>{% trans 'Default' %}</th>
+            <th>{% trans 'Extra' %}</th>
+            <th>{% trans 'Comment' %}</th>
+        </tr>
+    </thead>
+    <tbody>
+        {% set index = 1 %}
+        {% for field in columns %}
+            <tr class="noclick">
+                <td>{{ index }}</td>
+                {% set index = index + 1 %}
+                <td>
+                    <strong>
+                        {{ field['Field'] }}
+                        {% if field['Key'] == 'PRI' %}
+                            {{ get_image('b_primary', 'Primary'|trans) }}
+                        {% elseif field['Key'] is not empty %}
+                            {{ get_image('bd_primary', 'Index'|trans) }}
+                        {% endif %}
+                    </strong>
+                </td>
+                <td>{{ field['Type'] }}</td>
+                <td>{{ field['Collation'] }}</td>
+                <td>{{ field['Null'] == 'YES' ? 'Yes'|trans : 'No'|trans }}</td>
+                <td>
+                    {% if field['Default'] is defined %}
+                        {% set extracted_columnspec = extract_column_spec(field['Type']) %}
+                        {% if extracted_columnspec['type'] == 'bit' %}
+                            {# here, $field['Default'] contains something like b'010' #}
+                            {{ field['Default']|convert_bit_default_value }}
+                        {% else %}
+                            {{ field['Default'] }}
+                        {% endif %}
+                    {% else %}
+                        {% if field['Null'] == 'YES' %}
+                            <em>NULL</em>
+                        {% else %}
+                            <em>{% trans %}None{% context %}None for default{% endtrans %}</em>
+                        {% endif %}
+                    {% endif %}
+                </td>
+                <td>{{ field['Extra'] }}</td>
+                <td>{{ field['Comment'] }}</td>
+            </tr>
+        {% endfor %}
+    </tbody>
+</table>
diff --git a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig
new file mode 100644
index 0000000..a919252
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig
@@ -0,0 +1,33 @@
+<h3>{% trans 'Indexes' %}</h3>
+<table id="tablestructure_indexes" class="data">
+    <thead>
+        <tr>
+            <th>{% trans 'Keyname' %}</th>
+            <th>{% trans 'Type' %}</th>
+            <th>{% trans 'Unique' %}</th>
+            <th>{% trans 'Packed' %}</th>
+            <th>{% trans 'Column' %}</th>
+            <th>{% trans 'Cardinality' %}</th>
+            <th>{% trans 'Collation' %}</th>
+            <th>{% trans 'Null' %}</th>
+            <th>{% trans 'Comment' %}</th>
+        </tr>
+    </thead>
+    <tbody>
+        {% for index in indexes %}
+            <tr class="noclick">
+                <td>
+                    <strong>{{ index['Key_name'] }}</strong>
+                </td>
+                <td>{{ index['Index_type'] }}</td>
+                <td>{{ index['Non_unique'] == 0 ? 'Yes'|trans : 'No'|trans }}</td>
+                <td>{{ index['Packed'] != '' ? 'Yes'|trans : 'No'|trans }}</td>
+                <td>{{ index['Column_name'] }}</td>
+                <td>{{ index['Cardinality'] }}</td>
+                <td>{{ index['Collation'] }}</td>
+                <td>{{ index['Null'] }}</td>
+                <td>{{ index['Comment'] }}</td>
+            </tr>
+        {% endfor %}
+    </tbody>
+</table>