diff options
Diffstat (limited to 'srcs/phpmyadmin/templates/sql')
7 files changed, 161 insertions, 0 deletions
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=""> </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> |