Třídová akce

Kód:

14

Tělo:

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

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