/**
* 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, $sortBy)
{
parent::__construct(page_People::DISPLAY_FIELDS);
$this->pathModuleRoot = $pathModuleRoot;
$this->viewer = $viewer;
// $this->managerInit = $managerInit;
// $dataAccessObject = new RowManager_PersonManager();
$dataAccessObject = new MultiTableManager();
$personManager = new RowManager_PersonManager();
$dataAccessObject->addRowManager($personManager);
if ($sortBy == '') {
$sortBy = 'person_fname';
}
$dataAccessObject->setSortOrder($sortBy);
// $this->listManager = new PersonList( $sortBy );
$this->listManager = $dataAccessObject->getListIterator();
// 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_People::MULTILINGUAL_PAGE_KEY;
$this->labels->loadPageLabels($pageKey);
$this->labels->setSeriesKey(SITE_LABEL_SERIES_SITE);
$this->labels->loadPageLabels(SITE_LABEL_PAGE_FORM_LINKS);
}
/**
* function __construct
* <pre>
* Initialize the Class ...
* </pre>
* @param $sortBy [STRING] the field name to sort list by
* @return [void]
*/
function __construct($requireRegion = false, $getOnlyNS = false, $includeChildren = false, $includeAlumni = false, $sortBy = '', $excludeSpouse = false)
{
$this->requireRegion = $requireRegion;
$multiTableManager = new MultiTableManager();
// ----- STEP ONE: Deal with the ren table
$renManager = new RowManager_HrdbRenManager();
/* if( $getOnlyNS )
{
$renManager->setEmployeeStatus('NS');
}
*/
$multiTableManager->addRowManager($renManager);
if ($getOnlyNS) {
// we also need to
$condition = $multiTableManager->constructSearchCondition($renManager->getFieldEmployeeStatus(), OP_EQUAL, 'NS');
$condition .= ' OR ';
$condition .= $multiTableManager->constructSearchCondition($renManager->getFieldEmployeeStatus(), OP_EQUAL, 'ANS');
$multiTableManager->addSearchCondition($condition);
}
if (!$includeChildren) {
$multiTableManager->constructSearchCondition($renManager->getFieldIdentifierFamilyPosition(), OP_NOT_EQUAL, "Child", true);
}
if ($excludeSpouse) {
$multiTableManager->constructSearchCondition($renManager->getFieldIdentifierFamilyPosition(), OP_NOT_EQUAL, 'Spouse', true);
}
// STEP ONE COMPLETE
// ----- STEP TWO: Join with the family table
$familyManager = new RowManager_FamilyManager();
if (!$includeAlumni) {
// we want only those who are not alumni
$familyManager->setAlumni(false);
}
$multiTableManager->addRowManager($familyManager, new JoinPair($renManager->getJoinOnFamilyID(), $familyManager->getJoinOnFamilyID()));
// STEP TWO COMPLETE
// ------ STEP THREE: Check if region is needed
if ($requireRegion) {
// assignment
$assManager = new RowManager_HrdbAssignmentManager();
$multiTableManager->addRowManager($assManager, new JoinPair($renManager->getJoinOnAssignmentID(), $assManager->getJoinOnAssignmentID()));
// city
$cityManager = new RowManager_HrdbCityManager();
$multiTableManager->addRowManager($cityManager, new JoinPair($assManager->getJoinOnCityID(), $cityManager->getJoinOnCityID()));
// province
$provinceManager = new RowManager_ProvinceManager();
$multiTableManager->addRowManager($provinceManager, new JoinPair($cityManager->getJoinOnProvinceID(), $provinceManager->getJoinOnProvinceID()));
// region
$regionManager = new RowManager_HrdbRegionManager();
$multiTableManager->addRowManager($regionManager, new JoinPair($provinceManager->getJoinOnRegionID(), $regionManager->getJoinOnRegionID()));
}
// STEP THREE COMPLETE
$multiTableManager->setSortOrder($sortBy);
parent::__construct($multiTableManager, 'RowManager_HrdbRenManager');
}
/**
* function __construct
* <pre>
* Initialize the Class ...
* </pre>
* @param $personyear_id [INTEGER] value used to initialize the list.
* @param $sortBy [STRING] the field name to sort list by
* @return [void]
*/
function __construct($campus_id = -1, $assignment_status_list = '', $sortBy = '')
{
// NOTE: if you need to narrow the field of the search then uncommnet
// the following and set the proper search criteria.
if ($campus_id == '') {
$campus_id = -1;
}
if ($sortBy == '') {
$sortBy = 'personyear_id';
}
$personYearManager = new RowManager_PersonYearManager();
$campusAssignments = new RowManager_AssignmentsManager();
$campusAssignments->setCampusID($campus_id);
$person = new RowManager_PersonManager();
$searchManager = new MultiTableManager();
//new RowManager_PersonYearManager();
$searchManager->addRowManager($campusAssignments);
$searchManager->addRowManager($personYearManager, new JoinPair($personYearManager->getJoinOnPersonID(), $campusAssignments->getJoinOnPersonID(), JOIN_TYPE_LEFT));
$searchManager->addRowManager($person, new JoinPair($person->getJoinOnPersonID(), $personYearManager->getJoinOnPersonID()));
if ($assignment_status_list != '') {
$searchManager->addSearchCondition('assignmentstatus_id in (' . $assignment_status_list . ')');
// filter results by student-campus status
}
$searchManager->setSortOrder($sortBy);
// $this->resultSet = $searchManager->find();
$foundIterator = $searchManager->getListIterator();
$foundArray = $foundIterator->getDataList();
/** Add new person year entries as required **/
reset($foundArray);
foreach (array_keys($foundArray) as $k) {
$record = current($foundArray);
$person_id = $record['person_id'];
// person_id must exist given join condition, personyear_id and/or year_id may not
$personyear_id = $record['personyear_id'];
/** Add new person year entry if person doesn't have one yet **/
if ($personyear_id == "") {
$newPersonYear = new RowManager_PersonYearManager();
$newPersonYear->setPersonID($person_id);
$newPersonYear->setYear(RowManager_PersonYearManager::OTHER);
$newPersonYear->createNewEntry();
}
next($foundArray);
}
$keepList = 'campus_id';
$searchManager->deleteValuesExceptSome($keepList);
$this->resultSet = $searchManager->find();
// echo "record array = <pre>".print_r($foundArray,true)."</pre>";
// $searchManager->setValueByFieldName("campus_id", $campus_id );
//$searchManager->setValueByFieldName('module_isCommonLook', '1' );
}
private function loadFieldValuesForm(&$form)
{
$fields = new RowManager_FieldManager();
$fieldTypes = new RowManager_FieldTypeManager();
$fieldValues = new RowManager_FieldValueManager();
$fieldValues->setRegID($this->REG_ID);
$formFieldValues = new MultiTableManager();
$formFieldValues->addRowManager($fields);
$formFieldValues->addRowManager($fieldTypes, new JoinPair($fields->getJoinOnFieldTypeID(), $fieldTypes->getJoinOnFieldTypeID()));
$formFieldValues->addRowManager($fieldValues, new JoinPair($fields->getJoinOnFieldID(), $fieldValues->getJoinOnFieldID()));
$formFieldValues->setSortOrder('fields_priority');
$formFieldValuesList = $formFieldValues->getListIterator();
$formFieldValuesArray = $formFieldValuesList->getDataList();
$formFieldLabels = array();
$formData = array();
$fieldInfo = '';
// $isFirst = true;
$fieldValue = '';
reset($formFieldValuesArray);
// (below) store registration-specific form values for event-specific fields
foreach (array_keys($formFieldValuesArray) as $k) {
$row = current($formFieldValuesArray);
// $field_value = $row['fieldvalues_value'];
$fieldName = 'fields_id' . $row['fields_id'];
$fieldInfo .= $fieldName . '|' . $row['fieldtypes_desc'] . '|' . $row['datatypes_id'] . '|' . $row['fields_reqd'] . '|' . $row['fields_invalid'] . '';
$formFieldLabels[$fieldName] = $row['fields_desc'];
$fieldValue = $row['fieldvalues_value'];
$formData[$fieldName] = $fieldValue;
$fieldInfo .= ',';
next($formFieldValuesArray);
}
$fieldInfo = substr($fieldInfo, 0, -1);
// remove final ','
// set data in the form to be displayed
$form->setFields($fieldInfo);
$form->setFormData($formData);
$form->setLabels($formFieldLabels);
$form->setButtonText('Update');
// setup form action based on AppController standards
$parameters = array('EVENT_ID' => $this->EVENT_ID, 'FIELDTYPE_ID' => $this->FIELDTYPE_ID, 'PRICERULETYPE_ID' => $this->PRICERULETYPE_ID, 'CCTYPE_ID' => $this->CCTYPE_ID, 'PRIV_ID' => $this->PRIV_ID, 'VIEWER_ID' => $this->VIEWER_ID, 'SUPERADMIN_ID' => $this->SUPERADMIN_ID, 'EVENTADMIN_ID' => $this->EVENTADMIN_ID, 'FIELD_ID' => $this->FIELD_ID, 'DATATYPE_ID' => $this->DATATYPE_ID, 'PRICERULE_ID' => $this->PRICERULE_ID, 'CAMPUSACCESS_ID' => $this->CAMPUSACCESS_ID, 'CASHTRANS_ID' => $this->CASHTRANS_ID, 'CCTRANS_ID' => $this->CCTRANS_ID, 'REG_ID' => $this->REG_ID, 'FIELDVALUE_ID' => $this->FIELDVALUE_ID, 'SCHOLARSHIP_ID' => $this->SCHOLARSHIP_ID, 'STATUS_ID' => $this->STATUS_ID, 'CAMPUS_ID' => $this->CAMPUS_ID);
//[RAD_CALLBACK_PARAMS]
$formAction = $this->getCallBack(modulecim_reg::PAGE_EDITREGISTRATIONFIELDVALUESFORM, $this->sortBy, $parameters);
$form->setFormAction($formAction);
return;
}
protected function getFieldArray($scopeRefList, $freqID = '', $measID = '')
{
$stats = new MultiTableManager();
$stat = new RowManager_StatisticManager();
$freq = new RowManager_FreqTypeManager();
$stats->addRowManager($stat);
$stats->addRowManager($freq, new JoinPair($stat->getJoinOnFreqID(), $freq->getJoinOnFreqID()));
// filter the statistic fields shown using the parameters
$searchConditions = '';
if (isset($scopeRefList)) {
reset($scopeRefList);
foreach (array_keys($scopeRefList) as $k) {
$scopeID = key($scopeRefList);
$scopeRefID = current($scopeRefList);
$searchConditions .= '(p2c_stats_statistic.scope_id = ' . $scopeID;
$searchConditions .= ' AND p2c_stats_statistic.scope_ref_id = ' . $scopeRefID . ')';
$searchConditions .= ' OR ';
next($scopeRefList);
}
$searchConditions = substr($searchConditions, 0, -4);
// remove last OR
$stats->addSearchCondition($searchConditions);
}
if ($freqID != '') {
// $stats->setFreqID($freqID);
$stats->addSearchCondition('p2c_stats_statistic.freq_id = ' . $freqID);
}
if ($measID != '') {
// $stats->setMeasureTypeID($measID);
$stats->addSearchCondition('p2c_stats_statistic.meas_id = ' . $measID);
}
// $stats->setSortByStatID();
$stats->setSortOrder('statistic_id');
// echo $stats->createSQL();
$statsIterator = $stats->getListIterator();
$statsArray = $statsIterator->getDataList();
// echo "found statistics:<br><pre>".print_r($statsArray,true)."</pre>";
// map the fields_id of each field values row to the label of that particular form field
$idx = 0;
reset($statsArray);
foreach (array_keys($statsArray) as $k) {
$record = current($statsArray);
// store mapping associating form field label with fields_id
$this->formFieldToStatIDmapper['form_field' . $idx] = $record['statistic_id'];
$this->formFieldToStatIDmapper['form_field' . ++$idx] = $record['statistic_id'];
// for freq value field
next($statsArray);
$idx++;
}
// echo "stat id values:<br><pre>".print_r($this->formFieldToStatIDmapper,true)."</pre>";
return $statsArray;
}
/**
* 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->campusaccess_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
//
// NOTE: Hobbe, here are the original two lines that I moved to below
//
// $xmlNodeName = RowManager_EventAdminCampusAssignmentManager::XML_NODE_NAME;
// $this->template->set( 'rowManagerXMLNodeName', $xmlNodeName);
// store the primary key field name for the data being displayed
$this->template->set('primaryKeyFieldName', 'campusaccess_id');
// Russ' Debugging Methodoloy
// 1. Try and create a multi-table manager that returns the
// result set I want and put it into and array. Then figure
// out why that is not making it through to the template.
//
// Result: Hobbe, indeed you were creating the multi-table
// manager correctly (I just renamed the one row manager),
// otherwise your code was fine.
//
// 2. Ok, try and figure out why the template doesn't like
// XML it is getting.
//
// a. first I check another example (FormProcessor_AddSuperAdmin)
// of where an adminbox type template is generated. Yes, it
// appears we are sending the xml properly
//
// b. i notice the call to ->set('primaryKeyFieldName', ... )
// in the example I'm checking, that too seems to be okay
//
// c. I notice the xmlNodeName parameter being set in the
// templates, i realize that we are not setting this properly
// and refactor the code a little to get the xmlNodeName from
// the multitablemanager instead.
// store data list to the template
// NOTE: we initialize it here to make sure we capture any new data
// from a recent processData() call.
$campusAdminManager = new RowManager_EventAdminCampusAssignmentManager();
//*** ADDED JOIN TO FILTER BY EVENT ***/
$eventAdminManager = new RowManager_EventAdminAssignmentManager();
// echo "The eventID is [".$this->event_id."]<br/>";
$eventAdminManager->setEventID($this->event_id);
$multiTableManager = new MultiTableManager();
$multiTableManager->addRowManager($campusAdminManager);
$multiTableManager->addRowManager($eventAdminManager, new JoinPair($eventAdminManager->getJoinOnEventAdminID(), $campusAdminManager->getJoinOnEventAdminID()));
// code to check the result set in the multi-table manager
// $i = 0;
// $listIt = $multiTableManager->getListIterator();
// $listIt->setFirst();
// while( $listIt->moveNext() )
// {
// echo "ith [".$i."] element";
// $i++;
// }
// end multi-table manager check
// $this->dataList = $multiTableManager->getListIterator();
// echo "<pre>List: ".print_r($this->dataList,true)."</pre>";
//*** END ADD ***/
$this->dataList = $multiTableManager->getListIterator();
// Hobbe, I added/moved these two lines and now it works!
// It has to do with how the template understands the
// XML that it is passed
$xmlNodeName = $this->dataList->getRowManagerXMLNodeName();
$this->template->set('rowManagerXMLNodeName', $xmlNodeName);
$this->template->setXML('dataList', $this->dataList->getXML());
/*
* Add any additional data required by the template here
*/
$eventAdmin = new RowManager_EventAdminAssignmentManager();
$eventAdmin->setEventID($this->event_id);
$viewer = new RowManager_ViewerManager();
$multiTableManager2 = new MultiTableManager();
$multiTableManager2->addRowManager($eventAdmin);
$multiTableManager2->addRowManager($viewer, new JoinPair($eventAdmin->getJoinOnViewerID(), $viewer->getJoinOnViewerID()));
// $multiTableManager2->constructSearchCondition( 'event_id', '=', $this->event_id, true );
$multiTableManager2->setSortOrder('viewer_userID');
$multiTableManager2->setLabelTemplate('viewer_userID', '[viewer_userID]');
$listIterator = $multiTableManager2->getListIterator();
// code to check the result set in the multi-table manager
/* echo "<pre>List: ".print_r($listIterator,true)."</pre>";
$i = 0;
$listIt = $multiTableManager2->getListIterator();
$listIt->setFirst();
while( $listIt->moveNext() )
{
echo "ith [".$i."] element";
$i++;
}
*/
// end multi-table manager check
// echo print_r($listIterator,true);
/*
$viewer = new RowManager_ViewerManager();
$viewer->setSortOrder( 'viewer_userID' );
$viewerList = new ListIterator($viewer);
$viewerArray = $viewerList->getDropListArray();
*/
$viewerArray = $listIterator->getDropListArray();
//$listIterator
$this->template->set('list_eventadmin_id', $viewerArray);
// echo print_r($viewerArray,true);
$campus = new RowManager_CampusManager();
// $campus->setEventID( $this->event_id);
$campus->setSortOrder('campus_id');
$campusList = new ListIterator($campus);
$campusArray = $campusList->getDropListArray();
$this->template->set('list_campus_id', $campusArray);
$templateName = 'siteAdminBox.php';
// if you are creating a custom template for this page then
// replace $templateName with the following:
//$templateName = 'page_AddCampusAdmin.php';
return $this->template->fetch($templateName);
}
/**
* 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, $sortBy)
{
parent::__construct(page_ViewGroups::DISPLAY_FIELDS);
$this->pathModuleRoot = $pathModuleRoot;
$this->viewer = $viewer;
//Get person ID
$accessManager = new RowManager_AccessManager();
$accessManager->loadByViewerID($this->viewer->getViewerID());
$this->personID = $accessManager->getPersonID();
echo "ViewerID: " . $this->viewer->getViewerID() . " <br>personID: " . $this->personID . "<br>";
/*
* The code below contains the different permission cases for view groups.
*
* Check 1 = check if the user is a SUPER ADMIN
* Check 2 = check if the user is a STAFF and which campuses he/she is assigned to, taken from HRDB
* Check 3 =check cim_sch_permissionCampusAdmin for which CAMPUSES this user is ADMIN for
* Check 4 = check cim_sch_permissionGroupAdmin for which GROUPS this user is ADMIN for
* If check 1-4 FAIL then ViewGroup will show nothing. (This user is a normal user and have not created any groups .
*/
$multiTableManager = new MultiTableManager();
$groupManager = new RowManager_GroupManager();
$superAdminManager = new RowManager_PermissionsSuperAdminManager();
//SUPER ADMIN
//Check if user's Viewer_id is in the PermissionSuperAdmin table
if ($superAdminManager->loadByViewerID($this->viewer->getViewerID())) {
// the viewer is a super admin
echo "ViewerID[" . $this->viewer->getViewerID() . "] is a super admin<br/>";
$campusGroupManager = new RowManager_CampusGroupManager();
$multiTableManager->addRowManager($groupManager);
$multiTableManager->addRowManager($campusGroupManager, new JoinPair($campusGroupManager->getJoinOnGroupID(), $groupManager->getJoinOnGroupID(), JOIN_TYPE_LEFT));
} else {
//STAFF
// This array stores all the campuses associated to the user.
//This array is continually populated
$campusArray = array();
//check HRDB if the user is a staff
$assignmentManager = new RowManager_AssignmentsManager();
$assignmentManager->setPersonID($this->personID);
$assignmentManager->setAssignmentStatus(CA_STAFF);
$assList = new ListIterator($assignmentManager);
$assList->setFirst();
while ($assList->moveNext()) {
$assMan = $assList->getCurrent(new RowManager_AssignmentsManager());
//for each campuses found, store in array
$campusArray[] = $assMan->getCampusID();
}
//CAMPUS ADMIN
//Check cim_sch_permissionsCampusAdmin for the viewer id of the user
$permissionsCampusAdmin = new RowManager_PermissionsCampusAdminManager();
$permissionsCampusAdmin->setViewerID($this->viewer->getViewerID());
$campusAdminList = new ListIterator($permissionsCampusAdmin);
$campusAdminList->setFirst();
while ($campusAdminList->moveNext()) {
$permCampus = $campusAdminList->getCurrent(new RowManager_PermissionsCampusAdminManager());
//for each campuses found, store in array
$campusArray[] = $permCampus->getCampusID();
}
//remove any duplicate campus ID in the array
$campusArray = array_unique($campusArray);
//GROUP ADMIN
$permissionsGroupAdminManager = new RowManager_PermissionsGroupAdminManager();
$campusGroupManager = new RowManager_CampusGroupManager();
//send a list of campues and the viewer ID to constrict the search condition
//The Viewer_id is use to check the cim_sch_permissionsGroupAdmin table for
// groups that were created by the user
$searchCond = $campusGroupManager->returnSearchCondition($campusArray, $this->viewer->getViewerID());
//create the appropriate join between 3 tables
//Join cim_sch_group and cim_sch_permissionsGroupAdmin and cim_sch_campusGroup
$multiTableManager->addRowManager($groupManager);
$multiTableManager->addRowManager($campusGroupManager, new JoinPair($campusGroupManager->getJoinOnGroupID(), $groupManager->getJoinOnGroupID(), JOIN_TYPE_LEFT));
$multiTableManager->addRowManager($permissionsGroupAdminManager, new JoinPair($permissionsGroupAdminManager->getJoinOnGroupID(), $groupManager->getJoinOnGroupID(), JOIN_TYPE_LEFT));
$multiTableManager->addSearchCondition($searchCond);
}
/*Case 3: Group Admin - access to an individual group and can create other group admins
(ex. DGL)
Normal User - can only submit schedule, assume this unless given other permissions
Check the group admin table
check cim_sch_permissiongroupadmin -> cim_sch_campusgroup -> cim_sch_group
filter on viewer id
Case 4: All staff - implicit access to all groups on all campuses where their status is staff
check cim_hrdb_staff table
if true
get all campuses from cim_hrdb_assignment where assignment status id = 3
*/
/*$groupManager = new RowManager_GroupManager();
$multiTableManager = new MultiTableManager();
$campusGroupManager = new RowManager_CampusGroupManager();
$multiTableManager->addRowManager( $campusGroupManager );
$multiTableManager->addRowManager( $groupManager, new JoinPair( $campusGroupManager->getJoinOnGroupID(), $groupManager->getJoinOnGroupID(), JOIN_TYPE_RIGHT ) );*/
// $dataAccessObject = $multiTableManager;
$multiTableManager->setSortOrder('campus_id');
//******Not sure this is the way to do it*****
// $this->listManager = new GroupList( $sortBy );
$this->listManager = $multiTableManager->getListIterator();
// now initialize the labels for this page
// start by loading the default field labels for this Module
$languageID = $viewer->getLanguageID();
$seriesKey = modulecim_sch::MULTILINGUAL_SERIES_KEY;
$pageKey = modulecim_sch::MULTILINGUAL_PAGE_FIELDS;
$this->labels = new MultilingualManager($languageID, $seriesKey, $pageKey);
// then load the page specific labels for this page
$pageKey = page_ViewGroups::MULTILINGUAL_PAGE_KEY;
$this->labels->loadPageLabels($pageKey);
$this->labels->setSeriesKey(SITE_LABEL_SERIES_SITE);
$this->labels->loadPageLabels(SITE_LABEL_PAGE_FORM_LINKS);
}
/**
* function __construct
* <pre>
* Initialize the object.
* </pre>
* @param $pathModuleRoot [STRING] The path to the module's root dir.
* @param $viewer [OBJECT] The viewer object.
* @return [void]
*/
function __construct($pathModuleRoot, $viewer, $staff_id, $campus_id, $semester_id)
{
parent::__construct();
// initialzie the object values
$this->pathModuleRoot = $pathModuleRoot;
$this->viewer = $viewer;
// for looking up the person_id of this staff member
$this->staff_id = $staff_id;
$staffManager = new RowManager_StaffManager($this->staff_id);
// echo 'the staff_id['.$this->staff_id.']<br/>';
$this->permManager = new PermissionManager($this->viewer->getViewerID());
// figure out what campuses to display
$campusManager = new RowManager_CampusManager();
$multiTableManager = new MultiTableManager();
$isRT = $this->permManager->isRegional();
if ($isRT) {
// get all the campuses across the country
$multiTableManager->addRowManager($campusManager);
} else {
// get only the campuses the staff is assigned to
$assignmentManager = new RowManager_AssignmentsManager();
$this->person_id = $staffManager->getPersonID();
$assignmentManager->setPersonID($this->person_id);
$assignmentManager->setAssignmentStatusID(CA_STAFF);
$multiTableManager->addRowManager($assignmentManager);
$multiTableManager->addRowManager($campusManager, new JoinPair($campusManager->getJoinOnCampusID(), $assignmentManager->getJoinOnCampusID()));
}
$multiTableManager->setSortOrder('campus_desc');
$this->campusListIterator = $multiTableManager->getListIterator();
if ($campus_id != '') {
// echo 'campus_id is SET ['.$campus_id.']<br/>';
$this->campus_id = $campus_id;
} else {
// set a default campus id
// echo 'Choosing a default campus<br/>';
$this->campusListIterator->setFirst();
if ($this->campusListIterator->moveNext()) {
$campusObject = $this->campusListIterator->getCurrent(new RowManager_CampusManager());
$this->campus_id = $campusObject->getID();
} else {
die('ERROR - unable to set campus_id - page_StaffWeeklyReport');
}
}
// echo 'the campus_id['.$this->campus_id.']<br/>';
if ($semester_id != '') {
$this->semester_id = $semester_id;
} else {
// set a default semester id
$this->semester_id = 10;
// TODO set this properly
}
// echo 'the semester_id['.$this->semester_id.']<br/>';
// now initialize the labels for this page
// start by loading the default field labels for this Module
$languageID = $viewer->getLanguageID();
$seriesKey = modulecim_stats::MULTILINGUAL_SERIES_KEY;
$pageKey = modulecim_stats::MULTILINGUAL_PAGE_FIELDS;
$this->labels = new MultilingualManager($languageID, $seriesKey, $pageKey);
$pageKey = page_StaffSemesterReport::MULTILINGUAL_PAGE_KEY;
$this->labels->loadPageLabels($pageKey);
}
/**
* 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
$path = SITE_PATH_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]');
$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);
// echo "<pre>".print_r($this->linkValues, true)."</pre>";
$title = $this->labels->getLabel('[Details]');
$columnLabel = $this->labels->getLabel('[View]');
$link = $this->linkValues['view'];
$fieldName = 'event_id';
$this->addLinkColumn($title, $columnLabel, $link, $fieldName);
$REGISTERED = 2;
//'true';
$INCOMPLETE = 1;
$NOT_REGISTERED = 0;
//'false';
/** determine which events the user has already registered for... **/
$events = new RowManager_EventManager();
$events->setOnHomePage('1');
$events->addSearchCondition($this->countrySearchCondition);
// $events->setSortOrder( $this->sortBy ); // needed to sync lists
$regs = new RowManager_RegistrationManager();
$regs->setPersonID($this->person_id);
$status = new RowManager_StatusManager();
$status->setStatusDesc(RowManager_StatusManager::REGISTERED);
$reg_events = new MultiTableManager();
$reg_events->addRowManager($events);
$reg_events->addRowManager($regs, new JoinPair($events->getJoinOnEventID(), $regs->getJoinOnEventID()));
$reg_events->addRowManager($status, new JoinPair($regs->getJoinOnStatus(), $status->getJoinOnStatusID()));
if (!isset($this->sortBy) || $this->sortBy == '') {
$this->sortBy = 'event_id';
}
$reg_events->setSortOrder($this->sortBy);
// needed to sync lists
// echo "reg events sql = ".$reg_events->createSQL();
$regs_events_list = $reg_events->getListIterator();
$regs_events_array = $regs_events_list->getDataList();
/** determine which events the user has PARTIALLY completed registration for ***/
$events2 = new RowManager_EventManager();
$events2->setOnHomePage('1');
$events2->addSearchCondition($this->countrySearchCondition);
// $events->setSortOrder( $this->sortBy ); // needed to sync lists
$regs2 = new RowManager_RegistrationManager();
$regs2->setPersonID($this->person_id);
$status2 = new RowManager_StatusManager();
$status2->setStatusDesc(RowManager_StatusManager::INCOMPLETE);
$reg_events2 = new MultiTableManager();
$reg_events2->addRowManager($events2);
$reg_events2->addRowManager($regs2, new JoinPair($events2->getJoinOnEventID(), $regs2->getJoinOnEventID()));
$reg_events2->addRowManager($status2, new JoinPair($regs2->getJoinOnStatus(), $status2->getJoinOnStatusID()));
$reg_events2->setSortOrder($this->sortBy);
// needed to sync lists
// echo "reg events sql = ".$reg_events->createSQL():
$incomplete_regs_events_list = $reg_events2->getListIterator();
$incompete_regs_events_array = $incomplete_regs_events_list->getDataList();
// echo '<pre>'.print_r($incompete_regs_events_array, true).'</pre>';
// get full event-listing for mapping isRegistered to
$allEvents = $this->listManager->getDataList();
//
// echo 'reg events = <pre>'.print_r($regs_events_array,true).'</pre><br>';
// echo 'all events = <pre>'.print_r($allEvents, true).'</pre><br>';
$eventName_isReg_array = array();
reset($regs_events_array);
reset($incompete_regs_events_array);
reset($allEvents);
foreach (array_keys($allEvents) as $k) {
$record = current($allEvents);
$currentEvent = $record['event_id'];
$record2 = current($regs_events_array);
$currentRegEvent = $record2['event_id'];
$record3 = current($incompete_regs_events_array);
$currentIncRegEvent = $record3['event_id'];
$eventName = $record['event_name'];
// store event in registered array if mapping found
if ($currentEvent == $currentRegEvent) {
$eventName_isReg_array[$eventName] = $REGISTERED;
next($regs_events_array);
} else {
if ($currentEvent == $currentIncRegEvent) {
$eventName_isReg_array[$eventName] = $INCOMPLETE;
next($incompete_regs_events_array);
} else {
$eventName_isReg_array[$eventName] = $NOT_REGISTERED;
}
}
next($allEvents);
}
// echo "events: <PRE>".print_r($eventName_isReg_array,true)."</PRE>";
$title = $this->labels->getLabel('[RegisterAccess]');
$columnLabels = array();
$columnLabels[$NOT_REGISTERED] = $this->labels->getLabel('[Register]');
$columnLabels[$INCOMPLETE] = $this->labels->getLabel('[FinishReg]');
$columnLabels[$REGISTERED] = $this->labels->getLabel('[EditReg]');
// formerly [CancelReg]
$links = array();
$links[$NOT_REGISTERED] = $this->linkValues['register'];
$links[$INCOMPLETE] = $this->linkValues['complete'];
$links[$REGISTERED] = $this->linkValues['edit_reg'];
// formerly 'cancel'
// field column names to map to link name (i.e. filter by event to determine if link name should change based on reg status)
$fieldNames = array();
$fieldNames[$NOT_REGISTERED] = 'event_id';
$fieldNames[$INCOMPLETE] = 'event_id';
$fieldNames[$REGISTERED] = 'event_id';
// OLD: $this->addLinkColumn( $title, $columnLabel, $link, $fieldName, $useAlt, $alt_label, $link_alt, $fieldAlt);
$this->addDynamicLinkColumn($title, $columnLabels, $links, $fieldNames);
// link an array of filters to a particular link column
$linkColumnFilter[$title] = $eventName_isReg_array;
// echo '<pre>'.print_r($linkColumnFilter, true).'</pre>';
// store the page labels
// NOTE: use this location to update any label tags ...
// example:
// $name = $user->getName();
// $this->labels->setLabelTag( '[Title]', '[userName]', $name);
$this->prepareTemplate($path);
// set the filter list used to determine which events have 'register' links and which have 'cancel' links
$this->template->set('linkColumnFilter', $linkColumnFilter);
// store the Row Manager's XML Node Name
$this->template->set('rowManagerXMLNodeName', RowManager_EventManager::XML_NODE_NAME);
// store the primary key field name for the data being displayed
$this->template->set('primaryKeyFieldName', 'event_id');
/*
* Set up any additional data transfer to the Template here...
*/
$this->template->set('disableHeading', true);
$templateName = 'siteDataList.php';
// if you are creating a custom template for this page then
// replace $templateName with the following:
//$templateName = 'page_HomePageEventList.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()
{
// initialize the variable storing process report data
$reportDataDump = '';
$BR = '<BR>';
$HR = '<HR>';
// Make a new Template object
$path = $this->pathModuleRoot . 'templates/';
// $path = SITE_PATH_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['cont'] = $this->labels->getLabel('[GoBack]');
// 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);
$this->prepareTemplate($path);
/** Get list of unique triples of first name, last name, and e-mail address **/
// $allPeople = array(); // NOT USED BECAUSE WE HAVE NESTED LOOP INSTEAD OF MULTIPLE LOOPS
$personRecords = new MultiTableManager();
$personRecords->addRowManager($this->person_manager);
$personRecords->setSortOrder('person_lname');
// echo 'filters = '.$this->filter_fname.', '.$this->filter_lname.', '.$this->filter_email;
/**** DATA FILTERS: USED TO ENSURE 60 SEC TIME-OUT IS NOT VIOLATED ****/
$personRecords->addSearchCondition("person_fname like '" . $this->filter_fname . "%'");
$personRecords->addSearchCondition("person_lname like '" . $this->filter_lname . "%'");
$personRecords->addSearchCondition("person_email like '" . $this->filter_email . "%'");
// use GROUP BY to easily enforce distinct triplets of (person_fname, person_lname, person_email)
$groupBy = "person_fname,person_lname,person_email";
$personRecords->setGroupBy($groupBy);
$personData = $personRecords->getListIterator();
$personDataArray = $personData->getDataList();
/** Go through the list of names 1 by 1, running another query to find if duplicates exist **/
reset($personDataArray);
foreach (array_keys($personDataArray) as $k) {
$savedPersonID = -1;
// the only person ID left in the database for this individual
$person = current($personDataArray);
$person_fname = $person['person_fname'];
$person_lname = $person['person_lname'];
$person_email = $person['person_email'];
$reportDataDump .= 'Unique person record tuple:' . $BR . ' First Name = ' . $person_fname . ', Last Name = ' . $person_lname . ', E-mail = ' . $person_email . $BR . $BR;
// echo "PERSON NAME: ".$person_fname." ".$person_lname;
// echo "PERSON: <pre>".print_r($person,true)."</pre>";
// search for a particular person to see if duplicate records exist
$indiv_person_manager = new RowManager_PersonManager();
$indiv_person_manager->setFirstName(addslashes($person_fname));
// use addslashes to escape special chars in string
$indiv_person_manager->setLastName(addslashes($person_lname));
$indiv_person_manager->setEmail(addslashes($person_email));
$indiv_person_manager->setSortOrder('person_id');
$indiv_person_manager->setAscDesc('DESC');
// sort by descending person IDs
$indivData = $indiv_person_manager->getListIterator();
$indivDataArray = $indivData->getDataList();
// echo " INDIV COUNT: ".count($indivDataArray)."<br><br>";
// echo "INDIV RECORDS: <pre>".print_r($indivDataArray,true)."</pre>";
$person_ids_list = '';
//return all the person's data into array (key = person_id) of arrays (and store total data stored?)
if (isset($indivDataArray)) {
if (count($indivDataArray) == 0) {
echo "ERROR: person was found earlier and now NO records are found!";
} else {
if (count($indivDataArray) == 1) {
// echo "GREAT! This person only has one record.";
reset($indivDataArray);
$record = current($indivDataArray);
$savedPersonID = $record['person_id'];
$person_ids_list = $savedPersonID;
$reportDataDump .= 'Unique person id found for tuple: ' . $savedPersonID . $BR . $BR;
} else {
if (count($indivDataArray) > 1) {
// get the person IDs for this individual
reset($indivDataArray);
foreach (array_keys($indivDataArray) as $l) {
$record = current($indivDataArray);
$person_ids_list .= $record['person_id'];
$person_ids_list .= ',';
next($indivDataArray);
}
$person_ids_list = substr($person_ids_list, 0, -1);
// remove final comma
$reportDataDump .= 'Multiple person ids found for tuple: ' . $person_ids_list . $BR . $BR;
}
}
}
// Search for duplicate person-related entries - for 1 or more person_ids found for current person
if ($person_ids_list != '') {
// echo "<br> person ids list: ".$person_ids_list."<br>";
// $person_ids_array = explode($person_ids_list,',');
// check access table using all the found person IDs - retrieve viewer ids with person id as key
$foundViewerIDs = $this->getAccessRecords($person_ids_list);
// can safely assume array ISSET
// echo 'found viewer ids= <pre>'.print_r($foundViewerIDs,true).'</pre>';
/** IF 0 access table records were found: **/
if (count($foundViewerIDs) == 0) {
// TODO?: notify admin that this/these person record(s) require a viewer account
// Store the active (latest) person_id in special variable
reset($indivDataArray);
$savedPersonID = key($indivDataArray);
// recall that person_ids are sorted in descending order
} else {
if (count($foundViewerIDs) >= 1) {
// echo "<br>found viewer IDs: <pre>".print_r($foundViewerIDs, true)."</pre>";
/** Get the associated viewer_id with the most recent login date **/
// $viewers = new RowManager_ViewerManager();
// $viewer_ids = '';
// reset($foundViewerIDs);
// foreach (array_keys($foundViewerIDs) as $key)
// {
// // $record = current($foundViewerIDs);
// $viewer_ids .= $key.','; //$record //
// next($foundViewerIDs);
// }
// $viewer_ids = substr($viewer_ids, 0, -1); // remove final comma
// // echo 'viewer_ids list = '.$viewer_ids.'<br>';
// $viewers->addSearchCondition("viewer_id in (".$viewer_ids.")");
//
// $viewersData = $viewers->getListIterator();
// $viewersArray = $viewersData->getDataList();
//
// // echo 'viewers array data = <pre>'.print_r($viewersArray,true).'</pre>';
//
// $mostRecentDate = '0000-00-00';
// $mostRecentViewer = -1;
// reset($viewersArray);
// foreach(array_keys($viewersArray) as $l)
// {
// $record = current($viewersArray);
// $foundDate = $record['viewer_lastLogin'];
// $viewerID = $record['viewer_id'];
//
// // update most recent date if a more recent login date was found
// if ($foundDate > $mostRecentDate)
// {
// $mostRecentDate = $foundDate;
// $mostRecentViewer = $viewerID; // set viewer_id to use
// }
// }
// TODO: add loop here to check if all $foundViewerIDs (from access table) are in viewers table
// <loop>
// if (in_array($foundViewerIDs[index], array_keys($viewersArray)))
// delete $foundViewerIDs[index] from access table
// <end-loop>
// echo 'most recent viewer id = '.$mostRecentViewer;
// echo 'viewer ids from list = <pre>'.print_r(array_keys($foundViewerIDs),true).'</pre>';
/** store the active (access table) person_id in special variable **/
reset($foundViewerIDs);
// // (NEW) == person_id associated with the viewer_id having the most recent login date
// // ONLY IN THE CASE WHERE PERSON HAS MORE THAN 1 VIEWER_ID
// if (($mostRecentViewer != -1)&&(count($viewersArray) > 1))
// {
// $temp_viewerIDs = array_keys($foundViewerIDs); // gets the viewer ids
// $temp_personIDs = array_values($foundViewerIDs); // gets the person ids
// $index = array_search($mostRecentViewer, $temp_viewerIDs); // get index having most recent viewer_id
//
// $savedPersonID = $temp_personIDs[$index];
// $reportDataDump .= 'Person ID of the record to keep: '.$savedPersonID.' (associated with most recent login)'.$BR.$BR;
// }
// else // FORMERLY: (OLD) == latest viewer-associated person ID, since array is ordered by person_id (DESC)
// {
$personIDs = explode(',', $person_ids_list);
$savedPersonID = current($personIDs);
//current($foundViewerIDs);
$reportDataDump .= 'Person ID of the record to keep: ' . $savedPersonID . ' (associated with the most recent person record)' . $BR . $BR;
// }
// echo 'latest viewer ids = <pre>'.print_r($foundViewerIDs,true).'</pre>';
// echo 'saved person ID = '.$savedPersonID;
$reportDataDump .= 'Changes made to <b>cim_hrdb_access table</b>: ' . $BR;
/*** update the access table records to only use latest person ID **/
foreach (array_values($foundViewerIDs) as $person_id) {
$viewer_id = key($foundViewerIDs);
// echo 'viewer_id = '.$viewer_id;
// only update the access table record if it needs a different person_id
if ($person_id != $savedPersonID) {
// get access ID(s) for the record to change
$accessManager = new RowManager_AccessManager();
$accessManager->setViewerID($viewer_id);
$accessManager->setPersonID(current($foundViewerIDs));
// or just use $person_id
$accessData = $accessManager->getListIterator();
$accessDataArray = $accessData->getDataList();
// echo 'access data array = <pre>'.print_r($accessDataArray,true).'</pre>';
reset($accessDataArray);
// deal with the unlikely case that we have redundant viewerID-personID records
foreach (array_keys($accessDataArray) as $key) {
$record = current($accessDataArray);
$accessID = $record['access_id'];
// set the values to set in the record (using 'access_id' as search key)
$updateValues = array();
$updateValues['access_id'] = $accessID;
$updateValues['viewer_id'] = $viewer_id;
$updateValues['person_id'] = $savedPersonID;
// only data that is changed
$reportDataDump .= 'Updating person_id ' . $person_id . ' to be ' . $savedPersonID . $BR . $BR;
$accessManager->loadFromArray($updateValues);
$accessManager->updateDBTable();
next($accessDataArray);
}
}
$id = next($foundViewerIDs);
// person_id
if ($id === FALSE) {
break;
// no valid data found so break out of the loop
}
}
}
}
/** <end> access table update **/
$baseRecord = $indivDataArray[$savedPersonID];
// echo "<br>base record: <pre>".print_r($baseRecord,true)."</pre><br>";
$flagArray = $this->checkPersonRecordFields($baseRecord);
// echo "<br>flag array: <pre>".print_r($flagArray,true)."</pre><br>";
// Add data from other records to the stored latest person record, if required
// (i.e. if latest data misses phone #, etc)
reset($indivDataArray);
foreach (array_keys($indivDataArray) as $id) {
$record = current($indivDataArray);
$personID = $record['person_id'];
if ($personID != $savedPersonID) {
$personUpdater = new RowManager_PersonManager();
$personUpdater->setPersonID($savedPersonID);
$updateValues = array();
$updateValues['person_id'] = $savedPersonID;
// just to make sure...
$nextFlagArray = $this->checkPersonRecordFields($indivDataArray[$personID]);
// echo "<br>next flag array: <pre>".print_r($nextFlagArray,true)."</pre><br>";
reset($flagArray);
foreach (array_keys($flagArray) as $m) {
// if field is empty in active record then
// replace with most recent value - if one exists
// (since we are going through a list of person ids
// in descending order)
$flag = current($flagArray);
if ($flag == '0') {
$fieldName = key($flagArray);
// check if the replacement person record has a non-empty field
if ($nextFlagArray[$fieldName] == '1') {
$updateValues[$fieldName] = $record[$fieldName];
$flagArray[$fieldName] = '1';
// prevents less-recent person data to overwrite what was just written
}
}
next($flagArray);
}
// echo "<br>update values: <pre>".print_r($updateValues,true)."</pre><br>";
// update the active person record (in database)
if (count($updateValues) > 1) {
$reportDataDump .= 'Adding the following data to our preferred <b>cim_hrdb_person</b> record (using given person_id): ';
$reportDataDump .= '<pre>' . print_r($updateValues, true) . '</pre>' . $BR . $BR;
$personUpdater->loadFromArray($updateValues);
$personUpdater->updateDBTable();
}
}
next($indivDataArray);
}
}
// end "if >1 person id found for the person data"
/** Go through various tables and clean out or update records related to the current person **/
// Update and clean-up the Person-Year table (cim_hrdb_person_year)
// Step 1) Find the information stored for the active person_id
$personYearArray = array();
$person_year_manager = new RowManager_PersonYearManager();
$person_year_manager->setPersonID($savedPersonID);
$person_year_manager->setSortOrder('personyear_id');
$person_year_manager->setAscDesc('DESC');
// sort by descending personyear IDs
// echo "<BR>".$savedPersonID.",";
$personYearData = $person_year_manager->getListIterator();
$person_year_array = $personYearData->getDataList();
reset($person_year_array);
foreach (array_keys($person_year_array) as $key) {
$record = current($person_year_array);
$person_year_id = $record['personyear_id'];
$year_id = $record['year_id'];
$personYearArray[$person_year_id] = $year_id;
// store person_id associated with the person_year_id
next($person_year_array);
}
// if (count($person_year_array) > 0)
// {
// echo "<br>Years for active person_id ".$savedPersonID.": <pre>".print_r($personYearArray,true)."</pre><br>";
// }
// echo "Person IDs list: ".$person_ids_list."<br>";
$reportDataDump .= 'Changes made to <b>cim_hrdb_person_year table</b>: ' . $BR;
// remove all but the most recent person-year record (associated with active person id)
if (count($personYearArray) > 1) {
reset($personYearArray);
$person_year_id = key($personYearArray);
$reportDataDump .= 'Saving the first person year record associated with person ID ' . $savedPersonID . $BR . $BR;
next($personYearArray);
// keep the first record (most recent personyear_id
foreach (array_keys($personYearArray) as $m) {
$record = current($personYearArray);
$personYearID = key($personYearArray);
// echo "REMOVE person-year entry for person_id = ".$savedPersonID." using key = ".key($personYearArray);
if (isset($personYearID) && $personYearID != '' && $personYearID > 0) {
$reportDataDump .= 'Deleting redundant person year record having year ID ' . $record . $BR . $BR;
$personYearUpdater = new RowManager_PersonYearManager($personYearID);
$personYearUpdater->deleteEntry();
}
next($personYearArray);
}
}
// Step 2) Update the records having the non-active person ids for this person
$person_year_manager2 = new RowManager_PersonYearManager();
$person_year_manager2->addSearchCondition('person_id in (' . $person_ids_list . ')');
$person_year_manager2->setSortOrder('person_id');
$person_year_manager2->setAscDesc('DESC');
// sort by descending person IDs
$personYearData2 = $person_year_manager2->getListIterator();
$person_year_array2 = $personYearData2->getDataList();
// echo "<br>Years for ALL person_ids: <pre>".print_r($person_year_array2,true)."</pre><br>";
// If no record was found for the active person record - then set flag for updating
$updated = true;
if (count($personYearArray) < 1) {
$updated = false;
}
reset($person_year_array2);
$j = 0;
foreach (array_keys($person_year_array2) as $l) {
$record = current($person_year_array2);
$personID = $record['person_id'];
// We ignore records with the active person id - since we dealt with those redundancies already
if ($personID != $savedPersonID) {
// echo "FOUND person ".$personID;
$person_year_id = $record['personyear_id'];
$personYearUpdater = new RowManager_PersonYearManager($person_year_id);
// $personYearUpdater->setPersonYearID($person_year_id);
$person_id = $record['person_id'];
$year_id = $record['year_id'];
// check to see if identical information was already stored under active person_id
// if (in_array($year_id, $personYearArray))
// {
if ($updated == false) {
$updateValues = array();
$updateValues['person_id'] = $savedPersonID;
// just to make sure...
$updateValues['year_id'] = $year_id;
// echo "<br>update values to ".$savedPersonID." from ".$person_id.": <pre>".print_r($person_year_array2,true)."</pre><br>";
// update the person ID for a person-DG record (in database)
$personYearUpdater->loadFromArray($updateValues);
$personYearUpdater->updateDBTable();
$updated = true;
// prevents the new data from being overwritten with older data (and allows better efficiency)
$reportDataDump .= 'No record found for person ID ' . $savedPersonID . ', updating person ID for person ID ' . $person_id . $BR . $BR;
} else {
// echo "<br>TO BE DELETED FROM cim_hrdb_person_year: person_id = ".$personID.", year = ".$year_id."<br>";
$reportDataDump .= 'Deleting record for alternative person ID ' . $person_id . $BR . $BR;
$personYearUpdater->deleteEntry();
}
// else // add person-year data from other person-id-linked records
// {
// $updateValues = array();
// $updateValues['person_id'] = $savedPersonID; // just to make sure...
// $updateValues['year_id'] = $year_id;
//
// echo "<br>update values to ".$savedPersonID." from ".$person_id.": <pre>".print_r($person_year_array2,true)."</pre><br>";
//
// // update the person ID for a person-DG record (in database)
// $personYearUpdater->loadFromArray( $updateValues );
// $personYearUpdater->updateDBTable();
// }
}
next($person_year_array2);
}
// Update the Emergency Contact table (cim_hrdb_emerg)
// Step 1) Find the information stored for the active person_id
$emergInfoArray = array();
$emerg_info_manager = new RowManager_EmergencyInfoManager();
$emerg_info_manager->setPersonID($savedPersonID);
$emerg_info_manager->setSortOrder('emerg_id');
$emerg_info_manager->setAscDesc('DESC');
// sort by descending emerg IDs
// echo "<BR>".$savedPersonID.",";
$emergInfoData = $emerg_info_manager->getListIterator();
$emerg_info_array = $emergInfoData->getDataList();
reset($emerg_info_array);
foreach (array_keys($emerg_info_array) as $l) {
$record = current($emerg_info_array);
$emerg_id = $record['emerg_id'];
$emerg_info = array();
$fields = page_PersonRecordCleanUp::EMERG_RECORD_FIELDS;
$fieldsArray = explode(",", $fields);
// store the emergency info values in an array
reset($fieldsArray);
foreach (array_keys($fieldsArray) as $k) {
$fieldName = current($fieldsArray);
$emerg_info[$fieldName] = $record[$fieldName];
next($fieldsArray);
}
// $emerg_info['person_id'] = $record['person_id'];
// $emerg_info['emerg_passportNum'] = $record['emerg_passportNum'];
// $emerg_info['emerg_passportOrigin'] = $record['emerg_passportOrigin'];
// $emerg_info['emerg_passportExpiry'] = $record['emerg_passportExpiry'];
// $emerg_info['emerg_contactName'] = $record['emerg_contactName'];
// $emerg_info['emerg_contactRship'] = $record['emerg_contactRship'];
// $emerg_info['emerg_contactHome'] = $record['emerg_contactHome'];
// $emerg_info['emerg_contactWork'] = $record['emerg_contactWork'];
// $emerg_info['emerg_contactMobile'] = $record['emerg_contactMobile'];
// $emerg_info['emerg_contactEmail'] = $record['emerg_contactEmail'];
// $emerg_info['emerg_birthdate'] = $record['emerg_birthdate'];
// $emerg_info['emerg_medicalNotes'] = $record['emerg_medicalNotes'];
// store array of record values in array with emerg_id as key
$emergInfoArray[$emerg_id] = $emerg_info;
next($emerg_info_array);
}
// TEST CONDITION
// if (count($emerg_info_array) > 0)
// {
// echo "<br>Emergency info for active person_id ".$savedPersonID.": <pre>".print_r($emergInfoArray,true)."</pre><br>";
// }
$reportDataDump .= 'Changes made to <b>cim_hrdb_emerg table</b>: ' . $BR;
// remove all but the most recent emergency info record (associated with active person id)
if (count($emergInfoArray) > 1) {
reset($emergInfoArray);
$reportDataDump .= 'Saving the emergency contact record associated with person ID ' . $savedPersonID . $BR . $BR;
next($emergInfoArray);
// keep the first record (most recent emerg_id)
foreach (array_keys($emergInfoArray) as $m) {
$record = current($emergInfoArray);
$emergID = key($emergInfoArray);
// echo "REMOVE person-emerg entry for person_id = ".$savedPersonID." using key = ".key($emergInfoArray);
if (isset($emergID) && $emergID != '') {
$emergUpdater = new RowManager_EmergencyInfoManager($emergID);
$emergUpdater->deleteEntry();
$reportDataDump .= 'Deleting redundant emergency contact record having emergency ID ' . $emergID . $BR . $BR;
}
next($emergInfoArray);
}
}
// Step 2) Update the emergency contact records having the non-active person ids for this person
$emerg_info_manager2 = new RowManager_EmergencyInfoManager();
$emerg_info_manager2->addSearchCondition('person_id in (' . $person_ids_list . ')');
$emerg_info_manager2->setSortOrder('person_id');
$emerg_info_manager2->setAscDesc('DESC');
// sort by descending person IDs
// echo "candidate person ids = ".$person_ids_list."<br>";
$emergInfoData2 = $emerg_info_manager2->getListIterator();
$emerg_info_array2 = $emergInfoData2->getDataList();
// echo "<br>Contact data for ALL person_ids: <pre>".print_r($emerg_info_array2,true)."</pre><br>";
$updateValues = array();
// $updateValues = $this->initRecord(page_PersonRecordCleanUp::EMERG_RECORD_FIELDS);
// $updateID = -1;
// // If no record was found for the active person record - then set flag for updating
// $updated = true;
// if (count($personYearArray) < 1)
// {
// $updated = false;
// }
reset($emerg_info_array2);
foreach (array_keys($emerg_info_array2) as $l) {
$record = current($emerg_info_array2);
$personID = $record['person_id'];
$contactName = $record['emerg_contactName'];
if ($personID != $savedPersonID) {
$emerg_id = $record['emerg_id'];
$personEmergUpdater = new RowManager_EmergencyInfoManager($emerg_id);
// $personEmergUpdater->setPersonEmergID($emerg_id);
$person_id = $record['person_id'];
if (count($emergInfoArray) < 1) {
// update the last-updated record with further information (if there was a last update)
// if ($updateID != -1)
// {
// $personEmergUpdater = new RowManager_EmergencyInfoManager($updateID);
// }
// TODO: reactivate the above and then delete all entries but the first totally updated record
$record['person_id'] = $savedPersonID;
// require this to actually change person ID
// // determine if some fields have been replaced previously
// $flagArray = $this->checkRecordFields($updateValues, page_PersonRecordCleanUp::EMERG_RECORD_FIELDS);
//
// reset($flagArray);
// foreach(array_keys($flagArray) as $m)
// {
// // if field is empty in update record then
// // replace with most recent value - if one exists
// // (since we are going through a list of person ids
// // in descending order)
// $flag = current($flagArray);
// if ($flag == '0')
// {
// $fieldName = key($flagArray);
// $updateValues[$fieldName] = $record[$fieldName]; // update the array (or replace empty with empty)
// }
// next($flagArray);
// }
// (BELOW) REMOVE WHEN USING ABOVE:
$updateValues['person_id'] = $savedPersonID;
// update the person ID for an emergency contact record (in database)
$personEmergUpdater->loadFromArray($updateValues);
$personEmergUpdater->updateDBTable();
// $updateID = $emerg_id; // TODO: ensure that we end up with only ONE record that is updated with latest data
$reportDataDump .= 'No record found for person ID ' . $savedPersonID . ', updating person ID for person ID ' . $person_id . $BR . $BR;
} else {
$contact_name = $record['emerg_contactHome'];
// echo "<br>TO BE DELETED FROM cim_hrdb_emerg: person_id = ".$person_id.", contactName = ".$contact_name."<br>";
$reportDataDump .= 'Deleting record for alternative person ID ' . $person_id . ' having contact name = ' . $contactName . $BR . $BR;
$personEmergUpdater->deleteEntry();
}
}
next($emerg_info_array2);
}
/**** TODO: have code to deal with redundant person ids in 'cim_hrdb_admin' (LOW-PRIORITY DUE TO SMALL SIZE OF TABLE) **/
/*** Update the Campus Assignment table (cim_hrdb_assignment) **/
// Step 1) Find the information stored for the active person_id
$campusAssignArray = array();
$campus_assign_manager = new RowManager_AssignmentsManager();
$campus_assign_manager->setPersonID($savedPersonID);
$campus_assign_manager->setSortOrder('assignment_id');
$campus_assign_manager->setAscDesc('DESC');
// sort by descending assignment IDs
$campusAssignData = $campus_assign_manager->getListIterator();
$campus_assign_array = $campusAssignData->getDataList();
reset($campus_assign_array);
foreach (array_keys($campus_assign_array) as $id) {
$record = current($campus_assign_array);
$assign_id = $record['assignment_id'];
$assignment_info = array();
$fields = page_PersonRecordCleanUp::ASSIGNMENT_RECORD_FIELDS;
$fieldsArray = explode(",", $fields);
// store the campus assignment values in an array
reset($fieldsArray);
foreach (array_keys($fieldsArray) as $k) {
$fieldName = current($fieldsArray);
$assignment_info[$fieldName] = $record[$fieldName];
next($fieldsArray);
}
// store array of record values in array with assign_id as key
$campusAssignArray[$assign_id] = $assignment_info;
next($campus_assign_array);
}
// TEST CONDITION
// if (count($campus_assign_array) > 0)
// {
// echo "<br>Campus assignment info for active person_id ".$savedPersonID.": <pre>".print_r($campusAssignArray,true)."</pre><br>";
// }
$reportDataDump .= 'Changes made to <b>cim_hrdb_assignment table</b>: ' . $BR;
// TODO??: remove all but the most recent campus assignment record (associated with active person id)
// REMEMBER: a student may be an alumni of one school or attend two schools at once...
if (count($campusAssignArray) > 1) {
$campus_ids_list = array();
$idx = 0;
reset($campusAssignArray);
$row = current($campusAssignArray);
$campus_ids_list[$idx++] = $row['campus_id'];
next($campusAssignArray);
// keep the first record (most recent assign_id)
foreach (array_keys($campusAssignArray) as $m) {
$record = current($campusAssignArray);
$assignID = key($campusAssignArray);
// echo "REMOVE person-campus entry for person_id = ".$savedPersonID." using key = ".key($campusAssignArray);
if (isset($assignID) && $assignID != '') {
// remove entries having a campus_id already stored for the active person record
if (in_array($record['campus_id'], $campus_ids_list)) {
$assignUpdater = new RowManager_AssignmentsManager($assignID);
$assignUpdater->deleteEntry();
$reportDataDump .= 'Deleting redundant campus assignment record having campus ID ' . $record['campus_id'] . $BR . $BR;
} else {
$campus_ids_list[$idx++] = $record['campus_id'];
}
}
next($campusAssignArray);
}
}
// Step 2) Update the campus assignment records having the non-active person ids for this person
$campus_assign_manager2 = new RowManager_AssignmentsManager();
$campus_assign_manager2->addSearchCondition('person_id in (' . $person_ids_list . ')');
$campus_assign_manager2->setSortOrder('person_id');
$campus_assign_manager2->setAscDesc('DESC');
// sort by descending person IDs
// echo "candidate person ids = ".$person_ids_list."<br>";
$campusAssignData2 = $campus_assign_manager2->getListIterator();
$campus_assign_array2 = $campusAssignData2->getDataList();
// echo "<br>Contact data for ALL person_ids: <pre>".print_r($emerg_info_array2,true)."</pre><br>";
$campusIDs = array();
$idx = 0;
reset($campus_assign_array2);
foreach (array_keys($campus_assign_array2) as $l) {
$record = current($campus_assign_array2);
$personID = $record['person_id'];
if ($personID != $savedPersonID) {
// echo "FOUND person ".$personID;
$assignment_id = $record['assignment_id'];
$campus_id = $record['campus_id'];
$personAssignmentUpdater = new RowManager_AssignmentsManager($assignment_id);
// $personEmergUpdater->setPersonEmergID($emerg_id);
$person_id = $record['person_id'];
if (count($campusAssignArray) < 1) {
$record['person_id'] = $savedPersonID;
// require this to actually change person ID
// only create a new record with active person id if the campus ID not associated with the person yet
if (!in_array($campus_id, $campusIDs)) {
// update the person ID for an campus assignment record (in database)
$updateValues = array();
$updateValues['person_id'] = $savedPersonID;
$personAssignmentUpdater->loadFromArray($updateValues);
$personAssignmentUpdater->updateDBTable();
$reportDataDump .= 'No record found for person ID ' . $savedPersonID . ' (with campus ID ' . $campus_id . '),<br>';
$reportDataDump .= 'updating person ID for person ID ' . $person_id . $BR . $BR;
$campusIDs[$idx++] = $campus_id;
} else {
// echo "<br>Delete op #1.";
$personAssignmentUpdater->deleteEntry();
$reportDataDump .= 'Deleting record for alternative person ID ' . $person_id . $BR . $BR;
}
} else {
// echo "<br>TO BE DELETED FROM cim_hrdb_emerg: person_id = ".$person_id.", campus_id = ".$campus_id."<br>";
$personAssignmentUpdater->deleteEntry();
$reportDataDump .= 'Deleting record for alternative person ID ' . $person_id . $BR . $BR;
}
}
next($campus_assign_array2);
}
/*** Update the Registrations table (cim_reg_registration) **/
/** NOTE: Currenlty only use step 2, which simply replace associated person IDs with active person ID **/
// Step 1) Find the information stored for the active person_id
// $regRecordsArray = array();
// $idx = 0;
//
// $registration_manager = new RowManager_RegistrationManager();
// $registration_manager->setPersonID($savedPersonID);
// $registration_manager->setSortOrder( 'registration_id' );
// $registration_manager->setAscDesc( 'DESC' ); // sort by descending registration IDs
//
// // echo "<BR>".$savedPersonID.",";
// $registrationData = $registration_manager->getListIterator();
// $regs_array = $registrationData->getDataList();
// reset($regs_array);
// foreach(array_keys($regs_array) as $id)
// {
// $record = current($regs_array);
//
// $reg_id = $record['registration_id'];
// // $registration_info = array();
//
// // $fields = page_PersonRecordCleanUp::REGISTRATION_RECORD_FIELDS;
// // $fieldsArray = explode(",",$fields);
// //
// // // store the campus assignment values in an array
// // reset($fieldsArray);
// // foreach(array_keys($fieldsArray) as $k)
// // {
// // $fieldName = current($fieldsArray);
// //
// // $registration_info[$fieldName] = $record[$fieldName];
// //
// // next($fieldsArray);
// // }
//
// // store array of record values in array with assign_id as key
// // $regRecordsArray[$reg_id] = $registration_info;
// $regRecordsArray[$idx++] = $reg_id;
//
// next($regs_array);
// }
//
// // TEST CONDITION
// if (count($regs_array) > 0)
// {
// echo "<br>Registration ids for active person_id ".$savedPersonID.": <pre>".print_r($regRecordsArray,true)."</pre><br>";
// }
// TODO??: convert the code below to delete registration records that appear under same person_id (obviously with same event_id)
// if (count($regRecordsArray) > 1) // remove ONLY records with redundant person-campus pairs
// {
// $campus_ids_list = array();
// $idx = 0;
// reset($campusAssignArray);
// $row = current($campusAssignArray);
// $campus_ids_list[$idx++] = $row['campus_id'];
// next($campusAssignArray); // keep the first record (most recent emerg_id)
//
// foreach(array_keys($campusAssignArray) as $m)
// {
// $record = current($campusAssignArray);
//
// $assignID = key($campusAssignArray);
//
// // echo "REMOVE person-campus entry for person_id = ".$savedPersonID." using key = ".key($campusAssignArray);
// if ((isset($assignID))&&($assignID != ''))
// {
// // remove entries having a campus_id already stored for the active person record
// if (in_array($record['campus_id'], $campus_ids_list))
// {
// $assignUpdater = new RowManager_AssignmentsManager($assignID);
// $assignUpdater->deleteEntry();
// }
// else // store campus_id so as to remove any other records with this campus_id
// {
// $campus_ids_list[$idx++] = $record['campus_id'];
// }
// }
//
// next($campusAssignArray);
// }
//
// }
$reportDataDump .= 'Changes made to <b>cim_reg_registration table</b>: ' . $BR;
// Step 2) Update the registration records having the non-active person ids for this person (TODO: work from here)
$registration_manager2 = new RowManager_RegistrationManager();
$registration_manager2->addSearchCondition('person_id in (' . $person_ids_list . ')');
$registration_manager2->setSortOrder('person_id');
$registration_manager2->setAscDesc('DESC');
// sort by descending person IDs
// echo "candidate person ids = ".$person_ids_list."<br>";
$registrationData2 = $registration_manager2->getListIterator();
$registration_array2 = $registrationData2->getDataList();
// echo "<br>Contact data for ALL person_ids: <pre>".print_r($emerg_info_array2,true)."</pre><br>";
// $eventIDs = array();
// $idx = 0;
reset($registration_array2);
foreach (array_keys($registration_array2) as $key) {
$record = current($registration_array2);
$personID = $record['person_id'];
if ($personID != $savedPersonID) {
// echo "FOUND person ".$personID;
$registration_id = $record['registration_id'];
// $event_id = $record['event_id'];
$regRecordUpdater = new RowManager_RegistrationManager($registration_id);
// $personEmergUpdater->setPersonEmergID($emerg_id);
// if (count($regRecordsArray) < 1) // if active person ID doesn't have record yet, then update older record with active person ID
// {
// $record['person_id'] = $savedPersonID; // require this to actually change person ID
// // only create a new record with active person id if the event_id not associated with the person yet
// if (!in_array($event_id, $eventIDs))
// {
// update the person ID for an campus assignment record (in database)
$updateValues = array();
$updateValues['person_id'] = $savedPersonID;
$regRecordUpdater->loadFromArray($updateValues);
$regRecordUpdater->updateDBTable();
$reportDataDump .= 'Found registration record for alternative ID of person ID ' . $savedPersonID . ',' . $BR;
$reportDataDump .= 'updating person ID for person ID ' . $personID . $BR . $BR;
// $eventIDs[$idx++] = $event_id;
// }
// else
// {
// echo "<br>Delete op #1.";
// $regRecordUpdater->deleteEntry();
// }
// }
// else
// {
// echo "<br>TO BE DELETED FROM cim_reg_registration: person_id = ".$personID.", event_id = ".$event_id."<br>";
// $regRecordUpdater->deleteEntry();
// }
}
next($registration_array2);
}
/*** Update the Staff table (cim_hrdb_staff) **/
// Step 1) Find the information stored for the active person_id
$staff_manager = new RowManager_StaffManager();
$staff_manager->setPersonID($savedPersonID);
$staff_manager->setSortOrder('staff_id');
$staff_manager->setAscDesc('DESC');
// sort by descending assignment IDs
// echo "<BR>".$savedPersonID.",";
$staffData = $staff_manager->getListIterator();
$staff_array = $staffData->getDataList();
// reset($staff_array);
// foreach(array_keys($staff_array) as $id)
// {
// $record = current($staff_array);
//
// $staff_id = $record['staff_id'];
// $staffRecordsArray[$idx++] = $staff_id;
//
// next($staff_array);
// }
// TEST CONDITION
// if (count($staff_array) > 0)
// {
// echo "<br>Staff info for active person_id ".$savedPersonID.": <pre>".print_r($staff_array,true)."</pre><br>";
// }
$reportDataDump .= 'Changes made to <b>cim_hrdb_staff table</b>: ' . $BR;
// Step 2) Remove all but one of the staff records
if (count($staff_array) > 1) {
reset($staff_array);
next($staff_array);
// keep the first record (most recent staff_id for active person)
$reportDataDump .= 'Saving the first staff record associated with person ID ' . $savedPersonID . $BR . $BR;
// echo 'staff array = <pre>'.print_r($staff_array,true).'</pre>';
foreach (array_keys($staff_array) as $m) {
$record = current($staff_array);
$staffID = key($staff_array);
// remove redundant entry
$staffUpdater = new RowManager_StaffManager($staffID);
$staffUpdater->deleteEntry();
$reportDataDump .= 'Deleting redundant staff record having staff ID ' . $staffID . $BR . $BR;
$id = next($staff_array);
// staff ID
if ($id === FALSE) {
break;
// no valid data found so break out of the loop
}
}
}
// Step 3) Delete the staff records having the non-active person ids for this person
$staff_manager2 = new RowManager_StaffManager();
$staff_manager2->addSearchCondition('person_id in (' . $person_ids_list . ')');
$staff_manager2->setSortOrder('person_id');
$staff_manager2->setAscDesc('DESC');
// sort by descending person IDs
$staffData2 = $staff_manager2->getListIterator();
$staff_array2 = $staffData2->getDataList();
$toUpdate = false;
if (count($staff_array) < 1) {
$toUpdate = true;
}
reset($staff_array2);
foreach (array_keys($staff_array2) as $l) {
$record = current($staff_array2);
$personID = $record['person_id'];
if ($personID != $savedPersonID) {
$staff_id = $record['staff_id'];
$staffUpdater = new RowManager_StaffManager($staff_id);
if ($toUpdate == true) {
// $record['person_id'] = $savedPersonID; // require this to actually change person ID
// update the person ID for a staff record (in database)
$updateValues = array();
$updateValues['person_id'] = $savedPersonID;
$staffUpdater->loadFromArray($updateValues);
$staffUpdater->updateDBTable();
$toUpdate = false;
$reportDataDump .= 'No record found for person ID ' . $savedPersonID . ', updating person ID for person ID ' . $personID . $BR . $BR;
} else {
// echo "<br>TO BE DELETED FROM cim_hrdb_staff: person_id = ".$person_id.", staff_id = ".$staff_id."<br>";
$staffUpdater->deleteEntry();
$reportDataDump .= 'Deleting record for alternative person ID ' . $personID . $BR . $BR;
}
}
next($staff_array2);
}
/***** Remove redundant sub-group associations, otherwise rename person-id to active person-id ******************/
// Update the Person-DG table (sch_person_sub_group): still requires clean up
// Step 1) Find the information stored for the active person_id
$dg_campus_array = array();
$person_dg_manager = new RowManager_PersonDGManager();
$person_dg_manager->setPersonID($savedPersonID);
$person_dg_manager->setSortOrder('person_sub_group_id');
$person_dg_manager->setAscDesc('DESC');
// sort by descending person_sub_group_IDs
$personDGData = $person_dg_manager->getListIterator();
$personDGArray = $personDGData->getDataList();
reset($personDGArray);
foreach (array_keys($personDGArray) as $l) {
$record = current($personDGArray);
$dg_id = $record['sub_group_id'];
$campus_id = $record['organization_id'];
$dg_campus_array[$dg_id] = $campus_id;
next($personDGArray);
}
//
// if (count($dg_campus_array) > 0)
// {
// echo "<br>DG for active person_id ".$savedPersonID.": <pre>".print_r($personDGArray,true)."</pre><br>";
// // echo "<br>DG-Campus for active person_id ".$savedPersonID.": <pre>".print_r($dg_campus_array,true)."</pre><br>";
// }
$reportDataDump .= 'Changes made to <b>sch_person_sub_group table</b>: ' . $BR;
// Step 2) Update the records having the non-active person ids for this person
$person_dg_manager2 = new RowManager_PersonDGManager();
$person_dg_manager2->addSearchCondition('person_id in (' . $person_ids_list . ')');
$person_dg_manager2->setSortOrder('person_id');
$person_dg_manager2->setAscDesc('DESC');
// sort by descending person IDs
$personDGData2 = $person_dg_manager2->getListIterator();
$personDGArray2 = $personDGData2->getDataList();
// If no record was found for the active person record - then set flag for updating
// $updated = true;
// if (count($personDGArray2) < 1)
// {
// $updated = false;
// }
// $j = 0;
// echo 'DG array results = <pre>'.print_r($personDGArray2,true).'</pre>';
// echo 'dg - campus array: <pre>'.print_r($dg_campus_array,true).'</pre>';
reset($personDGArray2);
foreach (array_keys($personDGArray2) as $l) {
$record = current($personDGArray2);
$personID = $record['person_id'];
if ($personID != $savedPersonID) {
$personSubGroupID = $record['person_sub_group_id'];
$personDGUpdater = new RowManager_PersonDGManager($personSubGroupID);
$dg_id = $record['sub_group_id'];
$campus_id = $record['organization_id'];
// echo 'dg-id, campus-id = '.$dg_id.', '.$campus_id.'<br>';
// check to see if identical information was already stored under active person_id
if (isset($dg_campus_array[$dg_id]) && $dg_campus_array[$dg_id] == $campus_id) {
$personDGUpdater->deleteEntry();
$reportDataDump .= 'Deleting record for alternative person ID ' . $personID . $BR;
$reportDataDump .= 'since it has information already stored for primary person ID ' . $savedPersonID . $BR . $BR;
// echo "<br>TO BE DELETED FROM sch_person_sub_group: person_id = ".$personID.", dg = ".$dg_id.", campus = ".$campus_id."<br>";
} else {
$updateValues = array();
$updateValues['person_id'] = $savedPersonID;
// just to make sure...
$updateValues['sub_group_id'] = $record['sub_group_id'];
$updateValues['organization_id'] = $record['organization_id'];
// echo "<br>update values from ".$personID.": <pre>".print_r($dg_campus_array,true)."</pre><br>";
// TODO: deal with case where two non-active person-ids contain identical info (currently both are saved with active person id)
// update the person ID for a person-DG record (in database)
$personDGUpdater->loadFromArray($updateValues);
$personDGUpdater->updateDBTable();
$reportDataDump .= 'Updating record for alternative person ID ' . $personID . $BR;
$reportDataDump .= 'since it has new information: setting person ID to be ' . $savedPersonID . $BR . $BR;
}
}
next($personDGArray2);
}
/*** Update the personal schedule table (sch_schedule) **/
// Step 1) Find the information stored for the active person_id
$schedule_array = array();
$schedule_manager = new RowManager_ScheduleManager();
$schedule_manager->setPersonID($savedPersonID);
$schedule_manager->setSortOrder('schedule_id');
$schedule_manager->setAscDesc('DESC');
// sort by descending schedule_IDs
$personScheduleData = $schedule_manager->getListIterator();
$personScheduleArray = $personScheduleData->getDataList();
reset($personScheduleArray);
$idx = 0;
foreach (array_keys($personScheduleArray) as $l) {
$record = current($personScheduleArray);
$schedule_block = $record['schedule_block'];
$schedule_array[$idx] = $schedule_block;
next($personScheduleArray);
$idx++;
}
// echo 'active person schedule = <pre>'.print_r($personScheduleArray,true).'</pre>';
// echo 'person blocks array = <pre>'.print_r($schedule_array,true).'</pre>';
$reportDataDump .= 'Changes made to <b>sch_schedule table</b>: ' . $BR;
// Step 2) Create new records for active person ID from data linked to the non-active person ids for this person
$schedules = new RowManager_ScheduleManager();
$schedule_manager2 = new MultiTableManager();
$schedule_manager2->addRowManager($schedules);
$schedule_manager2->addSearchCondition('person_id in (' . $person_ids_list . ')');
$schedule_manager2->addSortField('person_id', 'DESC');
// $schedule_manager2->setAscDesc( 'DESC' ); // sort by descending person ID
$personScheduleData2 = $schedule_manager2->getListIterator();
$personScheduleArray2 = $personScheduleData2->getDataList();
// echo 'other person-ids schedule array = <pre>'.print_r($personScheduleArray2,true).'</pre>';
$toUpdate = false;
if (count($schedule_array) < 1) {
$toUpdate = true;
// echo 'Staff update needed';
}
// echo 'schedule array = <pre>'.print_r($personScheduleArray2,true).'</pre>';
$updatePersonID = -1;
reset($personScheduleArray2);
foreach (array_keys($personScheduleArray2) as $l) {
$record = current($personScheduleArray2);
$personID = $record['person_id'];
if ($personID != $savedPersonID) {
$found_sch_block = $record['schedule_block'];
$schedule_id = $record['schedule_id'];
$personScheduleUpdater = new RowManager_ScheduleManager($schedule_id);
// $personScheduleUpdater->setPersonID($personID);
// $personScheduleUpdater->setScheduleBlock($found_sch_block);
// if the active person_id DOES NOT HAVE this schedule block, then update record with active person id
// if (!in_array($found_sch_block, $schedule_array)) // COMMENTED OUT BECAUSE WE DON'T WANT TO MERGE SCHEDULES
// {
// if the active person_id DOES NOT HAVE **ANY** schedule block, then update record with active person id
if ($toUpdate == true || $updatePersonID == $personID) {
$updateValues = array();
$updateValues['person_id'] = $savedPersonID;
// NEW VALUE
$updateValues['schedule_block'] = $found_sch_block;
// just to make sure...
// update the person ID for a person-DG record (in database)
$personScheduleUpdater->loadFromArray($updateValues);
$personScheduleUpdater->updateDBTable();
if ($toUpdate == true) {
$toUpdate = false;
$updatePersonID = $personID;
// set person ID whose schedule blocks to use for updating
$reportDataDump .= 'No schedule block found for person ID ' . $savedPersonID . ',' . $BR;
$reportDataDump .= 'updating using schedule blocks from person ID ' . $updatePersonID . $BR . $BR;
}
} else {
// TODO: enable this code at mid-April 2008
// $personScheduleUpdater->deleteEntry();
// $reportDataDump .= 'Deleting record for alternative person ID '.$personID.$BR.$BR;
// TODO: deal with case where two non-active person-ids contain identical info
// (currently both are saved with active person id)
}
}
next($personScheduleArray2);
}
/*** Remove all person records other than the active person ID (most often the one used in most-recent login) ***/
$personIDs = explode(',', $person_ids_list);
foreach (array_values($personIDs) as $personID) {
if ($personID != $savedPersonID) {
$personUpdater = new RowManager_PersonManager($personID);
$personUpdater->deleteEntry();
$reportDataDump .= 'Deleting redundant <b>cim_hrdb_person</b> record having person ID ' . $personID . $BR;
}
next($personIDs);
}
}
// end if (isset($indivDataArray))
$reportDataDump = substr($reportDataDump, 0, -4);
// remove the last <BR>
$reportDataDump .= $HR;
next($personDataArray);
}
$this->template->set('reportDataDump', $reportDataDump);
// store the Row Manager's XML Node Name
// $this->template->set( 'rowManagerXMLNodeName', RowManager_ReceiptManager::XML_NODE_NAME );
// store the primary key field name for the data being displayed
// $this->template->set( 'primaryKeyFieldName', 'ccreceipt_sequencenum');
/*
* Set up any additional data transfer to the Template here...
*/
$templateName = 'page_PersonRecordCleanUp.tpl.php';
// if you are creating a custom template for this page then
// replace $templateName with the following:
//$templateName = 'page_DisplayCCtransactionReceipt.php';
// send CC transaction confirmation e-mail (but first remove links)
// $link_regex = '{<a.*?</a>}';
// $message_body = $this->template->fetch( $templateName );
// $message_body = preg_replace( $link_regex, '', $message_body);
//
// if (!defined('IGNORE_EMAILS'))
// {
// $this->sendCCTransactionEmail($message_body);
// }
return $this->template->fetch($templateName);
}
/**
* 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, $sortBy, $month_id = '')
{
parent::__construct(page_ViewScheduleCalendar::DISPLAY_FIELDS);
$this->pathModuleRoot = $pathModuleRoot;
$this->viewer = $viewer;
if ($month_id == '') {
$month_id = date('n');
}
$this->month_id = $month_id;
$this->year_id = date('Y');
$this->first_weekday = page_ViewScheduleCalendar::SUNDAY;
$this->monthValues = $this->getMonthValues();
//$this->yearValueList->getDropListArray();
// 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);
// Super-admin
if ($this->adminManager->hasSitePriv()) {
$dataAccessObject = new MultiTableManager();
$activities = new RowManager_StaffActivityManager();
$activityTypes = new RowManager_ActivityTypeManager();
$person_info = new RowManager_PersonManager();
$dataAccessObject->addRowManager($activities);
$dataAccessObject->addRowManager($activityTypes, new JoinPair($activityTypes->getJoinOnActivityTypeID(), $activities->getJoinOnActivityTypeID()));
$dataAccessObject->addRowManager($person_info, new JoinPair($person_info->getJoinOnPersonID(), $activities->getJoinOnPersonID()));
$dataAccessObject->setSortOrder($sortBy);
$this->listManager = $dataAccessObject->getListIterator();
} else {
if ($this->adminManager->isStaff($viewer->getID())) {
$director_id = $this->getStaffIDfromViewerID();
// $staffPersonManager = new MultiTableManager();
$staffManager = new RowManager_StaffDirectorManager();
$staffManager->setDirectorID($director_id);
// $staffInfoManager = new RowManager_StaffManager();
// $staffPersonManager->addRowManager($staffInfoManager);
// $staffPersonManager->addRowManager($staffManager, new JoinPair($staffManager->getJoinOnStaffID(),$staffInfoManager->getJoinOnStaffID()));
// $staffList = $staffPersonManager->getListIterator();
// $staffArray = $staffList->getDataList();
/* 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 .= $director_id;
//= substr( $directed_staff, 0, -1 );
} else {
$directed_staff = $director_id;
//page_ViewScheduleCalendar::NON_DIRECTOR;
}
// echo '<pre>'.print_r($staffArray,true).'</pre>';
// // Retrieve the list of staff supervised by current viewer
// $directed_staff = '';
// foreach (array_keys($staffArray) as $key)
// {
// $record = current($staffArray);
// $directed_staff .= $record['person_id'].',';
// next($staffArray);
// }
// $directed_staff = substr($directed_staff,0,-1);
// if ($directed_staff == '')
// {
// $directed_staff = page_FormApprovalListing::NO_SUPERVISEES; // don't match any person IDs
// }
// Filter activities by those staff persons found in the list of staff under the direction of the current viewer
$dataAccessObject = new MultiTableManager();
$schedules = new RowManager_StaffScheduleManager();
// $schedules->addSearchCondition('person_id in ('.$directed_staff.')');
$schedule_activities = new RowManager_ActivityScheduleManager();
$activities = new RowManager_StaffActivityManager();
$activityTypes = new RowManager_ActivityTypeManager();
$person_info = new RowManager_PersonManager();
$staff = new RowManager_StaffManager();
$dataAccessObject->addRowManager($activities);
$dataAccessObject->addRowManager($schedule_activities, new JoinPair($activities->getJoinOnActivityID(), $schedule_activities->getJoinOnActivityID()));
$dataAccessObject->addRowManager($schedules, new JoinPair($schedules->getJoinOnScheduleID(), $schedule_activities->getJoinOnScheduleID()));
$dataAccessObject->addRowManager($activityTypes, new JoinPair($activityTypes->getJoinOnActivityTypeID(), $activities->getJoinOnActivityTypeID()));
$dataAccessObject->addRowManager($person_info, new JoinPair($person_info->getJoinOnPersonID(), $activities->getJoinOnPersonID()));
$dataAccessObject->addRowManager($staff, new JoinPair($staff->getJoinOnPersonID(), $person_info->getJoinOnPersonID()));
$dataAccessObject->addSearchCondition('staff_id in (' . $directed_staff . ')');
$dataAccessObject->setSortOrder($sortBy);
$this->listManager = $dataAccessObject->getListIterator();
} else {
$dataAccessObject = new RowManager_StaffActivityManager(page_ViewScheduleCalendar::UNAUTHORIZED_DIRECTOR);
$this->listManager = $dataAccessObject->getListIterator();
}
}
$this->monthEvents = array();
// $eventsOfType = array(); // stores events/activities of a specific type
// $eventDetails = array(); // stores details for a specific person's event
$eventsArray = $this->listManager->getDataList();
reset($eventsArray);
if (count($eventsArray) > 0) {
// Search through found activities
foreach (array_keys($eventsArray) as $key) {
$record = current($eventsArray);
$activity_id = $record['staffactivity_id'];
$activity_desc = $record['activitytype_desc'];
$person_name = $record['person_fname'] . ' ' . $record['person_lname'];
$contact_phone = $record['staffactivity_contactPhone'];
$activity_type = $record['activitytype_abbr'];
// $eventDetails[$activity_id][0] = $person_name;
// $eventDetails[$activity_id][1] = $contact_phone;
//
// $eventsOfType[$activity_type] = $eventDetails;
$startdate_parts = explode('-', $record['staffactivity_startdate']);
$enddate_parts = explode('-', $record['staffactivity_enddate']);
// Store event information by weekday
for ($month_id = $startdate_parts[1]; $month_id <= $enddate_parts[1]; $month_id++) {
if ($this->month_id == $month_id) {
$start_day = $startdate_parts[2];
if (substr($start_day, 0, 1) == 0) {
$start_day = substr($start_day, 1);
}
$end_day = $enddate_parts[2];
if (substr($end_day, 0, 1) == 0) {
$end_day = substr($end_day, 1);
}
// Store the event data (name and contact #) for each valid day of the month
$init_day = page_ViewScheduleCalendar::FIRST_MONTH_DATE;
$last_day = page_ViewScheduleCalendar::MAX_MONTH_DATE;
if ($startdate_parts[1] == $enddate_parts[1]) {
$init_day = $start_day;
$last_day = $end_day;
} else {
if ($month_id == $startdate_parts[1]) {
$init_day = $start_day;
$last_day = page_ViewScheduleCalendar::MAX_MONTH_DATE;
} else {
if ($month_id == $enddate_parts[1]) {
$init_day = page_ViewScheduleCalendar::FIRST_MONTH_DATE;
$last_day = $end_day;
} else {
$init_day = page_ViewScheduleCalendar::FIRST_MONTH_DATE;
$last_day = page_ViewScheduleCalendar::MAX_MONTH_DATE;
}
}
}
// Use the init and last day values as set based on above conditions
for ($day_id = $init_day; $day_id <= $last_day; $day_id++) {
$this->monthEvents[$day_id][$activity_type][$activity_id][0] = $activity_desc;
$this->monthEvents[$day_id][$activity_type][$activity_id][1] = $person_name;
$this->monthEvents[$day_id][$activity_type][$activity_id][2] = $contact_phone;
//$this->monthEvents[$day_id] = $eventsOfType;
}
}
}
next($eventsArray);
}
}
/** TEST **/
// $values = $this->listManager->getDataList();
// echo 'values found = <pre>'.print_r($values,true).'</pre>';
/** END TEST **/
// 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_ViewScheduleCalendar::MULTILINGUAL_PAGE_KEY;
$this->labels->loadPageLabels($pageKey);
$this->labels->setSeriesKey(SITE_LABEL_SERIES_SITE);
$this->labels->loadPageLabels(SITE_LABEL_PAGE_FORM_LINKS);
}
private function generateRegistrantsDroplist()
{
// $content = $this->_controller->loadEditCampusRegistrations_OffflineRegBox();
//$content = $this->registrants_dropList->getHTML();
$people = new RowManager_PersonManager();
$access = new RowManager_AccessManager();
// ADDED Nov 21, 2007
$viewers = new RowManager_ViewerManager();
// ADDED Nov 21, 2007
$assignment = new RowManager_AssignmentsManager();
$assignment->setCampusID($this->campus_id);
$registrants = new MultiTableManager();
$registrants->addRowManager($people);
$registrants->addRowManager($assignment, new JoinPair($people->getJoinOnPersonID(), $assignment->getJoinOnPersonID()));
$registrants->addRowManager($access, new JoinPair($people->getJoinOnPersonID(), $access->getJoinOnPersonID()));
// ADDED Nov 21, 2007
$registrants->addRowManager($viewers, new JoinPair($access->getJoinOnViewerID(), $viewers->getJoinOnViewerID()));
// ADDED Nov 21, 2007
// get sub-query data for filtering out registrants that have already been registered for event
$regs = new RowManager_RegistrationManager();
$regs->setEventID($this->event_id);
// $regs->setPersonID($this->person_id);
$status = new RowManager_StatusManager();
$status->setStatusDesc(RowManager_StatusManager::REGISTERED);
$regData = new MultiTableManager();
$regData->addRowManager($regs);
$regData->addRowManager($status, new JoinPair($regs->getJoinOnStatus(), $status->getJoinOnStatusID()));
$regData->setFieldList('person_id');
$registered_SQL = $regData->createSQL();
// echo "<br>CREATED SQL 1 = ".$registered_SQL;
// actually creates the sub-query ensuring that registrants in drop-down list are NOT registered
$negateSubQuery = true;
$addSubQuery = true;
$registrants->constructSubQuery('person_id', $registered_SQL, $negateSubQuery, $addSubQuery);
$registrants->setSortOrder('person_lname');
$peopleManager = $registrants->getListIterator();
$registrantsArray = $peopleManager->getDataList();
// echo "<br>CREATED SQL 2 = ".$registrants->createSQL();
$registrant = array();
// NOTE: the drop-down list stealthily passes PERSON_ID to controller (see name="SV43")
$dropList = '<form name="Form" id="Form" method="post" action="' . $this->registrant_formAction . '">' . 'Select a registrant for offline registration, or choose "New Registrant" :<br><br>' . '<select name="' . modulecim_reg::PERSON_ID . '">' . '<option selected="selected" value="-1">New Registrant</option>';
// retrieve person first and last name from database array
reset($registrantsArray);
foreach (array_keys($registrantsArray) as $k) {
$personData = current($registrantsArray);
// $registrant['person_fname'] = $personData['person_fname'];
// $registrant['person_lname'] = $personData['person_lname'];
// add registrant names to drop-down list
// for ($i = 0; $i < $totalPeople; $i++)
// {
$dropList .= '<option value=' . $personData['person_id'] . '>' . $personData['person_lname'] . ', ' . $personData['person_fname'] . ' (' . $personData['viewer_userID'] . ')</option>';
// }
next($registrantsArray);
}
// $totalPeople = count($
$dropList .= '</select>' . ' <input name="REGISTER" type="submit" value="REGISTER" /></form>';
return $dropList;
}
/**
* 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, $sortBy, $staffscheduletype_id)
{
parent::__construct(page_FormApprovalListing::DISPLAY_FIELDS);
$this->pathModuleRoot = $pathModuleRoot;
$this->viewer = $viewer;
$this->formtype_id = $staffscheduletype_id;
$this->sortBy = $sortBy;
if ($this->sortBy == '') {
$this->sortBy = 'staffschedule_approved,person_lname,person_fname';
} else {
if ($this->sortBy == 'person_id') {
$this->sortBy = 'person_lname,person_fname';
}
}
// Now load the access Priviledge 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);
// Super-admin
if ($this->adminManager->hasSitePriv()) {
$dataAccessObject = new MultiTableManager();
$schedules = new RowManager_StaffScheduleManager();
$schedules->setFormID($this->formtype_id);
$persons = new RowManager_PersonManager();
$dataAccessObject->addRowManager($schedules);
$dataAccessObject->addRowManager($persons, new JoinPair($schedules->getJoinOnPersonID(), $persons->getJoinOnPersonID()));
$dataAccessObject->setSortOrder($this->sortBy);
// $this->listManager = new StaffScheduleList( $sortBy );
$this->listManager = $dataAccessObject->getListIterator();
} 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);
} else {
$directed_staff = page_FormApprovalListing::NO_SUPERVISEES;
}
// // Filter approval records by those staff persons found in the list of staff under the direction of the current viewer
$schedules = new RowManager_StaffScheduleManager();
$schedules->setFormID($this->formtype_id);
$person_info = new RowManager_PersonManager();
$staff = new RowManager_StaffManager();
$dataAccessObject = new MultiTableManager();
$dataAccessObject->addRowManager($staff);
$dataAccessObject->addRowManager($person_info, new JoinPair($staff->getJoinOnPersonID(), $person_info->getJoinOnPersonID()));
$dataAccessObject->addRowManager($schedules, new JoinPair($person_info->getJoinOnPersonID(), $schedules->getJoinOnPersonID()));
$dataAccessObject->addSearchCondition('staff_id in (' . $directed_staff . ')');
$dataAccessObject->setSortOrder($this->sortBy);
$this->listManager = $dataAccessObject->getListIterator();
} else {
$dataAccessObject = new MultiTableManager();
$schedules = new RowManager_StaffScheduleManager();
$schedules->setFormID(page_FormApprovalListing::UNAUTHORIZED_DIRECTOR);
$dataAccessObject->addRowManager($schedules);
$dataAccessObject->setSortOrder($this->sortBy);
// $this->listManager = new StaffScheduleList( $sortBy );
$this->listManager = $dataAccessObject->getListIterator();
}
}
// 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_FormApprovalListing::MULTILINGUAL_PAGE_KEY;
$this->labels->loadPageLabels($pageKey);
$this->labels->setSeriesKey(SITE_LABEL_SERIES_SITE);
$this->labels->loadPageLabels(SITE_LABEL_PAGE_FORM_LINKS);
}
protected function getFieldArray($reportID = '')
{
// $FALSE = 0;
$groupBy = 'cim_hrdb_fields.fields_id';
$dbFunction = 'COUNT';
$funcParam = 'person_id';
$fields = new RowManager_FormFieldManager();
// $fvalues = new RowManager_FieldValueManager();
$ftypes = new RowManager_FieldTypeManager();
// $custom_reports = new RowManager_CustomReportsManager(); //$reportID
$custom_fields = new RowManager_CustomFieldsManager();
//$reportID
if ($reportID != '') {
$custom_fields->setReportID($reportID);
}
$fieldvalues = new RowManager_FormFieldValueManager();
// "NEW" (in order to sort fields by # of values)
// echo "personID = ".$personID;
// if ($formID != '')
// {
// $fields->setFormID($formID);
// //$fvalues->setRegID($regID);
// }
$fieldInfo = new MultiTableManager();
$fieldInfo->addRowManager($fields);
// $fieldInfo->addRowManager($fvalues, new JoinPair($fvalues->getJoinOnFieldID(), $fields->getJoinOnFieldID()));
$fieldInfo->addRowManager($ftypes, new JoinPair($fields->getJoinOnFieldTypeID(), $ftypes->getJoinOnFieldTypeID()));
$fieldInfo->addRowManager($custom_fields, new JoinPair($custom_fields->getJoinOnFieldID(), $fields->getJoinOnFieldID()));
$fieldInfo->addRowManager($fieldvalues, new JoinPair($fieldvalues->getJoinOnFieldID(), $fields->getJoinOnFieldID()));
// use GROUP BY and $dbFunction = 'COUNT' to sort fields by # of values
if ($groupBy != '') {
$fieldInfo->setGroupBy($groupBy);
//'campus_desc');
}
if ($dbFunction != '') {
$fieldInfo->setFunctionCall($dbFunction, $funcParam);
}
$fieldInfo->setSortOrder('COUNT(person_id) DESC');
// $fieldInfo->setSortOrder('fields_priority');
// echo $fieldInfo->createSQL();
$valuesIterator = $fieldInfo->getListIterator();
$valuesArray = $valuesIterator->getDataList();
// echo "values:<br><pre>".print_r($valuesArray,true)."</pre>";
// map the fields_id of each field values row to the label of that particular form field
// $idx = 0;
// reset($valuesArray);
// foreach(array_keys($valuesArray) as $k)
// {
// $record = current($valuesArray);
//
// // store mapping associating form field label with fields_id
// $this->formFieldToFieldIDmapper['form_field'.$idx] = $record['fields_id'];
//
// next($valuesArray);
// $idx++;
// }
// echo "field id values:<br><pre>".print_r($this->formFieldToFieldIDmapper,true)."</pre>";
$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');
return $valuesArray;
}
/**
* 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, $sortBy, $campus_id = "")
{
parent::__construct(page_PeoplebyCampuses::DISPLAY_FIELDS);
$this->pathModuleRoot = $pathModuleRoot;
$this->viewer = $viewer;
$this->campus_id = $campus_id;
// echo 'campusID['.$this->campus_id.']<br/>';
// $this->managerInit = $managerInit;
// Now load the access Priviledge 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);
if ($this->adminManager->hasSitePriv()) {
$campusManager = new RowManager_CampusManager();
$campusManager->setSortOrder('campus_desc');
$this->campusList = $campusManager->getListIterator();
$this->accessibleCampuses = $this->campusList->getDropListArray();
} else {
if ($this->adminManager->hasCampusPriv()) {
$campusAdminManager = new RowManager_CampusAdminManager();
$adminID = $this->adminManager->getID();
// echo 'adminID['.$adminID.']<br/>';
$campusAdminManager->setAdminID($adminID);
$multiTableManager = new MultiTableManager();
$multiTableManager->addRowManager($campusAdminManager);
$multiTableManager->setSortOrder('campus_desc');
$campusManager = new RowManager_CampusManager();
$multiTableManager->addRowManager($campusManager, new JoinPair($campusManager->getJoinOnCampusID(), $campusAdminManager->getJoinOnCampusID()));
$this->campusList = $multiTableManager->getListIterator();
$this->accessibleCampuses = array();
$this->campusList->setFirst();
while ($this->campusList->moveNext()) {
$campusAdminObject = $this->campusList->getCurrent(new RowManager_CampusAdminManager());
$campusObject = $this->campusList->getCurrent(new RowManager_CampusManager());
$this->accessibleCampuses[$campusAdminObject->getCampusID()] = $campusObject->getLabel();
}
} else {
if ($this->adminManager->isStaff($viewer->getID())) {
$staffManager = new RowManager_StaffManager();
$staffManager->setPersonID($personID);
$multiTableManager = new MultiTableManager();
$multiTableManager->addRowManager($staffManager);
$multiTableManager->setSortOrder('campus_desc');
$assignmentManager = new RowManager_AssignmentsManager();
$multiTableManager->addRowManager($assignmentManager, new JoinPair($assignmentManager->getJoinOnPersonID(), $staffManager->getJoinOnPersonID()));
$campusManager = new RowManager_CampusManager();
$multiTableManager->addRowManager($campusManager, new JoinPair($campusManager->getJoinOnCampusID(), $assignmentManager->getJoinOnCampusID()));
$this->campusList = $multiTableManager->getListIterator();
$this->accessibleCampuses = array();
$this->campusList->setFirst();
while ($this->campusList->moveNext()) {
$campusAssignObject = $this->campusList->getCurrent(new RowManager_AssignmentsManager());
$campusObject = $this->campusList->getCurrent(new RowManager_CampusManager());
$this->accessibleCampuses[$campusAssignObject->getCampusID()] = $campusObject->getLabel();
}
} else {
$campusManager = new RowManager_CampusManager();
$campusManager->setSortOrder('campus_desc');
$this->campusList = $campusManager->getListIterator();
$this->accessibleCampuses = $this->campusList->getDropListArray();
}
}
}
// modify the campus_id if necessary
if ($this->campus_id == page_PeoplebyCampuses::DISPLAY_ALL_ID) {
// setting the campus id to blank will get entries from all the campuses
$this->campus_id = '';
} else {
if ($this->campus_id == '') {
// no campus has been specified
// choose a default campus if none specified
// echo 'No campus specified<br/>';
// get the first element from the accessible list
foreach ($this->accessibleCampuses as $key => $value) {
$this->campus_id = $key;
break;
}
// assert campus_id should now be something
if ($this->campus_id == '') {
die("ERROR - campusID not set to anything<br/>");
}
}
}
$dataAccessObject = new MultiTableManager();
$assignmentsManager = new RowManager_AssignmentsManager();
$assignmentsManager->setCampusID($this->campus_id);
$dataAccessObject->addRowManager($assignmentsManager);
$personManager = new RowManager_PersonManager();
$joinPair = new JoinPair($personManager->getJoinOnPersonID(), $assignmentsManager->getJoinOnPersonID());
$dataAccessObject->addRowManager($personManager, $joinPair);
$this->accessManager = new RowManager_AccessManager();
$joinPair2 = new JoinPair($personManager->getJoinOnPersonID(), $this->accessManager->getJoinOnPersonID(), JOIN_TYPE_LEFT);
$dataAccessObject->addRowManager($this->accessManager, $joinPair2);
$this->viewerManager = new RowManager_UserManager();
$joinPair3 = new JoinPair($this->accessManager->getJoinOnViewerID(), $this->viewerManager->getJoinOnViewerID(), JOIN_TYPE_LEFT);
$dataAccessObject->addRowManager($this->viewerManager, $joinPair3);
if ($sortBy == '') {
$sortBy = 'person_lname';
}
$dataAccessObject->setSortOrder($sortBy);
$this->listManager = $dataAccessObject->getListIterator();
// 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_PeoplebyCampuses::MULTILINGUAL_PAGE_KEY;
$this->labels->loadPageLabels($pageKey);
$this->labels->setSeriesKey(SITE_LABEL_SERIES_SITE);
$this->labels->loadPageLabels(SITE_LABEL_PAGE_FORM_LINKS);
}
protected function getFieldValuesArray($regID = '', $personID = '', $eventID = '')
{
$FALSE = 0;
$fields = new RowManager_FieldManager();
$fvalues = new RowManager_FieldValueManager();
$ftypes = new RowManager_FieldTypeManager();
// echo "personID = ".$personID;
// echo "eventID = ".$eventID;
if ($regID != '') {
//$fields->setEventID($eventID);
$fvalues->setRegID($regID);
} else {
if ($eventID != '' && $personID != '') {
$registrations = new RowManager_RegistrationManager();
// $registrations->setRegID($regID);
$person = new RowManager_PersonManager();
$person->setPersonID($personID);
$event = new RowManager_EventManager();
$event->setEventID($eventID);
$personReg = new MultiTableManager();
$personReg->addRowManager($registrations);
$personReg->addRowManager($person, new JoinPair($registrations->getJoinOnPersonID(), $person->getJoinOnPersonID()));
$personReg->addRowManager($event, new JoinPair($registrations->getJoinOnEventID(), $event->getJoinOnEventID()));
$valIterator = $personReg->getListIterator();
$valArray = $valIterator->getDataList();
// go through results and store field types
reset($valArray);
foreach (array_keys($valArray) as $k) {
$regValue = current($valArray);
$regID = $regValue['registration_id'];
//NOTE: assumes only 1 registration per person per event
next($valArray);
}
// $fields->setEventID($eventID);
$fvalues->setRegID($regID);
}
}
// $fvalues->setSortByFieldID();
$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);
}
$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 = 0;
/** Go through all event fields and map each to existing field value, otherwise create new field value record **/
$fieldsArray = array_values($this->formFieldToFieldIDmapper);
// 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['registration_id'] = $regID;
$fieldvalues_manager = new RowManager_FieldValueManager();
// store values in table manager object.
$fieldvalues_manager->loadFromArray($updateValues);
// now update the DB with the values
if (!$fieldvalues_manager->isLoaded()) {
$fieldvalues_manager->createNewEntry(true);
$form_value_id = $fieldvalues_manager->getID();
}
}
$fieldValues['form_field' . $idx] = $form_value;
// store mapping associating form field label with fieldvalues_id
$this->formFieldToValueIDmapper['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;
}
/**
* function __construct
* <pre>
* Initialize the object.
* </pre>
* @param $pathModuleRoot [STRING] The path to the module's root dir.
* @param $viewer [OBJECT] The viewer object.
* @return [void]
*/
function __construct($pathModuleRoot, $viewer, $eventID, $recalcStatus = FinancialTools::RECALC_NOTNEEDED, $campus_link = '')
{
parent::__construct();
// initialzie the object values
$this->pathModuleRoot = $pathModuleRoot;
$this->viewer = $viewer;
$this->event_id = $eventID;
$this->recalcStatus = $recalcStatus;
// get privileges for the current viewer
$privManager = new PrivilegeManager($this->viewer->getID());
$regSummaries = new RegSummaryTools();
// $is_campus_admin = false;
if ($privManager->isBasicAdmin($this->event_id) == true) {
/** Set the summary data headings (used only for generating PDF) **/
$this->summary_headings = array();
$this->summary_headings[0] = 'Campus';
$this->summary_headings[1] = 'Admin';
$this->summary_headings[2] = 'Males';
$this->summary_headings[3] = 'Females';
$this->summary_headings[4] = 'Total';
$this->summary_headings[5] = 'Cancellations';
$this->summary_headings[6] = 'Completed';
$this->summary_headings[7] = 'Incomplete';
/** RETRIEVE CAMPUS REGISTRATION SUMMARY DATA ***/
//TODO?: put some/all of this into a helper method
// initialized template arrays
$campusLevelLinks = array();
$this->summaryTotals = array();
$this->summaryTotals['label'] = '';
$this->summaryTotals['blank'] = '';
// 'Registrations' link has no need for a total...
$this->summaryTotals['numMales'] = 0;
$this->summaryTotals['numFemales'] = 0;
$this->summaryTotals['campusTotal'] = 0;
$this->summaryTotals['cancellations'] = 0;
$this->summaryTotals['completes'] = 0;
$this->summaryTotals['incompletes'] = 0;
/* Get all campuses (affiliated with the admin's country) */
// $campuses = new RowManager_CampusManager();
// $campuses->setSortOrder('campus_desc');
// $campusList = $campuses->getListIterator();
// $campusArray = $campusList->getDataList();
$country_campuses = new MultiTableManager();
$events = new RowManager_EventManager();
$events->setEventID($this->event_id);
$campuses = new RowManager_CampusManager();
$regions = new RowManager_RegionManager();
$countries = new RowManager_CountryManager();
$country_campuses->addRowManager($campuses);
$country_campuses->addRowManager($regions, new JoinPair($regions->getJoinOnRegionID(), $campuses->getJoinOnRegionID()));
$country_campuses->addRowManager($countries, new JoinPair($countries->getJoinOnCountryID(), $regions->getJoinOnCountryID()));
$country_campuses->addRowManager($events, new JoinPair($events->getJoinOnCountryID(), $countries->getJoinOnCountryID()));
$country_campuses->setSortOrder('campus_desc');
$countryList = $country_campuses->getListIterator();
$campusArray = $countryList->getDataList();
reset($campusArray);
// echo 'campus array = <pre>'.print_r($campusArray,true).'</pre>';
/** JANUARY 25, 2008 (HSMIT) added $campusList to all getCampusRegistrations() calls below
to match registration campuses with event-affliated country's campus list
ALSO: had to add somewhat redundant pre-processing to get campus list **/
$campusList = '';
foreach (array_keys($campusArray) as $key) {
$record = current($campusArray);
$campusList .= $record['campus_id'] . ',';
// populate CSV for registrations filter
next($campusArray);
}
$campusList = substr($campusList, 0, -1);
reset($campusArray);
// retrieve cancellations (for current event)
$results_cancelled = array();
$results_cancelled = $regSummaries->getCampusRegistrations($this->event_id, '', true, $campusList);
// retrieve total registrations and total females registered (for current event)
$results = array();
$results_female = array();
$results = $regSummaries->getCampusRegistrations($this->event_id, '', false, $campusList);
$results_female = $regSummaries->getCampusRegistrations($this->event_id, 'female', false, $campusList);
// retrieve total complete registrations and total incomplete registrations (for current event)
$results_complete = array();
$results_incomplete = array();
$results_complete = $regSummaries->getCampusRegistrations($this->event_id, '', false, $campusList, '', RowManager_RegistrationManager::STATUS_REGISTERED);
$results_incomplete = $regSummaries->getCampusRegistrations($this->event_id, '', false, $campusList, '', RowManager_RegistrationManager::STATUS_INCOMPLETE);
// $results = array_merge( $results_male, $results_female );
reset($results);
// reset($results_male);
// reset($results_female);
// go through total registrations in parallel with other results
foreach (array_keys($campusArray) as $k) {
$total = current($results);
$regCampusID = key($results);
$campusID = key($campusArray);
//key($results);
// retrieve campus name given the campus ID
$campus = new RowManager_CampusManager($campusID);
$campusName = $campus->getDesc();
// process registration total if it matches the current campus ID
if ($regCampusID == $campusID) {
// set total valid non-cancelled registrations for current campus (and event)
if (isset($results_cancelled[$campusID])) {
$cancelled = $results_cancelled[$campusID];
// $total = $total - $cancelled;
} else {
$cancelled = 0;
}
// set total females registered for current campus (and event)
if (isset($results_female[$campusID])) {
$females = $results_female[$campusID];
} else {
$females = 0;
}
// set total complete registrations for current campus (and event)
if (isset($results_complete[$campusID])) {
$completes = $results_complete[$campusID];
} else {
$completes = 0;
}
// set total incomplete registrations for current campus (and event)
if (isset($results_incomplete[$campusID])) {
$incompletes = $results_incomplete[$campusID];
} else {
$incompletes = 0;
}
// $females = current($results_female);
// $males = $results_male[$campusName];
// set total registered males
$males = $total - $females;
//current($results_male);//
// echo $campusName.': '.$total.' : '.$males.' : '.$females.'<br>';
// echo 'cancelled : '.$cancelled.'<br>';
// set registration summary values for current campus
$aCampus = array();
$aCampus['campus_desc'] = $campusName;
$aCampus['regLink'] = '#';
//$this->linkValues[ 'CampusLink' ].$campusID;//$this->event_id."_".$campusID;
$aCampus['numMales'] = $males;
$aCampus['numFemales'] = $females;
$aCampus['campusTotal'] = $total;
$aCampus['cancellations'] = $cancelled;
$aCampus['completes'] = $completes;
$aCampus['incompletes'] = $incompletes;
// $summaryTotals['numMales'] += $males;
// $summaryTotals['numFemales'] += $females;
// $summaryTotals['campusTotal'] += $total;
// $summaryTotals['cancellations'] += $cancelled;
next($results);
// increment array-pointer for registration totals array
} else {
// set registration summary values for current campus
$aCampus = array();
$aCampus['campus_desc'] = $campusName;
$aCampus['regLink'] = '#';
//$this->linkValues[ 'CampusLink' ].$campusID;//$this->event_id."_".$campusID;
$aCampus['numMales'] = 0;
$aCampus['numFemales'] = 0;
$aCampus['campusTotal'] = 0;
$aCampus['cancellations'] = 0;
$aCampus['completes'] = 0;
$aCampus['incompletes'] = 0;
}
// $editLink = $this->getCallBack( modulecim_reg::PAGE_ADMINEVENTHOME, $this->sortBy, $parameters );
// $editLink .= "&". modulecim_reg::REG_ID . "=";
// CampusLink
if ($privManager->isCampusAdmin($this->event_id, $campusID) == true) {
$aCampus['regLink'] = $campus_link . $campusID;
// $this->linkValues[ 'CampusLink' ].$campusID;
}
// <START> USED TO BE INSIDE CAMPUS ADMIN PRIV. CHECK
// BUT NOW ALL CAMPUS ADMINS CAN SEE SUMMARY DATA... ONLY REGISTRATION LINKS NOT SHOWN FOR INVALID CAMPUSES
// store campus summary info in array indexed by campus name
$campusLevelLinks[$campusName] = $aCampus;
// if ($is_campus_admin == false) {
// $this->template->set('isCampusAdmin', true);
// $is_campus_admin = true;
// }
// <END>
next($campusArray);
// next($results_female);
// next($results_male);
}
$this->summary_data = $campusLevelLinks;
/*** END CAMPUS REGISTRATION SUMMARY DATA RETRIEVAL ***/
/**** SET TOTAL *UNIQUE* REGISTRATIONS *******/
$totalRegs = array();
$totalRegs = $regSummaries->getUniqueRegistrations($this->event_id);
// echo "Total unique regs: ".count($totalRegs);
$femaleRegs = array();
$gender = 'female';
$femaleRegs = $regSummaries->getUniqueRegistrations($this->event_id, $gender);
// echo "<br>Total male regs: ".(count($totalRegs)-count($femaleRegs));
// echo "<br>Total female regs: ".count($femaleRegs);
$cancelledRegs = array();
$gender = '';
$areCancelled = true;
$cancelledRegs = $regSummaries->getUniqueRegistrations($this->event_id, $gender, $areCancelled);
// echo "<br>Total cancelled regs: ".count($cancelledRegs);
$completeRegs = array();
$gender = '';
$areCancelled = false;
$status = RowManager_RegistrationManager::STATUS_REGISTERED;
$completeRegs = $regSummaries->getUniqueRegistrations($this->event_id, $gender, $areCancelled, $status);
$incompleteRegs = array();
$gender = '';
$areCancelled = false;
$status = RowManager_RegistrationManager::STATUS_INCOMPLETE;
$incompleteRegs = $regSummaries->getUniqueRegistrations($this->event_id, $gender, $areCancelled, $status);
$this->summaryTotals['label'] = 'Total (Unique) Registrations:';
$this->summaryTotals['blank'] = '';
// 'Registrations' link has no need for a total...
$this->summaryTotals['numMales'] = count($totalRegs) - count($femaleRegs);
$this->summaryTotals['numFemales'] = count($femaleRegs);
$this->summaryTotals['campusTotal'] = count($totalRegs);
$this->summaryTotals['cancellations'] = count($cancelledRegs);
$this->summaryTotals['completes'] = count($completeRegs);
$this->summaryTotals['incompletes'] = count($incompleteRegs);
}
// now initialize the labels for this page
// start by loading the default field labels for this Module
$languageID = $viewer->getLanguageID();
$seriesKey = modulecim_reg::MULTILINGUAL_SERIES_KEY;
$pageKey = page_AdminEventHome::MULTILINGUAL_PAGE_KEY;
$this->labels = new MultilingualManager($languageID, $seriesKey, $pageKey);
}
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;
}
/**
* 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, $sortBy, $year_id = "", $campus_id = "")
{
parent::__construct(page_ViewStudentYearInSchool::DISPLAY_FIELDS);
$this->pathModuleRoot = $pathModuleRoot;
$this->viewer = $viewer;
$this->year_id = $year_id;
$this->campus_id = $campus_id;
// echo 'campusID['.$this->campus_id.']<br/>';
// $this->managerInit = $managerInit;
// Now load the access Priviledge 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);
// need to filter displayed data by campus associated with campus admin
$campusAdminSearchCondition = '';
if ($this->adminManager->hasSitePriv()) {
$campusManager = new RowManager_CampusManager();
$campusManager->setSortOrder('campus_desc');
$this->campusList = $campusManager->getListIterator();
$this->accessibleCampuses = $this->campusList->getDropListArray();
} else {
if ($this->adminManager->hasCampusPriv()) {
$campusAdminManager = new RowManager_CampusAdminManager();
$adminID = $this->adminManager->getID();
// echo 'adminID['.$adminID.']<br/>';
$campusAdminManager->setAdminID($adminID);
$campusList = $campusAdminManager->getListIterator();
//$multiTableManager->getListIterator();
$campusArray = $campusList->getDataList();
$campusIDsList = "";
// init the CSV of campus IDs associated with admin
reset($campusArray);
foreach (array_keys($campusArray) as $k) {
$record = current($campusArray);
$campusIDsList .= $record['campus_id'] . ',';
// create list of admin campuses
next($campusArray);
}
$campusIDsList = substr($campusIDsList, 0, -1);
// remove last comma
$campusAdminSearchCondition = 'cim_hrdb_assignment.campus_id in (' . $campusIDsList . ')';
} else {
if ($this->adminManager->isStaff($viewer->getID())) {
$staffManager = new RowManager_StaffManager();
$staffManager->setPersonID($personID);
$multiTableManager = new MultiTableManager();
$multiTableManager->addRowManager($staffManager);
$multiTableManager->setSortOrder('campus_desc');
$assignmentManager = new RowManager_AssignmentsManager();
$multiTableManager->addRowManager($assignmentManager, new JoinPair($assignmentManager->getJoinOnPersonID(), $staffManager->getJoinOnPersonID()));
$campusManager = new RowManager_CampusManager();
$multiTableManager->addRowManager($campusManager, new JoinPair($campusManager->getJoinOnCampusID(), $assignmentManager->getJoinOnCampusID()));
$this->campusList = $multiTableManager->getListIterator();
$campusIDsList = "";
// init the CSV of campus IDs associated with admin
$this->campusList->setFirst();
while ($this->campusList->moveNext()) {
$campusAssignObject = $this->campusList->getCurrent(new RowManager_AssignmentsManager());
$campusObject = $this->campusList->getCurrent(new RowManager_CampusManager());
$campusIDsList .= $campusAssignObject->getCampusID() . ',';
// create list of admin campuses
}
$campusIDsList = substr($campusIDsList, 0, -1);
// remove last comma
$campusAdminSearchCondition = 'cim_hrdb_assignment.campus_id in (' . $campusIDsList . ')';
}
}
}
$yearManager = new RowManager_YearInSchoolManager();
$yearManager->setSortOrder('year_id');
$this->yearValueList = $yearManager->getListIterator();
$this->yearValues = $this->yearValueList->getDropListArray();
// Add value to drop-list for showing person data for people not having person_year record
$keys = array_keys($this->yearValues);
$this->UNASSIGNED_IDX = $keys[count($this->yearValues) - 1] + 1;
// assumes autoincrement is active on table
$this->yearValues[$this->UNASSIGNED_IDX] = page_ViewStudentYearInSchool::UNASSIGNED;
// echo 'values = <pre>'.print_r($this->yearValues, true).'</pre>';
// modify the year_id if necessary
if ($this->year_id == page_ViewStudentYearInSchool::DISPLAY_ALL_ID) {
// setting the year_id to blank will get entries from all the years
$this->year_id = '';
} else {
if ($this->year_id == '') {
// no campus has been specified
// choose a default campus if none specified
// echo 'No campus specified<br/>';
// get the first element from the accessible list
foreach ($this->yearValues as $key => $value) {
$this->year_id = $key;
break;
}
// assert campus_id should now be something
if ($this->year_id == '') {
die("ERROR - year_id not set to anything<br/>");
}
}
}
$dataAccessObject = new MultiTableManager();
// Check if regular choice made (i.e. person has some year_in_school record)
if ($this->year_id != $this->UNASSIGNED_IDX) {
$personYearManager = new RowManager_PersonYearManager();
$personYearManager->setYear($this->year_id);
// SOMEWHAT REDUNDANT GIVEN addSearchCondition (which is required)
$dataAccessObject->addRowManager($personYearManager);
$yearManager = new RowManager_YearInSchoolManager();
$joinPair = new JoinPair($personYearManager->getJoinOnYearID(), $yearManager->getJoinOnYearID());
$dataAccessObject->addRowManager($yearManager, $joinPair);
$personManager = new RowManager_PersonManager();
$joinPair1 = new JoinPair($personManager->getJoinOnPersonID(), $personYearManager->getJoinOnPersonID());
$dataAccessObject->addRowManager($personManager, $joinPair1);
$assignmentManager = new RowManager_AssignmentsManager();
$joinPair2 = new JoinPair($personYearManager->getJoinOnPersonID(), $assignmentManager->getJoinOnPersonID());
$dataAccessObject->addRowManager($assignmentManager, $joinPair2);
$campusManager = new RowManager_CampusManager();
$joinPair3 = new JoinPair($assignmentManager->getJoinOnCampusID(), $campusManager->getJoinOnCampusID());
$dataAccessObject->addRowManager($campusManager, $joinPair3);
if ($sortBy == '') {
$sortBy = 'campus_shortDesc,person_lname';
}
if ($this->year_id != '') {
$dataAccessObject->addSearchCondition('cim_hrdb_person_year.year_id = ' . $this->year_id);
}
// filter by campuses assigned to this campus admin
if ($campusAdminSearchCondition != '') {
$dataAccessObject->addSearchCondition($campusAdminSearchCondition);
}
$dataAccessObject->setSortOrder($sortBy);
$this->listManager = $dataAccessObject->getListIterator();
} else {
// $personYearManager = new RowManager_PersonYearManager();
// $personYearManager->setYear($this->year_id); // SOMEWHAT REDUNDANT GIVEN addSearchCondition (which is required)
// $dataAccessObject->addRowManager( $personYearManager );
//
// $yearManager = new RowManager_YearInSchoolManager();
// $joinPair = new JoinPair($personYearManager->getJoinOnYearID(), $yearManager->getJoinOnYearID());
// $dataAccessObject->addRowManager( $yearManager, $joinPair );
$personManager = new RowManager_PersonManager();
$dataAccessObject->addRowManager($personManager);
$assignmentManager = new RowManager_AssignmentsManager();
$joinPair2 = new JoinPair($personManager->getJoinOnPersonID(), $assignmentManager->getJoinOnPersonID());
$dataAccessObject->addRowManager($assignmentManager, $joinPair2);
$campusManager = new RowManager_CampusManager();
$joinPair3 = new JoinPair($assignmentManager->getJoinOnCampusID(), $campusManager->getJoinOnCampusID());
$dataAccessObject->addRowManager($campusManager, $joinPair3);
if ($sortBy == '') {
$sortBy = 'campus_shortDesc,person_lname';
}
// get sub-query data for filtering out registrants that have already been registered for event
$subManager = new RowManager_PersonYearManager();
$personYearManager = new MultiTableManager();
$personYearManager->addRowManager($subManager);
$personYearManager->setFieldList('person_id');
$registered_SQL = $personYearManager->createSQL();
// echo "<br>CREATED SQL 1 = ".$registered_SQL;
// actually creates the sub-query ensuring that registrants listed do NOT have personyear records
$negateSubQuery = true;
$addSubQuery = true;
$dataAccessObject->constructSubQuery('person_id', $registered_SQL, $negateSubQuery, $addSubQuery);
// filter by campuses assigned to this campus admin
if ($campusAdminSearchCondition != '') {
$dataAccessObject->addSearchCondition($campusAdminSearchCondition);
}
$dataAccessObject->setSortOrder($sortBy);
$this->listManager = $dataAccessObject->getListIterator();
}
/** TEST **/
// $values = $this->listManager->getDataList();
// echo 'values found = <pre>'.print_r($values,true).'</pre>';
/** END TEST **/
// 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_ViewStudentYearInSchool::MULTILINGUAL_PAGE_KEY;
$this->labels->loadPageLabels($pageKey);
$this->labels->setSeriesKey(SITE_LABEL_SERIES_SITE);
$this->labels->loadPageLabels(SITE_LABEL_PAGE_FORM_LINKS);
}
/**
* function __construct
* <pre>
* Initialize the object.
* </pre>
* @param $pathModuleRoot [STRING] The path to this module's root directory
* @param $viewer [OBJECT] The viewer object.
* @param $formAction [STRING] The action on a form submit
* @param $ [INTEGER] Value used to initialize the rowManager
* @return [void]
*/
function __construct($pathModuleRoot, $viewer, $formAction, $person_id, $campus_id, $person_year_id = '')
{
// NOTE: be sure to call the parent constructor before trying to
// use the ->formXXX arrays...
parent::__construct($formAction, FormProcessor_EditStudentYearInSchool::FORM_FIELDS, FormProcessor_EditStudentYearInSchool::FORM_FIELD_TYPES);
$this->pathModuleRoot = $pathModuleRoot;
$this->viewer = $viewer;
$this->formAction = $formAction;
$this->campus_id = $campus_id;
$this->person_id = $person_id;
$this->person_year_id = $person_year_id;
// if ($person_year_id == '')
// {
// if (isset($person_id))
// {
// if (isset($campus_id))
// {
// }
// }
// }
/**** Check privileges and initialize campus drop-down list ***/
// Now load the access Priviledge 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);
if ($this->adminManager->hasSitePriv()) {
$campusManager = new RowManager_CampusManager();
$campusManager->setSortOrder('campus_desc');
$this->campusList = $campusManager->getListIterator();
$this->accessibleCampuses = $this->campusList->getDropListArray();
} else {
if ($this->adminManager->hasCampusPriv()) {
$campusAdminManager = new RowManager_CampusAdminManager();
$adminID = $this->adminManager->getID();
// echo 'adminID['.$adminID.']<br/>';
$campusAdminManager->setAdminID($adminID);
$multiTableManager = new MultiTableManager();
$multiTableManager->addRowManager($campusAdminManager);
$multiTableManager->setSortOrder('campus_desc');
$campusManager = new RowManager_CampusManager();
$multiTableManager->addRowManager($campusManager, new JoinPair($campusManager->getJoinOnCampusID(), $campusAdminManager->getJoinOnCampusID()));
$this->campusList = $multiTableManager->getListIterator();
$this->accessibleCampuses = array();
$this->campusList->setFirst();
while ($this->campusList->moveNext()) {
$campusAdminObject = $this->campusList->getCurrent(new RowManager_CampusAdminManager());
$campusObject = $this->campusList->getCurrent(new RowManager_CampusManager());
$this->accessibleCampuses[$campusAdminObject->getCampusID()] = $campusObject->getLabel();
}
} else {
if ($this->adminManager->isStaff($viewer->getID())) {
$staffManager = new RowManager_StaffManager();
$staffManager->setPersonID($personID);
$multiTableManager = new MultiTableManager();
$multiTableManager->addRowManager($staffManager);
$multiTableManager->setSortOrder('campus_desc');
$assignmentManager = new RowManager_AssignmentsManager();
$multiTableManager->addRowManager($assignmentManager, new JoinPair($assignmentManager->getJoinOnPersonID(), $staffManager->getJoinOnPersonID()));
$campusManager = new RowManager_CampusManager();
$multiTableManager->addRowManager($campusManager, new JoinPair($campusManager->getJoinOnCampusID(), $assignmentManager->getJoinOnCampusID()));
$this->campusList = $multiTableManager->getListIterator();
$this->accessibleCampuses = array();
$this->campusList->setFirst();
while ($this->campusList->moveNext()) {
$campusAssignObject = $this->campusList->getCurrent(new RowManager_AssignmentsManager());
$campusObject = $this->campusList->getCurrent(new RowManager_CampusManager());
$this->accessibleCampuses[$campusAssignObject->getCampusID()] = $campusObject->getLabel();
}
} else {
$campusManager = new RowManager_CampusManager();
$campusManager->setSortOrder('campus_desc');
$this->campusList = $campusManager->getListIterator();
$this->accessibleCampuses = $this->campusList->getDropListArray();
}
}
}
// modify the campus_id if necessary
if ($this->campus_id == FormProcessor_EditStudentYearInSchool::DISPLAY_ALL_ID) {
// setting the campus id to blank will get entries from all the campuses
$this->campus_id = '';
} else {
if ($this->campus_id == '') {
// no campus has been specified
// choose a default campus if none specified
// echo 'No campus specified<br/>';
// get the first element from the accessible list
foreach ($this->accessibleCampuses as $key => $value) {
$this->campus_id = $key;
break;
}
// assert campus_id should now be something
if ($this->campus_id == '') {
die("ERROR - campusID not set to anything<br/>");
}
}
}
/*** end privilege checking and campus droplist setup ***/
// echo 'campus = '.$this->campus_id;
// create new rowManager (a List Iterator obj.)
$statuses = '0,1,6';
// filter by assignment status in ('undefined', 'current student', 'unknown')
$this->rowManager = new PersonYearList($this->campus_id, $statuses, 'year_id,person_lname');
// figure out the important fields for the rowItems
$fieldsOfInterest = implode(',', $this->formFields);
$this->primaryIDs = array();
// for each row item ...
$this->rowManager->setFirst();
$i = 0;
$valid_values = explode(',', RowManager_PersonYearManager::FIELD_LIST);
while ($rowItem = $this->rowManager->getNext()) {
// make sure rowItems have valid entries in the DB
if (!$rowItem->isLoaded()) {
$rowItem->createNewEntry();
}
// set the fields of interest ...
$rowItem->setFieldsOfInterest($fieldsOfInterest);
// get the primaryID of this rowItem
$primaryID = $rowItem->getPrimaryKeyValue();
$this->primaryIDs[$i] = $primaryID;
$person_id = -1;
// now initialize beginning form values from rowItem object
for ($indx = 0; $indx < count($this->formFields); $indx++) {
$key = $this->formFields[$indx];
if (in_array($key, $valid_values)) {
$this->formValues[$key . $primaryID] = $rowItem->getValueByFieldName($key);
if ($key == 'person_id') {
$person_id = $this->formValues[$key . $primaryID];
}
} else {
if ($person_id != '-1') {
$person_manager = new RowManager_PersonManager($person_id);
$this->formValues[$key . $primaryID] = $person_manager->getValueByFieldName($key);
} else {
$this->formValues[$key . $primaryID] = "";
}
}
}
// next field
$i++;
}
// next rowItem in rowManager
// echo 'array = <pre>'.print_r($this->formValues,true).'</pre>';
// 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 = FormProcessor_EditStudentYearInSchool::MULTILINGUAL_PAGE_KEY;
$this->labels->loadPageLabels($pageKey);
// load the site default form link labels
$this->labels->setSeriesKey(SITE_LABEL_SERIES_SITE);
$this->labels->loadPageLabels(SITE_LABEL_PAGE_FORM_LINKS);
}
