https://prirucky.ksprogram.cz/index.php?action=history&feed=atom&title=N%C3%A1kladov%C3%A9_st%C5%99edisko_r%C5%AFzn%C3%A9_od_pracovn%C3%ADho_%28sestava%29 2026-10-17T14:38:47Z Historie editací této stránky MediaWiki 1.37.2 https://prirucky.ksprogram.cz/index.php?title=N%C3%A1kladov%C3%A9_st%C5%99edisko_r%C5%AFzn%C3%A9_od_pracovn%C3%ADho_(sestava)&diff=47974&oldid=prev 2025-03-17T11:08:36Z

<p><span dir="auto"><span class="autocomment">SQL definice</span></span></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 17. 3. 2025, 13:08</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l37">Řádek 37:</td> <td colspan="2" class="diff-lineno">Řádek 37:</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>&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 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>select  </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>select pracovnici.os_cislo, prijmeni, jmeno, prac_pom.cislo_pom, kmen_str, prac_pom.prac_str, pichacky.prac_str as str_btto, pichacky.kod, vyznam, dny, hodiny, sazba, castka, pichacky.datum from pracovnici, prac_pom, pichacky, ciselnik</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>pracovnici.os_cislo,  </div></td><td colspan="2" class="diff-side-added"></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>prijmeni,  </div></td><td colspan="2" class="diff-side-added"></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>jmeno,  </div></td><td colspan="2" class="diff-side-added"></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>prac_pom.cislo_pom,  </div></td><td colspan="2" class="diff-side-added"></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>kmen_str,  </div></td><td colspan="2" class="diff-side-added"></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>prac_pom.prac_str,  </div></td><td colspan="2" class="diff-side-added"></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>pichacky.prac_str as str_btto,  </div></td><td colspan="2" class="diff-side-added"></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>pichacky.kod,  </div></td><td colspan="2" class="diff-side-added"></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>vyznam,  </div></td><td colspan="2" class="diff-side-added"></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>dny,  </div></td><td colspan="2" class="diff-side-added"></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>hodiny,  </div></td><td colspan="2" class="diff-side-added"></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>sazba,  </div></td><td colspan="2" class="diff-side-added"></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>castka,  </div></td><td colspan="2" class="diff-side-added"></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>pichacky.datum <del style="font-weight: bold; text-decoration: none;"> </del></div></td><td colspan="2" class="diff-side-added"></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>from pracovnici, prac_pom, pichacky, ciselnik  </div></td><td colspan="2" class="diff-side-added"></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" 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>where  </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>where pracovnici.os_cislo = prac_pom.os_cislo and prac_pom.os_cislo = pichacky.os_cislo and prac_pom.cislo_pom = pichacky.cislo_pom and prac_pom.prac_str &lt;&gt; pichacky.prac_str and ciselnik.kod = pichacky.kod <ins style="font-weight: bold; text-decoration: none;">and </ins></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>pracovnici.os_cislo = prac_pom.os_cislo  </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>year(pichacky.datum) = (select year(datum_prvni) from par_map <ins style="font-weight: bold; text-decoration: none;">where id_podniku = pracovnici.id_podniku</ins>) and month(pichacky.datum) = (select month(datum_prvni) from par_map <ins style="font-weight: bold; text-decoration: none;">where id_podniku = pracovnici.id_podniku</ins>) <ins style="font-weight: bold; text-decoration: none;">and </ins></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>and prac_pom.os_cislo = pichacky.os_cislo  </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>year(%DATUMDO%) = (select year(datum_prvni) from par_map <ins style="font-weight: bold; text-decoration: none;">where id_podniku = pracovnici.id_podniku</ins>) and month(%DATUMDO%) = (select month(datum_prvni) from par_map <ins style="font-weight: bold; text-decoration: none;">where id_podniku = pracovnici.id_podniku</ins>)</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>and prac_pom.cislo_pom = pichacky.cislo_pom  </div></td><td colspan="2" class="diff-side-added"></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>and <del style="font-weight: bold; text-decoration: none;"> </del>prac_pom.prac_str &lt;&gt; pichacky.prac_str</div></td><td colspan="2" class="diff-side-added"></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>and ciselnik.kod = pichacky.kod</div></td><td colspan="2" class="diff-side-added"></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><del style="font-weight: bold; text-decoration: none;">and </del>year(pichacky.datum) = (select year(datum_prvni) from par_map)</div></td><td colspan="2" class="diff-side-added"></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>and month(pichacky.datum) = (select month(datum_prvni) from par_map)</div></td><td colspan="2" class="diff-side-added"></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><del style="font-weight: bold; text-decoration: none;">and </del>year(%DATUMDO%) = (select year(datum_prvni) from par_map)</div></td><td colspan="2" class="diff-side-added"></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>and month(%DATUMDO%) = (select month(datum_prvni) from par_map)</div></td><td colspan="2" class="diff-side-added"></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>union</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>union</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" 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>select  </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>select pracovnici.os_cislo, prijmeni, jmeno, pom_zal.cislo_pom, kmen_str, pom_zal.prac_str, pichacky.prac_str as str_btto, pichacky.kod, vyznam, dny, hodiny, sazba, castka, pichacky.datum from pracovnici, pom_zal, pichacky, ciselnik</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>pracovnici.os_cislo,  </div></td><td colspan="2" class="diff-side-added"></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>prijmeni,  </div></td><td colspan="2" class="diff-side-added"></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>jmeno,  </div></td><td colspan="2" class="diff-side-added"></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>pom_zal.cislo_pom,  </div></td><td colspan="2" class="diff-side-added"></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>kmen_str,  </div></td><td colspan="2" class="diff-side-added"></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>pom_zal.prac_str,  </div></td><td colspan="2" class="diff-side-added"></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>pichacky.prac_str as str_btto,  </div></td><td colspan="2" class="diff-side-added"></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>pichacky.kod,  </div></td><td colspan="2" class="diff-side-added"></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>vyznam,  </div></td><td colspan="2" class="diff-side-added"></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>dny,  </div></td><td colspan="2" class="diff-side-added"></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>hodiny,  </div></td><td colspan="2" class="diff-side-added"></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>sazba,  </div></td><td colspan="2" class="diff-side-added"></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>castka,  </div></td><td colspan="2" class="diff-side-added"></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>pichacky.datum <del style="font-weight: bold; text-decoration: none;"> </del></div></td><td colspan="2" class="diff-side-added"></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>from pracovnici, pom_zal, pichacky, ciselnik  </div></td><td colspan="2" class="diff-side-added"></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" 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>where  </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>where pracovnici.os_cislo = pom_zal.os_cislo and pom_zal.os_cislo = pichacky.os_cislo and pom_zal.cislo_pom = pichacky.cislo_pom and pom_zal.prac_str &lt;&gt; pichacky.prac_str and ciselnik.kod = pichacky.kod and pom_zal.datum = pichacky.datum and pom_zal.datum &gt;= %DATUMOD% and pom_zal.datum &lt;= %DATUMDO% and pichacky.datum &gt;= %DATUMOD% and pichacky.datum &lt;= %DATUMDO%</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>pracovnici.os_cislo = pom_zal.os_cislo  </div></td><td colspan="2" class="diff-side-added"></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>and pom_zal.os_cislo = pichacky.os_cislo  </div></td><td colspan="2" class="diff-side-added"></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>and pom_zal.cislo_pom = pichacky.cislo_pom <del style="font-weight: bold; text-decoration: none;"> </del></div></td><td colspan="2" class="diff-side-added"></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>and <del style="font-weight: bold; text-decoration: none;"> </del>pom_zal.prac_str &lt;&gt; pichacky.prac_str</div></td><td colspan="2" class="diff-side-added"></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>and ciselnik.kod = pichacky.kod</div></td><td colspan="2" class="diff-side-added"></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>and pom_zal.datum = pichacky.datum</div></td><td colspan="2" class="diff-side-added"></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>and pom_zal.datum &gt;= <del style="font-weight: bold; text-decoration: none;"> </del>%DATUMOD% and pom_zal.datum &lt;= %DATUMDO%</div></td><td colspan="2" class="diff-side-added"></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>and pichacky.datum &gt;= %DATUMOD% and pichacky.datum &lt;= %DATUMDO%</div></td><td colspan="2" class="diff-side-added"></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 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-33609:rev-47974 --> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=N%C3%A1kladov%C3%A9_st%C5%99edisko_r%C5%AFzn%C3%A9_od_pracovn%C3%ADho_(sestava)&diff=33609&oldid=prev 2018-06-07T10:49:42Z

