public function generarCodigos(Establecimiento $esta, $numCod)
{
$pr = 1;
$stmt = $this->db->prepare("SELECT * FROM codigo WHERE ?");
$stmt->execute(array($pr));
$cods = $stmt->fetchAll(PDO::FETCH_ASSOC);
$num = 0;
foreach ($cods as $cod) {
if ($num < $cod["id_codigo"]) {
$num = $cod["id_codigo"];
}
}
for ($i = 1; $i <= $numCod; $i++) {
$stmt = $this->db->prepare("INSERT INTO codigo(FK_establecimiento_cod, id_codigo, usado) VALUES (?,NULL,0)");
$stmt->execute(array($esta->getId()));
}
$stmt2 = $this->db->prepare("SELECT * FROM codigo WHERE id_codigo>?");
$stmt2->execute(array($num));
$cod_bd = $stmt2->fetchAll(PDO::FETCH_ASSOC);
$cods = array();
foreach ($cod_bd as $cod) {
array_push($cods, new Codigo($cod["FK_establecimiento_cod"], $cod["id_codigo"], $cod["usado"]));
}
return $cods;
}
public function setEstablecimiento(Establecimiento $v = null)
{
if ($v === null) {
$this->setFkEstablecimientoId(0);
} else {
$this->setFkEstablecimientoId($v->getId());
}
$this->aEstablecimiento = $v;
if ($v !== null) {
$v->addConcepto($this);
}
return $this;
}
public static function addInstanceToPool(Establecimiento $obj, $key = null)
{
if (Propel::isInstancePoolingEnabled()) {
if ($key === null) {
$key = (string) $obj->getId();
}
self::$instances[$key] = $obj;
}
}
public static function pinchoValido(Establecimiento $esta)
{
$db = PDOConnection::getInstance();
$req = $db->prepare("SELECT * FROM pincho WHERE validado=1 AND FK_establecimiento_pinc =?");
$req->execute(array($esta->getId()));
$pincho = $req->fetch();
if ($pincho != NULL) {
return new Pincho($pincho['nombre'], $pincho['celiaco'], $pincho['descripcion'], $pincho['num_votos'], $pincho["FK_establecimiento_pinc"], $pincho['id_pincho'], $pincho['validado'], $pincho['FK_concurso_pinc']);
} else {
return NULL;
}
}
