From c2796317373c0c0006ce9b99d1aad4bad21a3631 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Tue, 26 Feb 2013 14:34:57 +0100 Subject: [PATCH] Kosmetik: Leerzeichen am Zeilenende weg. --- SL/BackgroundJob/SelfTest/Transactions.pm | 2 +- SL/CT.pm | 4 ++-- SL/DATEV.pm | 4 ++-- SL/GL.pm | 4 ++-- SL/VK.pm | 6 +++--- 5 files changed, 10 insertions(+), 10 deletions(-) diff --git a/SL/BackgroundJob/SelfTest/Transactions.pm b/SL/BackgroundJob/SelfTest/Transactions.pm index 881298d98..a7fe76364 100644 --- a/SL/BackgroundJob/SelfTest/Transactions.pm +++ b/SL/BackgroundJob/SelfTest/Transactions.pm @@ -309,7 +309,7 @@ sub check_stornos_ohne_partner { LEFT JOIN vendor v on (v.id = ap.vendor_id) WHERE storno_id is null AND storno is true AND ap.id not in (SELECT storno_id FROM ap WHERE storno_id is not null AND storno is true); |; - + my $stornos_ohne_partner = selectall_hashref_query($::form, $self->dbh, $query); $self->tester->ok(@$stornos_ohne_partner == 0, 'Es sollte keine Stornos ohne Partner geben'); diff --git a/SL/CT.pm b/SL/CT.pm index 2ec7aec69..97f57c72c 100644 --- a/SL/CT.pm +++ b/SL/CT.pm @@ -639,7 +639,7 @@ sub search { my $sortorder; if ( $join_records ) { # in UNION case order by hash key, e.g. salesman - # the UNION created an implicit select around the result + # the UNION created an implicit select around the result $sortorder = $allowed_sort_columns{$form->{sort}} ? $form->{sort} : "name"; } else { # in not UNION case order by hash value, e.g. e.name @@ -812,7 +812,7 @@ sub search { } $query .= qq| ORDER BY $sortorder|; - + $form->{CT} = selectall_hashref_query($form, $dbh, $query, @values); $main::lxdebug->leave_sub(); diff --git a/SL/DATEV.pm b/SL/DATEV.pm index 875588859..b748d30d2 100644 --- a/SL/DATEV.pm +++ b/SL/DATEV.pm @@ -465,11 +465,11 @@ sub _get_transactions { next; } - # determine at which array position the reference value (called absumsatz) is + # determine at which array position the reference value (called absumsatz) is # and which amount it has for my $j (0 .. (scalar(@{$trans}) - 1)) { - + # Three cases: # 1: gl transaction (Dialogbuchung), invoice is false, no double split booking allowed diff --git a/SL/GL.pm b/SL/GL.pm index 5783fbfd3..cb7f346d1 100644 --- a/SL/GL.pm +++ b/SL/GL.pm @@ -280,7 +280,7 @@ sub all_transactions { push(@arvalues, '%' . $form->{description} . '%'); push(@apvalues, '%' . $form->{description} . '%'); } - + if ($form->{employee} =~ /--/) { ($form->{employee_id},$form->{employee_name}) = split(/--/,$form->{employee}); #if ($form->{employee_id}) { @@ -366,7 +366,7 @@ sub all_transactions { 'source' => { 'gl' => 'ac.source', 'arap' => 'ac.source', }, 'description' => { 'gl' => 'g.description', 'arap' => 'ct.name', }, ); - + # sortdir = sort direction (ascending or descending) my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC'; my $sortkey = $sort_columns{$form->{sort}} ? $form->{sort} : $form->{datesort}; # default used to be transdate diff --git a/SL/VK.pm b/SL/VK.pm index c056aac65..c373a1956 100644 --- a/SL/VK.pm +++ b/SL/VK.pm @@ -52,7 +52,7 @@ sub invoice_transactions { my $query = qq|SELECT ct.id as customerid, ct.name as customername,ct.customernumber,ct.country,ar.invnumber,ar.id,ar.transdate,p.partnumber,pg.partsgroup,i.parts_id,i.qty,i.price_factor,i.discount,i.description as description,i.lastcost,i.sellprice,i.fxsellprice,i.marge_total,i.marge_percent,i.unit,b.description as business,e.name as employee,e2.name as salesman, to_char(ar.transdate,'Month') as month, to_char(ar.transdate, 'YYYYMM') as nummonth, p.unit as parts_unit, p.weight | . - qq|FROM invoice i | . + qq|FROM invoice i | . qq|JOIN ar on (i.trans_id = ar.id) | . qq|JOIN parts p on (i.parts_id = p.id) | . qq|LEFT JOIN partsgroup pg on (p.partsgroup_id = pg.id) | . @@ -157,7 +157,7 @@ sub invoice_transactions { push(@values, $form->{"project_id"}, $form->{"project_id"}); } if ($form->{business_id}) { - $where .= qq| AND ct.business_id = ? |; + $where .= qq| AND ct.business_id = ? |; push(@values, $form->{"business_id"}); } @@ -179,7 +179,7 @@ sub invoice_transactions { $where .= qq| AND ($cvar_where_ic)|; push @values, @cvar_values_ic; } - + $query .= " WHERE $where ORDER BY $sortorder "; # LIMIT 5000"; my @result = selectall_hashref_query($form, $dbh, $query, @values); -- 2.20.1