symfony - findBy() 外键不起作用

Question

评分细则和品牌表(Many rubric to One Brand)之间存在关系。

这是我的代码

    $dbChoices = $this->getConfigurationPool()
        ->getContainer()
        ->get('Doctrine')
        ->getManager()
        ->getRepository('RibambelMainBundle:RubricMenu')
        ->findBy(array('brand_id' => 2));

每次运行这部分时，我都会收到以下错误:

Unrecognized field: brand_id

在 rubric 表中可以找到brand_id 列。


谁能帮我解决这个问题或告诉我另一种方法？

class RubricMenu
{
    /**
     * @var int
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;

    /**
     * @var string
     *
     * @ORM\Column(name="Title", type="string", length=255)
     */
    private $title;

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

    /**
     * @ORM\ManyToOne(targetEntity="Brand")
     * @ORM\JoinColumn(name="brand_id", nullable=false)
     */
    private $brand;


    /**
     * Get id
     *
     * @return int
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * Set name
     *
     * @param string $title
     *
     * @return RubricMenu
     */
    public function setTitle($title)
    {
        $this->title = $title;

        return $this;
    }

    /**
     * Get name
     *
     * @return string
     */
    public function getTitle()
    {
        return $this->title;
    }

    /**
     * Set position
     *
     * @param integer $position
     *
     * @return RubricMenu
     */
    public function setPosition($position)
    {
        $this->position = $position;

        return $this;
    }

    /**
     * Get position
     *
     * @return int
     */
    public function getPosition()
    {
        return $this->position;
    }


    /**
     * Set brand
     *
     * @param \Ribambel\MainBundle\Entity\Brand $brand
     *
     * @return RubricMenu
     */
    public function setBrand(\Ribambel\MainBundle\Entity\Brand $brand = null)
    {
        $this->brand = $brand;

        return $this;
    }

    /**
     * Get brand
     *
     * @return \Ribambel\MainBundle\Entity\Brand
     */
    public function getBrand()
    {
        return $this->brand;
    }
}

Answer 1

根据您的实体，您应该执行以下操作。

$dbChoices = $this->getConfigurationPool()
        ->getContainer()
        ->get('Doctrine')
        ->getManager()
        ->getRepository('RibambelMainBundle:RubricMenu')
        ->findBy(array('brand' => 2));