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 |
- |
|
|