Example #1
0
 /**
  * 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;
 }