From 4252995520f5020735ca33d3fbbe63d9f6d4ef0b Mon Sep 17 00:00:00 2001 From: Niclas Zimmermann Date: Fri, 19 Apr 2013 18:05:00 +0200 Subject: [PATCH] =?utf8?q?Anpassung=20f=C3=BCr=20global=20eindeutige=20Art?= =?utf8?q?ikelnummern?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Artikelnummern sind nun in der parts eindeutig. D.h. es ist auch sinnvoll vorher auf alle Artikelnummern zu prüfen. --- SL/TransNumber.pm | 1 - 1 file changed, 1 deletion(-) diff --git a/SL/TransNumber.pm b/SL/TransNumber.pm index 859ca6865..9d6d2993a 100644 --- a/SL/TransNumber.pm +++ b/SL/TransNumber.pm @@ -71,7 +71,6 @@ sub _get_filters { $filters{numberfield} = $type eq 'service' ? 'servicenumber' : 'articlenumber'; $filters{numberfield} = $type eq 'assembly' ? 'assemblynumber' : $filters{numberfield}; $filters{table} = "parts"; - $filters{where} = 'COALESCE(inventory_accno_id, 0) ' . ($type eq 'service' ? '= 0' : '<> 0 OR assembly'); } return %filters; -- 2.20.1