Function `sanitizeInventoryValues` has a Cognitive Complexity of 23 (exceeds 5 allowed). Consider refactoring.
Open

    public function sanitizeInventoryValues(array $inventoryRow, array $inventoryFields): array
    {
        ++$this->invNo;
        $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $this->invNo, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);
        ++$this->colNo;

Found in modules/Vtiger/models/ExportToSpreadsheet.php - About 3 hrs to fix

Read up
Read up

Cognitive Complexity

Cognitive Complexity is a measure of how difficult a unit of code is to intuitively understand. Unlike Cyclomatic Complexity, which determines how difficult your code will be to test, Cognitive Complexity tells you how difficult your code will be to read and comprehend.

A method's cognitive complexity is based on a few simple rules:

Code is not considered more complex when it uses shorthand that the language provides for collapsing multiple statements into one
Code is considered more complex for each "break in the linear flow of the code"
Code is considered more complex when "flow breaking structures are nested"

Cognitive Complexity

Cognitive Complexity is a measure of how difficult a unit of code is to intuitively understand. Unlike Cyclomatic Complexity, which determines how difficult your code will be to test, Cognitive Complexity tells you how difficult your code will be to read and comprehend.

A method's cognitive complexity is based on a few simple rules:

Code is not considered more complex when it uses shorthand that the language provides for collapsing multiple statements into one
Code is considered more complex for each "break in the linear flow of the code"
Code is considered more complex when "flow breaking structures are nested"

Cognitive Complexity

Cognitive Complexity is a measure of how difficult a unit of code is to intuitively understand. Unlike Cyclomatic Complexity, which determines how difficult your code will be to test, Cognitive Complexity tells you how difficult your code will be to read and comprehend.

A method's cognitive complexity is based on a few simple rules:

Code is not considered more complex when it uses shorthand that the language provides for collapsing multiple statements into one
Code is considered more complex for each "break in the linear flow of the code"
Code is considered more complex when "flow breaking structures are nested"

CyclomaticComplexity

Since: 0.1

Complexity is determined by the number of decision points in a method plus one for the method entry. The decision points are 'if', 'while', 'for', and 'case labels'. Generally, 1-4 is low complexity, 5-7 indicates moderate complexity, 8-10 is high complexity, and 11+ is very high complexity.

Example

// Cyclomatic Complexity = 11
class Foo {
1   public function example() {
2       if ($a == $b) {
3           if ($a1 == $b1) {
                fiddle();
4           } elseif ($a2 == $b2) {
                fiddle();
            } else {
                fiddle();
            }
5       } elseif ($c == $d) {
6           while ($c == $d) {
                fiddle();
            }
7        } elseif ($e == $f) {
8           for ($n = 0; $n < $h; $n++) {
                fiddle();
            }
        } else {
            switch ($z) {
9               case 1:
                    fiddle();
                    break;
10              case 2:
                    fiddle();
                    break;
11              case 3:
                    fiddle();
                    break;
                default:
                    fiddle();
                    break;
            }
        }
    }
}

Source https://phpmd.org/rules/codesize.html#cyclomaticcomplexity

