public function getEvent($user_id)
{
$dao = new dao();
try {
$query = "SELECT DISTINCT e.id,e.name,e.detail,e.location,e.photo,e.time,e.date FROM event as e, user as u, event_user as eu WHERE (eu.id_user='******' and e.id=eu.id_event and u.id=eu.id_user ) or e.id_autor='" . $user_id . "' order by e.date DESC limit 7 ";
$returnObject = $dao->genericQuery($query);
$returnObject = $this->addMultiData($returnObject);
return $returnObject;
// return $this->addPostData($returnObject);
} catch (Exception $e) {
throw new Exception("Failed geting the Posts, message: " . $e->getMessage());
}
}
public function getPost($user_id)
{
$dao = new dao();
try {
$query = "SELECT u.nick, u.id,u.photo,p.id_post,p.coment,p.media as media,pu.date FROM post as p, post_user as pu, user u WHERE \n u.id=pu.id_user and pu.id_post=p.id_post and (pu.id_user="******" or \n pu.id_user in (select id_follower from follow where id_user="******")) \n ORDER BY pu.date DESC limit 7 ";
$returnObject = $dao->genericQuery($query);
return $returnObject;
// return $this->addPostData($returnObject);
} catch (Exception $e) {
throw new Exception("Failed geting the Posts, message: " . $e->getMessage());
}
}
