<?php
$sub_menu = "200850";
include_once('./_common.php');
auth_check_menu($auth, $sub_menu, 'r');
include_once ('./admin.head.php');
?>

<?php
function array_msort($array, $cols){ // 배열 재정열 함수
    $colarr = array();
    foreach ($cols as $col => $order) {
        $colarr[$col] = array();
        foreach ($array as $k => $row) { $colarr[$col]['_'.$k] = strtolower($row[$col]); }
    }
    $eval = 'array_multisort(';
    foreach ($cols as $col => $order) {
        $eval .= '$colarr[\''.$col.'\'],'.$order.',';
    }
    $eval = substr($eval,0,-1).');';
    eval($eval);
    $ret = array();
    foreach ($colarr as $col => $arr) {
        foreach ($arr as $k => $v) {
            $k = substr($k,1);
            if (!isset($ret[$k])) $ret[$k] = $array[$k];
            $ret[$k][$col] = $array[$k][$col];
        }
    }
    return array_values($ret);
}
?>
<link rel="stylesheet" href="<?php echo G5_ADMIN_URL; ?>/css/admin.css">
<div class="local_desc02 local_desc">
<p>단골 고객<span>(비회원은 포함되지 않습니다.)</span></p>
</div>
<div class="tbl_head01 tbl_wrap">
<table>
    <tr>
        <th>순위</th>
        <th>회원 ID</th>
        <th>이름</th>
        <th>누적 주문</th>
        <th>총 구매금액</th>
        <th>최종접속일</th>
    </tr>
    <?php
    $ranking = array();
    $list = 0;
    $sql = "select a.mb_id,a.od_cart_price,b.mb_name from {$g5['g5_shop_order_table']} a inner join {$g5['member_table']} b on a.mb_id = b.mb_id where a.od_status != '취소' and a.mb_id != ''"; // 주문상태 취소를 제외, 비회원 제외하고 불러옵니다.
    $rs = sql_query($sql);
    while($row = sql_fetch_array($rs)){
        $search_key = array_search($row['mb_id'], array_column($ranking, 'mb_id'));
        if($search_key > -1){
            $ranking[$search_key]['price'] += $row['od_cart_price'];
            $ranking[$search_key]['count'] += 1;
        } else {
            $ranking[$list]['mb_id'] = $row['mb_id'];
            $ranking[$list]['mb_name'] = $row['mb_name'];
            $ranking[$list]['price'] = $row['od_cart_price'];
            $ranking[$list]['count'] = 1;
            $ranking[$list]['mb_today_login'] = $row['mb_today_login'];
            $list++;
        }
    }
    $rank = array_msort($ranking, array('price'=>SORT_DESC)); // 배열 재정열
    if(count($rank) > 20) $count = 20; // 출력 갯수
    else $count = count($rank);
    for($i=0; $i<$count; $i++){
    ?>
    <tr>
        <td><?php echo $i + 1;?></td>
        <td><?=$rank[$i]['mb_id']?></td>
        <td><?=$rank[$i]['mb_name']?></td>
        <td><?=number_format($rank[$i]['count'])?><span>건</span></td>
        <td><?=number_format($rank[$i]['price'])?><span>원</span></td>
        <td><?php echo date("Y.m.d H:i", strtotime($row['mb_today_login'])); ?></td>
    </tr>
    <?php } if($i == 0){?>
    <tr>
        <td colspan="50">아직 단골 고객이 없습니다.</td>
    </tr>
    <?php }?>
</table>
</div>

<?php
include_once ('./admin.tail.php');