Index: openacs-4/packages/ecommerce/www/admin/customer-service/customer-search-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/customer-search-oracle.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/admin/customer-service/customer-search-oracle.xql 26 Aug 2001 23:46:28 -0000 1.1
@@ -0,0 +1,22 @@
+
+
+
+ oracle8.1.6
+
+
+
+
+
+ select unique o.user_id, u.first_names, u.last_name, u.email
+ from ec_orders o, cc_users u
+ where o.user_id=u.user_id
+ and o.order_state not in ('void','in_basket')
+ and sysdate - o.confirmed_date <= :days
+ and :amount <= (select sum(i.price_charged) from ec_items i where i.order_id=o.order_id and (i.item_state is null or i.item_state not in ('void','received_back')))
+
+
+
+
+
+
+
Index: openacs-4/packages/ecommerce/www/admin/customer-service/customer-search-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/customer-search-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/admin/customer-service/customer-search-postgresql.xql 26 Aug 2001 23:46:28 -0000 1.1
@@ -0,0 +1,20 @@
+
+
+
+ postgresql7.1
+
+
+
+
+ select distinct o.user_id, u.first_names, u.last_name, u.email
+ from ec_orders o, cc_users u
+ where o.user_id=u.user_id
+ and o.order_state not in ('void','in_basket')
+ and current_timestamp - o.confirmed_date <= timespan_days(:days)
+ and :amount <= (select sum(i.price_charged) from ec_items i where i.order_id=o.order_id and (i.item_state is null or i.item_state not in ('void','received_back')))
+
+
+
+
+
+
Index: openacs-4/packages/ecommerce/www/admin/customer-service/customer-search.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/customer-search.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/customer-service/customer-search.tcl 20 Apr 2001 20:51:14 -0000 1.1
+++ openacs-4/packages/ecommerce/www/admin/customer-service/customer-search.tcl 26 Aug 2001 23:46:28 -0000 1.2
@@ -53,13 +53,14 @@
-set sql "select unique o.user_id, u.first_names, u.last_name, u.email
-from ec_orders o, cc_users u
-where o.user_id=u.user_id
-and o.order_state not in ('void','in_basket')
-and sysdate - o.confirmed_date <= :days
-and :amount <= (select sum(i.price_charged) from ec_items i where i.order_id=o.order_id and (i.item_state is null or i.item_state not in ('void','received_back')))
-"
+#set sql "select unique o.user_id, u.first_names, u.last_name, u.email
+#from ec_orders o, cc_users u
+#where o.user_id=u.user_id
+#and o.order_state not in ('void','in_basket')
+#and sysdate - o.confirmed_date <= :days
+#and :amount <= (select sum(i.price_charged) from ec_items i where i.order_id=o.order_id and (i.item_state is null or i.item_state not in ('void','received_back')))
+#"
+set sql [db_map user_id_sql]
set user_id_list [list]
db_foreach get_user_ids_from_search $sql {
@@ -84,4 +85,4 @@
db_release_unused_handles
-doc_return 200 text/html $doc_body
\ No newline at end of file
+doc_return 200 text/html $doc_body