[Koha-bugs] [Bug 9016] Multi transport types for notices

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9016

--- Comment #1 from Jonathan Druart <jonathan.druart at biblibre.com> ---
Created attachment 13276
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=13276&action=edit
Bug 9016: Multi transport types for notices

The goal of the patch:
This patch allows to choose one (or more) message transport type for one
overdue. Currently it is just possible to choose a letter.
To prevent too many letters, we create an association table between
overduerules and message_transport_types and change the primary key for
the letter table.
Like this, we are able to have an unique letter code for several
transport types.
The idea of this patch is to have a sms driver to send messages with a
transport type defined as "sms".

This patch:
- adds a new jquery plugin : insertatcaret
- adds datatable on the tools/letter.pl page
- adds a new column letter.message_transport_type
- adds a new table overduerules_transport_types : association table
  between overduerules and message_transport_types.
- modifies the primary key for the letter table (become module, code,
  branchcode, message_transport_type)
- rewrites a big part of the tools/overduerules.tt code

The migration problem:
A new updatedatabase entry changes the DB structures changes and set all
the letter.message_transport_type to 'email'. The email type is the
default type everywhere in the code.

To test:
1/ Check that all your previous overdue rules are preserved
2/ Check that the tables on the tools/overduerules.pl page are filled with the
email transport type (default type).
3/ On the tools/letters.pl check that your previous letters still exist.
4/ Now check the features :) The patch allows you to sent letters to the
queue with an email or sms format.
So try to create letters with 1 or both of these transport types and
check the corresponding checkbox on the overdues management page.
Play with the script misc/cronjobs/overdue_notices.pl in order to see
yours notices in the message_queue table.

-- 
You are receiving this mail because:
You are watching all bug changes.