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
48 use C4::Acquisition qw( SearchOrders );
51 use Koha::Acquisition::Booksellers;
54 my ($template, $loggedinuser, $cookie)
55 = get_template_and_user({template_name => "serials/acqui-search-result.tt",
58 flagsrequired => {serials => '*'},
62 my $supplier=$query->param('supplier');
63 my @suppliers = Koha::Acquisition::Booksellers->search(
64 { name => { -like => "%$supplier%" } },
65 { order_by => { -asc => 'name' } } );
68 my $loop_suppliers = [];
69 for my $s (@suppliers) {
70 my $orders = SearchOrders({
71 booksellerid => $s->id,
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,
93 $template->param(loop_suppliers => $loop_suppliers,
94 supplier => $supplier,
95 count => scalar @suppliers);
97 output_html_with_http_headers $query, $cookie, $template->output;