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