[PHP] 쇼핑몰에 쓰려고 만든 함수 몇개

// 매출액 계산
function get_shop_sales($period)
{
    global $g4;
    $len = strlen($period);

    $sql = ” select SUM( a.ct_amount * a.ct_qty ) – SUM( IF(a.ct_status = ‘취소’ OR a.ct_status = ‘반품’ OR a.ct_status = ‘품절’, a.ct_amount * a.ct_qty, 0) ) as sales
                from $g4[shop_cart_table] as a left join $g4[shop_order_table] as b on ( a.on_uid = b.on_uid )
                where substring(b.od_time, 1, $len) = ‘$period’ “;
    $row = sql_fetch($sql);

    return $row[sales];
}

// 결재완료수
function get_credit_count($period)
{
    global $g4;
    $len = strlen($period);

    $sql = ” select od_id from $g4[shop_order_table]
                where ((od_temp_bank – od_receipt_bank – od_receipt_point) = 0)
                    or ((od_temp_card – od_receipt_card – od_receipt_point) = 0)
                    and substring(od_receipt_time, 1, $len) = ‘$period’ “;
    $result = sql_query($sql);
    $count = mysql_num_rows($result);

    return $count;
}

// 주문수
function get_order_count($period)
{
    global $g4;
    $len = strlen($period);

    $sql = ” select od_id from $g4[shop_order_table] where substring(od_time, 1, $len) = ‘$period’ “;
    $result = sql_query($sql);
    $count = mysql_num_rows($result);

    return $count;
}

// 회원수
function get_member_count($period)
{
    global $g4;
    $len = strlen($period);

    $sql = ” select mb_no from $g4[member_table] where substring(mb_datetime, 1, $len) = ‘$period’ “;
    $result = sql_query($sql);
    $count = mysql_num_rows($result);

    return $count;
}

// 취소수
function get_cancel_count($period)
{
    global $g4;
    $len = strlen($period);

    $sql = ” select distinct b.od_id
                from $g4[shop_cart_table] as a left join $g4[shop_order_table] as b on ( a.on_uid = b.on_uid )
                where a.ct_status IN (‘취소’, ‘반품’, ‘품절’) and substring(b.od_time, 1, $len) = ‘$period’ “;
    $result = sql_query($sql);
    $count = mysql_num_rows($result);

    return $count;
}