FileAttachmentQueryBuilder::addRelationsToAQuery() - Code Metrics - Inspection of "FRW-10957 Adjusted P&S logic for product modules t..." - spryker/spryker-core - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Push — master ( ae631c...a04781 )

unknown

created 2025-09-16 09:19 UTC

FileAttachmentQueryBuilder::addRelationsToAQuery() B

↳ Parent: FileAttachmentQueryBuilder

Complexity

Conditions	10
Paths	37

Size

Total Lines	54
Code Lines	31

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	10
eloc	31
nc	37
nop	2
dl	0
loc	54
rs	7.6666
c	1
b	0
f	0

How to fix Long Method Complexity

<?php

/**
 * Copyright © 2016-present Spryker Systems GmbH. All rights reserved.
 * Use of this software requires acceptance of the Evaluation License Agreement. See LICENSE file.
 */

namespace SprykerFeature\Zed\SelfServicePortal\Persistence\QueryBuilder;

use ArrayObject;
use Generated\Shared\Transfer\FileAttachmentConditionsTransfer;
use Generated\Shared\Transfer\FileAttachmentCriteriaTransfer;
use Orm\Zed\CompanyBusinessUnit\Persistence\Map\SpyCompanyBusinessUnitTableMap;
use Orm\Zed\FileManager\Persistence\Map\SpyFileInfoTableMap;
use Orm\Zed\FileManager\Persistence\SpyFileQuery;
use Orm\Zed\SelfServicePortal\Persistence\Map\SpyCompanyBusinessUnitFileTableMap;
use Orm\Zed\SelfServicePortal\Persistence\Map\SpyCompanyUserFileTableMap;
use Orm\Zed\SelfServicePortal\Persistence\Map\SpySspAssetFileTableMap;
use Orm\Zed\SelfServicePortal\Persistence\Map\SpySspAssetTableMap;
use Propel\Runtime\ActiveQuery\Criteria;
use Propel\Runtime\ActiveQuery\Criterion\AbstractCriterion;
use Propel\Runtime\ActiveQuery\ModelCriteria;

class FileAttachmentQueryBuilder
{
    /**
     * @var string
     */
    public const BUSINESS_UNIT_IDS_COLUMN = 'businessUnitIds';

    /**
     * @var string
     */
    public const COMPANY_IDS_COLUMN = 'companyIds';

    /**
     * @var string
     */
    public const COMPANY_USER_IDS_COLUMN = 'companyUserIds';

    /**
     * @var string
     */
    public const SSP_ASSET_IDS_COLUMN = 'sspAssetIds';

    public function applyCriteria(SpyFileQuery $fileQuery, FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer): SpyFileQuery
    {
        $fileQuery = $this->applyFileIdFilter($fileQuery, $fileAttachmentCriteriaTransfer);
        $fileQuery = $this->applyFileAttachmentUuidFilter($fileQuery, $fileAttachmentCriteriaTransfer);
        $fileQuery = $this->addRelationsToAQuery($fileQuery, $fileAttachmentCriteriaTransfer);
        $fileQuery = $this->applyFileAttachmentSearch($fileQuery, $fileAttachmentCriteriaTransfer);
        $fileQuery = $this->applyFileAttachmentTypeFilter($fileQuery, $fileAttachmentCriteriaTransfer);
        $fileQuery = $this->applyFileAttachmentDateRangeFilter($fileQuery, $fileAttachmentCriteriaTransfer);

        /** @var \ArrayObject<array-key, \Generated\Shared\Transfer\SortTransfer> $sortTransfers */
        $sortTransfers = $fileAttachmentCriteriaTransfer->getSortCollection();
        $this->applyFileAttachmentSorting($fileQuery, $sortTransfers);

        return $fileQuery;
    }

