使用汇总表symfony2进行查询

/**
 * @var string
 *
 * One Order has Many OrderProduct.
 * @ORM\OneToMany(targetEntity="OrderProduct", mappedBy="order")
 */
private $product;

/**
 * CatalogOrder constructor.
 */
public function __construct() {
    $this->product = new ArrayCollection();
}

属性为product、order和number的OrderProduct实体(该实体用于存储订购产品的数量)

/**
 * @ORM\ManyToOne(targetEntity="CatalogOrder", inversedBy="product")
 * @ORM\JoinColumn(name="order_id", referencedColumnName="id")
 * @Assert\NotBlank()
 */
private $order;

/**
 * @ORM\ManyToOne(targetEntity="Product", inversedBy="order")
 * @ORM\JoinColumn(name="product_id", referencedColumnName="id")
 * @Assert\NotBlank()
 */
private $product;

/**
 * @var int
 *
 * @ORM\Column(name="number", type="integer")
 */
private $number;

具有属性顺序的产品实体

/**
 * @ORM\OneToMany(targetEntity="OrderProduct", mappedBy="product")
 */
private $order;

public function __construct()
{
    $this->order = new ArrayCollection();
}

我的猜测不是真的:

$qb->join('o.product', 'p')
    ->where('p.product.name LIKE :name')
    ->setParameter('name', '%'.$filters['productName'].'%');