fabarea / media

Classes/Facet/NumberOfReferencesFacet.php

Indentation +53 added lines, -53 removed lines

@@ -14,69 +14,69 @@
 
 class NumberOfReferencesFacet implements FacetInterface
 {
-    protected string $name = 'number_of_references';
+	protected string $name = 'number_of_references';
 
-    protected string $label = 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:usage';
+	protected string $label = 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:usage';
 
-    protected array $suggestions = [
-        '0', '1', '2', '3', 'etc...'
-    ];
-    protected string $dataType = 'sys_file';
+	protected array $suggestions = [
+		'0', '1', '2', '3', 'etc...'
+	];
+	protected string $dataType = 'sys_file';
 
-    public function getName(): string
-    {
-        return $this->name;
-    }
+	public function getName(): string
+	{
+		return $this->name;
+	}
 
-    public function getLabel(): string
-    {
-        return $this->getLanguageService()->sL($this->label);
-    }
+	public function getLabel(): string
+	{
+		return $this->getLanguageService()->sL($this->label);
+	}
 
-    public function getSuggestions(): array
-    {
-        return $this->suggestions;
-    }
+	public function getSuggestions(): array
+	{
+		return $this->suggestions;
+	}
 
-    public function hasSuggestions(): bool
-    {
-        return true;
-    }
+	public function hasSuggestions(): bool
+	{
+		return true;
+	}
 
-    /**
-     * @param string $dataType
-     * @return $this
-     */
-    public function setDataType($dataType): NumberOfReferencesFacet
-    {
-        $this->dataType = $dataType;
-        return $this;
-    }
+	/**
+	 * @param string $dataType
+	 * @return $this
+	 */
+	public function setDataType($dataType): NumberOfReferencesFacet
+	{
+		$this->dataType = $dataType;
+		return $this;
+	}
 
-    public function canModifyMatcher(): bool
-    {
-        return false;
-    }
+	public function canModifyMatcher(): bool
+	{
+		return false;
+	}
 
-    public function modifyMatcher(Matcher $matcher, $value): Matcher
-    {
-        return $matcher;
-    }
+	public function modifyMatcher(Matcher $matcher, $value): Matcher
+	{
+		return $matcher;
+	}
 
-    /**
-     * Magic method implementation for retrieving state.
-     *
-     * @param array $states
-     * @return $this
-     */
-    public static function __set_state($states)
-    {
-        return new NumberOfReferencesFacet();
-    }
+	/**
+	 * Magic method implementation for retrieving state.
+	 *
+	 * @param array $states
+	 * @return $this
+	 */
+	public static function __set_state($states)
+	{
+		return new NumberOfReferencesFacet();
+	}
 
-    protected function getLanguageService(): LanguageService
-    {
-        return $GLOBALS['LANG'];
-    }
+	protected function getLanguageService(): LanguageService
+	{
+		return $GLOBALS['LANG'];
+	}
 
 }

Classes/Facet/TypeFacet.php

Indentation +74 added lines, -74 removed lines

