?>
<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>
