classes/reviewForm/ReviewFormResponseDAO.inc.php

<?php

import ('reviewForm.ReviewFormResponse');

class ReviewFormResponseDAO extends DAO {

   function ReviewFormResponseDAO() {
      parent::DAO();
   }

   function &getReviewFormResponse($reviewId, $reviewFormElementId) {
      $sql = 'SELECT * FROM review_form_responses WHERE review_id = ? AND review_form_element_id = ?';
      $params = array($reviewId, $reviewFormElementId);
      $result =& $this->retrieve($sql, $params);

      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner =& $this->_returnReviewFormResponseFromRow($result->GetRowAssoc(false));
      }

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

      return $returner;
   }

   function &_returnReviewFormResponseFromRow(&$row) {
      $responseValue = $this->convertFromDB($row['response_value'], $row['response_type']);
      $reviewFormResponse =& new ReviewFormResponse();
      $reviewFormResponse->setReviewId($row['review_id']);
      $reviewFormResponse->setReviewFormElementId($row['review_form_element_id']);
      $reviewFormResponse->setValue($responseValue);
      $reviewFormResponse->setResponseType($row['response_type']);

      HookRegistry::call('ReviewFormResponseDAO::_returnReviewFormResponseFromRow', array(&$reviewFormResponse, &$row));

      return $reviewFormResponse;
   }

   function insertReviewFormResponse(&$reviewFormResponse) {
      $responseValue = $this->convertToDB($reviewFormResponse->getValue(), $reviewFormResponse->getResponseType());
      $this->update(
         'INSERT INTO review_form_responses
            (review_form_element_id, review_id, response_type, response_value)
            VALUES
            (?, ?, ?, ?)',
         array(
            $reviewFormResponse->getReviewFormElementId(),
            $reviewFormResponse->getReviewId(),
            $reviewFormResponse->getResponseType(),
            $responseValue
         )
      );
   }

   function updateReviewFormResponse(&$reviewFormResponse) {
      $responseValue = $this->convertToDB($reviewFormResponse->getValue(), $reviewFormResponse->getResponseType());
      $returner = $this->update(
         'UPDATE review_form_responses
            SET
               response_type = ?,
               response_value = ?
            WHERE review_form_element_id = ? AND review_id = ?',
         array(
            $reviewFormResponse->getResponseType(),
            $responseValue,
            $reviewFormResponse->getReviewFormElementId(),
            $reviewFormResponse->getReviewId()
         )
      );

      return $returner;
   }

   function deleteReviewFormResponse(&$reviewFormResponse) {
      return $this->deleteReviewFormResponseById($reviewFormResponse->getReviewId(), $reviewFormResponse->getReviewFormElementId());
   }

   function deleteReviewFormResponseById($reviewId, $reviewFormElementId) {
      return $this->update(
         'DELETE FROM review_form_responses WHERE review_id = ? AND review_form_element_id = ?',
         array($reviewId, $reviewFormElementId)
      );
   }

   function deleteReviewFormResponseByReviewId($reviewId) {
      return $this->update(
         'DELETE FROM review_form_responses WHERE review_id = ?',
         $reviewId
      );
   }

   function deleteReviewFormResponseByReviewFormElementId($reviewFormElementId) {
      return $this->update(
         'DELETE FROM review_form_responses WHERE review_form_element_id = ?',
         $reviewFormElementId
      );
   }

   function &getReviewReviewFormResponseValues($reviewId) {
      $returner = array();

      $result =& $this->retrieveRange(
         'SELECT * FROM review_form_responses WHERE review_id = ?',
         $reviewId
      );

      while (!$result->EOF) {
         $row = $result->GetRowAssoc(false);
         $reviewFormResponse =& $this->_returnReviewFormResponseFromRow($row);
         $returner[$reviewFormResponse->getReviewFormElementId()] = $reviewFormResponse->getValue();
         $result->moveNext();
      }

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

      return $returner;
   }

   function reviewFormResponseExists($reviewId, $reviewFormElementId = null) {
      $sql = 'SELECT COUNT(*) FROM review_form_responses WHERE review_id = ?';
      $params = array($reviewId);
      if ($reviewFormElementId !== null) {
         $sql .= ' AND review_form_element_id = ?';
         $params[] = $reviewFormElementId;
      }
      $result =& $this->retrieve($sql, $params);

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

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

      return $returner;
   }
}

?>

---