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

Timestamp:

2006/09/16 21:14:08 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/batch/daily.php (modified) (1 diff)

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

@@ -100 +100 @@
 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.create_date BETWEEN '$start' AND '$end' ";
     
     $sql = "SELECT ";
     $sql.= "COUNT(*) AS total_order, ";
-    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt FROM $from WHERE $where AND customer_id = 0) AS nonmember ) AS nonmember, ";
+    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND customer_id = 0) AS nonmember ) AS nonmember, ";
 /*  $sql.= "SUM((SELECT COUNT(*) WHERE customer_id <> 0 GROUP BY customer_id)) AS member, ";
     $sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 1)) AS men, ";