会话中的存储实体没有';t工作=>$em->;persist()


Store entity from session doesn't work => $em->persist()

首先:对不起我英语不好:-)

初学者需要帮助!

我有3个实体/表格:

表格:

contact_person
id, title, firstname, surname, adress_id
address
id, street, zip, city, country_id
country (fix values)
id, name, code
1, Austria, AT
2, Germany, DE
...

实体:

/**
 * ContactPerson
 *
 * @ORM'Table(name="contact_person")
 * @ORM'Entity
 * @ORM'HasLifecycleCallbacks
 */
class ContactPerson
{
    /**
     * @var integer $contactPersonId
     *
     * @ORM'Id
     * @ORM'Column(name="id", type="integer")
     * @ORM'GeneratedValue(strategy="AUTO")
     */
    private $contactPersonId;
    /**
     * @ORM'Column(name="title", type="string", columnDefinition="ENUM('m', 'w')")
     */
    private $title;
    /**
     * @ORM'Column(name="firstname", type="string", length=255)
     */
    private $firstName;
    /**
     * @ORM'Column(name="surname", type="string", length=255)
     */
    private $surName;
    /**
     * @ORM'OneToOne(targetEntity="Trac'TracBundle'Entity'Address", cascade={"persist"})
     * @ORM'JoinColumn(name="address_id", referencedColumnName="id")
     */
    protected $address;
    ...
}
/**
 * Address
 *
 * @ORM'Table(name="address")
 * @ORM'Entity
 * @ORM'HasLifecycleCallbacks
 */
class Address
{
    /**
     * @var integer $addresssId
     *
     * @ORM'Id
     * @ORM'Column(name="id", type="integer")
     * @ORM'GeneratedValue(strategy="AUTO")
     */
    private $addresssId;
    /**
     * @ORM'Column(name="street", type="string", length=255)
     */
    private $street;
    /**
     * @ORM'Column(name="zip", type="string", length=255)
     */
    private $zip;
    /**
     * @ORM'Column(name="city", type="string", length=255)
     */
    private $city;
    /**
     * @ORM'ManyToOne(targetEntity="Trac'TracBundle'Entity'Country", inversedBy="addresses", cascade={"persist"})
     * @ORM'JoinColumn(name="country_id", referencedColumnName="id", nullable=true)
     */
    private $country;
    ...
}
/**
 * Country
 *
 * @ORM'Table(name="country")
 * @ORM'Entity
 */
class Country
{
    /**
     * @var integer $countryId
     *
     * @ORM'Column(name="id", type="integer")
     * @ORM'Id
     * @ORM'GeneratedValue(strategy="AUTO")
     */
    private $countryId;
    /**
     * @ORM'Column(name="name", type="string", length=255)
     */
    private $name;
    /**
     * @ORM'Column(name="code", type="string", length=255)
     */
    private $code;
    ...
}

1形式:

联系人类型:

$builder->add('title', 'choice', array('choices'  => array('m' => 'male', 'w' => 'female')));
$builder->add('firstname', 'text');
$builder->add('surname', 'text');
$builder->add('address', new 'myBundle'Form'AddressType(), array(
    'data_class' => 'myBundle'Entity'Address'
));

地址类型:

$builder->add('street', 'text');
$builder->add('zip', 'text');
$builder->add('city', 'text');
$builder->add('country', 'entity', array(
    'class' => 'myBundle'Entity'Country',
    'property' => 'name'
));

国家类型:

$builder->add('country', 'entity', array(
    'class' => 'myBundle'Entity'Country',
    'property' => 'name'
));

当我发布表单时,控制器成功地将请求数据存储在表中一切正常

联系人控制器:

$form->handleRequest($request);
if($form->isValid()) {
    $contact_person = $form->getData();
    $em->persist($contact_person);
    $em->flush();
}

表格中的结果:

contact_person
id, title, firstname, surname, adress_id
1, Mr, Ted, Tester, 1
address
id, street, zip, city, country_id
1, myStreet, 12345, Berlin, 2
country
id, name, code
1, Austria, AT
2, Germany, DE

问题:

当我将联系人实体存储在会话中并从另一个控制器调用$em->persist()时,国家映射失败:

ContactPersonController(将联系人对象存储到会话中):

$form->handleRequest($request);
$session = $request->getSession();
if($form->isValid()) {
    $contactPersons[] = $form->getData();
    //Add to session
    $session->set('contactPersons', $contactPersons);
}

另一个控制器:

...
if($form->isValid()) {
    $customer = $form->getData();
    //Customer
    $em->persist($customer);
    $em->flush();
    //Get contact persons from session
    $contactPersons = $session->get('contactPersons');
    //Save contact persons to tables
    if(is_array($contactPersons) && !empty($contactPersons)) {
        foreach($contactPersons as $key => $contactPerson) {
            $em->persist($contactPerson);
            $em->flush();
        }
    }
}
...

表格中的错误结果

contact_person
id, title, firstname, surname, adress_id
1, Mr, Ted, Tester, 1
address
id, street, zip, city, country_id
1, myStreet, 12345, Berlin, 3
country
id, name, code
1, Austria, AT
2, Germany, DE
3, Germany, DE <= Create a new row... BUT WHY??? it should reference the id 2 by mapping into address (country_id)

感谢帮助,

吊舱

当您在会话中存储条令实体时,它们将与EntityManager分离。您需要将数据库中已存在的任何实体合并回EntityManager。类似这样的东西(必要时检查null):

    foreach($contactPersons as $key => $contactPerson) {
        $mergedCountry = $em->merge($contactPerson->getAddress()->getCountry());
        $contactPerson->getAddress()->setCountry($mergedCountry);
        $em->persist($contactPerson);
    }
    $em->flush();