Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

many-to-many and sonata-admin-bundle

I have ManyToMany related entities Partner and District, but when i editing relationships between object of entities changes are not saved.

Entity District

class District
{
    ...
    /**
     * @ORM\ManyToMany(targetEntity="Partner", inversedBy="districts")
     * @ORM\JoinTable(name="thedo_pcsuppurt_districts_partners",
     *     joinColumns={
     *     @ORM\JoinColumn(name="district_id", referencedColumnName="id")
     *   },
     *   inverseJoinColumns={
     *     @ORM\JoinColumn(name="partner_id", referencedColumnName="id")
     *   }
     * ) 
     */
    private $partners;
    ...

Entity Partner

class Partner
{
    ...
    /**
     * @ORM\ManyToMany(targetEntity="District", mappedBy="partners")
     * @ORM\OrderBy({"name" = "ASC"})
     */
    private $districts;
    ...

Admin class

class PartnerAdmin extends Admin
{
    public function configureFormFields(FormMapper $formMapper)
    {
        $formMapper
            ->with('General')
                ->add('name', null, array('label' => 'name'))
                ->add('mail', null, array('label' => 'mail'))
                ->add('ticket_prefix', null, array('label' => 'Ticket Prefix'))
            ->end()
            ->with('Districts', array('collapsed' => true))
                ->add('districts', null, array('label' => 'Districts', 'expanded' => true, 'by_reference' => false, 'multiple' => true))
            ->end()
        ;
    }
    ...

I not have any errors, but when page is reloaded relationships is not saved.

UPD In my logs i see this

[2013-10-03 10:09:19] doctrine.DEBUG: SELECT t0.id AS id1, t0.name AS name2, t0.mail AS mail3, t0.login AS login4, t0.password AS password5, t0.ticket_prefix AS ticket_prefix6, t0.created_at AS created_at7, t0.updated_at AS updated_at8 FROM thedo_pcsupport_partner t0 WHERE t0.id = ? ["1"] []
[2013-10-03 10:09:19] doctrine.DEBUG: SELECT t0.id AS id1, t0.name AS name2, t0.city_id AS city_id3 FROM thedo_pcsupport_district t0 [] []
[2013-10-03 10:09:19] doctrine.DEBUG: SELECT t0.id AS id1, t0.name AS name2, t0.city_id AS city_id3 FROM thedo_pcsupport_district t0 INNER JOIN thedo_pcsuppurt_districts_partners ON t0.id = thedo_pcsuppurt_districts_partners.district_id WHERE thedo_pcsuppurt_districts_partners.partner_id = ? ORDER BY t0.name ASC [1] []
like image 936
Nikita Borisovich Djigurda Avatar asked Oct 02 '13 14:10

Nikita Borisovich Djigurda


1 Answers

Can you try cascade={"persist"} on @ORM\ManyToMany annotations?

Other that that, ensure that you have your adders like so:

// District.php

public function addPartner($partner)
{
    $this->partners[] = $partner;
    $partner->setDistrict($this); // This line is important for Sonata.
}

I hope you know, that such adders (and removers) can be easily generated using doctrine:generate:entities (not doctrine:generate:entity).

like image 111
TautrimasPajarskas Avatar answered Oct 31 '22 00:10

TautrimasPajarskas