[Koha-patches] [PATCH] [SIGNED-OFF] bug #6053 Improvement of letter HOLD_PRINT

[Stéphane Delaune]

 From b6d48a1c43d3c9b2c514147a1479b3e753501e17 Mon Sep 17 00:00:00 2001
From: Sophie Meynieux <sophie.meynieux at biblibre.com>
Date: Tue, 5 Apr 2011 11:31:00 +0200
Subject: [PATCH] bug #6053 Improvement of letter HOLD_PRINT
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Modify title template for letter HOLD_PRINT in installer sample data

Signed-off-by: Stéphane Delaune <stephane.delaune at biblibre.com>
---
  .../mysql/fr-FR/1-Obligatoire/sample_notices.sql   |    4 ++--
  1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql 
b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
index 2b766a8..977e59d 100644
--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
@@ -1,4 +1,4 @@
-INSERT INTO `letter`
+INSERT IGNORE INTO `letter`
  (module, code, name, title, content)
  VALUES
  ('circulation','ODUE','Overdue Notice','Item Overdue','Dear 
<<borrowers.firstname>> <<borrowers.surname>>,\n\nAccording to our 
current records, you have items that are overdue.Your library does not 
charge late fines, but please return or renew them at the branch below 
as soon as 
possible.\n\n<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> 
<<branches.branchaddress3>>\nPhone: <<branches.branchphone>>\nFax: 
<<branches.branchfax>>\nEmail: <<branches.branchemail>>\n\nIf you have 
registered a password with the library, and you have a renewal 
available, you may renew online. If an item becomes more than 30 days 
overdue, you will be unable to use your library card until the item is 
returned.\n\nThe following item(s) is/are currently 
overdue:\n\n<item>"<<biblio.title>>" by <<biblio.author>>, 
<<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: 
<fine>GBP</fine></item>\n\nThank-you for your prompt attention to this 
matter.\n\n<<branches.branchname>> Staff\n'),
@@ -10,7 +10,7 @@ VALUES
  ('circulation','PREDUE','Advance Notice of Item Due','Advance Notice 
of Item Due','Dear <<borrowers.firstname>> 
<<borrowers.surname>>,\r\n\r\nThe following item will be due 
soon:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'),
  ('circulation','PREDUEDGST','Advance Notice of Item Due 
(Digest)','Advance Notice of Item Due','You have <<count>> items due soon'),
  ('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for 
Pickup at <<branches.branchname>>', 'Dear <<borrowers.firstname>> 
<<borrowers.surname>>,\r\n\r\nYou have a hold available for pickup as of 
<<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: 
<<biblio.author>>\r\nCopy: <<items.copynumber>>\r\nLocation: 
<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>'),
-('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', 
'Hold Available for Pickup (print notice)', 
'<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nChange 
Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> 
<<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> 
<<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> 
<<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nYou have a hold 
available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: 
<<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: 
<<items.copynumber>>\r\n'),
+('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', 
'Hold Available for Pickup at <<branches.branchname>>', 
'<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>>\n\n\nChange 
Service Requested\n\n\n\n\n\n\n\n<<borrowers.firstname>> 
<<borrowers.surname>>\n<<borrowers.address>>\n<<borrowers.city>> 
<<borrowers.zipcode>>\n\n\n\n\n\n\n\n\n\n\n<<borrowers.firstname>> 
<<borrowers.surname>> <<borrowers.cardnumber>>\n\nYou have a hold 
available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: 
<<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: 
<<items.copynumber>>\r\n'),
  ('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The 
following items have been checked 
in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
  ('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The 
following items have been checked 
out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting 
<<branches.branchname>>.'),
  ('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on 
Item','A hold has been placed on the following item : <<title>> 
(<<biblionumber>>) by the user <<firstname>> <<surname>> 
(<<cardnumber>>).'),
-- 
1.7.0.4

-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0001-bug-6053-Improvement-of-letter-HOLD_PRINT.patch.zip
Type: application/zip
Size: 1712 bytes
Desc: not available
URL: </pipermail/koha-patches/attachments/20110407/733bc2ff/attachment.zip>