Třídová akce

Kód:

7

Tělo:

select
  (B.Code || '-' || CAST(sd.OrdNumber AS VARCHAR(10)) || '/' || C.Code || '-' || A.OrdNumber) as DisplayName,
  SC.Name as Description,
  sd.DocDate$Date as Date$Date,
  A.ID as ID,
  sd.Firm_ID as FirmID
from ServiceAssemblyForms a, DocQueues b, Periods c, StoreCards sc, ServiceDocuments sd
where sd.DocQueue_ID=b.id and sd.Period_ID=c.id and 
  sd.BusOrder_ID=:ID and A.ServiceDocument_ID=sd.ID and sd.StoreCard_ID=SC.ID
  and (sd.DocDate$DATE >= :DateFrom) and (sd.DocDate$DATE < :DateTo + 1)
union all
select
  (B.Code || '-' || CAST(sd.OrdNumber AS VARCHAR(10)) || '/' || C.Code || '-' || A.OrdNumber) as DisplayName,
  SO.Name as Description,
  sd.DocDate$Date as Date$Date,
  A.ID as ID,
  sd.Firm_ID as FirmID
from ServiceAssemblyForms a, DocQueues b, Periods c, ServicedObjects so, ServiceDocuments sd 
where sd.DocQueue_ID=b.id and sd.Period_ID=c.id and 
  sd.BusOrder_ID=:ID and A.ServiceDocument_ID=sd.ID and sd.ServicedObject_ID=SO.ID
  and (sd.DocDate$DATE >= :DateFrom) and (sd.DocDate$DATE < :DateTo + 1)
union all
select
  (B.Code || '-' || CAST(sd.OrdNumber AS VARCHAR(10)) || '/' || C.Code || '-' || A.OrdNumber) as DisplayName,
  sd.ServicedObjectText as Description,
  sd.DocDate$Date as Date$Date,
  A.ID as ID,
  sd.Firm_ID as FirmID
from ServiceAssemblyForms a, DocQueues b, Periods c, ServiceDocuments sd
where sd.DocQueue_ID=b.id and sd.Period_ID=c.id and 
  sd.BusOrder_ID=:ID and A.ServiceDocument_ID=sd.ID
  and sd.ServicedObject_ID is null and sd.StoreCard_ID is null
  and (sd.DocDate$DATE >= :DateFrom) and (sd.DocDate$DATE < :DateTo + 1)

Generated by ABRA Software a.s. 27.10.2021 16:35:46