/**
* Retorna o itens da paginação
*
* @param int $iInicioPaginacao
* @param int $iItensPorPagina
* @return array
*/
public function getItems($iInicioPaginacao, $iItensPorPagina)
{
$this->_query->setFirstResult($iInicioPaginacao);
$this->_query->setMaxResults($iItensPorPagina);
$aResultado = $this->_query->getQuery()->getResult();
$aRetorno = array();
foreach ($aResultado as $sModelo) {
$aRetorno[] = new $this->_modelName($sModelo);
}
return $aRetorno;
}
public function getItems($offset, $itemCountPerPage)
{
$this->_query->setFirstResult($offset);
$this->_query->setMaxResults($itemCountPerPage);
$a = $this->_query->getQuery()->getResult();
$r = array();
foreach ($a as $i) {
$r[] = new $this->_modelName($i);
}
return $r;
}
/**
* Returns the whole aggregated feed. You can limit the list giving any number.
*
* @return List<UnifiedSocialEntityInterface>
*/
public function getFeed($limit = false)
{
if ($limit !== false && is_int($limit)) {
$this->qb->setMaxResults($limit);
}
$this->qb->andWhere('e.approved = 1');
return $this->qb->getQuery()->getResult();
}
/**
* Returns items matching the given criteria
*
* @param int $offset Page offset
* @param int $itemCountPerPage Number of items per page
* @return array
*/
public function getItems($offset, $itemCountPerPage)
{
if ($offset > 0) {
$this->query->setFirstResult($offset);
}
$this->query->setMaxResults($itemCountPerPage);
return $this->query->select('e')->getQuery()->getResult();
}
/**
* Set the page with paginate attribute.
*
* @param int $page
* @param int $limit
*
* @return $this
*/
public function paginate($limit = 25, $page = 0)
{
if ($limit > 0) {
$this->queryBuilder->setMaxResults($limit);
}
if ($page > 0) {
$this->queryBuilder->setFirstResult($page * $limit);
}
return $this;
}
/**
* Returns the whole aggregated feed. You can limit the list giving any number.
*
* @param bool $onlyApproved if only approved elements should be returned. default is true.
* @param int $limit how many items should be fetched at maximum
* @param array $requestIds which requestIds should be fetched, if left empty all are fetched
* @return array<TwitterEntityInterface> List of twitter entities
*/
public function getFeed($onlyApproved = true, $limit = false, array $requestIds = array())
{
$result = array();
foreach ($this->apiRequests as $request) {
if (count($requestIds) > 0 && !in_array($request->getId(), $requestIds)) {
continue;
}
$this->initializeQueryBuilder($request->getId());
if ($limit !== false && is_int($limit)) {
$this->qb->setMaxResults($limit);
}
if ($onlyApproved) {
$this->qb->andWhere('e.approved = true');
}
$this->qb->andWhere('e.requestId = :requestId')->setParameter('requestId', $request->getId());
$result = array_merge($result, $this->qb->getQuery()->getResult());
}
return $result;
}
public function getListWishedBooks($userId, $limit, $useCache)
{
$cacheId = $this->getCacheId(__FUNCTION__, array($userId));
$queryBuilder = new \Doctrine\ORM\QueryBuilder($this->entityManager);
$queryBuilder->select("ub, u, b, r, p, c")->from(self::MODEL, "ub")->join("ub.user", "u")->join("ub.book", "b")->leftJoin("ub.reading_state", "r")->leftJoin("b.publisher", "p")->leftJoin("b.contributors", "c")->orderBy("ub.id", "DESC")->where("u.id = :id")->andWhere("ub.is_deleted = 0")->andWhere("ub.is_wished = 1")->setParameter("id", $userId);
if ($limit != -1) {
$queryBuilder->setMaxResults($limit);
}
$result = $this->getResults($queryBuilder->getQuery(), $cacheId, $useCache);
return $result;
}