Changeset 1941 for temp/trunk

Timestamp:

2006/08/25 13:37:46 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/class/SC_SelectSql.php (modified) (3 diffs)

temp/trunk/data/class/SC_SelectSql.php

@@ -73 +73 @@
         $date1 = $from_year . "/" . $from_month . "/" . $from_day;
         
-        // TO(TO¤Ï+1Æü)
-        $date2 = date("Y/m/d", strtotime(date('Y/m/d', $date1 . " + day"));
+        // TO
+        $date2 = $to_month . "/" . $to_day . "/" . $to_year;
         
         sfprintr($date2);
@@ -86 +86 @@
         if( ( $from_year != "" ) && ( $from_month != "" ) && ( $from_day != "" ) && 
             ( $to_year != "" ) && ( $to_month != "" ) && ( $to_day != "" ) ) {
-            $this->setWhere( $column ." >= ? AND ". $column . " < ?" );
+            $this->setWhere( $column ." >= " . $date1 ." AND ". $column . " < date(" . $date2 . ")+1" );
             $return = array($date1, $date2);
         }
@@ -92 +92 @@
         // ½ªÎ»´ü´Ö¤À¤±»ØÄê¤Î¾ì¹ç
         if( ( $from_year == "" ) && ( $from_month == "" ) && ( $from_day == "" ) && ( $to_year != "" ) && ( $to_month != "" ) && ( $to_day != "" ) ) {
-            $this->setWhere( $column ." < ?" );
-            $return = array($date2);
+            $this->setWhere( $column ." < date(" . $date2 . ")+1");
         }
         return $return;