X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FHelper%2FPayment.pm;h=9555f001a001adaa75480f115f3c8b85d18d2e21;hb=a66cafd980c44371fd29b0383f665125d85b1cc7;hp=4403b0238ba9f9e0399f56e4d17ba22b3c598448;hpb=728f5827cddfd7e7ca7bd7c36a3d40a9ba311d16;p=kivitendo-erp.git diff --git a/SL/DB/Helper/Payment.pm b/SL/DB/Helper/Payment.pm index 4403b0238..9555f001a 100644 --- a/SL/DB/Helper/Payment.pm +++ b/SL/DB/Helper/Payment.pm @@ -4,7 +4,7 @@ use strict; use parent qw(Exporter); our @EXPORT = qw(pay_invoice); -our @EXPORT_OK = qw(skonto_date skonto_charts amount_less_skonto within_skonto_period percent_skonto reference_account reference_amount open_amount open_percent remaining_skonto_days skonto_amount check_skonto_configuration valid_skonto_amount get_payment_suggestions validate_payment_type open_sepa_transfer_amount get_payment_select_options_for_bank_transaction create_bank_transaction exchangerate forex); +our @EXPORT_OK = qw(skonto_date skonto_charts amount_less_skonto within_skonto_period percent_skonto reference_account reference_amount open_amount open_percent remaining_skonto_days skonto_amount check_skonto_configuration valid_skonto_amount get_payment_suggestions validate_payment_type open_sepa_transfer_amount get_payment_select_options_for_bank_transaction exchangerate forex); our %EXPORT_TAGS = ( "ALL" => [@EXPORT, @EXPORT_OK], ); @@ -107,13 +107,13 @@ sub pay_invoice { # account where money is paid to/from: bank account or cash my $account_bank = SL::DB::Manager::Chart->find_by(id => $params{chart_id}); - croak "can't find bank account" unless ref $account_bank; + croak "can't find bank account with id " . $params{chart_id} unless ref $account_bank; my $reference_account = $self->reference_account; croak "can't find reference account (link = AR/AP) for invoice" unless ref $reference_account; - my $memo = $params{'memo'} || ''; - my $source = $params{'source'} || ''; + my $memo = $params{memo} // ''; + my $source = $params{source} // ''; my $rounded_params_amount = _round( $params{amount} ); # / $exchangerate); my $fx_gain_loss_amount = 0; # for fx_gain and fx_loss @@ -294,14 +294,11 @@ sub pay_invoice { if ( $datev_check ) { my $datev = SL::DATEV->new( - exporttype => DATEV_ET_BUCHUNGEN, - format => DATEV_FORMAT_KNE, dbh => $db->dbh, trans_id => $self->{id}, ); - $datev->clean_temporary_directories; - $datev->export; + $datev->generate_datev_data; if ($datev->errors) { # this exception should be caught by with_transaction, which handles the rollback @@ -464,7 +461,7 @@ sub check_skonto_configuration { # my $transactions = $self->transactions; foreach my $transaction (@{ $self->transactions }) { # find all transactions with an AR_amount or AP_amount link - my $tax = SL::DB::Manager::Tax->get_first( where => [taxkey => $transaction->taxkey]); + my $tax = SL::DB::Manager::Tax->get_first( where => [taxkey => $transaction->taxkey, id => $transaction->tax_id ]); croak "no tax for taxkey " . $transaction->{taxkey} unless ref $tax; $transaction->{chartlinks} = { map { $_ => 1 } split(m/:/, $transaction->chart_link) }; @@ -545,7 +542,8 @@ sub skonto_charts { # $reference_ARAP_amount += $transaction->{amount} * $mult; # quick hack that works around problem of non-unique tax keys in SKR04 - my $tax = SL::DB::Manager::Tax->get_first( where => [taxkey => $transaction->{taxkey}]); + # ? use tax_id in acc_trans + my $tax = SL::DB::Manager::Tax->get_first( where => [id => $transaction->{tax_id}]); croak "no tax for taxkey " . $transaction->{taxkey} unless ref $tax; if ( $is_sales ) { @@ -640,7 +638,7 @@ sub get_payment_select_options_for_bank_transaction { if ( $open_amount && # invoice amount not 0 $self->skonto_date && # check whether skonto applies ( abs(abs($self->amount_less_skonto) - abs($bt->amount)) < 0.01 || - ( $bt->transaction_code eq "191" && abs($self->amount_less_skonto) < abs($bt->amount) )) && + ( abs($self->amount_less_skonto) < abs($bt->amount) )) && $self->check_skonto_configuration) { if ( $self->within_skonto_period($bt->transdate) ) { push(@options, { payment_type => 'without_skonto', display => t8('without skonto') }); @@ -723,41 +721,6 @@ sub validate_payment_type { return 1; } -sub create_bank_transaction { - my ($self, %params) = @_; - - require SL::DB::Chart; - require SL::DB::BankAccount; - - my $bank_chart; - if ( $params{chart_id} ) { - $bank_chart = SL::DB::Manager::Chart->find_by(chart_id => $params{chart_id}) or die "Can't find bank chart"; - } elsif ( $::instance_conf->get_ar_paid_accno_id ) { - $bank_chart = SL::DB::Manager::Chart->find_by(id => $::instance_conf->get_ar_paid_accno_id); - } else { - $bank_chart = SL::DB::Manager::Chart->find_by(description => 'Bank') or die "Can't find bank chart"; - }; - my $bank_account = SL::DB::Manager::BankAccount->find_by(chart_id => $bank_chart->id) or die "Can't find bank account for chart"; - - my $multiplier = $self->is_sales ? 1 : -1; - my $amount = ($params{amount} || $self->amount) * $multiplier; - - my $transdate = $params{transdate} || DateTime->today; - - my $bt = SL::DB::BankTransaction->new( - local_bank_account_id => $bank_account->id, - remote_bank_code => $self->customervendor->bank_code, - remote_account_number => $self->customervendor->account_number, - transdate => $transdate, - valutadate => $transdate, - amount => $::form->round_amount($amount, 2), - currency => $self->currency->id, - remote_name => $self->customervendor->depositor, - purpose => $params{purpose} || $self->invnumber - )->save; -}; - - sub forex { my ($self) = @_; $self->currency_id == $::instance_conf->get_currency_id ? return 0 : return 1; @@ -829,7 +792,7 @@ or in a certain currency: transdate => DateTime->now->to_kivitendo, memo => 'foobar', source => 'barfoo', - payment_type => 'with_skonto', + payment_type => 'with_skonto_pt', ); Allowed payment types are: @@ -1110,39 +1073,6 @@ If skonto is possible (skonto_date exists), add two possibilities: without_skonto and with_skonto_pt if payment date is within skonto_date, preselect with_skonto_pt, otherwise preselect without skonto. -=item C - -Method used for testing purposes, allows you to quickly create bank -transactions from invoices to have something to test payments against. - - my $ap = SL::DB::Manager::Invoice->find_by(id => 41); - $ap->create_bank_transaction(amount => $ap->amount/2, transdate => DateTime->today->add(days => 5)); - -To create a payment for 3 invoices that were all paid together, all with skonto: - my $ar1 = SL::DB::Manager::Invoice->find_by(invnumber=>'20'); - my $ar2 = SL::DB::Manager::Invoice->find_by(invnumber=>'21'); - my $ar3 = SL::DB::Manager::Invoice->find_by(invnumber=>'22'); - $ar1->create_bank_transaction(amount => ($ar1->amount_less_skonto + $ar2->amount_less_skonto + $ar2->amount_less_skonto), - purpose => 'Rechnungen 20, 21, 22', - ); - -Amount is always relative to the absolute amount of the invoice, use positive -values for sales and purchases. - -The following params can be passed to override the defaults: - -=over 2 - -=item * amount - -=item * purpose - -=item * chart_id (the chart the amount is to be paid to) - -=item * transdate - -=back - =item C Returns 1 immediately if the record uses the default currency.