projekt kivitendo

           o.ordnumber, o.transdate, o.cusordnumber, o.subtotal, o.recurring_billing_mode, o.longdescription,

           o.price_factor_id, o.price_factor, o.marge_price_factor, o.active_price_source, o.active_discount_source,

           pr.projectnumber, p.formel,

         FROM orderitems o

         JOIN parts p ON (o.parts_id = p.id)

         JOIN oe ON (o.trans_id = oe.id)

         LEFT JOIN chart c2 ON ((SELECT tc.income_accno_id  FROM taxzone_charts tc WHERE tc.taxzone_id = ? and tc.buchungsgruppen_id = p.buchungsgruppen_id) = c2.id)

         LEFT JOIN chart c3 ON ((SELECT tc.expense_accno_id FROM taxzone_charts tc WHERE tc.taxzone_id = ? and tc.buchungsgruppen_id = p.buchungsgruppen_id) = c3.id)

         LEFT JOIN project pr ON (o.project_id = pr.id)

      ($form->{id}

       ? qq|WHERE o.trans_id = ?|

       : qq|WHERE o.trans_id IN (| . join(", ", map("?", @ids)) . qq|)|) .

  my @arrays =

    qw(runningnumber number description longdescription qty qty_nofmt ship ship_nofmt unit bin

       partnotes serialnumber reqdate sellprice sellprice_nofmt listprice listprice_nofmt netprice netprice_nofmt

       discount discount_nofmt p_discount discount_sub discount_sub_nofmt nodiscount_sub nodiscount_sub_nofmt

       linetotal linetotal_nofmt nodiscount_linetotal nodiscount_linetotal_nofmt tax_rate projectnumber projectdescription

       price_factor price_factor_name partsgroup weight weight_nofmt lineweight lineweight_nofmt optional);