From 8b7b226d73364f6bd8582df83f0346d6c668d58c Mon Sep 17 00:00:00 2001 From: Philip Reetz Date: Mon, 29 Jan 2007 13:29:25 +0000 Subject: [PATCH] Bei eur wurden in der Kontenliste keine unbezahlten Rechnungen angezeigt. Entfernt. --- SL/CA.pm | 28 +++++----------------------- 1 file changed, 5 insertions(+), 23 deletions(-) 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'|; -- 2.20.1