[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] koha/C4/Circulation Fines.pm
From: |
Chris Cormack |
Subject: |
[Koha-cvs] koha/C4/Circulation Fines.pm |
Date: |
Wed, 12 Jul 2006 09:15:27 +0000 |
CVSROOT: /sources/koha
Module name: koha
Changes by: Chris Cormack <rangi> 06/07/12 09:15:27
Modified files:
C4/Circulation : Fines.pm
Log message:
Fixing bad sql
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Circulation/Fines.pm?cvsroot=koha&r1=1.13&r2=1.14
Patches:
Index: Fines.pm
===================================================================
RCS file: /sources/koha/koha/C4/Circulation/Fines.pm,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -b -r1.13 -r1.14
--- Fines.pm 7 Jun 2006 01:32:06 -0000 1.13
+++ Fines.pm 12 Jul 2006 09:15:26 -0000 1.14
@@ -1,6 +1,6 @@
package C4::Circulation::Fines;
-# $Id: Fines.pm,v 1.13 2006/06/07 01:32:06 rangi Exp $
+# $Id: Fines.pm,v 1.14 2006/07/12 09:15:26 rangi Exp $
# Copyright 2000-2002 Katipo Communications
#
@@ -155,11 +155,12 @@
# categoryitem table.
my $sth = $dbh->prepare(
-"Select * from items,biblioitems,itemtypes,issuingrules where
items.itemnumber=?
- and items.biblioitemnumber=biblioitems.biblioitemnumber and
- biblioitems.itemtype=itemtypes.itemtype and
- categoryitem.itemtype=itemtypes.itemtype and
- categoryitem.categorycode=? and (items.itemlost <> 1 or items.itemlost is
NULL)"
+"SELECT * FROM items,biblioitems,itemtypes,issuingrules
+ WHERE items.itemnumber=?
+ AND items.biblioitemnumber=biblioitems.biblioitemnumber
+ AND biblioitems.itemtype=itemtypes.itemtype
+ AND issuingrules.itemtype=itemtypes.itemtype
+ AND issuingrules.categorycode=? AND (items.itemlost <> 1 OR items.itemlost
is NULL)"
);
# print $query;
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-cvs] koha/C4/Circulation Fines.pm,
Chris Cormack <=