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_units = (isset($_SESSION['s_rep_filters']['units']) && !empty($_SESSION['s_rep_filters']['units']) ? implode(',', $_SESSION['s_rep_filters']['units']) : '');
$sess_units = json_encode($sess_units);
$sess_area = (isset($_SESSION['s_rep_filters']['area']) ? $_SESSION['s_rep_filters']['area'] : '-1');
$sess_issue = (isset($_SESSION['s_rep_filters']['issue']) ? $_SESSION['s_rep_filters']['issue'] : '-1');
$sess_resource = (isset($_SESSION['s_rep_filters']['resource']) ? $_SESSION['s_rep_filters']['resource'] : '-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 s.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;
}
}
$labelsByStates = [
1 => TRANS('STATE_OPEN_CLOSE_IN_SEARCH_RANGE'),
2 => TRANS('STATE_OPEN_IN_SEARCH_RANGE'),
3 => TRANS('STATE_OPEN_IN_SEARCH_RANGE_CLOSE_ANY_TIME'),
4 => TRANS('STATE_OPEN_ANY_TIME_CLOSE_IN_SEARCH_RANGE'),
5 => TRANS('STATE_JUST_OPEN_IN_SEARCH_RANGE')
];
$jsonChart1 = 0;
$jsonChart2 = 0;
$jsonChart3 = 0;
$jsonChart4 = 0;
?>
= TRANS('ALLOCABLE_RESOURCES'); ?>
' . TRANS('FILTERED_CLIENT') . ":
{$clientName}" . '';
}
/* Tratando os retorno sobre o filtro utilizado - Unidades */
$units = (isset($_POST['units']) && !empty($_POST['units']) ? array_map('intval', $_POST['units']) : "");
// $_SESSION['s_rep_filters']['units'] = $units;
$criterText = "";
if (!empty($units)) {
$unitsIDs = implode(',', $units);
$criterText = "";
$sqlCriter = "SELECT inst_nome FROM instituicao WHERE inst_cod in ({$unitsIDs}) ORDER BY inst_nome";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['inst_nome'];
}
}
$unitsNames = $criterText;
if (!empty($unitsNames)) {
$criteria .= '
' . TRANS('FILTERED_UNIT') . ": {$unitsNames}" . '';
}
/* Tratando os retorno sobre o filtro utilizado - Area */
$area = (isset($_POST['area']) && !empty($_POST['area']) ? (int)$_POST['area'] : "");
$_SESSION['s_rep_filters']['area'] = $area;
$areaName = (!empty($area) ? getAreaInfo($conn, $area)['area_name']: "");
if (!empty($areaName)) {
$criteria .= '
' . TRANS('FILTERED_AREA') . ": {$areaName}" . '';
}
/* Tratando os retorno sobre o filtro utilizado - Tipo de solicitação */
$issueType = (isset($_POST['issue_type']) && !empty($_POST['issue_type']) ? (int)$_POST['issue_type'] : "");
$_SESSION['s_rep_filters']['issue'] = $issueType;
$issueTypeName = (!empty($issueType) ? getIssueById($conn, $issueType)['problema']: "");
if (!empty($issueTypeName)) {
$criteria .= '
' . TRANS('FILTERED_ISSUE_TYPE') . ": {$issueTypeName}" . '';
}
/* Tratando os retorno sobre o filtro utilizado - Tipo de recurso alocado | alocável */
$resource = (isset($_POST['resource']) && !empty($_POST['resource']) ? (int)$_POST['resource'] : "");
$_SESSION['s_rep_filters']['resource'] = $resource;
$resourceInfo = (!empty($resource) ? getAssetsModels($conn, $resource): "");
$resourceName = (!empty($resourceInfo) ? $resourceInfo['tipo'] . ' ' . $resourceInfo['fabricante'] . ' ' . $resourceInfo['modelo'] : "");
if (!empty($resourceName)) {
$criteria .= '
' . TRANS('FILTERED_RESOURCE') . ": {$resourceName}" . '';
}
/* Tratando os retorno sobre o filtro utilizado - Situação quanto ao status dos chamados no período */
$state = (isset($_POST['state']) && !empty($_POST['state']) ? (int)$_POST['state'] : "");
$_SESSION['s_rep_filters']['state'] = $state;
$stateName = (!empty($state) ? $labelsByStates[$state]: "");
$criteria .= '
' . TRANS('FILTERED_STATE') . ": {$stateName}" . '';
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 ($d_ini <= $d_fim) {
$_SESSION['s_rep_filters']['d_ini'] = $_POST['d_ini'];
$_SESSION['s_rep_filters']['d_fim'] = $_POST['d_fim'];
$titleAboutRange = TRANS('TTL_PERIOD_FROM') . " " . dateScreen($d_ini, 1) . " " . TRANS('DATE_TO') . " " . dateScreen($d_fim, 1);
$clausulesByStates = [
1 => " AND o.data_abertura >= '{$d_ini}' AND o.data_abertura <= '{$d_fim}' AND
o.data_fechamento IS NOT NULL AND o.data_fechamento >= '{$d_ini}' AND o.data_fechamento <= '{$d_fim}' ",
2 => " AND o.data_abertura >= '{$d_ini}' AND o.data_abertura <= '{$d_fim}' AND
(o.data_fechamento >= '{$d_fim}' OR o.data_fechamento IS NULL) ",
3 => " AND o.data_abertura >= '{$d_ini}' AND o.data_abertura <= '{$d_fim}' AND
o.data_fechamento IS NOT NULL ",
4 => " AND o.data_fechamento >= '{$d_ini}' AND o.data_fechamento <= '{$d_fim}' ",
5 => " AND o.data_abertura >= '{$d_ini}' AND o.data_abertura <= '{$d_fim}' "
];
$clientPost = (isset($_POST['client']) && !empty($_POST['client']) ? (int)$_POST['client'] : "");
$clientTerm = (!empty($clientPost) ? " AND o.client = {$clientPost} " : "");
$unitsPost = (isset($_POST['units']) && !empty($_POST['units']) ? implode(',', array_map('intval', $_POST['units'])) : "");
$unitsTerm = (!empty($unitsPost) ? " AND o.instituicao IN ({$unitsPost}) " : "");
$areaPost = (isset($_POST['area']) && !empty($_POST['area']) ? (int)$_POST['area'] : "");
$areaTerm = (!empty($areaPost) ? " AND o.sistema = {$areaPost} " : "");
$issueTypePost = (isset($_POST['issue_type']) && !empty($_POST['issue_type']) ? (int)$_POST['issue_type'] : "");
$issueTypeTerm = (!empty($issueTypePost) ? " AND o.problema = {$issueTypePost} " : "");
$resourcePost = (isset($_POST['resource']) && !empty($_POST['resource']) ? (int)$_POST['resource'] : "");
$resourceTerm = (!empty($resourcePost) ? " AND txr.model_id = {$resourcePost} " : "");
/* Consulta base para a geração de tabelas e gráficos */
$sqlParts = [];
$sqlParts['SELECT_COLUMNS'] = "SELECT
CONCAT(te.tipo_nome, ' ', f.fab_nome, ' ', mc.marc_nome) as tipo,
SUM(txr.amount) as quantidade ";
$sqlParts['FROM_COLUMNS'] = "FROM
tickets_x_resources txr,
sistemas s,
problemas p,
tipo_equip te,
marcas_comp mc,
fabricantes f,
assets_categories ac,
ocorrencias o
LEFT JOIN clients cl ON cl.id = o.client
LEFT JOIN instituicao un ON un.inst_cod = o.instituicao ";
$sqlParts['WHERE_DEFAULT'] = "WHERE
o.numero = txr.ticket AND
o.sistema = s.sis_id AND
o.problema = p.prob_id AND
txr.model_id = mc.marc_cod AND
txr.is_current = 1 AND
mc.marc_tipo = te.tipo_cod AND
mc.marc_manufacturer = f.fab_cod AND
te.tipo_categoria = ac.id AND
te.can_be_product = 1 ";
// ac.cat_is_product = 1 ";
$sqlParts['WHERE_CUSTOM'] = "{$clientTerm}
{$unitsTerm}
{$areaTerm}
{$issueTypeTerm}
{$resourceTerm}
{$clausulesByStates[$_POST['state']]} ";
$sqlParts['GROUP_BY'] = "GROUP BY tipo ";
$sqlParts['ORDER_BY'] = "ORDER BY quantidade DESC";
$sqlTable1 = $sqlParts['SELECT_COLUMNS'] . $sqlParts['FROM_COLUMNS'] . $sqlParts['WHERE_DEFAULT'] . $sqlParts['WHERE_CUSTOM'] . $sqlParts['GROUP_BY'] . $sqlParts['ORDER_BY'];
try {
$resultado = $conn->query($sqlTable1);
$linhasTable1 = $resultado->rowCount();
if ($linhasTable1) {
?>
= $titleAboutRange; ?>= TRANS('NEW_SEARCH'); ?>
= $criteria; ?>
= TRANS('TTL_GROUP_BY_RESOURCES'); ?>
fetchall() as $row) {
$dataChart1[] = $row;
?>
| = $row['tipo']; ?> |
= $row['quantidade']; ?> |
query($sqlTable2);
$linhasTable2 = $resultado->rowCount();
if ($linhasTable2) {
?>
= $titleAboutRange; ?>= TRANS('NEW_SEARCH'); ?>
= $criteria; ?>
= TRANS('TTL_GROUP_BY_AREAS'); ?>
fetchall() as $row) {
?>
| = $row['tipo']; ?> |
= $row['area']; ?> |
= $row['quantidade']; ?> |
query($sqlChart2);
$linhasChart2 = $resChart2->rowCount();
foreach ($resChart2->fetchall() as $row) {
$dataChart2[] = $row;
}
$jsonChart2 = json_encode($dataChart2);
?>
query($sqlTable3);
$linhasTable3 = $resultado->rowCount();
if ($linhasTable3) {
?>
= $titleAboutRange; ?>= TRANS('NEW_SEARCH'); ?>
= $criteria; ?>
= TRANS('TTL_GROUP_BY_ISSUES_TYPES'); ?>
fetchall() as $row) {
?>
| = $row['tipo']; ?> |
= $row['problema']; ?> |
= $row['quantidade']; ?> |
query($sqlChart3);
foreach ($resChart3->fetchall() as $row) {
$dataChart3[] = $row;
}
$jsonChart3 = json_encode($dataChart3);
?>
query($sqlTable4);
$linhasTable4 = $resultado->rowCount();
if ($linhasTable4) {
?>
= $titleAboutRange; ?>= TRANS('NEW_SEARCH'); ?>
= $criteria; ?>
= TRANS('TTL_GROUP_BY_CATEGORIES'); ?>
fetchall() as $row) {
$dataChart4[] = $row;
?>
| = $row['categoria']; ?> |
= $row['quantidade']; ?> |
getMessage(), '');
redirect($_SERVER['PHP_SELF']);
}
} else {
$_SESSION['flash'] = message('info', '', TRANS('MSG_COMPARE_DATE'), '');
redirect($_SERVER['PHP_SELF']);
}
}
}
?>