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