The method putDataIntoSpreadsheet() has a Cyclomatic Complexity of 10. The configured cyclomatic complexity threshold is 10.
Open

    public function putDataIntoSpreadsheet(Vtiger_Field_Model $fieldModel, $value, int $id)
    {
        switch ($fieldModel->getFieldDataType()) {
            case 'integer':
            case 'double':

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

CyclomaticComplexity

Since: 0.1

Complexity is determined by the number of decision points in a method plus one for the method entry. The decision points are 'if', 'while', 'for', and 'case labels'. Generally, 1-4 is low complexity, 5-7 indicates moderate complexity, 8-10 is high complexity, and 11+ is very high complexity.

Example

// Cyclomatic Complexity = 11
class Foo {
1   public function example() {
2       if ($a == $b) {
3           if ($a1 == $b1) {
                fiddle();
4           } elseif ($a2 == $b2) {
                fiddle();
            } else {
                fiddle();
            }
5       } elseif ($c == $d) {
6           while ($c == $d) {
                fiddle();
            }
7        } elseif ($e == $f) {
8           for ($n = 0; $n < $h; $n++) {
                fiddle();
            }
        } else {
            switch ($z) {
9               case 1:
                    fiddle();
                    break;
10              case 2:
                    fiddle();
                    break;
11              case 3:
                    fiddle();
                    break;
                default:
                    fiddle();
                    break;
            }
        }
    }
}

Source https://phpmd.org/rules/codesize.html#cyclomaticcomplexity

Refactor this function to reduce its Cognitive Complexity from 26 to the 15 allowed.
Open

    public function sanitizeInventoryValues(array $inventoryRow, array $inventoryFields): array

Found in modules/Vtiger/models/ExportToSpreadsheet.php by sonar-php

Read up
Read up
Exclude checks
- Disable engine
- Disable check

Cognitive Complexity is a measure of how hard the control flow of a function is to understand. Functions with high Cognitive Complexity will be difficult to maintain.

See

Cognitive Complexity

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

        $this->workBook = new \PhpOffice\PhpSpreadsheet\Spreadsheet();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

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 '86', column '21').
Open

                $invRows = (new \App\Db\Query())->from($inventoryTable)->where(['crmid' => $row['id']])->orderBy('seq')->all();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

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\Fields\Currency' in method 'sanitizeInventoryValues'.
Open

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

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

Avoid using static access to class '\PhpOffice\PhpSpreadsheet\IOFactory' in method 'output'.
Open

        $workbookWriter = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($this->workBook, ucfirst($this->fileExtension));

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

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

The method putDataIntoSpreadsheet uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
Open

                } else {
                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);
                }

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

ElseExpression

Since: 1.4.0

An if expression with an else branch is basically not necessary. You can rewrite the conditions in a way that the else clause is not necessary and the code becomes simpler to read. To achieve this, use early return statements, though you may need to split the code it several smaller methods. For very simple assignments you could also use the ternary operations.

Example

class Foo
{
    public function bar($flag)
    {
        if ($flag) {
            // one branch
        } else {
            // another branch
        }
    }
}

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

The method sanitizeInventoryValues uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
Open

            } else {
                $type = is_numeric($value) ? \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC : \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING;
                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $value, $type);
            }

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

ElseExpression

Since: 1.4.0

An if expression with an else branch is basically not necessary. You can rewrite the conditions in a way that the else clause is not necessary and the code becomes simpler to read. To achieve this, use early return statements, though you may need to split the code it several smaller methods. For very simple assignments you could also use the ternary operations.

Example

class Foo
{
    public function bar($flag)
    {
        if ($flag) {
            // one branch
        } else {
            // another branch
        }
    }
}

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

The method exportData uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
Open

            } else {
                $this->sanitizeValues($row);
            }

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

ElseExpression

Since: 1.4.0

An if expression with an else branch is basically not necessary. You can rewrite the conditions in a way that the else clause is not necessary and the code becomes simpler to read. To achieve this, use early return statements, though you may need to split the code it several smaller methods. For very simple assignments you could also use the ternary operations.

Example

class Foo
{
    public function bar($flag)
    {
        if ($flag) {
            // one branch
        } else {
            // another branch
        }
    }
}

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

The method putDataIntoSpreadsheet uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
Open

                } else {
                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);
                }

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

ElseExpression

Since: 1.4.0

An if expression with an else branch is basically not necessary. You can rewrite the conditions in a way that the else clause is not necessary and the code becomes simpler to read. To achieve this, use early return statements, though you may need to split the code it several smaller methods. For very simple assignments you could also use the ternary operations.

Example

class Foo
{
    public function bar($flag)
    {
        if ($flag) {
            // one branch
        } else {
            // another branch
        }
    }
}

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

Avoid using static access to class '\PhpOffice\PhpSpreadsheet\Shared\Date' in method 'putDataIntoSpreadsheet'.
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

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

