1 AND o.numero = tcf.ticket AND tcf.cfield_id = {$costField} AND o.data_abertura >= '{$dateStart}' AND o.data_abertura <= '{$datesEnd[$i]}' AND (o.authorization_status <> 3 OR o.authorization_status IS NULL) {$qry_filter_clients} {$qry_filter_areas} {$areasTerms} "; $resultEach = $conn->query($sqlEach); $countResults = $resultEach->rowCount(); if ($countResults) { foreach ($resultEach->fetchAll() as $rowEach) { $data[$i]['mes'] = $months[$i]; $data[$i]['total'] = $rowEach['total'] ?? 0; } } else { $data[$i]['mes'] = $months[$i]; $data[$i]['total'] = 0; } $i++; } /* Ajusto os arrays de labels para não ter repetidos */ // $meses = array_unique($meses); /* Separo o conteúdo para organizar o JSON */ // $data['areas'] = $areas; // $data['months'] = $meses; // $data['totais'] = $areasDados; $data['chart_title'] = TRANS('TOTAL_COST_MONTH', '', 1); // var_dump($areas, $totais, $meses, $areasDados, $data); echo json_encode($data); ?>