From b9727d20582164da578d125db80576e72e050d2a Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Wed, 18 Jul 2018 17:35:46 +0000 Subject: [PATCH] Bug 18887: (follow-up) Fix null/empty behavior Signed-off-by: Lisette Scheer Signed-off-by: Jesse Maseto Signed-off-by: Josef Moravec Signed-off-by: Nick Clemens --- C4/Reserves.pm | 2 +- admin/smart-rules.pl | 2 +- installer/data/mysql/atomicupdate/bug_18887.perl | 4 ++-- koha-tmpl/intranet-tmpl/prog/en/modules/admin/smart-rules.tt | 2 +- 4 files changed, 5 insertions(+), 5 deletions(-) diff --git a/C4/Reserves.pm b/C4/Reserves.pm index bc5963ff9c..6cfe7776c2 100644 --- a/C4/Reserves.pm +++ b/C4/Reserves.pm @@ -429,7 +429,7 @@ sub CanItemBeReserved { rule_name => 'max_holds', } ); - if ( $rule ) { + if ( $rule && defined( $rule->rule_value ) && $rule->rule_value ne '' ) { my $total_holds_count = Koha::Holds->search( { borrowernumber => $borrower->{borrowernumber} diff --git a/admin/smart-rules.pl b/admin/smart-rules.pl index 4ff96fcc87..aa26cbe54a 100755 --- a/admin/smart-rules.pl +++ b/admin/smart-rules.pl @@ -232,7 +232,7 @@ elsif ($op eq "set-branch-defaults") { $holdallowed =~ s/\s//g; $holdallowed = undef if $holdallowed !~ /^\d+/; $max_holds =~ s/\s//g; - $max_holds = undef if $max_holds !~ /^\d+/; + $max_holds = '' if $max_holds !~ /^\d+/; if ($branch eq "*") { my $sth_search = $dbh->prepare("SELECT count(*) AS total diff --git a/installer/data/mysql/atomicupdate/bug_18887.perl b/installer/data/mysql/atomicupdate/bug_18887.perl index 38610c9d44..07ee2d357f 100644 --- a/installer/data/mysql/atomicupdate/bug_18887.perl +++ b/installer/data/mysql/atomicupdate/bug_18887.perl @@ -20,12 +20,12 @@ if( CheckVersion( $DBversion ) ) { $dbh->do(q{ INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) - SELECT branchcode, categorycode, NULL, 'max_holds', max_holds FROM branch_borrower_circ_rules + SELECT branchcode, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM branch_borrower_circ_rules }); $dbh->do(q{ INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) - SELECT NULL, categorycode, NULL, 'max_holds', max_holds FROM branch_borrower_circ_rules + SELECT NULL, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM default_borrower_circ_rules }); $dbh->do(q{ diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/smart-rules.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/smart-rules.tt index 509f0db30d..93b34f2f34 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/smart-rules.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/smart-rules.tt @@ -520,7 +520,7 @@ [% SET rule_value = CirculationRules.Get( branch_cat_rule_loo.branchcode, branch_cat_rule_loo.categorycode, branch_cat_rule_loo.itemtype, 'max_holds' ) %] - [% IF rule_value %] + [% IF rule_value.defined && rule_value != '' %] [% rule_value %] [% ELSE %] Unlimited -- 2.39.5