ProjectConfig::onProjectConfigRebuild() - Code Metrics - Inspection of "Bump to 1.2.0" - mmikkel/CacheFlag-Craft3 - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( f96468...e8dc9f )

by M. Mikkel

created 2020-07-23 17:58 UTC

ProjectConfig::onProjectConfigRebuild() B

↳ Parent: ProjectConfig

Complexity

Conditions	11
Paths	17

Size

Total Lines	45
Code Lines	34

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	11
eloc	34
c	1
b	0
f	0
nc	17
nop	1
dl	0
loc	45
rs	7.3166

How to fix Complexity

<?php

namespace mmikkel\cacheflag\services;

use Craft;
use craft\base\Component;
use craft\db\Query;
use craft\db\Table;
use craft\events\ConfigEvent;
use craft\events\RebuildConfigEvent;
use craft\helpers\Db;

use mmikkel\cacheflag\records\Flags;

/**
 * Class ProjectConfig
 * @package mmikkel\cacheflag\services
 * @since 1.2.0
 */
class ProjectConfig extends Component
{

    /**
     * @param ConfigEvent $event
     * @throws \yii\db\Exception
     */
    public function onProjectConfigChange(ConfigEvent $event)
    {

        $uid = $event->tokenMatches[0];

        $id = (new Query())
            ->select(['id'])
            ->from(Flags::tableName())
            ->where(['uid' => $uid])
            ->scalar();

        $isNew = empty($id);

        if ($isNew) {

            $source = \explode(':', $event->newValue['source']);
            $sourceKey = $source[0] ?? null;
            $sourceValue = $source[1] ?? null;

            if (!$sourceKey || !$sourceValue) {
                return;
            }

            switch ($sourceKey) {
                case 'section':
                    $column = 'sectionId';
                    $value = (int)Db::idByUid(Table::SECTIONS, $sourceValue);
                    break;
                case 'categoryGroup':
                    $column = 'categoryGroupId';
                    $value = (int)Db::idByUid(Table::CATEGORYGROUPS, $sourceValue);
                    break;
                case 'tagGroup':
                    $column = 'tagGroupId';
                    $value = (int)Db::idByUid(Table::TAGGROUPS, $sourceValue);
                    break;
                case 'userGroup':
                    $column = 'userGroupId';
                    $value = (int)Db::idByUid(Table::USERGROUPS, $sourceValue);
                    break;
                case 'volume':
                    $column = 'volumeId';
                    $value = (int)Db::idByUid(Table::VOLUMES, $sourceValue);
                    break;
                case 'globalSet':
                    $column = 'globalSetId';
                    $value = (int)Db::idByUid(Table::GLOBALSETS, $sourceValue);
                    break;
                case 'elementType':
                    $column = 'elementType';
                    $value = $sourceValue;
                    break;
                default:
                    return;
            }

            $flags = $event->newValue['flags'];

            Craft::$app->db->createCommand()
                ->insert(Flags::tableName(), [
                    'flags' => $flags,
                    $column => $value,
                    'uid' => $uid,
                ])
                ->execute();

        } else {

            Craft::$app->db->createCommand()
                ->update(Flags::tableName(), [
                    'flags' => $event->newValue['flags'],
                ], ['id' => $id])
                ->execute();
        }

    }

    /**
     * @param ConfigEvent $event
     * @throws \yii\db\Exception
     */
    public function onProjectConfigDelete(ConfigEvent $event)
    {

        $uid = $event->tokenMatches[0];

        $id = (new Query())
            ->select(['id'])
            ->from(Flags::tableName())
            ->where(['uid' => $uid])
            ->scalar();

        if (!$id) {
            return;
        }

        Craft::$app->db->createCommand()
            ->delete(Flags::tableName(), ['id' => $id])
            ->execute();

    }

