Similar to checkin, checkout notices already present. Renewal notices can be
set in messaging preferences at borrower and membership category level.
Contents will be picked up from a notice template.
---
 C4/Circulation.pm                                  |   17 +++++++++++++++++
 .../data/mysql/de-DE/mandatory/sample_notices.sql  |    1 +
 .../optional/sample_notices_message_attributes.sql |    3 ++-
 .../optional/sample_notices_message_transports.sql |    4 +++-
 .../data/mysql/en/mandatory/sample_notices.sql     |    1 +
 .../optional/sample_notices_message_attributes.sql |    4 +++-
 .../optional/sample_notices_message_transports.sql |    5 ++++-
 .../data/mysql/es-ES/mandatory/sample_notices.sql  |    1 +
 .../optional/sample_notices_message_attributes.sql |    4 ++--
 .../optional/sample_notices_message_transports.sql |    4 +++-
 .../mysql/fr-FR/1-Obligatoire/sample_notices.sql   |    1 +
 .../sample_notices_message_attributes.sql          |    3 ++-
 .../sample_notices_message_transports.sql          |    4 +++-
 installer/data/mysql/it-IT/necessari/notices.sql   |    1 +
 .../sample_notices_message_attributes.sql          |    3 ++-
 .../sample_notices_message_transports.sql          |    5 +++--
 .../mysql/nb-NO/1-Obligatorisk/sample_notices.sql  |    1 +
 .../sample_notices_message_attributes.sql          |    3 ++-
 .../sample_notices_message_transports.sql          |    4 +++-
 .../data/mysql/pl-PL/mandatory/sample_notices.sql  |    1 +
 .../optional/sample_notices_message_attributes.sql |    3 ++-
 .../optional/sample_notices_message_transports.sql |    4 +++-
 .../data/mysql/ru-RU/mandatory/sample_notices.sql  |    1 +
 .../optional/sample_notices_message_attributes.sql |    3 ++-
 .../optional/sample_notices_message_transports.sql |    4 +++-
 .../data/mysql/uk-UA/mandatory/sample_notices.sql  |    1 +
 .../optional/sample_notices_message_attributes.sql |    3 ++-
 .../optional/sample_notices_message_transports.sql |    4 +++-
 installer/data/mysql/updatedatabase.pl             |   14 ++++++++++++++
 .../prog/en/includes/messaging-preference-form.inc |    1 +
 .../prog/en/modules/admin/categorie.tt             |    1 +
 .../opac-tmpl/prog/en/modules/opac-messaging.tt    |    1 +
 32 files changed, 90 insertions(+), 20 deletions(-)

diff --git a/C4/Circulation.pm b/C4/Circulation.pm
index 47068f9..3aa7ab6 100644
--- a/C4/Circulation.pm
+++ b/C4/Circulation.pm
@@ -2298,6 +2298,22 @@ sub AddRenewal {
     }
     # Log the renewal
     UpdateStats( $branch, 'renew', $charge, '', $itemnumber, $item->{itype}, 
$borrowernumber);
+        my $borrower = GetMemberDetails( $borrowernumber);
+        my $circulation_alert = 'C4::ItemCirculationAlertPreference';
+        my %conditions = (
+           branchcode   => $branch,
+           categorycode => $borrower->{categorycode},
+           item_type    => $item->{itype},
+           notification => 'ITEMRENEW',
+        );
+         if ($circulation_alert->is_enabled_for(\%conditions)) {
+            SendCirculationAlert({
+               type     => 'ITEMRENEW',
+               item     => $item,
+               borrower => $borrower,
+               branch   => $branch,
+             });
+         }
        return $datedue;
 }
 
