#!/usr/bin/perl
#script to show display basket of orders
-#written by chris@katipo.co.nz 24/2/2000
-use C4::Acquisitions;
+# Copyright 2000 - 2004 Katipo
+# Copyright 2008 - 2009 BibLibre SARL
+#
+# This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it under the
+# terms of the GNU General Public License as published by the Free Software
+# Foundation; either version 2 of the License, or (at your option) any later
+# version.
+#
+# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
+# 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
+
+use strict;
+use warnings;
+use C4::Auth;
+use C4::Koha;
use C4::Output;
use CGI;
-use strict;
+use C4::Acquisition;
+use C4::Budgets;
-my $input=new CGI;
-print $input->header();
-my $basket=$input->param('basket');
-my ($count,@results)=basket($basket);
-print startpage;
+use C4::Bookseller;
+use C4::Dates qw/format_date/;
+use C4::Debug;
-my @inp=startmenu('acquisitions');
+use C4::Members qw/GetMember/; #needed for permissions checking for changing basketgroup of a basket
+=head1 NAME
-my $count3=@inp;
-for (my $i=0;$i<$count3;$i++){
- $inp[$i]=~ s/leftmargin=0 topmargin=0\>/leftmargin=0 topmargin=0 onload='update(orderform)'\>/;
- }
-print @inp;
-# print $count;
-my ($count2,@booksellers)=bookseller($results[0]->{'booksellerid'});
-
-print <<printend
-<div align=right>
-Our Reference: $basket<br>
-Authorised By: $results[0]->{'authorisedby'}<br>
-$results[0]->{'entrydate'};
-</div>
-<FONT SIZE=6><em>Shopping Basket For: <a href=supplier.pl?id=$results[0]->{'booksellerid'}></a> $booksellers[0]->{'name'}</em></FONT>
-<a href=newbasket.pl?id=$results[0]->{'booksellerid'}&basket=$basket>Add more orders</a>
-<CENTER>
-<FORM ACTION="/cgi-bin/koha/search.pl" method=post>
- <b>Search ISBN, Title or Author:</b> <INPUT TYPE="text" SIZE="25" NAME="recieve">
-</form>
-<p>
-<FORM ACTION="/cgi-bin/koha/acqui/modorders.pl" method=post name=orderform>
-<table border=0 cellspacing=0 cellpadding=5>
-<tr valign=top bgcolor=#99cc33>
- <td background="/images/background-mem.gif"><b>ORDER</b></td>
- <td background="/images/background-mem.gif"><b>ISBN</b></td>
- <td background="/images/background-mem.gif"><b>TITLE</b></td>
- <td background="/images/background-mem.gif"><b>AUTHOR</b></td>
- <td background="/images/background-mem.gif"><b>RRP</b></td>
- <td background="/images/background-mem.gif"><b>\$EST</b></td>
- <td background="/images/background-mem.gif"><b>QUANTITY</b></td>
- <td background="/images/background-mem.gif"><b>TOTAL</b></td></tr>
-printend
-;
-
-
-my $line_total; # total of each line
-my $sub_total; # total of line totals
-my $gist; # GST
-my $grand_total; # $subttotal + $gist
-
-for (my $i=0;$i<$count;$i++){
-my $rrp=$results[$i]->{'listprice'};
-if ($results[$i]->{'currency'} ne 'NZD'){
-$rrp=curconvert($results[$i]->{'currency'},$rrp);
+basket.pl
+
+=head1 DESCRIPTION
+
+ This script display all informations about basket for the supplier given
+ on input arg. Moreover, it allows us to add a new order for this supplier from
+ an existing record, a suggestion or a new record.
+
+=head1 CGI PARAMETERS
+
+=over 4
+
+=item $basketno
+
+The basket number.
+
+=item supplierid
+
+the supplier this script have to display the basket.
+
+=item order
+
+=back
+
+=cut
+
+my $query = new CGI;
+my $basketno = $query->param('basketno');
+my $booksellerid = $query->param('supplierid');
+my $sort = $query->param('order') || "aqorders.ordernumber";
+
+my @sort_loop;
+if (defined $sort) {
+ foreach (split /\,/, $sort) {
+ my %sorthash = (
+ string => $_,
+ );
+ # other possibly valid tables for later: aqbookfund biblio biblioitems
+ if (
+ (/^\s*(biblioitems)\.(\w+)\s*$/ and $2 eq 'publishercode') or
+ (/^\s*(aqorders)\.(\w+)\s*$/ and $2 eq 'ordernumber' )
+ ) {
+ $sorthash{table} = $1;
+ $sorthash{field} = $2;
+ } else {
+ $sorthash{error} = 1;
+ }
+ push @sort_loop, \%sorthash;
+ }
}
-$line_total=$results[$i]->{'quantity'}*$results[$i]->{'ecost'};
-$sub_total+=$line_total;
-$gist=sprintf("%.2f",$sub_total*0.125);
-$grand_total=$sub_total+$gist;
-
-print <<EOP
-<tr valign=top bgcolor=#ffffcc>
- <td>$results[$i]->{'ordernumber'}</td>
- <td>$results[$i]->{'isbn'}</td>
- <td><a href="newbiblio.pl?ordnum=$results[$i]->{'ordernumber'}&id=$results[$i]->{'booksellerid'}&basket=$basket">$results[$i]->{'title'}</a></td>
- <td>$results[$i]->{'author'}</td>
- <td>\$<input type=text name=rrp$i size=6 value="$results[$i]->{'rrp'}"></td>
- <td>\$<input type=text name=eup$i size=6 value="$results[$i]->{'ecost'}"></td>
- <td><input type=text name=quantity$i size=6 value=$results[$i]->{'quantity'} onchange='update(this.form)'></td>
- <td>\$<input type=text name=total$i size=10 value=$line_total></td>
- <input type=hidden name=ordnum$i value=$results[$i]->{'ordernumber'}>
- <input type=hidden name=bibnum$i value=$results[$i]->{'biblionumber'}>
-</tr>
-EOP
-;
+my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
+ {
+ template_name => "acqui/basket.tmpl",
+ query => $query,
+ type => "intranet",
+ authnotrequired => 0,
+ flagsrequired => { acquisition => 'order_manage' },
+ debug => 1,
+ }
+);
+
+my $basket = GetBasket($basketno);
+
+# FIXME : what about the "discount" percentage?
+# FIXME : the query->param('supplierid') below is probably useless. The bookseller is always known from the basket
+# if no booksellerid in parameter, get it from basket
+# warn "=>".$basket->{booksellerid};
+$booksellerid = $basket->{booksellerid} unless $booksellerid;
+my ($bookseller) = GetBookSellerFromId($booksellerid);
+my $op = $query->param('op');
+
+if ( $op eq 'delete_confirm' ) {
+ my $basketno = $query->param('basketno');
+ DelBasket($basketno);
+ $template->param( delete_confirmed => 1 );
+} elsif ( !$bookseller ) {
+ $template->param( NO_BOOKSELLER => 1 );
+} elsif ( $op eq 'del_basket') {
+ $template->param( delete_confirm => 1 );
+ if ( C4::Context->preference("IndependantBranches") ) {
+ my $userenv = C4::Context->userenv;
+ unless ( $userenv->{flags} == 1 ) {
+ my $validtest = ( $basket->{creationdate} eq '' )
+ || ( $userenv->{branch} eq $basket->{branch} )
+ || ( $userenv->{branch} eq '' )
+ || ( $basket->{branch} eq '' );
+ unless ($validtest) {
+ print $query->redirect("../mainpage.pl");
+ exit 1;
+ }
+ }
+ }
+ $basket->{creationdate} = "" unless ( $basket->{creationdate} );
+ $basket->{authorisedby} = $loggedinuser unless ( $basket->{authorisedby} );
+ my $contract = &GetContract($basket->{contractnumber});
+ my $count = scalar GetOrders( $basketno);
+ $template->param(
+ basketno => $basketno,
+ basketname => $basket->{'basketname'},
+ basketnote => $basket->{note},
+ basketbooksellernote => $basket->{booksellernote},
+ basketcontractno => $basket->{contractnumber},
+ basketcontractname => $contract->{contractname},
+ creationdate => format_date( $basket->{creationdate} ),
+ authorisedby => $basket->{authorisedby},
+ authorisedbyname => $basket->{authorisedbyname},
+ closedate => format_date( $basket->{closedate} ),
+ active => $bookseller->{'active'},
+ booksellerid => $bookseller->{'id'},
+ name => $bookseller->{'name'},
+ address1 => $bookseller->{'address1'},
+ address2 => $bookseller->{'address2'},
+ address3 => $bookseller->{'address3'},
+ address4 => $bookseller->{'address4'},
+ count => $count,
+ );
+} else {
+ # get librarian branch...
+ if ( C4::Context->preference("IndependantBranches") ) {
+ my $userenv = C4::Context->userenv;
+ unless ( $userenv->{flags} == 1 ) {
+ my $validtest = ( $basket->{creationdate} eq '' )
+ || ( $userenv->{branch} eq $basket->{branch} )
+ || ( $userenv->{branch} eq '' )
+ || ( $basket->{branch} eq '' );
+ unless ($validtest) {
+ print $query->redirect("../mainpage.pl");
+ exit 1;
+ }
+ }
+ }
+#if the basket is closed,and the user has the permission to edit basketgroups, display a list of basketgroups
+ my $basketgroups;
+ my $member = GetMember($loggedinuser, "borrowernumber");
+ if ($basket->{closedate} && haspermission({ flagsrequired => { acquisition => 'group_manage'} })) {
+ $basketgroups = GetBasketgroups($basket->{booksellerid});
+ for (my $i=0; $i < scalar(@$basketgroups); $i++) {
+ if (@$basketgroups[$i]->{closed}) {
+ splice(@$basketgroups, $i, 1);
+ $i--;
+ } elsif ($basket->{basketgroupid} == @$basketgroups[$i]->{id}){
+ @$basketgroups[$i]->{default} = 1;
+ }
+ }
+ my %emptygroup = ( id => undef,
+ name => "No group");
+ if ( ! $basket->{basketgroupid} ) {
+ $emptygroup{default} = 1;
+ }
+ unshift( @$basketgroups, \%emptygroup );
+ }
+ # if new basket, pre-fill infos
+ $basket->{creationdate} = "" unless ( $basket->{creationdate} );
+ $basket->{authorisedby} = $loggedinuser unless ( $basket->{authorisedby} );
+ $debug
+ and warn sprintf
+ "loggedinuser: $loggedinuser; creationdate: %s; authorisedby: %s",
+ $basket->{creationdate}, $basket->{authorisedby};
+
+ my @results = GetOrders( $basketno, $sort );
+ my $count = scalar @results;
+
+ my $sub_total; # total of line totals
+ my $grand_total; # $subttotal + $gist
+
+ # my $line_total_est; # total of each line
+ my $sub_total_est; # total of line totals
+ my $sub_total_rrp; # total of line totals
+ my $grand_total_est; # $subttotal + $gist
+
+ my $qty_total;
+ my @books_loop;
+
+ for ( my $i = 0 ; $i < $count ; $i++ ) {
+ my $rrp = $results[$i]->{'listprice'};
+ my $qty = $results[$i]->{'quantity'};
+
+ my $budget = GetBudget( $results[$i]->{'budget_id'} );
+ $rrp = ConvertCurrency( $results[$i]->{'currency'}, $rrp );
+
+ $sub_total_rrp += $qty * $results[$i]->{'rrp'};
+ my $line_total = $qty * $results[$i]->{'ecost'};
+ # FIXME: what about the "actual cost" field?
+ $sub_total += $line_total;
+ $qty_total += $qty;
+ my %line = %{ $results[$i] };
+ ($i%2) and $line{toggle} = 1;
+
+ $line{order_received} = ( $qty eq $results[$i]->{'quantityreceived'} );
+ $line{basketno} = $basketno;
+ $line{i} = $i;
+ $line{budget_name} = $budget->{budget_name};
+ $line{rrp} = sprintf( "%.2f", $line{'rrp'} );
+ $line{ecost} = sprintf( "%.2f", $line{'ecost'} );
+ $line{line_total} = sprintf( "%.2f", $line_total );
+ $line{odd} = $i % 2;
+ if ($line{uncertainprice}) {
+ $template->param( unclosable => 1 );
+ for my $key (qw/ecost line_total rrp/) {
+ $line{$key} .= '??';
+ }
+ }
+ push @books_loop, \%line;
+ }
+
+
+
+
+ my $prefgist = $bookseller->{gstrate} || C4::Context->preference("gist") || 0;
+ my $gist = $sub_total * $prefgist;
+ my $gist_rrp = $sub_total_rrp * $prefgist;
+ $grand_total = $sub_total_est = $sub_total;
+ $grand_total_est = $sub_total_est; # FIXME: Too many things that are ALL the SAME
+ my $temp;
+ if ($temp = $bookseller->{'listincgst'}) {
+ $template->param(listincgst => $temp);
+ $gist = 0;
+ } else {
+ $grand_total += $gist;
+ $grand_total_est += $sub_total_est * $prefgist; # same thing as += gist
+ }
+ if ($temp = $bookseller->{'discount'}) {
+ $template->param(discount => sprintf( "%.2f", $temp ));
+ }
+ my $contract = &GetContract($basket->{contractnumber});
+ $template->param(
+ basketno => $basketno,
+ basketname => $basket->{'basketname'},
+ basketnote => $basket->{note},
+ basketbooksellernote => $basket->{booksellernote},
+ basketcontractno => $basket->{contractnumber},
+ basketcontractname => $contract->{contractname},
+ creationdate => format_date( $basket->{creationdate} ),
+ authorisedby => $basket->{authorisedby},
+ authorisedbyname => $basket->{authorisedbyname},
+ closedate => format_date( $basket->{closedate} ),
+ active => $bookseller->{'active'},
+ booksellerid => $bookseller->{'id'},
+ name => $bookseller->{'name'},
+ address1 => $bookseller->{'address1'},
+ address2 => $bookseller->{'address2'},
+ address3 => $bookseller->{'address3'},
+ address4 => $bookseller->{'address4'},
+ entrydate => format_date( $results[0]->{'entrydate'} ),
+ books_loop => \@books_loop,
+ sort_loop => \@sort_loop,
+ count => $count,
+ gist => $gist ? sprintf( "%.2f", $gist ) : 0,
+ gist_rate => sprintf( "%.2f", $prefgist * 100 ) . '%',
+ gist_est => sprintf( "%.2f", $sub_total_est * $prefgist ),
+ gist_rrp => sprintf( "%.2f", $gist_rrp ),
+ sub_total => sprintf( "%.2f", $sub_total ),
+ grand_total => sprintf( "%.2f", $grand_total ),
+ sub_total_est => sprintf( "%.2f", $sub_total_est ),
+ grand_total_est => sprintf( "%.2f", $grand_total_est ),
+ sub_total_rrp => sprintf( "%.2f", $sub_total_rrp ),
+ grand_total_rrp => sprintf( "%.2f", $sub_total_rrp + $gist_rrp ),
+ currency => $bookseller->{'listprice'},
+ qty_total => $qty_total,
+ GST => $prefgist,
+ basketgroups => $basketgroups,
+ grouped => $basket->{basketgroupid},
+ );
}
-#
-print "<input type=hidden name=number value=$count>
-<input type=hidden name=basketno value=\"$basket\">";
-print <<EOP
-<tr valign=top bgcolor=white><td colspan=6 rowspan=3 bgcolor=#cccc99 background="/images/background-mem.gif">
- <b>HELP</b><br>
- To cancel an order, just change the quantity to 0 and click "save changes".<br>
- To change any of the catalogue or accounting information attached to an order, click on the title.<br>
- To add new orders to this supplier, start with a search. </td>
- <td><b>SubTotal</b></td>
- <td>\$<input type=text name=subtotal size=10 value=$sub_total></td></tr>
-<tr valign=top bgcolor=white>
- <td><b>GST</b></td>
- <td>\$<input type=text name=gst size=10 value=$gist></td></tr>
-<tr valign=top bgcolor=white><td><b>TOTAL</b></td>
- <td>\$<input type=text name=grandtotal size=10 value=$grand_total></td></tr>
-<tr valign=top bgcolor=white>
- <td></td>
- <td></td>
- <td></td>
- <td></td>
- <td></td>
- <td></td>
- <td colspan=3><input type=image name=submit src=/images/save-changes.gif border=0 width=187 height=42 align=right></td></tr>
-</table>
-</CENTER>
-EOP
- ;
-
-print endmenu('acquisitions');
-
-print endpage;
+output_html_with_http_headers $query, $cookie, $template->output;
projects / koha_fer / blobdiff