DAOVerba PHP代码示例

示例#1

0

显示文件

文件： altVerba.php 项目： GolfinhoPvP/lokorez

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" />

示例#2

0

显示文件

文件： cadAverbacao.php 项目： GolfinhoPvP/lokorez

$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;
    }

示例#3

0

显示文件

文件： cadVerba.php 项目： GolfinhoPvP/lokorez

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" />

示例#4

0

显示文件

文件： delVerba.php 项目： GolfinhoPvP/lokorez

<?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">
			<!--

示例#5

0

显示文件

文件： getVerbaAlt.php 项目： GolfinhoPvP/lokorez

<?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!";
}

示例#6

0

显示文件

文件： pesVerba.php 项目： GolfinhoPvP/lokorez

<?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(){

PHP DAOVerba示例