1 AND o.client = cl.id AND o.oco_real_open_date >= '" . $d_ini_completa . "' AND o.oco_real_open_date <= '" . $d_fim_completa . "' AND o.client = {$row['id']} {$qry_filter_clients} {$qry_filter_areas} GROUP BY cl.nickname"; $query_ab_sw = $conn->query($query_ab_sw); $totalAbertos += $query_ab_sw->fetch(PDO::FETCH_ASSOC)['abertos'] ?? 0; $query_fe_sw = "SELECT count(*) AS fechados, cl.nickname AS cliente, cl.id FROM ocorrencias AS o, sistemas AS s, usuarios ua, `status` st, clients cl WHERE " . $aliasAreasFilter . " = s.sis_id AND o.aberto_por = ua.user_id AND o.status = st.stat_id AND st.stat_ignored <> 1 AND o.data_fechamento >= '" . $d_ini_completa . "' AND o.data_fechamento <= '" . $d_fim_completa . "' AND o.client = {$row['id']} {$qry_filter_clients} {$qry_filter_areas} GROUP by cliente, cl.id"; $query_fe_sw = $conn->query($query_fe_sw); $totalFechados += $query_fe_sw->fetch(PDO::FETCH_ASSOC)['fechados'] ?? 0; $query_ca_sw = "SELECT count(*) AS cancelados, cl.nickname AS cliente FROM ocorrencias AS o, sistemas AS s, usuarios ua, `status` st, clients cl WHERE " . $aliasAreasFilter . " = s.sis_id AND o.aberto_por = ua.user_id AND o.status = st.stat_id AND st.stat_ignored <> 1 AND o.oco_real_open_date >= '" . $d_ini_completa . "' AND o.oco_real_open_date <= '" . $d_fim_completa . "' AND o.status in (12) AND o.client = {$row['id']} {$qry_filter_clients} {$qry_filter_areas} GROUP by cliente"; $query_ca_sw = $conn->query($query_ca_sw); $totalCancelados += $query_ca_sw->fetch(PDO::FETCH_ASSOC)['cancelados'] ?? 0; $data[$i]['cliente'] = $row['nickname']; $data[$i]['abertos'] = $totalAbertos; $data[$i]['fechados'] = $totalFechados; $data[$i]['cancelados'] = $totalCancelados; $totalAbertos = 0; $totalFechados = 0; $totalCancelados = 0; $i++; } } /* Trecho para remover os clientes que não tiveram registros no período */ foreach ($data as $key => $clientValues) { if (array_sum($clientValues) == 0) { unset($data[$key]); }; } //TICKETS_BY_REQUESTER_AREA_CURRENT_MONTH $data[]['chart_title'] = ($_SESSION['requester_areas'] ? TRANS('TICKETS_BY_CLIENTS_CURRENT_MONTH_REQUESTER', '', 1) : TRANS('TICKETS_BY_CLIENTS_CURRENT_MONTH', '', 1)); // IMPORTANT, output to json echo json_encode($data); ?>