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 @@