Warensuche: Verkaufte Anzahl kann auch kleiner als 0 sein, für Stornos

diff --git a/SL/IC.pm b/SL/IC.pm
index bce0debe7955d160541779084c42d9bb49cd567b..30aa8cf0d256078ba5f437b7e0d13e89dade3629 100644 (file)
--- a/SL/IC.pm
+++ b/SL/IC.pm
@@ -985,7 +985,7 @@ sub all_parts {
 
   # now the master trick: soldtotal.
   if ($form->{l_soldtotal}) {
 
   # now the master trick: soldtotal.
   if ($form->{l_soldtotal}) {

-    push @where_tokens, 'ioi.qty >= 0';
+    push @where_tokens, 'NOT ioi.qty = 0';

     push @group_tokens, @select_tokens;
      map { s/.*\sAS\s+//si } @group_tokens;
     push @select_tokens, 'SUM(ioi.qty)';
     push @group_tokens, @select_tokens;
      map { s/.*\sAS\s+//si } @group_tokens;
     push @select_tokens, 'SUM(ioi.qty)';

diff --git a/doc/changelog b/doc/changelog
index d09a3a1772a8844e76b26679cf1af643df3e217b..d0ab6eaad2990f3236889105006347fb4203a4f4 100644 (file)
--- a/doc/changelog
+++ b/doc/changelog
@@ -163,7 +163,7 @@
   1044 1046 1051 1055 1057 1058 1072 1073 1077 1079 1081 1082 1095 1098
   1100 1101 1108 1110 1118 1125 1127 1130 1133 1135 1136 1138 1144
   1146 1147 1150 1151 1155 1164 1173 1177 1186 1188 1190 1191 1195
   1044 1046 1051 1055 1057 1058 1072 1073 1077 1079 1081 1082 1095 1098
   1100 1101 1108 1110 1118 1125 1127 1130 1133 1135 1136 1138 1144
   1146 1147 1150 1151 1155 1164 1173 1177 1186 1188 1190 1191 1195

-  1197 1198 1199 1200 1201 1209 1213 1243 1248 1250 1286 1289
+  1197 1198 1199 1200 1201 1209 1213 1243 1248 1250 1262 1286 1289

 
 
 2009-06-02 - Version 2.6.0
 
 
 2009-06-02 - Version 2.6.0