Bug 26911: (bug 18936 follow-up) Remove invalid data before copying the circ rules
[koha.git] / serials / acqui-search-result.pl
blobece1232d192cc47ffa9a11c3b46253f1af590b0c
1 #!/usr/bin/perl
3 #script to show suppliers and orders
4 #written by chris@katipo.co.nz 23/2/2000
6 # Copyright 2000-2002 Katipo Communications
8 # This file is part of Koha.
10 # Koha is free software; you can redistribute it and/or modify it
11 # under the terms of the GNU General Public License as published by
12 # the Free Software Foundation; either version 3 of the License, or
13 # (at your option) any later version.
15 # Koha is distributed in the hope that it will be useful, but
16 # WITHOUT ANY WARRANTY; without even the implied warranty of
17 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 # GNU General Public License for more details.
20 # You should have received a copy of the GNU General Public License
21 # along with Koha; if not, see <http://www.gnu.org/licenses>.
24 =head1 NAME
26 acqui-search-result.pl
28 =head1 DESCRIPTION
30 TODO
32 =head1 PARAMETERS
34 =over 4
36 =item supplier
38 =back
40 =cut
43 use Modern::Perl;
44 use C4::Auth;
45 use C4::Biblio;
46 use C4::Output;
47 use CGI qw ( -utf8 );
48 use C4::Acquisition qw( SearchOrders );
49 use Koha::DateUtils;
51 use Koha::Acquisition::Booksellers;
53 my $query=CGI->new;
54 my ($template, $loggedinuser, $cookie)
55 = get_template_and_user({template_name => "serials/acqui-search-result.tt",
56 query => $query,
57 type => "intranet",
58 flagsrequired => {serials => '*'},
59 debug => 1,
60 });
62 my $supplier=$query->param('supplier');
63 my @suppliers = Koha::Acquisition::Booksellers->search(
64 { name => { -like => "%$supplier%" } },
65 { order_by => { -asc => 'name' } } );
67 #build result page
68 my $loop_suppliers = [];
69 for my $s (@suppliers) {
70 my $orders = SearchOrders({
71 booksellerid => $s->id,
72 pending => 1
73 });
75 my $loop_basket = [];
76 for my $ord ( @{$orders} ) {
77 push @{$loop_basket}, {
78 basketno => $ord->{'basketno'},
79 total => $ord->{'count(*)'},
80 authorisedby => $ord->{'authorisedby'},
81 creationdate => output_pref( { str => $ord->{'creationdate'} } ),
82 closedate => output_pref( { str => $ord->{'closedate'} } ),
85 push @{$loop_suppliers}, {
86 loop_basket => $loop_basket,
87 aqbooksellerid => $s->id,
88 name => $s->name,
89 active => $s->active,
93 $template->param(loop_suppliers => $loop_suppliers,
94 supplier => $supplier,
95 count => scalar @suppliers);
97 output_html_with_http_headers $query, $cookie, $template->output;