Tarif a vybrané příplatky (sestava)
Z Prirucky
Tarif a vybrané příplatky (sestava) je sestava pro Generátor sestav II.
Sestava zobrazuje vybrané položky prac.poměru, tarif, vybrané příplatky a součet příplatků. Platnost sestavy je omezena na 1 období - "měsíc od". Je možno volit i minulé období (historii).
Definice
SELECT A.os_cislo, A.prijmeni, A.jmeno, A.titul, B.cislo_pom, B.prac_kateg, B.pov_funkce, (select naz_pracmist from prac_mist PM where PM.cis_pracmist = B.pov_funkce and (PM.datum_od is null or PM.datum_od <= %DATUMOD%) and (PM.datum_do is null or PM.datum_do >= %DATUMOD%)) naz_pracmist, B.trida, B.mzd_stup, B.tarif, (select sum(castka) from priplatky P where P.os_cislo = B.os_cislo and P.cislo_pom = B.cislo_pom and (P.plati_od is null or P.plati_od <= %DATUMOD%) and (P.plati_do is null or P.plati_do >=%DATUMOD%) and P.kod = 245) as pripl_245, (select sum(castka) from priplatky P where P.os_cislo = B.os_cislo and P.cislo_pom = B.cislo_pom and (P.plati_od is null or P.plati_od <= %DATUMOD%) and (P.plati_do is null or P.plati_do >=%DATUMOD%)and P.kod = 292) as pripl_292, (select sum(castka) from priplatky P where P.os_cislo = B.os_cislo and P.cislo_pom = B.cislo_pom and (P.plati_od is null or P.plati_od <= %DATUMOD%) and (P.plati_do is null or P.plati_do >=%DATUMOD%)) as prip_celkem from pracovnici A, prac_pom B, par_map where A.os_cislo = B.os_cislo and par_map.datum_prvni = %DATUMOD% union SELECT A.os_cislo, A.prijmeni, A.jmeno, A.titul, B.cislo_pom, B.prac_kateg, B.pov_funkce, (select naz_pracmist from prac_mist PM where PM.cis_pracmist = B.pov_funkce and (PM.datum_od is null or PM.datum_od <= %DATUMOD%) and (PM.datum_do is null or PM.datum_do >= %DATUMOD%)) naz_pracmist, B.trida, B.mzd_stup, B.tarif, (select sum(castka) from priplatky P where P.os_cislo = B.os_cislo and P.cislo_pom = B.cislo_pom and (P.plati_od is null or P.plati_od <= %DATUMOD%) and (P.plati_do is null or P.plati_do >=%DATUMOD%) and P.kod = 245) as pripl_245, (select sum(castka) from priplatky P where P.os_cislo = B.os_cislo and P.cislo_pom = B.cislo_pom and (P.plati_od is null or P.plati_od <= %DATUMOD%) and (P.plati_do is null or P.plati_do >=%DATUMOD%)and P.kod = 292) as pripl_292, (select sum(castka) from priplatky P where P.os_cislo = B.os_cislo and P.cislo_pom = B.cislo_pom and (P.plati_od is null or P.plati_od <= %DATUMOD%) and (P.plati_do is null or P.plati_do >=%DATUMOD%)) as prip_celkem from pracovnici A, pom_zal B where A.os_cislo = B.os_cislo and B.datum = %DATUMOD%