Třídová akce

Kód:

3

Tělo:

SELECT FIRST 1 
  ASP.ID
FROM 
  ActionPriceLists APL
  JOIN ActionStorePrices ASP ON ASP.PriceList_ID = APL.ID
  LEFT JOIN ActionPriceListRestrictionUses R ON R.Parent_ID = APL.ID 
WHERE 
  :OnTheDate >= DateFrom$DATE and ROUND(:OnTheDate - 0.5,0) <= DateTo$DATE
  AND APL.Hidden = 'N'
  AND ASP.StoreCard_ID = :StoreCard_ID 
  AND (APL.ByTime = 'N' or :OnTheTime >= TimeFrom and :OnTheTime <= TimeTo)
  AND (APL.ByDateOfWeek = 'N' or {DayOfWeek} = 'A')
  AND 
  (
    R.ID IS NULL OR
    R.Firm_ID IN (SELECT ID FROM Firms WHERE ID=:Firm_ID OR Firm_ID=:Firm_ID) OR
    R.Store_ID = :Store_ID
  )
order by APL.Priority

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