protected function getFieldValuesArray($regID = '', $personID = '', $eventID = '')
{
$FALSE = 0;
$fields = new RowManager_FieldManager();
$fvalues = new RowManager_FieldValueManager();
$ftypes = new RowManager_FieldTypeManager();
// echo "personID = ".$personID;
// echo "eventID = ".$eventID;
if ($regID != '') {
//$fields->setEventID($eventID);
$fvalues->setRegID($regID);
} else {
if ($eventID != '' && $personID != '') {
$registrations = new RowManager_RegistrationManager();
// $registrations->setRegID($regID);
$person = new RowManager_PersonManager();
$person->setPersonID($personID);
$event = new RowManager_EventManager();
$event->setEventID($eventID);
$personReg = new MultiTableManager();
$personReg->addRowManager($registrations);
$personReg->addRowManager($person, new JoinPair($registrations->getJoinOnPersonID(), $person->getJoinOnPersonID()));
$personReg->addRowManager($event, new JoinPair($registrations->getJoinOnEventID(), $event->getJoinOnEventID()));
$valIterator = $personReg->getListIterator();
$valArray = $valIterator->getDataList();
// go through results and store field types
reset($valArray);
foreach (array_keys($valArray) as $k) {
$regValue = current($valArray);
$regID = $regValue['registration_id'];
//NOTE: assumes only 1 registration per person per event
next($valArray);
}
// $fields->setEventID($eventID);
$fvalues->setRegID($regID);
}
}
// $fvalues->setSortByFieldID();
$fieldInfo = new MultiTableManager();
$fieldInfo->addRowManager($fields);
$fieldInfo->addRowManager($fvalues, new JoinPair($fvalues->getJoinOnFieldID(), $fields->getJoinOnFieldID()));
$fieldInfo->addRowManager($ftypes, new JoinPair($fields->getJoinOnFieldTypeID(), $ftypes->getJoinOnFieldTypeID()));
if ($this->show_hidden == false) {
$fieldInfo->constructSearchCondition('fields_hidden', '=', $FALSE, true);
}
$fieldInfo->setSortOrder('fields_priority');
$valuesIterator = $fieldInfo->getListIterator();
$valuesArray = $valuesIterator->getDataList();
// echo "field values:<br><pre>".print_r($valuesArray,true)."</pre>";
// store field ids associated with values already in database
$initializedFieldIds = array_keys($valuesArray);
// since each field value is located in a DB row the result array has several arrays - one per field value
// need to extract each field value and store it as a non-array record in a result array
$fieldValues = array();
$idx = 0;
/** Go through all event fields and map each to existing field value, otherwise create new field value record **/
$fieldsArray = array_values($this->formFieldToFieldIDmapper);
// store field IDs (ASSUMES formFieldToFieldIDmapper is initialized)
// echo 'fieldsArray = <pre>'.print_r($fieldsArray,true).'</pre>';
reset($fieldsArray);
reset($valuesArray);
foreach (array_keys($fieldsArray) as $k) {
$fieldID = current($fieldsArray);
$form_value = '';
// default blank field value if none found
$form_value_id = -1;
// to be replaced with existing or newly-created field values ID
if (in_array($fieldID, $initializedFieldIds) == true) {
$record = $valuesArray[$fieldID];
$form_value = $record['fieldvalues_value'];
$form_value_id = $record['fieldvalues_id'];
} else {
$updateValues = array();
$updateValues['fields_id'] = $fieldID;
$updateValues['fieldvalues_value'] = $form_value;
$updateValues['registration_id'] = $regID;
$fieldvalues_manager = new RowManager_FieldValueManager();
// store values in table manager object.
$fieldvalues_manager->loadFromArray($updateValues);
// now update the DB with the values
if (!$fieldvalues_manager->isLoaded()) {
$fieldvalues_manager->createNewEntry(true);
$form_value_id = $fieldvalues_manager->getID();
}
}
$fieldValues['form_field' . $idx] = $form_value;
// store mapping associating form field label with fieldvalues_id
$this->formFieldToValueIDmapper['form_field' . $idx] = $form_value_id;
next($fieldsArray);
$idx++;
}
// echo 'labels-values = <pre>'.print_r($this->formFieldToValueIDmapper,true).'</pre>';
// echo 'labels-fields = <pre>'.print_r($this->formFieldToFieldIDmapper,true).'</pre>';
return $fieldValues;
}
