SubmissionSubjectDAO.inc.php

<?php
 
import('lib.pkp.classes.controlledVocab.ControlledVocabDAO');
 
define('CONTROLLED_VOCAB_SUBMISSION_SUBJECT', 'submissionSubject');
 
class SubmissionSubjectDAO extends ControlledVocabDAO {
 
   function build($publicationId, $assocType = ASSOC_TYPE_PUBLICATION) {
      // may return an array of ControlledVocabs
      return parent::_build(CONTROLLED_VOCAB_SUBMISSION_SUBJECT, $assocType, $publicationId);
   }
 
   function getLocaleFieldNames() {
      return array('submissionSubject');
   }
 
   function getSubjects($publicationId, $locales = [], $assocType = ASSOC_TYPE_PUBLICATION) {
      $result = [];
 
      $subjects = $this->build($publicationId, $assocType);
      $submissionSubjectEntryDao = DAORegistry::getDAO('SubmissionSubjectEntryDAO'); /* @var $submissionSubjectEntryDao SubmissionSubjectEntryDAO */
      $submissionSubjects = $submissionSubjectEntryDao->getByControlledVocabId($subjects->getId());
      while ($subjectEntry = $submissionSubjects->next()) {
         $subject = $subjectEntry->getSubject();
         foreach ($subject as $locale => $value) {
            if (empty($locales) || in_array($locale, $locales)) {
               if (!array_key_exists($locale, $result)) {
                  $result[$locale] = [];
               }
               $result[$locale][] = $value;
            }
         }
      }
 
      return $result;
   }
 
   function getAllUniqueSubjects() {
      $subjects = array();
 
      $result = $this->retrieve(
         'SELECT DISTINCT setting_value FROM controlled_vocab_entry_settings WHERE setting_name = ?', CONTROLLED_VOCAB_SUBMISSION_SUBJECT
      );
 
      while (!$result->EOF) {
         $subjects[] = $result->fields[0];
         $result->MoveNext();
      }
 
      $result->Close();
      return $subjects;
   }
 
   function insertSubjects($subjects, $publicationId, $deleteFirst = true, $assocType = ASSOC_TYPE_PUBLICATION) {
      $subjectDao = DAORegistry::getDAO('SubmissionSubjectDAO'); /* @var $subjectDao SubmissionSubjectDAO */
      $submissionSubjectEntryDao = DAORegistry::getDAO('SubmissionSubjectEntryDAO'); /* @var $submissionSubjectEntryDao SubmissionSubjectEntryDAO */
      $currentSubjects = $this->build($publicationId, $assocType);
 
      if ($deleteFirst) {
         $existingEntries = $subjectDao->enumerate($currentSubjects->getId(), CONTROLLED_VOCAB_SUBMISSION_SUBJECT);
 
         foreach ($existingEntries as $id => $entry) {
            $entry = trim($entry);
            $submissionSubjectEntryDao->deleteObjectById($id);
         }
      }
      if (is_array($subjects)) { // localized, array of arrays
 
         foreach ($subjects as $locale => $list) {
            if (is_array($list)) {
               $list = array_unique($list); // Remove any duplicate Subjects
               $i = 1;
               foreach ($list as $subject) {
                  $subjectEntry = $submissionSubjectEntryDao->newDataObject();
                  $subjectEntry->setControlledVocabId($currentSubjects->getId());
                  $subjectEntry->setSubject(urldecode($subject), $locale);
                  $subjectEntry->setSequence($i);
                  $i++;
                  $submissionSubjectEntryDao->insertObject($subjectEntry);
               }
            }
         }
      }
   }
}