[% supposed_x = header_row.shift.cell %]

    [% supposed_x = header_row.shift.cell %]

    <fieldset>

    <fieldset>

                </select>

                </select>

            </li>

            </li>

            <label for="exclude-last">Exclude last line (Rollup)</label>

            <label for="exclude-last">Exclude last line (Rollup)</label>

            <input id="exclude-last" name="chart-exclude-last" type="checkbox">

            <input id="exclude-last" name="chart-exclude-last" type="checkbox">

                <a class="btn btn-default btn-sm toggle_sql" id="toggle_sql_hid" href="#"><i class="fa fa-eye"></i> Show SQL code</a>

                <a class="btn btn-default btn-sm toggle_sql" id="toggle_sql_hid" href="#"><i class="fa fa-eye"></i> Show SQL code</a>

                <a class="btn btn-default btn-sm toggle_sql" id="toggle_sql_vis" href="#" style="display:none;"><i class="fa fa-eye-slash"></i> Hide SQL code</a>

                <a class="btn btn-default btn-sm toggle_sql" id="toggle_sql_vis" href="#" style="display:none;"><i class="fa fa-eye-slash"></i> Hide SQL code</a>

            </div>

            </div>

        [% END %]

        [% END %]

    [% END %]

    [% END %]

            <h2>Leaflet</h2>

            <h2>Leaflet</h2>

            <p>The <a href="http://leafletjs.com">Leaflet</a> JavaScript library by Vladimir Agafonkinis licensed under the <a href="https://github.com/Leaflet/Leaflet/blob/master/LICENSE">BSD License</a>.</p>

            <p>The <a href="http://leafletjs.com">Leaflet</a> JavaScript library by Vladimir Agafonkinis licensed under the <a href="https://github.com/Leaflet/Leaflet/blob/master/LICENSE">BSD License</a>.</p>

        </div>

        </div>

        <div id="translations">

        <div id="translations">

        $("#toggle_sql_vis").toggle();

        $("#toggle_sql_vis").toggle();

    });

    });

    $("#table_reports").delegate(".confirmdelete", 'click', function(){

    $("#table_reports").delegate(".confirmdelete", 'click', function(){

        $(this).parents('tr').attr("class","warn");

        $(this).parents('tr').attr("class","warn");

        if(confirm(_("Are you sure you want to delete this saved report?"))){

        if(confirm(_("Are you sure you want to delete this saved report?"))){

            $('#draw-chart').click(function() {

            $('#draw-chart').click(function() {

                var btn_text = $("#draw-chart").html();

                var btn_text = $("#draw-chart").html();

                var x_elements = $('select[name="x"]').val();

                var x_elements = $('select[name="x"]').val();

                var y_elements = [];

                var y_elements = [];

                //var headers = [% header_row.json %];

                //var headers = [% header_row.json %];

                headers = [% header_row.json %];

                headers = [% header_row.json %];

                if ($('input[name="chart-exclude-last"]').prop('checked')) {

                if ($('input[name="chart-exclude-last"]').prop('checked')) {

                    results.splice(-1, 1);

                    results.splice(-1, 1);

<div id="sql_output" style="display:none;"><span class="label">Report SQL:</span><pre>[% sql |html %]</pre></div>

<div id="sql_output" style="display:none;"><span class="label">Report SQL:</span><pre>[% sql |html %]</pre></div>

</br>

</br>

<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get" id="limitselect">

<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get" id="limitselect">

    <input type="hidden" name="phase" value="Run this report"/>

    <input type="hidden" name="phase" value="Run this report"/>

    <input type="hidden" name="reports" value="[% report_id %]"/>

    <input type="hidden" name="reports" value="[% report_id %]"/>

[% END %]

[% END %]

</table>

</table>

[% END %]

[% END %]

[% END %]

[% END %]

        $notes = $report->{notes};

        $notes = $report->{notes};

        my @rows = ();

        my @rows = ();

        # if we have at least 1 parameter, and it's not filled, then don't execute but ask for parameters

        # if we have at least 1 parameter, and it's not filled, then don't execute but ask for parameters

        if ($sql =~ /<</ && !@sql_params) {

        if ($sql =~ /<</ && !@sql_params) {

            # split on ??. Each odd (2,4,6,...) entry should be a parameter to fill

            # split on ??. Each odd (2,4,6,...) entry should be a parameter to fill

                $sql =~ s/<<$split[$i*2+1]>>/$quoted/;

                $sql =~ s/<<$split[$i*2+1]>>/$quoted/;

            }

            }

            my ( $sth, $errors ) = execute_query( $sql, $offset, $limit, undef, $report_id );

            my ( $sth, $errors ) = execute_query( $sql, $offset, $limit, undef, $report_id );

            my $total = nb_rows($sql) || 0;

            my $total = nb_rows($sql) || 0;

            unless ($sth) {

            unless ($sth) {

                die "execute_query failed to return sth for report $report_id: $sql";

                die "execute_query failed to return sth for report $report_id: $sql";

                    my @cells = map { +{ cell => $_ } } @$row;

                    my @cells = map { +{ cell => $_ } } @$row;

                    push @rows, { cells => \@cells };

                    push @rows, { cells => \@cells };

                }

                }

            }

            }

            my $totpages = int($total/$limit) + (($total % $limit) > 0 ? 1 : 0);

            my $totpages = int($total/$limit) + (($total % $limit) > 0 ? 1 : 0);

            }

            }

            $template->param(

            $template->param(

                'results' => \@rows,

                'results' => \@rows,

                'sql'     => $sql,

                'sql'     => $sql,

                original_sql => $original_sql,

                original_sql => $original_sql,

                'id'      => $report_id,

                'id'      => $report_id,