Changeset 384


Ignore:
Timestamp:
2007/02/27 12:06:26 (15 years ago)
Author:
kakinaka
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/dev/html/admin/batch/daily.php

    r155 r384  
    107107function lfGetOrderDailySQL($start, $end) { 
    108108    $from = " FROM dtb_order AS T1 LEFT JOIN dtb_customer AS T2 USING ( customer_id ) "; 
    109     $where = " WHERE T1.del_flg = 0 AND T1.create_date BETWEEN '$start' AND '$end' "; 
     109    $where = " WHERE T1.del_flg = 0 AND status <> " . ORDER_CANCEL . "AND T1.create_date BETWEEN '$start' AND '$end' "; 
    110110 
    111111/*  mysql¤Ç¤âÌäÂê¤Ê¤¤¤è¤¦¤Ë½¤Àµ 
     
    232232    /* ²ñ°÷½¸·× */ 
    233233 
    234     $base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id <> 0 AND del_flg = 0 "; 
     234    $base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id <> 0 AND del_flg = 0 AND status <> " . ORDER_CANCEL; 
    235235 
    236236    $end_date = date("Y/m/d", time());  
Note: See TracChangeset for help on using the changeset viewer.