|
|
| Řádek 1: |
Řádek 1: |
| ''Rozdělení úvazku na střediska - poměrné částky (sestava)'' - sestava je určena pro funkcionalitu [[Rozdělení úvazku na střediska]].
| |
|
| |
|
| == Příklad ==
| |
| === Data ===
| |
| [[Image: Rozdeleni-uvazku-na-strediska-sestava-1-1.png|590px]]
| |
| [[Image: Rozdeleni-uvazku-na-strediska-sestava-1-2.png|400px]]
| |
| [[Image: Rozdeleni-uvazku-na-strediska-sestava-1-3.png|400px]]
| |
|
| |
| === Sestava ===
| |
| [[Image: Rozdeleni-uvazku-na-strediska-sestava-1-4.png|650px]]
| |
|
| |
| Definice sestavy pro [[Generátor sestav II]]
| |
|
| |
| <small>
| |
| select
| |
| A.os_cislo, A.cislo_pom, P.prijmeni, P.jmeno, A.kod, A.prac_kateg, A.datum,
| |
| A.prac_str as stred,
| |
| A.castka,
| |
|
| |
| isnull(
| |
| (select 100-sum(koef) from par_ucty_tyco B where B.os_cislo = A.os_cislo and B.cislo_pom = A.cislo_pom and
| |
| B.dat_od <= A.datum and (B.dat_do is null or B.dat_do >= A.datum))
| |
| ,
| |
| 100) as koef,
| |
|
| |
| (A.castka *
| |
| isnull(
| |
| (select 100-sum(koef) from par_ucty_tyco B where B.os_cislo = A.os_cislo and B.cislo_pom = A.cislo_pom and
| |
| B.dat_od <= A.datum and (B.dat_do is null or B.dat_do >= A.datum))
| |
| ,
| |
| 100)/100) as castka_krat_koef
| |
|
| |
| from pichacky A, pracovnici P
| |
| where A.os_cislo = P.os_cislo and A.datum >= %DATUMOD% and A.datum <= %DATUMDO%
| |
|
| |
| union
| |
|
| |
| select
| |
| A.os_cislo, A.cislo_pom, P.prijmeni, P.jmeno, A.kod, A.prac_kateg, A.datum,
| |
| B.stred as stred,
| |
| A.castka,
| |
| B.koef,
| |
| (A.castka * B.koef / 100) as castka_krat_koef
| |
|
| |
| from pichacky A, pracovnici P, par_ucty_tyco B
| |
| where A.os_cislo = P.os_cislo and A.datum >= %DATUMOD% and A.datum <= %DATUMDO% and
| |
| A.os_cislo = B.os_cislo and
| |
| A.cislo_pom = B.cislo_pom and
| |
| B.dat_od <= A.datum and (B.dat_do is null or B.dat_do >= A.datum)
| |
| </small>
| |
|
| |
| == Odkazy ==
| |
| * [[Rozdělení úvazku na střediska]]
| |
