FillActivityAssociationTables::setActivityExtension() - Code Metrics - Inspection of "Merge remote-tracking branch 'remotes/dev/master'" - orocrm/crm - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 341743...7fbf31 )

unknown

created 2016-01-26 07:01 UTC

setActivityExtension() A

↳ Parent: FillActivityAssociationTables

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
c	1
b	0
f	1
dl	0
loc	4
rs	10
cc	1
eloc	2
nc	1
nop	1

<?php

namespace OroCRM\Bundle\ContactUsBundle\Migrations\Schema\v1_10;

use Doctrine\DBAL\Types\Type;
use Doctrine\DBAL\Schema\Schema;

use Oro\Bundle\MigrationBundle\Migration\QueryBag;
use Oro\Bundle\MigrationBundle\Migration\Migration;
use Oro\Bundle\MigrationBundle\Migration\SqlMigrationQuery;
use Oro\Bundle\MigrationBundle\Migration\ParametrizedSqlMigrationQuery;
use Oro\Bundle\MigrationBundle\Migration\OrderedMigrationInterface;

use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension;
use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface;

use Oro\Bundle\ActivityBundle\Migration\Extension\ActivityExtension;
use Oro\Bundle\ActivityBundle\Migration\Extension\ActivityExtensionAwareInterface;

use Oro\Bundle\ActivityListBundle\Migration\Extension\ActivityListExtension;
use Oro\Bundle\ActivityListBundle\Migration\Extension\ActivityListExtensionAwareInterface;

class FillActivityAssociationTables implements
    Migration,
    OrderedMigrationInterface,
    ExtendExtensionAwareInterface,
    ActivityExtensionAwareInterface,
    ActivityListExtensionAwareInterface
{
    /** @var ExtendExtension */
    protected $extendExtension;

    /** @var ActivityExtension */
    protected $activityExtension;

    /** @var ActivityListExtension */
    protected $activityListExtension;

    /**
     * {@inheritdoc}
     */
    public function setExtendExtension(ExtendExtension $extendExtension)
    {
        $this->extendExtension = $extendExtension;
    }

    /**
     * {@inheritdoc}
     */
    public function setActivityExtension(ActivityExtension $activityExtension)
    {
        $this->activityExtension = $activityExtension;
    }

    /**
     * {@inheritdoc}
     */
    public function setActivityListExtension(ActivityListExtension $activityListExtension)
    {
        $this->activityListExtension = $activityListExtension;
    }

    /**
     * {@inheritdoc}
     */
    public function getOrder()
    {
        return 2;
    }

    /**
     * {@inheritdoc}
     */
    public function up(Schema $schema, QueryBag $queries)
    {
        $this->fillActivityTables($queries);
        $this->fillActivityListTables($queries);

        // Remove orocrm_contactus_req_emails
        $table = $schema->getTable('orocrm_contactus_req_emails');
        $table->removeForeignKey('FK_E494F7AE427EB8A5');
        $table->removeForeignKey('FK_E494F7AEA832C1C9');
        $schema->dropTable('orocrm_contactus_req_emails');

        // Remove orocrm_contactus_request_calls
        $table = $schema->getTable('orocrm_contactus_request_calls');
        $table->removeForeignKey('FK_6F7A50CE427EB8A5');
        $table->removeForeignKey('FK_6F7A50CE50A89B2C');
        $schema->dropTable('orocrm_contactus_request_calls');

    }

    /**
     * @param QueryBag $queries
     */
    protected function fillActivityTables(QueryBag $queries)
    {
        $queries->addPreQuery(
            new SqlMigrationQuery(
                [$this->getFillContactRequestEmailActivityQuery(), $this->getFillContactRequestCallActivityQuery()]
            )
        );
    }

    /**
     * @param QueryBag $queries
     */
    protected function fillActivityListTables(QueryBag $queries)
    {
        // Fill activitylists tables
        $queries->addPreQuery(
            new ParametrizedSqlMigrationQuery(
                $this->getFillContactRequestEmailActivityListQuery(),
                ['class' => 'Oro\Bundle\EmailBundle\Entity\Email'],
                ['class' => Type::STRING]
            )
        );
        $queries->addPreQuery(
            new ParametrizedSqlMigrationQuery(
                $this->getFillContactRequestCallActivityListQuery(),
                ['class' => 'OroCRM\Bundle\CallBundle\Entity\Call'],
                ['class' => Type::STRING]
            )
        );
    }

    /**
     * @return string
     */
    protected function getFillContactRequestEmailActivityQuery()
    {
        $sql = 'INSERT INTO %s (email_id, contactrequest_id)' .
               ' SELECT email_id, request_id' .
               ' FROM orocrm_contactus_req_emails';

        return sprintf(
            $sql,
            $this->activityExtension->getAssociationTableName('oro_email', 'orocrm_contactus_request')

        );
    }

    /**
     * @return string
     */
    protected function getFillContactRequestCallActivityQuery()
    {
        $sql = 'INSERT INTO %s (call_id, contactrequest_id)' .
               ' SELECT call_id, request_id' .
               ' FROM orocrm_contactus_request_calls';

        return sprintf(
            $sql,
            $this->activityExtension->getAssociationTableName('orocrm_call', 'orocrm_contactus_request')

        );
    }

    /**
     * @return string
     */
    protected function getFillContactRequestEmailActivityListQuery()

    {
        $sql = 'INSERT INTO %s (activitylist_id, contactrequest_id)' .
               ' SELECT al.id, rel.contactrequest_id' .
               ' FROM oro_activity_list al' .
               ' JOIN %s rel ON rel.email_id = al.related_activity_id' .
               ' AND al.related_activity_class = :class';

        return sprintf(
            $sql,
            $this->activityListExtension->getAssociationTableName('orocrm_contactus_request'),

            $this->activityExtension->getAssociationTableName('oro_email', 'orocrm_contactus_request')

        );
    }

    /**
     * @return string
     */
    protected function getFillContactRequestCallActivityListQuery()

    {
        $sql = 'INSERT INTO %s (activitylist_id, contactrequest_id)' .
               ' SELECT al.id, rel.contactrequest_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_contactus_request'),

            $this->activityExtension->getAssociationTableName('orocrm_call', 'orocrm_contactus_request')

        );
    }
}


