projekt kivitendo

    marge_percent             => { type => 'numeric', precision => 5, scale => 15 },

    donumber                  => { type => 'text' },

    invnumber_for_credit_note => { type => 'text' },

  ],

  primary_key_columns => [ 'id' ],

                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->{"cp_id"}),            1 * $form->{marge_total} ,      1 * $form->{marge_percent},

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

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

                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)

         c.email, c.cc, c.bcc, c.language_id, c.payment_id,

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

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

         $duedate + COALESCE(pt.terms_netto, 0) AS duedate,

         b.discount AS tradediscount, b.description AS business

       FROM customer c

  'delete'                      => 'Löschen',

  'delivered'                   => 'geliefert',

  'deliverydate'                => 'Lieferdatum',

  'disposed'                    => 'Entsorgung',

  'do not include'              => 'Nicht aufnehmen',

  'done'                        => 'erledigt',

[%- USE T8 %]

[%- USE HTML %]

[%- USE LxERP %]

  <tr>

   <td>

    <table width="100%">

                 show_empty    = 1

                 allow_textbox = 0 -%]

          <script type='text/javascript'>$('#payment_id').change(function(){ if (this.value) set_duedate()})</script>

         </td>

        </tr>

[%- IF id && follow_ups.size %]