/** * Retrieve Published Paper by pub id * @param $pubId int * @return PublishedPaper object */ function &getPublishedPaperById($pubId) { $result =& $this->retrieve('SELECT * FROM published_papers WHERE pub_id = ?', $pubId); $row = $result->GetRowAssoc(false); $publishedPaper = new PublishedPaper(); $publishedPaper->setPubId($row['pub_id']); $publishedPaper->setId($row['paper_id']); $publishedPaper->setSchedConfId($row['sched_conf_id']); $publishedPaper->setDatePublished($this->datetimeFromDB($row['date_published'])); $publishedPaper->setSeq($row['seq']); $publishedPaper->setViews($row['views']); $publishedPaper->setRoomId($row['room_id']); $publishedPaper->setSuppFiles($this->suppFileDao->getSuppFilesByPaper($row['paper_id'])); $result->Close(); unset($result); return $publishedPaper; }