Ignore:
Timestamp:
2011/09/27 01:04:48 (9 years ago)
Author:
tao
Message:

#1248 会員情報の受注を更新する様に修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_11-dev/data/class/SC_Customer.php

    r21118 r21259  
    300300        } 
    301301    } 
     302     
     303    //受注関連の顧客情報を更新 
     304    function updateOrderSummary($customer_id){ 
     305        $objQuery = new SC_Query_Ex(); 
     306        $arrOrderSummary =  $objQuery->getRow("SUM( payment_total ) as buy_total, COUNT(order_id) as buy_times,MAX( create_date ) as last_buy_date, MIN(create_date) as first_buy_date","dtb_order","customer_id = ? AND del_flg = 0 AND status <> ?",array($customer_id,ORDER_CANCEL)); 
     307        $objQuery->update("dtb_customer",$arrOrderSummary,"customer_id = ?",array($customer_id)); 
     308    } 
    302309} 
    303310?> 
Note: See TracChangeset for help on using the changeset viewer.