top.window.location = '../../index.php'"; exit; } require_once __DIR__ . "/" . "../../includes/include_geral_new.inc.php"; require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php"; use includes\classes\ConnectPDO; $conn = ConnectPDO::getInstance(); $auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 2, 1); $_SESSION['s_page_ocomon'] = $_SERVER['PHP_SELF']; $sess_client = (isset($_SESSION['s_rep_filters']['client']) ? $_SESSION['s_rep_filters']['client'] : ''); $sess_area = (isset($_SESSION['s_rep_filters']['area']) ? $_SESSION['s_rep_filters']['area'] : '-1'); $sess_d_ini = (isset($_SESSION['s_rep_filters']['d_ini']) ? $_SESSION['s_rep_filters']['d_ini'] : date('01/m/Y')); $sess_d_fim = (isset($_SESSION['s_rep_filters']['d_fim']) ? $_SESSION['s_rep_filters']['d_fim'] : date('d/m/Y')); $sess_state = (isset($_SESSION['s_rep_filters']['state']) ? $_SESSION['s_rep_filters']['state'] : 1); $config = getConfig($conn); $doneStatus = $config['conf_status_done']; $filter_areas = ""; $areas_names = ""; if (isAreasIsolated($conn) && $_SESSION['s_nivel'] != 1) { /* Visibilidade isolada entre áreas para usuários não admin */ $u_areas = $_SESSION['s_uareas']; $filter_areas = " AND sis_id IN ({$u_areas}) "; $array_areas_names = getUserAreasNames($conn, $u_areas); foreach ($array_areas_names as $area_name) { if (strlen((string)$areas_names)) $areas_names .= ", "; $areas_names .= $area_name; } } $json = 0; $json2 = 0; $json3 = 0; $json4 = 0; ?> <?= APP_NAME; ?> <?= VERSAO; ?>
 
