|
Lines 61-66
my $filters = {
Link Here
|
| 61 |
holdingbranch => $holdingbranchfilter, |
61 |
holdingbranch => $holdingbranchfilter, |
| 62 |
dateduefrom => $dateduefrom, |
62 |
dateduefrom => $dateduefrom, |
| 63 |
datedueto => $datedueto, |
63 |
datedueto => $datedueto, |
|
|
64 |
showall => $showall, |
| 64 |
}; |
65 |
}; |
| 65 |
|
66 |
|
| 66 |
my $isfiltered = $op =~ /apply/i && $op =~ /filter/i; |
67 |
my $isfiltered = $op =~ /apply/i && $op =~ /filter/i; |
|
Lines 258-264
if ($noreport) {
Link Here
|
| 258 |
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber ) |
259 |
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber ) |
| 259 |
WHERE 1=1 "; # placeholder, since it is possible that none of the additional |
260 |
WHERE 1=1 "; # placeholder, since it is possible that none of the additional |
| 260 |
# conditions will be selected by user |
261 |
# conditions will be selected by user |
| 261 |
$strsth.=" AND date_due < '" . $todaysdate . "' " unless ($showall); |
262 |
$strsth.=" AND date_due < '" . $todaysdate . "' " unless ($showall or $datedueto); |
| 262 |
$strsth.=" AND (borrowers.firstname like '".$bornamefilter."%' or borrowers.surname like '".$bornamefilter."%' or borrowers.cardnumber like '".$bornamefilter."%')" if($bornamefilter) ; |
263 |
$strsth.=" AND (borrowers.firstname like '".$bornamefilter."%' or borrowers.surname like '".$bornamefilter."%' or borrowers.cardnumber like '".$bornamefilter."%')" if($bornamefilter) ; |
| 263 |
$strsth.=" AND borrowers.categorycode = '" . $borcatfilter . "' " if $borcatfilter; |
264 |
$strsth.=" AND borrowers.categorycode = '" . $borcatfilter . "' " if $borcatfilter; |
| 264 |
if( $itemtypefilter ){ |
265 |
if( $itemtypefilter ){ |
| 265 |
- |
|
|