From: Moritz Bunkus <m.bunkus@linet-services.de>
Date: Tue, 5 Jun 2007 13:59:14 +0000 (+0000)
Subject: Nur die Lieferanten und Händler zurückliefern, die nicht 'ungültig' markiert sind.
X-Git-Tag: release-2.4.3^2~197
X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/commitdiff_plain/a5501b166388f169f232af20d911d79528f2f5c5

Nur die Lieferanten und Händler zurückliefern, die nicht 'ungültig' markiert sind.
---

diff --git a/SL/Form.pm b/SL/Form.pm
index a1e6a4d9d..dbffe1ff7 100644
--- a/SL/Form.pm
+++ b/SL/Form.pm
@@ -1697,7 +1697,7 @@ sub _get_customers {
 
   $key = "all_customers" unless ($key);
 
-  my $query = qq|SELECT * FROM customer ORDER BY name|;
+  my $query = qq|SELECT * FROM customer WHERE NOT obsolete ORDER BY name|;
 
   $self->{$key} = selectall_hashref_query($self, $dbh, $query);
 
@@ -1711,7 +1711,7 @@ sub _get_vendors {
 
   $key = "all_vendors" unless ($key);
 
-  my $query = qq|SELECT * FROM vendor ORDER BY name|;
+  my $query = qq|SELECT * FROM vendor WHERE NOT obsolete ORDER BY name|;
 
   $self->{$key} = selectall_hashref_query($self, $dbh, $query);