Changeset 3556 for temp/trunk/html/admin/total/index.php

Timestamp:

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

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/total/index.php (modified) (3 diffs)

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();