OroCRM\Bundle\SalesBundle\Migrations\Schema\v1_24\RemoveLeadStatus

Complexity

Total Complexity

7

Size/Duplication

Total Lines	38
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getOrder()	0	4	1
B	up()	0	24	6

<?php

namespace OroCRM\Bundle\SalesBundle\Migrations\Schema\v1_24;

use Doctrine\DBAL\Schema\Schema;

use Oro\Bundle\MigrationBundle\Migration\OrderedMigrationInterface;

use Oro\Bundle\MigrationBundle\Migration\Migration;
use Oro\Bundle\MigrationBundle\Migration\QueryBag;

class RemoveLeadStatus implements Migration, OrderedMigrationInterface
{
    /**
     * {@inheritdoc}
     */
    public function getOrder()
    {
        return 3;
    }

    /**
     * {@inheritdoc}
     */
    public function up(Schema $schema, QueryBag $queries)
    {
        $table = $schema->getTable('orocrm_sales_lead');
        $statusColumnName = 'status_name';

        $leadForeignKeyList = $table->getForeignKeys();
        foreach ($leadForeignKeyList as $foreignKey) {
            $foreingKeyColumns = $foreignKey->getUnquotedLocalColumns();
            if (in_array($statusColumnName, $foreingKeyColumns, true)) {
                $table->removeForeignKey($foreignKey->getName());
            }
        }

        $leadIndexList = $table->getIndexes();
        foreach ($leadIndexList as $index) {
            if ($index->hasColumnAtPosition($statusColumnName, 0)) {
                $table->dropIndex($index->getName());
            }
        }

        if ($table->hasColumn($statusColumnName)) {
            $table->dropColumn($statusColumnName);
        }
    }
}