Changeset 380 for branches/dev

Timestamp:

2007/02/26 21:30:18 (19 years ago)

Author:

kakinaka

Message:

 

File:

• branches/dev/html/admin/home.php (modified) (3 diffs)

branches/dev/html/admin/home.php

@@ -85 +85 @@
         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')";
+                     WHERE del_flg = 0 AND to_char(create_date,'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD') AND status <> " . ORDER_CANCEL;
         }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)";
+                     WHERE del_flg = 0 AND cast(substring(create_date,1, 10) as date) = DATE_ADD(current_date, interval -1 day) AND status <> " . ORDER_CANCEL;
         }
         $return = $conn->getOne($sql);
@@ -104 +104 @@
         $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 to_char(create_date,'YYYY/MM/DD') <> to_char(now(),'YYYY/MM/DD') AND status <> " . ORDER_CANCEL;
     }else if (DB_TYPE == "mysql") {
         $sql = "SELECT ".$method."(total) FROM dtb_order
                  WHERE del_flg = 0 AND date_format(create_date, '%Y/%m') = ? 
-                 AND date_format(create_date, '%Y/%m/%d') <> date_format(now(), '%Y/%m/%d')";
+                 AND date_format(create_date, '%Y/%m/%d') <> date_format(now(), '%Y/%m/%d') AND status <> " . ORDER_CANCEL;
     }
         $return = $conn->getOne($sql, array($month));
@@ -189 +189 @@
                     dtb_order AS ord
                 WHERE
-                    del_flg = 0
+                    del_flg = 0 AND status <> " . ORDER_CANCEL . " 
                 ORDER BY
                     create_date DESC LIMIT 10 OFFSET 0