Třídová akce

Kód:

14

Tělo:

SELECT Count(*) 
FROM Docks A 
JOIN DockTypes DT ON A.DockType_ID = DT.ID 
WHERE 
(A.WAGEPERIOD_ID = :WAGEPERIOD) AND
((:EMPLOYEE = '0000000000') OR (A.EMPLOYEE_ID = :EMPLOYEE)) AND
((:BASETYPE < 0) OR (A.BASETYPE = :BASETYPE)) AND
((:Internal = ' ') OR (A.Internal = :Internal)) AND
((:DebtCorrect = ' ') OR (A.DebtCorrect = :DebtCorrect)) AND
((:OfMinimum = ' ') OR (A.OfMinimum = :OfMinimum)) AND
((:Partial = ' ') OR (A.Partial = :Partial)) AND
((:ItIsGeneratedDebt = ' ') OR (A.ItIsGeneratedDebt = :ItIsGeneratedDebt)) AND
((:IsDebt = ' ') OR (A.IsDebt = :IsDebt)) AND
((:PrintGroup = ' ') OR (A.PrintGroup = :PrintGroup)) AND
((:AgreementDock = ' ') OR (A.AgreementDock = :AgreementDock)) AND
((:DOCKCODE = '          ') OR (DT.Code = :DOCKCODE))

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