View | Details | Raw Unified | Return to bug 7266
Collapse All | Expand All

(-)a/circ/overdue.pl (-2 / +9 lines)
Lines 266-272 if ($noreport) { Link Here
266
    $strsth.=" AND (borrowers.firstname like '".$bornamefilter."%' or borrowers.surname like '".$bornamefilter."%' or borrowers.cardnumber like '".$bornamefilter."%')" if($bornamefilter) ;
266
    $strsth.=" AND (borrowers.firstname like '".$bornamefilter."%' or borrowers.surname like '".$bornamefilter."%' or borrowers.cardnumber like '".$bornamefilter."%')" if($bornamefilter) ;
267
    $strsth.=" AND borrowers.categorycode = '" . $borcatfilter   . "' " if $borcatfilter;
267
    $strsth.=" AND borrowers.categorycode = '" . $borcatfilter   . "' " if $borcatfilter;
268
    $strsth.=" AND biblioitems.itemtype   = '" . $itemtypefilter . "' " if $itemtypefilter;
268
    $strsth.=" AND biblioitems.itemtype   = '" . $itemtypefilter . "' " if $itemtypefilter;
269
    $strsth.=" AND borrowers.flags        = '" . $borflagsfilter . "' " if $borflagsfilter;
269
    if ( $borflagsfilter eq 'gonenoaddress' ) {
270
        $strsth .= " AND borrowers.gonenoaddress <> 0";
271
    }
272
    elsif ( $borflagsfilter eq 'debarred' ) {
273
        $strsth .= " AND borrowers.debarred >=  CURDATE()" ;
274
    }
275
    elsif ( $borflagsfilter eq 'lost') {
276
        $strsth .= " AND borrowers.debarred <> 0";
277
    }
270
    $strsth.=" AND borrowers.branchcode   = '" . $branchfilter   . "' " if $branchfilter;
278
    $strsth.=" AND borrowers.branchcode   = '" . $branchfilter   . "' " if $branchfilter;
271
    $strsth.=" AND date_due < '" . $datedueto . "' "  if $datedueto;
279
    $strsth.=" AND date_due < '" . $datedueto . "' "  if $datedueto;
272
    $strsth.=" AND date_due > '" . $dateduefrom . "' " if $dateduefrom;
280
    $strsth.=" AND date_due > '" . $dateduefrom . "' " if $dateduefrom;
273
- 

Return to bug 7266