* 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(); /* * StaffScheduleInstr Table * * The form instructions directly associated with a particular HRDB form * * staffscheduleinstr_toptext [STRING] The instructions for the main (top) form. * staffscheduleinstr_bottomtext [STRING] The instructions for the scheduled activities form (if it is used for this HR form). * staffscheduletype_id [INTEGER] The primary id of the object - same primary ID as the schedule form type object. */ $StaffScheduleInstr = new RowManager_StaffScheduleInstrManager(); $StaffScheduleInstr->dropTable(); $StaffScheduleInstr->createTable(); /* * StaffDirector Table * * Stores staff-to-director associations. That is, it indicates which staff have which other staff as their director(s). * * staffdirector_id [INTEGER] The unique ID of the staff-to-director association * staff_id [INTEGER] The ID of the staff to be associated with a director. * director_id [INTEGER] The staff ID of the staff director supervising the staff member indicated in the "staff_id" field. */ $StaffDirector = new RowManager_StaffDirectorManager(); $StaffDirector->dropTable(); $StaffDirector->createTable(); /*
/**
* function getHTML
* <pre>
* This method returns the HTML data generated by this object.
* </pre>
* @return [STRING] HTML Display data.
*/
function getHTML()
{
// Make a new Template object
//$this->pathModuleRoot.'templates/';
// Replace $path with the following line if you want to create a
// template tailored for this page:
$path = $this->pathModuleRoot . 'templates/';
// store the link values
// $this->linkValues[ 'view' ] = 'add/new/href/data/here';
// store the link labels
$this->linkLabels['add'] = $this->labels->getLabel('[Add]');
// $this->linkLabels[ 'edit' ] = $this->labels->getLabel( '[Edit]' );
// $this->linkLabels[ 'del' ] = $this->labels->getLabel( '[Delete]' );
if (!isset($this->linkLabels['cont'])) {
$this->linkLabels['cont'] = $this->labels->getLabel('[Continue]');
}
// $this->linkLabels[ 'view' ] = 'new link label here';
$this->prepareTemplate($path);
$top_instructions = '';
$bottom_instructions = '';
$form_instructions = new RowManager_StaffScheduleInstrManager();
$form_instructions->setFormTypeID($this->form_id);
$instr_list = $form_instructions->getListIterator();
$instr_array = $instr_list->getDataList();
foreach (array_keys($instr_array) as $key) {
$record = current($instr_array);
$top_instructions = $record['staffscheduleinstr_toptext'];
$bottom_instructions = $record['staffscheduleinstr_bottomtext'];
}
if ($top_instructions != '') {
$this->template->set('top_instructions', $top_instructions);
}
if ($bottom_instructions != '') {
$this->template->set('bottom_instructions', $bottom_instructions);
}
// Set form approval status message
$form_approved = "Approval Pending";
if ($this->is_form_approved == true) {
$form_approved = "Form Approved";
}
$this->template->set('form_approval_status', $form_approved);
$this->template->set('form_approval_notes', $this->approval_notes);
// Display message if form has just been submitted
if ($this->form_submitted == true) {
$statusMessage = 'Form information successfully submitted.';
$this->template->set('form_status_msg', $statusMessage);
$this->form_submitted = false;
}
// Set the sub-page objects
$this->template->set('basicStaffForm', $this->generateTopForm());
if ($this->has_activity_form == true) {
$this->template->set('scheduledActivityForm', $this->generateBottomForm());
}
// 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);
// store the page labels
// NOTE: use this location to update any label tags ...
// example:
// $name = $user->getName();
// $this->labels->setLabelTag( '[Title]', '[userName]', $name);
// store the Row Manager's XML Node Name
// $this->template->set( 'rowManagerXMLNodeName', RowManager_RegistrationManager::XML_NODE_NAME );
$this->template->set('rowManagerXMLNodeName', MultiTableManager::XML_NODE_NAME);
// store the primary key field name for the data being displayed
$this->template->set('primaryKeyFieldName', 'person_id');
// TODO: somehow merge the primary join with the balance owing join.... for efficiency
/*
* Set up any additional data transfer to the Template here...
*/
// $this->template->set( 'dataList', $this->dataList);
$form_notice = 'Please note that the "Update" button only updates the top form.<br>The bottom form is updated via its own buttons/links.';
$this->template->set('subheading', $this->hrdbFormTitle);
$this->template->set('formsNotice', $form_notice);
$templateName = 'page_EditStaffScheduleForm.tpl.php';
// if you are creating a custom template for this page then
// replace $templateName with the following:
//$templateName = 'page_EditCampusRegistrations.php';
return $this->template->fetch($templateName);
}