Remove an invalid db update
[koha.git] / serials / acqui-search-result.pl
blobdf73738cb1dc5cbd9af797881d4567025b808b87
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 under the
11 # terms of the GNU General Public License as published by the Free Software
12 # Foundation; either version 2 of the License, or (at your option) any later
13 # version.
15 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
16 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
17 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
19 # You should have received a copy of the GNU General Public License along with
20 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
21 # Suite 330, Boston, MA 02111-1307 USA
24 =head1 NAME
26 acqui-search-result.pl
28 =head1 DESCRIPTION
29 TODO
31 =head1 PARAMETERS
33 =over 4
35 =item supplier
37 =back
39 =cut
42 use strict;
43 use warnings;
44 use C4::Auth;
45 use C4::Biblio;
46 use C4::Output;
47 use CGI;
48 use C4::Acquisition;
49 use C4::Dates qw/format_date/;
50 use C4::Bookseller;
52 my $query=new CGI;
53 my ($template, $loggedinuser, $cookie)
54 = get_template_and_user({template_name => "serials/acqui-search-result.tmpl",
55 query => $query,
56 type => "intranet",
57 authnotrequired => 0,
58 flagsrequired => {serials => 1},
59 debug => 1,
60 });
62 my $supplier=$query->param('supplier');
63 my @suppliers = GetBookSeller($supplier);
64 #my $count = scalar @suppliers;
66 #build result page
67 my $loop_suppliers = [];
68 for my $s (@suppliers) {
69 my $orders = GetPendingOrders($s->{'id'});
71 my $loop_basket = [];
72 for my $ord ( @{$orders} ) {
73 push @{$loop_basket}, {
74 basketno => $ord->{'basketno'},
75 total => $ord->{'count(*)'},
76 authorisedby => $ord->{'authorisedby'},
77 creationdate => format_date($ord->{'creationdate'}),
78 closedate => format_date($ord->{'closedate'}),
81 push @{$loop_suppliers}, {
82 loop_basket => $loop_basket,
83 aqbooksellerid => $s->{'id'},
84 name => $s->{'name'},
85 active => $s->{'active'},
89 $template->param(loop_suppliers => $loop_suppliers,
90 supplier => $supplier,
91 count => scalar @suppliers);
93 output_html_with_http_headers $query, $cookie, $template->output;