    protected function addRelationsToAQuery(SpyFileQuery $fileQuery, FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer): SpyFileQuery
    {
        if (
            !$fileAttachmentCriteriaTransfer->getWithBusinessUnitRelation() &&
            !$fileAttachmentCriteriaTransfer->getWithCompanyUserRelation() &&
            !$fileAttachmentCriteriaTransfer->getWithSspAssetRelation()
        ) {
            return $fileQuery;
        }

        $fileAttachmentConditions = $fileAttachmentCriteriaTransfer->getFileAttachmentConditions() ?? new FileAttachmentConditionsTransfer();

        $fileAttachmentFilterCriteria = null;
        if ($fileAttachmentCriteriaTransfer->getWithBusinessUnitRelation()) {
            $fileQuery
                ->withColumn('GROUP_CONCAT(' . SpyCompanyBusinessUnitFileTableMap::COL_FK_COMPANY_BUSINESS_UNIT . ')', static::BUSINESS_UNIT_IDS_COLUMN)
                ->joinSpyCompanyBusinessUnitFile(null, Criteria::LEFT_JOIN);

            $businessUnitFileCriteria = $this->getBusinessUnitFileCriteria($fileQuery, $fileAttachmentConditions);

            $fileAttachmentFilterCriteria = $this->addSubCriteria($businessUnitFileCriteria, $fileAttachmentFilterCriteria);
        }

        if ($fileAttachmentCriteriaTransfer->getWithCompanyUserRelation()) {
            $fileQuery
                ->withColumn('GROUP_CONCAT(' . SpyCompanyUserFileTableMap::COL_FK_COMPANY_USER . ')', static::COMPANY_USER_IDS_COLUMN)
                ->joinSpyCompanyUserFile(null, Criteria::LEFT_JOIN);

            $companyUserFilterCriteria = $this->getCompanyUserFileCriteria($fileQuery, $fileAttachmentConditions);

            if ($companyUserFilterCriteria) {
                $fileAttachmentFilterCriteria = $this->addSubCriteria($companyUserFilterCriteria, $fileAttachmentFilterCriteria);
            }
        }

        if ($fileAttachmentCriteriaTransfer->getWithSspAssetRelation()) {
            $fileQuery
                ->withColumn('GROUP_CONCAT(' . SpySspAssetFileTableMap::COL_FK_SSP_ASSET . ')', static::SSP_ASSET_IDS_COLUMN)
                ->useSpySspAssetFileQuery(null, Criteria::LEFT_JOIN);

            $sspAssetFilterCriteria = $this->applySspAssetFileCriteria($fileQuery, $fileAttachmentCriteriaTransfer);

            if ($sspAssetFilterCriteria) {
                $fileAttachmentFilterCriteria = $this->addSubCriteria($sspAssetFilterCriteria, $fileAttachmentFilterCriteria);
            }
        }

        if (!$fileAttachmentFilterCriteria) {
            return $fileQuery;
        }

        $fileQuery->addAnd($fileAttachmentFilterCriteria);

        return $fileQuery;
    }

    protected function getBusinessUnitFileCriteria(
        SpyFileQuery $fileQuery,
        FileAttachmentConditionsTransfer $fileAttachmentConditionsTransfer
    ): ?AbstractCriterion {
        $businessUnitQuery = $fileQuery
            ->useSpyCompanyBusinessUnitFileQuery(null, Criteria::LEFT_JOIN)
            ->useCompanyBusinessUnitQuery(null, Criteria::LEFT_JOIN);

        $businessUnitQuery->endUse()->endUse();

        $criteria = null;
        if ($fileAttachmentConditionsTransfer->getCompanyIds()) {
            $criteria = $businessUnitQuery->getNewCriterion(
                SpyCompanyBusinessUnitTableMap::COL_FK_COMPANY,
                $fileAttachmentConditionsTransfer->getCompanyIds(),
                Criteria::IN,
            );
        }

        if ($fileAttachmentConditionsTransfer->getBusinessUnitIds()) {
            $businessUnitIdFileCriteria = $businessUnitQuery->getNewCriterion(
                SpyCompanyBusinessUnitTableMap::COL_ID_COMPANY_BUSINESS_UNIT,
                $fileAttachmentConditionsTransfer->getBusinessUnitIds(),
                Criteria::IN,
            );

            if ($criteria) {
                $criteria->addAnd($businessUnitIdFileCriteria);

                return $criteria;
            }

            return $businessUnitIdFileCriteria;
        }

        if ($fileAttachmentConditionsTransfer->getBusinessUnitUuids()) {
            $businessUnitUuidCriteria = $businessUnitQuery->getNewCriterion(
                SpyCompanyBusinessUnitTableMap::COL_UUID,
                $fileAttachmentConditionsTransfer->getBusinessUnitUuids(),
                Criteria::IN,
            );

            if ($criteria) {
                $criteria->addAnd($businessUnitUuidCriteria);

                return $criteria;
            }
        }

        return $criteria;
    }

