= DATE_SUB('{$hoje}', INTERVAL 1 YEAR) AND st.stat_ignored <> 1 {$qry_filter_clients} {$qry_filter_areas} "; $sql.= " GROUP BY s.sistema"; $sql = $conn->query($sql); $data = array(); if ($sql->rowCount()) { foreach ($sql->fetchAll(PDO::FETCH_ASSOC) as $row) { $data[] = $row; } } else { $data[] = array( "area" => TRANS('NO_RECORDS_FOUND'), "quantidade" => 0 ); } $data[]['chart_title'] = ($_SESSION['requester_areas'] ? TRANS('TICKETS_BY_REQUESTER_AREAS', '', 1) : TRANS('TICKETS_BY_AREAS', '', 1)); // IMPORTANT, output to json echo json_encode($data); ?>