https://prirucky.ksprogram.cz/index.php?action=history&feed=atom&title=P%C5%99%C3%ADplatky_a_pracovn%C3%AD_m%C3%ADsta_zam%C4%9Bstnanc%C5%AF_%28sestava%29 2026-10-17T06:53:16Z Historie editací této stránky MediaWiki 1.37.2 https://prirucky.ksprogram.cz/index.php?title=P%C5%99%C3%ADplatky_a_pracovn%C3%AD_m%C3%ADsta_zam%C4%9Bstnanc%C5%AF_(sestava)&diff=31086&oldid=prev 2017-05-02T07:07:57Z

<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 2. 5. 2017, 09:07</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l24">Řádek 24:</td> <td colspan="2" class="diff-lineno">Řádek 24:</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>  order by A.os_cislo</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>  order by A.os_cislo</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;"><div>&lt;/small&gt;</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>&lt;/small&gt;</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;"></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;">== Aktuální zaměstnanci a aktuální příplatky (filtr) ==</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;">Příklad filtru:</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;"></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;"> (isnull(plati_do)) Or plati_do > 'Date(gf_aktdatum_string())'</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;"> And</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;"> (isnull(datum_ukonc)) Or datum_ukonc > 'Date(gf_aktdatum_string())'</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;"></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;">[[Image: Priplatky-a-pracovni-mista-zamestnancu-filtr2.png|450px]]</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;"></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;">Anebo použít jen první řádek a druhý nahradit zatrhávacím polem v okně filtru.</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;"></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;"><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 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>* [[Generátor sestav II]]</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>* [[Generátor sestav II]]</div></td></tr> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=P%C5%99%C3%ADplatky_a_pracovn%C3%AD_m%C3%ADsta_zam%C4%9Bstnanc%C5%AF_(sestava)&diff=31082&oldid=prev 2017-04-28T11:00:36Z

<p>Založena nová stránka: &#039;&#039;Příplatky a pracovní místa zaměstnanců (sestava)&#039;&#039; - sestava pro <a href="/index.php?title=Gener%C3%A1tor_sestav_II" title="Generátor sestav II">Generátor sestav II</a>. Kombinuje údaje z agendy <a href="/index.php?title=P%C5%99%C3%ADplatky" title="Příplatky">Příplatky</a> a pracovní místa zaměstnanc…</p> <p><b>Nová stránka</b></p><div>''Příplatky a pracovní místa zaměstnanců (sestava)'' - sestava pro [[Generátor sestav II]]. Kombinuje údaje z agendy [[Příplatky]] a pracovní místa zaměstnanců.<br /> <br /> [[Image: Priplatky-a-pracovni-mista-zamestnancu.png|800px]]<br /> <br /> &lt;small&gt;<br /> select A.os_cislo, A.prijmeni, A.jmeno,<br /> B.cislo_pom, B.druh_pom_j, B.prac_str, B.datum_nastupu, B.datum_ukonc,<br /> C.cis_pracmist, C.naz_pracmist,<br /> D.kod,<br /> E.vyznam,<br /> D.plati_od,<br /> D.plati_do,<br /> D.perioda,<br /> D.castka<br /> <br /> from pracovnici A,<br /> prac_pom B left outer join prac_mist C on B.id_pracmist = C.id_pracmist,<br /> priplatky D right outer join prac_pom BB on D.os_cislo = BB.os_cislo and D.cislo_pom = BB.cislo_pom,<br /> ciselnik E where<br /> A.os_cislo = B.os_cislo and<br /> B.os_cislo = BB.os_cislo and<br /> B.cislo_pom = BB.cislo_pom and<br /> E.kod = D.kod<br /> order by A.os_cislo<br /> &lt;/small&gt;<br /> == Odkazy ==<br /> * [[Generátor sestav II]]</div>

Petrm