query($getAreaName); $rowAreaName = $exec->fetch(); $nomeArea = $rowAreaName['sistema']; $terms .= TRANS('FILTERED_AREA') . ": {$nomeArea}"; } else { $query_areas = "SELECT * FROM sistemas WHERE sis_status NOT IN (0) AND sis_atende = 1 AND sis_id IN ({$u_areas}) ORDER BY sistema"; $terms .= TRANS('FILTERED_AREA') . ": [" . $areas_names . "]"; } } else if (isset($_POST['area']) && (($_POST['area'] == -1) || empty($_POST['area']))) { $query_areas = "SELECT * FROM sistemas WHERE sis_status NOT IN (0) AND sis_atende = 1 ORDER BY sistema"; $terms .= TRANS('FILTERED_AREA') . ": " . TRANS('NONE_FILTER'); } else if (isset($_POST['area']) && !empty($_POST['area']) && $_POST['area'] != -1) { $query_areas = "SELECT * FROM sistemas WHERE sis_id IN (" . $_POST['area'] . ") ORDER BY sistema"; $getAreaName = "SELECT sistema FROM sistemas WHERE sis_id = " . $_POST['area'] . " "; $resGetArea = $conn->query($getAreaName); $terms .= TRANS('FILTERED_AREA') . ": ". $resGetArea->fetch()['sistema']; } $exec_qry_areas = $conn->query($query_areas); $exec_qry_areas_2 = $conn->query($query_areas); $linhas = $exec_qry_areas->rowCount(); if ($linhas == 0) { $_SESSION['flash'] = message('info', '', TRANS('MSG_NO_DATA_IN_PERIOD'), ''); redirect($_SERVER['PHP_SELF']); } else { $data = []; $data2 = []; $data3 = []; $data4 = []; $total = 0; $totalOpened = 0; $totalDone = 0; $totalClosed = 0; $totalStarted = 0; $totalAutoClosed = 0; $totalRated = 0; $tOpened = 0; $tDone = 0; $tClosed = 0; $tStarted = 0; $tAutoClosed = 0; $tRated = 0; $totalGreat = 0; $totalGood = 0; $totalRegular = 0; $totalBad = 0; $totalNotRated = 0; $tGreat = 0; $tGood = 0; $tRegular = 0; $tBad = 0; $tNotRated = 0; ?>

fetchall() as $row) { /** * Quantidade de chamados abertos no período */ $sqlOpened = "SELECT count(*) AS abertos, s.sistema AS area FROM ocorrencias AS o, sistemas AS s, `status` AS st WHERE o.status = st.stat_id AND st.stat_ignored <> 1 AND o.sistema = s.sis_id AND o.data_abertura >= '{$d_ini}' AND o.data_abertura <= '{$d_fim}' AND s.sis_id IN ({$row['sis_id']}) {$clausule} GROUP BY area"; $resOpened = $conn->query($sqlOpened); $rowOpened = $resOpened->fetch(); /** * Quantidade de chamados com atendimento iniciado no período */ $sqlStarted = "SELECT count(*) AS iniciados, s.sistema AS area, s.sis_id FROM ocorrencias AS o, sistemas AS s, `status` AS st WHERE o.status = st.stat_id AND st.stat_ignored <> 1 AND o.sistema = s.sis_id AND o.data_atendimento >= '{$d_ini}' AND o.data_atendimento <= '{$d_fim}' AND s.sis_id IN ({$row['sis_id']}) {$clausule} GROUP BY area, s.sis_id"; $resStarted = $conn->query($sqlStarted); $rowStarted = $resStarted->fetch(); /** * Quantidade de chamados concluídos (concluidos e encerrados) no período */ $sqlDone = "SELECT count(*) AS concluidos, s.sistema AS area, s.sis_id FROM ocorrencias AS o, sistemas AS s, `status` AS st WHERE o.status = st.stat_id AND o.status IN (4, {$doneStatus}) AND st.stat_ignored <> 1 AND o.sistema = s.sis_id AND o.data_fechamento >= '{$d_ini}' AND o.data_fechamento <= '{$d_fim}' AND s.sis_id IN ({$row['sis_id']}) {$clausule} GROUP BY area, s.sis_id"; $resDone = $conn->query($sqlDone); $rowDone = $resDone->fetch(); /** * Quantidade de chamados encerrados no período */ $sqlClosed = "SELECT count(*) AS fechados, s.sistema AS area, s.sis_id FROM ocorrencias AS o, sistemas AS s, `status` AS st WHERE o.status = st.stat_id AND o.status = 4 AND st.stat_ignored <> 1 AND o.sistema = s.sis_id AND o.data_fechamento >= '{$d_ini}' AND o.data_fechamento <= '{$d_fim}' AND s.sis_id IN ({$row['sis_id']}) {$clausule} GROUP BY area, s.sis_id"; $resClosed = $conn->query($sqlClosed); $rowClosed = $resClosed->fetch(); /** * Quantidade de chamados encerrados, de forma automática, no período */ $sqlAutoClosed = "SELECT count(*) AS auto_fechados, s.sistema AS area, s.sis_id FROM ocorrencias AS o, tickets_rated tr, sistemas AS s, `status` AS st WHERE o.status = st.stat_id AND o.status = 4 AND st.stat_ignored <> 1 AND o.sistema = s.sis_id AND o.numero = tr.ticket AND tr.rate IS NOT NULL AND tr.automatic_rate = 1 AND tr.rate_date >= '{$d_ini}' AND tr.rate_date <= '{$d_fim}' AND s.sis_id IN ({$row['sis_id']}) {$clausule} GROUP BY area, s.sis_id"; $resAutoClosed = $conn->query($sqlAutoClosed); $rowAutoClosed = $resAutoClosed->fetch(); /** * Quantidade de chamados avaliados no período */ $sqlRated = "SELECT COUNT(tr.rate) AS avaliados, s.sistema AS area, s.sis_id FROM ocorrencias AS o, tickets_rated tr, sistemas AS s, `status` AS st WHERE o.status = st.stat_id AND o.status = 4 AND st.stat_ignored <> 1 AND o.sistema = s.sis_id AND o.numero = tr.ticket AND tr.rate IS NOT NULL AND tr.rate_date >= '{$d_ini}' AND tr.rate_date <= '{$d_fim}' AND s.sis_id IN ({$row['sis_id']}) {$clausule} GROUP BY area, s.sis_id"; $resRated = $conn->query($sqlRated); $rowRated = $resRated->fetch(); /** * Operações para contabilizar a quantidade de chamados em cada situação para cada área */ $tOpened += $totalOpened += $rowOpened['abertos'] ?? 0; $tStarted += $totalStarted += $rowStarted['iniciados'] ?? 0; $tDone += $totalDone += $rowDone['concluidos'] ?? 0; $tClosed += $totalClosed += $rowClosed['fechados'] ?? 0; $tAutoClosed += $totalAutoClosed += $rowAutoClosed['auto_fechados'] ?? 0; $tRated += $totalRated += $rowRated['avaliados'] ?? 0; $data[$i]['area'] = $row['sistema']; $data[$i]['abertos'] = $totalOpened; $data[$i]['iniciados'] = $totalStarted; $data[$i]['concluidos'] = $totalDone; $data[$i]['fechados'] = $totalClosed; $data[$i]['auto_fechados'] = $totalAutoClosed; $data[$i]['avaliados'] = $totalRated; $totalOpened = 0; $totalStarted = 0; $totalDone = 0; $totalClosed = 0; $totalAutoClosed = 0; $totalRated = 0; ?>
 

fetchall() as $row) { /** * Avaliações dos chamados por área */ $sqlRates = "SELECT s.sistema AS area, tr.rate, count(tr.rate) as rates, s.sis_id FROM ocorrencias AS o, tickets_rated tr, sistemas AS s, `status` AS st WHERE o.status = st.stat_id AND o.status = 4 AND st.stat_ignored <> 1 AND o.sistema = s.sis_id AND o.numero = tr.ticket AND tr.rate IS NOT NULL AND tr.rate_date >= '{$d_ini}' AND tr.rate_date <= '{$d_fim}' AND s.sis_id IN ({$row['sis_id']}) {$clausule} GROUP BY area, tr.rate, s.sis_id"; $resRates = $conn->query($sqlRates); foreach ($resRates->fetchAll() as $rowRates) { $totalGreat += ($rowRates['rate'] == 'great' ? $rowRates['rates'] : 0) ?? 0; $totalGood += ($rowRates['rate'] == 'good' ? $rowRates['rates'] : 0) ?? 0; $totalRegular += ($rowRates['rate'] == 'regular' ? $rowRates['rates'] : 0) ?? 0; $totalBad += ($rowRates['rate'] == 'bad' ? $rowRates['rates'] : 0) ?? 0; $totalNotRated += ($rowRates['rate'] == 'not_rated' ? $rowRates['rates'] : 0) ?? 0; $tGreat += ($rowRates['rate'] == 'great' ? $rowRates['rates'] : 0) ?? 0; $tGood += ($rowRates['rate'] == 'good' ? $rowRates['rates'] : 0) ?? 0; $tRegular += ($rowRates['rate'] == 'regular' ? $rowRates['rates'] : 0) ?? 0; $tBad += ($rowRates['rate'] == 'bad' ? $rowRates['rates'] : 0) ?? 0; $tNotRated += ($rowRates['rate'] == 'not_rated' ? $rowRates['rates'] : 0) ?? 0; } $data3[$i]['area'] = $row['sistema']; $data3[$i]['great'] = $totalGreat; $data3[$i]['good'] = $totalGood; $data3[$i]['regular'] = $totalRegular; $data3[$i]['bad'] = $totalBad; $data3[$i]['not_rated'] = $totalNotRated; $totalGreat = 0; $totalGood = 0; $totalRegular = 0; $totalBad = 0; $totalNotRated = 0; ?>
{$sqlRates}"; // var_dump([ // 'Json normal' => "
" .$json3 . "
", // 'Data' => $data3 // ]); } } else { $_SESSION['flash'] = message('info', '', TRANS('MSG_COMPARE_DATE'), ''); redirect($_SERVER['PHP_SELF']); } } } ?>