SubmissionAgencyDAO.inc.php

<?php
 
import('lib.pkp.classes.controlledVocab.ControlledVocabDAO');
 
define('CONTROLLED_VOCAB_SUBMISSION_AGENCY', 'submissionAgency');
 
class SubmissionAgencyDAO extends ControlledVocabDAO {
 
   function build($publicationId, $assocType = ASSOC_TYPE_PUBLICATION) {
      return parent::_build(CONTROLLED_VOCAB_SUBMISSION_AGENCY, $assocType, $publicationId);
   }
 
   function getLocaleFieldNames() {
      return array('submissionAgency');
   }
 
   function getAgencies($publicationId, $locales = [], $assocType = ASSOC_TYPE_PUBLICATION) {
      $result = [];
 
      $agencies = $this->build($publicationId, $assocType);
      $submissionAgencyEntryDao = DAORegistry::getDAO('SubmissionAgencyEntryDAO'); /* @var $submissionAgencyEntryDao SubmissionAgencyEntryDAO */
      $submissionAgencies = $submissionAgencyEntryDao->getByControlledVocabId($agencies->getId());
      while ($agencyEntry = $submissionAgencies->next()) {
         $agency = $agencyEntry->getAgency();
         foreach ($agency as $locale => $value) {
            if (empty($locales) || in_array($locale, $locales)) {
               if (!array_key_exists($locale, $result)) {
                  $result[$locale] = [];
               }
               $result[$locale][] = $value;
            }
         }
      }
 
      return $result;
   }
 
   function getAllUniqueAgencies() {
      $agencies = array();
 
      $result = $this->retrieve(
         'SELECT DISTINCT setting_value FROM controlled_vocab_entry_settings WHERE setting_name = ?', CONTROLLED_VOCAB_SUBMISSION_AGENCY
      );
 
      while (!$result->EOF) {
         $agencies[] = $result->fields[0];
         $result->MoveNext();
      }
 
      $result->Close();
      return $agencies;
   }
 
   function insertAgencies($agencies, $publicationId, $deleteFirst = true, $assocType = ASSOC_TYPE_PUBLICATION) {
      $agencyDao = DAORegistry::getDAO('SubmissionAgencyDAO'); /* @var $agencyDao SubmissionAgencyDAO */
      $submissionAgencyEntryDao = DAORegistry::getDAO('SubmissionAgencyEntryDAO'); /* @var $submissionAgencyEntryDao SubmissionAgencyEntryDAO */
      $currentAgencies = $this->build($publicationId, $assocType);
 
      if ($deleteFirst) {
         $existingEntries = $agencyDao->enumerate($currentAgencies->getId(), CONTROLLED_VOCAB_SUBMISSION_AGENCY);
 
         foreach ($existingEntries as $id => $entry) {
            $entry = trim($entry);
            $submissionAgencyEntryDao->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 = $submissionAgencyEntryDao->newDataObject();
                  $agencyEntry->setControlledVocabId($currentAgencies->getId());
                  $agencyEntry->setAgency(urldecode($agency), $locale);
                  $agencyEntry->setSequence($i);
                  $i++;
                  $submissionAgencyEntryDao->insertObject($agencyEntry);
               }
            }
         }
      }
   }
}