1		<?php
2
3		namespace OroCRM\Bundle\ContactUsBundle\Migrations\Schema\v1_10;
4
5		use Doctrine\DBAL\Types\Type;
6		use Doctrine\DBAL\Schema\Schema;
7
8		use Oro\Bundle\MigrationBundle\Migration\QueryBag;
9		use Oro\Bundle\MigrationBundle\Migration\Migration;
10		use Oro\Bundle\MigrationBundle\Migration\SqlMigrationQuery;
11		use Oro\Bundle\MigrationBundle\Migration\ParametrizedSqlMigrationQuery;
12		use Oro\Bundle\MigrationBundle\Migration\OrderedMigrationInterface;
13
14		use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension;
15		use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface;
16
17		use Oro\Bundle\ActivityBundle\Migration\Extension\ActivityExtension;
18		use Oro\Bundle\ActivityBundle\Migration\Extension\ActivityExtensionAwareInterface;
19
20		use Oro\Bundle\ActivityListBundle\Migration\Extension\ActivityListExtension;
21		use Oro\Bundle\ActivityListBundle\Migration\Extension\ActivityListExtensionAwareInterface;
22
23		class FillActivityAssociationTables implements
24		Migration,
25		OrderedMigrationInterface,
26		ExtendExtensionAwareInterface,
27		ActivityExtensionAwareInterface,
28		ActivityListExtensionAwareInterface
29		{
30		/** @var ExtendExtension */
31		protected $extendExtension;
32
33		/** @var ActivityExtension */
34		protected $activityExtension;
35
36		/** @var ActivityListExtension */
37		protected $activityListExtension;
38
39		/**
40		* {@inheritdoc}
41		*/
42		public function setExtendExtension(ExtendExtension $extendExtension)
43		{
44		$this->extendExtension = $extendExtension;
45		}
46
47		/**
48		* {@inheritdoc}
49		*/
50		public function setActivityExtension(ActivityExtension $activityExtension)
51		{
52		$this->activityExtension = $activityExtension;
53		}
54
55		/**
56		* {@inheritdoc}
57		*/
58		public function setActivityListExtension(ActivityListExtension $activityListExtension)
59		{
60		$this->activityListExtension = $activityListExtension;
61		}
62
63		/**
64		* {@inheritdoc}
65		*/
66		public function getOrder()
67		{
68		return 2;
69		}
70
71		/**
72		* {@inheritdoc}
73		*/
74		public function up(Schema $schema, QueryBag $queries)
75		{
76		$this->fillActivityTables($queries);
77		$this->fillActivityListTables($queries);
78
79		// Remove orocrm_contactus_req_emails
80		$table = $schema->getTable('orocrm_contactus_req_emails');
81		$table->removeForeignKey('FK_E494F7AE427EB8A5');
82		$table->removeForeignKey('FK_E494F7AEA832C1C9');
83		$schema->dropTable('orocrm_contactus_req_emails');
84
85		// Remove orocrm_contactus_request_calls
86		$table = $schema->getTable('orocrm_contactus_request_calls');
87		$table->removeForeignKey('FK_6F7A50CE427EB8A5');
88		$table->removeForeignKey('FK_6F7A50CE50A89B2C');
89		$schema->dropTable('orocrm_contactus_request_calls');
90
91		}
92
93		/**
94		* @param QueryBag $queries
95		*/
96		protected function fillActivityTables(QueryBag $queries)
97		{
98		$queries->addPreQuery(
99		new SqlMigrationQuery(
100		[$this->getFillContactRequestEmailActivityQuery(), $this->getFillContactRequestCallActivityQuery()]
101		)
102		);
103		}
104
105		/**
106		* @param QueryBag $queries
107		*/
108		protected function fillActivityListTables(QueryBag $queries)
109		{
110		// Fill activitylists tables
111		$queries->addPreQuery(
112		new ParametrizedSqlMigrationQuery(
113		$this->getFillContactRequestEmailActivityListQuery(),
114		['class' => 'Oro\Bundle\EmailBundle\Entity\Email'],
115		['class' => Type::STRING]
116		)
117		);
118		$queries->addPreQuery(
119		new ParametrizedSqlMigrationQuery(
120		$this->getFillContactRequestCallActivityListQuery(),
121		['class' => 'OroCRM\Bundle\CallBundle\Entity\Call'],
122		['class' => Type::STRING]
123		)
124		);
125		}
126
127		/**
128		* @return string
129		*/
130		protected function getFillContactRequestEmailActivityQuery()
131		{
132		$sql = 'INSERT INTO %s (email_id, contactrequest_id)' .
133		' SELECT email_id, request_id' .
134		' FROM orocrm_contactus_req_emails';
135
136		return sprintf(
137		$sql,
138		$this->activityExtension->getAssociationTableName('oro_email', 'orocrm_contactus_request')
		0 ignored issues – show Bug introduced 2016-01-26 07:10 UTC by Report Bug Copy Issue Report The method `getAssociationTableName()` does not seem to exist on `object<Oro\Bundle\Activi...sion\ActivityExtension>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
139		);
140		}
141
142		/**
143		* @return string
144		*/
145		protected function getFillContactRequestCallActivityQuery()
146		{
147		$sql = 'INSERT INTO %s (call_id, contactrequest_id)' .
148		' SELECT call_id, request_id' .
149		' FROM orocrm_contactus_request_calls';
150
151		return sprintf(
152		$sql,
153		$this->activityExtension->getAssociationTableName('orocrm_call', 'orocrm_contactus_request')
		0 ignored issues – show Bug introduced 2016-01-26 07:10 UTC by Report Bug Copy Issue Report The method `getAssociationTableName()` does not seem to exist on `object<Oro\Bundle\Activi...sion\ActivityExtension>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
154		);
155		}
156
157		/**
158		* @return string
159		*/
160	View Code Duplication	protected function getFillContactRequestEmailActivityListQuery()
		0 ignored issues – show Duplication introduced 2016-01-26 07:10 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
161		{
162		$sql = 'INSERT INTO %s (activitylist_id, contactrequest_id)' .
163		' SELECT al.id, rel.contactrequest_id' .
164		' FROM oro_activity_list al' .
165		' JOIN %s rel ON rel.email_id = al.related_activity_id' .
166		' AND al.related_activity_class = :class';
167
168		return sprintf(
169		$sql,
170		$this->activityListExtension->getAssociationTableName('orocrm_contactus_request'),
		0 ignored issues – show Bug introduced 2016-01-26 07:10 UTC by Report Bug Copy Issue Report The method `getAssociationTableName()` does not seem to exist on `object<Oro\Bundle\Activi...\ActivityListExtension>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
171		$this->activityExtension->getAssociationTableName('oro_email', 'orocrm_contactus_request')
		0 ignored issues – show Bug introduced 2016-01-26 07:10 UTC by Report Bug Copy Issue Report The method `getAssociationTableName()` does not seem to exist on `object<Oro\Bundle\Activi...sion\ActivityExtension>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
172		);
173		}
174
175		/**
176		* @return string
177		*/
178	View Code Duplication	protected function getFillContactRequestCallActivityListQuery()
		0 ignored issues – show Duplication introduced 2015-11-25 07:11 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
179		{
180		$sql = 'INSERT INTO %s (activitylist_id, contactrequest_id)' .
181		' SELECT al.id, rel.contactrequest_id' .
182		' FROM oro_activity_list al' .
183		' JOIN %s rel ON rel.call_id = al.related_activity_id' .
184		' AND al.related_activity_class = :class';
185
186		return sprintf(
187		$sql,
188		$this->activityListExtension->getAssociationTableName('orocrm_contactus_request'),
		0 ignored issues – show Bug introduced 2016-01-26 07:10 UTC by Report Bug Copy Issue Report The method `getAssociationTableName()` does not seem to exist on `object<Oro\Bundle\Activi...\ActivityListExtension>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
189		$this->activityExtension->getAssociationTableName('orocrm_call', 'orocrm_contactus_request')
		0 ignored issues – show Bug introduced 2016-01-26 07:10 UTC by Report Bug Copy Issue Report The method `getAssociationTableName()` does not seem to exist on `object<Oro\Bundle\Activi...sion\ActivityExtension>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
190		);
191		}
192		}
193

orocrm / crm

Push — master ( 341743...7fbf31 )

setActivityExtension() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like