classes/conference/TrackDAO.inc.php

Go to the documentation of this file.

<?php

// $Id$


import ('conference.Track');

class TrackDAO extends DAO {
   function &getTrack($trackId) {
      $result =& $this->retrieve(
         'SELECT * FROM tracks WHERE track_id = ?', $trackId
      );

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

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

      return $returner;
   }

   function &getTrackByAbbrev($trackAbbrev, $schedConfId, $locale = null) {
      $sql = 'SELECT * FROM tracks t, track_settings l WHERE l.track_id = t.track_id AND l.setting_name = ? AND l.setting_value = ? AND t.sched_conf_id = ?';
      $params = array('abbrev', $trackAbbrev, $schedConfId);

      if ($locale !== null) {
         $sql .= ' AND l.locale = ?';
         $params[] = $locale;
      }
      $result =& $this->retrieve($sql, $params);

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

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

      return $returner;
   }

   function &getTrackByTitle($trackTitle, $schedConfId, $locale = null) {
      $sql = 'SELECT * FROM tracks t, track_settings l WHERE l.track_id = t.track_id AND l.setting_name = ? AND l.setting_value = ? AND t.sched_conf_id = ?';
      $params = array('title', $trackTitle, $schedConfId);

      if ($locale !== null) {
         $sql .= ' AND l.locale = ?';
         $params[] = $locale;
      }
      $result =& $this->retrieve($sql, $params);

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

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

      return $returner;
   }

   function &getTrackByTitleAndAbbrev($trackTitle, $trackAbbrev, $schedConfId, $locale = null) {
      $params = array('title', 'abbrev', $trackTitle, $trackAbbrev, $schedConfId);
      if ($locale !== null) {
         $params[] = $locale;
         $params[] = $locale;
      }

      $sql = 'SELECT t.*
         FROM  tracks t,
            track_settings l1,
            track_settings l2
         WHERE l1.track_id = t.track_id AND
            l2.track_id = t.track_id AND
            l1.setting_name = ? AND
            l2.setting_name = ? AND
            l1.setting_value = ? AND
            l2.setting_value = ? AND
            t.sched_conf_id = ?';
      if ($locale !== null) $sql .= ' AND l1.locale = ? AND l2.locale = ?';
      $result =& $this->retrieve($sql, $params);

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

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

      return $returner;
   }

   function &_returnTrackFromRow(&$row) {
      $track = new Track();
      $track->setId($row['track_id']);
      $track->setSchedConfId($row['sched_conf_id']);
      $track->setReviewFormId($row['review_form_id']);
      $track->setSequence($row['seq']);
      $track->setMetaReviewed($row['meta_reviewed']);
      $track->setDirectorRestricted($row['director_restricted']);
      $track->setHideAbout($row['hide_about']);
      $track->setDisableComments($row['disable_comments']);
      $track->setAbstractWordCount($row['abstract_word_count']);

      $this->getDataObjectSettings('track_settings', 'track_id', $row['track_id'], $track);

      HookRegistry::call('TrackDAO::_returnTrackFromRow', array(&$track, &$row));

      return $track;
   }

   function getLocaleFieldNames() {
      return array('title', 'abbrev', 'policy', 'identifyType');
   }

   function updateLocaleFields(&$track) {
      $this->updateDataObjectSettings('track_settings', $track, array(

         'track_id' => $track->getId()
      ));
   }

   function insertTrack(&$track) {
      $this->update(
         'INSERT INTO tracks
            (sched_conf_id, review_form_id, seq, meta_reviewed, director_restricted, hide_about, disable_comments, abstract_word_count)
            VALUES
            (?, ?, ?, ?, ?, ?, ?, ?)',
         array(
            (int) $track->getSchedConfId(),
            $track->getReviewFormId(),
            (int) $track->getSequence(),
            $track->getMetaReviewed() ? 1 : 0,
            $track->getDirectorRestricted() ? 1 : 0,
            $track->getHideAbout() ? 1 : 0,
            $track->getDisableComments() ? 1 : 0,
            (int) $track->getAbstractWordCount()
         )
      );

      $track->setId($this->getInsertTrackId());
      $this->updateLocaleFields($track);
      return $track->getId();
   }

