public function getTop() { /** * @TODO: FIX IT * I don't know WHY but I couldn't add the upvoteTotal in the UserEntity... * THUS, I have done a workaround thought out RAW SQL */ $result = $this->repository->getTop(); $data = array(); foreach ($result as $row) { $user = new User(); $user->setId($row['id']); $user->setFirstname($row['firstname']); $user->setLastname($row['lastname']); $user->setUsername($row['username']); $user->setPicturePath($row['picture_path']); $user->setUpvoteTotal($row['upvote_total']); $data[] = $user; } return $data; }