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

(-)a/installer/data/mysql/atomicupdate/bug23538-add_EmailPatronRegistrations_and_EmailAddressForPatronRegistrations_sysprefs.pl (-10 / +11 lines)
Lines 11-27 return { Link Here
11
11
12
        $dbh->do(q{INSERT IGNORE INTO letter (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES ( 'members', 'OPAC_REG', '', 'New OPAC self-registration submitted', 1, 'New OPAC self-registration',
12
        $dbh->do(q{INSERT IGNORE INTO letter (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES ( 'members', 'OPAC_REG', '', 'New OPAC self-registration submitted', 1, 'New OPAC self-registration',
13
            '<h3>New OPAC self-registration</h3>
13
            '<h3>New OPAC self-registration</h3>
14
            <p><h4>Self-registration made by</h4>
14
            <p><h4>Self-registration made:</h4>
15
            <ul>
15
            <ul>
16
            <li><<borrowers.firstname>> <<borrowers.surname>></li>
16
            <li>[% borrower.firstname %] [% borrower.surname %]</li>
17
            <li>Email: <<borrowers.email>></li>
17
            [% IF borrower.cardnumber %]<li>Cardnumber: [% borrower.cardnumber %]</li>[% END %]
18
            <li>Phone: <<borrowers.phone>></li>
18
            [% IF borrower.email %]<li>Email: [% borrower.email %]</li>[% END %]
19
            <li>Mobile: <<borrowers.mobile>></li>
19
            [% IF borrower.phone %]<li>Phone: [% borrower.phone %]</li>[% END %]
20
            <li>Fax: <<borrowers.fax>></li>
20
            [% IF borrower.mobile %]<li>Mobile: [% borrower.mobile %]</li>[% END %]
21
            <li>Secondary email: <<borrowers.emailpro>></li>
21
            [% IF borrower.fax %]<li>Fax: [% borrower.fax %]</li>[% END %]
22
            <li>Secondary phone:<<borrowers.phonepro>></li>
22
            [% IF borrower.emailpro %]<li>Secondary email: [% borrower.emailpro %]</li>[% END %]
23
            <li>Home library: <<borrowers.branchcode>></li>
23
            [% IF borrower.phonepro %]<li>Secondary phone:[% borrower.phonepro %]</li>[% END %]
24
            <li>Patron category: <<borrowers.categorycode>></li>
24
            [% IF borrower.branchcode %]<li>Home library: [% borrower.branchcode %]</li>[% END %]
25
            [% IF borrower.categorycode %]<li>Patron category: [% borrower.categorycode %]</li>[% END %]
25
            </ul>
26
            </ul>
26
            </p>', 'email', 'default') });
27
            </p>', 'email', 'default') });
27
    },
28
    },
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-10 / +11 lines)
Lines 1709-1724 tables: Link Here
1709
          lang: default
1709
          lang: default
1710
          content:
1710
          content:
1711
            - "<h3>New OPAC self-registration</h3>"
1711
            - "<h3>New OPAC self-registration</h3>"
1712
            - "<p><h4>Self-registration made by</h4>"
1712
            - "<p><h4>Self-registration made:</h4>"
1713
            - "<ul>"
1713
            - "<ul>"
1714
            - "<li><<borrowers.firstname>> <<borrowers.surname>></li>"
1714
            - "<li> [% borrower.firstname %] [% borrower.surname %]</li>"
1715
            - "<li>Email: <<borrowers.email>></li>"
1715
            - "[% IF borrower.cardnumber %]<li>Cardnumber: [% borrower.cardnumber %]</li>[% END %]"
1716
            - "<li>Phone: <<borrowers.phone>></li>"
1716
            - "[% IF borrower.email %]<li>Email: [% borrower.email %]</li>[% END %]"
1717
            - "<li>Mobile: <<borrowers.mobile>></li>"
1717
            - "[% IF borrower.phone %]<li>Phone: [% borrower.phone %]</li>[% END %]"
1718
            - "<li>Fax: <<borrowers.fax>></li>"
1718
            - "[% IF borrower.mobile %]<li>Mobile: [% borrower.mobile %]</li>[% END %]"
1719
            - "<li>Secondary email: <<borrowers.emailpro>></li>"
1719
            - "[% IF borrower.fax %]<li>Fax: [% borrower.fax %]</li>[% END %]"
1720
            - "<li>Secondary phone:<<borrowers.phonepro>></li>"
1720
            - "[% IF borrower.emailpro %]<li>Secondary email: [% borrower.emailpro %]</li>[% END %]"
1721
            - "<li>Home library: <<borrowers.branchcode>></li>"
1721
            - "[% IF borrower.phonepro %]<li>Secondary phone: [% borrower.phonepro %]</li>[% END %]"
1722
            - "<li>Temporary patron category: <<borrowers.categorycode>></li>"
1722
            - "[% IF borrower.branchcode %]<li>Home library: [% borrower.branchcode %]</li>[% END %]"
1723
            - "[% IF borrower.categorycode %]<li>Temporary patron category: [% borrower.categorycode %]</li>[% END %]"
1723
            - "</ul>"
1724
            - "</ul>"
1724
            - "</p>"
1725
            - "</p>"
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (-1 / +521 lines)
Line 0 Link Here
0
- 
1
INSERT IGNORE INTO `letter`
2
(module, code, name, title, content, message_transport_type)
3
VALUES
4
('circulation','ODUE','Avis de retard','Document en retard','Cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSelon nos informations actuelles, vous avez des documents signalés en retard dans votre compte.La Bibliothèque n\'applique pas les pénalités, mais nous vous invitons à retourner ou renouveler ces documents au plus vite dans la Bibliothèque suivante.\n\n<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> <<branches.branchaddress3>>\nTéléphone: <<branches.branchphone>>\nFax: <<branches.branchfax>>\nCourriel: <<branches.branchemail>>\n\nSi vous possédez un identifiant et un mot de passe pour vous connecter à notre catalogue en ligne,vous pouvez depuis celui-ci prolonger la durée de prêt des documents. Si les documents ont plus de 3à jours de retard, vous ne pourrez plus utiliser votre carte d\'adhérent tant que les documents ne seront pas rendus.\n\nLe(s) document(s) actuellement en retard:\n\n<item>"<<biblio.title>>" de <<biblio.author>>, <<items.itemcallnumber>>, Code barres: <<items.barcode>> Pénalité: <<items.fine>></item>\n\nAvec nos remerciements.\n\n<<branches.branchname>> La banque de prêt\n', 'email'),
5
('claimacquisition','ACQCLAIM','Réclamation Acquisitions','Document non reçu','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\n<order>Commande <<aqorders.ordernumber>> (<<biblio.title>>) (<<aqorders.quantity>> ordered) ($<<aqorders.listprice>> each) pas encore reçue.</order>', 'email'),
6
('orderacquisition','ACQORDER','Acquisition order','Order','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\nPlease order for the library:\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<biblio.title>>) (quantity: <<aqorders.quantity>>) ($<<aqorders.listprice>> each).</order>\r\n\r\nThank you,\n\n<<branches.branchname>>', 'email'),
7
('serial','SERIAL_ALERT','Liste de routage','Fascicule de périodique disponible','<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nLe numéro suivant est disponible:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nVous pouvez venir le retirer quand vous voulez.', 'email'),
8
('members','ACCTDETAILS','Nouveau compte adhérent','Votre nouveau compte adhérent.','Bonjour <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>.\r\n\r\nLes informations de votre nouveau compte sont:\r\n\r\nIdentifiant:  <<borrowers.userid>>\r\nMot de passe: <<borrowers.password>>\r\n\r\nSi vous avez des questions au sujet de votre nouveau compte, merci de prendre contact à l\'acceuil de la Bibliothèque.\r\n\r\nMerci,\r\nLa Bibliothèque\r\nkohaadmin@yoursite.org', 'email'),
9
('circulation','DUE','Document à rendre ','Document à rendre','Cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nLe document suivant doit être rendu aujourd\'hui:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)', 'email'),
10
('circulation','DUEDGST','Document à rendre (résumé)','Document à rendre','Vous avez <<count>> document(s) à rendre', 'email'),
11
('circulation','PREDUE','Document à rendre bientôt','Document à rendre bientôt','Cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nLa date de retour du doucment suivant est proche:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)', 'email'),
12
('circulation','PREDUEDGST','Document à rendre bientôt (résumé)','Document à rendre bientôt','Vous avez <<count>> document(s) dont la date de retour est proche', 'email'),
13
('reserves', 'HOLD', 'Réservation disponible pour retrait', 'Réservation disponible à la banque de retrait du site <<branches.branchname>>', 'Cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous avez une réservation disponible pour retrait depuis le <<reserves.waitingdate>>:\r\n\r\nTitre: <<biblio.title>>\r\nAuteur: <<biblio.author>>\r\nNuméro de fascicule: <<items.copynumber>>\r\nSite: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>', 'email'),
14
('reserves', 'HOLD', 'Réservation disponible pour retrait', 'Réservation disponible à la banque de retrait du site <<branches.branchname>>', '<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>>\n\n\nLe service des réservations\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\nVotre réservation est disponible pour retrait depuis le <<reserves.waitingdate>>:\r\n\r\nTitre: <<biblio.title>>\r\nAuteur: <<biblio.author>>\r\nNuméro de fascicule: <<items.copynumber>>\r\n', 'print'),
15
('circulation','CHECKIN','Document rendu (résumé)','Retours','Les documents suivants ont été rendus:\r\n----\r\n[% biblio.title %]\r\n----\r\nMerci.', 'email'),
16
('circulation','CHECKOUT','Document prêté (résumé)','Prêts','Les documents suivants ont été prêtés:\r\n----\r\n[% biblio.title %]\r\n----\r\nMerci de votre visite [% branch.branchname %].', 'email'),
17
('reserves', 'HOLDPLACED', 'Demande de réservation', 'Demande de réservation','Une demande de réservation a été placée sur le document : <<biblio.title>> (<<biblio.biblionumber>>) par l\'adhérent <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
18
('reserves','HOLD_REMINDER','Waiting hold reminder','You have waiting holds.','Dear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nThe following holds are waiting at [% branch.branchname %]:\r\n\\r\n[% FOREACH hold IN holds %]\r\n    [% hold.biblio.title %] : waiting since [% hold.waitingdate | $KohaDates %]\r\n[% END %]','email'),
19
('reserves', 'CANCEL_HOLD_ON_LOST', 'Hold has been cancelled', "Hold has been cancelled", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nWe regret to inform you, that the following item can not be provided due to it being missing. Your hold was cancelled.\n\nTitle: [% biblio.title %]\nAuthor: [% biblio.author %]\nCopy: [% item.copynumber %]\nLocation: [% branch.branchname %]", 'email'),
20
('suggestions','ACCEPTED','Suggestion accceptée', 'Suggestion acceptée','Cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\n\nVous avez crée une suggestion d\'achat au sujet du document <<suggestions.title>> de <<suggestions.author>>.\n\nLa Bibliothèque a reçu votre demande ce jour. Nous donnerons suite à votre demande aussi vite que possible. Vous serez averti par courriel dès que la commande sera envoyée,et quand les documents seront arrivés à la Bibliothèque.\n\nSi vous avez des questions, merci de nous contacter à l\'adresse suivante <<branches.branchemail>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','AVAILABLE','Suggestion disponible', 'Suggestion d\'achat disponible','cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\n\nVous avez effectué une suggestion d\'achat pour le docuement  <<suggestions.title>> de <<suggestions.author>>.\n\nNous sommes heureux de vous informer que le document que vous aviez demandé est maintenant disponible dans nos collections.\n\nSi vous avez des questions, merci de nous contacter par courriel à l\'adresse <<branches.branchemail>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),
22
('suggestions','ORDERED','Suggestion commandée', 'Suggestion commandée','Cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\n\nVous avez effectué une demande de suggestion d\'achat sur le docuement <<suggestions.title>> de <<suggestions.author>>.\n\nNous sommes heureux de vous informer que le document que vous avez demandé est maintenant en commande. Le document devrait arriver rapidement dans nos collections.\n\nVous serez averti quand le docuement sera disponible.\n\nSi vous avez des questions, merci de nous contacter à l\'adresse <<branches.branchemail>>\n\nMerci,\n\n<<branches.branchname>>', 'email'),
23
('suggestions','REJECTED','Suggestion rejetée', 'Suggestion d\'achat rejeté','Cher(e) <<borrowers.firstname>> <<borrowers.surname>>,\n\nVous avez fait la demande du document <<suggestions.title>> de <<suggestions.author>>.\n\nla Bibliothèque a examiné votre demande ce jour, et a décidé de ne pas retenir la suggestion pour l\'instant.\n\nLa raison est la suivante: <<suggestions.reason>>\n\nSi vous avez des questions, merci de nous contacter à l\'adresse <<branches.branchemail>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),
24
('suggestions','TO_PROCESS','Avis au propriétaire du poste budgétaire', 'Une suggestion est prête à être traitée','<<borrowers.firstname>> <<borrowers.surname>>,\n\nUne nouvelle suggestion est prête à être traitée : <<suggestions.title>> / <<suggestions.author>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),
25
('suggestions', 'NOTIFY_MANAGER', 'Notify manager of a suggestion', "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email'),
26
('members', 'DISCHARGE', 'Quitus', 'Quitus pour <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Quitus</h1>\r\n\r\nLa librairie <<borrowers.branchcode>> certifies que lecteur suivant :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Numéro de carte : <<borrowers.cardnumber>>\r\n\r\na bien retourné tous ses documents.', 'email'),
27
('members', 'PROBLEM_REPORT','OPAC problem report','OPAC problem report','Username: <<problem_reports.username>>\n\nProblem page: <<problem_reports.problempage>>\n\nTitle: <<problem_reports.title>>\n\nMessage: <<problem_reports.content>>','email');
28
29
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
30
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
31
    <p><h4>Suggested by</h4>
32
    <ul>
33
    <li><<borrowers.firstname>> <<borrowers.surname>></li>
34
    <li><<borrowers.cardnumber>></li>
35
    <li><<borrowers.phone>></li>
36
    <li><<borrowers.email>></li>
37
    </ul>
38
    </p>
39
    <p><h4>Title suggested</h4>
40
    <ul>
41
    <li><b>Library:</b> <<branches.branchname>></li>
42
    <li><b>Title:</b> <<suggestions.title>></li>
43
    <li><b>Author:</b> <<suggestions.author>></li>
44
    <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
45
    <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
46
    <li><b>Publisher:</b> <<suggestions.publishercode>></li>
47
    <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
48
    <li><b>Publication place:</b> <<suggestions.place>></li>
49
    <li><b>Quantity:</b> <<suggestions.quantity>></li>
50
    <li><b>Item type:</b>  <<suggestions.itemtype>></li>
51
    <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
52
    <li><b>Notes:</b> <<suggestions.note>></li>
53
    </ul>
54
    </p>',1, 'email'),
55
    ('circulation','CHECKINSLIP','Checkin slip','Checkin slip',
56
"<h3>[% branch.branchname %]</h3>
57
Checked in items for [% borrower.title %] [% borrower.firstname %] [% borrower.initials %] [% borrower.surname %] <br />
58
([% borrower.cardnumber %]) <br />
59
60
[% today | $KohaDates %]<br />
61
62
<h4>Checked in today</h4>
63
[% FOREACH checkin IN old_checkouts %]
64
[% SET item = checkin.item %]
65
<p>
66
[% item.biblio.title %] <br />
67
Barcode: [% item.barcode %] <br />
68
</p>
69
[% END %]", 1, 'print');
70
71
INSERT INTO `letter` (module, code, name, title, content, is_html)
72
VALUES ('circulation','ISSUESLIP','Ticket de de prêt','Ticket de prêt', '<h3><<branches.branchname>></h3>
73
Prêts à <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
74
(<<borrowers.cardnumber>>) <br />
75
76
<<today>><br />
77
78
<h4>Emprunts</h4>
79
<checkedout>
80
<p>
81
<<biblio.title>> <br />
82
Code à barres : <<items.barcode>><br />
83
Retour le : <<issues.date_due>><br />
84
</p>
85
</checkedout>
86
87
<h4>Retards</h4>
88
<overdue>
89
<p>
90
<<biblio.title>> <br />
91
Codes à barres : <<items.barcode>><br />
92
Retour le : <<issues.date_due>><br />
93
</p>
94
</overdue>
95
96
<hr>
97
98
<h4 style="text-align: center; font-style:italic;">Nouvelles</h4>
99
<news>
100
<div class="newsitem">
101
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<additional_contents.title>></b></h5>
102
<p style="margin-bottom: 1px; margin-top: 1px"><<additional_contents.content>></p>
103
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<additional_contents.published_on>></p>
104
<hr />
105
</div>
106
</news>', 1),
107
('circulation','ISSUEQSLIP','Ticket rapide','Ticket rapide', '<h3><<branches.branchname>></h3>
108
Prêts à <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
109
(<<borrowers.cardnumber>>) <br />
110
111
<<today>><br />
112
113
<h4>Emprunts du jour</h4>
114
<checkedout>
115
<p>
116
<<biblio.title>> <br />
117
Code à barres : <<items.barcode>><br />
118
Retour le : <<issues.date_due>><br />
119
</p>
120
</checkedout>', 1),
121
('circulation','HOLD_SLIP','Ticket de réservation','Ticket de réservation', '<h5>Date : <<today>></h5>
122
123
<h3> Transfert vers/Réservé à <<branches.branchname>></h3>
124
125
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
126
127
<ul>
128
    <li><<borrowers.cardnumber>></li>
129
    <li><<borrowers.phone>></li>
130
    <li> <<borrowers.address>><br />
131
         <<borrowers.address2>><br />
132
         <<borrowers.city >>  <<borrowers.zipcode>>
133
    </li>
134
    <li><<borrowers.email>></li>
135
</ul>
136
<br />
137
<h3>RESERVATIONS</h3>
138
<h4><<biblio.title>></h4>
139
<h5><<biblio.author>></h5>
140
<ul>
141
   <li><<items.barcode>></li>
142
   <li><<items.itemcallnumber>></li>
143
   <li><<reserves.waitingdate>></li>
144
</ul>
145
<p>Notes :
146
<pre><<reserves.reservenotes>></pre>
147
</p>
148
', 1),
149
('circulation','TRANSFERSLIP','Ticket de transfer','Ticket de transfert', '<h5>Date : <<today>></h5>
150
151
<h3>Transfert à <<branches.branchname>></h3>
152
153
<h3>Titres</h3>
154
<h4><<biblio.title>></h4>
155
<h5><<biblio.author>></h5>
156
<ul>
157
   <li><<items.barcode>></li>
158
   <li><<items.itemcallnumber>></li>
159
</ul>', 1);
160
161
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
162
VALUES (
163
'members',  'OPAC_REG_VERIFY',  '',  'Vérification de l''email donné à l''auto-inscription OPAC',  '1',  'Vérification de votre compte',  'Bonjour,
164
165
Votre compte de bibliothèque a été créé. Veuillez valider votre adresse email et le processus d''inscription en cliquant sur ce lien:
166
167
<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
168
169
Si vous n''êtes pas à l''origine de cette inscription, vous pouvez ignorer ce message.'
170
);
171
172
INSERT INTO `letter` (module, code, name, title, content) VALUES ('circulation','RENEWAL','Renouvellements','Renouvellements','Les documents suivants ont été renouvelés\r\n----\r\n<<biblio.title>>\r\n----\r\nMerci, <<branches.branchname>>.');
173
174
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
175
VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <<listname>>', 'Dear patron,
176
177
One of our patrons, <<borrowers.firstname>> <<borrowers.surname>>, invites you to share a list <<listname>> in our library catalog.
178
179
To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar.
180
181
<<shareurl>>
182
183
In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks.
184
185
Thank you.
186
187
Your library.'
188
);
189
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
190
VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <<listname>> accepted', 'Dear patron,
191
192
We want to inform you that <<borrowers.firstname>> <<borrowers.surname>> accepted your invitation to share your list <<listname>> in our library catalog.
193
194
Thank you.
195
196
Your library.'
197
);
198
199
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
200
VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email'),
201
('members','MEMBERSHIP_EXPIRY','','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian\r\n\r\n<<branches.branchname>>','email');
202
203
INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type )
204
VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues slip', '0', 'Overdues slip', 'The following item(s) is/are currently overdue:
205
206
<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>
207
', 'print' );
208
209
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type)
210
VALUES ('members','PASSWORD_RESET','','Online password reset',1,'Koha password recovery','<html>\r\n<p>This email has been sent in response to your password recovery request for the account <strong><<user>></strong>.\r\n</p>\r\n<p>\r\nYou can now create your new password using the following link:\r\n<br/><a href=\"<<passwordreseturl>>\"><<passwordreseturl>></a>\r\n</p>\r\n<p>This link will be valid for 2 days from this email\'s reception, then you must reapply if you do not change your password.</p>\r\n<p>Thank you.</p>\r\n</html>\r\n','email'
211
);
212
213
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
214
('circulation', 'AR_CANCELED', '', 'Article request - canceled', 0, 'Article request canceled', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nYour request for an article from <<biblio.title>> (<<items.barcode>>) has been canceled for the following reason:\r\n\r\n<<article_requests.notes>>\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\nFormat: [% IF article_request.format == \'PHOTOCOPY\' %]Copy[% ELSIF article_request.format == \'SCAN\' %]Scan[% END %]\r\n\r\nYour library', 'email'),
215
('circulation', 'AR_COMPLETED', '', 'Article request - completed', 0, 'Article request completed', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nWe have completed your request for an article from <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\nFormat: [% IF article_request.format == \'PHOTOCOPY\' %]Copy[% ELSIF article_request.format == \'SCAN\' %]Scan[% END %]\r\n\r\n[% IF article_request.format == \'PHOTOCOPY\' %]Vous pouvez venir chercher votre article à [% branch.branchname %].[% ELSIF article_request.format == \'SCAN\' %]You can download the scanned materials via the following url(s): [% article_request.urls %].[% END %]\r\n\r\nThank you!', 'email'),
216
('circulation', 'AR_PENDING', '', 'Article request - pending', 0, 'Article request received', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>)\r\n\r\nWe have received your request for an article from <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\nFormat: [% IF article_request.format == \'PHOTOCOPY\' %]Copy[% ELSIF article_request.format == \'SCAN\' %]Scan[% END %]\r\n\r\n\r\nThank you!', 'email'),
217
('circulation', 'AR_SLIP', '', 'Article request - print slip', 0, 'Article request', 'Article request:\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nTitle: <<biblio.title>>\r\nBarcode: <<items.barcode>>\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\nFormat: [% IF article_request.format == \'PHOTOCOPY\' %]Copy[% ELSIF article_request.format == \'SCAN\' %]Scan[% END %]\r\n', 'print'),
218
('circulation', 'AR_PROCESSING', '', 'Article request - processing', 0, 'Article request processing', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nWe are now processing your request for an article from <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\nFormat: [% IF article_request.format == \'PHOTOCOPY\' %]Copy[% ELSIF article_request.format == \'SCAN\' %]Scan[% END %]\r\n\r\nThank you!', 'email'),
219
('circulation', 'AR_REQUESTED', '', 'Article request - new', 0, 'Article request received', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nWe have received your request for an article from <<biblio.title>> (<<items.barcode>>)..\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\nFormat: [% IF article_request.format == \'PHOTOCOPY\' %]Copy[% ELSIF article_request.format == \'SCAN\' %]Scan[% END %]\r\n\r\nThank you!', 'email'),
220
('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<<borrowers.firstname>> <<borrowers.surname>> has added a note to the item <<biblio.title>> - <<biblio.author>> (<<biblio.biblionumber>>).','email'),
221
('circulation','RETURN_RECALLED_ITEM','','Notification to return a recalled item','0','Notification to return a recalled item','Date: <<today>>
222
223
<<borrowers.firstname>> <<borrowers.surname>>,
224
225
A recall has been placed on the following item: <<biblio.title>> / <<biblio.author>> (<<items.barcode>>). The due date has been updated, and is now <<issues.date_due>>. Please return the item before the due date.
226
227
Thank you!','email'),
228
('circulation','PICKUP_RECALLED_ITEM','','Recalled item awaiting pickup','0','Recalled item awaiting pickup','Date: <<today>>
229
230
<<borrowers.firstname>> <<borrowers.surname>>,
231
232
A recall that you requested on the following item: <<biblio.title>> / <<biblio.author>> (<<items.barcode>>) is now ready for you to pick up at <<recalls.branchcode>>. Please pick up your item by <<recalls.expirationdate>>.
233
234
Thank you!','email'),
235
('circulation','RECALL_REQUESTER_DET','','Details of patron who recalled item',0,'Details of patron who recalled item','Date: <<today>>
236
237
Recall for pickup at <<branches.branchname>>
238
<<borrowers.surname>>, <<borrowers.firstname>> (<<borrowers.cardnumber>>)
239
<<borrowers.phone>>
240
<<borrowers.streetnumber>> <<borrowers.address>>, <<borrowers.address2>>, <<borrowers.city>> <<borrowers.zipcode>>
241
<<borrowers.email>>
242
243
ITEM RECALLED
244
<<biblio.title>> by <<biblio.author>>
245
Barcode: <<items.barcode>>
246
Callnumber: <<items.itemcallnumber>>
247
Waiting since: <<recalls.waitingdate>>
248
Notes: <<recalls.recallnotes>>', 'print');
249
250
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
251
('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'),
252
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff 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');
253
254
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
255
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
256
[% PROCESS \"accounts.inc\" %]
257
<table>
258
[% IF ( LibraryName ) %]
259
 <tr>
260
    <th colspan=\"5\" class=\"centerednames\">
261
        <h3>[% LibraryName | html %]</h3>
262
    </th>
263
 </tr>
264
[% END %]
265
 <tr>
266
    <th colspan=\"5\" class=\"centerednames\">
267
        <h2><u>Fee receipt</u></h2>
268
    </th>
269
 </tr>
270
 <tr>
271
    <th colspan=\"5\" class=\"centerednames\">
272
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
273
    </th>
274
 </tr>
275
 <tr>
276
    <th colspan=\"5\">
277
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
278
        Card number: [% credit.patron.cardnumber | html %]<br />
279
    </th>
280
 </tr>
281
  <tr>
282
    <th>Created</th>
283
    <th>Updated</th>
284
    <th>Description of charges</th>
285
    <th>Note</th>
286
    <th>Amount</th>
287
 </tr>
288
289
 <tr class=\"highlight\">
290
    <td>[% credit.date | $KohaDates %]</td>
291
    <td>[% credit.timestamp | $KohaDates with_hours = 1 %]</td>
292
    <td>
293
      [% PROCESS account_type_description account=credit %]
294
      [%- IF credit.description %], [% credit.description | html %][% END %]
295
    </td>
296
    <td>[% credit.note | html %]</td>
297
    <td class=\"credit\">[% credit.amount | $Price %]</td>
298
 </tr>
299
300
[% IF ( tendered ) %]
301
  <tr>
302
    <td colspan=\"3\">Amount tendered: </td>
303
    <td>[% tendered | $Price %]</td>
304
  </tr>
305
  <tr>
306
    <td colspan=\"3\">Change given: </td>
307
    <td>[% change | $Price %]</td>
308
  </tr>
309
[% END %]
310
311
<tfoot>
312
  <tr>
313
    <td colspan=\"4\">Total outstanding dues as on date: </td>
314
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
315
  </tr>
316
</tfoot>
317
</table>', 'print', 'default');
318
319
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
320
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
321
[% PROCESS \"accounts.inc\" %]
322
<table>
323
  [% IF ( LibraryName ) %]
324
    <tr>
325
      <th colspan=\"6\" class=\"centerednames\">
326
        <h3>[% LibraryName | html %]</h3>
327
      </th>
328
    </tr>
329
  [% END %]
330
331
  <tr>
332
    <th colspan=\"6\" class=\"centerednames\">
333
      <h2><u>INVOICE</u></h2>
334
    </th>
335
  </tr>
336
  <tr>
337
    <th colspan=\"6\" class=\"centerednames\">
338
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
339
    </th>
340
  </tr>
341
  <tr>
342
    <th colspan=\"6\" >
343
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
344
      Card number: [% debit.patron.cardnumber | html %]<br />
345
    </th>
346
  </tr>
347
  <tr>
348
    <th>Created</th>
349
    <th>Updated</th>
350
    <th>Description of charges</th>
351
    <th>Note</th>
352
    <th style=\"text-align:right;\">Amount</th>
353
    <th style=\"text-align:right;\">Amount outstanding</th>
354
  </tr>
355
356
  <tr class=\"highlight\">
357
    <td>[% debit.date | $KohaDates%]</td>
358
    <td>[% debit.timestamp | $KohaDates with_hours = 1 %]</td>
359
    <td>
360
      [% PROCESS account_type_description account=debit %]
361
      [%- IF debit.description %], [% debit.description | html %][% END %]
362
    </td>
363
    <td>[% debit.note | html %]</td>
364
    <td class=\"debit\">[% debit.amount | $Price %]</td>
365
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
366
  </tr>
367
368
  <tfoot>
369
    <tr>
370
      <td colspan=\"5\">Total outstanding dues as on date: </td>
371
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
372
    </tr>
373
  </tfoot>
374
</table>', 'print', 'default');
375
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
376
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
377
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
378
('pos', 'RECEIPT', '', 'Point of sale receipt', 0, 'Receipt', '[% PROCESS "accounts.inc" %]
379
<table>
380
[% IF ( LibraryName ) %]
381
 <tr>
382
    <th colspan="2" class="centerednames">
383
        <h3>[% LibraryName | html %]</h3>
384
    </th>
385
 </tr>
386
[% END %]
387
 <tr>
388
    <th colspan="2" class="centerednames">
389
        <h2>[% Branches.GetName( payment.branchcode ) | html %]</h2>
390
    </th>
391
 </tr>
392
<tr>
393
    <th colspan="2" class="centerednames">
394
        <h3>[% payment.date | $KohaDates %]</h3>
395
</tr>
396
<tr>
397
  <td>Transaction ID: </td>
398
  <td>[% payment.accountlines_id %]</td>
399
</tr>
400
<tr>
401
  <td>Operator ID: </td>
402
  <td>[% payment.manager_id %]</td>
403
</tr>
404
<tr>
405
  <td>Payment type: </td>
406
  <td>[% payment.payment_type %]</td>
407
</tr>
408
 <tr></tr>
409
 <tr>
410
    <th colspan="2" class="centerednames">
411
        <h2><u>Fee receipt</u></h2>
412
    </th>
413
 </tr>
414
 <tr></tr>
415
 <tr>
416
    <th>Description of charges</th>
417
    <th>Amount</th>
418
  </tr>
419
420
  [% FOREACH offset IN offsets %]
421
    <tr>
422
        <td>[% PROCESS account_type_description account=offset.debit %]</td>
423
        <td>[% offset.amount * -1 | $Price %]</td>
424
    </tr>
425
  [% END %]
426
427
<tfoot>
428
  <tr class="highlight">
429
    <td>Total: </td>
430
    <td>[% payment.amount * -1| $Price %]</td>
431
  </tr>
432
  <tr>
433
    <td>Tendered: </td>
434
    <td>[% collected | $Price %]</td>
435
  </tr>
436
  <tr>
437
    <td>Change: </td>
438
    <td>[% change | $Price %]</td>
439
    </tr>
440
</tfoot>
441
</table>', 'print', 'default');
442
443
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
444
"Dear [% borrower.firstname %] [% borrower.surname %],
445
[% IF checkout.auto_renew_error %]
446
The following item, [% biblio.title %], has not been renewed because:
447
[% IF checkout.auto_renew_error == 'too_many' %]
448
You have reached the maximum number of checkouts possible.
449
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
450
This item is on hold for another patron.
451
[% ELSIF checkout.auto_renew_error == 'restriction' %]
452
You are currently restricted.
453
[% ELSIF checkout.auto_renew_error == 'overdue' %]
454
You have overdue items.
455
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
456
It\'s too late to renew this item.
457
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
458
Your total unpaid fines are too high.
459
[% ELSIF checkout.auto_renew_error == 'too_unseen' %]
460
This item must be renewed at the library.
461
[% END %]
462
[% ELSE %]
463
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
464
[% END %]", 'email');
465
466
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PICKUP_READY', '', 'ILL request ready for pickup', 0, "Interlibrary loan request ready for pickup", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nThe Interlibrary loans request number [% illrequest.illrequest_id %] you placed for:\n\n- [% ill_bib_title %] - [% ill_bib_author %]\n\nis ready for pick up from [% branch.branchname %].\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'email', 'default');
467
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_UNAVAIL', '', 'ILL request unavailable', 0, "Interlibrary loan request unavailable", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nThe Interlibrary loans request number [% illrequest.illrequest_id %] you placed for\n\n- [% ill_bib_title %] - [% ill_bib_author %]\n\nis unfortunately unavailable.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'email', 'default');
468
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'email', 'default');
469
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'email', 'default');
470
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'email', 'default');
471
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PICKUP_READY', '', 'ILL request ready for pickup', 0, "Interlibrary loan request ready for pickup", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nThe Interlibrary loans request number [% illrequest.illrequest_id %] you placed for:\n\n- [% ill_bib_title %] - [% ill_bib_author %]\n\nis ready for pick up from [% branch.branchname %].\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');
472
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_UNAVAIL', '', 'ILL request unavailable', 0, "Interlibrary loan request unavailable", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nThe Interlibrary loans request number [% illrequest.illrequest_id %] you placed for\n\n- [% ill_bib_title %] - [% ill_bib_author %]\n\nis unfortunately unavailable.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');
473
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
474
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
475
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');
476
477
INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
478
"Dear [% borrower.firstname %] [% borrower.surname %],
479
[% IF error %]
480
    There were [% error %] items that were not renewed.
481
[% END %]
482
[% IF success %]
483
    There were [% success %] items that were renewed.
484
[% END %]
485
[% FOREACH checkout IN checkouts %]
486
    [% checkout.item.biblio.title %] : [% checkout.item.barcode %]
487
    [% IF !checkout.auto_renew_error %]
488
        was renewed until [% checkout.date_due | $KohaDates as_due_date => 1%]
489
    [% ELSIF checkout.auto_renew_error == 'too_many' %]
490
        You have reached the maximum number of checkouts possible.
491
    [% ELSIF checkout.auto_renew_error == 'on_reserve' %]
492
        This item is on hold for another patron.
493
    [% ELSIF checkout.auto_renew_error == 'restriction' %]
494
        You are currently restricted.
495
    [% ELSIF checkout.auto_renew_error == 'overdue' %]
496
        You have overdue items.
497
    [% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
498
        It's too late to renew this item.
499
    [% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
500
        Your total unpaid fines are too high.
501
    [% ELSIF checkout.auto_renew_error == 'too_unseen' %]
502
        This item must be renewed at the library.
503
    [% END %]
504
[% END %]
505
", 'email');
506
507
INSERT IGNORE INTO letter (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES ( 'members', 'OPAC_REG', '', 'New OPAC self-registration submitted', 1, 'New OPAC self-registration','<h3>New OPAC self-registration</h3>
508
    <p><h4>Self-registration made:</h4>
509
    <ul>
510
    <li>[% borrower.firstname %] [% borrower.surname %]</li>
511
    [% IF borrower.cardnumber %]<li>Cardnumber: [% borrower.cardnumber %]</li>[% END %]
512
    [% IF borrower.email %]<li>Email: [% borrower.email %]</li>[% END %]
513
    [% IF borrower.phone %]<li>Phone: [% borrower.phone %]</li>[% END %]
514
    [% IF borrower.mobile %]<li>Mobile: [% borrower.mobile %]</li>[% END %]
515
    [% IF borrower.fax %]<li>Fax: [% borrower.fax %]</li>[% END %]
516
    [% IF borrower.emailpro %]<li>Secondary email: [% borrower.emailpro %]</li>[% END %]
517
    [% IF borrower.phonepro %]<li>Secondary phone:[% borrower.phonepro %]</li>[% END %]
518
    [% IF borrower.branchcode %]<li>Home library: [% borrower.branchcode %]</li>[% END %]
519
    [% IF borrower.categorycode %]<li>Patron category: [% borrower.categorycode %]</li>[% END %]
520
    </ul>
521
   </p>', 'email', 'default')

Return to bug 23538