acqui/order.pl

   1 #!/usr/bin/perl
   2
   3 # $Id$
   4
   5 #script to show suppliers and orders
   6 #written by chris@katipo.co.nz 23/2/2000
   7
   8
   9 # Copyright 2000-2002 Katipo Communications
  10 #
  11 # This file is part of Koha.
  12 #
  13 # Koha is free software; you can redistribute it and/or modify it under the
  14 # terms of the GNU General Public License as published by the Free Software
  15 # Foundation; either version 2 of the License, or (at your option) any later
  16 # version.
  17 #
  18 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
  19 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
  20 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
  21 #
  22 # You should have received a copy of the GNU General Public License along with
  23 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
  24 # Suite 330, Boston, MA  02111-1307 USA
  25
  26 use strict;
  27 use C4::Catalogue;
  28 use C4::Auth;
  29 use C4::Biblio;
  30 use C4::Output;
  31 use CGI;
  32 use C4::Interface::CGI::Output;
  33 use C4::Database;
  34 use HTML::Template;
  35 use C4::Catalogue;
  36
  37 my $query=new CGI;
  38 my ($template, $loggedinuser, $cookie)
  39     = get_template_and_user({template_name => "acqui/order.tmpl",
  40                              query => $query,
  41                              type => "intranet",
  42                              authnotrequired => 0,
  43                              flagsrequired => {acquisition => 1},
  44                              debug => 1,
  45                              });
  46
  47 my $supplier=$query->param('supplier');
  48 my ($count,@suppliers)=bookseller($supplier);
  49
  50 my $colour='#ffffcc';
  51 my $toggle=0;
  52 my @loop_suppliers;
  53 for (my $i=0; $i<$count; $i++) {
  54         my ($ordcount,$orders)=getorders($suppliers[$i]->{'id'});
  55         my %line;
  56         if ($toggle==0){
  57                 $line{color}='#ffffcc';
  58                 $toggle=1;
  59         } else {
  60                 $line{color}='white';
  61                 $toggle=0;
  62         }
  63         $line{id} =$suppliers[$i]->{'id'};
  64         $line{name} = $suppliers[$i]->{'name'};
  65         $line{total} = $orders->[0]->{'count(*)'};
  66         $line{authorisedby} = $orders->[0]->{'authorisedby'};
  67         $line{entrydate} = $orders->[0]->{'entrydate'};
  68         my @loop_basket;
  69         for (my $i2=0;$i2<$ordcount;$i2++){
  70                 my %inner_line;
  71                 $inner_line{basketno} =$orders->[$i2]->{'basketno'};
  72                 $inner_line{total} =$orders->[$i2]->{'count(*)'};
  73                 $inner_line{authorisedby} = $orders->[$i2]->{'authorisedby'};
  74                 $inner_line{entrydate} = $orders->[$i2]->{'entrydate'};
  75                 push @loop_basket, \%inner_line;
  76         }
  77         $line{loop_basket} = \@loop_basket;
  78         push @loop_suppliers, \%line;
  79 }
  80 $template->param(loop_suppliers => \@loop_suppliers,
  81                                                 supplier => $supplier,
  82                                                 count => $count);
  83
  84 output_html_with_http_headers $query, $cookie, $template->output;