@@ -, +, @@ --- 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}, --