$where .= " AND del_flg = 0 AND status <> " . ORDER_CANCEL;

/** 新規注文 */
define('ORDER_NEW', 1);
/** 入金待ち */
define('ORDER_PAY_WAIT', 2);
/** 入金済み */
define('ORDER_PRE_END', 6);
/** キャンセル */
define('ORDER_CANCEL', 3);
/** 取り寄せ中 */
define('ORDER_BACK_ORDER', 4);
/** 発送済み */
define('ORDER_DELIV', 5);
/** 決済処理中 */
define('ORDER_PENDING', 7);

$where .= " AND dtb_order.del_flg = 0 AND dtb_order.status <> " . ORDER_CANCEL . " AND dtb_order.status <> " . ORDER_NEW . " AND dtb_order.status <> " . ORDER_PENDING . " AND dtb_order.status <> " . ORDER_PAY_WAIT;

    function getOrderYesterdaySql($method) {
        return "SELECT ".$method."(total) FROM dtb_order "
              . "WHERE del_flg = 0 "
                . "AND cast(create_date as date) = DATE_ADD(current_date, interval -1 day) "
                . "AND status <> " . ORDER_CANCEL
                . " AND status <> " . ORDER_NEW
                . " AND status <> " . ORDER_PENDING
                . " AND status <> " . ORDER_PAY_WAIT;
    }