Zend Framework 2 Doctrine 2对结果进行分页

Question

我已经采用了Doctrine 2和ZF2安装，带分页，并尝试将搜索功能应用于该方法。

相册列表可通过常规路由http://myapp/album访问

我当前的代码似乎使用doctrine的createQueryBuilder()构建了一个可用的查询

当我没有给title/artist任何参数时，$qb->getDql();的结果是SELECT a FROM AlbumEntityAlbum a，它返回没有错误和分页结果fine。

我的方法;

public function indexAction()
{
  $view =  new ViewModel();
  $repository = $this->getEntityManager()->getRepository('AlbumEntityAlbum');
  $qb = $repository->createQueryBuilder('album');
  $qb->add('select', 'a')
     ->add('from', 'AlbumEntityAlbum a');
  if ($this->params()->fromQuery('title')) {
    $qb->add('where','title like :title');
    $qb->setParameter(':title', '%' . $this->params()->fromQuery('title') . '%');
  }
  if ($this->params()->fromQuery('artist')) {
    $qb->add('where','artist like :artist');
    $qb->setParameter(':artist', '%' . $this->params()->fromQuery('artist') . '%');
  }
  $q = $qb->getDql();
  $paginator = new Paginator(new DoctrineAdapter(new ORMPaginator($this->getEntityManager()->createQuery($q))));
  $paginator->setDefaultItemCountPerPage(10);
  $page = (int)$this->params()->fromQuery('page');
  if ($page) $paginator->setCurrentPageNumber($page);
  $view->setVariable('paginator', $paginator);
  return $view;
}

但是当我通过URL http://myapp/album?title=In%20My%20Dreams传递查询时，$qb->getDql();的结果是SELECT a FROM AlbumEntityAlbum a WHERE title like :title，它返回下面的错误。

ZendPaginatorExceptionRuntimeException
File:
/Users/luke/Sites/hotelio/vendor/zendframework/zendframework/library/Zend/Paginator/Paginator.php:637
Message:
Error producing an iterator
Stack trace:
#0 /myapp/module/Album/view/album/album/index.phtml(20): ZendPaginatorPaginator->getIterator()
#1 /myapp/vendor/zendframework/zendframework/library/Zend/View/Renderer/PhpRenderer.php(507): include('/myapp...')
#2 /myapp/vendor/zendframework/zendframework/library/Zend/View/View.php(205): ZendViewRendererPhpRenderer->render(Object(ZendViewModelViewModel))
#3 /myapp/vendor/zendframework/zendframework/library/Zend/View/View.php(233): ZendViewView->render(Object(ZendViewModelViewModel))
#4 /myapp/vendor/zendframework/zendframework/library/Zend/View/View.php(198): ZendViewView->renderChildren(Object(ZendViewModelViewModel))
#5 /myapp/vendor/zendframework/zendframework/library/Zend/Mvc/View/Http/DefaultRenderingStrategy.php(102): ZendViewView->render(Object(ZendViewModelViewModel))
#6 [internal function]: ZendMvcViewHttpDefaultRenderingStrategy->render(Object(ZendMvcMvcEvent))
#7 /myapp/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(ZendMvcMvcEvent))
#8 /myapp/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(207): ZendEventManagerEventManager->triggerListeners('render', Object(ZendMvcMvcEvent), Array)
#9 /myapp/vendor/zendframework/zendframework/library/Zend/Mvc/Application.php(347): ZendEventManagerEventManager->trigger('render', Object(ZendMvcMvcEvent))
#10 /myapp/vendor/zendframework/zendframework/library/Zend/Mvc/Application.php(322): ZendMvcApplication->completeRequest(Object(ZendMvcMvcEvent))
#11 /myapp/public/index.php(12): ZendMvcApplication->run()
#12 {main}

我理解错误是视图访问变量的地方，但是当分页器处理修改后的查询时，它似乎在错误之前得到视图的距离。我不太清楚这是怎么回事。

为免疑义，原方法也操作无误;

public function indexAction()
{
  $view =  new ViewModel();
  $repository = $this->getEntityManager()->getRepository('AlbumEntityAlbum');
  $paginator = new Paginator(new DoctrineAdapter(new ORMPaginator($this->getEntityManager()->createQuery($repository->createQueryBuilder('album')))));
  $paginator->setDefaultItemCountPerPage(10);
  $page = (int)$this->params()->fromQuery('page');
  if ($page) $paginator->setCurrentPageNumber($page);
  $view->setVariable('paginator', $paginator);
  return $view;
}

Answer 1

我得到同样的错误。在我的例子中，问题是"约会"。没有在php.ini中设置时区。这会导致以下代码实际捕获DateTime()异常。

Zend Paginator Paginator

    public function getIterator()
    {
        try {
            return $this->getCurrentItems();
        } catch (Exception $e) {
            throw new ExceptionRuntimeException('Error producing an iterator', null, $e);
        }
    }

Answer 2

除了错误的DQL，当data/DoctrineORMModule/Proxy没有设置正确的写权限时，也会发生"错误生成迭代器":

chmod 755 data/DoctrineORMModule/Proxy