YetiForceCompany/YetiForceCRM

View on GitHub
modules/Faq/models/KnowledgeBase.php

Summary

Maintainability
C
7 hrs
Test Coverage
F
0%

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

        $queryGenerator = new App\QueryGenerator('Faq');
Severity: Minor
Found in modules/Faq/models/KnowledgeBase.php by phpmd

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 '45', column '25').
Open

        $queryGenerator = new App\QueryGenerator('Faq');
Severity: Minor
Found in modules/Faq/models/KnowledgeBase.php by phpmd

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 '65', column '25').
Open

        $queryGenerator = new App\QueryGenerator('Faq');
Severity: Minor
Found in modules/Faq/models/KnowledgeBase.php by phpmd

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

        if ($this->has('filterField') && $this->has('filterValue')) {
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by sonar-php

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

        $queryGenerator->setFields(['id', 'category', 'subject']);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by sonar-php

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

        if ($this->has('filterField') && $this->has('filterValue')) {
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by sonar-php

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

        $queryGenerator->setFields(['accountid']);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by sonar-php

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

        $queryGenerator->addNativeCondition(['featured' => 1]);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator->addJoin(['INNER JOIN', 'vtiger_account', 'vtiger_account.accountid = vtiger_faq.accountid']);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

            $queryGenerator->addNativeCondition([$this->get('filterField') => $this->get('filterValue')]);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator->setLimit(Config\Modules\Faq::$knowledgeBaseArticleLimit);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

            $queryGenerator->addNativeCondition([$this->get('filterField') => $this->get('filterValue')]);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator = new App\QueryGenerator('Faq');
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator->setFields(['id', 'category', 'subject']);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator->setLimit(50);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator->setCustomColumn('vtiger_account.accountname');
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator = new App\QueryGenerator('Faq');
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator->addNativeCondition(['category' => $categories]);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator->addNativeCondition(['vtiger_faq.status' => 'Published']);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        return $queryGenerator->createQuery()->all();
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator->setFields(['id', 'assigned_user_id', 'subject', 'introduction', 'modifiedtime', 'category']);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator->addNativeCondition(['vtiger_faq.status' => 'Published']);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

Reference to static property knowledgeBaseArticleLimit from undeclared class \Config\Modules\Faq
Open

        $queryGenerator->setLimit(Config\Modules\Faq::$knowledgeBaseArticleLimit);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        return $queryGenerator->createQuery();
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator = new App\QueryGenerator('Faq');
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $dataReader = $queryGenerator->createQuery()->createCommand()->query();
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

            $queryGenerator->addNativeCondition(['category' => $this->get('parentCategory')]);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator->setFields(['accountid']);
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

        $queryGenerator->setDistinct('accountid');
Severity: Critical
Found in modules/Faq/models/KnowledgeBase.php by phan

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

    public function getListQuery(): App\Db\Query
    {
        $queryGenerator = new App\QueryGenerator('Faq');
        $queryGenerator->setFields(['id', 'assigned_user_id', 'subject', 'introduction', 'modifiedtime', 'category']);
        $queryGenerator->addNativeCondition(['vtiger_faq.status' => 'Published']);
Severity: Major
Found in modules/Faq/models/KnowledgeBase.php and 1 other location - About 4 hrs to fix
modules/KnowledgeBase/models/KnowledgeBase.php on lines 133..146

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 162.

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

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

    public function getFeaturedRecords(array $categories): array
    {
        $queryGenerator = new App\QueryGenerator('Faq');
        $queryGenerator->setFields(['id', 'category', 'subject']);
        $queryGenerator->addNativeCondition(['vtiger_faq.status' => 'Published']);
Severity: Major
Found in modules/Faq/models/KnowledgeBase.php and 1 other location - About 3 hrs to fix
modules/KnowledgeBase/models/KnowledgeBase.php on lines 114..126

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 152.

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 Faq_KnowledgeBase_Model extends KnowledgeBase_KnowledgeBase_Model

The class Faq_KnowledgeBase_Model is not named in CamelCase.
Open

class Faq_KnowledgeBase_Model extends KnowledgeBase_KnowledgeBase_Model
{
    /**
     * Get featured records.
     *
Severity: Minor
Found in modules/Faq/models/KnowledgeBase.php by phpmd

CamelCaseClassName

Since: 0.2

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

Example

class class_name {
}

Source

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 getFeaturedRecords(array $categories): array

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 $rows;

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

    public function getListQuery(): App\Db\Query

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

        $queryGenerator->setLimit(Config\Modules\Faq::$knowledgeBaseArticleLimit);

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

        $queryGenerator->setLimit(50);

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->addNativeCondition(['vtiger_faq.status' => 'Published']);

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

     * @return App\Db\Query

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

            $rows[$row['accountid']] = $row['accountname'];

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 = new App\QueryGenerator('Faq');

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

        if ($this->has('parentCategory')) {

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

            $queryGenerator->addNativeCondition(['category' => $this->get('parentCategory')]);

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

        $dataReader = $queryGenerator->createQuery()->createCommand()->query();

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

     * Get featured records.

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

        $queryGenerator = new App\QueryGenerator('Faq');

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

     * Get record list query.

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->setFields(['id', 'category', 'subject']);

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

        $queryGenerator->addNativeCondition(['category' => $categories]);

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 $queryGenerator->createQuery()->all();

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

        $queryGenerator->addNativeCondition(['vtiger_faq.status' => 'Published']);

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

     * Get accounts.

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 getAccounts(): array

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

        $rows = [];

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

        $queryGenerator = new App\QueryGenerator('Faq');

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

        $queryGenerator->addNativeCondition(['featured' => 1]);

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->setFields(['accountid']);

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

        while ($row = $dataReader->read()) {

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

     * @return array

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->setCustomColumn('vtiger_account.accountname');

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

        $dataReader->close();

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

            $queryGenerator->addNativeCondition([$this->get('filterField') => $this->get('filterValue')]);

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

        if ($this->has('filterField') && $this->has('filterValue')) {

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

     * @param string[] $categories

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

     *

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

        if ($this->has('filterField') && $this->has('filterValue')) {

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

     * @return string[]

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 $queryGenerator->createQuery();

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

        $queryGenerator->setDistinct('accountid');

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

        $queryGenerator->setFields(['id', 'assigned_user_id', 'subject', 'introduction', 'modifiedtime', 'category']);

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

            $queryGenerator->addNativeCondition([$this->get('filterField') => $this->get('filterValue')]);

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

        $queryGenerator->addJoin(['INNER JOIN', 'vtiger_account', 'vtiger_account.accountid = vtiger_faq.accountid']);

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

class Faq_KnowledgeBase_Model extends KnowledgeBase_KnowledgeBase_Model

There are no issues that match your filters.

Category
Status