    protected function getCompanyUserFileCriteria(
        SpyFileQuery $fileQuery,
        FileAttachmentConditionsTransfer $fileAttachmentConditionsTransfer
    ): ?AbstractCriterion {
        $companyUserFileQuery = $fileQuery
            ->useSpyCompanyUserFileQuery(null, Criteria::LEFT_JOIN);

        $companyUserQuery = $companyUserFileQuery->useCompanyUserQuery('company_user', Criteria::LEFT_JOIN);

        $companyUserFileQuery->endUse();

        $criteria = null;
        if ($fileAttachmentConditionsTransfer->getCompanyUserIds()) {
            $criteria = $companyUserFileQuery->getNewCriterion(
                SpyCompanyUserFileTableMap::COL_FK_COMPANY_USER,
                $fileAttachmentConditionsTransfer->getCompanyUserIds(),
                Criteria::IN,
            );
        }

        if ($fileAttachmentConditionsTransfer->getCompanyIds()) {
            $companyIdCriteria = $companyUserQuery->getNewCriterion(
                'company_user.fk_company',
                $fileAttachmentConditionsTransfer->getCompanyIds(),
                Criteria::IN,
            );

            if ($criteria) {
                $companyIdCriteria->addAnd($criteria);
            }

            if (!$criteria) {
                $criteria = $companyIdCriteria;
            }
        }

        if ($fileAttachmentConditionsTransfer->getBusinessUnitIds()) {
            $businessUnitIdCriteria = $companyUserQuery->getNewCriterion(
                'company_user.fk_company_business_unit',
                $fileAttachmentConditionsTransfer->getBusinessUnitIds(),
                Criteria::IN,
            );

            if ($criteria) {
                $criteria->addAnd($businessUnitIdCriteria);

                return $criteria;
            }

            return $businessUnitIdCriteria;
        }

        return $criteria;
    }

    protected function applySspAssetFileCriteria(SpyFileQuery $fileQuery, FileAttachmentCriteriaTransfer $criteriaTransfer): ?AbstractCriterion
    {
        $fileAttachmentCriteriaTransfer = $criteriaTransfer->getFileAttachmentConditionsOrFail();

        $sspAssetQuery = $fileQuery
            ->useSpySspAssetFileQuery(null, Criteria::LEFT_JOIN)
            ->useSspAssetQuery(null, Criteria::LEFT_JOIN);

        $companyBusinessUnitQuery = $sspAssetQuery
            ->useSpySspAssetToCompanyBusinessUnitQuery(null, Criteria::LEFT_JOIN)
            ->joinSpyCompanyBusinessUnit('ssp_asset_business_unit', Criteria::LEFT_JOIN);

        $companyBusinessUnitQuery
            ->endUse()
            ->endUse()
            ->endUse();

        $criteria = null;
        if ($fileAttachmentCriteriaTransfer->getAssetReferences()) {
            $criteria = $sspAssetQuery->getNewCriterion(
                SpySspAssetTableMap::COL_REFERENCE,
                $fileAttachmentCriteriaTransfer->getAssetReferences(),
                Criteria::IN,
            );
        }

        if ($fileAttachmentCriteriaTransfer->getSspAssetCompanyIds()) {
            $assetCompanyIdCriterion = $fileQuery->getNewCriterion(
                'ssp_asset_business_unit.fk_company',
                $fileAttachmentCriteriaTransfer->getSspAssetCompanyIds(),
                Criteria::IN,
            );

            if ($criteria) {
                $criteria->addAnd($assetCompanyIdCriterion);
            } else {
                $criteria = $assetCompanyIdCriterion;
            }
        }

        if ($fileAttachmentCriteriaTransfer->getSspAssetBusinessUnitIds()) {
            $assetBusinessUnitIdCriterion = $fileQuery->getNewCriterion(
                'ssp_asset_business_unit.id_company_business_unit',
                $fileAttachmentCriteriaTransfer->getSspAssetBusinessUnitIds(),
                Criteria::IN,
            );

            if ($criteria) {
                $criteria->addAnd($assetBusinessUnitIdCriterion);
            } else {
                $criteria = $assetBusinessUnitIdCriterion;
            }
        }

        return $criteria;
    }

    protected function applyFileAttachmentSearch(
        SpyFileQuery $query,
        FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer
    ): SpyFileQuery {
        if (!$fileAttachmentCriteriaTransfer->getFileAttachmentSearchConditions()) {
            return $query;
        }

        $searchString = $fileAttachmentCriteriaTransfer->getFileAttachmentSearchConditions()->getSearchString();
        if ($searchString) {
            $query->filterByFileName_Like(sprintf('%%%s%%', $searchString))
                ->_or()
                ->filterByFileReference_Like(sprintf('%%%s%%', $searchString));
        }

        return $query;
    }

