top.window.location = '../../index.php'"; exit; } require_once __DIR__ . "/" . "../../includes/include_basics_only.php"; require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php"; require_once __DIR__ . "/" . "../../includes/classes/worktime/Worktime.php"; require_once __DIR__ . "/" . "../../includes/functions/getWorktimeProfile.php"; use includes\classes\ConnectPDO; $conn = ConnectPDO::getInstance(); $auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 2, 1); set_time_limit(300); /* if (!isset($_POST['numero'])) { exit(); } */ $isAdmin = $_SESSION['s_nivel'] == 1; $dataPosted = []; $post = []; if (isset($_POST)){ $post = $_POST; } $dataPosted['client'] = (isset($post['client']) && !empty($post['client']) ? $post['client'] : ""); $dataPosted['area'] = (isset($post['area']) && !empty($post['area']) ? $post['area'] : ""); /* Se for filtro pelas áreas de destino do chamado (padrão) */ $dataPosted['requester_areas'] = (isset($post['requester_areas']) ? ($post['requester_areas'] == "yes" ? 1 : 0) : 0); $dataPosted['render_custom_fields'] = (isset($post['render_custom_fields']) ? ($post['render_custom_fields'] == "yes" ? 1 : 0) : 0); $dataPosted['app_from'] = (isset($post['app_from']) ? (noHtml($post['app_from'])) : ""); /* Filtro de seleção de clientes - formulário no painel de controle */ $filtered_clients = ""; /* Controle para limitar os resultados com base nos clientes selecionados */ $qry_filter_clients = ""; if (!empty($dataPosted['client'])) { $filtered_clients = implode(',', $dataPosted['client']); } if (!empty($filtered_clients)) { $qry_filter_clients = " AND o.client IN ({$filtered_clients}) "; } /* Filtro de seleção de áreas - formulário no painel de controle */ $filtered_areas = ""; /* Controle para limitar os resultados das consultas às áreas do usuário logado quando a opção estiver habilitada */ $qry_filter_areas = ""; if (!empty($dataPosted['area'])) { $filtered_areas = implode(',', $dataPosted['area']); } $aliasAreasFilter = ($dataPosted['requester_areas'] ? "ua.AREA" : "o.sistema"); $uareas = $_SESSION['s_uareas'] . ",-1"; if (empty($filtered_areas)) { if ($isAdmin) { $qry_filter_areas = ""; } else { $qry_filter_areas = " AND (" . $aliasAreasFilter . " IN ({$uareas}))"; } } else { $qry_filter_areas = " AND " . $aliasAreasFilter . " IN ({$filtered_areas})"; } $hoje = date('Y-m-d 00:00:00'); $mes = date('Y-m-01 00:00:00'); $config = getConfig($conn); $percLimit = $config['conf_sla_tolerance']; /* Chamados com tempo de vida maiores de $maxAgeToCalc anos não serão processados para cálculos de tempo nos cards */ $maxAgeToCalc = 1; $defaultValues = [ 'running' => 1, 'response' => [ 'time' => 'Nao calculado', 'seconds' => '0', ], 'solution' => [ 'time' => 'Nao calculado', 'seconds' => '0' ] ]; $totalEmAberto = 0; /* Total de chamados em aberto no sistema */ $sqlTotalEmAberto = "SELECT count(*) AS total FROM ocorrencias o, `status`, usuarios ua WHERE -- status.stat_ignored <> 1 AND -- status.stat_painel not in (3) AND status.not_done = 1 AND o.status = status.stat_id AND o.oco_scheduled = 0 AND o.aberto_por = ua.user_id {$qry_filter_clients} {$qry_filter_areas} "; try { $res = $conn->query($sqlTotalEmAberto); } catch (Exception $e) { echo 'Erro: ', $e->getMessage(), "
"; $erro = true; return false; } $totalEmAberto = $res->fetch()['total']; /* final do total em aberto */ /* Abertos na data corrente */ $sqlOpenToday = "SELECT count(*) AS total FROM ocorrencias o, usuarios ua, `status` s WHERE o.aberto_por = ua.user_id AND o.status = s.stat_id AND s.stat_ignored <> 1 AND o.oco_real_open_date >= '". $hoje ."' {$qry_filter_clients} {$qry_filter_areas} "; try { $resultOpenToday = $conn->query($sqlOpenToday); } catch (Exception $e) { // echo 'Erro: ', $e->getMessage(), "
"; return false; } $abertosHoje = $resultOpenToday->fetch()['total']; /* Abertos no mês corrente */ $sqlOpenMonth = "SELECT count(*) AS total FROM ocorrencias o, usuarios ua, `status` s WHERE o.aberto_por = ua.user_id AND o.status = s.stat_id AND s.stat_ignored <> 1 AND o.oco_real_open_date >= '". $mes ."' {$qry_filter_clients} {$qry_filter_areas}"; try { $resultOpenMonth = $conn->query($sqlOpenMonth); } catch (Exception $e) { echo 'Erro: ', $e->getMessage(), "
"; return false; } $abertosMes = $resultOpenMonth->fetch()['total']; /* Fechados na data corrente */ $sqlCloseToday = "SELECT count(*) AS total FROM ocorrencias o, usuarios ua, `status` s WHERE o.aberto_por = ua.user_id AND o.status = s.stat_id AND s.stat_ignored <> 1 AND o.data_fechamento >= '". $hoje ."' {$qry_filter_clients} {$qry_filter_areas}"; try { $resultCloseToday = $conn->query($sqlCloseToday); } catch (Exception $e) { echo 'Erro: ', $e->getMessage(), "
"; return false; } $fechadosHoje = $resultCloseToday->fetch()['total']; /* Fechados no mês corrente */ $sqlCloseMonth = "SELECT count(*) AS total FROM ocorrencias o, usuarios ua, `status` s WHERE o.aberto_por = ua.user_id AND o.status = s.stat_id AND s.stat_ignored <> 1 AND o.data_fechamento >= '". $mes ."' {$qry_filter_clients} {$qry_filter_areas}"; try { $resultCloseMonth = $conn->query($sqlCloseMonth); } catch (Exception $e) { echo 'Erro: ', $e->getMessage(), "
"; return false; } $fechadosMes = $resultCloseMonth->fetch()['total']; /* Modificar para pegar todas as ocorrências em status vinculados aos operadores - painel superior */ $sqlEmProgresso = "SELECT count(*) AS total FROM ocorrencias o, status s, usuarios ua WHERE -- o.status NOT IN (1, 4, 12) AND -- s.stat_painel in (1) AND -- s.stat_ignored <> 1 AND s.in_progress = 1 AND o.status = s.stat_id AND o.oco_scheduled = 0 AND o.aberto_por = ua.user_id {$qry_filter_clients} {$qry_filter_areas}"; try { $resultEmProgresso = $conn->query($sqlEmProgresso); } catch (Exception $e) { echo 'Erro: ', $e->getMessage(), "
"; // return false; } $emProgresso = $resultEmProgresso->fetch()['total']; $percEmProgresso = 0; if ($totalEmAberto) { $percEmProgresso = round($emProgresso * 100 / $totalEmAberto, 2); } /* Chamados sem resposta */ $sqlSemResposta = "SELECT count(*) AS total FROM ocorrencias o, usuarios ua, `status` s WHERE o.aberto_por = ua.user_id AND o.status = s.stat_id AND -- s.stat_ignored <> 1 AND -- s.stat_painel <> 3 AND s.not_done = 1 AND o.data_atendimento IS NULL {$qry_filter_clients} {$qry_filter_areas}"; try { $resultSemResposta = $conn->query($sqlSemResposta); } catch (Exception $e) { // echo 'Erro: ', $e->getMessage(), "
"; return false; } $semResposta = $resultSemResposta->fetch()['total']; $percSemResposta = 0; if ($totalEmAberto) { $percSemResposta = round($semResposta * 100 / $totalEmAberto, 2); } /* Busca geral de ocorrencias em aberto para os cálculos de tempos de resposta */ $countResponseUndefined = 0; $countResponseGreen = 0; $countResponseYellow = 0; $countResponseRed = 0; $countSolutionUndefined = 0; $countSolutionGreen = 0; $countSolutionYellow = 0; $countSolutionRed = 0; $absoluteReponseTime = 0; $absoluteSolutionTime = 0; $filteredResponseTime = 0; $filteredSolutionTime = 0; $frozenByStatus = 0; $frozenByWorktime = 0; $percResponseUndefined = 0; $percResponseGreen = 0; $percResponseYellow = 0; $percResponseRed = 0; $percSolutionUndefined = 0; $percSolutionGreen = 0; $percSolutionYellow = 0; $percSolutionRed = 0; $avgAbsoluteResponseTime = 0; $avgAbsoluteSolutionTime = 0; $avgFilteredResponseTime = 0; $avgFilteredSolutionTime = 0; /* final das variáveis sobre os chamados em aberto no sistema */ $data = array(); /* info dos chamados em aberto */ $data['abertosHoje'] = $abertosHoje; // $data['abertosHojeFilter']["data_abertura_from"] = date('Y-m-d'); $data['abertosHojeFilter']["data_abertura_from"] = date('d/m/Y'); $data['abertosHojeFilter']["app_from"] = $dataPosted['app_from']; $data['abertosHojeFilter']["is_requester_area"] = $dataPosted['requester_areas']; $data['abertosHojeFilter']["areas_filter"] = $filtered_areas; $data['abertosHojeFilter']["clients_filter"] = $filtered_clients; $data['abertosHojeFilter']["render_custom_fields"] = $dataPosted['render_custom_fields']; $data['fechadosHoje'] = $fechadosHoje; // $data['fechadosHojeFilter']["data_fechamento_from"] = date('Y-m-d'); $data['fechadosHojeFilter']["data_fechamento_from"] = date('d/m/Y'); $data['fechadosHojeFilter']["app_from"] = $dataPosted['app_from']; $data['fechadosHojeFilter']["is_requester_area"] = $dataPosted['requester_areas']; $data['fechadosHojeFilter']["areas_filter"] = $filtered_areas; $data['fechadosHojeFilter']["clients_filter"] = $filtered_clients; $data['fechadosHojeFilter']["render_custom_fields"] = $dataPosted['render_custom_fields']; $data['abertosMes'] = $abertosMes; $data['abertosMesFilter']["current_month"] = 1; $data['abertosMesFilter']["app_from"] = $dataPosted['app_from']; $data['abertosMesFilter']["is_requester_area"] = $dataPosted['requester_areas']; $data['abertosMesFilter']["areas_filter"] = $filtered_areas; $data['abertosMesFilter']["clients_filter"] = $filtered_clients; $data['abertosMesFilter']["render_custom_fields"] = $dataPosted['render_custom_fields']; $data['fechadosMes'] = $fechadosMes; $data['fechadosMesFilter']["closed_current_month"] = 1; $data['fechadosMesFilter']["app_from"] = $dataPosted['app_from']; $data['fechadosMesFilter']["is_requester_area"] = $dataPosted['requester_areas']; $data['fechadosMesFilter']["areas_filter"] = $filtered_areas; $data['fechadosMesFilter']["clients_filter"] = $filtered_clients; $data['fechadosMesFilter']["render_custom_fields"] = $dataPosted['render_custom_fields']; $data['emProgresso'] = $emProgresso; $data['emProgressoFilter']["em_progresso"] = 1; $data['emProgressoFilter']["app_from"] = $dataPosted['app_from']; $data['emProgressoFilter']["is_requester_area"] = $dataPosted['requester_areas']; $data['emProgressoFilter']["areas_filter"] = $filtered_areas; $data['emProgressoFilter']["clients_filter"] = $filtered_clients; $data['emProgressoFilter']["render_custom_fields"] = $dataPosted['render_custom_fields']; $data['percEmProgresso'] = $percEmProgresso; $data['semResposta'] = $semResposta; $data['semRespostaFilter']["empty_response"] = 1; $data['semRespostaFilter']["app_from"] = $dataPosted['app_from']; $data['semRespostaFilter']["is_requester_area"] = $dataPosted['requester_areas']; $data['semRespostaFilter']["areas_filter"] = $filtered_areas; $data['semRespostaFilter']["clients_filter"] = $filtered_clients; $data['semRespostaFilter']["render_custom_fields"] = $dataPosted['render_custom_fields']; $data['percSemResposta'] = $percSemResposta; echo json_encode($data);