classes/cataloguingMetadata/CataloguingMetadataFieldDAO.inc.php

<?php
import('classes.cataloguingMetadata.CataloguingMetadataField');
import('classes.press.DefaultSettingDAO');

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

   function getPrimaryKeyColumnName() {
      return 'field_id';
   }

   function &getById($cataloguingMetadataFieldId, $pressId = null) {
      $params = array((int) $cataloguingMetadataFieldId);
      if ($pressId) $params[] = (int) $pressId;

      $result =& $this->retrieve(
         'SELECT  *
         FROM  cataloguing_metadata_fields
         WHERE field_id = ?
         ' . ($pressId?' AND press_id = ?':''),
         $params
      );

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

   function &getEnabledByPressId($pressId) {
      $result =& $this->retrieve(
         'SELECT  *
         FROM  cataloguing_metadata_fields
         WHERE enabled = ? AND
            press_id = ?',
         array(1, (int) $pressId)
      );

      $returner = null;
      while (!$result->EOF) {
         $returner[] =& $this->_fromRow($result->GetRowAssoc(false));
         $result->MoveNext();
      }
      $result->Close();
      unset($result);

      return $returner;
   }

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

   function updateLocaleFields(&$cataloguingMetadataField) {
      $this->updateDataObjectSettings('cataloguing_metadata_field_settings', $cataloguingMetadataField, array(
         'field_id' => $cataloguingMetadataField->getId()
      ));
   }

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

   function &_fromRow(&$row) {
      $cataloguingMetadataField = $this->newDataObject();
      $cataloguingMetadataField->setPressId($row['press_id']);
      $cataloguingMetadataField->setId($row['field_id']);
      $cataloguingMetadataField->setEnabled($row['enabled']);

      $this->getDataObjectSettings('cataloguing_metadata_field_settings', 'field_id', $row['field_id'], $cataloguingMetadataField);

      return $cataloguingMetadataField;
   }

   function insertObject(&$cataloguingMetadataField) {
      $this->update(
         'INSERT INTO cataloguing_metadata_fields
            (press_id, enabled)
         VALUES
            (?, ?)',
         array(
            (int) $cataloguingMetadataField->getPressId(),
            $cataloguingMetadataField->getEnabled()?1:0
         )
      );

      $cataloguingMetadataField->setId($this->getInsertCataloguingMetadataFieldId());

      $this->updateLocaleFields($cataloguingMetadataField);

      return $cataloguingMetadataField->getId();
   }

   function updateObject(&$cataloguingMetadataField) {

      $this->updateLocaleFields($cataloguingMetadataField);
   }

   function deleteById($cataloguingMetadataFieldId, $pressId = null) {
      $params = array(0, (int) $cataloguingMetadataFieldId);
      if ($pressId) $params[] = (int) $pressId;

      return $this->update(
         'UPDATE  cataloguing_metadata_fields
         SET   enabled = ?
         WHERE field_id = ?
            ' . ($pressId?' AND press_id = ?':''),
         $params
      );
   }

   function getInsertCataloguingMetadataFieldId() {
      return $this->getInsertId('cataloguing_metadata_fields', 'field_id');
   }

   function getSettingsTableName() {
      return 'cataloguing_metadata_field_settings';
   }

   function getTableName() {
      return 'cataloguing_metadata_fields';
   }

   function getDefaultType() {
      return DEFAULT_SETTING_PUBLICATION_FORMATS;
   }

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

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

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

      foreach ($data['cataloguingMetadataField'] as $entry) {
         $attrs = $entry['attributes'];
         $this->update(
            'INSERT INTO cataloguing_metadata_fields
            (press_id, enabled)
            VALUES
            (?, ?)',
            array((int) $pressId, 1)
         );
      }
      return true;
   }

   function &getSettingAttributes($node = null, $locale = null) {
      if ($node == null) {
         $settings = array('name');
      } else {
         $localeKey = $node->getAttribute('localeKey');

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

?>