[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] koha/C4 Search.pm [dev_week]
From: |
Joshua Ferraro |
Subject: |
[Koha-cvs] koha/C4 Search.pm [dev_week] |
Date: |
Wed, 04 Oct 2006 02:19:18 +0000 |
CVSROOT: /sources/koha
Module name: koha
Branch: dev_week
Changes by: Joshua Ferraro <kados> 06/10/04 02:19:18
Modified files:
C4 : Search.pm
Log message:
looking for itemtypes.notforloan, not items.notforloan (we get that
automatically with the *)
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Search.pm?cvsroot=koha&only_with_tag=dev_week&r1=1.99.2.11.2.26&r2=1.99.2.11.2.27
Patches:
Index: Search.pm
===================================================================
RCS file: /sources/koha/koha/C4/Search.pm,v
retrieving revision 1.99.2.11.2.26
retrieving revision 1.99.2.11.2.27
diff -u -b -r1.99.2.11.2.26 -r1.99.2.11.2.27
--- Search.pm 29 Sep 2006 16:07:47 -0000 1.99.2.11.2.26
+++ Search.pm 4 Oct 2006 02:19:18 -0000 1.99.2.11.2.27
@@ -39,7 +39,7 @@
use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
# set the version for version checking
-$VERSION = do { my @v = '$Revision: 1.99.2.11.2.26 $' =~ /\d+/g;
+$VERSION = do { my @v = '$Revision: 1.99.2.11.2.27 $' =~ /\d+/g;
shift(@v) . "." . join("_", map {sprintf "%03d", $_ } @v); };
=head1 NAME
@@ -1241,12 +1241,12 @@
sub ItemInfo {
my ($env,$biblionumber,$type) = @_;
my $dbh = C4::Context->dbh;
- my $query = "SELECT *,items.notforloan as itemnotforloan FROM items,
biblio, biblioitems
- left join itemtypes on
biblioitems.itemtype = itemtypes.itemtype
+ my $query = "SELECT *,itemtypes.notforloan AS itemnotforloan FROM
items, biblio, biblioitems
+ LEFT JOIN itemtypes ON
biblioitems.itemtype = itemtypes.itemtype
WHERE items.biblionumber = ?
AND biblioitems.biblioitemnumber =
items.biblioitemnumber
AND biblio.biblionumber =
items.biblionumber";
- $query .= " order by items.dateaccessioned desc";
+ $query .= " ORDER BY items.dateaccessioned DESC";
my $sth=$dbh->prepare($query);
$sth->execute($biblionumber);
my $i=0;
- [Koha-cvs] koha/C4 Search.pm [dev_week],
Joshua Ferraro <=