How to Send mail to Context whose appointment is set in calendar event

Hi Team ,

We have a requirement wherein i need to send email to Customers(Leads) once a appointment to a context(Customer) is set by creating a calendar event.This is a similar requirement that was done for automatic email triggering when a lead is created which was handled using Processes (link for reference : Automatic mail trigger when Lead Created using process.yml.

Here i tried to go with processes but i am not knowing how to access the context’s email as only context’s name would be displayed in Calendar Event form. I also tried looking at Database structure for this wherein Context/lead mapping for this calendar events are done separately in a relation table which is linked with calendar event Id.Please find the Database structure screenshots for Calendar Event & relation table(oro_rel_46a29d1988a3cef5d4431f) given below:

I also tried going through the calendar Event form type wherein Its using a field called childEvents to display the contexts.
Please find the form type of Calendar Event given below: (Proj_Dir\vendor\oro\platform\src\Oro\Bundle\CalendarBundle\Form\Type\CalendarEventType.php)

PHP

public function buildForm(FormBuilderInterface $builder, array $options) { $builder ->add( 'title', 'text', [ 'required' => true, 'label' => 'oro.calendar.calendarevent.title.label' ] ) ->add( 'description', 'oro_resizeable_rich_text', [ 'required' => false, 'label' => 'oro.calendar.calendarevent.description.label' ] ) ->add( 'start', 'oro_datetime', [ 'required' => true, 'label' => 'oro.calendar.calendarevent.start.label', 'attr' => ['class' => 'start'], ] ) ->add( 'end', 'oro_datetime', [ 'required' => true, 'label' => 'oro.calendar.calendarevent.end.label', 'attr' => ['class' => 'end'], ] ) ->add( 'allDay', 'checkbox', [ 'required' => false, 'label' => 'oro.calendar.calendarevent.all_day.label' ] ) ->add( 'backgroundColor', 'oro_simple_color_picker', [ 'required' => false, 'label' => 'oro.calendar.calendarevent.background_color.label', 'color_schema' => 'oro_calendar.event_colors', 'empty_value' => 'oro.calendar.calendarevent.no_color', 'allow_empty_color' => true, 'allow_custom_color' => true ] ) ->add( 'reminders', 'oro_reminder_collection', [ 'required' => false, 'label' => 'oro.reminder.entity_plural_label' ] ) ->add( 'childEvents', 'oro_calendar_event_invitees', [ 'required' => false, 'label' => 'oro.calendar.calendarevent.invitation.label' ] ) ->add( 'notifyInvitedUsers', 'hidden', [ 'mapped' => false ] ); $builder->addEventListener(FormEvents::PRE_SET_DATA, [$this, 'preSetData']); $this->subscribeOnChildEvents($builder); }

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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84

public function buildForm(FormBuilderInterface $builder, array $options)     {         $builder             ->add(                 'title',                 'text',                 [                     'required' => true,                     'label'    => 'oro.calendar.calendarevent.title.label'                 ]             )             ->add(                 'description',                 'oro_resizeable_rich_text',                 [                     'required' => false,                     'label'    => 'oro.calendar.calendarevent.description.label'                 ]             )             ->add(                 'start',                 'oro_datetime',                 [                     'required' => true,                     'label'    => 'oro.calendar.calendarevent.start.label',                     'attr'     => ['class' => 'start'],                 ]             )             ->add(                 'end',                 'oro_datetime',                 [                     'required' => true,                     'label'    => 'oro.calendar.calendarevent.end.label',                     'attr'     => ['class' => 'end'],                 ]             )             ->add(                 'allDay',                 'checkbox',                 [                     'required' => false,                     'label'    => 'oro.calendar.calendarevent.all_day.label'                 ]             )             ->add(                 'backgroundColor',                 'oro_simple_color_picker',                 [                     'required'           => false,                     'label'              => 'oro.calendar.calendarevent.background_color.label',                     'color_schema'       => 'oro_calendar.event_colors',                     'empty_value'        => 'oro.calendar.calendarevent.no_color',                     'allow_empty_color'  => true,                     'allow_custom_color' => true                 ]             )             ->add(                 'reminders',                 'oro_reminder_collection',                 [                     'required' => false,                     'label'    => 'oro.reminder.entity_plural_label'                 ]             )             ->add(                 'childEvents',                 'oro_calendar_event_invitees',                 [                     'required' => false,                     'label'    => 'oro.calendar.calendarevent.invitation.label'                 ]             )             ->add(                 'notifyInvitedUsers',                 'hidden',                 [                     'mapped' => false                 ]             );           $builder->addEventListener(FormEvents::PRE_SET_DATA, [$this, 'preSetData']);         $this->subscribeOnChildEvents($builder);     }

Please need help in knowing how to go about with this, to trigger automatic mail to Customers(i.e Lead/Context & also if possible to Guests selected) who are related to the Calendar Event once a Calendar Event is created.

Thanks & Regards,
Shreyas S

Topic

[shreyasParticipant]

Hi Team ,

I was able to access Guests selected during Calendar Event Appointment Creation in Process.yml to send them auto mails once appointment is set to them using $calendar.owner.email . But the issue faced here is even if i am able to send mails to Guests who are set for that appointment, the process jobs are failing as shown below:

But when i donot select any guest & process job , i get a successfully finished Status & mail triggers to the one who has set the appointment (i.e User Logged In). i Dont know how to go about to solve with this issue. i guess there is a different way in accessing the emails through process.yml since there would be multiple mails to be sent for a calendar event created.
Please find below the Process.yml code:

YAML

send_appointment_mail: label: 'New Appointment' enabled: true entity: Oro\Bundle\CalendarBundle\Entity\CalendarEvent order: 20 actions_configuration: - @send_email_template: attribute: $.email from: 'madhur.h@gmail.com' to: $calendar.owner.email template: 'calendar_reminder' entity: $.data - @add_email_activity_target: email: $.email target_entity: $.data triggers: send_appointment_mail: - event: create priority: 0 queued: true time_shift: 5

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

send_appointment_mail:         label: 'New Appointment'         enabled: true         entity: Oro\Bundle\CalendarBundle\Entity\CalendarEvent         order: 20         actions_configuration:              - @send_email_template:                        attribute: $.email                        from: 'madhur.h@gmail.com'                        to: $calendar.owner.email                        template: 'calendar_reminder'                        entity: $.data              - @add_email_activity_target:                        email: $.email                        target_entity: $.data     triggers:    send_appointment_mail: - event: create priority: 0 queued: true time_shift: 5

In the above code i am able to access Guests using $calendar.owner.email

In the Calendar_reminder template i have used in process.yml above , i am unable to get proper link processed when a mail is received that is More Details link used to accept/Reject/tentatively attend meeting. Please find the screenshot given below:

Please find the source code slightly modified from existing Calendar_reminder template since process Job failed with existing Calendar_reminder template due to <style> issue for Entity :Calendar.

<table style="border-collapse: collapse; width: 480pt;" class="wrapper"> <tbody> <tr> <td style="background-color: #ffffff; padding: 4pt;"> <p><span>{{ entity.title }} is starting at {{ entity.start|date('F j, Y, g:i A') }}</span></p> <p><strong>When: </strong><br />{{ calendar_date_range(entity.start, entity.end, entity.allDay, 'F j, Y', 1) }}</p> <p><strong>Calendar: </strong><br />{{ entity.calendar }}</p> <p>details:</p> <p>{{ entity.description }}</p> <p></p> <p></p> </td> </tr> <tr> <td style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt;"><a href="http://shreyas.demosite.com/%7B%7B%20oro_config_value('oro_ui.application_url')%20%7D%7D%7B%7B%20path('oro_calendar_event_view',%20%7B'id'%3A%20entity.id%7D)%20%7D%7D" target="_blank" rel="nofollow">more details &raquo;</a></td> </tr> </tbody> </table>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

<table style="border-collapse: collapse; width: 480pt;" class="wrapper"> <tbody> <tr> <td style="background-color: #ffffff; padding: 4pt;"> <p><span>{{ entity.title }} is starting at {{ entity.start|date('F j, Y, g:i A') }}</span></p> <p><strong>When: </strong><br />{{ calendar_date_range(entity.start, entity.end, entity.allDay, 'F j, Y', 1) }}</p> <p><strong>Calendar: </strong><br />{{ entity.calendar }}</p> <p>details:</p> <p>{{ entity.description }}</p> <p></p> <p></p> </td> </tr> <tr> <td style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt;"><a href="http://shreyas.demosite.com/%7B%7B%20oro_config_value('oro_ui.application_url')%20%7D%7D%7B%7B%20path('oro_calendar_event_view',%20%7B'id'%3A%20entity.id%7D)%20%7D%7D" target="_blank" rel="nofollow">more details &raquo;</a></td> </tr> </tbody> </table>

Please need help in knowing how to resolve the above issues occured & Also in getting access to Contexts selected during Calendar Event Creation to send them automatic mails once an appointment is set.

Thanks & Regards,
Shreyas S

[shreyasParticipant]

Hi Team,

I was able to get Lead Id to get lead emails with the help of Curl using the Hardcoded Url set in code which is not best way to get this working. So i am trying to get lead/Account Id based on API name instead of Url since the Url can change but not API Name given by OroCRM.

Please find the Code Below wherein i have written a php class under Location:
Proj_Dir\src\Custom\Bundle\CalendarBundle\Service\GetContext.php

PHP

<?php namespace Custom\Bundle\CalendarBundle\Service; use Symfony\Component\PropertyAccess\PropertyAccess; class GetContext { /** * @param int $calendarId * @param string $chkifleadoraccount * @return int */ public function getLeadAccount($calendarId,$chkifleadoraccount) { $username = 'demo'; $apiUserKey = '6c123d583ce1cc365b33b4da8b8685d5535c678a'; //$uri = $_SERVER['HTTP_HOST'].'/'; $url = "http://shreyas.demosite.com/api/rest/latest/activities/calendarevents/$calendarId/context.json?_format=json"; $oroWsse = new Authentication($username, $apiUserKey); $headers = $oroWsse->getHeaders(); $resArr = array(); $options = array( CURLOPT_RETURNTRANSFER => true, // return web page CURLOPT_HEADER => false, // don't return headers CURLOPT_HTTPHEADER => $headers, CURLOPT_FOLLOWLOCATION => true, // follow redirects CURLOPT_MAXREDIRS => 10, // stop after 10 redirects CURLOPT_ENCODING => "", // handle compressed CURLOPT_USERAGENT => "test", // name of client CURLOPT_AUTOREFERER => true, // set referrer on redirect CURLOPT_CONNECTTIMEOUT => 120, // time-out on connect CURLOPT_TIMEOUT => 120, // time-out on response ); $ch = curl_init($url); curl_setopt_array($ch, $options); $content = curl_exec($ch); curl_close($ch); $resArr = json_decode($content); $contextid = ''; // $chkifleadoraccount; foreach($resArr as $re) { if(($chkifleadoraccount == 'OroCRM_Bundle_AccountBundle_Entity_Account') && ($re->targetClassName == 'OroCRM_Bundle_AccountBundle_Entity_Account')) { $contextid = $re->targetId; //Account id } else if(($chkifleadoraccount == 'OroCRM_Bundle_SalesBundle_Entity_Lead') && ($re->targetClassName == 'OroCRM_Bundle_SalesBundle_Entity_Lead')) { $contextid = $re->targetId; } else { //exception } } return $contextid; } } class Authentication { protected $_username; protected $_apiKey; /** * @param $username * @param $apiUserKey */ public function __construct($username, $apiUserKey) { $this->_username = $username; $this->_apiKey = $apiUserKey; } /** * @param $raw * @param $salt * @return string */ private function _encodePassword($raw, $salt) { $salted = $this->_mergePasswordAndSalt($raw, $salt); $digest = hash('sha1', $salted, true); return base64_encode($digest); } /** * @param string $password * @param string $salt * @return string * @throws \InvalidArgumentException */ private function _mergePasswordAndSalt($password, $salt) { if (empty($salt)) { return $password; } if (false !== strrpos($salt, '{') || false !== strrpos($salt, '}')) { throw new \InvalidArgumentException('Cannot use { or } in salt.'); } return $password . '{' . $salt . '}'; } /** * @return array */ public function getHeaders() { $prefix = gethostname(); $created = date('c'); $nonce = base64_encode(substr(md5(uniqid($prefix . '_', true)), 0, 16)); $salt = ''; // do not use real salt here, because API key already encrypted enough $passwordDigest = $this->_encodePassword(sprintf( '%s%s%s', base64_decode($nonce), $created, $this->_apiKey ), $salt ); $wsseProfile = sprintf( 'X-WSSE: UsernameToken Username="%s", PasswordDigest="%s", Nonce="%s", Created="%s"', $this->_username, $passwordDigest, $nonce, $created ); return array( 'Authorization: WSSE profile="UsernameToken"', $wsseProfile ); } }

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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129

<?php   namespace Custom\Bundle\CalendarBundle\Service;   use Symfony\Component\PropertyAccess\PropertyAccess;   class GetContext {     /**      * @param int $calendarId      * @param string $chkifleadoraccount      * @return int      */     public function getLeadAccount($calendarId,$chkifleadoraccount)     {         $username = 'demo';         $apiUserKey = '6c123d583ce1cc365b33b4da8b8685d5535c678a';         //$uri = $_SERVER['HTTP_HOST'].'/';         $url = "http://shreyas.demosite.com/api/rest/latest/activities/calendarevents/$calendarId/context.json?_format=json";                  $oroWsse = new Authentication($username, $apiUserKey);                     $headers = $oroWsse->getHeaders();         $resArr = array();         $options = array(         CURLOPT_RETURNTRANSFER => true,   // return web page         CURLOPT_HEADER         => false,  // don't return headers         CURLOPT_HTTPHEADER => $headers,         CURLOPT_FOLLOWLOCATION => true,   // follow redirects         CURLOPT_MAXREDIRS      => 10,     // stop after 10 redirects         CURLOPT_ENCODING       => "",     // handle compressed         CURLOPT_USERAGENT      => "test", // name of client         CURLOPT_AUTOREFERER    => true,   // set referrer on redirect         CURLOPT_CONNECTTIMEOUT => 120,    // time-out on connect         CURLOPT_TIMEOUT        => 120,    // time-out on response     );       $ch = curl_init($url);     curl_setopt_array($ch, $options);       $content  = curl_exec($ch);       curl_close($ch);            $resArr = json_decode($content);     $contextid = '';         // $chkifleadoraccount;     foreach($resArr as $re)     {         if(($chkifleadoraccount == 'OroCRM_Bundle_AccountBundle_Entity_Account') && ($re->targetClassName == 'OroCRM_Bundle_AccountBundle_Entity_Account'))         {         $contextid = $re->targetId; //Account id         }         else if(($chkifleadoraccount == 'OroCRM_Bundle_SalesBundle_Entity_Lead') && ($re->targetClassName == 'OroCRM_Bundle_SalesBundle_Entity_Lead'))         {             $contextid = $re->targetId;         }         else         {             //exception         }     }     return $contextid;   } }   class Authentication {       protected $_username;     protected $_apiKey;       /**      * @param $username      * @param $apiUserKey      */     public function __construct($username, $apiUserKey) {         $this->_username = $username;         $this->_apiKey = $apiUserKey;     }       /**      * @param $raw      * @param $salt      * @return string      */     private function _encodePassword($raw, $salt) {         $salted = $this->_mergePasswordAndSalt($raw, $salt);         $digest = hash('sha1', $salted, true);         return base64_encode($digest);     }       /**      * @param string $password      * @param string $salt      * @return string      * @throws \InvalidArgumentException      */     private function _mergePasswordAndSalt($password, $salt) {         if (empty($salt)) {             return $password;         }         if (false !== strrpos($salt, '{') || false !== strrpos($salt, '}')) {             throw new \InvalidArgumentException('Cannot use { or } in salt.');         }         return $password . '{' . $salt . '}';     }       /**      * @return array      */     public function getHeaders() {         $prefix = gethostname();         $created = date('c');         $nonce = base64_encode(substr(md5(uniqid($prefix . '_', true)), 0, 16));         $salt = ''; // do not use real salt here, because API key already encrypted enough         $passwordDigest = $this->_encodePassword(sprintf(                         '%s%s%s', base64_decode($nonce), $created, $this->_apiKey                 ), $salt         );         $wsseProfile = sprintf(                 'X-WSSE: UsernameToken Username="%s", PasswordDigest="%s", Nonce="%s", Created="%s"', $this->_username, $passwordDigest, $nonce, $created         );         return array(             'Authorization: WSSE profile="UsernameToken"',             $wsseProfile         );     }   }

Here in above code i am able to get data through CURL with the help Url with the API defined i.e:
http://shreyas.demosite.com/api/rest/latest/activities/calendarevents/$calendarId/context.json?_format=json
Where in CalendarId is passed through Process.yml. Here i don’t want to use Curl & the URL of API to get Data instead need to Call the API through its name which is working fine when i tested it in an controller function . Please find the code given below for tested Data obtained from API (Loc: Proj_Dir\src\Custom\Bundle\CalendarBundle\Controller\CalendarEventController.php):

PHP

/** * @param int $calendarId * @param string $chkifleadoraccount * @return int */ public function getLeadAccount($calendarId,$chkifleadoraccount) { $resArr = $this->getContainer()->get('oro_activity.manager.activity_context.api')->getActivityContext('Oro\Bundle\CalendarBundle\Entity\CalendarEvent',$calendarId); foreach($resArr as $re) { if(($chkifleadoraccount == 'OroCRM_Bundle_AccountBundle_Entity_Account') && ($re['targetClassName'] == 'OroCRM_Bundle_AccountBundle_Entity_Account')) { $contextid = $re['targetId']; //Account id } else if(($chkifleadoraccount == 'OroCRM_Bundle_SalesBundle_Entity_Lead') && ($re['targetClassName'] == 'OroCRM_Bundle_SalesBundle_Entity_Lead')) { $contextid = $re['targetId']; } else { //exception } } return $contextid; }

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

/**      * @param int $calendarId      * @param string $chkifleadoraccount      * @return int      */     public function getLeadAccount($calendarId,$chkifleadoraccount)     {         $resArr = $this->getContainer()->get('oro_activity.manager.activity_context.api')->getActivityContext('Oro\Bundle\CalendarBundle\Entity\CalendarEvent',$calendarId);            foreach($resArr as $re)         {         if(($chkifleadoraccount == 'OroCRM_Bundle_AccountBundle_Entity_Account') && ($re['targetClassName'] == 'OroCRM_Bundle_AccountBundle_Entity_Account'))         {         $contextid = $re['targetId']; //Account id         }         else if(($chkifleadoraccount == 'OroCRM_Bundle_SalesBundle_Entity_Lead') && ($re['targetClassName'] == 'OroCRM_Bundle_SalesBundle_Entity_Lead'))         {             $contextid = $re['targetId'];         }         else         {             //exception         }         }          return $contextid;       }

With this Code Snippet above i am able to fetch data . i.e .. LeadId / Account Id through the Call to this function.But if the same function if i have used in GetContext.php file , then in Process.yml i am unable to get the leads & process job fails.

Please find the partially working Process.yml that is able to fetch Lead Id from GetContext.php (implemented using Curl shown above) & get Lead/Account emails & send mail to them.

YAML

send_appointment_mail: label: 'New Appointment' enabled: true entity: Oro\Bundle\CalendarBundle\Entity\CalendarEvent order: 20 actions_configuration: - '@tree': actions: - '@create_object': attribute: $.lead class: Custom\Bundle\CalendarBundle\Service\GetContext - '@call_method': attribute: $.leadid object: $.lead method: 'getLeadAccount' method_parameters: [$id,'OroCRM_Bundle_SalesBundle_Entity_Lead'] - '@create_object': attribute: $.account class: Custom\Bundle\CalendarBundle\Service\GetContext - '@call_method': attribute: $.accid object: $.account method: 'getLeadAccount' method_parameters: [$id,'OroCRM_Bundle_AccountBundle_Entity_Account'] - '@find_entity': parameters: class: OroCRM\Bundle\SalesBundle\Entity\Lead attribute: $.leadobj where: id: $.leadid - '@find_entity': parameters: class: OroCRM\Bundle\AccountBundle\Entity\Account attribute: $.accobj where: id: $.accid - '@tree': conditions: '@not_empty': $.leadobj.email actions: - @send_email_template: attribute: $.email from: 'shreyas.s104@gmail.com' to: $.leadobj.email template: 'calendar_reminder' entity: $.data - @add_email_activity_target: email: $.email target_entity: $.data - '@tree': conditions: '@not_empty': $.accobj.primaryEmail actions: - @send_email_template: attribute: $.email from: 'shreyas.s104@gmail.com' to: $.accobj.primaryEmail template: 'calendar_reminder' entity: $.data - @add_email_activity_target: email: $.email target_entity: $.data # actions: #- '@foreach': # array: $calendar.owner.email # value: $.ownermail # actions: - @send_email_template: attribute: $.email from: 'shreyas.s104@gmail.com' to: $calendar.owner.email template: 'calendar_reminder' entity: $.data - @add_email_activity_target: email: $.email target_entity: $.data triggers: send_appointment_mail: - event: create priority: 0 queued: true time_shift: 5

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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84

send_appointment_mail:         label: 'New Appointment'         enabled: true         entity: Oro\Bundle\CalendarBundle\Entity\CalendarEvent         order: 20         actions_configuration:             - '@tree':                 actions:                     - '@create_object':                         attribute: $.lead                         class: Custom\Bundle\CalendarBundle\Service\GetContext                     - '@call_method':                         attribute: $.leadid                         object: $.lead                         method: 'getLeadAccount'                         method_parameters: [$id,'OroCRM_Bundle_SalesBundle_Entity_Lead']                     - '@create_object':                         attribute: $.account                         class: Custom\Bundle\CalendarBundle\Service\GetContext                     - '@call_method':                         attribute: $.accid                         object: $.account                         method: 'getLeadAccount'                         method_parameters: [$id,'OroCRM_Bundle_AccountBundle_Entity_Account']                       - '@find_entity':                         parameters:                             class:     OroCRM\Bundle\SalesBundle\Entity\Lead                             attribute: $.leadobj                             where:                                 id: $.leadid                     - '@find_entity':                         parameters:                             class:     OroCRM\Bundle\AccountBundle\Entity\Account                             attribute: $.accobj                             where:                                 id: $.accid                     - '@tree':                         conditions:                             '@not_empty': $.leadobj.email                         actions:                             - @send_email_template:                                 attribute: $.email                                 from: 'shreyas.s104@gmail.com'                                 to: $.leadobj.email                                 template: 'calendar_reminder'                                 entity: $.data                             - @add_email_activity_target:                                 email: $.email                                 target_entity: $.data                     - '@tree':                                             conditions:                             '@not_empty': $.accobj.primaryEmail                         actions:                             - @send_email_template:                                 attribute: $.email                                 from: 'shreyas.s104@gmail.com'                                 to: $.accobj.primaryEmail                                 template: 'calendar_reminder'                                 entity: $.data                             - @add_email_activity_target:                                 email: $.email                                 target_entity: $.data                     #    actions:                     #- '@foreach':                     #    array: $calendar.owner.email                     #    value: $.ownermail                     #    actions:                     - @send_email_template:                          attribute: $.email                          from: 'shreyas.s104@gmail.com'                          to: $calendar.owner.email                          template: 'calendar_reminder'                          entity: $.data                     - @add_email_activity_target:                          email: $.email                          target_entity: $.data triggers:     send_appointment_mail:         -             event: create             priority: 0             queued: true             time_shift: 5

Here in above Process.yml i am calling getLeadAccount from GetContext.php to get Lead Id/Account Id & passing it to respective entities to fetch their mail Id & sending it to send_email_template.

Now using the Above Codes for Process.yml & GetContext.php i am able to get lead’s emails & process to send auto emails once appointment is created. But i would slightly need to change the GetContext.php file to not use Curl & API URL instead use the code i have tested in CalendarEventController shown above (i.e function getLeadAccount which contains logic written which used API Name to retrieve data)

Please find the Code for GetContext.php i am trying now to eliminate the use of Curl Logic shown above:

PHP

<?php namespace Custom\Bundle\CalendarBundle\Service; class GetContext { protected $container; /** * @param int $calendarId * @param string $chkifleadoraccount * @return int */ public function getLeadAccount($calendarId,$chkifleadoraccount) { $resArr = $GLOBALS['kernel']->getContainer()->get('oro_activity.manager.activity_context.api')->getActivityContext('Oro\Bundle\CalendarBundle\Entity\CalendarEvent',$calendarId); foreach($resArr as $re) { if(($chkifleadoraccount == 'OroCRM_Bundle_AccountBundle_Entity_Account') && ($re['targetClassName'] == 'OroCRM_Bundle_AccountBundle_Entity_Account')) { $contextid = $re['targetId']; //Account id } else if(($chkifleadoraccount == 'OroCRM_Bundle_SalesBundle_Entity_Lead') && ($re['targetClassName'] == 'OroCRM_Bundle_SalesBundle_Entity_Lead')) { $contextid = $re['targetId']; } else { } } return $contextid; } }

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

<?php   namespace Custom\Bundle\CalendarBundle\Service;   class GetContext {        protected $container;               /**      * @param int $calendarId      * @param string $chkifleadoraccount      * @return int      */     public function getLeadAccount($calendarId,$chkifleadoraccount)     {                  $resArr = $GLOBALS['kernel']->getContainer()->get('oro_activity.manager.activity_context.api')->getActivityContext('Oro\Bundle\CalendarBundle\Entity\CalendarEvent',$calendarId);            foreach($resArr as $re)         {         if(($chkifleadoraccount == 'OroCRM_Bundle_AccountBundle_Entity_Account') && ($re['targetClassName'] == 'OroCRM_Bundle_AccountBundle_Entity_Account'))         {         $contextid = $re['targetId']; //Account id         }         else if(($chkifleadoraccount == 'OroCRM_Bundle_SalesBundle_Entity_Lead') && ($re['targetClassName'] == 'OroCRM_Bundle_SalesBundle_Entity_Lead'))         {             $contextid = $re['targetId'];         }         else         {         }         }          return $contextid;            }      }

Here i am trying to use the API ‘oro_activity.manager.activity_context.api’ to get result. I have used $GLOBALS[‘kernel’] since i would not have access to get() method to call.This Code is working fine when i am trying to write service to this Code & call it in a Controller as shown below:

YAML

parameters: custom_association.service.getcontext.class: Custom\Bundle\CalendarBundle\Service\GetContext services: custom_association.service.getcontext: class: %custom_association.service.getcontext.class%

1 2 3 4 5

parameters:     custom_association.service.getcontext.class:          Custom\Bundle\CalendarBundle\Service\GetContext services:     custom_association.service.getcontext:         class: %custom_association.service.getcontext.class%

Please find the Service for GetContext.php Called in Controller which is working fine to get the result id shown below:

PHP

/** * @Route("/testcode/{id}", name="oro_calendar_event_getcontexttest", requirements={"id"="\d+"}) * * */ public function chkworkingcode($id) { $res = $this->get('custom_association.service.getcontext')->getLeadAccount($id,'OroCRM_Bundle_SalesBundle_Entity_Lead'); print_r($res); }

1 2 3 4 5 6 7 8 9 10

/**      * @Route("/testcode/{id}", name="oro_calendar_event_getcontexttest", requirements={"id"="\d+"})      *      *      */     public function chkworkingcode($id)     {          $res = $this->get('custom_association.service.getcontext')->getLeadAccount($id,'OroCRM_Bundle_SalesBundle_Entity_Lead');          print_r($res);     }

Now with these Code Changes when i try to use in process.yml , it does not work & process Job fails.

I also tried different ways to get it working in Process.yml but i am stuck on how to solve this issue.
Some of things tried were implementing ContainerAwareInterface in GetContext Class & adding a setContainer Method which would initialize container which would be used further in code. This setContainer would be called through service once this class object is created.

Please find the code for GetContext.php file given below:

PHP

namespace Custom\Bundle\CalendarBundle\Service; use Symfony\Component\DependencyInjection\ContainerAwareInterface; use Symfony\Component\DependencyInjection\ContainerAwareTrait; use Symfony\Component\DependencyInjection\ContainerInterface; class GetContext implements ContainerAwareInterface { // use ContainerAwareTrait; // protected $container; /** * {@inheritdoc} */ public function setContainer(ContainerInterface $container = null) { $this->container = $container; } /** * @param int $calendarId * @param string $chkifleadoraccount * @return int */ public function getLeadAccount($calendarId,$chkifleadoraccount) { $resArr = $this->container->get('oro_activity.manager.activity_context.api')->getActivityContext('Oro\Bundle\CalendarBundle\Entity\CalendarEvent',$calendarId); foreach($resArr as $re) { if(($chkifleadoraccount == 'OroCRM_Bundle_AccountBundle_Entity_Account') && ($re['targetClassName'] == 'OroCRM_Bundle_AccountBundle_Entity_Account')) { $contextid = $re['targetId']; //Account id } else if(($chkifleadoraccount == 'OroCRM_Bundle_SalesBundle_Entity_Lead') && ($re['targetClassName'] == 'OroCRM_Bundle_SalesBundle_Entity_Lead')) { $contextid = $re['targetId']; } else { } } return $contextid; } }

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

namespace Custom\Bundle\CalendarBundle\Service; use Symfony\Component\DependencyInjection\ContainerAwareInterface; use Symfony\Component\DependencyInjection\ContainerAwareTrait; use Symfony\Component\DependencyInjection\ContainerInterface;   class GetContext implements ContainerAwareInterface {   // use ContainerAwareTrait;   //  protected $container;       /**      * {@inheritdoc}      */     public function setContainer(ContainerInterface $container = null)     {         $this->container = $container;     }     /**      * @param int $calendarId      * @param string $chkifleadoraccount      * @return int      */     public function getLeadAccount($calendarId,$chkifleadoraccount)     {         $resArr = $this->container->get('oro_activity.manager.activity_context.api')->getActivityContext('Oro\Bundle\CalendarBundle\Entity\CalendarEvent',$calendarId);            foreach($resArr as $re)         {         if(($chkifleadoraccount == 'OroCRM_Bundle_AccountBundle_Entity_Account') && ($re['targetClassName'] == 'OroCRM_Bundle_AccountBundle_Entity_Account'))         {         $contextid = $re['targetId']; //Account id         }         else if(($chkifleadoraccount == 'OroCRM_Bundle_SalesBundle_Entity_Lead') && ($re['targetClassName'] == 'OroCRM_Bundle_SalesBundle_Entity_Lead'))         {             $contextid = $re['targetId'];         }         else         {         }         }          return $contextid;            }           }

In Services.yml changed the previous configuration of service custom_association.service.getcontext to given below:

YAML

custom_association.service.getcontext: class: %custom_association.service.getcontext.class% calls: - [setContainer,['@service_container']]

1 2 3 4

custom_association.service.getcontext:         class: %custom_association.service.getcontext.class%         calls:             - [setContainer,['@service_container']]

This is working again when called from controller but is not working in Process.yml i.e in process job shows failed status with no further errors nor any log.

Please need help on how to go about with this issue.
Thanks & Regards,
Shreyas S

[Mike KudelyaParticipant]

Hi,

I modified a bit your code. My process sends emails to account and lead.

services.yml:

YAML

parameters: custom_oro.calendar_context.provider.class: Custom\Bundle\OroBundle\Provider\CalendarContext services: custom_oro.calendar_context.provider: class: %custom_oro.calendar_context.provider.class% arguments: - '@doctrine.orm.entity_manager'

1 2 3 4 5 6 7 8

parameters:     custom_oro.calendar_context.provider.class: Custom\Bundle\OroBundle\Provider\CalendarContext   services:     custom_oro.calendar_context.provider:         class: %custom_oro.calendar_context.provider.class%         arguments:             - '@doctrine.orm.entity_manager'

CalendarContext.php:

PHP

<?php namespace Custom\Bundle\OroBundle\Provider; use Doctrine\ORM\EntityManager; use Oro\Bundle\ActivityBundle\Model\ActivityInterface; use OroCRM\Bundle\AccountBundle\Entity\Account; use OroCRM\Bundle\SalesBundle\Entity\Lead; class CalendarContext { /** * @var EntityManager */ protected $entityManager; /** * @param EntityManager $entityManager */ public function __construct(EntityManager $entityManager) { $this->entityManager = $entityManager; } /** * @param int $calendarId * * @return array */ public function getCalendarContextEmails($calendarId) { $emails = []; $contexts = $this->getActivityContext($calendarId); foreach ($contexts as $context) { if($context instanceof Account) { $emails[] = $context->getEmail(); } elseif($context instanceof Lead) { $emails[] = $context->getPrimaryEmail()->getEmail(); } } return $emails; } /** * @param int $id * * @return array */ public function getActivityContext($id) { $entity = $this->entityManager->getRepository('OroCalendarBundle:CalendarEvent')->find($id); if (!$entity || !$entity instanceof ActivityInterface) { return []; } return $entity->getActivityTargetEntities(); } }

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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65

<?php   namespace Custom\Bundle\OroBundle\Provider;   use Doctrine\ORM\EntityManager;   use Oro\Bundle\ActivityBundle\Model\ActivityInterface;   use OroCRM\Bundle\AccountBundle\Entity\Account; use OroCRM\Bundle\SalesBundle\Entity\Lead;   class CalendarContext {     /**      * @var EntityManager      */     protected $entityManager;       /**      * @param EntityManager $entityManager      */     public function __construct(EntityManager $entityManager)     {         $this->entityManager = $entityManager;     }       /**      * @param int $calendarId      *      * @return array      */     public function getCalendarContextEmails($calendarId)     {         $emails = [];           $contexts = $this->getActivityContext($calendarId);           foreach ($contexts as $context) {             if($context instanceof Account) {                 $emails[] = $context->getEmail();             }             elseif($context instanceof Lead) {                 $emails[] = $context->getPrimaryEmail()->getEmail();             }         }           return $emails;     }       /**      * @param int $id      *      * @return array      */     public function getActivityContext($id)     {         $entity = $this->entityManager->getRepository('OroCalendarBundle:CalendarEvent')->find($id);           if (!$entity || !$entity instanceof ActivityInterface) {             return [];         }           return $entity->getActivityTargetEntities();     } }

process.yml:

YAML

definitions: send_calendar_mail: label: 'Calendar Email' enabled: true entity: Oro\Bundle\CalendarBundle\Entity\CalendarEvent order: 20 actions_configuration: - '@tree': actions: - '@call_service_method': service: custom_oro.calendar_context.provider method: getCalendarContextEmails method_parameters: ['$id'] attribute: $.contextEmails - '@foreach': array: $.contextEmails value: $.email actions: - '@send_email_template': attribute: $.email from: '@gmail.com' to: $.email template: 'calendar_reminder' entity: $.data triggers: send_calendar_mail: - event: create priority: 0 queued: true time_shift: 1

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

definitions:     send_calendar_mail:         label: 'Calendar Email'         enabled: true         entity: Oro\Bundle\CalendarBundle\Entity\CalendarEvent         order: 20         actions_configuration:             - '@tree':                 actions:                     - '@call_service_method':                         service: custom_oro.calendar_context.provider                         method: getCalendarContextEmails                         method_parameters: ['$id']                         attribute: $.contextEmails                     - '@foreach':                         array: $.contextEmails                         value: $.email                         actions:                             - '@send_email_template':                                 attribute: $.email                                 from: '@gmail.com'                                 to: $.email                                 template: 'calendar_reminder'                                 entity: $.data   triggers:     send_calendar_mail:         -             event: create             priority: 0             queued: true             time_shift: 1

[shreyasParticipant]

Thanks a lot Mike for the solution.It Worked as expected!!!

Thanks & Regards,
Shreyas S

[Author]

Replies