projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
mebil
[kivitendo-erp.git]
/
SL
/
SEPA.pm
diff --git
a/SL/SEPA.pm
b/SL/SEPA.pm
index
c62c2ce
..
9457917
100644
(file)
--- a/
SL/SEPA.pm
+++ b/
SL/SEPA.pm
@@
-326,6
+326,17
@@
sub list_exports {
$joins_sub{$arap} = 1;
}
$joins_sub{$arap} = 1;
}
+ if ($filter->{message_id}) {
+ push @values, '%' . $filter->{message_id} . '%';
+ push @where, <<SQL;
+ se.id IN (
+ SELECT sepa_export_id
+ FROM sepa_export_message_ids
+ WHERE message_id ILIKE ?
+ )
+SQL
+ }
+
if ($filter->{vc}) {
push @where_sub, "vc.name ILIKE ?";
push @values_sub, '%' . $filter->{vc} . '%';
if ($filter->{vc}) {
push @where_sub, "vc.name ILIKE ?";
push @values_sub, '%' . $filter->{vc} . '%';