projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Letter: is_sales nicht in init_letter clobbern
[kivitendo-erp.git]
/
SL
/
SEPA.pm
diff --git
a/SL/SEPA.pm
b/SL/SEPA.pm
index
9457917
..
2809063
100644
(file)
--- a/
SL/SEPA.pm
+++ b/
SL/SEPA.pm
@@
-49,7
+49,7
@@
sub retrieve_open_invoices {
FROM ${arap}
LEFT JOIN ${vc} vc ON (${arap}.${vc}_id = vc.id)
FROM ${arap}
LEFT JOIN ${vc} vc ON (${arap}.${vc}_id = vc.id)
- LEFT JOIN (SELECT sei.${arap}_id, SUM(sei.amount) AS amount
+ LEFT JOIN (SELECT sei.${arap}_id, SUM(sei.amount)
+ SUM(COALESCE(sei.skonto_amount,0))
AS amount
FROM sepa_export_items sei
LEFT JOIN sepa_export se ON (sei.sepa_export_id = se.id)
WHERE NOT se.closed
FROM sepa_export_items sei
LEFT JOIN sepa_export se ON (sei.sepa_export_id = se.id)
WHERE NOT se.closed
@@
-322,12
+322,12
@@
sub list_exports {
if ($filter->{invnumber}) {
push @where_sub, "arap.invnumber ILIKE ?";
if ($filter->{invnumber}) {
push @where_sub, "arap.invnumber ILIKE ?";
- push @values_sub,
'%' . $filter->{invnumber} . '%'
;
+ push @values_sub,
like($filter->{invnumber})
;
$joins_sub{$arap} = 1;
}
if ($filter->{message_id}) {
$joins_sub{$arap} = 1;
}
if ($filter->{message_id}) {
- push @values,
'%' . $filter->{message_id} . '%'
;
+ push @values,
like($filter->{message_id})
;
push @where, <<SQL;
se.id IN (
SELECT sepa_export_id
push @where, <<SQL;
se.id IN (
SELECT sepa_export_id
@@
-339,7
+339,7
@@
SQL
if ($filter->{vc}) {
push @where_sub, "vc.name ILIKE ?";
if ($filter->{vc}) {
push @where_sub, "vc.name ILIKE ?";
- push @values_sub,
'%' . $filter->{vc} . '%'
;
+ push @values_sub,
like($filter->{vc})
;
$joins_sub{$arap} = 1;
$joins_sub{vc} = 1;
}
$joins_sub{$arap} = 1;
$joins_sub{vc} = 1;
}