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

(-)a/installer/data/mysql/en/mandatory/sample_notices.sql (+5 lines)
Lines 133-138 Thank you. Link Here
133
133
134
Your library.'
134
Your library.'
135
);
135
);
136
136
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
137
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
137
VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <<listname>> accepted', 'Dear patron,
138
VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <<listname>> accepted', 'Dear patron,
138
139
Lines 142-144 Thank you. Link Here
142
143
143
Your library.'
144
Your library.'
144
);
145
);
146
147
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
148
VALUES (
149
'members','MEMEXP','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian');
(-)a/installer/data/mysql/sysprefs.sql (-2 / +2 lines)
Lines 192-197 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
192
('maxoutstanding','5','','maximum amount withstanding to be able make holds','Integer'),
192
('maxoutstanding','5','','maximum amount withstanding to be able make holds','Integer'),
193
('maxRecordsForFacets','20',NULL,NULL,'Integer'),
193
('maxRecordsForFacets','20',NULL,NULL,'Integer'),
194
('maxreserves','50','','Define maximum number of holds a patron can place','Integer'),
194
('maxreserves','50','','Define maximum number of holds a patron can place','Integer'),
195
('MembershipExpiryDaysNotice' ,14,'Send an account expiration notice that a patron\'s card is about to expire after',NULL,'Integer'),
195
('minPasswordLength','3',NULL,'Specify the minimum length of a patron/staff password','free'),
196
('minPasswordLength','3',NULL,'Specify the minimum length of a patron/staff password','free'),
196
('NewItemsDefaultLocation','','','If set, all new items will have a location of the given Location Code ( Authorized Value type LOC )',''),
197
('NewItemsDefaultLocation','','','If set, all new items will have a location of the given Location Code ( Authorized Value type LOC )',''),
197
('noissuescharge','5','','Define maximum amount withstanding before check outs are blocked','Integer'),
198
('noissuescharge','5','','Define maximum amount withstanding before check outs are blocked','Integer'),
Lines 454-458 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
454
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
455
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
455
('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'),
456
('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'),
456
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
457
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
457
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo')
458
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo');
458
;
(-)a/installer/data/mysql/updatedatabase.pl (+8 lines)
Lines 8845-8850 if ( CheckVersion($DBversion) ) { Link Here
8845
   SetVersion ($DBversion);
8845
   SetVersion ($DBversion);
8846
}
8846
}
8847
8847
8848
$DBversion = "3.17.00.XXX";
8849
if ( CheckVersion($DBversion) ) {
8850
    $dbh->do(q{INSERT INTO `letter` (`module`, `code`, `name`, `title`,`content`) VALUES('members','MEMEXP','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian')});
8851
    $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('MembershipExpiryDaysNotice',14,'Send an account expiration notice that a patron''s card is about to expire after',NULL,'Integer')");
8852
    print "Upgrade to $DBversion done (Bug - 6810 Insert value in letter and syspref table for account expiration notifications)\n";
8853
   SetVersion ($DBversion);
8854
}
8855
8848
=head1 FUNCTIONS
8856
=head1 FUNCTIONS
8849
8857
8850
=head2 TableExists($table)
8858
=head2 TableExists($table)
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-2 / +1 lines)
Lines 90-96 Patrons: Link Here
90
           class: integer
90
           class: integer
91
         - days beforehand.
91
         - days beforehand.
92
     -
92
     -
93
         - Send a membership expiry notice that a patron is about to expire after
93
         - "Send an account expiration notice when a patron's card will expire in"
94
         - pref: MembershipExpiryDaysNotice
94
         - pref: MembershipExpiryDaysNotice
95
           class: integer
95
           class: integer
96
         - days.
96
         - days.
97
- 

Return to bug 6810