YetiForceCompany/YetiForceCRM

View on GitHub
modules/Documents/relations/GetAttachments.php

Summary

Maintainability
A
0 mins
Test Coverage
C
71%

Missing class import via use statement (line '95', 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 '84', column '21').
Open

            $subQuery = (new \App\Db\Query())->select(['contactid'])->from('vtiger_contactdetails')->where(['parentid' => $sourceRecordId]);

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 using static access to class '\App\Condition' in method 'loadAdvancedConditionsByRelationId'.
Open

            $relationQueryGenerator->setConditions(\App\Condition::getConditionsFromRequest($advancedConditions['relationConditions']));

StaticAccess

Since: 1.4.0

Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

Example

class Foo
{
    public function bar()
    {
        Bar::baz();
    }
}

Source https://phpmd.org/rules/cleancode.html#staticaccess

Define a constant instead of duplicating this literal "crmid" 5 times.
Open

        $data = ['notesid' => $destinationRecordId, 'crmid' => $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 "INNER JOIN" 4 times.
Open

        $queryGenerator->addJoin(['INNER JOIN', $tableName, "{$tableName}.notesid= vtiger_notes.notesid"]);

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

        $data = ['notesid' => $destinationRecordId, 'crmid' => $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.

Saw an @param annotation for searchParam, but it was not found in the param list of function loadAdvancedConditionsByRelationId(\App\QueryGenerator $queryGenerator) : void
Open

     * @param array              $searchParam

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

        $relationQueryGenerator->setStateCondition($queryGenerator->getState());

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

            $subQuery = (new \App\Db\Query())->select(['contactid'])->from('vtiger_contactdetails')->where(['parentid' => $sourceRecordId]);

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

        $queryGenerator->addJoin(['INNER JOIN', $tableName, "{$tableName}.notesid= vtiger_notes.notesid"]);

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

        $query = $relationQueryGenerator->createQuery();

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

        $queryGenerator->setOrder('id', 'DESC');

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

        $queryGenerator->addJoin(['INNER JOIN', $tableName, "{$tableName}.crmid = vtiger_crmentity.crmid"])

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

        $queryGenerator->addJoin(['INNER JOIN', 'vtiger_crmentity crm2', "crm2.crmid = {$tableName}.crmid"]);

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

        $relationQueryGenerator->setStateCondition($queryGenerator->getState());

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

        return (bool) App\Db::getInstance()->createCommand()->delete(self::TABLE_NAME, $data)->execute();

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

        $queryGenerator->setCustomColumn('vtiger_notes.filetype');

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

        $queryGenerator->addJoin(['INNER JOIN', $tableName, "{$tableName}.crmid = vtiger_crmentity.crmid"])

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

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

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

        $queryGenerator->addNativeCondition(['crm2.crmid' => $this->relationModel->get('parentRecord')->getId()]);

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

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

Parameter $queryGenerator has undeclared type \App\QueryGenerator (Did you mean class \Tests\App\QueryGenerator)
Open

    public function loadAdvancedConditionsByColumns(App\QueryGenerator $queryGenerator, array $searchParam): void

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

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

Parameter $queryGenerator has undeclared type \App\QueryGenerator (Did you mean class \Tests\App\QueryGenerator)
Open

    public function loadAdvancedConditionsByRelationId(App\QueryGenerator $queryGenerator): void

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

        $advancedConditions = $queryGenerator->getAdvancedConditions();

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

            $relationQueryGenerator->setConditions(\App\Condition::getConditionsFromRequest($advancedConditions['relationConditions']));

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

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

Avoid excessively long variable names like $relationQueryGenerator. Keep variable name length under 20.
Open

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

LongVariable

Since: 0.2

Detects when a field, formal or local variable is declared with a long name.

Example

class Something {
    protected $reallyLongIntName = -3; // VIOLATION - Field
    public static function main( array $interestingArgumentsList[] ) { // VIOLATION - Formal
        $otherReallyLongName = -5; // VIOLATION - Local
        for ($interestingIntIndex = 0; // VIOLATION - For
             $interestingIntIndex < 10;
             $interestingIntIndex++ ) {
        }
    }
}

Source https://phpmd.org/rules/naming.html#longvariable

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

class Documents_GetAttachments_Relation extends \App\Relation\RelationAbstraction

The class Documents_GetAttachments_Relation is not named in CamelCase.
Open

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

        ['crmid' => $toRecordId], ['crmid' => $fromRecordId, 'notesid' => $relatedRecordId])->execute();

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

    {

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

            ->addNativeCondition(["{$tableName}.notesid" => $query]);

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

     * Load advanced conditions relationship by custom column.

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

            $subQuery = (new \App\Db\Query())->select(['contactid'])->from('vtiger_contactdetails')->where(['parentid' => $sourceRecordId]);

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

     * @param array              $searchParam

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

        $query = $relationQueryGenerator->createQuery();

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

        $queryGenerator->addJoin(['INNER JOIN', $tableName, "{$tableName}.crmid = vtiger_crmentity.crmid"])

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 Vtiger_Relation_Model::RELATION_M2M;

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->addJoin(['INNER JOIN', $tableName, "{$tableName}.notesid= vtiger_notes.notesid"]);

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

     *

Line exceeds 120 characters; contains 127 characters
Open

     * @param App\QueryGenerator $queryGenerator QueryGenerator for the list of records to be tapered based on the relationship

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

    public function loadAdvancedConditionsByColumns(App\QueryGenerator $queryGenerator, array $searchParam): void

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

        if ($this->relationModel && 'Accounts' === $this->relationModel->getParentModuleModel()->getName()) {

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

    {

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

        $queryGenerator->addNativeCondition(['crm2.crmid' => $this->relationModel->get('parentRecord')->getId()]);

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

     * @param App\QueryGenerator $queryGenerator QueryGenerator for the list of records to be tapered based on the relationship

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

     * @return void

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

        $relationQueryGenerator->setStateCondition($queryGenerator->getState());

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

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

Line exceeds 120 characters; contains 136 characters
Open

            $relationQueryGenerator->setConditions(\App\Condition::getConditionsFromRequest($advancedConditions['relationConditions']));

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 transfer(int $relatedRecordId, int $fromRecordId, int $toRecordId): 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

    }

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

            $relationQueryGenerator->setConditions(\App\Condition::getConditionsFromRequest($advancedConditions['relationConditions']));

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

        $tableName = static::TABLE_NAME;

Line exceeds 120 characters; contains 140 characters
Open

            $subQuery = (new \App\Db\Query())->select(['contactid'])->from('vtiger_contactdetails')->where(['parentid' => $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

        $data = ['notesid' => $destinationRecordId, 'crmid' => $sourceRecordId];

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

     * @param App\QueryGenerator $queryGenerator QueryGenerator for the list of records to be tapered based on the relationship

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

    /** {@inheritdoc} */

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

    public function loadAdvancedConditionsByRelationId(App\QueryGenerator $queryGenerator): void

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) $result;

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

    /**

Line exceeds 120 characters; contains 127 characters
Open

     * @param App\QueryGenerator $queryGenerator QueryGenerator for the list of records to be tapered based on the relationship

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

        $advancedConditions = $queryGenerator->getAdvancedConditions();

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

        $data = ['notesid' => $destinationRecordId, 'crmid' => $sourceRecordId];

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

            $data = ['or', $data, ['crmid' => $subQuery] + $data];

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

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

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

        $queryGenerator->addJoin(['INNER JOIN', $tableName, "{$tableName}.crmid = vtiger_crmentity.crmid"])

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

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

     * @return void

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

        return (bool) App\Db::getInstance()->createCommand()->delete(self::TABLE_NAME, $data)->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 const TABLE_NAME = 'vtiger_senotesrel';

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

        $queryGenerator->setCustomColumn('vtiger_notes.filetype');

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

        $queryGenerator->addJoin(['INNER JOIN', 'vtiger_crmentity crm2', "crm2.crmid = {$tableName}.crmid"]);

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

    /** {@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

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

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

        if (!empty($advancedConditions['relationConditions'])) {

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

            ->addNativeCondition(["{$tableName}.notesid" => $searchParam['value']]);

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

        return (bool) \App\Db::getInstance()->createCommand()->update(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

    {

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

        $queryGenerator->setOrder('id', 'DESC');

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

     * Load advanced conditions for filtering related records.

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

        $tableName = static::TABLE_NAME;

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

     * @param array              $searchParam    Related record for which we are filtering the list of records

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

    }

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

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

        ['crmid' => $toRecordId], ['crmid' => $fromRecordId, 'notesid' => $relatedRecordId])->execute();

There are no issues that match your filters.

Category
Status