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;
?>
= TRANS('TTL_BOARD_CALL_AREA_ATTEND'); ?>
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 {
?>
= TRANS('TTL_PERIOD_FROM') . " " . dateScreen($d_ini, 1) . " " . TRANS('DATE_TO') . " " . dateScreen($d_fim, 1); ?>
= $terms; ?>= TRANS('NEW_SEARCH'); ?>
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;
?>
| = $data[$i]['area']; ?> |
= $data[$i]['abertos']; ?> |
= $data[$i]['fechados']; ?> |
$query,
// 'Data' => $data,
// 'Json normal' => $json,
// ]);
}
} else {
$_SESSION['flash'] = message('info', '', TRANS('MSG_COMPARE_DATE'), '');
redirect($_SERVER['PHP_SELF']);
}
}
}
?>