projekt kivitendo

         customer_id = ?, amount = ?, netamount = ?, reqdate = ?, taxincluded = ?,

         shippingpoint = ?, shipvia = ?, notes = ?, intnotes = ?, currency_id = (SELECT id FROM currencies WHERE name=?), closed = ?,

         delivered = ?, proforma = ?, quotation = ?, department_id = ?, language_id = ?,

         globalproject_id = ?, employee_id = ?, salesman_id = ?, cp_id = ?, transaction_description = ?, marge_total = ?, marge_percent = ?

       WHERE id = ?|;

             conv_i($form->{shipto_id}), conv_i($form->{payment_id}),

             conv_i($form->{delivery_vendor_id}),

             conv_i($form->{delivery_customer_id}),

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

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

             $form->{transaction_description},

           o.closed, o.reqdate, o.quonumber, o.department_id, o.cusordnumber,

           d.description AS department, o.payment_id, o.language_id, o.taxzone_id,

           o.delivery_customer_id, o.delivery_vendor_id, o.proforma, o.shipto_id,

         FROM oe o

         JOIN ${vc} cv ON (o.${vc}_id = cv.id)

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

  $dbh->disconnect;

  $main::lxdebug->leave_sub();

}