* access_id [INTEGER] This is the key for the table * viewer_id [INTEGER] This is the viewer(user) id of the user who is assigned to a person id. * person_id [INTEGER] This is the person id connected to the viewer id. */ $Access = new RowManager_AccessManager(); $Access->dropTable(); $Access->createTable(); /* * Region Table * * manages regions * * region_id [INTEGER] id of a region * reg_desc [STRING] description of a region */ $Region = new RowManager_RegionManager(); $Region->dropTable(); $Region->createTable(); /* * EmergencyInfo Table * * a record of emergency info for a person * * emerg_id [INTEGER] unique indentifier * person_id [INTEGER] Person id * emerg_passportNum [STRING] Passport number * emerg_passportOrigin [STRING] passport's country of origin * emerg_passportExpiry [DATE] passport date of expiry * emerg_contactName [STRING] emergency contact name * emerg_contactRship [STRING] emergency contact's relationship to the person * emerg_contactHome [STRING] emergency contact's home phone number
/**
* 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->location_id);
// store all the fields to the template
$this->setFormFieldsToTemplate();
/*
* Form related Template variables:
*/
$ministryManager = new RowManager_MinistryManager();
$ministryIterator = $ministryManager->getListIterator();
$ministryList = $ministryIterator->getDropListArray();
$this->template->set('list_ministry_id', $ministryList);
$divisionManager = new RowManager_DivisionManager();
$divisionIterator = $divisionManager->getListIterator();
$divisionList = $divisionIterator->getDropListArray();
$this->template->set('list_division_id', $divisionList);
$regionManager = new RowManager_RegionManager();
$regionIterator = $regionManager->getListIterator();
$regionList = $regionIterator->getDropListArray();
$this->template->set('list_region_id', $regionList);
/*
* 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_LocationManager::XML_NODE_NAME;
$this->template->set('rowManagerXMLNodeName', $xmlNodeName);
// store the primary key field name for the data being displayed
$this->template->set('primaryKeyFieldName', 'location_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_LocationManager();
$dataAccessManager->setSortOrder($this->sortBy);
// $this->dataList = new LocationList( $this->sortBy );
$this->dataList = $dataAccessManager->getListIterator();
$this->template->setXML('dataList', $this->dataList->getXML());
/*
* Add any additional data required by the template here
*/
$templateName = 'siteAdminBox.php';
// if you are creating a custom template for this page then
// replace $templateName with the following:
//$templateName = 'page_EditLocation.php';
return $this->template->fetch($templateName);
}
