1 package C4::Acquisition;
3 # Copyright 2000-2002 Katipo Communications
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along
17 # with Koha; if not, write to the Free Software Foundation, Inc.,
18 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
26 use C4::Dates qw(format_date format_date_in_iso);
31 use C4::SQLHelper qw(InsertInTable);
32 use C4::Bookseller qw(GetBookSellerFromId);
33 use C4::Templates qw(gettemplate);
38 use vars qw($VERSION @ISA @EXPORT);
41 # set the version for version checking
42 $VERSION = 3.07.00.049;
46 &GetBasket &NewBasket &CloseBasket &DelBasket &ModBasket
47 &GetBasketAsCSV &GetBasketGroupAsCSV
48 &GetBasketsByBookseller &GetBasketsByBasketgroup
49 &GetBasketsInfosByBookseller
53 &ModBasketgroup &NewBasketgroup &DelBasketgroup &GetBasketgroup &CloseBasketgroup
54 &GetBasketgroups &ReOpenBasketgroup
56 &NewOrder &DelOrder &ModOrder &GetPendingOrders &GetOrder &GetOrders &GetOrdersByBiblionumber
57 &GetLateOrders &GetOrderFromItemnumber
58 &SearchOrder &GetHistory &GetRecentAcqui
59 &ModReceiveOrder &CancelReceipt
60 &GetCancelledOrders &TransferOrder
61 &GetLastOrderNotReceivedFromSubscriptionid &GetLastOrderReceivedFromSubscriptionid
62 &NewOrderItem &ModItemOrder
64 &GetParcels &GetParcel
65 &GetContracts &GetContract
76 &GetItemnumbersFromOrder
86 sub GetOrderFromItemnumber {
87 my ($itemnumber) = @_;
88 my $dbh = C4::Context->dbh;
91 SELECT * from aqorders LEFT JOIN aqorders_items
92 ON ( aqorders.ordernumber = aqorders_items.ordernumber )
93 WHERE itemnumber = ? |;
95 my $sth = $dbh->prepare($query);
99 $sth->execute($itemnumber);
101 my $order = $sth->fetchrow_hashref;
106 # Returns the itemnumber(s) associated with the ordernumber given in parameter
107 sub GetItemnumbersFromOrder {
108 my ($ordernumber) = @_;
109 my $dbh = C4::Context->dbh;
110 my $query = "SELECT itemnumber FROM aqorders_items WHERE ordernumber=?";
111 my $sth = $dbh->prepare($query);
112 $sth->execute($ordernumber);
115 while (my $order = $sth->fetchrow_hashref) {
116 push @tab, $order->{'itemnumber'};
130 C4::Acquisition - Koha functions for dealing with orders and acquisitions
138 The functions in this module deal with acquisitions, managing book
139 orders, basket and parcels.
143 =head2 FUNCTIONS ABOUT BASKETS
147 $aqbasket = &GetBasket($basketnumber);
149 get all basket informations in aqbasket for a given basket
151 B<returns:> informations for a given basket returned as a hashref.
157 my $dbh = C4::Context->dbh;
160 concat( b.firstname,' ',b.surname) AS authorisedbyname,
161 b.branchcode AS branch
163 LEFT JOIN borrowers b ON aqbasket.authorisedby=b.borrowernumber
166 my $sth=$dbh->prepare($query);
167 $sth->execute($basketno);
168 my $basket = $sth->fetchrow_hashref;
172 #------------------------------------------------------------#
176 $basket = &NewBasket( $booksellerid, $authorizedby, $basketname,
177 $basketnote, $basketbooksellernote, $basketcontractnumber, $deliveryplace, $billingplace );
179 Create a new basket in aqbasket table
183 =item C<$booksellerid> is a foreign key in the aqbasket table
185 =item C<$authorizedby> is the username of who created the basket
189 The other parameters are optional, see ModBasketHeader for more info on them.
194 my ( $booksellerid, $authorisedby, $basketname, $basketnote,
195 $basketbooksellernote, $basketcontractnumber, $deliveryplace,
196 $billingplace ) = @_;
197 my $dbh = C4::Context->dbh;
199 'INSERT INTO aqbasket (creationdate,booksellerid,authorisedby) '
200 . 'VALUES (now(),?,?)';
201 $dbh->do( $query, {}, $booksellerid, $authorisedby );
203 my $basket = $dbh->{mysql_insertid};
204 $basketname ||= q{}; # default to empty strings
206 $basketbooksellernote ||= q{};
207 ModBasketHeader( $basket, $basketname, $basketnote, $basketbooksellernote,
208 $basketcontractnumber, $booksellerid, $deliveryplace, $billingplace );
212 #------------------------------------------------------------#
216 &CloseBasket($basketno);
218 close a basket (becomes unmodifiable,except for recieves)
224 my $dbh = C4::Context->dbh;
230 my $sth = $dbh->prepare($query);
231 $sth->execute($basketno);
234 #------------------------------------------------------------#
236 =head3 GetBasketAsCSV
238 &GetBasketAsCSV($basketno);
240 Export a basket as CSV
242 $cgi parameter is needed for column name translation
247 my ($basketno, $cgi) = @_;
248 my $basket = GetBasket($basketno);
249 my @orders = GetOrders($basketno);
250 my $contract = GetContract($basket->{'contractnumber'});
252 my $template = C4::Templates::gettemplate("acqui/csv/basket.tmpl", "intranet", $cgi);
255 foreach my $order (@orders) {
256 my $bd = GetBiblioData( $order->{'biblionumber'} );
258 contractname => $contract->{'contractname'},
259 ordernumber => $order->{'ordernumber'},
260 entrydate => $order->{'entrydate'},
261 isbn => $order->{'isbn'},
262 author => $bd->{'author'},
263 title => $bd->{'title'},
264 publicationyear => $bd->{'publicationyear'},
265 publishercode => $bd->{'publishercode'},
266 collectiontitle => $bd->{'collectiontitle'},
267 notes => $order->{'notes'},
268 quantity => $order->{'quantity'},
269 rrp => $order->{'rrp'},
270 deliveryplace => C4::Branch::GetBranchName( $basket->{'deliveryplace'} ),
271 billingplace => C4::Branch::GetBranchName( $basket->{'billingplace'} ),
274 contractname author title publishercode collectiontitle notes
275 deliveryplace billingplace
277 # Double the quotes to not be interpreted as a field end
278 $row->{$_} =~ s/"/""/g if $row->{$_};
284 if(defined $a->{publishercode} and defined $b->{publishercode}) {
285 $a->{publishercode} cmp $b->{publishercode};
289 $template->param(rows => \@rows);
291 return $template->output;
295 =head3 GetBasketGroupAsCSV
299 &GetBasketGroupAsCSV($basketgroupid);
301 Export a basket group as CSV
303 $cgi parameter is needed for column name translation
309 sub GetBasketGroupAsCSV {
310 my ($basketgroupid, $cgi) = @_;
311 my $baskets = GetBasketsByBasketgroup($basketgroupid);
313 my $template = C4::Templates::gettemplate('acqui/csv/basketgroup.tmpl', 'intranet', $cgi);
316 for my $basket (@$baskets) {
317 my @orders = GetOrders( $$basket{basketno} );
318 my $contract = GetContract( $$basket{contractnumber} );
319 my $bookseller = GetBookSellerFromId( $$basket{booksellerid} );
320 my $basketgroup = GetBasketgroup( $$basket{basketgroupid} );
322 foreach my $order (@orders) {
323 my $bd = GetBiblioData( $order->{'biblionumber'} );
325 clientnumber => $bookseller->{accountnumber},
326 basketname => $basket->{basketname},
327 ordernumber => $order->{ordernumber},
328 author => $bd->{author},
329 title => $bd->{title},
330 publishercode => $bd->{publishercode},
331 publicationyear => $bd->{publicationyear},
332 collectiontitle => $bd->{collectiontitle},
333 isbn => $order->{isbn},
334 quantity => $order->{quantity},
335 rrp => $order->{rrp},
336 discount => $bookseller->{discount},
337 ecost => $order->{ecost},
338 notes => $order->{notes},
339 entrydate => $order->{entrydate},
340 booksellername => $bookseller->{name},
341 bookselleraddress => $bookseller->{address1},
342 booksellerpostal => $bookseller->{postal},
343 contractnumber => $contract->{contractnumber},
344 contractname => $contract->{contractname},
345 basketgroupdeliveryplace => C4::Branch::GetBranchName( $basketgroup->{deliveryplace} ),
346 basketgroupbillingplace => C4::Branch::GetBranchName( $basketgroup->{billingplace} ),
347 basketdeliveryplace => C4::Branch::GetBranchName( $basket->{deliveryplace} ),
348 basketbillingplace => C4::Branch::GetBranchName( $basket->{billingplace} ),
351 basketname author title publishercode collectiontitle notes
352 booksellername bookselleraddress booksellerpostal contractname
353 basketgroupdeliveryplace basketgroupbillingplace
354 basketdeliveryplace basketbillingplace
356 # Double the quotes to not be interpreted as a field end
357 $row->{$_} =~ s/"/""/g if $row->{$_};
362 $template->param(rows => \@rows);
364 return $template->output;
368 =head3 CloseBasketgroup
370 &CloseBasketgroup($basketgroupno);
376 sub CloseBasketgroup {
377 my ($basketgroupno) = @_;
378 my $dbh = C4::Context->dbh;
379 my $sth = $dbh->prepare("
380 UPDATE aqbasketgroups
384 $sth->execute($basketgroupno);
387 #------------------------------------------------------------#
389 =head3 ReOpenBaskergroup($basketgroupno)
391 &ReOpenBaskergroup($basketgroupno);
397 sub ReOpenBasketgroup {
398 my ($basketgroupno) = @_;
399 my $dbh = C4::Context->dbh;
400 my $sth = $dbh->prepare("
401 UPDATE aqbasketgroups
405 $sth->execute($basketgroupno);
408 #------------------------------------------------------------#
413 &DelBasket($basketno);
415 Deletes the basket that has basketno field $basketno in the aqbasket table.
419 =item C<$basketno> is the primary key of the basket in the aqbasket table.
426 my ( $basketno ) = @_;
427 my $query = "DELETE FROM aqbasket WHERE basketno=?";
428 my $dbh = C4::Context->dbh;
429 my $sth = $dbh->prepare($query);
430 $sth->execute($basketno);
434 #------------------------------------------------------------#
438 &ModBasket($basketinfo);
440 Modifies a basket, using a hashref $basketinfo for the relevant information, only $basketinfo->{'basketno'} is required.
444 =item C<$basketno> is the primary key of the basket in the aqbasket table.
451 my $basketinfo = shift;
452 my $query = "UPDATE aqbasket SET ";
454 foreach my $key (keys %$basketinfo){
455 if ($key ne 'basketno'){
456 $query .= "$key=?, ";
457 push(@params, $basketinfo->{$key} || undef );
460 # get rid of the "," at the end of $query
461 if (substr($query, length($query)-2) eq ', '){
466 $query .= "WHERE basketno=?";
467 push(@params, $basketinfo->{'basketno'});
468 my $dbh = C4::Context->dbh;
469 my $sth = $dbh->prepare($query);
470 $sth->execute(@params);
474 #------------------------------------------------------------#
476 =head3 ModBasketHeader
478 &ModBasketHeader($basketno, $basketname, $note, $booksellernote, $contractnumber, $booksellerid);
480 Modifies a basket's header.
484 =item C<$basketno> is the "basketno" field in the "aqbasket" table;
486 =item C<$basketname> is the "basketname" field in the "aqbasket" table;
488 =item C<$note> is the "note" field in the "aqbasket" table;
490 =item C<$booksellernote> is the "booksellernote" field in the "aqbasket" table;
492 =item C<$contractnumber> is the "contractnumber" (foreign) key in the "aqbasket" table.
494 =item C<$booksellerid> is the id (foreign) key in the "aqbooksellers" table for the vendor.
496 =item C<$deliveryplace> is the "deliveryplace" field in the aqbasket table.
498 =item C<$billingplace> is the "billingplace" field in the aqbasket table.
504 sub ModBasketHeader {
505 my ($basketno, $basketname, $note, $booksellernote, $contractnumber, $booksellerid, $deliveryplace, $billingplace) = @_;
508 SET basketname=?, note=?, booksellernote=?, booksellerid=?, deliveryplace=?, billingplace=?
512 my $dbh = C4::Context->dbh;
513 my $sth = $dbh->prepare($query);
514 $sth->execute($basketname, $note, $booksellernote, $booksellerid, $deliveryplace, $billingplace, $basketno);
516 if ( $contractnumber ) {
517 my $query2 ="UPDATE aqbasket SET contractnumber=? WHERE basketno=?";
518 my $sth2 = $dbh->prepare($query2);
519 $sth2->execute($contractnumber,$basketno);
525 #------------------------------------------------------------#
527 =head3 GetBasketsByBookseller
529 @results = &GetBasketsByBookseller($booksellerid, $extra);
531 Returns a list of hashes of all the baskets that belong to bookseller 'booksellerid'.
535 =item C<$booksellerid> is the 'id' field of the bookseller in the aqbooksellers table
537 =item C<$extra> is the extra sql parameters, can be
539 $extra->{groupby}: group baskets by column
540 ex. $extra->{groupby} = aqbasket.basketgroupid
541 $extra->{orderby}: order baskets by column
542 $extra->{limit}: limit number of results (can be helpful for pagination)
548 sub GetBasketsByBookseller {
549 my ($booksellerid, $extra) = @_;
550 my $query = "SELECT * FROM aqbasket WHERE booksellerid=?";
552 if ($extra->{groupby}) {
553 $query .= " GROUP by $extra->{groupby}";
555 if ($extra->{orderby}){
556 $query .= " ORDER by $extra->{orderby}";
558 if ($extra->{limit}){
559 $query .= " LIMIT $extra->{limit}";
562 my $dbh = C4::Context->dbh;
563 my $sth = $dbh->prepare($query);
564 $sth->execute($booksellerid);
565 my $results = $sth->fetchall_arrayref({});
570 =head3 GetBasketsInfosByBookseller
572 my $baskets = GetBasketsInfosByBookseller($supplierid, $allbaskets);
574 The optional second parameter allbaskets is a boolean allowing you to
575 select all baskets from the supplier; by default only active baskets (open or
576 closed but still something to receive) are returned.
578 Returns in a arrayref of hashref all about booksellers baskets, plus:
579 total_biblios: Number of distinct biblios in basket
580 total_items: Number of items in basket
581 expected_items: Number of non-received items in basket
585 sub GetBasketsInfosByBookseller {
586 my ($supplierid, $allbaskets) = @_;
588 return unless $supplierid;
590 my $dbh = C4::Context->dbh;
593 SUM(aqorders.quantity) AS total_items,
594 COUNT(DISTINCT aqorders.biblionumber) AS total_biblios,
596 IF(aqorders.datereceived IS NULL
597 AND aqorders.datecancellationprinted IS NULL
602 LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno
603 WHERE booksellerid = ?};
605 $query.=" AND (closedate IS NULL OR (aqorders.quantity > aqorders.quantityreceived AND datecancellationprinted IS NULL))";
607 $query.=" GROUP BY aqbasket.basketno";
609 my $sth = $dbh->prepare($query);
610 $sth->execute($supplierid);
611 return $sth->fetchall_arrayref({});
615 #------------------------------------------------------------#
617 =head3 GetBasketsByBasketgroup
619 $baskets = &GetBasketsByBasketgroup($basketgroupid);
621 Returns a reference to all baskets that belong to basketgroup $basketgroupid.
625 sub GetBasketsByBasketgroup {
626 my $basketgroupid = shift;
628 SELECT *, aqbasket.booksellerid as booksellerid
630 LEFT JOIN aqcontract USING(contractnumber) WHERE basketgroupid=?
632 my $dbh = C4::Context->dbh;
633 my $sth = $dbh->prepare($query);
634 $sth->execute($basketgroupid);
635 my $results = $sth->fetchall_arrayref({});
640 #------------------------------------------------------------#
642 =head3 NewBasketgroup
644 $basketgroupid = NewBasketgroup(\%hashref);
646 Adds a basketgroup to the aqbasketgroups table, and add the initial baskets to it.
648 $hashref->{'booksellerid'} is the 'id' field of the bookseller in the aqbooksellers table,
650 $hashref->{'name'} is the 'name' field of the basketgroup in the aqbasketgroups table,
652 $hashref->{'basketlist'} is a list reference of the 'id's of the baskets that belong to this group,
654 $hashref->{'billingplace'} is the 'billingplace' field of the basketgroup in the aqbasketgroups table,
656 $hashref->{'deliveryplace'} is the 'deliveryplace' field of the basketgroup in the aqbasketgroups table,
658 $hashref->{'freedeliveryplace'} is the 'freedeliveryplace' field of the basketgroup in the aqbasketgroups table,
660 $hashref->{'deliverycomment'} is the 'deliverycomment' field of the basketgroup in the aqbasketgroups table,
662 $hashref->{'closed'} is the 'closed' field of the aqbasketgroups table, it is false if 0, true otherwise.
667 my $basketgroupinfo = shift;
668 die "booksellerid is required to create a basketgroup" unless $basketgroupinfo->{'booksellerid'};
669 my $query = "INSERT INTO aqbasketgroups (";
671 foreach my $field (qw(name billingplace deliveryplace freedeliveryplace deliverycomment closed)) {
672 if ( defined $basketgroupinfo->{$field} ) {
673 $query .= "$field, ";
674 push(@params, $basketgroupinfo->{$field});
677 $query .= "booksellerid) VALUES (";
682 push(@params, $basketgroupinfo->{'booksellerid'});
683 my $dbh = C4::Context->dbh;
684 my $sth = $dbh->prepare($query);
685 $sth->execute(@params);
686 my $basketgroupid = $dbh->{'mysql_insertid'};
687 if( $basketgroupinfo->{'basketlist'} ) {
688 foreach my $basketno (@{$basketgroupinfo->{'basketlist'}}) {
689 my $query2 = "UPDATE aqbasket SET basketgroupid=? WHERE basketno=?";
690 my $sth2 = $dbh->prepare($query2);
691 $sth2->execute($basketgroupid, $basketno);
694 return $basketgroupid;
697 #------------------------------------------------------------#
699 =head3 ModBasketgroup
701 ModBasketgroup(\%hashref);
703 Modifies a basketgroup in the aqbasketgroups table, and add the baskets to it.
705 $hashref->{'id'} is the 'id' field of the basketgroup in the aqbasketgroup table, this parameter is mandatory,
707 $hashref->{'name'} is the 'name' field of the basketgroup in the aqbasketgroups table,
709 $hashref->{'basketlist'} is a list reference of the 'id's of the baskets that belong to this group,
711 $hashref->{'billingplace'} is the 'billingplace' field of the basketgroup in the aqbasketgroups table,
713 $hashref->{'deliveryplace'} is the 'deliveryplace' field of the basketgroup in the aqbasketgroups table,
715 $hashref->{'freedeliveryplace'} is the 'freedeliveryplace' field of the basketgroup in the aqbasketgroups table,
717 $hashref->{'deliverycomment'} is the 'deliverycomment' field of the basketgroup in the aqbasketgroups table,
719 $hashref->{'closed'} is the 'closed' field of the aqbasketgroups table, it is false if 0, true otherwise.
724 my $basketgroupinfo = shift;
725 die "basketgroup id is required to edit a basketgroup" unless $basketgroupinfo->{'id'};
726 my $dbh = C4::Context->dbh;
727 my $query = "UPDATE aqbasketgroups SET ";
729 foreach my $field (qw(name billingplace deliveryplace freedeliveryplace deliverycomment closed)) {
730 if ( defined $basketgroupinfo->{$field} ) {
731 $query .= "$field=?, ";
732 push(@params, $basketgroupinfo->{$field});
737 $query .= " WHERE id=?";
738 push(@params, $basketgroupinfo->{'id'});
739 my $sth = $dbh->prepare($query);
740 $sth->execute(@params);
742 $sth = $dbh->prepare('UPDATE aqbasket SET basketgroupid = NULL WHERE basketgroupid = ?');
743 $sth->execute($basketgroupinfo->{'id'});
745 if($basketgroupinfo->{'basketlist'} && @{$basketgroupinfo->{'basketlist'}}){
746 $sth = $dbh->prepare("UPDATE aqbasket SET basketgroupid=? WHERE basketno=?");
747 foreach my $basketno (@{$basketgroupinfo->{'basketlist'}}) {
748 $sth->execute($basketgroupinfo->{'id'}, $basketno);
755 #------------------------------------------------------------#
757 =head3 DelBasketgroup
759 DelBasketgroup($basketgroupid);
761 Deletes a basketgroup in the aqbasketgroups table, and removes the reference to it from the baskets,
765 =item C<$basketgroupid> is the 'id' field of the basket in the aqbasketgroup table
772 my $basketgroupid = shift;
773 die "basketgroup id is required to edit a basketgroup" unless $basketgroupid;
774 my $query = "DELETE FROM aqbasketgroups WHERE id=?";
775 my $dbh = C4::Context->dbh;
776 my $sth = $dbh->prepare($query);
777 $sth->execute($basketgroupid);
781 #------------------------------------------------------------#
784 =head2 FUNCTIONS ABOUT ORDERS
786 =head3 GetBasketgroup
788 $basketgroup = &GetBasketgroup($basketgroupid);
790 Returns a reference to the hash containing all infermation about the basketgroup.
795 my $basketgroupid = shift;
796 die "basketgroup id is required to edit a basketgroup" unless $basketgroupid;
797 my $query = "SELECT * FROM aqbasketgroups WHERE id=?";
798 my $dbh = C4::Context->dbh;
799 my $sth = $dbh->prepare($query);
800 $sth->execute($basketgroupid);
801 my $result = $sth->fetchrow_hashref;
806 #------------------------------------------------------------#
808 =head3 GetBasketgroups
810 $basketgroups = &GetBasketgroups($booksellerid);
812 Returns a reference to the array of all the basketgroups of bookseller $booksellerid.
816 sub GetBasketgroups {
817 my $booksellerid = shift;
818 die 'bookseller id is required to edit a basketgroup' unless $booksellerid;
819 my $query = 'SELECT * FROM aqbasketgroups WHERE booksellerid=? ORDER BY id DESC';
820 my $dbh = C4::Context->dbh;
821 my $sth = $dbh->prepare($query);
822 $sth->execute($booksellerid);
823 return $sth->fetchall_arrayref({});
826 #------------------------------------------------------------#
828 =head2 FUNCTIONS ABOUT ORDERS
832 #------------------------------------------------------------#
834 =head3 GetPendingOrders
836 $orders = &GetPendingOrders($supplierid,$grouped,$owner,$basketno,$ordernumber,$search,$ean);
838 Finds pending orders from the bookseller with the given ID. Ignores
839 completed and cancelled orders.
841 C<$booksellerid> contains the bookseller identifier
842 C<$owner> contains 0 or 1. 0 means any owner. 1 means only the list of orders entered by the user itself.
843 C<$grouped> is a boolean that, if set to 1 will group all order lines of the same basket
844 in a single result line
845 C<$orders> is a reference-to-array; each element is a reference-to-hash.
847 Used also by the filter in parcel.pl
854 These give the value of the corresponding field in the aqorders table
855 of the Koha database.
857 Results are ordered from most to least recent.
861 sub GetPendingOrders {
862 my ($supplierid,$grouped,$owner,$basketno,$ordernumber,$search,$ean) = @_;
863 my $dbh = C4::Context->dbh;
865 SELECT ".($grouped?"count(*),":"")."aqbasket.basketno,
866 surname,firstname,biblio.*,biblioitems.isbn,
867 aqbasket.closedate, aqbasket.creationdate, aqbasket.basketname,
870 LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno
871 LEFT JOIN borrowers ON aqbasket.authorisedby=borrowers.borrowernumber
872 LEFT JOIN biblio ON biblio.biblionumber=aqorders.biblionumber
873 LEFT JOIN biblioitems ON biblioitems.biblionumber=biblio.biblionumber
874 WHERE (quantity > quantityreceived OR quantityreceived is NULL)
875 AND datecancellationprinted IS NULL";
877 my $userenv = C4::Context->userenv;
878 if ( C4::Context->preference("IndependentBranches") ) {
879 if ( ($userenv) && ( $userenv->{flags} != 1 ) ) {
880 $strsth .= " AND (borrowers.branchcode = ?
881 or borrowers.branchcode = '')";
882 push @query_params, $userenv->{branch};
886 $strsth .= " AND aqbasket.booksellerid = ?";
887 push @query_params, $supplierid;
890 $strsth .= " AND (aqorders.ordernumber=?)";
891 push @query_params, $ordernumber;
894 $strsth .= " AND (biblio.title like ? OR biblio.author LIKE ? OR biblioitems.isbn like ?)";
895 push @query_params, ("%$search%","%$search%","%$search%");
898 $strsth .= " AND biblioitems.ean = ?";
899 push @query_params, $ean;
902 $strsth .= " AND aqbasket.basketno=? ";
903 push @query_params, $basketno;
906 $strsth .= " AND aqbasket.authorisedby=? ";
907 push @query_params, $userenv->{'number'};
909 $strsth .= " group by aqbasket.basketno" if $grouped;
910 $strsth .= " order by aqbasket.basketno";
911 my $sth = $dbh->prepare($strsth);
912 $sth->execute( @query_params );
913 my $results = $sth->fetchall_arrayref({});
918 #------------------------------------------------------------#
922 @orders = &GetOrders($basketnumber, $orderby);
924 Looks up the pending (non-cancelled) orders with the given basket
925 number. If C<$booksellerID> is non-empty, only orders from that seller
929 C<&basket> returns a two-element array. C<@orders> is an array of
930 references-to-hash, whose keys are the fields from the aqorders,
931 biblio, and biblioitems tables in the Koha database.
936 my ( $basketno, $orderby ) = @_;
937 my $dbh = C4::Context->dbh;
939 SELECT biblio.*,biblioitems.*,
944 LEFT JOIN aqbudgets ON aqbudgets.budget_id = aqorders.budget_id
945 LEFT JOIN biblio ON biblio.biblionumber = aqorders.biblionumber
946 LEFT JOIN biblioitems ON biblioitems.biblionumber =biblio.biblionumber
948 AND (datecancellationprinted IS NULL OR datecancellationprinted='0000-00-00')
951 $orderby = "biblioitems.publishercode,biblio.title" unless $orderby;
952 $query .= " ORDER BY $orderby";
953 my $sth = $dbh->prepare($query);
954 $sth->execute($basketno);
955 my $results = $sth->fetchall_arrayref({});
960 #------------------------------------------------------------#
961 =head3 GetOrdersByBiblionumber
963 @orders = &GetOrdersByBiblionumber($biblionumber);
965 Looks up the orders with linked to a specific $biblionumber, including
966 cancelled orders and received orders.
969 C<@orders> is an array of references-to-hash, whose keys are the
970 fields from the aqorders, biblio, and biblioitems tables in the Koha database.
974 sub GetOrdersByBiblionumber {
975 my $biblionumber = shift;
976 return unless $biblionumber;
977 my $dbh = C4::Context->dbh;
979 SELECT biblio.*,biblioitems.*,
983 LEFT JOIN aqbudgets ON aqbudgets.budget_id = aqorders.budget_id
984 LEFT JOIN biblio ON biblio.biblionumber = aqorders.biblionumber
985 LEFT JOIN biblioitems ON biblioitems.biblionumber =biblio.biblionumber
986 WHERE aqorders.biblionumber=?
988 my $sth = $dbh->prepare($query);
989 $sth->execute($biblionumber);
990 my $results = $sth->fetchall_arrayref({});
995 #------------------------------------------------------------#
999 $order = &GetOrder($ordernumber);
1001 Looks up an order by order number.
1003 Returns a reference-to-hash describing the order. The keys of
1004 C<$order> are fields from the biblio, biblioitems, aqorders tables of the Koha database.
1009 my ($ordernumber) = @_;
1010 my $dbh = C4::Context->dbh;
1012 SELECT biblioitems.*, biblio.*, aqorders.*
1014 LEFT JOIN biblio on biblio.biblionumber=aqorders.biblionumber
1015 LEFT JOIN biblioitems on biblioitems.biblionumber=aqorders.biblionumber
1016 WHERE aqorders.ordernumber=?
1019 my $sth= $dbh->prepare($query);
1020 $sth->execute($ordernumber);
1021 my $data = $sth->fetchrow_hashref;
1026 =head3 GetLastOrderNotReceivedFromSubscriptionid
1028 $order = &GetLastOrderNotReceivedFromSubscriptionid($subscriptionid);
1030 Returns a reference-to-hash describing the last order not received for a subscription.
1034 sub GetLastOrderNotReceivedFromSubscriptionid {
1035 my ( $subscriptionid ) = @_;
1036 my $dbh = C4::Context->dbh;
1038 SELECT * FROM aqorders
1039 LEFT JOIN subscription
1040 ON ( aqorders.subscriptionid = subscription.subscriptionid )
1041 WHERE aqorders.subscriptionid = ?
1042 AND aqorders.datereceived IS NULL
1045 my $sth = $dbh->prepare( $query );
1046 $sth->execute( $subscriptionid );
1047 my $order = $sth->fetchrow_hashref;
1051 =head3 GetLastOrderReceivedFromSubscriptionid
1053 $order = &GetLastOrderReceivedFromSubscriptionid($subscriptionid);
1055 Returns a reference-to-hash describing the last order received for a subscription.
1059 sub GetLastOrderReceivedFromSubscriptionid {
1060 my ( $subscriptionid ) = @_;
1061 my $dbh = C4::Context->dbh;
1063 SELECT * FROM aqorders
1064 LEFT JOIN subscription
1065 ON ( aqorders.subscriptionid = subscription.subscriptionid )
1066 WHERE aqorders.subscriptionid = ?
1067 AND aqorders.datereceived =
1069 SELECT MAX( aqorders.datereceived )
1071 LEFT JOIN subscription
1072 ON ( aqorders.subscriptionid = subscription.subscriptionid )
1073 WHERE aqorders.subscriptionid = ?
1074 AND aqorders.datereceived IS NOT NULL
1076 ORDER BY ordernumber DESC
1079 my $sth = $dbh->prepare( $query );
1080 $sth->execute( $subscriptionid, $subscriptionid );
1081 my $order = $sth->fetchrow_hashref;
1087 #------------------------------------------------------------#
1091 &NewOrder(\%hashref);
1093 Adds a new order to the database. Any argument that isn't described
1094 below is the new value of the field with the same name in the aqorders
1095 table of the Koha database.
1099 =item $hashref->{'basketno'} is the basketno foreign key in aqorders, it is mandatory
1101 =item $hashref->{'ordernumber'} is a "minimum order number."
1103 =item $hashref->{'budgetdate'} is effectively ignored.
1104 If it's undef (anything false) or the string 'now', the current day is used.
1105 Else, the upcoming July 1st is used.
1107 =item $hashref->{'subscription'} may be either "yes", or anything else for "no".
1109 =item $hashref->{'uncertainprice'} may be 0 for "the price is known" or 1 for "the price is uncertain"
1111 =item defaults entrydate to Now
1113 The following keys are used: "biblionumber", "title", "basketno", "quantity", "notes", "rrp", "ecost", "gstrate", "unitprice", "subscription", "sort1", "sort2", "booksellerinvoicenumber", "listprice", "budgetdate", "purchaseordernumber", "branchcode", "booksellerinvoicenumber", "budget_id".
1120 my $orderinfo = shift;
1121 #### ------------------------------
1122 my $dbh = C4::Context->dbh;
1126 # if these parameters are missing, we can't continue
1127 for my $key (qw/basketno quantity biblionumber budget_id/) {
1128 croak "Mandatory parameter $key missing" unless $orderinfo->{$key};
1131 if ( defined $orderinfo->{subscription} && $orderinfo->{'subscription'} eq 'yes' ) {
1132 $orderinfo->{'subscription'} = 1;
1134 $orderinfo->{'subscription'} = 0;
1136 $orderinfo->{'entrydate'} ||= C4::Dates->new()->output("iso");
1137 if (!$orderinfo->{quantityreceived}) {
1138 $orderinfo->{quantityreceived} = 0;
1141 my $ordernumber=InsertInTable("aqorders",$orderinfo);
1142 if (not $orderinfo->{parent_ordernumber}) {
1143 my $sth = $dbh->prepare("
1145 SET parent_ordernumber = ordernumber
1146 WHERE ordernumber = ?
1148 $sth->execute($ordernumber);
1150 return ( $orderinfo->{'basketno'}, $ordernumber );
1155 #------------------------------------------------------------#
1164 my ($itemnumber, $ordernumber) = @_;
1165 my $dbh = C4::Context->dbh;
1167 INSERT INTO aqorders_items
1168 (itemnumber, ordernumber)
1171 my $sth = $dbh->prepare($query);
1172 $sth->execute( $itemnumber, $ordernumber);
1175 #------------------------------------------------------------#
1179 &ModOrder(\%hashref);
1181 Modifies an existing order. Updates the order with order number
1182 $hashref->{'ordernumber'} and biblionumber $hashref->{'biblionumber'}. All
1183 other keys of the hash update the fields with the same name in the aqorders
1184 table of the Koha database.
1189 my $orderinfo = shift;
1191 die "Ordernumber is required" if $orderinfo->{'ordernumber'} eq '' ;
1192 die "Biblionumber is required" if $orderinfo->{'biblionumber'} eq '';
1194 my $dbh = C4::Context->dbh;
1197 # update uncertainprice to an integer, just in case (under FF, checked boxes have the value "ON" by default)
1198 $orderinfo->{uncertainprice}=1 if $orderinfo->{uncertainprice};
1200 # delete($orderinfo->{'branchcode'});
1201 # the hash contains a lot of entries not in aqorders, so get the columns ...
1202 my $sth = $dbh->prepare("SELECT * FROM aqorders LIMIT 1;");
1204 my $colnames = $sth->{NAME};
1205 #FIXME Be careful. If aqorders would have columns with diacritics,
1206 #you should need to decode what you get back from NAME.
1207 #See report 10110 and guided_reports.pl
1208 my $query = "UPDATE aqorders SET ";
1210 foreach my $orderinfokey (grep(!/ordernumber/, keys %$orderinfo)){
1211 # ... and skip hash entries that are not in the aqorders table
1212 # FIXME : probably not the best way to do it (would be better to have a correct hash)
1213 next unless grep(/^$orderinfokey$/, @$colnames);
1214 $query .= "$orderinfokey=?, ";
1215 push(@params, $orderinfo->{$orderinfokey});
1218 $query .= "timestamp=NOW() WHERE ordernumber=?";
1219 # push(@params, $specorderinfo{'ordernumber'});
1220 push(@params, $orderinfo->{'ordernumber'} );
1221 $sth = $dbh->prepare($query);
1222 $sth->execute(@params);
1226 #------------------------------------------------------------#
1230 ModItemOrder($itemnumber, $ordernumber);
1232 Modifies the ordernumber of an item in aqorders_items.
1237 my ($itemnumber, $ordernumber) = @_;
1239 return unless ($itemnumber and $ordernumber);
1241 my $dbh = C4::Context->dbh;
1243 UPDATE aqorders_items
1245 WHERE itemnumber = ?
1247 my $sth = $dbh->prepare($query);
1248 return $sth->execute($ordernumber, $itemnumber);
1251 #------------------------------------------------------------#
1253 =head3 GetCancelledOrders
1255 my @orders = GetCancelledOrders($basketno, $orderby);
1257 Returns cancelled orders for a basket
1261 sub GetCancelledOrders {
1262 my ( $basketno, $orderby ) = @_;
1264 return () unless $basketno;
1266 my $dbh = C4::Context->dbh;
1268 SELECT biblio.*, biblioitems.*, aqorders.*, aqbudgets.*
1270 LEFT JOIN aqbudgets ON aqbudgets.budget_id = aqorders.budget_id
1271 LEFT JOIN biblio ON biblio.biblionumber = aqorders.biblionumber
1272 LEFT JOIN biblioitems ON biblioitems.biblionumber = biblio.biblionumber
1274 AND (datecancellationprinted IS NOT NULL
1275 AND datecancellationprinted <> '0000-00-00')
1278 $orderby = "aqorders.datecancellationprinted desc, aqorders.timestamp desc"
1280 $query .= " ORDER BY $orderby";
1281 my $sth = $dbh->prepare($query);
1282 $sth->execute($basketno);
1283 my $results = $sth->fetchall_arrayref( {} );
1289 #------------------------------------------------------------#
1291 =head3 ModReceiveOrder
1293 &ModReceiveOrder($biblionumber, $ordernumber, $quantityreceived, $user,
1294 $cost, $ecost, $invoiceid, rrp, budget_id, datereceived, \@received_itemnumbers);
1296 Updates an order, to reflect the fact that it was received, at least
1297 in part. All arguments not mentioned below update the fields with the
1298 same name in the aqorders table of the Koha database.
1300 If a partial order is received, splits the order into two.
1302 Updates the order with bibilionumber C<$biblionumber> and ordernumber
1308 sub ModReceiveOrder {
1310 $biblionumber, $ordernumber, $quantrec, $user, $cost, $ecost,
1311 $invoiceid, $rrp, $budget_id, $datereceived, $received_items
1315 my $dbh = C4::Context->dbh;
1316 $datereceived = C4::Dates->output('iso') unless $datereceived;
1317 my $suggestionid = GetSuggestionFromBiblionumber( $biblionumber );
1318 if ($suggestionid) {
1319 ModSuggestion( {suggestionid=>$suggestionid,
1320 STATUS=>'AVAILABLE',
1321 biblionumber=> $biblionumber}
1325 my $sth=$dbh->prepare("
1326 SELECT * FROM aqorders
1327 WHERE biblionumber=? AND aqorders.ordernumber=?");
1329 $sth->execute($biblionumber,$ordernumber);
1330 my $order = $sth->fetchrow_hashref();
1333 my $new_ordernumber = $ordernumber;
1334 if ( $order->{quantity} > $quantrec ) {
1335 # Split order line in two parts: the first is the original order line
1336 # without received items (the quantity is decreased),
1337 # the second part is a new order line with quantity=quantityrec
1338 # (entirely received)
1339 $sth=$dbh->prepare("
1342 WHERE ordernumber = ?
1345 $sth->execute($order->{quantity} - $quantrec, $ordernumber);
1349 delete $order->{'ordernumber'};
1350 $order->{'quantity'} = $quantrec;
1351 $order->{'quantityreceived'} = $quantrec;
1352 $order->{'datereceived'} = $datereceived;
1353 $order->{'invoiceid'} = $invoiceid;
1354 $order->{'unitprice'} = $cost;
1355 $order->{'rrp'} = $rrp;
1356 $order->{ecost} = $ecost;
1357 $order->{'orderstatus'} = 3; # totally received
1359 ( $basketno, $new_ordernumber ) = NewOrder($order);
1361 if ($received_items) {
1362 foreach my $itemnumber (@$received_items) {
1363 ModItemOrder($itemnumber, $new_ordernumber);
1367 $sth=$dbh->prepare("update aqorders
1368 set quantityreceived=?,datereceived=?,invoiceid=?,
1369 unitprice=?,rrp=?,ecost=?
1370 where biblionumber=? and ordernumber=?");
1371 $sth->execute($quantrec,$datereceived,$invoiceid,$cost,$rrp,$ecost,$biblionumber,$ordernumber);
1374 return ($datereceived, $new_ordernumber);
1377 =head3 CancelReceipt
1379 my $parent_ordernumber = CancelReceipt($ordernumber);
1381 Cancel an order line receipt and update the parent order line, as if no
1383 If items are created at receipt (AcqCreateItem = receiving) then delete
1389 my $ordernumber = shift;
1391 return unless $ordernumber;
1393 my $dbh = C4::Context->dbh;
1395 SELECT datereceived, parent_ordernumber, quantity
1397 WHERE ordernumber = ?
1399 my $sth = $dbh->prepare($query);
1400 $sth->execute($ordernumber);
1401 my $order = $sth->fetchrow_hashref;
1403 warn "CancelReceipt: order $ordernumber does not exist";
1406 unless($order->{'datereceived'}) {
1407 warn "CancelReceipt: order $ordernumber is not received";
1411 my $parent_ordernumber = $order->{'parent_ordernumber'};
1413 if($parent_ordernumber == $ordernumber || not $parent_ordernumber) {
1414 # The order line has no parent, just mark it as not received
1417 SET quantityreceived = ?,
1420 WHERE ordernumber = ?
1422 $sth = $dbh->prepare($query);
1423 $sth->execute(0, undef, undef, $ordernumber);
1425 # The order line has a parent, increase parent quantity and delete
1428 SELECT quantity, datereceived
1430 WHERE ordernumber = ?
1432 $sth = $dbh->prepare($query);
1433 $sth->execute($parent_ordernumber);
1434 my $parent_order = $sth->fetchrow_hashref;
1435 unless($parent_order) {
1436 warn "Parent order $parent_ordernumber does not exist.";
1439 if($parent_order->{'datereceived'}) {
1440 warn "CancelReceipt: parent order is received.".
1441 " Can't cancel receipt.";
1447 WHERE ordernumber = ?
1449 $sth = $dbh->prepare($query);
1450 my $rv = $sth->execute(
1451 $order->{'quantity'} + $parent_order->{'quantity'},
1455 warn "Cannot update parent order line, so do not cancel".
1459 if(C4::Context->preference('AcqCreateItem') eq 'receiving') {
1460 # Remove items that were created at receipt
1462 DELETE FROM items, aqorders_items
1463 USING items, aqorders_items
1464 WHERE items.itemnumber = ? AND aqorders_items.itemnumber = ?
1466 $sth = $dbh->prepare($query);
1467 my @itemnumbers = GetItemnumbersFromOrder($ordernumber);
1468 foreach my $itemnumber (@itemnumbers) {
1469 $sth->execute($itemnumber, $itemnumber);
1473 my @itemnumbers = GetItemnumbersFromOrder($ordernumber);
1474 foreach my $itemnumber (@itemnumbers) {
1475 ModItemOrder($itemnumber, $parent_ordernumber);
1480 DELETE FROM aqorders
1481 WHERE ordernumber = ?
1483 $sth = $dbh->prepare($query);
1484 $sth->execute($ordernumber);
1488 return $parent_ordernumber;
1491 #------------------------------------------------------------#
1495 @results = &SearchOrder($search, $biblionumber, $complete);
1497 Searches for orders.
1499 C<$search> may take one of several forms: if it is an ISBN,
1500 C<&ordersearch> returns orders with that ISBN. If C<$search> is an
1501 order number, C<&ordersearch> returns orders with that order number
1502 and biblionumber C<$biblionumber>. Otherwise, C<$search> is considered
1503 to be a space-separated list of search terms; in this case, all of the
1504 terms must appear in the title (matching the beginning of title
1507 If C<$complete> is C<yes>, the results will include only completed
1508 orders. In any case, C<&ordersearch> ignores cancelled orders.
1510 C<&ordersearch> returns an array.
1511 C<@results> is an array of references-to-hash with the following keys:
1517 =item C<seriestitle>
1528 #### -------- SearchOrder-------------------------------
1529 my ( $ordernumber, $search, $ean, $supplierid, $basket ) = @_;
1531 my $dbh = C4::Context->dbh;
1536 LEFT JOIN biblio ON aqorders.biblionumber=biblio.biblionumber
1537 LEFT JOIN biblioitems ON biblioitems.biblionumber=biblio.biblionumber
1538 LEFT JOIN aqbasket ON aqorders.basketno = aqbasket.basketno
1539 WHERE (datecancellationprinted is NULL)";
1542 $query .= " AND (aqorders.ordernumber=?)";
1543 push @args, $ordernumber;
1546 $query .= " AND (biblio.title like ? OR biblio.author LIKE ? OR biblioitems.isbn like ?)";
1547 push @args, ("%$search%","%$search%","%$search%");
1550 $query .= " AND biblioitems.ean = ?";
1554 $query .= "AND aqbasket.booksellerid = ?";
1555 push @args, $supplierid;
1558 $query .= "AND aqorders.basketno = ?";
1559 push @args, $basket;
1562 my $sth = $dbh->prepare($query);
1563 $sth->execute(@args);
1564 my $results = $sth->fetchall_arrayref({});
1569 #------------------------------------------------------------#
1573 &DelOrder($biblionumber, $ordernumber);
1575 Cancel the order with the given order and biblio numbers. It does not
1576 delete any entries in the aqorders table, it merely marks them as
1582 my ( $bibnum, $ordernumber ) = @_;
1583 my $dbh = C4::Context->dbh;
1586 SET datecancellationprinted=now()
1587 WHERE biblionumber=? AND ordernumber=?
1589 my $sth = $dbh->prepare($query);
1590 $sth->execute( $bibnum, $ordernumber );
1592 my @itemnumbers = GetItemnumbersFromOrder( $ordernumber );
1593 foreach my $itemnumber (@itemnumbers){
1594 C4::Items::DelItem( $dbh, $bibnum, $itemnumber );
1599 =head3 TransferOrder
1601 my $newordernumber = TransferOrder($ordernumber, $basketno);
1603 Transfer an order line to a basket.
1604 Mark $ordernumber as cancelled with an internal note 'Cancelled and transfered
1605 to BOOKSELLER on DATE' and create new order with internal note
1606 'Transfered from BOOKSELLER on DATE'.
1607 Move all attached items to the new order.
1608 Received orders cannot be transfered.
1609 Return the ordernumber of created order.
1614 my ($ordernumber, $basketno) = @_;
1616 return unless $ordernumber or $basketno;
1618 my $order = GetOrder( $ordernumber );
1619 return if $order->{datereceived};
1621 my $today = C4::Dates->new()->output("iso");
1623 SELECT aqbooksellers.name
1625 LEFT JOIN aqbasket ON aqorders.basketno = aqbasket.basketno
1626 LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id
1627 WHERE aqorders.ordernumber = ?
1629 my $dbh = C4::Context->dbh;
1630 my $sth = $dbh->prepare($query);
1631 $sth->execute($ordernumber);
1632 my ($booksellerfromname) = $sth->fetchrow_array;
1635 SELECT aqbooksellers.name
1637 LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id
1638 WHERE aqbasket.basketno = ?
1640 $sth = $dbh->prepare($query);
1641 $sth->execute($basketno);
1642 my ($booksellertoname) = $sth->fetchrow_array;
1646 SET datecancellationprinted = CAST(NOW() AS date),
1648 WHERE ordernumber = ?
1650 $sth = $dbh->prepare($query);
1651 $sth->execute("Cancelled and transfered to $booksellertoname on $today", $ordernumber);
1653 delete $order->{'ordernumber'};
1654 $order->{'basketno'} = $basketno;
1655 $order->{'internalnotes'} = "Transfered from $booksellerfromname on $today";
1657 (undef, $newordernumber) = NewOrder($order);
1660 UPDATE aqorders_items
1662 WHERE ordernumber = ?
1664 $sth = $dbh->prepare($query);
1665 $sth->execute($newordernumber, $ordernumber);
1667 return $newordernumber;
1670 =head2 FUNCTIONS ABOUT PARCELS
1674 #------------------------------------------------------------#
1678 @results = &GetParcel($booksellerid, $code, $date);
1680 Looks up all of the received items from the supplier with the given
1681 bookseller ID at the given date, for the given code (bookseller Invoice number). Ignores cancelled and completed orders.
1683 C<@results> is an array of references-to-hash. The keys of each element are fields from
1684 the aqorders, biblio, and biblioitems tables of the Koha database.
1686 C<@results> is sorted alphabetically by book title.
1691 #gets all orders from a certain supplier, orders them alphabetically
1692 my ( $supplierid, $code, $datereceived ) = @_;
1693 my $dbh = C4::Context->dbh;
1696 if $code; # add % if we search on a given code (otherwise, let him empty)
1698 SELECT authorisedby,
1703 aqorders.biblionumber,
1704 aqorders.ordernumber,
1705 aqorders.parent_ordernumber,
1707 aqorders.quantityreceived,
1715 LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno
1716 LEFT JOIN borrowers ON aqbasket.authorisedby=borrowers.borrowernumber
1717 LEFT JOIN biblio ON aqorders.biblionumber=biblio.biblionumber
1718 LEFT JOIN aqinvoices ON aqorders.invoiceid = aqinvoices.invoiceid
1720 aqbasket.booksellerid = ?
1721 AND aqinvoices.invoicenumber LIKE ?
1722 AND aqorders.datereceived = ? ";
1724 my @query_params = ( $supplierid, $code, $datereceived );
1725 if ( C4::Context->preference("IndependentBranches") ) {
1726 my $userenv = C4::Context->userenv;
1727 if ( ($userenv) && ( $userenv->{flags} != 1 ) ) {
1728 $strsth .= " and (borrowers.branchcode = ?
1729 or borrowers.branchcode = '')";
1730 push @query_params, $userenv->{branch};
1733 $strsth .= " ORDER BY aqbasket.basketno";
1734 # ## parcelinformation : $strsth
1735 my $sth = $dbh->prepare($strsth);
1736 $sth->execute( @query_params );
1737 while ( my $data = $sth->fetchrow_hashref ) {
1738 push( @results, $data );
1740 # ## countparcelbiblio: scalar(@results)
1746 #------------------------------------------------------------#
1750 $results = &GetParcels($bookseller, $order, $code, $datefrom, $dateto);
1752 get a lists of parcels.
1759 is the bookseller this function has to get parcels.
1762 To know on what criteria the results list has to be ordered.
1765 is the booksellerinvoicenumber.
1767 =item $datefrom & $dateto
1768 to know on what date this function has to filter its search.
1773 a pointer on a hash list containing parcel informations as such :
1779 =item Last operation
1781 =item Number of biblio
1783 =item Number of items
1790 my ($bookseller,$order, $code, $datefrom, $dateto) = @_;
1791 my $dbh = C4::Context->dbh;
1792 my @query_params = ();
1794 SELECT aqinvoices.invoicenumber,
1795 datereceived,purchaseordernumber,
1796 count(DISTINCT biblionumber) AS biblio,
1797 sum(quantity) AS itemsexpected,
1798 sum(quantityreceived) AS itemsreceived
1799 FROM aqorders LEFT JOIN aqbasket ON aqbasket.basketno = aqorders.basketno
1800 LEFT JOIN aqinvoices ON aqorders.invoiceid = aqinvoices.invoiceid
1801 WHERE aqbasket.booksellerid = ? and datereceived IS NOT NULL
1803 push @query_params, $bookseller;
1805 if ( defined $code ) {
1806 $strsth .= ' and aqinvoices.invoicenumber like ? ';
1807 # add a % to the end of the code to allow stemming.
1808 push @query_params, "$code%";
1811 if ( defined $datefrom ) {
1812 $strsth .= ' and datereceived >= ? ';
1813 push @query_params, $datefrom;
1816 if ( defined $dateto ) {
1817 $strsth .= 'and datereceived <= ? ';
1818 push @query_params, $dateto;
1821 $strsth .= "group by aqinvoices.invoicenumber,datereceived ";
1823 # can't use a placeholder to place this column name.
1824 # but, we could probably be checking to make sure it is a column that will be fetched.
1825 $strsth .= "order by $order " if ($order);
1827 my $sth = $dbh->prepare($strsth);
1829 $sth->execute( @query_params );
1830 my $results = $sth->fetchall_arrayref({});
1835 #------------------------------------------------------------#
1837 =head3 GetLateOrders
1839 @results = &GetLateOrders;
1841 Searches for bookseller with late orders.
1844 the table of supplier with late issues. This table is full of hashref.
1850 my $supplierid = shift;
1852 my $estimateddeliverydatefrom = shift;
1853 my $estimateddeliverydateto = shift;
1855 my $dbh = C4::Context->dbh;
1857 #BEWARE, order of parenthesis and LEFT JOIN is important for speed
1858 my $dbdriver = C4::Context->config("db_scheme") || "mysql";
1860 my @query_params = ();
1862 SELECT aqbasket.basketno,
1863 aqorders.ordernumber,
1864 DATE(aqbasket.closedate) AS orderdate,
1865 aqorders.rrp AS unitpricesupplier,
1866 aqorders.ecost AS unitpricelib,
1867 aqorders.claims_count AS claims_count,
1868 aqorders.claimed_date AS claimed_date,
1869 aqbudgets.budget_name AS budget,
1870 borrowers.branchcode AS branch,
1871 aqbooksellers.name AS supplier,
1872 aqbooksellers.id AS supplierid,
1873 biblio.author, biblio.title,
1874 biblioitems.publishercode AS publisher,
1875 biblioitems.publicationyear,
1876 ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) AS estimateddeliverydate,
1880 aqorders LEFT JOIN biblio ON biblio.biblionumber = aqorders.biblionumber
1881 LEFT JOIN biblioitems ON biblioitems.biblionumber = biblio.biblionumber
1882 LEFT JOIN aqbudgets ON aqorders.budget_id = aqbudgets.budget_id,
1883 aqbasket LEFT JOIN borrowers ON aqbasket.authorisedby = borrowers.borrowernumber
1884 LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id
1885 WHERE aqorders.basketno = aqbasket.basketno
1886 AND ( datereceived = ''
1887 OR datereceived IS NULL
1888 OR aqorders.quantityreceived < aqorders.quantity
1890 AND aqbasket.closedate IS NOT NULL
1891 AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00')
1894 if ($dbdriver eq "mysql") {
1896 aqorders.quantity - COALESCE(aqorders.quantityreceived,0) AS quantity,
1897 (aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal,
1898 DATEDIFF(CAST(now() AS date),closedate) AS latesince
1900 if ( defined $delay ) {
1901 $from .= " AND (closedate <= DATE_SUB(CAST(now() AS date),INTERVAL ? DAY)) " ;
1902 push @query_params, $delay;
1905 HAVING quantity <> 0
1906 AND unitpricesupplier <> 0
1907 AND unitpricelib <> 0
1910 # FIXME: account for IFNULL as above
1912 aqorders.quantity AS quantity,
1913 aqorders.quantity * aqorders.rrp AS subtotal,
1914 (CAST(now() AS date) - closedate) AS latesince
1916 if ( defined $delay ) {
1917 $from .= " AND (closedate <= (CAST(now() AS date) -(INTERVAL ? DAY)) ";
1918 push @query_params, $delay;
1921 if (defined $supplierid) {
1922 $from .= ' AND aqbasket.booksellerid = ? ';
1923 push @query_params, $supplierid;
1925 if (defined $branch) {
1926 $from .= ' AND borrowers.branchcode LIKE ? ';
1927 push @query_params, $branch;
1930 if ( defined $estimateddeliverydatefrom or defined $estimateddeliverydateto ) {
1931 $from .= ' AND aqbooksellers.deliverytime IS NOT NULL ';
1933 if ( defined $estimateddeliverydatefrom ) {
1934 $from .= ' AND ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) >= ?';
1935 push @query_params, $estimateddeliverydatefrom;
1937 if ( defined $estimateddeliverydateto ) {
1938 $from .= ' AND ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) <= ?';
1939 push @query_params, $estimateddeliverydateto;
1941 if ( defined $estimateddeliverydatefrom and not defined $estimateddeliverydateto ) {
1942 $from .= ' AND ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) <= CAST(now() AS date)';
1944 if (C4::Context->preference("IndependentBranches")
1945 && C4::Context->userenv
1946 && C4::Context->userenv->{flags} != 1 ) {
1947 $from .= ' AND borrowers.branchcode LIKE ? ';
1948 push @query_params, C4::Context->userenv->{branch};
1950 my $query = "$select $from $having\nORDER BY latesince, basketno, borrowers.branchcode, supplier";
1951 $debug and print STDERR "GetLateOrders query: $query\nGetLateOrders args: " . join(" ",@query_params);
1952 my $sth = $dbh->prepare($query);
1953 $sth->execute(@query_params);
1955 while (my $data = $sth->fetchrow_hashref) {
1956 $data->{orderdate} = format_date($data->{orderdate});
1957 $data->{claimed_date} = format_date($data->{claimed_date});
1958 push @results, $data;
1963 #------------------------------------------------------------#
1967 (\@order_loop, $total_qty, $total_price, $total_qtyreceived) = GetHistory( %params );
1969 Retreives some acquisition history information
1977 basket - search both basket name and number
1978 booksellerinvoicenumber
1981 $order_loop is a list of hashrefs that each look like this:
1983 'author' => 'Twain, Mark',
1985 'biblionumber' => '215',
1987 'creationdate' => 'MM/DD/YYYY',
1988 'datereceived' => undef,
1991 'invoicenumber' => undef,
1993 'ordernumber' => '1',
1995 'quantityreceived' => undef,
1996 'title' => 'The Adventures of Huckleberry Finn'
1998 $total_qty is the sum of all of the quantities in $order_loop
1999 $total_price is the cost of each in $order_loop times the quantity
2000 $total_qtyreceived is the sum of all of the quantityreceived entries in $order_loop
2005 # don't run the query if there are no parameters (list would be too long for sure !)
2006 croak "No search params" unless @_;
2008 my $title = $params{title};
2009 my $author = $params{author};
2010 my $isbn = $params{isbn};
2011 my $ean = $params{ean};
2012 my $name = $params{name};
2013 my $from_placed_on = $params{from_placed_on};
2014 my $to_placed_on = $params{to_placed_on};
2015 my $basket = $params{basket};
2016 my $booksellerinvoicenumber = $params{booksellerinvoicenumber};
2017 my $basketgroupname = $params{basketgroupname};
2020 my $total_qtyreceived = 0;
2021 my $total_price = 0;
2023 my $dbh = C4::Context->dbh;
2031 aqbasket.basketname,
2032 aqbasket.basketgroupid,
2033 aqbasketgroups.name as groupname,
2035 aqbasket.creationdate,
2036 aqorders.datereceived,
2038 aqorders.quantityreceived,
2040 aqorders.ordernumber,
2042 aqinvoices.invoicenumber,
2043 aqbooksellers.id as id,
2044 aqorders.biblionumber
2046 LEFT JOIN aqbasket ON aqorders.basketno=aqbasket.basketno
2047 LEFT JOIN aqbasketgroups ON aqbasket.basketgroupid=aqbasketgroups.id
2048 LEFT JOIN aqbooksellers ON aqbasket.booksellerid=aqbooksellers.id
2049 LEFT JOIN biblioitems ON biblioitems.biblionumber=aqorders.biblionumber
2050 LEFT JOIN biblio ON biblio.biblionumber=aqorders.biblionumber
2051 LEFT JOIN aqinvoices ON aqorders.invoiceid = aqinvoices.invoiceid";
2053 $query .= " LEFT JOIN borrowers ON aqbasket.authorisedby=borrowers.borrowernumber"
2054 if ( C4::Context->preference("IndependentBranches") );
2056 $query .= " WHERE (datecancellationprinted is NULL or datecancellationprinted='0000-00-00') ";
2058 my @query_params = ();
2061 $query .= " AND biblio.title LIKE ? ";
2062 $title =~ s/\s+/%/g;
2063 push @query_params, "%$title%";
2067 $query .= " AND biblio.author LIKE ? ";
2068 push @query_params, "%$author%";
2072 $query .= " AND biblioitems.isbn LIKE ? ";
2073 push @query_params, "%$isbn%";
2075 if ( defined $ean and $ean ) {
2076 $query .= " AND biblioitems.ean = ? ";
2077 push @query_params, "$ean";
2080 $query .= " AND aqbooksellers.name LIKE ? ";
2081 push @query_params, "%$name%";
2084 if ( $from_placed_on ) {
2085 $query .= " AND creationdate >= ? ";
2086 push @query_params, $from_placed_on;
2089 if ( $to_placed_on ) {
2090 $query .= " AND creationdate <= ? ";
2091 push @query_params, $to_placed_on;
2095 if ($basket =~ m/^\d+$/) {
2096 $query .= " AND aqorders.basketno = ? ";
2097 push @query_params, $basket;
2099 $query .= " AND aqbasket.basketname LIKE ? ";
2100 push @query_params, "%$basket%";
2104 if ($booksellerinvoicenumber) {
2105 $query .= " AND aqinvoices.invoicenumber LIKE ? ";
2106 push @query_params, "%$booksellerinvoicenumber%";
2109 if ($basketgroupname) {
2110 $query .= " AND aqbasketgroups.name LIKE ? ";
2111 push @query_params, "%$basketgroupname%";
2114 if ( C4::Context->preference("IndependentBranches") ) {
2115 my $userenv = C4::Context->userenv;
2116 if ( $userenv && ($userenv->{flags} || 0) != 1 ) {
2117 $query .= " AND (borrowers.branchcode = ? OR borrowers.branchcode ='' ) ";
2118 push @query_params, $userenv->{branch};
2121 $query .= " ORDER BY id";
2122 my $sth = $dbh->prepare($query);
2123 $sth->execute( @query_params );
2125 while ( my $line = $sth->fetchrow_hashref ) {
2126 $line->{count} = $cnt++;
2127 $line->{toggle} = 1 if $cnt % 2;
2128 push @order_loop, $line;
2129 $total_qty += $line->{'quantity'};
2130 $total_qtyreceived += $line->{'quantityreceived'};
2131 $total_price += $line->{'quantity'} * $line->{'ecost'};
2133 return \@order_loop, $total_qty, $total_price, $total_qtyreceived;
2136 =head2 GetRecentAcqui
2138 $results = GetRecentAcqui($days);
2140 C<$results> is a ref to a table which containts hashref
2144 sub GetRecentAcqui {
2146 my $dbh = C4::Context->dbh;
2150 ORDER BY timestamp DESC
2153 my $sth = $dbh->prepare($query);
2155 my $results = $sth->fetchall_arrayref({});
2161 $contractlist = &GetContracts($booksellerid, $activeonly);
2163 Looks up the contracts that belong to a bookseller
2165 Returns a list of contracts
2169 =item C<$booksellerid> is the "id" field in the "aqbooksellers" table.
2171 =item C<$activeonly> if exists get only contracts that are still active.
2178 my ( $booksellerid, $activeonly ) = @_;
2179 my $dbh = C4::Context->dbh;
2181 if (! $activeonly) {
2185 WHERE booksellerid=?
2190 WHERE booksellerid=?
2191 AND contractenddate >= CURDATE( )";
2193 my $sth = $dbh->prepare($query);
2194 $sth->execute( $booksellerid );
2196 while (my $data = $sth->fetchrow_hashref ) {
2197 push(@results, $data);
2203 #------------------------------------------------------------#
2207 $contract = &GetContract($contractID);
2209 Looks up the contract that has PRIMKEY (contractnumber) value $contractID
2216 my ( $contractno ) = @_;
2217 my $dbh = C4::Context->dbh;
2221 WHERE contractnumber=?
2224 my $sth = $dbh->prepare($query);
2225 $sth->execute( $contractno );
2226 my $result = $sth->fetchrow_hashref;
2234 &AddClaim($ordernumber);
2236 Add a claim for an order
2242 my ($ordernumber) = @_;
2243 my $dbh = C4::Context->dbh;
2246 claims_count = claims_count + 1,
2247 claimed_date = CURDATE()
2248 WHERE ordernumber = ?
2250 my $sth = $dbh->prepare($query);
2251 $sth->execute($ordernumber);
2256 my @invoices = GetInvoices(
2257 invoicenumber => $invoicenumber,
2258 suppliername => $suppliername,
2259 shipmentdatefrom => $shipmentdatefrom, # ISO format
2260 shipmentdateto => $shipmentdateto, # ISO format
2261 billingdatefrom => $billingdatefrom, # ISO format
2262 billingdateto => $billingdateto, # ISO format
2263 isbneanissn => $isbn_or_ean_or_issn,
2266 publisher => $publisher,
2267 publicationyear => $publicationyear,
2268 branchcode => $branchcode,
2269 order_by => $order_by
2272 Return a list of invoices that match all given criteria.
2274 $order_by is "column_name (asc|desc)", where column_name is any of
2275 'invoicenumber', 'booksellerid', 'shipmentdate', 'billingdate', 'closedate',
2276 'shipmentcost', 'shipmentcost_budgetid'.
2278 asc is the default if omitted
2285 my @columns = qw(invoicenumber booksellerid shipmentdate billingdate
2286 closedate shipmentcost shipmentcost_budgetid);
2288 my $dbh = C4::Context->dbh;
2290 SELECT aqinvoices.*, aqbooksellers.name AS suppliername,
2293 aqorders.datereceived IS NOT NULL,
2294 aqorders.biblionumber,
2297 ) AS receivedbiblios,
2298 SUM(aqorders.quantityreceived) AS receiveditems
2300 LEFT JOIN aqbooksellers ON aqbooksellers.id = aqinvoices.booksellerid
2301 LEFT JOIN aqorders ON aqorders.invoiceid = aqinvoices.invoiceid
2302 LEFT JOIN biblio ON aqorders.biblionumber = biblio.biblionumber
2303 LEFT JOIN biblioitems ON biblio.biblionumber = biblioitems.biblionumber
2304 LEFT JOIN subscription ON biblio.biblionumber = subscription.biblionumber
2309 if($args{supplierid}) {
2310 push @bind_strs, " aqinvoices.booksellerid = ? ";
2311 push @bind_args, $args{supplierid};
2313 if($args{invoicenumber}) {
2314 push @bind_strs, " aqinvoices.invoicenumber LIKE ? ";
2315 push @bind_args, "%$args{invoicenumber}%";
2317 if($args{suppliername}) {
2318 push @bind_strs, " aqbooksellers.name LIKE ? ";
2319 push @bind_args, "%$args{suppliername}%";
2321 if($args{shipmentdatefrom}) {
2322 push @bind_strs, " aqinvoices.shipementdate >= ? ";
2323 push @bind_args, $args{shipmentdatefrom};
2325 if($args{shipmentdateto}) {
2326 push @bind_strs, " aqinvoices.shipementdate <= ? ";
2327 push @bind_args, $args{shipmentdateto};
2329 if($args{billingdatefrom}) {
2330 push @bind_strs, " aqinvoices.billingdate >= ? ";
2331 push @bind_args, $args{billingdatefrom};
2333 if($args{billingdateto}) {
2334 push @bind_strs, " aqinvoices.billingdate <= ? ";
2335 push @bind_args, $args{billingdateto};
2337 if($args{isbneanissn}) {
2338 push @bind_strs, " (biblioitems.isbn LIKE ? OR biblioitems.ean LIKE ? OR biblioitems.issn LIKE ? ) ";
2339 push @bind_args, $args{isbneanissn}, $args{isbneanissn}, $args{isbneanissn};
2342 push @bind_strs, " biblio.title LIKE ? ";
2343 push @bind_args, $args{title};
2346 push @bind_strs, " biblio.author LIKE ? ";
2347 push @bind_args, $args{author};
2349 if($args{publisher}) {
2350 push @bind_strs, " biblioitems.publishercode LIKE ? ";
2351 push @bind_args, $args{publisher};
2353 if($args{publicationyear}) {
2354 push @bind_strs, " biblioitems.publicationyear = ? ";
2355 push @bind_args, $args{publicationyear};
2357 if($args{branchcode}) {
2358 push @bind_strs, " aqorders.branchcode = ? ";
2359 push @bind_args, $args{branchcode};
2362 $query .= " WHERE " . join(" AND ", @bind_strs) if @bind_strs;
2363 $query .= " GROUP BY aqinvoices.invoiceid ";
2365 if($args{order_by}) {
2366 my ($column, $direction) = split / /, $args{order_by};
2367 if(grep /^$column$/, @columns) {
2368 $direction ||= 'ASC';
2369 $query .= " ORDER BY $column $direction";
2373 my $sth = $dbh->prepare($query);
2374 $sth->execute(@bind_args);
2376 my $results = $sth->fetchall_arrayref({});
2382 my $invoice = GetInvoice($invoiceid);
2384 Get informations about invoice with given $invoiceid
2386 Return a hash filled with aqinvoices.* fields
2391 my ($invoiceid) = @_;
2394 return unless $invoiceid;
2396 my $dbh = C4::Context->dbh;
2402 my $sth = $dbh->prepare($query);
2403 $sth->execute($invoiceid);
2405 $invoice = $sth->fetchrow_hashref;
2409 =head3 GetInvoiceDetails
2411 my $invoice = GetInvoiceDetails($invoiceid)
2413 Return informations about an invoice + the list of related order lines
2415 Orders informations are in $invoice->{orders} (array ref)
2419 sub GetInvoiceDetails {
2420 my ($invoiceid) = @_;
2422 if ( !defined $invoiceid ) {
2423 carp 'GetInvoiceDetails called without an invoiceid';
2427 my $dbh = C4::Context->dbh;
2429 SELECT aqinvoices.*, aqbooksellers.name AS suppliername
2431 LEFT JOIN aqbooksellers ON aqinvoices.booksellerid = aqbooksellers.id
2434 my $sth = $dbh->prepare($query);
2435 $sth->execute($invoiceid);
2437 my $invoice = $sth->fetchrow_hashref;
2440 SELECT aqorders.*, biblio.*
2442 LEFT JOIN biblio ON aqorders.biblionumber = biblio.biblionumber
2445 $sth = $dbh->prepare($query);
2446 $sth->execute($invoiceid);
2447 $invoice->{orders} = $sth->fetchall_arrayref({});
2448 $invoice->{orders} ||= []; # force an empty arrayref if fetchall_arrayref fails
2455 my $invoiceid = AddInvoice(
2456 invoicenumber => $invoicenumber,
2457 booksellerid => $booksellerid,
2458 shipmentdate => $shipmentdate,
2459 billingdate => $billingdate,
2460 closedate => $closedate,
2461 shipmentcost => $shipmentcost,
2462 shipmentcost_budgetid => $shipmentcost_budgetid
2465 Create a new invoice and return its id or undef if it fails.
2472 return unless(%invoice and $invoice{invoicenumber});
2474 my @columns = qw(invoicenumber booksellerid shipmentdate billingdate
2475 closedate shipmentcost shipmentcost_budgetid);
2479 foreach my $key (keys %invoice) {
2480 if(0 < grep(/^$key$/, @columns)) {
2481 push @set_strs, "$key = ?";
2482 push @set_args, ($invoice{$key} || undef);
2488 my $dbh = C4::Context->dbh;
2489 my $query = "INSERT INTO aqinvoices SET ";
2490 $query .= join (",", @set_strs);
2491 my $sth = $dbh->prepare($query);
2492 $rv = $sth->execute(@set_args);
2494 $rv = $dbh->last_insert_id(undef, undef, 'aqinvoices', undef);
2503 invoiceid => $invoiceid, # Mandatory
2504 invoicenumber => $invoicenumber,
2505 booksellerid => $booksellerid,
2506 shipmentdate => $shipmentdate,
2507 billingdate => $billingdate,
2508 closedate => $closedate,
2509 shipmentcost => $shipmentcost,
2510 shipmentcost_budgetid => $shipmentcost_budgetid
2513 Modify an invoice, invoiceid is mandatory.
2515 Return undef if it fails.
2522 return unless(%invoice and $invoice{invoiceid});
2524 my @columns = qw(invoicenumber booksellerid shipmentdate billingdate
2525 closedate shipmentcost shipmentcost_budgetid);
2529 foreach my $key (keys %invoice) {
2530 if(0 < grep(/^$key$/, @columns)) {
2531 push @set_strs, "$key = ?";
2532 push @set_args, ($invoice{$key} || undef);
2536 my $dbh = C4::Context->dbh;
2537 my $query = "UPDATE aqinvoices SET ";
2538 $query .= join(",", @set_strs);
2539 $query .= " WHERE invoiceid = ?";
2541 my $sth = $dbh->prepare($query);
2542 $sth->execute(@set_args, $invoice{invoiceid});
2547 CloseInvoice($invoiceid);
2551 Equivalent to ModInvoice(invoiceid => $invoiceid, closedate => undef);
2556 my ($invoiceid) = @_;
2558 return unless $invoiceid;
2560 my $dbh = C4::Context->dbh;
2563 SET closedate = CAST(NOW() AS DATE)
2566 my $sth = $dbh->prepare($query);
2567 $sth->execute($invoiceid);
2570 =head3 ReopenInvoice
2572 ReopenInvoice($invoiceid);
2576 Equivalent to ModInvoice(invoiceid => $invoiceid, closedate => C4::Dates->new()->output('iso'))
2581 my ($invoiceid) = @_;
2583 return unless $invoiceid;
2585 my $dbh = C4::Context->dbh;
2588 SET closedate = NULL
2591 my $sth = $dbh->prepare($query);
2592 $sth->execute($invoiceid);
2597 DelInvoice($invoiceid);
2599 Delete an invoice if there are no items attached to it.
2604 my ($invoiceid) = @_;
2606 return unless $invoiceid;
2608 my $dbh = C4::Context->dbh;
2614 my $sth = $dbh->prepare($query);
2615 $sth->execute($invoiceid);
2616 my $res = $sth->fetchrow_arrayref;
2617 if ( $res && $res->[0] == 0 ) {
2619 DELETE FROM aqinvoices
2622 my $sth = $dbh->prepare($query);
2623 return ( $sth->execute($invoiceid) > 0 );
2633 Koha Development Team <http://koha-community.org/>