2 # Copyright 2000-2002 Katipo Communications
3 # copyright 2010 BibLibre
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
23 use C4::Output qw( output_html_with_http_headers );
24 use C4::Auth qw( get_template_and_user );
29 use Koha::CirculationRules;
30 use Koha::Patron::Categories;
35 my $dbh = C4::Context->dbh;
38 # $flagsrequired->{circulation}=1;
39 my ($template, $loggedinuser, $cookie)
40 = get_template_and_user({template_name => "admin/smart-rules.tt",
43 flagsrequired => {parameters => 'manage_circ_rules'},
46 my $type=$input->param('type');
48 my $branch = $input->param('branch');
50 if ( C4::Context->preference('DefaultToLoggedInLibraryCircRules') ) {
51 $branch = Koha::Libraries->search->count() == 1 ? undef : C4::Context::mybranch();
54 $branch = C4::Context::only_my_library() ? ( C4::Context::mybranch() || '*' ) : '*';
58 my $logged_in_patron = Koha::Patrons->find( $loggedinuser );
60 my $can_edit_from_any_library = $logged_in_patron->has_permission( {parameters => 'manage_circ_rules_from_any_libraries' } );
61 $template->param( restricted_to_own_library => not $can_edit_from_any_library );
62 $branch = C4::Context::mybranch() unless $can_edit_from_any_library;
64 my $op = $input->param('op') || q{};
65 my $language = C4::Languages::getlanguage();
67 my $cache = Koha::Caches->get_instance;
68 $cache->clear_from_cache( Koha::CirculationRules::GUESSED_ITEMTYPES_KEY );
70 if ($op eq 'delete') {
71 my $itemtype = $input->param('itemtype');
72 my $categorycode = $input->param('categorycode');
74 Koha::CirculationRules->set_rules(
76 categorycode => $categorycode eq '*' ? undef : $categorycode,
77 branchcode => $branch eq '*' ? undef : $branch,
78 itemtype => $itemtype eq '*' ? undef : $itemtype,
81 maxonsiteissueqty => undef,
82 rentaldiscount => undef,
85 maxsuspensiondays => undef,
86 suspension_chargeperiod => undef,
88 chargeperiod => undef,
89 chargeperiod_charge_at => undef,
94 hardduedatecompare => undef,
95 renewalsallowed => undef,
96 unseen_renewals_allowed => undef,
97 renewalperiod => undef,
98 norenewalbefore => undef,
100 no_auto_renewal_after => undef,
101 no_auto_renewal_after_hard_limit => undef,
102 reservesallowed => undef,
103 holds_per_record => undef,
104 holds_per_day => undef,
105 onshelfholds => undef,
106 opacitemholds => undef,
107 overduefinescap => undef,
108 cap_fine_to_replacement_price => undef,
109 article_requests => undef,
111 recalls_allowed => undef,
112 recalls_per_record => undef,
113 on_shelf_recalls => undef,
114 recall_due_date_interval => undef,
115 recall_overdue_fine => undef,
116 recall_shelf_time => undef,
117 decreaseloanholds => undef,
122 elsif ($op eq 'delete-branch-cat') {
123 my $categorycode = $input->param('categorycode');
124 if ($branch eq "*") {
125 if ($categorycode eq "*") {
126 Koha::CirculationRules->set_rules(
129 categorycode => undef,
132 patron_maxissueqty => undef,
133 patron_maxonsiteissueqty => undef,
137 Koha::CirculationRules->set_rules(
142 holdallowed => undef,
143 hold_fulfillment_policy => undef,
144 returnbranch => undef,
149 Koha::CirculationRules->set_rules(
151 categorycode => $categorycode,
155 patron_maxissueqty => undef,
156 patron_maxonsiteissueqty => undef,
161 } elsif ($categorycode eq "*") {
162 Koha::CirculationRules->set_rules(
164 branchcode => $branch,
165 categorycode => undef,
168 patron_maxissueqty => undef,
169 patron_maxonsiteissueqty => undef,
173 Koha::CirculationRules->set_rules(
175 branchcode => $branch,
178 holdallowed => undef,
179 hold_fulfillment_policy => undef,
180 returnbranch => undef,
185 Koha::CirculationRules->set_rules(
187 categorycode => $categorycode,
188 branchcode => $branch,
191 patron_maxissueqty => undef,
192 patron_maxonsiteissueqty => undef,
198 elsif ($op eq 'delete-branch-item') {
199 my $itemtype = $input->param('itemtype');
200 if ($branch eq "*") {
201 if ($itemtype eq "*") {
202 Koha::CirculationRules->set_rules(
207 holdallowed => undef,
208 hold_fulfillment_policy => undef,
209 returnbranch => undef,
214 Koha::CirculationRules->set_rules(
217 itemtype => $itemtype,
219 holdallowed => undef,
220 hold_fulfillment_policy => undef,
221 returnbranch => undef,
226 } elsif ($itemtype eq "*") {
227 Koha::CirculationRules->set_rules(
229 branchcode => $branch,
232 holdallowed => undef,
233 hold_fulfillment_policy => undef,
234 returnbranch => undef,
239 Koha::CirculationRules->set_rules(
241 branchcode => $branch,
242 itemtype => $itemtype,
244 holdallowed => undef,
245 hold_fulfillment_policy => undef,
246 returnbranch => undef,
252 # save the values entered
253 elsif ($op eq 'add') {
254 my $br = $branch; # branch
255 my $bor = $input->param('categorycode'); # borrower category
256 my $itemtype = $input->param('itemtype'); # item type
257 my $fine = $input->param('fine');
258 my $finedays = $input->param('finedays');
259 my $maxsuspensiondays = $input->param('maxsuspensiondays') || q{};
260 my $suspension_chargeperiod = $input->param('suspension_chargeperiod') || 1;
261 my $firstremind = $input->param('firstremind');
262 my $chargeperiod = $input->param('chargeperiod');
263 my $chargeperiod_charge_at = $input->param('chargeperiod_charge_at');
264 my $maxissueqty = strip_non_numeric( scalar $input->param('maxissueqty') );
265 my $maxonsiteissueqty = strip_non_numeric( scalar $input->param('maxonsiteissueqty') );
266 my $renewalsallowed = $input->param('renewalsallowed');
267 my $unseen_renewals_allowed = defined $input->param('unseen_renewals_allowed') ? strip_non_numeric( scalar $input->param('unseen_renewals_allowed') ) : q{};
268 my $renewalperiod = $input->param('renewalperiod');
269 my $norenewalbefore = $input->param('norenewalbefore');
270 $norenewalbefore = q{} if $norenewalbefore =~ /^\s*$/;
271 my $auto_renew = $input->param('auto_renew') eq 'yes' ? 1 : 0;
272 my $no_auto_renewal_after = $input->param('no_auto_renewal_after');
273 $no_auto_renewal_after = q{} if $no_auto_renewal_after =~ /^\s*$/;
274 my $no_auto_renewal_after_hard_limit = $input->param('no_auto_renewal_after_hard_limit') || q{};
275 my $reservesallowed = strip_non_numeric( scalar $input->param('reservesallowed') );
276 my $holds_per_record = strip_non_numeric( scalar $input->param('holds_per_record') );
277 my $holds_per_day = strip_non_numeric( scalar $input->param('holds_per_day') );
278 my $onshelfholds = $input->param('onshelfholds') || 0;
279 my $issuelength = $input->param('issuelength') || 0;
280 my $daysmode = $input->param('daysmode');
281 my $lengthunit = $input->param('lengthunit');
282 my $hardduedate = $input->param('hardduedate') || q{};
283 my $hardduedatecompare = $input->param('hardduedatecompare');
284 my $rentaldiscount = $input->param('rentaldiscount') || 0;
285 my $opacitemholds = $input->param('opacitemholds') || 0;
286 my $article_requests = $input->param('article_requests') || 'no';
287 my $overduefinescap = $input->param('overduefinescap') || q{};
288 my $cap_fine_to_replacement_price = ($input->param('cap_fine_to_replacement_price') || q{}) eq 'on';
289 my $note = $input->param('note');
290 my $decreaseloanholds = $input->param('decreaseloanholds') || q{};
291 my $recalls_allowed = $input->param('recalls_allowed');
292 my $recalls_per_record = $input->param('recalls_per_record');
293 my $on_shelf_recalls = $input->param('on_shelf_recalls');
294 my $recall_due_date_interval = $input->param('recall_due_date_interval');
295 my $recall_overdue_fine = $input->param('recall_overdue_fine');
296 my $recall_shelf_time = $input->param('recall_shelf_time');
299 maxissueqty => $maxissueqty,
300 maxonsiteissueqty => $maxonsiteissueqty,
301 rentaldiscount => $rentaldiscount,
303 finedays => $finedays,
304 maxsuspensiondays => $maxsuspensiondays,
305 suspension_chargeperiod => $suspension_chargeperiod,
306 firstremind => $firstremind,
307 chargeperiod => $chargeperiod,
308 chargeperiod_charge_at => $chargeperiod_charge_at,
309 issuelength => $issuelength,
310 daysmode => $daysmode,
311 lengthunit => $lengthunit,
312 hardduedate => $hardduedate,
313 hardduedatecompare => $hardduedatecompare,
314 renewalsallowed => $renewalsallowed,
315 unseen_renewals_allowed => $unseen_renewals_allowed,
316 renewalperiod => $renewalperiod,
317 norenewalbefore => $norenewalbefore,
318 auto_renew => $auto_renew,
319 no_auto_renewal_after => $no_auto_renewal_after,
320 no_auto_renewal_after_hard_limit => $no_auto_renewal_after_hard_limit,
321 reservesallowed => $reservesallowed,
322 holds_per_record => $holds_per_record,
323 holds_per_day => $holds_per_day,
324 onshelfholds => $onshelfholds,
325 opacitemholds => $opacitemholds,
326 overduefinescap => $overduefinescap,
327 cap_fine_to_replacement_price => $cap_fine_to_replacement_price,
328 article_requests => $article_requests,
330 decreaseloanholds => $decreaseloanholds,
331 recalls_allowed => $recalls_allowed,
332 recalls_per_record => $recalls_per_record,
333 on_shelf_recalls => $on_shelf_recalls,
334 recall_due_date_interval => $recall_due_date_interval,
335 recall_overdue_fine => $recall_overdue_fine,
336 recall_shelf_time => $recall_shelf_time,
339 Koha::CirculationRules->set_rules(
341 categorycode => $bor eq '*' ? undef : $bor,
342 itemtype => $itemtype eq '*' ? undef : $itemtype,
343 branchcode => $br eq '*' ? undef : $br,
349 elsif ($op eq "set-branch-defaults") {
350 my $categorycode = $input->param('categorycode');
351 my $patron_maxissueqty = strip_non_numeric( scalar $input->param('patron_maxissueqty') );
352 my $patron_maxonsiteissueqty = $input->param('patron_maxonsiteissueqty');
353 $patron_maxonsiteissueqty = strip_non_numeric($patron_maxonsiteissueqty);
354 my $holdallowed = $input->param('holdallowed');
355 my $hold_fulfillment_policy = $input->param('hold_fulfillment_policy');
356 my $returnbranch = $input->param('returnbranch');
357 my $max_holds = strip_non_numeric( scalar $input->param('max_holds') );
359 if ($branch eq "*") {
360 Koha::CirculationRules->set_rules(
365 holdallowed => $holdallowed,
366 hold_fulfillment_policy => $hold_fulfillment_policy,
367 returnbranch => $returnbranch,
371 Koha::CirculationRules->set_rules(
373 categorycode => undef,
376 patron_maxissueqty => $patron_maxissueqty,
377 patron_maxonsiteissueqty => $patron_maxonsiteissueqty,
382 Koha::CirculationRules->set_rules(
385 branchcode => $branch,
387 holdallowed => $holdallowed,
388 hold_fulfillment_policy => $hold_fulfillment_policy,
389 returnbranch => $returnbranch,
393 Koha::CirculationRules->set_rules(
395 categorycode => undef,
396 branchcode => $branch,
398 patron_maxissueqty => $patron_maxissueqty,
399 patron_maxonsiteissueqty => $patron_maxonsiteissueqty,
404 Koha::CirculationRules->set_rule(
406 branchcode => $branch,
407 categorycode => undef,
408 rule_name => 'max_holds',
409 rule_value => $max_holds,
413 elsif ($op eq "add-branch-cat") {
414 my $categorycode = $input->param('categorycode');
415 my $patron_maxissueqty = strip_non_numeric( scalar $input->param('patron_maxissueqty') );
416 my $patron_maxonsiteissueqty = $input->param('patron_maxonsiteissueqty');
417 $patron_maxonsiteissueqty = strip_non_numeric($patron_maxonsiteissueqty);
418 my $max_holds = $input->param('max_holds');
419 $max_holds = strip_non_numeric($max_holds);
421 if ($branch eq "*") {
422 if ($categorycode eq "*") {
423 Koha::CirculationRules->set_rules(
425 categorycode => undef,
428 max_holds => $max_holds,
429 patron_maxissueqty => $patron_maxissueqty,
430 patron_maxonsiteissueqty => $patron_maxonsiteissueqty,
435 Koha::CirculationRules->set_rules(
437 categorycode => $categorycode,
440 max_holds => $max_holds,
441 patron_maxissueqty => $patron_maxissueqty,
442 patron_maxonsiteissueqty => $patron_maxonsiteissueqty,
447 } elsif ($categorycode eq "*") {
448 Koha::CirculationRules->set_rules(
450 categorycode => undef,
451 branchcode => $branch,
453 max_holds => $max_holds,
454 patron_maxissueqty => $patron_maxissueqty,
455 patron_maxonsiteissueqty => $patron_maxonsiteissueqty,
460 Koha::CirculationRules->set_rules(
462 categorycode => $categorycode,
463 branchcode => $branch,
465 max_holds => $max_holds,
466 patron_maxissueqty => $patron_maxissueqty,
467 patron_maxonsiteissueqty => $patron_maxonsiteissueqty,
473 elsif ( $op eq "add-open-article-requests-limit" ) {
474 my $categorycode = $input->param('categorycode');
475 my $open_article_requests_limit = strip_non_numeric( scalar $input->param('open_article_requests_limit') );
477 Koha::Exception->throw("No value passed for article request limit")
478 if not defined $open_article_requests_limit # There is a JS check for that
479 || $open_article_requests_limit eq q{};
481 if ( $branch eq "*" ) {
482 if ( $categorycode eq "*" ) {
483 Koha::CirculationRules->set_rules(
484 { categorycode => undef,
486 rules => { open_article_requests_limit => $open_article_requests_limit, }
490 Koha::CirculationRules->set_rules(
491 { categorycode => $categorycode,
493 rules => { open_article_requests_limit => $open_article_requests_limit, }
497 } elsif ( $categorycode eq "*" ) {
498 Koha::CirculationRules->set_rules(
499 { categorycode => undef,
500 branchcode => $branch,
501 rules => { open_article_requests_limit => $open_article_requests_limit, }
505 Koha::CirculationRules->set_rules(
506 { categorycode => $categorycode,
507 branchcode => $branch,
508 rules => { open_article_requests_limit => $open_article_requests_limit, }
512 } elsif ( $op eq 'del-open-article-requests-limit' ) {
513 my $categorycode = $input->param('categorycode');
514 if ( $branch eq "*" ) {
515 if ( $categorycode eq "*" ) {
516 Koha::CirculationRules->set_rules(
517 { branchcode => undef,
518 categorycode => undef,
519 rules => { open_article_requests_limit => undef, }
523 Koha::CirculationRules->set_rules(
524 { categorycode => $categorycode,
526 rules => { open_article_requests_limit => undef, }
530 } elsif ( $categorycode eq "*" ) {
531 Koha::CirculationRules->set_rules(
532 { branchcode => $branch,
533 categorycode => undef,
534 rules => { open_article_requests_limit => undef, }
538 Koha::CirculationRules->set_rules(
539 { categorycode => $categorycode,
540 branchcode => $branch,
541 rules => { open_article_requests_limit => undef, }
546 elsif ( $op eq "set-article-request-fee" ) {
548 my $category = $input->param('article_request_fee_category');
549 my $fee = strip_non_numeric( scalar $input->param('article_request_fee') );
551 Koha::Exception->throw("No value passed for article request fee")
552 if not defined $fee # There is a JS check for that
555 Koha::CirculationRules->set_rules(
556 { categorycode => ( $category eq '*' ) ? undef : $category,
557 branchcode => ( $branch eq '*' ) ? undef : $branch,
558 rules => { article_request_fee => $fee },
562 } elsif ( $op eq 'del-article-request-fee' ) {
564 my $category = $input->param('article_request_fee_category');
566 Koha::CirculationRules->set_rules(
567 { categorycode => ( $category eq '*' ) ? undef : $category,
568 branchcode => ( $branch eq '*' ) ? undef : $branch,
569 rules => { article_request_fee => undef },
573 elsif ($op eq "add-branch-item") {
574 my $itemtype = $input->param('itemtype');
575 my $holdallowed = $input->param('holdallowed');
576 my $hold_fulfillment_policy = $input->param('hold_fulfillment_policy');
577 my $returnbranch = $input->param('returnbranch');
579 if ($branch eq "*") {
580 if ($itemtype eq "*") {
581 Koha::CirculationRules->set_rules(
586 holdallowed => $holdallowed,
587 hold_fulfillment_policy => $hold_fulfillment_policy,
588 returnbranch => $returnbranch,
593 Koha::CirculationRules->set_rules(
595 itemtype => $itemtype,
598 holdallowed => $holdallowed,
599 hold_fulfillment_policy => $hold_fulfillment_policy,
600 returnbranch => $returnbranch,
605 } elsif ($itemtype eq "*") {
606 Koha::CirculationRules->set_rules(
609 branchcode => $branch,
611 holdallowed => $holdallowed,
612 hold_fulfillment_policy => $hold_fulfillment_policy,
613 returnbranch => $returnbranch,
618 Koha::CirculationRules->set_rules(
620 itemtype => $itemtype,
621 branchcode => $branch,
623 holdallowed => $holdallowed,
624 hold_fulfillment_policy => $hold_fulfillment_policy,
625 returnbranch => $returnbranch,
631 elsif ( $op eq 'mod-refund-lost-item-fee-rule' ) {
633 my $lostreturn = $input->param('lostreturn');
635 if ( $lostreturn eq '*' ) {
636 if ( $branch ne '*' ) {
637 # only do something for $lostreturn eq '*' if branch-specific
638 Koha::CirculationRules->set_rules(
640 branchcode => $branch,
648 Koha::CirculationRules->set_rules(
650 branchcode => $branch,
652 lostreturn => $lostreturn
658 my $processingreturn = $input->param('processingreturn');
660 if ( $processingreturn eq '*' ) {
661 if ( $branch ne '*' ) {
662 # only do something for $processingreturn eq '*' if branch-specific
663 Koha::CirculationRules->set_rules(
665 branchcode => $branch,
667 processingreturn => undef
673 Koha::CirculationRules->set_rules(
675 branchcode => $branch,
677 processingreturn => $processingreturn
682 } elsif ( $op eq "set-waiting-hold-cancellation" ) {
684 my $category = $input->param('waiting_hold_cancellation_category');
685 my $itemtype = $input->param('waiting_hold_cancellation_itemtype');
686 my $policy = strip_non_numeric( scalar $input->param('waiting_hold_cancellation_policy') )
690 Koha::Exception->throw("No value passed for waiting holds cancellation policy")
691 if not defined $policy # There is a JS check for that
694 Koha::CirculationRules->set_rules(
695 { categorycode => ( $category eq '*' ) ? undef : $category,
696 itemtype => ( $itemtype eq '*' ) ? undef : $itemtype,
697 branchcode => ( $branch eq '*' ) ? undef : $branch,
698 rules => { waiting_hold_cancellation => $policy },
702 } elsif ( $op eq 'del-waiting-hold-cancellation' ) {
704 my $category = $input->param('waiting_hold_cancellation_category');
705 my $itemtype = $input->param('waiting_hold_cancellation_itemtype');
707 Koha::CirculationRules->set_rules(
708 { categorycode => ( $category eq '*' ) ? undef : $category,
709 itemtype => ( $itemtype eq '*' ) ? undef : $itemtype,
710 branchcode => ( $branch eq '*' ) ? undef : $branch,
711 rules => { waiting_hold_cancellation => undef },
717 my $refundLostItemFeeRule = Koha::CirculationRules->find({ branchcode => ($branch eq '*') ? undef : $branch, rule_name => 'lostreturn' });
718 my $defaultLostItemFeeRule = Koha::CirculationRules->find({ branchcode => undef, rule_name => 'lostreturn' });
719 my $refundProcessingFeeRule = Koha::CirculationRules->find({ branchcode => ($branch eq '*') ? undef : $branch, rule_name => 'processingreturn' });
720 my $defaultProcessingFeeRule = Koha::CirculationRules->find({ branchcode => undef, rule_name => 'processingreturn' });
722 refundLostItemFeeRule => $refundLostItemFeeRule,
723 defaultRefundRule => $defaultLostItemFeeRule ? $defaultLostItemFeeRule->rule_value : 'refund',
724 refundProcessingFeeRule => $refundProcessingFeeRule,
725 defaultProcessingRefundRule => $defaultProcessingFeeRule ? $defaultProcessingFeeRule->rule_value : 'refund',
728 my $patron_categories = Koha::Patron::Categories->search({}, { order_by => ['description'] });
730 my $itemtypes = Koha::ItemTypes->search_with_localization;
732 my $humanbranch = ( $branch ne '*' ? $branch : undef );
734 my $all_rules = Koha::CirculationRules->search({ branchcode => $humanbranch });
735 my $definedbranch = $all_rules->count ? 1 : 0;
738 while ( my $r = $all_rules->next ) {
740 $rules->{ $r->{categorycode} // q{} }->{ $r->{itemtype} // q{} }->{ $r->{rule_name} } = $r->{rule_value};
743 $template->param(show_branch_cat_rule_form => 1);
746 patron_categories => $patron_categories,
747 itemtypeloop => $itemtypes,
748 humanbranch => $humanbranch,
749 current_branch => $branch,
750 definedbranch => $definedbranch,
753 output_html_with_http_headers $input, $cookie, $template->output;
757 # sort by patron category, then item type, putting
758 # default entries at the bottom
759 sub by_category_and_itemtype {
760 unless (by_category($a, $b)) {
761 return by_itemtype($a, $b);
767 if ($a->{'default_humancategorycode'}) {
768 return ($b->{'default_humancategorycode'} ? 0 : 1);
769 } elsif ($b->{'default_humancategorycode'}) {
772 return $a->{'humancategorycode'} cmp $b->{'humancategorycode'};
778 if ($a->{default_translated_description}) {
779 return ($b->{'default_translated_description'} ? 0 : 1);
780 } elsif ($b->{'default_translated_description'}) {
783 return lc $a->{'translated_description'} cmp lc $b->{'translated_description'};
787 sub strip_non_numeric {
790 $string = q{} if $string !~ /^\d+/;