@@ -2617,6 +2633,7 @@ sub SendCirculationAlert {
     my %message_name = (
         CHECKIN  => 'Item_Check_in',
         CHECKOUT => 'Item_Checkout',
+        ITEMRENEW    => 'Item_Renew',
     );
     my $borrower_preferences = 
C4::Members::Messaging::GetMessagingPreferences({
         borrowernumber => $borrower->{borrowernumber},
diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql 
b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
index 166c36d..721e8b3 100644
--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
@@ -11,6 +11,7 @@ VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r 
<<borrowers.firstname>
 ('reserves', 'HOLD_PRINT', 'Vormerkbenachrichtigung (Print)', 
'Vormerkbenachrichtigung (Print)', 
'<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchzip>>
 <<branches.branchcity>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> 
<<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.address2>>\r\n<<borrowers.zipcode>>
 
<<borrowers.city>>\r\n<<borrowers.country>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nLiebe(r)
 <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFür Sie liegt seit dem 
<<reserves.waitingdate>> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: 
<<biblio.title>>\r\nVerfasser: <<biblio.author>>\r\nSignatur: 
<<items.itemcallnumber>>\r\n'),
 ('circulation','CHECKIN','Rückgabequittung 
(Zusammenfassung)','Rückgabequittung','Die folgenden Medien wurden 
zurückgegeben:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank.'),
 ('circulation','CHECKOUT','Ausleihquittung 
(Zusammenfassung)','Ausleihquittung','Die folgenden Medien wurden 
entliehen:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank für Ihren Besuch 
in <<branches.branchname>>.'),
+('circulation','ITEMRENEW','Item_Renew','ItemRenew','The following items have 
been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting 
<<branches.branchname>>.'),
 ('reserves', 'HOLDPLACED', 'Neue Vormerkung', 'Neue Vormerkung','Folgender 
Titel wurde vorgemerkt: <<title>> (<<biblionumber>>) durch den Benutzer 
<<firstname>> <<surname>> (<<cardnumber>>).'),
 ('suggestions','ACCEPTED','Anschaffungsvorschlag wurde angenommen', 'Ihr 
Anschaffungsvorschlag wurde angenommen','Liebe(r) <<borrowers.firstname>> 
<<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur 
Anschaffung vorgeschlagen: <<suggestions.title>> by 
<<suggestions.author>>.\n\nDie Bibliothek hat diesen Titel heute recherchiert 
und wird Ihn sobald wie möglich im Buchhandel bestellen. Sie erhalten 
Nachricht, sobald die Bestellung abgeschlossen ist und sobald der Titel in der 
Bibliotek verfügbar ist.\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte 
an: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'),
 ('suggestions','AVAILABLE','Vorgeschlagenes Medium verfügbar', 'Das 
vorgeschlagene Medium ist jetzt verfügbar','Liebe(r) <<borrowers.firstname>> 
<<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur 
Anschaffung vorgeschlagen: <<suggestions.title>> von 
<<suggestions.author>>.\n\nWir freuen uns Ihnen mitteilen zu können, dass 
dieser Titel jetzt im Bestand der Bibliothek verfügbar ist.\n\nWenn Sie Fragen 
haben, richten Sie Ihre Mail bitte an: <<branches.branchemail>>.\n\nVielen 
Dank,\n\n<<branches.branchname>>'),
diff --git 
a/installer/data/mysql/de-DE/optional/sample_notices_message_attributes.sql 
b/installer/data/mysql/de-DE/optional/sample_notices_message_attributes.sql
index b505486..367bf24 100644
--- a/installer/data/mysql/de-DE/optional/sample_notices_message_attributes.sql
+++ b/installer/data/mysql/de-DE/optional/sample_notices_message_attributes.sql
@@ -5,4 +5,5 @@ values
 (2, 'Advance_Notice', 1),
 (4, 'Hold_Filled', 0),
 (5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
\ No newline at end of file
+(6, 'Item_Checkout', 0),
+(7, 'Item_Renew', 0);
diff --git 
a/installer/data/mysql/de-DE/optional/sample_notices_message_transports.sql 
b/installer/data/mysql/de-DE/optional/sample_notices_message_transports.sql
index ae68378..60ddd52 100644
--- a/installer/data/mysql/de-DE/optional/sample_notices_message_transports.sql
+++ b/installer/data/mysql/de-DE/optional/sample_notices_message_transports.sql
@@ -14,4 +14,6 @@ values
 (5, 'email', 0, 'circulation', 'CHECKIN'),
 (5, 'sms',   0, 'circulation', 'CHECKIN'),
 (6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
+(6, 'sms',   0, 'circulation', 'CHECKOUT'),
+(7, 'email', 0, 'circulation', 'ITEMRENEW'),
+(7, 'sms', 0, 'circulation', 'ITEMRENEW');
diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql 
b/installer/data/mysql/en/mandatory/sample_notices.sql
index 689fa0f..4bb8d4f 100644
--- a/installer/data/mysql/en/mandatory/sample_notices.sql
+++ b/installer/data/mysql/en/mandatory/sample_notices.sql
@@ -11,6 +11,7 @@ VALUES ('circulation','ODUE','Overdue Notice','Item 
Overdue','Dear <<borrowers.f
 ('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', 'Hold 
Available for Pickup (print notice)', 
'<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nChange
 Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> 
<<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> 
<<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>>
 <<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nYou have a hold 
available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: 
<<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: 
<<items.copynumber>>\r\n'),
 ('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following 
items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
 ('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following 
items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you 
for visiting <<branches.branchname>>.'),
+('circulation','ITEMRENEW','Item_Renew','ItemRenew','The following items have 
been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting 
<<branches.branchname>>.'),
 ('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A 
hold has been placed on the following item : <<title>> (<<biblionumber>>) by 
the user <<firstname>> <<surname>> (<<cardnumber>>).'),
 ('suggestions','ACCEPTED','Suggestion accepted', 'Purchase suggestion 
accepted','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nThe library has reviewed your suggestion today. The 
item will be ordered as soon as possible. You will be notified by mail when the 
order is completed, and again when the item arrives at the library.\n\nIf you 
have any questions, please email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
 ('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase 
available','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nWe are pleased to inform you that the item you 
requested is now part of the collection.\n\nIf you have any questions, please 
email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
diff --git 
a/installer/data/mysql/en/optional/sample_notices_message_attributes.sql 
b/installer/data/mysql/en/optional/sample_notices_message_attributes.sql
index a7a6032..ae68f2b 100644
--- a/installer/data/mysql/en/optional/sample_notices_message_attributes.sql
+++ b/installer/data/mysql/en/optional/sample_notices_message_attributes.sql
@@ -5,5 +5,7 @@ values
 (2, 'Advance_Notice', 1),
 (4, 'Hold_Filled', 0),
 (5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
+(6, 'Item_Checkout', 0),
+(7, 'Item_Renew', 0);
+
 
diff --git 
a/installer/data/mysql/en/optional/sample_notices_message_transports.sql 
b/installer/data/mysql/en/optional/sample_notices_message_transports.sql
index ae68378..5b8e2c3 100644
--- a/installer/data/mysql/en/optional/sample_notices_message_transports.sql
+++ b/installer/data/mysql/en/optional/sample_notices_message_transports.sql
@@ -14,4 +14,7 @@ values
 (5, 'email', 0, 'circulation', 'CHECKIN'),
 (5, 'sms',   0, 'circulation', 'CHECKIN'),
 (6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
+(6, 'sms',   0, 'circulation', 'CHECKOUT'),
+(7, 'email', 0, 'circulation', 'ITEMRENEW'),
+(7, 'sms', 0, 'circulation', 'ITEMRENEW');
+
diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices.sql 
b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
index 689fa0f..4bb8d4f 100644
--- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql
+++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
@@ -11,6 +11,7 @@ VALUES ('circulation','ODUE','Overdue Notice','Item 
Overdue','Dear <<borrowers.f
 ('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', 'Hold 
Available for Pickup (print notice)', 
'<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nChange
 Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> 
<<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> 
<<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>>
 <<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nYou have a hold 
available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: 
<<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: 
<<items.copynumber>>\r\n'),
 ('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following 
items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
 ('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following 
items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you 
for visiting <<branches.branchname>>.'),
+('circulation','ITEMRENEW','Item_Renew','ItemRenew','The following items have 
been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting 
<<branches.branchname>>.'),
 ('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A 
hold has been placed on the following item : <<title>> (<<biblionumber>>) by 
the user <<firstname>> <<surname>> (<<cardnumber>>).'),
 ('suggestions','ACCEPTED','Suggestion accepted', 'Purchase suggestion 
accepted','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nThe library has reviewed your suggestion today. The 
item will be ordered as soon as possible. You will be notified by mail when the 
order is completed, and again when the item arrives at the library.\n\nIf you 
have any questions, please email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
 ('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase 
available','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nWe are pleased to inform you that the item you 
requested is now part of the collection.\n\nIf you have any questions, please 
email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
diff --git 
a/installer/data/mysql/es-ES/optional/sample_notices_message_attributes.sql 
b/installer/data/mysql/es-ES/optional/sample_notices_message_attributes.sql
index a7a6032..4f2f6ef 100644
--- a/installer/data/mysql/es-ES/optional/sample_notices_message_attributes.sql
+++ b/installer/data/mysql/es-ES/optional/sample_notices_message_attributes.sql
@@ -5,5 +5,5 @@ values
 (2, 'Advance_Notice', 1),
 (4, 'Hold_Filled', 0),
 (5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
-
+(6, 'Item_Checkout', 0),
+(7, 'Item_Renew', 0);
diff --git 
a/installer/data/mysql/es-ES/optional/sample_notices_message_transports.sql 
b/installer/data/mysql/es-ES/optional/sample_notices_message_transports.sql
index ae68378..60ddd52 100644
--- a/installer/data/mysql/es-ES/optional/sample_notices_message_transports.sql
+++ b/installer/data/mysql/es-ES/optional/sample_notices_message_transports.sql
@@ -14,4 +14,6 @@ values
 (5, 'email', 0, 'circulation', 'CHECKIN'),
 (5, 'sms',   0, 'circulation', 'CHECKIN'),
 (6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
+(6, 'sms',   0, 'circulation', 'CHECKOUT'),
+(7, 'email', 0, 'circulation', 'ITEMRENEW'),
+(7, 'sms', 0, 'circulation', 'ITEMRENEW');
diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql 
b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
index 977e59d..8fcb471 100644
--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
@@ -13,6 +13,7 @@ VALUES
 ('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', 'Hold 
Available for Pickup at <<branches.branchname>>', 
'<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>>\n\n\nChange
 Service Requested\n\n\n\n\n\n\n\n<<borrowers.firstname>> 
<<borrowers.surname>>\n<<borrowers.address>>\n<<borrowers.city>> 
<<borrowers.zipcode>>\n\n\n\n\n\n\n\n\n\n\n<<borrowers.firstname>> 
<<borrowers.surname>> <<borrowers.cardnumber>>\n\nYou have a hold available for 
pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: 
<<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: 
<<items.copynumber>>\r\n'),
 ('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following 
items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
 ('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following 
items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you 
for visiting <<branches.branchname>>.'),
+('circulation','ITEMRENEW','Item_Renew','ItemRenew','The following items have 
been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting 
<<branches.branchname>>.'),
 ('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A 
hold has been placed on the following item : <<title>> (<<biblionumber>>) by 
the user <<firstname>> <<surname>> (<<cardnumber>>).'),
 ('suggestions','ACCEPTED','Suggestion accepted', 'Purchase suggestion 
accepted','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nThe library has reviewed your suggestion today. The 
item will be ordered as soon as possible. You will be notified by mail when the 
order is completed, and again when the item arrives at the library.\n\nIf you 
have any questions, please email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
 ('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase 
available','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nWe are pleased to inform you that the item you 
requested is now part of the collection.\n\nIf you have any questions, please 
email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
diff --git 
a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql 
b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
index 8e919e9..debe7d5 100644
--- 
a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
+++ 
b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
@@ -5,5 +5,6 @@ values
 (2, 'Advance_Notice', 1),
 (4, 'Hold_Filled', 0),
 (5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
+(6, 'Item_Checkout', 0),
+(7, 'Item_Renew', 0);
 
diff --git 
a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql 
b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql
index ae68378..60ddd52 100644
--- 
a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql
+++ 
b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql
@@ -14,4 +14,6 @@ values
 (5, 'email', 0, 'circulation', 'CHECKIN'),
 (5, 'sms',   0, 'circulation', 'CHECKIN'),
 (6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
+(6, 'sms',   0, 'circulation', 'CHECKOUT'),
+(7, 'email', 0, 'circulation', 'ITEMRENEW'),
+(7, 'sms', 0, 'circulation', 'ITEMRENEW');
diff --git a/installer/data/mysql/it-IT/necessari/notices.sql 
b/installer/data/mysql/it-IT/necessari/notices.sql
index 689fa0f..4bb8d4f 100644
--- a/installer/data/mysql/it-IT/necessari/notices.sql
+++ b/installer/data/mysql/it-IT/necessari/notices.sql
@@ -11,6 +11,7 @@ VALUES ('circulation','ODUE','Overdue Notice','Item 
Overdue','Dear <<borrowers.f
 ('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', 'Hold 
Available for Pickup (print notice)', 
'<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nChange
 Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> 
<<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> 
<<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>>
 <<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nYou have a hold 
available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: 
<<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: 
<<items.copynumber>>\r\n'),
 ('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following 
items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
 ('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following 
items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you 
for visiting <<branches.branchname>>.'),
+('circulation','ITEMRENEW','Item_Renew','ItemRenew','The following items have 
been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting 
<<branches.branchname>>.'),
 ('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A 
hold has been placed on the following item : <<title>> (<<biblionumber>>) by 
the user <<firstname>> <<surname>> (<<cardnumber>>).'),
 ('suggestions','ACCEPTED','Suggestion accepted', 'Purchase suggestion 
accepted','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nThe library has reviewed your suggestion today. The 
item will be ordered as soon as possible. You will be notified by mail when the 
order is completed, and again when the item arrives at the library.\n\nIf you 
have any questions, please email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
 ('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase 
available','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nWe are pleased to inform you that the item you 
requested is now part of the collection.\n\nIf you have any questions, please 
email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
diff --git 
a/installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.sql 
b/installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.sql
index 63d07fd..672d6da 100644
--- a/installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.sql
+++ b/installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.sql
@@ -7,5 +7,6 @@ values
 (2, 'Advance_Notice', 1),
 (4, 'Hold_Filled', 0),
 (5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
+(6, 'Item_Checkout', 0),
+(7, 'Item_Renew', 0);
 SET FOREIGN_KEY_CHECKS=1;
diff --git 
a/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql 
b/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql
index c1b1f29..1961d85 100644
--- a/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql
+++ b/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql
@@ -18,6 +18,7 @@ values
 (5, 'email', 0, 'circulation', 'CHECKIN'),
 (5, 'sms',   0, 'circulation', 'CHECKIN'),
 (6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
-
+(6, 'sms',   0, 'circulation', 'CHECKOUT'),
+(7, 'email', 0, 'circulation', 'ITEMRENEW'),
+(7, 'sms', 0, 'circulation', 'ITEMRENEW');
 SET FOREIGN_KEY_CHECKS=1;
diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql 
b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
index cdb5529..45d0e67 100644
--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
@@ -32,6 +32,7 @@ VALUES ('circulation','ODUE','Purring','Purring på 
dokument','<<borrowers.first
 ('reserves', 'HOLD_PRINT', 'Hentemelding (på papir)', 'Hentemelding', 
'<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>>
 <<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> 
<<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>>
 <<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nDu har et reservert 
dokument som kan hentes fra  <<reserves.waitingdate>>:\r\n\r\nTittel: 
<<biblio.title>>\r\nForfatter: <<biblio.author>>\r\nEksemplar: 
<<items.copynumber>>\r\n'),
 ('circulation','CHECKIN','Innlevering','Melding om innlevering','Følgende 
dokument har blitt innlevert:\r\n----\r\n<<biblio.title>>\r\n----\r\nVennlig 
hilsen\r\nBiblioteket'),
 ('circulation','CHECKOUT','Utlån','Melding om utlån','Følgende dokument har 
blitt lånt ut:\r\n----\r\n<<biblio.title>>\r\n----\r\nVennlig 
hilsen\r\nBiblioteket'),
+('circulation','ITEMRENEW','Item_Renew','ItemRenew','The following items have 
been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting 
<<branches.branchname>>.'),
 ('reserves', 'HOLDPLACED', 'Melding om reservasjon', 'Melding om 
reservasjon','Følgende dokument har blitt reservert : <<title>> 
(<<biblionumber>>) av <<firstname>> <<surname>> (<<cardnumber>>).'),
 ('suggestions','ACCEPTED','Forslag godtatt', 'Innkjøpsforslag 
godtatt','<<borrowers.firstname>> <<borrowers.surname>>,\n\nDu har foreslått 
at biblioteket kjøper inn <<suggestions.title>> av 
<<suggestions.author>>.\n\nBiblioteket har vurdert forslaget i dag. Dokumentet 
vil bli bestilt så fort det lar seg gjøre. Du vil få en ny melding når 
bestillingen er gjort, og når dokumentet ankommer biblioteket.\n\nEr det noe 
du lurer på, vennligst kontakt oss på <<branches.branchemail>>.\n\nVennlig 
hilsen,\n\n<<branches.branchname>>'),
 ('suggestions','AVAILABLE','Foreslått dokument tilgjengelig', 'Foreslått 
dokument tilgjengelig','<<borrowers.firstname>> <<borrowers.surname>>,\n\nDu 
har foreslått at biblioteket kjøper inn <<suggestions.title>> av 
<<suggestions.author>>.\n\nVi har gleden av å informere deg om at dokumentet 
nå er innlemmet i samlingen.\n\nEr det noe du lurer på, vennligst kontakt oss 
på <<branches.branchemail>>.\n\nVennlig hilsen,\n\n<<branches.branchname>>'),
diff --git 
a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql 
b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql
index a7a6032..459b913 100644
--- 
a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql
+++ 
b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql
@@ -5,5 +5,6 @@ values
 (2, 'Advance_Notice', 1),
 (4, 'Hold_Filled', 0),
 (5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
+(6, 'Item_Checkout', 0),
+(7, 'Item_Renew', 0);
 
diff --git 
a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql 
b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql
index ae68378..60ddd52 100644
--- 
a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql
+++ 
b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql
@@ -14,4 +14,6 @@ values
 (5, 'email', 0, 'circulation', 'CHECKIN'),
 (5, 'sms',   0, 'circulation', 'CHECKIN'),
 (6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
+(6, 'sms',   0, 'circulation', 'CHECKOUT'),
+(7, 'email', 0, 'circulation', 'ITEMRENEW'),
+(7, 'sms', 0, 'circulation', 'ITEMRENEW');
diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql 
b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
index 6be2eb8..916f05d 100644
--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
@@ -13,6 +13,7 @@ VALUES
 ('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', 'Hold 
Available for Pickup (print notice)', 
'<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nChange
 Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> 
<<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> 
<<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>>
 <<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nYou have a hold 
available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: 
<<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: 
<<items.copynumber>>\r\n'),
 ('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following 
items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
 ('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following 
items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you 
for visiting <<branches.branchname>>.'),
+('circulation','ITEMRENEW','Item_Renew','ItemRenew','The following items have 
been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting 
<<branches.branchname>>.'),
 ('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A 
hold has been placed on the following item : <<title>> (<<biblionumber>>) by 
the user <<firstname>> <<surname>> (<<cardnumber>>).'),
 ('suggestions','ACCEPTED','Suggestion accepted', 'Purchase suggestion 
accepted','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nThe library has reviewed your suggestion today. The 
item will be ordered as soon as possible. You will be notified by mail when the 
order is completed, and again when the item arrives at the library.\n\nIf you 
have any questions, please email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
 ('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase 
available','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nWe are pleased to inform you that the item you 
requested is now part of the collection.\n\nIf you have any questions, please 
email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
diff --git 
a/installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.sql 
b/installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.sql
index 8e919e9..debe7d5 100644
--- a/installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.sql
+++ b/installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.sql
@@ -5,5 +5,6 @@ values
 (2, 'Advance_Notice', 1),
 (4, 'Hold_Filled', 0),
 (5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
+(6, 'Item_Checkout', 0),
+(7, 'Item_Renew', 0);
 
diff --git 
a/installer/data/mysql/pl-PL/optional/sample_notices_message_transports.sql 
b/installer/data/mysql/pl-PL/optional/sample_notices_message_transports.sql
index ae68378..60ddd52 100644
--- a/installer/data/mysql/pl-PL/optional/sample_notices_message_transports.sql
+++ b/installer/data/mysql/pl-PL/optional/sample_notices_message_transports.sql
@@ -14,4 +14,6 @@ values
 (5, 'email', 0, 'circulation', 'CHECKIN'),
 (5, 'sms',   0, 'circulation', 'CHECKIN'),
 (6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
+(6, 'sms',   0, 'circulation', 'CHECKOUT'),
+(7, 'email', 0, 'circulation', 'ITEMRENEW'),
+(7, 'sms', 0, 'circulation', 'ITEMRENEW');
diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql 
b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
index 689fa0f..4bb8d4f 100644
--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
@@ -11,6 +11,7 @@ VALUES ('circulation','ODUE','Overdue Notice','Item 
Overdue','Dear <<borrowers.f
 ('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', 'Hold 
Available for Pickup (print notice)', 
'<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nChange
 Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> 
<<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> 
<<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>>
 <<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nYou have a hold 
available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: 
<<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: 
<<items.copynumber>>\r\n'),
 ('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following 
items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
 ('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following 
items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you 
for visiting <<branches.branchname>>.'),
+('circulation','ITEMRENEW','Item_Renew','ItemRenew','The following items have 
been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting 
<<branches.branchname>>.'),
 ('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A 
hold has been placed on the following item : <<title>> (<<biblionumber>>) by 
the user <<firstname>> <<surname>> (<<cardnumber>>).'),
 ('suggestions','ACCEPTED','Suggestion accepted', 'Purchase suggestion 
accepted','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nThe library has reviewed your suggestion today. The 
item will be ordered as soon as possible. You will be notified by mail when the 
order is completed, and again when the item arrives at the library.\n\nIf you 
have any questions, please email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
 ('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase 
available','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nWe are pleased to inform you that the item you 
requested is now part of the collection.\n\nIf you have any questions, please 
email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
diff --git 
a/installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.sql 
b/installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.sql
index c9d9bd1..af73e8b 100644
--- a/installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.sql
+++ b/installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.sql
@@ -7,5 +7,6 @@ values
 (2, 'Advance_Notice',              1),
 (4, 'Hold_Filled',                 0),
 (5, 'Item_Check_in',               0),
-(6, 'Item_Checkout',               0);
+(6, 'Item_Checkout',               0),
+(7, 'Item_Renew',                 0);
 
diff --git 
a/installer/data/mysql/ru-RU/optional/sample_notices_message_transports.sql 
b/installer/data/mysql/ru-RU/optional/sample_notices_message_transports.sql
index ade4d03..6433ab5 100644
--- a/installer/data/mysql/ru-RU/optional/sample_notices_message_transports.sql
+++ b/installer/data/mysql/ru-RU/optional/sample_notices_message_transports.sql
@@ -15,4 +15,6 @@ values
 (5, 'email', 0, 'circulation', 'CHECKIN'),
 (5, 'sms',   0, 'circulation', 'CHECKIN'),
 (6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
+(6, 'sms',   0, 'circulation', 'CHECKOUT'),
+(7, 'email', 0, 'circulation', 'ITEMRENEW'),
+(7, 'sms', 0, 'circulation', 'ITEMRENEW');
diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql 
b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
index 358205b..e081454 100644
--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
@@ -10,6 +10,7 @@ VALUES ('circulation','ODUE','Overdue Notice','Item 
Overdue','Dear <<borrowers.f
 ('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for Pickup 
at <<branches.branchname>>', 'Dear <<borrowers.firstname>> 
<<borrowers.surname>>,\r\n\r\nYou have a hold available for pickup as of 
<<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: 
<<biblio.author>>\r\nCopy: <<items.copynumber>>\r\nLocation: 
<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>>
 <<branches.branchzip>>'),
 ('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following 
items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
 ('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following 
items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you 
for visiting <<branches.branchname>>.'),
+('circulation','ITEMRENEW','Item_Renew','ItemRenew','The following items have 
been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting 
<<branches.branchname>>.'),
 ('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A 
hold has been placed on the following item : <<title>> (<<biblionumber>>) by 
the user <<firstname>> <<surname>> (<<cardnumber>>).'),
 ('suggestions','ACCEPTED','Suggestion accepted', 'Purchase suggestion 
accepted','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nThe library has reviewed your suggestion today. The 
item will be ordered as soon as possible. You will be notified by mail when the 
order is completed, and again when the item arrives at the library.\n\nIf you 
have any questions, please email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
 ('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase 
available','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have 
suggested that the library acquire <<suggestions.title>> by 
<<suggestions.author>>.\n\nWe are pleased to inform you that the item you 
requested is now part of the collection.\n\nIf you have any questions, please 
email us at <<branches.branchemail>>.\n\nThank 
you,\n\n<<branches.branchname>>'),
diff --git 
a/installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.sql 
b/installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.sql
index 75e2793..9156b78 100644
--- a/installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.sql
+++ b/installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.sql
@@ -7,5 +7,6 @@ values
 (2, 'Advance_Notice'        , 1),
 (4, 'Hold_Filled'           , 0),
 (5, 'Item_Check_in'         , 0),
-(6, 'Item_Checkout'         , 0);
+(6, 'Item_Checkout'         , 0),
+(7, 'Item_Renew'           , 0);
 
diff --git 
a/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql 
b/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql
index ade4d03..6433ab5 100644
--- a/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql
+++ b/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql
@@ -15,4 +15,6 @@ values
 (5, 'email', 0, 'circulation', 'CHECKIN'),
 (5, 'sms',   0, 'circulation', 'CHECKIN'),
 (6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
+(6, 'sms',   0, 'circulation', 'CHECKOUT'),
+(7, 'email', 0, 'circulation', 'ITEMRENEW'),
+(7, 'sms', 0, 'circulation', 'ITEMRENEW');
diff --git a/installer/data/mysql/updatedatabase.pl 
b/installer/data/mysql/updatedatabase.pl
index bdfc9ac..4c0b063 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -4439,6 +4439,20 @@ if (C4::Context->preference("Version") < 
TransformToNum($DBversion)) {
     SetVersion($DBversion);
 }
 
+$DBversion = "3.05.00.XXX";
+if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
+$dbh->do(q{
+        INSERT INTO `letter` (`module`, `code`, `name`, `title`, `content`) 
VALUES
+        ('circulation','ITEMRENEW','Item_Renew','ItemRenew','The following 
items have been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for 
visiting <<branches.branchname>>.');
+    });
+    $dbh->do(q{INSERT INTO message_attributes (message_attribute_id, 
message_name, takes_days) VALUES (7, 'Item_Renew', 0);});
+    $dbh->do(q{INSERT INTO message_transports (message_attribute_id, 
message_transport_type, is_digest, letter_module, letter_code) VALUES (7, 
'email', 0, 'circulation', 'ITEMRENEW');});
+    $dbh->do(q{INSERT INTO message_transports (message_attribute_id, 
message_transport_type, is_digest, letter_module, letter_code) VALUES (7, 
'sms',   0, 'circulation', 'ITEMRENEW');});
+    print "Upgrade to $DBversion done (Add letter for Item Renew 
notifications)\n";
+    SetVersion ($DBversion);
+}
+
+
 
 =head1 FUNCTIONS
 
diff --git 
a/koha-tmpl/intranet-tmpl/prog/en/includes/messaging-preference-form.inc 
b/koha-tmpl/intranet-tmpl/prog/en/includes/messaging-preference-form.inc
index 7ece680..4f55666 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/includes/messaging-preference-form.inc
+++ b/koha-tmpl/intranet-tmpl/prog/en/includes/messaging-preference-form.inc
@@ -33,6 +33,7 @@
           [% ELSIF ( messaging_preference.Hold_Filled ) %]Hold Filled
           [% ELSIF ( messaging_preference.Item_Check_in ) %]Item Check-in
           [% ELSIF ( messaging_preference.Item_Checkout ) %]Item Checkout
+         [% ELSIF ( messaging_preference.Item_Renew ) %]Item Renew
           [% ELSE %]Unknown [% END %]</td>
       [% IF ( messaging_preference.takes_days ) %]
       <td>
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/categorie.tt 
b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/categorie.tt
index b50012f..f9a5e70 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/categorie.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/categorie.tt
@@ -349,6 +349,7 @@ Confirm Deletion of Category [% categorycode |html %][% END 
%]</legend>
                                                        [% ELSIF ( 
prefs.Hold_Filled ) %]Hold Filled
                                                        [% ELSIF ( 
prefs.Item_Check_in ) %]Item Check-in
                                                        [% ELSIF ( 
prefs.Item_Checkout ) %]Item Checkout
+                                                       [% ELSIF ( 
prefs.Item_Renew ) %]Item Renew
                                                        [% ELSE %]Unknown
                                                        [% END %]:
                                                            <strong>[% 
transport.transport %]</strong><br />
diff --git a/koha-tmpl/opac-tmpl/prog/en/modules/opac-messaging.tt 
b/koha-tmpl/opac-tmpl/prog/en/modules/opac-messaging.tt
index ebb1e26..851a9cb 100644
--- a/koha-tmpl/opac-tmpl/prog/en/modules/opac-messaging.tt
+++ b/koha-tmpl/opac-tmpl/prog/en/modules/opac-messaging.tt
@@ -45,6 +45,7 @@
           [% ELSIF ( messaging_preference.Hold_Filled ) %]Hold Filled
           [% ELSIF ( messaging_preference.Item_Check_in ) %]Item Check-in
           [% ELSIF ( messaging_preference.Item_Checkout ) %]Item Checkout
+         [% ELSIF ( messaging_preference.Item_Renew ) %]Item Renew
           [% ELSE %]Unknown [% END %]</td>
       [% IF ( messaging_preference.takes_days ) %]
       <td><select name="[% messaging_preference.message_attribute_id %]-DAYS">
-- 
1.6.4.2

_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to