Changeset 4844 for temp

Timestamp:

2006/09/17 13:24:53 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/total/index.php (modified) (1 diff)

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

@@ -614 +614 @@
     list($where, $arrval) = lfGetWhereMember('T2.create_date', $sdate, $edate, $type);
     
-    $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, int8(AVG(total)) AS total_average ";
+    $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average ";
     $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0 ";
     $sql.= "GROUP BY job ORDER BY total DESC";