[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] koha/C4 Acquisition.pm [rel_3_0]
From: |
Antoine Farnault |
Subject: |
[Koha-cvs] koha/C4 Acquisition.pm [rel_3_0] |
Date: |
Mon, 30 Oct 2006 13:21:40 +0000 |
CVSROOT: /sources/koha
Module name: koha
Branch: rel_3_0
Changes by: Antoine Farnault <toins> 06/10/30 13:21:40
Modified files:
C4 : Acquisition.pm
Log message:
make SQL query from GetOrders compatible with mysql 5.0
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Acquisition.pm?cvsroot=koha&only_with_tag=rel_3_0&r1=1.43&r2=1.43.2.1
Patches:
Index: Acquisition.pm
===================================================================
RCS file: /sources/koha/koha/C4/Acquisition.pm,v
retrieving revision 1.43
retrieving revision 1.43.2.1
diff -u -b -r1.43 -r1.43.2.1
--- Acquisition.pm 1 Aug 2006 08:47:49 -0000 1.43
+++ Acquisition.pm 30 Oct 2006 13:21:40 -0000 1.43.2.1
@@ -17,7 +17,7 @@
# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
# Suite 330, Boston, MA 02111-1307 USA
-# $Id: Acquisition.pm,v 1.43 2006/08/01 08:47:49 toins Exp $
+# $Id: Acquisition.pm,v 1.43.2.1 2006/10/30 13:21:40 toins Exp $
use strict;
require Exporter;
@@ -30,7 +30,7 @@
use vars qw($VERSION @ISA @EXPORT);
# set the version for version checking
-$VERSION = do { my @v = '$Revision: 1.43 $' =~ /\d+/g; shift(@v) . "." . join(
"_", map { sprintf "%03d", $_ } @v ); };
+$VERSION = do { my @v = '$Revision: 1.43.2.1 $' =~ /\d+/g; shift(@v) . "." .
join( "_", map { sprintf "%03d", $_ } @v ); };
# used in receiveorder subroutine
# to provide library specific handling
@@ -270,12 +270,11 @@
biblio.*,biblioitems.*,
aqorders.*,
biblio.title
- FROM aqorders,biblio,biblioitems
- LEFT JOIN aqorderbreakdown ON
- aqorders.ordernumber=aqorderbreakdown.ordernumber
+ FROM aqorders
+ LEFT JOIN aqorderbreakdown ON
aqorders.ordernumber=aqorderbreakdown.ordernumber
+ LEFT JOIN biblio ON
biblio.biblionumber=aqorders.biblionumber
+ LEFT JOIN biblioitems ON
biblioitems.biblioitemnumber=aqorders.biblioitemnumber
WHERE basketno=?
- AND biblio.biblionumber=aqorders.biblionumber
- AND biblioitems.biblioitemnumber=aqorders.biblioitemnumber
AND (datecancellationprinted IS NULL OR
datecancellationprinted='0000-00-00')
";
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-cvs] koha/C4 Acquisition.pm [rel_3_0],
Antoine Farnault <=