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);