/**
* function __construct
* <pre>
* Initialize the object.
* </pre>
* @param $pathModuleRoot [STRING] The path to the module's root dir.
* @param $viewer [OBJECT] The viewer object.
* @param $sortBy [STRING] Field data to sort listManager by.
* @param $managerInit [INTEGER] Initialization value for the listManager.
* @return [void]
*/
function __construct($pathModuleRoot, $viewer, $customreport_id, $disable_heading = false)
{
$this->is_blank_page = false;
$this->disable_heading = $disable_heading;
// store field display types
$DISPLAY_FIELDS = $this->getDisplayFields($customreport_id);
parent::__construct($DISPLAY_FIELDS);
// parent::__construct( page_ViewCustomReport::DISPLAY_FIELDS );
$this->pathModuleRoot = $pathModuleRoot;
$this->viewer = $viewer;
$this->disableHeading = $disable_heading;
$this->customreport_id = $customreport_id;
$this->fields_id_array = array();
$this->listLabels = array();
// Get fields for the custom report; required for retrieving data in column format
// $columns = 'customfields_id,report_id,cim_hrdb_customfields.fields_id,count(person_id)';
$groupBy = 'cim_hrdb_customfields.fields_id';
$dbFunction = 'COUNT';
$funcParam = 'person_id';
$reportFields = new MultiTableManager();
$customfields = new RowManager_CustomFieldsManager();
$customfields->setReportID($this->customreport_id);
// TODO? error checking on ID
$fieldvalues = new RowManager_FormFieldValueManager();
$reportFields->addRowManager($customfields);
$reportFields->addRowManager($fieldvalues, new JoinPair($customfields->getJoinOnFieldID(), $fieldvalues->getJoinOnFieldID()));
// use GROUP BY and $dbFunction = 'COUNT' to quickly get summary data per campus
if ($groupBy != '') {
$reportFields->setGroupBy($groupBy);
//'campus_desc');
}
if ($dbFunction != '') {
$reportFields->setFunctionCall($dbFunction, $funcParam);
}
$reportFields->setSortOrder('COUNT(person_id) DESC');
// $reportFields->setFieldList($columns);
$customFieldsList = $reportFields->getListIterator();
$customFieldsArray = $customFieldsList->getDataList();
// echo '<pre>'.print_r($customFieldsArray,true).'</pre>';
$i = 0;
foreach (array_keys($customFieldsArray) as $key) {
$record = current($customFieldsArray);
$this->fields_id_array[$i] = $record['fields_id'];
$i++;
next($customFieldsArray);
}
// Ensure that the custom report has been given at least one field
if (count($this->fields_id_array) > 0) {
// Default sorting: by person name, since this is the only standard field
$this->sortBy = 'person_lname,person_fname';
// TODO: need to add person table to allow person_name sorting
// Now load the access Privilege manager of this viewer
$this->adminManager = new RowManager_AdminManager();
// Get the person ID
$accessManager = new RowManager_AccessManager();
$accessManager->loadByViewerID($this->viewer->getViewerID());
$personID = $accessManager->getPersonID();
// Get the permissions the person has.
$this->adminManager->loadByPersonID($personID);
$directed_staff = '';
$directed_people = '';
// Super-admin
if ($this->adminManager->hasSitePriv()) {
$this->access_level = page_ViewCustomReport::SUPERADMIN;
} else {
if ($this->adminManager->isStaff($viewer->getID())) {
$director_id = $this->getStaffIDfromViewerID();
$staffManager = new RowManager_StaffDirectorManager();
$staffManager->setDirectorID($director_id);
/* Retrieve all directors under the current director */
$hierarchy_result = $staffManager->getDirectorHierarchy($director_id);
$hierarchy_result->setFirst();
$hierarchy_array = array();
$directed_staff = '';
while ($hierarchy_result->moveNext()) {
$staff_ids = $hierarchy_result->getCurrentRow();
// echo 'array = <pre>'.print_r($hierarchy_array,true).'</pre>';
for ($lvl = 1; $lvl <= MAX_DIRECTOR_LEVELS; $lvl++) {
$staff_id = $staff_ids['staff_lvl' . $lvl];
if ($staff_id != null) {
$directed_staff .= $staff_id . ',';
}
}
}
if ($directed_staff != '') {
$directed_staff = substr($directed_staff, 0, -1);
$this->access_level = page_ViewCustomReport::DIRECTOR;
} else {
$directed_staff = page_ViewCustomReport::NON_DIRECTOR;
$this->access_level = page_ViewCustomReport::NON_DIRECTOR;
}
$personGetter = new MultiTableManager();
$person_info = new RowManager_PersonManager();
$staff = new RowManager_StaffManager();
$personGetter->addRowManager($person_info);
$personGetter->addRowManager($staff, new JoinPair($staff->getJoinOnPersonID(), $person_info->getJoinOnPersonID()));
$personGetter->addSearchCondition('staff_id in (' . $directed_staff . ')');
$staffPersonList = $personGetter->getListIterator();
$staffPersonArray = $staffPersonList->getDataList();
foreach (array_keys($staffPersonArray) as $key) {
$record = current($staffPersonArray);
$directed_people .= $record['person_id'] . ',';
next($staffPersonArray);
}
$directed_people = substr($directed_people, 0, -1);
//remove last comma
} else {
$this->access_level = page_ViewCustomReport::UNAUTHORIZED_DIRECTOR;
}
}
// Retrieve custom report fields and store them in data columns for easy display
$dataAccessObject = new MultiTableManager();
$person_manager = new RowManager_PersonManager();
$dataAccessObject->addRowManager($person_manager);
$fieldList = '';
$temp_tables = array();
for ($i = 0; $i < count($this->fields_id_array); $i++) {
$tempTableCreationSQLmaker = new MultiTableManager();
$fieldvalue_manager = new RowManager_FormFieldValueManager();
$fieldvalue_manager->setFieldID($this->fields_id_array[$i]);
// if ($this->access_level == page_ViewCustomReport::UNAUTHORIZED_DIRECTOR)
// {
// $fieldvalue_manager->setPersonID($personID); // only show staff's own data
// }
// else if ($this->access_level == page_ViewCustomReport::DIRECTOR)
// {
// $fieldvalue_manager->addSearchCondition('person_id in ('.$directed_people.')');
// }
// else if ($this->access_level == page_ViewCustomReport::NON_DIRECTOR) // director with no underlings
// {
// $fieldvalue_manager->setPersonID($personID); // only show staff's own data
// }
// else if ($this->access_level == page_ViewCustomReport::SUPERADMIN)
// {
// // no restrictions
// }
// Create a temporary table from a SQL join retrieving the data for a particular form field
$tempTableCreationSQLmaker->addRowManager($fieldvalue_manager);
$fields_manager = new RowManager_FormFieldManager();
$tempTableCreationSQLmaker->addRowManager($fields_manager, new JoinPair($fieldvalue_manager->getJoinOnFieldID(), $fields_manager->getJoinOnFieldID()));
$customfields_manager = new RowManager_CustomFieldsManager();
$customfields_manager->setReportID($this->customreport_id);
$tempTableCreationSQLmaker->addRowManager($customfields_manager, new JoinPair($fieldvalue_manager->getJoinOnFieldID(), $customfields_manager->getJoinOnFieldID()));
$tempFieldList = 'person_id,fieldvalues_value';
$tempTableCreationSQLmaker->setFieldList($tempFieldList);
$tempTableCreationSQL = $tempTableCreationSQLmaker->createSQL();
$temp_tables[$i] = new TempTableManager('temptable' . $i, $tempTableCreationSQL, $tempFieldList, 'temptable' . $i);
//$PRIMARY_ID=-1
$temp_tables[$i]->createTable(true);
// Join the temporary tables together to get a table of n+1 columns where n = count($this->field_ids_array) and the extra column stores person_id
if ($i > 0) {
$fieldList .= ',temptable' . $i . '.fieldvalues_value as value' . $i;
$i_minus = $i - 1;
$dataAccessObject->addRowManager($temp_tables[$i], new JoinPair($temp_tables[$i_minus]->getJoinOnFieldX(page_ViewCustomReport::JOIN_FIELD), $temp_tables[$i]->getJoinOnFieldX(page_ViewCustomReport::JOIN_FIELD), JOIN_TYPE_LEFT));
} else {
$fieldList .= 'cim_hrdb_person.person_id,temptable' . $i . '.fieldvalues_value as value' . $i;
$dataAccessObject->addRowManager($temp_tables[0], new JoinPair($person_manager->getJoinOnFieldX(page_ViewCustomReport::JOIN_FIELD), $temp_tables[0]->getJoinOnFieldX(page_ViewCustomReport::JOIN_FIELD)));
}
}
// Filter results by directed people IDs (if viewer is NOT super-admin)
if ($this->access_level != page_ViewCustomReport::SUPERADMIN) {
// for ($i=0; $i < count($this->fields_id_array); $i++)
// {
// if ($this->access_level == page_ViewCustomReport::UNAUTHORIZED_DIRECTOR)
// {
// $dataAccessObject->addSearchCondition('temptable'.$i.'.person_id in ('.$personID.')'); // only show staff's own data
// }
// else if ($this->access_level == page_ViewCustomReport::DIRECTOR)
// {
// $dataAccessObject->addSearchCondition('temptable'.$i.'.person_id in ('.$directed_people.')');
// }
// else if ($this->access_level == page_ViewCustomReport::NON_DIRECTOR) // director with no underlings
// {
// $dataAccessObject->addSearchCondition('temptable'.$i.'.person_id in ('.$personID.')'); // only show staff's own data
// }
// }
$dataAccessObject->addSearchCondition('cim_hrdb_person.person_id in (' . $directed_people . ')');
}
// echo '<pre>'.print_r($temp_tables[0]->getListIterator()->getDataList(),true).'</pre>';
// $temp_tables[0]->db->runSQL('select * from temptable0');
$dataAccessObject->setFieldList($fieldList);
$dataAccessObject->setSortOrder($this->sortBy);
$this->listManager = $dataAccessObject->getListIterator();
// echo '<pre>'.print_r($this->listManager->getDataList(),true).'</pre>';
} else {
$dataAccessObject = new MultiTableManager();
$person_manager = new RowManager_PersonManager();
$person_manager->setPersonID(page_ViewCustomReport::NO_FIELDS_SET);
$dataAccessObject->addRowManager($person_manager);
$dataAccessObject->setSortOrder($this->sortBy);
$this->listManager = $dataAccessObject->getListIterator();
$this->is_blank_page = true;
}
// now initialize the labels for this page
// start by loading the default field labels for this Module
$languageID = $viewer->getLanguageID();
$seriesKey = modulecim_hrdb::MULTILINGUAL_SERIES_KEY;
$pageKey = modulecim_hrdb::MULTILINGUAL_PAGE_FIELDS;
$this->labels = new MultilingualManager($languageID, $seriesKey, $pageKey);
// then load the page specific labels for this page
$pageKey = page_ViewCustomReport::MULTILINGUAL_PAGE_KEY;
$this->labels->loadPageLabels($pageKey);
$this->labels->setSeriesKey(SITE_LABEL_SERIES_SITE);
$this->labels->loadPageLabels(SITE_LABEL_PAGE_FORM_LINKS);
$this->listLabels = $this->getListLabels($this->customreport_id);
// NOTE: parameter *required*
// foreach (array_keys($this->listLabels,true) as $key)
// {
// $label = current($this->listLabels);
// $this->labels->setLabelTag('[title_value0]', '<title in tool_setup>', 'Monthly Support Goal'); // NOTE: cannot be used because nothing set in tool_setup
// echo 'labels = <pre>'.print_r($this->listLabels,true).'</pre>';
}
*/ $FormField = new RowManager_FormFieldManager(); $FormField->dropTable(); $FormField->createTable(); /* * FormFieldValue Table * * A record storing a field value entered via a HRDB form. * * fieldvalues_id [INTEGER] The unique field value id. * fields_id [INTEGER] The id of the form field where this value was entered. * 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
protected function getFooterFieldValuesArray($personID = '', $formID = '', $isRepeatable = true)
{
$FALSE = 0;
$fields = new RowManager_FormFieldManager();
$fields->setFieldGroupID(FormProcessor_EditStaffScheduleForm::NO_FIELDGROUP_ID);
// HSMIT added
$fvalues = new RowManager_FormFieldValueManager();
$ftypes = new RowManager_FieldTypeManager();
if ($personID != '') {
//$fields->setFormID($formID);
$fvalues->setPersonID($personID);
}
$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);
}
// filter out repeatable fields if flag set to FALSE
if ($isRepeatable == false) {
$fieldInfo->constructSearchCondition('fieldgroup_id', '=', '0', true);
} else {
$fieldInfo->constructSearchCondition('fieldgroup_id', '!=', '0', 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 = $this->total_nonrepeatable_fields;
// initialize counter to first available form ID (some used already)
/** Go through all event fields and map each to existing field value, otherwise create new field value record **/
$fieldsArray = array_values($this->footerFieldToFieldIDmapper);
// 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['person_id'] = $personID;
$fieldvalues_manager = new RowManager_FormFieldValueManager();
// store values in table manager object.
$fieldvalues_manager->loadFromArray($updateValues);
// now update the DB with the values
if (!$fieldvalues_manager->isLoaded()) {
// echo "new entry ".$fieldID.", ".$personID;
$fieldvalues_manager->createNewEntry();
$form_value_id = $fieldvalues_manager->getID();
}
}
$fieldValues['form_field' . $idx] = $form_value;
// store mapping associating form field label with fieldvalues_id
$this->footerFieldToValueIDmapper['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;
}
