Index: openacs-4/packages/ecommerce/ecommerce.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/ecommerce.info,v diff -u -r1.20 -r1.21 --- openacs-4/packages/ecommerce/ecommerce.info 26 May 2002 04:36:49 -0000 1.20 +++ openacs-4/packages/ecommerce/ecommerce.info 12 Sep 2002 22:22:48 -0000 1.21 @@ -17,7 +17,7 @@ ACS 3.x based e-commerce solution. This version represents a major overhaul of the prior version (4.2a). See the documentation for more information. 2002-05-13 furfly.net, LLC - This module implements all that IT needs for a standard business-to-consumer Web service. You can find a feature summary in the documentaion. + This module implements all that IT needs for a standard business-to-consumer Web service. You can find a feature summary in the documentaion. @@ -47,7 +47,6 @@ - @@ -337,7 +336,6 @@ - @@ -374,6 +372,8 @@ + + @@ -956,54 +956,54 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: openacs-4/packages/ecommerce/www/admin/orders/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/index-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/ecommerce/www/admin/orders/index-oracle.xql 12 Sep 2002 22:22:48 -0000 1.1 @@ -0,0 +1,19 @@ + + + + + oracle + 8.1.6 + + + + + select shipping_method, nvl(count(*),0) as shipping_method_count + from ec_orders_shippable + where shipping_method not in ('no_shipping', 'pickup') + and shipping_method is not null + group by shipping_method + + + + Index: openacs-4/packages/ecommerce/www/admin/orders/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/index-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/ecommerce/www/admin/orders/index-postgresql.xql 12 Sep 2002 22:22:48 -0000 1.1 @@ -0,0 +1,19 @@ + + + + + postgresql + 7.1 + + + + + select shipping_method, coalesce(count(*), 0) as shipping_method_count + from ec_orders_shippable + where shipping_method not in ('no_shipping', 'pickup') + and shipping_method is not null + group by shipping_method + + + +