@@ -15,79 +15,79 @@
 
 class TypeFacet implements FacetInterface
 {
-    protected string $name = 'type';
-
-    protected string $label = 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type';
-
-    protected array $suggestions = [
-        File::FILETYPE_TEXT => 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type_1',
-        File::FILETYPE_IMAGE => 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type_2',
-        File::FILETYPE_AUDIO => 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type_3',
-        File::FILETYPE_VIDEO => 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type_4',
-        File::FILETYPE_APPLICATION => 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type_5',
-    ];
-
-    protected string $dataType = '';
-
-    public function getName(): string
-    {
-        return $this->name;
-    }
-
-    public function getLabel(): string
-    {
-        return $this->getLanguageService()->sL($this->label);
-    }
-
-    public function getSuggestions(): array
-    {
-        $suggestions = [];
-        foreach ($this->suggestions as $key => $label) {
-            $suggestions[] = array($key => $this->getLanguageService()->sL($label));
-        }
-
-        return $suggestions;
-    }
-
-    public function hasSuggestions(): bool
-    {
-        return true;
-    }
-
-    /**
-     * @param string $dataType
-     * @return $this
-     */
-    public function setDataType($dataType): TypeFacet
-    {
-        $this->dataType = $dataType;
-        return $this;
-    }
-
-    public function canModifyMatcher(): bool
-    {
-        return false;
-    }
-
-    public function modifyMatcher(Matcher $matcher, $value): Matcher
-    {
-        return $matcher;
-    }
-
-    /**
-     * Magic method implementation for retrieving state.
-     *
-     * @param array $states
-     * @return $this
-     */
-    public static function __set_state($states)
-    {
-        return new TypeFacet();
-    }
-
-    protected function getLanguageService(): LanguageService
-    {
-        return $GLOBALS['LANG'];
-    }
+	protected string $name = 'type';
+
+	protected string $label = 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type';
+
+	protected array $suggestions = [
+		File::FILETYPE_TEXT => 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type_1',
+		File::FILETYPE_IMAGE => 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type_2',
+		File::FILETYPE_AUDIO => 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type_3',
+		File::FILETYPE_VIDEO => 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type_4',
+		File::FILETYPE_APPLICATION => 'LLL:EXT:media/Resources/Private/Language/locallang.xlf:type_5',
+	];
+
+	protected string $dataType = '';
+
+	public function getName(): string
+	{
+		return $this->name;
+	}
+
+	public function getLabel(): string
+	{
+		return $this->getLanguageService()->sL($this->label);
+	}
+
+	public function getSuggestions(): array
+	{
+		$suggestions = [];
+		foreach ($this->suggestions as $key => $label) {
+			$suggestions[] = array($key => $this->getLanguageService()->sL($label));
+		}
+
+		return $suggestions;
+	}
+
+	public function hasSuggestions(): bool
+	{
+		return true;
+	}
+
+	/**
+	 * @param string $dataType
+	 * @return $this
+	 */
+	public function setDataType($dataType): TypeFacet
+	{
+		$this->dataType = $dataType;
+		return $this;
+	}
+
+	public function canModifyMatcher(): bool
+	{
+		return false;
+	}
+
+	public function modifyMatcher(Matcher $matcher, $value): Matcher
+	{
+		return $matcher;
+	}
+
+	/**
+	 * Magic method implementation for retrieving state.
+	 *
+	 * @param array $states
+	 * @return $this
+	 */
+	public static function __set_state($states)
+	{
+		return new TypeFacet();
+	}
+
+	protected function getLanguageService(): LanguageService
+	{
+		return $GLOBALS['LANG'];
+	}
 
 }

Classes/Resource/FileReferenceService.php

Indentation +215 added lines, -215 removed lines

