Changeset 4833 for temp/trunk/html/admin/batch

Timestamp:

2006/09/17 12:54:00 (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

@@ -226 +226 @@
     $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 ?) ";
-    $where = $base_where . " AND order_birth BETWEEN ? AND ? ";
-    
-    sfprintr(   date("Y/m/d",strtotime(time())));
-    
+    //$where = $base_where . " AND order_birth BETWEEN ? AND ? ";
     
     $end_date = date("Y/m/d",strtotime("-10 year"));
     $start_date = date("Y/m/d",strtotime("1 day" ,strtotime($end_date)));
     
-    
     $end_date = date("Y/m/d H:i:s", time()); 
     $start_date = date("Y/m/d",strtotime("-10 year"));
+    
+    sfprintr($start_date);
+    // ǯÎðËè¤Ë½¸·×¤¹¤ë¡£
+    for($i = 0; $i <= $age_loop; $i++) {
+        $where = $base_where . " AND order_birth >= $start_date";
+        if($i <= $age_loop) {
+            $where = $where . " AND order_birth <= $end_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++) {
+        $start_age = $i * 10;
+        $end_age = $start_age + 9;
+        if($i >= $age_loop) {
+            $end_age = 999;
+        }
+        lfBatOrderAgeSub($sql . $where, $start, $end, $start_age, $end_age, 1);
+    }
+*/
+
+    // ÃÂÀ¸ÆüÆþÎϤʤ·
+    $where = $base_where . " AND order_birth IS NULL ";
+    lfBatOrderAgeSub($sql . $where, $start, $end, NULL, NULL, 1);
+
+    /* Èó²ñ°÷½¸·× */
+    
+    $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 ?) ";
     
     // ǯÎðËè¤Ë½¸·×¤¹¤ë¡£
@@ -245 +272 @@
             $end_age = 999;
         }
-        lfBatOrderAgeSub($sql . $where, $start, $end, $start_age, $end_age, 1);
-    }
-
-    // ÃÂÀ¸ÆüÆþÎϤʤ·
-    $where = $base_where . " AND order_birth IS NULL ";
-    lfBatOrderAgeSub($sql . $where, $start, $end, NULL, NULL, 1);
-
-    /* Èó²ñ°÷½¸·× */
-    
-    $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 ?) ";
-    
-    // ǯÎðËè¤Ë½¸·×¤¹¤ë¡£
-    for($i = 0; $i <= $age_loop; $i++) {
-        $start_age = $i * 10;
-        $end_age = $start_age + 9;
-        if($i >= $age_loop) {
-            $end_age = 999;
-        }
         lfBatOrderAgeSub($sql . $where, $start, $end, $start_age, $end_age, 0);
     }