YetiForceCompany/YetiForceCRM

View on GitHub
modules/HelpDesk/dashboards/ClosedTicketsByUser.php

Summary

Maintainability
A
1 hr
Test Coverage
F
0%

Method getTicketsByUser has 48 lines of code (exceeds 25 allowed). Consider refactoring.
Open

    public function getTicketsByUser($time)
    {
        $moduleName = 'HelpDesk';
        $ticketStatus = Settings_SupportProcesses_Module_Model::getTicketStatusNotModify();
        $listViewUrl = Vtiger_Module_Model::getInstance($moduleName)->getListViewUrl();
Severity: Minor
Found in modules/HelpDesk/dashboards/ClosedTicketsByUser.php - About 1 hr to fix

    Missing class import via use statement (line '47', column '19').
    Open

                'count' => new \yii\db\Expression('COUNT(*)'),

    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 '46', column '17').
    Open

            $query = (new App\Db\Query())->select([

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

                $time = Settings_WidgetsManagement_Module_Model::getDefaultDateRange($widget);

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

            \App\PrivilegeQuery::getConditions($query, $moduleName);

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

                $chartData['datasets'][0]['backgroundColor'][] = \App\Fields\Owner::getColor((int) $row['smownerid']);

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

                $label = \App\Fields\Owner::getLabel($row['smownerid']);

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

            $widget = Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId());

    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

            $widget = Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId());

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

            $ticketStatus = Settings_SupportProcesses_Module_Model::getTicketStatusNotModify();

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

            $viewer->assign('DTIME', \App\Fields\Date::formatRangeToDisplay($time));

    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/ClosedTicketsByUser.tpl', $moduleName);
            }

    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\Fields\Date' in method 'getTicketsByUser'.
    Open

            $time = \App\Fields\Date::formatRangeToDisplay($time);

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

                $chartData['labels'][] = \App\Utils::getInitials($label);

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

                $label = \App\Fields\Owner::getLabel($row['smownerid']);

    Duplicated string literals make the process of refactoring error-prone, since you must be sure to update all occurrences.

    On the other hand, constants can be referenced from many places, but only need to be updated in a single place.

    Noncompliant Code Example

    With the default threshold of 3:

    function run() {
      prepare('action1');                              // Non-Compliant - 'action1' is duplicated 3 times
      execute('action1');
      release('action1');
    }
    

    Compliant Solution

    ACTION_1 = 'action1';
    
    function run() {
      prepare(ACTION_1);
      execute(ACTION_1);
      release(ACTION_1);
    }
    

    Exceptions

    To prevent generating some false-positives, literals having less than 5 characters are excluded.

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

                'datasets' => [

    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 getLabel from undeclared class \App\Fields\Owner
    Open

                $label = \App\Fields\Owner::getLabel($row['smownerid']);

    Call to method getInstance from undeclared class \Vtiger_Widget_Model
    Open

            $widget = Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId());

    Call to undeclared method \Vtiger_Viewer::assign
    Open

            $viewer->assign('DTIME', \App\Fields\Date::formatRangeToDisplay($time));

    Call to undeclared method \Vtiger_Viewer::assign
    Open

            $viewer->assign('DATA', $data);

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

            $widget = Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId());

    Call to undeclared method \Vtiger_Viewer::assign
    Open

            $viewer->assign('MODULE_NAME', $moduleName);

    Saw unextractable annotation for comment '* @param <array> $time contain start date and end time'</array>
    Open

         * @param <Array> $time contain start date and end time

    Saw unextractable annotation for comment '* @return <array> data to display chart'</array>
    Open

         * @return <Array> data to display chart

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

            $query = (new App\Db\Query())->select([

    Call to undeclared method \Vtiger_Viewer::assign
    Open

            $viewer->assign('WIDGET', $widget);

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

                $chartData['datasets'][0]['backgroundColor'][] = \App\Fields\Owner::getColor((int) $row['smownerid']);

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

                'count' => new \yii\db\Expression('COUNT(*)'),

    Saw unextractable annotation for comment '* @param <array> $time contain start date and end time'</array>
    Open

         * @param <Array> $time  contain start date and end time

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

    class HelpDesk_ClosedTicketsByUser_Dashboard extends Vtiger_IndexAjax_View

    The class HelpDesk_ClosedTicketsByUser_Dashboard is not named in CamelCase.
    Open

    class HelpDesk_ClosedTicketsByUser_Dashboard extends Vtiger_IndexAjax_View
    {
        /**
         * Return search params (use to in building address URL to listview).
         *

    CamelCaseClassName

    Since: 0.2

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

    Example

    class class_name {
    }

    Source

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

         *

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

                ->innerJoin('vtiger_ticketpriorities', 'vtiger_ticketpriorities.ticketpriorities = vtiger_troubletickets.priority')

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

        /**

    Line exceeds 120 characters; contains 127 characters
    Open

                ->innerJoin('vtiger_ticketpriorities', 'vtiger_ticketpriorities.ticketpriorities = vtiger_troubletickets.priority')

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

         * @param <Array> $time  contain start date and end time

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

                $conditions[] = ['closing_datatime', 'bw', implode(',', $time)];

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

        public function getTicketsByUser($time)

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

            }

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

            $ticketStatus = Settings_SupportProcesses_Module_Model::getTicketStatusNotModify();

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

            $listViewUrl = Vtiger_Module_Model::getInstance($moduleName)->getListViewUrl();

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

            $listSearchParams = [];

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

                ->innerJoin('vtiger_crmentity', 'vtiger_troubletickets.ticketid = vtiger_crmentity.crmid')

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

                ->where(['vtiger_crmentity.deleted' => 0]);

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

        public function getSearchParams($owner, $time)

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

                $conditions[] = ['assigned_user_id', 'e', $owner];

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

                ->innerJoin('vtiger_ticketstatus', 'vtiger_troubletickets.status = vtiger_ticketstatus.ticketstatus')

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

        {

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

            }

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

        {

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

        }

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

         */

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

         * Return search params (use to in building address URL to listview).

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

         * @param int     $owner numer id of user

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

            return '&entityState=Active&viewname=All&search_params=' . json_encode($listSearchParams);

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

         * @return <Array> data to display chart

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

            $listSearchParams[] = $conditions;

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

        /**

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

            $conditions = [];

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

            $query = (new App\Db\Query())->select([

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

                'count' => new \yii\db\Expression('COUNT(*)'),

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

            ])->from('vtiger_troubletickets')

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

                    [

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

                        'data' => [],

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

            if (empty($time)) {

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

         *

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

         *

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

            $moduleName = 'HelpDesk';

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

                'vtiger_crmentity.smownerid',

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

            }

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

                'datasets' => [

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

                'show_chart' => false,

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

        public function process(App\Request $request)

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

            if (!empty($time)) {

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

            $moduleName = $request->getModule();

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

        }

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

         * @return string

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

         */

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

            if (!empty($time)) {

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

            if (!empty($owner)) {

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

         *

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

                ]);

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

            }

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

                $chartData['datasets'][0]['links'][] = $listViewUrl . $this->getSearchParams($row['smownerid'], $time);

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

        }

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

            $viewer = $this->getViewer($request);

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

            $time = $request->getDateRange('time');

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

            $viewer->assign('MODULE_NAME', $moduleName);

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

         * Function returns Tickets grouped by users.

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

         * @param <Array> $time contain start date and end time

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

                $query->andWhere([

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

                    'and',

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

                $label = \App\Fields\Owner::getLabel($row['smownerid']);

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

                $chartData['datasets'][0]['titlesFormatted'][] = $label;

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

            }

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

                    ['<=', 'vtiger_troubletickets.closing_datatime', $time[1] . ' 23:59:59'],

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

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

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

            $viewer->assign('DTIME', \App\Fields\Date::formatRangeToDisplay($time));

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

         */

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

            }

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

            $data = $this->getTicketsByUser($time);

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

                $query->andWhere(['vtiger_troubletickets.status' => $ticketStatus]);

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

            $chartData = [

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

                        'backgroundColor' => [],

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

                ],

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

         * @param \App\Request $request

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

            } else {

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

            }

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

                    ],

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

            $widget = Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId());

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

            if (!empty($ticketStatus)) {

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

                    ['>=', 'vtiger_troubletickets.closing_datatime', $time[0] . ' 00:00:00'],

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

                        'links' => [],

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

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

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

         *

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

                $viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);

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

                        'titlesFormatted' => [],

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

        /**

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

                $time = Settings_WidgetsManagement_Module_Model::getDefaultDateRange($widget);

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

            $viewer->assign('WIDGET', $widget);

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

            \App\PrivilegeQuery::getConditions($query, $moduleName);

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

            $query->groupBy('vtiger_crmentity.smownerid');

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

                $chartData['labels'][] = \App\Utils::getInitials($label);

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

                $chartData['datasets'][0]['backgroundColor'][] = \App\Fields\Owner::getColor((int) $row['smownerid']);

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

            if ($request->has('content')) {

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

            $time = \App\Fields\Date::formatRangeToDisplay($time);

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

                $chartData['datasets'][0]['data'][] = (int) $row['count'];

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

            return $chartData;

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

        {

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

            $dataReader->close();

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

         * Main function.

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

            ];

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

            $viewer->assign('DATA', $data);

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

                $viewer->view('dashboards/ClosedTicketsByUser.tpl', $moduleName);

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

                'labels' => [],

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

            $chartData['show_chart'] = (bool) $dataReader->count();

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

    class HelpDesk_ClosedTicketsByUser_Dashboard extends Vtiger_IndexAjax_View

    There are no issues that match your filters.

    Category
    Status