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, 2); $_SESSION['s_page_invmon'] = $_SERVER['PHP_SELF']; $data = []; $data2 = []; $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 */ /* Equipamentos */ $sqlTotalCount = $QRY["total_equip"] . " WHERE comp_inst NOT IN (" . INST_TERCEIRA . ") {$termsTotalAllowedUnits}"; $resTotalCount = $conn->query($sqlTotalCount); $total = $resTotalCount->fetch()['total']; if ($total == 0) { echo message('info', 'Ooops!', TRANS('NO_RECORDS_FOUND'), '', '', 1); // return; } else { $terms = ""; $query = "SELECT count(*) as Quantidade, count(*)*100/" . $total . " as Percentual, T.tipo_nome as Equipamento, T.tipo_cod as tipo FROM equipamentos as C, tipo_equip as T WHERE C.comp_tipo_equip = T.tipo_cod and C.comp_inst not in (" . INST_TERCEIRA . ") {$termsAllowedUnits} GROUP by C.comp_tipo_equip, T.tipo_nome, T.tipo_cod ORDER BY Quantidade desc, Equipamento"; $resultado = $conn->query($query); $linhas = $resultado->rowCount(); if ($linhas == 0) { echo message('info', '', TRANS('MSG_NO_DATA_IN_PERIOD'), ''); return; } ?>
 
*". TRANS('RESULT_LIMITED_BY_PERMISSIONS').""; } ?>
fetchall() as $row) { $data[] = $row; ?>
%
query($sqlTotalCount); $total = $resTotalCount->fetch()['total']; // if ($total == 0) { // echo message('info', 'Ooops!', TRANS('NO_RECORDS_FOUND'), '', '', 1); // return; // } if ($total) { $terms = ""; $query = "SELECT count(*) as quantidade, count(*)*100/{$total} as percentual, i.item_nome as tipo, i.item_cod as tipo_cod FROM estoque as e, itens as i WHERE e.estoq_tipo = i.item_cod {$termsStockAllowedUnits} GROUP by tipo, tipo_cod ORDER BY quantidade desc, tipo"; $resultado = $conn->query($query); $linhas = $resultado->rowCount(); ?>
  
fetchall() as $row) { $data2[] = $row; ?>
%