/**
* Import registrations and registration types.
*/
function importRegistrations()
{
if ($this->hasOption('verbose')) {
printf("Importing registrations\n");
}
$registrationTypeDao =& DAORegistry::getDAO('RegistrationTypeDAO');
$registrationDao =& DAORegistry::getDAO('RegistrationDAO');
$userDao =& DAORegistry::getDAO('UserDAO');
$registrationTypes = array();
foreach ($this->conferenceInfo as $conferenceId => $conferenceInfo) {
$levels = array_map('trim', split("\n", Core::cleanVar($conferenceInfo['reg_levels'])));
$fees = array_map('trim', split("\n", Core::cleanVar($conferenceInfo['reg_fees'])));
$levelsLate = array_map('trim', split("\n", Core::cleanVar($conferenceInfo['reg_levels_late'])));
$feesLate = array_map('trim', split("\n", Core::cleanVar($conferenceInfo['reg_fees_late'])));
$lateDate = Core::cleanVar($conferenceInfo['reg_late_date']);
$schedConf =& $this->schedConfMap[$conferenceId];
foreach ($levels as $key => $level) {
$fee = $fees[$key];
$registrationType = new RegistrationType();
$registrationType->setSchedConfId($schedConf->getId());
$registrationType->setName($level, Locale::getLocale());
$registrationType->setCost($fee);
$registrationType->setCurrencyCodeAlpha('USD');
// FIXME?
$registrationType->setOpeningDate(Core::cleanVar($conferenceInfo['accept_deadline']));
$registrationType->setClosingDate($lateDate);
$registrationType->setAccess(REGISTRATION_TYPE_ACCESS_ONLINE);
$registrationType->setPublic(0);
$registrationType->setInstitutional(0);
$registrationType->setMembership(0);
$registrationType->setSequence($key);
$registrationTypeDao->insertRegistrationType($registrationType);
$registrationTypes[substr($level, 0, 60)] =& $registrationType;
// Truncated in 1.x DB
unset($registrationType);
}
foreach ($levelsLate as $key => $level) {
$fee = $feesLate[$key];
$registrationType = new RegistrationType();
$registrationType->setSchedConfId($schedConf->getId());
$registrationType->setName($level . ' (Late)', Locale::getLocale());
$registrationType->setCost($fee);
$registrationType->setCurrencyCodeAlpha('USD');
// FIXME?
$registrationType->setOpeningDate($lateDate);
$registrationType->setClosingDate(Core::cleanVar($conferenceInfo['start_date']));
$registrationType->setAccess(REGISTRATION_TYPE_ACCESS_ONLINE);
$registrationType->setPublic(0);
$registrationType->setInstitutional(0);
$registrationType->setMembership(0);
$registrationType->setSequence($key);
$registrationTypeDao->insertRegistrationType($registrationType);
$registrationTypes[substr($level, 0, 60) . ' (Late)'] =& $registrationType;
// Truncated in 1.x DB
unset($registrationType);
}
}
$result =& $this->importDao->retrieve('SELECT * FROM registrants ORDER BY cf, id');
while (!$result->EOF) {
$row =& $result->fields;
$schedConf =& $this->schedConfMap[$row['cf']];
$email = Core::cleanVar($row['email']);
if (!($user =& $userDao->getUserByEmail($email))) {
// The user doesn't exist by email; create one.
$name = Core::cleanVar($row['name']);
$nameParts = split(' ', $name);
$lastName = array_pop($nameParts);
$firstName = join(' ', $nameParts);
$user = new User();
$user->setEmail($email);
$user->setFirstName($firstName);
$user->setLastName($lastName);
$user->setPhone(Core::cleanVar($row['phone']));
$user->setFax(Core::cleanVar($row['fax']));
$user->setMailingAddress(Core::cleanVar($row['address']));
$i = "";
while ($userDao->userExistsByUsername($lastName . $i)) {
$i++;
}
$user->setUsername($lastName . $i);
$user->setDateRegistered($row['date_registered']);
$user->setDateLastLogin(null);
$user->setMustChangePassword(1);
$password = Validation::generatePassword();
$user->setPassword(Validation::encryptCredentials($user->getUsername(), $password));
$userDao->insertUser($user);
if ($this->hasOption('emailUsers')) {
import('classes.mail.MailTemplate');
$mail = new MailTemplate('USER_REGISTER');
$mail->setFrom($schedConf->getSetting('contactEmail'), $schedConf->getSetting('contactName'));
$mail->assignParams(array('username' => $user->getUsername(), 'password' => $password, 'conferenceName' => $schedConf->getFullTitle()));
$mail->addRecipient($user->getEmail(), $user->getFullName());
$mail->send();
}
}
$regLevel = trim(Core::cleanVar($row['reg_level']));
$regFee = Core::cleanVar($row['reg_fee']);
$conferenceInfo =& $this->conferenceInfo[$row['cf']];
$seekingRegLevel = $regLevel . (strtotime($row['date_registered']) > strtotime($conferenceInfo['reg_late_date']) ? ' (Late)' : '');
$registrationType =& $registrationTypes[$seekingRegLevel];
if (!$registrationType || $registrationType->getCost() != $regFee) {
if (!$registrationType) {
$this->errors[] = "Registration data inconsistency: Registration type \"{$seekingRegLevel}\" not found for user with email {$email}.";
} else {
$this->errors[] = "Registration data inconsistency: Paid registration fee {$regFee} does not match registration type cost for \"{$seekingRegLevel}\" (" . $registrationType->getCost() . ") for user with email {$email}.";
unset($registrationType);
}
unset($user);
unset($schedConf);
$result->MoveNext();
continue;
}
if ($registrationDao->registrationExistsByUser($user->getId(), $schedConf->getId())) {
$this->errors[] = "A duplicate registration (level \"{$seekingRegLevel}\") was skipped for user with email {$email}.";
} else {
$registration = new Registration();
$registration->setSchedConfId($schedConf->getId());
$registration->setUserId($user->getId());
$registration->setTypeId($registrationType->getTypeId());
if ($row['has_paid'] == 'paid') {
$registration->setDatePaid(Core::cleanVar($row['date_paid']));
}
$registration->setSpecialRequests(Core::cleanVar($row['special_requests']));
$registration->setDateRegistered($row['date_registered']);
$registrationDao->insertRegistration($registration);
unset($registration);
}
unset($user);
unset($registrationType);
unset($conferenceInfo);
unset($schedConf);
$result->MoveNext();
}
$result->Close();
}
/**
* Save registration type.
*/
function execute()
{
$schedConf =& Request::getSchedConf();
if (isset($this->typeId)) {
$registrationType =& $this->registrationTypeDao->getRegistrationType($this->typeId);
}
if (!isset($registrationType)) {
$registrationType = new RegistrationType();
}
$registrationType->setSchedConfId($schedConf->getId());
$registrationType->setName($this->getData('name'), null);
// Localized
$registrationType->setDescription($this->getData('description'), null);
// Localized
$registrationType->setCost(round($this->getData('cost'), 2));
$registrationType->setCurrencyCodeAlpha($this->getData('currency'));
$registrationType->setOpeningDate($this->getData('openDate'));
$registrationType->setClosingDate($this->getData('closeDate'));
$registrationType->setExpiryDate($this->getData('expiryDate'));
$registrationType->setAccess($this->getData('access'));
$registrationType->setInstitutional($this->getData('institutional') ? 1 : 0);
$registrationType->setMembership($this->getData('membership') ? 1 : 0);
$registrationType->setPublic($this->getData('notPublic') ? 0 : 1);
$registrationType->setCode($this->getData('code'));
// Update or insert registration type
if ($registrationType->getTypeId() != null) {
$this->registrationTypeDao->updateRegistrationType($registrationType);
$this->registrationTypeDao->deleteRegistrationOptionCosts($registrationType->getTypeId());
} else {
$registrationType->setSequence(REALLY_BIG_NUMBER);
$this->registrationTypeDao->insertRegistrationType($registrationType);
// Re-order the registration types so the new one is at the end of the list.
$this->registrationTypeDao->resequenceRegistrationTypes($registrationType->getSchedConfId());
}
$registrationOptionCosts = (array) $this->getData('registrationOptionCosts');
foreach ($registrationOptionCosts as $optionId => $cost) {
$this->registrationTypeDao->insertRegistrationOptionCost($registrationType->getTypeId(), $optionId, $cost);
}
}
/**
* Create an associative array of object properties from XML
* @static
* @param SimpleXMLElement $parsedResponse - XML of an event
* @return array
*/
public static function createStruct($parsedResponse)
{
$event['link'] = (string) $parsedResponse->link->Attributes()->href;
$event['updated'] = (string) $parsedResponse->updated;
$event['id'] = (string) $parsedResponse->id;
$eventNode = $parsedResponse->content->children();
$event['name'] = (string) $eventNode->Event->Name;
$event['description'] = (string) $eventNode->Event->Description;
$event['title'] = (string) $eventNode->Event->Title;
$event['registered'] = (string) $eventNode->Event->Registered;
$event['createdDate'] = (string) $eventNode->Event->CreatedDate;
$event['status'] = (string) $eventNode->Event->Status;
$event['eventType'] = (string) $eventNode->Event->EventType;
$location['location'] = (string) $eventNode->Event->EventLocation->Location;
$location['addr1'] = (string) $eventNode->Event->EventLocation->Address1;
$location['addr2'] = (string) $eventNode->Event->EventLocation->Address2;
$location['addr3'] = (string) $eventNode->Event->EventLocation->Address3;
$location['city'] = (string) $eventNode->Event->EventLocation->City;
$location['state'] = (string) $eventNode->Event->EventLocation->State;
$location['country'] = (string) $eventNode->Event->EventLocation->Country;
$location['postalCode'] = (string) $eventNode->Event->EventLocation->PostalCode;
$event['eventLocation'] = new EventLocation($location);
$event['registrationUrl'] = (string) $eventNode->Event->RegistrationURL;
$event['startDate'] = (string) $eventNode->Event->StartDate;
$event['endDate'] = (string) $eventNode->Event->EndDate;
$event['publishDate'] = (string) $eventNode->Event->PublishDate;
$event['attendedCount'] = (string) $eventNode->Event->AttendedCount;
$event['cancelledCount'] = (string) $eventNode->Event->CancelledCount;
$event['eventFeeRequired'] = (string) $eventNode->Event->EventFeeRequired;
$event['currencyType'] = (string) $eventNode->Event->CurrencyType;
$event['paymentOptions'] = array();
if (isset($eventNode->Event->PaymentOptions->PaymentOption)) {
foreach ($eventNode->Event->PaymentOptions->PaymentOption as $options) {
$payOption = '';
$type = (string) $options->Type;
try {
if ($type == "PAYPAL") {
$paypalAddr = (string) $options->PayPalAccountEmail;
$payOption = new PayPalPayment($paypalAddr);
} elseif ($type == "chECK") {
$payOption = new checkPayment(checkPayment::createStruct($options));
} elseif ($type == "DOOR") {
$payOption = new DoorPayment();
}
if (empty($payOption)) {
throw new Exception('Payment Type ' . $type . ' is not a valid option');
}
} catch (Exception $e) {
die($e->getMessage());
}
$event['paymentOptions'][] = $payOption;
}
foreach ($eventNode->Event->RegistrationTypes->RegistrationType as $regType) {
$registration = new RegistrationType(RegistrationType::createStruct($regType));
}
$event['registrationTypes'][] = $registration;
}
return $event;
}
/**
* Internal function to return a RegistrationType object from a row.
* @param $row array
* @return RegistrationType
*/
function &_returnRegistrationTypeFromRow(&$row)
{
$registrationType = new RegistrationType();
$registrationType->setTypeId($row['type_id']);
$registrationType->setSchedConfId($row['sched_conf_id']);
$registrationType->setCode($row['code']);
$registrationType->setCost($row['cost']);
$registrationType->setCurrencyCodeAlpha($row['currency_code_alpha']);
$registrationType->setOpeningDate($this->dateFromDB($row['opening_date']));
$registrationType->setClosingDate($this->datetimeFromDB($row['closing_date']));
$registrationType->setExpiryDate($this->datetimeFromDB($row['expiry_date']));
$registrationType->setAccess($row['access']);
$registrationType->setInstitutional($row['institutional']);
$registrationType->setMembership($row['membership']);
$registrationType->setPublic($row['pub']);
$registrationType->setSequence($row['seq']);
$this->getDataObjectSettings('registration_type_settings', 'type_id', $row['type_id'], $registrationType);
HookRegistry::call('RegistrationTypeDAO::_returnRegistrationTypeFromRow', array(&$registrationType, &$row));
return $registrationType;
}
