dao.tar

dao/class/conecta.php0000664000175000017500000000112113663531600015221 0ustar  teleckentelecken<?php

class DAO{
   
    function conectaBD() {
        $servername = "127.0.0.1";
        $port = "";
        $username = "postgres";
        $password = "postgres";
        $dbname = "loja";
        
        try {
            $conn = new PDO("pgsql:host=$servername;dbname=$dbname;user=$username;password=$password");
            // setar PDO error mode para exception
            $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            return $conn;
        }
        catch(PDOException $e){
            echo "Erro na Conexao: " . $e->getMessage();
        }
    }
}
?>dao/class/cliente.php0000664000175000017500000000562114234044005015232 0ustar  teleckentelecken<?php
require_once('../class/conecta.php');
class cliente {
    private $cod;
    private $nome;
    private $cpf;

    public function __construct($nome, $cpf){
        $this->nome = $nome;
        $this->cpf = $cpf;
    }
    public function getCod(){
        return $this->cod;
    }
    public function getNome(){
        return $this->nome;
    }  
    public function getCpf(){
        return $this->cpf;
    }      
    public function setNome($nome){
        $this->nome = $nome;
    }
    public function setCpf($cpf){
        $this->cpf = $cpf;
    }
    public function setCod($cod){
        $this->cod = $cod;
    }    
}
class clienteDao extends DAO {
    public function inserir($cliente){
        $con=$this->conectaBD();
        $sql = "INSERT INTO cliente (nome, cpf) VALUES (?, ?)";
        $stm = $con->prepare($sql);
        $stm->bindValue(1,$cliente->getNome());
        $stm->bindValue(2,$cliente->getCpf());
        $res = $stm->execute();
        $stm->closeCursor();
        $stm = NULL;
        $con = NULL;
        return $res;
    }
    public function deletar($cliente){
        $con = $this->conectaBD();
        $sql = "DELETE FROM cliente WHERE codigo = ?";
        $stm = $con->prepare($sql);
        $stm->bindValue(1,$cliente->getCod());
        $res = $stm->execute();
        $stm->closeCursor();
        $stm = NULL;
        $con = NULL;
        return $res;
    }
    public function alterar($cliente){
        $con=$this->conectaBD();
        $sql="UPDATE cliente SET nome = ?, cpf = ? WHERE codigo = ? ";
        $stm = $con->prepare($sql);
        $stm->bindValue(1,$cliente->getNome());
        $stm->bindValue(2,$cliente->getCpf());
        $stm->bindValue(3,$cliente->getCod());
        $result = $stm->execute();
        
        $stm->closeCursor();
        $stm = NULL;
        $con = NULL;
    }
    public function listaClientes(){
        $con = $this->conectaBD();
        $sql = "SELECT * FROM cliente";
        $stm = $con->prepare($sql);
        $tabela=$stm->execute();
        $clientes = array();
        if($tabela){	
            while($linha = $stm->fetch(PDO::FETCH_ASSOC)){
                $cli = new Cliente($linha['nome'],$linha['cpf']);
                $cli->setCod(intval($linha['codigo']));
                array_push($clientes,$cli);
            }
        }
        $stm->closeCursor();
        $stm=NULL;
        $con = NULL;
        return $clientes;
    }

    public function buscarCli($cod){
        $con = $this->conectaBD();
        $sql = "SELECT * FROM cliente WHERE codigo = ?";
        $stm = $con->prepare($sql);
        $stm->bindValue(1,$cod);
        $tabela = $stm->execute();
        if($tabela ){
            $linha = $stm->fetch(PDO::FETCH_ASSOC);
            $cli = new cliente($linha['nome'],$linha['cpf']);
            $cli->setCod(intval($linha['codigo']));
        }
        $stm->closeCursor();
        $stm=NULL;
        $con = NULL;
        return $cli;
    } 
}
?>dao/class/dependente.php0000664000175000017500000000723014234046173015730 0ustar  teleckentelecken<?php
require_once('../class/conecta.php');
require_once('../class/cliente.php');
class Dependente {
    private $cod;
    private $nome;
    private $relacao;
    private $cliente;

