Zobrazení zdroje stránky Penzijní připojištění a bankovní účty (sestava)

''Penzijní připojištění a bankovní účty (sestava)''

== Sestava ==
[[Image: Penzijni pripojisteni-a-Bankovni ucty.png]]


== SQL definice ==
<small>
 select EVP.os_cislo, A.prijmeni, A.jmeno, A.rodne_cislo, EVP.fond, 
 OS.nazev, EVP.c_smlouvy, EVP.varianta, EVP.indik, EVP.castka, EVP.dat_od, EVP.dat_do, EVP.perioda,
 
 (select max(kod) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as kod_zamtel,
 
 (select max(mes_castka) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as mescastka_zamtel,
 
 (select max(cislo_banky) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as banka_zamtel,
 
 (select max(cislo_platby) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as ucet_zamtel,
 
 (select max(var_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as varsym_zamtel,
 
 (select max(konst_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as konst_zamtel,
 
 (select max(spec_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select pp_srazky from param_pp where pp_kod = (select c_pole2 from osoby_typ where id_osoby = EVP.fond))) as spec_zamtel,
 
 null as nothing,
  
 (select max(kod) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as kod_zamec,
 
 (select max(mes_castka) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as mescastka_zamec,
 
 (select max(cislo_banky) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as banka_zamec,
 
 (select max(cislo_platby) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as ucet_zamec,
 
 (select max(var_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as varsym_zamec,
 
 (select max(konst_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as konst_zamec,
 
 (select max(spec_symb) from platby PL where PL.os_cislo = EVP.os_cislo and
 (dat_do is null or dat_do > (select datum_prvni from par_map)) and
 PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as spec_zamec
 
 from ev_p_prisp EVP, pracovnici A, osoby OS where 
 EVP.os_cislo = A.os_cislo and EVP.fond = OS.id_osoby
 </small>

== Odkazy ==