Changeset 4721 for temp/trunk

Timestamp:

2006/09/14 14:33:42 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/conf/core.php (modified) (1 diff)
• html/admin/home.php (modified) (1 diff)

temp/trunk/data/conf/core.php

@@ -31 +31 @@
 // ¥µ¥¤¥ÈÍÑDB
 define("DB_TYPE", "pgsql");
-define("DB_SERVER", "test.ec-cube.net");
+//define("DB_SERVER", "test.ec-cube.net");
 define ("DEFAULT_DSN", DB_TYPE . "://" . DB_USER . ":" . DB_PASSWORD . "@" . DB_SERVER . "/" . DB_NAME);
 

temp/trunk/html/admin/home.php

@@ -85 +85 @@
     if ( $method == 'SUM' or $method == 'COUNT'){
         $sql = "SELECT ".$method."(total) FROM dtb_order
-                 WHERE del_flg = 0 AND cast(substring(create_date,1,6) as date) = ? 
+                 WHERE del_flg = 0 AND cast(substring(create_date,1,7) as date) = ? 
                  AND cast(substring(create_date,1, 10) as date) <> cast(substring(now(),1, 10) as date)";
         $return = $conn->getOne($sql, array($month));