{#**
 * 2007-2018 PrestaShop
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * https://opensource.org/licenses/OSL-3.0
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to http://www.prestashop.com for more information.
 *
 * @author    PrestaShop SA <contact@prestashop.com>
 * @copyright 2007-2018 PrestaShop SA
 * @license   https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
 * International Registered Trademark & Property of PrestaShop SA
 *#}

{% extends '@PrestaShop/Admin/layout.html.twig' %}
{% trans_default_domain 'Admin.Advparameters.Feature' %}

{% block content %}
  <div class="container">
    <div class="row">
      <div class="col">
      {% block sql_manager_form_panel %}
        {{ form_start(requestSqlForm) }}
        <div class="card">
          <h3 class="card-header">
              {{ 'SQL query'|trans }}
          </h3>
          <div class="card-block p-3">
            <div class="form-group">
              <label for="{{ requestSqlForm.request_sql.name.vars.id }}" class="form-control-label">{{ 'SQL query name'|trans }}</label>
              {{ form_errors(requestSqlForm.request_sql.name) }}
              {{ form_widget(requestSqlForm.request_sql.name) }}
            </div>

            <div class="form-group">
              <label for="{{ requestSqlForm.request_sql.sql.vars.id }}" class="form-control-label">{{ 'SQL query'|trans }}</label>
              {{ form_errors(requestSqlForm.request_sql.sql) }}
              {{ form_widget(requestSqlForm.request_sql.sql, {'attr': { 'rows': 10}}) }}
            </div>

            {{ form_rest(requestSqlForm) }}
          </div>
          <div class="card-footer">
            <a href="{{ path('admin_sql_request') }}" class="btn btn-outline-secondary">
              <i class="material-icons">cancel</i>
              {{ 'Cancel'|trans({}, 'Admin.Actions') }}
            </a>
            <button class="btn btn-primary float-right">
              <i class="material-icons">save</i>
              {{ 'Save'|trans({}, 'Admin.Actions') }}
            </button>
          </div>
        </div>
        {{ form_end(requestSqlForm) }}
      {% endblock %}
      </div>
    </div>

    {% block sql_manager_db_tables_panel %}
      {% include '@PrestaShop/Admin/Configure/AdvancedParameters/RequestSql/Blocks/db_tables_panel.html.twig' %}
    {% endblock %}
  </div>
{% endblock %}

{% block javascripts %}
  {{ parent() }}

  <script src="{{ asset('themes/new-theme/public/sql_manager.bundle.js') }}"></script>
  <script src="{{ asset('themes/default/js/bundle/pagination.js') }}"></script>
{% endblock %}