EventAvailability::isEventAvailableInLanguage() - Code Metrics - derhansen/sf_event_mgt - Measure and Improve Code Quality continuously with Scrutinizer

EventAvailability::isEventAvailableInLanguage() A
last analyzed 2025-12-19 09:53 UTC

↳ Parent: EventAvailability

Complexity

Conditions	2
Paths	2

Size

Total Lines	67
Code Lines	46

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	2
eloc	46
nc	2
nop	2
dl	0
loc	67
rs	9.1781
c	1
b	0
f	0

How to fix Long Method

<?php

declare(strict_types=1);

/*
 * This file is part of the Extension "sf_event_mgt" for TYPO3 CMS.
 *
 * For the full copyright and license information, please read the
 * LICENSE.txt file that was distributed with this source code.
 */

namespace DERHANSEN\SfEventMgt\Utility;

use Psr\Http\Message\ServerRequestInterface;
use TYPO3\CMS\Core\Database\Connection;
use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Site\Entity\Site;
use TYPO3\CMS\Core\Site\Entity\SiteLanguage;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use UnexpectedValueException;

class EventAvailability
{
    /**
     * Checks if an event record is available the given language id
     */
    public function check(int $languageId, int $eventId, ServerRequestInterface $request): bool
    {
        /** @var Site $site */
        $site = $request->getAttribute('site');
        $allAvailableLanguagesOfSite = $site->getAllLanguages();

        $targetLanguage = $this->getLanguageFromAllLanguages($allAvailableLanguagesOfSite, $languageId);
        if (!$targetLanguage) {
            throw new UnexpectedValueException('Target language could not be found', 1608059129);
        }
        return $this->mustBeIncluded($eventId, $targetLanguage);
    }

    protected function mustBeIncluded(int $eventId, SiteLanguage $language): bool
    {
        // @extensionScannerIgnoreLine
        return !($language->getFallbackType() === 'strict' &&
            !$this->isEventAvailableInLanguage($eventId, $language->getLanguageId()));
    }

    /**
     * @param SiteLanguage[] $allLanguages
     */
    protected function getLanguageFromAllLanguages(array $allLanguages, int $languageId): ?SiteLanguage
    {
        foreach ($allLanguages as $siteLanguage) {
            if ($siteLanguage->getLanguageId() === $languageId) {
                return $siteLanguage;
            }
        }
        return null;
    }

