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>.
26 acqui-search-result.pl
44 use C4::Auth qw( get_template_and_user );
45 use C4::Output qw( output_html_with_http_headers );
47 use C4::Acquisition qw( SearchOrders );
48 use Koha::DateUtils qw( output_pref );
50 use Koha::Acquisition::Booksellers;
53 my ($template, $loggedinuser, $cookie)
54 = get_template_and_user({template_name => "serials/acqui-search-result.tt",
57 flagsrequired => {serials => '*'},
60 my $supplier=$query->param('supplier');
61 my @suppliers = Koha::Acquisition::Booksellers->search(
62 { name => { -like => "%$supplier%" } },
63 { order_by => { -asc => 'name' } } )->as_list;
66 my $loop_suppliers = [];
67 for my $s (@suppliers) {
68 my $orders = SearchOrders({
69 booksellerid => $s->id,
74 for my $ord ( @{$orders} ) {
75 push @{$loop_basket}, {
76 basketno => $ord->{'basketno'},
77 total => $ord->{'count(*)'},
78 authorisedby => $ord->{'authorisedby'},
79 creationdate => output_pref( { str => $ord->{'creationdate'} } ),
80 closedate => output_pref( { str => $ord->{'closedate'} } ),
83 push @{$loop_suppliers}, {
84 loop_basket => $loop_basket,
85 aqbooksellerid => $s->id,
91 $template->param(loop_suppliers => $loop_suppliers,
92 supplier => $supplier,
93 count => scalar @suppliers);
95 output_html_with_http_headers $query, $cookie, $template->output;