From a5b8547f15b866eb1a23d26c24fc7effa90dd1e0 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 22 Sep 2020 14:10:10 -0400 Subject: [PATCH] Bug 26510: Transport Cost Matrix editor doesn't show all data when HoldsQueueSkipClosed is enabled If HoldsQueueSkipClosed is enabled, and a library happens to be closed on the day you edit the transport cost matrix, all the values for that library will not show. Instead they will appear disabled, and if you were to edit the cell and save a new value in it, it will also 'disappear' when the page is reloaded. Test Plan: 1) Set today as a holiday for a library 2) Set HoldsQueueSkipClosed to 'open' 3) Go to the transport cost matrix editor 4) Edit a cell where the 'from' is for the closed library 5) Note the value doesn't 'save', it is still in the database though 6) Apply this patch 7) Restart all the things! 8) Reload the transport cost matrix editor 9) The value now appears correctly! Signed-off-by: Lisette Scheer Signed-off-by: Katrin Fischer Signed-off-by: Jonathan Druart (cherry picked from commit 26ab04a3b383f5a9c88124625f8edc1c4cf1d816) Signed-off-by: Lucas Gass (cherry picked from commit eab46b1758cc4749aba581469f40a8405f79fb2b) Signed-off-by: Aleisha Amohia (cherry picked from commit af554209575a7e6f137ec1dd09f3b773c4058e9b) Signed-off-by: Victor Grousset/tuxayo --- C4/HoldsQueue.pm | 5 ++++- admin/transport-cost-matrix.pl | 2 +- 2 files changed, 5 insertions(+), 2 deletions(-) diff --git a/C4/HoldsQueue.pm b/C4/HoldsQueue.pm index d55e7e3161..ceba15e977 100755 --- a/C4/HoldsQueue.pm +++ b/C4/HoldsQueue.pm @@ -61,6 +61,9 @@ Returns Transport Cost Matrix as a hashref => {ignore_holds_queue_skip_closed}; + my $dbh = C4::Context->dbh; my $transport_costs = $dbh->selectall_arrayref("SELECT * FROM transport_cost",{ Slice => {} }); @@ -77,7 +80,7 @@ sub TransportCostMatrix { disable_transfer => $disabled }; - if ( C4::Context->preference("HoldsQueueSkipClosed") ) { + if ( !$ignore_holds_queue_skip_closed && C4::Context->preference("HoldsQueueSkipClosed") ) { $calendars->{$from} ||= Koha::Calendar->new( branchcode => $from ); $transport_cost_matrix{$to}{$from}{disable_transfer} ||= $calendars->{$from}->is_holiday( $today ); diff --git a/admin/transport-cost-matrix.pl b/admin/transport-cost-matrix.pl index 9ef26c72b1..c146da975c 100755 --- a/admin/transport-cost-matrix.pl +++ b/admin/transport-cost-matrix.pl @@ -45,7 +45,7 @@ my $update = ( $input->param('op') // '' ) eq 'set-cost-matrix'; my ($cost_matrix, $have_matrix); unless ($update) { - $cost_matrix = TransportCostMatrix(); + $cost_matrix = TransportCostMatrix({ ignore_holds_queue_skip_closed => 1 }); $have_matrix = keys %$cost_matrix if $cost_matrix; } -- 2.39.5