classes/paper/AuthorDAO.inc.php

Go to the documentation of this file.

<?php

//$Id$

import('paper.Author');
import('paper.Paper');

class AuthorDAO extends DAO {
   function &getAuthor($authorId) {
      $result =& $this->retrieve(
         'SELECT * FROM paper_authors WHERE author_id = ?', $authorId
      );

      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner =& $this->_returnAuthorFromRow($result->GetRowAssoc(false));
      }

      $result->Close();
      unset($result);

      return $returner;
   }

   function &getAuthorsByPaper($paperId) {
      $authors = array();

      $result =& $this->retrieve(
         'SELECT * FROM paper_authors WHERE paper_id = ? ORDER BY seq',
         $paperId
      );

      while (!$result->EOF) {
         $authors[] =& $this->_returnAuthorFromRow($result->GetRowAssoc(false));
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $authors;
   }

   function &getPublishedPapersForAuthor($schedConfId, $firstName, $middleName, $lastName, $affiliation, $country) {
      $publishedPapers = array();
      $publishedPaperDao =& DAORegistry::getDAO('PublishedPaperDAO');
      $params = array($firstName, $middleName, $lastName, $affiliation, $country);
      if ($schedConfId !== null) $params[] = $schedConfId;

      $result =& $this->retrieve(
         'SELECT DISTINCT
            aa.paper_id
         FROM paper_authors aa
            LEFT JOIN papers a ON (aa.paper_id = a.paper_id)
         WHERE aa.first_name = ? AND
            a.status = ' . STATUS_PUBLISHED . ' AND
            (aa.middle_name = ?' . (empty($middleName)?' OR aa.middle_name IS NULL':'') .  ') AND
            aa.last_name = ? AND
            (aa.affiliation = ?' . (empty($affiliation)?' OR aa.affiliation IS NULL':'') . ') AND
            (aa.country = ?' . (empty($country)?' OR aa.country IS NULL':'') . ')' .
            ($schedConfId!==null?(' AND a.sched_conf_id = ?'):''),
         $params
      );

      while (!$result->EOF) {
         $row =& $result->getRowAssoc(false);
         $publishedPaper =& $publishedPaperDao->getPublishedPaperByPaperId($row['paper_id']);
         if ($publishedPaper) {
            $publishedPapers[] =& $publishedPaper;
         }
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $publishedPapers;
   }

   function &getAuthorsAlphabetizedBySchedConf($schedConfId = null, $initial = null, $rangeInfo = null, $includeEmail = false) {
      $params = array();

      if (isset($schedConfId)) $params[] = $schedConfId;
      if (isset($initial)) {
         $params[] = String::strtolower($initial) . '%';
         $initialSql = ' AND LOWER(aa.last_name) LIKE LOWER(?)';
      } else {
         $initialSql = '';
      }

      $result =& $this->retrieveRange(
         'SELECT  DISTINCT CAST(\'\' AS CHAR) AS url,
            0 AS author_id,
            0 AS paper_id,
            ' . ($includeEmail?'aa.email AS email,':'CAST(\'\' AS CHAR) AS email,') . '
            0 AS primary_contact,
            0 AS seq,
            aa.first_name AS first_name,
            aa.middle_name AS middle_name,
            aa.last_name AS last_name,
            aa.affiliation AS affiliation,
            aa.country FROM paper_authors aa,
            papers a,
            published_papers pa,
            sched_confs e
         WHERE e.sched_conf_id = pa.sched_conf_id
            AND aa.paper_id = a.paper_id
            ' . (isset($schedConfId)?'AND a.sched_conf_id = ? ':'') . '
            AND pa.paper_id = a.paper_id
            AND a.status = ' . STATUS_PUBLISHED . '
            AND (aa.last_name IS NOT NULL
            AND aa.last_name <> \'\')' . $initialSql . ' ORDER BY aa.last_name, aa.first_name',
         empty($params)?false:$params,
         $rangeInfo
      );

      $returner = new DAOResultFactory($result, $this, '_returnAuthorFromRow');
      return $returner;
   }

   function &getAuthorIdsByPaper($paperId) {
      $authors = array();

      $result =& $this->retrieve(
         'SELECT author_id FROM paper_authors WHERE paper_id = ? ORDER BY seq',
         $paperId
      );

      while (!$result->EOF) {
         $authors[] = $result->fields[0];
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $authors;
   }

   function getLocaleFieldNames() {
      return array('biography');
   }

   function updateLocaleFields(&$author) {
      $this->updateDataObjectSettings('paper_author_settings', $author, array(
         'author_id' => $author->getId()
      ));

   }

   function &_returnAuthorFromRow(&$row) {
      $author = new Author();
      $author->setId($row['author_id']);
      $author->setPaperId($row['paper_id']);
      $author->setFirstName($row['first_name']);
      $author->setMiddleName($row['middle_name']);
      $author->setLastName($row['last_name']);
      $author->setAffiliation($row['affiliation']);
      $author->setCountry($row['country']);
      $author->setEmail($row['email']);
      $author->setUrl($row['url']);
      $author->setPrimaryContact($row['primary_contact']);
      $author->setSequence($row['seq']);

      $this->getDataObjectSettings('paper_author_settings', 'author_id', $row['author_id'], $author);

      HookRegistry::call('AuthorDAO::_returnAuthorFromRow', array(&$author, &$row));

      return $author;
   }

   function insertAuthor(&$author) {
      $this->update(
         'INSERT INTO paper_authors
            (paper_id, first_name, middle_name, last_name, affiliation, country, email, url, primary_contact, seq)
            VALUES
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)',
         array(
            $author->getPaperId(),
            $author->getFirstName(),
            $author->getMiddleName() . '', // make non-null
            $author->getLastName(),
            $author->getAffiliation() . '', // make non-null
            $author->getCountry(),
            $author->getEmail(),
            $author->getUrl(),
            (int) $author->getPrimaryContact(),
            (float) $author->getSequence()
         )
      );

      $author->setId($this->getInsertAuthorId());
      $this->updateLocaleFields($author);

      return $author->getId();
   }

   function updateAuthor(&$author) {
      $returner = $this->update(
         'UPDATE paper_authors
            SET
               first_name = ?,
               middle_name = ?,
               last_name = ?,
               affiliation = ?,
               country = ?,
               email = ?,
               url = ?,
               primary_contact = ?,
               seq = ?
            WHERE author_id = ?',
         array(
            $author->getFirstName(),
            $author->getMiddleName() . '', // make non-null
            $author->getLastName(),
            $author->getAffiliation() . '', // make non-null
            $author->getCountry(),
            $author->getEmail(),
            $author->getUrl(),
            $author->getPrimaryContact(),
            $author->getSequence(),
            $author->getId()
         )
      );
      $this->updateLocaleFields($author);
      return $returner;
   }

   function deleteAuthor(&$author) {
      return $this->deleteAuthorById($author->getId());
   }

   function deleteAuthorById($authorId, $paperId = null) {
      $params = array($authorId);
      if ($paperId) $params[] = $paperId;
      $returner = $this->update(
         'DELETE FROM paper_authors WHERE author_id = ?' .
         ($paperId?' AND paper_id = ?':''),
         $params
      );
      if ($returner) $this->update('DELETE FROM paper_author_settings WHERE author_id = ?', array($authorId));
   }

   function deleteAuthorsByPaper($paperId) {
      $authors =& $this->getAuthorsByPaper($paperId);
      foreach ($authors as $author) {
         $this->deleteAuthor($author);
      }
   }

   function resequenceAuthors($paperId) {
      $result =& $this->retrieve(
         'SELECT author_id FROM paper_authors WHERE paper_id = ? ORDER BY seq', $paperId
      );

      for ($i=1; !$result->EOF; $i++) {
         list($authorId) = $result->fields;
         $this->update(
            'UPDATE paper_authors SET seq = ? WHERE author_id = ?',
            array(
               $i,
               $authorId
            )
         );

         $result->moveNext();
      }

      $result->close();
      unset($result);
   }

   function getInsertAuthorId() {
      return $this->getInsertId('paper_authors', 'author_id');
   }
}

?>

---