    protected function isEventAvailableInLanguage(int $eventId, int $language): bool
    {
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
            ->getQueryBuilderForTable('tx_sfeventmgt_domain_model_event');
        if ($language === 0) {
            $where = [
                $queryBuilder->expr()->or(
                    $queryBuilder->expr()->eq(
                        'sys_language_uid',
                        $queryBuilder->createNamedParameter($language, Connection::PARAM_INT)
                    ),
                    $queryBuilder->expr()->eq(
                        'sys_language_uid',
                        $queryBuilder->createNamedParameter(-1, Connection::PARAM_INT)
                    )
                ),
                $queryBuilder->expr()->eq('uid', $queryBuilder->createNamedParameter($eventId, Connection::PARAM_INT)),
            ];
        } else {
            $where = [
                $queryBuilder->expr()->or(
                    $queryBuilder->expr()->and(
                        $queryBuilder->expr()->eq(
                            'sys_language_uid',
                            $queryBuilder->createNamedParameter(-1, Connection::PARAM_INT)
                        ),
                        $queryBuilder->expr()->eq(
                            'uid',
                            $queryBuilder->createNamedParameter($eventId, Connection::PARAM_INT)
                        )
                    ),
                    $queryBuilder->expr()->and(
                        $queryBuilder->expr()->eq(
                            'l10n_parent',
                            $queryBuilder->createNamedParameter($eventId, Connection::PARAM_INT)
                        ),
                        $queryBuilder->expr()->eq(
                            'sys_language_uid',
                            $queryBuilder->createNamedParameter($language, Connection::PARAM_INT)
                        )
                    ),
                    $queryBuilder->expr()->and(
                        $queryBuilder->expr()->eq(
                            'uid',
                            $queryBuilder->createNamedParameter($eventId, Connection::PARAM_INT)
                        ),
                        $queryBuilder->expr()->eq(
                            'l10n_parent',
                            $queryBuilder->createNamedParameter(0, Connection::PARAM_INT)
                        ),
                        $queryBuilder->expr()->eq(
                            'sys_language_uid',
                            $queryBuilder->createNamedParameter($language, Connection::PARAM_INT)
                        )
                    )
                ),
            ];
        }

        $eventsFound = $queryBuilder
           ->count('uid')
           ->from('tx_sfeventmgt_domain_model_event')
           ->where(...$where)
           ->executeQuery()
           ->fetchOne();

        return $eventsFound > 0;
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			/*
6			* This file is part of the Extension "sf_event_mgt" for TYPO3 CMS.
7			*
8			* For the full copyright and license information, please read the
9			* LICENSE.txt file that was distributed with this source code.
10			*/
11
12			namespace DERHANSEN\SfEventMgt\Utility;
13
14			use Psr\Http\Message\ServerRequestInterface;
15			use TYPO3\CMS\Core\Database\Connection;
16			use TYPO3\CMS\Core\Database\ConnectionPool;
17			use TYPO3\CMS\Core\Site\Entity\Site;
18			use TYPO3\CMS\Core\Site\Entity\SiteLanguage;
19			use TYPO3\CMS\Core\Utility\GeneralUtility;
20			use UnexpectedValueException;
21
22			class EventAvailability
23			{
24			/**
25			* Checks if an event record is available the given language id
26			*/
27			public function check(int $languageId, int $eventId, ServerRequestInterface $request): bool
28			{
29			/** @var Site $site */
30			$site = $request->getAttribute('site');
31			$allAvailableLanguagesOfSite = $site->getAllLanguages();
32
33			$targetLanguage = $this->getLanguageFromAllLanguages($allAvailableLanguagesOfSite, $languageId);
34			if (!$targetLanguage) {
35			throw new UnexpectedValueException('Target language could not be found', 1608059129);
36			}
37			return $this->mustBeIncluded($eventId, $targetLanguage);
38			}
39
40			protected function mustBeIncluded(int $eventId, SiteLanguage $language): bool
41			{
42			// @extensionScannerIgnoreLine
43			return !($language->getFallbackType() === 'strict' &&
44			!$this->isEventAvailableInLanguage($eventId, $language->getLanguageId()));
45			}
46
47			/**
48			* @param SiteLanguage[] $allLanguages
49			*/
50			protected function getLanguageFromAllLanguages(array $allLanguages, int $languageId): ?SiteLanguage
51			{
52			foreach ($allLanguages as $siteLanguage) {
53			if ($siteLanguage->getLanguageId() === $languageId) {
54			return $siteLanguage;
55			}
56			}
57			return null;
58			}
59
60			protected function isEventAvailableInLanguage(int $eventId, int $language): bool
61			{
62			$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
63			->getQueryBuilderForTable('tx_sfeventmgt_domain_model_event');
64			if ($language === 0) {
65			$where = [
66			$queryBuilder->expr()->or(
67			$queryBuilder->expr()->eq(
68			'sys_language_uid',
69			$queryBuilder->createNamedParameter($language, Connection::PARAM_INT)
70			),
71			$queryBuilder->expr()->eq(
72			'sys_language_uid',
73			$queryBuilder->createNamedParameter(-1, Connection::PARAM_INT)
74			)
75			),
76			$queryBuilder->expr()->eq('uid', $queryBuilder->createNamedParameter($eventId, Connection::PARAM_INT)),
77			];
78			} else {
79			$where = [
80			$queryBuilder->expr()->or(
81			$queryBuilder->expr()->and(
82			$queryBuilder->expr()->eq(
83			'sys_language_uid',
84			$queryBuilder->createNamedParameter(-1, Connection::PARAM_INT)
85			),
86			$queryBuilder->expr()->eq(
87			'uid',
88			$queryBuilder->createNamedParameter($eventId, Connection::PARAM_INT)
89			)
90			),
91			$queryBuilder->expr()->and(
92			$queryBuilder->expr()->eq(
93			'l10n_parent',
94			$queryBuilder->createNamedParameter($eventId, Connection::PARAM_INT)
95			),
96			$queryBuilder->expr()->eq(
97			'sys_language_uid',
98			$queryBuilder->createNamedParameter($language, Connection::PARAM_INT)
99			)
100			),
101			$queryBuilder->expr()->and(
102			$queryBuilder->expr()->eq(
103			'uid',
104			$queryBuilder->createNamedParameter($eventId, Connection::PARAM_INT)
105			),
106			$queryBuilder->expr()->eq(
107			'l10n_parent',
108			$queryBuilder->createNamedParameter(0, Connection::PARAM_INT)
109			),
110			$queryBuilder->expr()->eq(
111			'sys_language_uid',
112			$queryBuilder->createNamedParameter($language, Connection::PARAM_INT)
113			)
114			)
115			),
116			];
117			}
118
119			$eventsFound = $queryBuilder
120			->count('uid')
121			->from('tx_sfeventmgt_domain_model_event')
122			->where(...$where)
123			->executeQuery()
124			->fetchOne();
125
126			return $eventsFound > 0;
127			}
128			}
129

derhansen / sf_event_mgt

EventAvailability::isEventAvailableInLanguage() A last analyzed 2025-12-19 09:53 UTC

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like

EventAvailability::isEventAvailableInLanguage() A
last analyzed 2025-12-19 09:53 UTC