* emerg_contactEmail [STRING] emergency contact's email address * emerg_birthdate [DATE] person's birthdate * emerg_medicalNotes [STRING] medical notes about this person */ $EmergencyInfo = new RowManager_EmergencyInfoManager(); $EmergencyInfo->dropTable(); $EmergencyInfo->createTable(); /* * CampusAssignmentStatus Table * * The status of a person assigned to some campus. * * assignmentstatus_id [INTEGER] unique identifier for a particular campus assignment status * assignmentstatus_desc [STRING] Description of a particular campus assignment status */ $CampusAssignmentStatus = new RowManager_CampusAssignmentStatusManager(); $CampusAssignmentStatus->dropTable(); $CampusAssignmentStatus->createTable(); /* * EditCampusAssignment Table * * Page used to edit campus assignments for people. Assigns campus and some sort of campus status (i.e. student, staff, alumni, etc) to a person. * * assignment_id [INTEGER] Unique id of some campus assignment for some student * person_id [INTEGER] Unique id of the person being assigned a campus * campus_id [INTEGER] Unique ID of the campus being assigned to a person * assignmentstatus_id [INTEGER] ID referring to a particular status w.r.t. a campus (i.e. student, staff, etc) */ $EditCampusAssignment = new RowManager_EditCampusAssignmentManager(); $EditCampusAssignment->dropTable(); $EditCampusAssignment->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->assignmentstatus_id);
// store all the fields to the template
$this->setFormFieldsToTemplate();
/*
* Form related Template variables:
*/
/*
* 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_CampusAssignmentStatusManager::XML_NODE_NAME;
$this->template->set('rowManagerXMLNodeName', $xmlNodeName);
// store the primary key field name for the data being displayed
$this->template->set('primaryKeyFieldName', 'assignmentstatus_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_CampusAssignmentStatusManager();
$dataAccessManager->setSortOrder($this->sortBy);
// $this->dataList = new CampusAssignmentStatusList( $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_EditCampusAssignmentStatusTypes.php';
return $this->template->fetch($templateName);
}
/**
* 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->assignment_id);
$this->template->set('notice', $this->notice);
$this->template->set('errorMessage', $this->error_message);
// store all the fields to the template
$this->setFormFieldsToTemplate();
/*
* Form related Template variables:
*/
/*
* 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 primary key field name for the data being displayed
$this->template->set('primaryKeyFieldName', 'assignment_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_EditCampusAssignmentManager();
$dataAccessManager->setPersonID($this->person_id);
if ($this->campus_id != '') {
$dataAccessManager->setCampusID($this->campus_id);
}
$dataAccessManager->setSortOrder($this->sortBy);
$this->dataList = $dataAccessManager->getListIterator();
// Store the XML Node name for the Data Access Field List
$xmlNodeName = $this->dataList->getRowManagerXMLNodeName();
//RowManager_EditCampusAssignmentManager::XML_NODE_NAME;
$this->template->set('rowManagerXMLNodeName', $xmlNodeName);
$this->template->setXML('dataList', $this->dataList->getXML());
// enable drop-down list for adding new person assignments
$personManager = new RowManager_PersonManager();
$campusManager = new RowManager_CampusManager();
/* $combinedManager = new MultiTableManager();
$combinedManager->addRowManager($personManager);
$combinedManager->addRowManager($dataAccessManager, new JoinPair($personManager->getJoinOnPersonID(),$dataAccessManager->getJoinOnPersonID()));
// $combinedManager->addRowManager($campusManager, new JoinPair($campusManager->getJoinOnCampusID(),$dataAccessManager->getJoinOnCampusID()));
if ($this->person_id!='') {
$combinedManager->constructSearchCondition( 'person_id', '=', $this->person_id, true );
}
if ($this->campus_id!='') {
$combinedManager->constructSearchCondition( 'campus_id', '=', $this->campus_id, true );
}
$dataList = $combinedManager->getListIterator();
$dataArray = $dataList->getDropListArray(); /**/
// $personManager = new RowManager_PersonManager($this->person_id);
// $personList = $personManager->getListIterator();
// $personArray = $personList ->getDropListArray();
// $this->template->set( 'list_person_id', $personArray );
// $personList = $combinedManager->getListIterator();
$personManager->setPersonID($this->person_id);
$personManager->setLabelTemplateLastNameFirstName();
$personList = $personManager->getListIterator();
$personArray = $personList->getDropListArray();
$this->template->set('list_person_id', $personArray);
// enable drop-down list for adding new campus assignments
if ($this->campus_id != '') {
$campusManager->setCampusID($this->campus_id);
}
$campusList = $campusManager->getListIterator();
// $campusList = $combinedManager->getListIterator();
$campusArray = $campusList->getDropListArray();
$this->template->set('list_campus_id', $campusArray);
// enable drop-down list for adding new campus assignments
$statusManager = new RowManager_CampusAssignmentStatusManager();
$statusList = $statusManager->getListIterator();
// $statusList = $combinedManager->getListIterator();
$statusArray = $statusList->getDropListArray();
$this->template->set('list_assignmentstatus_id', $statusArray);
// $dataAccessManager->setPersonID($this->person_id);
// $dataAccessManager->setCampusID($this->campus_id);
// $this->dataList = new EditCampusAssignmentList( $this->sortBy );
// $this->dataList = $combinedManager->getListIterator();
/*
* Add any additional data required by the template here
*/
// $this->displayValues =
$templateName = 'siteAdminBox.php';
// if you are creating a custom template for this page then
// replace $templateName with the following:
//$templateName = 'page_EditCampusAssignment.php';
return $this->template->fetch($templateName);
}