Objektová akce

Popis:

Vrátí odpracovaný čas a množství dle pracovních lístků a kooperace.

Kód:

2

Tělo:

SELECT 
  COALESCE(SUM(A.TotalTime), 0.0), 
  COALESCE(SUM(A.Quantity), 0.0), 
  COALESCE(SUM(A.TotalTAC), 0.0), 
  COALESCE(SUM(A.TotalTBC), 0.0) 
FROM
(  
  SELECT 
    O.TotalTime AS TotalTime, 
    O.Quantity AS Quantity, 
    O.TotalTAC AS TotalTAC,
    O.TotalTBC AS TotalTBC
  FROM PLMJobOrdersRoutines R
  JOIN PLMOperations O ON O.JobOrdersRoutines_ID = R.ID AND O.Cooperation = 'N'
  WHERE R.ID = :OBJID
  UNION ALL
  SELECT 
    0.0 AS TotalTime,
    COI.ReturnedQuantity AS Quantity, 
    0.0 AS TotalTAC,
    0.0 AS TotalTBC
  FROM PLMJobOrdersRoutines R
  JOIN PLMCoopRoutines COR ON COR.JobOrdersRoutine_ID = R.ID
  JOIN PLMCoopOutputItems COI ON COR.Parent_ID = COI.ID
  WHERE R.ID = :OBJID
) A

Generated by ABRA Software a.s. 27.10.2021 16:34:49