//$libros = LibroQuery::create()->find(); //$usuarios = UsuarioQuery::create()->find(); switch ($_POST["accion"]) { case "e": //Edit $audiolibroObj = AudiolibroQuery::create()->findOneBy($_POST["id"]); //$usuarioObj = UsuarioQuery::create()->findOneById($datos->id); //echo $usuarioObj->toArray(); $audiolibroObj->setNombre($_POST["nombreaudio"]); //$audiolibroObj->setHash($datosaudio->hasharchivo); $audiolibroObj->save(); echo json_encode(array('error' => 0, 'msg' => "Audiolibro modificado correctamente")); break; case "d": //Delete $audiolibroObj = AudiolibroQuery::create()->findOneBy($_POST["id"]); //$objTerapia = TerapiasQuery::create()->findOneById($_GET["id"]); if ($audiolibroObj != null) { $audiolibroObj->delete(); } echo json_encode(array('error' => 0, 'msg' => "Audiolibro borrado correctamente")); break; case "n": //New $audiolibroObj = new Audiolibro(); $audiolibroObj->setNombre($_POST["nombreaudio"]); $audiolibroObj->setIdlibro($_POST["vinculolibro"]); $audiolibroObj->save(); $idLibro = $audiolibroObj->getId(); // obtenemos los datos del archivo $tamano = $_FILES["mp3"]['size'];
<?php //die; error_reporting(E_ALL); ini_set("display_errors", 1); include_once "../../data/config.php"; //$libros = LibroQuery::create()->findOneById($_GET['id']); //$usuarios = UsuarioQuery::create()->find(); $idusuario = $_SESSION['userid']; $usuario = UsuarioQuery::create()->findOneById($idusuario); $audiolibros = AudiolibroQuery::create()->find(); $idLibro = $_GET['id']; $libro = LibroQuery::create()->findOneById($idLibro); //echo $libro->getEs_editable(); //$options = "<option value = ''>Seleccione un libro</option> "; $listaaudios = ""; //$arr=array(); foreach ($audiolibros as $reg) { //if(!array_key_exists($reg->getId(), $arr)){ //$arr[$reg->getId()] = ""; $listaaudios .= "<li>" . $reg->getNombre() . "</li>"; //$options .= "<option value = '".$reg->getId()."'>".$reg->getNombre()."</option> "; //$options .= "<option value = '".$reg->getId()."'>".$reg->getNombre()."</option> "; //$options .= "<option value = '".$reg->getId()."'>".$reg->getNombre()."</option> "; //} } //echo $listaLibros; //$listaLibros = ""; //$libros = LibroQuery::create()->find(); ?> <table>
//die; error_reporting(E_ALL); ini_set("display_errors", 1); include_once "../../data/config.php"; //$libros = LibroQuery::create()->findOneById($_GET['id']); //$usuarios = UsuarioQuery::create()->find(); $idusuario = $_SESSION['userid']; $usuario = UsuarioQuery::create()->findOneById($idusuario); $idLibro = $_GET['id']; $libro = LibroQuery::create()->findOneById($idLibro); if ($libro->getDebaja() != NULL) { echo "<h1>El libro al que esta intentando acceder se encuentra bloqueado por el administrador</h1>"; die; } $audiolibros = AudiolibroQuery::create()->filterByIdlibro($idLibro)->find(); //obtengo la puntuación del libro $puntaje = 0; $calificacionLibro = CalificacionQuery::create()->filterById_libro($idLibro)->find(); foreach ($calificacionLibro as $reg) { $puntaje += $reg->getPuntuacion(); } $cantidadVotos = $calificacionLibro->count(); if ($cantidadVotos != 0) { $promedioPuntaje = round($puntaje / $cantidadVotos, 1); } $votoPropio = CalificacionQuery::create()->filterById_libro($idLibro)->filterById_usuario($idusuario)->find()->count(); //echo $libro->getEs_editable(); //$options = "<option value = ''>Seleccione un libro</option> "; $listaaudios = ""; //$arr=array();
/** * Removes this object from datastore and sets delete attribute. * * @param PropelPDO $con * @return void * @throws PropelException * @see BaseObject::setDeleted() * @see BaseObject::isDeleted() */ public function delete(PropelPDO $con = null) { if ($this->isDeleted()) { throw new PropelException("This object has already been deleted."); } if ($con === null) { $con = Propel::getConnection(AudiolibroPeer::DATABASE_NAME, Propel::CONNECTION_WRITE); } $con->beginTransaction(); try { $deleteQuery = AudiolibroQuery::create()->filterByPrimaryKey($this->getPrimaryKey()); $ret = $this->preDelete($con); if ($ret) { $deleteQuery->delete($con); $this->postDelete($con); $con->commit(); $this->setDeleted(true); } else { $con->commit(); } } catch (Exception $e) { $con->rollBack(); throw $e; } }
/** * Get the associated Audiolibro object * * @param PropelPDO Optional Connection object. * @return Audiolibro The associated Audiolibro object. * @throws PropelException */ public function getAudiolibro(PropelPDO $con = null) { if ($this->aAudiolibro === null && $this->id_audiolibro !== null) { $this->aAudiolibro = AudiolibroQuery::create()->findPk($this->id_audiolibro, $con); /* The following can be used additionally to guarantee the related object contains a reference to this object. This level of coupling may, however, be undesirable since it could result in an only partially populated collection in the referenced object. $this->aAudiolibro->addLista_audiolibros($this); */ } return $this->aAudiolibro; }
/** * Returns the number of related Audiolibro objects. * * @param Criteria $criteria * @param boolean $distinct * @param PropelPDO $con * @return int Count of related Audiolibro objects. * @throws PropelException */ public function countAudiolibros(Criteria $criteria = null, $distinct = false, PropelPDO $con = null) { if (null === $this->collAudiolibros || null !== $criteria) { if ($this->isNew() && null === $this->collAudiolibros) { return 0; } else { $query = AudiolibroQuery::create(null, $criteria); if ($distinct) { $query->distinct(); } return $query->filterByLibro($this)->count($con); } } else { return count($this->collAudiolibros); } }
function traerAudiolibros($busqueda) { $audiolibroObj = AudiolibroQuery::create()->findOneBy($_POST["id"]); }