classes/press/SeriesEditorsDAO.inc.php

<?php

class SeriesEditorsDAO extends DAO {
   function SeriesEditorsDAO() {
      parent::DAO();
   }

   function insertEditor($pressId, $seriesId, $userId, $canReview, $canEdit) {
      return $this->update(
         'INSERT INTO series_editors
            (press_id, series_id, user_id, can_review, can_edit)
            VALUES
            (?, ?, ?, ?, ?)',
         array(
            $pressId,
            $seriesId,
            $userId,
            $canReview ? 1 : 0,
            $canEdit ? 1 : 0
         )
      );
   }

   function deleteEditor($pressId, $seriesId, $userId) {
      return $this->update(
         'DELETE FROM series_editors WHERE press_id = ? AND series_id = ? AND user_id = ?',
         array(
            $pressId,
            $seriesId,
            $userId
         )
      );
   }

   function &getEditorsBySeriesId($seriesId, $pressId) {
      $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, series_editors AS e WHERE u.user_id = e.user_id AND e.press_id = ? AND e.series_id = ? ORDER BY last_name, first_name',
         array($pressId, $seriesId)
      );

      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 &getEditorsNotInSeries($pressId, $seriesId) {
      $users = array();

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

      $result =& $this->retrieve(
         'SELECT  u.*
         FROM  users u
            JOIN user_user_groups uug ON (u.user_id = uug.user_id)
            JOIN user_groups ug ON (uug.user_group_id = ug.user_group_id AND ug.role_id = ? AND ug.context_id = ?)
            LEFT JOIN series_editors e ON (e.user_id = u.user_id AND e.press_id = ug.context_id AND e.series_id = ?)
         WHERE e.series_id IS NULL
         ORDER BY last_name, first_name',
         array(ROLE_ID_SERIES_EDITOR, (int) $pressId, (int) $seriesId)
      );

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

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

      return $users;
   }

   function deleteEditorsBySeriesId($seriesId, $pressId = null) {
      if (isset($pressId)) return $this->update(
         'DELETE FROM series_editors WHERE press_id = ? AND series_id = ?',
         array($pressId, $seriesId)
      );
      else return $this->update(
         'DELETE FROM series_editors WHERE series_id = ?',
         $seriesId
      );
   }

   function deleteEditorsByPressId($pressId) {
      return $this->update(
         'DELETE FROM series_editors WHERE press_id = ?', $pressId
      );
   }

   function deleteEditorsByUserId($userId, $pressId  = null, $seriesId = null) {
      return $this->update(
         'DELETE FROM series_editors WHERE user_id = ?' . (isset($pressId) ? ' AND press_id = ?' : '') . (isset($seriesId) ? ' AND series_id = ?' : ''),
         isset($pressId) && isset($seriesId) ? array($userId, $pressId, $seriesId)
         : (isset($pressId) ? array($userId, $pressId)
         : (isset($seriesId) ? array($userId, $seriesId) : $userId))
      );
   }

   function editorExists($pressId, $seriesId, $userId) {
      $result =& $this->retrieve(
         'SELECT COUNT(*) FROM series_editors WHERE press_id = ? AND series_id = ? AND user_id = ?', array($pressId, $seriesId, $userId)
      );
      $returner = isset($result->fields[0]) && $result->fields[0] == 1 ? true : false;

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

      return $returner;
   }
}

?>