Třídová akce

Kód:

8

Tělo:

SELECT {FIELDS}
 FROM SickBenefits A
 JOIN WorkingRelations WR on WR.ID = A.WorkingRelation_ID
 JOIN Employees EMP ON EMP.ID = WR.Employee_ID 
 WHERE 
   (  
     (
       (:HeaderFrom = 0) AND (:HeaderTo = 0) AND (A.DATEFROM$DATE <= :DATETO)
     ) OR
     (
       (:HeaderFrom <> 0) AND (:HeaderTo <> 0) AND (A.DATEFROM$DATE <= :HeaderTo) AND (A.DATEFROM$DATE >= :HeaderFrom) 
     )
   )    
  AND (A.DATETO$DATE = 0 OR A.DATETO$DATE >= :DATEFROM)
  AND (
        ((:ALLWR = 'N') AND (A.WORKINGRELATION_ID = :WORKINGRELATION OR '0000000000'=:WORKINGRELATION)) OR
        (:ALLWR = 'A')
      )  
  AND  A.BASESICKTYPE IN ({SICKTYPE})
  AND {EXCLDAYS}
  AND (
        (:WithWI = -1) OR    
        ((:WithWI = 0) AND (A.WorkingInjury_ID is null or (A.WorkingInjury_ID = '0000000000'))) OR
        ((:WithWI = 1) AND (A.WorkingInjury_ID is not null or (A.WorkingInjury_ID <> '0000000000')))
      )  
  AND {JUSTPAIDSB}   

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