Changeset 4722 for temp/trunk

Timestamp:

2006/09/14 14:37:52 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/home.php (modified) (1 diff)

temp/trunk/html/admin/home.php

@@ -84 +84 @@
     
     if ( $method == 'SUM' or $method == 'COUNT'){
+    // postgresql ¤È mysql ¤È¤ÇSQL¤ò¤ï¤±¤ë
+    if (DB_TYPE == "pgsql") {
+        $sql = "SELECT ".$method."(total) FROM dtb_order
+                 WHERE del_flg = 0 AND to_char(create_date,'YYYY/MM') = ? 
+                 AND to_char(create_date,'YYYY/MM/DD') <> to_char(now(),'YYYY/MM/DD')";
+    }else if (DB_TYPE == "mysql") {
         $sql = "SELECT ".$method."(total) FROM dtb_order
                  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));
     }