classes/press/DefaultSettingDAO.inc.php

<?php
define('DEFAULT_SETTING_GENRES',    1);
define('DEFAULT_SETTING_PUBLICATION_FORMATS',   2);

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

   function installDefaultBase($pressId) {
      return null;
   }

   function getDefaultBaseFilename() {
      return null;
   }

   function getPrimaryKeyColumnName() {
      // Must be implemented by sub-classes.
      assert(false);
   }

   function getDefaultKey() {
      return 'entry_key';
   }

   function getSettingAttributes($node = null) {
      return array();
   }

   function getSettingsTableName() {
      return null;
   }

   function getTableName() {
      return null;
   }

   function getDefaultType() {
      return null;
   }

   function installDefaultBaseData($locale, $pressId, $skipLoad = true, $localeInstall = false) {
      $xmlDao = new XMLDAO();
      $data = $xmlDao->parse($this->getDefaultBaseFilename());
      if (!$data) return false;
      $defaultIds = $this->getDefaultSettingIds($pressId);
      AppLocale::requireComponents(LOCALE_COMPONENT_OMP_DEFAULT_SETTINGS, $locale);

      foreach ($data->getChildren() as $formatNode) {

         $settings =& $this->getSettingAttributes($formatNode, $locale);

         if (empty($defaultIds[$formatNode->getAttribute('key')])) { // ignore keys not associated with this press
            continue;
         } else { // prepare a list of attributes not defined in the current settings xml file
            unset($defaultIds[$formatNode->getAttribute('key')]);
         }

         foreach ($settings as $settingName => $settingValue) {

            $this->update(
               'INSERT INTO press_defaults
               (press_id, assoc_type, entry_key, locale, setting_name, setting_value, setting_type)
               VALUES
               (?, ?, ?, ?, ?, ?, ?)',
               array(
                  $pressId,
                  $this->getDefaultType(),
                  $formatNode->getAttribute('key'),
                  $locale,
                  $settingName,
                  $settingValue,
                  'string'
               )
            );
         }
      }

      $attributeNames =& $this->getSettingAttributes();

      // install defaults for keys not defined in the xml
      foreach ($defaultIds as $key => $id) {
         foreach ($attributeNames as $setting) {
            $this->update(
               'INSERT INTO press_defaults
               (press_id, assoc_type, entry_key, locale, setting_name, setting_value, setting_type)
               VALUES
               (?, ?, ?, ?, ?, ?, ?)',
               array(
                  $pressId,
                  $this->getDefaultType(),
                  $key,
                  $locale,
                  $setting,
                  '##',
                  'string'
               )
            );
         }
      }

      if ($skipLoad) {
         return true;
      }

      if ($localeInstall) {
         $this->restoreByPressId($pressId, $locale);
      } else {
         $this->restoreByPressId($pressId);
      }

      return true;
   }

   function &getDefaultSettingIds($pressId) {
      $result =& $this->retrieve(
         'SELECT '. $this->getPrimaryKeyColumnName() .', '. $this->getDefaultKey() .' FROM '. $this->getTableName() .'
         WHERE press_id = ? AND '. $this->getDefaultKey() .' IS NOT NULL', $pressId
      );

      $returner = null;
      while (!$result->EOF) {
         $returner[$result->fields[$this->getDefaultKey()]] =& $result->fields[$this->getPrimaryKeyColumnName()];
         $result->MoveNext();
      }
      $result->Close();
      unset($result);

      return $returner;
   }

   function restoreByPressId($pressId, $locale = null) {

      $defaultIds = $this->getDefaultSettingIds($pressId);

      if ($locale) {
         foreach ($defaultIds as $key => $id) {
            $this->update('DELETE FROM '. $this->getSettingsTableName() .' WHERE '. $this->getPrimaryKeyColumnName() .' = ? AND locale = ?', array($id, $locale));
         }
      } else {
         foreach ($defaultIds as $key => $id) {
            $this->update('DELETE FROM '. $this->getSettingsTableName() .' WHERE '. $this->getPrimaryKeyColumnName() .' = ?', $id);
         }
      }

      if (!$locale) {
         $this->update('UPDATE '. $this->getTableName() .' SET enabled = ? WHERE press_id = ? AND '. $this->getDefaultKey() .' IS NOT NULL', array(1, $pressId));
         $this->update('UPDATE '. $this->getTableName() .' SET enabled = ? WHERE press_id = ? AND '. $this->getDefaultKey() .' IS NULL', array(0, $pressId));
      }

      $sql = 'SELECT * FROM press_defaults WHERE press_id = ? AND assoc_type = ?';
      $sqlParams = array($pressId, $this->getDefaultType());
      if ($locale) {
         $sql .= ' AND locale = ?';
         $sqlParams[] = $locale;
      }

      $result =& $this->retrieve($sql, $sqlParams);

      $returner = null;
      while (!$result->EOF) {
         $row =& $result->GetRowAssoc(false);
         $this->update(
            'INSERT INTO '. $this->getSettingsTableName() .'
            ('. $this->getPrimaryKeyColumnName() .', locale, setting_name, setting_value, setting_type)
            VALUES
            (?, ?, ?, ?, ?)',
            array($defaultIds[$row['entry_key']], $row['locale'], $row['setting_name'], $row['setting_value'], $row['setting_type'])
         );
         unset($row);
         $result->MoveNext();
      }
      $result->Close();
      unset($result);
   }

   function installDefaults($pressId, $locales) {
      $this->installDefaultBase($pressId);
      foreach ($locales as $locale) {
         $this->installDefaultBaseData($locale, $pressId);
      }
      $this->restoreByPressId($pressId);
   }

   function installLocale($locale) {
      $pressDao =& DAORegistry::getDAO('PressDAO');
      $presses =& $pressDao->getNames();

      foreach ($presses as $id => $name) {
         $this->installDefaultBaseData($locale, $id, false, true);
      }

   }

   function uninstallLocale($locale) {
      $this->update('DELETE FROM '. $this->getSettingsTableName() .' WHERE locale = ?', array($locale));
      $this->update('DELETE FROM press_defaults WHERE locale = ?', array($locale));
   }
}

?>