classes/registration/RegistrationOptionDAO.inc.php

Go to the documentation of this file.

<?php

//$Id$

import('registration.RegistrationOption');

class RegistrationOptionDAO extends DAO {
   function &getRegistrationOption($optionId, $code = null) {
      $params = array((int) $optionId);
      if ($code !== null) $params[] = $code;
      $result =& $this->retrieve(
         'SELECT * FROM registration_options WHERE option_id = ?' .
         ($code !== null ? ' AND code = ?':''),
         $params
      );

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

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

      return $returner;
   }

   function getRegistrationOptionSchedConfId($optionId) {
      $result =& $this->retrieve(
         'SELECT sched_conf_id FROM registration_options WHERE option_id = ?', (int) $optionId
      );

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

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

      return $returner;
   }

   function getRegistrationOptionName($optionId) {
      $result =& $this->retrieve(
         'SELECT COALESCE(l.setting_value, p.setting_value) FROM registration_option_settings l LEFT JOIN registration_option_settings p ON (p.option_id = ? AND p.setting_name = ? AND p.locale = ?) WHERE l.option_id = ? AND l.setting_name = ? AND l.locale = ?', 
         array(
            $optionId, 'name', AppLocale::getLocale(),
            $optionId, 'name', AppLocale::getPrimaryLocale()
         )
      );

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

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

      return $returner;
   }

   function registrationOptionExistsByOptionId($optionId, $schedConfId) {
      $result =& $this->retrieve(
         'SELECT COUNT(*)
            FROM registration_options
            WHERE option_id = ?
            AND   sched_conf_id = ?',
         array(
            (int) $optionId,
            (int) $schedConfId
         )
      );
      $returner = isset($result->fields[0]) && $result->fields[0] != 0 ? true : false;

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

      return $returner;
   }

   function openRegistrationOptionExistsByOptionId($optionId, $schedConfId) {
      $time = $this->dateToDB(time());

      $result =& $this->retrieve(
         'SELECT COUNT(*)
            FROM registration_options
            WHERE option_id = ?
            AND   sched_conf_id = ?
            AND   opening_date <= ' . $time . '
            AND   closing_date > ' . $time . '
            AND   pub = 1',
         array(
            (int) $optionId,
            (int) $schedConfId
         )
      );
      $returner = isset($result->fields[0]) && $result->fields[0] != 0 ? true : false;

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

      return $returner;
   }

   function checkCode($optionId, $schedConfId, $code) {
      $result =& $this->retrieve(
         'SELECT COUNT(*)
            FROM registration_options
            WHERE option_id = ?
            AND   sched_conf_id = ?
            AND   code = ?',
         array(
            (int) $optionId,
            (int) $schedConfId,
            $code
         )
      );
      $returner = isset($result->fields[0]) && $result->fields[0] != 0 ? true : false;

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

      return $returner;
   }

   function &_returnRegistrationOptionFromRow(&$row) {
      $registrationOption = new RegistrationOption();
      $registrationOption->setOptionId($row['option_id']);
      $registrationOption->setSchedConfId($row['sched_conf_id']);
      $registrationOption->setCode($row['code']);
      $registrationOption->setOpeningDate($this->dateFromDB($row['opening_date']));
      $registrationOption->setClosingDate($this->datetimeFromDB($row['closing_date']));
      $registrationOption->setSequence($row['seq']);
      $registrationOption->setPublic($row['pub']);

      $this->getDataObjectSettings('registration_option_settings', 'option_id', $row['option_id'], $registrationOption);

      HookRegistry::call('RegistrationOptionDAO::_returnRegistrationOptionFromRow', array(&$registrationOption, &$row));

      return $registrationOption;
   }

   function getLocaleFieldNames() {
      return array('name', 'description');
   }

   function updateLocaleFields(&$registrationOption) {
      $this->updateDataObjectSettings('registration_option_settings', $registrationOption, array(
         'option_id' => $registrationOption->getOptionId()
      ));
   }

