I have a form with a drop down and a set of checkboxes, i've used entity form field type to get the values via DB. it works with one of the entity but not with the other. i have this code seperately inside AddBadgesType there is NO AddBadges entity

<?php
namespace Test\Bundle\TestBundle\Form;

use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\FormBuilderInterface;

class AddBadgesType extends AbstractType
{
 /**
  * @param FormBuilderInterface $builder
  * @param array $options
  */
 public function buildForm(FormBuilderInterface $builder, array   $options)
{
    $builder
        ->add('property', 'entity', array(
            'class' => 'TestBundle:Property',
            'property' => 'id',
            'query_builder' => function (\Doctrine\ORM\EntityRepository $er) {
                return $er->createQueryBuilder('property')
                    ->orderBy('property.id ', 'ASC');
            },
        ))
        ->add('badges', 'entity', array(
                'class' => 'TestBundle:Badge',
                'property' => 'name',
                'multiple' => true,
                'expanded' => true,
            ))
        ;
}

/**
 * @return string
 */
public function getName()
{
    return 'test_bundle_testbundle_AddBadges';
}
}

with this error

Could not convert database value "" to Doctrine Type array

here is the enity for property

<?php

 namespace Test\Bundle\TestBundle\Entity;

 use Doctrine\ORM\Mapping as ORM;
 use Symfony\Component\Validator\Constraints as Assert;
 use Doctrine\Common\Collections\ArrayCollection;
  /**
   * Property
   *
   * @ORM\Table()
   * @ORM\Entity(repositoryClass="Test\Bundle\TestBundle\Entity\PropertyRepository")
   */
 class Property
 {
public function __construct() {
    $this->campus = new ArrayCollection();
    $this->tag = new ArrayCollection();
}

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



/**
 * @ORM\ManyToOne(targetEntity="University", inversedBy="property")
 * @ORM\JoinColumn(name="university_id", referencedColumnName="id")
 */
private $university;

/**
 * @ORM\ManyToMany(targetEntity="Tag")
 */
private $tag;

/**
 * @ORM\Column(name="badges", type="array")
 */
private $badges;

/**
 * @ORM\ManyToMany(targetEntity="Campus")
 */
private $campus;

/**
 * @var string
 * @ORM\Column(name="address", type="string", length=255)
 * @Assert\NotBlank()
 * @Assert\Length(
 *                 min = 10,
 *                 max = 80,
 *                 minMessage = "Address must be more specific",
 *                 maxMessage = "80 characters limit exceeded"
 *              )
 */
private $address;

/**
 * @var integer
 * @ORM\Column(name="postalcode", type="integer")
 * @Assert\NotBlank()
 * @Assert\Length(
 *                 min = 3,
 *                 minMessage = "Password must contain atleast 3 digits"
 *              )
 */
private $postalcode;

/**
 * @var integer
 * @Assert\NotBlank()
 * @ORM\Column(name="propertytype", type="integer")
 */
private $propertytype;

/**
 * @var integer
 * @Assert\NotBlank()
 * @ORM\Column(name="rent", type="integer")
 */
private $rent;

/**
 * @var integer
 * @Assert\NotBlank()
 * @ORM\Column(name="leaseperiod", type="integer")
 */
private $leaseperiod;

/**
 * @var integer
 * @Assert\NotBlank()
 * @ORM\Column(name="utilities", type="integer")
 */
private $utilities;

/**
 * @var integer
 * @Assert\NotBlank()
 * @ORM\Column(name="bedrooms", type="integer")
 */
private $bedrooms;

/**
 * @var integer
 * @Assert\NotBlank()
 * @ORM\Column(name="bathrooms", type="integer")
 */
private $bathrooms;

/**
 * @var string
 * @ORM\Column(name="additionaldetails", type="string", length=255)
 * @Assert\Length(
 *                 min = 10,
 *                 max = 200,
 *                 minMessage = "Details must be more specific",
 *                 maxMessage = "200 characters limit exceeded"
 *              )
 */
private $additionaldetails;


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

/**
 * Set address
 *
 * @param string $address
 * @return Property
 */
public function setAddress($address)
{
    $this->address = $address;

    return $this;
}

/**
 * Get address
 *
 * @return string 
 */
public function getAddress()
{
    return $this->address;
}

/**
 * Set postalcode
 *
 * @param string $postalcode
 * @return Property
 */
public function setPostalcode($postalcode)
{
    $this->postalcode = $postalcode;

    return $this;
}

/**
 * Get postalcode
 *
 * @return string 
 */
public function getPostalcode()
{
    return $this->postalcode;
}

/**
 * Set propertytype
 *
 * @param integer $propertytype
 * @return Property
 */
public function setPropertytype($propertytype)
{
    $this->propertytype = $propertytype;

    return $this;
}

/**
 * Get propertytype
 *
 * @return integer 
 */
public function getPropertytype()
{
    return $this->propertytype;
}

/**
 * Set rent
 *
 * @param string $rent
 * @return Property
 */
public function setRent($rent)
{
    $this->rent = $rent;

    return $this;
}

/**
 * Get rent
 *
 * @return string 
 */
public function getRent()
{
    return $this->rent;
}

/**
 * Set leaseperiod
 *
 * @param integer $leaseperiod
 * @return Property
 */
public function setLeaseperiod($leaseperiod)
{
    $this->leaseperiod = $leaseperiod;

    return $this;
}

/**
 * Get leaseperiod
 *
 * @return integer 
 */
public function getLeaseperiod()
{
    return $this->leaseperiod;
}

/**
 * Set utilities
 *
 * @param integer $utilities
 * @return Property
 */
public function setUtilities($utilities)
{
    $this->utilities = $utilities;

    return $this;
}

/**
 * Get utilities
 *
 * @return integer 
 */
public function getUtilities()
{
    return $this->utilities;
}

/**
 * Set bedrooms
 *
 * @param integer $bedrooms
 * @return Property
 */
public function setBedrooms($bedrooms)
{
    $this->bedrooms = $bedrooms;

    return $this;
}

/**
 * Get bedrooms
 *
 * @return integer 
 */
public function getBedrooms()
{
    return $this->bedrooms;
}

/**
 * Set bathrooms
 *
 * @param integer $bathrooms
 * @return Property
 */
public function setBathrooms($bathrooms)
{
    $this->bathrooms = $bathrooms;

    return $this;
}

/**
 * Get bathrooms
 *
 * @return integer 
 */
public function getBathrooms()
{
    return $this->bathrooms;
}

/**
 * Set additionaldetails
 *
 * @param string $additionaldetails
 * @return Property
 */
public function setAdditionaldetails($additionaldetails)
{
    $this->additionaldetails = $additionaldetails;

    return $this;
}

/**
 * Get additionaldetails
 *
 * @return string 
 */
public function getAdditionaldetails()
{
    return $this->additionaldetails;
}

/**
 * Set university
 *
 * @param \Test\Bundle\TestBundle\Entity\Univerisity $university
 * @return Property
 */
public function setUniversity(\Test\Bundle\TestBundle\Entity\University $university = null)
{
    $this->university = $university;

    return $this;
}

/**
 * Get university
 *
 * @return \Test\Bundle\TestBundle\Entity\Univerisity 
 */
public function getUniversity()
{
    return $this->university;
}

/**
 * Add campus
 *
 * @param \Test\Bundle\TestBundle\Entity\Campus $campus
 * @return Property
 */
public function addCampus(\Test\Bundle\TestBundle\Entity\Campus $campus)
{
    $this->campus[] = $campus;

    return $this;
}

/**
 * Remove campus
 *
 * @param \Test\Bundle\TestBundle\Entity\Campus $campus
 */
public function removeCampus(\Test\Bundle\TestBundle\Entity\Campus $campus)
{
    $this->campus->removeElement($campus);
}

/**
 * Get campus
 *
 * @return \Doctrine\Common\Collections\Collection 
 */
public function getCampus()
{
    return $this->campus;
}

/**
 * Add tag
 *
 * @param \Test\Bundle\TestBundle\Entity\Tag $tag
 * @return Property
 */
public function addTag(\Test\Bundle\TestBundle\Entity\Tag $tag)
{
    $this->tag[] = $tag;

    return $this;
}

/**
 * Remove tag
 *
 * @param \Test\Bundle\TestBundle\Entity\Tag $tag
 */
public function removeTag(\Test\Bundle\TestBundle\Entity\Tag $tag)
{
    $this->tag->removeElement($tag);
}

/**
 * Get tag
 *
 * @return \Doctrine\Common\Collections\Collection 
 */
public function getTag()
{
    return $this->tag;
}

/**
 * Set badges
 *
 * @param array $badges
 * @return Property
 */
public function setBadges($badges)
{
    $this->badges = $badges;
    return $this;
}

/**
 * Get badges
 *
 * @return array 
 */
public function getBadges()
{
    return $this->badges;
}
}

