Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 11. Menny zoznam platitelov, ktori si svoje povinnosti nesplnili v termine (20% odvodov bud nezaplatili vobec alebo nezaplatili do konca nasledujuceho mesiaca)
- SELECT pl.id_platitela,
- COALESCE((SELECT z.nazov
- FROM p_zamestnavatel z
- WHERE z.ico = pl.id_platitela),
- (SELECT o.meno || ' ' || o.priezvisko AS meno
- FROM p_osoba o
- WHERE o.rod_cislo = pl.id_platitela) ) AS meno_platitela
- FROM p_platitel pl
- join p_poistenie po ON(po.id_platitela = pl.id_platitela)
- WHERE LOWER(po.oslobodeny) = 'n'
- AND (po.id_poistenca IN ( --len tie id_poistenca kde sa omeskali s platbami alebo vobec nezaplatili
- SELECT op.id_poistenca
- FROM p_odvod_platba op
- WHERE op.dat_platby IS NULL
- OR op.dat_platby > LAST_DAY(ADD_MONTHS(op.obdobie, 1))
- )
- OR po.id_poistenca IN( -- len tie id_poistenca kde nieje zaplatene 20% z celkovej sumy
- SELECT op.id_poistenca
- FROM p_odvod_platba op
- GROUP BY op.id_poistenca
- HAVING SUM(op.suma) / SUM((CASE WHEN op.dat_platby IS NULL THEN 0 ELSE 1 END) * op.suma) < 0.8
- )
- )
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement