From 74ec8d780d8a0e2021d22067756efe7a5655b6c7 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Fri, 8 Jan 2021 20:12:28 +0000 Subject: [PATCH] Bug 25760: [Alternate] (bug 15422 follow-up) Display record with hold ratio greater than or equal to the value entered On bug 15422 we made it so that only holds with copies to buy to acheive the holds ratio showed Users have reported that they want to see record where there are 0 copies to buy i.e. the holds ration matches the value entered This patch changes the criteria for returning holds to be if the ratio for a given title is equal to or greater then the ratio specified in the form I also renamed 'ratiocalc' to 'copies_to_buy' since that is what is contains Test plan: 1. Create bibliographic records with 1, 2 and 3 items 2. Place 1 hold on each of them 3. Go to the Hold ratios report and search with ratio = 1, 2 then 3 4. You expect to see: the title with 1 item with ratio 1 nothing otherwise 5. Place another hold on each of the record 6. Repeat 3 you expect to see: titles with 1 or 2 items with ratio 1 title with 1 item for ratio 2 nothing with ratio 3 7. Place another hold on each of the record 8. Repeat 3 you expect to see: titles with 1 or 2 or 3 items with ratio 1 title with 1 item or 2 items for ratio 2 nothing with ratio 3 9. Make sure there is no regression in the test plan of bug 15422 --- circ/reserveratios.pl | 6 +++--- koha-tmpl/intranet-tmpl/prog/en/modules/circ/reserveratios.tt | 8 ++++---- 2 files changed, 7 insertions(+), 7 deletions(-) diff --git a/circ/reserveratios.pl b/circ/reserveratios.pl index 47b0375387..ed57613d5a 100755 --- a/circ/reserveratios.pl +++ b/circ/reserveratios.pl @@ -157,8 +157,8 @@ $sth->execute(@query_params); my @reservedata; while ( my $data = $sth->fetchrow_hashref ) { my $thisratio = $data->{reservecount} / $data->{itemcount}; - my $ratiocalc = ceil($data->{reservecount}/$ratio - $data->{itemcount}); - $ratiocalc >= 1 or next; # TODO: tighter targeting -- get ratio limit into SQL using HAVING clause + my $copies_to_buy = ceil($data->{reservecount}/$ratio - $data->{itemcount}); + $thisratio >= $ratio or next; # TODO: tighter targeting -- get ratio limit into SQL using HAVING clause push( @reservedata, { @@ -182,7 +182,7 @@ while ( my $data = $sth->fetchrow_hashref ) { itype => [split('\|', $data->{l_itype})], reservecount => $data->{reservecount}, itemcount => $data->{itemcount}, - ratiocalc => sprintf( "%.0d", $ratiocalc ), + copies_to_buy => sprintf( "%d", $copies_to_buy ), thisratio => sprintf( "%.2f", $thisratio ), thisratio_atleast1 => ( $thisratio >= 1 ) ? 1 : 0, listcall => [split('\|', $data->{listcall})] diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/reserveratios.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/reserveratios.tt index 87b7564305..ff806f51f0 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/reserveratios.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/reserveratios.tt @@ -98,10 +98,10 @@

[% IF ( reserveloo.thisratio_atleast1 ) %] - [% IF ( CAN_user_acquisition && basketno && booksellerid ) %] - [% reserveloo.ratiocalc | html %] to order + [% IF ( CAN_user_acquisition && basketno && booksellerid ) %] + [% reserveloo.copies_to_buy | html %] to order [% ELSE %] - [% reserveloo.ratiocalc | html %] to order + [% reserveloo.copies_to_buy | html %] to order [% END %] [% IF ( reserveloo.pendingorders ) %]
[% reserveloo.pendingorders | html %] pending[% END %] [% ELSE %] @@ -128,7 +128,7 @@

Refine results:

  1. - +
  2. -- 2.11.0