projekt kivitendo

  ORDER BY oi.trans_id, oi.position

# oi not item linked. takes about 250ms for 100k hits

my $fill_up_oi_query = <<'';

  SELECT oi.id, oi.trans_id, oi.position, oi.parts_id, oi.description, oi.reqdate, oi.serialnumber, oi.qty, oi.unit

  FROM orderitems oi

  ORDER BY oi.trans_id, oi.position

# doi linked by record, but not by items; 250ms for 100k hits

my $no_stock_fill_up_doi_query = <<'';

  SELECT doi.id, doi.delivery_order_id, doi.position, doi.parts_id, doi.description, doi.reqdate, doi.serialnumber, doi.qty, doi.unit

  FROM delivery_order_items doi

    } elsif ('SL::DB::Order' eq ref $obj) {

      if (defined $obj->{orderitems}) {

        $self->write_to($obj->{orderitems});

      } else {

        # don't force a load on items. just compute by oe_id directly

        $obj->{delivered} = $self->delivered->{$obj->id};