<?php
/************************************************************************
 * This file is part of EspoCRM.
 *
 * EspoCRM – Open Source CRM application.
 * Copyright (C) 2014-2025 Yurii Kuznietsov, Taras Machyshyn, Oleksii Avramenko
 * Website: https://www.espocrm.com
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 *
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 *
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "EspoCRM" word.
 ************************************************************************/

namespace tests\unit\Espo\Core\Select\Applier\Appliers;

use Espo\Core\{
    Select\Select\Applier as SelectApplier,
    Select\SearchParams,
    Select\Select\MetadataProvider,
    Utils\FieldUtil,
};

use Espo\{
    ORM\Query\SelectBuilder as QueryBuilder,
    ORM\Entity,
    Entities\User,
};

class SelectApplierTest extends \PHPUnit\Framework\TestCase
{
    protected function setUp(): void
    {
        $this->user = $this->createMock(User::class);
        $this->metadataProvider = $this->createMock(MetadataProvider::class);
        $this->queryBuilder = $this->createMock(QueryBuilder::class);
        $this->searchParams = $this->createMock(SearchParams::class);
        $this->fieldUtil = $this->createMock(FieldUtil::class);

        $this->entityType = 'Test';

        $this->applier = new SelectApplier(
            $this->entityType,
            $this->user,
            $this->fieldUtil,
            $this->metadataProvider
        );
    }

    public function testApply1()
    {
        $this->initTestApply();
    }

    public function testApplyPortal()
    {
        $this->initTestApply(true);
    }

    protected function initTestApply(bool $isPortal = false)
    {
        $select = ['testSelect', 'testNotExisting', 'testText'];

        $orderBy = 'testOrder';

        $aclAttributeList = ['testAcl'];

        $aclPortalAttributeList = ['testAclPortal'];

        $dependencyMap = [
            'testSelect' => [
                'testDependency',
            ],
        ];

        $aclAttribute = $aclAttributeList[0];

        if ($isPortal) {
            $aclAttribute = $aclPortalAttributeList[0];
        }

        $this->user
            ->expects($this->any())
            ->method('isPortal')
            ->willReturn($isPortal);

        $this->searchParams
            ->expects($this->any())
            ->method('getMaxTextAttributeLength')
            ->willReturn(100);

        $this->searchParams
            ->expects($this->any())
            ->method('getSelect')
            ->willReturn($select);

        $this->searchParams
            ->expects($this->any())
            ->method('getOrderBy')
            ->willReturn($orderBy);

        $this->metadataProvider
            ->expects($this->any())
            ->method('getAclAttributeList')
            ->willReturn($aclAttributeList);

        $this->metadataProvider
            ->expects($this->any())
            ->method('getAclPortalAttributeList')
            ->willReturn($aclPortalAttributeList);

        $this->metadataProvider
            ->expects($this->any())
            ->method('getSelectAttributesDependencyMap')
            ->with($this->entityType)
            ->willReturn($dependencyMap);

        $this->fieldUtil
            ->expects($this->once())
            ->method('getAttributeList')
            ->with($this->entityType, $orderBy)
            ->willReturn([$orderBy]);

        $this->metadataProvider
            ->expects($this->any())
            ->method('hasAttribute')
            ->will(
                $this->returnValueMap(
                    [
                        [$this->entityType, 'id', true],
                        [$this->entityType, 'testSelect', true],
                        [$this->entityType, 'testNotExisting', false],
                        [$this->entityType, 'testOrder', true],
                        [$this->entityType, 'testAcl', true],
                        [$this->entityType, 'testAclPortal', true],
                        [$this->entityType, 'testDependency', true],
                        [$this->entityType, 'testText', true],
                    ]
                )
            );

        $this->metadataProvider
            ->expects($this->any())
            ->method('isAttributeNotStorable')
            ->willReturn(false);

        $this->metadataProvider
            ->expects($this->any())
            ->method('getAttributeType')
            ->will(
                $this->returnValueMap(
                    [
                        [$this->entityType, 'id', Entity::ID],
                        [$this->entityType, 'testSelect', Entity::VARCHAR],
                        [$this->entityType, 'testOrder', Entity::VARCHAR],
                        [$this->entityType, 'testAcl', Entity::VARCHAR],
                        [$this->entityType, 'testAclPortal', Entity::VARCHAR],
                        [$this->entityType, 'testDependency', Entity::VARCHAR],
                        [$this->entityType, 'testText', Entity::TEXT],
                    ]
                )
            );

        $expected = [
            'id',
            $aclAttribute,
            'testSelect',
            ['LEFT:(testText, 100)', 'testText'],
            'testOrder',
            'testDependency',
        ];

        $this->queryBuilder
            ->expects($this->once())
            ->method('select')
            ->with($expected);

        $this->applier->apply($this->queryBuilder, $this->searchParams);
    }
}
