} unset($end_date); //var_dump($user_wage); $pending_requests = array(); if (isset($filter_data['pay_period_ids']) and count($filter_data['pay_period_ids']) > 0) { //Get all pending requests $rlf = new RequestListFactory(); $rlf->getSumByPayPeriodIdAndStatus($filter_data['pay_period_ids'], 30); if ($rlf->getRecordCount() > 0) { $r_obj = $rlf->getCurrent(); $pending_requests[$r_obj->getColumn('pay_period_id')] = $r_obj->getColumn('total'); } } $slf = new ScheduleListFactory(); //$slf->getReportByPayPeriodIdAndUserId($filter_data['pay_period_ids'], $filter_data['user_ids']); $slf->getReportByCompanyIdAndArrayCriteria($current_company->getId(), $filter_data); if ($slf->getRecordCount() > 0) { foreach ($slf as $s_obj) { $user_id = $s_obj->getColumn('user_id'); $pay_period_id = $s_obj->getColumn('pay_period_id'); $status_id = $s_obj->getColumn('status_id'); $status = strtolower(Option::getByKey($status_id, $s_obj->getOptions('status'))); $schedule_rows[$user_id][$pay_period_id][$status] = $s_obj->getColumn('total_time'); unset($user_id, $pay_period_id, $status_id, $status); } } //var_dump($schedule_rows); $pay_period_ids = array(); $udtlf = new UserDateTotalListFactory(); //$udtlf->getReportByPayPeriodIDListAndUserIdList($filter_data['pay_period_ids'], $filter_data['user_ids'], array($filter_data['primary_sort'] => 'asc') ); $udtlf->getReportByCompanyIdAndArrayCriteria($current_company->getId(), $filter_data);