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

(-)a/installer/data/mysql/atomicupdate/bug_5770.sql (-14 / +14 lines)
Lines 3-9 INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) V Link Here
3
('EmailAddressForSuggestions','','','If you choose EmailAddressForSuggestions you should enter a valid email address','free');
3
('EmailAddressForSuggestions','','','If you choose EmailAddressForSuggestions you should enter a valid email address','free');
4
4
5
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
5
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
6
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
6
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
7
<p><h4>Suggested by</h4>
7
<p><h4>Suggested by</h4>
8
 <ul>
8
 <ul>
9
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
9
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
Lines 12-30 VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> S Link Here
12
   <li><<borrowers.email>></li>
12
   <li><<borrowers.email>></li>
13
 </ul>
13
 </ul>
14
</p>
14
</p>
15
<p><h4>Item on suggestion</h4>
15
<p><h4>Title suggested</h4>
16
 <ul>
16
 <ul>
17
   <li><b>Library : </b> <<branches.branchname>></li>
17
   <li><b>Library:</b> <<branches.branchname>></li>
18
   <li><b>Title : </b> <<suggestions.title>></li>
18
   <li><b>Title:</b> <<suggestions.title>></li>
19
   <li><b>Author : </b> <<suggestions.author>></li>
19
   <li><b>Author:</b> <<suggestions.author>></li>
20
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
20
   <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
21
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
21
   <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
22
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
22
   <li><b>Publisher:</b> <<suggestions.publishercode>></li>
23
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
23
   <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
24
   <li><b>Publication place : </b> <<suggestions.place>></li>
24
   <li><b>Publication place:</b> <<suggestions.place>></li>
25
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
25
   <li><b>Quantity:</b> <<suggestions.quantity>></li>
26
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
26
   <li><b>Item type:</b> <<suggestions.itemtype>></li>
27
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
27
   <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
28
   <li><b>Notes : </b> <<suggestions.note>></li>
28
   <li><b>Notes:</b> <<suggestions.note>></li>
29
 </ul>
29
 </ul>
