/** * Retrieve Published Article by pub id * @param $publishedArticleId int * @param $simple boolean Whether or not to skip fetching dependent objects; default false * @return PublishedArticle object */ function &getPublishedArticleById($publishedArticleId, $simple = false) { $result =& $this->retrieve('SELECT * FROM published_articles WHERE published_article_id = ?', (int) $publishedArticleId); $row = $result->GetRowAssoc(false); $publishedArticle = new PublishedArticle(); $publishedArticle->setPublishedArticleId($row['published_article_id']); $publishedArticle->setId($row['article_id']); $publishedArticle->setIssueId($row['issue_id']); $publishedArticle->setDatePublished($this->datetimeFromDB($row['date_published'])); $publishedArticle->setSeq($row['seq']); $publishedArticle->setAccessStatus($row['access_status']); if (!$simple) { $publishedArticle->setSuppFiles($this->suppFileDao->getSuppFilesByArticle($row['article_id'])); } $result->Close(); unset($result); return $publishedArticle; }