미배송건 쿼리 보니 토나오네요.. 흑흑 정보
미배송건 쿼리 보니 토나오네요.. 흑흑본문
count(distinct a.od_id) as ordercount,
count(b.ct_id) as itemcount,
(SUM(b.ct_amount * b.ct_qty) + a.od_send_cost) as orderamount ,
(SUM(IF(b.ct_status = '취소' OR b.ct_status = '반품' OR b.ct_status = '품절', b.ct_amount * b.ct_qty, 0))) as ordercancel,
(a.od_receipt_bank + a.od_receipt_card + a.od_receipt_hp + a.od_receipt_point) as receiptamount,
(a.od_refund_amount + a.od_cancel_card) as receiptcancel,
(
(SUM(b.ct_amount * b.ct_qty) + a.od_send_cost) -
(SUM(IF(b.ct_status = '취소' OR b.ct_status = '반품' OR b.ct_status = '품절', b.ct_amount * b.ct_qty, 0))) -
a.od_dc_amount -
(a.od_receipt_bank + a.od_receipt_card + a.od_receipt_hp + a.od_receipt_point) +
(a.od_refund_amount + a.od_cancel_card)
) as misu ");
>>
미배송건 쿼리 보니 토나오네요.. 흑흑
취소한것도 미배송에 나오는데요 안나오게 할려면 어떻게 하면 좋을까요??
count(b.ct_id) as itemcount,
(SUM(b.ct_amount * b.ct_qty) + a.od_send_cost) as orderamount ,
(SUM(IF(b.ct_status = '취소' OR b.ct_status = '반품' OR b.ct_status = '품절', b.ct_amount * b.ct_qty, 0))) as ordercancel,
(a.od_receipt_bank + a.od_receipt_card + a.od_receipt_hp + a.od_receipt_point) as receiptamount,
(a.od_refund_amount + a.od_cancel_card) as receiptcancel,
(
(SUM(b.ct_amount * b.ct_qty) + a.od_send_cost) -
(SUM(IF(b.ct_status = '취소' OR b.ct_status = '반품' OR b.ct_status = '품절', b.ct_amount * b.ct_qty, 0))) -
a.od_dc_amount -
(a.od_receipt_bank + a.od_receipt_card + a.od_receipt_hp + a.od_receipt_point) +
(a.od_refund_amount + a.od_cancel_card)
) as misu ");
>>
미배송건 쿼리 보니 토나오네요.. 흑흑
취소한것도 미배송에 나오는데요 안나오게 할려면 어떻게 하면 좋을까요??
댓글 전체