select
rozdil.stravnik_id,
datum,
rozdil.chod_id,
kusu,
kusuc1,
kusuc2,
kusu_poh,
kusuc1_poh,
kusuc2_poh

 

from

 

#rozdil 
(
select
obj.stravnik_id,
obj.datum,
obj.chod_id,
ifn(poh.kusu_poh) as kusu_poh,
ifn(poh.kusuc1_poh) as kusuc1_poh,
ifn(poh.kusuc2_poh) as kusuc2_poh,
(obj.kusu + ifn(poh.kusu_poh)) as kusu,
(obj.kusuc1 + ifn(poh.kusuc1_poh)) as kusuc1,
(obj.kusuc2 + ifn(poh.kusuc2_poh)) as kusuc2

 

from

 

#obj
(
select
stravnik_id,
datum,
sum(kusu) as kusu,
sum(kusuc1) as kusuc1,
sum(kusuc2) as kusuc2,
chod_id

 

from

 

tobjednavky as tobj

 

where datum between '2020-06-01' and '2020-06-30'
and kusu <> 0
and platne >= 0

 

group by stravnik_id, datum, chod_id

 

) as obj

 

left join

 

#poh
(
select
stravnik_id,
tuc.datum,
sum(mnozstvi) as kusu_poh,
if(c12 = 1, sum(mnozstvi), 0) as kusuc1_poh,
if(c12 = 2, sum(mnozstvi), 0) as kusuc2_poh,
chod_id

 

from poh

 

join tuctenky as tuc
on poh.id_uctenka = tuc.uctenka_id

 

join sklad as sk
on poh.id_zbozi = sk.id

 

where true
and poh.datum between '2020-06-01' and '2020-06-30'
and not sk.chod_id is null

 

group by stravnik_id, datum, chod_id
) as poh

 

on 
poh.stravnik_id = obj.stravnik_id
and poh.chod_id = obj.chod_id
and poh.datum = obj.datum
and obj.chod_id = obj.chod_id

 

) as rozdil

 

join tstravnici as ts
on rozdil.stravnik_id = ts.stravnik_id

 

join tstravnicistat as tss
on rozdil.stravnik_id = tss.stravnik_id

 

join tcenik as tcen
on rozdil.chod_id = tcen.chod_id
and ts.kategorie_id = tcen.kategorie_id

 

where kusu <> 0
and (platnostcenyod <= '2020-06-30' and (platnostcenydo >= '2020-06-01' or platnostcenydo is null))
and (platnostod <= '2020-06-30' and (platnostdo >= '2020-06-01' or platnostcenydo is null))
and (((rozdil.datum <= ts.platnostdo) or (ts.platnostdo is null) or (ts.platnostdo = '0000-00-00')) and (rozdil.datum >= ts.platnostod))
#and kusu_poh <> 0




select sum(kusu), sum(tc.Cena1VcetneDPH*kusuc1), sum(tc.Cena2VcetneDPH*kusuc2)  from tobjednavky as tob
left join tstravnici as ts on ts.Stravnik_Id = tob.Stravnik_Id
left join tcenik as tc on tc.Kategorie_Id = ts.Kategorie_Id and tob.Chod_Id=tc.Chod_Id
where zdrojobj_id=6 and  datum  between "2020-07-01" and "2020-07-31" and tob.stravnik_id not in (3520,3611)
and (platnostod <= tob.Datum  and (platnostdo >= tob.Datum or platnostdo is null))
and (platnostcenyod <= tob.Datum  and (platnostcenydo >= tob.Datum or platnostcenydo is null))
and tob.platne>=0