require("../../system/include/common.ini");
$i=0;
$list = '';
$login = '';
$s_price = 0;
if(array_key_exists('user_id',$_COOKIE)){
$isql = "SELECT *
FROM cart
LEFT JOIN (
SELECT
no,
det1
FROM topics_data AS m
WHERE NOT EXISTS (
SELECT 1
FROM topics_data AS s
WHERE
s.page = 'item'
AND s.cate = 'file'
AND m.no = s.no
AND m.num > s.num
)
AND m.page = 'item'
AND m.cate = 'file'
) topics_data
ON cart.item_no = topics_data.no
WHERE
cart.user_id = '".$_COOKIE['user_id']."'
ORDER BY
cart.ct
";
$result = $mysqli->query($isql);
while($customer = $result->fetch()){
$i++;
$item_no = $customer['item_no'];
$item_id = $customer['item_id'];
$item_name = $customer['item_name'];
$item_name2 = $customer['item_name2'];
$u_price = $customer['u_price'];
$kazu = $customer['kazu'];
$k_price = $customer['k_price'];
$wrap_flg = $customer['wrap_flg'];
$det1 = $customer['det1'];
//item_no + wrap_flg
$key = $item_no.$wrap_flg;
//数量選択
$sel_kazu = array('','','','','','','','','','','');
$sel_kazu[$kazu] = 'selected';
//熨斗
switch($wrap_flg){
case '1':
$wrap = '熨斗 御歳暮+名前';
break;
case '2':
$wrap = '熨斗 御礼+名前';
break;
case '3':
$wrap = '熨斗 贈答+名前';
break;
case '4':
$wrap = '熨斗 御祝+名前';
break;
default:
$wrap = '';
}
//商品名
//if($item_name2) $item_name .= '【'.$item_name2.'】';
if($wrap) $item_name .= '('.$wrap.')';
//画像
if(!$det1) $det1 = '../img/noimages.png';
else $det1 = _HREF_MAS.$det1;
$det1 = '';
//小計
$s_price = math_auto($s_price,$k_price,'+');
$list .= '
商品名
'.$det1.'
'.$item_name.'
単価
¥'.number($u_price).'
数量
金額(税込)
¥'.number($k_price).'
カートに商品がありません