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;
?>
= TRANS('TTL_EQUIP_X_SECTOR'); ?>
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 {
?>
= $search_terms; ?>
fetchall() as $row) {
?>
| = $row['department']; ?> |
= $row['equipamento'];?> |
= $row['quantidade'];?> |
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,
// ]);
}
}
?>