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);
?>
= TRANS('HNT_HISTORY_LOCAL_EQUIP'); ?>
query($queryTotal);
$linhasTotal = $resultadoTotal->rowCount();
$query = "SELECT
c.comp_inv AS etiqueta, c.comp_inst AS instituicao, c.comp_local AS tipo_local,
i.inst_nome AS instituicao_nome, c.comp_tipo_equip AS tipo,
t.tipo_nome AS equipamento, s.situac_cod AS situac_cod,
l.local AS locais, l.loc_id AS local_cod, h.hist_data AS data,
extract(day FROM hist_data)AS DIA,
extract(month FROM hist_data)AS MES,
extract(year FROM hist_data)AS ANO
FROM equipamentos AS c, instituicao AS i,
localizacao AS l, historico AS h, tipo_equip AS t, situacao AS s
WHERE
c.comp_inv = h.hist_inv AND c.comp_inst = h.hist_inst AND h.hist_local = l.loc_id AND h.hist_inv = '{$asset_tag}'
AND h.hist_inst = '{$asset_unit}' AND i.inst_cod = h.hist_inst AND c.comp_tipo_equip = t.tipo_cod
AND c.comp_situac = s.situac_cod
ORDER BY data DESC";
$resultado = $conn->query($query);
$resultado2 = $conn->query($query);
$linhas = $resultado->rowCount();
if (!$linhas) {
echo message('info', 'Ooops!', TRANS('TXT_NOT_FOUND_EQUIP_CAD_SYSTEM'), '', '', 1);
return;
}
$row = $resultado->fetch();
?>
= TRANS('COL_UNIT'); ?>: = $row['instituicao_nome']; ?>
= TRANS('ASSET_TAG_TAG'); ?>: = $row['etiqueta']; ?>
= TRANS('FIELD_TYPE_EQUIP'); ?>: = $row['equipamento']; ?>
fetchall() as $row) {
$currentLocation = '';
if ($i == 1) {
$currentLocation = ''. TRANS('CURRENT_DEPARTMENT') .'';
}
?>
| = $i; ?> |
= $row['locais'] . " " . $currentLocation ?> |
">= $row['DIA']."/".$row['MES']."/".$row['ANO']; ?> |