Changeset 4608 for temp/trunk/html/admin/batch

Timestamp:

2006/09/11 19:37:56 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/batch/daily.php (modified) (5 diffs)

temp/trunk/html/admin/batch/daily.php

@@ -36 +36 @@
     // ºï½ü¤µ¤ì¤¿¼õÃí¥Ç¡¼¥¿¤Î¼õÃí¾ÜºÙ¾ðÊó¤Îºï½ü
     $objQuery = new SC_Query();
-    $where = "order_id IN (SELECT order_id FROM dtb_order WHERE delete = 1)";
+    $where = "order_id IN (SELECT order_id FROM dtb_order WHERE del_flg = 1)";
     $objQuery->delete("dtb_order_detail", $where);
     
@@ -112 +112 @@
     $sql.= "int8(AVG(total)) AS total_average ";
     $sql.= "FROM dtb_order AS T1 LEFT JOIN dtb_customer AS T2 USING ( customer_id ) ";
-    $sql.= "WHERE T1.delete = 0 AND T1.create_date BETWEEN ? AND ?";        // ¼õÃíºîÀ®Æü¤Ç¸¡º÷¤¹¤ë
+    $sql.= "WHERE T1.del_flg = 0 AND T1.create_date BETWEEN ? AND ?";       // ¼õÃíºîÀ®Æü¤Ç¸¡º÷¤¹¤ë
     return $sql;
 }
@@ -204 +204 @@
     /* ²ñ°÷½¸·× */
     
-    $base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id <> 0 AND delete = 0 ";
+    $base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id <> 0 AND del_flg = 0 ";
     $where = $base_where . " AND (to_number(to_char(age(current_timestamp, order_birth), 'YYY'), 999) BETWEEN ? AND ?) ";
     
@@ -223 +223 @@
     /* Èó²ñ°÷½¸·× */
     
-    $base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id = 0 AND delete = 0";
+    $base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id = 0 AND del_flg = 0";
     $where = $base_where . " AND (to_number(to_char(age(current_timestamp, order_birth), 'YYY'), 999) BETWEEN ? AND ?) ";
     
@@ -237 +237 @@
     
     // ÃÂÀ¸ÆüÆþÎϤʤ·
-    $where = $base_where . " AND order_birth IS NULL AND delete = 0";
+    $where = $base_where . " AND order_birth IS NULL AND del_flg = 0";
     lfBatOrderAgeSub($sql . $where, $start, $end, NULL, NULL, 0);   
 }