Ejemplo n.º 1
0
<?php

use app\model\CasaCaracteristica;
use app\repository\CaracteristicaRepository;
use app\repository\CasaCaracteristicaRepository;
use app\repository\EstadoRepository;
require_once '../../repository/EstadoRepository.php';
require_once '../../repository/CaracteristicaRepository.php';
require_once '../../repository/CasaCaracteristicaRepository.php';
require_once '../../model/Estado.php';
require_once '../../model/Caracteristica.php';
require_once '../../model/CasaCaracteristica.php';
require_once '../../repository/Connection.php';
$estadoRepository = new EstadoRepository();
$estado = $estadoRepository->getOneByName("Valida");
$caracteristicaRepository = new CaracteristicaRepository();
$caracteristicas = $caracteristicaRepository->getAllByEstado($estado->getId());
foreach ($caracteristicas as $c) {
    if (isset($_POST[$c->getId()])) {
        $casaCaracteristica = new CasaCaracteristica();
        $casaCaracteristica->setDescripcion(null);
        $casaCaracteristica->setIdCasa($_POST['idCasa']);
        $casaCaracteristica->setIdCaracteristica($c->getId());
        $casaCaracteristicaRepository = new CasaCaracteristicaRepository();
        $casaCaracteristicaRepository->insert($casaCaracteristica);
    }
}
header("location: ../../casa_list.php");
require_once '../../repository/CaracteristicaRepository.php';
require_once '../../repository/CasaCaracteristicaRepository.php';
require_once '../../model/Estado.php';
require_once '../../model/Caracteristica.php';
require_once '../../model/CasaCaracteristica.php';
require_once '../../repository/Connection.php';
$estadoRepository = new EstadoRepository();
$estado = $estadoRepository->getOneByName("Valida");
$caracteristicaRepository = new CaracteristicaRepository();
$caracteristicas = $caracteristicaRepository->getAllByEstado($estado->getId());
foreach ($caracteristicas as $c) {
    $idCasa = $_POST['idCasa'];
    $idCaracteristica = $c->getId();
    $casaCaracteristicaRepository = new CasaCaracteristicaRepository();
    $casaCaracteristica = $casaCaracteristicaRepository->getOneByCasaAndCaracteristica($idCasa, $idCaracteristica);
    if (isset($casaCaracteristica) && !is_null($casaCaracteristica->getId())) {
        echo $casaCaracteristica->getId();
        if (!isset($_POST[$c->getId()])) {
            $casaCaracteristicaRepository->delete($casaCaracteristica->getId());
        }
    } else {
        if (isset($_POST[$c->getId()])) {
            $casaCaracteristica = new CasaCaracteristica();
            $casaCaracteristica->setDescripcion(null);
            $casaCaracteristica->setIdCasa($idCasa);
            $casaCaracteristica->setIdCaracteristica($idCaracteristica);
            $casaCaracteristicaRepository->insert($casaCaracteristica);
        }
    }
}
header("location: ../../casa_list.php");
 public function getOneByCasaAndCaracteristica($idCasa, $idCaracteristica)
 {
     $casaCaracteristica = new CasaCaracteristica();
     $mysqli = new mysqli(Connection::DBHOST, Connection::DBUSERNAME, Connection::DBPASS, Connection::DBNAME);
     $query = "SELECT id, id_casa, id_caracteristica, descripcion FROM casa_caracteristica\n                  WHERE id_casa=? and id_caracteristica=?";
     $statement = $mysqli->prepare($query);
     $statement->bind_param("ii", $idCasa, $idCaracteristica);
     if ($statement->execute()) {
         $statement->bind_result($id, $idCasas, $idCaracteristicas, $descripcion);
         $statement->fetch();
         $casaCaracteristica->setId($id);
         $casaCaracteristica->setIdCasa($idCasas);
         $casaCaracteristica->setIdCaracteristica($idCaracteristicas);
         $casaCaracteristica->setDescripcion($descripcion);
     }
     $statement->close();
     $mysqli->close();
     return $casaCaracteristica;
 }