projekt kivitendo

                invoice      = ?, taxzone_id  = ?, notes         = ?, taxincluded  = ?,

                intnotes     = ?, storno_id   = ?, storno        = ?, tax_point    = ?,

                cp_id        = ?, employee_id = ?, department_id = ?, delivery_term_id = ?,

                currency_id = (SELECT id FROM currencies WHERE name = ?),

                globalproject_id = ?, direct_debit = ?

              WHERE id = ?|;

            '1',                             $taxzone_id, $restricter->process($form->{notes}),               $form->{taxincluded} ? 't' : 'f',

                $form->{intnotes},           conv_i($form->{storno_id}),     $form->{storno}      ? 't' : 'f', conv_date($form->{tax_point}),

         conv_i($form->{cp_id}),      conv_i($form->{employee_id}), conv_i($form->{department_id}), conv_i($form->{delivery_term_id}),

                $form->{"currency"},

         conv_i($form->{globalproject_id}),

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

                ordnumber, quonumber, paid, taxincluded, notes, taxzone_id, storno, gldate,

                mtime, itime,

                intnotes, (SELECT cu.name FROM currencies cu WHERE cu.id=ap.currency_id) AS currency, direct_debit,

              FROM ap

              WHERE id = ?|;

  $ref = selectfirst_hashref_query($form, $dbh, $query, conv_i($form->{id}));