YetiForceCompany/YetiForceCRM

View on GitHub
modules/Products/relations/GetProductPricebooks.php

Summary

Maintainability
A
2 hrs
Test Coverage
F
0%

Missing class import via use statement (line '60', column '13').
Open

        if (!(new App\Db\Query())->from(self::TABLE_NAME)->where($data)->exists()) {

MissingImport

Since: 2.7.0

Importing all external classes in a file through use statements makes them clearly visible.

Example

function make() {
    return new \stdClass();
}

Source http://phpmd.org/rules/cleancode.html#MissingImport

Missing class import via use statement (line '37', column '25').
Open

        $queryByProduct = new \App\QueryGenerator($this->relationModel->getParentModuleModel()->getName());

MissingImport

Since: 2.7.0

Importing all external classes in a file through use statements makes them clearly visible.

Example

function make() {
    return new \stdClass();
}

Source http://phpmd.org/rules/cleancode.html#MissingImport

Avoid assigning values to variables in if clauses and the like (line '38', column '8').
Open

    public function getQuery()
    {
        $tableName = self::TABLE_NAME;
        $queryGenerator = $this->relationModel->getQueryGenerator()
            ->setCustomColumn("{$tableName}.listprice")

IfStatementAssignment

Since: 2.7.0

Assignments in if clauses and the like are considered a code smell. Assignments in PHP return the right operand as their result. In many cases, this is an expected behavior, but can lead to many difficult to spot bugs, especially when the right operand could result in zero, null or an empty string and the like.

Example

class Foo
{
    public function bar($flag)
    {
        if ($foo = 'bar') { // possible typo
            // ...
        }
        if ($baz = 0) { // always false
            // ...
        }
    }
}

Source http://phpmd.org/rules/cleancode.html#ifstatementassignment

Define a constant instead of duplicating this literal "pricebookid" 3 times.
Open

            ->delete(self::TABLE_NAME, ['pricebookid' => $destinationRecordId, 'productid' => $sourceRecordId])

Duplicated string literals make the process of refactoring error-prone, since you must be sure to update all occurrences.

On the other hand, constants can be referenced from many places, but only need to be updated in a single place.

Noncompliant Code Example

With the default threshold of 3:

function run() {
  prepare('action1');                              // Non-Compliant - 'action1' is duplicated 3 times
  execute('action1');
  release('action1');
}

Compliant Solution

ACTION_1 = 'action1';

function run() {
  prepare(ACTION_1);
  execute(ACTION_1);
  release(ACTION_1);
}

Exceptions

To prevent generating some false-positives, literals having less than 5 characters are excluded.

Define a constant instead of duplicating this literal "productid" 4 times.
Open

            ->delete(self::TABLE_NAME, ['pricebookid' => $destinationRecordId, 'productid' => $sourceRecordId])

Duplicated string literals make the process of refactoring error-prone, since you must be sure to update all occurrences.

On the other hand, constants can be referenced from many places, but only need to be updated in a single place.

Noncompliant Code Example

With the default threshold of 3:

function run() {
  prepare('action1');                              // Non-Compliant - 'action1' is duplicated 3 times
  execute('action1');
  release('action1');
}

Compliant Solution

ACTION_1 = 'action1';

function run() {
  prepare(ACTION_1);
  execute(ACTION_1);
  release(ACTION_1);
}

Exceptions

To prevent generating some false-positives, literals having less than 5 characters are excluded.

Call to method setFields from undeclared class \App\QueryGenerator (Did you mean class \Tests\App\QueryGenerator)
Open

            $queryByProduct->setFields(['id']);

Reference to instance property permissions from undeclared class \App\QueryGenerator
Open

            $queryByProduct->permissions = false;

Call to undeclared method \App\Db::createCommand
Open

        return (bool) \App\Db::getInstance()->createCommand()->update(self::TABLE_NAME,

Call to method getModuleField from undeclared class \App\QueryGenerator (Did you mean class \Tests\App\QueryGenerator)
Open

        if (($fieldModel = $queryByProduct->getModuleField('unit_price')) && $fieldModel->isActiveField()) {

Call to undeclared method \App\Db::createCommand
Open

        return (bool) App\Db::getInstance()->createCommand()

Call to method setCustomColumn from undeclared class \App\QueryGenerator (Did you mean class \Tests\App\QueryGenerator)
Open

        $queryGenerator = $this->relationModel->getQueryGenerator()

Call to method getColumnName from undeclared class \App\QueryGenerator (Did you mean class \Tests\App\QueryGenerator)
Open

                ->setCustomColumn($queryByProduct->getColumnName($fieldModel->getName()))

Call to method __construct from undeclared class \App\QueryGenerator (Did you mean class \Tests\App\QueryGenerator)
Open

        $queryByProduct = new \App\QueryGenerator($this->relationModel->getParentModuleModel()->getName());

Call to undeclared method \App\Db\Query::from
Open

        if (!(new App\Db\Query())->from(self::TABLE_NAME)->where($data)->exists()) {

Call to method getColumnName from undeclared class \App\QueryGenerator (Did you mean class \Tests\App\QueryGenerator)
Open

            $queryGenerator->addJoin(['INNER JOIN', $fieldModel->getTableName(), $queryByProduct->getColumnName('id') . " = {$tableName}.productid"])

Call to method createQuery from undeclared class \App\QueryGenerator (Did you mean class \Tests\App\QueryGenerator)
Open

                ->addNativeCondition([$queryByProduct->getColumnName('id') => $queryByProduct->createQuery()]);

Call to method getColumnName from undeclared class \App\QueryGenerator (Did you mean class \Tests\App\QueryGenerator)
Open

                ->addNativeCondition([$queryByProduct->getColumnName('id') => $queryByProduct->createQuery()]);

Call to undeclared method \App\Db::createCommand
Open

            $result = (bool) \App\Db::getInstance()->createCommand()->insert(self::TABLE_NAME, $data)->execute();

Similar blocks of code found in 2 locations. Consider refactoring.
Open

    public function create(int $sourceRecordId, int $destinationRecordId): bool
    {
        $result = false;
        $data = ['pricebookid' => $destinationRecordId, 'productid' => $sourceRecordId];
        if (!(new App\Db\Query())->from(self::TABLE_NAME)->where($data)->exists()) {
Severity: Major
Found in modules/Products/relations/GetProductPricebooks.php and 1 other location - About 2 hrs to fix
modules/PriceBooks/relations/GetPricebookProducts.php on lines 49..59

Duplicated Code

Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

Tuning

This issue has a mass of 138.

We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

Refactorings

Further Reading

Each class must be in a namespace of at least one level (a top-level vendor name)
Open

class Products_GetProductPricebooks_Relation extends \App\Relation\RelationAbstraction

The class Products_GetProductPricebooks_Relation is not named in CamelCase.
Open

class Products_GetProductPricebooks_Relation extends \App\Relation\RelationAbstraction
{
    /**
     * @var string Name of the table that stores relations.
     */

CamelCaseClassName

Since: 0.2

It is considered best practice to use the CamelCase notation to name classes.

Example

class class_name {
}

Source

Only one argument is allowed per line in a multi-line function call
Open

        ['productid' => $toRecordId], ['productid' => $fromRecordId, 'pricebookid' => $relatedRecordId])->execute();

Spaces must be used to indent lines; tabs are not allowed
Open

    /**

Spaces must be used to indent lines; tabs are not allowed
Open

    {

Spaces must be used to indent lines; tabs are not allowed
Open

    public function getQuery()

Spaces must be used to indent lines; tabs are not allowed
Open

    public function create(int $sourceRecordId, int $destinationRecordId): bool

Spaces must be used to indent lines; tabs are not allowed
Open

     * @var string Name of the table that stores relations.

Spaces must be used to indent lines; tabs are not allowed
Open

        return Vtiger_Relation_Model::RELATION_M2M;

Spaces must be used to indent lines; tabs are not allowed
Open

     */

Spaces must be used to indent lines; tabs are not allowed
Open

    }

Spaces must be used to indent lines; tabs are not allowed
Open

    public const TABLE_NAME = 'vtiger_pricebookproductrel';

Spaces must be used to indent lines; tabs are not allowed
Open

    public function getRelationType(): int

Spaces must be used to indent lines; tabs are not allowed
Open

    public function transfer(int $relatedRecordId, int $fromRecordId, int $toRecordId): bool

Line exceeds 120 characters; contains 149 characters
Open

            $queryGenerator->addJoin(['INNER JOIN', $fieldModel->getTableName(), $queryByProduct->getColumnName('id') . " = {$tableName}.productid"])

Spaces must be used to indent lines; tabs are not allowed
Open

                ->setCustomColumn($queryByProduct->getColumnName($fieldModel->getName()))

Spaces must be used to indent lines; tabs are not allowed
Open

        if (!(new App\Db\Query())->from(self::TABLE_NAME)->where($data)->exists()) {

Spaces must be used to indent lines; tabs are not allowed
Open

            $data['listprice'] = 0;

Spaces must be used to indent lines; tabs are not allowed
Open

            $result = (bool) \App\Db::getInstance()->createCommand()->insert(self::TABLE_NAME, $data)->execute();

Spaces must be used to indent lines; tabs are not allowed
Open

    /** {@inheritdoc} */

Spaces must be used to indent lines; tabs are not allowed
Open

        $tableName = self::TABLE_NAME;

Spaces must be used to indent lines; tabs are not allowed
Open

    /** {@inheritdoc} */

Spaces must be used to indent lines; tabs are not allowed
Open

            ->addNativeCondition(["{$tableName}.productid" => $this->relationModel->get('parentRecord')->getId()]);

Spaces must be used to indent lines; tabs are not allowed
Open

        $queryByProduct = new \App\QueryGenerator($this->relationModel->getParentModuleModel()->getName());

Spaces must be used to indent lines; tabs are not allowed
Open

        return $result;

Spaces must be used to indent lines; tabs are not allowed
Open

    {

Spaces must be used to indent lines; tabs are not allowed
Open

            $data['usedcurrency'] = \Vtiger_Record_Model::getInstanceById($destinationRecordId)->get('currency_id');

Spaces must be used to indent lines; tabs are not allowed
Open

    {

Spaces must be used to indent lines; tabs are not allowed
Open

        return (bool) \App\Db::getInstance()->createCommand()->update(self::TABLE_NAME,

Spaces must be used to indent lines; tabs are not allowed
Open

    /** {@inheritdoc} */

Spaces must be used to indent lines; tabs are not allowed
Open

    {

Spaces must be used to indent lines; tabs are not allowed
Open

        $data = ['pricebookid' => $destinationRecordId, 'productid' => $sourceRecordId];

Spaces must be used to indent lines; tabs are not allowed
Open

    }

Spaces must be used to indent lines; tabs are not allowed
Open

    /** {@inheritdoc} */

Spaces must be used to indent lines; tabs are not allowed
Open

        $queryGenerator = $this->relationModel->getQueryGenerator()

Spaces must be used to indent lines; tabs are not allowed
Open

            $queryByProduct->permissions = false;

Spaces must be used to indent lines; tabs are not allowed
Open

    }

Spaces must be used to indent lines; tabs are not allowed
Open

        return (bool) App\Db::getInstance()->createCommand()

Spaces must be used to indent lines; tabs are not allowed
Open

    /** {@inheritdoc} */

Spaces must be used to indent lines; tabs are not allowed
Open

    }

Spaces must be used to indent lines; tabs are not allowed
Open

    {

Spaces must be used to indent lines; tabs are not allowed
Open

            ->addJoin(['INNER JOIN', $tableName, "vtiger_pricebook.pricebookid = {$tableName}.pricebookid"])

Spaces must be used to indent lines; tabs are not allowed
Open

        }

Spaces must be used to indent lines; tabs are not allowed
Open

    public function delete(int $sourceRecordId, int $destinationRecordId): bool

Spaces must be used to indent lines; tabs are not allowed
Open

            ->delete(self::TABLE_NAME, ['pricebookid' => $destinationRecordId, 'productid' => $sourceRecordId])

Spaces must be used to indent lines; tabs are not allowed
Open

            ->execute();

Spaces must be used to indent lines; tabs are not allowed
Open

        $result = false;

Spaces must be used to indent lines; tabs are not allowed
Open

    }

Spaces must be used to indent lines; tabs are not allowed
Open

            ->setCustomColumn("{$tableName}.listprice")

Spaces must be used to indent lines; tabs are not allowed
Open

        if (($fieldModel = $queryByProduct->getModuleField('unit_price')) && $fieldModel->isActiveField()) {

Spaces must be used to indent lines; tabs are not allowed
Open

            $queryGenerator->addJoin(['INNER JOIN', $fieldModel->getTableName(), $queryByProduct->getColumnName('id') . " = {$tableName}.productid"])

Spaces must be used to indent lines; tabs are not allowed
Open

                ->addNativeCondition([$queryByProduct->getColumnName('id') => $queryByProduct->createQuery()]);

Spaces must be used to indent lines; tabs are not allowed
Open

        }

Spaces must be used to indent lines; tabs are not allowed
Open

            $queryByProduct->setFields(['id']);

Spaces must be used to indent lines; tabs are not allowed
Open

        ['productid' => $toRecordId], ['productid' => $fromRecordId, 'pricebookid' => $relatedRecordId])->execute();

Closing parenthesis of a multi-line function call must be on a line by itself
Open

        ['productid' => $toRecordId], ['productid' => $fromRecordId, 'pricebookid' => $relatedRecordId])->execute();

Opening parenthesis of a multi-line function call must be the last content on the line
Open

        return (bool) \App\Db::getInstance()->createCommand()->update(self::TABLE_NAME,

Class name "Products_GetProductPricebooks_Relation" is not in camel caps format
Open

class Products_GetProductPricebooks_Relation extends \App\Relation\RelationAbstraction

There are no issues that match your filters.

Category
Status