Sign upLogin

YetiForceCompany/YetiForceCRM

View on GitHub
Star
modules/HelpDesk/dashboards/OpenTickets.php

Summary

Maintainability
A
1 hr
Test Coverage
F
0%

Method getOpenTickets has 44 lines of code (exceeds 25 allowed). Consider refactoring.
Open

    public function getOpenTickets()
    {
        $ticketStatus = Settings_SupportProcesses_Module_Model::getTicketStatusNotModify();
        $moduleName = 'HelpDesk';
        $query = new \App\Db\Query();
Severity: Minor
Found in modules/HelpDesk/dashboards/OpenTickets.php - About 1 hr to fix

    Missing class import via use statement (line '23', column '16').
    Open

            $query = new \App\Db\Query();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.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 '27', column '19').
    Open

                'color' => new \yii\db\Expression("CASE WHEN ($userNameSql NOT LIKE '') THEN
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.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 '25', column '34').
    Open

            $query->select(['count' => new \yii\db\Expression('COUNT(*)'),
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.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 '26', column '18').
    Open

                'name' => new \yii\db\Expression("CASE WHEN ($userNameSql NOT LIKE '') THEN $userNameSql ELSE vtiger_groups.groupname END"),
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.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

    Avoid using static access to class 'App\Module' in method 'getOpenTickets'.
    Open

            $userNameSql = App\Module::getSqlForNameInDisplayFormat('Users');
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    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 getSearchParams uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

            } else {
            $allTicketStatus = Settings_SupportProcesses_Module_Model::getAllTicketStatus();
            $openTicketsStatus = implode('##', $allTicketStatus);
        }
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    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 'Settings_SupportProcesses_Module_Model' in method 'getSearchParams'.
    Open

            $openTicketsStatus = Settings_SupportProcesses_Module_Model::getOpenTicketStatus();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    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 'getSearchParams'.
    Open

            return '&entityState=Active&viewname=All&search_params=' . urlencode(App\Json::encode($listSearchParams));
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    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\User' in method 'process'.
    Open

            $viewer->assign('WIDGET', Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId()));
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    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 process uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

            } else {
            $viewer->view('dashboards/OpenTickets.tpl', $moduleName);
        }
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    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 'Vtiger_Widget_Model' in method 'process'.
    Open

            $viewer->assign('WIDGET', Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId()));
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    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 'Settings_SupportProcesses_Module_Model' in method 'getOpenTickets'.
    Open

            $ticketStatus = Settings_SupportProcesses_Module_Model::getTicketStatusNotModify();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    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\PrivilegeQuery' in method 'getOpenTickets'.
    Open

            \App\PrivilegeQuery::getConditions($query, $moduleName);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    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 'Settings_SupportProcesses_Module_Model' in method 'getSearchParams'.
    Open

                $allTicketStatus = Settings_SupportProcesses_Module_Model::getAllTicketStatus();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    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\Fields\Owner' in method 'getOpenTickets'.
    Open

                $chartData['datasets'][0]['backgroundColor'][] = \App\Fields\Owner::getColor($row['id']);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    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\Utils' in method 'getOpenTickets'.
    Open

                $chartData['labels'][] = \App\Utils::getInitials($label);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpmd

    StaticAccess

    Since: 1.4.0

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

    Example

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

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

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

                'datasets' => [
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.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 __construct from undeclared class \yii\db\Expression
    Open

                'name' => new \yii\db\Expression("CASE WHEN ($userNameSql NOT LIKE '') THEN $userNameSql ELSE vtiger_groups.groupname END"),
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

    Call to method __construct from undeclared class \yii\db\Expression
    Open

                'color' => new \yii\db\Expression("CASE WHEN ($userNameSql NOT LIKE '') THEN
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

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

            $query->groupBy(['smownerid', 'vtiger_users.last_name', 'vtiger_users.first_name', 'vtiger_groups.groupname', 'vtiger_users.cal_color', 'vtiger_groups.color']);
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

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

            $dataReader->close();
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

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

                $query->andWhere(['not in', 'vtiger_troubletickets.status', $ticketStatus]);
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

    Call to method getColor from undeclared class \App\Fields\Owner
    Open

                $chartData['datasets'][0]['backgroundColor'][] = \App\Fields\Owner::getColor($row['id']);
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

    Call to method getInstance from undeclared class \Vtiger_Widget_Model
    Open

            $viewer->assign('WIDGET', Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId()));
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

    Call to undeclared method \Vtiger_Viewer::assign
    Open

            $viewer->assign('WIDGET', Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId()));
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

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

            while ($row = $dataReader->read()) {
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

    Call to method __construct from undeclared class \yii\db\Expression
    Open

            $query->select(['count' => new \yii\db\Expression('COUNT(*)'),
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

    Call to undeclared method \Vtiger_Viewer::assign
    Open

            $viewer->assign('DATA', $data);
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

    Call to undeclared method \Vtiger_Viewer::assign
    Open

            $viewer->assign('MODULE_NAME', $moduleName);
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

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

            $query->select(['count' => new \yii\db\Expression('COUNT(*)'),
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

    Call to method count from undeclared class \yii\db\DataReader
    Open

            $chartData['show_chart'] = (bool) $dataReader->count();
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

    Call to method getCurrentUserId from undeclared class \App\User (Did you mean class \Tests\App\User)
    Open

            $viewer->assign('WIDGET', Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId()));
    Severity: Critical
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phan

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

    class HelpDesk_OpenTickets_Dashboard extends Vtiger_IndexAjax_View
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

    The class HelpDesk_OpenTickets_Dashboard is not named in CamelCase.
    Open

    class HelpDesk_OpenTickets_Dashboard extends Vtiger_IndexAjax_View
{
    /**
     * Function returns Tickets grouped by Status.
     *
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.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

                ],
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        /**
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        public function getSearchParams($value)
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $listSearchParams = [];
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        /**
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        {
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        /**
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

    Line exceeds 120 characters; contains 136 characters
    Open

                'name' => new \yii\db\Expression("CASE WHEN ($userNameSql NOT LIKE '') THEN $userNameSql ELSE vtiger_groups.groupname END"),
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                'color' => new \yii\db\Expression("CASE WHEN ($userNameSql NOT LIKE '') THEN
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

    Line exceeds 120 characters; contains 168 characters
    Open

            $query->groupBy(['smownerid', 'vtiger_users.last_name', 'vtiger_users.first_name', 'vtiger_groups.groupname', 'vtiger_users.cal_color', 'vtiger_groups.color']);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $listViewUrl = Vtiger_Module_Model::getInstance($moduleName)->getListViewUrl();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $chartData['labels'][] = \App\Utils::getInitials($label);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            } else {
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        public function process(App\Request $request)
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         * @return array
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                        'data' => [],
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                        'backgroundColor' => [],
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         * @param int $value
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

    Line exceeds 120 characters; contains 137 characters
    Open

     * *********************************************************************************************************************************** */
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         */
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                ->leftJoin('vtiger_users', 'vtiger_crmentity.smownerid = vtiger_users.id')
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                ->where(['vtiger_crmentity.deleted' => 0]);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                'labels' => [],
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                'show_chart' => false,
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                        'titlesFormatted' => [],
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $chartData['show_chart'] = (bool) $dataReader->count();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        }
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         * Return params to search.
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $query->andWhere(['not in', 'vtiger_troubletickets.status', $ticketStatus]);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $dataReader = $query->createCommand()->query();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         * Main process.
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $data = $this->getOpenTickets();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $viewer->assign('MODULE_NAME', $moduleName);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $viewer->view('dashboards/OpenTickets.tpl', $moduleName);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         *
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            if (!empty($ticketStatus)) {
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                    [
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                    ],
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $label = trim($row['name']);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $allTicketStatus = Settings_SupportProcesses_Module_Model::getAllTicketStatus();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            }
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $moduleName = 'HelpDesk';
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                ->leftJoin('vtiger_groups', 'vtiger_crmentity.smownerid = vtiger_groups.groupid')
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            ];
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $chartData['datasets'][0]['data'][] = (int) $row['count'];
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         * @return string
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                'name' => new \yii\db\Expression("CASE WHEN ($userNameSql NOT LIKE '') THEN $userNameSql ELSE vtiger_groups.groupname END"),
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         */
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            if ($openTicketsStatus) {
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            return '&entityState=Active&viewname=All&search_params=' . urlencode(App\Json::encode($listSearchParams));
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         *
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            //Include special script and css needed for this widget
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

    Line exceeds 120 characters; contains 131 characters
    Open

            $viewer->assign('WIDGET', Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId()));
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            } else {
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $query = new \App\Db\Query();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                'id' => 'smownerid', ])
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                ->innerJoin('vtiger_crmentity', 'vtiger_troubletickets.ticketid = vtiger_crmentity.crmid')
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            \App\PrivilegeQuery::getConditions($query, $moduleName);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $chartData = [
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            while ($row = $dataReader->read()) {
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $dataReader->close();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         *
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $openTicketsStatus = Settings_SupportProcesses_Module_Model::getOpenTicketStatus();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $openTicketsStatus = implode('##', $allTicketStatus);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         * @param \App\Request $request
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $viewer->assign('WIDGET', Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId()));
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         */
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $moduleName = $request->getModule();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $viewer->assign('DATA', $data);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        public function getOpenTickets()
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                        'links' => [],
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $chartData['datasets'][0]['titlesFormatted'][] = $label;
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $openTicketsStatus = implode('##', $openTicketsStatus);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $conditions = [['assigned_user_id', 'e', $value]];
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $viewer = $this->getViewer($request);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        {
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $userNameSql = App\Module::getSqlForNameInDisplayFormat('Users');
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $chartData['datasets'][0]['links'][] = $listViewUrl . $this->getSearchParams($row['id']);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            return $chartData;
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         * Function returns Tickets grouped by Status.
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $ticketStatus = Settings_SupportProcesses_Module_Model::getTicketStatusNotModify();
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                ->from('vtiger_troubletickets')
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                $chartData['datasets'][0]['backgroundColor'][] = \App\Fields\Owner::getColor($row['id']);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            array_push($conditions, ['ticketstatus', 'e', $openTicketsStatus]);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $listSearchParams[] = $conditions;
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        }
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $query->select(['count' => new \yii\db\Expression('COUNT(*)'),
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

                'datasets' => [
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        {
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

        }
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            if ($request->has('content')) {
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            }
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            $query->groupBy(['smownerid', 'vtiger_users.last_name', 'vtiger_users.first_name', 'vtiger_groups.groupname', 'vtiger_users.cal_color', 'vtiger_groups.color']);
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            }
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

         *
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

            }
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

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

    class HelpDesk_OpenTickets_Dashboard extends Vtiger_IndexAjax_View
    Severity: Minor
    Found in modules/HelpDesk/dashboards/OpenTickets.php by phpcodesniffer

    There are no issues that match your filters.

    Category
    Status