PHP ResponsavelDAO Beispiele

Beispiel #1

Datei: new.php Projekt: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/ResponsavelDAO.php';
include_once '../Responsavel.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
if (!in_array(192, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="index.php";</script>';
}
$responsavel = new Responsavel();
$DAO = new ResponsavelDAO();
//Verifica se a acao de salvar foi iniciada
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'inserir') {
    // 	$responsavel->setUsuario(userId());
    $responsavel->setResponsavel($_POST['responsavel']);
    $responsavel->setSetor($_POST['setor']);
    $resultado = $DAO->Gravar($responsavel);
    if ($resultado == 1) {
        echo '<script language= "JavaScript">alert("Registro cadastrado com sucesso");</script>';
        echo '<script language= "JavaScript">location.href="new.php";</script>';
    } else {
        echo '<script language="JavaScript">alert("Erro ao salvar");</script>';
    }
}
?>
<!-- topbar ends -->
<div class="container-fluid">
	<div class="row-fluid"> 

Beispiel #2

Datei: edit.php Projekt: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/ResponsavelDAO.php';
include_once '../Responsavel.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
if (!in_array(193, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="index.php";</script>';
}
$responsavel = new Responsavel();
$DAO = new ResponsavelDAO();
//Verifica se a acao de salvar foi iniciada
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'editar') {
    // 	$responsavel->setUsuario(userId());
    $responsavel->setResponsavel($_POST['responsavel']);
    $responsavel->setSetor($_POST['setor']);
    $responsavel->setId($_POST['id']);
    $resultado = $DAO->Atualizar($responsavel);
    if ($resultado == 1) {
        echo '<script language= "JavaScript">alert("Registro cadastrado com sucesso");</script>';
        echo '<script language= "JavaScript">location.href="new.php";</script>';
    } else {
        echo '<script language="JavaScript">alert("Erro ao salvar");</script>';
    }
} else {
    $id = limpaTexto($_GET['id']);
    $resultado = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_RESPONSAVEIS . " WHERE id = " . $id);
    if ($resultado) {
        foreach ($resultado as $item) {

Beispiel #3

Datei: index.php Projekt: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/ResponsavelDAO.php';
include_once '../Responsavel.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
if (!in_array(191, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
$DAO = new ResponsavelDAO();
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') {
    $id = ValidateInteger(INPUT_GET, 'id');
    $retorno = $DAO->Deletar($id);
    if ($retorno == 1) {
        echo '<script language= "JavaScript">alert("Registro removido com sucesso");</script>';
        echo '<script language= "JavaScript">location.href="index.php";</script>';
    } else {
        print_r($retorno);
    }
}
?>
	<!-- topbar ends -->
		<div class="container-fluid">
		<div class="row-fluid">
				
			<!-- left menu starts -->
			<div class="span2 main-menu-span">
				<?php 
include_once '../menu.php';