public function createDepartmentsReportFinalArray($dataArray, $columnArray) { $businessunitArray = array(); $cityArray = array(); $stateArray = array(); $countryArray = array(); if (!empty($dataArray)) { foreach ($dataArray as $key => $curr) { if (isset($curr['unitid'])) { if (!in_array($curr['unitid'], $businessunitArray)) { array_push($businessunitArray, $curr['unitid']); } } if (isset($curr['city'])) { if (!in_array($curr['city'], $cityArray)) { array_push($cityArray, $curr['city']); } } if (isset($curr['state'])) { if (!in_array($curr['state'], $stateArray)) { array_push($stateArray, $curr['state']); } } if (isset($curr['country'])) { if (!in_array($curr['country'], $countryArray)) { array_push($countryArray, $curr['country']); } } } } if (!empty($businessunitArray)) { $businessunitModel = new Default_Model_Businessunits(); $businessNameArray = $businessunitModel->getBusinessunitNamesByIds($businessunitArray); } if (!empty($cityArray)) { $cityModel = new Default_Model_Cities(); $cityNameArray = $cityModel->getCityNamesByIds($cityArray); } if (!empty($stateArray)) { $stateModel = new Default_Model_States(); $stateNameArray = $stateModel->getStateNamesByIds($stateArray); } if (!empty($countryArray)) { $countryModel = new Default_Model_Countries(); $countryNameArray = $countryModel->getCountryNamesByIds($countryArray); } $finalArray = array(); if (!empty($dataArray)) { foreach ($dataArray as $key => $curr) { $finalArray[$key]['id'] = $curr['id']; if (in_array("deptname", $columnArray)) { $finalArray[$key]['deptname'] = $curr['deptname']; } if (in_array("unitname", $columnArray)) { $finalArray[$key]['unitname'] = isset($businessNameArray[$curr['unitid']]) ? $businessNameArray[$curr['unitid']] : ''; } if (in_array("deptcode", $columnArray)) { $finalArray[$key]['deptcode'] = $curr['deptcode']; } if (in_array("empcount", $columnArray)) { $finalArray[$key]['empcount'] = $curr['empcount']; } if (in_array("startdate", $columnArray)) { $finalArray[$key]['startdate'] = $curr['startdate']; } if (in_array("address", $columnArray)) { $finalArray[$key]['address1'] = $curr['address1']; $finalArray[$key]['address'] = $curr['address1']; } if (in_array("ccity", $columnArray)) { $finalArray[$key]['ccity'] = isset($cityNameArray[$curr['city']]) ? $cityNameArray[$curr['city']] : ''; } if (in_array("sstate", $columnArray)) { $finalArray[$key]['sstate'] = isset($stateNameArray[$curr['state']]) ? $stateNameArray[$curr['state']] : ''; } if (in_array("ccountry", $columnArray)) { $finalArray[$key]['ccountry'] = isset($countryNameArray[$curr['country']]) ? $countryNameArray[$curr['country']] : ''; } if (in_array("status", $columnArray)) { $finalArray[$key]['status'] = $curr['status']; } } } return $finalArray; }