projekt kivitendo

  # make sure to have a id

  my ($query, $sth, @values);

  if (!$payments_only) {

    # if we have an id delete old records

    if ($form->{id}) {

      # delete detail records

      $query = qq|DELETE FROM acc_trans WHERE trans_id = ?|;

      do_query($form, $dbh, $query, $form->{id});

    } else {

      ($form->{id}) = selectrow_query($form, $dbh, qq|SELECT nextval('glid')|);

      $query =

        qq|INSERT INTO ap (id, invnumber, employee_id,currency_id, taxzone_id) | .

        qq|VALUES (?, ?, (SELECT e.id FROM employee e WHERE e.login = ?),

                      (SELECT id FROM currencies WHERE name = ?), (SELECT taxzone_id FROM vendor WHERE id = ?) )|;

      do_query($form, $dbh, $query, $form->{id}, $form->{invnumber}, $::myconfig{login}, $form->{currency}, $form->{vendor_id});

    }

  }

  # check default or record exchangerate

  # if we have an id delete old records else make one

  if (!$payments_only) {

    if ($form->{id}) {

      # delete detail records

      $query = qq|DELETE FROM acc_trans WHERE trans_id = ?|;

      do_query($form, $dbh, $query, $form->{id});

    } else {

      $query = qq|SELECT nextval('glid')|;

      ($form->{id}) = selectrow_query($form, $dbh, $query);

      $query = qq|INSERT INTO ar (id, invnumber, employee_id, currency_id, taxzone_id) VALUES (?, 'dummy', ?, (SELECT id FROM currencies WHERE name=?), (SELECT taxzone_id FROM customer WHERE id = ?))|;

      do_query($form, $dbh, $query, $form->{id}, $form->{employee_id}, $form->{currency}, $form->{customer_id});

      if (!$form->{invnumber}) {

        my $trans_number   = SL::TransNumber->new(type => 'invoice', dbh => $dbh, number => $form->{partnumber}, id => $form->{id});

        $form->{invnumber} = $trans_number->create_unique;

      }

    }

  }