Changeset 3556 for temp/trunk/html/admin

Timestamp:

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

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html/admin

Files:

• batch/daily.php (modified) (2 diffs)
• total/index.php (modified) (3 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 ";
     

temp/trunk/html/admin/total/index.php

@@ -553 +553 @@
     
     // ²ñ°÷½¸·×¤Î¼èÆÀ
-    $col = "COUNT(*) AS order_count, SUM(total) AS total, int4(AVG(total)) AS total_average, order_sex";
+    $col = "COUNT(*) AS order_count, SUM(total) AS total, int8(AVG(total)) AS total_average, order_sex";
     $from = "dtb_order";
     $objQuery = new SC_Query();
@@ -625 +625 @@
     list($where, $arrval) = lfGetWhereMember('T2.create_date', $sdate, $edate, $type);
     
-    $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, int4(AVG(total)) AS total_average ";
+    $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, int8(AVG(total)) AS total_average ";
     $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.delete = 0";
     $sql.= "GROUP BY job ORDER BY total DESC";
@@ -698 +698 @@
         $tmp_col.= "sum(men_member) as men_member, sum(men_nonmember) as men_nonmember,";
         $tmp_col.= "sum(women_member) as women_member, sum(women_nonmember) as women_nonmember,";
-        $tmp_col.= "sum(total) as total, int4(avg(total_average)) as total_average";
+        $tmp_col.= "sum(total) as total, int8(avg(total_average)) as total_average";
         $objQuery = new SC_Query();