However if i change the entity to 'Campus' it works fine, i think it might be something to do with the ManyToMany relationship in property entity?!

Campus entity for reference

<?php

 namespace Test\Bundle\TestBundle\Entity;

 use Doctrine\ORM\Mapping as ORM;
 use Symfony\Component\Validator\Constraints as Assert;

 /**
  * Campus
  *
  * @ORM\Table()
  * @ORM\Entity(repositoryClass="Test\Bundle\TestBundle\Entity\CampusRepository")
  */
 class Campus
{
/**
 * @var integer
 *
 * @ORM\Column(name="id", type="integer")
 * @ORM\Id
 * @ORM\GeneratedValue(strategy="AUTO")
 */
private $id;

/**
 * @ORM\ManyToOne(targetEntity="University", inversedBy="campus")
 * @ORM\JoinColumn(name="university_id", referencedColumnName="id")
 */
private $university;

/**
 * @var string
 *
 * @ORM\Column(name="name", type="string", length=255)
 * @Assert\NotBlank
 * @Assert\Length(
 *                  min=3,
 *                  max=35,
 *                  minMessage= "Name Field should contains at least 3 characters",
 *                  maxMessage = "Name Field Cannot contain more than 35 characters"
 *               )
 * @Assert\Regex(pattern="/[^a-z\s-]/i", match=false , message="Name can only contain letters")
 */
private $name;

/**
 * @var string
 * @ORM\Column(name="address", type="string", length=255)
 * @Assert\NotBlank()
 * @Assert\Length(
 *                 min = 10,
 *                 max = 80,
 *                 minMessage = "Address must be more specific",
 *                 maxMessage = "80 characters limit exceeded"
 *              )
 */
private $address;


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

/**
 * Set name
 *
 * @param string $name
 * @return Campus
 */
public function setName($name)
{
    $this->name = $name;

    return $this;
}

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

/**
 * Set address
 *
 * @param string $address
 * @return Campus
 */
public function setAddress($address)
{
    $this->address = $address;

    return $this;
}

/**
 * Get address
 *
 * @return string 
 */
public function getAddress()
{
    return $this->address;
}

/**
 * Set university
 *
 * @param \Test\Bundle\TestBundle\Entity\University $university
 * @return Campus
 */
public function setUniversity(\Test\Bundle\TestBundle\Entity\University $university = null)
{
    $this->university = $university;

    return $this;
}

/**
 * Get university
 *
 * @return \Test\Bundle\TestBundle\Entity\University 
 */
public function getUniversity()
{
    return $this->university;
}

}

不能找到Comparator接口

Cazymouse

2个回复