KnpPaginator 不适用于联接的表

Question

我正在尝试连接两个表并从 KnpPaginator 获取排序的结果集。这是我的代码。

视图

<table class="table table-bordered">
<tr>
<th>{{ knp_pagination_sortable(pagination, 'Id', 'c.id') }}</th>
<th{% if pagination.isSorted('c.name') %} class="sorted"{% endif %}>{{ knp_pagination_sortable(pagination, 'Name', 'c.name') }}</th>
<th>{{ knp_pagination_sortable(pagination, 'Version', 'c.model.name') }}</th>
</tr>
{% for article in pagination %}
<tr {% if loop.index is odd %}class="color"{% endif %}>
<td>{{ article.id }}</td>
<td>{{ article.getName }}</td>
<td>{{ article.model.name }}</td>
</tr>
{% endfor %}
</table>

控制器

$em = $this->get('doctrine.orm.entity_manager');
$dql = "SELECT c FROM AppEntityCar c";
$query = $em->createQuery($dql);
$paginator = $this->get('knp_paginator');
$pagination = $paginator->paginate(
$query, /* query NOT result */ $request->query->getInt('page', 1)/* page number */, 10/* limit per page */
);

模型模型

/**
* @ORMEntity(repositoryClass="AppRepositoryModelRepository")
*/
class Model
{
/**
* @ORMId()
* @ORMGeneratedValue()
* @ORMColumn(type="integer")
*/
private $id;
/**

汽车模型

<?php
namespace AppEntity;
use DoctrineORMMapping as ORM;
/**
* @ORMEntity(repositoryClass="AppRepositoryCarRepository")
*/
class Car
{
/**
* @ORMId()
* @ORMGeneratedValue()
* @ORMColumn(type="integer")
*/
private $id;
/**
* @ORMColumn(type="string", length=255, nullable=true)
*/
private $name;
/**
* @ORMColumn(type="string", length=255, nullable=true)
*/
private $code;
/**
* @ORMManyToOne(targetEntity="AppEntityModel",cascade={"refresh","merge"}, inversedBy="cars")
* @ORMJoinColumn(nullable=false)
*/
private $model;
public function getModel(): ?Model
{
return $this->model;
}
public /**
* @param $
*/function setModel(?Model $model): self
{
$this->model = $model;
return $this;
}
}

当我在表体内 article.model.name 时，它可以工作。但knp_pagination_sortable(pagination, 'Version', 'c.model.name')只显示此错误

在给定的查询组件中没有这样的字段 [model.name]， 别名为 [c]

我删除了一些不需要的代码以提高可见性。谢谢

Answer 1

终于找到了解决方案。

$em = $this->get('doctrine.orm.entity_manager');
$qb = $em->createQueryBuilder();

$query = $qb->select('c', 'm')
->from('AppEntityCar', 'c')
->leftJoin('c.model', 'm')
->getQuery();
$paginator = $this->get('knp_paginator');
$pagination = $paginator->paginate(
$query, /* query NOT result */ $request->query->getInt('page', 1)/* page number */, 10/* limit per page */
);

但是您需要正确添加关系才能工作 在这里我添加了，

/**
* @ORMManyToOne(targetEntity="AppEntityModel",cascade={"refresh","merge"}, inversedBy="cars")
* @ORMJoinColumn(nullable=false)
*/
private $model;
public function getModel(): ?Model
{
return $this->model;
}
public /**
* @param $
*/function setModel(?Model $model): self
{
$this->model = $model;
return $this;
}