Пользовательский репозиторий Doctrine с формой objectselect

Этот вопрос является возможным решением для ZF2 Doctrine, чтобы получить многосоставные отношения с objectSelect , но вопрос сам по себе отличается и не связан.

У меня есть специальный репозиторий с этим кодом:

• Как установить расширение PHP intl в Ubuntu 14.04
• Zend Framework 2 - Проверка пользовательской формы
• настроить несколько баз данных в zf2
• ZF2 - подзапросы
• Как установить ZF2 в ubuntu 12.04 + виртуальный хост + mod_rewrite

class StoreRepository extends EntityRepository { public function getCategories(array $criteria){ return $this->createQueryBuilder("s") ->select('c.id,c.categoryName') ->innerJoin("s.categories", "c", "WITH", "s=:storeid") ->setParameter("storeid", $criteria['storeid']) ->getQuery()->getResult(); } } 

Это моя объектная форму:

  $this->add(array( 'type' => 'DoctrineModule\Form\Element\ObjectSelect', 'name' => 'categories', 'attributes' => array( 'multiple' => true, ), 'options' => array( 'object_manager' => $objectManager, 'target_class' => 'Application\Entity\Store', 'label' => 'Selecteer categorieën', 'column-size' => 'sm-9', 'label_attributes' => array('class' => 'col-sm-3 control-label'), 'property' => 'categoryName', 'is_method' => true, 'find_method' => array( 'name' => 'getCategories', 'params' => array( 'criteria' => array('storeid' => $storeid), ), ), ), )); 

Запрос работает нормально, но я получаю:

  Method "Application\Entity\Store::getCategoryName" is not callable 

Мой объект магазина выглядит так:

  <?php namespace Application\Entity; use Doctrine\ORM\Mapping as ORM; /** * An example entity that represents a store. * * @ORM\Entity * @ORM\Table(name="store") * @ORM\Entity(repositoryClass="Application\Repositories\StoreRepository") * */ class Store { /** * @var int * @ORM\Id * @ORM\Column(type="integer") * @ORM\GeneratedValue(strategy="AUTO") */ protected $id; /** * @var string * @ORM\Column(type="string", name="storeName", length=255, unique=true, nullable=true) */ protected $storeName; /** * @var \Doctrine\Common\Collections\Collection * @ORM\ManyToMany(targetEntity="Application\Entity\Product", inversedBy="stores") * @ORM\JoinTable(name="product_store") */ protected $products; /** * @var \Doctrine\Common\Collections\Collection * @ORM\ManyToMany(targetEntity="Application\Entity\Category", inversedBy="stores") * @ORM\JoinTable(name="category_store") */ protected $categories; /** * Initialies the roles variable. */ public function __construct() { $this->products = new ArrayCollection(); } /** * Get the id. * * @return int */ public function getId() { return $this->id; } /** * Set the id. * * @param int $id * * @return void */ public function setId($id) { $this->id = (int)$id; } /** * Get the store id. * * @return string */ public function getStoreName() { return $this->storeName; } /** * Set the store id. * * @param string $storeName * * @return void */ public function setStoreName($storeName) { $this->storeName = (string) $storeName; } /** * Get product. * * @return array */ public function getProducts() { return $this->products->getValues(); } /** * Add a product to the user. * * @param Role $product * * @return void */ public function addProduct($products) { $this->products[] = $products; } /** * Get category. * * @return array */ public function getCategories() { return $this->categories->getValues(); } /** * Add a product to the user. * * @param Role $product * * @return void */ public function addCategory($categories) { $this->categories[] = $categories; } } 

