usky-website/web/phpMyAdmin/templates/export.twig

{{ page_settings_error_html|raw }}
{{ page_settings_html|raw }}

{% block message %}{% endblock %}

<div class="exportoptions row" id="header">
  <h2>
    {{ get_image('b_export', 'Export'|trans) }}
    {% block title %}{% endblock %}
  </h2>
</div>

{% if templates.is_enabled %}
  <div class="exportoptions" id="export_templates">
    <h3>{% trans 'Export templates:' %}</h3>

    <div class="floatleft">
      <form method="post" action="{{ url('/export/template/create') }}" id="newTemplateForm" class="ajax">
        <h4>{% trans 'New template:' %}</h4>
        <input type="text" name="templateName" id="templateName" maxlength="64" placeholder="{% trans 'Template name' %}" required>
        <input class="btn btn-secondary" type="submit" name="createTemplate" id="createTemplate" value="{% trans 'Create' %}">
      </form>
    </div>

    <div class="floatleft" style="margin-left: 50px;">
      <form method="post" id="existingTemplatesForm" class="ajax">
        <h4>{% trans 'Existing templates:' %}</h4>
        <label for="template">{% trans 'Template:' %}</label>
        <select name="template" id="template" required>
          <option value="">-- {% trans 'Select a template' %} --</option>
          {% for template in templates.templates %}
            <option value="{{ template.getId() }}"{{ template.getId() == templates.selected ? ' selected' }}>
              {{ template.getName() }}
            </option>
          {% endfor %}
        </select>
        <input class="btn btn-secondary" type="submit" formaction="{{ url('/export/template/update') }}" name="updateTemplate" id="updateTemplate" value="{% trans 'Update' %}">
        <input class="btn btn-secondary" type="submit" formaction="{{ url('/export/template/delete') }}" name="deleteTemplate" id="deleteTemplate" value="{% trans 'Delete' %}">
      </form>
    </div>

    <div class="clearfloat"></div>
  </div>
{% endif %}

