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']; $json = 0; $json2 = 0; $json3 = 0; ?> <?= APP_NAME; ?> <?= VERSAO; ?>
 
query($sqlTotalCount); $total = $resTotalCount->fetch()['total']; if ($total == 0) { echo message('info', 'Ooops!', TRANS('NO_RECORDS_FOUND'), '', '', 1); return; } // $query = "select count(l.local)as qtd, count(*)/" . $total . "*100 as porcento, // l.local as local, l.loc_id as tipo_local, t.tipo_nome as equipamento, t.tipo_cod as tipo // from equipamentos as c, // tipo_equip as t, localizacao as l where ((c.comp_tipo_equip = t.tipo_cod) // and (c.comp_local = l.loc_id) and (t.tipo_cod in (1,2)) " . $clausula2 . ") group by local,tipo order by qtd desc , // local asc"; $terms = ""; $query = "SELECT count(*) as Quantidade, count(*)*100/" . $total . " as Percentual, 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 FROM equipamentos AS C, tipo_equip AS T, marcas_comp AS M, fabricantes AS F, localizacao as L WHERE C.comp_tipo_equip = T.tipo_cod AND C.comp_inst not in (" . INST_TERCEIRA . ") AND F.fab_cod = C.comp_fab AND C.comp_marca = M.marc_cod AND C.comp_local = L.loc_id AND T.tipo_cod IN (1,2) GROUP BY department, Equipamento ORDER BY Quantidade DESC, department ASC"; $resultado = $conn->query($query); $linhas = $resultado->rowCount(); if ($linhas == 0) { echo message('info', '', TRANS('MSG_NO_DATA_IN_PERIOD'), ''); return; } $data = []; // $data2 = []; // $data3 = []; ?>
fetchall() as $row) { $data[] = $row; ?>
%