[Koha-cvs] CVS: koha/reports issues_by_borrower_category.plugin,1.2.2.2,1.2.2.3

[Henri-Damien LAURENT]

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

Modified Files:
      Tag: rel_2_2
        issues_by_borrower_category.plugin 
Log Message:
Adding borrowers branchcode management

Index: issues_by_borrower_category.plugin
===================================================================
RCS file: /cvsroot/koha/koha/reports/issues_by_borrower_category.plugin,v
retrieving revision 1.2.2.2
retrieving revision 1.2.2.3
diff -C2 -r1.2.2.2 -r1.2.2.3
*** issues_by_borrower_category.plugin  7 Apr 2005 12:18:43 -0000       1.2.2.2
--- issues_by_borrower_category.plugin  14 Oct 2005 09:34:16 -0000      1.2.2.3
***************
*** 101,111 ****
        }
  # now, parse each category. Before filling the result array, fill it with 0 
to have every itemtype column.
!       my $sth = $dbh->prepare("SELECT itemtype, count( * )
                                FROM issues, borrowers, biblioitems, items
                                WHERE issues.borrowernumber = 
borrowers.borrowernumber 
                                        AND items.itemnumber = 
issues.itemnumber 
                                        AND biblioitems.biblionumber = 
items.biblionumber 
!                                       AND borrowers.categorycode = ?
!                               GROUP BY biblioitems.itemtype");
        my $sthcategories = $dbh->prepare("select categorycode,description from 
categories");
        $sthcategories->execute;
--- 101,113 ----
        }
  # now, parse each category. Before filling the result array, fill it with 0 
to have every itemtype column.
!       my $strsth="SELECT itemtype, count( * )
                                FROM issues, borrowers, biblioitems, items
                                WHERE issues.borrowernumber = 
borrowers.borrowernumber 
                                        AND items.itemnumber = 
issues.itemnumber 
                                        AND biblioitems.biblionumber = 
items.biblionumber 
!                                       AND borrowers.categorycode = ?";
!       $strsth.= " AND borrowers.branchcode = ".$dbh->quote($branch) if 
($branch);
!       $strsth .= " GROUP BY biblioitems.itemtype";
!       my $sth = $dbh->prepare($strsth);
        my $sthcategories = $dbh->prepare("select categorycode,description from 
categories");
        $sthcategories->execute;