[Koha-cvs] CVS: koha/C4 Stats.pm,1.21,1.22

[Chris Cormack]

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

Modified Files:
        Stats.pm 
Log Message:
fixing unfilledreserves


Index: Stats.pm
===================================================================
RCS file: /cvsroot/koha/koha/C4/Stats.pm,v
retrieving revision 1.21
retrieving revision 1.22
diff -C2 -r1.21 -r1.22
*** Stats.pm    22 Aug 2005 01:05:49 -0000      1.21
--- Stats.pm    25 Aug 2005 23:15:34 -0000      1.22
***************
*** 212,216 ****
  sub unfilledreserves {
          my $dbh = C4::Context->dbh;
!         my $sth=$dbh->prepare("select *,biblio.title from 
reserves,reserveconstraints,biblio,borrowers,biblioitems where found <> 'F' and 
cancellationdate
                                                                  is NULL and 
biblio.biblionumber=reserves.biblionumber and
                                                                  
reserves.constrainttype='o'
--- 212,217 ----
  sub unfilledreserves {
          my $dbh = C4::Context->dbh;
!         my $sth=$dbh->prepare("select *,biblio.title from 
reserves,reserveconstraints,biblio,borrowers,biblioitems where (found <> 'F' or
!           found is NULL) and cancellationdate
                                                                  is NULL and 
biblio.biblionumber=reserves.biblionumber and
                                                                  
reserves.constrainttype='o'
***************
*** 229,233 ****
          }
          $sth->finish;
!         $sth=$dbh->prepare("select *,biblio.title from 
reserves,biblio,borrowers where found <> 'F' and cancellationdate
                  is NULL and biblio.biblionumber=reserves.biblionumber and 
reserves.constrainttype='a' and
                  reserves.borrowernumber=borrowers.borrowernumber
--- 230,234 ----
          }
          $sth->finish;
!         $sth=$dbh->prepare("select *,biblio.title from 
reserves,biblio,borrowers where (found <> 'F' or found is NULL) and 
cancellationdate
                  is NULL and biblio.biblionumber=reserves.biblionumber and 
reserves.constrainttype='a' and
                  reserves.borrowernumber=borrowers.borrowernumber