Avoid using static access to class '\PhpOffice\PhpSpreadsheet\Shared\Date' in method 'putDataIntoSpreadsheet'.
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

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

Avoid using static access to class '\App\Json' in method 'sanitizeInventoryValues'.
Open

                        $valueParam = \App\Json::encode($valueNewData);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

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

Avoid using static access to class '\PhpOffice\PhpSpreadsheet\Shared\Date' in method 'sanitizeInventoryValues'.
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

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

The method sanitizeInventoryValues uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
Open

                } else {
                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);
                }

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

ElseExpression

Since: 1.4.0

An if expression with an else branch is basically not necessary. You can rewrite the conditions in a way that the else clause is not necessary and the code becomes simpler to read. To achieve this, use early return statements, though you may need to split the code it several smaller methods. For very simple assignments you could also use the ternary operations.

Example

class Foo
{
    public function bar($flag)
    {
        if ($flag) {
            // one branch
        } else {
            // another branch
        }
    }
}

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

Avoid using static access to class '\App\Config' in method 'output'.
Open

        $tempFileName = tempnam(ROOT_DIRECTORY . DIRECTORY_SEPARATOR . \App\Config::main('tmp_dir'), 'xls');

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

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

Avoid using static access to class 'Vtiger_Inventory_Model' in method 'exportData'.
Open

            $inventoryModel = Vtiger_Inventory_Model::getInstance($this->moduleName);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

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

Avoid unused local variables such as '$dbType'.
Open

            foreach ($field->getCustomColumn() as $customColumnName => $dbType) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

UnusedLocalVariable

Since: 0.2

Detects when a local variable is declared and/or assigned, but not used.

Example

class Foo {
    public function doSomething()
    {
        $i = 5; // Unused
    }
}

Source https://phpmd.org/rules/unusedcode.html#unusedlocalvariable

Call to method `__construct` from undeclared class `\PhpOffice\PhpSpreadsheet\Spreadsheet`
Open

        $this->workBook = new \PhpOffice\PhpSpreadsheet\Spreadsheet();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Call to method `setActiveSheetIndex` from undeclared class `\PhpOffice\PhpSpreadsheet\Spreadsheet`
Open

        $this->workSheet = $this->workBook->setActiveSheetIndex(0);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Call to method `createWriter` from undeclared class `\PhpOffice\PhpSpreadsheet\IOFactory`
Open

        $workbookWriter = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($this->workBook, ucfirst($this->fileExtension));

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                $type = is_numeric($value) ? \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC : \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                $type = is_numeric($value) ? \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC : \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

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

                $invRows = (new \App\Db\Query())->from($inventoryTable)->where(['crmid' => $row['id']])->orderBy('seq')->all();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Call to method `PHPToExcel` from undeclared class `\PhpOffice\PhpSpreadsheet\Shared\Date`
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Call to method `close` from undeclared class `\yii\db\DataReader`
Open

        $dataReader->close();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $displayValue, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                $type = is_numeric($value) ? \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC : \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $field->getDisplayValue($value, $inventoryRow, true), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Call to method `PHPToExcel` from undeclared class `\PhpOffice\PhpSpreadsheet\Shared\Date`
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                $type = is_numeric($value) ? \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC : \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $valueParam, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Call to method `read` from undeclared class `\yii\db\DataReader`
Open

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Call to method `PHPToExcel` from undeclared class `\PhpOffice\PhpSpreadsheet\Shared\Date`
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

            $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $header, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `FILL_SOLID` from undeclared class `\PhpOffice\PhpSpreadsheet\Style\Fill`
Open

            'fill' => ['type' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID, 'color' => ['argb' => 'E1E0F7']],

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

        $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $this->invNo, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phan

