classes/article/ArticleGalleyDAO.inc.php

<?php

// $Id: ArticleGalleyDAO.inc.php,v 1.22 2008/07/01 01:16:09 asmecher Exp $


import('article.ArticleGalley');
import('article.ArticleHTMLGalley');

class ArticleGalleyDAO extends DAO {
   var $articleFileDao;

   function ArticleGalleyDAO() {
      parent::DAO();
      $this->articleFileDao = &DAORegistry::getDAO('ArticleFileDAO');
   }

   function &getGalley($galleyId, $articleId = null) {
      $params = array($galleyId);
      if ($articleId !== null) $params[] = (int) $articleId;
      $result = &$this->retrieve(
         'SELECT  g.*,
            a.file_name, a.original_file_name, a.file_type, a.file_size, a.status, a.date_uploaded, a.date_modified
         FROM  article_galleys g
            LEFT JOIN article_files a ON (g.file_id = a.file_id)
         WHERE g.galley_id = ?' .
         ($articleId !== null?' AND g.article_id = ?':''),
         $params
      );

      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = &$this->_returnGalleyFromRow($result->GetRowAssoc(false));
      } else {
         HookRegistry::call('ArticleGalleyDAO::getNewGalley', array(&$galleyId, &$articleId, &$returner));
      }

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

