Třídová akce

Kód:

28

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 
 JOIN WorkingInjuries WI ON WI.ID = A.WorkingInjury_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 (WI.BaseType IN ({WI_BaseType})) 
  AND (
        (:WI_Relevance = -1) OR
        ((:WI_Relevance <> -1) AND (WI.Relevance = :WI_Relevance))
      )  

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