Třídová akce

Popis:

Hledání podle sériového čísla pro modul Servis

Kód:

16

Tělo:

SELECT
  A.ID, A.Name, SC.ID as StoreCardID, SC.Name as StoreCardName, SC.Code as StoreCardCode, F.Name as ProducerName
FROM
  StoreBatches A
  LEFT JOIN StoreCards SC ON SC.ID=A.StoreCard_ID
  LEFT JOIN Firms F ON F.ID=SC.Producer_ID
WHERE
  (Upper(A.Name collate PXW_CSY) LIKE Upper('{SEARCHBATCH}') ESCAPE '~') AND
  (Upper(SC.Name collate PXW_CSY) LIKE Upper('{SEARCHCARD}') ESCAPE '~') AND
  ((SC.Category = 1) or (SC.Category = 2) or ('{SEARCHCARD}'='%%')) AND
  ((Upper(F.Name collate PXW_CSY) LIKE Upper('{SEARCHPRODUCER}') ESCAPE '~') OR 
   (('{SEARCHPRODUCER}'='%%') AND SC.Producer_ID is null) OR
   ((:WithAncestors='A') AND
    (SC.Producer_ID in
     (SELECT F1.ID FROM Firms F1
      WHERE
       (SC.Producer_ID = F1.ID) and
       (F1.Firm_ID in 
        (SELECT F12.ID FROM Firms F12 
         where (Upper(F12.Name collate PXW_CSY) LIKE Upper('{SEARCHPRODUCER}') ESCAPE '~')
        )
       )
     )
    ) 
   )
  )
ORDER BY
  A.Name

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