    protected function applyFileAttachmentTypeFilter(
        SpyFileQuery $query,
        FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer
    ): SpyFileQuery {
        $fileTypes = $fileAttachmentCriteriaTransfer->getFileAttachmentConditionsOrFail()->getFileTypes();

        if (!$fileTypes) {
            return $query;
        }

        return $query
            ->useSpyFileInfoQuery()
            ->filterByExtension_In($fileTypes)
            ->endUse();
    }

    protected function applyFileAttachmentDateRangeFilter(
        SpyFileQuery $query,
        FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer
    ): SpyFileQuery {
        $rangeCreatedAt = $fileAttachmentCriteriaTransfer->getFileAttachmentConditionsOrFail()->getRangeCreatedAt();
        if (!$rangeCreatedAt) {
            return $query;
        }

        if ($rangeCreatedAt->getFrom()) {
            $query->useSpyFileInfoQuery()
                ->filterByCreatedAt($rangeCreatedAt->getFrom(), Criteria::GREATER_EQUAL)
                ->endUse();
        }

        if ($rangeCreatedAt->getTo()) {
            $query->useSpyFileInfoQuery()
                ->filterByCreatedAt($rangeCreatedAt->getTo(), Criteria::LESS_EQUAL)
                ->endUse();
        }

        return $query;
    }

    protected function applyFileAttachmentUuidFilter(
        SpyFileQuery $query,
        FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer
    ): SpyFileQuery {
        $uuids = $fileAttachmentCriteriaTransfer->getFileAttachmentConditionsOrFail()->getUuids();
        if ($uuids !== []) {
            $query
                ->filterByUuid_In($uuids);
        }

        return $query;
    }

    protected function applyFileIdFilter(
        SpyFileQuery $query,
        FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer
    ): SpyFileQuery {
        $fileIds = $fileAttachmentCriteriaTransfer->getFileAttachmentConditionsOrFail()->getIdFiles();
        if ($fileIds !== []) {
            $query
                ->filterByIdFile_In($fileIds);
        }

        return $query;
    }

    /**
     * @param \Propel\Runtime\ActiveQuery\ModelCriteria $query
     * @param \ArrayObject<array-key, \Generated\Shared\Transfer\SortTransfer> $sortTransfers
     *
     * @return \Propel\Runtime\ActiveQuery\ModelCriteria
     */
    protected function applyFileAttachmentSorting(ModelCriteria $query, ArrayObject $sortTransfers): ModelCriteria
    {
        $fileAttachmentSortFieldMapping = $this->getFileAttachmentSortFieldMapping();
        foreach ($sortTransfers as $sortTransfer) {
            $query
                ->groupBy($fileAttachmentSortFieldMapping[$sortTransfer->getFieldOrFail()] ?? $sortTransfer->getFieldOrFail())
                ->orderBy(
                    $fileAttachmentSortFieldMapping[$sortTransfer->getFieldOrFail()] ?? $sortTransfer->getFieldOrFail(),
                    $sortTransfer->getIsAscending() ? Criteria::ASC : Criteria::DESC,
                );
        }

        return $query;
    }

    /**
     * @return array<string, string>
     */
    protected function getFileAttachmentSortFieldMapping(): array
    {
        return [
            'fileType' => SpyFileInfoTableMap::COL_EXTENSION,
            'size' => SpyFileInfoTableMap::COL_SIZE,
            'createdAt' => SpyFileInfoTableMap::COL_CREATED_AT,
        ];
    }

    protected function addSubCriteria(?AbstractCriterion $subCriteria, ?AbstractCriterion $criteria): ?AbstractCriterion
    {
        if (!$subCriteria) {
            return $criteria;
        }

        if ($criteria) {
            $criteria->addOr($subCriteria);

            return $criteria;
        }

        return $subCriteria;
    }
}


