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

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

[[Image: Kdo pozadal a nepozadal o prohlaseni.png|750px]]

<small>

 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

</small>

* 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 ==
<small>
 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
</small>

== Odkazy ==
* [[Generátor sestav II (příklady sestav)]]
* [[Daňovka]]