Changeset 4666 for temp/trunk/html/admin/home.php

Timestamp:

2006/09/13 10:46:43 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/home.php (modified) (3 diffs)

temp/trunk/html/admin/home.php

@@ -66 +66 @@
 function lfGetOrderYesterday($conn, $method){
     if ( $method == 'SUM' or $method == 'COUNT'){
-        $sql = "SELECT ".$method."(total) FROM dtb_order
-                 WHERE del_flg = 0 AND to_char(create_date,'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')";
+        // 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/DD') = to_char(now() - interval '1 days','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, 10) as date) = DATE_ADD(current_date, interval -1 day)";
+        }
         $return = $conn->getOne($sql);
     }
@@ -80 +86 @@
         $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')";
+                 AND cast(substring(create_date,1, 10) as date) <> cast(substring(now(),1, 10) as date)";
         $return = $conn->getOne($sql, array($month));
     }
@@ -96 +102 @@
 
 function lfGetReviewYesterday($conn){
-    $sql = "SELECT COUNT (*) FROM dtb_review 
-             WHERE del_flg=0 AND to_char(create_date, 'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')
-             AND to_char(create_date,'YYYY/MM/DD') != to_char(now(),'YYYY/MM/DD')";
+    // postgresql ¤È mysql ¤È¤ÇSQL¤ò¤ï¤±¤ë
+    if (DB_TYPE == "pgsql") {
+        $sql = "SELECT COUNT (*) FROM dtb_review 
+                 WHERE del_flg=0 AND to_char(create_date, 'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')
+                 AND to_char(create_date,'YYYY/MM/DD') != to_char(now(),'YYYY/MM/DD')";
+    }else if (DB_TYPE == "mysql") {
+        $sql = "SELECT COUNT (*) FROM dtb_review 
+                 WHERE del_flg = 0 AND cast(substring(create_date,1, 10) as date) = DATE_ADD(current_date, interval -1 day)
+                 AND cast(substring(create_date,1, 10) as date) != cast(substring(now(),1, 10) as date)";
+    }
     $return = $conn->getOne($sql);
     return $return;