ArticleGalleyDAO::getBySubmissionId PHP Method

getBySubmissionId() public method

public getBySubmissionId ( $submissionId, $contextId = null )
    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');
    }

Usage Example

Beispiel #1
0
 /**
  * creates and returns a published article object from a row
  * @param $row array
  * @param $callHooks boolean Whether or not to call hooks
  * @return PublishedArticle object
  */
 function _fromRow($row, $callHooks = true)
 {
     $publishedArticle = parent::_fromRow($row);
     $publishedArticle->setPublishedArticleId($row['published_submission_id']);
     $publishedArticle->setIssueId($row['issue_id']);
     $publishedArticle->setSequence($row['seq']);
     $publishedArticle->setAccessStatus($row['access_status']);
     $publishedArticle->setGalleys($this->galleyDao->getBySubmissionId($row['submission_id'])->toArray());
     if ($callHooks) {
         HookRegistry::call('PublishedArticleDAO::_returnPublishedArticleFromRow', array(&$publishedArticle, &$row));
     }
     return $publishedArticle;
 }