/** * Enable activities * * @param Schema $schema * @param ActivityExtension $activityExtension */ public static function addActivityAssociations(Schema $schema, ActivityExtension $activityExtension) { $associationTableName = $activityExtension->getAssociationTableName('orocrm_task', 'orocrm_magento_order'); if (!$schema->hasTable($associationTableName)) { $activityExtension->addActivityAssociation($schema, 'orocrm_task', 'orocrm_magento_order'); } $associationTableName = $activityExtension->getAssociationTableName('orocrm_task', 'orocrm_magento_order'); if (!$schema->hasTable($associationTableName)) { $activityExtension->addActivityAssociation($schema, 'oro_calendar_event', 'orocrm_magento_order'); } }
/** * @return string */ protected function getFillOrderCallActivityListQuery() { $sql = 'INSERT INTO %s (activitylist_id, order_id)' . ' SELECT al.id, rel.order_id' . ' FROM oro_activity_list al' . ' JOIN %s rel ON rel.call_id = al.related_activity_id' . ' AND al.related_activity_class = :class'; return sprintf($sql, $this->activityListExtension->getAssociationTableName('orocrm_magento_order'), $this->activityExtension->getAssociationTableName('orocrm_call', 'orocrm_magento_order')); }