Bug 20180: [sql_modes] Remove GROUP BY clause in manage-marc-import.pl
[koha.git] / acqui / edifactmsgs.pl
blobc706d9248bdb66598d983738671fe16adf76ec75
1 #!/usr/bin/perl
3 # Copyright 2014 PTFS Europe Ltd.
4 # This file is part of Koha.
6 # Koha is free software; you can redistribute it and/or modify it under the
7 # terms of the GNU General Public License as published by the Free Software
8 # Foundation; either version 3 of the License, or (at your option) any later
9 # version.
11 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
12 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
13 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
15 # You should have received a copy of the GNU General Public License along
16 # with Koha; if not, write to the Free Software Foundation, Inc.,
17 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19 use Modern::Perl;
21 use CGI;
22 use Koha::Database;
23 use C4::Koha;
24 use C4::Auth;
25 use C4::Output;
27 my $q = CGI->new;
28 my ( $template, $loggedinuser, $cookie, $userflags ) = get_template_and_user(
30 template_name => 'acqui/edifactmsgs.tt',
31 query => $q,
32 type => 'intranet',
33 authnotrequired => 0,
34 flagsrequired => { acquisition => 'manage_edi' },
35 debug => 1,
39 my $schema = Koha::Database->new()->schema();
40 my $cmd = $q->param('op');
41 if ( $cmd && $cmd eq 'delete' ) {
42 my $id = $q->param('message_id');
43 my $msg = $schema->resultset('EdifactMessage')->find($id);
44 $msg->deleted(1);
45 $msg->update;
48 my @msgs = $schema->resultset('EdifactMessage')->search(
50 deleted => 0,
53 join => 'vendor',
54 order_by => { -desc => 'transfer_date' },
57 )->all;
59 $template->param( messages => \@msgs );
61 output_html_with_http_headers( $q, $cookie, $template->output );