|
|
| (Není zobrazeno 946 mezilehlých verzí od stejného uživatele.) |
| Řádek 1: |
Řádek 1: |
| '''Sestavy (Rozpad na projekty dle odpracované doby)''' | | == Číselníky == |
| | {|class="wikitable sortable" border="1" cellpadding="3" cellspacing="0" |
| | |- style="background-color: #eeeeee" |
| | |'''Souhrn údajů''' |
| | |'''Čtení''' |
| | |'''Zápis''' |
| | |'''Význam''' |
| | |- |
| | | [[WebAPI Střediska|Strediska ]] |
| | | Ano |
| | | Ano |
| | | Číselník středisek |
| | |- |
| | | [[WebAPI Skupiny středisek |SkupinyStredisek ]] |
| | | Ano |
| | | Ano |
| | | Číselník skupiny středisek |
| | |- |
| | | [[WebAPI Divize|Divize ]] |
| | | Ano |
| | | Ano |
| | | Číselník divizí |
| | |- |
| | |- |
| | | [[WebAPI Pracovní místa|PracovniMista ]] |
| | | Ano |
| | | Ano |
| | | Číselník pracovních míst |
| | |- |
| | | [[WebAPI CiselnikJazyku|CiselnikJazyku]] || || || Číselník jazyků |
| | |- |
| | | [[WebAPI CiselnikStupnuVzdelani|CiselnikStupnuVzdelani]] || || || Číselník stupňů vzdělání |
| | |- |
| | | [[WebAPI iTutor_Courses|iTutor_Courses]] || || || |
| | |} |
|
| |
|
| Sestavy jsou určeny jako doplněk funkcionality
| | == Zaměstnanci == |
| : [[Rozpad na projekty dle odpracované doby]] | | {|class="wikitable sortable" border="1" cellpadding="3" cellspacing="0" |
| převážně pro [[Generátor sestav II]], kam je také potřeba zadat příslušnou definici (uváděnou níže u každé sestavy) - [[Generátor sestav II (nová definice SQL)]].
| | |- style="background-color: #eeeeee" |
| | |'''Souhrn údajů''' |
| | |'''Čtení''' |
| | |'''Zápis''' |
| | |'''Význam''' |
| | |- |
| | | [[WebAPI Kmenové údaje|KmenoveUdaje ]] |
| | | Ano |
| | | Ano |
| | | Evidence zaměstnanců |
| | |- |
| | | [[WebAPI Vzdělání|Vzdelani ]] |
| | | Ano |
| | | Ano |
| | | Dosažené vzdělání zaměstnanců |
| | |- |
| | | [[WebAPI Jazykové znalosti |JazykoveZnalosti ]] |
| | | Ano |
| | | Ano |
| | | Jazykové znalosti zaměstnanců |
| | |- |
| | | [[WebAPI Rodinní příslušníci|RodinniPrislusnici ]] |
| | | Ano |
| | | Ano |
| | | Rodinní příslušníci |
| | |- |
| | | [[WebAPI Rodinní příslušníci slevy|RodinniPrislusniciSlevy ]] |
| | | Ano |
| | | Ano |
| | | Daňové zvýhodnění rodinných příslušníků |
| | |- |
| | |- |
| | | [[WebAPI Kontakty|Kontakty]] |
| | | Ano |
| | | Ano |
| | | Kontakty (telefonní čísla, emaily) |
| | |- |
| | | [[WebAPI Poznamky|Poznamky]] || || || Poznámky |
| | |- |
| | | [[WebAPI Platby |Platby ]] |
| | | Ano |
| | | Ano |
| | | Platby zaměstanců |
|
| |
|
| == Odpracovaná doba na projektech (vč. neschválené) ==
| | |- |
| [[Image: Odpracovana-doba-na-projektech-vcetne-neschvalenych.png|900px]] | | | [[WebAPI Pracovní povolení|PracovniPovoleni ]] |
| | | Ano |
| | | Ano |
| | | Pracovní povolení cizinců |
| | |- |
| | | [[WebAPI Požadavky|Požadavky]] || || || [[Požadavky]] |
| | |} |
|
| |
|
| * ''hod'' - vykázané hodiny na projektu
| | == Pracovní poměry == |
| * ''hod_cinn'' - součet vykázaných hodin činností na projektu (měl by být stejný jako ''hod'')
| | {|class="wikitable sortable" border="1" cellpadding="3" cellspacing="0" |
| * ''hod_bez_cinn'' - v případě prázdné hodnoty značí, že nebyly pořízeny činnosti
| | |- style="background-color: #eeeeee" |
| | |'''Souhrn údajů''' |
| | |'''Čtení''' |
| | |'''Zápis''' |
| | |'''Význam''' |
| | |- |
| | | [[WebAPI Pracovní poměry |PracovniPomery ]] |
| | | Ano |
| | | Ano |
| | | Pracovněprávní poměry zaměstnanců |
| | |- |
| | | [[WebAPI Pracovní postup|PracovniPostup ]] |
| | | Ano |
| | | Ne |
| | | Pracovní postup zaměstnanců |
| | |- |
| | | [[WebAPI Dovolená|Dovolena ]] |
| | | Ano |
| | | Ne |
| | | Dovolená v hodinách (legislativa 2021) |
| | |- |
| | | [[WebAPI Benefitní volno|BenefitniVolno ]] |
| | | Ano |
| | | Ne |
| | | Benefitní volna zaměstnanců |
| | |- |
| | | [[WebAPI MimoevidencniStavy|MimoevidencniStavy]] || Ano || Ne || [[Mimoevidenční stav]] |
| | |} |
|
| |
|
| <small>
| | == Mzdy == |
| select
| | {|class="wikitable sortable" border="1" cellpadding="3" cellspacing="0" |
| projekty_hod.id, projekty_hod.id_proj, datum,
| | |- style="background-color: #eeeeee" |
| pracovnici.os_cislo, prijmeni, jmeno, titul,
| | |'''Souhrn údajů''' |
| prac_pom.cislo_pom, prac_pom.prac_str,
| | |'''Čtení''' |
| cis_projekty.cislo, cis_projekty.nazev, id_poz, schvaleno, hod,
| | |'''Zápis''' |
| (select sum (hod) from projekty_cinn where id_proj_hod = projekty_hod.id) as hod_cinn,
| | |'''Význam''' |
| (hod -
| | |- |
| (select sum (hod) from projekty_cinn where id_proj_hod = projekty_hod.id)) as hod_bez_cinn,
| | | [[WebAPI Zpracované mzdy |ZpracovaneMzdy ]] |
| poz as poznamka
| | | Ano |
|
| | | Ne |
| from projekty_hod, pracovnici,prac_pom, cis_projekty
| | | Mzdy zaměstnanců a odvody podniku. |
| where pracovnici.os_cislo = prac_pom.os_cislo and
| | |- |
| prac_pom.os_cislo = projekty_hod.os_cislo and
| | | [[WebAPI Zpracovaná docházka|ZpracovanaDochazka ]] |
| prac_pom.cislo_pom = projekty_hod.cislo_pom and
| | | Ano |
| projekty_hod.id_proj = cis_projekty.id | | | Ano |
| and datum >= %DATUMOD% and datum <= %DATUMDO% | | | Sesumovaná docházková data pro mzdy |
|
| | |- |
| order by pracovnici.prijmeni, projekty_hod.id
| | | [[WebAPI Plánované směny|Plánované směny]] || || || |
| | |- |
| | | [[WebAPI KumulacePoVyuctovani|KumulacePoVyuctovani]] || Ano || Ne || Měsíční kumulace a další údaje po vyúčtování za os.číslo. |
| | |} |
|
| |
|
| </small>
| | == Ostatní == |
| | {|class="wikitable sortable" border="1" cellpadding="3" cellspacing="0" |
| | |- style="background-color: #eeeeee" |
| | |'''Souhrn údajů''' |
| | |'''Čtení''' |
| | |'''Zápis''' |
| | |'''Význam''' |
| | |- |
| | | [[WebAPI Pracovní pomůcky|PracovniPomucky]] |
| | | Ano |
| | | Ano |
| | | Přiřazení prac. pomůcek zaměstnancům |
|
| |
|
| == Činnosti na projektech (vč. neschválených) ==
| | |- |
| [[Image: Cinnosti-na-projektech-vcetne-neschvalenych.png|900px]] | | | [[WebAPI Služební cesty výdaje |SluzebniCestyVydaje ]] |
| | | | Ano |
| Sestava načítá všechny vykázané projekty s odpracovanou dobou a ke každému uvede pořízené činnosti. Projekty bez zadaných činností je možno zjistit tak, že ve sloupci ''hod_cinn'' (nebo ''nazev_cinn'') je prázdná hodnota.
| | | Ne |
| | | | Cestovní výdaje/náhrady |
| <small>
| | |- |
| select
| | | [[WebAPI Služební cesty|SluzebniCesty ]] |
| HOD.id,
| | | Ano |
| HOD.id_poz,
| | | Ne |
| HOD.schvaleno,
| | | Služební cesty |
| HOD.datum,
| | |- |
| HOD.id_proj,
| | | [[WebAPI Služební cesty vyučtování|SluzebniCestyVyuctovani ]] |
| CISPROJ.cislo as cis_proj, CISPROJ.nazev as naz_proj,
| | | Ano |
| PRAC.os_cislo, PRAC.prijmeni, PRAC.jmeno, PRAC.titul,
| | | Ne |
| PRACPOM.cislo_pom, PRACPOM.prac_str,
| | | Vyúčtování služebních cest |
| CIN.id,
| | |- |
| CIN.nazev as nazev_cinn, CIN.hod as hod_cinn, CIN.popis as popis_cinn
| | | [[WebAPI Služební cesty zálohy|SluzebniCestyZalohy ]] |
|
| | | Ano |
| from projekty_hod HOD left outer join projekty_cinn CIN on HOD.id = CIN.id_proj_hod,
| | | Ne |
| pracovnici PRAC, prac_pom PRACPOM, cis_projekty CISPROJ where
| | | Zálohy na služební cesty |
|
| | |} |
| PRAC.os_cislo = PRACPOM.os_cislo and
| |
| PRACPOM.os_cislo = HOD.os_cislo and
| |
| PRACPOM.cislo_pom = HOD.cislo_pom and
| |
| HOD.id_proj = CISPROJ.id and
| |
| HOD.datum >= %DATUMOD% and HOD.datum <= %DATUMDO%
| |
|
| |
| order by PRAC.prijmeni, HOD.id, CIN.id
| |
| </small>
| |
| | |
| == Vypočítané peníze po projektech ==
| |
| [[Image: Vypoctene-penize-po-projektech.png|800px]] | |
| | |
| <small>
| |
| select
| |
| pracovnici.os_cislo,
| |
| prac_pom.cislo_pom,
| |
| prijmeni, jmeno,
| |
| pichacky.kod,
| |
| (select vyznam from ciselnik where kod = pichacky.kod) as vyznam,
| |
| pichacky.prac_str, dat_od, dat_do, dny, hodiny, sazba, castka, prizn_aut, pichacky.prac_kateg, datum, id_vazby, typ_vazby,
| |
| (select cislo from cis_projekty where id = pichacky.id_vazby and typ_vazby = 'ph') as cis_projektu,
| |
| (select nazev from cis_projekty where id = pichacky.id_vazby and typ_vazby = 'ph') as naz_projektu
| |
|
| |
| from pracovnici, prac_pom, pichacky where
| |
| pracovnici.os_cislo = prac_pom.os_cislo and
| |
| pracovnici.os_cislo = pichacky.os_cislo and
| |
| prac_pom.cislo_pom = pichacky.cislo_pom and
| |
| datum >= %DATUMOD% and datum <= %DATUMDO%
| |
| order by datum, os_cislo, cislo_pom, kod
| |
| </small>
| |
| | |
| == Částky po měsících a po kódech a projektech ==
| |
| [[Image: Castky-po-mesich-po-kodech-a-projektech.png|900px]] | |
| | |
| * '''Pro MS SQL'''
| |
| <small>
| |
| select
| |
| kod, id_vazby, cislo, nazev, plati_od, plati_do,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-01-01') as Kc_01_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-02-01') as Kc_02_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-03-01') as Kc_03_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-04-01') as Kc_04_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-05-01') as Kc_05_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-06-01') as Kc_06_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-07-01') as Kc_07_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-08-01') as Kc_08_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-09-01') as Kc_09_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-10-01') as Kc_10_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-11-01') as Kc_11_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-12-01') as Kc_12_2015
| |
| from pichacky A left outer join cis_projekty on
| |
| A.id_vazby = cis_projekty.id
| |
| where id_vazby is not null
| |
| group by kod, id_vazby, cislo, nazev, plati_od, plati_do
| |
|
| |
| union
| |
|
| |
| select
| |
| kod, id_vazby, cislo, nazev, plati_od, plati_do,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-01-01') as Kc_01_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-02-01') as Kc_02_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-03-01') as Kc_03_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-04-01') as Kc_04_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-05-01') as Kc_05_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-06-01') as Kc_06_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-07-01') as Kc_07_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-08-01') as Kc_08_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-09-01') as Kc_09_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-10-01') as Kc_10_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-11-01') as Kc_11_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-12-01') as Kc_12_2015
| |
|
| |
| from pichacky A left outer join cis_projekty on
| |
| A.id_vazby = cis_projekty.id
| |
| where id_vazby is null
| |
| group by kod, id_vazby, cislo, nazev, plati_od, plati_do
| |
| | |
| | |
| Včetně názvu mzdové položky
| |
| select
| |
| A.kod, vyznam, id_vazby, cislo, nazev, plati_od, plati_do,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-01-01') as Kc_01_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-02-01') as Kc_02_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-03-01') as Kc_03_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-04-01') as Kc_04_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-05-01') as Kc_05_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-06-01') as Kc_06_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-07-01') as Kc_07_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-08-01') as Kc_08_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-09-01') as Kc_09_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-10-01') as Kc_10_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-11-01') as Kc_11_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '2015-12-01') as Kc_12_2015
| |
|
| |
| from pichacky A left outer join cis_projekty on
| |
| A.id_vazby = cis_projekty.id, ciselnik
| |
| where id_vazby is not null and ciselnik.kod = A.kod
| |
| group by A.kod, vyznam, id_vazby, cislo, nazev, plati_od, plati_do
| |
|
| |
| union
| |
|
| |
| select
| |
| A.kod, vyznam, id_vazby, cislo, nazev, plati_od, plati_do,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-01-01') as Kc_01_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-02-01') as Kc_02_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-03-01') as Kc_03_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-04-01') as Kc_04_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-05-01') as Kc_05_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-06-01') as Kc_06_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-07-01') as Kc_07_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-08-01') as Kc_08_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-09-01') as Kc_09_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-10-01') as Kc_10_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-11-01') as Kc_11_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '2015-12-01') as Kc_12_2015
| |
|
| |
| from pichacky A left outer join cis_projekty on
| |
| A.id_vazby = cis_projekty.id, ciselnik
| |
| where id_vazby is null and ciselnik.kod = A.kod
| |
| group by A.kod, vyznam, id_vazby, cislo, nazev, plati_od, plati_do
| |
| | |
| </small>
| |
| | |
| * '''Pro Informix'''
| |
| <small>
| |
| | |
| select
| |
| kod, id_vazby, cislo, nazev, plati_od, plati_do,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.01.2015') as Kc_01_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.02.2015') as Kc_02_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.03.2015') as Kc_03_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.04.2015') as Kc_04_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.05.2015') as Kc_05_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.06.2015') as Kc_06_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.07.2015') as Kc_07_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.08.2015') as Kc_08_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.09.2015') as Kc_09_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.10.2015') as Kc_10_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.11.2015') as Kc_11_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby = A.id_vazby and B.datum = '01.12.2015') as Kc_12_2015
| |
|
| |
| from pichacky A left outer join cis_projekty on
| |
| A.id_vazby = cis_projekty.id
| |
| where id_vazby is not null
| |
| group by kod, id_vazby, cislo, nazev, plati_od, plati_do
| |
|
| |
| union
| |
|
| |
| select
| |
| kod, id_vazby, cislo, nazev, plati_od, plati_do,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.01.2015') as Kc_01_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.02.2015') as Kc_02_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.03.2015') as Kc_03_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.04.2015') as Kc_04_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.05.2015') as Kc_05_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.06.2015') as Kc_06_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.07.2015') as Kc_07_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.08.2015') as Kc_08_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.09.2015') as Kc_09_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.10.2015') as Kc_10_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.11.2015') as Kc_11_2015,
| |
| (select sum(castka) from pichacky B where B.kod = A.kod and B.id_vazby is null and B.datum = '01.12.2015') as Kc_12_2015
| |
|
| |
| from pichacky A left outer join cis_projekty on
| |
| A.id_vazby = cis_projekty.id
| |
| where id_vazby is null
| |
| group by kod, id_vazby, cislo, nazev, plati_od, plati_do
| |
|
| |
| </small>
| |
| | |
| == Odkazy ==
| |
| * [[Rozpad na projekty dle odpracované doby]]
| |
| * DB: [[Image: Projekty hod cinn tabulky.png|70px]]
| |