Changeset 11982 for branches/comu/html/admin/batch

Timestamp:

2007/03/28 13:01:38 (20 years ago)

Author:

uehara

Message:

 

File:

• branches/comu/html/admin/batch/daily.php (modified) (3 diffs)

branches/comu/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 T1.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()); 
@@ -259 +259 @@
     /* Èó²ñ°÷½¸·× */
     
-    $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;
     $where = $base_where . " AND (to_number(to_char(age(current_timestamp, order_birth), 'YYY'), 999) BETWEEN ? AND ?) ";