Signed-off-by: Minna Kivinen <minna.kivinen@hamk.fi>
Signed-off-by: Joonas Kylmälä <joonas.kylmala@helsinki.fi>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
# Circ rule warnings
{
my $dbh = C4::Context->dbh;
- my $units = $dbh->selectall_arrayref(
- q|SELECT branchcode, categorycode, itemtype, lengthunit FROM issuingrules WHERE lengthunit NOT IN ( 'days', 'hours' ); |,
- { Slice => {} }
- );
+ my $units = Koha::CirculationRules->search({ rule_name => 'lengthunit', rule_value => { -not_in => ['days', 'hours'] } });
- if (@$units) {
+ if ( $units->count ) {
$template->param(
warnIssuingRules => 1,
ir_units => $units,
[% FOREACH unit IN ir_units %]
<tr>
<th scope="row"><b>Warning</b></th>
- <td>The [% unit.branchcode | html %], [% unit.categorycode | html %], [% unit.itemtype | html %]
- issuingrule will fallback to 'days' for 'lengthunit' as it is incorrectly defined as
- [% unit.lengthunit | html %].
+ <td>The [% unit.branchcode || 'branchcode=default' | html %], [% unit.categorycode || 'categorycode=default' | html %], [% unit.itemtype || 'itemtype=default' | html %]
+ issuingrule will fallback to 'days' for 'lengthunit' as it is incorrectly defined as
+ [% unit.rule_value | html %].
</td>
</tr>
[% END %]