и мое подразделение категории:

  <?php namespace Application\Entity; use Doctrine\Common\Collections\ArrayCollection; use Doctrine\Common\Collections\Collection; use Doctrine\ORM\Mapping as ORM; /** * An example entity that represents a category. * * @ORM\Entity * @ORM\Table(name="category") * */ class Category { /** * @var int * @ORM\Id * @ORM\Column(type="integer") * @ORM\GeneratedValue(strategy="AUTO") */ protected $id; /** * @var string * @ORM\Column(type="string", name="categoryName", length=255, unique=true, nullable=true) */ protected $categoryName; /** * @var \Doctrine\Common\Collections\Collection * @ORM\ManyToMany(targetEntity="Application\Entity\Product", mappedBy="categories", cascade={"all"}) */ protected $product; /** * @ORM\OneToMany(targetEntity="Application\Entity\Category", mappedBy="parent") */ private $children; /** * @var Category * @ORM\ManyToOne(targetEntity="Application\Entity\Category") * @ORM\JoinColumn(name="parent_id", referencedColumnName="id", nullable=true, onDelete="CASCADE") */ protected $parent; /** * @var \Doctrine\Common\Collections\Collection * @ORM\ManyToMany(targetEntity="Application\Entity\Store", mappedBy="categories") */ protected $stores; /** * Initialies the roles variable. */ public function __construct() { $this->children = new ArrayCollection(); $this->products = new ArrayCollection(); $this->stores = new ArrayCollection(); } /** * Get the id. * * @return int */ public function getId() { return $this->id; } /** * Set the id. * * @param int $id * * @return void */ public function setId($id) { $this->id = (int)$id; } /** * Get the category id. * * @return string */ public function getCategoryName() { return $this->categoryName; } /** * Set the category id. * * @param string $categoryName * * @return void */ public function setCategoryName($categoryName) { $this->categoryName = (string) $categoryName; } /** * Get product. * * @return array */ public function getProduct() { return $this->product; } /** * Add a product to the user. * * @param Role $product * * @return void */ public function addProduct($product = null) { $product->addCategory($this); $this->product = $products; } /** * Get store. * * @return array */ public function getStores() { return $this->stores->getValues(); } /** * Add a stores to the product. * * @param Stores * * @return void */ public function addStores(Collection $stores) { foreach ($stores as $store) { $store->addCategory($this); $this->stores->add($store); } } public function removeStores(Collection $stores){ foreach($stores as $store){ $this->stores->removeElement($store); } } /** * Get the parent role * * @return Role */ public function getParent() { return $this->parent; } /** * Set the parent role. * * @param Role $parent * * @return void */ public function setParent(Category $parent = null) { $this->parent = $parent; } /** * Get images. * * @return array */ public function getChildren() { return $this->children; } /** * Add a image to the product. * * @param Images * * @return void */ public function addChildren(Collection $children) { foreach ($children as $child) { $child->setCategory($this); $this->children->add($child); } } /** * @param Collection $images */ public function removeChildren(Collection $children) { foreach ($children as $child) { $child->setCategory($this); $this->children->removeElement($child); } } } -  <?php namespace Application\Entity; use Doctrine\Common\Collections\ArrayCollection; use Doctrine\Common\Collections\Collection; use Doctrine\ORM\Mapping as ORM; /** * An example entity that represents a category. * * @ORM\Entity * @ORM\Table(name="category") * */ class Category { /** * @var int * @ORM\Id * @ORM\Column(type="integer") * @ORM\GeneratedValue(strategy="AUTO") */ protected $id; /** * @var string * @ORM\Column(type="string", name="categoryName", length=255, unique=true, nullable=true) */ protected $categoryName; /** * @var \Doctrine\Common\Collections\Collection * @ORM\ManyToMany(targetEntity="Application\Entity\Product", mappedBy="categories", cascade={"all"}) */ protected $product; /** * @ORM\OneToMany(targetEntity="Application\Entity\Category", mappedBy="parent") */ private $children; /** * @var Category * @ORM\ManyToOne(targetEntity="Application\Entity\Category") * @ORM\JoinColumn(name="parent_id", referencedColumnName="id", nullable=true, onDelete="CASCADE") */ protected $parent; /** * @var \Doctrine\Common\Collections\Collection * @ORM\ManyToMany(targetEntity="Application\Entity\Store", mappedBy="categories") */ protected $stores; /** * Initialies the roles variable. */ public function __construct() { $this->children = new ArrayCollection(); $this->products = new ArrayCollection(); $this->stores = new ArrayCollection(); } /** * Get the id. * * @return int */ public function getId() { return $this->id; } /** * Set the id. * * @param int $id * * @return void */ public function setId($id) { $this->id = (int)$id; } /** * Get the category id. * * @return string */ public function getCategoryName() { return $this->categoryName; } /** * Set the category id. * * @param string $categoryName * * @return void */ public function setCategoryName($categoryName) { $this->categoryName = (string) $categoryName; } /** * Get product. * * @return array */ public function getProduct() { return $this->product; } /** * Add a product to the user. * * @param Role $product * * @return void */ public function addProduct($product = null) { $product->addCategory($this); $this->product = $products; } /** * Get store. * * @return array */ public function getStores() { return $this->stores->getValues(); } /** * Add a stores to the product. * * @param Stores * * @return void */ public function addStores(Collection $stores) { foreach ($stores as $store) { $store->addCategory($this); $this->stores->add($store); } } public function removeStores(Collection $stores){ foreach($stores as $store){ $this->stores->removeElement($store); } } /** * Get the parent role * * @return Role */ public function getParent() { return $this->parent; } /** * Set the parent role. * * @param Role $parent * * @return void */ public function setParent(Category $parent = null) { $this->parent = $parent; } /** * Get images. * * @return array */ public function getChildren() { return $this->children; } /** * Add a image to the product. * * @param Images * * @return void */ public function addChildren(Collection $children) { foreach ($children as $child) { $child->setCategory($this); $this->children->add($child); } } /** * @param Collection $images */ public function removeChildren(Collection $children) { foreach ($children as $child) { $child->setCategory($this); $this->children->removeElement($child); } } } 

• Как использовать коллекции на фабрике fieldset в ZF2
• ZF2 Загрузка файла не работает для меня
• ZF2 Как передать переменную в форму
• Как (правильно) расширить метод ScnSocialAuth \ Authentication \ Adapter \ HybridAuth :: authenticate ()?
• форма не обязательные значения для объекта

  $this->add(array( 'type' => 'DoctrineModule\Form\Element\ObjectSelect', 'name' => 'categories', 'attributes' => array( 'multiple' => true, ), 'options' => array( 'object_manager' => $objectManager, 'target_class' => 'Application\Entity\Category', 'label' => 'Selecteer categorieën', 'column-size' => 'sm-9', 'label_attributes' => array('class' => 'col-sm-3 control-label'), 'property' => 'categoryName', 'is_method' => true, 'find_method' => array( 'name' => 'getStoreCategories', 'params' => array( 'criteria' => array('storeid' => $storeid), ), ), ), )); 

  <?php namespace Application\Repositories; use Doctrine\ORM\EntityRepository; use Doctrine\ORM\Query\ResultSetMapping; use Doctrine\DBAL\Types\Type; class CategoryRepository extends EntityRepository { public function getStoreCategories(array $criteria){ return $this->createQueryBuilder('c') ->select('c') ->innerJoin("c.stores", "s", "WITH", "s=:storeid") ->setParameter("storeid", $criteria['storeid']) ->getQuery()->getResult(); } }