X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FCA.pm;h=8122b9d4eeecab9497b2176a93c533793c739565;hb=8815371268e0e1f627835d5f8344f04730cbf0af;hp=4f4dbde63f9082d5412b40160632a722d8ed9ba4;hpb=f893eda30f6dc4c793f3e51f936d676720898432;p=kivitendo-erp.git diff --git a/SL/CA.pm b/SL/CA.pm index 4f4dbde63..8122b9d4e 100644 --- a/SL/CA.pm +++ b/SL/CA.pm @@ -144,29 +144,11 @@ sub all_transactions { $glwhere .= " AND ac.transdate <= '$form->{todate}'"; } - if ($form->{eur}) { - $AR_PAID = qq|AND ac.trans_id IN - ( - SELECT trans_id - FROM acc_trans - JOIN chart ON (chart_id = id) - WHERE link LIKE '%AR_paid%' - $subwhere - )|; - $AP_PAID = qq|AND ac.trans_id IN - ( - SELECT trans_id - FROM acc_trans - JOIN chart ON (chart_id = id) - WHERE link LIKE '%AP_paid%' - $subwhere - )|; - } else { - $where .= $fromto; - $AR_PAID = ""; - $AP_PAID = ""; - $glwhere = ""; # note! gl will be aliased as "a" later... - } + + $where .= $fromto; + $AR_PAID = ""; + $AP_PAID = ""; + $glwhere = ""; # note! gl will be aliased as "a" later... my $sortorder = join ', ', $form->sort_columns(qw(transdate reference description)); my $false = ($myconfig->{dbdriver} eq 'Pg') ? FALSE: q|'0'|;