$pptsvlf = new PayPeriodTimeSheetVerifyListFactory(); $pptsvlf->getByPayPeriodIdAndCompanyId($pay_period_obj->getId(), $current_company->getId()); $verified_time_sheets = 0; $pending_time_sheets = 0; if ($pptsvlf->getRecordCount() > 0) { foreach ($pptsvlf as $pptsv_obj) { if ($pptsv_obj->getAuthorized() == TRUE) { $verified_time_sheets++; } elseif ($pptsv_obj->getStatus() == 30) { $pending_time_sheets++; } } } //Get total employees with time for this pay period. $udtlf = new UserDateTotalListFactory(); $total_worked_users = $udtlf->getWorkedUsersByPayPeriodId($pay_period_obj->getId()); //Count how many pay stubs for each pay period. $pslf = new PayStubListFactory(); $total_pay_stubs = $pslf->getByPayPeriodId($pay_period_obj->getId())->getRecordCount(); if ($pay_period_obj->getStatus() != 20) { $open_pay_periods = TRUE; } $pay_periods[] = array('id' => $pay_period_obj->getId(), 'company_id' => $pay_period_obj->getCompany(), 'pay_period_schedule_id' => $pay_period_obj->getPayPeriodSchedule(), 'name' => $pay_period_schedule->getName(), 'type' => Option::getByKey($pay_period_schedule->getType(), $pay_period_schedule->getOptions('type')), 'status' => Option::getByKey($pay_period_obj->getStatus(), $pay_period_obj->getOptions('status')), 'start_date' => TTDate::getDate('DATE+TIME', $pay_period_obj->getStartDate()), 'end_date' => TTDate::getDate('DATE+TIME', $pay_period_obj->getEndDate()), 'transaction_date' => TTDate::getDate('DATE+TIME', $pay_period_obj->getTransactionDate()), 'low_severity_exceptions' => $low_severity_exceptions, 'med_severity_exceptions' => $med_severity_exceptions, 'high_severity_exceptions' => $high_severity_exceptions, 'pending_requests' => $pending_requests, 'verified_time_sheets' => $verified_time_sheets, 'pending_time_sheets' => $pending_time_sheets, 'total_worked_users' => $total_worked_users, 'total_ps_amendments' => $total_ps_amendments, 'total_pay_stubs' => $total_pay_stubs, 'deleted' => $pay_period_obj->getDeleted()); } unset($total_shifts, $total_ps_amendments, $total_pay_stubs, $verified_time_sheets, $total_worked_users); } } else { Debug::Text('No pay periods pending transaction ', __FILE__, __LINE__, __METHOD__, 10); } $smarty->assign_by_ref('open_pay_periods', $open_pay_periods); $smarty->assign_by_ref('pay_periods', $pay_periods);