wr-70205 Rental discount not being respected
authorChris Cormack <chrisc@catalyst.net.nz>
Thu, 6 May 2010 23:24:23 +0000 (11:24 +1200)
committerChris Cormack <chrisc@catalyst.net.nz>
Thu, 13 May 2010 19:22:32 +0000 (07:22 +1200)
Signed-off-by: Galen Charlton <gmcharlt@gmail.com>
C4/Circulation.pm

index 395494f..e270b56 100644 (file)
@@ -2288,7 +2288,7 @@ sub GetIssuingCharges {
         my $q2 = "SELECT rentaldiscount FROM borrowers
             LEFT JOIN issuingrules ON borrowers.categorycode = issuingrules.categorycode
             WHERE borrowers.borrowernumber = ?
-            AND issuingrules.itemtype = ?";
+            AND (issuingrules.itemtype = ? OR issuingrules.itemtype = '*')";
         my $sth2 = $dbh->prepare($q2);
         $sth2->execute( $borrowernumber, $item_type );
         if ( my $data2 = $sth2->fetchrow_hashref ) {