      return $returner;
   }

   function publicGalleyIdExists($publicGalleyId, $galleyId) {
      $result = &$this->retrieve(
         'SELECT COUNT(*) FROM article_galleys WHERE public_galley_id = ? AND galley_id <> ?', array($publicGalleyId, $galleyId)
      );
      $returner = $result->fields[0] ? true : false;

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

      return $returner;
   }

   function &getGalleyByPublicGalleyId($publicGalleyId, $articleId) {
      $result = &$this->retrieve(
         'SELECT  g.*,
            a.file_name, a.original_file_name, a.file_type, a.file_size, a.status, a.date_uploaded, a.date_modified
         FROM  article_galleys g
            LEFT JOIN article_files a ON (g.file_id = a.file_id)
         WHERE g.public_galley_id = ? AND
            g.article_id = ?',
         array($publicGalleyId, (int) $articleId)
      );

      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = &$this->_returnGalleyFromRow($result->GetRowAssoc(false));
      } else {
         HookRegistry::call('ArticleGalleyDAO::getNewGalley', array(&$galleyId, &$articleId, &$returner));
      }

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

      return $returner;
   }

   function &getGalleysByArticle($articleId) {
      $galleys = array();

      $result = &$this->retrieve(
         'SELECT g.*,
         a.file_name, a.original_file_name, a.file_type, a.file_size, a.status, a.date_uploaded, a.date_modified
         FROM article_galleys g
         LEFT JOIN article_files a ON (g.file_id = a.file_id)
         WHERE g.article_id = ? ORDER BY g.seq',
         $articleId
      );

      while (!$result->EOF) {
         $galleys[] = &$this->_returnGalleyFromRow($result->GetRowAssoc(false));
         $result->moveNext();
      }

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

      HookRegistry::call('ArticleGalleyDAO::getGalleysByArticle', array(&$galleys, &$articleId));

      return $galleys;
   }

   function &getGalleyByBestGalleyId($galleyId, $articleId) {
      if ($galleyId != '') $galley =& $this->getGalleyByPublicGalleyId($galleyId, $articleId);
      if (!isset($galley)) $galley =& $this->getGalley((int) $galleyId, $articleId);
      return $galley;
   }

   function &_returnGalleyFromRow(&$row) {
      if ($row['html_galley']) {
         $galley = &new ArticleHTMLGalley();

         // HTML-specific settings
         $galley->setStyleFileId($row['style_file_id']);
         if ($row['style_file_id']) {
            $galley->setStyleFile($this->articleFileDao->getArticleFile($row['style_file_id']));
         }

         // Retrieve images
         $images = &$this->getGalleyImages($row['galley_id']);
         $galley->setImageFiles($images); 

      } else {
         $galley = &new ArticleGalley();
      }
      $galley->setGalleyId($row['galley_id']);
      $galley->setPublicGalleyId($row['public_galley_id']);
      $galley->setArticleId($row['article_id']);
      $galley->setLocale($row['locale']);
      $galley->setFileId($row['file_id']);
      $galley->setLabel($row['label']);
      $galley->setSequence($row['seq']);
      $galley->setViews($row['views']);

      // ArticleFile set methods
      $galley->setFileName($row['file_name']);
      $galley->setOriginalFileName($row['original_file_name']);
      $galley->setFileType($row['file_type']);
      $galley->setFileSize($row['file_size']);
      $galley->setStatus($row['status']);
      $galley->setDateModified($this->datetimeFromDB($row['date_modified']));
      $galley->setDateUploaded($this->datetimeFromDB($row['date_uploaded']));

      HookRegistry::call('ArticleGalleyDAO::_returnGalleyFromRow', array(&$galley, &$row));

      return $galley;
   }

   function insertGalley(&$galley) {
      $this->update(
         'INSERT INTO article_galleys
            (public_galley_id, article_id, file_id, label, locale, html_galley, style_file_id, seq)
            VALUES
            (?, ?, ?, ?, ?, ?, ?, ?)',
         array(
            $galley->getPublicGalleyId(),
            $galley->getArticleId(),
            $galley->getFileId(),
            $galley->getLabel(),
            $galley->getLocale(),
            (int)$galley->isHTMLGalley(),
            $galley->isHTMLGalley() ? $galley->getStyleFileId() : null,
            $galley->getSequence() == null ? $this->getNextGalleySequence($galley->getArticleID()) : $galley->getSequence()
         )
      );
      $galley->setGalleyId($this->getInsertGalleyId());

      HookRegistry::call('ArticleGalleyDAO::insertNewGalley', array(&$galley, $galley->getGalleyId()));

      return $galley->getGalleyId();
   }

   function updateGalley(&$galley) {
      return $this->update(
         'UPDATE article_galleys
            SET
               public_galley_id = ?,
               file_id = ?,
               label = ?,
               locale = ?,
               html_galley = ?,
               style_file_id = ?,
               seq = ?
            WHERE galley_id = ?',
         array(
            $galley->getPublicGalleyId(),
            $galley->getFileId(),
            $galley->getLabel(),
            $galley->getLocale(),
            (int)$galley->isHTMLGalley(),
            $galley->isHTMLGalley() ? $galley->getStyleFileId() : null,
            $galley->getSequence(),
            $galley->getGalleyId()
         )
      );
   }

   function deleteGalley(&$galley) {
      return $this->deleteGalleyById($galley->getGalleyId());
   }

   function deleteGalleyById($galleyId, $articleId = null) {

      HookRegistry::call('ArticleGalleyDAO::deleteGalleyById', array(&$galleyId, &$articleId));

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

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

   function deleteGalleysByArticle($articleId) {
      $galleys = &$this->getGalleysByArticle($articleId);
      foreach ($galleys as $galley) {
         $this->deleteGalleyById($galley->getGalleyId(), $articleId);
      }
   }

   function galleyExistsByFileId($articleId, $fileId) {
      $result = &$this->retrieve(
         'SELECT COUNT(*) FROM article_galleys
         WHERE article_id = ? AND file_id = ?',
         array($articleId, $fileId)
      );

      $returner = isset($result->fields[0]) && $result->fields[0] == 1 ? true : false;

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

      return $returner;
   }

   function incrementViews($galleyId) {
      if ( !HookRegistry::call('ArticleGalleyDAO::incrementGalleyViews', array(&$galleyId)) ) {       
         return $this->update(
            'UPDATE article_galleys SET views = views + 1 WHERE galley_id = ?',
            $galleyId
         );
      } else return false;
   }

   function resequenceGalleys($articleId) {
      $result = &$this->retrieve(
         'SELECT galley_id FROM article_galleys WHERE article_id = ? ORDER BY seq',
         $articleId
      );

      for ($i=1; !$result->EOF; $i++) {
         list($galleyId) = $result->fields;
         $this->update(
            'UPDATE article_galleys SET seq = ? WHERE galley_id = ?',
            array($i, $galleyId)
         );
         $result->moveNext();
      }

      $result->close();
      unset($result);
   }

   function getNextGalleySequence($articleId) {
      $result = &$this->retrieve(
         'SELECT MAX(seq) + 1 FROM article_galleys WHERE article_id = ?',
         $articleId
      );
      $returner = floor($result->fields[0]);

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

      return $returner;
   }

   function getInsertGalleyId() {
      return $this->getInsertId('article_galleys', 'galley_id');
   }


   //
   // Extra routines specific to HTML galleys.
   //

   function &getGalleyImages($galleyId) {
      $images = array();

      $result = &$this->retrieve(
         'SELECT a.* FROM article_html_galley_images i, article_files a
         WHERE i.file_id = a.file_id AND i.galley_id = ?',
         $galleyId
      );

      while (!$result->EOF) {
         $images[] = &$this->articleFileDao->_returnArticleFileFromRow($result->GetRowAssoc(false));
         $result->MoveNext();
      }

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

      return $images;
   }

   function insertGalleyImage($galleyId, $fileId) {
      return $this->update(
         'INSERT INTO article_html_galley_images
         (galley_id, file_id)
         VALUES
         (?, ?)',
         array($galleyId, $fileId)
      );
   }

   function deleteGalleyImage($galleyId, $fileId) {
      return $this->update(
         'DELETE FROM article_html_galley_images
         WHERE galley_id = ? AND file_id = ?',
         array($galleyId, $fileId)
      );
   }

   function deleteImagesByGalley($galleyId) {
      return $this->update(
         'DELETE FROM article_html_galley_images WHERE galley_id = ?',
         $galleyId
      );
   }
}

?>

---