Index: openacs.org-dev/packages/ecommerce/www/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/ecommerce/www/index-postgresql.xql,v diff -u -r1.1.1.1 -r1.1.1.2 --- openacs.org-dev/packages/ecommerce/www/index-postgresql.xql 9 Jul 2002 17:35:05 -0000 1.1.1.1 +++ openacs.org-dev/packages/ecommerce/www/index-postgresql.xql 8 Oct 2002 15:47:06 -0000 1.1.1.2 @@ -13,4 +13,32 @@ </querytext> </fullquery> + <fullquery name="get_produc_recs"> + <querytext> + select p.product_id, p.product_name, p.dirname, r.recommendation_text, o.offer_code + from ec_product_recommendations r, ec_products_displayable p left outer join ec_user_session_offer_codes o on + (p.product_id = o.product_id and user_session_id = :user_session_id) + where 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' + </querytext> + </fullquery> + + <fullquery name="get_tl_products"> + <querytext> + select p.product_id, p.product_name, p.one_line_description, o.offer_code + from ec_products_searchable p left outer join ec_user_session_offer_codes o on (p.product_id = o.product_id and user_session_id = :user_session_id) + where not exists (select 1 + from ec_category_product_map m + where p.product_id = m.product_id) + order by p.product_name + </querytext> + </fullquery> + </queryset>