top.window.location = '../../index.php'"; exit; } require_once __DIR__ . "/" . "../../includes/include_basics_only.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, 1); $qry = $QRY["useropencall_custom"]; $qry .= " AND c.conf_cod = '" . $_SESSION['s_screen'] . "'"; $execqry = $conn->query($qry); $rowconf = $execqry->fetch(PDO::FETCH_ASSOC); $showLoadButton = false; $showSearchButton = false; if ((!empty($rowconf) && $rowconf['conf_scr_btloadlocal']) || empty($rowconf)) { $showLoadButton = true; } if ((!empty($rowconf) && $rowconf['conf_scr_searchbylocal']) || empty($rowconf)) { $showSearchButton = true; } if (isset($_GET['unidade']) && isset($_GET['etiqueta'])) { $qryDesc = "SELECT * FROM equipamentos where comp_inst = '" . (int)$_GET['unidade'] . "' AND comp_inv ='" . noHtml($_GET['etiqueta']) . "' "; $execDesc = $conn->query($qryDesc); $rowDesc = $execDesc->fetch(PDO::FETCH_ASSOC); } ?>
"; print ""; $query = "SELECT l . * , r.reit_nome, pr.prior_nivel AS prioridade, d.dom_desc AS dominio, pred.pred_desc as predio FROM localizacao AS l LEFT JOIN reitorias AS r ON r.reit_cod = l.loc_reitoria LEFT JOIN prioridades AS pr ON pr.prior_cod = l.loc_prior LEFT JOIN dominios AS d ON d.dom_cod = l.loc_dominio LEFT JOIN predios as pred on pred.pred_cod = l.loc_predio WHERE loc_status not in (0) ORDER BY LOCAL "; $resultado = $conn->query($query); $linhas = $resultado->rowCount(); foreach ($resultado->fetchAll(PDO::FETCH_ASSOC) as $rowi) { print ""; } print ""; if ($showSearchButton) { ?>