    public function __construct($nome, $relacao){
        $this->nome = $nome;
        $this->relacao = $relacao;
    }
    public function getCod(){
        return $this->cod;
    }
    public function getNome(){
        return $this->nome;
    }  
    public function getCliente(){
        return $this->cliente;
    }  
    public function getRelacao(){
        return $this->relacao;
    }     
    public function setNome($nome){
        $this->nome = $nome;
    }
    public function setCliente($cliente){
        $this->cliente = $cliente;
    }
    public function setRelacao($relacao){
        $this->relacao = $relacao;
    }
    public function setCod($cod){
        $this->cod = $cod;
    }    
}
class dependenteDao extends DAO {
    public function inserir($dependente){
        $con=$this->conectaBD(); 
        $sql = "INSERT INTO dependente (cliente, nome, relacao) VALUES (?, ?, ?)";
        $stm = $con->prepare($sql);
        $stm->bindValue(1,$dependente->getCliente()->getCod());
        $stm->bindValue(2,$dependente->getNome());
        $stm->bindValue(3,$dependente->getRelacao());
        $res = $stm->execute();
        $stm->closeCursor();
        $stm = NULL;
        $con = NULL;
        return $res;
    }
    public function deletar($dependente){
        $con = $this->conectaBD();
        $sql = "DELETE FROM dependente WHERE codigo = ?";
        $stm = $con->prepare($sql);
        $stm->bindValue(1,$dependente->getCod());
        $res = $stm->execute();
        $stm->closeCursor();
        $stm = NULL;
        $con = NULL;
        return $res;
    }
    public function alterar($dependente){
        $con=$this->conectaBD();
        $sql="UPDATE dependente SET cliente = ?, nome = ?, relacao = ? WHERE codigo = ? ";

        $stm = $con->prepare($sql);
        $stm->bindValue(1,$dependente->getCliente()->getCod());
        $stm->bindValue(2,$dependente->getNome());
        $stm->bindValue(3,$dependente->getRelacao());
        $stm->bindValue(4,$dependente->getCod());
        $result = $stm->execute();
        
        $stm->closeCursor();
        $stm = NULL;
        $con = NULL;
    }

    
    public function listaDependentes(){
        $con = $this->conectaBD();
        $depDao= new dependenteDao;
        $cliDao= new clienteDao;

        $sql = "SELECT * FROM dependente";
        $stm = $con->prepare($sql);
        $tabela=$stm->execute();

        $dependentes = array();
        if($tabela){	
            while($linha = $stm->fetch(PDO::FETCH_ASSOC)){
                $dep = new Dependente($linha['nome'],$linha['relacao']);
                $dep->setCod(intval($linha['codigo']));
                $dep->setCliente($cliDao->buscarCli($linha['cliente']));
                
                array_push($dependentes,$dep);
            }
        }
        $stm->closeCursor();
        $stm=NULL;
        $con = NULL;
        return $dependentes;
    }

    public function buscarDep ($cod){
    
        $con = $this->conectaBD();
        $cliDao= new clienteDao;
        $sql = "SELECT * FROM dependente WHERE codigo = ?";
        $stm = $con->prepare($sql);
        $stm->bindValue(1,$cod);
        $tabela = $stm->execute();
        if($tabela ){
            $linha = $stm->fetch(PDO::FETCH_ASSOC);
            $dep = new Dependente($linha['nome'],$linha['relacao']);
            $dep->setCod(intval($linha['codigo']));
            $dep->setCliente($cliDao->buscarCli($linha['cliente']));
        }
        $stm->closeCursor();
        $stm=NULL;
        $con = NULL;
        return $dep;
    } 
}
?>dao/cliente/insereCli1.php0000664000175000017500000000255314224157257016141 0ustar  teleckentelecken<?php
ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(E_ALL);

 ?>

