/**
* @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 showSchool()
{
return $this->html($this->publication->getSchool());
}
/**
* @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;
}
