Changeset 17568 for branches/comu-ver2/data/class/pages/admin/total

Timestamp:

2008/08/28 09:33:38 (18 years ago)

Author:

Seasoft

Message:

merge 17212,17213,17214,17216,17218,17219,17220

File:

• branches/comu-ver2/data/class/pages/admin/total/LC_Page_Admin_Total.php (modified) (2 diffs, 1 prop)

branches/comu-ver2/data/class/pages/admin/total/LC_Page_Admin_Total.php

@@ -638 +638 @@
 
         // 会員集計の取得
-        $col = "COUNT(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average, order_sex";
+        $col = "COUNT(*) AS order_count, SUM(total) AS total, trunc(AVG(total)) AS total_average, order_sex";
         $from = "dtb_order";
         $objQuery = new SC_Query();
@@ -704 +704 @@
     /** 職業別集計 **/
     function lfGetOrderJob($type, $sdate, $edate, &$objPage, $graph = true) {
-        global $arrJob;
-
         list($where, $arrval) = $this->lfGetWhereMember('T2.create_date', $sdate, $edate, $type);
 
-        $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average ";
+        $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, trunc(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 and T2.status <> " . ORDER_CANCEL;
         $sql.= " GROUP BY job ORDER BY total DESC";