<?php
/***********************************************************************************
 * The contents of this file are subject to the Extension License Agreement
 * ("Agreement") which can be viewed at
 * https://www.espocrm.com/extension-license-agreement/.
 * By copying, installing downloading, or using this file, You have unconditionally
 * agreed to the terms and conditions of the Agreement, and You may not use this
 * file except in compliance with the Agreement. Under the terms of the Agreement,
 * You shall not license, sublicense, sell, resell, rent, lease, lend, distribute,
 * redistribute, market, publish, commercialize, or otherwise transfer rights or
 * usage to the software or any modified version or derivative work of the software
 * created by or for you.
 *
 * Copyright (C) 2015-2025 Letrium Ltd.
 *
 * License ID: a67be8f75bc1974a987315ddc1024a78
 ************************************************************************************/

namespace Espo\Modules\Sales\Classes\FieldLoaders\Product;

use Espo\Core\FieldProcessing\Loader;
use Espo\Core\FieldProcessing\Loader\Params;
use Espo\Core\Utils\Metadata;
use Espo\Modules\Sales\Entities\Product;
use Espo\Modules\Sales\Entities\TransferOrderItem;
use Espo\Modules\Sales\Tools\Sales\ConfigDataProvider;
use Espo\ORM\Entity;
use Espo\ORM\EntityManager;
use Espo\ORM\Query\Part\Expression as Expr;
use Espo\ORM\Query\SelectBuilder;

/**
 * @implements Loader<Product>
 * @noinspection PhpUnused
 */
class QuantityInTransit implements Loader
{
    public function __construct(
        private Metadata $metadata,
        private ConfigDataProvider $configDataProvider,
        private EntityManager $entityManager
    ) {}

    public function process(Entity $entity, Params $params): void
    {
        if (
            !$this->configDataProvider->isWarehousesEnabled() ||
            !$this->configDataProvider->isInventoryTransactionsEnabled()
        ) {
            return;
        }

        if ($params->hasSelect() && !$params->hasInSelect('quantityInTransit')) {
            return;
        }

        $queryBuilder = SelectBuilder::create()
            ->from(TransferOrderItem::ENTITY_TYPE)
            ->select(
                Expr::coalesce(
                    Expr::sum(Expr::column('quantity')),
                    Expr::value(0.0)
                ),
                'sum'
            )
            ->join('transferOrder', 'transferOrder')
            ->where([
                'transferOrder.status!=' => $this->getIgnoreStatusList(),
            ]);

        if ($entity->getType() === Product::TYPE_TEMPLATE) {
            $queryBuilder
                ->join('product')
                ->where(['product.templateId' => $entity->getId()]);
        }
        else {
            $queryBuilder->where(['productId' => $entity->getId()]);
        }

        $query = $queryBuilder->build();

        $sth = $this->entityManager->getQueryExecutor()->execute($query);

        if (!$row = $sth->fetch()) {
            return;
        }

        $quantity = (float) $row['sum'];

        $entity->set('quantityInTransit', $quantity);
    }

    /**
     * @return string[]
     */
    private function getIgnoreStatusList(): array
    {
        return array_merge(
            $this->metadata->get('scopes.TransferOrder.reserveStatusList') ?? [],
            $this->metadata->get('scopes.TransferOrder.softReserveStatusList') ?? [],
            $this->metadata->get('scopes.TransferOrder.doneStatusList') ?? [],
            $this->metadata->get('scopes.TransferOrder.canceledStatusList') ?? [],
            $this->metadata->get('scopes.TransferOrder.failedStatusList') ?? [],
        );
    }
}
