public function getreportAction()
{
$user = $this->session->getCurrentUser();
$data = array();
$data['date_from'] = addslashes(trim(strip_tags($this->request->getPost('date_from'))));
$data['date_to'] = addslashes(trim(strip_tags($this->request->getPost('date_to'))));
$data['users_id'] = (int) $user->id;
$data['ids'] = array();
if (!is_null($this->request->getPost('ids')) && is_array($this->request->getPost('ids'))) {
foreach ($this->request->getPost('ids') as $id) {
$data['ids'][] = (int) $id;
}
}
$projectsModel = new Projects();
$reports = $projectsModel->getReports($data);
$totalTime = 0;
foreach ($reports as $key => &$item) {
if ($item['t_sum'] === null) {
unset($reports[$key]);
} else {
$totalTime += $item['t_sum'];
$hours = floor($item['t_sum'] / 3600);
$mins = floor(($item['t_sum'] - $hours * 3600) / 60);
$item['t_sum'] = $hours . ' часов ' . $mins . ' минут';
}
}
$this->view->reports = array_values($reports);
$hours = floor($totalTime / 3600);
$mins = floor(($totalTime - $hours * 3600) / 60);
$this->view->totalTime = $hours . ' часов ' . $mins . ' минут';
$dateFrom = new \DateTime($data['date_from']);
$dateTo = new \DateTime($data['date_to']);
$this->view->dateFrom = $dateFrom->format('d.m.Y');
$this->view->dateTo = $dateTo->format('d.m.Y');
}