Changeset 384

Timestamp:

2007/02/27 12:06:26 (17 years ago)

Author:

kakinaka

Message:

 

File:

• branches/dev/html/admin/batch/daily.php (modified) (2 diffs)

branches/dev/html/admin/batch/daily.php

@@ -107 +107 @@
 function lfGetOrderDailySQL($start, $end) {
     $from = " FROM dtb_order AS T1 LEFT JOIN dtb_customer AS T2 USING ( customer_id ) ";
-    $where = " WHERE T1.del_flg = 0 AND T1.create_date BETWEEN '$start' AND '$end' ";
+    $where = " WHERE T1.del_flg = 0 AND status <> " . ORDER_CANCEL . "AND T1.create_date BETWEEN '$start' AND '$end' ";
 
 /*  mysql¤Ç¤âÌäÂê¤Ê¤¤¤è¤¦¤Ë½¤Àµ
@@ -232 +232 @@
     /* ²ñ°÷½¸·× */
 
-    $base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id <> 0 AND del_flg = 0 ";
+    $base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id <> 0 AND del_flg = 0 AND status <> " . ORDER_CANCEL;
 
     $end_date = date("Y/m/d", time());