| 12345678910111213141516171819202122232425262728293031 |
- WITH current_invoice AS (
- SELECT Client_DB, Beleg_Nr, Kunde_Nr, Fahrzeug_Nr
- FROM dbo.Forderungen_Kopf
- WHERE Client_DB = :client_db AND Beleg_Nr = :beleg_nr
- ), scoped_invoices AS (
- {% if scope == 'invoice' %}
- SELECT Client_DB, Beleg_Nr FROM current_invoice
- {% elif scope == 'open' %}
- SELECT F.Client_DB, F.Beleg_Nr FROM dbo.Forderungen_Kopf AS F
- WHERE F.Client_DB = :client_db AND F.Beleg_Offen <> 0
- AND EXISTS (SELECT 1 FROM current_invoice AS C WHERE C.Kunde_Nr = F.Kunde_Nr)
- {% else %}
- SELECT F.Client_DB, F.Beleg_Nr FROM dbo.Forderungen_Kopf AS F
- WHERE F.Client_DB = :client_db
- AND EXISTS (
- SELECT 1 FROM current_invoice AS C WHERE C.Kunde_Nr = F.Kunde_Nr
- {% if scope == 'vehicle' %}
- AND C.Fahrzeug_Nr IS NOT NULL AND C.Fahrzeug_Nr <> '' AND C.Fahrzeug_Nr = F.Fahrzeug_Nr
- {% endif %}
- )
- UNION
- SELECT H.Client_DB, H.Beleg_Nr FROM dbo.Forderungen_Historie AS H
- WHERE H.Client_DB = :client_db
- AND EXISTS (
- SELECT 1 FROM current_invoice AS C WHERE C.Kunde_Nr = H.Kunde_Nr
- {% if scope == 'vehicle' %}
- AND C.Fahrzeug_Nr IS NOT NULL AND C.Fahrzeug_Nr <> '' AND C.Fahrzeug_Nr = H.Fahrzeug_Nr
- {% endif %}
- )
- {% endif %}
- )
|