* fieldvalues_value [STRING] The value stored. * person_id [INTEGER] The person who entered the value stored. * fieldvalues_modTime [DATE] The time when the value record was last changed. */ $FormFieldValue = new RowManager_FormFieldValueManager(); $FormFieldValue->dropTable(); $FormFieldValue->createTable(); /* * FieldGroup Table * * Object describing a group of fields * * fieldgroup_id [INTEGER] Unique id of a field group * fieldgroup_desc [STRING] The field group description/label. */ $FieldGroup = new RowManager_FieldGroupManager(); $FieldGroup->dropTable(); $FieldGroup->createTable(); /* * FieldGroup_Matches Table * * An object that matches a field group with some (repeatable form) field * * fieldgroup_matches_id [INTEGER] The unique id of the matching * fieldgroup_id [INTEGER] the id of the field group being matched * fields_id [INTEGER] the id of the field being matched to a fieldgroup */ $FieldGroup_Matches = new RowManager_FieldGroup_MatchesManager(); $FieldGroup_Matches->dropTable(); $FieldGroup_Matches->createTable(); /*
/**
* function getHTML
* <pre>
* This method returns the HTML data generated by this object.
* </pre>
* @return [STRING] HTML Display data.
*/
function getHTML()
{
// Uncomment the following line if you want to create a template
// tailored for this page:
//$path = $this->pathModuleRoot.'templates/';
// Otherwise use the standard Templates for the site:
$path = SITE_PATH_TEMPLATES;
/*
* store the link values
*/
// example:
// $this->linkValues[ 'view' ] = 'add/new/href/data/here';
// store the link labels
$this->linkLabels['edit'] = $this->labels->getLabel('[Edit]');
$this->linkLabels['del'] = $this->labels->getLabel('[Delete]');
$this->linkLabels['cont'] = $this->labels->getLabel('[Continue]');
// $this->linkLabels[ 'view' ] = 'new link label here';
/*
* store any additional link Columns
*/
// example:
//$title = $this->labels->getLabel( '[title_groups]');
//$columnLabel = $this->labels->getLabel( '[groups]');
//$link = $this->linkValues[ 'groups' ];
//$fieldName = 'accessgroup_id';
//$this->addLinkColumn( $title, $columnLabel, $link, $fieldName);
/*
* Update any label tags ...
*/
// example:
// $name = $user->getName();
// $this->labels->setLabelTag( '[Title]', '[userName]', $name);
// NOTE: this parent method prepares the $this->template with the
// common AdminBox data.
$this->prepareTemplate($path);
// store the statevar id to edit
$this->template->set('editEntryID', $this->fields_id);
// store all the fields to the template
$this->setFormFieldsToTemplate();
/*
* Form related Template variables:
*/
$this->formValues['form_name'] = 'editFieldsForm';
/*
* Insert the date start/end values for the following date fields:
*/
// example:
//$this->template->set( 'startYear_[fieldName]', 2000);
//$this->template->set( 'endYear_[fieldName]', 2010);
/*
* List related Template variables :
*/
// Store the XML Node name for the Data Access Field List
$xmlNodeName = RowManager_FormFieldManager::XML_NODE_NAME;
$this->template->set('rowManagerXMLNodeName', $xmlNodeName);
// store the primary key field name for the data being displayed
$this->template->set('primaryKeyFieldName', 'fields_id');
// store data list to the template
// NOTE: we initialize it here to make sure we capture any new data
// from a recent processData() call.
$dataAccessManager = new RowManager_FormFieldManager();
$dataAccessManager->setFormID($this->staffscheduletype_id);
$dataAccessManager->setSortOrder($this->sortBy);
// $this->dataList = new FormFieldList( $this->sortBy );
$this->dataList = $dataAccessManager->getListIterator();
$this->template->setXML('dataList', $this->dataList->getXML());
/*
* Add any additional data required by the template here
*/
// get a list of all field type IDs
$fieldtype = new RowManager_FieldTypeManager();
$fieldtype->setSortOrder('fieldtype_id');
$fieldtypeList = new ListIterator($fieldtype);
$fieldtypeArray = $fieldtypeList->getDropListArray();
$this->template->set('list_fieldtype_id', $fieldtypeArray);
// get a list of all data types; DB table = reg_cim_datatypes
$type = new RowManager_DataTypeManager();
$type->setSortOrder('datatypes_id');
$typeList = new ListIterator($type);
$typeArray = $typeList->getDropListArray();
$this->template->set('list_datatypes_id', $typeArray);
// get a list of all fieldgroups; DB table = reg_cim_fieldgroup
$group = new RowManager_FieldGroupManager();
$group->setSortOrder('fieldgroup_desc');
$groupList = new ListIterator($group);
$groupArray = $groupList->getDropListArray();
$groupArray[0] = '';
//'(None)';
$this->template->set('list_fieldgroup_id', $groupArray);
//TODO: replace this with a reference to a multi_lingual label constant array...
$boolArray = array();
$boolArray['0'] = 'false';
$boolArray['1'] = 'true';
$this->template->set('list_fields_hidden', $boolArray);
$this->template->set('list_fields_reqd', $boolArray);
$this->template->set('list_fields_islistfield', $boolArray);
$this->template->set('disableHeading', $this->disableHeading);
$templateName = 'siteFormDataList.php';
// if you are creating a custom template for this page then
// replace $templateName with the following:
//$templateName = 'page_EditFormFields.php';
return $this->template->fetch($templateName);
}