https://prirucky.ksprogram.cz/index.php?action=history&feed=atom&title=Minul%C3%A9%2C_aktu%C3%A1ln%C3%AD_a_budouc%C3%AD_tarify_%28sestava%29 2026-10-17T13:08:41Z Historie editací této stránky MediaWiki 1.37.2 https://prirucky.ksprogram.cz/index.php?title=Minul%C3%A9,_aktu%C3%A1ln%C3%AD_a_budouc%C3%AD_tarify_(sestava)&diff=48740&oldid=prev 2025-09-08T12:50:47Z

<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 8. 9. 2025, 14:50</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l4">Řádek 4:</td> <td colspan="2" class="diff-lineno">Řádek 4:</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> <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;">* Úprava - výraz ''TM.id = 3'' je potřeba upravit - změnit číslo dle konkrétní databáze (&lt;small>select id from timer_sez where tabulka = 'prac_pom' and polozka = 'tarif';&lt;/small>)</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>&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;"><div>  SELECT A.os_cislo, A.prijmeni, A.jmeno, B.cislo_pom, B.pov_funkce, PM.naz_pracmist, B.datum_nastupu, B.datum_ukonc, B.tarif as tarif_akt,  B.min_zakl as tarif_minul,  </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>  SELECT A.os_cislo, A.prijmeni, A.jmeno, B.cislo_pom, B.pov_funkce, PM.naz_pracmist, B.datum_nastupu, B.datum_ukonc, B.tarif as tarif_akt,  B.min_zakl as tarif_minul,  </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 max(hodnota) from timer_data TM where TM.os_cislo = B.os_cislo and TM.cislo_pom = B.cislo_pom and TM.id = 3 and TM.plati_od &gt;=  %DATUMOD%) as tarif_bud_max, B.trida as trida_akt</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 max(hodnota) from timer_data TM where TM.os_cislo = B.os_cislo and TM.cislo_pom = B.cislo_pom and TM.id = 3 and TM.plati_od &gt;=  %DATUMOD%) as tarif_bud_max,  </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>B.trida as trida_akt</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>  from pracovnici A, prac_pom B left outer join prac_mist PM on B.id_pracmist = PM.id_pracmist where A.os_cislo = B.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>  from pracovnici A, prac_pom B left outer join prac_mist PM on B.id_pracmist = PM.id_pracmist where A.os_cislo = B.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-lineno" id="mw-diff-left-l12">Řádek 12:</td> <td colspan="2" class="diff-lineno">Řádek 14:</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 (příklady sestav)]]</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 (příklady sestav)]]</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 79 225)&lt;/small></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>__NOTOC__</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>__NOTOC__</div></td></tr> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=Minul%C3%A9,_aktu%C3%A1ln%C3%AD_a_budouc%C3%AD_tarify_(sestava)&diff=48739&oldid=prev 2025-09-08T12:32:31Z

