Index: openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time-oracle.xql	26 May 2002 04:36:50 -0000	1.3
+++ openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time-oracle.xql	12 Sep 2002 02:57:26 -0000	1.4
@@ -21,4 +21,23 @@
     </querytext>
   </partialquery>
 
+  <partialquery name="all">
+    <querytext>
+      and 1=1
+    </querytext>
+  </partialquery>
+
+  <fullquery name="orders_select">      
+    <querytext>
+      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, ec_items i, cc_users u
+      where o.order_id=i.order_id
+      and 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
+    </querytext>
+  </fullquery>
+
 </queryset>