query($sql); foreach ($result->fetchAll() as $row) { $i = 0; foreach ($datesBegin as $dateStart) { /* Em cada intervalo de tempo busco os totais de cada área */ $sqlEach = "SELECT count(*) AS total, s.sistema FROM ocorrencias o, sistemas s, usuarios ua, `status` st WHERE s.sis_id = " . $aliasAreasFilter . " AND o.aberto_por = ua.user_id AND o.status = st.stat_id AND st.stat_ignored <> 1 AND " . $aliasAreasFilter . " = " . $row['sis_id'] . " AND o.oco_real_open_date >= '" . $dateStart . "' AND o.oco_real_open_date <= '" . $datesEnd[$i] . "' {$qry_filter_clients} {$qry_filter_areas} GROUP BY s.sistema "; $resultEach = $conn->query($sqlEach); $countResults = $resultEach->rowCount(); if ($countResults) { foreach ($resultEach->fetchAll() as $rowEach) { if ($rowEach['sistema']) { $areas[] = $rowEach['sistema']; $meses[] = $months[$i]; $areasDados[$rowEach['sistema']][] = $rowEach['total']; } else { $areas[] = $row['sistema']; $meses[] = $months[$i]; $areasDados[$row['sistema']][] = 0; } } } else { $areas[] = $row['sistema']; $meses[] = $months[$i]; $areasDados[$row['sistema']][] = 0; } $i++; } } /* Ajusto os arrays de labels para não ter repetidos */ $meses = array_unique($meses); $areas = array_unique($areas); /* Trecho para remover as areas que não tiveram registros no período */ foreach ($areasDados as $key => $value) { if (array_sum($value) == 0) { unset($areas[array_search($key, $areas)]); unset($areasDados[$key]); } } /* Separo o conteúdo para organizar o JSON */ $data['areas'] = $areas; $data['months'] = $meses; $data['totais'] = $areasDados; $data['chart_title'] = ($_SESSION['requester_areas'] ? TRANS('TICKETS_BY_REQUESTER_AREA_LAST_MONTHS', '', 1) : TRANS('TICKETS_BY_AREA_LAST_MONTHS', '', 1)); // var_dump($areas, $totais, $meses, $areasDados, $data); echo json_encode($data); ?>