function getBySubmissionId($submissionId, $contextId = null)
{
$params = array((int) $submissionId);
if ($contextId) {
$params[] = (int) $contextId;
}
return new DAOResultFactory($this->retrieve('SELECT sf.*, g.*
FROM submission_galleys g
' . ($contextId ? 'INNER JOIN submissions s ON (g.submission_id = s.submission_id) ' : '') . '
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = ?
AND nsf.file_id IS NULL
' . ($contextId ? ' AND s.context_id = ? ' : '') . '
ORDER BY g.seq', $params), $this, '_fromRow');
}