svc/convert_report

   1 #!/usr/bin/perl
   2
   3 # This file is part of Koha.
   4 #
   5 # Copyright 2017 Koha Development Team
   6 #
   7 # Koha is free software; you can redistribute it and/or modify it
   8 # under the terms of the GNU General Public License as published by
   9 # the Free Software Foundation; either version 3 of the License, or
  10 # (at your option) any later version.
  11 #
  12 # Koha is distributed in the hope that it will be useful, but
  13 # WITHOUT ANY WARRANTY; without even the implied warranty of
  14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  15 # GNU General Public License for more details.
  16 #
  17 # You should have received a copy of the GNU General Public License
  18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
  19
  20 use Modern::Perl;
  21
  22 use C4::Auth;
  23 use C4::Reports::Guided;
  24 use Koha::Reports;
  25 use C4::Output;
  26 use CGI qw ( -utf8 );
  27
  28 my $query  = CGI->new();
  29 my $report_id = $query->param('report_id');
  30
  31 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
  32     {
  33         template_name   => "reports/convert_report.tt",
  34         query           => $query,
  35         type            => "intranet",
  36         authnotrequired => 0,
  37         flagsrequired   => { reports => 'execute_reports' },
  38     }
  39 );
  40
  41 my $report = Koha::Reports->find( $report_id );
  42
  43 my $params;
  44 if ( $report ) {
  45     my $sql = $report->savedsql;
  46     my $updated_sql = C4::Reports::Guided::convert_sql( $sql );
  47     $params = { msg => 'can_be_updated', updated_sql => $updated_sql, current_sql => $sql };
  48 } else {
  49     $params = { msg => 'no_report' };
  50 }
  51
  52 $template->param( %$params );
  53
  54 output_html_with_http_headers $query, $cookie, $template->output;