Index: openacs-4/packages/ecommerce/www/admin/orders/refunds-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/refunds-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/admin/orders/refunds-oracle.xql	23 Jul 2001 06:02:16 -0000	1.1
@@ -0,0 +1,26 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<partialquery name="last_24">
+      <querytext>
+      and sysdate-r.refund_date <= 1
+      </querytext>
+</partialquery>
+
+
+<partialquery name="last_week">
+      <querytext>
+      and sysdate-r.refund_date <= 7
+      </querytext>
+</partialquery>
+
+
+<partialquery name="last_month">
+      <querytext>
+      and months_between(sysdate,r.refund_date) <= 1
+      </querytext>
+</partialquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/admin/orders/refunds-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/refunds-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/admin/orders/refunds-postgresql.xql	23 Jul 2001 06:02:16 -0000	1.1
@@ -0,0 +1,26 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<partialquery name="last_24">
+      <querytext>
+      and now()-r.refund_date <= timespan_days(1)
+      </querytext>
+</partialquery>
+
+
+<partialquery name="last_week">
+      <querytext>
+      and now()-r.refund_date <= timespan_days(7)
+      </querytext>
+</partialquery>
+
+
+<partialquery name="last_month">
+      <querytext>
+      and now()-r.refund_date <= '1 month'::interval
+      </querytext>
+</partialquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/admin/orders/refunds.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/refunds.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/orders/refunds.tcl	20 Apr 2001 20:51:14 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/orders/refunds.tcl	23 Jul 2001 06:02:16 -0000	1.2
@@ -50,11 +50,14 @@
 "
 
 if { $view_refund_date == "last_24" } {
-    set refund_date_query_bit "and sysdate-r.refund_date <= 1"
+    #set refund_date_query_bit "and sysdate-r.refund_date <= 1"
+    set refund_date_query_bit [db_map last_24]
 } elseif { $view_refund_date == "last_week" } {
-    set refund_date_query_bit "and sysdate-r.refund_date <= 7"
+    #set refund_date_query_bit "and sysdate-r.refund_date <= 7"
+    set refund_date_query_bit [db_map last_week]
 } elseif { $view_refund_date == "last_month" } {
-    set refund_date_query_bit "and months_between(sysdate,r.refund_date) <= 1"
+    #set refund_date_query_bit "and months_between(sysdate,r.refund_date) <= 1"
+    set refund_date_query_bit [db_map last_month]
 } else {
     set refund_date_query_bit ""
 }