[Koha-cvs] CVS: koha/C4 Search.pm,1.35,1.36

[Finlay Thompson]

Update of /cvsroot/koha/koha/C4
In directory usw-pr-cvs1:/tmp/cvs-serv27637/C4

Modified Files:
	Search.pm 
Log Message:

Fixed the ordering of bibitems displayed in the request page. Most recent at top, ordered by dateaccessioned on the items table.


Index: Search.pm
===================================================================
RCS file: /cvsroot/koha/koha/C4/Search.pm,v
retrieving revision 1.35
retrieving revision 1.36
diff -C2 -r1.35 -r1.36
*** Search.pm	22 Aug 2002 02:31:58 -0000	1.35
--- Search.pm	19 Sep 2002 00:24:27 -0000	1.36
***************
*** 1338,1342 ****
         $nacount++;         
      } else {         
!       if ($data->{'holdingbranch'} eq 'C'){         
          $lcount++;               
        }                       
--- 1338,1342 ----
         $nacount++;         
      } else {         
!       if ($data->{'holdingbranch'} eq 'C' || $data->{'holdingbranch'} eq 'LT'){         
          $lcount++;               
        }                       
***************
*** 1438,1442 ****
      my ($bibnum) = @_;
      my $dbh   = C4Connect;
!     my $query = "SELECT biblioitems.*, itemtypes.*, MIN(items.itemlost) as itemlost
                            FROM biblioitems, itemtypes, items
                           WHERE biblioitems.biblionumber     = ?
--- 1438,1445 ----
      my ($bibnum) = @_;
      my $dbh   = C4Connect;
!     my $query = "SELECT biblioitems.*, 
!                         itemtypes.*, 
!                         MIN(items.itemlost)        as itemlost,
!                         MIN(items.dateaccessioned) as dateaccessioned
                            FROM biblioitems, itemtypes, items
                           WHERE biblioitems.biblionumber     = ?