13327579701

Committed 14 Feb 2025 10:43AM UTC coverage: 1.276%. First build

Build # 13327579701

Build Type

push

github

Committed by

web-flow

Commit Message

Merge pull request #597 from Yoast/feature/v11

[FEATURE] Release 11.0.0

Run Details

21 of 894 new or added lines in 76 files covered. (2.35%)

35 of 2744 relevant lines covered (1.28%)

0.04 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

0.0

/Classes/Widgets/Provider/OrphanedContentDataProvider.php

<?php

declare(strict_types=1);

namespace YoastSeoForTypo3\YoastSeo\Widgets\Provider;

use TYPO3\CMS\Core\Database\Connection;
use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Type\Bitmask\Permission;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use YoastSeoForTypo3\YoastSeo\Traits\BackendUserTrait;

class OrphanedContentDataProvider implements PageProviderInterface
{
    use BackendUserTrait;

    public function __construct(
        /** @var int[] */
        private array $excludedDoktypes,
        private int $limit
    ) {
        $this->limit = $limit ?: 5;
    }

    /**
     * @return array<int, array<string, mixed>>
     */
    public function getPages(): array
    {
        $qb = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('sys_refindex');

        $constraints = [
            $qb->expr()->eq('ref_table', $qb->createNamedParameter('pages')),
            $qb->expr()->notIn(
                'field',
                $qb->createNamedParameter([
                    'l10n_parent',
                    'db_mountpoints',
                ], Connection::PARAM_STR_ARRAY)
            ),
        ];

        $refs = $qb->select('ref_uid')
            ->from('sys_refindex')
            ->where(...$constraints)
            ->groupBy('ref_uid')
            ->executeQuery()
            ->fetchAllAssociative();

        $pageIds = [];
        foreach ($refs as $ref) {
            $pageIds[] = $ref['ref_uid'];
        }

        $items = [];
        $counter = 0;
        $iterator = 0;

        $constraints = [];
        if (count($pageIds)) {
            $constraints = [
                $qb->expr()->notIn('p.doktype', $this->excludedDoktypes),
                $qb->expr()->notIn('p.uid', $pageIds),
            ];
        }

        $qb = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('pages');
        while ($counter < $this->limit) {
            $row = $qb->select('p.*')
                ->from('pages', 'p')
                ->where(...$constraints)
                ->orderBy('tstamp', 'DESC')
                ->setFirstResult($iterator)
                ->setMaxResults(1)
                ->executeQuery()
                ->fetchAssociative();

            if ($row === false) {
                // Likely fewer pages than the limit, prevent infinite loop
                break;
            }

            $iterator++;

            if (!$this->getBackendUser()->doesUserHaveAccess($row, Permission::PAGE_SHOW)) {
                continue;
            }

            $items[] = $row;
            $counter++;
        }

        return $items;
    }
}

1	<?php
2
3	declare(strict_types=1);
4
5	namespace YoastSeoForTypo3\YoastSeo\Widgets\Provider;
6
7	use TYPO3\CMS\Core\Database\Connection;
8	use TYPO3\CMS\Core\Database\ConnectionPool;
9	use TYPO3\CMS\Core\Type\Bitmask\Permission;
10	use TYPO3\CMS\Core\Utility\GeneralUtility;
11	use YoastSeoForTypo3\YoastSeo\Traits\BackendUserTrait;
12
13	class OrphanedContentDataProvider implements PageProviderInterface
14	{
15	use BackendUserTrait;
16
17	public function __construct(
18	/** @var int[] */
19	private array $excludedDoktypes,
20	private int $limit
21	) {
22	$this->limit = $limit ?: 5;	×
23	}
24
25	/**
26	* @return array<int, array<string, mixed>>
27	*/
28	public function getPages(): array
29	{
30	$qb = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('sys_refindex');	×
31
32	$constraints = [	×
33	$qb->expr()->eq('ref_table', $qb->createNamedParameter('pages')),	×
34	$qb->expr()->notIn(	×
35	'field',	×
36	$qb->createNamedParameter([	×
37	'l10n_parent',	×
NEW 38	'db_mountpoints',	×
39	], Connection::PARAM_STR_ARRAY)	×
NEW 40	),	×
41	];	×
42
43	$refs = $qb->select('ref_uid')	×
44	->from('sys_refindex')	×
45	->where(...$constraints)	×
46	->groupBy('ref_uid')	×
47	->executeQuery()	×
48	->fetchAllAssociative();	×
49
50	$pageIds = [];	×
51	foreach ($refs as $ref) {	×
52	$pageIds[] = $ref['ref_uid'];	×
53	}
54
55	$items = [];	×
56	$counter = 0;	×
57	$iterator = 0;	×
58
59	$constraints = [];	×
60	if (count($pageIds)) {	×
61	$constraints = [	×
62	$qb->expr()->notIn('p.doktype', $this->excludedDoktypes),	×
63	$qb->expr()->notIn('p.uid', $pageIds),	×
64	];	×
65	}
66
67	$qb = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('pages');	×
68	while ($counter < $this->limit) {	×
69	$row = $qb->select('p.*')	×
70	->from('pages', 'p')	×
71	->where(...$constraints)	×
72	->orderBy('tstamp', 'DESC')	×
73	->setFirstResult($iterator)	×
74	->setMaxResults(1)	×
75	->executeQuery()	×
76	->fetchAssociative();	×
77
78	if ($row === false) {	×
79	// Likely fewer pages than the limit, prevent infinite loop
80	break;	×
81	}
82
83	$iterator++;	×
84
85	if (!$this->getBackendUser()->doesUserHaveAccess($row, Permission::PAGE_SHOW)) {	×
86	continue;	×
87	}
88
89	$items[] = $row;	×
90	$counter++;	×
91	}
92
93	return $items;	×
94	}
95	}

Yoast / Yoast-SEO-for-TYPO3 / 13327579701

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous