Opportunity event listener: how to modify her activities

I am trying to mark any opportunity as won or lost are closed all tasks listed on that opportunity.

For this I have made an extended bundle of Opportunity Bundle that has an event that it enters when an opportunity is saved but I can not get the list of tasks of that opportunity to close it.

PHP

namespace MtcOpportunityBundle\Listener; use Doctrine\ORM\Event\OnFlushEventArgs; use Oro\Bundle\SalesBundle\Entity\Opportunity; use Oro\Bundle\TaskBundle\Entity\Task; class Finalizado { public function onFlush(OnFlushEventArgs $args) { $em = $args->getEntityManager(); $uow = $em->getUnitOfWork(); // we would like to listen on insertions and updates events $entities = array_merge( $uow->getScheduledEntityInsertions(), $uow->getScheduledEntityUpdates() ); foreach ($entities as $entity) { // every time we update or insert a new ContactEmail entity we do the work if (!$entity instanceof Opportunity) { continue; } foreach($entity->tasks as $task){ if(!$task instanceof Task){ continue; } $task->status_id = 'closed'; $em->persist($task); $md = $em->getClassMetadata(get_class($task)); $uow->computeChangeSet($md, $owner); } // ... update social info of the owner with its primary email // force persist /*$em->persist($owner); $md = $em->getClassMetadata(get_class($owner)); $uow->computeChangeSet($md, $owner);*/ } } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

namespace MtcOpportunityBundle\Listener;   use Doctrine\ORM\Event\OnFlushEventArgs; use Oro\Bundle\SalesBundle\Entity\Opportunity; use Oro\Bundle\TaskBundle\Entity\Task;   class Finalizado {     public function onFlush(OnFlushEventArgs $args)     {         $em = $args->getEntityManager();         $uow = $em->getUnitOfWork();           // we would like to listen on insertions and updates events         $entities = array_merge(             $uow->getScheduledEntityInsertions(),             $uow->getScheduledEntityUpdates()         );           foreach ($entities as $entity) {                      // every time we update or insert a new ContactEmail entity we do the work             if (!$entity instanceof Opportunity) {                 continue;             } foreach($entity->tasks as $task){ if(!$task instanceof Task){ continue; } $task->status_id = 'closed'; $em->persist($task);                 $md = $em->getClassMetadata(get_class($task));                 $uow->computeChangeSet($md, $owner); }             // ... update social info of the owner with its primary email                   // force persist             /*$em->persist($owner);             $md = $em->getClassMetadata(get_class($owner));             $uow->computeChangeSet($md, $owner);*/         }     } }

Topic

[Alan Culvi BertomeuParticipant]

Another problem I have found is to modify a “promocion_id” field created from entity management

[Mike KudelyaParticipant]

Hi

Try to use the following code:

PHP

$doctrine = $this->getDoctrine(); $em = $doctrine->getManager(); $qb = $doctrine ->getRepository('OroActivityListBundle:ActivityList') ->getBaseActivityListQueryBuilder(Opportunity::class, 49); $listOfActivities = $qb->getQuery()->getResult(); $idToUpdate = []; foreach ($listOfActivities as $activity) { if ($activity->getRelatedActivityClass() == Task::class) { $idToUpdate[] = $activity->getRelatedActivityId(); } } if ($idToUpdate) { $qb = $em->createQueryBuilder(); $q = $qb->update('Oro\Bundle\TaskBundle\Entity\Task', 't') ->set('t.status', '?1') ->where('t.id IN (?2)') ->setParameter(1, 'closed') ->setParameter(2, $idToUpdate) ->getQuery(); $q->execute(); }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

$doctrine = $this->getDoctrine();         $em = $doctrine->getManager();           $qb = $doctrine             ->getRepository('OroActivityListBundle:ActivityList')             ->getBaseActivityListQueryBuilder(Opportunity::class, 49);           $listOfActivities = $qb->getQuery()->getResult();         $idToUpdate = [];           foreach ($listOfActivities as $activity) {             if ($activity->getRelatedActivityClass() == Task::class) {                 $idToUpdate[] = $activity->getRelatedActivityId();             }         }           if ($idToUpdate) {             $qb = $em->createQueryBuilder();             $q = $qb->update('Oro\Bundle\TaskBundle\Entity\Task', 't')                 ->set('t.status', '?1')                 ->where('t.id IN (?2)')                 ->setParameter(1, 'closed')                 ->setParameter(2, $idToUpdate)                 ->getQuery();             $q->execute();         }

[roberto.taschettoParticipant]

Hi @Mike,
I succesfully applied your code in order to close all task related to a closed opportunity, but when I go to Task detail I see that the status is “Closed” but “Task flow” status is “Open” and workflow “Close” button enabled.

It’s seems like that I have to update also the “workflow” status. How can I achive that?

Thank You,
Roberto

[Author]

Replies