YetiForceCompany/YetiForceCRM

View on GitHub
modules/PriceBooks/relations/GetPricebookProducts.php

Summary

Maintainability
A
2 hrs
Test Coverage
F
0%

Missing class import via use statement (line '53', 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

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

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

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" 3 times.
Open

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

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 getColumnName from undeclared class \App\QueryGenerator (Did you mean class \Tests\App\QueryGenerator)
Open

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

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

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

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

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

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

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

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

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

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

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

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

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

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 PriceBooks_GetPricebookProducts_Relation extends \App\Relation\RelationAbstraction

The class PriceBooks_GetPricebookProducts_Relation is not named in CamelCase.
Open

class PriceBooks_GetPricebookProducts_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

        ['pricebookid' => $toRecordId], ['pricebookid' => $fromRecordId, 'productid' => $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

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

Line exceeds 120 characters; contains 121 characters
Open

            ->addNativeCondition(['vtiger_pricebook.pricebookid' => $this->relationModel->get('parentRecord')->getId()]);

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

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

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

    }

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

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

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, $queryGenerator->getColumnName('id') . " = {$tableName}.productid"])

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

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

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 getRelationType(): int

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

    }

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

            ->execute();

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

            $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

    {

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

    public function getQuery()

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

            ->addNativeCondition(['vtiger_pricebook.pricebookid' => $this->relationModel->get('parentRecord')->getId()]);

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

    }

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

        return $result;

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

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

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

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

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

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

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

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

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

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

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

class PriceBooks_GetPricebookProducts_Relation extends \App\Relation\RelationAbstraction

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,

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

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

There are no issues that match your filters.

Category
Status