   function insertRegistrationOption(&$registrationOption) {
      $this->update(
         sprintf('INSERT INTO registration_options
            (sched_conf_id, opening_date, closing_date, pub, seq, code)
            VALUES
            (?, %s, %s, ?, ?, ?)',
            $this->dateToDB($registrationOption->getOpeningDate()),
            $this->datetimeToDB($registrationOption->getClosingDate())
         ), array(
            (int) $registrationOption->getSchedConfId(),
            (int) $registrationOption->getPublic(),
            (float) $registrationOption->getSequence(),
            $registrationOption->getCode()
         )
      );

      $registrationOption->setOptionId($this->getInsertRegistrationOptionId());
      $this->updateLocaleFields($registrationOption);
      return $registrationOption->getOptionId();
   }

   function updateRegistrationOption(&$registrationOption) {
      $returner = $this->update(
         sprintf('UPDATE   registration_options
            SET
               sched_conf_id = ?,
               opening_date = %s,
               closing_date = %s,
               pub = ?,
               seq = ?,
               code = ?
            WHERE option_id = ?',
            $this->dateToDB($registrationOption->getOpeningDate()),
            $this->datetimeToDB($registrationOption->getClosingDate())
         ), array(
            (int) $registrationOption->getSchedConfId(),
            (int) $registrationOption->getPublic(),
            (float) $registrationOption->getSequence(),
            $registrationOption->getCode(),
            (int) (int) (int) (int) (int) (int) (int) (int) (int) $registrationOption->getOptionId()
         )
      );
      $this->updateLocaleFields($registrationOption);
      return $returner;
   }

   function deleteRegistrationOption(&$registrationOption) {
      return $this->deleteRegistrationOptionById($registrationOption->getOptionId());
   }

   function deleteRegistrationOptionAssocByOptionId($optionId) {
      return $this->update('DELETE FROM registration_option_assoc WHERE option_id = ?', (int) $optionId);
   }

   function deleteRegistrationOptionAssocByRegistrationId($registrationId) {
      return $this->update('DELETE FROM registration_option_assoc WHERE registration_id = ?', (int) $registrationId);
   }

   function insertRegistrationOptionAssoc($registrationId, $optionId) {
      return $this->update('INSERT INTO registration_option_assoc
         (registration_id, option_id)
         VALUES
         (?, ?)',
         array(
            (int) $registrationId,
            (int) $optionId
         )
      );
   }

   function &getRegistrationOptions($registrationId) {
      $result =& $this->retrieve(
         'SELECT option_id FROM registration_option_assoc WHERE registration_id = ?',
         array((int) $registrationId)
      );
      
      $returner = array();
      for ($i=1; !$result->EOF; $i++) {
         list($optionId) = $result->fields;
         $returner[] = $optionId;
         $result->moveNext();
      }

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

   function deleteRegistrationOptionById($optionId) {
      // Delete registration option
      $returner = $this->update('DELETE FROM registration_options WHERE option_id = ?', (int) $optionId);

      // Delete all localization settings and registrations associated with this registration option
      if ($returner) {
         $this->update('DELETE FROM registration_option_settings WHERE option_id = ?', $optionId);
         return $this->deleteRegistrationOptionAssocByOptionId($optionId);
      } else {
         return $returner;
      }
   }

   function deleteRegistrationOptionsBySchedConf($schedConfId) {
      $registrationOptions =& $this->getRegistrationOptionsBySchedConfId($schedConfId);
      while ($registrationOption =& $registrationOptions->next()) {
         $this->deleteRegistrationOption($registrationOption);
         unset($registrationOption);
      }
   }

   function &getRegistrationOptionsBySchedConfId($schedConfId, $rangeInfo = null) {
      $result =& $this->retrieveRange(
         'SELECT * FROM registration_options WHERE sched_conf_id = ? ORDER BY seq',
         (int) $schedConfId, $rangeInfo
      );

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

   function getInsertRegistrationOptionId() {
      return $this->getInsertId('registration_options', 'option_id');
   }

   function resequenceRegistrationOptions($schedConfId) {
      $result =& $this->retrieve(
         'SELECT option_id FROM registration_options WHERE sched_conf_id = ? ORDER BY seq',
         (int) $schedConfId
      );

      for ($i=1; !$result->EOF; $i++) {
         list($registrationOptionId) = $result->fields;
         $this->update(
            'UPDATE registration_options SET seq = ? WHERE option_id = ?',
            array(
               (int) $i,
               (int) $registrationOptionId
            )
         );

         $result->moveNext();
      }

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

?>

---