1 AND o.aberto_por = ua.user_id {$qry_filter_clients} {$qry_filter_areas} GROUP BY cliente ORDER BY quantidade DESC"; $sql = $conn->query($sql); /* Total de ocorrências sem definição de cliente */ $labelClientNull = TRANS('CLIENT_NULL'); $sqlClientNull = "SELECT count(o.numero) AS quantidade FROM `status` s, ocorrencias o, usuarios ua WHERE o.client IS null AND s.stat_id = o.status AND s.stat_painel NOT IN (3) AND s.stat_ignored <> 1 AND o.aberto_por = ua.user_id {$qry_filter_clients} {$qry_filter_areas} ORDER BY quantidade DESC"; $sqlClientNull = $conn->query($sqlClientNull); if ($sql->rowCount()) { $hasClient = true; foreach ($sql->fetchAll(PDO::FETCH_ASSOC) as $row) { $data[] = $row; } } if ($sqlClientNull->rowCount()) { $totalNullClients = $sqlClientNull->fetchColumn(); if ($totalNullClients > 0) { $data[] = array( 'cliente' => $labelClientNull, 'quantidade' => $totalNullClients ); } elseif (!$hasClient) { $data[] = array( "cliente" => TRANS('NO_RECORDS_FOUND'), "quantidade" => 0 ); } } $data[]['chart_title'] = TRANS('TICKETS_BY_CLIENTS', '', 1); echo json_encode($data); ?>