@@ -, +, @@
- recalls table
- circulation rules: recalls allowed (total), recalls per record
- sysprefs: useRecalls, RecallsMaxPickUpDelay, RecallsLog
- email notices: RETURN_RECALLED_ITEM, PICKUP_RECALLED_ITEM, RECALL_REQUESTER_DET
- user permission: recalls, manage_recalls
- Recall and CancelRecall reasons for branch transfers
---
Koha/CirculationRules.pm | 18 +++++++
admin/smart-rules.pl | 18 +++++++
...bug_19532-add_recalls_enum_branchtransfers.perl | 6 +++
.../atomicupdate/bug_19532-add_recalls_flags.perl | 7 +++
.../bug_19532-add_recalls_notices.perl | 23 ++++++++
.../bug_19532-add_recalls_sysprefs.perl | 11 ++++
.../atomicupdate/bug_19532-add_recalls_table.perl | 34 ++++++++++++
.../data/mysql/de-DE/mandatory/sample_notices.sql | 17 +++++-
.../data/mysql/en/mandatory/sample_notices.yml | 63 ++++++++++++++++++++++
.../mysql/fr-CA/obligatoire/sample_notices.sql | 17 +++++-
.../mysql/fr-FR/1-Obligatoire/sample_notices.sql | 17 +++++-
installer/data/mysql/it-IT/necessari/notices.sql | 17 +++++-
installer/data/mysql/kohastructure.sql | 34 +++++++++++-
.../mysql/nb-NO/1-Obligatorisk/sample_notices.sql | 17 +++++-
.../data/mysql/pl-PL/mandatory/sample_notices.sql | 17 +++++-
.../data/mysql/ru-RU/mandatory/sample_notices.sql | 17 +++++-
installer/data/mysql/sysprefs.sql | 3 ++
.../data/mysql/uk-UA/mandatory/sample_notices.sql | 21 +++++++-
installer/data/mysql/userflags.sql | 3 +-
installer/data/mysql/userpermissions.sql | 3 +-
installer/onboarding.pl | 6 +++
.../intranet-tmpl/prog/en/includes/permissions.inc | 9 ++++
.../en/modules/admin/preferences/circulation.pref | 12 +++++
.../prog/en/modules/admin/preferences/logs.pref | 6 +++
.../prog/en/modules/admin/smart-rules.tt | 54 ++++++++++++++++++-
25 files changed, 438 insertions(+), 12 deletions(-)
create mode 100644 installer/data/mysql/atomicupdate/bug_19532-add_recalls_enum_branchtransfers.perl
create mode 100644 installer/data/mysql/atomicupdate/bug_19532-add_recalls_flags.perl
create mode 100644 installer/data/mysql/atomicupdate/bug_19532-add_recalls_notices.perl
create mode 100644 installer/data/mysql/atomicupdate/bug_19532-add_recalls_sysprefs.perl
create mode 100644 installer/data/mysql/atomicupdate/bug_19532-add_recalls_table.perl
--- a/Koha/CirculationRules.pm
+++ a/Koha/CirculationRules.pm
@@ -157,6 +157,24 @@ our $RULE_KINDS = {
note => { # This is not really a rule. Maybe we will want to separate this later.
scope => [ 'branchcode', 'categorycode', 'itemtype' ],
},
+ recalls_allowed => {
+ scope => [ 'branchcode', 'categorycode', 'itemtype' ],
+ },
+ recalls_per_record => {
+ scope => [ 'branchcode', 'categorycode', 'itemtype' ],
+ },
+ on_shelf_recalls => {
+ scope => [ 'branchcode', 'categorycode', 'itemtype' ],
+ },
+ recall_due_date_interval => {
+ scope => [ 'branchcode', 'categorycode', 'itemtype' ],
+ },
+ recall_overdue_fine => {
+ scope => [ 'branchcode', 'categorycode', 'itemtype' ],
+ },
+ recall_shelf_time => {
+ scope => [ 'branchcode', 'categorycode', 'itemtype' ],
+ },
# Not included (deprecated?):
# * accountsent
# * reservecharge
--- a/admin/smart-rules.pl
+++ a/admin/smart-rules.pl
@@ -112,6 +112,12 @@ if ($op eq 'delete') {
cap_fine_to_replacement_price => undef,
article_requests => undef,
note => undef,
+ recalls_allowed => undef,
+ recalls_per_record => undef,
+ on_shelf_recalls => undef,
+ recall_due_date_interval => undef,
+ recall_overdue_fine => undef,
+ recall_shelf_time => undef,
}
}
);
@@ -288,6 +294,12 @@ elsif ($op eq 'add') {
my $overduefinescap = $input->param('overduefinescap') || '';
my $cap_fine_to_replacement_price = $input->param('cap_fine_to_replacement_price') eq 'on';
my $note = $input->param('note');
+ my $recalls_allowed = $input->param('recalls_allowed');
+ my $recalls_per_record = $input->param('recalls_per_record');
+ my $on_shelf_recalls = $input->param('on_shelf_recalls');
+ my $recall_due_date_interval = $input->param('recall_due_date_interval');
+ my $recall_overdue_fine = $input->param('recall_overdue_fine');
+ my $recall_shelf_time = $input->param('recall_shelf_time');
$debug and warn "Adding $br, $bor, $itemtype, $fine, $maxissueqty, $maxonsiteissueqty, $cap_fine_to_replacement_price";
my $rules = {
@@ -320,6 +332,12 @@ elsif ($op eq 'add') {
cap_fine_to_replacement_price => $cap_fine_to_replacement_price,
article_requests => $article_requests,
note => $note,
+ recalls_allowed => $recalls_allowed,
+ recalls_per_record => $recalls_per_record,
+ on_shelf_recalls => $on_shelf_recalls,
+ recall_due_date_interval => $recall_due_date_interval,
+ recall_overdue_fine => $recall_overdue_fine,
+ recall_shelf_time => $recall_shelf_time,
};
Koha::CirculationRules->set_rules(
--- a/installer/data/mysql/atomicupdate/bug_19532-add_recalls_enum_branchtransfers.perl
+++ a/installer/data/mysql/atomicupdate/bug_19532-add_recalls_enum_branchtransfers.perl
@@ -0,0 +1,6 @@
+$DBversion = 'XXX';
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{ ALTER TABLE branchtransfers MODIFY COLUMN reason ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve', 'Recall', 'CancelRecall') });
+
+ NewVersion( $DBversion, 19532, "Add Recall and CancelReserve ENUM options to branchtransfers.reason" );
+}
--- a/installer/data/mysql/atomicupdate/bug_19532-add_recalls_flags.perl
+++ a/installer/data/mysql/atomicupdate/bug_19532-add_recalls_flags.perl
@@ -0,0 +1,7 @@
+$DBversion = 'XXX';
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{ INSERT IGNORE INTO userflags (bit, flag, flagdesc, defaulton) VALUES (27, 'recalls', 'Recalls', 0) });
+ $dbh->do(q{ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (27, 'manage_recalls', 'Manage recalls for patrons') });
+
+ NewVersion( $DBversion, 19532, "Add recalls user flag and manage_recalls user permission" );
+}
--- a/installer/data/mysql/atomicupdate/bug_19532-add_recalls_notices.perl
+++ a/installer/data/mysql/atomicupdate/bug_19532-add_recalls_notices.perl
@@ -0,0 +1,23 @@
+$DBversion = 'XXX';
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{
+ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
+ ('circulation','RETURN_RECALLED_ITEM','','Notification to return a recalled item','0','Notification to return a recalled item','Date: <>
+
+<> <>,
+
+A recall has been placed on the following item: <> / <> (<>). The due date has been updated, and is now <>. Please return the item before the due date.
+
+Thank you!','email'),
+ ('circulation','PICKUP_RECALLED_ITEM','','Recalled item awaiting pickup','0','Recalled item awaiting pickup','Date: <>
+
+<> <>,
+
+A recall that you requested on the following item: <> / <> (<>) is now ready for you to pick up at <>. Please pick up your item by <>.
+
+Thank you!','email'),
+ ('circulation','RECALL_REQUESTER_DET','','Details of patron who recalled item',1,'Details of patron who recalled item','Date: <>
Recall for pickup at <>
<>, <>
ITEM RECALLED
<>
<>
Notes:
<>
', 'print')
+ });
+
+ NewVersion( $DBversion, 19532, "Add recalls notices: RETURN_RECALLED_ITEM, PICKUP_RECALLED_ITEM, RECALL_REQUESTER_DET" );
+}
--- a/installer/data/mysql/atomicupdate/bug_19532-add_recalls_sysprefs.perl
+++ a/installer/data/mysql/atomicupdate/bug_19532-add_recalls_sysprefs.perl
@@ -0,0 +1,11 @@
+$DBversion = 'XXX';
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{
+ INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES
+ ('RecallsLog','1',NULL,'If ON, log create/cancel/expire/fulfill actions on recalls','YesNo'),
+ ('RecallsMaxPickUpDelay','7',NULL,'Define the maximum time a recall can be awaiting pickup','Integer'),
+ ('UseRecalls','0',NULL,'Enable or disable recalls','YesNo')
+ });
+
+ NewVersion( $DBversion, 19532, "Add RecallsLog, RecallsMaxPickUpDelay and UseRecalls system preferences");
+}
--- a/installer/data/mysql/atomicupdate/bug_19532-add_recalls_table.perl
+++ a/installer/data/mysql/atomicupdate/bug_19532-add_recalls_table.perl
@@ -0,0 +1,34 @@
+$DBversion = 'XXX';
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{ DROP TABLE IF EXISTS recalls });
+ $dbh->do(q{
+ CREATE TABLE recalls (
+ recall_id int(11) NOT NULL auto_increment,
+ borrowernumber int(11) NOT NULL DEFAULT 0,
+ recalldate datetime DEFAULT NULL,
+ biblionumber int(11) NOT NULL DEFAULT 0,
+ branchcode varchar(10) DEFAULT NULL,
+ cancellationdate datetime DEFAULT NULL,
+ recallnotes mediumtext,
+ priority smallint(6) DEFAULT NULL,
+ status varchar(1) DEFAULT NULL,
+ timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ itemnumber int(11) DEFAULT NULL,
+ waitingdate datetime DEFAULT NULL,
+ expirationdate datetime DEFAULT NULL,
+ old TINYINT(1) DEFAULT NULL,
+ item_level_recall TINYINT(1) NOT NULL DEFAULT 0,
+ PRIMARY KEY (recall_id),
+ KEY borrowernumber (borrowernumber),
+ KEY biblionumber (biblionumber),
+ KEY itemnumber (itemnumber),
+ KEY branchcode (branchcode),
+ CONSTRAINT recalls_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT recalls_ibfk_2 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT recalls_ibfk_3 FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT recalls_ibfk_4 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+ });
+
+ NewVersion( $DBversion, 19532, "Add recalls table" );
+}
--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
+++ a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
@@ -205,7 +205,22 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
('circulation', 'AR_PENDING', '', 'Artikelbestellung - Offen', 0, 'Artikelbestellung ist eingegangen', 'Liebe/r <> <> (<>)\r\n\r\nIhre Artikelbestellung aus <> (<>) ist bei uns eingegangen.\r\n\r\nBestellter Artikel:\r\nTitel: <>\r\nVerfasser: <>\r\nJahrgang/Band: <>\r\nHeft: <>\r\nJahr/Datum: <>\r\nSeiten: <>\r\nKapitel: <>\r\nHinweise: <>\r\n\r\n\r\nVielen Dank!', 'email'),
('circulation', 'AR_SLIP', '', 'Artikelbestellung - Quittung', 0, 'Artikelbestellung', 'Artikelbestellung:\r\n\r\n<> <> (<>)\r\n\r\nTitel: <>\r\nBarcode: <>\r\n\r\nBestellter Artikel:\r\nTitle: <>\r\nVerfasser: <>\r\nJahrgang/Band: <>\r\nHeft: <>\r\nJahr/Datum: <>\r\nSeiten: <>\r\nKapitel: <>\r\nHinweise: <>\r\n', 'print'),
('circulation', 'AR_PROCESSING', '', 'Artikelbestellung - In Bearbeitung', 0, 'Artikelbestellung in Bearbeitung', 'Liebe/r <> <> (<>)\r\n\r\nIhre Artikelbestellung aus <> (<>) wird zur Zeit bearbeitet.\r\n\r\nBestellter Artikel:\r\nTitel: <>\r\nVerfasser: <>\r\nBand/Jahrgang: <>\r\nHeft: <>\r\nJahr/Datum: <>\r\nSeiten: <>\r\nKapitel: <>\r\nHinweise: <>\r\n\r\nVielen Dank!', 'email'),
-('circulation', 'CHECKOUT_NOTE', '', 'Ausleihnotiz zu einem Exemplar', '0', 'Ausleihnotiz', '<> <> hat eine Notiz zu folgendem Exemplar angegeben: <> - <> (<>).','email');
+('circulation', 'CHECKOUT_NOTE', '', 'Ausleihnotiz zu einem Exemplar', '0', 'Ausleihnotiz', '<> <> hat eine Notiz zu folgendem Exemplar angegeben: <> - <> (<>).','email'),
+('circulation','RETURN_RECALLED_ITEM','','Notification to return a recalled item','0','Notification to return a recalled item','Date: <>
+
+<> <>,
+
+A recall has been placed on the following item: <> / <> (<>). The due date has been updated, and is now <>. Please return the item before the due date.
+
+Thank you!','email'),
+('circulation','PICKUP_RECALLED_ITEM','','Recalled item awaiting pickup','0','Recalled item awaiting pickup','Date: <>
+
+<> <>,
+
+A recall that you requested on the following item: <> / <> (<>) is now ready for you to pick up at <>. Please pick up your item by <>.
+
+Thank you!','email'),
+('circulation','RECALL_REQUESTER_DET','','Details of patron who recalled item',1,'Details of patron who recalled item','Date: <>
Recall for pickup at <>
<>, <>
ITEM RECALLED
<>
<>
Notes:
<>
', 'print');
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_PAYMENT', '', 'Zahlung', 0, 'Zahlungsquittung für Bibliothekskonto', '[%- USE Price -%]\r\nEine Zahlung in Höhe von [% credit.amount * -1 | $Price %] wurde auf Ihr Konto verbucht.\r\n\r\nDiese Zahlung wurde mit den folgenden Gebührenposten verrechnet:\r\n[%- FOREACH o IN offsets %]\r\nBeschreibung: [% o.debit.description %]\r\nGezahlter Betrag: [% o.amount * -1 | $Price %]\r\nOffener Betrag: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default'),
--- a/installer/data/mysql/en/mandatory/sample_notices.yml
+++ a/installer/data/mysql/en/mandatory/sample_notices.yml
@@ -1179,3 +1179,66 @@ tables:
- "Title: <>"
- ""
- "Message: <>"
+
+ - module: circulation
+ code: RETURN_RECALLED_ITEM
+ branchcode: ""
+ name: "Notification to return a recalled item"
+ is_html: 0
+ title: "Notification to return a recalled item"
+ message_transport_type: email
+ lang: default
+ content:
+ - "Date: <>"
+ - ""
+ - "<> <>,"
+ - ""
+ - "A recall has been placed on the following item: <> / <> (<>). The due date has been updated, and is now <>. Please return the item before the due date."
+ - ""
+ - "Thank you!"
+
+ - module: circulation
+ code: PICKUP_RECALLED_ITEM
+ branchcode: ""
+ name: "Recalled item awaiting pickup"
+ is_html: 0
+ title: "Recalled item awaiting pickup"
+ message_transport_type: email
+ lang: default
+ content:
+ - "Date: <>"
+ - ""
+ - "<> <>,"
+ - ""
+ - "A recall that you requested on the following item: <> / <> (<>) is now ready for you to pick up at <>. Please pick up your item by <>."
+ - ""
+ - "Thank you!"
+
+ - module: circulation
+ code: RECALL_REQUESTER_DET
+ branchcode: ""
+ name: "Details of patron who recalled item"
+ is_html: 1
+ title: "Details of patron who recalled item"
+ message_transport_type: print
+ lang: default
+ content:
+ - "Date: <>
"
+ - " Recall for pickup at <>
<>, <>
"
+ - ""
+ - "- <>
"
+ - "- <>
"
+ - "- <>
<>
<><> "
+ - "- <>
"
+ - "
"
+ - "
"
+ - "ITEM RECALLED
"
+ - "<>
"
+ - "<>
"
+ - ""
+ - "- <>
"
+ - "- <>
"
+ - "- <>
"
+ - "
"
+ - "Notes:
<>
"
+
--- a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
+++ a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
@@ -84,7 +84,22 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
('circulation', 'AR_PENDING', '', 'Demande d\'article - en attente', 0, 'Demande d\'article reçue', 'Bonjour <> <> (<>)\r\n\r\nNous avons bien reçu votre demande d\'article de <> (<>).\r\n\r\nArticle demandé :\r\nTitre : <>\r\nAuteur : <>\r\nVolume : <>\r\nNuméro : <>\r\nDate : <>\r\nPages : <>\r\nChapitres : <>\r\nNotes : <>\r\n\r\n\r\nMerci.', 'email'),
('circulation', 'AR_SLIP', '', 'Demande d\'article - ticket', 0, 'Demande d\'article', 'Demande d\'article :\r\n\r\n<> <> (<>),\r\n\r\nTitre : <>\r\nCode-barres : <>\r\n\r\nArticle demandé :\r\nTitre : <>\r\nAuteur : <>\r\nVolume : <>\r\nNuméro : <>\r\nDate : <>\r\nPages : <>\r\nChapitres : <>\r\nNotes : <>\r\n', 'print'),
('circulation', 'AR_PROCESSING', '', 'Demande d\'article - en traitement', 0, 'Demande d\'article en traitement', 'Bonjour <> <> (<>),\r\n\r\nNous traitons votre demande d\'article de <> (<>).\r\n\r\nArticle demandé :\r\nTitre : <>\r\nAuteur : <>\r\nVolume : <>\r\nNuméro : <>\r\nDate : <>\r\nPages : <>\r\nChapitres : <>\r\nNotes : <>\r\n\r\nMerci.', 'email'),
-('circulation', 'CHECKOUT_NOTE', '', 'Notes d\'un utilisateur sur les documents en prêt', '0', 'Notes sur les documents en prêts', '<> <> a ajouté une note sur un exemplaire de <> - <> (<>).','email');
+('circulation', 'CHECKOUT_NOTE', '', 'Notes d\'un utilisateur sur les documents en prêt', '0', 'Notes sur les documents en prêts', '<> <> a ajouté une note sur un exemplaire de <> - <> (<>).','email'),
+('circulation','RETURN_RECALLED_ITEM','','Notification to return a recalled item','0','Notification to return a recalled item','Date: <>
+
+<> <>,
+
+A recall has been placed on the following item: <> / <> (<>). The due date has been updated, and is now <>. Please return the item before the due date.
+
+Thank you!','email'),
+('circulation','PICKUP_RECALLED_ITEM','','Recalled item awaiting pickup','0','Recalled item awaiting pickup','Date: <>
+
+<> <>,
+
+A recall that you requested on the following item: <> / <> (<>) is now ready for you to pick up at <>. Please pick up your item by <>.
+
+Thank you!','email'),
+('circulation','RECALL_REQUESTER_DET','','Details of patron who recalled item',1,'Details of patron who recalled item','Date: <>
Recall for pickup at <>
<>, <>
ITEM RECALLED
<>
<>
Notes:
<>
', 'print');
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type)
VALUES ('members','PASSWORD_RESET','','Récupération de mot de passe en ligne',1,'Récupération de mot de passe','\r\nCe courriel vous a été envoyé suite à une demande de récupération de mot de passe pour le compte de <>.\r\n
\r\n\r\nVous pouvez créer un nouveau mot de passe en cliquant le lien suivant :\r\n
>\"><>\r\n
\r\nCe lien sera valide pour 2 jours après la réception de ce courriel. Si vous ne changez pas votre mot de passe d\'ici deux jours, vous devrez faire une nouvelle demande de récuération de mot de passe..
\r\nMerci.
\r\n\r\n','email'),
--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
+++ a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
@@ -199,7 +199,22 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
('circulation', 'AR_PENDING', '', 'Article request - pending', 0, 'Article request received', 'Dear <> <> (<>)\r\n\r\nWe have received your request for an article from <> (<>).\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n\r\n\r\nThank you!', 'email'),
('circulation', 'AR_SLIP', '', 'Article request - print slip', 0, 'Article request', 'Article request:\r\n\r\n<> <> (<>),\r\n\r\nTitle: <>\r\nBarcode: <>\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n', 'print'),
('circulation', 'AR_PROCESSING', '', 'Article request - processing', 0, 'Article request processing', 'Dear <> <> (<>),\r\n\r\nWe are now processing your request for an article from <> (<>).\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n\r\nThank you!', 'email'),
-('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<> <> has added a note to the item <> - <> (<>).','email');
+('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<> <> has added a note to the item <> - <> (<>).','email'),
+('circulation','RETURN_RECALLED_ITEM','','Notification to return a recalled item','0','Notification to return a recalled item','Date: <>
+
+<> <>,
+
+A recall has been placed on the following item: <> / <> (<>). The due date has been updated, and is now <>. Please return the item before the due date.
+
+Thank you!','email'),
+('circulation','PICKUP_RECALLED_ITEM','','Recalled item awaiting pickup','0','Recalled item awaiting pickup','Date: <>
+
+<> <>,
+
+A recall that you requested on the following item: <> / <> (<>) is now ready for you to pick up at <>. Please pick up your item by <>.
+
+Thank you!','email'),
+('circulation','RECALL_REQUESTER_DET','','Details of patron who recalled item',1,'Details of patron who recalled item','Date: <>
Recall for pickup at <>
<>, <>
ITEM RECALLED
<>
<>
Notes:
<>
', 'print');
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_PAYMENT', '', 'Account payment', 0, 'Account payment', '[%- USE Price -%]\r\nA payment of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis payment affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default'),
--- a/installer/data/mysql/it-IT/necessari/notices.sql
+++ a/installer/data/mysql/it-IT/necessari/notices.sql
@@ -201,7 +201,22 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
('circulation', 'AR_PENDING', '', 'Richiesta articolo - ricevuta', 0, 'Ricevuto la richiesta di un articolo', 'Salve <> <> (<>)\r\n\r\nAbbiamo ricevuto la tua richiesta di un articolo di <> (<>).\r\n\r\nL\'articolo richiesto:\r\nTitolo: <>\r\nAutore: <>\r\nVolume: <>\r\nFascicolo: <>\r\nData: <>\r\nPagine: <>\r\nChapitoli: <>\r\nNote: <>\r\n\r\nGrazie!', 'email'),
('circulation', 'AR_SLIP', '', 'Richiesta articolo - ricevuta a stampa', 0, 'Richiesta articolo', 'Richiesta articolo\r\n\r\n<> <> (<>),\r\n\r\nTitolo: <>\r\nBarcode: <>\r\n\r\nArticolo rechiesto:\r\nTitle: <>\r\nAutore: <>\r\nVolume: <>\r\nFascicolo: <>\r\nData: <>\r\nPagine: <>\r\nChapitoli: <>\r\nNote: <>\r\n', 'print'),
('circulation', 'AR_PROCESSING', '', 'Richiesta articolo - in lavorazione', 0, 'La richiesta di un articolo è in lavorazione', 'Salve <> <> (<>),\r\n\r\nStiamo ora lavorando la tua richiesta di un articolo da <> (<>).\r\n\r\nL\'articolo richiesto:\r\nTitolo: <>\r\nAutore: <>\r\nVolume: <>\r\nFascicolo: <>\r\nData: <>\r\nPagine: <>\r\nChapitoli: <>\r\nNote: <>\r\n\r\nGrazie!', 'email'),
-('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<> <> has added a note to the item <> - <> (<>).','email');
+('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<