Zestawienie SQD {AA3CC96F-B02F-42FF-A832-1430DD56F83C} True True True True False sqtQuery " SELECT","P.symbol_fmt,"," P.Nazwa AS NazwaKonta, "," Z.opis,","SUM(IF(Z.stronaWn = 1 AND Z.opis LIKE '%$%',Z.kwota,0)) AS WN_Z, ","SUM(IF(Z.stronaWn = 0 AND Z.opis LIKE '%$%',Z.kwota,0)) AS MA_Z,","SUM(IF(Z.stronaWn = 1 AND Z.opis NOT LIKE '%$%',Z.kwota,0)) AS WN_BeZ, ","SUM(IF(Z.stronaWn = 0 AND Z.opis NOT LIKE '%$%',Z.kwota,0)) AS MA_BeZ",,FROM," zapisy Z ","LEFT JOIN plankont P ON P.symbol=Z.konto AND P.Rok = Z.Rok ","LEFT JOIN rodzaje_dowodow RD ON RD.symbol=Z.RodzajDowodu ","LEFT JOIN opng O ON O.GUID=Z.IdnOper ","LEFT JOIN waluty W ON W.idn=O.waluta ",WHERE," Z.Rok = :ROK "," and "," ( (P.symbol_fmt IN ('239-03-17', '239-03-18', '237-01-911', '237-01-913') AND IF(P.symbol_fmt LIKE '237%', Z.opis LIKE '%$%', TRUE) ) OR (P.symbol_fmt LIKE '239-03-27%') )"," "," "," GROUP BY Z.opis " ftString symbol_fmt 0 symbol_fmt 15 50 TH False (brak) #TH;#pd;d;H.#;MM;"(brak)" #TH;d;H.#;MM;"(brak)" False 0" sec ";-0" sec ";"" 0 True False True 00" min ";-00" min ";"" MM True False True 0.#" godz ";-0.#" godz ";"" H.# True True True 0"d ";-0"d ";"" d False False False 0" ty ";-0" ty ";"" 0 True False ftString NazwaKonta 1 NazwaKonta 20 200 TH False (brak) #TH;#pd;d;H.#;MM;"(brak)" #TH;d;H.#;MM;"(brak)" False 0" sec ";-0" sec ";"" 0 True False True 00" min ";-00" min ";"" MM True False True 0.#" godz ";-0.#" godz ";"" H.# True True True 0"d ";-0"d ";"" d False False False 0" ty ";-0" ty ";"" 0 True False ftFloat WN_Z 2 taRightJustify WN_Z (FV Kasa Krajowa) ###,##0.00;-###,##0.00;"" 10 True SUM(WN_Z) TH False (brak) #TH;#pd;d;H.#;MM;"(brak)" #TH;d;H.#;MM;"(brak)" False 0" sec ";-0" sec ";"" 0 True False True 00" min ";-00" min ";"" MM True False True 0.#" godz ";-0.#" godz ";"" H.# True True True 0"d ";-0"d ";"" d False False False 0" ty ";-0" ty ";"" 0 True False ftFloat MA_Z 3 taRightJustify MA_Z ###,##0.00;-###,##0.00;"" 10 True SUM(MA_Z) TH False (brak) #TH;#pd;d;H.#;MM;"(brak)" #TH;d;H.#;MM;"(brak)" False 0" sec ";-0" sec ";"" 0 True False True 00" min ";-00" min ";"" MM True False True 0.#" godz ";-0.#" godz ";"" H.# True True True 0"d ";-0"d ";"" d False False False 0" ty ";-0" ty ";"" 0 True False ftFloat WN_BeZ 4 taRightJustify WN_BeZ ###,##0.00;-###,##0.00;"" 10 True SUM(WN_BeZ) TH False (brak) #TH;#pd;d;H.#;MM;"(brak)" #TH;d;H.#;MM;"(brak)" False 0" sec ";-0" sec ";"" 0 True False True 00" min ";-00" min ";"" MM True False True 0.#" godz ";-0.#" godz ";"" H.# True True True 0"d ";-0"d ";"" d False False False 0" ty ";-0" ty ";"" 0 True False ftFloat MA_BeZ 5 taRightJustify MA_BeZ ###,##0.00;-###,##0.00;"" 10 True SUM(MA_BeZ) TH False (brak) #TH;#pd;d;H.#;MM;"(brak)" #TH;d;H.#;MM;"(brak)" False 0" sec ";-0" sec ";"" 0 True False True 00" min ";-00" min ";"" MM True False True 0.#" godz ";-0.#" godz ";"" H.# True True True 0"d ";-0"d ";"" d False False False 0" ty ";-0" ty ";"" 0 True False ftString opis 6 opis 30 250 TH False (brak) #TH;#pd;d;H.#;MM;"(brak)" #TH;d;H.#;MM;"(brak)" False 0" sec ";-0" sec ";"" 0 True False True 00" min ";-00" min ";"" MM True False True 0.#" godz ";-0.#" godz ";"" H.# True True True 0"d ";-0"d ";"" d False False False 0" ty ";-0" ty ";"" 0 True False ftInteger ROK ptInput ftInteger ptInput 2017 svetValue 2017 2017 ftInteger ptInput 2017 svetValue 2017 2017 (NULL) (NULL) ROK <domyœlny> 200 6.0 True Field1 42948D 42978D ffEqu,ffBetween,ffIN,ffLike,ffLikeBegin Z.data_dowodu Data dowodu SELECT symbol_fmt,nazwa FROM plankont WHERE rok= "#ROK#" "SELECT symbol_fmt,nazwa FROM plankont WHERE rok= ""#ROK#""" ffBetween ftDate Field2 ffEqu P.symbol_fmt Konto symbol_fmt symbol_fmt SELECT symbol_fmt,nazwa FROM plankont WHERE symbol_fmt like '237-01%' or symbol_fmt like '237-02%' "SELECT symbol_fmt,nazwa FROM plankont WHERE symbol_fmt like '237-01%' or symbol_fmt like '237-02%'" Field3 Wyp ffLike,ffLikeBegin Z.opis Opis ffLike False 0