Exclude checks
- Disable engine
- Disable check

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

                if ('currencyparam' === $customColumnName) {
                    $field = $inventoryFields['currency'];
                    $valueData = $field->getCurrencyParam([], $valueParam);
                    if (\is_array($valueData)) {
                        $valueNewData = [];

Found in modules/Vtiger/models/ExportToSpreadsheet.php and 1 other location - About 1 hr to fix

Read up
Read up

app/Export/Records.php on lines 344..355

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

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

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

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

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

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

ShortVariable

Since: 0.2

Detects when a field, local, or parameter has a very short name.

Example

class Something {
    private $q = 15; // VIOLATION - Field
    public static function main( array $as ) { // VIOLATION - Formal
        $r = 20 + $this->q; // VIOLATION - Local
        for (int $i = 0; $i < 10; $i++) { // Not a Violation (inside FOR)
            $r += $this->q;
        }
    }
}

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

Avoid variables with short names like $id. Configured minimum length is 3.
Open

    public function putDataIntoSpreadsheet(Vtiger_Field_Model $fieldModel, $value, int $id)

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

ShortVariable

Since: 0.2

Detects when a field, local, or parameter has a very short name.

Example

class Something {
    private $q = 15; // VIOLATION - Field
    public static function main( array $as ) { // VIOLATION - Formal
        $r = 20 + $this->q; // VIOLATION - Local
        for (int $i = 0; $i < 10; $i++) { // Not a Violation (inside FOR)
            $r += $this->q;
        }
    }
}

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

The class Vtiger_ExportToSpreadsheet_Model is not named in CamelCase.
Open

class Vtiger_ExportToSpreadsheet_Model extends \App\Export\Records
{
    protected $workBook;
    protected $workSheet;
    protected $headerStyles;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpmd

Read up
Read up
Exclude checks
- Disable engine
- Disable check

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

    protected $headerStyles;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 156 characters
Open

            $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $header, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        ++$this->rowNo;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $this->workBook = new \PhpOffice\PhpSpreadsheet\Spreadsheet();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            'font' => ['bold' => true],

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    public function output($headers, $entries)

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    protected $colNo = 1;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        //having written out all the data lets have a go at getting the columns to auto-size

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            ++$col;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $tempFileName = tempnam(ROOT_DIRECTORY . DIRECTORY_SEPARATOR . \App\Config::main('tmp_dir'), 'xls');

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    /** {@inheritdoc} */

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $length = \count($headers);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            $cell = $this->workSheet->getCellByColumnAndRow($col, $row);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        unlink($tempFileName);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    protected $workBook;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    protected $invNo = 0;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

     * Constructor.

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

*/

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $this->workSheet = $this->workBook->setActiveSheetIndex(0);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    public function getHeaders(): array

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $headers = parent::getHeaders();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        fclose($fp);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    protected $workSheet;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

];

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    /** {@inheritdoc} */

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            ++$this->colNo;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $workbookWriter = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($this->workBook, ucfirst($this->fileExtension));

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $this->headerStyles = [

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            $this->workSheet->getStyleByColumnAndRow($col, $row)->applyFromArray($this->headerStyles);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                        $this->sanitizeValues($row);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $this->output($headers, []);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

/**

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $displayValue, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    $field = $inventoryFields['currency'];

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                            $valueNewData[$currencyName] = $data;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    public function __construct()

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            $this->putDataIntoSpreadsheet($fieldModel, $row[$dbKey], $row[$idKey] ?? 0);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

     * @param mixed              $value

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            case 'integer':

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            default:

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 205 characters
Open

                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $field->getDisplayValue($value, $inventoryRow, true), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

/**

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        parent::__construct();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        return $headers;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        fpassthru($fp);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    /** {@inheritdoc} */

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $this->colNo = 1;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

     * @return void

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                if ($value) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        ++$this->invNo;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            $value = $inventoryRow[$columnName] ?? '';

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                if ('currencyparam' === $customColumnName) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                            $currencyName = \App\Fields\Currency::getById($currencyId)['currency_name'];

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                        $valueParam = \App\Json::encode($valueNewData);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            $this->workSheet->getColumnDimension($cell->getColumn())->setAutoSize(true);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $type = is_numeric($value) ? \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC : \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                } else {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    /** {@inheritdoc} */

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    public function sanitizeInventoryValues(array $inventoryRow, array $inventoryFields): array

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 154 characters
Open

                $type = is_numeric($value) ? \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC : \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 164 characters
Open

                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $valueParam, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            case 'double':

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            case 'datetime':

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 146 characters
Open

                    $this->workSheet->getStyleByColumnAndRow($this->colNo, $this->rowNo)->getNumberFormat()->setFormatCode('DD/MM/YYYY HH:MM:SS');

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $field->getDisplayValue($value, $inventoryRow, true), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    public function exportData()

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                if ($invRows) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            } else {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            $idKey = 'id';

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $name = $fieldModel->get('source_field_name') . $fieldModel->getModuleName();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $value, $type);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            case 'date':

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        foreach ($inventoryFields as $columnName => $field) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            ++$this->colNo;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        return [];

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            'fill' => ['type' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID, 'color' => ['argb' => 'E1E0F7']],

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    /** {@inheritdoc} */

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        for ($i = 1; $i <= $length; ++$i) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 127 characters
Open

                $invRows = (new \App\Db\Query())->from($inventoryTable)->where(['crmid' => $row['id']])->orderBy('seq')->all();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                        $this->sanitizeInventoryValues($invRow, $inventoryFields);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    public function sanitizeValues(array $row): array

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            if ($fieldModel->get('source_field_name')) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                } else {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 159 characters
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        ++$this->colNo;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 215 characters
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    $this->workSheet->getStyleByColumnAndRow($this->colNo, $this->rowNo)->getNumberFormat()->setFormatCode('DD/MM/YYYY');

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            } else {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $header, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $idKey = $name . $idKey;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $this->invNo, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            } elseif ('Date' === $field->getType()) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                        $valueNewData = [];

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $valueParam, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $row = $col = 1;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $headers = $this->getHeaders();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        if ($addInventoryData) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $invRows = (new \App\Db\Query())->from($inventoryTable)->where(['crmid' => $row['id']])->orderBy('seq')->all();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

     * Put data into spread sheet.

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 137 characters
Open

                    $this->workSheet->getStyleByColumnAndRow($this->colNo, $this->rowNo)->getNumberFormat()->setFormatCode('DD/MM/YYYY');

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                ++$this->colNo;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    protected $rowNo = 1;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        foreach ($headers as $header) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 124 characters
Open

        $workbookWriter = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($this->workBook, ucfirst($this->fileExtension));

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $workbookWriter->save($tempFileName);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $fp = fopen($tempFileName, 'r');

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            $inventoryModel = Vtiger_Inventory_Model::getInstance($this->moduleName);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            if ($addInventoryData) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $dataReader->close();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    $this->workSheet->getStyleByColumnAndRow($this->colNo, $this->rowNo)->getNumberFormat()->setFormatCode('DD/MM/YYYY HH:MM:SS');

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 158 characters
Open

        $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $this->invNo, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

    public function putDataIntoSpreadsheet(Vtiger_Field_Model $fieldModel, $value, int $id)

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                if ($value) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 166 characters
Open

                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $displayValue, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                } else {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $valueParam = $inventoryRow[$customColumnName] ?? '';

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            $inventoryTable = $inventoryModel->getDataTableName();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $this->sanitizeValues($row);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

     * @param Vtiger_Field_Model $fieldModel

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                break;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    $this->workSheet->getStyleByColumnAndRow($this->colNo, $this->rowNo)->getNumberFormat()->setFormatCode('DD/MM/YYYY');

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 159 characters
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        ++$this->colNo;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $type = is_numeric($value) ? \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC : \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $addInventoryData = $this->fullData && $this->moduleInstance->isInventory();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            $inventoryFields = $inventoryModel->getFields();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, $value, $type);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            foreach ($field->getCustomColumn() as $customColumnName => $dbType) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        foreach ($this->fields as $dbKey => $fieldModel) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        return [];

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

     * @param int                $id

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

