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

---
 .../phpmyadmin/templates/database/search/main.twig | 84 ++++++++++++++++++++++
 .../templates/database/search/results.twig         | 62 ++++++++++++++++
 2 files changed, 146 insertions(+)
 create mode 100644 srcs/phpmyadmin/templates/database/search/main.twig
 create mode 100644 srcs/phpmyadmin/templates/database/search/results.twig

(limited to 'srcs/phpmyadmin/templates/database/search')

diff --git a/srcs/phpmyadmin/templates/database/search/main.twig b/srcs/phpmyadmin/templates/database/search/main.twig
new file mode 100644
index 0000000..45e5e71
--- /dev/null
+++ b/srcs/phpmyadmin/templates/database/search/main.twig
@@ -0,0 +1,84 @@
+<a id="db_search"></a>
+<form id="db_search_form" method="post" action="db_search.php" name="db_search" class="ajax lock-page">
+    {{ get_hidden_inputs(db) }}
+    <fieldset>
+        <legend>{% trans 'Search in database' %}</legend>
+        <p>
+            <label for="criteriaSearchString" class="displayblock">
+                {% trans 'Words or values to search for (wildcard: "%"):' %}
+            </label>
+            <input id="criteriaSearchString" name="criteriaSearchString" class="all85" type="text" value="
+                {{- criteria_search_string }}">
+        </p>
+
+        <fieldset>
+            <legend>{% trans 'Find:' %}</legend>
+            {# 4th parameter set to true to add line breaks #}
+            {# 5th parameter set to false to avoid htmlspecialchars() escaping
+            in the label since we have some HTML in some labels #}
+            {{ get_radio_fields(
+                'criteriaSearchType',
+                choices,
+                criteria_search_type,
+                true,
+                false
+            ) }}
+        </fieldset>
+
+        <fieldset>
+            <legend>{% trans 'Inside tables:' %}</legend>
+            <p>
+                <a href="#" onclick="Functions.setSelectOptions('db_search', 'criteriaTables[]', true); return false;">
+                    {% trans 'Select all' %}
+                </a> /
+                <a href="#" onclick="Functions.setSelectOptions('db_search', 'criteriaTables[]', false); return false;">
+                    {% trans 'Unselect all' %}
+                </a>
+            </p>
+            <select name="criteriaTables[]" multiple>
+                {% for each_table in tables_names_only %}
+                    <option value="{{ each_table }}"
+                            {% if criteria_tables|length > 0 %}
+                                {{- each_table in criteria_tables ? ' selected' }}
+                            {% else %}
+                                {{- ' selected' }}
+                            {% endif %}
+                        >
+                        {{ each_table }}
+                    </option>
+                {% endfor %}
+            </select>
+        </fieldset>
+
+        <p>
+            {# Inputbox for column name entry #}
+            <label for="criteriaColumnName" class="displayblock">
+                {% trans 'Inside column:' %}
+            </label>
+            <input id="criteriaColumnName" type="text" name="criteriaColumnName" class="all85" value="
+                {{- criteria_column_name is not empty ? criteria_column_name }}">
+        </p>
+    </fieldset>
+    <fieldset class="tblFooters">
+        <input id="buttonGo" class="btn btn-primary" type="submit" name="submit_search" value="{% trans 'Go' %}">
+    </fieldset>
+</form>
+<div id="togglesearchformdiv">
+    <a id="togglesearchformlink"></a>
+</div>
+<div id="searchresults"></div>
+<div id="togglesearchresultsdiv"><a id="togglesearchresultlink"></a></div>
+<br class="clearfloat">
+{# These two table-image and table-link elements display the table name in browse search results #}
+<div id="table-info">
+    <a id="table-link" class="item"></a>
+</div>
+{# Div for browsing results #}
+<div id="browse-results">
+    {# This browse-results div is used to load the browse and delete results in the db search #}
+</div>
+<div id="sqlqueryform" class="clearfloat">
+    {# This sqlqueryform div is used to load the delete form in the db search #}
+</div>
+{# Toggle query box link #}
+<a id="togglequerybox"></a>
diff --git a/srcs/phpmyadmin/templates/database/search/results.twig b/srcs/phpmyadmin/templates/database/search/results.twig
new file mode 100644
index 0000000..3d7a780
--- /dev/null
+++ b/srcs/phpmyadmin/templates/database/search/results.twig
@@ -0,0 +1,62 @@
+<table class="data">
+    <caption class="tblHeaders">
+        {{ 'Search results for "<em>%s</em>" %s:'|format(
+            criteria_search_string,
+            search_type_description
+        )|raw }}
+    </caption>
+    {% for row in rows %}
+        <tr class="noclick">
+            <td>
+                {% set result_message %}
+                    {% trans %}
+                        %1$s match in <strong>%2$s</strong>
+                    {% plural row.result_count %}
+                        %1$s matches in <strong>%2$s</strong>
+                    {% endtrans %}
+                {% endset %}
+                {{ result_message|format(row.result_count, row.table)|raw }}
+            </td>
+            {% if row.result_count > 0 %}
+                {% set url_params = {
+                    'db': db,
+                    'table': row.table,
+                    'goto': 'db_sql.php',
+                    'pos': 0,
+                    'is_js_confirmed': 0
+                } %}
+                <td>
+                    <a name="browse_search"
+                        class="ajax browse_results"
+                        href="sql.php{{ get_common(url_params) }}"
+                        data-browse-sql="{{ row.new_search_sqls.select_columns }}"
+                        data-table-name="{{ row.table }}">
+                        {% trans 'Browse' %}
+                    </a>
+                </td>
+                <td>
+                    <a name="delete_search"
+                        class="ajax delete_results"
+                        href="sql.php{{ get_common(url_params) }}"
+                        data-delete-sql="{{ row.new_search_sqls.delete }}"
+                        data-table-name="{{ row.table }}">
+                        {% trans 'Delete' %}
+                    </a>
+                </td>
+            {% else %}
+                <td></td>
+                <td></td>
+            {% endif %}
+        </tr>
+    {% endfor %}
+</table>
+
+{% if criteria_tables|length > 1 %}
+    <p>
+        {% trans %}
+            <strong>Total:</strong> <em>{{ count }}</em> match
+        {% plural result_total %}
+            <strong>Total:</strong> <em>{{ count }}</em> matches
+        {% endtrans %}
+    </p>
+{% endif %}
-- 
cgit