[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] koha/C4/Circulation Circ2.pm [rel_3_0]
From: |
Antoine Farnault |
Subject: |
[Koha-cvs] koha/C4/Circulation Circ2.pm [rel_3_0] |
Date: |
Thu, 11 Jan 2007 15:13:45 +0000 |
CVSROOT: /sources/koha
Module name: koha
Branch: rel_3_0
Changes by: Antoine Farnault <toins> 07/01/11 15:13:45
Modified files:
C4/Circulation : Circ2.pm
Log message:
Fix a bug. confusion between itemnumber and biblionumber.
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.32&r2=1.114.2.33
Patches:
Index: Circ2.pm
===================================================================
RCS file: /sources/koha/koha/C4/Circulation/Circ2.pm,v
retrieving revision 1.114.2.32
retrieving revision 1.114.2.33
diff -u -b -r1.114.2.32 -r1.114.2.33
--- Circ2.pm 11 Jan 2007 14:23:55 -0000 1.114.2.32
+++ Circ2.pm 11 Jan 2007 15:13:44 -0000 1.114.2.33
@@ -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.32 2007/01/11 14:23:55 toins Exp $
+# $Id: Circ2.pm,v 1.114.2.33 2007/01/11 15:13:44 toins 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.32 $' =~ /\d+/g;
shift(@v).".".join( "_", map { sprintf "%03d", $_ } @v ); };
+$VERSION = do { my @v = '$Revision: 1.114.2.33 $' =~ /\d+/g;
shift(@v).".".join( "_", map { sprintf "%03d", $_ } @v ); };
=head1 NAME
@@ -2261,7 +2261,7 @@
$issues = GetIssuesFromBiblio($biblionumber);
-this function get all issues from a biblionumer.
+this function get all issues from a biblionumber.
Return:
C<$issues> is a reference to array which each value is ref-to-hash. This
ref-to-hash containts all column from
@@ -2276,9 +2276,10 @@
my $query = "
SELECT issues.*,biblio.biblionumber,biblio.title,
biblio.author,borrowers.cardnumber,borrowers.surname,borrowers.firstname
FROM issues
- LEFT JOIN items ON issues.itemnumber = items.itemnumber
- LEFT JOIN biblio ON biblio.biblionumber = items.itemnumber
LEFT JOIN borrowers ON borrowers.borrowernumber =
issues.borrowernumber
+ LEFT JOIN items ON issues.itemnumber = items.itemnumber
+ LEFT JOIN biblioitems ON items.itemnumber =
biblioitems.biblioitemnumber
+ LEFT JOIN biblio ON biblio.biblionumber = items.biblioitemnumber
WHERE biblio.biblionumber = ?
ORDER BY issues.timestamp
";