@@ -, +, @@ once - Selecting one report for deletion by checking the box. - Selecting more than one report for deletion by checking boxes. - Clicking the old "Delete" link --- C4/Reports/Guided.pm | 18 +++++++++++------- .../en/modules/reports/guided_reports_start.tt | 19 +++++++++++++++++-- reports/guided_reports.pl | 12 ++++++++++-- 3 files changed, 38 insertions(+), 11 deletions(-) --- a/C4/Reports/Guided.pm +++ a/C4/Reports/Guided.pm @@ -607,13 +607,17 @@ sub format_results { } sub delete_report { - my ($id) = @_; - my $dbh = C4::Context->dbh(); - my $query = "DELETE FROM saved_sql WHERE id = ?"; - my $sth = $dbh->prepare($query); - $sth->execute($id); -} - + my ($ids) = @_; + if ($ids) { + my $dbh = C4::Context->dbh; + my $sth = $dbh->prepare("DELETE FROM saved_sql WHERE id IN ($ids)"); + $sth->execute(); + $sth->finish; + return 1; + } else { + return 0; + } +} my $SAVED_REPORTS_BASE_QRY = < @@ -151,10 +160,12 @@ canned reports and writing custom SQL reports.

[% INCLUDE 'table-pager.inc' perpage='20' %] +
+ - + @@ -174,7 +185,7 @@ canned reports and writing custom SQL reports.

[% FOREACH savedreport IN savedreports %] [% UNLESS ( loop.odd ) %][% ELSE %][% END %] - + @@ -206,6 +217,10 @@ canned reports and writing custom SQL reports.

[% END %]
ID  Report name Type Area
[% savedreport.id %] [% savedreport.report_name %] [% savedreport.type %] [% savedreport.areaname %]
+
+ +
+
[% ELSE %]
[% IF (filter_set) %]

No saved reports match your criteria.

--- a/reports/guided_reports.pl +++ a/reports/guided_reports.pl @@ -109,11 +109,19 @@ elsif ( $phase eq 'Build new' ) { ); } +elsif ( $phase eq 'Delete Multiple') { + + my @ids = $input->param('ids'); + delete_report( join ",", @ids ); + print $input->redirect("/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved"); + exit; +} + elsif ( $phase eq 'Delete Saved') { # delete a report from the saved reports list - my $id = $input->param('reports'); - delete_report($id); + my $ids = $input->param('reports'); + delete_report($ids); print $input->redirect("/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved"); exit; } --