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); $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; ?> <?= 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']) && $_POST['area'] != -1 && !empty($_POST['area'])) { $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); $linhas = $exec_qry_areas->rowCount(); if ($linhas == 0) { $_SESSION['flash'] = message('info', '', TRANS('MSG_NO_DATA_IN_PERIOD'), ''); redirect($_SERVER['PHP_SELF']); } else { ?>

fetchall() as $row) { $query_ab_sw = "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"; $exec_ab_sw = $conn->query($query_ab_sw); $row_ab_sw = $exec_ab_sw->fetch(); $query_fe_sw = "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 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"; $exec_fe_sw = $conn->query($query_fe_sw); $row_fe_sw = $exec_fe_sw->fetch(); // $tAbertos += $totalAbertos += $tt_ab = $row_ab_sw['abertos']; // $tFechados += $totalFechados += $tt_fe = $row_fe_sw['fechados']; $tAbertos += $totalAbertos += $row_ab_sw['abertos'] ?? 0; $tFechados += $totalFechados += $row_fe_sw['fechados'] ?? 0; $data[$i]['area'] = $row['sistema']; $data[$i]['abertos'] = $totalAbertos; $data[$i]['fechados'] = $totalFechados; $totalAbertos = 0; $totalFechados = 0; ?>
$query, // 'Data' => $data, // 'Json normal' => $json, // ]); } } else { $_SESSION['flash'] = message('info', '', TRANS('MSG_COMPARE_DATE'), ''); redirect($_SERVER['PHP_SELF']); } } } ?>