FilterGroupDAO.inc.php

<?php
 
import('lib.pkp.classes.filter.FilterGroup');
 
class FilterGroupDAO extends DAO {
 
   function insertObject(&$filterGroup) {
      $this->update(
         sprintf('INSERT INTO filter_groups
            (symbolic, display_name, description, input_type, output_type)
            VALUES (?, ?, ?, ?, ?)'),
         array(
            $filterGroup->getSymbolic(),
            $filterGroup->getDisplayName(),
            $filterGroup->getDescription(),
            $filterGroup->getInputType(),
            $filterGroup->getOutputType()
         )
      );
      $filterGroup->setId((int)$this->getInsertId());
      return $filterGroup->getId();
   }
 
   function &getObject(&$filterGroup) {
      return $this->getObjectById($filterGroup->getId());
   }
 
   function &getObjectById($filterGroupId) {
      $result = $this->retrieve(
            'SELECT * FROM filter_groups'.
            ' WHERE filter_group_id = ?', $filterGroupId);
 
      $filterGroup = null;
      if ($result->RecordCount() != 0) {
         $filterGroup = $this->_fromRow($result->GetRowAssoc(false));
      }
 
      $result->Close();
      return $filterGroup;
   }
 
   function &getObjectBySymbolic($filterGroupSymbolic) {
      $result = $this->retrieve(
            'SELECT * FROM filter_groups'.
            ' WHERE symbolic = ?', $filterGroupSymbolic);
 
      $filterGroup = null;
      if ($result->RecordCount() != 0) {
         $filterGroup = $this->_fromRow($result->GetRowAssoc(false));
      }
 
      $result->Close();
      return $filterGroup;
   }
 
   function updateObject(&$filterGroup) {
      $this->update(
         'UPDATE  filter_groups
         SET   symbolic = ?,
            display_name = ?,
            description = ?,
            input_type = ?,
            output_type = ?
         WHERE filter_group_id = ?',
         array(
            $filterGroup->getSymbolic(),
            $filterGroup->getDisplayName(),
            $filterGroup->getDescription(),
            $filterGroup->getInputType(),
            $filterGroup->getOutputType(),
            (integer)$filterGroup->getId()
         )
      );
   }
 
   function deleteObject(&$filterGroup) {
      $filterDao = DAORegistry::getDAO('FilterDAO'); /* @var $filterDao FilterDAO */
 
      // Check whether there are still templates saved for this filter group.
      $filterTemplates = $filterDao->getObjectsByGroup($filterGroup->getSymbolic(), null, true, false);
      if (!empty($filterTemplates)) return false;
 
      // Check whether there are still filters saved for this filter group.
      $filters = $filterDao->getObjectsByGroup($filterGroup->getSymbolic(), null, false, false);
      if (!empty($filters)) return false;
 
      // Delete the group if it's empty.
      $this->update('DELETE FROM filter_groups WHERE filter_group_id = ?', $filterGroup->getId());
 
      return true;
   }
 
   function deleteObjectById($filterGroupId) {
      $filterGroupId = (int)$filterGroupId;
      $filterGroup =& $this->getObjectById($filterGroupId);
      if (!is_a($filterGroup, 'FilterGroup')) return false;
      return $this->deleteObject($filterGroup);
   }
 
   function deleteObjectBySymbolic($filterGroupSymbolic) {
      $filterGroup =& $this->getObjectBySymbolic($filterGroupSymbolic);
      if (!is_a($filterGroup, 'FilterGroup')) return false;
      return $this->deleteObject($filterGroup);
   }
 
 
   //
   // Protected helper methods
   //
   function getInsertId() {
      return parent::_getInsertId('filter_groups', 'filter_group_id');
   }
 
   function newDataObject() {
      return new FilterGroup();
   }
 
 
   //
   // Private helper methods
   //
   function _fromRow($row) {
      // Instantiate the filter group.
      $filterGroup = $this->newDataObject();
 
      // Configure the filter group.
      $filterGroup->setId((int)$row['filter_group_id']);
      $filterGroup->setSymbolic($row['symbolic']);
      $filterGroup->setDisplayName($row['display_name']);
      $filterGroup->setDescription($row['description']);
      $filterGroup->setInputType($row['input_type']);
      $filterGroup->setOutputType($row['output_type']);
 
      return $filterGroup;
   }
}