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

(-)a/installer/data/mysql/atomicupdate/bug_25429.perl (+9 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
        INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
5
        ('CleanUpDatabaseReturnClaims', '', '', 'Sets the age of resolved return claims to delete from the database for cleanup_database.pl', 'Integer' );
6
    });
7
8
    NewVersion( $DBversion, 25429, "Cleanup Database - remove resolved claims returned from db after X days");
9
}
(-)a/installer/data/mysql/mandatory/sysprefs.sql (+1 lines)
Lines 131-136 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
131
('ClaimReturnedChargeFee', 'ask', 'ask|charge|no_charge', 'Controls whether or not a lost item fee is charged for return claims', 'Choice'),
131
('ClaimReturnedChargeFee', 'ask', 'ask|charge|no_charge', 'Controls whether or not a lost item fee is charged for return claims', 'Choice'),
132
('ClaimReturnedLostValue', '', '', 'Sets the LOST AV value that represents "Claims returned" as a lost value', 'Free'),
132
('ClaimReturnedLostValue', '', '', 'Sets the LOST AV value that represents "Claims returned" as a lost value', 'Free'),
133
('ClaimReturnedWarningThreshold', '', '', 'Sets the number of return claims past which the librarian will be warned the patron has many return claims', 'Integer'),
133
('ClaimReturnedWarningThreshold', '', '', 'Sets the number of return claims past which the librarian will be warned the patron has many return claims', 'Integer'),
134
('CleanUpDatabaseReturnClaims', '', '', 'Sets the age of resolved return claims to delete from the database for cleanup_database.pl', 'Integer' ),
134
('CoceHost', '', NULL, 'Coce server URL', 'Free'),
135
('CoceHost', '', NULL, 'Coce server URL', 'Free'),
135
('CoceProviders', '', 'aws,gb,ol', 'Coce providers', 'multiple'),
136
('CoceProviders', '', 'aws,gb,ol', 'Coce providers', 'multiple'),
136
('COinSinOPACResults','1','','If ON, use COinS in OPAC search results page.  NOTE: this can slow down search response time significantly','YesNo'),
137
('COinSinOPACResults','1','','If ON, use COinS in OPAC search results page.  NOTE: this can slow down search response time significantly','YesNo'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (+6 lines)
Lines 1224-1226 Circulation: Link Here
1224
            - pref: ClaimReturnedWarningThreshold
1224
            - pref: ClaimReturnedWarningThreshold
1225
              class: integer
1225
              class: integer
1226
            - items.
1226
            - items.
1227
        -
1228
            - Remove resolved return claims older than
1229
            - pref: CleanUpDatabaseReturnClaims
1230
              class: integer
1231
            - days.
1232
            - <span class="hint">This system preference is used by the cleanup_database.pl cronjob.</span>
(-)a/misc/cronjobs/cleanup_database.pl (-3 / +1 lines)
Lines 123-129 my $pZ3950; Link Here
123
my $pListShareInvites;
123
my $pListShareInvites;
124
my $pDebarments;
124
my $pDebarments;
125
my $allDebarments;
125
my $allDebarments;
126
my $return_claims;
126
my $return_claims = C4::Context->preference('CleanUpDatabaseReturnClaims');
127
my $pExpSelfReg;
127
my $pExpSelfReg;
128
my $pUnvSelfReg;
128
my $pUnvSelfReg;
129
my $fees_days;
129
my $fees_days;
Lines 157-163 GetOptions( Link Here
157
    'list-invites:i'    => \$pListShareInvites,
157
    'list-invites:i'    => \$pListShareInvites,
158
    'restrictions:i'    => \$pDebarments,
158
    'restrictions:i'    => \$pDebarments,
159
    'all-restrictions'  => \$allDebarments,
159
    'all-restrictions'  => \$allDebarments,
160
    'return-claims:i'   => \$return_claims,
161
    'del-exp-selfreg'   => \$pExpSelfReg,
160
    'del-exp-selfreg'   => \$pExpSelfReg,
162
    'del-unv-selfreg'   => \$pUnvSelfReg,
161
    'del-unv-selfreg'   => \$pUnvSelfReg,
163
    'unique-holidays:i' => \$special_holidays_days,
162
    'unique-holidays:i' => \$special_holidays_days,
164
- 

Return to bug 25429