classes/monograph/GenreDAO.inc.php

<?php

import('classes.monograph.Genre');
import('classes.press.DefaultSettingDAO');

class GenreDAO extends DefaultSettingDAO {
   function GenreDAO() {
      parent::DefaultSettingDAO();
   }

   function getPrimaryKeyColumnName() {
      return 'genre_id';
   }

   function &getById($genreId, $pressId = null){
      $sqlParams = array((int)$genreId);
      if ($pressId) {
         $sqlParams[] = (int)$pressId;
      }

      $result =& $this->retrieve('SELECT * FROM genres WHERE genre_id = ?'. ($pressId ? ' AND press_id = ?' : ''), $sqlParams);
      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner =& $this->_fromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      return $returner;
   }

   function &getEnabledByPressId($pressId, $rangeInfo = null) {
      $result =& $this->retrieveRange(
         'SELECT * FROM genres WHERE enabled = ? AND press_id = ?', array(1, $pressId), $rangeInfo
      );

      $returner = new DAOResultFactory($result, $this, '_fromRow', array('id'));
      return $returner;
   }

   function getLocaleFieldNames() {
      return array('name', 'designation');
   }

   function updateLocaleFields(&$genre) {
      $this->updateDataObjectSettings('genre_settings', $genre, array(
         'genre_id' => $genre->getId()
      ));
   }

   function newDataObject() {
      return new Genre();
   }

   function &_fromRow(&$row) {
      $genre = $this->newDataObject();
      $genre->setId($row['genre_id']);
      $genre->setPressId($row['press_id']);
      $genre->setSortable($row['sortable']);
      $genre->setCategory($row['category']);

      $this->getDataObjectSettings('genre_settings', 'genre_id', $row['genre_id'], $genre);

      HookRegistry::call('GenreDAO::_fromRow', array(&$genre, &$row));

      return $genre;
   }

   function insertObject(&$genre) {
      $this->update(
         'INSERT INTO genres
            (sortable, press_id, category)
         VALUES
            (?, ?, ?)',
         array(
            $genre->getSortable() ? 1 : 0,
            (int) $genre->getPressId(),
            (int) $genre->getCategory()
         )
      );

      $genre->setId($this->getInsertGenreId());

      $this->updateLocaleFields($genre);

      return $genre->getId();
   }

   function updateObject(&$genre) {
      $this->updateLocaleFields($genre);
   }

   function deleteObject($genre) {
      return $this->deleteById($genre->getId());
   }

   function deleteById($entryId) {
      return $this->update(
         'UPDATE genres SET enabled = ? WHERE genre_id = ?', array(0, (int) $entryId)
      );
   }

   function deleteByPressId($pressId) {
      return $this->update(
         'DELETE FROM genres WHERE press_id = ?', array((int) $pressId)
      );
   }

   function getInsertGenreId() {
      return $this->getInsertId('genres', 'genre_id');
   }

   function getSettingsTableName() {
      return 'genre_settings';
   }

   function getTableName() {
      return 'genres';
   }

   function getDefaultType() {
      return DEFAULT_SETTING_GENRES;
   }

   function getDefaultBaseFilename() {
      return 'registry/genres.xml';
   }

   function installDefaultBase($pressId) {
      $xmlDao = new XMLDAO();

      $data = $xmlDao->parseStruct($this->getDefaultBaseFilename(), array('genre'));
      if (!isset($data['genre'])) return false;

      foreach ($data['genre'] as $entry) {
         $attrs = $entry['attributes'];
         $this->update(
            'INSERT INTO genres
            (entry_key, sortable, press_id, category)
            VALUES
            (?, ?, ?, ?)',
            array($attrs['key'], $attrs['sortable'] ? 1 : 0, $pressId, $attrs['category'])
         );
      }
      return true;
   }

   function &getSettingAttributes($node = null, $locale = null) {

      if ($node == null) {
         $settings = array('name', 'designation');
      } else {
         $localeKey = $node->getAttribute('localeKey');
         $sortable = $node->getAttribute('sortable');

         $designation = $sortable ? GENRE_SORTABLE_DESIGNATION : __($localeKey.'.designation', array(), $locale);

         $settings = array(
            'name' => __($localeKey, array(), $locale),
            'designation' => $designation
         );
      }
      return $settings;
   }
}

?>