Changeset 1884

Timestamp:

2006/08/24 22:01:22 (18 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/class/SC_SelectSql.php (modified) (2 diffs)
• html/admin/customer/index.php (modified) (1 diff)

temp/trunk/data/class/SC_SelectSql.php

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

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

@@ -97 +97 @@
 // POSTÃͤΰú¤­·Ñ¤®
 $objPage->arrForm = $_POST;
-
-sfprintr($_POST);
 
 // ¥Ú¡¼¥¸Á÷¤êÍÑ