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