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'], 3, 2); ?> <?= APP_NAME; ?> <?= VERSAO; ?> query($query); $row = $resultado->fetch(); if (!$row) { // echo message ('warning','Ooops!', TRANS('NO_RECORDS_FOUND'), '', '', 1); // return; /* Se não achar o equipamento, checará se existe o componente com a etiqueta fornecida */ $sql = "SELECT estoq_cod FROM estoque WHERE estoq_tag_inv = '{$tag}' AND estoq_tag_inst = '{$unit}'"; $result = $conn->query($sql); if ($result->rowCount()) { $rowEstoq = $result->fetch(); redirect('../../invmon/geral/peripheral_show.php?cod='.$rowEstoq['estoq_cod'].'&origin=modal'); return; } echo message ('warning','Ooops!', TRANS('NO_RECORDS_FOUND'), '', '', 1); return; } // dump($query); // var_dump([ // 'row' => $row, // ]); exit(); /* Para manter a compatibilidade com versões antigas */ $qryPieces = $QRY["componentexequip_ini"]; $table = "equipxpieces"; $sqlTest = "SELECT * FROM {$table}"; try { $conn->query($sqlTest); } catch (Exception $e) { $table = "equipXpieces"; $qryPieces = $QRY["componenteXequip_ini"]; } /* Componentes avulsos */ // $qryPieces = $QRY["componenteXequip_ini"]; $qryPieces .= " and eqp.eqp_equip_inv in ('" . $tag . "') and eqp.eqp_equip_inst=" . $unit . ""; $qryPieces .= $QRY["componenteXequip_fim"]; // dump($qryPieces); $resultPieces = $conn->query($qryPieces); $pieces = $resultPieces->rowCount(); /* Arquivos associados ao modelo*/ $sqlFilesModel = "SELECT i.* FROM imagens i WHERE i.img_model ='" . $row['modelo_cod'] . "' order by i.img_inv "; $resFilesModel = $conn->query($sqlFilesModel); $hasFilesFromModel = $resFilesModel->rowCount(); /* Arquivos associados diretamente ao equipamento */ $sqlFilesEquipment = "SELECT i.* FROM imagens i WHERE i.img_inst ='".$row['cod_inst']."' AND i.img_inv ='".$row['etiqueta']."' ORDER BY i.img_inv "; $resFilesEquipment = $conn->query($sqlFilesEquipment); $hasFilesFromEquipment = $resFilesEquipment->rowCount(); /* Arquivos nos chamados relacionados */ $sqlFiles = "SELECT o.*, i.* FROM ocorrencias o , imagens i WHERE (i.img_oco = o.numero) AND (o.equipamento ='" . $tag . "' AND o.instituicao ='" . $unit . "') ORDER BY o.numero "; $resultFiles = $conn->query($sqlFiles); $hasFilesFromTickets = $resultFiles->rowCount(); /* Definições do grid */ $colLabel = "col-sm-3 text-md-right font-weight-bold p-2"; $colsDefault = "small text-break border-bottom rounded p-2 bg-white"; /* border-secondary */ $colContent = $colsDefault . " col-sm-3 col-md-3"; $colContentLine = $colsDefault . " col-sm-9"; ?>

0 ? '' : ' disabled'); $ariaDisabledPieces = ($pieces > 0 ? '' : ' true'); $classDisabledFilesFromEquipment = ($hasFilesFromEquipment > 0 ? '' : ' disabled'); $ariaDisabledFilesFromEquipment = ($hasFilesFromEquipment > 0 ? '' : ' true'); $classDisabledFilesFromModel = ($hasFilesFromModel > 0 ? '' : ' disabled'); $ariaDisabledFilesFromModel = ($hasFilesFromModel > 0 ? '' : ' true'); $classDisabledFilesFromTickets = ($hasFilesFromTickets > 0 ? '' : ' disabled'); $ariaDisabledFilesFromTickets = ($hasFilesFromTickets > 0 ? '' : ' true'); ?>
fetchAll() as $rowPiece) { $oldManufacturer = ($rowPiece['fabricante'] ? $rowPiece['fabricante'] . " " : ""); $manufacturer = ($rowPiece['fab_nome'] ? $rowPiece['fab_nome'] . " " : ""); ?>
#
fetchAll() as $rowFiles) { $size = round($rowFiles['img_size'] / 1024, 1); $rowFiles['img_tipo'] . "](" . $size . "k)"; if (isImage($rowFiles["img_tipo"])) { $viewImage = " "; } else { $viewImage = ""; } ?>
#
k
fetchAll() as $rowFiles) { $size = round($rowFiles['img_size'] / 1024, 1); $rowFiles['img_tipo'] . "](" . $size . "k)"; if (isImage($rowFiles["img_tipo"])) { $viewImage = " "; } else { $viewImage = ""; } ?>
#
k
fetchAll() as $rowFiles) { $size = round($rowFiles['img_size'] / 1024, 1); $rowFiles['img_tipo'] . "](" . $size . "k)"; if (isImage($rowFiles["img_tipo"])) { $viewImage = " "; } else { $viewImage = ""; } ?>
#
k