|
Lines 255-266
if ($noreport) {
Link Here
|
| 255 |
items.replacementprice, |
255 |
items.replacementprice, |
| 256 |
items.enumchron, |
256 |
items.enumchron, |
| 257 |
items.itemnotes_nonpublic, |
257 |
items.itemnotes_nonpublic, |
| 258 |
items.itype |
258 |
items.itype, |
|
|
259 |
return_claims.created_on AS return_claim_created_on, |
| 260 |
return_claims.id AS return_claim_id |
| 259 |
FROM issues |
261 |
FROM issues |
| 260 |
LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber ) |
262 |
LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber ) |
| 261 |
LEFT JOIN items ON (issues.itemnumber=items.itemnumber) |
263 |
LEFT JOIN items ON (issues.itemnumber=items.itemnumber) |
| 262 |
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=items.biblioitemnumber) |
264 |
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=items.biblioitemnumber) |
| 263 |
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber ) |
265 |
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber ) |
|
|
266 |
LEFT JOIN return_claims ON (return_claims.borrowernumber=borrowers.borrowernumber AND return_claims.itemnumber=items.itemnumber) |
| 264 |
WHERE 1=1 "; # placeholder, since it is possible that none of the additional |
267 |
WHERE 1=1 "; # placeholder, since it is possible that none of the additional |
| 265 |
# conditions will be selected by user |
268 |
# conditions will be selected by user |
| 266 |
$strsth.=" AND date_due < '" . $todaysdate . "' " unless ($showall or $datedueto); |
269 |
$strsth.=" AND date_due < '" . $todaysdate . "' " unless ($showall or $datedueto); |
|
Lines 308-313
if ($noreport) {
Link Here
|
| 308 |
my $pattrs = $borrowernumber_to_attributes{$data->{borrowernumber}} || {}; # patron attrs for this borrower |
311 |
my $pattrs = $borrowernumber_to_attributes{$data->{borrowernumber}} || {}; # patron attrs for this borrower |
| 309 |
# $pattrs is a hash { attrcode => [ [value,displayvalue], [value,displayvalue]... ] } |
312 |
# $pattrs is a hash { attrcode => [ [value,displayvalue], [value,displayvalue]... ] } |
| 310 |
|
313 |
|
|
|
314 |
my $return_claim_created_on = $data->{return_claim_created_on}; |
| 315 |
if ( defined $return_claim_created_on ) { |
| 316 |
$return_claim_created_on = output_pref({ dt => dt_from_string($return_claim_created_on ) }); |
| 317 |
} |
| 318 |
|
| 311 |
my @patron_attr_value_loop; # template array [ {value=>v1}, {value=>v2} ... } ] |
319 |
my @patron_attr_value_loop; # template array [ {value=>v1}, {value=>v2} ... } ] |
| 312 |
for my $pattr_filter (grep { ! $_->{isclone} } @patron_attr_filter_loop) { |
320 |
for my $pattr_filter (grep { ! $_->{isclone} } @patron_attr_filter_loop) { |
| 313 |
my @displayvalues = map { $_->[1] } @{ $pattrs->{$pattr_filter->{code}} }; # grab second value from each subarray |
321 |
my @displayvalues = map { $_->[1] } @{ $pattrs->{$pattr_filter->{code}} }; # grab second value from each subarray |
|
Lines 347-352
if ($noreport) {
Link Here
|
| 347 |
itemcallnumber => $data->{itemcallnumber}, |
355 |
itemcallnumber => $data->{itemcallnumber}, |
| 348 |
replacementprice => $data->{replacementprice}, |
356 |
replacementprice => $data->{replacementprice}, |
| 349 |
itemnotes_nonpublic => $data->{itemnotes_nonpublic}, |
357 |
itemnotes_nonpublic => $data->{itemnotes_nonpublic}, |
|
|
358 |
return_claim_created_on => $return_claim_created_on, |
| 359 |
return_claim_id => $data->{return_claim_id}, |
| 350 |
enumchron => $data->{enumchron}, |
360 |
enumchron => $data->{enumchron}, |
| 351 |
itemtype => $data->{itype}, |
361 |
itemtype => $data->{itype}, |
| 352 |
patron_attr_value_loop => \@patron_attr_value_loop, |
362 |
patron_attr_value_loop => \@patron_attr_value_loop, |