phpmyadmin · nijel · Apr 28, 2017 · Apr 20, 2017 · Apr 23, 2017 · Apr 24, 2017
diff --git a/libraries/Template.php b/libraries/Template.php
@@ -11,6 +11,7 @@
 use Twig_Loader_Filesystem;
 use PMA\libraries\twig\I18nExtension;
 use PMA\libraries\twig\UrlExtension;
+use PMA\libraries\twig\UtilExtension;
 
 /**
  * Class Template
@@ -64,6 +65,7 @@ protected function __construct($name, $data = array(), $helperFunctions = array(
         ));
         $this->twig->addExtension(new I18nExtension());
         $this->twig->addExtension(new UrlExtension());
+        $this->twig->addExtension(new UtilExtension());
     }
 
     /**

diff --git a/libraries/Util.php b/libraries/Util.php
@@ -4350,7 +4350,7 @@ public static function getStartAndNumberOfRowsPanel($sql_query)
             }
         }
 
-        return Template::get('startAndNumberOfRowsPanel')
+        return Template::get('start_and_number_of_rows_panel')
             ->render(
                 array(
                     'pos' => $pos,

diff --git a/libraries/twig/UtilExtension.php b/libraries/twig/UtilExtension.php
@@ -0,0 +1,49 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * hold PMA\libraries\twig\UtilExtension class
+ *
+ * @package PMA\libraries\twig
+ */
+namespace PMA\libraries\twig;
+
+use Twig_Extension;
+use Twig_SimpleFunction;
+
+/**
+ * Class UtilExtension
+ *
+ * @package PMA\libraries\twig
+ */
+class UtilExtension extends Twig_Extension
+{
+    /**
+     * Returns a list of functions to add to the existing list.
+     *
+     * @return Twig_SimpleFunction[]
+     */
+    public function getFunctions()
+    {
+        return array(
+            new Twig_SimpleFunction(
+                'Util_showIcons',
+                'PMA\libraries\Util::showIcons'
+            ),
+            new Twig_SimpleFunction(
+                'Util_getImage',
+                'PMA\libraries\Util::getImage',
+                array('is_safe' => array('html'))
+            ),
+            new Twig_SimpleFunction(
+                'Util_formatSql',
+                'PMA\libraries\Util::formatSql',
+                array('is_safe' => array('html'))
+            ),
+            new Twig_SimpleFunction(
+                'Util_getHtmlTab',
+                'PMA\libraries\Util::getHtmlTab',
+                array('is_safe' => array('html'))
+            ),
+        );
+    }
+}
diff --git a/scripts/generate-twig-cache b/scripts/generate-twig-cache
@@ -6,6 +6,7 @@ require_once 'libraries/vendor_config.php';
 
 use PMA\libraries\twig\I18nExtension;
 use PMA\libraries\twig\UrlExtension;
+use PMA\libraries\twig\UtilExtension;
 
 $tplDir = dirname(__FILE__) . '/../templates';
 $tmpDir = dirname(__FILE__) . '/../' . CACHE_DIR . 'twig';
@@ -18,6 +19,7 @@ $twig = new Twig_Environment($loader, array(
 ));
 $twig->addExtension(new I18nExtension());
 $twig->addExtension(new UrlExtension());
