Index: openacs-4/packages/ecommerce/ecommerce.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/ecommerce.info,v
diff -u -r1.21 -r1.22
--- openacs-4/packages/ecommerce/ecommerce.info	12 Sep 2002 22:22:48 -0000	1.21
+++ openacs-4/packages/ecommerce/ecommerce.info	12 Sep 2002 22:55:34 -0000	1.22
@@ -903,6 +903,8 @@
             <file type="content_page" path="www/review-submit.adp"/>
             <file type="content_page" path="www/review-submit.tcl"/>
             <file type="query_file" path="www/review-submit.xql"/>
+            <file type="query_file" db_type="oracle" path="www/select-shipping-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/select-shipping-postgresql.xql"/>
             <file type="content_page" path="www/select-shipping.adp"/>
             <file type="content_page" path="www/select-shipping.tcl"/>
             <file type="query_file" path="www/select-shipping.xql"/>
Index: openacs-4/packages/ecommerce/www/select-shipping-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/select-shipping-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/select-shipping-oracle.xql	12 Sep 2002 22:55:35 -0000	1.1
@@ -0,0 +1,21 @@
+<?xml version="1.0"?>
+
+<queryset>
+  <rdbms>
+    <type>oracle</type>
+    <version>8.1.6</version>
+  </rdbms>
+
+  <fullquery name="select_hard_goods">      
+    <querytext>
+      select i.product_id, i.color_choice, i.size_choice, i.style_choice, count(*) as item_count, u.offer_code
+      from ec_products p, ec_items i, ec_user_session_offer_codes u
+      where u.product_id(+)=i.product_id and (u.user_session_id is null or u.user_session_id=:user_session_id)
+      and i.product_id = p.product_id
+      and p.no_shipping_avail_p = 'f' 
+      and i.order_id = :order_id
+      group by i.product_id, i.color_choice, i.size_choice, i.style_choice, u.offer_code
+    </querytext>
+  </fullquery>
+
+</queryset>
Index: openacs-4/packages/ecommerce/www/select-shipping-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/select-shipping-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/select-shipping-postgresql.xql	12 Sep 2002 22:55:35 -0000	1.1
@@ -0,0 +1,21 @@
+<?xml version="1.0"?>
+
+<queryset>
+  <rdbms>
+    <type>postgresql</type>
+    <version>7.1</version>
+  </rdbms>
+
+  <fullquery name="select_hard_goods">      
+    <querytext>
+        select i.product_id, i.color_choice, i.size_choice, i.style_choice, count(*) as item_count, u.offer_code
+        from ec_products p, ec_items i
+        left join ec_user_session_offer_codes u on (u.product_id = i.product_id and u.user_session_id = :user_session_id)
+        where i.product_id = p.product_id
+        and p.no_shipping_avail_p = 'f' 
+        and i.order_id = :order_id
+        group by i.product_id, i.color_choice, i.size_choice, i.style_choice, u.offer_code
+    </querytext>
+  </fullquery>
+
+</queryset>