[Koha-cvs] koha/C4/Circulation Circ2.pm [rel_3_0]

[LAURIN arnaud]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_3_0
Changes by:     LAURIN arnaud <alaurin> 07/02/05 13:47:37

Modified files:
        C4/Circulation : Circ2.pm 

Log message:
        bugfixing sql mistake for display information with filtered departement 
.....

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Circulation/Circ2.pm?cvsroot=koha&only_with_tag=rel_3_0&r1=1.114.2.36&r2=1.114.2.37

Patches:
Index: Circ2.pm
===================================================================
RCS file: /sources/koha/koha/C4/Circulation/Circ2.pm,v
retrieving revision 1.114.2.36
retrieving revision 1.114.2.37
diff -u -b -r1.114.2.36 -r1.114.2.37
--- Circ2.pm    2 Feb 2007 09:57:46 -0000       1.114.2.36
+++ Circ2.pm    5 Feb 2007 13:47:37 -0000       1.114.2.37
@@ -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: Circ2.pm,v 1.114.2.36 2007/02/02 09:57:46 alaurin Exp $
+# $Id: Circ2.pm,v 1.114.2.37 2007/02/05 13:47:37 alaurin Exp $
 
 use strict;
 require Exporter;
@@ -41,7 +41,7 @@
 use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
 
 # set the version for version checking
-$VERSION = do { my @v = '$Revision: 1.114.2.36 $' =~ /\d+/g; 
shift(@v).".".join( "_", map { sprintf "%03d", $_ } @v ); };
+$VERSION = do { my @v = '$Revision: 1.114.2.37 $' =~ /\d+/g; 
shift(@v).".".join( "_", map { sprintf "%03d", $_ } @v ); };
 
 =head1 NAME
 
@@ -2941,16 +2941,16 @@
                     items.itemnumber,
                     biblio.biblionumber,
                     issues.branchcode,
-                    accounlines.notify_id,
-                    accounlines.notify_level,
+                    accountlines.notify_id,
+                    accountlines.notify_level,
                     items.location,
-                    accounlines.amountoutstanding
-           FROM  
issues,borrowers,biblio,biblioitems,itemtypes,items,branches,accounlines
+                    accountlines.amountoutstanding
+           FROM  
issues,borrowers,biblio,biblioitems,itemtypes,items,branches,accountlines
            WHERE ((( issues.returndate  is null)
-             AND ( accounlines.amountoutstanding  != '0.000000')
-             AND ( accounlines.accounttype  = 'FU')))
-             AND (( issues.borrowernumber = accounlines.borrowernumber )
-             AND ( issues.itemnumber = accounlines.itemnumber )
+             AND ( accountlines.amountoutstanding  != '0.000000')
+             AND ( accountlines.accounttype  = 'FU')))
+             AND (( issues.borrowernumber = accountlines.borrowernumber )
+             AND ( issues.itemnumber = accountlines.itemnumber )
              AND ( borrowers.borrowernumber = issues.borrowernumber )
              AND ( biblio.biblionumber = biblioitems.biblionumber )
              AND ( biblioitems.biblionumber = items.biblionumber )
@@ -2960,9 +2960,9 @@
              AND (issues.branchcode = ? AND items.location = ?)
              AND NOT EXISTS (
                 SELECT * FROM  notifys  
-                WHERE ( accounlines.notify_id  =  notifys.notify_id )
-                  AND ( accounlines.notify_level  =  notifys.notify_level )
-                  AND ( accounlines.itemnumber  =  notifys.itemnumber ) )
+                WHERE ( accountlines.notify_id  =  notifys.notify_id )
+                  AND ( accountlines.notify_level  =  notifys.notify_level )
+                  AND ( accountlines.itemnumber  =  notifys.itemnumber ) )
            ORDER BY  borrowers.surname 
         " );
         $sth->execute( $branch, $departement );