<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 8. 9. 2025, 14:32</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>Minulé, aktuální a budoucí tarify (sestava) je sestava pro [[Generátor sestav II]]. Období zadává uživatel v poli ''Od''.</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>Minulé, aktuální a budoucí tarify (sestava) je sestava pro [[Generátor sestav II]]. Období zadává uživatel v poli ''Od''.</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: <del style="font-weight: bold; text-decoration: none;">Aktivni pracovni pomery v obdobi</del>-Sestava.png<del style="font-weight: bold; text-decoration: none;">|990px</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: <ins style="font-weight: bold; text-decoration: none;">Minule aktualni budouci tarify</ins>-Sestava.png]]</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> <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 <del style="font-weight: bold; text-decoration: none;">A.id_podniku, </del>A.os_cislo, A.prijmeni, A.jmeno, <del style="font-weight: bold; text-decoration: none;">A</del>.<del style="font-weight: bold; text-decoration: none;">datum_nastupu</del>, <del style="font-weight: bold; text-decoration: none;">A</del>.<del style="font-weight: bold; text-decoration: none;">datum_vystupu</del>, <del style="font-weight: bold; text-decoration: none;">A</del>.<del style="font-weight: bold; text-decoration: none;">kmen_str</del>, B.<del style="font-weight: bold; text-decoration: none;">cislo_pom</del>, B.<del style="font-weight: bold; text-decoration: none;">prac_str</del>, B.<del style="font-weight: bold; text-decoration: none;">druh_pom</del>, <del style="font-weight: bold; text-decoration: none;">  </del>B.<del style="font-weight: bold; text-decoration: none;">druh_pom_j</del>, <del style="font-weight: bold; text-decoration: none;">B.datum_nastupu, B.datum_ukonc</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>  SELECT A.os_cislo, A.prijmeni, A.jmeno, <ins style="font-weight: bold; text-decoration: none;">B</ins>.<ins style="font-weight: bold; text-decoration: none;">cislo_pom</ins>, <ins style="font-weight: bold; text-decoration: none;">B</ins>.<ins style="font-weight: bold; text-decoration: none;">pov_funkce</ins>, <ins style="font-weight: bold; text-decoration: none;">PM</ins>.<ins style="font-weight: bold; text-decoration: none;">naz_pracmist</ins>, B.<ins style="font-weight: bold; text-decoration: none;">datum_nastupu</ins>, B.<ins style="font-weight: bold; text-decoration: none;">datum_ukonc</ins>, B.<ins style="font-weight: bold; text-decoration: none;">tarif as tarif_akt</ins>, <ins style="font-weight: bold; text-decoration: none;"> </ins>B.<ins style="font-weight: bold; text-decoration: none;">min_zakl as tarif_minul</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><del style="font-weight: bold; text-decoration: none;"> </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>  <ins style="font-weight: bold; text-decoration: none;">(select max(hodnota) </ins>from <ins style="font-weight: bold; text-decoration: none;">timer_data TM </ins>where <ins style="font-weight: bold; text-decoration: none;">TM</ins>.os_cislo = B.os_cislo and <ins style="font-weight: bold; text-decoration: none;">TM.cislo_pom = </ins>B.<ins style="font-weight: bold; text-decoration: none;">cislo_pom and TM.id </ins>= <ins style="font-weight: bold; text-decoration: none;">3 </ins>and <ins style="font-weight: bold; text-decoration: none;">TM</ins>.<ins style="font-weight: bold; text-decoration: none;">plati_od </ins>&gt;= <ins style="font-weight: bold; text-decoration: none;"> </ins>%DATUMOD%) <ins style="font-weight: bold; text-decoration: none;">as tarif_bud_max, B.trida as trida_akt</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>  from <del style="font-weight: bold; text-decoration: none;">pracovnici A, prac_pom B </del>where <del style="font-weight: bold; text-decoration: none;">A</del>.os_cislo = B.os_cislo and</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;"> from pracovnici A, prac_pom B left outer join prac_mist PM on B.id_pracmist = PM.id_pracmist where A.os_cislo = B.os_cislo;</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><del style="font-weight: bold; text-decoration: none;"> </del>B.<del style="font-weight: bold; text-decoration: none;">datum_nastupu &lt;</del>= <del style="font-weight: bold; text-decoration: none;">%DATUMDO% </del>and <del style="font-weight: bold; text-decoration: none;">(B.datum_ukonc is null or B</del>.<del style="font-weight: bold; text-decoration: none;">datum_ukonc </del>&gt;= %DATUMOD%)</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> <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" 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;">* [[Filtr]]</del></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>* [[Generátor sestav II (příklady sestav)]]</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 (příklady sestav)]]</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>__NOTOC__</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>__NOTOC__</div></td></tr> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=Minul%C3%A9,_aktu%C3%A1ln%C3%AD_a_budouc%C3%AD_tarify_(sestava)&diff=48737&oldid=prev 2025-09-08T12:28:01Z

<p>založena nová stránka s textem „Minulé, aktuální a budoucí tarify (sestava) je sestava pro <a href="/index.php?title=Gener%C3%A1tor_sestav_II" title="Generátor sestav II">Generátor sestav II</a>. Období zadává uživatel v poli &#039;&#039;Od&#039;&#039;. <a href="/index.php?title=Soubor:Aktivni_pracovni_pomery_v_obdobi-Sestava.png" title="Soubor:Aktivni pracovni pomery v obdobi-Sestava.png">990px</a> == Definice == &lt;small&gt; SELECT A.id_podniku, A.os_cislo, A.prijmeni, A.jmeno, A.datum_nastupu, A.datum_vystupu, A.kmen_str, B.cislo_pom, B.prac_str, B.druh_pom, B.druh_pom_j, B.datum_nastupu, B.datum_ukonc from pracovnici A, prac_pom B where A.os_cislo =…“</p> <p><b>Nová stránka</b></p><div>Minulé, aktuální a budoucí tarify (sestava) je sestava pro [[Generátor sestav II]]. Období zadává uživatel v poli ''Od''.<br /> <br /> [[Image: Aktivni pracovni pomery v obdobi-Sestava.png|990px]]<br /> <br /> == Definice ==<br /> &lt;small&gt;<br /> SELECT A.id_podniku, A.os_cislo, A.prijmeni, A.jmeno, A.datum_nastupu, A.datum_vystupu, A.kmen_str, B.cislo_pom, B.prac_str, B.druh_pom, B.druh_pom_j, B.datum_nastupu, B.datum_ukonc<br /> <br /> from pracovnici A, prac_pom B where A.os_cislo = B.os_cislo and<br /> B.datum_nastupu &lt;= %DATUMDO% and (B.datum_ukonc is null or B.datum_ukonc &gt;= %DATUMOD%)<br /> &lt;/small&gt;<br /> <br /> == Odkazy ==<br /> * [[Filtr]]<br /> * [[Generátor sestav II (příklady sestav)]]<br /> __NOTOC__</div>

Petrm