storestockquantity.php

См. документацию.

<?php
 
namespace Bitrix\Catalog\Integration\Report\StoreStock;
 
use Bitrix\Catalog\StoreDocumentElementTable;
use Bitrix\Catalog\StoreDocumentTable;
use Bitrix\Main\ORM\Fields\ExpressionField;
use Bitrix\Main\ORM\Query\Query;
use Bitrix\Main\ORM\Query\Result;
use Bitrix\Main\Type\DateTime;

final class StoreStockQuantity
{
    protected const DEFAULT_DATE_INTERVAL = '-30D';

    public static function getOutgoingQuantityForStores(array $userFilter = []): array
    {
        $receivedQuantity = self::getIncomingOutgoingQuantitiesFromDocuments($userFilter);
 
        $reduceCallback = static function($result, $current)
        {
            $measureId = (int)$current['MEASURE_ID'] ?: \CCatalogMeasure::getDefaultMeasure(true)['ID'];
            if (!array_key_exists($measureId, $result))
            {
                $result[$measureId] = 0.0;
            }
 
            $result[$measureId] += $current['AMOUNT']['OUTGOING'];
            return $result;
        };
 
        foreach ($receivedQuantity as $storeId => $productEntry)
        {
            $receivedQuantity[$storeId] = array_reduce($productEntry, $reduceCallback, []);
        }
 
        return $receivedQuantity;
    }
 

    public static function getOutgoingQuantityForProducts(array $userFilter = []): array
    {
        $result = [];
        $userFilter['ONLY_EXTERNAL_INCOMING'] = true;
        foreach (self::getIncomingOutgoingQuantitiesFromDocuments($userFilter) as $entries)
        {
            foreach ($entries as $productId => $fields)
            {
                $result[$productId] ??= 0;
                $result[$productId] += (float)($fields['AMOUNT']['OUTGOING'] ?? 0);
            }
        }
 
        return $result;
    }

    public static function getOutgoingQuantityForProductsOnStore(int $storeId, array $userFilter = []): array
    {
        $userFilter['STORES'] = $storeId;
 
        $outgoingQuantity = self::getIncomingOutgoingQuantitiesFromDocuments($userFilter)[$storeId] ?? [];
 
        return array_map(fn(array $entry) => $entry['AMOUNT']['OUTGOING'], $outgoingQuantity);
    }

    public static function getReceivedQuantityForStores(array $userFilter = []): array
    {
        $receivedQuantity = self::getIncomingOutgoingQuantitiesFromDocuments($userFilter);
 
        $reduceCallback = static function($result, $current)
        {
            $measureId = (int)$current['MEASURE_ID'] ?: \CCatalogMeasure::getDefaultMeasure(true)['ID'];
            if (!array_key_exists($measureId, $result))
            {
                $result[$measureId] = 0.0;
            }
 
            $result[$measureId] += $current['AMOUNT']['INCOMING'];
            return $result;
        };
 
        foreach ($receivedQuantity as $storeId => $productEntry)
        {
            $receivedQuantity[$storeId] = array_reduce($productEntry, $reduceCallback, []);
        }
 
        return $receivedQuantity;
    }

    public static function getReceivedQuantityForProducts(array $userFilter = []): array
    {
        $result = [];
 
        $userFilter['ONLY_EXTERNAL_INCOMING'] = true;
        foreach (self::getIncomingOutgoingQuantitiesFromDocuments($userFilter) as $entries)
        {
            foreach ($entries as $productId => $fields)
            {
                $result[$productId] ??= 0;
                $result[$productId] += (float)($fields['AMOUNT']['INCOMING'] ?? 0);
            }
        }
 
        return $result;
    }

    public static function getReceivedQuantityForProductsOnStore(int $storeId, array $userFilter = []): array
    {
        $userFilter['STORES'] = $storeId;
 
        $receivedQuantity = self::getIncomingOutgoingQuantitiesFromDocuments($userFilter)[$storeId] ?? [];
 
        return array_map(fn(array $entry) => $entry['AMOUNT']['INCOMING'], $receivedQuantity);
    }

