Advertisement
Guest User

Untitled

a guest
Jul 28th, 2016
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.65 KB | None | 0 0
  1. /**
  2. * @ORMOneToMany(targetEntity="Repair", mappedBy="device", cascade={"remove"})
  3. */
  4. private $repairs;
  5.  
  6. /**
  7. * @ORMManyToMany(targetEntity="Color", inversedBy="devices")
  8. * @ORMJoinTable(name="devices_colors",
  9. * joinColumns={@ORMJoinColumn(name="device_id", referencedColumnName="id")},
  10. * inverseJoinColumns={@ORMJoinColumn(name="color_id", referencedColumnName="id")}
  11. * )
  12. */
  13. private $colors;
  14.  
  15. /**
  16. * @ORMManyToMany(targetEntity="Device", mappedBy="colors")
  17. */
  18. private $devices;
  19.  
  20. /**
  21. * @ORMManyToOne(targetEntity="Device", inversedBy="repairs")
  22. * @ORMJoinColumn(name="device_id", referencedColumnName="id")
  23. */
  24. private $device;
  25.  
  26. /**
  27. * @ORMManyToMany(targetEntity="Color")
  28. * @ORMJoinTable(name="repairs_colors",
  29. * joinColumns={@ORMJoinColumn(name="repair_id", referencedColumnName="id")},
  30. * inverseJoinColumns={@ORMJoinColumn(name="color_id", referencedColumnName="id")}
  31. * )
  32. */
  33. private $colors;
  34.  
  35. ->add('colors', EntityType::class, array(
  36. 'label'=>'Kleuren',
  37. 'class'=>'AppBundle:Color',
  38. 'choice_label'=>'name',
  39. 'choice_value'=>'id',
  40. 'multiple'=>true,
  41. 'expanded'=>true,
  42. 'query_builder'=>function (EntityRepository $er) use ($device) {
  43. return $er->createQueryBuilder('c')
  44. ->join('AppBundle:Device','d')
  45. ->where('d.id = :device')
  46. ->setParameter('device', $device);
  47. }
  48. )
  49. )
  50.  
  51. SELECT c.name FROM colors c LEFT JOIN devices_colors d ON (d.color_id=c.id) WHERE d.device_id = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement