projekt kivitendo

  $form->set_payment_options($myconfig, $form->{invdate});

  $form->{username} = $myconfig->{name};

  $main::lxdebug->leave_sub();

                cp_id       = ?, marge_total   = ?, marge_percent = ?,

                globalproject_id               = ?, delivery_customer_id             = ?,

                transaction_description        = ?, delivery_vendor_id               = ?,

              WHERE id = ?|;

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

             conv_date($form->{"invdate"}),  conv_date($form->{"orddate"}),    conv_date($form->{"quodate"}),    conv_i($form->{"customer_id"}),

                conv_i($form->{"globalproject_id"}),                              conv_i($form->{"delivery_customer_id"}),

                       $form->{transaction_description},                          conv_i($form->{"delivery_vendor_id"}),

                       $form->{"donumber"}, $form->{"invnumber_for_credit_note"},        $form->{direct_debit} ? 't' : 'f',

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

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

           a.employee_id, a.salesman_id, a.payment_id,

           a.language_id, a.delivery_customer_id, a.delivery_vendor_id, a.type,

           a.transaction_description, a.donumber, a.invnumber_for_credit_note,

           e.name AS employee

         FROM ar a

         LEFT JOIN employee e ON (e.id = a.employee_id)

  $query =

    qq|SELECT

         c.id AS customer_id, c.name AS customer, c.discount as customer_discount, c.creditlimit, c.terms,

         c.street, c.zipcode, c.city, c.country,

         c.notes AS intnotes, c.klass as customer_klass, c.taxzone_id, c.salesman_id, cu.name AS curr,

         c.taxincluded_checked, c.direct_debit,