?> <div class="tbl_head02 tbl_wrap"> <table> <caption>쿠폰 선택</caption> <thead> <tr> <th scope="col">쿠폰명</th> <th scope="col">할인금액</th> <th scope="col">적용</th> </tr> </thead> <tbody> <?php for ($i = 0; $row = sql_fetch_array($result); $i++) { // 사용한 쿠폰인지 체크 if (is_used_coupon($member['mb_id'], $row['cp_id'])) { continue; } $dc = 0; if ($row['cp_type']) { $dc = floor($send_cost * ($row['cp_price'] / 100) / $row['cp_trunc']) * $row['cp_trunc']; } else { $dc = $row['cp_price']; } if ($row['cp_maximum'] && $dc > $row['cp_maximum']) { $dc = $row['cp_maximum']; } if ($dc > $send_cost) { $dc = $send_cost; } ?>
function apms_coupon_update($mb_id) { global $g5; if (!$mb_id) { return; } $sql = " select cp_id from {$g5['g5_shop_coupon_table']} where mb_id IN ('{$mb_id}', '전체회원') and cp_start <= '" . G5_TIME_YMD . "' and cp_end >= '" . G5_TIME_YMD . "'"; $result = sql_query($sql); $k = 0; for ($i = 0; $row = sql_fetch_array($result); $i++) { if (is_used_coupon($mb_id, $row['cp_id'])) { continue; } $k++; } // 보유 쿠폰 업데이트 sql_query(" update {$g5['member_table']} set as_coupon = '{$k}' where mb_id = '{$mb_id}' ", false); return; }
} $tot_cp_price = $tot_it_cp_price + $tot_od_cp_price; } if ((int) ($row['od_price'] - $tot_cp_price) !== $i_price) { die("Error."); } // 배송비가 상이함 $send_cost = get_sendcost($tmp_cart_id); $tot_sc_cp_price = 0; if ($is_member && $send_cost > 0) { // 배송쿠폰 if ($_POST['sc_cp_id']) { $sql = " select cp_id, cp_type, cp_price, cp_trunc, cp_minimum, cp_maximum\n from {$g5['g5_shop_coupon_table']}\n where cp_id = '{$_POST['sc_cp_id']}'\n and mb_id IN ( '{$member['mb_id']}', '전체회원' )\n and cp_start <= '" . G5_TIME_YMD . "'\n and cp_end >= '" . G5_TIME_YMD . "'\n and cp_method = '3' "; $cp = sql_fetch($sql); // 사용한 쿠폰인지 $cp_used = is_used_coupon($member['mb_id'], $cp['cp_id']); $dc = 0; if (!$cp_used && $cp['cp_id'] && $cp['cp_minimum'] <= $tot_od_price) { if ($cp['cp_type']) { $dc = floor($send_cost * ($cp['cp_price'] / 100) / $cp['cp_trunc']) * $cp['cp_trunc']; } else { $dc = $cp['cp_price']; } if ($cp['cp_maximum'] && $dc > $cp['cp_maximum']) { $dc = $cp['cp_maximum']; } if ($dc > $send_cost) { $dc = $send_cost; } $tot_sc_cp_price = $dc; }
<?php include_once './_common.php'; if (!$is_member) { goto_url(G5_BBS_URL . "/login.php?url=" . urlencode(G5_SHOP_URL . "/mypage.php")); } $g5['title'] = '마이페이지'; include_once G5_MSHOP_PATH . '/_head.php'; // 쿠폰 $cp_count = 0; $sql = " select cp_id\n from {$g5['g5_shop_coupon_table']}\n where mb_id IN ( '{$member['mb_id']}', '전체회원' )\n and cp_start <= '" . G5_TIME_YMD . "'\n and cp_end >= '" . G5_TIME_YMD . "' "; $res = sql_query($sql); for ($k = 0; $cp = sql_fetch_array($res); $k++) { if (!is_used_coupon($member['mb_id'], $cp['cp_id'])) { $cp_count++; } } ?> <div id="smb_my"> <section id="smb_my_ov"> <h2>회원정보 개요</h2> <ul> <li class="my_cou">보유쿠폰<a href="<?php echo G5_SHOP_URL; ?> /coupon.php" target="_blank" class="win_coupon"><?php echo number_format($cp_count); ?> </a></li>