View | Details | Raw Unified | Return to bug 38924
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_38924-patron_quotas.pl (-1 / +10 lines)
Lines 3-9 use Koha::Installer::Output qw(say_warning say_success say_info); Link Here
3
3
4
return {
4
return {
5
    bug_number  => "38924",
5
    bug_number  => "38924",
6
    description => "Add patron quota and quota_usage tables and permissions",
6
    description => "Add patron quota and quota_usage tables, permissions and system preferences for quotas",
7
    up          => sub {
7
    up          => sub {
8
        my ($args) = @_;
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
Lines 58-62 return { Link Here
58
        } else {
58
        } else {
59
            say_info( $out, "Patron quota usage table already exists" );
59
            say_info( $out, "Patron quota usage table already exists" );
60
        }
60
        }
61
62
        $dbh->do(q{
63
            INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type)
64
            VALUES 
65
            ('AllowQuotaOverride', '0', NULL, 'Allow staff to override and check out items to patrons who have exceeded their quota limit', 'YesNo'),
66
            ('UseGuarantorQuota', '0', NULL, 'Use guarantor quota instead of guarantee quota when checking out items', 'YesNo')
67
        });
68
69
        say_success( $out, "Patron quota preferences added successfully" );
61
    },
70
    },
62
};
71
};
(-)a/installer/data/mysql/mandatory/sysprefs.sql (+2 lines)
Lines 45-50 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
45
('AllowPatronToSetCheckoutsVisibilityForGuarantor', '0', NULL, 'If enabled, the patron can set checkouts to be visible to their guarantor', 'YesNo'),
45
('AllowPatronToSetCheckoutsVisibilityForGuarantor', '0', NULL, 'If enabled, the patron can set checkouts to be visible to their guarantor', 'YesNo'),
46
('AllowPatronToSetFinesVisibilityForGuarantor', '0', NULL, 'If enabled, the patron can set fines to be visible to their guarantor', 'YesNo'),
46
('AllowPatronToSetFinesVisibilityForGuarantor', '0', NULL, 'If enabled, the patron can set fines to be visible to their guarantor', 'YesNo'),
47
('AllowPKIAuth','None','None|Common Name|emailAddress','Use the field from a client-side SSL certificate to look a user in the Koha database','Choice'),
47
('AllowPKIAuth','None','None|Common Name|emailAddress','Use the field from a client-side SSL certificate to look a user in the Koha database','Choice'),
48
('AllowQuotaOverride','0','Allow staff to override and check out items to patrons who have exceeded their quota limit','','YesNo'),
48
('AllowRenewalIfOtherItemsAvailable','0',NULL,'If enabled, allow a patron to renew an item with unfilled holds if other available items can fill that hold.','YesNo'),
49
('AllowRenewalIfOtherItemsAvailable','0',NULL,'If enabled, allow a patron to renew an item with unfilled holds if other available items can fill that hold.','YesNo'),
49
('AllowRenewalLimitOverride','0',NULL,'if ON, allows renewal limits to be overridden on the circulation screen','YesNo'),
50
('AllowRenewalLimitOverride','0',NULL,'if ON, allows renewal limits to be overridden on the circulation screen','YesNo'),
50
('AllowRenewalOnHoldOverride','0',NULL,'If ON, allow items on hold to be renewed with a specified due date','YesNo'),
51
('AllowRenewalOnHoldOverride','0',NULL,'If ON, allow items on hold to be renewed with a specified due date','YesNo'),
Lines 877-882 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
877
('useDaysMode','Calendar','Calendar|Days|Datedue|Dayweek','Choose the method for calculating due date: select Calendar, Datedue or Dayweek to use the holidays module, and Days to ignore the holidays module','Choice'),
878
('useDaysMode','Calendar','Calendar|Days|Datedue|Dayweek','Choose the method for calculating due date: select Calendar, Datedue or Dayweek to use the holidays module, and Days to ignore the holidays module','Choice'),
878
('useDefaultReplacementCost', '0', NULL, 'default replacement cost defined in item type', 'YesNo'),
879
('useDefaultReplacementCost', '0', NULL, 'default replacement cost defined in item type', 'YesNo'),
879
('useDischarge','0',NULL,'Allows librarians to discharge borrowers and borrowers to request a discharge','YesNo'),
880
('useDischarge','0',NULL,'Allows librarians to discharge borrowers and borrowers to request a discharge','YesNo'),
881
('UseGuarantorQuota','0','Use guarantor quota instead of guarantee quota when checking out items if one exists and has enough quota available','','YesNo'),
880
('UseICUStyleQuotes','0',NULL,'Tell Koha whether to use ICU style quotes ({) or default (") when tracing subjects .','YesNo'),
882
('UseICUStyleQuotes','0',NULL,'Tell Koha whether to use ICU style quotes ({) or default (") when tracing subjects .','YesNo'),
881
('UseLibraryFloatLimits', '0', '', 'Enables library float limits', 'YesNo'),
883
('UseLibraryFloatLimits', '0', '', 'Enables library float limits', 'YesNo'),
882
('UseLocationAsAQInSIP', '0', NULL, 'Use permanent_location instead of homebranch for AQ in SIP response', 'YesNo'),
884
('UseLocationAsAQInSIP', '0', NULL, 'Use permanent_location instead of homebranch for AQ in SIP response', 'YesNo'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +12 lines)
Lines 402-407 Circulation: Link Here
402
                  1: Allow
402
                  1: Allow
403
                  0: "Don't allow"
403
                  0: "Don't allow"
404
            - staff to check out an item with age restriction.
404
            - staff to check out an item with age restriction.
405
        -
406
            - pref: AllowQuotaOverride
407
              choices:
408
                  1: "Allow"
409
                  0: "Don't allow" 
410
            - staff to check out items to patrons who have exceeded their quota limit.
411
        -
412
            - pref: UseGuarantorQuota
413
              choices:
414
                  1: "Use"
415
                  0: "Don't use"
416
            - guarantor's quota instead of guarantee's quota when checking out items if guarantor has an active quota and quota has enough availability.
405
        -
417
        -
406
            - Prevent patrons from checking out items if they have more than
418
            - Prevent patrons from checking out items if they have more than
407
            - pref: noissuescharge
419
            - pref: noissuescharge
408
- 

Return to bug 38924