Changeset 226

Timestamp:

2007/02/09 20:03:45 (16 years ago)

Author:

kakinaka

Message:

 

File:

• branches/dev/data/class/SC_SelectSql.php (modified) (2 diffs)

branches/dev/data/class/SC_SelectSql.php

@@ -77 +77 @@
         
         // TO
-        $date2 = $to_year . "/" . $to_month . "/" . $to_day;
+        $date2 = mktime (0, 0, 0, $to_month, $to_day,  $to_year);
+        $date2 = $date2 + 86400;
+        $date2 = date('y/m/d', $date2);
         
         // ³«»Ï´ü´Ö¤À¤±»ØÄê¤Î¾ì¹ç
@@ -84 +86 @@
         }
 
-        //¡¡³«»Ï¢·½ªÎ»
+        //¡¡³«»Ï¡Á½ªÎ»
         if( ( $from_year != "" ) && ( $from_month != "" ) && ( $from_day != "" ) && 
             ( $to_year != "" ) && ( $to_month != "" ) && ( $to_day != "" ) ) {
-            $this->setWhere( $column ." >= '" . $date1 ."' AND ". $column . " < date('" . $date2 . "')+1" );
+            $this->setWhere( $column ." >= '" . $date1 ."' AND ". $column . " < date('" . $date2 . "')" );
         }
 
         // ½ªÎ»´ü´Ö¤À¤±»ØÄê¤Î¾ì¹ç
         if( ( $from_year == "" ) && ( $from_month == "" ) && ( $from_day == "" ) && ( $to_year != "" ) && ( $to_month != "" ) && ( $to_day != "" ) ) {
-            $this->setWhere( $column ." < date('" . $date2 . "')+1");
+            $this->setWhere( $column ." < date('" . $date2 . "')");
         }
         return $return;