{% if sql_query is not empty %}
  <div class="exportoptions">
    {# l10n: Title of the option on the Export page #}
    <h3>{% trans 'SQL query:' %}</h3>
    <div class="floatleft">
      <div id="sqlqueryform">
        {# l10n: Button to show the SQL query on the export page #}
        <input class="btn btn-secondary" type="submit" id="showsqlquery" value="{% trans 'Show SQL query' %}">
      </div>
      <div class="d-none">
        <div id="export_sql_modal_content">
          <code class="sql">
            <pre id="sql_preview_query">{{ sql_query }}</pre>
          </code>
        </div>
      </div>
    </div>
    <div class="clearfloat"></div>
  </div>
{% endif %}

<form method="post" action="{{ url('/export') }}" name="dump" class="disableAjax">
  {{ get_hidden_inputs(hidden_inputs) }}

  {% if export_method != 'custom-no-form' %}
    <div class="exportoptions" id="quick_or_custom">
      <h3>{% trans 'Export method:' %}</h3>
      <ul>
        <li>
          <input type="radio" name="quick_or_custom" value="quick" id="radio_quick_export"
            {{- export_method == 'quick' ? ' checked' }}>
          <label for="radio_quick_export">
            {% trans 'Quick - display only the minimal options' %}
          </label>
        </li>

        <li>
          <input type="radio" name="quick_or_custom" value="custom" id="radio_custom_export"
            {{- export_method == 'custom' ? ' checked' }}>
          <label for="radio_custom_export">
            {% trans 'Custom - display all possible options' %}
          </label>
        </li>
      </ul>
    </div>
  {% endif %}

  <div class="exportoptions" id="format">
    <h3>{% trans 'Format:' %}</h3>
    {{ dropdown|raw }}
  </div>

  {% block selection_options %}{% endblock %}

  {% if rows is not empty %}
    <div class="exportoptions" id="rows">
      <h3>{% trans 'Rows:' %}</h3>
      <ul>
        <li>
          <input type="radio" name="allrows" value="0" id="radio_allrows_0"
            {{- rows.allrows is not null and rows.allrows == 0 ? ' checked' }}>
          <label for="radio_allrows_0">{% trans 'Dump some row(s)' %}</label>
          <ul>
            <li>
              <label for="limit_to">{% trans 'Number of rows:' %}</label>
              <input type="text" id="limit_to" name="limit_to" size="5" value="
                {%- if rows.limit_to is not null -%}
                  {{- rows.limit_to -}}
                {%- elseif rows.unlim_num_rows is not empty and rows.unlim_num_rows != 0 -%}
                  {{- rows.unlim_num_rows -}}
                {%- else %}
                  {{- rows.number_of_rows -}}
                {%- endif -%}" onfocus="this.select()">
            </li>
            <li>
              <label for="limit_from">{% trans 'Row to begin at:' %}</label>
              <input type="text" id="limit_from" name="limit_from" size="5" value="
              {{- rows.limit_from is not null ? rows.limit_from : 0 }}" onfocus="this.select()">
            </li>
          </ul>
        </li>
        <li>
          <input type="radio" name="allrows" value="1" id="radio_allrows_1"
            {{- rows.allrows is null or rows.allrows == 1 ? ' checked' }}>
          <label for="radio_allrows_1">{% trans 'Dump all rows' %}</label>
        </li>
      </ul>
    </div>
  {% endif %}

  {% if has_save_dir %}
    <div class="exportoptions" id="output_quick_export">
      <h3>{% trans 'Output:' %}</h3>
      <ul>
        <li>
          <input type="checkbox" name="quick_export_onserver" value="saveit" id="checkbox_quick_dump_onserver"{{ export_is_checked ? ' checked' }}>
          <label for="checkbox_quick_dump_onserver">
            {{ 'Save on server in the directory <strong>%s</strong>'|trans|format(save_dir|e)|raw }}
          </label>
        </li>
        <li>
          <input type="checkbox" name="quick_export_onserver_overwrite" value="saveitover" id="checkbox_quick_dump_onserver_overwrite"
            {{- export_overwrite_is_checked ? ' checked' }}>
          <label for="checkbox_quick_dump_onserver_overwrite">
            {% trans 'Overwrite existing file(s)' %}
          </label>
        </li>
      </ul>
    </div>
  {% endif %}

  <div id="alias_modal" class="hide" title="{% trans 'Rename exported databases/tables/columns' %}">
    <table class="pma-table" id="alias_data">
      <thead>
      <tr>
        <th colspan="4">
          {% trans 'Defined aliases' %}
        </th>
      </tr>
      </thead>

      <tbody>
      {% for db, db_data in aliases %}
        {% if db_data.alias is defined and db_data.alias is not null %}
          <tr>
            <th>{% trans %}Database{% context %}Alias{% endtrans %}</th>
            <td>{{ db }}</td>
            <td>
              <input name="aliases[{{ db }}][alias]" value="{{ db_data.alias }}" type="text">
            </td>
            <td>
              <button class="alias_remove btn btn-secondary">{% trans 'Remove' %}</button>
            </td>
          </tr>
        {% endif %}

        {% for table, table_data in db_data.tables ?? [] %}
          {% if table_data.alias is defined and table_data.alias is not null %}
            <tr>
              <th>{% trans %}Table{% context %}Alias{% endtrans %}</th>
              <td>{{ db }}.{{ table }}</td>
              <td>
                <input name="aliases[{{ db }}][tables][{{ table }}][alias]" value="{{ table_data.alias }}" type="text">
              </td>
              <td>
                <button class="alias_remove btn btn-secondary">{% trans 'Remove' %}</button>
              </td>
            </tr>
          {% endif %}

          {% for column, column_name in table_data.columns ?? [] %}
            <tr>
              <th>{% trans %}Column{% context %}Alias{% endtrans %}</th>
              <td>{{ db }}.{{ table }}.{{ column }}</td>
              <td>
                <input name="aliases[{{ db }}][tables][{{ table }}][colums][{{ column }}]" value="{{ column_name }}" type="text">
              </td>
              <td>
                <button class="alias_remove btn btn-secondary">{% trans 'Remove' %}</button>
              </td>
            </tr>
          {% endfor %}
        {% endfor %}
      {% endfor %}
      </tbody>

      {# Empty row for javascript manipulations. #}
      <tfoot class="hide">
      <tr>
        <th></th>
        <td></td>
        <td>
          <input name="aliases_new" value="" type="text">
        </td>
        <td>
          <button class="alias_remove btn btn-secondary">{% trans 'Remove' %}</button>
        </td>
      </tr>
      </tfoot>
    </table>

    <table class="pma-table">
      <thead>
      <tr>
        <th colspan="4">{% trans 'Define new aliases' %}</th>
      </tr>
      </thead>
      <tr>
        <td>
          <label>{% trans 'Select database:' %}</label>
        </td>
        <td>
          <select id="db_alias_select"><option value=""></option></select>
        </td>
        <td>
          <input id="db_alias_name" placeholder="{% trans 'New database name' %}" disabled="1">
        </td>
        <td>
          <button id="db_alias_button" class="btn btn-secondary" disabled="1">{% trans 'Add' %}</button>
        </td>
      </tr>
      <tr>
        <td>
          <label>{% trans 'Select table:' %}</label>
        </td>
        <td>
          <select id="table_alias_select"><option value=""></option></select>
        </td>
        <td>
          <input id="table_alias_name" placeholder="{% trans 'New table name' %}" disabled="1">
        </td>
        <td>
          <button id="table_alias_button" class="btn btn-secondary" disabled="1">{% trans 'Add' %}</button>
        </td>
      </tr>
      <tr>
        <td>
          <label>{% trans 'Select column:' %}</label>
        </td>
        <td>
          <select id="column_alias_select"><option value=""></option></select>
        </td>
        <td>
          <input id="column_alias_name" placeholder="{% trans 'New column name' %}" disabled="1">
        </td>
        <td>
          <button id="column_alias_button" class="btn btn-secondary" disabled="1">{% trans 'Add' %}</button>
        </td>
      </tr>
    </table>
  </div>

  <div class="exportoptions" id="output">
    <h3>{% trans 'Output:' %}</h3>
    <ul id="ul_output">
      <li>
        <input type="checkbox" id="btn_alias_config"{{ has_aliases ? ' checked' }}>
        <label for="btn_alias_config">
          {% trans 'Rename exported databases/tables/columns' %}
        </label>
      </li>

      {% if export_type != 'server' %}
        <li>
          <input type="checkbox" name="lock_tables" value="something" id="checkbox_lock_tables"
            {{- (not repopulate and is_checked_lock_tables) or lock_tables ? ' checked' }}>
          <label for="checkbox_lock_tables">
            {{ 'Use %s statement'|trans|format('<code>LOCK TABLES</code>')|raw }}
          </label>
        </li>
      {% endif %}

      <li>
        <input type="radio" name="output_format" value="sendit" id="radio_dump_asfile"
          {{- not repopulate and is_checked_asfile ? ' checked' }}>
        <label for="radio_dump_asfile">
          {% trans 'Save output to a file' %}
        </label>
        <ul id="ul_save_asfile">
          {% if has_save_dir %}
            <li>
              <input type="checkbox" name="onserver" value="saveit" id="checkbox_dump_onserver"{{ is_checked_export ? ' checked' }}>
              <label for="checkbox_dump_onserver">
                {{ 'Save on server in the directory <strong>%s</strong>'|trans|format(save_dir|e)|raw }}
              </label>
            </li>
            <li>
              <input type="checkbox" name="onserver_overwrite" value="saveitover" id="checkbox_dump_onserver_overwrite"
                {{- is_checked_export_overwrite ? ' checked' }}>
              <label for="checkbox_dump_onserver_overwrite">
                {% trans 'Overwrite existing file(s)' %}
              </label>
            </li>
          {% endif %}

          <li>
            <label for="filename_template" class="desc">
              {% trans 'File name template:' %}
              {{ show_hint('This value is interpreted using the \'strftime\' function, so you can use time formatting strings. Additionally the following transformations will happen: %s Other text will be kept as is. See the FAQ 6.27 for details.'|trans|format(filename_hint)) }}
            </label>
            <input type="text" name="filename_template" id="filename_template" value="{{ filename_template }}">
            <input type="checkbox" name="remember_template" id="checkbox_remember_template"{{ is_checked_remember_file_template ? ' checked' }}>
            <label for="checkbox_remember_template">
              {% trans 'use this for future exports' %}
            </label>
          </li>

          {% if is_encoding_supported %}
            <li>
              <label for="select_charset" class="desc">
                {% trans 'Character set of the file:' %}
              </label>
              <select id="select_charset" name="charset" size="1">
                {% for charset in encodings %}
                  <option value="{{ charset }}"
                    {{- (export_charset is empty and charset == 'utf-8') or charset == export_charset ? ' selected' }}>
                    {{- charset -}}
                  </option>
                {% endfor %}
              </select>
            </li>
          {% endif %}

          {% if has_zip or has_gzip %}
            <li>
              <label for="compression" class="desc">
                {% trans 'Compression:' %}
              </label>
              <select id="compression" name="compression">
                <option value="none">{% trans 'None' %}</option>
                {% if has_zip %}
                  <option value="zip"
                    {{- selected_compression == 'zip' ? ' selected' }}>
                    {% trans 'zipped' %}
                  </option>
                {% endif %}
                {% if has_gzip %}
                  <option value="gzip"
                    {{- selected_compression == 'gzip' ? ' selected' }}>
                    {% trans 'gzipped' %}
                  </option>
                {% endif %}
              </select>
            </li>
          {% else %}
            <input type="hidden" name="compression" value="{{ selected_compression }}">
          {% endif %}

          {% if export_type == 'server' or export_type == 'database' %}
            <li>
              <input type="checkbox" id="checkbox_as_separate_files" name="as_separate_files" value="{{ export_type }}"
                {{- is_checked_as_separate_files ? ' checked' }}>
              <label for="checkbox_as_separate_files">
                {% if export_type == 'server' %}
                  {% trans 'Export databases as separate files' %}
                {% elseif export_type == 'database' %}
                  {% trans 'Export tables as separate files' %}
                {% endif %}
              </label>
            </li>
          {% endif %}
        </ul>
      </li>

      <li>
        <input type="radio" id="radio_view_as_text" name="output_format" value="astext"
          {{- repopulate or export_asfile == false ? ' checked' }}>
        <label for="radio_view_as_text">
          {% trans 'View output as text' %}
        </label>
      </li>
    </ul>

    <label for="maxsize">
      {{- 'Skip tables larger than %s MiB'|trans|format(
        '</label><input type="text" id="maxsize" name="maxsize" size="4">'
      )|raw }}
  </div>

  <div class="exportoptions" id="format_specific_opts">
    <h3>{% trans 'Format-specific options:' %}</h3>
    <p class="no_js_msg" id="scroll_to_options_msg">
      {% trans 'Scroll down to fill in the options for the selected format and ignore the options for other formats.' %}
    </p>
    {{ options|raw }}
  </div>

  {% if can_convert_kanji %}
    {# Japanese encoding setting #}
    <div class="exportoptions" id="kanji_encoding">
      <h3>{% trans 'Encoding Conversion:' %}</h3>
      {% include 'encoding/kanji_encoding_form.twig' %}
    </div>
  {% endif %}

  <div class="exportoptions justify-content-end" id="submit">
    <input id="buttonGo" class="btn btn-primary" type="submit" value="{% trans 'Go' %}" data-exec-time-limit="{{ exec_time_limit }}">
  </div>
</form>