ContextDAO.inc.php

<?php
 
import('lib.pkp.classes.db.SchemaDAO');
 
abstract class ContextDAO extends SchemaDAO {
   function getNames($enabledOnly = false) {
      $contexts = array();
      $iterator = $this->getAll($enabledOnly);
      while ($context = $iterator->next()) {
         $contexts[$context->getId()] = $context->getLocalizedName();
      }
      return $contexts;
   }
 
   function getLocaleFieldNames() {
      return array('name', 'description');
   }
 
   function existsByPath($path) {
      $result = $this->retrieve(
         'SELECT COUNT(*) FROM ' . $this->tableName . ' WHERE path = ?',
         (string) $path
      );
      $returner = isset($result->fields[0]) && $result->fields[0] == 1 ? true : false;
      $result->Close();
      return $returner;
   }
 
   function getByPath($path) {
      $result = $this->retrieve(
         'SELECT * FROM ' . $this->tableName . ' WHERE path = ?',
         (string) $path
      );
      if ($result->RecordCount() == 0) return null;
 
      $returner = $this->_fromRow($result->GetRowAssoc(false));
      $result->Close();
      return $returner;
   }
 
   function getAll($enabledOnly = false, $rangeInfo = null) {
      $result = $this->retrieveRange(
         'SELECT * FROM ' . $this->tableName .
         ($enabledOnly?' WHERE enabled = 1':'') .
         ' ORDER BY seq',
         false,
         $rangeInfo
      );
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   function getAvailable($userId = null, $rangeInfo = null) {
      $params = array();
      if ($userId) $params = array_merge(
         $params,
         array((int) $userId, (int) $userId, (int) ROLE_ID_SITE_ADMIN)
      );
 
      $result = $this->retrieveRange(
         'SELECT c.* FROM ' . $this->tableName . ' c
         WHERE ' .
            ($userId?
               'c.' . $this->primaryKeyColumn . ' IN (SELECT DISTINCT ug.context_id FROM user_groups ug JOIN user_user_groups uug ON (ug.user_group_id = uug.user_group_id) WHERE uug.user_id = ?)
               OR ? IN (SELECT user_id FROM user_groups ug JOIN user_user_groups uug ON (ug.user_group_id = uug.user_group_id) WHERE ug.role_id = ?)'
            :'c.enabled = 1') .
         ' ORDER BY seq',
         $params,
         $rangeInfo
      );
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   function getBySetting($settingName, $settingValue, $contextId = null) {
      $params = array($settingName, $settingValue);
      if ($contextId) $params[] = $contextId;
 
      $result = $this->retrieve(
         'SELECT * FROM ' . $this->tableName . ' AS c
         LEFT JOIN ' . $this->settingsTableName . ' AS cs
         ON c.' . $this->primaryKeyColumn . ' = cs.' . $this->primaryKeyColumn .
         ' WHERE cs.setting_name = ? AND cs.setting_value = ?' .
         ($contextId?' AND c.' . $this->primaryKeyColumn . ' = ?':''),
         $params
      );
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   function resequence() {
      $result = $this->retrieve(
         'SELECT ' . $this->primaryKeyColumn . ' FROM ' . $this->tableName . ' ORDER BY seq'
      );
 
      for ($i=1; !$result->EOF; $i+=2) {
         list($contextId) = $result->fields;
         $this->update(
            'UPDATE ' . $this->tableName . ' SET seq = ? WHERE ' . $this->primaryKeyColumn . ' = ?',
            array(
               $i,
               $contextId
            )
         );
 
         $result->MoveNext();
      }
      $result->Close();
   }
}