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