/**
* 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>';
}