[Koha-patches] [PATCH 16/92] [MT2435] Fixed the SQL syntax error in GetLateOrders
Henri-Damien LAURENT
henridamien.laurent at biblibre.com
Tue Dec 22 01:20:09 CET 2009
From: Jean-André Santoni <jeanandre.santoni at biblibre.com>
---
C4/Acquisition.pm | 17 +++++++++--------
1 files changed, 9 insertions(+), 8 deletions(-)
diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm
index 1f1132b..a1238a4 100644
--- a/C4/Acquisition.pm
+++ b/C4/Acquisition.pm
@@ -1493,15 +1493,16 @@ sub GetLateOrders {
biblioitems.publicationyear,
";
my $from = "
- FROM (((
- (aqorders LEFT JOIN biblio ON biblio.biblionumber = aqorders.biblionumber)
- LEFT JOIN biblioitems ON biblioitems.biblionumber = biblio.biblionumber)
- LEFT JOIN aqbudgets ON aqorders.budget_id = aqbudgets.budget_id),
- (aqbasket LEFT JOIN borrowers ON aqbasket.authorisedby = borrowers.borrowernumber)
- LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id
+ FROM
+ aqorders LEFT JOIN biblio ON biblio.biblionumber = aqorders.biblionumber
+ LEFT JOIN biblioitems ON biblioitems.biblionumber = biblio.biblionumber
+ LEFT JOIN aqbudgets ON aqorders.budget_id = aqbudgets.budget_id,
+ aqbasket LEFT JOIN borrowers ON aqbasket.authorisedby = borrowers.borrowernumber
+ LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id
WHERE aqorders.basketno = aqbasket.basketno
- AND ( (datereceived = '' OR datereceived IS NULL)
- OR (aqorders.quantityreceived < aqorders.quantity)
+ AND ( datereceived = ''
+ OR datereceived IS NULL
+ OR aqorders.quantityreceived < aqorders.quantity
)
";
my $having = "";
--
1.6.3.3
More information about the Koha-patches
mailing list