@@ -21,219 +21,219 @@
  */
 class FileReferenceService
 {
-    /**
-     * Return all references found in sys_file_reference.
-     *
-     * @param File|int $file
-     */
-    public function findFileReferences($file): array
-    {
-        $fileIdentifier = $file instanceof File ? $file->getUid() : (int)$file;
-
-        // Get the file references of the file.
-        return $this->getDataService()->getRecords(
-            'sys_file_reference',
-            [
-                'uid_local' => $fileIdentifier,
-            ]
-        );
-    }
-
-    /**
-     * Return soft image references.
-     *
-     * @param File|int $file
-     */
-    public function findSoftImageReferences($file): array
-    {
-        $fileIdentifier = $file instanceof File ? $file->getUid() : (int)$file;
-
-        // Get the file references of the file in the RTE.
-        $softReferences = $this->getDataService()->getRecords(
-            'sys_refindex',
-            [
-                'softref_key' => 'rtehtmlarea_images',
-                'ref_table' => 'sys_file',
-                'ref_uid' => $fileIdentifier,
-            ]
-        );
-        return $softReferences;
-    }
-
-    protected function findFileIndexReferences(File $file): array
-    {
-        $queryBuilder = $this->getQueryBuilder('sys_refindex');
-        return $queryBuilder
-            ->select('*')
-            ->from('sys_refindex')
-            ->where(
-                $queryBuilder->expr()->eq(
-                    'ref_table',
-                    $queryBuilder->createNamedParameter('sys_file')
-                ),
-                $queryBuilder->expr()->eq(
-                    'ref_uid',
-                    $queryBuilder->createNamedParameter($file->getUid(), Connection::PARAM_INT)
-                ),
-                $queryBuilder->expr()->neq(
-                    'tablename',
-                    $queryBuilder->createNamedParameter('sys_file_metadata')
-                )
-            )
-            ->executeQuery()
-            ->fetchAllAssociative();
-    }
-
-    public function findContentIndexReferences(File $file): array
-    {
-        $queryBuilder = $this->getQueryBuilder('sys_refindex');
-        $relatedIndexReferences = [];
-        foreach ($this->findFileIndexReferences($file) as $fileIndexReference) {
-            $relatedIndexReference = $queryBuilder
-                ->select('*')
-                ->from('sys_refindex')
-                ->where(
-                    $queryBuilder->expr()->eq(
-                        'ref_table',
-                        $queryBuilder->createNamedParameter('sys_file_reference')
-                    ),
-                    $queryBuilder->expr()->eq(
-                        'ref_uid',
-                        $queryBuilder->createNamedParameter($fileIndexReference['recuid'], Connection::PARAM_INT)
-                    ),
-                    $queryBuilder->expr()->neq(
-                        'tablename',
-                        $queryBuilder->createNamedParameter('sys_file_metadata')
-                    )
-                )
-                ->executeQuery()
-                ->fetchAssociative();
-
-            if ($relatedIndexReference) {
-                $relatedIndexReferences[] = $relatedIndexReference;
-            }
-        }
-        return $relatedIndexReferences;
-    }
-
-    /**
-     * Return link image references.
-     *
-     * @param File|int $file
-     */
-    public function findSoftLinkReferences($file)
-    {
-        $fileIdentifier = $file instanceof File ? $file->getUid() : (int)$file;
-
-        // Get the link references of the file.
-        $softReferences = $this->getDataService()->getRecords(
-            'sys_refindex',
-            [
-                'softref_key' => 'typolink_tag',
-                'ref_table' => 'sys_file',
-                'ref_uid' => $fileIdentifier,
-            ]
-        );
-        return $softReferences;
-    }
-
-    /**
-     * @param File|int $file
-     */
-    public function countTotalReferences($file): int
-    {
-
-        $fileUid = $file instanceof File
-            ? $file->getUid()
-            : $file;
-
-        $numberOfReferences = $this->countFileReferences($fileUid);
-        $numberOfReferences += $this->countSoftImageReferences($fileUid);
-        $numberOfReferences += $this->countSoftLinkReferences($fileUid);
-        $numberOfReferences += $this->countFileIndexReferences($fileUid);
-
-        return $numberOfReferences;
-    }
-
-    /**
-     * Count all references found in sys_file_reference.
-     */
-    protected function countFileReferences(int $fileUid): int
-    {
-        return $this->getDataService()
-            ->count(
-                'sys_file_reference',
-                [
-                    'uid_local' => $fileUid
-                ]
-            );
-    }
-
-    /**
-     * Count soft image references.
-     */
-    protected function countSoftImageReferences(int $fileUid): int
-    {
-        return $this->getDataService()
-            ->count(
-                'sys_refindex',
-                [
-                    'softref_key' => 'rtehtmlarea_images',
-                    'ref_table' => 'sys_file',
-                    'ref_uid' => $fileUid
-                ]
-            );
-    }
-
-    /**
-     * Count link image references.
-     */
-    protected function countSoftLinkReferences(int $fileUid): int
-    {
-        return $this->getDataService()
-            ->count(
-                'sys_refindex',
-                [
-                    'softref_key' => 'typolink_tag',
-                    'ref_table' => 'sys_file',
-                    'ref_uid' => $fileUid
-                ]
-            );
-    }
-
-    protected function countFileIndexReferences(int $fileUid): int
-    {
-        $queryBuilder = $this->getQueryBuilder('sys_refindex');
-        return (int)$queryBuilder
-            ->count('*')
-            ->from('sys_refindex')
-            ->where(
-                $queryBuilder->expr()->eq(
-                    'ref_table',
-                    $queryBuilder->createNamedParameter('sys_file')
-                ),
-                $queryBuilder->expr()->eq(
-                    'ref_uid',
-                    $queryBuilder->createNamedParameter($fileUid, Connection::PARAM_INT)
-                ),
-                $queryBuilder->expr()->neq(
-                    'tablename',
-                    $queryBuilder->createNamedParameter('sys_file_metadata')
-                )
-            )
-            ->executeQuery()
-            ->fetchOne();
-    }
-
-    protected function getQueryBuilder(string $tableName): QueryBuilder
-    {
-        /** @var ConnectionPool $connectionPool */
-        $connectionPool = GeneralUtility::makeInstance(ConnectionPool::class);
-        return $connectionPool->getQueryBuilderForTable($tableName);
-    }
-
-    protected function getDataService(): DataService
-    {
-        return GeneralUtility::makeInstance(DataService::class);
-    }
+	/**
+	 * Return all references found in sys_file_reference.
+	 *
+	 * @param File|int $file
+	 */
+	public function findFileReferences($file): array
+	{
+		$fileIdentifier = $file instanceof File ? $file->getUid() : (int)$file;
+
+		// Get the file references of the file.
+		return $this->getDataService()->getRecords(
+			'sys_file_reference',
+			[
+				'uid_local' => $fileIdentifier,
+			]
+		);
+	}
+
+	/**
+	 * Return soft image references.
+	 *
+	 * @param File|int $file
+	 */
+	public function findSoftImageReferences($file): array
+	{
+		$fileIdentifier = $file instanceof File ? $file->getUid() : (int)$file;
+
+		// Get the file references of the file in the RTE.
+		$softReferences = $this->getDataService()->getRecords(
+			'sys_refindex',
+			[
+				'softref_key' => 'rtehtmlarea_images',
+				'ref_table' => 'sys_file',
+				'ref_uid' => $fileIdentifier,
+			]
+		);
+		return $softReferences;
+	}
+
+	protected function findFileIndexReferences(File $file): array
+	{
+		$queryBuilder = $this->getQueryBuilder('sys_refindex');
+		return $queryBuilder
+			->select('*')
+			->from('sys_refindex')
+			->where(
+				$queryBuilder->expr()->eq(
+					'ref_table',
+					$queryBuilder->createNamedParameter('sys_file')
+				),
+				$queryBuilder->expr()->eq(
+					'ref_uid',
+					$queryBuilder->createNamedParameter($file->getUid(), Connection::PARAM_INT)
+				),
+				$queryBuilder->expr()->neq(
+					'tablename',
+					$queryBuilder->createNamedParameter('sys_file_metadata')
+				)
+			)
+			->executeQuery()
+			->fetchAllAssociative();
+	}
+
+	public function findContentIndexReferences(File $file): array
+	{
+		$queryBuilder = $this->getQueryBuilder('sys_refindex');
+		$relatedIndexReferences = [];
+		foreach ($this->findFileIndexReferences($file) as $fileIndexReference) {
+			$relatedIndexReference = $queryBuilder
+				->select('*')
+				->from('sys_refindex')
+				->where(
+					$queryBuilder->expr()->eq(
+						'ref_table',
+						$queryBuilder->createNamedParameter('sys_file_reference')
+					),
+					$queryBuilder->expr()->eq(
+						'ref_uid',
+						$queryBuilder->createNamedParameter($fileIndexReference['recuid'], Connection::PARAM_INT)
+					),
+					$queryBuilder->expr()->neq(
+						'tablename',
+						$queryBuilder->createNamedParameter('sys_file_metadata')
+					)
+				)
+				->executeQuery()
+				->fetchAssociative();
+
+			if ($relatedIndexReference) {
+				$relatedIndexReferences[] = $relatedIndexReference;
+			}
+		}
+		return $relatedIndexReferences;
+	}
+
+	/**
+	 * Return link image references.
+	 *
+	 * @param File|int $file
+	 */
+	public function findSoftLinkReferences($file)
+	{
+		$fileIdentifier = $file instanceof File ? $file->getUid() : (int)$file;
+
+		// Get the link references of the file.
+		$softReferences = $this->getDataService()->getRecords(
+			'sys_refindex',
+			[
+				'softref_key' => 'typolink_tag',
+				'ref_table' => 'sys_file',
+				'ref_uid' => $fileIdentifier,
+			]
+		);
+		return $softReferences;
+	}
+
+	/**
+	 * @param File|int $file
+	 */
+	public function countTotalReferences($file): int
+	{
+
+		$fileUid = $file instanceof File
+			? $file->getUid()
+			: $file;
+
+		$numberOfReferences = $this->countFileReferences($fileUid);
+		$numberOfReferences += $this->countSoftImageReferences($fileUid);
+		$numberOfReferences += $this->countSoftLinkReferences($fileUid);
+		$numberOfReferences += $this->countFileIndexReferences($fileUid);
+
+		return $numberOfReferences;
+	}
+
+	/**
+	 * Count all references found in sys_file_reference.
+	 */
+	protected function countFileReferences(int $fileUid): int
+	{
+		return $this->getDataService()
+			->count(
+				'sys_file_reference',
+				[
+					'uid_local' => $fileUid
+				]
+			);
+	}
+
+	/**
+	 * Count soft image references.
+	 */
+	protected function countSoftImageReferences(int $fileUid): int
+	{
+		return $this->getDataService()
+			->count(
+				'sys_refindex',
+				[
+					'softref_key' => 'rtehtmlarea_images',
+					'ref_table' => 'sys_file',
+					'ref_uid' => $fileUid
+				]
+			);
+	}
+
+	/**
+	 * Count link image references.
+	 */
+	protected function countSoftLinkReferences(int $fileUid): int
+	{
+		return $this->getDataService()
+			->count(
+				'sys_refindex',
+				[
+					'softref_key' => 'typolink_tag',
+					'ref_table' => 'sys_file',
+					'ref_uid' => $fileUid
+				]
+			);
+	}
+
+	protected function countFileIndexReferences(int $fileUid): int
+	{
+		$queryBuilder = $this->getQueryBuilder('sys_refindex');
+		return (int)$queryBuilder
+			->count('*')
+			->from('sys_refindex')
+			->where(
+				$queryBuilder->expr()->eq(
+					'ref_table',
+					$queryBuilder->createNamedParameter('sys_file')
+				),
+				$queryBuilder->expr()->eq(
+					'ref_uid',
+					$queryBuilder->createNamedParameter($fileUid, Connection::PARAM_INT)
+				),
+				$queryBuilder->expr()->neq(
+					'tablename',
+					$queryBuilder->createNamedParameter('sys_file_metadata')
+				)
+			)
+			->executeQuery()
+			->fetchOne();
+	}
+
+	protected function getQueryBuilder(string $tableName): QueryBuilder
+	{
+		/** @var ConnectionPool $connectionPool */
+		$connectionPool = GeneralUtility::makeInstance(ConnectionPool::class);
+		return $connectionPool->getQueryBuilderForTable($tableName);
+	}
+
+	protected function getDataService(): DataService
+	{
+		return GeneralUtility::makeInstance(DataService::class);
+	}
 }