Daňovka - kdo požádal a nepožádal o Prohlášení-RZD
Z Prirucky
(přesměrováno z Daňovka - kdo požádal a nepožádal o prohlášení)
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