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.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time-oracle.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time-oracle.xql	23 Jul 2001 05:40:41 -0000	1.2
@@ -3,6 +3,27 @@
 <queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
+<partialquery name="last_24">
+      <querytext>
+      and sysdate-o.confirmed_date <= 1
+      </querytext>
+</partialquery>
+
+
+<partialquery name="last_week">
+      <querytext>
+      and sysdate-o.confirmed_date <= 7
+      </querytext>
+</partialquery>
+
+
+<partialquery name="last_month">
+      <querytext>
+      and months_between(sysdate,o.confirmed_date) <= 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