30
</p>',1, 'email');
30
</p>',1, 'email');
(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (-14 / +14 lines)
Lines 22-28 VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r <<borrowers.firstname> Link Here
22
('suggestions','TO_PROCESS','Benachrichtigung an Besitzer des Kontos', 'Anschaffungsvorschlag wartet auf Bearbeitung','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nEin neuer Anschaffungsvorschlag wartet auf Bearbeitung: <<suggestions.title>> von <<suggestions.author>>.\n\nVielen Dank,\n\n<<branches.branchname>>', 'email');
22
('suggestions','TO_PROCESS','Benachrichtigung an Besitzer des Kontos', 'Anschaffungsvorschlag wartet auf Bearbeitung','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nEin neuer Anschaffungsvorschlag wartet auf Bearbeitung: <<suggestions.title>> von <<suggestions.author>>.\n\nVielen Dank,\n\n<<branches.branchname>>', 'email');
23
23
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
26
<p><h4>Suggested by</h4>
26
<p><h4>Suggested by</h4>
27
 <ul>
27
 <ul>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
Lines 31-50 VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> S Link Here
31
   <li><<borrowers.email>></li>
31
   <li><<borrowers.email>></li>
32
 </ul>
32
 </ul>
33
</p>
33
</p>
34
<p><h4>Item on suggestion</h4>
34
<p><h4>Title suggested</h4>
35
 <ul>
35
 <ul>
36
   <li><b>Library : </b> <<branches.branchname>></li>
36
   <li><b>Library:</b> <<branches.branchname>></li>
37
   <li><b>Title : </b> <<suggestions.title>></li>
37
   <li><b>Title:</b> <<suggestions.title>></li>
38
   <li><b>Author : </b> <<suggestions.author>></li>
38
   <li><b>Author:</b> <<suggestions.author>></li>
39
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
39
   <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
40
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
40
   <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
41
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
41
   <li><b>Publisher:</b> <<suggestions.publishercode>></li>
42
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
42
   <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
43
   <li><b>Publication place : </b> <<suggestions.place>></li>
43
   <li><b>Publication place:</b> <<suggestions.place>></li>
44
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
44
   <li><b>Quantity:</b> <<suggestions.quantity>></li>
45
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
45
   <li><b>Item type:</b>  <<suggestions.itemtype>></li>
46
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
46
   <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
47
   <li><b>Notes : </b> <<suggestions.note>></li>
47
   <li><b>Notes:</b> <<suggestions.note>></li>
48
 </ul>
48
 </ul>
49
</p>',1, 'email');
49
</p>',1, 'email');
50
50
(-)a/installer/data/mysql/en/mandatory/sample_notices.sql (-16 / +16 lines)
Lines 13-28 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
13
('reserves', 'HOLD', 'Hold Available for Pickup', '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', 'print'),
13
('reserves', 'HOLD', 'Hold Available for Pickup', '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', 'print'),
14
('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.', 'email'),
14
('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.', 'email'),
15
('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 [% branch.branchname %].', 'email'),
15
('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 [% branch.branchname %].', 'email'),
16
('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A hold has been placed on the following item : <<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
16
('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A hold has been placed on the following item:<<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
17
('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'),
17
('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'),
18
('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>>', 'email'),
18
('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>>', 'email'),
19
('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>>', 'email'),
19
('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>>', 'email'),
20
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','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 has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>', 'email'),
20
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','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 has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
22
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email');
22
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA New suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email');
23
23
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
26
<p><h4>Suggested by</h4>
26
<p><h4>Suggested by</h4>
27
 <ul>
27
 <ul>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
Lines 31-50 VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> S Link Here
31
   <li><<borrowers.email>></li>
31
   <li><<borrowers.email>></li>
32
 </ul>
32
 </ul>
33
</p>
33
</p>
34
<p><h4>Item on suggestion</h4>
34
<p><h4>Title suggested</h4>
35
 <ul>
35
 <ul>
36
   <li><b>Library : </b> <<branches.branchname>></li>
36
   <li><b>Library:</b> <<branches.branchname>></li>
37
   <li><b>Title : </b> <<suggestions.title>></li>
37
   <li><b>Title:</b> <<suggestions.title>></li>
38
   <li><b>Author : </b> <<suggestions.author>></li>
38
   <li><b>Author:</b> <<suggestions.author>></li>
39
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
39
   <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
40
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
40
   <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
41
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
41
   <li><b>Publisher:</b> <<suggestions.publishercode>></li>
42
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
42
   <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
43
   <li><b>Publication place : </b> <<suggestions.place>></li>
43
   <li><b>Publication place:</b> <<suggestions.place>></li>
44
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
44
   <li><b>Quantity:</b> <<suggestions.quantity>></li>
45
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
45
   <li><b>Item type:</b>  <<suggestions.itemtype>></li>
46
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
46
   <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
47
   <li><b>Notes : </b> <<suggestions.note>></li>
47
   <li><b>Notes:</b> <<suggestions.note>></li>
48
 </ul>
48
 </ul>
49
</p>',1, 'email');
49
</p>',1, 'email');
50
50
(-)a/installer/data/mysql/es-ES/mandatory/sample_notices.sql (-17 / +17 lines)
Lines 12-28 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
12
('reserves', 'HOLD', 'Hold Available for Pickup', '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', 'print'),
12
('reserves', 'HOLD', 'Hold Available for Pickup', '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', 'print'),
13
('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.', 'email'),
13
('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.', 'email'),
14
('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 [% branch.branchname %].', 'email'),
14
('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 [% branch.branchname %].', 'email'),
15
('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A hold has been placed on the following item : <<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
15
('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A hold has been placed on the following item:<<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
16
('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'),
16
('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'),
17
('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>>', 'email'),
17
('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>>', 'email'),
18
('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>>', 'email'),
18
('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>>', 'email'),
19
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','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 has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>', 'email'),
19
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','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 has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>', 'email'),
20
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
20
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA New suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
22
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
22
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber:<<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
23
23
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
26
<p><h4>Suggested by</h4>
26
<p><h4>Suggested by</h4>
27
 <ul>
27
 <ul>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
Lines 31-50 VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> S Link Here
31
   <li><<borrowers.email>></li>
31
   <li><<borrowers.email>></li>
32
 </ul>
32
 </ul>
33
</p>
33
</p>
34
<p><h4>Item on suggestion</h4>
34
<p><h4>Title suggested</h4>
35
 <ul>
35
 <ul>
36
   <li><b>Library : </b> <<branches.branchname>></li>
36
   <li><b>Library:</b> <<branches.branchname>></li>
37
   <li><b>Title : </b> <<suggestions.title>></li>
37
   <li><b>Title:</b> <<suggestions.title>></li>
38
   <li><b>Author : </b> <<suggestions.author>></li>
38
   <li><b>Author:</b> <<suggestions.author>></li>
39
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
39
   <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
40
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
40
   <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
41
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
41
   <li><b>Publisher:</b> <<suggestions.publishercode>></li>
42
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
42
   <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
43
   <li><b>Publication place : </b> <<suggestions.place>></li>
43
   <li><b>Publication place:</b> <<suggestions.place>></li>
44
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
44
   <li><b>Quantity:</b> <<suggestions.quantity>></li>
45
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
45
   <li><b>Item type:</b>  <<suggestions.itemtype>></li>
46
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
46
   <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
47
   <li><b>Notes : </b> <<suggestions.note>></li>
47
   <li><b>Notes:</b> <<suggestions.note>></li>
48
 </ul>
48
 </ul>
49
</p>',1, 'email');
49
</p>',1, 'email');
50
50
(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (-40 / +40 lines)
Lines 3-31 INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, m Link Here
3
('circulation','CHECKOUT','','Emprunts (Résumé)',0,'Emprunts','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous venez d\'emprunter les documents suivants :\r\n----\r\n<<biblio.title>>\r\n----\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
3
('circulation','CHECKOUT','','Emprunts (Résumé)',0,'Emprunts','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous venez d\'emprunter les documents suivants :\r\n----\r\n<<biblio.title>>\r\n----\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
4
('circulation','DUE','','Document à rendre aujourd\'hui',0,'Document à rendre aujourd\'hui','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nLe prêt de ce document arrive à expiration aujourd\'hui.\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nMerci de nous le retourner.\r\n\r\n<<branches.branchname>>','email'),
4
('circulation','DUE','','Document à rendre aujourd\'hui',0,'Document à rendre aujourd\'hui','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nLe prêt de ce document arrive à expiration aujourd\'hui.\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nMerci de nous le retourner.\r\n\r\n<<branches.branchname>>','email'),
5
('circulation','DUEDGST','','Document à rendre aujourd\'hui (Résumé)',0,'Document à rendre aujourd\'hui','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous avez <<count>> document(s) dont le prêt arrive à expiration.\r\n\r\nMerci de nous le(s) retourner rapidement.\r\n\r\n<<branches.branchname>>','email'),
5
('circulation','DUEDGST','','Document à rendre aujourd\'hui (Résumé)',0,'Document à rendre aujourd\'hui','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous avez <<count>> document(s) dont le prêt arrive à expiration.\r\n\r\nMerci de nous le(s) retourner rapidement.\r\n\r\n<<branches.branchname>>','email'),
6
('circulation','ISSUEQSLIP','','Ticket rapide de prêts',1,'Ticket rapide de prêts','<h3><<branches.branchname>></h3>\r\nEmprunté par <<borrowers.firstname>> <<borrowers.surname>> <br />\r\n(<<borrowers.cardnumber>>) <br />\r\n\r\n<<today>><br />\r\n\r\n<h4>Emprunté(s) aujourd\'hui</h4>\r\n<checkedout>\r\n<p>\r\n<<biblio.title>><br />\r\nCode-barres : <<items.barcode>><br />\r\nDate de retour : <<issues.date_due>><br />\r\n</p>\r\n</checkedout>','email'),
6
('circulation','ISSUEQSLIP','','Ticket rapide de prêts',1,'Ticket rapide de prêts','<h3><<branches.branchname>></h3>\r\nEmprunté par <<borrowers.firstname>> <<borrowers.surname>> <br />\r\n(<<borrowers.cardnumber>>) <br />\r\n\r\n<<today>><br />\r\n\r\n<h4>Emprunté(s) aujourd\'hui</h4>\r\n<checkedout>\r\n<p>\r\n<<biblio.title>><br />\r\nCode-barres:<<items.barcode>><br />\r\nDate de retour:<<issues.date_due>><br />\r\n</p>\r\n</checkedout>','email'),
7
('circulation','ISSUESLIP','','Ticket de prêts',1,'Ticket de prêts','<h3><<branches.branchname>></h3>\r\nEmprunté par <<borrowers.firstname>> <<borrowers.surname>> <br />\r\n(<<borrowers.cardnumber>>) <br />\r\n\r\n<<today>><br />\r\n\r\n<h4>Emprunté(s) aujourd\'hui</h4>\r\n<checkedout>\r\n<p>\r\n<<biblio.title>> <br />\r\nCode-barres : <<items.barcode>><br />\r\nDate de retour : <<issues.date_due>><br />\r\n</p>\r\n</checkedout>\r\n\r\n<h4>Retards</h4>\r\n<overdue>\r\n<p>\r\n<<biblio.title>> <br />\r\nCode-barres : <<items.barcode>><br />\r\nDate de retour : <<issues.date_due>><br />\r\n</p>\r\n</overdue>\r\n\r\n<hr>\r\n\r\n<h4 style=\"text-align: center; font-style:italic;\">Nouvelles</h4>\r\n<news>\r\n<div class=\"newsitem\">\r\n<h5 style=\"margin-bottom: 1px; margin-top: 1px\"><b><<opac_news.title>></b></h5>\r\n<p style=\"margin-bottom: 1px; margin-top: 1px\"><<opac_news.content>></p>\r\n<p class=\"newsfooter\" style=\"font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px\">Publiée le <<opac_news.timestamp>></p>\r\n<hr />\r\n</div>\r\n</news>','email'),
7
('circulation','ISSUESLIP','','Ticket de prêts',1,'Ticket de prêts','<h3><<branches.branchname>></h3>\r\nEmprunté par <<borrowers.firstname>> <<borrowers.surname>> <br />\r\n(<<borrowers.cardnumber>>) <br />\r\n\r\n<<today>><br />\r\n\r\n<h4>Emprunté(s) aujourd\'hui</h4>\r\n<checkedout>\r\n<p>\r\n<<biblio.title>> <br />\r\nCode-barres:<<items.barcode>><br />\r\nDate de retour:<<issues.date_due>><br />\r\n</p>\r\n</checkedout>\r\n\r\n<h4>Retards</h4>\r\n<overdue>\r\n<p>\r\n<<biblio.title>> <br />\r\nCode-barres:<<items.barcode>><br />\r\nDate de retour:<<issues.date_due>><br />\r\n</p>\r\n</overdue>\r\n\r\n<hr>\r\n\r\n<h4 style=\"text-align: center; font-style:italic;\">Nouvelles</h4>\r\n<news>\r\n<div class=\"newsitem\">\r\n<h5 style=\"margin-bottom: 1px; margin-top: 1px\"><b><<opac_news.title>></b></h5>\r\n<p style=\"margin-bottom: 1px; margin-top: 1px\"><<opac_news.content>></p>\r\n<p class=\"newsfooter\" style=\"font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px\">Publiée le <<opac_news.timestamp>></p>\r\n<hr />\r\n</div>\r\n</news>','email'),
8
('circulation','ODUE','','Document(s) en retard',0,'Document(s) en retard','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nSelon nos informations, vous avez au moins un document en retard. Merci de retourner ou renouveller ce ou ces documents dans votre bibliothèque le plus rapidement possible.\r\n\r\n<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>> <<branches.branchaddress3>>\r\nTél : <<branches.branchphone>>\r\nFax : <<branches.branchfax>>\r\nCourriel : <<branches.branchemail>>\r\n\r\nSi vous avez le mot de passe de votre compte lecteur, vous pouvez renouveler directement en ligne. Sinon, merci de nous contacter.\r\n\r\nLe ou les documents suivants sont en retard :\r\n\r\n<item>\"<<biblio.title>>\" par <<biblio.author>>, <<items.itemcallnumber>>, code-barres : <<items.barcode>> Amende : <<items.fine>></item>\r\n\r\nMerci de votre attention.\r\n\r\n<<branches.branchname>>','email'),
8
('circulation','ODUE','','Document(s) en retard',0,'Document(s) en retard','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nSelon nos informations, vous avez au moins un document en retard. Merci de retourner ou renouveller ce ou ces documents dans votre bibliothèque le plus rapidement possible.\r\n\r\n<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>> <<branches.branchaddress3>>\r\nTél:<<branches.branchphone>>\r\nFax:<<branches.branchfax>>\r\nCourriel:<<branches.branchemail>>\r\n\r\nSi vous avez le mot de passe de votre compte lecteur, vous pouvez renouveler directement en ligne. Sinon, merci de nous contacter.\r\n\r\nLe ou les documents suivants sont en retard :\r\n\r\n<item>\"<<biblio.title>>\" par <<biblio.author>>, <<items.itemcallnumber>>, code-barres:<<items.barcode>> Amende:<<items.fine>></item>\r\n\r\nMerci de votre attention.\r\n\r\n<<branches.branchname>>','email'),
9
('circulation','PREDUE','','Document à rendre bientôt',0,'Document à rendre bientôt','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nNous souhaitons vous informer que le prêt de ce document arrive bientôt à expiration :\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
9
('circulation','PREDUE','','Document à rendre bientôt',0,'Document à rendre bientôt','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nNous souhaitons vous informer que le prêt de ce document arrive bientôt à expiration :\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
10
('circulation','PREDUEDGST','','Document à rendre bientôt (Résumé)',0,'Document(s) à rendre bientôt','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous avez <<count>> document(s) dont le prêt arrive bientôt à expiration.\r\n\r\n<<branches.branchname>>','email'),
10
('circulation','PREDUEDGST','','Document à rendre bientôt (Résumé)',0,'Document(s) à rendre bientôt','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous avez <<count>> document(s) dont le prêt arrive bientôt à expiration.\r\n\r\n<<branches.branchname>>','email'),
11
('circulation','RENEWAL','','Renouvellements',0,'Renouvellements','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous avez renouvelé les documents suivants :\r\n----\r\n<<biblio.title>>\r\n----\r\nMerci.\r\n\r\n<<branches.branchname>>.','email'),
11
('circulation','RENEWAL','','Renouvellements',0,'Renouvellements','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous avez renouvelé les documents suivants :\r\n----\r\n<<biblio.title>>\r\n----\r\nMerci.\r\n\r\n<<branches.branchname>>.','email'),
12
('circulation','HOLD_SLIP','','Ticket de réservation',1,'Ticket de réservation','<h5>Date : <<today>></h5>\r\n\r\n<h3> Transfert / Réservation disponible à <<branches.branchname>></h3>\r\n\r\n<h3><<borrowers.surname>>, <<borrowers.firstname>> </h3>\r\n\r\n<ul>\r\n    <li><<borrowers.cardnumber>></li>\r\n    <li><<borrowers.phone>></li>\r\n    <li> <<borrowers.address>><br />\r\n         <<borrowers.address2>><br />\r\n         <<borrowers.city >>  <<borrowers.zipcode>>\r\n    </li>\r\n    <li><<borrowers.email>></li>\r\n</ul>\r\n<br />\r\n<h3>DOCUMENT RÉSERVÉ</h3>\r\n<h4><<biblio.title>></h4>\r\n<h5><<biblio.author>></h5>\r\n<ul>\r\n   <li><<items.barcode>></li>\r\n   <li><<items.itemcallnumber>></li>\r\n   <li><<reserves.waitingdate>></li>\r\n</ul>\r\n<p>Notes :\r\n<pre><<reserves.reservenotes>></pre>\r\n</p>\r\n','email'),
12
('circulation','HOLD_SLIP','','Ticket de réservation',1,'Ticket de réservation','<h5>Date:<<today>></h5>\r\n\r\n<h3> Transfert / Réservation disponible à <<branches.branchname>></h3>\r\n\r\n<h3><<borrowers.surname>>, <<borrowers.firstname>> </h3>\r\n\r\n<ul>\r\n    <li><<borrowers.cardnumber>></li>\r\n    <li><<borrowers.phone>></li>\r\n    <li> <<borrowers.address>><br />\r\n         <<borrowers.address2>><br />\r\n         <<borrowers.city >>  <<borrowers.zipcode>>\r\n    </li>\r\n    <li><<borrowers.email>></li>\r\n</ul>\r\n<br />\r\n<h3>DOCUMENT RÉSERVÉ</h3>\r\n<h4><<biblio.title>></h4>\r\n<h5><<biblio.author>></h5>\r\n<ul>\r\n   <li><<items.barcode>></li>\r\n   <li><<items.itemcallnumber>></li>\r\n   <li><<reserves.waitingdate>></li>\r\n</ul>\r\n<p>Notes :\r\n<pre><<reserves.reservenotes>></pre>\r\n</p>\r\n','email'),
13
('circulation','TRANSFERSLIP','','Ticket de transfert',1,'Ticket de transfert','<h5>Date : <<today>></h5>\r\n\r\n<h3>Transfert à <<branches.branchname>></h3>\r\n\r\n<h3>DOCUMENT</h3>\r\n<h4><<biblio.title>></h4>\r\n<h5><<biblio.author>></h5>\r\n<ul>\r\n   <li><<items.barcode>></li>\r\n   <li><<items.itemcallnumber>></li>\r\n</ul>','email'),
13
('circulation','TRANSFERSLIP','','Ticket de transfert',1,'Ticket de transfert','<h5>Date:<<today>></h5>\r\n\r\n<h3>Transfert à <<branches.branchname>></h3>\r\n\r\n<h3>DOCUMENT</h3>\r\n<h4><<biblio.title>></h4>\r\n<h5><<biblio.author>></h5>\r\n<ul>\r\n   <li><<items.barcode>></li>\r\n   <li><<items.itemcallnumber>></li>\r\n</ul>','email'),
14
('claimacquisition','ACQCLAIM','','Réclamation d\'une commande',0,'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\nBonjour,\r\n\r\nLa commande suivante n\'a pas été reçue par notre service d\'acquisitions.\r\n\r\n<order>Commande n. <<aqorders.ordernumber>> (<<biblio.title>>) (<<aqorders.quantity>> exemplaire(s) commandé(s)) ($<<aqorders.listprice>> / unité).</order>\r\n\r\nMerci de faire le nécessaire pour nous la faire parvenir rapidement.\r\n\r\nEn cas de problème, veuillez nous contacter à l\'adresse ci-dessous.\r\n\r\nCordialement,\r\n\r\n<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>\r\n<<branches.branchphone>>\r\n<<branches.branchemail>>\r\n','email'),
14
('claimacquisition','ACQCLAIM','','Réclamation d\'une commande',0,'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\nBonjour,\r\n\r\nLa commande suivante n\'a pas été reçue par notre service d\'acquisitions.\r\n\r\n<order>Commande n. <<aqorders.ordernumber>> (<<biblio.title>>) (<<aqorders.quantity>> exemplaire(s) commandé(s)) ($<<aqorders.listprice>> / unité).</order>\r\n\r\nMerci de faire le nécessaire pour nous la faire parvenir rapidement.\r\n\r\nEn cas de problème, veuillez nous contacter à l\'adresse ci-dessous.\r\n\r\nCordialement,\r\n\r\n<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>\r\n<<branches.branchphone>>\r\n<<branches.branchemail>>\r\n','email'),
15
('orderacquisition','ACQORDER','','Commande',0,'Commande','<<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\nLa bibliothèque désire commander :\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<biblio.title>>) (quantity: <<aqorders.quantity>>) ($<<aqorders.listprice>> chacun).</order>\r\n\r\nMerci,\n\n<<branches.branchname>>', 'email'),
15
('orderacquisition','ACQORDER','','Commande',0,'Commande','<<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\nLa bibliothèque désire commander :\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<biblio.title>>) (quantity: <<aqorders.quantity>>) ($<<aqorders.listprice>> chacun).</order>\r\n\r\nMerci,\n\n<<branches.branchname>>', 'email'),
16
('members','ACCTDETAILS','','Modèle de message pour les détails d\'un compte lecteur - DEFAULT',0,'Votre compte Koha','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nLes informations pour vous connecter à votre compte lecteur sont :\r\n\r\nIdentifiant :  <<borrowers.userid>>\r\nMot de passe: <<borrowers.password>>\r\n\r\nSi vous rencontrez des problèmes ou avez des questions concernant votre compte, veuillez contacter l\'administrateur de Koha.\r\n\r\nMerci, \r\nL\'administrateur de Koha\r\nkohaadmin@yoursite.org','email'),
16
('members','ACCTDETAILS','','Modèle de message pour les détails d\'un compte lecteur - DEFAULT',0,'Votre compte Koha','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nLes informations pour vous connecter à votre compte lecteur sont :\r\n\r\nIdentifiant: <<borrowers.userid>>\r\nMot de passe: <<borrowers.password>>\r\n\r\nSi vous rencontrez des problèmes ou avez des questions concernant votre compte, veuillez contacter l\'administrateur de Koha.\r\n\r\nMerci, \r\nL\'administrateur de Koha\r\nkohaadmin@yoursite.org','email'),
17
('reserves','HOLD','','Réservation en attente de retrait',0,'Réservation en attente de retrait à <<branches.branchname>>','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVotre réservation est disponible depuis le <<reserves.waitingdate>> :\r\n\r\nTitre : <<biblio.title>>\r\nAuteur : <<biblio.author>>\r\nCopie : <<items.copynumber>>\r\nLocalisation : <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>\r\n\r\nNous vous invitons à venir emprunter votre document rapidement.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
17
('reserves','HOLD','','Réservation en attente de retrait',0,'Réservation en attente de retrait à <<branches.branchname>>','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVotre réservation est disponible depuis le <<reserves.waitingdate>> :\r\n\r\nTitre:<<biblio.title>>\r\nAuteur:<<biblio.author>>\r\nCopie:<<items.copynumber>>\r\nLocalisation:<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>\r\n\r\nNous vous invitons à venir emprunter votre document rapidement.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
18
('reserves','HOLD','','Réservation en attente de retrait',0,'Réservation en attente de retrait à <<branches.branchname>>','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVotre réservation est disponible depuis le <<reserves.waitingdate>> :\r\n\r\nTitre : <<biblio.title>>\r\nAuteur : <<biblio.author>>\r\nCopie : <<items.copynumber>>\r\nLocalisation : <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>\r\n\r\nNous vous invitons à venir emprunter votre document rapidement.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','print'),
18
('reserves','HOLD','','Réservation en attente de retrait',0,'Réservation en attente de retrait à <<branches.branchname>>','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVotre réservation est disponible depuis le <<reserves.waitingdate>> :\r\n\r\nTitre:<<biblio.title>>\r\nAuteur:<<biblio.author>>\r\nCopie:<<items.copynumber>>\r\nLocalisation:<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>\r\n\r\nNous vous invitons à venir emprunter votre document rapidement.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','print'),
19
('reserves','HOLDPLACED','','Réservation sur un document',0,'Un document a été réservé','Le document suivant a été réservé : \r\n<<biblio.title>> (<<biblio.biblionumber>>) par l\'adhérent <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).','email'),
19
('reserves','HOLDPLACED','','Réservation sur un document',0,'Un document a été réservé','Le document suivant a été réservé:\r\n<<biblio.title>> (<<biblio.biblionumber>>) par l\'adhérent <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).','email'),
20
('reserves', 'CANCEL_HOLD_ON_LOST', '','Réservation annulée',0,"Réservation annulée", "Bonjour [% borrower.firstname %] [% borrower.surname %],\n\nVotre réservation pour le document suivant ne peut malheureusement pas être comblée parce que le document est introuvable.\n\nTitre : [% biblio.title %]\nAuteur : [% biblio.author %]\nExemplaire : [% item.copynumber %]\nLocalisation : [% branch.branchname %]", 'email'),
20
('reserves', 'CANCEL_HOLD_ON_LOST', '','Réservation annulée',0,"Réservation annulée", "Bonjour [% borrower.firstname %] [% borrower.surname %],\n\nVotre réservation pour le document suivant ne peut malheureusement pas être comblée parce que le document est introuvable.\n\nTitre:[% biblio.title %]\nAuteur:[% biblio.author %]\nExemplaire:[% item.copynumber %]\nLocalisation:[% branch.branchname %]", 'email'),
21
('serial','SERIAL_ALERT','','Liste de circulation',0,'Le nouveau numéro de <<biblio.title>> est disponible','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nLe nouveau numéro de <<biblio.title>> est disponible.\r\n\r\nVous pouvez venir à la bilbliothèque pour le consulter.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
21
('serial','SERIAL_ALERT','','Liste de circulation',0,'Le nouveau numéro de <<biblio.title>> est disponible','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nLe nouveau numéro de <<biblio.title>> est disponible.\r\n\r\nVous pouvez venir à la bilbliothèque pour le consulter.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
22
('suggestions','ACCEPTED','','Suggestion d\'achat acceptée',0,'Suggestion d\'achat acceptée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons évalué votre suggestion aujourdhui. Le document sera commandé dès que possible. Vous serez tenu au courant par courriel quand le document aura été commandé et quand il sera disponible à la bibliothèque.\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante : <<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
22
('suggestions','ACCEPTED','','Suggestion d\'achat acceptée',0,'Suggestion d\'achat acceptée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons évalué votre suggestion aujourdhui. Le document sera commandé dès que possible. Vous serez tenu au courant par courriel quand le document aura été commandé et quand il sera disponible à la bibliothèque.\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante:<<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
23
('suggestions','AVAILABLE','','Suggestion d\'achat disponible',0,'Suggestion d\'achat disponible','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons le plaisir de vous informer que le document fait aujourd\'hui partie de nos collection et qu\'il est disponible à la bibliothèque.\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante : <<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
23
('suggestions','AVAILABLE','','Suggestion d\'achat disponible',0,'Suggestion d\'achat disponible','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons le plaisir de vous informer que le document fait aujourd\'hui partie de nos collection et qu\'il est disponible à la bibliothèque.\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante:<<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
24
('suggestions','ORDERED','','Suggestion d\'achat commandée',0,'Suggestion d\'achat commandée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons le plaisir de vous informer que le document a été commandé.\r\n\r\nVous recevrez une nouvelle notification quand le document sera disponible à bibliothèque.\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante : <<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
24
('suggestions','ORDERED','','Suggestion d\'achat commandée',0,'Suggestion d\'achat commandée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons le plaisir de vous informer que le document a été commandé.\r\n\r\nVous recevrez une nouvelle notification quand le document sera disponible à bibliothèque.\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante:<<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
25
('suggestions','REJECTED','','Suggestion d\'achat rejetée',0,'Suggestion d\'achat rejetée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons évalué votre suggestion aujourd\'hui et décidé de ne pas l\'acheter cette fois.\r\n\r\nLa raison de notre refus est : <<suggestions.reason>>\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante : <<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email');
25
('suggestions','REJECTED','','Suggestion d\'achat rejetée',0,'Suggestion d\'achat rejetée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons évalué votre suggestion aujourd\'hui et décidé de ne pas l\'acheter cette fois.\r\n\r\nLa raison de notre refus est:<<suggestions.reason>>\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante:<<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email');
26
26
27
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
27
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
28
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
28
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
29
<p><h4>Suggested by</h4>
29
<p><h4>Suggested by</h4>
30
 <ul>
30
 <ul>
31
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
31
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
Lines 34-61 VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> S Link Here
34
   <li><<borrowers.email>></li>
34
   <li><<borrowers.email>></li>
35
 </ul>
35
 </ul>
36
</p>
36
</p>
37
<p><h4>Item on suggestion</h4>
37
<p><h4>Title suggested</h4>
38
 <ul>
38
 <ul>
39
   <li><b>Library : </b> <<branches.branchname>></li>
39
   <li><b>Library:</b> <<branches.branchname>></li>
40
   <li><b>Title : </b> <<suggestions.title>></li>
40
   <li><b>Title:</b> <<suggestions.title>></li>
41
   <li><b>Author : </b> <<suggestions.author>></li>
41
   <li><b>Author:</b> <<suggestions.author>></li>
42
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
42
   <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
43
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
43
   <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
44
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
44
   <li><b>Publisher:</b> <<suggestions.publishercode>></li>
45
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
45
   <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
46
   <li><b>Publication place : </b> <<suggestions.place>></li>
46
   <li><b>Publication place:</b> <<suggestions.place>></li>
47
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
47
   <li><b>Quantity:</b> <<suggestions.quantity>></li>
48
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
48
   <li><b>Item type:</b> <<suggestions.itemtype>></li>
49
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
49
   <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
50
   <li><b>Notes : </b> <<suggestions.note>></li>
50
   <li><b>Notes:</b> <<suggestions.note>></li>
51
 </ul>
51
 </ul>
52
</p>',1, 'email');
52
</p>',1, 'email');
53
53
54
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
54
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
55
('members','DISCHARGE','','Quittance',0,'Quittance pour <<borrowers.firstname>> <<borrowers.surname>>','Quittance\r\n\r\nLa bibliothèque <<borrowers.branchcode>> certifie que l\'utilisateur suivant :\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\nCardnumber : <<borrowers.cardnumber>>\r\n\r\na rendu tous ses documents.','email');
55
('members','DISCHARGE','','Quittance',0,'Quittance pour <<borrowers.firstname>> <<borrowers.surname>>','Quittance\r\n\r\nLa bibliothèque <<borrowers.branchcode>> certifie que l\'utilisateur suivant :\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\nCardnumber:<<borrowers.cardnumber>>\r\n\r\na rendu tous ses documents.','email');
56
56
57
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
57
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
58
('members','OPAC_REG_VERIFY','','Courriel de vérification lors d\'une auto-inscription',1,'Vérification de votre compte','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVotre compte lecteur a été créé. Pour terminer votre inscription, veuillez confirmer votre courriel en cliquant sur ce lien : \r\n\r\nhttp://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>\r\n\r\nSi vous n\'êtes pas à l\'origine de cette inscription, vous pouvez ignorer ce message. Le lien expirera sous peu.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email');
58
('members','OPAC_REG_VERIFY','','Courriel de vérification lors d\'une auto-inscription',1,'Vérification de votre compte','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVotre compte lecteur a été créé. Pour terminer votre inscription, veuillez confirmer votre courriel en cliquant sur ce lien:\r\n\r\nhttp://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>\r\n\r\nSi vous n\'êtes pas à l\'origine de cette inscription, vous pouvez ignorer ce message. Le lien expirera sous peu.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email');
59
59
60
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
60
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
61
('members','SHARE_INVITE','','Invitation pour partager une liste',0,'Partage de la liste <<listname>>','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nUn de nos lecteurs, <<borrowers.firstname>> <<borrowers.surname>>, vous invite à partager la liste <<listname>> dans le catalogue de la bibliothèque.\r\n\r\nPour voir cette liste, veuillez cliquer sur le lien suivant ou le copier/coller dans la barre d\'adresse de votre navigateur.\r\n\r\n<<shareurl>>\r\n\r\nSi vous n\'êtes pas un adhérent de notre bibliothèque ou si vous ne souhaitez pas accepter cette invitation, merci d\'ignorer ce message. Veuillez noter également que cette invitation expirera dans deux semaines.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email');
61
('members','SHARE_INVITE','','Invitation pour partager une liste',0,'Partage de la liste <<listname>>','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nUn de nos lecteurs, <<borrowers.firstname>> <<borrowers.surname>>, vous invite à partager la liste <<listname>> dans le catalogue de la bibliothèque.\r\n\r\nPour voir cette liste, veuillez cliquer sur le lien suivant ou le copier/coller dans la barre d\'adresse de votre navigateur.\r\n\r\n<<shareurl>>\r\n\r\nSi vous n\'êtes pas un adhérent de notre bibliothèque ou si vous ne souhaitez pas accepter cette invitation, merci d\'ignorer ce message. Veuillez noter également que cette invitation expirera dans deux semaines.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email');
Lines 67-86 INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, m Link Here
67
('acquisition','ACQ_NOTIF_ON_RECEIV','','Notification lors de la réception',0,'Commande reçue','Bonjour <<borrowers.firstname>> <<borrowers.surname>bbbb>,\r\n\r\nLa commande <<aqorders.ordernumber>> (<<biblio.title>>) a été reçue.\r\n\r\n<<branches.branchname>>','email');
67
('acquisition','ACQ_NOTIF_ON_RECEIV','','Notification lors de la réception',0,'Commande reçue','Bonjour <<borrowers.firstname>> <<borrowers.surname>bbbb>,\r\n\r\nLa commande <<aqorders.ordernumber>> (<<biblio.title>>) a été reçue.\r\n\r\n<<branches.branchname>>','email');
68
68
69
INSERT INTO `letter` (module, code, name, title, content, message_transport_type) VALUES
69
INSERT INTO `letter` (module, code, name, title, content, message_transport_type) VALUES
70
('suggestions','TO_PROCESS','Notification pour le responsable du poste budgétaire', 'Une suggestion est prête à être traitée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\n\nUne nouvelle suggestion est prête à être traitée : <<suggestions.title>> par <<suggestions.author>>.\n\nMerci,\n\n<<branches.branchname>>', 'email');
70
('suggestions','TO_PROCESS','Notification pour le responsable du poste budgétaire', 'Une suggestion est prête à être traitée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\n\nUne nouvelle suggestion est prête à être traitée:<<suggestions.title>> par <<suggestions.author>>.\n\nMerci,\n\n<<branches.branchname>>', 'email');
71
71
72
INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) VALUES
72
INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) VALUES
73
('circulation', 'OVERDUES_SLIP', '', 'Ticket pour les documents en retard', '0', 'OVERDUES_SLIP', 'Le(s) document(s) est/sont présentement en retard :
73
('circulation', 'OVERDUES_SLIP', '', 'Ticket pour les documents en retard', '0', 'OVERDUES_SLIP', 'Le(s) document(s) est/sont présentement en retard :
74
74
75
<item>"<<biblio.title>>" par <<biblio.author>>, <<items.itemcallnumber>>, Code-barres : <<items.barcode>> Amendes : <<items.fine>></item>
75
<item>"<<biblio.title>>" par <<biblio.author>>, <<items.itemcallnumber>>, Code-barres:<<items.barcode>> Amendes:<<items.fine>></item>
76
', 'print' );
76
', 'print' );
77
77
78
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
78
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
79
('circulation', 'AR_CANCELED', '', 'Demande d\'article - annulation', 0, 'Demande d\'article annulée', 'Bonjour <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nVotre demande d\'article de <<biblio.title>> (<<items.barcode>>) a été annulée pour la raison suivante :\r\n\r\n<<article_requests.notes>>\r\n\r\nArticle demandé :\r\nTitre : <<article_requests.title>>\r\nAuteur : <<article_requests.author>>\r\nVolume : <<article_requests.volume>>\r\nNuméro : <<article_requests.issue>>\r\nDate : <<article_requests.date>>\r\nPages : <<article_requests.pages>>\r\nChapitres : <<article_requests.chapters>>\r\nNotes : <<article_requests.patron_notes>>\r\n\r\nVotre bibliothèque.', 'email'),
79
('circulation', 'AR_CANCELED', '', 'Demande d\'article - annulation', 0, 'Demande d\'article annulée', 'Bonjour <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nVotre demande d\'article de <<biblio.title>> (<<items.barcode>>) a été annulée pour la raison suivante :\r\n\r\n<<article_requests.notes>>\r\n\r\nArticle demandé :\r\nTitre:<<article_requests.title>>\r\nAuteur:<<article_requests.author>>\r\nVolume:<<article_requests.volume>>\r\nNuméro:<<article_requests.issue>>\r\nDate:<<article_requests.date>>\r\nPages:<<article_requests.pages>>\r\nChapitres:<<article_requests.chapters>>\r\nNotes:<<article_requests.patron_notes>>\r\n\r\nVotre bibliothèque.', 'email'),
80
('circulation', 'AR_COMPLETED', '', 'Demande d\'article - disponible', 0, 'L\'article demandé est disponible', 'Bonjour <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nL\'article de <<biblio.title>> (<<items.barcode>>) que vous avez demandé est maintenant disponible.\r\n\r\nArticle demandé :\r\nTitre : <<article_requests.title>>\r\nAuteur : <<article_requests.author>>\r\nVolume : <<article_requests.volume>>\r\nNuméro : <<article_requests.issue>>\r\nDate : <<article_requests.date>>\r\nPages : <<article_requests.pages>>\r\nChapitres : <<article_requests.chapters>>\r\nNotes : <<article_requests.patron_notes>>\r\n\r\nVous pouvez venir chercher votre article à <<branches.branchname>>.\r\n\r\nMerci.', 'email'),
80
('circulation', 'AR_COMPLETED', '', 'Demande d\'article - disponible', 0, 'L\'article demandé est disponible', 'Bonjour <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nL\'article de <<biblio.title>> (<<items.barcode>>) que vous avez demandé est maintenant disponible.\r\n\r\nArticle demandé :\r\nTitre:<<article_requests.title>>\r\nAuteur:<<article_requests.author>>\r\nVolume:<<article_requests.volume>>\r\nNuméro:<<article_requests.issue>>\r\nDate:<<article_requests.date>>\r\nPages:<<article_requests.pages>>\r\nChapitres:<<article_requests.chapters>>\r\nNotes:<<article_requests.patron_notes>>\r\n\r\nVous pouvez venir chercher votre article à <<branches.branchname>>.\r\n\r\nMerci.', 'email'),
81
('circulation', 'AR_PENDING', '', 'Demande d\'article - en attente', 0, 'Demande d\'article reçue', 'Bonjour <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>)\r\n\r\nNous avons bien reçu votre demande d\'article de <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle demandé :\r\nTitre : <<article_requests.title>>\r\nAuteur : <<article_requests.author>>\r\nVolume : <<article_requests.volume>>\r\nNuméro : <<article_requests.issue>>\r\nDate : <<article_requests.date>>\r\nPages : <<article_requests.pages>>\r\nChapitres : <<article_requests.chapters>>\r\nNotes : <<article_requests.patron_notes>>\r\n\r\n\r\nMerci.', 'email'),
81
('circulation', 'AR_PENDING', '', 'Demande d\'article - en attente', 0, 'Demande d\'article reçue', 'Bonjour <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>)\r\n\r\nNous avons bien reçu votre demande d\'article de <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle demandé :\r\nTitre:<<article_requests.title>>\r\nAuteur:<<article_requests.author>>\r\nVolume:<<article_requests.volume>>\r\nNuméro:<<article_requests.issue>>\r\nDate:<<article_requests.date>>\r\nPages:<<article_requests.pages>>\r\nChapitres:<<article_requests.chapters>>\r\nNotes:<<article_requests.patron_notes>>\r\n\r\n\r\nMerci.', 'email'),
82
('circulation', 'AR_SLIP', '', 'Demande d\'article - ticket', 0, 'Demande d\'article', 'Demande d\'article :\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nTitre : <<biblio.title>>\r\nCode-barres : <<items.barcode>>\r\n\r\nArticle demandé :\r\nTitre : <<article_requests.title>>\r\nAuteur : <<article_requests.author>>\r\nVolume : <<article_requests.volume>>\r\nNuméro : <<article_requests.issue>>\r\nDate : <<article_requests.date>>\r\nPages : <<article_requests.pages>>\r\nChapitres : <<article_requests.chapters>>\r\nNotes : <<article_requests.patron_notes>>\r\n', 'print'),
82
('circulation', 'AR_SLIP', '', 'Demande d\'article - ticket', 0, 'Demande d\'article', 'Demande d\'article :\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nTitre:<<biblio.title>>\r\nCode-barres:<<items.barcode>>\r\n\r\nArticle demandé :\r\nTitre:<<article_requests.title>>\r\nAuteur:<<article_requests.author>>\r\nVolume:<<article_requests.volume>>\r\nNuméro:<<article_requests.issue>>\r\nDate:<<article_requests.date>>\r\nPages:<<article_requests.pages>>\r\nChapitres:<<article_requests.chapters>>\r\nNotes:<<article_requests.patron_notes>>\r\n', 'print'),
83
('circulation', 'AR_PROCESSING', '', 'Demande d\'article - en traitement', 0, 'Demande d\'article en traitement', 'Bonjour <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nNous traitons votre demande d\'article de <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle demandé :\r\nTitre : <<article_requests.title>>\r\nAuteur : <<article_requests.author>>\r\nVolume : <<article_requests.volume>>\r\nNuméro : <<article_requests.issue>>\r\nDate : <<article_requests.date>>\r\nPages : <<article_requests.pages>>\r\nChapitres : <<article_requests.chapters>>\r\nNotes : <<article_requests.patron_notes>>\r\n\r\nMerci.', 'email'),
83
('circulation', 'AR_PROCESSING', '', 'Demande d\'article - en traitement', 0, 'Demande d\'article en traitement', 'Bonjour <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nNous traitons votre demande d\'article de <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle demandé :\r\nTitre:<<article_requests.title>>\r\nAuteur:<<article_requests.author>>\r\nVolume:<<article_requests.volume>>\r\nNuméro:<<article_requests.issue>>\r\nDate:<<article_requests.date>>\r\nPages:<<article_requests.pages>>\r\nChapitres:<<article_requests.chapters>>\r\nNotes:<<article_requests.patron_notes>>\r\n\r\nMerci.', 'email'),
84
('circulation', 'CHECKOUT_NOTE', '', 'Notes d\'un utilisateur sur les documents en prêt', '0', 'Notes sur les documents en prêts', '<<borrowers.firstname>> <<borrowers.surname>> a ajouté une note sur un exemplaire de <<biblio.title>> - <<biblio.author>> (<<biblio.biblionumber>>).','email');
84
('circulation', 'CHECKOUT_NOTE', '', 'Notes d\'un utilisateur sur les documents en prêt', '0', 'Notes sur les documents en prêts', '<<borrowers.firstname>> <<borrowers.surname>> a ajouté une note sur un exemplaire de <<biblio.title>> - <<biblio.author>> (<<biblio.biblionumber>>).','email');
85
85
86
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type)
86
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type)
Lines 89-96 VALUES ('members','PASSWORD_RESET','','Récupération de mot de passe en ligne', Link Here
89
89
90
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`)
90
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`)
91
    VALUES
91
    VALUES
92
        ('circulation', 'ACCOUNT_PAYMENT', '', 'Paiement', 0, 'Paiement', '[%- USE Price -%]\r\nVous avez fait un paiement de [% credit.amount * -1 | $Price %].\r\n\r\nLes frais suivants ont été acquittés :\r\n[%- FOREACH o IN offsets %]\r\nDescription : [% o.debit.description %]\r\nMontant payé : [% o.amount * -1 | $Price %]\r\nMontant en souffrance : [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default'),
92
        ('circulation', 'ACCOUNT_PAYMENT', '', 'Paiement', 0, 'Paiement', '[%- USE Price -%]\r\nVous avez fait un paiement de [% credit.amount * -1 | $Price %].\r\n\r\nLes frais suivants ont été acquittés :\r\n[%- FOREACH o IN offsets %]\r\nDescription:[% o.debit.description %]\r\nMontant payé:[% o.amount * -1 | $Price %]\r\nMontant en souffrance:[% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default'),
93
            ('circulation', 'ACCOUNT_WRITEOFF', '', 'Amnistie', 0, 'Amnistie', '[%- USE Price -%]\r\nNous avons accordé une amnistie de [% credit.amount * -1 | $Price %] à votre compte.\r\n\r\nLes frais suivants ont été amnistiés :\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nMontant payé : [% o.amount * -1 | $Price %]\r\nMontant en souffrance : [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
93
            ('circulation', 'ACCOUNT_WRITEOFF', '', 'Amnistie', 0, 'Amnistie', '[%- USE Price -%]\r\nNous avons accordé une amnistie de [% credit.amount * -1 | $Price %] à votre compte.\r\n\r\nLes frais suivants ont été amnistiés :\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nMontant payé:[% o.amount * -1 | $Price %]\r\nMontant en souffrance:[% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
94
94
95
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
95
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
96
('circulation', 'SR_SLIP', '', 'Ticket de rotation automatique d\'exemplaires', 0, 'Rapport de rotation automatique d\'exemplaires', 'Rapport de rotation automatique d\'exemplaires pour [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] exemplaires de cette bibliothèque à traiter.\r\n[% ELSE %]Aucun exemplaire de cette bibliothèque à traiter\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Titre : [% item.title %]\r\nAuteur : [% item.author %]\r\nCote : [% item.callnumber %]\r\nLocalisation : [% item.location %]\r\nCode-barres: [% item.barcode %]\r\nEn prêt? : [% item.onloan %]\r\nStatut : [% item.reason %]\r\nBibliothèque dépositaire : [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
96
('circulation', 'SR_SLIP', '', 'Ticket de rotation automatique d\'exemplaires', 0, 'Rapport de rotation automatique d\'exemplaires', 'Rapport de rotation automatique d\'exemplaires pour [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] exemplaires de cette bibliothèque à traiter.\r\n[% ELSE %]Aucun exemplaire de cette bibliothèque à traiter\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Titre:[% item.title %]\r\nAuteur:[% item.author %]\r\nCote:[% item.callnumber %]\r\nLocalisation:[% item.location %]\r\nCode-barres: [% item.barcode %]\r\nEn prêt?:[% item.onloan %]\r\nStatut:[% item.reason %]\r\nBibliothèque dépositaire:[% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (-25 / +25 lines)
Lines 14-30 VALUES Link Here
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'),
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'),
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'),
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'),
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', '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'),
18
('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'),
19
('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'),
19
('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'),
20
('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'),
20
('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'),
21
('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'),
21
('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'),
22
('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'),
22
('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'),
23
('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'),
23
('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'),
24
('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');
24
('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');
25
25
26
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
26
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
27
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
27
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
28
<p><h4>Suggested by</h4>
28
<p><h4>Suggested by</h4>
29
 <ul>
29
 <ul>
30
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
30
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
Lines 33-52 VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> S Link Here
33
   <li><<borrowers.email>></li>
33
   <li><<borrowers.email>></li>
34
 </ul>
34
 </ul>
35
</p>
35
</p>
36
<p><h4>Item on suggestion</h4>
36
<p><h4>Title suggested</h4>
37
 <ul>
37
 <ul>
38
   <li><b>Library : </b> <<branches.branchname>></li>
38
   <li><b>Library:</b> <<branches.branchname>></li>
39
   <li><b>Title : </b> <<suggestions.title>></li>
39
   <li><b>Title:</b> <<suggestions.title>></li>
40
   <li><b>Author : </b> <<suggestions.author>></li>
40
   <li><b>Author:</b> <<suggestions.author>></li>
41
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
41
   <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
42
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
42
   <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
43
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
43
   <li><b>Publisher:</b> <<suggestions.publishercode>></li>
44
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
44
   <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
45
   <li><b>Publication place : </b> <<suggestions.place>></li>
45
   <li><b>Publication place:</b> <<suggestions.place>></li>
46
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
46
   <li><b>Quantity:</b> <<suggestions.quantity>></li>
47
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
47
   <li><b>Item type:</b>  <<suggestions.itemtype>></li>
48
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
48
   <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
49
   <li><b>Notes : </b> <<suggestions.note>></li>
49
   <li><b>Notes:</b> <<suggestions.note>></li>
50
 </ul>
50
 </ul>
51
</p>',1, 'email');
51
</p>',1, 'email');
52
52
Lines 61-68 Prêts à <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<b Link Here
61
<checkedout>
61
<checkedout>
62
<p>
62
<p>
63
<<biblio.title>> <br />
63
<<biblio.title>> <br />
64
Code à barres : <<items.barcode>><br />
64
Code à barres:<<items.barcode>><br />
65
Retour le : <<issues.date_due>><br />
65
Retour le:<<issues.date_due>><br />
66
</p>
66
</p>
67
</checkedout>
67
</checkedout>
68
68
Lines 70-77 Retour le : <<issues.date_due>><br /> Link Here
70
<overdue>
70
<overdue>
71
<p>
71
<p>
72
<<biblio.title>> <br />
72
<<biblio.title>> <br />
73
Codes à barres : <<items.barcode>><br />
73
Codes à barres:<<items.barcode>><br />
74
Retour le : <<issues.date_due>><br />
74
Retour le:<<issues.date_due>><br />
75
</p>
75
</p>
76
</overdue>
76
</overdue>
77
77
Lines 96-106 Prêts à <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<b Link Here
96
<checkedout>
96
<checkedout>
97
<p>
97
<p>
98
<<biblio.title>> <br />
98
<<biblio.title>> <br />
99
Code à barres : <<items.barcode>><br />
99
Code à barres:<<items.barcode>><br />
100
Retour le : <<issues.date_due>><br />
100
Retour le:<<issues.date_due>><br />
101
</p>
101
</p>
102
</checkedout>', 1),
102
</checkedout>', 1),
103
('circulation','HOLD_SLIP','Ticket de réservation','Ticket de réservation', '<h5>Date : <<today>></h5>
103
('circulation','HOLD_SLIP','Ticket de réservation','Ticket de réservation', '<h5>Date:<<today>></h5>
104
104
105
<h3> Transfert vers/Réservé à <<branches.branchname>></h3>
105
<h3> Transfert vers/Réservé à <<branches.branchname>></h3>
106
106
Lines 128-134 Retour le : <<issues.date_due>><br /> Link Here
128
<pre><<reserves.reservenotes>></pre>
128
<pre><<reserves.reservenotes>></pre>
129
</p>
129
</p>
130
', 1),
130
', 1),
131
('circulation','TRANSFERSLIP','Ticket de transfer','Ticket de transfert', '<h5>Date : <<today>></h5>
131
('circulation','TRANSFERSLIP','Ticket de transfer','Ticket de transfert', '<h5>Date:<<today>></h5>
132
132
133
<h3>Transfert à <<branches.branchname>></h3>
133
<h3>Transfert à <<branches.branchname>></h3>
134
134
(-)a/installer/data/mysql/it-IT/necessari/notices.sql (-18 / +18 lines)
Lines 15-35 Il prestito dei seguenti volumi sta per scadere: Link Here
15
<<branches.branchname>>', 'email'),
15
<<branches.branchname>>', 'email'),
16
('circulation','RENEWAL','Rinnovi','Rinnovi','Per le seguenti copie sono stati rinnovati i prestiti:\r\n----\r\n<<
16
('circulation','RENEWAL','Rinnovi','Rinnovi','Per le seguenti copie sono stati rinnovati i prestiti:\r\n----\r\n<<
17
biblio.title>>\r\n----\r\nGrazie per aver visitaro <<branches.branchname>>.', 'email'),
17
biblio.title>>\r\n----\r\nGrazie per aver visitaro <<branches.branchname>>.', 'email'),
18
('reserves', 'HOLD', 'Prenotazione disponibile per il ritiro', 'Prenotazione disponibile per il ritiro a <<branches.branchname>>', 'Salve <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nHai una prenotazione disponibile per il ritiro fino al <<reserves.waitingdate>>:\r\n\r\nTitolo: <<biblio.title>>\r\nAutore: <<biblio.author>>\r\nCopia n. : <<items.copynumber>>\r\nPresso: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>', 'email'),
18
('reserves', 'HOLD', 'Prenotazione disponibile per il ritiro', 'Prenotazione disponibile per il ritiro a <<branches.branchname>>', 'Salve <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nHai una prenotazione disponibile per il ritiro fino al <<reserves.waitingdate>>:\r\n\r\nTitolo: <<biblio.title>>\r\nAutore: <<biblio.author>>\r\nCopia n.:<<items.copynumber>>\r\nPresso: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>', 'email'),
19
('reserves', 'HOLD', 'Prenotazione disponibile per il ritiro (stampa)', 'Prenotazione disponibile per il ritiro (stampa)', '<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nPrenotazione disponibile per il ritiro\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\nHai una prenotazione disponibile per il ritiro fino al <<reserves.waitingdate>>:\r\n\r\nTitolo: <<biblio.title>>\r\nAutore: <<biblio.author>>\r\nCopia n. : <<items.copynumber>>\r\n', 'print'),
19
('reserves', 'HOLD', 'Prenotazione disponibile per il ritiro (stampa)', 'Prenotazione disponibile per il ritiro (stampa)', '<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nPrenotazione disponibile per il ritiro\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\nHai una prenotazione disponibile per il ritiro fino al <<reserves.waitingdate>>:\r\n\r\nTitolo: <<biblio.title>>\r\nAutore: <<biblio.author>>\r\nCopia n.:<<items.copynumber>>\r\n', 'print'),
20
('circulation','CHECKIN','Restituzione (Digest)','Restituzione','Questi prestiti sono stati restituiti:\r\n----\r\n[% biblio.title %]\r\n----\r\nGrazie.', 'email'),
20
('circulation','CHECKIN','Restituzione (Digest)','Restituzione','Questi prestiti sono stati restituiti:\r\n----\r\n[% biblio.title %]\r\n----\r\nGrazie.', 'email'),
21
('circulation','CHECKOUT','Prestiti','Prestiti','Ti sono stati dati in prestito:\r\n----\r\n[% biblio.title %]\r\n----\r\nGrazie da parte di [% branch.branchname %].', 'email'),
21
('circulation','CHECKOUT','Prestiti','Prestiti','Ti sono stati dati in prestito:\r\n----\r\n[% biblio.title %]\r\n----\r\nGrazie da parte di [% branch.branchname %].', 'email'),
22
('reserves', 'HOLDPLACED', 'Prenotazione di una copia', 'Prenotazione di una copia','Una prenotazione è stata fatta su una copia di : <<biblio.title>> (<<biblio.biblionumber>>) dall\'utente <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
22
('reserves', 'HOLDPLACED', 'Prenotazione di una copia', 'Prenotazione di una copia','Una prenotazione è stata fatta su una copia di:<<biblio.title>> (<<biblio.biblionumber>>) dall\'utente <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
23
('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'),
23
('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'),
24
('suggestions','ACCEPTED','Suggerimento d\'acquisto accettato', 'Suggerimento d\'acquisto accettato','Salve <<borrowers.firstname>> <<borrowers.surname>>,\n\nHai suggerito di acquistare <<suggestions.title>> di <<suggestions.author>>.\n\nLa biblioteca ha revisionato il suggerimento oggi. La copia verrà ordinato il più presto possibile. Riceverai un\'email quando l\'ordine sarà completato e una altra mail quanto arriverà in biblioteca.\n\nSe hai domande, scrivici pure all\' email <<branches.branchemail>>.\n\nGrazie di tutto,\n\n<<branches.branchname>>', 'email'),
24
('suggestions','ACCEPTED','Suggerimento d\'acquisto accettato', 'Suggerimento d\'acquisto accettato','Salve <<borrowers.firstname>> <<borrowers.surname>>,\n\nHai suggerito di acquistare <<suggestions.title>> di <<suggestions.author>>.\n\nLa biblioteca ha revisionato il suggerimento oggi. La copia verrà ordinato il più presto possibile. Riceverai un\'email quando l\'ordine sarà completato e una altra mail quanto arriverà in biblioteca.\n\nSe hai domande, scrivici pure all\' email <<branches.branchemail>>.\n\nGrazie di tutto,\n\n<<branches.branchname>>', 'email'),
25
('suggestions','AVAILABLE','Suggerimento d\'acquisto disponibile', 'Suggerimento d\'acquisto disponibile','Salve <<borrowers.firstname>> <<borrowers.surname>>,\n\nHai suggerito di acquistare <<suggestions.title>> di <<suggestions.author>>.\n\nTi informiamo che la copia è arrivata in biblioteca.\n\nSe hai domande, scrivici pure all\' email <<branches.branchemail>>.\n\nGrazie di tutto,\n\n<<branches.branchname>>', 'email'),
25
('suggestions','AVAILABLE','Suggerimento d\'acquisto disponibile', 'Suggerimento d\'acquisto disponibile','Salve <<borrowers.firstname>> <<borrowers.surname>>,\n\nHai suggerito di acquistare <<suggestions.title>> di <<suggestions.author>>.\n\nTi informiamo che la copia è arrivata in biblioteca.\n\nSe hai domande, scrivici pure all\' email <<branches.branchemail>>.\n\nGrazie di tutto,\n\n<<branches.branchname>>', 'email'),
26
('suggestions','ORDERED','Suggerimento d\'acquisto ordinato', 'Suggerimento d\'acquisto ordinato','Salve <<borrowers.firstname>> <<borrowers.surname>>,\n\nHai suggerito di acquistare <<suggestions.title>> di <<suggestions.author>>.\n\nTi informiamo che l\'ordine è stata inviato al fornitore della biblioteca. Dovrebbe arrivare in poco tempo, poi verrà aggiunto alla collezione della biblioteca.\n\nRiceverai un\'altra email quando sarà disponibile.\n\nSe hai domande, scrivici pure all\' email <<branches.branchemail>>\n\nGrazie di tutto,\n\n<<branches.branchname>>', 'email'),
26
('suggestions','ORDERED','Suggerimento d\'acquisto ordinato', 'Suggerimento d\'acquisto ordinato','Salve <<borrowers.firstname>> <<borrowers.surname>>,\n\nHai suggerito di acquistare <<suggestions.title>> di <<suggestions.author>>.\n\nTi informiamo che l\'ordine è stata inviato al fornitore della biblioteca. Dovrebbe arrivare in poco tempo, poi verrà aggiunto alla collezione della biblioteca.\n\nRiceverai un\'altra email quando sarà disponibile.\n\nSe hai domande, scrivici pure all\' email <<branches.branchemail>>\n\nGrazie di tutto,\n\n<<branches.branchname>>', 'email'),
27
('suggestions','REJECTED','Suggerimento d\'acquisto rifiutato', 'Suggerimento d\'acquisto rifiutato','Salve <<borrowers.firstname>> <<borrowers.surname>>,\n\nHai suggerito di acquistare <<suggestions.title>> di <<suggestions.author>>.\n\na biblioteca ha revisionato il suggerimento oggi e ha deciso di non seguire il suggerimento.\n\nLa motivazione è: <<suggestions.reason>>\n\nSe hai domande, scrivici pure all\' email <<branches.branchemail>>.\n\nGrazie di tuttp,\n\n<<branches.branchname>>', 'email'),
27
('suggestions','REJECTED','Suggerimento d\'acquisto rifiutato', 'Suggerimento d\'acquisto rifiutato','Salve <<borrowers.firstname>> <<borrowers.surname>>,\n\nHai suggerito di acquistare <<suggestions.title>> di <<suggestions.author>>.\n\na biblioteca ha revisionato il suggerimento oggi e ha deciso di non seguire il suggerimento.\n\nLa motivazione è: <<suggestions.reason>>\n\nSe hai domande, scrivici pure all\' email <<branches.branchemail>>.\n\nGrazie di tuttp,\n\n<<branches.branchname>>', 'email'),
28
('suggestions','TO_PROCESS','Notifica al proprietario del fondo', 'Un suggeerimento è pronto per essere lavorato','Caro bibliotecario <<borrowers.firstname>> <<borrowers.surname>>,\n\n c\'è un nuovo suggerimento pronto per essere lavorato: <<suggestions.title>> by <<suggestions.author>>.\n\n Grazie dell\'attenzione,\n\n<<branches.branchname>>', 'email'),
28
('suggestions','TO_PROCESS','Notifica al proprietario del fondo', 'Un suggeerimento è pronto per essere lavorato','Caro bibliotecario <<borrowers.firstname>> <<borrowers.surname>>,\n\n c\'è un nuovo suggerimento pronto per essere lavorato: <<suggestions.title>> by <<suggestions.author>>.\n\n Grazie dell\'attenzione,\n\n<<branches.branchname>>', 'email'),
29
('members', 'DISCHARGE', 'Liberatoria', 'Liberatoria per <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Liberatoria</h1>\r\n\r\nLa biblioteca  <<borrowers.branchcode>> certifica che il seguente utente :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Numero tessera : <<borrowers.cardnumber>>\r\n\r\nha restituito tutti i documenti ricevuti.', 'email');
29
('members', 'DISCHARGE', 'Liberatoria', 'Liberatoria per <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Liberatoria</h1>\r\n\r\nLa biblioteca  <<borrowers.branchcode>> certifica che il seguente utente :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Numero tessera:<<borrowers.cardnumber>>\r\n\r\nha restituito tutti i documenti ricevuti.', 'email');
30
30
31
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
31
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
32
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
32
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
33
<p><h4>Suggested by</h4>
33
<p><h4>Suggested by</h4>
34
 <ul>
34
 <ul>
35
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
35
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
Lines 38-57 VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> S Link Here
38
   <li><<borrowers.email>></li>
38
   <li><<borrowers.email>></li>
39
 </ul>
39
 </ul>
40
</p>
40
</p>
41
<p><h4>Item on suggestion</h4>
41
<p><h4>Title suggested</h4>
42
 <ul>
42
 <ul>
43
   <li><b>Library : </b> <<branches.branchname>></li>
43
   <li><b>Library:</b> <<branches.branchname>></li>
44
   <li><b>Title : </b> <<suggestions.title>></li>
44
   <li><b>Title:</b> <<suggestions.title>></li>
45
   <li><b>Author : </b> <<suggestions.author>></li>
45
   <li><b>Author:</b> <<suggestions.author>></li>
46
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
46
   <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
47
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
47
   <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
48
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
48
   <li><b>Publisher:</b> <<suggestions.publishercode>></li>
49
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
49
   <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
50
   <li><b>Publication place : </b> <<suggestions.place>></li>
50
   <li><b>Publication place:</b> <<suggestions.place>></li>
51
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
51
   <li><b>Quantity:</b> <<suggestions.quantity>></li>
52
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
52
   <li><b>Item type:</b>  <<suggestions.itemtype>></li>
53
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
53
   <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
54
   <li><b>Notes : </b> <<suggestions.note>></li>
54
   <li><b>Notes:</b> <<suggestions.note>></li>
55
 </ul>
55
 </ul>
56
</p>',1, 'email');
56
</p>',1, 'email');
57
57
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (-17 / +17 lines)
Lines 35-51 VALUES ('circulation','ODUE','Purring','Purring pÃ¥ dokument','<<borrowers.first Link Here
35
('reserves', 'HOLD', 'Hentemelding', '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', 'print'),
35
('reserves', 'HOLD', 'Hentemelding', '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', 'print'),
36
('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', 'email'),
36
('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', 'email'),
37
('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', 'email'),
37
('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', 'email'),
38
('reserves', 'HOLDPLACED', 'Melding om reservasjon', 'Melding om reservasjon','Følgende dokument har blitt reservert : <<biblio.title>> (<<biblio.biblionumber>>) av <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
38
('reserves', 'HOLDPLACED', 'Melding om reservasjon', 'Melding om reservasjon','Følgende dokument har blitt reservert:<<biblio.title>> (<<biblio.biblionumber>>) av <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
39
('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'),
39
('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'),
40
('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>>', 'email'),
40
('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>>', 'email'),
41
('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>>', 'email'),
41
('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>>', 'email'),
42
('suggestions','ORDERED','Innkjøpsforslag i bestilling', 'Innkjøpsforslag i bestilling','Dear <<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 du foreslo nå er i bestilling.\n\nDu vil få en ny melding når dokumentet er tilgjengelig.\n\nEr det noe du lurer på, vennligst kontakt oss på <<branches.branchemail>>.\n\nVennlig hilsen,\n\n<<branches.branchname>>', 'email'),
42
('suggestions','ORDERED','Innkjøpsforslag i bestilling', 'Innkjøpsforslag i bestilling','Dear <<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 du foreslo nå er i bestilling.\n\nDu vil få en ny melding når dokumentet er tilgjengelig.\n\nEr det noe du lurer på, vennligst kontakt oss på <<branches.branchemail>>.\n\nVennlig hilsen,\n\n<<branches.branchname>>', 'email'),
43
('suggestions','REJECTED','Innkjøpsforslag avslått', 'Innkjøpsforslag avslått','<<borrowers.firstname>> <<borrowers.surname>>,\n\nDu har foreslått at biblioteket kjøper inn <<suggestions.title>> av <<suggestions.author>>.\n\nBiblioteket har vurdert innkjøpsforslaget ditt i dag, og bestemt seg for å ikke ta det til følge.\n\nBegrunnelse: <<suggestions.reason>>\n\nEr det noe du lurer på, vennligst kontakt oss på <<branches.branchemail>>.\n\nVennlig hilsen,\n\n<<branches.branchname>>', 'email'),
43
('suggestions','REJECTED','Innkjøpsforslag avslått', 'Innkjøpsforslag avslått','<<borrowers.firstname>> <<borrowers.surname>>,\n\nDu har foreslått at biblioteket kjøper inn <<suggestions.title>> av <<suggestions.author>>.\n\nBiblioteket har vurdert innkjøpsforslaget ditt i dag, og bestemt seg for å ikke ta det til følge.\n\nBegrunnelse: <<suggestions.reason>>\n\nEr det noe du lurer på, vennligst kontakt oss på <<branches.branchemail>>.\n\nVennlig hilsen,\n\n<<branches.branchname>>', 'email'),
44
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
44
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA New suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
45
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
45
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber:<<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
46
46
47
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
47
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
48
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
48
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
49
<p><h4>Suggested by</h4>
49
<p><h4>Suggested by</h4>
50
 <ul>
50
 <ul>
51
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
51
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
Lines 54-73 VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> S Link Here
54
   <li><<borrowers.email>></li>
54
   <li><<borrowers.email>></li>
55
 </ul>
55
 </ul>
56
</p>
56
</p>
57
<p><h4>Item on suggestion</h4>
57
<p><h4>Title suggested</h4>
58
 <ul>
58
 <ul>
59
   <li><b>Library : </b> <<branches.branchname>></li>
59
   <li><b>Library:</b> <<branches.branchname>></li>
60
   <li><b>Title : </b> <<suggestions.title>></li>
60
   <li><b>Title:</b> <<suggestions.title>></li>
61
   <li><b>Author : </b> <<suggestions.author>></li>
61
   <li><b>Author:</b> <<suggestions.author>></li>
62
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
62
   <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
63
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
63
   <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
64
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
64
   <li><b>Publisher:</b> <<suggestions.publishercode>></li>
65
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
65
   <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
66
   <li><b>Publication place : </b> <<suggestions.place>></li>
66
   <li><b>Publication place:</b> <<suggestions.place>></li>
67
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
67
   <li><b>Quantity:</b> <<suggestions.quantity>></li>
68
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
68
   <li><b>Item type:</b>  <<suggestions.itemtype>></li>
69
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
69
   <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
70
   <li><b>Notes : </b> <<suggestions.note>></li>
70
   <li><b>Notes:</b> <<suggestions.note>></li>
71
 </ul>
71
 </ul>
72
</p>',1, 'email');
72
</p>',1, 'email');
73
73
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (-17 / +17 lines)
Lines 13-29 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
13
('reserves', 'HOLD', 'Hold Available for Pickup', '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', 'print'),
13
('reserves', 'HOLD', 'Hold Available for Pickup', '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', 'print'),
14
('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.', 'email'),
14
('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.', 'email'),
15
('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 [% branch.branchname %].', 'email'),
15
('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 [% branch.branchname %].', 'email'),
16
('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A hold has been placed on the following item : <<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
16
('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A hold has been placed on the following item:<<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
17
('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'),
17
('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'),
18
('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>>', 'email'),
18
('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>>', 'email'),
19
('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>>', 'email'),
19
('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>>', 'email'),
20
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','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 has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>', 'email'),
20
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','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 has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
22
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
22
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA New suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
23
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
23
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber:<<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
24
24
25
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
26
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
26
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
27
<p><h4>Suggested by</h4>
27
<p><h4>Suggested by</h4>
28
 <ul>
28
 <ul>
29
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
29
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
Lines 32-51 VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> S Link Here
32
   <li><<borrowers.email>></li>
32
   <li><<borrowers.email>></li>
33
 </ul>
33
 </ul>
34
</p>
34
</p>
35
<p><h4>Item on suggestion</h4>
35
<p><h4>Title suggested</h4>
36
 <ul>
36
 <ul>
37
   <li><b>Library : </b> <<branches.branchname>></li>
37
   <li><b>Library:</b> <<branches.branchname>></li>
38
   <li><b>Title : </b> <<suggestions.title>></li>
38
   <li><b>Title:</b> <<suggestions.title>></li>
39
   <li><b>Author : </b> <<suggestions.author>></li>
39
   <li><b>Author:</b> <<suggestions.author>></li>
40
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
40
   <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
41
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
41
   <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
42
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
42
   <li><b>Publisher:</b> <<suggestions.publishercode>></li>
43
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
43
   <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
44
   <li><b>Publication place : </b> <<suggestions.place>></li>
44
   <li><b>Publication place:</b> <<suggestions.place>></li>
45
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
45
   <li><b>Quantity:</b> <<suggestions.quantity>></li>
46
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
46
   <li><b>Item type:</b>  <<suggestions.itemtype>></li>
47
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
47
   <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
48
   <li><b>Notes : </b> <<suggestions.note>></li>
48
   <li><b>Notes:</b> <<suggestions.note>></li>
49
 </ul>
49
 </ul>
50
</p>',1, 'email');
50
</p>',1, 'email');
51
51
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (-17 / +17 lines)
Lines 12-28 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
12
('reserves', 'HOLD', 'Hold Available for Pickup', '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', 'print'),
12
('reserves', 'HOLD', 'Hold Available for Pickup', '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', 'print'),
13
('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.', 'email'),
13
('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.', 'email'),
14
('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 [% branch.branchname %].', 'email'),
14
('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 [% branch.branchname %].', 'email'),
15
('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A hold has been placed on the following item : <<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
15
('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A hold has been placed on the following item:<<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
16
('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'),
16
('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'),
17
('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>>', 'email'),
17
('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>>', 'email'),
18
('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>>', 'email'),
18
('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>>', 'email'),
19
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','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 has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>', 'email'),
19
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','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 has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>', 'email'),
20
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
20
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA New suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
22
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
22
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber:<<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
23
23
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
26
<p><h4>Suggested by</h4>
26
<p><h4>Suggested by</h4>
27
 <ul>
27
 <ul>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
Lines 31-50 VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> S Link Here
31
   <li><<borrowers.email>></li>
31
   <li><<borrowers.email>></li>
32
 </ul>
32
 </ul>
33
</p>
33
</p>
34
<p><h4>Item on suggestion</h4>
34
<p><h4>Title suggested</h4>
35
 <ul>
35
 <ul>
36
   <li><b>Library : </b> <<branches.branchname>></li>
36
   <li><b>Library:</b> <<branches.branchname>></li>
37
   <li><b>Title : </b> <<suggestions.title>></li>
37
   <li><b>Title:</b> <<suggestions.title>></li>
38
   <li><b>Author : </b> <<suggestions.author>></li>
38
   <li><b>Author:</b> <<suggestions.author>></li>
39
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
39
   <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
40
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
40
   <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
41
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
41
   <li><b>Publisher:</b> <<suggestions.publishercode>></li>
42
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
42
   <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
43
   <li><b>Publication place : </b> <<suggestions.place>></li>
43
   <li><b>Publication place:</b> <<suggestions.place>></li>
44
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
44
   <li><b>Quantity:</b> <<suggestions.quantity>></li>
45
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
45
   <li><b>Item type:</b>  <<suggestions.itemtype>></li>
46
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
46
   <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
47
   <li><b>Notes : </b> <<suggestions.note>></li>
47
   <li><b>Notes:</b> <<suggestions.note>></li>
48
 </ul>
48
 </ul>
49
</p>',1, 'email');
49
</p>',1, 'email');
50
50
(-)a/installer/data/mysql/sysprefs.sql (-2 / +2 lines)
Lines 157-165 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
157
('EasyAnalyticalRecords','0','','If on, display in the catalogue screens tools to easily setup analytical record relationships','YesNo'),
157
('EasyAnalyticalRecords','0','','If on, display in the catalogue screens tools to easily setup analytical record relationships','YesNo'),
158
('ElasticsearchIndexStatus_authorities', '0', 'Authorities index status', NULL, NULL),
158
('ElasticsearchIndexStatus_authorities', '0', 'Authorities index status', NULL, NULL),
159
('ElasticsearchIndexStatus_biblios', '0', 'Biblios index status', NULL, NULL),
159
('ElasticsearchIndexStatus_biblios', '0', 'Biblios index status', NULL, NULL),
160
('emailLibrarianWhenHoldIsPlaced','0',NULL,'If ON, emails the librarian whenever a hold is placed','YesNo'),
161
('EmailPurchaseSuggestions','KohaAdminEmailAddress','EmailAddressForSuggestions|BranchEmailAddress|KohaAdminEmailAddress','Choose email address that will be sent new purchase suggestions','Choice'),
162
('EmailAddressForSuggestions','','','If you choose EmailAddressForSuggestions you should enter a valid email address','free'),
160
('EmailAddressForSuggestions','','','If you choose EmailAddressForSuggestions you should enter a valid email address','free'),
161
('emailLibrarianWhenHoldIsPlaced','0',NULL,'If ON, emails the librarian whenever a hold is placed','YesNo'),
162
('EmailPurchaseSuggestions','KohaAdminEmailAddress','EmailAddressForSuggestions|BranchEmailAddress|KohaAdminEmailAddress','Choose email address that new purchase suggestions will be sent to','Choice'),
163
('EnableAdvancedCatalogingEditor','0','','Enable the Rancor advanced cataloging editor','YesNo'),
163
('EnableAdvancedCatalogingEditor','0','','Enable the Rancor advanced cataloging editor','YesNo'),
164
('EnableBorrowerFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to a borrower record.','YesNo'),
164
('EnableBorrowerFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to a borrower record.','YesNo'),
165
('EnableOpacSearchHistory','1','YesNo','Enable or disable opac search history',''),
165
('EnableOpacSearchHistory','1','YesNo','Enable or disable opac search history',''),
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-14 / +14 lines)
Lines 85-91 INSERT INTO `letter` (module, code, name, title, content, message_transport_type Link Here
85
;
85
;
86
86
87
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
87
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
88
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
88
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pending approval</h3>
89
<p><h4>Suggested by</h4>
89
<p><h4>Suggested by</h4>
90
 <ul>
90
 <ul>
91
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
91
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
Lines 94-113 VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> S Link Here
94
   <li><<borrowers.email>></li>
94
   <li><<borrowers.email>></li>
95
 </ul>
95
 </ul>
96
</p>
96
</p>
97
<p><h4>Item on suggestion</h4>
97
<p><h4>Title suggested</h4>
98
 <ul>
98
 <ul>
99
   <li><b>Library : </b> <<branches.branchname>></li>
99
   <li><b>Library:</b> <<branches.branchname>></li>
100
   <li><b>Title : </b> <<suggestions.title>></li>
100
   <li><b>Title:</b> <<suggestions.title>></li>
101
   <li><b>Author : </b> <<suggestions.author>></li>
101
   <li><b>Author:</b> <<suggestions.author>></li>
102
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
102
   <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
103
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
103
   <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
104
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
104
   <li><b>Publisher:</b> <<suggestions.publishercode>></li>
105
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
105
   <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
106
   <li><b>Publication place : </b> <<suggestions.place>></li>
106
   <li><b>Publication place:</b> <<suggestions.place>></li>
107
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
107
   <li><b>Quantity:</b> <<suggestions.quantity>></li>
108
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
108
   <li><b>Item type:</b>  <<suggestions.itemtype>></li>
109
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
109
   <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
110
   <li><b>Notes : </b> <<suggestions.note>></li>
110
   <li><b>Notes:</b> <<suggestions.note>></li>
111
 </ul>
111
 </ul>
112
</p>',1, 'email');
112
</p>',1, 'email');
113
113
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref (-3 / +2 lines)
Lines 7-20 Administration: Link Here
7
              class: email
7
              class: email
8
            - "(This is the default From: address for emails unless there is one for the particular library, and is referred to when an internal error occurs.)"
8
            - "(This is the default From: address for emails unless there is one for the particular library, and is referred to when an internal error occurs.)"
9
        -
9
        -
10
            - "Choose email address that will be sent new purchase suggestions : "
10
            - "Choose email address that new purchase suggestions will be sent to: "
11
            - pref:   EmailPurchaseSuggestions
11
            - pref:   EmailPurchaseSuggestions
12
              default: KohaAdminEmailAddress
12
              default: KohaAdminEmailAddress
13
              choices:
13
              choices:
14
                  EmailAddressForSuggestions: EmailAddressForSuggestions
14
                  EmailAddressForSuggestions: EmailAddressForSuggestions
15
                  BranchEmailAddress: email address of branch
15
                  BranchEmailAddress: email address of branch
16
                  KohaAdminEmailAddress: KohaAdminEmailAddress
16
                  KohaAdminEmailAddress: KohaAdminEmailAddress
17
            - "If you choose EmailAddressForSuggestions you should enter a valid email address : "
17
            - "If you choose EmailAddressForSuggestions you have to enter a valid email address: "
18
            - pref: EmailAddressForSuggestions
18
            - pref: EmailAddressForSuggestions
19
              class: email
19
              class: email
20
        -
20
        -
21
- 

Return to bug 5770