classes/conference/TrackDirectorsDAO.inc.php

Go to the documentation of this file.

<?php

//$Id$

class TrackDirectorsDAO extends DAO {
   function insertDirector($schedConfId, $trackId, $userId) {
      return $this->update(
         'INSERT INTO track_directors
            (sched_conf_id, track_id, user_id)
            VALUES
            (?, ?, ?)',
         array(
            $schedConfId,
            $trackId,
            $userId
         )
      );
   }

   function deleteDirector($schedConfId, $trackId, $userId) {
      return $this->update(
         'DELETE FROM track_directors WHERE sched_conf_id = ? AND track_id = ? AND user_id = ?',
         array(
            $schedConfId,
            $trackId,
            $userId
         )
      );
   }

   function &getTracksByUserId($schedConfId, $userId) {
      $tracks = array();

      $trackDao =& DAORegistry::getDAO('TrackDAO');

      $result =& $this->retrieve(
         'SELECT t.* FROM tracks t, track_directors td WHERE t.track_id = td.track_id AND t.sched_conf_id = ? AND td.user_id = ?',
         array($schedConfId, $userId)
      );

      while (!$result->EOF) {
         $tracks[] =& $trackDao->_returnTrackFromRow($result->GetRowAssoc(false));
         $result->moveNext();
      }

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

      return $tracks;
   }

   function &getDirectorsByTrackId($schedConfId, $trackId) {
      $users = array();

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

      $result =& $this->retrieve(
         'SELECT u.* FROM users AS u, track_directors AS e WHERE u.user_id = e.user_id AND e.sched_conf_id = ? AND e.track_id = ? ORDER BY last_name, first_name',
         array($schedConfId, $trackId)
      );

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

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

      return $users;
   }

   function &getDirectorsNotInTrack($schedConfId, $trackId) {
      $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 track_directors e ON (e.user_id = u.user_id AND e.sched_conf_id = r.sched_conf_id AND e.track_id = ?)
         WHERE r.sched_conf_id = ? AND
            r.role_id = ? AND
            e.track_id IS NULL
         ORDER BY last_name, first_name',
         array($trackId, $schedConfId, ROLE_ID_TRACK_DIRECTOR)
      );

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

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

      return $users;
   }

   function deleteDirectorsByTrackId($trackId, $schedConfId = null) {
      if (isset($schedConfId)) return $this->update(
         'DELETE FROM track_directors WHERE sched_conf_id = ? AND track_id = ?',
         array($schedConfId, $trackId)
      );
      else return $this->update(
         'DELETE FROM track_directors WHERE track_id = ?',
         $trackId
      );
   }

   function deleteDirectorsBySchedConfId($schedConfId) {
      return $this->update(
         'DELETE FROM track_directors WHERE sched_conf_id = ?', $schedConfId
      );
   }

   function deleteDirectorsByUserId($userId, $schedConfId  = null, $trackId = null) {
      return $this->update(
         'DELETE FROM track_directors WHERE user_id = ?' . (isset($schedConfId) ? ' AND sched_conf_id = ?' : '') . (isset($trackId) ? ' AND track_id = ?' : ''),
         isset($schedConfId) && isset($trackId) ? array($userId, $schedConfId, $trackId)
         : (isset($schedConfId) ? array($userId, $schedConfId)
         : (isset($trackId) ? array($userId, $trackId) : $userId))
      );
   }

   function directorExists($schedConfId, $trackId, $userId) {
      $result =& $this->retrieve(
         'SELECT COUNT(*) FROM track_directors WHERE sched_conf_id = ? AND track_id = ? AND user_id = ?', array($schedConfId, $trackId, $userId)
      );
      $returner = isset($result->fields[0]) && $result->fields[0] == 1 ? true : false;

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

      return $returner;
   }
}

?>

---