public function getComentariosByIdPost($idPost = null)
{
$sql = 'SELECT *
FROM comentario';
$sqlQuery = new SqlQuery($sql);
if ($idPost) {
$sqlQuery->addWhere('id_post = ?');
$sqlQuery->setNumber($idPost);
}
return $this->getList($sqlQuery);
}
/**
* Get Domain object by IdPost
*
* @param String $idPost
* @return PostMySql
*/
public function getPosts($idCategoria = null, $idPost = null, $emailUsuario = null)
{
$sql = 'SELECT p.id_post, p.titulo, p.texto, p.data, p.id_categoria, u.email, c.nome
FROM post p
INNER JOIN categoria c ON ( p.id_categoria = c.id_categoria )
INNER JOIN usuario u ON ( p.id_usuario = u.id_usuario )';
$sqlQuery = new SqlQuery($sql);
if ($idCategoria) {
$sqlQuery->addWhere('c.id_categoria = ?');
$sqlQuery->setNumber($idCategoria);
}
if ($idPost) {
$sqlQuery->addWhere('p.id_post = ?');
$sqlQuery->setNumber($idPost);
}
if ($emailUsuario) {
$sqlQuery->addWhere('u.email = ?');
$sqlQuery->set($emailUsuario);
}
return $this->getList($sqlQuery);
}