   function updateTrack(&$track) {
      $returner = $this->update(
         'UPDATE  tracks
         SET   review_form_id = ?,
            seq = ?,
            meta_reviewed = ?,
            director_restricted = ?,
            hide_about = ?,
            disable_comments = ?,
            abstract_word_count = ?
         WHERE track_id = ?',
         array(
            $track->getReviewFormId(),
            (int) $track->getSequence(),
            $track->getMetaReviewed()?1:0,
            $track->getDirectorRestricted()?1:0,
            $track->getHideAbout()?1:0,
            $track->getDisableComments()?1:0,
            (int) $track->getAbstractWordCount(),
            (int) $track->getId()
         )
      );
      $this->updateLocaleFields($track);
      return $returner;
   }

   function deleteTrack(&$track) {
      return $this->deleteTrackById($track->getId(), $track->getSchedConfId());
   }

   function deleteTrackById($trackId, $schedConfId = null) {
      $trackDirectorsDao =& DAORegistry::getDAO('TrackDirectorsDAO');
      $trackDirectorsDao->deleteDirectorsByTrackId($trackId, $schedConfId);

      // Remove papers from this track
      $paperDao =& DAORegistry::getDAO('PaperDAO');
      $paperDao->removePapersFromTrack($trackId);

      // Delete published paper entries from this track -- they must
      // be re-published.
      $publishedPaperDao =& DAORegistry::getDAO('PublishedPaperDAO');
      $publishedPaperDao->deletePublishedPapersByTrackId($trackId);

      if (isset($schedConfId) && !$this->trackExists($trackId, $schedConfId)) return false;
      $this->update('DELETE FROM track_settings WHERE track_id = ?', array($trackId));
      return $this->update('DELETE FROM tracks WHERE track_id = ?', array($trackId));
   }

   function deleteTracksBySchedConf($schedConfId) {
      $tracks =& $this->getSchedConfTracks($schedConfId);
      while (($track =& $tracks->next())) {
         $this->deleteTrack($track);
         unset($track);
      }
   }

   function &getDirectorTracks($schedConfId) {
      $returner = array();

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

      while (!$result->EOF) {
         $row = $result->GetRowAssoc(false);
         $track =& $this->_returnTrackFromRow($row);
         if (!isset($returner[$row['director_id']])) {
            $returner[$row['director_id']] = array($track);
         } else {
            $returner[$row['director_id']][] = $track;
         }
         $result->moveNext();
      }

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

      return $returner;
   }

   function &getTracksBySchedConfId($schedConfId) {
      $returner = array();

      $result =& $this->retrieve(
         'SELECT DISTINCT t.*,
            t.seq AS track_seq
         FROM tracks t, papers p
         LEFT JOIN sched_confs i ON (p.sched_conf_id = i.sched_conf_id) AND (i.sched_conf_id = ?)
         WHERE t.track_id = p.track_id ORDER BY track_seq',
         array($schedConfId)
      );

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

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

      return $returner;
   }

   function &getSchedConfTracks($schedConfId, $rangeInfo = null) {
      $result =& $this->retrieveRange(
         'SELECT  *
         FROM  tracks
         WHERE sched_conf_id = ?
         ORDER BY seq',
         (int) $schedConfId,
         $rangeInfo
      );

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

   function &getConferenceTracks($conferenceId, $rangeInfo = null) {
      $result =& $this->retrieveRange(
         'SELECT  t.*
         FROM  tracks t,
            sched_confs sc
         WHERE t.sched_conf_id = sc.sched_conf_id AND
            sc.conference_id = ?
         ORDER BY sc.seq, t.seq',
         (int) $conferenceId,
         $rangeInfo
      );

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

   function &getTrackTitles($schedConfId, $submittableOnly = false) {
      $tracks = array();
      $tracksIterator =& $this->getSchedConfTracks($schedConfId);
      while (($track =& $tracksIterator->next())) {
         if (!$submittableOnly || !$track->getDirectorRestricted()) {
            $tracks[$track->getId()] = $track->getLocalizedTitle();
         }

         unset($track);
      }

      return $tracks;
   }

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

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

      return $returner;
   }

   function resequenceTracks($schedConfId) {
      $result =& $this->retrieve(
         'SELECT track_id FROM tracks WHERE sched_conf_id = ? ORDER BY seq',
         $schedConfId
      );

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

         $result->moveNext();
      }

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

   function getInsertTrackId() {
      return $this->getInsertId('tracks', 'track_id');
   }
}

?>

---