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

Timestamp:

2006/08/31 20:30:10 (20 years ago)

Author:

kakinaka

Message:

blank

File:

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

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

@@ -108 +108 @@
     $sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 2 AND customer_id = 0)) AS women_nonmember, ";
     $sql.= "SUM(total) AS total, ";
-    $sql.= "int4(AVG(total)) AS total_average ";
+    $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 ?";        // ¼õÃíºîÀ®Æü¤Ç¸¡º÷¤¹¤ë
@@ -188 +188 @@
     
     // ǯÎð¤ÎÈϰϤò»ØÄꤷ¤Æ¥Ç¡¼¥¿Ãê½Ð
-    $sql.= "SELECT COUNT(*) AS order_count, SUM(total) AS total, int4(AVG(total)) AS total_average ";
+    $sql.= "SELECT COUNT(*) AS order_count, SUM(total) AS total, int8(AVG(total)) AS total_average ";
     $sql.= "FROM dtb_order ";