Lines 104-109
my $sql = '
Link Here
|
104 |
items.damaged, |
104 |
items.damaged, |
105 |
items.location, |
105 |
items.location, |
106 |
items.enumchron, |
106 |
items.enumchron, |
|
|
107 |
items.materials, |
107 |
|
108 |
|
108 |
DATEDIFF( issues.issuedate, CURRENT_DATE() ) AS not_issued_today, |
109 |
DATEDIFF( issues.issuedate, CURRENT_DATE() ) AS not_issued_today, |
109 |
|
110 |
|
Lines 186-191
while ( my $c = $sth->fetchrow_hashref() ) {
Link Here
|
186 |
my $av = Koha::AuthorisedValues->search({ category => 'DAMAGED', authorised_value => $c->{damaged} }); |
187 |
my $av = Koha::AuthorisedValues->search({ category => 'DAMAGED', authorised_value => $c->{damaged} }); |
187 |
$damaged = $av->count ? $av->next->lib : ''; |
188 |
$damaged = $av->count ? $av->next->lib : ''; |
188 |
} |
189 |
} |
|
|
190 |
my $materials; |
191 |
if ( $c->{materials} ) { |
192 |
my $descriptions = Koha::AuthorisedValues->get_description_by_koha_field({frameworkcode => '', kohafield =>'items.materials', authorised_value => $c->{materials} }); |
193 |
$materials = $descriptions->{lib} // $c->{materials}; |
194 |
} |
189 |
my @subtitles = split(/ \| /, $c->{'subtitle'} // '' ); |
195 |
my @subtitles = split(/ \| /, $c->{'subtitle'} // '' ); |
190 |
my $checkout = { |
196 |
my $checkout = { |
191 |
DT_RowId => $c->{itemnumber} . '-' . $c->{borrowernumber}, |
197 |
DT_RowId => $c->{itemnumber} . '-' . $c->{borrowernumber}, |
Lines 248-253
while ( my $c = $sth->fetchrow_hashref() ) {
Link Here
|
248 |
lost => $lost, |
254 |
lost => $lost, |
249 |
claims_returned => $claims_returned, |
255 |
claims_returned => $claims_returned, |
250 |
damaged => $damaged, |
256 |
damaged => $damaged, |
|
|
257 |
materials => $materials, |
251 |
borrower => { |
258 |
borrower => { |
252 |
surname => $c->{surname}, |
259 |
surname => $c->{surname}, |
253 |
firstname => $c->{firstname}, |
260 |
firstname => $c->{firstname}, |
254 |
- |
|
|