@@ -, +, @@
---
installer/data/mysql/updatedatabase.pl | 24 ++++++++++++++++
.../prog/en/modules/tools/overduerules.tt | 8 ++++++
misc/cronjobs/overdue_notices.pl | 12 ++++++--
tools/overduerules.pl | 30 +++++++++++++-------
4 files changed, 60 insertions(+), 14 deletions(-)
--- a/installer/data/mysql/updatedatabase.pl
+++ a/installer/data/mysql/updatedatabase.pl
@@ -8551,6 +8551,30 @@ if (CheckVersion($DBversion)) {
SetVersion($DBversion);
}
+$DBversion = "3.17.00.XXX";
+if (CheckVersion($DBversion)) {
+ $dbh->do("alter table overduerules
+ add invoice1 int(1) default 0 after debarred1,
+ add invoice2 int(1) default 0 after debarred2,
+ add invoice3 int(1) default 0 after debarred3
+ ");
+ $dbh->do("insert into systempreferences values('InvoiceProcessingFee', 0, NULL, 'Invoice processing fee (charged once per item)', 'Float')");
+ $dbh->do("insert into systempreferences values('InvoiceBillingFee', 0, NULL, 'Invoice billing fee (charged once per bill)', 'Float')");
+ $dbh->do("insert into systempreferences values('DefaultReplacementPrice', 10.0, NULL,'Amount to use when the item has none associated to it.', 'Float')");
+ $dbh->do("insert into letter (module, code, name, is_html, title, message_transport_type, content) values ('circulation', 'INVOICE', 'Processing/Billing invoice', 1, 'Billing invoice', 'email',
+ '
Dear <> <>,
+
The following items are now due and fines have been added:
+ - <>, <>, Barcode: <> Fine: <> Replacement cost:<>, Processing fee:<>
+
+ Billing fee: <>
+ Total: <>
+