Changeset 8326 for temp/trunk/html/admin

Timestamp:

2006/11/14 13:34:41 (20 years ago)

Author:

uehara

Message:

* empty log message *

File:

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

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

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