@@ -, +, @@ --- C4/Items.pm | 2 +- admin/columns_settings.yml | 31 ++++++ .../prog/en/modules/admin/columns_settings.tt | 7 ++ .../prog/en/modules/reports/itemslost.tt | 106 ++++++++++++-------- 4 files changed, 105 insertions(+), 41 deletions(-) --- a/C4/Items.pm +++ a/C4/Items.pm @@ -997,7 +997,7 @@ sub GetLostItems { my $query = " SELECT title, author, lib, itemlost, authorised_value, barcode, datelastseen, price, replacementprice, homebranch, - itype, itemtype, holdingbranch, location, itemnotes, items.biblionumber as biblionumber + itype, itemtype, holdingbranch, location, itemnotes, items.biblionumber as biblionumber, itemcallnumber FROM items LEFT JOIN biblio ON (items.biblionumber = biblio.biblionumber) LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber) --- a/admin/columns_settings.yml +++ a/admin/columns_settings.yml @@ -21,3 +21,34 @@ modules: columnname: active - columnname: actions + reports: + lostitems: + lostitems-table: + - + columnname: title + cannot_be_toggled: 1 + cannot_be_modified: 1 + - + columnname: author + - + columnname: lostcode + - + columnname: barcode + - + columnname: callnumber + - + columnname: datelastseen + - + columnname: price + - + columnname: replacementprice + - + columnname: library + - + columnname: itemtype + - + columnname: current_location + - + columnname: location + - + columnname: notes --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/columns_settings.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/columns_settings.tt @@ -143,6 +143,13 @@

Circulation tables

[% PROCESS pagelist module=modules.circ modulename="circ" %] + +

Reports

+
+

Reports tables

+ [% PROCESS pagelist module=modules.reports modulename="reports" %] +
+ --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/itemslost.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/itemslost.tt @@ -1,6 +1,29 @@ +[% USE Branches %] +[% USE ColumnsSettings %] [% INCLUDE 'doc-head-open.inc' %] Koha › Reports › Lost items [% INCLUDE 'doc-head-close.inc' %] + +[% INCLUDE 'datatables.inc' %] +[% INCLUDE 'columns_settings.inc' %] + + [% INCLUDE 'header.inc' %] @@ -26,47 +49,50 @@ [% END %] - [% IF ( itemsloop ) %] - - - - - - - - - - - - - - - [% FOREACH itemsloo IN itemsloop %] - [% UNLESS ( loop.odd ) %] - - [% ELSE %] - - [% END %] - - - - - - - - - - - - - + [% IF itemsloop %] +
TitleAuthorLost codeBarcodeDate last seenPriceRep.priceLibraryItem typeCurrent locationLocationNotes
- [% itemsloo.title |html %] - [% itemsloo.author %][% itemsloo.lib %] - [% itemsloo.barcode %] - [% itemsloo.datelastseen %][% itemsloo.price %][% itemsloo.replacementprice %][% itemsloo.homebranch %][% IF ( itemsloo.itype_level ) %][% itemsloo.itype %][% ELSE %][% itemsloo.itemtype %][% END %][% itemsloo.holdingbranch %][% itemsloo.location %][% itemsloo.itemnotes %]
+ + + + + + + + + + + + + + + + + + + [% FOREACH itemsloo IN itemsloop %] + + + + + + + + + + + + + + + + [% END %] + +
TitleAuthorLost codeBarcodeCall numberDate last seenPriceRep.priceLibraryItem typeCurrent locationLocationNotes
+ [% itemsloo.title |html %] + [% itemsloo.author %][% itemsloo.lib %] + [% itemsloo.barcode %] + [% itemsloo.itemcallnumber %][% itemsloo.datelastseen %][% itemsloo.price %][% itemsloo.replacementprice %][% Branches.GetName(itemsloo.homebranch) %][% IF ( itemsloo.itype_level ) %][% itemsloo.itype %][% ELSE %][% itemsloo.itemtype %][% END %][% Branches.GetName(itemsloo.holdingbranch) %][% itemsloo.location %][% itemsloo.itemnotes %]
[% END %] - - [% END %] [% ELSE %]
--