Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/ecommerce/www/admin/orders/by-state-and-time-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/ecommerce/www/admin/orders/by-state-and-time-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/ecommerce/www/admin/orders/by-state-and-time.tcl'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/ecommerce/www/admin/orders/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/index.tcl,v
diff -u -r1.5 -r1.5.2.1
--- openacs-4/packages/ecommerce/www/admin/orders/index.tcl	9 Mar 2004 00:59:50 -0000	1.5
+++ openacs-4/packages/ecommerce/www/admin/orders/index.tcl	9 Feb 2005 10:06:32 -0000	1.5.2.1
@@ -26,6 +26,10 @@
     select sum(one_if_within_n_days(confirmed_date,1)) as n_o_in_last_24_hours, sum(one_if_within_n_days(confirmed_date,7)) as n_o_in_last_7_days
     from ec_orders_reportable"
 
+db_1row recent_baskets_select "
+    select sum(one_if_within_n_days(in_basket_date,1)) as s_b_in_last_24_hours, sum(one_if_within_n_days(in_basket_date,7)) as s_b_in_last_7_days
+    from ec_orders"
+
 db_1row recent_gift_certificates_purchased_select "
     select sum(one_if_within_n_days(issue_date,1)) as n_g_in_last_24_hours, sum(one_if_within_n_days(issue_date,7)) as n_g_in_last_7_days
     from ec_gift_certificates_purchased"
@@ -46,6 +50,8 @@
     <ul>
       <li><p><a href=\"by-order-state-and-time\">Orders</a> 
         <font size=-1>($n_o_in_last_24_hours in last 24 hours; $n_o_in_last_7_days in last 7 days)</font></p></li>
+      <li><p><a href=\"by-state-and-time\">Shopping Basket Activity</a>
+        <font size=-1>($s_b_in_last_24_hours in last 24 hours; $s_b_in_last_7_days in last 7 days)</font></p></li>
       <li><p><a href=\"fulfillment\">Order Fulfillment</a> 
         <font size=-1>"
 
Index: openacs-4/packages/ecommerce/www/admin/orders/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/index.xql,v
diff -u -r1.4 -r1.4.8.1
--- openacs-4/packages/ecommerce/www/admin/orders/index.xql	13 Sep 2002 00:42:09 -0000	1.4
+++ openacs-4/packages/ecommerce/www/admin/orders/index.xql	9 Feb 2005 10:06:32 -0000	1.4.8.1
@@ -10,6 +10,15 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="recent_baskets_select">      
+    <querytext>
+      select 
+      	sum(one_if_within_n_days(in_basket_date,1)) as s_b_in_last_24_hours,
+      	sum(one_if_within_n_days(in_basket_date,7)) as s_b_in_last_7_days
+      from ec_orders
+    </querytext>
+  </fullquery>
+
   <fullquery name="recent_gift_certificates_purchased_select">      
     <querytext>
       select