classes/monograph/MonographAgencyDAO.inc.php

<?php

import('lib.pkp.classes.controlledVocab.ControlledVocabDAO');

define('CONTROLLED_VOCAB_MONOGRAPH_AGENCY', 'monographAgency');

class MonographAgencyDAO extends ControlledVocabDAO {
   function MonographAgencyDAO() {
      parent::ControlledVocabDAO();
   }

   function build($monographId) {
      return parent::build(CONTROLLED_VOCAB_MONOGRAPH_AGENCY, ASSOC_TYPE_MONOGRAPH, $monographId);
   }

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

   function getAgencies($monographId, $locales) {

      $returner = array();
      foreach ($locales as $locale) {
         $returner[$locale] = array();
         $agencies = $this->build($monographId);
         $monographAgencyEntryDao =& DAORegistry::getDAO('MonographAgencyEntryDAO');
         $monographAgencies = $monographAgencyEntryDao->getByControlledVocabId($agencies->getId());

         while ($agency =& $monographAgencies->next()) {
            $agency = $agency->getAgency();
            if (array_key_exists($locale, $agency)) { // quiets PHP when there are no agencies for a given locale
               $returner[$locale][] = $agency[$locale];
               unset($agency);
            }
         }
      }
      return $returner;
   }

   function getAllUniqueAgencies() {
      $agencies = array();

      $result =& $this->retrieve(
         'SELECT DISTINCT setting_value FROM controlled_vocab_entry_settings WHERE setting_name = ?', CONTROLLED_VOCAB_MONOGRAPH_AGENCY
      );

      while (!$result->EOF) {
         $agencies[] = $result->fields[0];
         $result->MoveNext();
      }

      $result->Close();
      unset($result);

      return $agencies;
   }

   function getMonographIdsByAgency($agency) {
      $result =& $this->retrieve(
         'SELECT assoc_id
          FROM controlled_vocabs cv
          LEFT JOIN controlled_vocab_entries cve ON cv.controlled_vocab_id = cve.controlled_vocab_id
          INNER JOIN controlled_vocab_entry_settings cves ON cve.controlled_vocab_entry_id = cves.controlled_vocab_entry_id
          WHERE cves.setting_name = ? AND cves.setting_value = ?',
         array(CONTROLLED_VOCAB_MONOGRAPH_AGENCY, $agency)
      );

      $returner = array();
      while (!$result->EOF) {
         $row = $result->GetRowAssoc(false);
         $returner[] = $row['assoc_id'];
         $result->MoveNext();
      }
      $result->Close();
      return $returner;
   }

   function insertAgencies($agencies, $monographId, $deleteFirst = true) {
      $agencyDao =& DAORegistry::getDAO('MonographAgencyDAO');
      $monographAgencyEntryDao =& DAORegistry::getDAO('MonographAgencyEntryDAO');
      $currentAgencies = $this->build($monographId);

      if ($deleteFirst) {
         $existingEntries = $agencyDao->enumerate($currentAgencies->getId(), CONTROLLED_VOCAB_MONOGRAPH_AGENCY);

         foreach ($existingEntries as $id => $entry) {
            $entry = trim($entry);
            $monographAgencyEntryDao->deleteObjectById($id);
         }
      }
      if (is_array($agencies)) { // localized, array of arrays

         foreach ($agencies as $locale => $list) {
            if (is_array($list)) {
               $list = array_unique($list); // Remove any duplicate keywords
               $i = 1;
               foreach ($list as $agency) {
                  $agencyEntry = $monographAgencyEntryDao->newDataObject();
                  $agencyEntry->setControlledVocabId($currentAgencies->getID());
                  $agencyEntry->setAgency(urldecode($agency), $locale);
                  $agencyEntry->setSequence($i);
                  $i ++;
                  $agencyEntryId = $monographAgencyEntryDao->insertObject($agencyEntry);
               }
            }
         }
      }
   }
}

?>