<!DOCTYPE html>
<html lang="pt-br">
    <head>
        <title>Inserir</title>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
    </head>
    <body>
        <div class="container">
            <h2>Inserir</h2>
            <form action="insereCli2.php" method="post">
                <div class="form-group">
                    <label for="nome">Nome:</label>
                    <input type="text" class="form-control" id="nome" name="nome" value="">
                </div>
                <div class="form-group">
                    <label for="cpf">CPF:</label>
                    <input type="text" class="form-control" id="cpf" name="cpf" value="">
                </div>
                <button type="submit" class="btn btn-primary">Inserir</button>
            </form>
        </div>
    </body>
</html>
dao/cliente/alteraCli1.php0000664000175000017500000000345414234023304016107 0ustar  teleckentelecken<?php
ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(E_ALL);

require_once('../class/cliente.php');

$cod = intval($_GET['cod']);

$clienteDao=new clienteDAO();
$cli=$clienteDao->buscarCli($cod); ?>

<!DOCTYPE html>
<html lang="pt-br">
    <head>
        <title>PDO - Editar</title>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
    </head>
    <body>
        <div class="container">
            <h2>PDO - Editar</h2>
            <form action="alteraCli2.php" method="post">
                <div class="form-group">
                    <label for="codigo">Código:</label>
                    <input type="text" class="form-control" id="cod" name="cod" value="<?php echo $cli->getCod(); ?>" readonly>
                </div>
                <div class="form-group">
                    <label for="nome">Nome:</label>
                    <input type="text" class="form-control" id="nome" name="nome" value="<?php echo $cli->getNome();?>">
                </div>
                <div class="form-group">
                    <label for="cpf">CPF:</label>
                    <input type="text" class="form-control" id="cpf" name="cpf" value="<?php echo $cli->getCpf(); ?>">
                </div>
                <button type="submit" class="btn btn-primary">Salvar</button>
            </form>
        </div>
    </body>
</html>
dao/cliente/alteraCli2.php0000664000175000017500000000054714021166533016116 0ustar  teleckentelecken<?php
 ini_set('display_errors',1);
 ini_set('display_startup_errors',1);
 error_reporting(E_ALL);

require_once('../class/cliente.php');

$cod = intval($_POST['cod']);
$nome= $_POST['nome'];
$cpf= $_POST['cpf'];

$cli = new cliente($nome,$cpf);
$cli->setCod($cod);
$clidao = new clienteDAO();
$clidao->alterar($cli);
header("Location: ./mostraCli.php");


?>dao/cliente/mostraCli.php0000664000175000017500000000323514224156727016077 0ustar  teleckentelecken<?php
ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(E_ALL);

require_once('../class/cliente.php');

$clienteDao=new clienteDAO();
$clientes=$clienteDao->listaClientes(); ?>

<!DOCTYPE html>
<html lang="pt-br">
    <head>
        <title> Selecionar</title>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
    </head>
    <body>
        <div class="container">
            <h2>Selecionar</h2>
    
    <?php
    echo "<table class='table table-striped'>";
    echo "<tr>";
    echo "<th>Código</th>";
    echo "<th>Nome</th>";
    echo "<th>CPF</th>";
    echo "<th>Editar</th>";
    echo "<th>Excluir</th>";
    echo "</tr>";
    foreach ($clientes as $cli) {
        $codigo=$cli->getCod();
        $nome=$cli->getNome();
        $cpf=$cli->getCpf();
        

        echo "<tr>";
        echo "<td>$codigo</td>";
        echo "<td>$nome</td>";
        echo "<td>$cpf</td>";
        echo "<td><a href='alteraCli1.php?cod=$codigo'>Editar</a></td>";
        echo "<td><a href='deletaCli1.php?cod=$codigo'>Excluir</a></td>";
        echo "</tr>";

    } 
    
    echo "</table>";
    echo "<br><br><a href='./insereCli1.php'>Inserir</a>";
    ?>
    
        </div>
    </body>
