@@ -, +, @@
C4::Letters::getletter
leave 'Library' and 'Koha module' options as default selections.
Enter 'KOHA_14206' and 'Koha Test 14206' against Code and Name
respectively, and 'Test' and 'Test Message' for subject and body.
Leave the Email, Phone and SMS tabs blank. Save the notice.
delete it. It will load the 'Delete notice' dialog form, but the
table will not show any data under
s - 'Library', 'Module',
'Code' or 'Name'.
Notices listing reloaded. The print-only KOHA_14206 notice should
continue to exist. This is *wrong*.
KOHA_14206. This time, it should show the data under 'Module',
'Code' or 'Name' at least.
reload. This time KOHA_14206 will be gone.
to check actual deletion from the database. No record should be
returned.
email, phone and sms delivery options.
be shown in the listing. Confirm deletion by running step #7.
No record should be returned.
---
C4/Letters.pm | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
--- a/C4/Letters.pm
+++ a/C4/Letters.pm
@@ -226,7 +226,8 @@ sub getletter {
my $sth = $dbh->prepare(q{
SELECT *
FROM letter
- WHERE module=? AND code=? AND (branchcode = ? OR branchcode = '') AND message_transport_type = ?
+ WHERE module=? AND code=? AND (branchcode = ? OR branchcode = '')
+ AND (message_transport_type = ? OR message_transport_type IN (SELECT message_transport_type FROM message_transport_types))
ORDER BY branchcode DESC LIMIT 1
});
$sth->execute( $module, $code, $branchcode, $message_transport_type );
--
|