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 |
- |
|
|