classes/journal/SectionEditorsDAO.inc.php

<?php

// $Id: SectionEditorsDAO.inc.php,v 1.13 2008/07/01 01:16:10 asmecher Exp $


class SectionEditorsDAO extends DAO {
   function insertEditor($journalId, $sectionId, $userId, $canReview, $canEdit) {
      return $this->update(
         'INSERT INTO section_editors
            (journal_id, section_id, user_id, can_review, can_edit)
            VALUES
            (?, ?, ?, ?, ?)',
         array(
            $journalId,
            $sectionId,
            $userId,
            $canReview?1:0,
            $canEdit?1:0
         )
      );
   }

   function deleteEditor($journalId, $sectionId, $userId) {
      return $this->update(
         'DELETE FROM section_editors WHERE journal_id = ? AND section_id = ? AND user_id = ?',
         array(
            $journalId,
            $sectionId,
            $userId
         )
      );
   }

   function &getEditorsBySectionId($journalId, $sectionId) {
      $users = array();

      $userDao = &DAORegistry::getDAO('UserDAO');

      $result = &$this->retrieve(
         'SELECT u.*, e.can_review AS can_review, e.can_edit AS can_edit FROM users AS u, section_editors AS e WHERE u.user_id = e.user_id AND e.journal_id = ? AND e.section_id = ? ORDER BY last_name, first_name',
         array($journalId, $sectionId)
      );

      while (!$result->EOF) {
         $row = $result->GetRowAssoc(false);
         $users[] = array(
            'user' => $userDao->_returnUserFromRow($row),
            'canReview' => $row['can_review'],
            'canEdit' => $row['can_edit']
         );
         $result->moveNext();
      }

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

      return $users;
   }

   function &getEditorsNotInSection($journalId, $sectionId) {
      $users = array();

      $userDao = &DAORegistry::getDAO('UserDAO');

      $result = &$this->retrieve(
         'SELECT  u.*
         FROM  users u
            LEFT JOIN roles r ON (r.user_id = u.user_id)
            LEFT JOIN section_editors e ON (e.user_id = u.user_id AND e.journal_id = r.journal_id AND e.section_id = ?)
         WHERE r.journal_id = ? AND
            r.role_id = ? AND
            e.section_id IS NULL
         ORDER BY last_name, first_name',
         array($sectionId, $journalId, ROLE_ID_SECTION_EDITOR)
      );

      while (!$result->EOF) {
         $users[] = &$userDao->_returnUserFromRow($result->GetRowAssoc(false));
         $result->moveNext();
      }

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

      return $users;
   }

   function deleteEditorsBySectionId($sectionId, $journalId = null) {
      if (isset($journalId)) return $this->update(
         'DELETE FROM section_editors WHERE journal_id = ? AND section_id = ?',
         array($journalId, $sectionId)
      );
      else return $this->update(
         'DELETE FROM section_editors WHERE section_id = ?',
         $sectionId
      );
   }

   function deleteEditorsByJournalId($journalId) {
      return $this->update(
         'DELETE FROM section_editors WHERE journal_id = ?', $journalId
      );
   }

   function deleteEditorsByUserId($userId, $journalId  = null, $sectionId = null) {
      return $this->update(
         'DELETE FROM section_editors WHERE user_id = ?' . (isset($journalId) ? ' AND journal_id = ?' : '') . (isset($sectionId) ? ' AND section_id = ?' : ''),
         isset($journalId) && isset($sectionId) ? array($userId, $journalId, $sectionId)
         : (isset($journalId) ? array($userId, $journalId)
         : (isset($sectionId) ? array($userId, $sectionId) : $userId))
      );
   }

   function editorExists($journalId, $sectionId, $userId) {
      $result = &$this->retrieve(
         'SELECT COUNT(*) FROM section_editors WHERE journal_id = ? AND section_id = ? AND user_id = ?', array($journalId, $sectionId, $userId)
      );
      $returner = isset($result->fields[0]) && $result->fields[0] == 1 ? true : false;

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

      return $returner;
   }
}

?>

---