[Koha-cvs] CVS: koha/C4/Circulation Circ2.pm,1.70,1.71

[Paul POULAIN]

Update of /cvsroot/koha/koha/C4/Circulation
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4402/C4/Circulation

Modified Files:
        Circ2.pm 
Log Message:
renaming items.bulk field to items.itemcallnumber.
Will be used to store call number for libraries that don't use dewey 
classification.
Note it's related to ITEMS, not biblio.

Index: Circ2.pm
===================================================================
RCS file: /cvsroot/koha/koha/C4/Circulation/Circ2.pm,v
retrieving revision 1.70
retrieving revision 1.71
diff -C2 -r1.70 -r1.71
*** Circ2.pm    24 Mar 2004 21:06:48 -0000      1.70
--- Circ2.pm    2 Apr 2004 14:55:47 -0000       1.71
***************
*** 88,92 ****
        my ($minlocation,$maxlocation,$datelastseen,$offset,$size) = @_;
        my $dbh = C4::Context->dbh;
!       my $sth = $dbh->prepare("select itemnumber,barcode,bulk,title,author 
from items,biblio where items.biblionumber=biblio.biblionumber and bulk>= ? and 
bulk <=? and (datelastseen< ? or datelastseen is null) order by bulk,title");
        $sth->execute($minlocation,$maxlocation,$datelastseen);
        my @results;
--- 88,92 ----
        my ($minlocation,$maxlocation,$datelastseen,$offset,$size) = @_;
        my $dbh = C4::Context->dbh;
!       my $sth = $dbh->prepare("select 
itemnumber,barcode,itemcallnumber,title,author from items,biblio where 
items.biblionumber=biblio.biblionumber and itemcallnumber>= ? and 
itemcallnumber <=? and (datelastseen< ? or datelastseen is null) order by 
itemcallnumber,title");
        $sth->execute($minlocation,$maxlocation,$datelastseen);
        my @results;