diff options
Diffstat (limited to 'srcs/phpmyadmin/templates/database/designer')
6 files changed, 0 insertions, 1295 deletions
diff --git a/srcs/phpmyadmin/templates/database/designer/database_tables.twig b/srcs/phpmyadmin/templates/database/designer/database_tables.twig deleted file mode 100644 index 5453bb5..0000000 --- a/srcs/phpmyadmin/templates/database/designer/database_tables.twig +++ /dev/null @@ -1,121 +0,0 @@ -{% for designerTable in tables %} - {% set i = loop.index0 %} - {% set t_n_url = designerTable.getDbTableString()|escape('url') %} - {% set db = designerTable.getDatabaseName() %} - {% set db_url = db|escape('url') %} - {% set t_n = designerTable.getDbTableString() %} - {% set table_name = designerTable.getTableName()|escape('html') %} - <input name="t_x[{{ t_n_url }}]" type="hidden" id="t_x_{{ t_n_url }}_" /> - <input name="t_y[{{ t_n_url }}]" type="hidden" id="t_y_{{ t_n_url }}_" /> - <input name="t_v[{{ t_n_url }}]" type="hidden" id="t_v_{{ t_n_url }}_" /> - <input name="t_h[{{ t_n_url }}]" type="hidden" id="t_h_{{ t_n_url }}_" /> - <table id="{{ t_n_url }}" - db_url="{{ designerTable.getDatabaseName()|escape('url') }}" - table_name_url="{{ designerTable.getTableName()|escape('url') }}" - cellpadding="0" - cellspacing="0" - class="designer_tab" - style="position:absolute; left: - {{- tab_pos[t_n] is defined ? tab_pos[t_n]['X'] : random(range(20, 700)) }}px; top: - {{- tab_pos[t_n] is defined ? tab_pos[t_n]['Y'] : random(range(20, 550)) }}px; display: - {{- tab_pos[t_n] is defined or display_page == -1 ? 'block' : 'none' }}; z-index: 1;"> <!--"--> - <thead> - <tr class="header"> - {% if has_query %} - <td class="select_all"> - <input class="select_all_1" - type="checkbox" - style="margin: 0;" - value="select_all_{{ t_n_url }}" - id="select_all_{{ i }}" - title="{% trans 'Select all' %}" - table_name="{{ table_name }}" - db_name="{{ db }}"> - </td> - {% endif %} - <td class="small_tab" - title="{% trans 'Show/hide columns' %}" - id="id_hide_tbody_{{ t_n_url }}" - table_name="{{ t_n_url }}">{{ tab_pos[t_n] is not defined or tab_pos[t_n]['V'] is not empty ? 'v' : '>' }}</td> - <td class="small_tab_pref small_tab_pref_1" - db="{{ designerTable.getDatabaseName() }}" - db_url="{{ designerTable.getDatabaseName()|escape('url') }}" - table_name="{{ designerTable.getTableName() }}" - table_name_url="{{ designerTable.getTableName()|escape('url') }}"> - <img src="{{ theme.getImgPath('designer/exec_small.png') }}" - title="{% trans 'See table structure' %}"> - </td> - <td id="id_zag_{{ t_n_url }}" - class="tab_zag nowrap tab_zag_noquery" - table_name="{{ t_n_url }}" - query_set="{{ has_query ? 1 : 0 }}"> - <span class="owner">{{ designerTable.getDatabaseName() }}</span> - {{ designerTable.getTableName() }} - </td> - {% if has_query %} - <td class="tab_zag tab_zag_query" - id="id_zag_{{ t_n_url }}_2" - table_name="{{ t_n_url }}"> - </td> - {% endif %} - </tr> - </thead> - <tbody id="id_tbody_{{ t_n_url }}" - {{- tab_pos[t_n] is defined and tab_pos[t_n]['V'] is empty ? ' style="display: none"' }}> - {% set display_field = designerTable.getDisplayField() %} - {% for j in 0..tab_column[t_n]['COLUMN_ID']|length - 1 %} - {% set col_name = tab_column[t_n]['COLUMN_NAME'][j] %} - {% set tmp_column = t_n ~ '.' ~ tab_column[t_n]['COLUMN_NAME'][j] %} - {% set click_field_param = [ - designerTable.getTableName()|escape('url'), - tab_column[t_n]['COLUMN_NAME'][j]|url_encode - ] %} - {% if not designerTable.supportsForeignkeys() %} - {% set click_field_param = click_field_param|merge([tables_pk_or_unique_keys[tmp_column] is defined ? 1 : 0]) %} - {% else %} - {# if foreign keys are supported, it's not necessary that the - index is a primary key #} - {% set click_field_param = click_field_param|merge([tables_all_keys[tmp_column] is defined ? 1 : 0]) %} - {% endif %} - {% set click_field_param = click_field_param|merge([db]) %} - <tr id="id_tr_{{ designerTable.getTableName()|escape('url') }}.{{ tab_column[t_n]['COLUMN_NAME'][j] }}" class="tab_field - {{- display_field == tab_column[t_n]['COLUMN_NAME'][j] ? '_3' }}" click_field_param=" - {{- click_field_param|join(',') }}"> - {% if has_query %} - <td class="select_all"> - <input class="select_all_store_col" - value="{{ t_n_url }}{{ tab_column[t_n]['COLUMN_NAME'][j]|url_encode }}" - type="checkbox" - id="select_{{ t_n_url }}._{{ tab_column[t_n]['COLUMN_NAME'][j]|url_encode }}" - style="margin: 0;" - title="{{ 'Select "%s"'|trans|format(col_name) }}" - id_check_all="select_all_{{ i }}" - db_name="{{ db }}" - table_name="{{ table_name }}" - col_name="{{ col_name }}"> - </td> - {% endif %} - <td width="10px" colspan="3" id="{{ t_n_url }}. - {{- tab_column[t_n]['COLUMN_NAME'][j]|url_encode }}"> - <div class="nowrap"> - {% set type = columns_type[t_n ~ '.' ~ tab_column[t_n]['COLUMN_NAME'][j]] %} - <img src="{{ theme.getImgPath(type) }}.png" alt="*"> - {{ tab_column[t_n]['COLUMN_NAME'][j] }} : {{ tab_column[t_n]['TYPE'][j] }} - </div> - </td> - {% if has_query %} - <td class="small_tab_pref small_tab_pref_click_opt" - {# Escaped 2 times to be able to use it in innerHtml #} - option_col_name_modal="<strong>{{ 'Add an option for column "%s".'|trans|format(col_name)|escape('html')|escape('html') }}</strong>" - db_name="{{ db }}" - table_name="{{ table_name }}" - col_name="{{ col_name }}" - db_table_name_url="{{ t_n_url }}"> - <img src="{{ theme.getImgPath('designer/exec_small.png') }}" title="{% trans 'Options' %}" /> - </td> - {% endif %} - </tr> - {% endfor %} - </tbody> - </table> -{% endfor %} diff --git a/srcs/phpmyadmin/templates/database/designer/edit_delete_pages.twig b/srcs/phpmyadmin/templates/database/designer/edit_delete_pages.twig deleted file mode 100644 index 75d1a1a..0000000 --- a/srcs/phpmyadmin/templates/database/designer/edit_delete_pages.twig +++ /dev/null @@ -1,13 +0,0 @@ -<form action="db_designer.php" method="post" name="edit_delete_pages" id="edit_delete_pages" class="ajax"> - {{ get_hidden_inputs(db) }} - <fieldset id="page_edit_delete_options"> - <input type="hidden" name="operation" value="{{ operation }}"> - <label for="selected_page"> - {{ operation == 'editPage' ? 'Page to open'|trans : 'Page to delete'|trans }}: - </label> - {% include 'database/designer/page_selector.twig' with { - 'pdfwork': pdfwork, - 'pages': pages - } only %} - </fieldset> -</form> diff --git a/srcs/phpmyadmin/templates/database/designer/main.twig b/srcs/phpmyadmin/templates/database/designer/main.twig deleted file mode 100644 index f971dc5..0000000 --- a/srcs/phpmyadmin/templates/database/designer/main.twig +++ /dev/null @@ -1,1105 +0,0 @@ -{# Invisible characters will make javascript crash #} -{% apply spaceless %} -<script type="text/javascript"> -var designerConfig = {{ designer_config|raw }}; -</script> -{% endapply %} - -{# side menu #} -{% if not has_query %} - <div id="name-panel"> - <span id="page_name"> - {{ selected_page == null ? 'Untitled'|trans : selected_page }} - </span> - <span id="saved_state"> - {{ selected_page == null ? '*' : '' }} - </span> - </div> -{% endif %} -<div class="designer_header side-menu" id="side_menu"> - <a class="M_butt" id="key_Show_left_menu" href="#"> - <img title="{% trans 'Show/Hide tables list' %}" - alt="v" - src="{{ theme.getImgPath('designer/downarrow2_m.png') }}" - data-down="{{ theme.getImgPath('designer/downarrow2_m.png') }}" - data-up="{{ theme.getImgPath('designer/uparrow2_m.png') }}"> - <span class="hide hidable"> - {% trans 'Show/Hide tables list' %} - </span> - </a> - <a href="#" id="toggleFullscreen" class="M_butt"> - <img title="{% trans 'View in fullscreen' %}" - src="{{ theme.getImgPath('designer/viewInFullscreen.png') }}" - data-enter="{{ theme.getImgPath('designer/viewInFullscreen.png') }}" - data-exit="{{ theme.getImgPath('designer/exitFullscreen.png') }}"> - <span class="hide hidable" - data-exit="{% trans 'Exit fullscreen' %}" - data-enter="{% trans 'View in fullscreen' %}"> - {% trans 'View in fullscreen' %} - </span> - </a> - <a href="#" id="addOtherDbTables" class="M_butt"> - <img title="{% trans 'Add tables from other databases' %}" - src="{{ theme.getImgPath('designer/other_table.png') }}"> - <span class="hide hidable"> - {% trans 'Add tables from other databases' %} - </span> - </a> - {% if not has_query %} - <a id="newPage" href="#" class="M_butt"> - <img title="{% trans 'New page' %}" - alt="" - src="{{ theme.getImgPath('designer/page_add.png') }}"> - <span class="hide hidable"> - {% trans 'New page' %} - </span> - </a> - <a href="#" id="editPage" class="M_butt ajax"> - <img title="{% trans 'Open page' %}" - src="{{ theme.getImgPath('designer/page_edit.png') }}"> - <span class="hide hidable"> - {% trans 'Open page' %} - </span> - </a> - <a href="#" id="savePos" class="M_butt"> - <img title="{% trans 'Save page' %}" - src="{{ theme.getImgPath('designer/save.png') }}"> - <span class="hide hidable"> - {% trans 'Save page' %} - </span> - </a> - <a href="#" id="SaveAs" class="M_butt ajax"> - <img title="{% trans 'Save page as' %}" - src="{{ theme.getImgPath('designer/save_as.png') }}"> - <span class="hide hidable"> - {% trans 'Save page as' %} - </span> - </a> - <a href="#" id="delPages" class="M_butt ajax"> - <img title="{% trans 'Delete pages' %}" - src="{{ theme.getImgPath('designer/page_delete.png') }}"> - <span class="hide hidable"> - {% trans 'Delete pages' %} - </span> - </a> - <a href="#" id="StartTableNew" class="M_butt"> - <img title="{% trans 'Create table' %}" - src="{{ theme.getImgPath('designer/table.png') }}"> - <span class="hide hidable"> - {% trans 'Create table' %} - </span> - </a> - <a href="#" class="M_butt" id="rel_button"> - <img title="{% trans 'Create relationship' %}" - src="{{ theme.getImgPath('designer/relation.png') }}"> - <span class="hide hidable"> - {% trans 'Create relationship' %} - </span> - </a> - <a href="#" class="M_butt" id="display_field_button"> - <img title="{% trans 'Choose column to display' %}" - src="{{ theme.getImgPath('designer/display_field.png') }}"> - <span class="hide hidable"> - {% trans 'Choose column to display' %} - </span> - </a> - <a href="#" id="reloadPage" class="M_butt"> - <img title="{% trans 'Reload' %}" - src="{{ theme.getImgPath('designer/reload.png') }}"> - <span class="hide hidable"> - {% trans 'Reload' %} - </span> - </a> - <a href="{{ get_docu_link('faq', 'faq6-31') }}" - target="documentation" - class="M_butt"> - <img title="{% trans 'Help' %}" - src="{{ theme.getImgPath('designer/help.png') }}"> - <span class="hide hidable"> - {% trans 'Help' %} - </span> - </a> - {% endif %} - <a href="#" class="{{ params_array['angular_direct'] }}" id="angular_direct_button"> - <img title="{% trans 'Angular links' %} / {% trans 'Direct links' %}" - src="{{ theme.getImgPath('designer/ang_direct.png') }}"> - <span class="hide hidable"> - {% trans 'Angular links' %} / {% trans 'Direct links' %} - </span> - </a> - <a href="#" class="{{ params_array['snap_to_grid'] }}" id="grid_button"> - <img title="{% trans 'Snap to grid' %}" src="{{ theme.getImgPath('designer/grid.png') }}"> - <span class="hide hidable"> - {% trans 'Snap to grid' %} - </span> - </a> - <a href="#" class="{{ params_array['small_big_all'] }}" id="key_SB_all"> - <img title="{% trans 'Small/Big All' %}" - alt="v" - src="{{ theme.getImgPath('designer/downarrow1.png') }}" - data-down="{{ theme.getImgPath('designer/downarrow1.png') }}" - data-right="{{ theme.getImgPath('designer/rightarrow1.png') }}"> - <span class="hide hidable"> - {% trans 'Small/Big All' %} - </span> - </a> - <a href="#" id="SmallTabInvert" class="M_butt"> - <img title="{% trans 'Toggle small/big' %}" - src="{{ theme.getImgPath('designer/bottom.png') }}"> - <span class="hide hidable"> - {% trans 'Toggle small/big' %} - </span> - </a> - <a href="#" id="relLineInvert" class="{{ params_array['relation_lines'] }}" > - <img title="{% trans 'Toggle relationship lines' %}" - src="{{ theme.getImgPath('designer/toggle_lines.png') }}"> - <span class="hide hidable"> - {% trans 'Toggle relationship lines' %} - </span> - </a> - {% if not visual_builder %} - <a href="#" id="exportPages" class="M_butt" > - <img title="{% trans 'Export schema' %}" - src="{{ theme.getImgPath('designer/export.png') }}"> - <span class="hide hidable"> - {% trans 'Export schema' %} - </span> - </a> - {% else %} - <a id="build_query_button" - class="M_butt" - href="#" - class="M_butt"> - <img title="{% trans 'Build Query' %}" - src="{{ theme.getImgPath('designer/query_builder.png') }}"> - <span class="hide hidable"> - {% trans 'Build Query' %} - </span> - </a> - {% endif %} - <a href="#" class="{{ params_array['side_menu'] }}" id="key_Left_Right"> - <img title="{% trans 'Move Menu' %}" alt=">" - data-right="{{ theme.getImgPath('designer/2leftarrow_m.png') }}" - src="{{ theme.getImgPath('designer/2rightarrow_m.png') }}"> - <span class="hide hidable"> - {% trans 'Move Menu' %} - </span> - </a> - <a href="#" class="{{ params_array['pin_text'] }}" id="pin_Text"> - <img title="{% trans 'Pin text' %}" - alt=">" - data-right="{{ theme.getImgPath('designer/anchor.png') }}" - src="{{ theme.getImgPath('designer/anchor.png') }}"> - <span class="hide hidable"> - {% trans 'Pin text' %} - </span> - </a> -</div> -<div id="canvas_outer"> - <form action="" id="container-form" method="post" name="form1"> - <div id="osn_tab"> - <canvas class="designer" id="canvas" width="100" height="100"></canvas> - </div> - <div id="layer_menu" class="hide"> - <div class="center"> - <a href="#" class="M_butt" target="_self" > - <img title="{% trans 'Hide/Show all' %}" - alt="v" - id="key_HS_all" - src="{{ theme.getImgPath('designer/downarrow1.png') }}" - data-down="{{ theme.getImgPath('designer/downarrow1.png') }}" - data-right="{{ theme.getImgPath('designer/rightarrow1.png') }}"> - </a> - <a href="#" class="M_butt" target="_self" > - <img alt="v" - id="key_HS" - title="{% trans 'Hide/Show tables with no relationship' %}" - src="{{ theme.getImgPath('designer/downarrow2.png') }}" - data-down="{{ theme.getImgPath('designer/downarrow2.png') }}" - data-right="{{ theme.getImgPath('designer/rightarrow2.png') }}"> - </a> - </div> - <div id="id_scroll_tab" class="scroll_tab"> - <table width="100%" style="padding-left: 3px;"></table> - </div> - {# end id_scroll_tab #} - <div class="center"> - {% trans 'Number of tables:' %} <span id="tables_counter">0</span> - </div> - <div id="layer_menu_sizer"> - <div class="floatleft"> - <img class="icon" - data-right="{{ theme.getImgPath('designer/resizeright.png') }}" - src="{{ theme.getImgPath('designer/resize.png') }}"> - </div> - </div> - </div> - {# end layer_menu #} - {% include 'database/designer/database_tables.twig' with { - 'db': db, - 'get_db': get_db, - 'has_query': has_query, - 'tab_pos': tab_pos, - 'display_page': display_page, - 'tab_column': tab_column, - 'tables_all_keys': tables_all_keys, - 'tables_pk_or_unique_keys': tables_pk_or_unique_keys, - 'columns_type': columns_type, - 'tables': designerTables, - 'theme': theme, - } only %} - </form> -</div> -<div id="designer_hint"></div> -{# create relation pane #} -<table id="layer_new_relation" class="hide" width="5%" cellpadding="0" cellspacing="0"> - <tbody> - <tr> - <td class="frams1" width="10px"> - </td> - <td class="frams5" width="99%" > - </td> - <td class="frams2" width="10px"> - <div class="bor"> - </div> - </td> - </tr> - <tr> - <td class="frams8"> - </td> - <td class="input_tab"> - <table width="168" class="center" cellpadding="2" cellspacing="0"> - <thead> - <tr> - <td colspan="2" class="center nowrap"> - <strong> - {% trans 'Create relationship' %} - </strong> - </td> - </tr> - </thead> - <tbody id="foreign_relation"> - <tr> - <td colspan="2" class="center nowrap"> - <strong> - FOREIGN KEY - </strong> - </td> - </tr> - <tr> - <td width="58" class="nowrap"> - on delete - </td> - <td width="102"> - <select name="on_delete" id="on_delete"> - <option value="nix" selected="selected"> - -- - </option> - <option value="CASCADE"> - CASCADE - </option> - <option value="SET NULL"> - SET NULL - </option> - <option value="NO ACTION"> - NO ACTION - </option> - <option value="RESTRICT"> - RESTRICT - </option> - </select> - </td> - </tr> - <tr> - <td class="nowrap"> - on update - </td> - <td> - <select name="on_update" id="on_update"> - <option value="nix" selected="selected"> - -- - </option> - <option value="CASCADE"> - CASCADE - </option> - <option value="SET NULL"> - SET NULL - </option> - <option value="NO ACTION"> - NO ACTION - </option> - <option value="RESTRICT"> - RESTRICT - </option> - </select> - </td> - </tr> - </tbody> - <tbody> - <tr> - <td colspan="2" class="center nowrap"> - <input type="button" id="ok_new_rel_panel" class="btn btn-secondary butt" - name="Button" value="{% trans 'OK' %}"> - <input type="button" id="cancel_new_rel_panel" - class="btn btn-secondary butt" name="Button" value="{% trans 'Cancel' %}"> - </td> - </tr> - </tbody> - </table> - </td> - <td class="frams6"> - </td> - </tr> - <tr> - <td class="frams4"> - <div class="bor"> - </div> - </td> - <td class="frams7"> - </td> - <td class="frams3"> - </td> - </tr> - </tbody> -</table> -{# delete relation pane #} -<table id="layer_upd_relation" class="hide" width="5%" cellpadding="0" cellspacing="0"> - <tbody> - <tr> - <td class="frams1" width="10px"> - </td> - <td class="frams5" width="99%"> - </td> - <td class="frams2" width="10px"> - <div class="bor"> - </div> - </td> - </tr> - <tr> - <td class="frams8"> - </td> - <td class="input_tab"> - <table width="100%" class="center" cellpadding="2" cellspacing="0"> - <tr> - <td colspan="3" class="center nowrap"> - <strong> - {% trans 'Delete relationship' %} - </strong> - </td> - </tr> - <tr> - <td colspan="3" class="center nowrap"> - <input id="del_button" name="Button" type="button" - class="btn btn-secondary butt" value="{% trans 'Delete' %}"> - <input id="cancel_button" type="button" class="btn btn-secondary butt" - name="Button" value="{% trans 'Cancel' %}"> - </td> - </tr> - </table> - </td> - <td class="frams6"> - </td> - </tr> - <tr> - <td class="frams4"> - <div class="bor"> - </div> - </td> - <td class="frams7"> - </td> - <td class="frams3"> - </td> - </tr> - </tbody> -</table> -{% if has_query %} - {# options pane #} - <table id="designer_optionse" class="hide" width="5%" cellpadding="0" cellspacing="0"> - <tbody> - <tr> - <td class="frams1" width="10px"> - </td> - <td class="frams5" width="99%" > - </td> - <td class="frams2" width="10px"> - <div class="bor"> - </div> - </td> - </tr> - <tr> - <td class="frams8"> - </td> - <td class="input_tab"> - <table width="168" class="center" cellpadding="2" cellspacing="0"> - <thead> - <tr> - <td colspan="2" rowspan="2" id="option_col_name" class="center nowrap"> - </td> - </tr> - </thead> - <tbody id="where"> - <tr> - <td class="center nowrap"> - <b> - WHERE - </b> - </td> - </tr> - <tr> - <td width="58" class="nowrap"> - {% trans 'Relationship operator' %} - </td> - <td width="102"> - <select name="rel_opt" id="rel_opt"> - <option value="--" selected="selected"> - -- - </option> - <option value="="> - = - </option> - <option value=">"> - > - </option> - <option value="<"> - < - </option> - <option value=">="> - >= - </option> - <option value="<="> - <= - </option> - <option value="NOT"> - NOT - </option> - <option value="IN"> - IN - </option> - <option value="EXCEPT"> - {% trans 'Except' %} - </option> - <option value="NOT IN"> - NOT IN - </option> - </select> - </td> - </tr> - <tr> - <td class="nowrap"> - {% trans 'Value' %} - <br> - {% trans 'subquery' %} - </td> - <td> - <textarea id="Query" cols="18"></textarea> - </td> - </tr> - <tr> - <td class="center nowrap"> - <b> - {% trans 'Rename to' %} - </b> - </td> - </tr> - <tr> - <td width="58" class="nowrap"> - {% trans 'New name' %} - </td> - <td width="102"> - <input type="text" id="new_name"> - </td> - </tr> - <tr> - <td class="center nowrap"> - <b> - {% trans 'Aggregate' %} - </b> - </td> - </tr> - <tr> - <td width="58" class="nowrap"> - {% trans 'Operator' %} - </td> - <td width="102"> - <select name="operator" id="operator"> - <option value="---" selected="selected"> - --- - </option> - <option value="sum" > - SUM - </option> - <option value="min"> - MIN - </option> - <option value="max"> - MAX - </option> - <option value="avg"> - AVG - </option> - <option value="count"> - COUNT - </option> - </select> - </td> - </tr> - <tr> - <td width="58" class="center nowrap"> - <b> - GROUP BY - </b> - </td> - <td> - <input type="checkbox" value="groupby" id="groupby"> - </td> - </tr> - <tr> - <td width="58" class="center nowrap"> - <b> - ORDER BY - </b> - </td> - <td> - <select name="orderby" id="orderby"> - <option value="---" selected="selected"> - --- - </option> - <option value="ASC" > - ASC - </option> - <option value="DESC"> - DESC - </option> - </select> - </td> - </tr> - <tr> - <td class="center nowrap"> - <b> - HAVING - </b> - </td> - </tr> - <tr> - <td width="58" class="nowrap"> - {% trans 'Operator' %} - </td> - <td width="102"> - <select name="h_operator" id="h_operator"> - <option value="---" selected="selected"> - --- - </option> - <option value="None" > - {% trans 'None' %} - </option> - <option value="sum" > - SUM - </option> - <option value="min"> - MIN - </option> - <option value="max"> - MAX - </option> - <option value="avg"> - AVG - </option> - <option value="count"> - COUNT - </option> - </select> - </td> - </tr> - <tr> - <td width="58" class="nowrap"> - {% trans 'Relationship operator' %} - </td> - <td width="102"> - <select name="h_rel_opt" id="h_rel_opt"> - <option value="--" selected="selected"> - -- - </option> - <option value="="> - = - </option> - <option value=">"> - > - </option> - <option value="<"> - < - </option> - <option value=">="> - & |