= '{$ticketInfo['data_abertura']}' AND " : ""); $sql = "SELECT s.status as status, count(o.status) AS quantidade FROM status s, ocorrencias o, usuarios ua WHERE {$limitDateFrom} s.stat_id = o.status AND -- s.stat_painel NOT IN (3) AND -- s.stat_ignored <> 1 AND s.not_done = 1 AND o.aberto_por = ua.user_id {$qry_filter_clients} {$qry_filter_areas} GROUP BY status ORDER BY quantidade DESC"; $sql = $conn->query($sql); $data = array(); if ($sql->rowCount()) { foreach ($sql->fetchAll(PDO::FETCH_ASSOC) as $row) { $data[] = $row; } } else { $data[] = array( "status" => TRANS('NO_RECORDS_FOUND'), "quantidade" => 0 ); } $data[]['chart_title'] = TRANS('TICKETS_BY_STATUS', '', 1); // IMPORTANT, output to json echo json_encode($data); ?>