Lines 270-279
if ($noreport) {
Link Here
|
270 |
$strsth .= " AND borrowers.gonenoaddress <> 0"; |
270 |
$strsth .= " AND borrowers.gonenoaddress <> 0"; |
271 |
} |
271 |
} |
272 |
elsif ( $borflagsfilter eq 'debarred' ) { |
272 |
elsif ( $borflagsfilter eq 'debarred' ) { |
273 |
$strsth .= " AND borrowers.debarred >= CURDATE()" ; |
273 |
$strsth .= " AND borrowers.debarred >= CURDATE()"; |
274 |
} |
274 |
} |
275 |
elsif ( $borflagsfilter eq 'lost') { |
275 |
elsif ( $borflagsfilter eq 'lost') { |
276 |
$strsth .= " AND borrowers.debarred <> 0"; |
276 |
$strsth .= " AND borrowers.lost <> 0"; |
277 |
} |
277 |
} |
278 |
$strsth.=" AND borrowers.branchcode = '" . $branchfilter . "' " if $branchfilter; |
278 |
$strsth.=" AND borrowers.branchcode = '" . $branchfilter . "' " if $branchfilter; |
279 |
$strsth.=" AND date_due < '" . $datedueto . "' " if $datedueto; |
279 |
$strsth.=" AND date_due < '" . $datedueto . "' " if $datedueto; |
280 |
- |
|
|