|
Lines 225-233
sub getletter {
Link Here
|
| 225 |
my $dbh = C4::Context->dbh; |
225 |
my $dbh = C4::Context->dbh; |
| 226 |
my $sth = $dbh->prepare(q{ |
226 |
my $sth = $dbh->prepare(q{ |
| 227 |
SELECT * |
227 |
SELECT * |
| 228 |
FROM letter |
228 |
FROM letter |
| 229 |
WHERE module=? AND code=? AND (branchcode = ? OR branchcode = '') |
229 |
WHERE module=? AND code=? AND (branchcode = ? OR branchcode = '') |
| 230 |
AND (message_transport_type = ? OR message_transport_type IN (SELECT message_transport_type FROM message_transport_types)) |
230 |
AND message_transport_type = ? |
| 231 |
ORDER BY branchcode DESC LIMIT 1 |
231 |
ORDER BY branchcode DESC LIMIT 1 |
| 232 |
}); |
232 |
}); |
| 233 |
$sth->execute( $module, $code, $branchcode, $message_transport_type ); |
233 |
$sth->execute( $module, $code, $branchcode, $message_transport_type ); |
| 234 |
- |
|
|