aboutsummaryrefslogtreecommitdiff
path: root/srcs/phpmyadmin/templates/table/relation/common_form.twig
diff options
context:
space:
mode:
authorCharles Cabergs <me@cacharle.xyz>2020-07-27 10:05:23 +0200
committerCharles Cabergs <me@cacharle.xyz>2020-07-27 10:05:23 +0200
commit5bf66662a9bdd62c5bccab15e607cd95cfb8fcab (patch)
tree39a1a4629749056191c05dfd899f931701b7acf3 /srcs/phpmyadmin/templates/table/relation/common_form.twig
parent5afd237bbd22028b85532b8c0b3fcead49a00764 (diff)
downloadft_server-master.tar.gz
ft_server-master.tar.bz2
ft_server-master.zip
Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my famillyHEADmaster
Diffstat (limited to 'srcs/phpmyadmin/templates/table/relation/common_form.twig')
-rw-r--r--srcs/phpmyadmin/templates/table/relation/common_form.twig223
1 files changed, 0 insertions, 223 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 %}