projekt kivitendo

    FROM periodic_invoices pi

    LEFT JOIN periodic_invoices_configs pcfg ON (pi.config_id = pcfg.id)

    WHERE pcfg.active

      AND (pi.period_start_date >= to_date($q_min_date, 'YYYY-MM-DD'))

SQL

    LEFT JOIN buchungsgruppen bg             ON (p.buchungsgruppen_id                     = bg.id)

    LEFT JOIN employee e                     ON (COALESCE(oe.salesman_id, oe.employee_id) = e.id)

    WHERE pcfg.active

SQL

  # 3. Iterieren über Saldierungsintervalle, vormerken

    WHERE (oe.customer_id IS NOT NULL)

      AND NOT COALESCE(oe.quotation, FALSE)

      AND NOT COALESCE(oe.closed,    FALSE)

SQL

  # 5. Initialisierung der Datenstrukturen zum Speichern der