1 AND o.client = cl.id AND o.client = {$row['id']} AND o.oco_real_open_date >= '" . $dateStart . "' AND o.oco_real_open_date <= '" . $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']) { $clientes[] = $rowEach['cliente']; $meses[] = $months[$i]; $clientesDados[$rowEach['cliente']][] = $rowEach['total']; } else { $clientes[] = $row['nickname']; $meses[] = $months[$i]; $clientesDados[$row['nickname']][] = 0; } } } else { $clientes[] = $row['nickname']; $meses[] = $months[$i]; $clientesDados[$row['nickname']][] = 0; } $i++; } } /* Ajusto os arrays de labels para não ter repetidos */ $meses = array_unique($meses); $clientes = array_unique($clientes); /* Separo o conteúdo para organizar o JSON */ $data['clientes'] = $clientes; $data['months'] = $meses; $data['totais'] = $clientesDados; $data['chart_title'] = ($_SESSION['requester_areas'] ? TRANS('TICKETS_BY_CLIENT_LAST_MONTHS_REQUESTER', '', 1) : TRANS('TICKETS_BY_CLIENT_LAST_MONTHS', '', 1)); echo json_encode($data); ?>