1 AND o.client = cl.id AND o.client = {$row['id']} AND " . $aliasAreasFilter . " = s.sis_id AND o.data_fechamento >= '" . $dateStart . "' AND o.data_fechamento <= '" . $datesEnd[$i] . "' {$qry_filter_clients} {$qry_filter_areas} GROUP BY cliente "; $resultEach = $conn->query($sqlEach); $countResults = $resultEach->rowCount(); if ($countResults) { foreach ($resultEach->fetchAll() as $rowEach) { if ($rowEach['cliente']){ $clients[] = $rowEach['cliente']; $meses[] = $months[$i]; $clientsDados[$rowEach['cliente']][] = intval($rowEach['total']); } else { $clients[] = $row['nickname']; $clientsDados[$row['nickname']][] = 0; $meses[] = $months[$i]; } } } else { $clients[] = $row['nickname']; $meses[] = $months[$i]; $clientsDados[$row['nickname']][] = 0; } $i++; } } /* Ajusto os arrays de labels para não ter repetidos */ $meses = array_unique($meses); $clients = array_unique($clients); /* Separo o conteúdo para organizar o JSON */ $data['clientes'] = $clients; $data['months'] = $meses; $data['totais'] = $clientsDados; // TICKETS_CLOSED_BY_REQUESTER_AREA_LAST_MONTHS $data['chart_title'] = ($_SESSION['requester_areas'] ? TRANS('TICKETS_CLOSED_BY_CLIENT_LAST_MONTHS_REQUESTER', '', 1) : TRANS('TICKETS_CLOSED_BY_CLIENT_LAST_MONTHS', '', 1)); echo json_encode($data); ?>