From 05c240953a7989af72c461bd9e2e37bac0fe2a66 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Fri, 7 Jan 2011 05:34:11 -0500 Subject: [PATCH] Additional fix for Bug 3550, Use GetRecordValue to get the subtitle - Adding subtitle to Hold Ratio report output - Sorting by default on ratio, descending - Adding author - Removing description Signed-off-by: Nicole Engard Signed-off-by: Chris Cormack --- circ/reserveratios.pl | 4 ++++ .../intranet-tmpl/prog/en/modules/circ/reserveratios.tmpl | 8 ++------ 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/circ/reserveratios.pl b/circ/reserveratios.pl index 8807339f0d..5a86675d3b 100755 --- a/circ/reserveratios.pl +++ b/circ/reserveratios.pl @@ -28,6 +28,7 @@ use C4::Auth; use C4::Dates qw/format_date format_date_in_iso/; use C4::Debug; use Date::Calc qw/Today Add_Delta_YM/; +use C4::Biblio qw/GetMarcBiblio GetRecordValue GetFrameworkCode/; my $input = new CGI; my $order = $input->param('order') || ''; @@ -144,6 +145,8 @@ while ( my $data = $sth->fetchrow_hashref ) { my $thisratio = $data->{reservecount} / $data->{itemcount}; my $ratiocalc = ($thisratio / $ratio); ($thisratio / $ratio) >= 1 or next; # TODO: tighter targeting -- get ratio limit into SQL using HAVING clause + my $record = GetMarcBiblio($data->{biblionumber}); + $data->{subtitle} = GetRecordValue('subtitle', $record, GetFrameworkCode($data->{biblionumber})); push( @reservedata, { @@ -151,6 +154,7 @@ while ( my $data = $sth->fetchrow_hashref ) { priority => $data->{priority}, name => $data->{borrower}, title => $data->{title}, + subtitle => $data->{subtitle}, author => $data->{author}, notes => $data->{notes}, itemnum => $data->{itemnumber}, diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/reserveratios.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/reserveratios.tmpl index 68c4209040..15d9cdb416 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/reserveratios.tmpl +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/reserveratios.tmpl @@ -28,7 +28,7 @@ $.tablesorter.addParser({ ); $.tablesorter.defaults.widgets = ['zebra']; $("#holdst:has(tbody tr)").tablesorter({ // only add sort if the table has a body and rows - sortList: [[0,0]], + sortList: [[0,1]], headers: { 1: { sorter: 'articles' }} }); }); @@ -91,11 +91,7 @@ $.tablesorter.addParser({

-

- - -

-

+ by

-- 2.39.5