public function createreportuserlogfinalArray($userLogData, $selectColumns) { $userArray = array(); $empRoleArray = array(); $groupArray = array(); if (!empty($userLogData)) { foreach ($userLogData as $key => $curr) { if (isset($curr['userid'])) { if (!in_array($curr['userid'], $userArray)) { array_push($userArray, $curr['userid']); } } if (isset($curr['emprole'])) { if (!in_array($curr['emprole'], $empRoleArray)) { array_push($empRoleArray, $curr['emprole']); } } if (isset($curr['group_id'])) { if (!in_array($curr['group_id'], $groupArray)) { array_push($groupArray, $curr['group_id']); } } } } if (!empty($empRoleArray)) { $roleModel = new Default_Model_Roles(); $roleNameArray = $roleModel->getEmpRoleNamesByIds($empRoleArray); } if (!empty($groupArray)) { $groupModel = new Default_Model_Groups(); $groupNameArray = $groupModel->getGroupNamesByIds($groupArray); } $finalArray = array(); if (!empty($userLogData)) { foreach ($userLogData as $key => $curr) { if (in_array("userfullname", $selectColumns)) { $finalArray[$key]['userfullname'] = $curr['userfullname']; } if (in_array("employeeId", $selectColumns)) { $finalArray[$key]['employeeId'] = $curr['employeeId']; } if (in_array("group_id", $selectColumns)) { $finalArray[$key]['group_id'] = isset($groupNameArray[$curr['group_id']]) ? $groupNameArray[$curr['group_id']] : ''; } if (in_array("emprole", $selectColumns)) { $finalArray[$key]['emprole'] = isset($roleNameArray[$curr['emprole']]) ? $roleNameArray[$curr['emprole']] : ''; } if (in_array("emailaddress", $selectColumns)) { $finalArray[$key]['emailaddress'] = $curr['emailaddress']; } if (in_array("logindatetime", $selectColumns)) { $finalArray[$key]['logindatetime'] = sapp_Global::getDisplayDate($curr['logindatetime']); } if (in_array("empipaddress", $selectColumns)) { $curr['empipaddress'] = $curr['empipaddress'] == '::1' ? '127.0.01' : $curr['empipaddress']; $finalArray[$key]['empipaddress'] = $curr['empipaddress']; } } } return $finalArray; }