Changeset 4841 for temp

Timestamp:

2006/09/17 13:07:16 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/batch/daily.php (modified) (2 diffs)

temp/trunk/html/admin/batch/daily.php

@@ -235 +235 @@
     $start_age = null;
     $end_age = null;
-    
     // ǯÎðËè¤Ë½¸·×¤¹¤ë¡£
     for($i = 0; $i <= $age_loop; $i++) {
@@ -265 +264 @@
     $base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id = 0 AND del_flg = 0";
     $where = $base_where . " AND (to_number(to_char(age(current_timestamp, order_birth), 'YYY'), 999) BETWEEN ? AND ?) ";
-    
+
+    
+    $end_date = date("Y/m/d", time()); 
+    $start_date = date("Y/m/d",strtotime("-10 year"));
+    $start_age = null;
+    $end_age = null;
     // ǯÎðËè¤Ë½¸·×¤¹¤ë¡£
+    for($i = 0; $i <= $age_loop; $i++) {
+        $where = $base_where . " AND order_birth >= cast('$start_date' as date)";
+        if($i <= $age_loop) {
+            $where = $where . " AND order_birth <= cast('$end_date' as date)";
+        }
+        lfBatOrderAgeSub($sql . $where, $start, $end, $start_age, $end_age, 1);
+        $end_date = date("Y/m/d",strtotime("1 day" ,strtotime($start_date)));
+        $start_date = date("Y/m/d",strtotime("-10 year",strtotime($end_date)));
+    }
+
 /*
     for($i = 0; $i <= $age_loop; $i++) {