X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FBankTransaction.pm;h=e4cf67cd37cb6ce6fab1e64690757aa8b8748550;hb=001f0168070d166b1a6fa44f52fd9dd0396ab7f7;hp=e91651a98bcb5373f6c9fd9a593e132da70102bb;hpb=88d162cc5e8e8d3810059d918a1eef6a2b205984;p=kivitendo-erp.git diff --git a/SL/DB/BankTransaction.pm b/SL/DB/BankTransaction.pm index e91651a98..e4cf67cd3 100644 --- a/SL/DB/BankTransaction.pm +++ b/SL/DB/BankTransaction.pm @@ -47,6 +47,11 @@ sub linked_invoices { return [ @linked_invoices ]; } +sub is_batch_transaction { + ($_[0]->transaction_code // '') eq "191"; +} + + sub get_agreement_with_invoice { my ($self, $invoice) = @_; @@ -73,10 +78,16 @@ sub get_agreement_with_invoice { skonto_exact_amount => 5, wrong_sign => -1, sepa_export_item => 5, + batch_sepa_transaction => 20, ); my ($agreement,$rule_matches); + if ( $self->is_batch_transaction && $self->{sepa_export_ok}) { + $agreement += $points{batch_sepa_transaction}; + $rule_matches .= 'batch_sepa_transaction(' . $points{'batch_sepa_transaction'} . ') '; + } + # compare banking arrangements my ($iban, $bank_code, $account_number); $bank_code = $invoice->customer->bank_code if $invoice->is_sales; @@ -88,11 +99,11 @@ sub get_agreement_with_invoice { if ( $bank_code eq $self->remote_bank_code && $account_number eq $self->remote_account_number ) { $agreement += $points{remote_account_number}; $rule_matches .= 'remote_account_number(' . $points{'remote_account_number'} . ') '; - }; + } if ( $iban eq $self->remote_account_number ) { $agreement += $points{remote_account_number}; $rule_matches .= 'remote_account_number(' . $points{'remote_account_number'} . ') '; - }; + } my $datediff = $self->transdate->{utc_rd_days} - $invoice->transdate->{utc_rd_days}; $invoice->{datediff} = $datediff; @@ -101,19 +112,19 @@ sub get_agreement_with_invoice { if (abs(abs($invoice->amount) - abs($self->amount)) < 0.01) { $agreement += $points{exact_amount}; $rule_matches .= 'exact_amount(' . $points{'exact_amount'} . ') '; - }; + } # compare open amount, preventing double points when open amount = invoice amount if ( $invoice->amount != $invoice->open_amount && abs(abs($invoice->open_amount) - abs($self->amount)) < 0.01) { $agreement += $points{exact_open_amount}; $rule_matches .= 'exact_open_amount(' . $points{'exact_open_amount'} . ') '; - }; + } if ( $invoice->skonto_date && abs(abs($invoice->amount_less_skonto) - abs($self->amount)) < 0.01) { $agreement += $points{skonto_exact_amount}; $rule_matches .= 'skonto_exact_amount(' . $points{'skonto_exact_amount'} . ') '; $invoice->{skonto_type} = 'with_skonto_pt'; - }; + } #search invoice number in purpose my $invnumber = $invoice->invnumber; @@ -132,11 +143,11 @@ sub get_agreement_with_invoice { if ( $invoice->is_sales && $self->amount < 0 ) { $agreement += $points{wrong_sign}; $rule_matches .= 'wrong_sign(' . $points{'wrong_sign'} . ') '; - }; + } if ( ! $invoice->is_sales && $self->amount > 0 ) { $agreement += $points{wrong_sign}; $rule_matches .= 'wrong_sign(' . $points{'wrong_sign'} . ') '; - }; + } # search customer/vendor number in purpose my $cvnumber; @@ -151,10 +162,10 @@ sub get_agreement_with_invoice { my $cvname; $cvname = $invoice->customer->name if $invoice->is_sales; $cvname = $invoice->vendor->name if ! $invoice->is_sales; - if ( $cvname && $self->purpose =~ /\b$cvname\b/i ) { + if ( $cvname && $self->purpose =~ /\b\Q$cvname\E\b/i ) { $agreement += $points{cust_vend_name_in_purpose}; $rule_matches .= 'cust_vend_name_in_purpose(' . $points{'cust_vend_name_in_purpose'} . ') '; - }; + } # compare depositorname, don't try to match empty depositors my $depositorname; @@ -163,24 +174,24 @@ sub get_agreement_with_invoice { if ( $depositorname && $self->remote_name =~ /$depositorname/ ) { $agreement += $points{depositor_matches}; $rule_matches .= 'depositor_matches(' . $points{'depositor_matches'} . ') '; - }; + } #Check if words in remote_name appear in cvname my $check_string_points = _check_string($self->remote_name,$cvname); if ( $check_string_points ) { $agreement += $check_string_points; $rule_matches .= 'remote_name(' . $check_string_points . ') '; - }; + } # transdate prefilter: compare transdate of bank_transaction with transdate of invoice if ( $datediff < -5 ) { # this might conflict with advance payments $agreement += $points{payment_before_invoice}; $rule_matches .= 'payment_before_invoice(' . $points{'payment_before_invoice'} . ') '; - }; + } if ( $datediff < 30 ) { $agreement += $points{payment_within_30_days}; $rule_matches .= 'payment_within_30_days(' . $points{'payment_within_30_days'} . ') '; - }; + } # only if we already have a good agreement, let date further change value of agreement. # this is so that if there are several plausible open invoices which are all equal @@ -205,31 +216,30 @@ sub get_agreement_with_invoice { $agreement += $points{datebonus_negative}; $rule_matches .= 'datebonus_negative(' . $points{'datebonus_negative'} . ') '; } else { - # e.g. datediff > 120 - }; - }; - -# # if there is exactly one non-executed sepa_export_item for the invoice -# if ( my $seis = $invoice->find_sepa_export_items({ executed => 0 }) ) { -# if ( scalar @$seis == 1 ) { -# my $sei = $seis->[0]; -# -# # test for amount and id matching only, sepa transfer date and bank -# # transaction date needn't match -# my $arap = $invoice->is_sales ? 'ar' : 'ap'; -# if ( abs($self->amount) == ($sei->amount) -# && $invoice->id == $sei->arap_id -# ) { -# $agreement += $points{sepa_export_item}; -# $rule_matches .= 'sepa_export_item(' . $points{'sepa_export_item'} . ') '; -# }; -# } else { -# # zero or more than one sepa_export_item, do nothing for this invoice -# # zero: do nothing, no sepa_export_item exists, no match -# # more than one: does this ever apply? Currently you can't create sepa -# # exports for invoices that already have a non-executed sepa_export -# }; -# }; + # e.g. datediff > 120 + } + } + + # if there is exactly one non-executed sepa_export_item for the invoice + if ( my $seis = $invoice->find_sepa_export_items({ executed => 0 }) ) { + if (scalar @$seis == 1) { + my $sei = $seis->[0]; + + # test for amount and id matching only, sepa transfer date and bank + # transaction date needn't match + if (abs($self->amount) == ($sei->amount) && $invoice->id == $sei->arap_id) { + $agreement += $points{sepa_export_item}; + $rule_matches .= 'sepa_export_item(' . $points{'sepa_export_item'} . ') '; + } + } else { + # zero or more than one sepa_export_item, do nothing for this invoice + # zero: do nothing, no sepa_export_item exists, no match + # more than one: does this ever apply? Currently you can't create sepa + # exports for invoices that already have a non-executed sepa_export + # TODO: Catch the more than one case. User is allowed to split + # payments for one invoice item in one sepa export. + } + } return ($agreement,$rule_matches); };