Třídová akce

Kód:

15

Tělo:

SELECT A.DateOfBegin$DATE, A.DateOfEnd$DATE, A.IndividualWeekDuty,
coalesce(
(SELECT C.Duty FROM ShiftCalendar C WHERE C.ID =
(SELECT SValue FROM WageStringValueOfFldWithDef(A.ID, 'RFW3EQ50IEVOF2F5F33OWL1GXC', 227, ib_greatest(A.DateOfBegin$DATE, :DATETO),''))
), 0) as Duty,
  (SELECT Sum(ib_least(AB.AbsentTo$DATE + 1000000 * (SELECT count(*) FROM Absences AB2 WHERE AB2.ID = AB.ID and AB2.AbsentTo$DATE = 0), :DATETO) -
              ib_greatest(AB.AbsentFrom$DATE, :DATEFROM) + 1)
  FROM Absences AB WHERE
  (AB.NoEvidenceState = 'A') and (AB.WorkingRelation_ID = A.ID) and (AB.AbsentFrom$DATE <= :DATETO) and
  ((AB.AbsentTo$DATE >= :DATEFROM) or (AB.AbsentTo$DATE = 0)) )as AbsenceDays,
A.ID as ID  
FROM WorkingRelations A
WHERE (A.DateOfBegin$DATE <= :DATETO) and
((A.DateOfEnd$DATE >= :DATEFROM) or (A.DateOfEnd$DATE = 0)) and
(A.Hidden = 'N') and (A.RecordedStatus = 'A')

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