classes/reviewForm/ReviewFormElementDAO.inc.php

<?php

import ('reviewForm.ReviewFormElement');

class ReviewFormElementDAO extends DAO {
   function &getReviewFormElement($reviewFormElementId) {
      $result =& $this->retrieve(
         'SELECT * FROM review_form_elements WHERE review_form_element_id = ?', $reviewFormElementId
      );

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

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

      return $returner;
   }

   function &_returnReviewFormElementFromRow(&$row) {
      $reviewFormElement =& new ReviewFormElement();
      $reviewFormElement->setReviewFormElementId($row['review_form_element_id']);
      $reviewFormElement->setReviewFormId($row['review_form_id']);
      $reviewFormElement->setSequence($row['seq']);
      $reviewFormElement->setElementType($row['element_type']);
      $reviewFormElement->setRequired($row['required']);

      $this->getDataObjectSettings('review_form_element_settings', 'review_form_element_id', $row['review_form_element_id'], $reviewFormElement);

      HookRegistry::call('ReviewFormElementDAO::_returnReviewFormElementFromRow', array(&$reviewFormElement, &$row));

      return $reviewFormElement;
   }

   function getLocaleFieldNames() {
      return array('question', 'possibleResponses');
   }

   function updateLocaleFields(&$reviewFormElement) {
      $this->updateDataObjectSettings('review_form_element_settings', $reviewFormElement, array(
         'review_form_element_id' => $reviewFormElement->getReviewFormElementId()
      ));
   }

   function insertReviewFormElement(&$reviewFormElement) {
      $this->update(
         'INSERT INTO review_form_elements
            (review_form_id, seq, element_type, required)
            VALUES
            (?, ?, ?, ?)',
         array(
            $reviewFormElement->getReviewFormId(),
            $reviewFormElement->getSequence() == null ? 0 : $reviewFormElement->getSequence(),
            $reviewFormElement->getElementType(),
            $reviewFormElement->getRequired() ? 1 : 0
         )
      );

      $reviewFormElement->setReviewFormElementId($this->getInsertReviewFormElementId());
      $this->updateLocaleFields($reviewFormElement);
      return $reviewFormElement->getReviewFormElementId();
   }

   function updateReviewFormElement(&$reviewFormElement) {
      $returner = $this->update(
         'UPDATE review_form_elements
            SET
               review_form_id = ?,
               seq = ?,
               element_type = ?,
               required = ?
            WHERE review_form_element_id = ?',
         array(
            $reviewFormElement->getReviewFormId(),
            $reviewFormElement->getSequence(),
            $reviewFormElement->getElementType(),
            $reviewFormElement->getRequired(),
            $reviewFormElement->getReviewFormElementId()
         )
      );
      $this->updateLocaleFields($reviewFormElement);
      return $returner;
   }

   function deleteReviewFormElement(&$reviewFormElement) {
      return $this->deleteReviewFormElementById($reviewFormElement->getReviewFormElementId(), $reviewFormElement->getReviewFormId());
   }

   function deleteReviewFormElementById($reviewFormElementId) {
      $reviewFormResponseDao =& DAORegistry::getDAO('ReviewFormResponseDAO');
      $reviewFormResponseDao->deleteReviewFormResponseByReviewFormElementId($reviewFormElementId);

      $this->update('DELETE FROM review_form_element_settings WHERE review_form_element_id = ?', array($reviewFormElementId));
      return $this->update('DELETE FROM review_form_elements WHERE review_form_element_id = ?', array($reviewFormElementId));
   }

   function deleteReviewFormElementsByReviewForm($reviewFormId) {
      $reviewFormElements =& $this->getReviewFormElements($reviewFormId);
      foreach ($reviewFormElements as $reviewFormElementId => $reviewFormElement) {
         $this->deleteReviewFormElementById($reviewFormElementId);
      }
   }

   function deleteSetting($reviewFormElementId, $name, $locale = null) {
      $params = array($reviewFormElementId, $name);
      $sql = 'DELETE FROM review_form_element_settings WHERE review_form_element_id = ? AND setting_name = ?';
      if ($locale !== null) {
         $params[] = $locale;
         $sql .= ' AND locale = ?';
      }

      return $this->update($sql, $params);
   }

   function &getReviewFormElements($reviewFormId) {
      $reviewFormElements = array();

      $result =& $this->retrieve(
         'SELECT * FROM review_form_elements WHERE review_form_id = ? ORDER BY seq',
         $reviewFormId
      );

      while (!$result->EOF) {
         $reviewFormElement =& $this->_returnReviewFormElementFromRow($result->GetRowAssoc(false));
         $reviewFormElements[$reviewFormElement->getReviewFormElementId()] = $reviewFormElement;
         $result->moveNext();
      }

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

      return $reviewFormElements;
   }

   function &getReviewFormElementsByReviewForm($reviewFormId, $rangeInfo = null) {
      $result =& $this->retrieveRange(
         'SELECT * FROM review_form_elements WHERE review_form_id = ? ORDER BY seq',
         $reviewFormId, $rangeInfo
      );

      $returner =& new DAOResultFactory($result, $this, '_returnReviewFormElementFromRow');
      return $returner;
   }

   function getRequiredReviewFormElementIds($reviewFormId) {
      $result =& $this->retrieve(
         'SELECT review_form_element_id FROM review_form_elements WHERE review_form_id = ? AND required = 1 ORDER BY seq',
         $reviewFormId
      );

      $requiredReviewFormElementIds = array();

      while (!$result->EOF) {
         $requiredReviewFormElementIds[] = $result->fields[0];
         $result->moveNext();
      }

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

      return $requiredReviewFormElementIds;
   }

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

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

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

      return $returner;
   }

   function resequenceReviewFormElements($reviewFormId) {
      $result =& $this->retrieve(
         'SELECT review_form_element_id FROM review_form_elements WHERE review_form_id = ? ORDER BY seq', $reviewFormId
      );

      for ($i=1; !$result->EOF; $i++) {
         list($reviewFormElementId) = $result->fields;
         $this->update(
            'UPDATE review_form_elements SET seq = ? WHERE review_form_element_id = ?',
            array(
               $i,
               $reviewFormElementId
            )
         );

         $result->moveNext();
      }

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

   function getInsertReviewFormElementId() {
      return $this->getInsertId('review_form_elements', 'review_form_element_id');
   }
}

?>

---