if ($type !== NULL and $policy_id !== NULL and $policy_name !== NULL) {
$user_attendance_rows[$udt_obj->getColumn('user_id')]['hours_worked'][$type][$policy_id]['month'] = array('avg' => round($udt_obj->getColumn('avg'), 1), 'min' => $udt_obj->getColumn('min'), 'max' => $udt_obj->getColumn('max'), 'date_units' => $udt_obj->getColumn('date_units'));
}
unset($type, $policy_id, $policy_name);
}
}
//var_dump($user_attendance_rows);
//Repeat broken out by branch/department as well
}
/*
Exception History
*/
if (isset($columns['exception'])) {
//Get exception types.
$eplf = new ExceptionPolicyListFactory();
$eplf->getByCompanyId($current_company->getId());
if ($eplf->getRecordCount() > 0) {
foreach ($eplf as $ep_obj) {
$exception_policy_arr[$ep_obj->getId()] = array('type_id' => $ep_obj->getType(), 'name' => Option::getByKey($ep_obj->getType(), $ep_obj->getOptions('type')), 'severity_id' => $ep_obj->getSeverity());
}
}
//var_dump($exception_policy_arr);
$elf = new ExceptionListFactory();
$elf->getReportByTimePeriodAndUserIdAndCompanyIdAndStartDateAndEndDate('week', $filter_data['user_ids'], $current_company->getId(), $filter_data['start_date'], $filter_data['end_date']);
if ($elf->getRecordCount() > 0) {
foreach ($elf as $e_obj) {
$user_exception_rows[$e_obj->getColumn('user_id')][$e_obj->getColumn('exception_policy_id')]['week'] = array('exception_policy_id' => $e_obj->getColumn('exception_policy_id'), 'name' => $exception_policy_arr[$e_obj->getColumn('exception_policy_id')]['name'], 'code' => $exception_policy_arr[$e_obj->getColumn('exception_policy_id')]['type_id'], 'avg' => round($e_obj->getColumn('avg'), 2), 'min' => $e_obj->getColumn('min'), 'max' => $e_obj->getColumn('max'), 'total' => $e_obj->getColumn('total'));
}
}
$elf->getReportByTimePeriodAndUserIdAndCompanyIdAndStartDateAndEndDate('month', $filter_data['user_ids'], $current_company->getId(), $filter_data['start_date'], $filter_data['end_date']);
if ($elf->getRecordCount() > 0) {
