Třídová akce

Kód:

9

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 A.DATEFROM$DATE >= :DATEFROM
  AND (A.DATEFROM$DATE <= :DATETO)
  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')))
      )  
  

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