    /**
     * @param RebuildConfigEvent $event
     * @return void
     */
    public function onProjectConfigRebuild(RebuildConfigEvent $event)
    {

        Craft::$app->getProjectConfig()->remove('cacheFlags');

        $rows = (new Query())
            ->select(['flags', 'sectionId', 'categoryGroupId', 'tagGroupId', 'userGroupId', 'volumeId', 'globalSetId', 'elementType', 'uid'])
            ->from(Flags::tableName())
            ->all();

        foreach ($rows as $row) {

            $sourceKey = null;
            $sourceValue = null;

            if ($row['sectionId']) {
                $sourceKey = 'section';
                $sourceValue = Db::uidById(Table::SECTIONS, $row['sectionId']);
            } else if ($row['categoryGroupId']) {
                $sourceKey = 'categoryGroup';
                $sourceValue = Db::uidById(Table::CATEGORYGROUPS, $row['categoryGroupId']);
            } else if ($row['tagGroupId']) {
                $sourceKey = 'tagGroup';
                $sourceValue = Db::uidById(Table::TAGGROUPS, $row['tagGroupId']);
            } else if ($row['userGroupId']) {
                $sourceKey = 'userGroup';
                $sourceValue = Db::uidById(Table::USERGROUPS, $row['userGroupId']);
            } else if ($row['volumeId']) {
                $sourceKey = 'volume';
                $sourceValue = Db::uidById(Table::VOLUMES, $row['volumeId']);
            } else if ($row['globalSetId']) {
                $sourceKey = 'globalSet';
                $sourceValue = Db::uidById(Table::GLOBALSETS, $row['globalSetId']);
            } else if ($row['elementType']) {
                $sourceKey = 'elementType';
                $sourceValue = $row['elementType'];
            }

            if (!$sourceKey || !$sourceValue) {
                return;
            }

            $event->config['cacheFlags'][$row['uid']] = [
                'source' => "$sourceKey:$sourceValue",
                'flags' => $row['flags'],
            ];
        }

    }

}


