@@ -, +, @@
---
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 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 ) %]
-
- Title |
- Author |
- Lost code |
- Barcode |
- Date last seen |
- Price |
- Rep.price |
- Library |
- Item type |
- Current location |
- Location |
- Notes |
-
- [% FOREACH itemsloo IN itemsloop %]
- [% UNLESS ( loop.odd ) %]
-
- [% ELSE %]
-
- [% END %]
-
- [% 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 %] |
-
+ [% IF itemsloop %]
+
+
+
+ Title |
+ Author |
+ Lost code |
+ Barcode |
+ Call number |
+ Date last seen |
+ Price |
+ Rep.price |
+ Library |
+ Item type |
+ Current location |
+ Location |
+ Notes |
+
+
+
+ [% FOREACH itemsloo IN itemsloop %]
+
+
+ [% 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 %]
-
- [% END %]
[% ELSE %]