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/en/mandatory/sample_notices.sql | 1 +
.../optional/sample_notices_message_attributes.sql | 3 ++-
.../optional/sample_notices_message_transports.sql | 4 +++-
.../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 | 4 ++--
.../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 | 4 +++-
.../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 +
kohaversion.pl | 2 +-
30 files changed, 84 insertions(+), 20 deletions(-)
diff --git a/C4/Circulation.pm b/C4/Circulation.pm
index 47068f9..400c857 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/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..459b913 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,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/en/optional/sample_notices_message_transports.sql
b/installer/data/mysql/en/optional/sample_notices_message_transports.sql
index ae68378..60ddd52 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,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/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..367bf24 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,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/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..a8738a0 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,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/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..9725285 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.011";
+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">
diff --git a/kohaversion.pl b/kohaversion.pl
index 5b72642..f864378 100644
--- a/kohaversion.pl
+++ b/kohaversion.pl
@@ -16,7 +16,7 @@ the kohaversion is divided in 4 parts :
use strict;
sub kohaversion {
- our $VERSION = '3.05.00.010';
+ our $VERSION = '3.05.00.011';
# version needs to be set this way
# so that it can be picked up by Makefile.PL
# during install
--
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/
