projekt kivitendo

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

    LEFT JOIN partsgroup pg      ON (p.partsgroup_id                          = pg.id)

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

      AND NOT COALESCE(oe.closed,    FALSE)

      AND (oe.id NOT IN (SELECT oe_id FROM periodic_invoices_configs WHERE periodicity <> 'o'))

SQL

  }

  my @where = (

    or             => [ closed    => undef, closed    => 0, ],

  );

  push @where, (reqdate => { ge => $params{after}->clone })  if $params{after};