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;
?>
= TRANS('TTL_COMP_X_SECTOR'); ?>
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 = [];
?>
= TRANS('TTL_GENERAL_BOARD'); ?>
fetchall() as $row) {
$data[] = $row;
?>
| = $row['department']; ?> |
= $row['Equipamento'];?> |
= $row['Quantidade'];?> |
= round($row['Percentual'], 2);?>% |