diff options
Diffstat (limited to 'srcs/phpmyadmin/templates/server/databases/index.twig')
| -rw-r--r-- | srcs/phpmyadmin/templates/server/databases/index.twig | 323 |
1 files changed, 323 insertions, 0 deletions
diff --git a/srcs/phpmyadmin/templates/server/databases/index.twig b/srcs/phpmyadmin/templates/server/databases/index.twig new file mode 100644 index 0000000..ebff55f --- /dev/null +++ b/srcs/phpmyadmin/templates/server/databases/index.twig @@ -0,0 +1,323 @@ +<h2> + {{ get_image('s_db') }} + {% if has_statistics %} + {% trans 'Databases statistics' %} + {% else %} + {% trans 'Databases' %} + {% endif %} +</h2> + +{% if is_create_database_shown %} + <ul> + <li id="li_create_database" class="no_bullets"> + {% if has_create_database_privileges %} + <form method="post" action="server_databases.php" id="create_database_form" class="ajax"> + <p> + <strong> + <label for="text_create_db"> + {{ get_image('b_newdb') }} + {% trans 'Create database' %} + </label> + {{ show_mysql_docu('CREATE_DATABASE') }} + </strong> + </p> + + {{ get_hidden_inputs('', '', 5) }} + <input type="hidden" name="reload" value="1"> + {% if has_statistics %} + <input type="hidden" name="statistics" value="1"> + {% endif %} + + <input type="text" name="new_db" maxlength="64" class="textfield" value=" + {{- database_to_create }}" id="text_create_db" placeholder=" + {%- trans 'Database name' %}" required> + + {% if charsets is not empty %} + <select lang="en" dir="ltr" name="db_collation"> + <option value="">{% trans 'Collation' %}</option> + <option value=""></option> + {% for charset in charsets %} + <optgroup label="{{ charset.name }}" title="{{ charset.description }}"> + {% for collation in charset.collations %} + <option value="{{ collation.name }}" title="{{ collation.description }}"{{ collation.is_selected ? ' selected' }}> + {{- collation.name -}} + </option> + {% endfor %} + </optgroup> + {% endfor %} + </select> + {% endif %} + + <input id="buttonGo" class="btn btn-primary" type="submit" value="{% trans 'Create' %}"> + </form> + {% else %} + <p> + <strong> + {{ get_image('b_newdb') }} + {% trans 'Create database' %} + {{ show_mysql_docu('CREATE_DATABASE') }} + </strong> + </p> + + <span class="noPrivileges"> + {{ get_image('s_error', '', { + 'hspace': 2, + 'border': 0, + 'align': 'middle' + }) }} + {% trans 'No privileges to create databases' %} + </span> + {% endif %} + </li> + </ul> +{% endif %} + +{% if database_count > 0 %} + {% include 'filter.twig' with {'filter_value': ''} only %} + + <div id="tableslistcontainer"> + {{ get_list_navigator( + database_count, + pos, + url_params, + 'server_databases.php', + 'frame_content', + max_db_list + ) }} + + <form class="ajax" action="server_databases.php" method="post" name="dbStatsForm" id="dbStatsForm"> + {{ get_hidden_inputs(url_params) }} + <div class="responsivetable"> + <table id="tabledatabases" class="data"> + <thead> + <tr> + {% if is_drop_allowed %} + <th></th> + {% endif %} + <th> + <a href="server_databases.php{{ get_common(url_params|merge({ + 'sort_by': 'SCHEMA_NAME', + 'sort_order': url_params.sort_by == 'SCHEMA_NAME' + and url_params.sort_order == 'asc' ? 'desc' : 'asc' + })) }}"> + {% trans 'Database' %} + {% if url_params.sort_by == 'SCHEMA_NAME' %} + {% if url_params.sort_order == 'asc' %} + {{ get_image('s_asc', 'Ascending'|trans) }} + {% else %} + {{ get_image('s_desc', 'Descending'|trans) }} + {% endif %} + {% endif %} + </a> + </th> + + <th> + <a href="server_databases.php{{ get_common(url_params|merge({ + 'sort_by': 'DEFAULT_COLLATION_NAME', + 'sort_order': url_params.sort_by == 'DEFAULT_COLLATION_NAME' + and url_params.sort_order == 'asc' ? 'desc' : 'asc' + })) }}"> + {% trans 'Collation' %} + {% if url_params.sort_by == 'DEFAULT_COLLATION_NAME' %} + {% if url_params.sort_order == 'asc' %} + {{ get_image('s_asc', 'Ascending'|trans) }} + {% else %} + {{ get_image('s_desc', 'Descending'|trans) }} + {% endif %} + {% endif %} + </a> + </th> + + {% if has_statistics %} + {% for name, statistic in header_statistics %} + <th{{ statistic.format == 'byte' ? ' colspan="2"' }}> + <a href="server_databases.php{{ get_common(url_params|merge({ + 'sort_by': name, + 'sort_order': url_params.sort_by == name + and url_params.sort_order == 'asc' ? 'desc' : 'asc' + })) }}"> + {{ statistic.title }} + {% if url_params.sort_by == name %} + {% if url_params.sort_order == 'asc' %} + {{ get_image('s_asc', 'Ascending'|trans) }} + {% else %} + {{ get_image('s_desc', 'Descending'|trans) }} + {% endif %} + {% endif %} + </a> + </th> + {% endfor %} + {% endif %} + + {% if has_master_replication %} + <th>{% trans 'Master replication' %}</th> + {% endif %} + + {% if has_slave_replication %} + <th>{% trans 'Slave replication' %}</th> + {% endif %} + + <th>{% trans 'Action' %}</th> + </tr> + </thead> + + <tbody> + {% for database in databases %} + <tr class="db-row{{ database.is_system_schema ? ' noclick' }}" data-filter-row="{{ database.name|upper }}"> + {% if is_drop_allowed %} + <td class="tool"> + <input type="checkbox" name="selected_dbs[]" class="checkall" title=" + {{- database.name }}" value=" + {{- database.name }}" + {{- database.is_system_schema ? ' disabled' }}> + </td> + {% endif %} + + <td class="name"> + <a href="{{ get_script_name_for_option(default_tab_database, 'database') }} + {{- get_common({'db': database.name}) }}" title=" + {{- "Jump to database '%s'"|trans|format(database.name) }}"> + {{ database.name }} + </a> + </td> + + <td class="value"> + <dfn title="{{ database.collation.description }}"> + {{ database.collation.name }} + </dfn> + </td> + + {% if has_statistics %} + {% for statistic in database.statistics %} + {% if statistic.format is same as('byte') %} + {% set value = format_byte_down(statistic.raw, 3, 1) %} + <td class="value"> + <data value="{{ statistic.raw }}" title="{{ statistic.raw }}"> + {{ value[0] }} + </data> + </td> + <td class="unit">{{ value[1] }}</td> + {% else %} + <td class="value"> + <data value="{{ statistic.raw }}" title="{{ statistic.raw }}"> + {{ format_number(statistic.raw, 0) }} + </data> + </td> + {% endif %} + {% endfor %} + {% endif %} + + {% if database.replication.master.status %} + {% if database.replication.master.is_replicated %} + <td class="tool center"> + {{ get_icon('s_success', 'Replicated'|trans) }} + </td> + {% else %} + <td class="tool center"> + {{ get_icon('s_cancel', 'Not replicated'|trans) }} + </td> + {% endif %} + {% endif %} + + {% if database.replication.slave.status %} + {% if database.replication.slave.is_replicated %} + <td class="tool center"> + {{ get_icon('s_success', 'Replicated'|trans) }} + </td> + {% else %} + <td class="tool center"> + {{ get_icon('s_cancel', 'Not replicated'|trans) }} + </td> + {% endif %} + {% endif %} + + <td class="tool"> + <a class="server_databases" data=" + {{- database.name|js_format }}" href="server_privileges.php + {{- get_common({ + 'db': database.name, + 'checkprivsdb': database.name + }) }}" title=" + {{- 'Check privileges for database "%s".'|trans|format(database.name) }}"> + {{ get_icon('s_rights', 'Check privileges'|trans) }} + </a> + </td> + </tr> + {% endfor %} + </tbody> + + <tfoot> + <tr> + <th colspan="{{ is_drop_allowed ? '3' : '2' }}"> + {% trans 'Total:' %} + <span id="filter-rows-count"> + {{- database_count -}} + </span> + </th> + + {% if has_statistics %} + {% for statistic in total_statistics %} + {% if statistic.format is same as('byte') %} + {% set value = format_byte_down(statistic.raw, 3, 1) %} + <th class="value"> + <data value="{{ statistic.raw }}" title="{{ statistic.raw }}"> + {{ value[0] }} + </data> + </th> + <th class="unit">{{ value[1] }}</th> + {% else %} + <th class="value"> + <data value="{{ statistic.raw }}" title="{{ statistic.raw }}"> + {{ format_number(statistic.raw, 0) }} + </data> + </th> + {% endif %} + {% endfor %} + {% endif %} + + {% if has_master_replication %} + <th></th> + {% endif %} + + {% if has_slave_replication %} + <th></th> + {% endif %} + + <th></th> + </tr> + </tfoot> + </table> + </div> + + {# Footer buttons #} + {% if is_drop_allowed %} + {% include 'select_all.twig' with { + 'pma_theme_image': pma_theme_image, + 'text_dir': text_dir, + 'form_name': 'dbStatsForm' + } only %} + + {{ get_button_or_image( + '', + 'mult_submit ajax', + 'Drop'|trans, + 'b_deltbl' + ) }} + {% endif %} + + {# Enable statistics #} + {% if not has_statistics %} + {{ 'Note: Enabling the database statistics here might cause heavy traffic between the web server and the MySQL server.'|trans|notice }} + <ul> + <li class="li_switch_dbstats"> + <a href="server_databases.php" data-post="{{ get_common({'statistics': '1'}, '') }}" title="{% trans 'Enable statistics' %}"> + <strong>{% trans 'Enable statistics' %}</strong> + </a> + </li> + </ul> + {% endif %} + </form> + </div> +{% else %} + <p>{{ 'No databases'|trans|notice }}</p> +{% endif %} |