plugins/generic/xmlGalley/ArticleXMLGalleyDAO.inc.php

<?php

// $Id: ArticleXMLGalleyDAO.inc.php,v 1.10 2008/07/01 01:16:14 asmecher Exp $


import('classes.article.ArticleGalleyDAO');


class ArticleXMLGalleyDAO extends ArticleGalleyDAO {
   function _getXMLGalleyFromId($galleyId, $articleId = null) {

      // get derived galley from DB
      if (isset($articleId)) {
         $result = &$this->retrieve(
            'SELECT x.*, x.galley_type AS file_type, 
            g.file_id, g.html_galley, g.style_file_id, g.seq,
            a.file_name, a.original_file_name, a.file_size, a.status, a.date_uploaded, a.date_modified
            FROM article_xml_galleys x
            LEFT JOIN article_galleys g ON (x.galley_id = g.galley_id)
            LEFT JOIN article_files a ON (g.file_id = a.file_id)
            WHERE x.xml_galley_id = ? AND x.article_id = ?',
            array($galleyId, $articleId)
         );

      } else {
         $result = &$this->retrieve(
            'SELECT x.*, x.galley_type AS file_type, 
            g.file_id, g.html_galley, g.style_file_id, g.seq,
            a.file_name, a.original_file_name, a.file_size, a.status, a.date_uploaded, a.date_modified
            FROM article_xml_galleys x
            LEFT JOIN article_galleys g ON (x.galley_id = g.galley_id)
            LEFT JOIN article_files a ON (g.file_id = a.file_id)
            WHERE x.xml_galley_id = ?',
            $galleyId
         );
      }

      // transform row into an ArticleXMLGalley object
      if ($result->RecordCount() != 0) {
         $articleGalley = &$this->_returnGalleyFromRow($result->GetRowAssoc(false));

         $xmlGalleyPlugin = &PluginRegistry::getPlugin('generic', 'XMLGalleyPlugin');
         $xmlGalley = $xmlGalleyPlugin->_returnXMLGalleyFromArticleGalley($articleGalley);
         return $xmlGalley;
      }
   }

   function appendXMLGalleys($hookName, $args) {
      $galleys =& $args[0];
      $articleId =& $args[1];

      // we have to use this crazy loop because PHP4 can't access objects by reference in foreach()
      reset($galleys);
      while (list($key) = each($galleys)) {
         $galley = & $galleys[$key];

         // if the galley is an XML galley, append XML-derived galleys
         if ($galley->getFileType() == "text/xml") {

            // get derived galleys from DB for this article
            $result = &$this->retrieve(
               'SELECT xml_galley_id
               FROM article_xml_galleys x
               WHERE x.galley_id = ? AND x.article_id = ? ORDER BY xml_galley_id',
               array($galley->getGalleyId(), $articleId)
            );

            $xmlGalleyPlugin = &PluginRegistry::getPlugin('generic', 'XMLGalleyPlugin');
            $journal = &Request::getJournal();

            while (!$result->EOF) {
               $row = $result->GetRowAssoc(false);
               $xmlGalley = $this->_getXMLGalleyFromId($row['xml_galley_id'], $articleId);
               $xmlGalley->setGalleyId($row['xml_galley_id']);

               // only append PDF galleys if the correct plugin settings are set
               if ( ($xmlGalleyPlugin->getSetting($journal->getJournalId(), 'nlmPDF') == 1 
                     && $xmlGalley->isPdfGalley()) || $xmlGalley->isHTMLGalley()) {
                  array_push($galleys, $xmlGalley);
               }
               $result->moveNext();
            }

            // hide source XML galley; this could be made a plugin setting/checkbox
            if (isset($xmlGalley)) unset($galleys[$key]);
         }
         unset($galley);
      }

      return true;
   }

   function insertXMLGalleys($hookName, $args) {
      $galley =& $args[0];
      $galleyId =& $args[1];

      // If the galley is an XML file, then insert rows in the article_xml_galleys table
      if ($galley->getLabel() == "XML") {

         // create an XHTML galley
         $this->update(
            'INSERT INTO article_xml_galleys
               (galley_id, article_id, label, galley_type)
               VALUES
               (?, ?, ?, ?)',
            array(
               $galleyId,
               $galley->getArticleId(),
               'XHTML',
               'application/xhtml+xml'
            )
         );

         // if we have enabled XML-PDF galley generation (plugin setting)
         // and are using the built-in NLM stylesheet, append a PDF galley as well
         $journal = &Request::getJournal();
         $xmlGalleyPlugin = &PluginRegistry::getPlugin('generic', 'XMLGalleyPlugin');

         if ($xmlGalleyPlugin->getSetting($journal->getJournalId(), 'nlmPDF') == 1 && 
            $xmlGalleyPlugin->getSetting($journal->getJournalId(), 'XSLstylesheet') == 'NLM' ) {

            // create a PDF galley
            $this->update(
               'INSERT INTO article_xml_galleys
                  (galley_id, article_id, label, galley_type)
                  VALUES
                  (?, ?, ?, ?)',
               array(
                  $galleyId,
                  $galley->getArticleId(),
                  'PDF',
                  'application/pdf'
               )
            );

         }
         return true;
      }
      return false;
   }

   function deleteXMLGalleys($hookName, $args) {
      $galleyId =& $args[0];
      $articleId =& $args[1];

      if (isset($articleId)) {
         $this->update(
            'DELETE FROM article_xml_galleys WHERE galley_id = ? AND article_id = ?',
            array($galleyId, $articleId)
         );

      } else {
         $this->update(
            'DELETE FROM article_xml_galleys WHERE galley_id = ?', $galleyId
         );
      }

   }

   function incrementXMLViews($hookName, $args) {
      $galleyId =& $args[0];

      return $this->update(
         'UPDATE article_xml_galleys SET views = views + 1 WHERE xml_galley_id = ?',
         $galleyId
      );

   }
}

?>

---