주문현황 월별 출력 채택완료

<?php

// 일자별 주문 합계 금액

function get_order_month_sum($date)

{

    global $g5;

 

    $sql = " select sum(od_cart_price + od_send_cost + od_send_cost2) as orderprice,

                    sum(od_cancel_price) as cancelprice

                from {$g5['g5_shop_order_table']}

                where SUBSTRING(od_time, 1, 10) = '$date' ";

    $row = sql_fetch($sql);

 

    $info = array();

    $info['order'] = (int)$row['orderprice'];

    $info['cancel'] = (int)$row['cancelprice'];

 

    return $info;

}

 

// 일자별 결제수단 주문 합계 금액

function get_order_settle_sum($date)

{

    global $g5, $default;

 

    $case = array('신용카드', '계좌이체', '가상계좌', '무통장', '휴대폰');

    $info = array();

 

    // 결제수단별 합계

    foreach($case as $val)

    {

        $sql = " select sum(od_cart_price + od_send_cost + od_send_cost2 - od_receipt_point - od_cart_coupon - od_coupon - od_send_coupon) as price,

                        count(*) as cnt

                    from {$g5['g5_shop_order_table']}

                    where SUBSTRING(od_time, 1, 10) = '$date'

                      and od_settle_case = '$val' ";

        $row = sql_fetch($sql);

 

        $info[$val]['price'] = (int)$row['price'];

        $info[$val]['count'] = (int)$row['cnt'];

    }

 

    // 포인트 합계

    $sql = " select sum(od_receipt_point) as price,

                    count(*) as cnt

                from {$g5['g5_shop_order_table']}

                where SUBSTRING(od_time, 1, 10) = '$date'

                  and od_receipt_point > 0 ";

    $row = sql_fetch($sql);

    $info['포인트']['price'] = (int)$row['price'];

    $info['포인트']['count'] = (int)$row['cnt'];

 

    // 쿠폰 합계

    $sql = " select sum(od_cart_coupon + od_coupon + od_send_coupon) as price,

                    count(*) as cnt

                from {$g5['g5_shop_order_table']}

                where SUBSTRING(od_time, 1, 10) = '$date'

                  and ( od_cart_coupon > 0 or od_coupon > 0 or od_send_coupon > 0 ) ";

    $row = sql_fetch($sql);

    $info['쿠폰']['price'] = (int)$row['price'];

    $info['쿠폰']['count'] = (int)$row['cnt'];

 

    return $info;

}
 

?>