Daňovka - kdo požádal a nepožádal o Prohlášení-RZD

Daňovka - kdo požádal a nepožádal o Prohlášení-RZD

SELECT A.os_cislo, A.prijmeni, A.jmeno, A.dan_sleva, A.sleva_od, A.sleva_do,  B.cislo_pom, B.datum_nastupu, B.datum_ukonc,
HL.typ,
HL.id_poz,
(select max(doba) from workfl_body BO where BO.id_poz = HL.id_poz) as rok,
(select max(datum) from workfl_body BO where BO.id_poz = HL.id_poz) as datum,
(select max(zapsal) from workfl_body BO where BO.id_poz = HL.id_poz) as zapsal,
(select max(obdobi) from workfl_body BO where BO.id_poz = HL.id_poz) as obdobi,
 
(select stav from workfl_proc PRO where id_poz = HL.id_poz
and id = (select max(id) from workfl_proc PRO2 where PRO2.id_poz = PRO.id_poz)
) as stav,

(select datum from workfl_proc PRO where id_poz = HL.id_poz
and id = (select max(id) from workfl_proc PRO2 where PRO2.id_poz = PRO.id_poz)
) as datum,

(select cas from workfl_proc PRO where id_poz = HL.id_poz
and id = (select max(id) from workfl_proc PRO2 where PRO2.id_poz = PRO.id_poz)
) as cas,

(select zapsal from workfl_proc PRO where id_poz = HL.id_poz
and id = (select max(id) from workfl_proc PRO2 where PRO2.id_poz = PRO.id_poz)
) as zapsal

from pracovnici A left outer join workfl_hl HL on A.os_cislo = HL.os_cislo and HL.typ = 'danprohl'
and HL.id_poz in (select id_poz from workfl_body BO where BO.doba = (select max(year(cast(datum_prvni as date))) from par_map)), 
prac_pom B
where A.os_cislo = B.os_cislo 
order by A.os_cislo

• Vybírají se požadavky typu "danprohl" z aktuálního roku.
• Z db tab workfl_body jsou zobrazovány některé sloupce jako je rok (doba), datum, zapsal.
• Z db tab workfl_proc je vybírán záznam pro dané id_poz s nejvyšším id - tedy nejposlednější proběhlý proces; k němu jsou zobrazovány některé údaje (stav, datum, čas, zapsal).

Žádost o RZD

SELECT A.os_cislo, A.prijmeni, A.jmeno, A.dan_sleva, A.sleva_od, A.sleva_do,  B.cislo_pom, B.datum_nastupu, B.datum_ukonc,
HL.typ,
HL.id_poz,
(select max(doba) from workfl_body BO where BO.id_poz = HL.id_poz) as rok,
(select max(datum) from workfl_body BO where BO.id_poz = HL.id_poz) as datum,
(select max(zapsal) from workfl_body BO where BO.id_poz = HL.id_poz) as zapsal,
(select max(obdobi) from workfl_body BO where BO.id_poz = HL.id_poz) as obdobi,
 
(select stav from workfl_proc PRO where id_poz = HL.id_poz
and id = (select max(id) from workfl_proc PRO2 where PRO2.id_poz = PRO.id_poz)
) as stav,

(select datum from workfl_proc PRO where id_poz = HL.id_poz
and id = (select max(id) from workfl_proc PRO2 where PRO2.id_poz = PRO.id_poz)
) as datum,

(select cas from workfl_proc PRO where id_poz = HL.id_poz
and id = (select max(id) from workfl_proc PRO2 where PRO2.id_poz = PRO.id_poz)
) as cas,

(select zapsal from workfl_proc PRO where id_poz = HL.id_poz
and id = (select max(id) from workfl_proc PRO2 where PRO2.id_poz = PRO.id_poz)
) as zapsal

from pracovnici A left outer join workfl_hl HL on A.os_cislo = HL.os_cislo and HL.typ = 'zroczuct' 
and HL.id_poz in (select id_poz from workfl_body BO where BO.doba = (select max(year(cast(datum_prvni as date)))-1 from par_map)),
prac_pom B
where A.os_cislo = B.os_cislo 
order by A.os_cislo

Odkazy

• Generátor sestav II (příklady sestav)
• Daňovka