View | Details | Raw Unified | Return to bug 14206
Collapse All | Expand All

(-)a/C4/Letters.pm (-2 / +1 lines)
Lines 227-233 sub getletter { Link Here
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 = ?
230
        AND ( message_transport_type = ? OR message_transport_type IN (SELECT message_transport_type FROM message_transport_types))
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
- 

Return to bug 14206