<p>Založena nová stránka: &#039;&#039;Nákladové středisko různé od pracovního (sestava)&#039;&#039; je sestava určená pro <a href="/index.php?title=Gener%C3%A1tor_sestav_II" title="Generátor sestav II">Generátor sestav II</a>. [[Image: Nakladove-stredisko-rozdilne-od-pracovniho-za-aktualn…</p> <p><b>Nová stránka</b></p><div>''Nákladové středisko různé od pracovního (sestava)'' je sestava určená pro [[Generátor sestav II]].<br /> [[Image: Nakladove-stredisko-rozdilne-od-pracovniho-za-aktualni-obdobi.png|right|720px]]<br /> <br /> == Účel ==<br /> * '''Pořízení nebo import'''<br /> Někdy může docházet k tomu, že [[nákladové středisko]] se liší od [[pracovní středisko|pracovního střediska]] u zaměstnance. Je to dáno tím, že uživatelům je umožněno při ručním zadávání např. odměny změnit defaultně nabízené (pracovní) středisko na středisko jiné. Také importem z docházky nebo výroby může být tato informace dotažena (zaměstnanec pracoval tolik a tolik hodin na jiném středisku). <br /> <br /> * '''Více pracovních poměrů'''<br /> Další situací, kdy k tomu dochází, je výpočet u zaměstnance, který má souběžných více pracovních poměrů a u každého jiné pracovní středisko. Protože daň je počítána v souhrnu za všechny pracovní poměry, je pak nákladově přiřazena k jednomu (nejčastěji ke kmenovému středisku - středisku v Evidenci zaměstnanců). Obdobně tomu může být u dalších položek.<br /> <br /> * '''Rozdíly'''<br /> Níže uvedená sestava ukáže právě toto; tedy záznamy z agendy [[Zpracování brutto]], u nichž je evidováno jiné středisko, než je pracovní středisko dotyčného zaměstnance.<br /> <br /> == Položkově ==<br /> [[Image: Nakladove-stredisko-rozdilne-od-pracovniho-polozkova-sestava-a-filtr.png|450px]]<br /> <br /> Je možno vytvořit sestavu pomocí položek:<br /> skupina ''Evidence zaměstnanců''<br /> * ''Příjmení''<br /> * ''Jméno''<br /> <br /> skupina ''Pracovní poměr''<br /> * ''Číslo poměru''<br /> * ''Prac.středisko - prac.stř.-P.pom.''<br /> <br /> skupina ''Složky mzdy''<br /> * ''Os.číslo''<br /> * ''Prac.středisko'' - prac.stř.-Btto (&quot;nákladové&quot;)<br /> * ''Kód''<br /> * ''Hodiny''<br /> * ''Datum''<br /> <br /> Sestava vytvoří všechny záznamy. Rozdílové je potřeba získat filtrací (středisko z prac.pom &lt;&gt; středisko ze Zprac.brutta).<br /> Sestava je určena pro vytváření '''za jedno období'''.<br /> <br /> == SQL definice ==<br /> <br /> &lt;small&gt;<br /> select <br /> pracovnici.os_cislo, <br /> prijmeni, <br /> jmeno, <br /> prac_pom.cislo_pom, <br /> kmen_str, <br /> prac_pom.prac_str, <br /> pichacky.prac_str as str_btto, <br /> pichacky.kod, <br /> vyznam, <br /> dny, <br /> hodiny, <br /> sazba, <br /> castka, <br /> pichacky.datum <br /> from pracovnici, prac_pom, pichacky, ciselnik <br /> <br /> where <br /> pracovnici.os_cislo = prac_pom.os_cislo <br /> and prac_pom.os_cislo = pichacky.os_cislo <br /> and prac_pom.cislo_pom = pichacky.cislo_pom <br /> and prac_pom.prac_str &lt;&gt; pichacky.prac_str<br /> and ciselnik.kod = pichacky.kod<br /> and year(pichacky.datum) = (select year(datum_prvni) from par_map)<br /> and month(pichacky.datum) = (select month(datum_prvni) from par_map)<br /> and year(%DATUMDO%) = (select year(datum_prvni) from par_map)<br /> and month(%DATUMDO%) = (select month(datum_prvni) from par_map)<br /> <br /> union<br /> <br /> select <br /> pracovnici.os_cislo, <br /> prijmeni, <br /> jmeno, <br /> pom_zal.cislo_pom, <br /> kmen_str, <br /> pom_zal.prac_str, <br /> pichacky.prac_str as str_btto, <br /> pichacky.kod, <br /> vyznam, <br /> dny, <br /> hodiny, <br /> sazba, <br /> castka, <br /> pichacky.datum <br /> from pracovnici, pom_zal, pichacky, ciselnik <br /> <br /> where <br /> pracovnici.os_cislo = pom_zal.os_cislo <br /> and pom_zal.os_cislo = pichacky.os_cislo <br /> and pom_zal.cislo_pom = pichacky.cislo_pom <br /> and pom_zal.prac_str &lt;&gt; pichacky.prac_str<br /> and ciselnik.kod = pichacky.kod<br /> and pom_zal.datum = pichacky.datum<br /> and pom_zal.datum &gt;= %DATUMOD% and pom_zal.datum &lt;= %DATUMDO%<br /> and pichacky.datum &gt;= %DATUMOD% and pichacky.datum &lt;= %DATUMDO%<br /> &lt;/small&gt;<br /> <br /> Sestavu je možno vytvářet i za více období:<br /> <br /> [[Image: Nakladove-stredisko-rozdilne-od-pracovniho-za-vice-obdobi.png|250px]]<br /> <br /> == Odkazy ==<br /> * [[Nákladové středisko]]<br /> * [[Pracovní středisko]]<br /> * [[Export do účetnictví]]</div>

Petrm