Changeset 6973

Timestamp:

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

Author:

kakinaka

Message:

* empty log message *

Location:

temp/trunk/html/admin

Files:

• batch/daily.php (modified) (3 diffs)
• total/index.php (modified) (1 diff)

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

@@ -256 +256 @@
     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";
+        $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 '$start_age' year";
+            $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 '$start_age' year";
+            $where = $base_where . " AND order_birth < cast('$end_date' as date) -interval " . lfSingleQuot("$start_age year");
             $end_age = 999;
         }
@@ -298 +298 @@
     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";
+        $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 '$start_age' year";
+            $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 '$start_age' year";
+            $where = $base_where . " AND order_birth < cast('$end_date' as date) -interval " . lfSingleQuot("$start_age year");
             $end_age = 999;
         }
@@ -339 +339 @@
 }
 
+// ʸ»úÎó¤ËSingleQuotation¤òÉÕÍ¿¤¹¤ë
+function lfSingleQuot($value){
+    $ret = "";
+    if (DB_TYPE == "MySQL") {
+        $ret = $value;
+    }else{
+        $ret = "'" . $value . "'";
+    } 
+    return $ret;
+}
+
 ?>

temp/trunk/html/admin/total/index.php

@@ -682 +682 @@
     }
     
-    sfprintr($objPage->arrResults );
-    
     return $objPage;
 }