</html>dao/cliente/deletaCli1.php0000664000175000017500000000045514234046715016106 0ustar  teleckentelecken<?php
 ini_set('display_errors',1);
 ini_set('display_startup_errors',1);
 error_reporting(E_ALL);

 require_once('../class/cliente.php');
$cod = intval($_GET['cod']);
$clienteDao=new clienteDAO();
$cli=$clienteDao->buscarCli($cod);
$clienteDao->deletar($cli);
header("Location: ./mostraCli.php");

?>dao/cliente/insereCli2.php0000664000175000017500000000046314021166510016123 0ustar  teleckentelecken<?php
ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(E_ALL);
require_once('../class/cliente.php');


$nome= $_POST['nome'];
$cpf= $_POST['cpf'];
$clienteDao=new clienteDAO();
$cli=new cliente($nome,$cpf);
$clienteDao->inserir($cli);
header("Location: ./mostraCli.php");
?>dao/dependente/editarDep.php0000664000175000017500000000475214234050427016527 0ustar  teleckentelecken<?php
require_once('../class/cliente.php');
require_once('../class/dependente.php');

$cod = intval($_GET['cod']);

$depDao=new dependenteDAO;
$cliDao=new clienteDao;
$dep=$depDao->buscarDep($cod);

?>

<!DOCTYPE html>
<html lang="pt-br">
    <head>
        <title>Editar</title>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
    </head>
    <body>
        <div class="container">
            <h2>Editar</h2>

<?php

	
        $codigoDep=$dep->getCod();
        $nomeDep=$dep->getNome();
        $relacao=$dep->getRelacao();  
        $codigoCli=$dep->getCliente()->getCod();  
        
	

?>
  
  <form method="POST" action="./editarDep2.php">
     
     <div class="form-group">
                    <label for="codigo">Código:</label>
                    <input type="text" class="form-control" id="codigo" name="codigo" value="<?php echo $codigoDep; ?>" readonly >
                </div>
                <div class="form-group">
                    <label for="nome">Nome:</label>
                    <input type="text" class="form-control" id="nome" name="nome" value="<?php echo $nomeDep; ?>">
                </div>
                <div class="form-group">
                    <label for="relacao">Relação:</label>
                    <input type="text" class="form-control" id="relacao" name="relacao" value="<?php echo $relacao; ?>">
                </div>
     
     <div class="form-group">
                    <label for="cliente">Cliente</label>
                    
     <select name="cliente" id="cliente" class="form-control">
     <?php
     
    $clientes=$cliDao->listaClientes();
    foreach ($clientes as $cliente) {
            $codigo = $cliente->getCod();
            $nomeCli = $cliente->getNome();
            if($codigo==$codigoCli)
                echo "<option selected value='$codigo'>$nomeCli</option>";
            else
                echo "<option value='$codigo'>$nomeCli</option>";
        }
    
?>
 </select>
</div>
    <input type="submit" name="submit" value="Alterar" class="btn btn-primary">
  </form>


</body>
</html>
dao/dependente/editarDep2.php0000664000175000017500000000060314234046303016576 0ustar  teleckentelecken<?php
require_once('../class/dependente.php');

$cod = $_POST['codigo'];
$nome= $_POST['nome'];
$relacao= $_POST['relacao'];
$cliente= $_POST['cliente'];


$depDao= new dependenteDao();
$cliDao= new clienteDao();

$dep = new dependente($nome,$relacao);
$dep->setCod($cod);
$dep->setCliente($cliDao->buscarCli($cliente));


$depDao->alterar($dep);
header("Location: mostrarDep.php");
?>

dao/dependente/excluirDep.php0000664000175000017500000000034514234024517016725 0ustar  teleckentelecken<?php
 require_once('../class/dependente.php');
 $cod = intval($_GET['cod']);
 $dependenteDao=new dependenteDAO();
 $dep=$dependenteDao->buscarDep($cod);
 $dependenteDao->deletar($dep);
 