*/

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            case 'currency':

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 215 characters
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    foreach ($invRows as $invRow) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        switch ($fieldModel->getFieldDataType()) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 154 characters
Open

                $type = is_numeric($value) ? \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC : \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 215 characters
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                break;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 177 characters
Open

            if (\in_array($field->getType(), ['Name', 'Reference', 'Currency', 'Value', 'Unit', 'Boolean', 'Comment', 'Picklist', 'PicklistField', 'DiscountMode', 'TaxMode'])) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    if (\is_array($valueData)) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        $dataReader = $this->getExportQuery()->createCommand()->query();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $dbKey = $name . $fieldModel->getName();

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

        ++$this->rowNo;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 137 characters
Open

                    $this->workSheet->getStyleByColumnAndRow($this->colNo, $this->rowNo)->getNumberFormat()->setFormatCode('DD/MM/YYYY');

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                break;

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                $displayValue = $this->getDisplayValue($fieldModel, $value, $id, []) ?: '';

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

            if (\in_array($field->getType(), ['Name', 'Reference', 'Currency', 'Value', 'Unit', 'Boolean', 'Comment', 'Picklist', 'PicklistField', 'DiscountMode', 'TaxMode'])) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                if ($value) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($value), \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

Line exceeds 120 characters; contains 159 characters
Open

                    $this->workSheet->setCellValueExplicitByColumnAndRow($this->colNo, $this->rowNo, '', \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                    $valueData = $field->getCurrencyParam([], $valueParam);

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

                        foreach ($valueData as $currencyId => $data) {

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

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

class Vtiger_ExportToSpreadsheet_Model extends \App\Export\Records

Found in modules/Vtiger/models/ExportToSpreadsheet.php by phpcodesniffer

Exclude checks
- Disable engine
- Disable check

YetiForceCompany/YetiForceCRM

Summary

Maintainability

Test Coverage

Function sanitizeInventoryValues has a Cognitive Complexity of 23 (exceeds 5 allowed). Consider refactoring. Open

Cognitive Complexity

A method's cognitive complexity is based on a few simple rules:

Further reading

Function exportData has a Cognitive Complexity of 13 (exceeds 5 allowed). Consider refactoring. Open

Cognitive Complexity

A method's cognitive complexity is based on a few simple rules:

Further reading

Method sanitizeInventoryValues has 38 lines of code (exceeds 25 allowed). Consider refactoring. Open

Method putDataIntoSpreadsheet has 28 lines of code (exceeds 25 allowed). Consider refactoring. Open

Function putDataIntoSpreadsheet has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring. Open

Cognitive Complexity

A method's cognitive complexity is based on a few simple rules:

Further reading

The method sanitizeInventoryValues() has a Cyclomatic Complexity of 10. The configured cyclomatic complexity threshold is 10. Open

CyclomaticComplexity

Since: 0.1

Example

Source https://phpmd.org/rules/codesize.html#cyclomaticcomplexity

The method putDataIntoSpreadsheet() has a Cyclomatic Complexity of 10. The configured cyclomatic complexity threshold is 10. Open

CyclomaticComplexity

Since: 0.1

Example

Source https://phpmd.org/rules/codesize.html#cyclomaticcomplexity

Refactor this function to reduce its Cognitive Complexity from 26 to the 15 allowed. Open

See

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

MissingImport

Since: 2.7.0

Example

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

Missing class import via use statement (line '86', column '21'). Open

MissingImport

Since: 2.7.0

Example

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

Avoid using static access to class '\App\Fields\Currency' in method 'sanitizeInventoryValues'. Open

StaticAccess

Since: 1.4.0

Example

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

Avoid using static access to class '\PhpOffice\PhpSpreadsheet\IOFactory' in method 'output'. Open

StaticAccess

Since: 1.4.0

Example

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

The method putDataIntoSpreadsheet uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them. Open

ElseExpression

Since: 1.4.0

Example

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

The method sanitizeInventoryValues uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them. Open

ElseExpression

Since: 1.4.0

Example

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

The method exportData uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them. Open

ElseExpression

Since: 1.4.0

Example

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

The method putDataIntoSpreadsheet uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them. Open

ElseExpression

Since: 1.4.0

Example

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

Avoid using static access to class '\PhpOffice\PhpSpreadsheet\Shared\Date' in method 'putDataIntoSpreadsheet'. Open

StaticAccess

Since: 1.4.0

Example

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

Avoid using static access to class '\PhpOffice\PhpSpreadsheet\Shared\Date' in method 'putDataIntoSpreadsheet'. Open

StaticAccess

Since: 1.4.0

Example

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

Function `sanitizeInventoryValues` has a Cognitive Complexity of 23 (exceeds 5 allowed). Consider refactoring.
Open

Function `exportData` has a Cognitive Complexity of 13 (exceeds 5 allowed). Consider refactoring.
Open

Method `sanitizeInventoryValues` has 38 lines of code (exceeds 25 allowed). Consider refactoring.
Open

Method `putDataIntoSpreadsheet` has 28 lines of code (exceeds 25 allowed). Consider refactoring.
Open

Function `putDataIntoSpreadsheet` has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.
Open

The method sanitizeInventoryValues() has a Cyclomatic Complexity of 10. The configured cyclomatic complexity threshold is 10.
Open

The method putDataIntoSpreadsheet() has a Cyclomatic Complexity of 10. The configured cyclomatic complexity threshold is 10.
Open

Refactor this function to reduce its Cognitive Complexity from 26 to the 15 allowed.
Open

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

Missing class import via use statement (line '86', column '21').
Open

Avoid using static access to class '\App\Fields\Currency' in method 'sanitizeInventoryValues'.
Open

Avoid using static access to class '\PhpOffice\PhpSpreadsheet\IOFactory' in method 'output'.
Open

The method putDataIntoSpreadsheet uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
Open

The method sanitizeInventoryValues uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
Open

The method exportData uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
Open

The method putDataIntoSpreadsheet uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
Open

Avoid using static access to class '\PhpOffice\PhpSpreadsheet\Shared\Date' in method 'putDataIntoSpreadsheet'.
Open

Avoid using static access to class '\PhpOffice\PhpSpreadsheet\Shared\Date' in method 'putDataIntoSpreadsheet'.
Open

Avoid using static access to class '\App\Json' in method 'sanitizeInventoryValues'.
Open

Avoid using static access to class '\PhpOffice\PhpSpreadsheet\Shared\Date' in method 'sanitizeInventoryValues'.
Open

The method sanitizeInventoryValues uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
Open

Avoid using static access to class '\App\Config' in method 'output'.
Open

Avoid using static access to class 'Vtiger_Inventory_Model' in method 'exportData'.
Open

Avoid unused local variables such as '$dbType'.
Open

Call to method `__construct` from undeclared class `\PhpOffice\PhpSpreadsheet\Spreadsheet`
Open

Call to method `setActiveSheetIndex` from undeclared class `\PhpOffice\PhpSpreadsheet\Spreadsheet`
Open

Call to method `createWriter` from undeclared class `\PhpOffice\PhpSpreadsheet\IOFactory`
Open

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

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

Call to method `PHPToExcel` from undeclared class `\PhpOffice\PhpSpreadsheet\Shared\Date`
Open

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Call to method `close` from undeclared class `\yii\db\DataReader`
Open

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Call to method `PHPToExcel` from undeclared class `\PhpOffice\PhpSpreadsheet\Shared\Date`
Open

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Call to method `read` from undeclared class `\yii\db\DataReader`
Open

Call to method `PHPToExcel` from undeclared class `\PhpOffice\PhpSpreadsheet\Shared\Date`
Open

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Reference to constant `TYPE_STRING` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Reference to constant `FILL_SOLID` from undeclared class `\PhpOffice\PhpSpreadsheet\Style\Fill`
Open

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

Reference to constant `TYPE_NUMERIC` from undeclared class `\PhpOffice\PhpSpreadsheet\Cell\DataType`
Open

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

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

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