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