1			<?php
2
3			namespace mmikkel\cacheflag\services;
4
5			use Craft;
6			use craft\base\Component;
7			use craft\db\Query;
8			use craft\db\Table;
9			use craft\events\ConfigEvent;
10			use craft\events\RebuildConfigEvent;
11			use craft\helpers\Db;
12
13			use mmikkel\cacheflag\records\Flags;
14
15			/**
16			* Class ProjectConfig
17			* @package mmikkel\cacheflag\services
18			* @since 1.2.0
19			*/
20			class ProjectConfig extends Component
21			{
22
23			/**
24			* @param ConfigEvent $event
25			* @throws \yii\db\Exception
26			*/
27			public function onProjectConfigChange(ConfigEvent $event)
28			{
29
30			$uid = $event->tokenMatches[0];
31
32			$id = (new Query())
33			->select(['id'])
34			->from(Flags::tableName())
35			->where(['uid' => $uid])
36			->scalar();
37
38			$isNew = empty($id);
39
40			if ($isNew) {
41
42			$source = \explode(':', $event->newValue['source']);
43			$sourceKey = $source[0] ?? null;
44			$sourceValue = $source[1] ?? null;
45
46			if (!$sourceKey \|\| !$sourceValue) {
47			return;
48			}
49
50			switch ($sourceKey) {
51			case 'section':
52			$column = 'sectionId';
53			$value = (int)Db::idByUid(Table::SECTIONS, $sourceValue);
54			break;
55			case 'categoryGroup':
56			$column = 'categoryGroupId';
57			$value = (int)Db::idByUid(Table::CATEGORYGROUPS, $sourceValue);
58			break;
59			case 'tagGroup':
60			$column = 'tagGroupId';
61			$value = (int)Db::idByUid(Table::TAGGROUPS, $sourceValue);
62			break;
63			case 'userGroup':
64			$column = 'userGroupId';
65			$value = (int)Db::idByUid(Table::USERGROUPS, $sourceValue);
66			break;
67			case 'volume':
68			$column = 'volumeId';
69			$value = (int)Db::idByUid(Table::VOLUMES, $sourceValue);
70			break;
71			case 'globalSet':
72			$column = 'globalSetId';
73			$value = (int)Db::idByUid(Table::GLOBALSETS, $sourceValue);
74			break;
75			case 'elementType':
76			$column = 'elementType';
77			$value = $sourceValue;
78			break;
79			default:
80			return;
81			}
82
83			$flags = $event->newValue['flags'];
84
85			Craft::$app->db->createCommand()
86			->insert(Flags::tableName(), [
87			'flags' => $flags,
88			$column => $value,
89			'uid' => $uid,
90			])
91			->execute();
92
93			} else {
94
95			Craft::$app->db->createCommand()
96			->update(Flags::tableName(), [
97			'flags' => $event->newValue['flags'],
98			], ['id' => $id])
99			->execute();
100			}
101
102			}
103
104			/**
105			* @param ConfigEvent $event
106			* @throws \yii\db\Exception
107			*/
108			public function onProjectConfigDelete(ConfigEvent $event)
109			{
110
111			$uid = $event->tokenMatches[0];
112
113			$id = (new Query())
114			->select(['id'])
115			->from(Flags::tableName())
116			->where(['uid' => $uid])
117			->scalar();
118
119			if (!$id) {
120			return;
121			}
122
123			Craft::$app->db->createCommand()
124			->delete(Flags::tableName(), ['id' => $id])
125			->execute();
126
127			}
128
129			/**
130			* @param RebuildConfigEvent $event
131			* @return void
132			*/
133			public function onProjectConfigRebuild(RebuildConfigEvent $event)
134			{
135
136			Craft::$app->getProjectConfig()->remove('cacheFlags');
137
138			$rows = (new Query())
139			->select(['flags', 'sectionId', 'categoryGroupId', 'tagGroupId', 'userGroupId', 'volumeId', 'globalSetId', 'elementType', 'uid'])
140			->from(Flags::tableName())
141			->all();
142
143			foreach ($rows as $row) {
144
145			$sourceKey = null;
146			$sourceValue = null;
147
148			if ($row['sectionId']) {
149			$sourceKey = 'section';
150			$sourceValue = Db::uidById(Table::SECTIONS, $row['sectionId']);
151			} else if ($row['categoryGroupId']) {
152			$sourceKey = 'categoryGroup';
153			$sourceValue = Db::uidById(Table::CATEGORYGROUPS, $row['categoryGroupId']);
154			} else if ($row['tagGroupId']) {
155			$sourceKey = 'tagGroup';
156			$sourceValue = Db::uidById(Table::TAGGROUPS, $row['tagGroupId']);
157			} else if ($row['userGroupId']) {
158			$sourceKey = 'userGroup';
159			$sourceValue = Db::uidById(Table::USERGROUPS, $row['userGroupId']);
160			} else if ($row['volumeId']) {
161			$sourceKey = 'volume';
162			$sourceValue = Db::uidById(Table::VOLUMES, $row['volumeId']);
163			} else if ($row['globalSetId']) {
164			$sourceKey = 'globalSet';
165			$sourceValue = Db::uidById(Table::GLOBALSETS, $row['globalSetId']);
166			} else if ($row['elementType']) {
167			$sourceKey = 'elementType';
168			$sourceValue = $row['elementType'];
169			}
170
171			if (!$sourceKey \|\| !$sourceValue) {
172			return;
173			}
174
175			$event->config['cacheFlags'][$row['uid']] = [
176			'source' => "$sourceKey:$sourceValue",
177			'flags' => $row['flags'],
178			];
179			}
180
181			}
182
183			}
184

mmikkel / CacheFlag-Craft3

Push — master ( f96468...e8dc9f )

ProjectConfig::onProjectConfigRebuild() B

Complexity

Size

Duplication

Importance

How to fix Complexity

Long Method

Duplication Side-by-Side

Filter issues like