#!/usr/bin/perl
#script to show suppliers and orders
-#written by chris@katipo.co.nz 23/2/2000
# Copyright 2000-2002 Katipo Communications
+# Copyright 2008-2009 BibLibre SARL
+# Copyright 2010 PTFS Europe
#
# This file is part of Koha.
#
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
#
-# You should have received a copy of the GNU General Public License along with
-# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
-# Suite 330, Boston, MA 02111-1307 USA
-
+# You should have received a copy of the GNU General Public License along
+# with Koha; if not, write to the Free Software Foundation, Inc.,
+# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
=head1 NAME
=head1 DESCRIPTION
-this script displays the list of suppliers & orders like C<$supplier> given on input arg.
+this script displays the list of suppliers & baskets like C<$supplier> given on input arg.
thus, this page brings differents features like to display supplier's details,
to add an order for a specific supplier or to just add a new supplier.
=item supplier
-C<$supplier> is the suplier we have to search order.
-=back
-
-=item op
+C<$supplier> is the string with which we search for a supplier
-C<OP> can be equals to 'close' if we have to close a basket before building the page.
+=back
-=item basket
+=item id or supplierid
-the C<basket> we have to close if op is equal to 'close'.
+The id of the supplier whose baskets we will display
=back
=cut
use strict;
+use warnings;
use C4::Auth;
use C4::Biblio;
use C4::Output;
use CGI;
+use C4::Dates qw/format_date/;
+use C4::Bookseller qw/ GetBookSellerFromId GetBookSeller /;
+use C4::Members qw/GetMember/;
+use C4::Context;
-use C4::Acquisition;
-use C4::Dates;
-use C4::Bookseller;
-
-my $query = new CGI;
+my $query = CGI->new;
my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
- {
- template_name => "acqui/booksellers.tmpl",
+ { template_name => 'acqui/booksellers.tmpl',
query => $query,
- type => "intranet",
+ type => 'intranet',
authnotrequired => 0,
- flagsrequired => { acquisition => 1 },
+ flagsrequired => { acquisition => '*' },
debug => 1,
}
);
#parameters
my $supplier = $query->param('supplier');
+my $id = $query->param('id') || $query->param('supplierid');
+my @suppliers;
+
+if ($id) {
+ push @suppliers, GetBookSellerFromId($id);
+} else {
+ @suppliers = GetBookSeller($supplier);
+}
-my @suppliers = GetBookSeller($supplier);
-my $count = scalar @suppliers;
+my $supplier_count = @suppliers;
+if ( $supplier_count == 1 ) {
+ $template->param(
+ supplier_name => $suppliers[0]->{'name'},
+ id => $suppliers[0]->{'id'}
+ );
+}
-# check if we have to "close" a basket before building page
-my $op = $query->param('op');
-my $basket = $query->param('basketno');
-if ( $op eq 'close' ) {
- CloseBasket($basket);
+my $uid;
+if ($loggedinuser) {
+ $uid = GetMember( borrowernumber => $loggedinuser )->{userid};
}
+my $userenv = C4::Context::userenv;
+my $viewbaskets = C4::Context->preference('AcqViewBaskets');
+
+my $userbranch = $userenv->{branch};
+
#build result page
-my $toggle = 0;
-my @loop_suppliers;
-for ( my $i = 0 ; $i < $count ; $i++ ) {
- my $orders = GetPendingOrders( $suppliers[$i]->{'id'}, "grouped" );
- my $ordcount = scalar @$orders;
- my %line;
- if ( $toggle == 0 ) {
- $line{even} = 1;
- $toggle = 1;
- } else {
- $line{even} = 0;
- $toggle = 0;
+my $loop_suppliers = [];
+
+for my $vendor (@suppliers) {
+ my $baskets = get_vendors_baskets( $vendor->{id} );
+
+ my $loop_basket = [];
+
+ for my $basket ( @{$baskets} ) {
+ my $authorisedby = $basket->{authorisedby};
+ my $basketbranch = ''; # set a blank branch to start with
+ if ( GetMember( borrowernumber => $authorisedby ) ) {
+ # authorisedby may not be a valid borrowernumber; it's not foreign-key constrained!
+ $basketbranch = GetMember( borrowernumber => $authorisedby )->{branchcode};
+ }
+
+ if ($userenv->{'flags'} & 1 || #user is superlibrarian
+ (haspermission( $uid, { acquisition => q{*} } ) && #user has acq permissions and
+ ($viewbaskets eq 'all' || #user is allowed to see all baskets
+ ($viewbaskets eq 'branch' && $authorisedby && $userbranch eq $basketbranch) || #basket belongs to user's branch
+ ($basket->{authorisedby} && $viewbaskets == 'user' && $authorisedby == $loggedinuser) #user created this basket
+ )
+ )
+ ) {
+ for my $date_field (qw( creationdate closedate)) {
+ if ( $basket->{$date_field} ) {
+ $basket->{$date_field} = format_date( $basket->{$date_field} );
+ }
+ }
+ push @{$loop_basket}, $basket;
+ }
}
- $line{supplierid} = $suppliers[$i]->{'id'};
- $line{name} = $suppliers[$i]->{'name'};
- $line{active} = $suppliers[$i]->{'active'};
- my @loop_basket;
- for ( my $i2 = 0 ; $i2 < $ordcount ; $i2++ ) {
- my %inner_line;
- $inner_line{basketno} = $orders->[$i2]{'basketno'};
- $inner_line{total} = $orders->[$i2]{'count(*)'};
- $inner_line{authorisedby} = $orders->[$i2]{'authorisedby'};
- $inner_line{surname} = $orders->[$i2]{'firstname'};
- $inner_line{firstname} = $orders->[$i2]{'surname'};
- $inner_line{creationdate} = format_date( $orders->[$i2]{'creationdate'} );
- $inner_line{closedate} = format_date( $orders->[$i2]{'closedate'} );
- push @loop_basket, \%inner_line;
- }
- $line{loop_basket} = \@loop_basket;
- push @loop_suppliers, \%line;
+
+ push @{$loop_suppliers},
+ { loop_basket => $loop_basket,
+ supplierid => $vendor->{id},
+ name => $vendor->{name},
+ active => $vendor->{active},
+ };
+
}
$template->param(
- loop_suppliers => \@loop_suppliers,
- supplier => $supplier,
- count => $count,
+ loop_suppliers => $loop_suppliers,
+ supplier => ( $id || $supplier ),
+ count => $supplier_count,
);
output_html_with_http_headers $query, $cookie, $template->output;
+
+sub get_vendors_baskets {
+ my $supplier_id = shift;
+ my $dbh = C4::Context->dbh;
+ my $sql = <<'ENDSQL';
+select aqbasket.*, count(*) as total, borrowers.firstname, borrowers.surname
+from aqbasket left join aqorders on aqorders.basketno = aqbasket.basketno
+left join borrowers on aqbasket.authorisedby = borrowers.borrowernumber
+where booksellerid = ?
+AND ( aqorders.quantity > aqorders.quantityreceived OR quantityreceived IS NULL)
+AND datecancellationprinted IS NULL
+group by basketno
+ENDSQL
+ return $dbh->selectall_arrayref( $sql, { Slice => {} }, $supplier_id );
+}