Changeset 13415


Ignore:
Timestamp:
2007/05/25 10:40:53 (17 years ago)
Author:
kakinaka
Message:
 
File:
1 edited

Legend:

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

    r13414 r13415  
    659659     
    660660    $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average "; 
    661     $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0"; 
     661    $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; 
    662662    $sql.= "GROUP BY job ORDER BY total DESC"; 
    663663     
    664664    $objQuery = new SC_Query(); 
    665665    $objPage->arrResults = $objQuery->getall($sql, $arrval); 
     666     
     667     
     668    sfprintr($objQuery->getlastquery(false)); 
    666669             
    667670    $max = count($objPage->arrResults); 
Note: See TracChangeset for help on using the changeset viewer.