41;42.5;防水;V底;Merrell迈乐J21291登山鞋徒步鞋户外鞋_Merrell户外鞋靴_Merrell/迈乐/麦乐_【品牌】KLMNO_a5shop 宝贝展示中心
0) ? ' AND ' . get_children($cat) : '';
$sql = "SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag ".
"FROM " . $GLOBALS['ecs']->table('brand') . "AS b, ".
$GLOBALS['ecs']->table('goods') . " AS g ".
"WHERE g.brand_id = b.brand_id $children AND is_show = 1 " .
" AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ".
"GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC";
$row = $GLOBALS['db']->getAll($sql);
foreach ($row AS $key => $val)
$row[$key]['url'] = build_uri($app, array('cid' => $cat, 'bid' => $val['brand_id']), $val['brand_name']);
$row[$key]['brand_desc'] = htmlspecialchars($val['brand_desc'],ENT_QUOTES);
function get_promotion_info1($goods_id = '')
$snatch = array();
$group = array();
$auction = array();
$package = array();
$favourable = array();
$gmtime = gmtime();
$sql = 'SELECT act_id, act_name, act_type, start_time, end_time FROM ' . $GLOBALS['ecs']->table('goods_activity') . " WHERE is_finished=0 AND start_time = '$gmtime'";
if(!empty($goods_id))
$sql .= " AND goods_id = '$goods_id'";
$res = $GLOBALS['db']->getAll($sql);
foreach ($res as $data)
switch ($data['act_type'])
case GAT_SNATCH: //夺宝奇兵
$snatch[$data['act_id']]['act_name'] = $data['act_name'];
$snatch[$data['act_id']]['url'] = build_uri('snatch', array('sid' => $data['act_id']));
$snatch[$data['act_id']]['time'] = sprintf($GLOBALS['_LANG']['promotion_time'], local_date('Y-m-d', $data['start_time']), local_date('Y-m-d', $data['end_time']));
$snatch[$data['act_id']]['sort'] = $data['start_time'];
$snatch[$data['act_id']]['type'] = 'snatch';
case GAT_GROUP_BUY: //团购
$group[$data['act_id']]['act_name'] = $data['act_name'];
$group[$data['act_id']]['url'] = build_uri('group_buy', array('gbid' => $data['act_id']));
$group[$data['act_id']]['time'] = sprintf($GLOBALS['_LANG']['promotion_time'], local_date('Y-m-d', $data['start_time']), local_date('Y-m-d', $data['end_time']));
$group[$data['act_id']]['sort'] = $data['start_time'];
$group[$data['act_id']]['type'] = 'group_buy';
case GAT_AUCTION: //拍卖
$auction[$data['act_id']]['act_name'] = $data['act_name'];
$auction[$data['act_id']]['url'] = build_uri('auction', array('auid' => $data['act_id']));
$auction[$data['act_id']]['time'] = sprintf($GLOBALS['_LANG']['promotion_time'], local_date('Y-m-d', $data['start_time']), local_date('Y-m-d', $data['end_time']));
$auction[$data['act_id']]['sort'] = $data['start_time'];
$auction[$data['act_id']]['type'] = 'auction';
case GAT_PACKAGE: //礼包
$package[$data['act_id']]['act_name'] = $data['act_name'];
$package[$data['act_id']]['url'] = 'package.php#' . $data['act_id'];
$package[$data['act_id']]['time'] = sprintf($GLOBALS['_LANG']['promotion_time'], local_date('Y-m-d', $data['start_time']), local_date('Y-m-d', $data['end_time']));
$package[$data['act_id']]['sort'] = $data['start_time'];
$package[$data['act_id']]['type'] = 'package';
$user_rank = ',' . $_SESSION['user_rank'] . ',';
$favourable = array();
$sql = 'SELECT act_id, act_range, act_range_ext, act_name, start_time, end_time FROM ' . $GLOBALS['ecs']->table('favourable_activity') . " WHERE start_time = '$gmtime'";
if(!empty($goods_id))
$sql .= " AND CONCAT(',', user_rank, ',') LIKE '%" . $user_rank . "%'";
$res = $GLOBALS['db']->getAll($sql);
if(empty($goods_id))
foreach ($res as $rows)
$favourable[$rows['act_id']]['act_name'] = $rows['act_name'];
$favourable[$rows['act_id']]['url'] = 'activity.php';
$favourable[$rows['act_id']]['time'] = sprintf($GLOBALS['_LANG']['promotion_time'], local_date('Y-m-d', $rows['start_time']), local_date('Y-m-d', $rows['end_time']));
$favourable[$rows['act_id']]['sort'] = $rows['start_time'];
$favourable[$rows['act_id']]['type'] = 'favourable';
$sql = "SELECT cat_id, brand_id FROM " . $GLOBALS['ecs']->table('goods') .
"WHERE goods_id = '$goods_id'";
$row = $GLOBALS['db']->getRow($sql);
$category_id = $row['cat_id'];
$brand_id = $row['brand_id'];
foreach ($res as $rows)
if ($rows['act_range'] == FAR_ALL)
$favourable[$rows['act_id']]['act_name'] = $rows['act_name'];
$favourable[$rows['act_id']]['url'] = 'activity.php';
$favourable[$rows['act_id']]['time'] = sprintf($GLOBALS['_LANG']['promotion_time'], local_date('Y-m-d', $rows['start_time']), local_date('Y-m-d', $rows['end_time']));
$favourable[$rows['act_id']]['sort'] = $rows['start_time'];
$favourable[$rows['act_id']]['type'] = 'favourable';
elseif ($rows['act_range'] == FAR_CATEGORY)
/* 找出分类id的子分类id */
$id_list = array();
$raw_id_list = explode(',', $rows['act_range_ext']);
foreach ($raw_id_list as $id)
$id_list = array_merge($id_list, array_keys(cat_list($id, 0, false)));
$ids = join(',', array_unique($id_list));
if (strpos(',' . $ids . ',', ',' . $category_id . ',') !== false)
$favourable[$rows['act_id']]['act_name'] = $rows['act_name'];
$favourable[$rows['act_id']]['url'] = 'activity.php';
$favourable[$rows['act_id']]['time'] = sprintf($GLOBALS['_LANG']['promotion_time'], local_date('Y-m-d', $rows['start_time']), local_date('Y-m-d', $rows['end_time']));
$favourable[$rows['act_id']]['sort'] = $rows['start_time'];
$favourable[$rows['act_id']]['type'] = 'favourable';
elseif ($rows['act_range'] == FAR_BRAND)
if (strpos(',' . $rows['act_range_ext'] . ',', ',' . $brand_id . ',') !== false)
$favourable[$rows['act_id']]['act_name'] = $rows['act_name'];
$favourable[$rows['act_id']]['url'] = 'activity.php';
$favourable[$rows['act_id']]['time'] = sprintf($GLOBALS['_LANG']['promotion_time'], local_date('Y-m-d', $rows['start_time']), local_date('Y-m-d', $rows['end_time']));
$favourable[$rows['act_id']]['sort'] = $rows['start_time'];
$favourable[$rows['act_id']]['type'] = 'favourable';
elseif ($rows['act_range'] == FAR_GOODS)
if (strpos(',' . $rows['act_range_ext'] . ',', ',' . $goods_id . ',') !== false)
$favourable[$rows['act_id']]['act_name'] = $rows['act_name'];
$favourable[$rows['act_id']]['url'] = 'activity.php';
$favourable[$rows['act_id']]['time'] = sprintf($GLOBALS['_LANG']['promotion_time'], local_date('Y-m-d', $rows['start_time']), local_date('Y-m-d', $rows['end_time']));
$favourable[$rows['act_id']]['sort'] = $rows['start_time'];
$favourable[$rows['act_id']]['type'] = 'favourable';
$sort_time = array();
$arr = array_merge($snatch, $group, $auction, $package, $favourable);
foreach($arr as $key => $value)
$sort_time[] = $value['sort'];
array_multisort($sort_time, SORT_NUMERIC, SORT_DESC, $arr);
$this->assign('promotion_info1', get_promotion_info1());
喵，欢迎来本站！
& 41;42.5;防水;V底;Merrell迈乐J21291登山鞋徒步鞋户外鞋
商品库存：
.會員優惠代碼（截圖給客服）.
1、一號店【】
2、二號店【..】
3、三號店【..】
品牌：.美国..Merrell..迈乐；麦乐（谐音）.
型号：.J21291（Men's Moab Rover Mid GTX）（/goods.php?id=370）.
产地：.Made in China.
官方定价：.160美元.
附属品说明：.直接来自工厂内部的全新真品;无原盒及吊牌.介意者敬请专柜购买！
鞋码比对参考标准：.以大品牌皮鞋（非运动鞋）尺码为参考基准;或者比对鞋垫长度.
｛现货1双｝：US9/UK8.5/EUR43（实测鞋垫长27.2厘米:偏小,建议41皮鞋/42运动鞋）
｛现货1双｝：US10/UK9.5/EUR44（实测鞋垫长28.6厘米:偏小,建议42.5皮鞋/43.5运动鞋）
...防水油性牛皮鞋面.
...透气网布里衬通过 M Select FRESH 抗菌科技处理，能抑制异味的产生.
...防水透气的 GORE-TEX& 里衬确保足部持续干燥和舒适.
...连体鞋舌阻挡外部的碎屑.
...麦乐 后跟气垫结合 EVA 减震吸收震动增加稳定.
...铸造成型的玻璃纤维拱形鞋骨.
...抽取式 EVA 减震鞋垫.
...EcoRight and Lazy 鞋内底 = 包含 70% 再生材料，麦乐专利的 Me Foam& 记忆发泡材料确保透气和舒适.
...5毫米鞋底齿纹深度.
...Vibram& 橡胶鞋底.
*【重要提醒】:.中国境内品牌直属工厂内部货源.由于无包装运输原因.鞋面并未光滑如镜.可能略有轻微折痕或划痕.具体情况参照实物照片.追求极致完美的朋友请谨慎购买.
*因货源的特殊性，我们能且仅能提供有限的售后服务！
*若您的要求超过以下所述，谨慎考虑！请勿勉强！避免不必要的售后纠纷！
一、仅能提供有条件的包修和包退服务，不包换。若您要换，可以先退再买！
二、真皮材质包修/包退期三个月；人造革面/布面材质包修/包退期二个月。
二.1、包修：自收到货之日起，第一个月内出现脱胶，包修产生的来回运费由卖家承担。第二（三）个月内出现脱胶，包修产生的来回运费双方各自承担。
二.2、包退：未穿过的新鞋；鞋面无明显折痕；鞋底无任何磨损。（即便仅仅穿过几次，鞋底有磨损痕迹，出现开胶等也只可能属于包修范畴，概不退货，只能维修）
二.2.1、自收到货之日起，三个月内正常使用而鞋面/鞋底断裂的，包退！
二.2.2、自收到货之日起，三个月内三次修理无效的，按原价（不含运费）每日0.5% 收取折旧费，予以退货退款。
三、鞋靴都是机制或手工制造的，都有出现问题的可能，请相互谅解和包涵......
退换货服务标准
退换货基本条件：
对全部商品：
外包装完整，且不影响二次销售。一旦拆封无法复原商品不可退货（质量问题除外）。
若交易已完成，发现质量问题，请在交易完成后15天内进行退款申请。
退款时买家需将发票和赠品一起退回。
不可退换货特殊说明：
无质量问题且外包装已拆无法复原，影响二次销售。
为客户特殊定制的商品不支持7天无理由退换货。
人为刻意损害或不可抗力导致的损坏。
7天无理由退换货超过食用期限的商品。
非天猫店铺出售的商品或已超出退换货期限的商品（7天无理由退货以签收日为准起始7日之内）。
商品的图片及信息仅供参考。因拍摄灯光及不同显示器色差等问题可能造成商品图片与实物有细微色差。
退换货费用说明：
如果是买家原因退货，由买家自行承担退货费用。
如果是商品质量问题、描述不符而导致的退货，退货费用则应由店铺承担。
退货时可能涉及的证明：
购货发票以及赠品。
权威检验机构以及品牌所有者出具的鉴定报告或其他能够证明所购买商品为假货的凭证。
旺旺聊天记录截图（在使用阿里旺旺与店铺沟通时，请事先在系统设置-聊天设置中选择“将我的消息记录保存到阿里旺旺服务器上”）。
其他天猫需要双方出具的证明文件。