[Koha-patches] [PATCH] bug 2434 remove upcoming events messages

[Nicole Engard]

So sorry - I didn't update all of the languages, so this patch should
also be ignored - the final corrected one is on its way ... sorry
again!

----------------------------------------------
Nicole C. Engard
Director of Open Source Education
ByWater Solutions
nengard at bywatersolutions.com
http://bywatersolutions.com

See us at ALA : BOOTH # 817



On Wed, Jun 2, 2010 at 7:58 AM, Nicole Engard
<nengard at bywatersolutions.com> wrote:
> this patch removed the template for the upcoming events
> message and the upcoming events message from the options
> for enhanced messages because this messaging preference
> has not been implemented
> ---
>  .../data/mysql/en/mandatory/sample_notices.sql     |    4 +---
>  .../optional/sample_notices_message_attributes.sql |    1 -
>  .../mysql/fr-FR/1-Obligatoire/sample_notices.sql   |    1 -
>  .../sample_notices_message_attributes.sql          |    1 -
>  installer/data/mysql/updatedatabase.pl             |    8 ++++++++
>  5 files changed, 9 insertions(+), 6 deletions(-)
>
> diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql
> index 66947f2..64e2564 100644
> --- a/installer/data/mysql/en/mandatory/sample_notices.sql
> +++ b/installer/data/mysql/en/mandatory/sample_notices.sql
> @@ -5,10 +5,8 @@ VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f
>  ('members','ACCTDETAILS','Account Details Template - DEFAULT','Your new Koha account details.','Hello <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>.\r\n\r\nYour new Koha account details are:\r\n\r\nUser:  <<borrowers.userid>>\r\nPassword: <<borrowers.password>>\r\n\r\nIf you have any problems or questions regarding your account, please contact your Koha Administrator.\r\n\r\nThank you,\r\nKoha Administrator\r\nkohaadmin at yoursite.org'),
>  ('circulation','DUE','Item Due Reminder','Item Due Reminder','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item is now due:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'),
>  ('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You have <<count>> items due'),
> -('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','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'),
> -('circulation','EVENT','Upcoming Library Event','Upcoming Library Event','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThis is a reminder of an upcoming library event in which you have expressed interest.'),
>  ('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for Pickup at <<branches.branchname>>', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYou have a hold available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: <<items.copynumber>>\r\nLocation: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>'),
>  ('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', 'Hold Available for Pickup (print notice)', '<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nChange Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> <<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nYou have a hold available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: <<items.copynumber>>\r\n'),
>  ('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
> diff --git a/installer/data/mysql/en/optional/sample_notices_message_attributes.sql b/installer/data/mysql/en/optional/sample_notices_message_attributes.sql
> index 5d1ecb6..1834063 100644
> --- a/installer/data/mysql/en/optional/sample_notices_message_attributes.sql
> +++ b/installer/data/mysql/en/optional/sample_notices_message_attributes.sql
> @@ -3,7 +3,6 @@ insert into `message_attributes`
>  values
>  (1, 'Item DUE', 0),
>  (2, 'Advance Notice', 1),
> -(3, 'Upcoming Events', 1),
>  (4, 'Hold Filled', 0),
>  (5, 'Item Check-in', 0),
>  (6, 'Item Checkout', 0);
> 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 023df9b..80f3ea3 100644
> --- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
> +++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
> @@ -9,7 +9,6 @@ VALUES
>  ('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You have <<count>> items due'),
>  ('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'),
> -('circulation','EVENT','Upcoming Library Event','Upcoming Library Event','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThis is a reminder of an upcoming library event in which you have expressed interest.'),
>  ('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'),
>  ('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.'),
> diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
> index 5d1ecb6..1834063 100644
> --- a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
> +++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
> @@ -3,7 +3,6 @@ insert into `message_attributes`
>  values
>  (1, 'Item DUE', 0),
>  (2, 'Advance Notice', 1),
> -(3, 'Upcoming Events', 1),
>  (4, 'Hold Filled', 0),
>  (5, 'Item Check-in', 0),
>  (6, 'Item Checkout', 0);
> diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
> index 1d90656..4787d3e 100755
> --- a/installer/data/mysql/updatedatabase.pl
> +++ b/installer/data/mysql/updatedatabase.pl
> @@ -3624,6 +3624,14 @@ INSERT INTO permissions (module_bit, code, description) VALUES
>     SetVersion ($DBversion);
>  }
>
> +$DBversion = 'XXX';
> +if (C4::Context->preference('Version') < TransformToNum($DBversion)){
> +    $dbh->do(qq{DELETE FROM message_attributes WHERE message_attribute_id=3;});
> +    $dbh->do(qq{DELETE FROM letter WHERE code='EVENT' AND title='Upcoming Library Event';});
> +    print "Upgrade to $DBversion done Remove upcoming events messaging option (bug 2434)";
> +    SetVersion ($DBversion);
> +}
> +
>
>  =item DropAllForeignKeys($table)
>
> --
> 1.5.6.5
>
>