Index: openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/Attic/by-order-state-and-time.xql,v diff -u -N --- openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time.xql 26 May 2002 04:36:50 -0000 1.4 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,18 +0,0 @@ - - - - - - - select o.order_id, o.confirmed_date, o.order_state, ec_total_price(o.order_id) as price_to_display, o.user_id, u.first_names, u.last_name, count(*) as n_items - from ec_orders o - join ec_items i using (order_id) - left join cc_users u on (o.user_id=u.user_id) - $confirmed_query_bit - $order_state_query_bit - group by o.order_id, o.confirmed_date, o.order_state, ec_total_price(o.order_id), o.user_id, u.first_names, u.last_name - order by $order_by_clause - - - -