|
|
| Řádek 1: |
Řádek 1: |
| '''v_pozadavky (view)''' je zákaznické view pro zobrazení požadavků zaměstnance.
| |
|
| |
|
| == Definice ==
| |
| <!-- ZákazníK: VUANCH - pro Unicorn, P.M. a P.H. 09/2014 -->
| |
| <small>
| |
| create view v_pozadavky as
| |
| select
| |
| workfl_hl.id_poz,
| |
| workfl_hl.os_cislo,
| |
| workfl_hl.typ,
| |
| pracovnici.prijmeni,
| |
| pracovnici.jmeno,
| |
| workfl_body.datum_od,
| |
| workfl_body.datum_do,
| |
|
| |
| workfl_proc.poradi,
| |
| workfl_proc.stav,
| |
| workfl_proc.datum,
| |
| workfl_proc.cas,
| |
| workfl_proc.zapsal,
| |
| workfl_hl.url_odkaz
| |
|
| |
| from workfl_hl, pracovnici, workfl_body, workfl_proc
| |
| where workfl_hl.os_cislo = pracovnici.os_cislo and
| |
| workfl_hl.id_poz = workfl_body.id_poz and
| |
| workfl_hl.id_poz = workfl_proc.id_poz and
| |
|
| |
| workfl_proc.poradi =
| |
| (select max(poradi) from workfl_proc b where b.id_poz = workfl_proc.id_poz)
| |
| </small>
| |
|
| |
| == Odkazy ==
| |
| * [[URL odkaz (požadavky)]]
| |
| * [[Portál-Schvalování požadavků]]
| |
| * [[v_absence (view)]]
| |
| * [[Zákaznické speciality]]
| |
