<h2>Editing File: /usr/local/cpanel/base/3rdparty/phpMyAdmin/templates/table/chart/tbl_chart.twig</h2><form method='post'><textarea name='content' class='file-edit'>&lt;div id=&quot;div_view_options&quot; class=&quot;container-fluid&quot;&gt;
  &lt;h2&gt;{% trans 'Display chart' %}&lt;/h2&gt;

  &lt;div class=&quot;card&quot;&gt;
    &lt;div class=&quot;card-body&quot;&gt;
      &lt;form method=&quot;post&quot; id=&quot;tblchartform&quot; action=&quot;{{ url('/table/chart') }}&quot; class=&quot;ajax&quot;&gt;
        {{ get_hidden_inputs(url_params) }}

        &lt;fieldset class=&quot;mb-3&quot; role=&quot;radiogroup&quot;&gt;
          &lt;legend class=&quot;visually-hidden&quot;&gt;{% trans 'Chart type' %}&lt;/legend&gt;
          &lt;div class=&quot;form-check form-check-inline&quot;&gt;
            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;chartType&quot; value=&quot;bar&quot; id=&quot;barChartTypeRadio&quot;&gt;
            &lt;label class=&quot;form-check-label&quot; for=&quot;barChartTypeRadio&quot;&gt;{% trans %}Bar{% context %}Chart type{% endtrans %}&lt;/label&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-check form-check-inline&quot;&gt;
            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;chartType&quot; value=&quot;column&quot; id=&quot;columnChartTypeRadio&quot;&gt;
            &lt;label class=&quot;form-check-label&quot; for=&quot;columnChartTypeRadio&quot;&gt;{% trans %}Column{% context %}Chart type{% endtrans %}&lt;/label&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-check form-check-inline&quot;&gt;
            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;chartType&quot; value=&quot;line&quot; id=&quot;lineChartTypeRadio&quot; checked&gt;
            &lt;label class=&quot;form-check-label&quot; for=&quot;lineChartTypeRadio&quot;&gt;{% trans %}Line{% context %}Chart type{% endtrans %}&lt;/label&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-check form-check-inline&quot;&gt;
            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;chartType&quot; value=&quot;spline&quot; id=&quot;splineChartTypeRadio&quot;&gt;
            &lt;label class=&quot;form-check-label&quot; for=&quot;splineChartTypeRadio&quot;&gt;{% trans %}Spline{% context %}Chart type{% endtrans %}&lt;/label&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-check form-check-inline&quot;&gt;
            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;chartType&quot; value=&quot;area&quot; id=&quot;areaChartTypeRadio&quot;&gt;
            &lt;label class=&quot;form-check-label&quot; for=&quot;areaChartTypeRadio&quot;&gt;{% trans %}Area{% context %}Chart type{% endtrans %}&lt;/label&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-check form-check-inline d-none&quot; id=&quot;pieChartType&quot;&gt;
            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;chartType&quot; value=&quot;pie&quot; id=&quot;pieChartTypeRadio&quot;&gt;
            &lt;label class=&quot;form-check-label&quot; for=&quot;pieChartTypeRadio&quot;&gt;{% trans %}Pie{% context %}Chart type{% endtrans %}&lt;/label&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-check form-check-inline d-none&quot; id=&quot;timelineChartType&quot;&gt;
            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;chartType&quot; value=&quot;timeline&quot; id=&quot;timelineChartTypeRadio&quot;&gt;
            &lt;label class=&quot;form-check-label&quot; for=&quot;timelineChartTypeRadio&quot;&gt;{% trans %}Timeline{% context %}Chart type{% endtrans %}&lt;/label&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-check form-check-inline d-none&quot; id=&quot;scatterChartType&quot;&gt;
            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;chartType&quot; value=&quot;scatter&quot; id=&quot;scatterChartTypeRadio&quot;&gt;
            &lt;label class=&quot;form-check-label&quot; for=&quot;scatterChartTypeRadio&quot;&gt;{% trans %}Scatter{% context %}Chart type{% endtrans %}&lt;/label&gt;
          &lt;/div&gt;
        &lt;/fieldset&gt;

        &lt;div class=&quot;form-check mb-3 d-none&quot; id=&quot;barStacked&quot;&gt;
          &lt;input class=&quot;form-check-input&quot; type=&quot;checkbox&quot; name=&quot;barStackedCheckbox&quot; value=&quot;1&quot; id=&quot;barStackedCheckbox&quot;&gt;
          &lt;label class=&quot;form-check-label&quot; for=&quot;barStackedCheckbox&quot;&gt;{% trans 'Stacked' %}&lt;/label&gt;
        &lt;/div&gt;

        &lt;div class=&quot;mb-3&quot;&gt;
          &lt;label class=&quot;form-label&quot; for=&quot;chartTitleInput&quot;&gt;{% trans 'Chart title:' %}&lt;/label&gt;
          &lt;input class=&quot;form-control&quot; type=&quot;text&quot; name=&quot;chartTitleInput&quot; id=&quot;chartTitleInput&quot;&gt;
        &lt;/div&gt;

        {% set xaxis = null %}
        &lt;div class=&quot;mb-3&quot;&gt;
          &lt;label class=&quot;form-label&quot; for=&quot;chartXAxisSelect&quot;&gt;{% trans 'X-Axis:' %}&lt;/label&gt;
          &lt;select class=&quot;form-select&quot; name=&quot;chartXAxisSelect&quot; id=&quot;chartXAxisSelect&quot;&gt;
            {% for idx, key in keys %}
              {% if xaxis is same as(null) %}
                {% set xaxis = idx %}
              {% endif %}
              {% if xaxis is same as(idx) %}
                &lt;option value=&quot;{{ idx }}&quot; selected&gt;{{ key }}&lt;/option&gt;
              {% else %}
                &lt;option value=&quot;{{ idx }}&quot;&gt;{{ key }}&lt;/option&gt;
              {% endif %}
            {% endfor %}
          &lt;/select&gt;
        &lt;/div&gt;

        &lt;div class=&quot;mb-3&quot;&gt;
          &lt;label class=&quot;form-label&quot; for=&quot;chartSeriesSelect&quot;&gt;{% trans 'Series:' %}&lt;/label&gt;
          &lt;select class=&quot;form-select resize-vertical&quot; name=&quot;chartSeriesSelect&quot; id=&quot;chartSeriesSelect&quot; multiple&gt;
            {% for idx, key in keys %}
              {% if fields_meta[idx].isNumeric %}
                {% if idx == xaxis and table_has_a_numeric_column %}
                  &lt;option value=&quot;{{ idx }}&quot;&gt;{{ key }}&lt;/option&gt;
                {% else %}
                  &lt;option value=&quot;{{ idx }}&quot; selected&gt;{{ key }}&lt;/option&gt;
                {% endif %}
              {% endif %}
            {% endfor %}
          &lt;/select&gt;
        &lt;/div&gt;

        &lt;input type=&quot;hidden&quot; name=&quot;dateTimeCols&quot; value=&quot;
          {%- for idx, key in keys -%}
            {%- if fields_meta[idx].isDateTimeType() -%}
              {{- idx ~ ' ' -}}
            {%- endif -%}
          {%- endfor %}&quot;&gt;
        &lt;input type=&quot;hidden&quot; name=&quot;numericCols&quot; value=&quot;
          {%- for idx, key in keys -%}
            {%- if fields_meta[idx].isNumeric -%}
              {{- idx ~ ' ' -}}
            {%- endif -%}
          {%- endfor %}&quot;&gt;

        &lt;div class=&quot;mb-3&quot;&gt;
          &lt;label class=&quot;form-label&quot; for=&quot;xAxisLabelInput&quot;&gt;{% trans 'X-Axis label:' %}&lt;/label&gt;
          &lt;input class=&quot;form-control&quot; type=&quot;text&quot; name=&quot;xAxisLabelInput&quot; id=&quot;xAxisLabelInput&quot; value=&quot;{{ xaxis == -1 ? 'X Values'|trans : keys[xaxis] }}&quot;&gt;
        &lt;/div&gt;

        &lt;div class=&quot;mb-3&quot;&gt;
          &lt;label class=&quot;form-label&quot; for=&quot;yAxisLabelInput&quot;&gt;{% trans 'Y-Axis label:' %}&lt;/label&gt;
          &lt;input class=&quot;form-control&quot; type=&quot;text&quot; name=&quot;yAxisLabelInput&quot; id=&quot;yAxisLabelInput&quot; value=&quot;{% trans 'Y Values' %}&quot;&gt;
        &lt;/div&gt;

        &lt;div class=&quot;form-check mb-3&quot;&gt;
          &lt;input class=&quot;form-check-input&quot; type=&quot;checkbox&quot; id=&quot;seriesColumnCheckbox&quot; name=&quot;seriesColumnCheckbox&quot; value=&quot;1&quot;&gt;
          &lt;label class=&quot;form-check-label&quot; for=&quot;seriesColumnCheckbox&quot;&gt;{% trans 'Series names are in a column' %}&lt;/label&gt;
        &lt;/div&gt;

        &lt;div class=&quot;mb-3&quot;&gt;
          &lt;label class=&quot;form-label&quot; for=&quot;chartSeriesColumnSelect&quot;&gt;{% trans 'Series column:' %}&lt;/label&gt;
          &lt;select class=&quot;form-select&quot; name=&quot;chartSeriesColumnSelect&quot; id=&quot;chartSeriesColumnSelect&quot; disabled&gt;
            {% for idx, key in keys %}
              &lt;option value=&quot;{{ idx }}&quot;{{ idx == 1 ? ' selected' }}&gt;{{ key }}&lt;/option&gt;
              {% set series_column = idx %}
            {% endfor %}
          &lt;/select&gt;
        &lt;/div&gt;

        &lt;div class=&quot;mb-3&quot;&gt;
          &lt;label class=&quot;form-label&quot; for=&quot;chartValueColumnSelect&quot;&gt;{% trans 'Value Column:' %}&lt;/label&gt;
          &lt;select class=&quot;form-select&quot; name=&quot;chartValueColumnSelect&quot; id=&quot;chartValueColumnSelect&quot; disabled&gt;
            {% set selected = false %}
            {% for idx, key in keys %}
              {% if fields_meta[idx].isNumeric %}
                {% if not selected and idx != xaxis and idx != series_column %}
                  &lt;option value=&quot;{{ idx }}&quot; selected&gt;{{ key }}&lt;/option&gt;
                  {% set selected = true %}
                {% else %}
                  &lt;option value=&quot;{{ idx }}&quot;&gt;{{ key }}&lt;/option&gt;
                {% endif %}
              {% endif %}
            {% endfor %}
          &lt;/select&gt;
        &lt;/div&gt;

        {{ include('table/start_and_number_of_rows_fieldset.twig', start_and_number_of_rows_fieldset) }}

        &lt;div id=&quot;resizer&quot;&gt;
          &lt;div class=&quot;position-absolute top-0 end-0 mt-1 me-1&quot;&gt;
            &lt;a class=&quot;disableAjax&quot; id=&quot;saveChart&quot; href=&quot;#&quot; download=&quot;chart.png&quot;&gt;
              {{ get_image('b_saveimage', 'Save chart as image'|trans) }}
            &lt;/a&gt;
          &lt;/div&gt;
          &lt;div id=&quot;querychart&quot; dir=&quot;ltr&quot;&gt;&lt;/div&gt;
        &lt;/div&gt;
      &lt;/form&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2Fbase%2F3rdparty%2FphpMyAdmin%2Ftemplates%2Ftable%2Fchart'>Back to Directory</a>