src/EventSubscriber/PositionNormalizerSubscriber.php line 24

Open in your IDE?
  1. <?php
  3. namespace App\EventSubscriber;
  5. use App\Entity\PositionedInterface;
  6. use Doctrine\ORM\EntityManagerInterface;
  7. use EasyCorp\Bundle\EasyAdminBundle\Event\AfterEntityDeletedEvent;
  8. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  10. class PositionNormalizerSubscriber implements EventSubscriberInterface
  11. {
  12.     public function __construct(
  13.         private EntityManagerInterface $entityManager,
  14.     )
  15.     {}
  17.     public static function getSubscribedEvents()
  18.     {
  19.         return [
  20.             AfterEntityDeletedEvent::class => [['onAfterEntityDeleted', 0]],
  21.         ];
  22.     }
  24.     public function onAfterEntityDeleted(AfterEntityDeletedEvent $event)
  25.     {
  26.         $entity = $event->getEntityInstance();
  27.         if ($entity instanceof PositionedInterface) {
  28.             // Re-normalize positions
  29.             $qb = $this->entityManager->createQueryBuilder()
  30.                 ->update($entity::class, 'p')
  31.                 ->set('p.position', 'p.position - 1')
  32.                 ->where('p.position > :position')
  33.                 ->setParameter('position', $entity->getPosition());
  34.             $qb->getQuery()->execute();
  35.         }
  36.     }
  37. }