    private static function getIncomingOutgoingQuantitiesFromDocuments(array $userFilter = []): array
    {
        $userFilter = self::prepareFilter($userFilter);
 
        $productsDataList = self::getDocumentProductsDataList($userFilter);
 
        $result = [];
 
        while ($entry = $productsDataList->fetch())
        {
            $storeFromId = (int)$entry['STORE_FROM'];
            $storeToId = (int)$entry['STORE_TO'];
 
            if (!isset($result[$storeFromId]))
            {
                $result[$storeFromId] = [];
            }
            if (!isset($result[$storeToId]))
            {
                $result[$storeToId] = [];
            }
 
            $productId = $entry['ELEMENT_ID'];
            if (!array_key_exists($productId, $result[$storeToId]))
            {
                $result[$storeToId][$productId] = [
                    'MEASURE_ID' => (int)$entry['MEASURE_ID'] ?: \CCatalogMeasure::getDefaultMeasure(true)['ID'],
                    'AMOUNT' => [
                        'INCOMING' => 0.0,
                        'OUTGOING' => 0.0,
                    ],
                ];
            }
 
            if ($storeFromId > 0)
            {
                $result[$storeFromId][$productId]['AMOUNT']['OUTGOING'] += (float)$entry['AMOUNT_SUM'];
            }
 
            if ($storeToId > 0)
            {
                $result[$storeToId][$productId]['AMOUNT']['INCOMING'] += (float)$entry['AMOUNT_SUM'];
            }
        }
 
        return $result;
    }

    private static function getDocumentProductsDataList(array $userFilter = []): Result
    {
        $receivedQuantityQuery = new Query(StoreDocumentElementTable::getEntity());
        $receivedQuantityQuery->setSelect([
            'DOCUMENT.DOC_TYPE',
            'STORE_FROM',
            'STORE_TO',
            'ELEMENT_ID',
            'AMOUNT_SUM',
            'MEASURE_ID' => 'PRODUCT.MEASURE'
        ]);
 
        $filter = [
            '=DOCUMENT.STATUS' => 'Y',
        ];
 
        if (isset($userFilter['PRODUCTS']))
        {
            $filter['=ELEMENT_ID'] = $userFilter['PRODUCTS'];
        }
 
        if (isset($userFilter['STORES']))
        {
            $filter[] = [
                'LOGIC' => 'OR',
                '=STORE_TO' => $userFilter['STORES'],
                '=STORE_FROM' => $userFilter['STORES'],
            ];
        }
        elseif (isset($userFilter['ONLY_EXTERNAL_INCOMING']))
        {
            $filter['!DOCUMENT.DOC_TYPE'] = StoreDocumentTable::TYPE_MOVING;
        }
 
        if (isset($userFilter['REPORT_INTERVAL']))
        {
            $filter['>=DOCUMENT.DATE_STATUS'] = new DateTime($userFilter['REPORT_INTERVAL']['FROM']);
            $filter['<=DOCUMENT.DATE_STATUS'] = new DateTime($userFilter['REPORT_INTERVAL']['TO']);
        }
 
        $receivedQuantityQuery->setFilter($filter);
        $receivedQuantityQuery->setGroup(['STORE_FROM', 'STORE_TO', 'ELEMENT_ID']);
        $receivedQuantityQuery->registerRuntimeField(
            new ExpressionField('AMOUNT_SUM', 'SUM(de.AMOUNT)')
        );
        $receivedQuantityQuery->setCustomBaseTableAlias('de');
 
        return $receivedQuantityQuery->exec();
    }

    private static function getDefaultReportInterval(): array
    {
        $currentDate = new DateTime();
        $intervalStartDate = new DateTime();
        $intervalStartDate->add(self::DEFAULT_DATE_INTERVAL);
 
        return [
            'FROM' => $intervalStartDate->toString(),
            'TO' => $currentDate->toString(),
        ];
    }

    private static function prepareFilter(array $filter): array
    {
        if (!isset($filter['REPORT_INTERVAL']['FROM'], $filter['REPORT_INTERVAL']['TO']))
        {
            $filter['REPORT_INTERVAL'] = self::getDefaultReportInterval();
        }
 
        return $filter;
    }
}