projekt kivitendo

sub delivery_plan_query_linked_items {

  my ($self) = @_;

  my $employee_id = SL::DB::Manager::Employee->current->id;

  my $oe_owner = $_[0]->all_edit_right ? '' : " oe.employee_id = $employee_id AND";

  [

  'order.closed' => 0,

  # filter by shipped_qty < qty, read from innermost to outermost

  'id' => [ \"

      FROM orderitems oi, oe, record_links rl, delivery_order_items doi

      WHERE

        oe.id = oi.trans_id AND

        NOT oe.closed AND

        $oe_owner

        doi.id = rl.to_id AND

    SELECT oi.id FROM orderitems oi, oe

    WHERE

      oe.id = oi.trans_id AND

      NOT oe.closed AND

      $oe_owner

      NOT EXISTS (