/** * @param Publication $publication * * @return array */ private function createFields(Publication $publication) { $fields = array(); foreach ($publication->getAuthors() as $author) { if ($author->getFirstName() && $author->getLastName()) { $fields[] = array('author', $author->getFirstName() . ' ' . $author->getLastName()); } } $fields[] = array('title', $publication->getTitle()); $fields[] = array('journal', $publication->getJournal()); $fields[] = array('booktitle', $publication->getBooktitle()); $fields[] = array('volume', $publication->getVolume()); $fields[] = array('number', $publication->getNumber()); $fields[] = array('series', $publication->getSeries()); $fields[] = array('edition', $publication->getEdition()); $fields[] = array('pages', $publication->getPages('--')); $fields[] = array('month', $publication->getDatePublished('F')); $fields[] = array('year', $publication->getDatePublished('Y')); $file = $publication->getFullTextFile(); if ($file) { $fields[] = array('url', Request::createUrl(array('p' => 'publication', 'id' => $publication->getId(), 'file_id' => $file->getId()), true)); } //$fields[] = array('issn', false); // TODO $fields[] = array('isbn', $publication->getIsbn()); $fields[] = array('institution', $publication->getInstitution()); $fields[] = array('school', $publication->getSchool()); $fields[] = array('publisher', $publication->getPublisher()); $fields[] = array('ee', $publication->getDoi()); $fields[] = array('address', $publication->getAddress()); $fields[] = array('howpublished', $publication->getHowpublished()); $fields[] = array('note', $publication->getNote()); $fields[] = array('abstract', $publication->getAbstract()); $fields[] = array('biburl', Request::createUrl(array('p' => 'publication', 'id' => $publication->getId()), true)); return $fields; }
/** * @param Publication $publication * * @return string * @throws exceptions\DBDuplicateEntryException * @throws exceptions\DBForeignKeyException */ public function store(Publication $publication) { if ($publication->getTypeId()) { $type_id = $publication->getTypeId(); } else { $repo = new TypeRepository($this->db); $type = $repo->where('name', '=', $publication->getTypeName())->findSingle(); $type_id = $type->getId(); } if ($publication->getStudyFieldId()) { $study_field_id = $publication->getStudyFieldId(); } else { $repo = new StudyFieldRepository($this->db); $type = $repo->where('name', '=', $publication->getStudyField())->findSingle(); $study_field_id = $type->getId(); } $query = 'INSERT INTO publications (type_id, study_field_id, title, date_published, booktitle, journal, volume, number, pages_from, pages_to, series, edition, note, location, publisher, institution, school, address, isbn, doi, howpublished, abstract, copyright, `foreign`) VALUES (:type_id, :study_field_id, :title, :date_published, :booktitle, :journal, :volume, :number, :pages_from, :pages_to, :series, :edition, :note, :location, :publisher, :institution, :school, :address, :isbn, :doi, :howpublished, :abstract, :copyright, :foreign);'; $this->db->prepare($query); $this->db->bindValue(':type_id', $type_id); $this->db->bindValue(':study_field_id', $study_field_id); $this->db->bindValue(':title', $publication->getTitle()); $this->db->bindValue(':date_published', $publication->getDatePublished()); $this->db->bindValue(':booktitle', $publication->getBooktitle()); $this->db->bindValue(':journal', $publication->getJournal()); $this->db->bindValue(':volume', $publication->getVolume()); $this->db->bindValue(':number', $publication->getNumber()); $this->db->bindValue(':pages_from', $publication->getFirstPage()); $this->db->bindValue(':pages_to', $publication->getLastPage()); $this->db->bindValue(':series', $publication->getSeries()); $this->db->bindValue(':edition', $publication->getEdition()); $this->db->bindValue(':note', $publication->getNote()); $this->db->bindValue(':location', $publication->getLocation()); $this->db->bindValue(':publisher', $publication->getPublisher()); $this->db->bindValue(':institution', $publication->getInstitution()); $this->db->bindValue(':school', $publication->getSchool()); $this->db->bindValue(':address', $publication->getAddress()); $this->db->bindValue(':isbn', $publication->getIsbn()); $this->db->bindValue(':doi', $publication->getDoi()); $this->db->bindValue(':howpublished', $publication->getHowpublished()); $this->db->bindValue(':abstract', $publication->getAbstract()); $this->db->bindValue(':copyright', $publication->getCopyright()); $this->db->bindValue(':foreign', $publication->getForeign()); $this->db->execute(); return $this->db->lastInsertId(); }
/** * @return string */ public function showHowpublished() { return $this->html($this->publication->getHowpublished()); }
/** * @param Publication $publication * * @return string * @throws Exception */ public function export(Publication $publication) { if (!$publication->getTypeName()) { throw new Exception('publication type missing'); } $authors = ''; foreach ($publication->getAuthors() as $author) { if ($author->getFirstName() && $author->getLastName()) { $authors .= $author->getFirstName() . ' ' . $author->getLastName() . ' and '; } } $authors = substr($authors, 0, -5); $keywords = ''; foreach ($publication->getKeywords() as $keyword) { if ($keyword->getName()) { $keywords .= $keyword->getName() . ', '; } } $keywords = substr($keywords, 0, -2); $fields = array(); $fields[] = array('author', $authors); $fields[] = array('title', $publication->getTitle()); $fields[] = array('journal', $publication->getJournal()); $fields[] = array('volume', $publication->getVolume()); $fields[] = array('number', $publication->getNumber()); $fields[] = array('booktitle', $publication->getBooktitle()); $fields[] = array('series', $publication->getSeries()); $fields[] = array('edition', $publication->getEdition()); $fields[] = array('pages', $publication->getPages('--')); $fields[] = array('note', $publication->getNote()); $fields[] = array('location', $publication->getLocation()); $fields[] = array('month', $publication->getDatePublished('F')); $fields[] = array('year', $publication->getDatePublished('Y')); $file = $publication->getFullTextFile(); $urls = $publication->getUrls(); if ($file) { $fields[] = array('url', Request::createUrl(array('p' => 'publication', 'id' => $publication->getId(), 'file_id' => $file->getId()), true)); } else { if ($urls && isset($urls[0])) { $fields[] = array('url', $urls[0]); } } //$fields[] = array('issn', false); $fields[] = array('publisher', $publication->getPublisher()); $fields[] = array('institution', $publication->getInstitution()); $fields[] = array('school', $publication->getSchool()); $fields[] = array('address', $publication->getAddress()); $fields[] = array('howpublished', $publication->getHowpublished()); $fields[] = array('copyright', $publication->getCopyright()); $fields[] = array('doi', $publication->getDoi()); $fields[] = array('isbn', $publication->getIsbn()); $fields[] = array('abstract', $publication->getAbstract()); $fields[] = array('biburl', Request::createUrl(array('p' => 'publication', 'id' => $publication->getId()), true)); $fields[] = array('keywords', $keywords); $result = '@' . $publication->getTypeName() . '{' . $this->generateCiteKey($publication); foreach ($fields as $field) { if ($field[1]) { $result .= ',' . "\n\t" . $field[0] . ' = {' . $this->encodeSpecialChars($field[1]) . '}'; } } $result .= "\n" . '}'; return $result; }