1			<?php
2
3			/**
4			* Copyright © 2016-present Spryker Systems GmbH. All rights reserved.
5			* Use of this software requires acceptance of the Evaluation License Agreement. See LICENSE file.
6			*/
7
8			namespace SprykerFeature\Zed\SelfServicePortal\Persistence\QueryBuilder;
9
10			use ArrayObject;
11			use Generated\Shared\Transfer\FileAttachmentConditionsTransfer;
12			use Generated\Shared\Transfer\FileAttachmentCriteriaTransfer;
13			use Orm\Zed\CompanyBusinessUnit\Persistence\Map\SpyCompanyBusinessUnitTableMap;
14			use Orm\Zed\FileManager\Persistence\Map\SpyFileInfoTableMap;
15			use Orm\Zed\FileManager\Persistence\SpyFileQuery;
16			use Orm\Zed\SelfServicePortal\Persistence\Map\SpyCompanyBusinessUnitFileTableMap;
17			use Orm\Zed\SelfServicePortal\Persistence\Map\SpyCompanyUserFileTableMap;
18			use Orm\Zed\SelfServicePortal\Persistence\Map\SpySspAssetFileTableMap;
19			use Orm\Zed\SelfServicePortal\Persistence\Map\SpySspAssetTableMap;
20			use Propel\Runtime\ActiveQuery\Criteria;
21			use Propel\Runtime\ActiveQuery\Criterion\AbstractCriterion;
22			use Propel\Runtime\ActiveQuery\ModelCriteria;
23
24			class FileAttachmentQueryBuilder
25			{
26			/**
27			* @var string
28			*/
29			public const BUSINESS_UNIT_IDS_COLUMN = 'businessUnitIds';
30
31			/**
32			* @var string
33			*/
34			public const COMPANY_IDS_COLUMN = 'companyIds';
35
36			/**
37			* @var string
38			*/
39			public const COMPANY_USER_IDS_COLUMN = 'companyUserIds';
40
41			/**
42			* @var string
43			*/
44			public const SSP_ASSET_IDS_COLUMN = 'sspAssetIds';
45
46			public function applyCriteria(SpyFileQuery $fileQuery, FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer): SpyFileQuery
47			{
48			$fileQuery = $this->applyFileIdFilter($fileQuery, $fileAttachmentCriteriaTransfer);
49			$fileQuery = $this->applyFileAttachmentUuidFilter($fileQuery, $fileAttachmentCriteriaTransfer);
50			$fileQuery = $this->addRelationsToAQuery($fileQuery, $fileAttachmentCriteriaTransfer);
51			$fileQuery = $this->applyFileAttachmentSearch($fileQuery, $fileAttachmentCriteriaTransfer);
52			$fileQuery = $this->applyFileAttachmentTypeFilter($fileQuery, $fileAttachmentCriteriaTransfer);
53			$fileQuery = $this->applyFileAttachmentDateRangeFilter($fileQuery, $fileAttachmentCriteriaTransfer);
54
55			/** @var \ArrayObject<array-key, \Generated\Shared\Transfer\SortTransfer> $sortTransfers */
56			$sortTransfers = $fileAttachmentCriteriaTransfer->getSortCollection();
57			$this->applyFileAttachmentSorting($fileQuery, $sortTransfers);
58
59			return $fileQuery;
60			}
61
62			protected function addRelationsToAQuery(SpyFileQuery $fileQuery, FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer): SpyFileQuery
63			{
64			if (
65			!$fileAttachmentCriteriaTransfer->getWithBusinessUnitRelation() &&
66			!$fileAttachmentCriteriaTransfer->getWithCompanyUserRelation() &&
67			!$fileAttachmentCriteriaTransfer->getWithSspAssetRelation()
68			) {
69			return $fileQuery;
70			}
71
72			$fileAttachmentConditions = $fileAttachmentCriteriaTransfer->getFileAttachmentConditions() ?? new FileAttachmentConditionsTransfer();
73
74			$fileAttachmentFilterCriteria = null;
75			if ($fileAttachmentCriteriaTransfer->getWithBusinessUnitRelation()) {
76			$fileQuery
77			->withColumn('GROUP_CONCAT(' . SpyCompanyBusinessUnitFileTableMap::COL_FK_COMPANY_BUSINESS_UNIT . ')', static::BUSINESS_UNIT_IDS_COLUMN)
78			->joinSpyCompanyBusinessUnitFile(null, Criteria::LEFT_JOIN);
79
80			$businessUnitFileCriteria = $this->getBusinessUnitFileCriteria($fileQuery, $fileAttachmentConditions);
81
82			$fileAttachmentFilterCriteria = $this->addSubCriteria($businessUnitFileCriteria, $fileAttachmentFilterCriteria);
83			}
84
85			if ($fileAttachmentCriteriaTransfer->getWithCompanyUserRelation()) {
86			$fileQuery
87			->withColumn('GROUP_CONCAT(' . SpyCompanyUserFileTableMap::COL_FK_COMPANY_USER . ')', static::COMPANY_USER_IDS_COLUMN)
88			->joinSpyCompanyUserFile(null, Criteria::LEFT_JOIN);
89
90			$companyUserFilterCriteria = $this->getCompanyUserFileCriteria($fileQuery, $fileAttachmentConditions);
91
92			if ($companyUserFilterCriteria) {
93			$fileAttachmentFilterCriteria = $this->addSubCriteria($companyUserFilterCriteria, $fileAttachmentFilterCriteria);
94			}
95			}
96
97			if ($fileAttachmentCriteriaTransfer->getWithSspAssetRelation()) {
98			$fileQuery
99			->withColumn('GROUP_CONCAT(' . SpySspAssetFileTableMap::COL_FK_SSP_ASSET . ')', static::SSP_ASSET_IDS_COLUMN)
100			->useSpySspAssetFileQuery(null, Criteria::LEFT_JOIN);
101
102			$sspAssetFilterCriteria = $this->applySspAssetFileCriteria($fileQuery, $fileAttachmentCriteriaTransfer);
103
104			if ($sspAssetFilterCriteria) {
105			$fileAttachmentFilterCriteria = $this->addSubCriteria($sspAssetFilterCriteria, $fileAttachmentFilterCriteria);
106			}
107			}
108
109			if (!$fileAttachmentFilterCriteria) {
110			return $fileQuery;
111			}
112
113			$fileQuery->addAnd($fileAttachmentFilterCriteria);
114
115			return $fileQuery;
116			}
117
118			protected function getBusinessUnitFileCriteria(
119			SpyFileQuery $fileQuery,
120			FileAttachmentConditionsTransfer $fileAttachmentConditionsTransfer
121			): ?AbstractCriterion {
122			$businessUnitQuery = $fileQuery
123			->useSpyCompanyBusinessUnitFileQuery(null, Criteria::LEFT_JOIN)
124			->useCompanyBusinessUnitQuery(null, Criteria::LEFT_JOIN);
125
126			$businessUnitQuery->endUse()->endUse();
127
128			$criteria = null;
129			if ($fileAttachmentConditionsTransfer->getCompanyIds()) {
130			$criteria = $businessUnitQuery->getNewCriterion(
131			SpyCompanyBusinessUnitTableMap::COL_FK_COMPANY,
132			$fileAttachmentConditionsTransfer->getCompanyIds(),
133			Criteria::IN,
134			);
135			}
136
137			if ($fileAttachmentConditionsTransfer->getBusinessUnitIds()) {
138			$businessUnitIdFileCriteria = $businessUnitQuery->getNewCriterion(
139			SpyCompanyBusinessUnitTableMap::COL_ID_COMPANY_BUSINESS_UNIT,
140			$fileAttachmentConditionsTransfer->getBusinessUnitIds(),
141			Criteria::IN,
142			);
143
144			if ($criteria) {
145			$criteria->addAnd($businessUnitIdFileCriteria);
146
147			return $criteria;
148			}
149
150			return $businessUnitIdFileCriteria;
151			}
152
153			if ($fileAttachmentConditionsTransfer->getBusinessUnitUuids()) {
154			$businessUnitUuidCriteria = $businessUnitQuery->getNewCriterion(
155			SpyCompanyBusinessUnitTableMap::COL_UUID,
156			$fileAttachmentConditionsTransfer->getBusinessUnitUuids(),
157			Criteria::IN,
158			);
159
160			if ($criteria) {
161			$criteria->addAnd($businessUnitUuidCriteria);
162
163			return $criteria;
164			}
165			}
166
167			return $criteria;
168			}
169
170			protected function getCompanyUserFileCriteria(
171			SpyFileQuery $fileQuery,
172			FileAttachmentConditionsTransfer $fileAttachmentConditionsTransfer
173			): ?AbstractCriterion {
174			$companyUserFileQuery = $fileQuery
175			->useSpyCompanyUserFileQuery(null, Criteria::LEFT_JOIN);
176
177			$companyUserQuery = $companyUserFileQuery->useCompanyUserQuery('company_user', Criteria::LEFT_JOIN);
178
179			$companyUserFileQuery->endUse();
180
181			$criteria = null;
182			if ($fileAttachmentConditionsTransfer->getCompanyUserIds()) {
183			$criteria = $companyUserFileQuery->getNewCriterion(
184			SpyCompanyUserFileTableMap::COL_FK_COMPANY_USER,
185			$fileAttachmentConditionsTransfer->getCompanyUserIds(),
186			Criteria::IN,
187			);
188			}
189
190			if ($fileAttachmentConditionsTransfer->getCompanyIds()) {
191			$companyIdCriteria = $companyUserQuery->getNewCriterion(
192			'company_user.fk_company',
193			$fileAttachmentConditionsTransfer->getCompanyIds(),
194			Criteria::IN,
195			);
196
197			if ($criteria) {
198			$companyIdCriteria->addAnd($criteria);
199			}
200
201			if (!$criteria) {
202			$criteria = $companyIdCriteria;
203			}
204			}
205
206			if ($fileAttachmentConditionsTransfer->getBusinessUnitIds()) {
207			$businessUnitIdCriteria = $companyUserQuery->getNewCriterion(
208			'company_user.fk_company_business_unit',
209			$fileAttachmentConditionsTransfer->getBusinessUnitIds(),
210			Criteria::IN,
211			);
212
213			if ($criteria) {
214			$criteria->addAnd($businessUnitIdCriteria);
215
216			return $criteria;
217			}
218
219			return $businessUnitIdCriteria;
220			}
221
222			return $criteria;
223			}
224
225			protected function applySspAssetFileCriteria(SpyFileQuery $fileQuery, FileAttachmentCriteriaTransfer $criteriaTransfer): ?AbstractCriterion
226			{
227			$fileAttachmentCriteriaTransfer = $criteriaTransfer->getFileAttachmentConditionsOrFail();
228
229			$sspAssetQuery = $fileQuery
230			->useSpySspAssetFileQuery(null, Criteria::LEFT_JOIN)
231			->useSspAssetQuery(null, Criteria::LEFT_JOIN);
232
233			$companyBusinessUnitQuery = $sspAssetQuery
234			->useSpySspAssetToCompanyBusinessUnitQuery(null, Criteria::LEFT_JOIN)
235			->joinSpyCompanyBusinessUnit('ssp_asset_business_unit', Criteria::LEFT_JOIN);
236
237			$companyBusinessUnitQuery
238			->endUse()
239			->endUse()
240			->endUse();
241
242			$criteria = null;
243			if ($fileAttachmentCriteriaTransfer->getAssetReferences()) {
244			$criteria = $sspAssetQuery->getNewCriterion(
245			SpySspAssetTableMap::COL_REFERENCE,
246			$fileAttachmentCriteriaTransfer->getAssetReferences(),
247			Criteria::IN,
248			);
249			}
250
251			if ($fileAttachmentCriteriaTransfer->getSspAssetCompanyIds()) {
252			$assetCompanyIdCriterion = $fileQuery->getNewCriterion(
253			'ssp_asset_business_unit.fk_company',
254			$fileAttachmentCriteriaTransfer->getSspAssetCompanyIds(),
255			Criteria::IN,
256			);
257
258			if ($criteria) {
259			$criteria->addAnd($assetCompanyIdCriterion);
260			} else {
261			$criteria = $assetCompanyIdCriterion;
262			}
263			}
264
265			if ($fileAttachmentCriteriaTransfer->getSspAssetBusinessUnitIds()) {
266			$assetBusinessUnitIdCriterion = $fileQuery->getNewCriterion(
267			'ssp_asset_business_unit.id_company_business_unit',
268			$fileAttachmentCriteriaTransfer->getSspAssetBusinessUnitIds(),
269			Criteria::IN,
270			);
271
272			if ($criteria) {
273			$criteria->addAnd($assetBusinessUnitIdCriterion);
274			} else {
275			$criteria = $assetBusinessUnitIdCriterion;
276			}
277			}
278
279			return $criteria;
280			}
281
282			protected function applyFileAttachmentSearch(
283			SpyFileQuery $query,
284			FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer
285			): SpyFileQuery {
286			if (!$fileAttachmentCriteriaTransfer->getFileAttachmentSearchConditions()) {
287			return $query;
288			}
289
290			$searchString = $fileAttachmentCriteriaTransfer->getFileAttachmentSearchConditions()->getSearchString();
291			if ($searchString) {
292			$query->filterByFileName_Like(sprintf('%%%s%%', $searchString))
293			->_or()
294			->filterByFileReference_Like(sprintf('%%%s%%', $searchString));
295			}
296
297			return $query;
298			}
299
300			protected function applyFileAttachmentTypeFilter(
301			SpyFileQuery $query,
302			FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer
303			): SpyFileQuery {
304			$fileTypes = $fileAttachmentCriteriaTransfer->getFileAttachmentConditionsOrFail()->getFileTypes();
305
306			if (!$fileTypes) {
307			return $query;
308			}
309
310			return $query
311			->useSpyFileInfoQuery()
312			->filterByExtension_In($fileTypes)
313			->endUse();
314			}
315
316			protected function applyFileAttachmentDateRangeFilter(
317			SpyFileQuery $query,
318			FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer
319			): SpyFileQuery {
320			$rangeCreatedAt = $fileAttachmentCriteriaTransfer->getFileAttachmentConditionsOrFail()->getRangeCreatedAt();
321			if (!$rangeCreatedAt) {
322			return $query;
323			}
324
325			if ($rangeCreatedAt->getFrom()) {
326			$query->useSpyFileInfoQuery()
327			->filterByCreatedAt($rangeCreatedAt->getFrom(), Criteria::GREATER_EQUAL)
328			->endUse();
329			}
330
331			if ($rangeCreatedAt->getTo()) {
332			$query->useSpyFileInfoQuery()
333			->filterByCreatedAt($rangeCreatedAt->getTo(), Criteria::LESS_EQUAL)
334			->endUse();
335			}
336
337			return $query;
338			}
339
340			protected function applyFileAttachmentUuidFilter(
341			SpyFileQuery $query,
342			FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer
343			): SpyFileQuery {
344			$uuids = $fileAttachmentCriteriaTransfer->getFileAttachmentConditionsOrFail()->getUuids();
345			if ($uuids !== []) {
346			$query
347			->filterByUuid_In($uuids);
348			}
349
350			return $query;
351			}
352
353			protected function applyFileIdFilter(
354			SpyFileQuery $query,
355			FileAttachmentCriteriaTransfer $fileAttachmentCriteriaTransfer
356			): SpyFileQuery {
357			$fileIds = $fileAttachmentCriteriaTransfer->getFileAttachmentConditionsOrFail()->getIdFiles();
358			if ($fileIds !== []) {
359			$query
360			->filterByIdFile_In($fileIds);
361			}
362
363			return $query;
364			}
365
366			/**
367			* @param \Propel\Runtime\ActiveQuery\ModelCriteria $query
368			* @param \ArrayObject<array-key, \Generated\Shared\Transfer\SortTransfer> $sortTransfers
369			*
370			* @return \Propel\Runtime\ActiveQuery\ModelCriteria
371			*/
372			protected function applyFileAttachmentSorting(ModelCriteria $query, ArrayObject $sortTransfers): ModelCriteria
373			{
374			$fileAttachmentSortFieldMapping = $this->getFileAttachmentSortFieldMapping();
375			foreach ($sortTransfers as $sortTransfer) {
376			$query
377			->groupBy($fileAttachmentSortFieldMapping[$sortTransfer->getFieldOrFail()] ?? $sortTransfer->getFieldOrFail())
378			->orderBy(
379			$fileAttachmentSortFieldMapping[$sortTransfer->getFieldOrFail()] ?? $sortTransfer->getFieldOrFail(),
380			$sortTransfer->getIsAscending() ? Criteria::ASC : Criteria::DESC,
381			);
382			}
383
384			return $query;
385			}
386
387			/**
388			* @return array<string, string>
389			*/
390			protected function getFileAttachmentSortFieldMapping(): array
391			{
392			return [
393			'fileType' => SpyFileInfoTableMap::COL_EXTENSION,
394			'size' => SpyFileInfoTableMap::COL_SIZE,
395			'createdAt' => SpyFileInfoTableMap::COL_CREATED_AT,
396			];
397			}
398
399			protected function addSubCriteria(?AbstractCriterion $subCriteria, ?AbstractCriterion $criteria): ?AbstractCriterion
400			{
401			if (!$subCriteria) {
402			return $criteria;
403			}
404
405			if ($criteria) {
406			$criteria->addOr($subCriteria);
407
408			return $criteria;
409			}
410
411			return $subCriteria;
412			}
413			}
414

spryker / spryker-core

Push — master ( ae631c...a04781 )

FileAttachmentQueryBuilder::addRelationsToAQuery() B

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like