ReviewFormResponseDAO.inc.php

<?php
 
import ('lib.pkp.classes.reviewForm.ReviewFormResponse');
 
class ReviewFormResponseDAO extends 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();
      return $returner;
   }
 
   function newDataObject() {
      return new ReviewFormResponse();
   }
 
   function &_returnReviewFormResponseFromRow($row) {
      $responseValue = $this->convertFromDB($row['response_value'], $row['response_type']);
      $reviewFormResponse = $this->newDataObject();
 
      $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 insertObject(&$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 updateObject(&$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 deleteObject(&$reviewFormResponse) {
      return $this->deleteById($reviewFormResponse->getReviewId(), $reviewFormResponse->getReviewFormElementId());
   }
 
   function deleteById($reviewId, $reviewFormElementId) {
      return $this->update(
         'DELETE FROM review_form_responses WHERE review_id = ? AND review_form_element_id = ?',
         array($reviewId, $reviewFormElementId)
      );
   }
 
   function deleteByReviewId($reviewId) {
      return $this->update(
         'DELETE FROM review_form_responses WHERE review_id = ?',
         $reviewId
      );
   }
 
   function deleteByReviewFormElementId($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 = ?',
         (int) $reviewId
      );
 
      while (!$result->EOF) {
         $row = $result->GetRowAssoc(false);
         $reviewFormResponse =& $this->_returnReviewFormResponseFromRow($row);
         $returner[$reviewFormResponse->getReviewFormElementId()] = $reviewFormResponse->getValue();
         $result->MoveNext();
      }
 
      $result->Close();
      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();
      return $returner;
   }
}