Index: openacs-4/packages/ecommerce/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/index-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/www/index-oracle.xql 12 Sep 2002 22:15:01 -0000 1.3
+++ openacs-4/packages/ecommerce/www/index-oracle.xql 19 Sep 2002 23:40:46 -0000 1.4
@@ -15,6 +15,23 @@
+
+
+ select p.product_id, p.product_name, p.dirname, r.recommendation_text, o.offer_code
+ from ec_product_recommendations r, ec_products_displayable p, ec_user_session_offer_codes o
+ where (p.product_id(+)=o.product_id and user_session_id = :user_session_id)
+ and p.product_id=r.product_id
+ and category_id is null
+ and subcategory_id is null
+ and subsubcategory_id is null
+ and (r.user_class_id is null or r.user_class_id in (select user_class_id
+ from ec_user_class_user_map
+ where user_id = :user_id
+ $user_class_approved_p_clause))
+ and r.active_p='t'
+
+
+
select p.product_id, p.product_name, p.one_line_description, o.offer_code