@@ -, +, @@
4a) that the page does work as before
4b) there is ne "Column visibility" button in datatable toolbar
4c) the column configuration does work as expected
4d) there is new column "First patron" with link to patron which is
first in holds queue for given record
4e) sorting works ax expected
4f) filters (in teh bottom of table) work as expected
---
admin/columns_settings.yml | 27 +++++++++++++++++++
circ/pendingreserves.pl | 6 ++++-
.../prog/en/modules/circ/pendingreserves.tt | 31 +++++++++++++---------
3 files changed, 51 insertions(+), 13 deletions(-)
--- a/admin/columns_settings.yml
+++ a/admin/columns_settings.yml
@@ -394,3 +394,30 @@ modules:
columnname: date
-
columnname: notes
+
+ holds:
+ holds-to-pull:
+ -
+ columnname: pull_items
+ -
+ columnname: avalaible_items
+ -
+ columnname: patrons
+ -
+ columnname: patron
+ -
+ columnname: title
+ -
+ columnname: libraries
+ -
+ columnname: call_numbers
+ -
+ columnname: copy_numbers
+ -
+ columnname: enumeration
+ -
+ columnname: itemtypes
+ -
+ columnname: locations
+ -
+ columnname: hold_date
--- a/circ/pendingreserves.pl
+++ a/circ/pendingreserves.pl
@@ -35,6 +35,7 @@ use Koha::Biblios;
use C4::Debug;
use Koha::DateUtils;
use DateTime::Duration;
+use Koha::Patrons;
my $input = new CGI;
my $startdate=$input->param('from');
@@ -122,12 +123,14 @@ if ( $run_report ) {
biblio.title,
biblio.author,
count(DISTINCT items.itemnumber) as icount,
- count(DISTINCT reserves.borrowernumber) as rcount
+ count(DISTINCT reserves.borrowernumber) as rcount,
+ CONCAT_WS(' ', borrowers.firstname, borrowers.surname) as l_patron
FROM reserves
LEFT JOIN items ON items.biblionumber=reserves.biblionumber
LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber
LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber
LEFT JOIN issues ON items.itemnumber=issues.itemnumber
+ LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber
WHERE
reserves.found IS NULL
$sqldatewhere
@@ -154,6 +157,7 @@ if ( $run_report ) {
while ( my $data = $sth->fetchrow_hashref ) {
my $record = Koha::Biblios->find($data->{biblionumber});
+ my $patron = Koha::Patrons->find($data->{borrowernumber});
if ($record){
$data->{subtitle} = [ $record->subtitles ];
}
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tt
+++ a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tt
@@ -1,4 +1,5 @@
[% USE KohaDates %]
+[% USE ColumnsSettings %]
[% USE AuthorisedValues %]
[%- USE Branches -%]
[%- USE ItemTypes -%]
@@ -9,17 +10,19 @@
[% INCLUDE 'datatables.inc' %]
+[% INCLUDE 'columns_settings.inc' %]