Třídová akce

Kód:

2

Tělo:

  SELECT MC.* FROM PLMMACHINECOMPETENCES MC
  JOIN PLMMACHINES M ON M.id = MC.PARENT_ID AND M.MachineKind = :MachineKind
  JOIN PLMWORKPLACESMACHINES WM ON WM.MACHINE_ID= M.ID
  JOIN PLMWORKPLACESHIFTTYPES WST ON WST.PARENT_ID = WM.PARENT_ID
  JOIN SHIFTTYPES ST ON ST.id = WST.SHIFTTYPE_ID
  JOIN PLMWORKPLACESHIFTTYPES WST2 ON WST2.PARENT_ID = :Workplace_ID
  JOIN SHIFTTYPES ST2 ON st2.id = WST2.SHIFTTYPE_ID
  WHERE 
   MC.Competence_ID = :Competence_ID
   AND
  (ST.weekdays LIKE 'A______' AND ST2.weekdays LIKE 'A______'
  OR 
  ST.weekdays LIKE '_A_____' AND ST2.weekdays LIKE '_A_____'
  OR 
  ST.weekdays LIKE '__A____' AND ST2.weekdays LIKE '__A____'
  OR 
  ST.weekdays LIKE '___A___' AND ST2.weekdays LIKE '___A___'
  OR 
  ST.weekdays LIKE '____A__' AND ST2.weekdays LIKE  '____A__'
  OR 
  ST.weekdays LIKE '_____A_' AND ST2.weekdays LIKE  '_____A_'
  OR 
  ST.weekdays LIKE '______A' AND ST2.weekdays LIKE '______A'
)
AND (ST.INITIALHOUR BETWEEN ST2.INITIALHOUR AND ST2.INITIALHOUR + ST2.HOURSSHIFT OR ST2.INITIALHOUR BETWEEN ST.INITIALHOUR AND ST.INITIALHOUR + ST.HOURSSHIFT)

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