https://prirucky.ksprogram.cz/index.php?action=history&feed=atom&title=Mzdov%C3%A9_polo%C5%BEky_zam%C4%9Bstnanc%C5%AF_-_%C3%BAhrn_%28sestava%29 2026-10-17T10:13:21Z Historie editací této stránky MediaWiki 1.37.2 https://prirucky.ksprogram.cz/index.php?title=Mzdov%C3%A9_polo%C5%BEky_zam%C4%9Bstnanc%C5%AF_-_%C3%BAhrn_(sestava)&diff=46394&oldid=prev 2024-06-04T14:08:43Z

<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 4. 6. 2024, 16:08</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"></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>Mzdové položky zaměstnanců - úhrn (sestava) je sestava pro [[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>Mzdové položky zaměstnanců - úhrn (sestava) je sestava pro [[Generátor sestav II]]</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;">Dny, hodiny a částky jsou uváděny v úhrnné hodnotě (součtu) za období vybraná uživatelem (od - do).</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;"><div>[[Image: Mzdove polozky zamestnancu-Uhrn.png|790px]]</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>[[Image: Mzdove polozky zamestnancu-Uhrn.png|790px]]</div></td></tr> <!-- diff cache key wikidb_1372:diff::1.12:old-46393:rev-46394 --> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=Mzdov%C3%A9_polo%C5%BEky_zam%C4%9Bstnanc%C5%AF_-_%C3%BAhrn_(sestava)&diff=46393&oldid=prev 2024-06-04T14:07:22Z

<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 4. 6. 2024, 16:07</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"></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>Mzdové položky zaměstnanců - úhrn (sestava) je sestava pro [[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>Mzdové položky zaměstnanců - úhrn (sestava) je sestava pro [[Generátor sestav II]]</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>[[Image: Mzdove polozky zamestnancu-Uhrn.png|<del style="font-weight: bold; text-decoration: none;">750px</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: Mzdove polozky zamestnancu-Uhrn.png|<ins style="font-weight: bold; text-decoration: none;">790px</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;"><div>== Definice ==</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>== Definice ==</div></td></tr> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=Mzdov%C3%A9_polo%C5%BEky_zam%C4%9Bstnanc%C5%AF_-_%C3%BAhrn_(sestava)&diff=46392&oldid=prev 2024-06-04T14:06:56Z

<p>založena nová stránka s textem „Mzdové položky zaměstnanců - úhrn (sestava) je sestava pro <a href="/index.php?title=Gener%C3%A1tor_sestav_II" title="Generátor sestav II">Generátor sestav II</a> <a href="/index.php?title=Soubor:Mzdove_polozky_zamestnancu-Uhrn.png" title="Soubor:Mzdove polozky zamestnancu-Uhrn.png">750px</a> == Definice == &lt;small&gt; select A.os_cislo, A.prijmeni, A.jmeno, B.cislo_pom, B.druh_pom_j, B.prac_str, B.datum_nastupu, B.datum_ukonc, P.kod, C.vyznam, sum (P.dny) as dny, sum (P.hodiny) as hod, sum (P.castka) as castka from pracovnici A, prac_pom B, pichacky P, ciselnik C where A.os_cislo = B.os_cislo a…“</p> <p><b>Nová stránka</b></p><div>Mzdové položky zaměstnanců - úhrn (sestava) je sestava pro [[Generátor sestav II]]<br /> <br /> [[Image: Mzdove polozky zamestnancu-Uhrn.png|750px]]<br /> <br /> == Definice ==<br /> &lt;small&gt;<br /> select A.os_cislo, A.prijmeni, A.jmeno, B.cislo_pom, B.druh_pom_j, B.prac_str, B.datum_nastupu, B.datum_ukonc, <br /> P.kod, C.vyznam, sum (P.dny) as dny, sum (P.hodiny) as hod, sum (P.castka) as castka <br /> from pracovnici A, prac_pom B, pichacky P, ciselnik C where <br /> A.os_cislo = B.os_cislo and B.os_cislo = P.os_cislo and B.cislo_pom = P.cislo_pom and P.datum &gt;= %DATUMOD% and P.datum &lt;= %DATUMDO%<br /> and P.kod = C.kod<br /> group by <br /> A.os_cislo, A.prijmeni, A.jmeno, B.cislo_pom, B.druh_pom_j, B.prac_str, B.datum_nastupu, B.datum_ukonc, <br /> P.kod, C.vyznam<br /> order by A.os_cislo, B.cislo_pom, P.kod<br /> &lt;/small&gt;<br /> <br /> == Odkazy ==<br /> * [[Generátor sestav II (příklady sestav)]]</div>

Petrm