top.window.location = '../../index.php'"; exit; } 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, 2); $_SESSION['s_page_invmon'] = $_SERVER['PHP_SELF']; $json = 0; $json2 = 0; ?> <?= APP_NAME; ?> <?= VERSAO; ?>
 
0) { $filteredUnitsNames .= ", "; } else { $filteredUnitsNames .= TRANS('FILTERED_BY_FOLLOW_UNITS') . ': '; } $filteredUnitsNames .= $filteredUnit['inst_nome'] . '(' . $filteredUnit['nickname']. ')'; } } /* Final do Bloco de controle de visualização */ $search_terms = ""; $query_filter = ""; $query_base = "SELECT count(*) as quantidade, T.tipo_nome AS equipamento, T.tipo_cod AS tipo, F.fab_nome AS fabricante, M.marc_nome AS modelo, M.marc_tipo AS modelo_cod, L.local AS department, L.loc_id AS department_cod, I.inst_cod as unit_cod, I.inst_nome as unit_name FROM equipamentos AS C, tipo_equip AS T, marcas_comp AS M, fabricantes AS F, localizacao as L, instituicao as I WHERE C.comp_tipo_equip = T.tipo_cod AND C.comp_inst = I.inst_cod AND F.fab_cod = C.comp_fab AND C.comp_marca = M.marc_cod AND C.comp_local = L.loc_id {$termsAllowedUnits}"; $queryRules = " FROM equipamentos AS C, tipo_equip AS T, marcas_comp AS M, fabricantes AS F, localizacao as L, instituicao as I WHERE C.comp_tipo_equip = T.tipo_cod AND C.comp_inst = I.inst_cod AND F.fab_cod = C.comp_fab AND C.comp_marca = M.marc_cod AND C.comp_local = L.loc_id {$termsAllowedUnits}"; /* Filtro por tipo de equipamento */ if (isset($_POST['equipment_type']) and (!empty($_POST['equipment_type']))) { $equipment_type_names = ""; $fieldIn = ""; foreach ($_POST['equipment_type'] as $field) { if (strlen((string)$fieldIn)) $fieldIn .= ","; $fieldIn .= $field; } $query_filter .= " AND T.tipo_cod IN ({$fieldIn}) "; $getTypeName = "SELECT * from tipo_equip where tipo_cod IN ({$fieldIn}) "; $exec = $conn->query($getTypeName); foreach ($exec->fetchall() as $rowName) { if (strlen((string)$equipment_type_names) > 0) $equipment_type_names .= ", "; $equipment_type_names .= $rowName['tipo_nome']; } $search_terms .= "" . TRANS('FILTERED_EQUIPMENT_TYPE') . ": {$equipment_type_names}"; } else { $equipment_type_names = TRANS('NONE_FILTER'); $search_terms .= "" . TRANS('FILTERED_EQUIPMENT_TYPE') . ": {$equipment_type_names}"; } /* Filtro por unidade */ if (isset($_POST['unit']) and (!empty($_POST['unit']))) { $unit_names = ""; $fieldIn = ""; foreach ($_POST['unit'] as $field) { if (strlen((string)$fieldIn)) $fieldIn .= ","; $fieldIn .= $field; } $query_filter .= " AND C.comp_inst IN ({$fieldIn}) "; $getTypeName = "SELECT * from instituicao where inst_cod IN ({$fieldIn}) "; $exec = $conn->query($getTypeName); foreach ($exec->fetchall() as $rowName) { if (strlen((string)$unit_names)) $unit_names .= ", "; $unit_names .= $rowName['inst_nome']; } $search_terms .= "" . TRANS('FILTERED_UNIT') . ": {$unit_names}"; } else { $unit_names = TRANS('NONE_FILTER'); $search_terms .= "" . TRANS('FILTERED_UNIT') . ": {$unit_names}"; } if (!empty($_SESSION['s_allowed_units'])) { $search_terms .= "*". TRANS('RESULT_LIMITED_BY_PERMISSIONS').""; } /* Query apenas para retornar os dados para o gráfico 1 - o agrupamento é diferente para a listagem */ $queryChart1 = "SELECT count(*) as quantidade, L.local AS department "; $queryChart1 .= $queryRules . $query_filter . " GROUP BY department ORDER BY quantidade DESC, department ASC"; $resultadoChart1 = $conn->query($queryChart1); /* Query apenas para retornar os dados para o gráfico 2 - o agrupamento é diferente para a listagem */ $queryChart2 = "SELECT count(*) as quantidade, I.inst_cod as unit_cod, I.inst_nome as unit_name "; $queryChart2 .= $queryRules . $query_filter . " GROUP BY unit_name, unit_cod ORDER BY quantidade DESC, unit_name ASC"; $resultadoChart2 = $conn->query($queryChart2); $query_base .= $query_filter; $query_base .= " GROUP BY department, department_cod, unit_cod, unit_name, fabricante, modelo, modelo_cod, tipo, tipo_cod, equipamento ORDER BY quantidade DESC, department ASC"; $resultado = $conn->query($query_base); $linhas = $resultado->rowCount(); if ($linhas == 0) { $_SESSION['flash'] = message('info', '', TRANS('NO_RECORDS_FOUND'), ''); redirect($_SERVER['PHP_SELF']); } else { ?>
fetchall() as $row) { ?> fetchall() as $rowDataChart1) { $data[] = $rowDataChart1; } foreach ($resultadoChart2->fetchall() as $rowDataChart2) { $data2[] = $rowDataChart2; } $json = json_encode($data); $json2 = json_encode($data2); ?>
$query, // 'Data' => $data, // 'Json normal' => $json, // ]); } } ?>