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('DEPARTMENTS_X_AREAS'); ?>
1 AND
o.sistema = s.sis_id AND o.local = l.loc_id ";
$queryRules = " FROM ocorrencias AS o, localizacao AS l, sistemas AS s, status st
WHERE o.status = st.stat_id AND st.stat_ignored <> 1 AND o.sistema = s.sis_id AND o.local = l.loc_id ";
if (!empty($filter_areas)) {
/* Nesse caso o usuário só pode filtrar por áreas que faça parte */
if (!empty($_POST['area']) && ($_POST['area'] != -1)) {
$query .= " AND o.sistema = " . $_POST['area'] . "";
$queryRules .= " AND o.sistema = " . $_POST['area'] . "";
$getAreaName = "SELECT * from sistemas where sis_id = " . $_POST['area'] . "";
$exec = $conn->query($getAreaName);
$rowAreaName = $exec->fetch();
$nomeArea = $rowAreaName['sistema'];
$criterio .= TRANS('FILTERED_AREA') . ": {$nomeArea}";
} else {
$query .= " AND o.sistema IN ({$u_areas}) ";
$queryRules .= " AND o.sistema IN ({$u_areas}) ";
$criterio .= TRANS('FILTERED_AREA') . ": [" . $areas_names . "]";
}
} else
if (isset($_POST['area']) && (!empty($_POST['area'])) && ($_POST['area'] != -1) && (($_POST['area'] == $_SESSION['s_area']) || ($_SESSION['s_nivel'] == 1))) {
$query .= " AND o.sistema = " . $_POST['area'] . "";
$queryRules .= " AND o.sistema = " . $_POST['area'] . "";
$getAreaName = "SELECT * from sistemas where sis_id = '" . $_POST['area'] . "'";
$exec = $conn->query($getAreaName);
$rowAreaName = $exec->fetch();
$nomeArea = $rowAreaName['sistema'];
$criterio .= TRANS('FILTERED_AREA') . ": {$nomeArea}";
} else
if ($_SESSION['s_nivel'] != 1) {
$_SESSION['flash'] = message('info', '', TRANS('MSG_CONSULT_FOR_YOU_AREA'), '');
redirect($_SERVER['PHP_SELF']);
} else {
$nomeArea = TRANS('NONE_FILTER');
$criterio .= TRANS('FILTERED_AREA') . ": {$nomeArea}";
}
$criterio .= ", " . TRANS('ONLY_CLOSED_IN_THE_PERIOD');
if ((!isset($_POST['d_ini'])) || (!isset($_POST['d_fim']))) {
$_SESSION['flash'] = message('info', '', TRANS('MSG_ALERT_PERIOD'), '');
redirect($_SERVER['PHP_SELF']);
} else {
$d_ini = $_POST['d_ini'] . $hora_inicio;
$d_ini = dateDB($d_ini);
$d_fim = $_POST['d_fim'] . $hora_fim;
$d_fim = dateDB($d_fim);
if (isset($_POST['mesAtual'])) {
$d_ini = date("Y-m-01 00:00:00");
$d_fim = date("Y-m-d H:i:s");
}
if ($d_ini <= $d_fim) {
$_SESSION['s_rep_filters']['d_ini'] = $_POST['d_ini'];
$_SESSION['s_rep_filters']['d_fim'] = $_POST['d_fim'];
/* Query apenas para retornar os dados para o gráfico 1 - o agrupamento é diferente para a listagem */
$queryChart = "SELECT count(*) AS quantidade, l.local AS setor ";
$queryChart .= $queryRules . " AND o.data_fechamento >= '".$d_ini."' AND o.data_fechamento <= '".$d_fim."' AND
o.data_atendimento IS NOT NULL
{$clausule}
GROUP BY l.local ORDER BY setor, quantidade desc";
$resultadoChart = $conn->query($queryChart);
/* Query apenas para retornar os dados para o gráfico 2 - o agrupamento é diferente para a listagem */
$queryChart2 = "SELECT count(*) AS quantidade, s.sistema AS area ";
$queryChart2 .= $queryRules . " AND o.data_fechamento >= '".$d_ini."' AND o.data_fechamento <= '".$d_fim."' AND
o.data_atendimento IS NOT NULL
{$clausule}
GROUP BY s.sistema ORDER BY quantidade desc";
$resultadoChart2 = $conn->query($queryChart2);
$query .= " AND o.data_fechamento >= '".$d_ini."' AND o.data_fechamento <= '".$d_fim."' AND
o.data_atendimento IS NOT NULL
{$clausule}
GROUP BY l.local, s.sistema ORDER BY setor, quantidade desc, area"; /* area, quantidade desc, setor */
$resultado = $conn->query($query);
$linhas = $resultado->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); ?>
= $criterio; ?>= TRANS('NEW_SEARCH'); ?>
fetchall() as $row) {
// $data[] = $row;
?>
| = $row['setor']; ?> |
= $row['quantidade']; ?> |
= $row['area']; ?> |
fetchall() as $rowDataChart) {
$data[] = $rowDataChart;
}
foreach ($resultadoChart2->fetchall() as $rowDataChart2) {
$data2[] = $rowDataChart2;
}
$json = json_encode($data);
$json2 = json_encode($data2);
?>
$query,
// 'Data' => $data,
// 'Json normal' => $json,
// ]);
}
} else {
$_SESSION['flash'] = message('info', '', TRANS('MSG_COMPARE_DATE'), '');
redirect($_SERVER['PHP_SELF']);
}
}
}
?>