diff options
Diffstat (limited to 'srcs/phpmyadmin/templates/table/relation')
4 files changed, 0 insertions, 386 deletions
diff --git a/srcs/phpmyadmin/templates/table/relation/common_form.twig b/srcs/phpmyadmin/templates/table/relation/common_form.twig deleted file mode 100644 index e85c6ce..0000000 --- a/srcs/phpmyadmin/templates/table/relation/common_form.twig +++ /dev/null @@ -1,223 +0,0 @@ -{% extends 'table/page_with_secondary_tabs.twig' %} - -{% block content %} -<form method="post" action="tbl_relation.php"> - {{ get_hidden_inputs(db, table) }} - {# InnoDB #} - {% if is_foreign_key_supported(tbl_storage_engine) %} - <fieldset> - <legend>{% trans 'Foreign key constraints' %}</legend> - <div class="responsivetable jsresponsive"> - <table id="foreign_keys" class="relationalTable"> - <thead><tr> - <th>{% trans 'Actions' %}</th> - <th>{% trans 'Constraint properties' %}</th> - {% if tbl_storage_engine|upper == 'INNODB' %} - <th> - {% trans 'Column' %} - {{ show_hint('Creating a foreign key over a non-indexed column would automatically create an index on it. Alternatively, you can define an index below, before creating the foreign key.'|trans) }} - </th> - {% else %} - <th> - {% trans 'Column' %} - {{ show_hint('Only columns with index will be displayed. You can define an index below.'|trans) }} - </th> - {% endif %} - <th colspan="3"> - {% trans 'Foreign key constraint' %} - ({{ tbl_storage_engine }}) - </th> - </tr> - <tr> - <th></th> - <th></th> - <th></th> - <th>{% trans 'Database' %}</th> - <th>{% trans 'Table' %}</th> - <th>{% trans 'Column' %}</th> - </tr></thead> - {% set i = 0 %} - {% if existrel_foreign is not empty %} - {% for key, one_key in existrel_foreign %} - {# Foreign database dropdown #} - {% set foreign_db = one_key['ref_db_name'] is defined - and one_key['ref_db_name'] is not null - ? one_key['ref_db_name'] : db %} - {% set foreign_table = false %} - {% if foreign_db %} - {% set foreign_table = one_key['ref_table_name'] is defined - and one_key['ref_table_name'] is not null - ? one_key['ref_table_name'] : false %} - {% endif %} - {% set unique_columns = [] %} - {% if foreign_db and foreign_table %} - {% set table_obj = table_get(foreign_table, foreign_db) %} - {% set unique_columns = table_obj.getUniqueColumns(false, false) %} - {% endif %} - {% include 'table/relation/foreign_key_row.twig' with { - 'i': i, - 'one_key': one_key, - 'column_array': column_array, - 'options_array': options_array, - 'tbl_storage_engine': tbl_storage_engine, - 'db': db, - 'table': table, - 'url_params': url_params, - 'databases': databases, - 'foreign_db': foreign_db, - 'foreign_table': foreign_table, - 'unique_columns': unique_columns - } only %} - {% set i = i + 1 %} - {% endfor %} - {% endif %} - {% include 'table/relation/foreign_key_row.twig' with { - 'i': i, - 'one_key': [], - 'column_array': column_array, - 'options_array': options_array, - 'tbl_storage_engine': tbl_storage_engine, - 'db': db, - 'table': table, - 'url_params': url_params, - 'databases': databases, - 'foreign_db': foreign_db, - 'foreign_table': foreign_table, - 'unique_columns': unique_columns - } only %} - {% set i = i + 1 %} - <tr> - <th colspan="6"> - <a class="formelement clearfloat add_foreign_key" href=""> - {% trans '+ Add constraint' %} - </a> - </th> - </tr> - </table> - </div> - </fieldset> - {% endif %} - - {% if cfg_relation['relwork'] %} - {% if is_foreign_key_supported(tbl_storage_engine) %} - {% include 'div_for_slider_effect.twig' with { - 'id': 'ir_div', - 'message': 'Internal relationships'|trans, - 'initial_sliders_state': default_sliders_state - } only %} - {% endif %} - - <fieldset> - <legend> - {% trans 'Internal relationships' %} - {{ show_docu('config', 'cfg_Servers_relation') }} - </legend> - <table id="internal_relations" class="relationalTable"> - <tr> - <th>{% trans 'Column' %}</th> - <th>{% trans 'Internal relation' %} - {% if is_foreign_key_supported(tbl_storage_engine) %} - {{ show_hint('An internal relation is not necessary when a corresponding FOREIGN KEY relation exists.'|trans) }} - {% endif %} - </th> - {% set saved_row_cnt = save_row|length - 1 %} - {% for i in 0..saved_row_cnt %} - {% set myfield = save_row[i]['Field'] %} - {# Use an md5 as array index to avoid having special characters - in the name attribute (see bug #1746964 ) #} - {% set myfield_md5 = column_hash_array[myfield] %} - - {% set foreign_table = false %} - {% set foreign_column = false %} - - {# Database dropdown #} - {% if existrel[myfield] is defined %} - {% set foreign_db = existrel[myfield]['foreign_db'] %} - {% else %} - {% set foreign_db = db %} - {% endif %} - - {# Table dropdown #} - {% set tables = [] %} - {% if foreign_db %} - {% if existrel[myfield] is defined %} - {% set foreign_table = existrel[myfield]['foreign_table'] %} - {% endif %} - {% set tables = dbi.getTables(foreign_db) %} - {% endif %} - - {# Column dropdown #} - {% set unique_columns = [] %} - {% if foreign_db and foreign_table %} - {% if existrel[myfield] is defined %} - {% set foreign_column = existrel[myfield]['foreign_field'] %} - {% endif %} - {% set table_obj = table_get(foreign_table, foreign_db) %} - {% set unique_columns = table_obj.getUniqueColumns(false, false) %} - {% endif %} - - <tr> - <td class="vmiddle"> - <strong>{{ myfield }}</strong> - <input type="hidden" name="fields_name[{{ myfield_md5 }}]" - value="{{ myfield }}"> - </td> - - <td> - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_db[' ~ myfield_md5 ~ ']', - 'title': 'Database'|trans, - 'values': databases, - 'foreign': foreign_db - } only %} - - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_table[' ~ myfield_md5 ~ ']', - 'title': 'Table'|trans, - 'values': tables, - 'foreign': foreign_table - } only %} - - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_column[' ~ myfield_md5 ~ ']', - 'title': 'Column'|trans, - 'values': unique_columns, - 'foreign': foreign_column - } only %} - </td> - </tr> - {% endfor %} - </table> - </fieldset> - {% if is_foreign_key_supported(tbl_storage_engine) %} - </div> - {% endif %} - {% endif %} - - {% if cfg_relation['displaywork'] %} - {% set disp = get_display_field(db, table) %} - <fieldset> - <label>{% trans 'Choose column to display:' %}</label> - <select name="display_field"> - <option value="">---</option> - {% for row in save_row %} - <option value="{{ row['Field'] }}" - {%- if disp is defined and row['Field'] == disp %} - selected="selected" - {%- endif %}> - {{ row['Field'] }} - </option> - {% endfor %} - </select> - </fieldset> - {% endif %} - - <fieldset class="tblFooters"> - <input class="btn btn-secondary preview_sql" type="button" value="{% trans 'Preview SQL' %}"> - <input class="btn btn-primary" type="submit" value="{% trans 'Save' %}"> - </fieldset> -</form> -{% if foreignKeySupported %} - {{ displayIndexesHtml|raw }} -{% endif %} -{% endblock %} diff --git a/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig b/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig deleted file mode 100644 index ff179bc..0000000 --- a/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig +++ /dev/null @@ -1,9 +0,0 @@ -{{ dropdown_question is not empty ? dropdown_question -}} -<select name="{{ select_name }}"> -{% for one_value, one_label in choices %} - <option value="{{ one_value }}" - {%- if selected_value == one_value %} selected="selected"{% endif %}> - {{ one_label }} - </option> -{% endfor %} -</select> diff --git a/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig b/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig deleted file mode 100644 index 3df6c34..0000000 --- a/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig +++ /dev/null @@ -1,136 +0,0 @@ -<tr> - {# Drop key anchor #} - <td> - {% set js_msg = '' %} - {% set this_params = null %} - {% if one_key['constraint'] is defined %} - {% set drop_fk_query = 'ALTER TABLE ' ~ backquote(db) ~ '.' ~ backquote(table) - ~ ' DROP FOREIGN KEY ' - ~ backquote(one_key['constraint']) ~ ';' - %} - {% set this_params = url_params %} - {% set this_params = { - 'goto': 'tbl_relation.php', - 'back': 'tbl_relation.php', - 'sql_query': drop_fk_query, - 'message_to_show': 'Foreign key constraint %s has been dropped'|trans|format( - one_key['constraint'] - ) - } %} - {% set js_msg = 'ALTER TABLE ' ~ db ~ '.' ~ table ~ ' DROP FOREIGN KEY ' ~ one_key['constraint'] ~ ';'|js_format %} - {% endif %} - {% if one_key['constraint'] is defined %} - <input type="hidden" class="drop_foreign_key_msg" value=" - {{- js_msg }}"> - {% set drop_url = 'sql.php' ~ get_common(this_params) %} - {% set drop_str = get_icon('b_drop', 'Drop'|trans) %} - {{ link_or_button(drop_url, drop_str, {'class': 'drop_foreign_key_anchor ajax'}) }} - {% endif %} - </td> - <td> - <span class="formelement clearfloat"> - <input type="text" name="constraint_name[{{ i }}]" value=" - {{- one_key['constraint'] is defined ? one_key['constraint'] -}} - " placeholder="{% trans 'Constraint name' %}" maxlength="64"> - </span> - <div class="floatleft"> - {# For ON DELETE and ON UPDATE, the default action - is RESTRICT as per MySQL doc; however, a SHOW CREATE TABLE - won't display the clause if it's set as RESTRICT. #} - {% set on_delete = one_key['on_delete'] is defined - ? one_key['on_delete'] : 'RESTRICT' %} - {% set on_update = one_key['on_update'] is defined - ? one_key['on_update'] : 'RESTRICT' %} - <span class="formelement"> - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': 'ON DELETE', - 'select_name': 'on_delete[' ~ i ~ ']', - 'choices': options_array, - 'selected_value': on_delete - } only %} - </span> - <span class="formelement"> - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': 'ON UPDATE', - 'select_name': 'on_update[' ~ i ~ ']', - 'choices': options_array, - 'selected_value': on_update - } only %} - </span> - </div> - </td> - <td> - {% if one_key['index_list'] is defined %} - {% for key, column in one_key['index_list'] %} - <span class="formelement clearfloat"> - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': '', - 'select_name': 'foreign_key_fields_name[' ~ i ~ '][]', - 'choices': column_array, - 'selected_value': column - } only %} - </span> - {% endfor %} - {% else %} - <span class="formelement clearfloat"> - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': '', - 'select_name': 'foreign_key_fields_name[' ~ i ~ '][]', - 'choices': column_array, - 'selected_value': '' - } only %} - </span> - {% endif %} - <a class="formelement clearfloat add_foreign_key_field" data-index=" - {{- i }}" href=""> - {% trans '+ Add column' %} - </a> - </td> - {% set tables = [] %} - {% if foreign_db %} - {% set tables = get_tables(foreign_db, tbl_storage_engine) %} - {% endif %} - <td> - <span class="formelement clearfloat"> - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_db[' ~ i ~ ']', - 'title': 'Database'|trans, - 'values': databases, - 'foreign': foreign_db - } only %} - </span> - </td> - <td> - <span class="formelement clearfloat"> - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_table[' ~ i ~ ']', - 'title': 'Table'|trans, - 'values': tables, - 'foreign': foreign_table - } only %} - </span> - </td> - <td> - {% if foreign_db and foreign_table %} - {% for foreign_column in one_key['ref_index_list'] %} - <span class="formelement clearfloat"> - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_column[' ~ i ~ '][]', - 'title': 'Column'|trans, - 'values': unique_columns, - 'foreign': foreign_column - } only %} - </span> - {% endfor %} - {% else %} - <span class="formelement clearfloat"> - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_column[' ~ i ~ '][]', - 'title': 'Column'|trans, - 'values': [], - 'foreign': '' - } only %} - </span> - {% endif %} - </td> -</tr> diff --git a/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig b/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig deleted file mode 100644 index 9d5f3c9..0000000 --- a/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig +++ /dev/null @@ -1,18 +0,0 @@ -<select name="{{ name }}" title="{{ title }}"> - <option value=""></option> - {% set seen_key = false %} - {% for value in values %} - <option value="{{ value }}" - {%- if foreign is not same as(false) and value == foreign %} - selected="selected" - {%- set seen_key = true -%} - {%- endif %}> - {{ value }} - </option> - {% endfor %} - {% if foreign is not same as(false) and not seen_key %} - <option value="{{ foreign }}" selected="selected"> - {{ foreign }} - </option> - {% endif %} -</select> |