aboutsummaryrefslogtreecommitdiff
path: root/srcs/phpmyadmin/templates/database/designer/main.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/database/designer/main.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/database/designer/main.twig')
-rw-r--r--srcs/phpmyadmin/templates/database/designer/main.twig1105
1 files changed, 0 insertions, 1105 deletions
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="&gt;">
- &gt;
- </option>
- <option value="&lt;">
- &lt;
- </option>
- <option value="&gt;=">
- &gt;=
- </option>
- <option value="&lt;=">
- &lt;=
- </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="&gt;">
- &gt;
- </option>
- <option value="&lt;">
- &lt;
- </option>
- <option value="&gt;=">
- &gt;=
- </option>
- <option value="&lt;=">
- &lt;=
- </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 width="58" class="nowrap">
- {% trans 'Value' %}
- <br>
- {% trans 'subquery' %}
- </td>
- <td width="102">
- <textarea id="having" cols="18"></textarea>
- </td>
- </tr>
- </tbody>
- <tbody>
- <tr>
- <td colspan="2" class="center nowrap">
- <input type="hidden" id="ok_add_object_db_and_table_name_url" />
- <input type="hidden" id="ok_add_object_db_name" />
- <input type="hidden" id="ok_add_object_table_name" />
- <input type="hidden" id="ok_add_object_col_name" />
- <input type="button" id="ok_add_object" class="btn btn-secondary butt"
- name="Button" value="{% trans 'OK' %}">
- <input type="button" id="cancel_close_option" 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>
- {# rename to pane #}
- <table id="query_rename_to" 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 'Rename to' %}
- </strong>
- </td>
- </tr>
- </thead>
- <tbody id="rename_to">
- <tr>
- <td width="58" class="nowrap">
- {% trans 'New name' %}
- </td>
- <td width="102">
- <input type="text" id="e_rename">
- </td>
- </tr>
- </tbody>
- <tbody>
- <tr>
- <td colspan="2" class="center nowrap">
- <input type="button" id="ok_edit_rename" class="btn btn-secondary butt"
- name="Button" value="{% trans 'OK' %}">
- <input id="query_rename_to_button" type="button"
- 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>
- {# having query panel #}
- <table id="query_having" 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>
- HAVING
- </strong>
- </td>
- </tr>
- </thead>
- <tbody id="rename_to">
- <tr>
- <td width="58" class="nowrap">
- {% trans 'Operator' %}
- </td>
- <td width="102">
- <select name="hoperator" id="hoperator">
- <option value="---" selected="selected">
- ---
- </option>
- <option value="None" >
- 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>
- <tr>
- <td width="58" class="nowrap">
- {% trans 'Operator' %}
- </td>
- <td width="102">
- <select name="hrel_opt" id="hrel_opt">
- <option value="--" selected="selected">
- --
- </option>
- <option value="=">
- =
- </option>
- <option value="&gt;">
- &gt;
- </option>
- <option value="&lt;">
- &lt;
- </option>
- <option value="&gt;=">
- &gt;=
- </option>
- <option value="&lt;=">
- &lt;=
- </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="hQuery" cols="18">
- </textarea>
- </td>
- </tr>
- </tbody>
- <tbody>
- <tr>
- <td colspan="2" class="center nowrap">
- <input type="button" id="ok_edit_having" class="btn btn-secondary butt"
- name="Button" value="{% trans 'OK' %}">
- <input id="query_having_button" type="button"
- 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>
- {# aggregate query pane #}
- <table id="query_Aggregate" 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 'Aggregate' %}
- </strong>
- </td>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td width="58" class="nowrap">
- {% trans 'Operator' %}
- </td>
- <td width="102">
- <select name="operator" id="e_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>
- </tbody>
- <tbody>
- <tr>
- <td colspan="2" class="center nowrap">
- <input type="button" id="ok_edit_Aggr" class="btn btn-secondary butt"
- name="Button" value="{% trans 'OK' %}">
- <input id="query_Aggregate_Button" type="button"
- 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>
- {# where query pane #}
- <table id="query_where" 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>
- WHERE
- </strong>
- </td>
- </tr>
- </thead>
- <tbody id="rename_to">
- <tr>
- <td width="58" class="nowrap">
- {% trans 'Operator' %}
- </td>
- <td width="102">
- <select name="erel_opt" id="erel_opt">
- <option value="--" selected="selected">
- --
- </option>
- <option value="=" >
- =
- </option>
- <option value="&gt;">
- &gt;
- </option>
- <option value="&lt;">
- &lt;
- </option>
- <option value="&gt;=">
- &gt;=
- </option>
- <option value="&lt;=">
- &lt;=
- </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="eQuery" cols="18">
- </textarea>
- </td>
- </tr>
- </tbody>
- <tbody>
- <tr>
- <td colspan="2" class="center nowrap">
- <input type="button" id="ok_edit_where" class="btn btn-secondary butt"
- name="Button" value="{% trans 'OK' %}">
- <input id="query_where_button" type="button" 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>
- {# query details #}
- <div class="panel">
- <div class="clearfloat"></div>
- <div id="ab"></div>
- <div class="clearfloat"></div>
- </div>
- <a class="trigger" href="#">{% trans 'Active options' %}</a>
- <div id="box">
- <form method="post" action="db_qbe.php" id="vqb_form">
- <textarea cols="80" name="sql_query" id="textSqlquery" rows="15"></textarea>
- <input type="hidden" name="submit_sql" value="true">
- {{ get_hidden_inputs(get_db) }}
- </form>
- </div>
-{% endif %}
-<div id="PMA_disable_floating_menubar"></div>