#!/usr/bin/perl
-# $Id$
-
#script to show display basket of orders
-#written by chris@katipo.co.nz 24/2/2000
-
-# Copyright 2000-2002 Katipo Communications
+# Copyright 2000 - 2004 Katipo
+# Copyright 2008 - 2009 BibLibre SARL
#
# 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.
-use C4::Catalogue;
-use C4::Biblio;
+use strict;
+use warnings;
+use C4::Auth;
+use C4::Koha;
use C4::Output;
use CGI;
-use strict;
+use C4::Acquisition;
+use C4::Budgets;
+use C4::Bookseller qw( GetBookSellerFromId);
+use C4::Debug;
+use C4::Biblio;
+use C4::Members qw/GetMember/; #needed for permissions checking for changing basketgroup of a basket
+use C4::Items;
+use C4::Suggestions;
+use Date::Calc qw/Add_Delta_Days/;
+
+=head1 NAME
+
+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 booksellerid
+
+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('booksellerid');
+
+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('booksellerid') 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 (!defined $op) {
+ $op = q{};
+}
+
+my $confirm_pref= C4::Context->preference("BasketConfirmations") || '1';
+$template->param( skip_confirm_reopen => 1) if $confirm_pref eq '2';
+
+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});
+ $template->param(
+ basketno => $basketno,
+ basketname => $basket->{'basketname'},
+ basketnote => $basket->{note},
+ basketbooksellernote => $basket->{booksellernote},
+ basketcontractno => $basket->{contractnumber},
+ basketcontractname => $contract->{contractname},
+ creationdate => $basket->{creationdate},
+ authorisedby => $basket->{authorisedby},
+ authorisedbyname => $basket->{authorisedbyname},
+ closedate => $basket->{closedate},
+ active => $bookseller->{'active'},
+ booksellerid => $bookseller->{'id'},
+ name => $bookseller->{'name'},
+ address1 => $bookseller->{'address1'},
+ address2 => $bookseller->{'address2'},
+ address3 => $bookseller->{'address3'},
+ address4 => $bookseller->{'address4'},
+ );
+} elsif ($op eq 'attachbasket' && $template->{'VARS'}->{'CAN_user_acquisition_group_manage'} == 1) {
+ print $query->redirect('/cgi-bin/koha/acqui/basketgroup.pl?basketno=' . $basket->{'basketno'} . '&op=attachbasket&booksellerid=' . $booksellerid);
+ # check if we have to "close" a basket before building page
+} elsif ($op eq 'export') {
+ print $query->header(
+ -type => 'text/csv',
+ -attachment => 'basket' . $basket->{'basketno'} . '.csv',
+ );
+ print GetBasketAsCSV($query->param('basketno'));
+ exit;
+} elsif ($op eq 'close') {
+ my $confirm = $query->param('confirm') || $confirm_pref eq '2';
+ if ($confirm) {
+ my $basketno = $query->param('basketno');
+ my $booksellerid = $query->param('booksellerid');
+ $basketno =~ /^\d+$/ and CloseBasket($basketno);
+ # if requested, create basket group, close it and attach the basket
+ if ($query->param('createbasketgroup')) {
+ my $basketgroupid = NewBasketgroup( { name => $basket->{basketname},
+ booksellerid => $booksellerid,
+ closed => 1,
+ });
+ ModBasket( { basketno => $basketno,
+ basketgroupid => $basketgroupid } );
+ print $query->redirect('/cgi-bin/koha/acqui/basketgroup.pl?booksellerid='.$booksellerid.'&closed=1');
+ } else {
+ print $query->redirect('/cgi-bin/koha/acqui/booksellers.pl?booksellerid=' . $booksellerid);
+ }
+ exit;
+ } else {
+ $template->param(confirm_close => "1",
+ booksellerid => $booksellerid,
+ basketno => $basket->{'basketno'},
+ basketname => $basket->{'basketname'},
+ basketgroupname => $basket->{'basketname'});
+
+ }
+} elsif ($op eq 'reopen') {
+ my $basket;
+ $basket->{basketno} = $query->param('basketno');
+ $basket->{closedate} = undef;
+ ModBasket($basket);
+ print $query->redirect('/cgi-bin/koha/acqui/basket.pl?basketno='.$basket->{'basketno'})
+} 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(borrowernumber => $loggedinuser);
+ if ($basket->{closedate} && haspermission({ acquisition => 'group_manage'} )) {
+ $basketgroups = GetBasketgroups($basket->{booksellerid});
+ for my $bg ( @{$basketgroups} ) {
+ if ($basket->{basketgroupid} && $basket->{basketgroupid} == $bg->{id}){
+ $bg->{default} = 1;
+ }
+ }
+ my %emptygroup = ( id => undef,
+ name => "No group");
+ if ( ! $basket->{basketgroupid} ) {
+ $emptygroup{default} = 1;
+ $emptygroup{nogroup} = 1;
+ }
+ unshift( @$basketgroups, \%emptygroup );
+ }
+
+ # if the basket is closed, calculate estimated delivery date
+ my $estimateddeliverydate;
+ if( $basket->{closedate} ) {
+ my ($year, $month, $day) = ($basket->{closedate} =~ /(\d+)-(\d+)-(\d+)/);
+ ($year, $month, $day) = Add_Delta_Days($year, $month, $day, $bookseller->{deliverytime});
+ $estimateddeliverydate = "$year-$month-$day";
+ }
+
+ # 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};
+
+ #to get active currency
+ my $cur = GetCurrency();
+
-my $input=new CGI;
-print $input->header();
-my $basket=$input->param('basket');
-my ($count,@results)=basket($basket);
-print startpage;
+ my @results = GetOrders( $basketno );
+
+ my $gist = $bookseller->{gstrate} // C4::Context->preference("gist") // 0;
+ $gist = 0 if $gist == 0.0000;
+ my $discount = $bookseller->{'discount'} / 100;
+ my $total_rrp = 0; # RRP Total, its value will be assigned to $total_rrp_gsti or $total_rrp_gste depending of $bookseller->{'listincgst'}
+ my $total_rrp_gsti = 0; # RRP Total, GST included
+ my $total_rrp_gste = 0; # RRP Total, GST excluded
+ my $gist_rrp = 0;
+ my $total_rrp_est = 0;
-my @inp=startmenu('acquisitions');
+ my $qty_total;
+ my @books_loop;
+ my $suggestion;
-my $count3=@inp;
-for (my $i=0;$i<$count3;$i++){
- $inp[$i]=~ s/leftmargin=0 topmargin=0\>/leftmargin=0 topmargin=0 onload='update(orderform)'\>/;
+ for my $order ( @results ) {
+ my $rrp = $order->{'listprice'} || 0;
+ my $qty = $order->{'quantity'} || 0;
+ if (!defined $order->{quantityreceived}) {
+ $order->{quantityreceived} = 0;
+ }
+ for ( qw(rrp ecost quantityreceived)) {
+ if (!defined $order->{$_}) {
+ $order->{$_} = 0;
+ }
+ }
+
+ my $budget = GetBudget( $order->{'budget_id'} );
+ $rrp = ConvertCurrency( $order->{'currency'}, $rrp );
+
+ $total_rrp += $qty * $order->{'rrp'};
+ my $line_total = $qty * $order->{'ecost'};
+ $total_rrp_est += $qty * $order->{'ecost'};
+ # FIXME: what about the "actual cost" field?
+ $qty_total += $qty;
+ my %line = %{ $order };
+ my $biblionumber = $order->{'biblionumber'};
+ my $countbiblio = CountBiblioInOrders($biblionumber);
+ my $ordernumber = $order->{'ordernumber'};
+ my @subscriptions = GetSubscriptionsId ($biblionumber);
+ my $itemcount = GetItemsCount($biblionumber);
+ my $holds = GetHolds ($biblionumber);
+ my @items = GetItemnumbersFromOrder( $ordernumber );
+ my $itemholds;
+ foreach my $item (@items){
+ my $nb = GetItemHolds($biblionumber, $item);
+ if ($nb){
+ $itemholds += $nb;
+ }
+ }
+ # if the biblio is not in other orders and if there is no items elsewhere and no subscriptions and no holds we can then show the link "Delete order and Biblio" see bug 5680
+ $line{can_del_bib} = 1 if $countbiblio <= 1 && $itemcount == scalar @items && !(@subscriptions) && !($holds);
+ $line{items} = ($itemcount) - (scalar @items);
+ $line{left_item} = 1 if $line{items} >= 1;
+ $line{left_biblio} = 1 if $countbiblio > 1;
+ $line{biblios} = $countbiblio - 1;
+ $line{left_subscription} = 1 if scalar @subscriptions >= 1;
+ $line{subscriptions} = scalar @subscriptions;
+ ($holds >= 1) ? $line{left_holds} = 1 : $line{left_holds} = 0;
+ $line{left_holds_on_order} = 1 if $line{left_holds}==1 && ($line{items} == 0 || $itemholds );
+ $line{holds} = $holds;
+ $line{holds_on_order} = $itemholds?$itemholds:$holds if $line{left_holds_on_order};
+ $line{order_received} = ( $qty == $order->{'quantityreceived'} );
+ $line{basketno} = $basketno;
+ $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 );
+ if ($line{uncertainprice}) {
+ $template->param( uncertainprices => 1 );
+ $line{rrp} .= ' (Uncertain)';
+ }
+ if ($line{'title'}){
+ my $volume = $order->{'volume'};
+ my $seriestitle = $order->{'seriestitle'};
+ $line{'title'} .= " / $seriestitle" if $seriestitle;
+ $line{'title'} .= " / $volume" if $volume;
+ } else {
+ $line{'title'} = "Deleted bibliographic notice, can't find title.";
+ }
+
+ $suggestion = GetSuggestionInfoFromBiblionumber($line{biblionumber});
+ $line{suggestionid} = $suggestion->{suggestionid};
+ $line{surnamesuggestedby} = $suggestion->{surnamesuggestedby};
+ $line{firstnamesuggestedby} = $suggestion->{firstnamesuggestedby};
+
+ push @books_loop, \%line;
}
-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);
+
+my $total_est_gste;
+ my $total_est_gsti;
+ my $gist_est;
+ if ($gist){ # if we have GST
+ if ( $bookseller->{'listincgst'} ) { # if prices already includes GST
+ $total_rrp_gsti = $total_rrp; # we know $total_rrp_gsti
+ $total_rrp_gste = $total_rrp_gsti / ( $gist + 1 ); # and can reverse compute other values
+ $gist_rrp = $total_rrp_gsti - $total_rrp_gste; #
+ $total_est_gste = $total_rrp_gste - ( $total_rrp_gste * $discount );
+ $total_est_gsti = $total_rrp_est;
+ } else { # if prices does not include GST
+ $total_rrp_gste = $total_rrp; # then we use the common way to compute other values
+ $gist_rrp = $total_rrp_gste * $gist; #
+ $total_rrp_gsti = $total_rrp_gste + $gist_rrp; #
+ $total_est_gste = $total_rrp_est;
+ $total_est_gsti = $total_rrp_gsti - ( $total_rrp_gsti * $discount );
+ }
+ $gist_est = $gist_rrp - ( $gist_rrp * $discount );
+ } else {
+ $total_rrp_gsti = $total_rrp;
+ $total_est_gsti = $total_rrp_est;
}
-$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 $contract = &GetContract($basket->{contractnumber});
+ my @orders = GetOrders($basketno);
+
+ my $borrower= GetMember('borrowernumber' => $loggedinuser);
+ my $budgets = GetBudgetHierarchy(q{},$borrower->{branchcode},$borrower->{borrowernumber});
+ my $has_budgets = 0;
+ foreach my $r (@{$budgets}) {
+ if (!defined $r->{budget_amount} || $r->{budget_amount} == 0) {
+ next;
+ }
+ $has_budgets = 1;
+ last;
+ }
+
+ my @cancelledorders = GetCancelledOrders($basketno);
+ foreach (@cancelledorders) {
+ $_->{'line_total'} = sprintf("%.2f", $_->{'ecost'} * $_->{'quantity'});
+ }
+
+ $template->param(
+ basketno => $basketno,
+ basketname => $basket->{'basketname'},
+ basketnote => $basket->{note},
+ basketbooksellernote => $basket->{booksellernote},
+ basketcontractno => $basket->{contractnumber},
+ basketcontractname => $contract->{contractname},
+ creationdate => $basket->{creationdate},
+ authorisedby => $basket->{authorisedby},
+ authorisedbyname => $basket->{authorisedbyname},
+ closedate => $basket->{closedate},
+ estimateddeliverydate=> $estimateddeliverydate,
+ active => $bookseller->{'active'},
+ booksellerid => $bookseller->{'id'},
+ name => $bookseller->{'name'},
+ books_loop => \@books_loop,
+ cancelledorders_loop => \@cancelledorders,
+ gist_rate => sprintf( "%.2f", $gist * 100 ) . '%',
+ total_rrp_gste => sprintf( "%.2f", $total_rrp_gste ),
+ total_est_gste => sprintf( "%.2f", $total_est_gste ),
+ gist_est => sprintf( "%.2f", $gist_est ),
+ gist_rrp => sprintf( "%.2f", $gist_rrp ),
+ total_rrp_gsti => sprintf( "%.2f", $total_rrp_gsti ),
+ total_est_gsti => sprintf( "%.2f", $total_est_gsti ),
+# currency => $bookseller->{'listprice'},
+ currency => $cur->{'currency'},
+ qty_total => $qty_total,
+ GST => $gist,
+ basketgroups => $basketgroups,
+ grouped => $basket->{basketgroupid},
+ unclosable => @orders ? 0 : 1,
+ has_budgets => $has_budgets,
+ );
}
-#
-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_gimpoz / blobdiff