projekt kivitendo

    qq|  o.amount, ct.name, o.netamount, o.${vc}_id, o.globalproject_id, | .

    qq|  o.closed, o.delivered, o.quonumber, o.shippingpoint, o.shipvia, | .

    qq|  o.transaction_description, | .

    qq|  ex.$rate AS exchangerate, | .

    qq|  pr.projectnumber AS globalprojectnumber, | .

    qq|  e.name AS employee | .

      }

      my $baseqty = $form->{"qty_$i"} * $basefactor;

      # set values to 0 if nothing entered

      $form->{"discount_$i"} =

        $form->parse_amount($myconfig, $form->{"discount_$i"}) / 100;

      }

      $query .= qq|trans_id, parts_id, description, longdescription, qty, base_qty, | .

                qq|sellprice, discount, unit, reqdate, project_id, serialnumber, ship, | .

                qq|VALUES (|;

      if($form->{"orderitems_id_$i"}) {

        $query .= qq|?,|;

        push(@values, $form->{"orderitems_id_$i"});

      }

		  push(@values,

           conv_i($form->{id}), conv_i($form->{"id_$i"}),

           $form->{"description_$i"}, $form->{"longdescription_$i"},

           $form->{"unit_$i"}, conv_date($reqdate), conv_i($form->{"project_id_$i"}),

           $form->{"serialnumber_$i"}, $form->{"ship_$i"}, conv_i($pricegroup_id),

           $form->{"ordnumber_$i"}, conv_date($form->{"transdate_$i"}),

      do_query($form, $dbh, $query, @values);

      $form->{"sellprice_$i"} = $fxsellprice;

    qq|shippingpoint = ?, shipvia = ?, notes = ?, intnotes = ?, curr = ?, closed = ?, | .

    qq|delivered = ?, proforma = ?, quotation = ?, department_id = ?, language_id = ?, | .

    qq|taxzone_id = ?, shipto_id = ?, payment_id = ?, delivery_vendor_id = ?, delivery_customer_id = ?, | .

    qq|WHERE id = ?|;

  @values = ($form->{ordnumber}, $form->{quonumber},

             conv_i($form->{globalproject_id}), conv_i($form->{employee_id}),

             conv_i($form->{salesman_id}), conv_i($form->{cp_id}),

             $form->{transaction_description},

             conv_i($form->{id}));

  do_query($form, $dbh, $query, @values);

      qq|  oe.ordnumber AS ordnumber_oe, oe.transdate AS transdate_oe, oe.cusordnumber AS cusordnumber_oe,  | .

      qq|  p.partnumber, p.assembly, o.description, o.qty, | .

      qq|  o.sellprice, o.parts_id AS id, o.unit, o.discount, p.bin, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id, | .

      qq|  o.ordnumber, o.transdate, o.cusordnumber, o.subtotal, o.longdescription, | .

      qq|  pr.projectnumber, p.formel, | .

      qq|  pg.partsgroup, o.pricegroup_id, (SELECT pricegroup FROM pricegroup WHERE id=o.pricegroup_id) as pricegroup | .