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; ?> <?= APP_NAME; ?> <?= VERSAO; ?>
 
' . 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) { ?>

     
    fetchall() as $row) { $dataChart1[] = $row; ?>
    query($sqlTable2); $linhasTable2 = $resultado->rowCount(); if ($linhasTable2) { ?>

     
    fetchall() as $row) { ?>
    query($sqlChart2); $linhasChart2 = $resChart2->rowCount(); foreach ($resChart2->fetchall() as $row) { $dataChart2[] = $row; } $jsonChart2 = json_encode($dataChart2); ?>
    query($sqlTable3); $linhasTable3 = $resultado->rowCount(); if ($linhasTable3) { ?>

     
    fetchall() as $row) { ?>
    query($sqlChart3); foreach ($resChart3->fetchall() as $row) { $dataChart3[] = $row; } $jsonChart3 = json_encode($dataChart3); ?>
    query($sqlTable4); $linhasTable4 = $resultado->rowCount(); if ($linhasTable4) { ?>

     
    fetchall() as $row) { $dataChart4[] = $row; ?>
    getMessage(), ''); redirect($_SERVER['PHP_SELF']); } } else { $_SESSION['flash'] = message('info', '', TRANS('MSG_COMPARE_DATE'), ''); redirect($_SERVER['PHP_SELF']); } } } ?>