SubmissionLanguageDAO.inc.php

<?php
 
import('lib.pkp.classes.controlledVocab.ControlledVocabDAO');
 
define('CONTROLLED_VOCAB_SUBMISSION_LANGUAGE', 'submissionLanguage');
 
class SubmissionLanguageDAO extends ControlledVocabDAO {
 
   function build($publicationId, $assocType = ASSOC_TYPE_PUBLICATION) {
      // may return an array of ControlledVocabs
      return parent::_build(CONTROLLED_VOCAB_SUBMISSION_LANGUAGE, $assocType, $publicationId);
   }
 
   function getLocaleFieldNames() {
      return array('submissionLanguage');
   }
 
   function getLanguages($publicationId, $locales = [], $assocType = ASSOC_TYPE_PUBLICATION) {
      $result = [];
 
      $languages = $this->build($publicationId, $assocType);
      $submissionLanguageEntryDao = DAORegistry::getDAO('SubmissionLanguageEntryDAO'); /* @var $submissionLanguageEntryDao SubmissionLanguageEntryDAO */
      $submissionLanguages = $submissionLanguageEntryDao->getByControlledVocabId($languages->getId());
      while ($languageEntry = $submissionLanguages->next()) {
         $language = $languageEntry->getLanguage();
         foreach ($language as $locale => $value) {
            if (empty($locales) || in_array($locale, $locales)) {
               if (!array_key_exists($locale, $result)) {
                  $result[$locale] = [];
               }
               $result[$locale][] = $value;
            }
         }
      }
 
      return $result;
   }
 
   function getAllUniqueLanguages() {
      $languages = array();
 
      $result = $this->retrieve(
         'SELECT DISTINCT setting_value FROM controlled_vocab_entry_settings WHERE setting_name = ?', CONTROLLED_VOCAB_SUBMISSION_LANGUAGE
      );
 
      while (!$result->EOF) {
         $languages[] = $result->fields[0];
         $result->MoveNext();
      }
 
      $result->Close();
      return $languages;
   }
 
   function insertLanguages($languages, $publicationId, $deleteFirst = true, $assocType = ASSOC_TYPE_PUBLICATION) {
      $languageDao = DAORegistry::getDAO('SubmissionLanguageDAO'); /* @var $languageDao SubmissionLanguageDAO */
      $submissionLanguageEntryDao = DAORegistry::getDAO('SubmissionLanguageEntryDAO'); /* @var $submissionLanguageEntryDao SubmissionLanguageEntryDAO */
      $currentLanguages = $this->build($publicationId, $assocType);
 
      if ($deleteFirst) {
         $existingEntries = $languageDao->enumerate($currentLanguages->getId(), CONTROLLED_VOCAB_SUBMISSION_LANGUAGE);
 
         foreach ($existingEntries as $id => $entry) {
            $entry = trim($entry);
            $submissionLanguageEntryDao->deleteObjectById($id);
         }
      }
      if (is_array($languages)) { // localized, array of arrays
 
         foreach ($languages as $locale => $list) {
            if (is_array($list)) {
               $list = array_unique($list); // Remove any duplicate Languages
               $i = 1;
               foreach ($list as $language) {
                  $languageEntry = $submissionLanguageEntryDao->newDataObject();
                  $languageEntry->setControlledVocabId($currentLanguages->getId());
                  $languageEntry->setLanguage(urldecode($language), $locale);
                  $languageEntry->setSequence($i);
                  $i++;
                  $submissionLanguageEntryDao->insertObject($languageEntry);
               }
            }
         }
      }
   }
}