Changeset 13426 for branches/rel


Ignore:
Timestamp:
2007/05/25 10:56:40 (15 years ago)
Author:
kakinaka
Message:

職業別集計にキャンセル商品は含まないように修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/rel/html/admin/total/index.php

    r13354 r13426  
    653653     
    654654    $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average "; 
    655     $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0 "; 
     655    $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; 
    656656    $sql.= "GROUP BY job ORDER BY total DESC"; 
    657657     
Note: See TracChangeset for help on using the changeset viewer.