projekt kivitendo

    qq|UPDATE gl SET

         reference = ?, description = ?, notes = ?,

         transdate = ?, deliverydate = ?, tax_point = ?, department_id = ?, taxincluded = ?,

       WHERE id = ?|;

  @values = ($form->{reference}, $form->{description}, $form->{notes},

             conv_date($form->{transdate}), conv_date($form->{deliverydate}), conv_date($form->{tax_point}), conv_i($form->{department_id}), $form->{taxincluded} ? 't' : 'f',

             $form->{storno} ? 't' : 'f', conv_i($form->{storno_id}), $form->{ob_transaction} ? 't' : 'f', $form->{cb_transaction} ? 't' : 'f',

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

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

           g.storno, g.storno_id,

           g.department_id, d.description AS department,

           e.name AS employee, g.taxincluded, g.gldate,

         FROM gl g

         LEFT JOIN department d ON (d.id = g.department_id)

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

  $form->isblank("reference",   $locale->text('Reference missing!'));

  $form->isblank("transdate",   $locale->text('Transaction Date missing!'));

  $form->isblank("description", $locale->text('Description missing!'));

  my $transdate = $form->datetonum($form->{transdate}, \%myconfig);

  my $closedto  = $form->datetonum($form->{closedto},  \%myconfig);

          <td>[% L.date_tag('tax_point', tax_point) %]</td>

        </tr>

        <tr>

          <th align=right>[% 'Delivery Date' | $T8 %]</th>

          <td>[% L.date_tag('deliverydate', deliverydate) %]</td>

        </tr>

        <tr>

          <th align="right">[%- IF id %][% 'Mitarbeiter' | $T8 %][% END %]</th>

          <td>[%- IF id %][% L.input_tag('employee', employee, size=20, readonly=readonly) %][% END %]</td>