nystudio107\webperf\controllers\TablesController::actionErrorsIndex()

Complexity

Conditions	14
Paths	240

Size

Total Lines	127
Code Lines	85

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function actionErrorsIndex(
        string $start = '',
        string $end = '',
        string $sort = 'url|DESC',
        int $page = 1,
        int $per_page = 20,
        $filter = '',
        $siteId = 0
    ): Response {
        PermissionHelper::controllerPermissionCheck('webperf:errors');
        $data = [];
        $sortField = 'url';
        $sortType = 'DESC';
        // Add a day since YYYY-MM-DD is really YYYY-MM-DD 00:00:00
        $end = date('Y-m-d', strtotime($end.'+1 day'));
        // Figure out the sorting type
        if ($sort !== '') {
            if (strpos($sort, '|') === false) {
                $sortField = $sort;
            } else {
                list($sortField, $sortType) = explode('|', $sort);
            }
        }
        $db = Craft::$app->getDb();
        // Query the db table
        $offset = ($page - 1) * $per_page;
        $query = (new Query())
            ->select([

The opening parenthesis of a multi-line function call should be the last content on the line.

                '[[url]]',
                'MIN([[title]]) as [[title]]',
                'MAX([[dateCreated]]) as [[latestErrorDate]]',
                'SUM([[type]] = \'craft\') as [[craftCount]]',
                'SUM([[type]] = \'boomerang\') as [[boomerangCount]]',
                'COUNT([[url]]) AS cnt',
            ])

For multi-line function calls, the closing parenthesis should be on a new line.

            ->from(['{{%webperf_error_samples}}'])
            ->offset($offset)
            ->where(['between', 'dateCreated', $start, $end])

Space after closing parenthesis of function call prohibited

        ;
        if ($db->getIsMysql()) {
            $query
                ->addSelect([

The opening parenthesis of a multi-line function call should be the last content on the line.

                    'SUM([[type]] = \'craft\') as [[craftCount]]',
                    'SUM([[type]] = \'boomerang\') as [[boomerangCount]]',
                ]);

For multi-line function calls, the closing parenthesis should be on a new line.

        }
        if ($db->getIsPgsql()) {
            $query
                ->addSelect([

The opening parenthesis of a multi-line function call should be the last content on the line.

                    'SUM(case when [[type]] = \'craft\' then 1 else 0 end) as [[craftCount]]',
                    'SUM(case when [[type]] = \'boomerang\' then 1 else 0 end) as [[boomerangCount]]',
                ]);

For multi-line function calls, the closing parenthesis should be on a new line.

        }
        if ((int)$siteId !== 0) {
            $query->andWhere(['siteId' => $siteId]);
        }
        if ($filter !== '') {
            $query
                ->andWhere(['like', 'url', $filter])
                ->orWhere(['like', 'title', $filter])
                ->orWhere(['like', 'pageErrors', $filter])

Space after closing parenthesis of function call prohibited

            ;
        }
        $query
            ->orderBy("[[{$sortField}]] {$sortType}")
            ->groupBy('url')
            ->limit($per_page)

Space after closing parenthesis of function call prohibited

        ;

        $stats = $query->all();
        if ($stats) {
            $user = Craft::$app->getUser()->getIdentity();
            // Massage the stats
            foreach ($stats as &$stat) {
                $stat['cnt'] = (int)$stat['cnt'];
                $stat['craftCount'] = (int)$stat['craftCount'];
                $stat['boomerangCount'] = (int)$stat['boomerangCount'];
                // Decode any emojis in the title
                if (!empty($stat['title'])) {
                    $stat['title'] = html_entity_decode($stat['title'], ENT_NOQUOTES, 'UTF-8');
                }
                // Set up the appropriate helper links
                $stat['deleteLink'] = UrlHelper::actionUrl('webperf/error-samples/delete-samples-by-url', [

The opening parenthesis of a multi-line function call should be the last content on the line.

                    'pageUrl' => $stat['url'],
                    'siteId' => $siteId
                ]);

For multi-line function calls, the closing parenthesis should be on a new line.

                $stat['detailPageUrl'] = UrlHelper::cpUrl('webperf/errors/page-detail', [

The opening parenthesis of a multi-line function call should be the last content on the line.

                    'pageUrl' => $stat['url'],
                    'siteId' => $siteId,
                ]);

For multi-line function calls, the closing parenthesis should be on a new line.

                // Override based on permissions
                if (!$user->can('webperf:delete-error-samples')) {
                    $stat['deleteLink'] = '';
                }
                if (!$user->can('webperf:errors-detail')) {
                    $stat['detailPageUrl'] = '';
                }
            }
            // Format the data for the API
            $data['data'] = $stats;
            $query = (new Query())
                ->select(['[[url]]'])
                ->from(['{{%webperf_error_samples}}'])
                ->groupBy('[[url]]')
                ->where(['between', 'dateCreated', $start, $end])

Space after closing parenthesis of function call prohibited

            ;
            if ($filter !== '') {
                $query
                    ->andWhere(['like', 'url', $filter])
                    ->orWhere(['like', 'title', $filter])
                    ->orWhere(['like', 'pageErrors', $filter])

Space after closing parenthesis of function call prohibited

                ;
            }
            $count = $query->count();
            $data['links']['pagination'] = [
                'total' => $count,
                'per_page' => $per_page,
                'current_page' => $page,
                'last_page' => ceil($count / $per_page),
                'next_page_url' => null,
                'prev_page_url' => null,
                'from' => $offset + 1,
                'to' => $offset + ($count > $per_page ? $per_page : $count),
            ];
        }

        return $this->asJson($data);
    }