header("Location: mostrarDep.php");
?>

dao/dependente/inserirDep.php0000664000175000017500000000311114234027341016715 0ustar  teleckentelecken<?php
require_once('../class/cliente.php');

$clienteDao=new clienteDAO();
$clientes=$clienteDao->listaClientes();

?>

<!DOCTYPE html>
<html lang="pt-br">
    <head>
        <title>Inserir</title>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
    </head>
    <body>
        <div class="container">
            <h2>Inserir</h2>


  <form method="POST" action="./inserirDep2.php">
     
  <div class="form-group">
    <label for="nome">Nome:</label>
    <input type="text" class="form-control"  id="nome" name="nome" value="">
  </div>
  <div class="form-group">
    <label for="cpf">Relação:</label>
    <input type="text" class="form-control" id="relacao" name="relacao" value="">
  </div>
  <div class="form-group">
    <label for="cliente">Cliente:</label>
     <select name="cliente" class="form-control">
     <?php
     
     foreach ($clientes as $cli) {
      $codigo=$cli->getCod();
      $nome=$cli->getNome();
      
      echo "<option value='$codigo'>$nome</option>";
    }
    
    
?>
 </select>



    <hr />
    <input type="submit" name="submit" value="inserir" class="btn btn-primary">
  </form>


</body>
</html>
dao/dependente/inserirDep2.php0000664000175000017500000000056214234031603017002 0ustar  teleckentelecken<?php
require_once('../class/cliente.php');
require_once('../class/dependente.php');

$nome= $_POST['nome'];
$relacao= $_POST['relacao'];
$cliente= $_POST['cliente'];

$depDao=new dependenteDAO();
$cli= new clienteDao;

$dep=new dependente($nome,$relacao);
$dep->setCliente($cli->buscarCli($cliente));
$depDao->inserir($dep);
  

header("Location: mostrarDep.php");
?>

dao/dependente/mostrarDep.php0000664000175000017500000000342614234023170016736 0ustar  teleckentelecken<!DOCTYPE html>
<html lang="pt-br">
    <head>
        <title>Selecionar</title>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
    </head>
    <body>
        <div class="container">
            <h2>Selecionar</h2>
        
<?php
require_once('../class/dependente.php');

$depDao=new dependenteDAO();
$dependentes=$depDao->listaDependentes();


        echo "<table class='table table-striped'>";
        echo "<tr>";
        echo "<th>Código</th>";
        echo "<th>Nome Dependente</th>";
        echo "<th>Cliente</th>";
        echo "<th>Relação</th>";
        echo "<th>Editar</th>";
        echo "<th>Excluir</th>";
        echo "</tr>";

	foreach ($dependentes as $dep) {
                $codigo=$dep->getCod();
                $nome=$dep->getNome();
                $relacao=$dep->getRelacao();
                $cliente=$dep->getCliente()->getNome();

        echo "<tr>";
        echo "<td> $codigo </td>";
        echo "<td> $nome </td>";
        echo "<td> $cliente </td>";
        echo "<td> $relacao </td>";
        echo "<td><a href='./editarDep.php?cod=$codigo'>Editar</a></td>";
        echo "<td><a href='./excluirDep.php?cod=$codigo'>Excluir</a></td>";
        echo "</tr>";

               
	}
        echo "</table>";

?>


<br><br><br>
<a href='./inserirDep.php' class="btn btn-primary">Inserir</a> 

</body>
</html>
dao/class/0000775000175000017500000000000014233751013013075 5ustar  teleckenteleckendao/cliente/0000775000175000017500000000000014021167016013412 5ustar  teleckenteleckendao/dependente/0000775000175000017500000000000014233750406014110 5ustar  teleckenteleckendao/0000775000175000017500000000000014235264645012004 5ustar  teleckentelecken