session_start(); $nivelAcesso = "../../:2:3:4"; include_once "../../utils/controladorAcesso.php"; include_once "../../utils/funcoes.php"; $slVerRef = antiSQL(isset($_POST["slVerRef"]) ? $_POST["slVerRef"] : NULL); $tfVerba = antiSQL(isset($_POST["tfVerba"]) ? $_POST["tfVerba"] : NULL); $slEmpRef = antiSQL(isset($_POST["slEmpRef"]) ? $_POST["slEmpRef"] : NULL); $slBancRef = antiSQL(isset($_POST["slBancRef"]) ? $_POST["slBancRef"] : NULL); $slProRef = antiSQL(isset($_POST["slProRef"]) ? $_POST["slProRef"] : NULL); $tfVerDesc = antiSQL(isset($_POST["tfVerDesc"]) ? $_POST["tfVerDesc"] : NULL); if ($slVerRef != NULL && $tfVerba != NULL && $slEmpRef != NULL && $slBancRef != NULL && $slProRef != NULL && $tfVerDesc != NULL) { include_once "../../utils/ConectarMySQL.class.php"; $conexao = new ConectarMySQL(); include_once "../../dao/DAOVerba.class.php"; include_once "../../dao/DAOLog.class.php"; $dao = new DAOVerba($tfVerba, $slEmpRef, $slBancRef, $slProRef, $tfVerDesc, "../../", $conexao); $log = new DAOLog($_SESSION["pessoa"], 4, $_SESSION["nivel"], $_SESSION["codigo"], 9, "Log id=\\'" . $slVerRef . "\\'", "../../", $conexao); if ($dao->alterar($slVerRef) && $log->cadastrar()) { $conexao->commit(); } else { $conexao->rollback(); } header("Location: altVerba.php?alt=ok"); die; } $alt = antiSQL(isset($_GET["alt"]) ? $_GET["alt"] : NULL); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
$tfMon = antiSQL(isset($_POST["tfMon"]) ? $_POST["tfMon"] : NULL); $tfTxJ = antiSQL(isset($_POST["tfTxJ"]) ? $_POST["tfTxJ"] : NULL); $tfValor = antiSQL(isset($_POST["tfValor"]) ? $_POST["tfValor"] : NULL); if ($tfValor != NULL && $slSerRef != NULL && $tfNumExt != NULL && $slPer != NULL && $slPro != NULL && $slPar != NULL) { include_once "../../utils/ConectarMySQL.class.php"; $conexao = new ConectarMySQL(); $comitar = true; include_once "../../dao/DAOServidor.class.php"; $dao = new DAOServidor(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "../../", $conexao); if (!$dao->atualizarVerba($slSerRef, $tfValor)) { $comitar = false; } $val = explode(":", $slSerRef); $servidor = $dao->getServidor($val[0], $val[1]); include_once "../../dao/DAOVerba.class.php"; $dao = new DAOVerba(NULL, NULL, NULL, NULL, NULL, "../../", $conexao); $verba = $dao->getVerba($slPro); $data = date("Y-m-d H:i:s"); include_once "../../dao/DAOAverbacao.class.php"; if (strlen($tfMon) == 0) { $tfMon = 0; } if (strlen($tfTxJ) == 0) { $tfTxJ = 0; } $dao = new DAOAverbacao($tfNumExt, 'NULL', $servidor->getEmpCodigo(), $servidor->getPesCodigo(), $val[1], $_SESSION["banco"], $verba->getProCodigo(), $slPer, 1, $data, '0000-00-00', $slPar, $tfMon, $tfTxJ, "../../", $conexao); include_once "../../dao/DAOLog.class.php"; $log = new DAOLog($_SESSION["pessoa"], 3, $_SESSION["nivel"], $_SESSION["codigo"], 12, "noum ext=\\'" . $tfNumExt . "\\'", "../../", $conexao); if (!$dao->cadastrar() || !$log->cadastrar()) { $comitar = false; }
session_start(); $nivelAcesso = "../../:2:3:4"; include_once "../../utils/controladorAcesso.php"; include_once "../../utils/funcoes.php"; $tfVerba = antiSQL(isset($_POST["tfVerba"]) ? $_POST["tfVerba"] : NULL); $slEmpRef = antiSQL(isset($_POST["slEmpRef"]) ? $_POST["slEmpRef"] : NULL); $slBancRef = antiSQL(isset($_POST["slBancRef"]) ? $_POST["slBancRef"] : NULL); $slProRef = antiSQL(isset($_POST["slProRef"]) ? $_POST["slProRef"] : NULL); $tfVerDesc = antiSQL(isset($_POST["tfVerDesc"]) ? $_POST["tfVerDesc"] : NULL); if ($tfVerba != NULL && $slEmpRef != NULL && $slBancRef != NULL && $slProRef != NULL && $tfVerDesc != NULL) { include_once "../../utils/ConectarMySQL.class.php"; $conexao = new ConectarMySQL(); include_once "../../dao/DAOVerba.class.php"; include_once "../../dao/DAOLog.class.php"; $dao = new DAOVerba($tfVerba, $slEmpRef, $slBancRef, $slProRef, $tfVerDesc, "../../", $conexao); $log = new DAOLog($_SESSION["pessoa"], 3, $_SESSION["nivel"], $_SESSION["codigo"], 9, "id=\\'" . $tfVerba . "\\'", "../../", $conexao); if ($dao->cadastrar() && $log->cadastrar()) { $conexao->commit(); } else { $conexao->rollback(); } header("Location: cadVerba.php?cad=ok"); die; } $cad = antiSQL(isset($_GET["cad"]) ? $_GET["cad"] : NULL); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<?php session_start(); $nivelAcesso = "../../:2:3:4"; include_once "../../utils/controladorAcesso.php"; include_once "../../utils/funcoes.php"; $slVerRef = antiSQL(isset($_POST["slVerRef"]) ? $_POST["slVerRef"] : NULL); if ($slVerRef != NULL) { include_once "../../utils/ConectarMySQL.class.php"; $conexao = new ConectarMySQL(); include_once "../../dao/DAOVerba.class.php"; include_once "../../dao/DAOLog.class.php"; $dao = new DAOVerba(NULL, NULL, NULL, NULL, NULL, "../../", $conexao); $log = new DAOLog($_SESSION["pessoa"], 5, $_SESSION["nivel"], $_SESSION["codigo"], 9, "Log id=\\'" . $slVerRef . "\\'", "../../", $conexao); if ($dao->deletar($slVerRef) && $log->cadastrar()) { $conexao->commit(); } else { $conexao->rollback(); } header("Location: delVerba.php?del=ok"); die; } $alt = antiSQL(isset($_GET["del"]) ? $_GET["del"] : NULL); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <style type="text/css"> <!--
<?php session_start(); $nivelAcesso = "../../:2:3:4"; include_once "../../utils/controladorAcesso.php"; include_once "../../utils/funcoes.php"; $key = antiSQL(isset($_GET["key"]) ? $_GET["key"] : NULL); if ($key != NULL) { include_once "../../utils/ConectarMySQL.class.php"; $conexao = new ConectarMySQL(); include_once "../../dao/DAOVerba.class.php"; include_once "../../beans/Verba.class.php"; $dao = new DAOVerba(NULL, NULL, NULL, NULL, NULL, "../../", $conexao); $verba = new Verba(NULL, NULL, NULL, NULL, NULL); $verba = $dao->getVerba($key); $conexao->commit(); echo '<div id="A">' . $verba->getVerba() . '</div>'; echo '<div id="B">' . $verba->getEmpCodigo() . '</div>'; echo '<div id="C">' . $verba->getBanCodigo() . '</div>'; echo '<div id="D">' . $verba->getProCodigo() . '</div>'; echo '<div id="E">' . utf8_encode($verba->getDescricao()) . '</div>'; } else { echo "ERRO!"; }
<?php session_start(); $nivelAcesso = "../../:2:3:4"; include_once "../../utils/controladorAcesso.php"; include_once "../../utils/funcoes.php"; $slVerRef = antiSQL(isset($_POST["slVerRef"]) ? $_POST["slVerRef"] : NULL); if ($slVerRef != NULL) { include_once "../../utils/ConectarMySQL.class.php"; $conexao = new ConectarMySQL(); include_once "../../dao/DAOVerba.class.php"; include_once "../../beans/Verba.class.php"; $dao = new DAOVerba(NULL, NULL, NULL, NULL, NULL, "../../", $conexao); $verba = new Verba(NULL, NULL, NULL, NULL, NULL); $verba = $dao->getVerba($slVerRef); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <style type="text/css"> <!-- @import url("../../scripts/css/geral.css"); --> </style> <script type="text/javascript" language="javascript" src="../../scripts/javascript/ajax.js"></script> <script type="text/javascript" language="javascript" src="../../scripts/javascript/verba.js"></script> <script type="text/javascript" language="javascript"> window.onload = function(){