+$twig->addExtension(new UtilExtension());
 
 // iterate over all templates
 foreach (new RecursiveIteratorIterator(

diff --git a/templates/checkbox.phtml b/templates/checkbox.phtml
diff --git a/templates/checkbox.twig b/templates/checkbox.twig
@@ -0,0 +1,6 @@
+<input type="checkbox" name="{{ html_field_name }}"
+{%- if html_field_id is defined %} id="{{ html_field_id }}"{% endif -%}
+{%- if checked is defined and checked %} checked="checked"{% endif -%}
+{%- if onclick is defined and onclick %} class="autosubmit"{% endif %} /><label
+{%- if html_field_id is defined %} for="{{ html_field_id }}"
+{%- endif %}>{{ label }}</label>
diff --git a/templates/components/error_message.phtml → templates/components/error_message.twig b/templates/components/error_message.phtml → templates/components/error_message.twig
@@ -1,4 +1,4 @@
 <div class="error">
     <img src="themes/dot.gif" title="" alt="" class="icon ic_s_error" />
-    <?= $msg; ?>
-</div>
+    {{ msg }}
+</div>
diff --git a/templates/console/query_action.phtml b/templates/console/query_action.phtml
diff --git a/templates/console/query_action.twig b/templates/console/query_action.twig
@@ -0,0 +1,12 @@
+<div class="{{ parentDivClasses }}">
+    {% for content in contentArray %}
+        {% if content is defined %}
+        <span class="{{ content[0] }}">
+            {{ content[1] }}
+            {% if content['extraSpan'] is defined %}
+                : <span>{{ content['extraSpan'] }}</span>
+            {% endif %}
+        </span>
+        {% endif %}
+    {% endfor %}
+</div>
diff --git a/templates/console/toolbar.phtml b/templates/console/toolbar.phtml
diff --git a/templates/console/toolbar.twig b/templates/console/toolbar.twig
@@ -0,0 +1,10 @@
+<div class="toolbar {{ parentDivClasses }}">
+    {% for content in contentArray %}
+        {% if content is defined %}
+        <div class="{{ content[0] }}">
+            {{ content['image'] ? content['image'] }}
+            <span>{{ content[1] }}</span>
+        </div>
+        {% endif %}
+    {% endfor %}
+</div>
diff --git a/templates/database/create_table.phtml → templates/database/create_table.twig b/templates/database/create_table.phtml → templates/database/create_table.twig
@@ -1,23 +1,23 @@
 <form id="create_table_form_minimal" method="post" action="tbl_create.php" class="lock-page">
     <fieldset>
         <legend>
-        <?php if (PMA\libraries\Util::showIcons('ActionLinksMode')): ?>
-            <?= PMA\libraries\Util::getImage('b_table_add.png'); ?>&nbsp
-        <?php endif; ?>
-        <?= __('Create table'); ?>
+        {% if Util_showIcons('ActionLinksMode') -%}
+            {{ Util_getImage('b_table_add.png') }}
+        {%- endif %}
+        {% trans "Create table" %}
         </legend>
-        <?= PMA\libraries\URL::getHiddenInputs($db); ?>
+        {{ URL_getHiddenInputs(db) }}
         <div class="formelement">
-            <?= __('Name'); ?>:
+            {% trans "Name" %}:
             <input type="text" name="table" maxlength="64" size="30" required="required" />
         </div>
         <div class="formelement">
-            <?= __('Number of columns'); ?>:
+            {% trans "Number of columns" %}:
             <input type="number" min="1" name="num_fields" value="4" required="required" />
         </div>
         <div class="clearfloat"></div>
     </fieldset>
     <fieldset class="tblFooters">
-        <input type="submit" value="<?= __('Go'); ?>" />
+        <input type="submit" value="{% trans "Go" %}" />
     </fieldset>
 </form>
diff --git a/templates/div_for_slider_effect.phtml b/templates/div_for_slider_effect.phtml
diff --git a/templates/div_for_slider_effect.twig b/templates/div_for_slider_effect.twig
@@ -0,0 +1,16 @@
+{% if InitialSlidersState == 'disabled' %}
+    <div{% if id is defined %} id="{{ id }}"{% endif %}>
+{% else %}
+    {#
+    Bad hack on the next line. document.write() conflicts with jQuery,
+    hence, opening the <div> with PHP itself instead of JavaScript.
+
+    @todo find a better solution that uses $.append(), the recommended
+    method maybe by using an additional param, the id of the div to
+    append to
+    #}
+    <div{% if id is defined %} id="{{ id }}"
+        {%- endif %} {% if InitialSlidersState == 'closed' -%}
+        style="display: none; overflow:auto;"{% endif %} class="pma_auto_slider"
+        {%- if message is defined %} title="{{ message }}"{% endif %}>
+{% endif %}
diff --git a/templates/dropdown.phtml b/templates/dropdown.phtml
diff --git a/templates/dropdown.twig b/templates/dropdown.twig
@@ -0,0 +1,10 @@
+<select name="{{ select_name }}" id="{{ id }}"{{ class ? ' class="' ~ class ~ '"' }}>
+{% if placeholder is not empty %}
+    <option value="" disabled="disabled"
+    {%- if not selected %} selected="selected"{% endif %}>{{ placeholder }}</option>
+{% endif %}
+{% for option in resultOptions %}
+<option value="{{ option['value'] }}"
+    {{- option['selected'] ? ' selected="selected"' }}>{{ option['label'] }}</option>
+{% endfor %}
+</select>
diff --git a/templates/error/report_form.phtml b/templates/error/report_form.phtml
diff --git a/templates/error/report_form.twig b/templates/error/report_form.twig
@@ -0,0 +1,32 @@
+<form action="error_report.php" method="post" name="report_frm" id="report_frm"
+      class="ajax">
+    <fieldset style="padding-top:0">
+
+        <p>
+            {% trans %}
+            This report automatically includes data about the error and information about relevant configuration settings. It will be sent to the phpMyAdmin team for debugging the error.
+            {% endtrans %}
+        </p>
+
+        <div class="label"><label><strong>
+                    {% trans "Can you tell us the steps leading to this error? It decisively helps in debugging:" %}
+                </strong></label>
+        </div>
+        <textarea class="report-description" name="description"
+                  id="report_description"></textarea>
+
+        <div class="label"><label><p>
+                    {% trans "You may examine the data in the error report:" %}
+                </p></label></div>
+        <pre class="report-data">{{ report_data }}</pre>
+
+        <input type="checkbox" name="always_send" id="always_send_checkbox" />
+        <label for="always_send_checkbox">
+            {% trans "Automatically send report next time" %}
+        </label>
+
+    </fieldset>
+
+    {{ hidden_inputs }}
+    {{ hidden_fields }}
+</form>
diff --git a/templates/filter.phtml b/templates/filter.phtml
diff --git a/templates/filter.twig b/templates/filter.twig
@@ -0,0 +1,8 @@
+<fieldset id="tableFilter">
+    <legend>{% trans "Filters" %}</legend>
+    <div class="formelement">
+        <label for="filterText">{% trans "Containing the word:" %}</label>
+        <input name="filterText" type="text" id="filterText"
+               value="{{ filterValue }}" />
+    </div>
+</fieldset>
diff --git a/templates/prefs_autoload.phtml b/templates/prefs_autoload.phtml
diff --git a/templates/prefs_autoload.twig b/templates/prefs_autoload.twig
@@ -0,0 +1,15 @@
+<div id="prefs_autoload" class="notice print_ignore" style="display:none">
+    <form action="prefs_manage.php" method="post" class="disableAjax">
+        {{ hiddenInputs|raw }}
+        <input type="hidden" name="json" value="" />
+        <input type="hidden" name="submit_import" value="1" />
+        <input type="hidden" name="return_url" value="{{ return_url }}" />
+        {% trans %}
+            Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
+        {% endtrans %}
+        <br />
+        <a href="#yes">{% trans "Yes" %}</a>
+        / <a href="#no">{% trans "No" %}</a>
+        / <a href="#delete">{% trans "Delete settings" %}</a>
+    </form>
+</div>
diff --git a/templates/preview_sql.phtml b/templates/preview_sql.phtml
diff --git a/templates/preview_sql.twig b/templates/preview_sql.twig
@@ -0,0 +1,11 @@
+<div class="preview_sql">
+    {% if query_data is empty %}
+        {% trans 'No change' %}
+    {% elseif query_data is iterable %}
+        {% for query in query_data %}
+            {{ Util_formatSql(query) }}
+        {% endfor %}
+    {% else %}
+        {{ Util_formatSql(query_data) }}
+    {% endif %}
+</div>