public static function getUserById($user_id)
{
return DAL::getUserById($user_id);
}
static function getCommentsAdventure($id)
{
$req = 'SELECT * FROM comment WHERE adventure_id=?';
$param = array(0 => array($id, PDO::PARAM_INT));
$res = DB::getInstance()->prepareAndExecuteQueryWithResult($req, $param);
$comments = array();
foreach ($res as $data) {
$text = $data["content"];
$user = DAL::getUserById($data["user_id"]);
$comments[] = new Comment($user->getUsername(), $text);
}
return $comments;
}
public static function getUserAdventures($user_id)
{
$adventures = DAL::getUserAdventures($user_id);
$photos = array();
$tags = array();
$comments = array();
$nAdventures = array();
$i = 0;
foreach ($adventures as $adventure) {
$nbVotes = DAL::countVotesForAdventure($adventure->getId());
$photos = DAL::getPhotosAdventure($adventure->getId());
$tags = DAL::getTagsAdventure($adventure->getId());
$comments = DAL::getCommentsAdventure($adventure->getId());
$author = DAL::getUserById($adventure->getUser_id());
$adventure->setNumberOfVotes($nbVotes);
$adventure->setTags($tags);
$adventure->setPhotos($photos);
$adventure->setComments($comments);
$adventure->setAuthor($author->getUsername());
$nAdventures[] = $adventure;
}
return $nAdventures;
}
