@@ -, +, @@
---
koha-tmpl/intranet-tmpl/prog/en/js/checkouts.js | 16 +++++++++++++---
svc/checkouts | 9 +++++++--
2 files changed, 20 insertions(+), 5 deletions(-)
--- a/koha-tmpl/intranet-tmpl/prog/en/js/checkouts.js
+++ a/koha-tmpl/intranet-tmpl/prog/en/js/checkouts.js
@@ -183,11 +183,21 @@ $(document).ready(function() {
{
"iDataSort": 1, // Sort on hidden unformatted date due column
"mDataProp": function( oObj ) {
+ var due = oObj.date_due_formatted;
+
if ( oObj.date_due_overdue ) {
- return "" + oObj.date_due_formatted + "";
- } else {
- return oObj.date_due_formatted;
+ due = "" + due + "";
+ }
+
+ if ( oObj.lost ) {
+ due += "" + oObj.lost + "";
}
+
+ if ( oObj.damaged ) {
+ due += "" + oObj.damaged + "";
+ }
+
+ return due;
}
},
{
--- a/svc/checkouts
+++ a/svc/checkouts
@@ -25,8 +25,8 @@ use JSON qw(to_json);
use C4::Auth qw(check_cookie_auth);
use C4::Biblio qw(GetMarcBiblio GetFrameworkCode GetRecordValue );
-use C4::Circulation
- qw(GetIssuingCharges CanBookBeRenewed GetRenewCount GetSoonestRenewDate);
+use C4::Circulation qw(GetIssuingCharges CanBookBeRenewed GetRenewCount GetSoonestRenewDate);
+use C4::Koha qw(GetAuthorisedValueByCode);
use C4::Context;
use Koha::DateUtils;
@@ -86,6 +86,9 @@ my $sql = '
firstname,
cardnumber,
+ itemlost,
+ damaged,
+
DATEDIFF( issuedate, CURRENT_DATE() ) AS not_issued_today
FROM issues
LEFT JOIN items USING ( itemnumber )
@@ -175,6 +178,8 @@ while ( my $c = $sth->fetchrow_hashref() ) {
GetMarcBiblio( $c->{biblionumber} ),
GetFrameworkCode( $c->{biblionumber} )
),
+ lost => $c->{itemlost} ? GetAuthorisedValueByCode( 'LOST', $c->{itemlost} ) : undef,
+ damaged => $c->{damaged} ? GetAuthorisedValueByCode( 'DAMAGED', $c->{damaged} ) : undef,
borrower => {
surname => $c->{surname},
firstname => $c->{firstname},
--