GO
DECLARE @dateOfUpgradeTo_2026_20 datetime2 = (SELECT InstallDate FROM SSCommon.STModulesVersions WHERE Code = 'PZF' and [Version] like '%26.20%')
SELECT distinct 
o.DocNumber AS KodZlecenia,
CASE WHEN o.PriceCalculateType = 0 THEN 'Cena ewidencyjna' 
  WHEN o.PriceCalculateType = 1 THEN 'Cena z pozycji karty'
  WHEN o.PriceCalculateType = 2 THEN 'Ceny zakupu'
  WHEN o.PriceCalculateType = 3 THEN 'Ceny zakupu + koszty'
  ELSE 'BrakInformacji' END AS RodzajKalkulacjiCeny,
CASE WHEN o.OrderStatus = 0 THEN 'Otwarte'
  WHEN o.OrderStatus = 10 THEN 'W trakcie'
  WHEN o.OrderStatus = 20 THEN 'Zakończone'
  WHEN o.OrderStatus = 30 THEN 'Zamknięte'
  WHEN o.OrderStatus = -1 THEN 'Anulowane'
  ELSE 'BrakInformacji' END AS [Status],
o.CloseDate AS DataOstatniegoRozliczeniaZlecenia
FROM MF.ProductionInventory inv
JOIN MF.ProductionOrder o on o.ID = inv.OrderID
WHERE 1=1
AND StockDocKind in (77)
AND o.CloseDate is not null
AND o.CloseDate >=  ISNULL(@dateOfUpgradeTo_2026_20, '9999-12-31')