From 33feb7bd4b883680fe871dc2d85217915e42aa5a Mon Sep 17 00:00:00 2001 From: jan Date: Sun, 15 Nov 2009 11:50:45 +0100 Subject: [PATCH] =?utf8?q?Berichte=20->=20GuV,=20BWA=20(get=5Faccounts=5Fg?= =?utf8?q?)=20und=20Berichte=20->=20Bilanz=20(get=5Faccounts)=20k=C3=B6nne?= =?utf8?q?n=20jeweils=20nach=20E=C3=9CR=20oder=20Bilanz=20unterschieden=20?= =?utf8?q?werden.=20Die=20Abfrage=20nach=20Abteilungen=20scheint=20etwas?= =?utf8?q?=20redundant=20f=C3=BCr=20den=20Fallunterschied=20(Bilanz=20oder?= =?utf8?q?=20E=C3=9CR)=20zu=20sein.=20Erstmal=20auskommentiert,=20mit=20de?= =?utf8?q?r=20Bitte=20zu=20pr=C3=BCfen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/RP.pm | 18 ++++++++++-------- 1 file changed, 10 insertions(+), 8 deletions(-) diff --git a/SL/RP.pm b/SL/RP.pm index 2aa1e8d98..1f86d4b39 100644 --- a/SL/RP.pm +++ b/SL/RP.pm @@ -325,10 +325,12 @@ sub get_accounts { } } else { # if ($form->{method} eq 'cash') - if ($department_id) { - $dpt_join = qq| JOIN dpt_trans t ON (t.trans_id = ac.trans_id) |; - $dpt_where = qq| AND t.department_id = $department_id |; - } + # ich sehe keinen sinn das nochmal explizit ohne conv_i aufzurufen + # bitte prüfen und löschen jan 15.11.2009 + # if ($department_id) { + # $dpt_join = qq| JOIN dpt_trans t ON (t.trans_id = ac.trans_id) |; + # $dpt_where = qq| AND t.department_id = $department_id |; + # } $query = qq| SELECT c.accno, sum(ac.amount) AS amount, c.description, c.category @@ -573,10 +575,10 @@ sub get_accounts_g { } } else { # if ($form->{method} eq 'cash') - if ($department_id) { - $dpt_join = qq| JOIN dpt_trans t ON (t.trans_id = ac.trans_id) |; - $dpt_where = qq| AND (t.department_id = | . conv_i($department_id, 'NULL') . qq|) |; - } + # s.o. jan 15.11.2009 + # if ($department_id) { + # ($dpt_join, $dpt_where) = sql_department($department_id); + # } $query = qq| SELECT sum(ac.amount * chart_category_to_sgn(c.category)) AS amount, c.$category -- 2.20.1