https://prirucky.ksprogram.cz/index.php?action=history&feed=atom&title=Penzijn%C3%AD_p%C5%99ipoji%C5%A1t%C4%9Bn%C3%AD_a_bankovn%C3%AD_%C3%BA%C4%8Dty_%28sestava%29 2026-10-17T17:47:26Z Historie editací této stránky MediaWiki 1.37.2 https://prirucky.ksprogram.cz/index.php?title=Penzijn%C3%AD_p%C5%99ipoji%C5%A1t%C4%9Bn%C3%AD_a_bankovn%C3%AD_%C3%BA%C4%8Dty_(sestava)&diff=44646&oldid=prev 2023-03-14T13:39:33Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 14. 3. 2023, 15:39</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l2">Řádek 2:</td> <td colspan="2" class="diff-lineno">Řádek 2:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Sestava ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Sestava ==</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image: Penzijni pripojisteni-a-Bankovni ucty.png|<del style="font-weight: bold; text-decoration: none;">590px</del>]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image: Penzijni pripojisteni-a-Bankovni ucty.png|<ins style="font-weight: bold; text-decoration: none;">890px</ins>]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <!-- diff cache key wikidb_1372:diff::1.12:old-44645:rev-44646 --> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=Penzijn%C3%AD_p%C5%99ipoji%C5%A1t%C4%9Bn%C3%AD_a_bankovn%C3%AD_%C3%BA%C4%8Dty_(sestava)&diff=44645&oldid=prev 2023-03-14T13:39:15Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 14. 3. 2023, 15:39</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>''Penzijní připojištění a bankovní účty (sestava)''</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>''<ins style="font-weight: bold; text-decoration: none;">[[</ins>Penzijní připojištění<ins style="font-weight: bold; text-decoration: none;">]] </ins>a bankovní účty (sestava)''</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Sestava ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Sestava ==</div></td></tr> <!-- diff cache key wikidb_1372:diff::1.12:old-44644:rev-44645 --> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=Penzijn%C3%AD_p%C5%99ipoji%C5%A1t%C4%9Bn%C3%AD_a_bankovn%C3%AD_%C3%BA%C4%8Dty_(sestava)&diff=44644&oldid=prev 2023-03-14T13:39:02Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 14. 3. 2023, 15:39</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l2">Řádek 2:</td> <td colspan="2" class="diff-lineno">Řádek 2:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Sestava ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Sestava ==</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image: Penzijni pripojisteni-a-Bankovni ucty.png]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image: Penzijni pripojisteni-a-Bankovni ucty.png<ins style="font-weight: bold; text-decoration: none;">|590px</ins>]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l73">Řádek 73:</td> <td colspan="2" class="diff-lineno">Řádek 73:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Odkazy ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Odkazy ==</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* [[Generátor sestav II (příklady sestav)]]</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* &lt;small>hd 65990&lt;/small></ins></div></td></tr> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=Penzijn%C3%AD_p%C5%99ipoji%C5%A1t%C4%9Bn%C3%AD_a_bankovn%C3%AD_%C3%BA%C4%8Dty_(sestava)&diff=44643&oldid=prev 2023-03-14T12:21:00Z

<p>založena nová stránka s textem „&#039;&#039;Penzijní připojištění a bankovní účty (sestava)&#039;&#039; == Sestava == <a href="/index.php?title=Soubor:Penzijni_pripojisteni-a-Bankovni_ucty.png" title="Soubor:Penzijni pripojisteni-a-Bankovni ucty.png">Image: Penzijni pripojisteni-a-Bankovni ucty.png</a> == SQL definice == &lt;small&gt; 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 &gt; (select datum_prvni from par…“</p> <p><b>Nová stránka</b></p><div>''Penzijní připojištění a bankovní účty (sestava)''<br /> <br /> == Sestava ==<br /> [[Image: Penzijni pripojisteni-a-Bankovni ucty.png]]<br /> <br /> <br /> == SQL definice ==<br /> &lt;small&gt;<br /> select EVP.os_cislo, A.prijmeni, A.jmeno, A.rodne_cislo, EVP.fond, <br /> OS.nazev, EVP.c_smlouvy, EVP.varianta, EVP.indik, EVP.castka, EVP.dat_od, EVP.dat_do, EVP.perioda,<br /> <br /> (select max(kod) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> 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,<br /> <br /> (select max(mes_castka) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> 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,<br /> <br /> (select max(cislo_banky) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> 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,<br /> <br /> (select max(cislo_platby) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> 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,<br /> <br /> (select max(var_symb) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> 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,<br /> <br /> (select max(konst_symb) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> 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,<br /> <br /> (select max(spec_symb) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> 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,<br /> <br /> null as nothing,<br /> <br /> (select max(kod) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as kod_zamec,<br /> <br /> (select max(mes_castka) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as mescastka_zamec,<br /> <br /> (select max(cislo_banky) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as banka_zamec,<br /> <br /> (select max(cislo_platby) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as ucet_zamec,<br /> <br /> (select max(var_symb) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as varsym_zamec,<br /> <br /> (select max(konst_symb) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as konst_zamec,<br /> <br /> (select max(spec_symb) from platby PL where PL.os_cislo = EVP.os_cislo and<br /> (dat_do is null or dat_do &gt; (select datum_prvni from par_map)) and<br /> PL.kod in (select c_pole3 from osoby_typ where id_osoby = EVP.fond)) as spec_zamec<br /> <br /> from ev_p_prisp EVP, pracovnici A, osoby OS where <br /> EVP.os_cislo = A.os_cislo and EVP.fond = OS.id_osoby<br /> &lt;/small&gt;<br /> <br /> == Odkazy ==</div>

Petrm