diff options
Diffstat (limited to 'srcs/phpmyadmin/templates/database/multi_table_query/form.twig')
| -rw-r--r-- | srcs/phpmyadmin/templates/database/multi_table_query/form.twig | 184 |
1 files changed, 184 insertions, 0 deletions
diff --git a/srcs/phpmyadmin/templates/database/multi_table_query/form.twig b/srcs/phpmyadmin/templates/database/multi_table_query/form.twig new file mode 100644 index 0000000..068ceda --- /dev/null +++ b/srcs/phpmyadmin/templates/database/multi_table_query/form.twig @@ -0,0 +1,184 @@ +{% include 'secondary_tabs.twig' with { + 'url_params': { + 'db': db + }, + 'sub_tabs': [ + { + 'link': 'db_multi_table_query.php', + 'text': 'Multi-table query'|trans + }, + { + 'link': 'db_qbe.php', + 'text': 'Query by example'|trans + } + ] +} only %} +{% include 'div_for_slider_effect.twig' with { + 'id': 'query_div', + 'message': 'Query window'|trans, + 'initial_sliders_state': 'open', +} only %} +<form action="" id="query_form"> + <input type="hidden" id="db_name" value="{{ db }}"> + <fieldset> + {% for table in tables %} + <div style="display:none" id="{{ table.hash }}"> + <option value="*">*</option> + {% for column in table.columns %} + <option value="{{ column }}">{{ column }}</option> + {% endfor %} + </div> + {% endfor %} + + {% for id in 0..default_no_of_columns %} + {% if id == 0 %}<div style="display:none" id="new_column_layout">{% endif %} + <fieldset style="display:inline" class="column_details"> + <select style="display:inline" class="tableNameSelect"> + <option value="">{% trans 'select table' %}</option> + {% for table in tables|keys %} + <option value="{{ table }}">{{ table }}</option> + {% endfor %} + </select> + <span>.</span> + <select style="display:inline" class="columnNameSelect"> + <option value="">{% trans 'select column' %}</option> + </select> + <br> + <input type="checkbox" checked="checked" class="show_col"> + <span>{% trans 'Show' %}</span> + <br> + <input type="text" placeholder="{% trans 'Table alias' %}" class="table_alias"> + <input type="text" placeholder="{% trans 'Column alias' %}" class="col_alias"> + <br> + <input type="checkbox" + title="{% trans 'Use this column in criteria' %}" + class="criteria_col"> + {% include 'div_for_slider_effect.twig' with { + 'id': 'criteria_div' ~ id, + 'initial_sliders_state': 'closed', + 'message': 'criteria'|trans + } %} + <div> + <table> + + <tr class="sort_order" style="background:none"> + <td>{% trans 'Sort' %}</td> + <td><input type="radio" name="sort[{{ id }}]">{% trans 'Ascending' %}</td> + <td><input type="radio" name="sort[{{ id }}]">{% trans 'Descending' %}</td> + </tr> + + <tr class="logical_operator" style="background:none;display:none"> + <td>{% trans 'Add as' %}</td> + <td> + <input type="radio" + name="logical_op[{{ id }}]" + value="AND" + class="logical_op" + checked="checked"> + AND + </td> + <td> + <input type="radio" + name="logical_op[{{ id }}]" + value="OR" + class="logical_op"> + OR + </td> + </tr> + + <tr style="background:none"> + <td>Op </td> + <td> + <select class="criteria_op"> + <option value="=">=</option> + <option value=">">></option> + <option value=">=">>=</option> + <option value="<"><</option> + <option value="<="><=</option> + <option value="!=">!=</option> + <option value="LIKE">LIKE</option> + <option value="LIKE %...%">LIKE %...%</option> + <option value="NOT LIKE">NOT LIKE</option> + <option value="IN (...)">IN (...)</option> + <option value="NOT IN (...)">NOT IN (...)</option> + <option value="BETWEEN">BETWEEN</option> + <option value="NOT BETWEEN">NOT BETWEEN</option> + <option value="IS NULL">IS NULL</option> + <option value="IS NOT NULL">IS NOT NULL</option> + <option value="REGEXP">REGEXP</option> + <option value="REGEXP ^...$">REGEXP ^...$</option> + <option value="NOT REGEXP">NOT REGEXP</option> + </select> + </td> + <td> + <select class="criteria_rhs"> + <option value="text">{% trans 'Text' %}</option> + <option value="anotherColumn">{% trans 'Another column' %}</option> + </select> + </td> + </tr> + + <tr class="rhs_table" style="display:none;background:none"> + <td></td> + <td> + <select class="tableNameSelect"> + <option value="">{% trans 'select table' %}</option> + {% for table in tables|keys %} + <option value="{{ table }}">{{ table }}</option> + {% endfor %} + </select><span>.</span> + </td> + <td> + <select style="display:inline" class="columnNameSelect"> + <option value="">{% trans 'select column' %}</option> + </select> + </td> + </tr> + + <tr style="background:none" class="rhs_text"> + <td></td> + <td colspan="2"> + <input type="text" + style="width:91%" + class="rhs_text_val" + placeholder="{% trans 'Enter criteria as free text' %}"> + </td> + </tr> + + </table> + </div> + </div> + <a href="#" + title="{% trans 'Remove this column' %}" + style="float:right;color:red" + class="removeColumn"> + X + </a> + </fieldset> + {% if id == 0 %}</div>{% endif %} + {% endfor %} + + <fieldset style="display:inline"> + <input class="btn btn-secondary" type="button" value="{% trans '+ Add column' %}" id="add_column_button"> + </fieldset> + + <fieldset> + {% apply spaceless %} + <textarea id="MultiSqlquery" + cols="80" + rows="4" + style="float:left" + name="sql_query" + dir="ltr"> + </textarea> + {% endapply %} + </fieldset> + </fieldset> + + <fieldset class="tblFooters"> + <input class="btn btn-secondary" type="button" id="update_query_button" value="{% trans 'Update query' %}"> + <input class="btn btn-primary" type="button" id="submit_query" value="{% trans 'Submit query' %}"> + </fieldset> +</form> +</div>{# Slider div #} +<div id="sql_results"></div> |