Changeset 6977 for temp/trunk/html/admin

Timestamp:

2006/10/27 18:22:48 (20 years ago)

Author:

kakinaka

Message:

* empty log message *

File:

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

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

@@ -239 +239 @@
     // ǯÎðËè¤Ë½¸·×¤¹¤ë¡£
     for($i = 0; $i <= $age_loop; $i++) {
-        $start_age = $i * 10;
-        $where = $base_where . " AND order_birth >= cast('$start_date' as date) -interval " . lfSingleQuot("$start_age year");
-        if($i < $age_loop) {
-            $end_age = $start_age+9;
-            $where = $where . " AND order_birth < cast('$end_date' as date) -interval " . lfSingleQuot("$start_age year");
-        }else{
-            $where = $base_where . " AND order_birth < cast('$end_date' as date) -interval " . lfSingleQuot("$start_age year");
-            $end_age = 999;
-        }
-        lfBatOrderAgeSub($sql . $where, $start, $end, $start_age, $end_age, 1);
-    }
-
+        $where = $base_where . " AND order_birth >= cast('$start_date' as date)";
+        $start_age = $i * 10;
+        if($i < $age_loop) {
+            $end_age = $start_age+9;
+            $where = $where . " AND order_birth < cast('$end_date' as date)";
+        }else{
+            $where = $base_where . " AND order_birth < cast('$end_date' as date)";
+            $end_age = 999;
+        }
+        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($start_date)));
+    }
+    
     // ÃÂÀ¸ÆüÆþÎϤʤ·
     $where = $base_where . " AND order_birth IS NULL ";
@@ -265 +267 @@
     // ǯÎðËè¤Ë½¸·×¤¹¤ë¡£
     for($i = 0; $i <= $age_loop; $i++) {
-        $start_age = $i * 10;
-        $where = $base_where . " AND order_birth >= cast('$start_date' as date) -interval " . lfSingleQuot("$start_age year");
-        if($i < $age_loop) {
-            $end_age = $start_age+9;
-            $where = $where . " AND order_birth < cast('$end_date' as date) -interval " . lfSingleQuot("$start_age year");
-        }else{
-            $where = $base_where . " AND order_birth < cast('$end_date' as date) -interval " . lfSingleQuot("$start_age year");
-            $end_age = 999;
-        }
-        lfBatOrderAgeSub($sql . $where, $start, $end, $start_age, $end_age, 0);
-    }
-
+        $where = $base_where . " AND order_birth >= cast('$start_date' as date)";
+        $start_age = $i * 10;
+        if($i < $age_loop) {
+            $end_age = $start_age+9;
+            $where = $where . " AND order_birth < cast('$end_date' as date)";
+        }else{
+            $where = $base_where . " AND order_birth < cast('$end_date' as date)";
+            $end_age = 999;
+        }
+        lfBatOrderAgeSub($sql . $where, $start, $end, $start_age, $end_age, 0);
+        $end_date = date("Y/m/d",strtotime("1 day" ,strtotime($start_date)));
+        $start_date = date("Y/m/d",strtotime("-10 year",strtotime($start_date)));
+    }
+    
     // ÃÂÀ¸ÆüÆþÎϤʤ·
     $where = $base_where . " AND order_birth IS NULL AND del_flg = 0";