<?php

/**

* ECSHOP 商品详情

* ============================================================================

* * 版权所有 2005-2012 上海商派网络科技有限公司，并保留所有权利。

* 网站地址: http://www.ecshop.com；

* ----------------------------------------------------------------------------

* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和

* 使用；不允许对程序代码以任何形式任何目的的再发布。

* ============================================================================

* $Author: liubo $

* $Id: goods.php 17217 2011-01-19 06:29:08Z liubo $

*/

define('IN_ECS', true); //判断是否未非法访问

require(dirname(__FILE__) . '/includes/init.php');

/*ross 修改, 为了 显示 运费*/

require_once(ROOT_PATH . 'includes/lib_order.php');

/*ross 修改, 为了 显示 运费*/

if ((DEBUG_MODE & 2) != 2)

{

$smarty->caching = true;

}

$affiliate = unserialize($GLOBALS['_CFG']['affiliate']);

$smarty->assign('affiliate', $affiliate);

/*------------------------------------------------------ */

//-- INPUT

/*------------------------------------------------------ */

$goods_id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;

/*------------------------------------------------------ */

//-- 改变属性、数量时重新计算商品价格

/*------------------------------------------------------ */

if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'price')

{

include('includes/cls_json.php');

$json = new JSON;

$res = array('err_msg' => '', 'result' => '', 'qty' => 1);

$attr_id = isset($_REQUEST['attr']) ? explode(',', $_REQUEST['attr']) : array();

$number = (isset($_REQUEST['number'])) ? intval($_REQUEST['number']) : 1;

$goods_id = intval($_REQUEST['id']);

$goods2 = get_goods_info($goods_id);

$goods_weight=$goods2['goods_weight'];

if(substr($goods_weight,-6,6) != '千克') {

$goods_weight =floatval($goods_weight)/1000;

}

$goods_weight = $goods_weight*$number;

$goods_amount = floatval($goods2['shop_price']);

if ($goods_id == 0)

{

$res['err_msg'] = $_LANG['err_change_attr'];

$res['err_no'] = 1;

}

else

{

if ($number == 0)

{

$res['qty'] = $number = 1;

}

else

{

$res['qty'] = $number;

}

//取到运费

$shipping_list = available_shipping_list([2]);

$goods_weight = $goods_weight*

$shipping_fee = @shipping_fee('sf_express', unserialize($shipping_list[0]['configure']), $goods_weight, $goods_amount, $number);

$shop_price = get_final_price($goods_id, $number, true, $attr_id);

$res['result'] = price_format($shop_price * $number);

}

$res['shipping_fee'] = $shipping_fee;

die($json->encode($res));

}

/*------------------------------------------------------ */

//-- 商品购买记录ajax处理

/*------------------------------------------------------ */

if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'gotopage')

{

include('includes/cls_json.php');

$json = new JSON;

$res = array('err_msg' => '', 'result' => '');

$goods_id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;

$page = (isset($_REQUEST['page'])) ? intval($_REQUEST['page']) : 1;

if (!empty($goods_id))

{

$need_cache = $GLOBALS['smarty']->caching;

$need_compile = $GLOBALS['smarty']->force_compile;

$GLOBALS['smarty']->caching = false;

$GLOBALS['smarty']->force_compile = true;

/* 商品购买记录 */

$sql = 'SELECT u.user_name, og.goods_number, oi.add_time, IF(oi.order_status IN (2, 3, 4), 0, 1) AS order_status ' .

'FROM ' . $ecs->table('order_info') . ' AS oi LEFT JOIN ' . $ecs->table('users') . ' AS u ON oi.user_id = u.user_id, ' . $ecs->table('order_goods') . ' AS og ' .

'WHERE oi.order_id = og.order_id AND ' . time() . ' - oi.add_time < 2592000 AND og.goods_id = ' . $goods_id . ' ORDER BY oi.add_time DESC LIMIT ' . (($page > 1) ? ($page-1) : 0) * 5 . ',5';

$bought_notes = $db->getAll($sql);

foreach ($bought_notes as $key => $val)

{

$bought_notes[$key]['add_time'] = local_date("Y-m-d G:i:s", $val['add_time']);

}

$sql = 'SELECT count(*) ' .

'FROM ' . $ecs->table('order_info') . ' AS oi LEFT JOIN ' . $ecs->table('users') . ' AS u ON oi.user_id = u.user_id, ' . $ecs->table('order_goods') . ' AS og ' .

'WHERE oi.order_id = og.order_id AND ' . time() . ' - oi.add_time < 2592000 AND og.goods_id = ' . $goods_id;

$count = $db->getOne($sql);

/* 商品购买记录分页样式 */

$pager = array();

$pager['page'] = $page;

$pager['size'] = $size = 5;

$pager['record_count'] = $count;

$pager['page_count'] = $page_count = ($count > 0) ? intval(ceil($count / $size)) : 1;;

$pager['page_first'] = "javascript:gotoBuyPage(1,$goods_id)";

$pager['page_prev'] = $page > 1 ? "javascript:gotoBuyPage(" .($page-1). ",$goods_id)" : 'javascript:;';

$pager['page_next'] = $page < $page_count ? 'javascript:gotoBuyPage(' .($page + 1) . ",$goods_id)" : 'javascript:;';

$pager['page_last'] = $page < $page_count ? 'javascript:gotoBuyPage(' .$page_count. ",$goods_id)" : 'javascript:;';

$smarty->assign('notes', $bought_notes);

$smarty->assign('pager', $pager);

$res['result'] = $GLOBALS['smarty']->fetch('library/bought_notes.lbi');

$GLOBALS['smarty']->caching = $need_cache;

$GLOBALS['smarty']->force_compile = $need_compile;

}

die($json->encode($res));

}

//print_r($have_province);die;

$jincity = isset($_COOKIE['jincity'])?$_COOKIE['jincity']:'CN000051';

$jinpro = isset($_COOKIE['jinpro'])?$_COOKIE['jinpro']:19;

//取得运费的省

$have_province = $db->getAll("SELECT * FROM " .$ecs->table('new_region')." WHERE parent_id=0 ");

$have_city = $db->getAll("SELECT * FROM " .$ecs->table('new_region')." WHERE parent_id='$jinpro'");

$smarty->assign('jincity', $jincity);

$smarty->assign('jinpro', $jinpro);

$smarty->assign('have_city', $have_city);

$smarty->assign('have_province', $have_province);

$smarty->assign('jincity', $jincity);

$smarty->assign('jinpro', $jinpro);

if($_REQUEST['act']=='region_') {

$val = $_REQUEST['val'];

$sql = "SELECT * FROM " .$ecs->table('new_region'). " WHERE parent_id= $val ";

$have_province2 = $db->getAll($sql);

$region_city = json_encode($have_province2);

echo($region_city);die;

}

/*

* TODO ajax获取运费

*/

if(!empty($_REQUEST['act']) && $_REQUEST['act'] == 'gotLogisticsPrice'){

$orderType = !empty($_REQUEST['$orderType'])?$_REQUEST['$orderType']:'WHOLESALE';

$qty = !empty($_REQUEST['qty'])?intval($_REQUEST['qty']):'';

$productAttr = !empty($_REQUEST['productAttr'])?$_REQUEST['productAttr']:'';

$qtyOfPackage = !empty($_REQUEST['qtyOfPackage'])?$_REQUEST['qtyOfPackage']:'';

$packWeight = !empty($_REQUEST['packWeight'])?$_REQUEST['packWeight']:'';

$packVolume = !empty($_REQUEST['packVolume'])?$_REQUEST['packVolume']:'';

$HSCode = !empty($_REQUEST['HSCode'])?$_REQUEST['HSCode']:'';

$originCityCode = !empty($_REQUEST['originCityCode'])?$_REQUEST['originCityCode']:'';

$destCityCode = !empty($_REQUEST['destCityCode'])?$_REQUEST['destCityCode']:'';

$transportModel = !empty($_REQUEST['transportModel'])?$_REQUEST['transportModel']:'';

$postData = array(

orderType=>$orderType,

qty=>$qty,

productAttr=>$productAttr,

qtyOfPackage=>$qtyOfPackage,

packWeight=>$packWeight,

packVolume=>$packVolume,

HSCode=>$HSCode,

originCityCode=>$originCityCode,

destCityCode=>$destCityCode,

transportModel=>$transportModel

);

$postUrl = "http://www.234plog.com/eCloudsService/ecshippingcost/"; //可做成配置项

echo json_encode(http_post($postUrl, $postData, $_COOKIE));

exit();

}

/*------------------------------------------------------ */

//-- PROCESSOR

/*------------------------------------------------------ */

//$sql ="select * from jindong_shipping WHERE shipping_id = 8";

//$res = $db->getAll($sql);

/*ross 在 产品详情页 显示 运费*/

$shipping_list = available_shipping_list([2]);

foreach ($shipping_list AS $key => $val) {

$shipping_fee = ($shipping_count == 0 AND $cart_weight_price['free_shipping'] == 1) ? 0 : shipping_fee($val['shipping_code'], unserialize($val['configure']), $goods_weight, $goods_amount, 1);

}

$goods2 = get_goods_info($goods_id);

if($goods2['is_shipping']) {

$shipping_fee = 0;

}

$smarty->assign('shipping_fee',$shipping_fee);

/*ross 在 产品详情页 显示 运费*/

$cache_id = $goods_id . '-' . $_SESSION['user_rank'].'-'.$_CFG['lang'];

$cache_id = sprintf('%X', crc32($cache_id));

if (!$smarty->is_cached('goods.dwt', $cache_id))

{

$smarty->assign('image_width', $_CFG['image_width']);

$smarty->assign('image_height', $_CFG['image_height']);

$smarty->assign('helps', get_shop_help()); // 网店帮助

$smarty->assign('id', $goods_id);

$smarty->assign('type', 0);

$smarty->assign('cfg', $_CFG);

$smarty->assign('promotion', get_promotion_info($goods_id));//促销信息

$smarty->assign('promotion_info', get_promotion_info());

/* 获得商品的信息 */

$goods = get_goods_info($goods_id);

if ($goods === false)

{

/* 如果没有找到任何记录则跳回到首页 */

ecs_header("Location: ./\n");

exit;

}

else

{

if ($goods['brand_id'] > 0)

{

$goods['goods_brand_url'] = build_uri('brand', array('bid'=>$goods['brand_id']), $goods['goods_brand']);

}

$shop_price = $goods['shop_price'];

$linked_goods = get_linked_goods($goods_id);

$goods['goods_style_name'] = add_style($goods['goods_name'], $goods['goods_name_style']);

/* 购买该商品可以得到多少钱的红包 */

if ($goods['bonus_type_id'] > 0)

{

$time = gmtime();

$sql = "SELECT type_money FROM " . $ecs->table('bonus_type') .

" WHERE type_id = '$goods[bonus_type_id]' " .

" AND send_type = '" . SEND_BY_GOODS . "' " .

" AND send_start_date <= '$time'" .

" AND send_end_date >= '$time'";

$goods['bonus_money'] = floatval($db->getOne($sql));

if ($goods['bonus_money'] > 0)

{

$goods['bonus_money'] = price_format($goods['bonus_money']);

}

}

$smarty->assign('goods', $goods);

$smarty->assign('goods_id', $goods['goods_id']);

$smarty->assign('promote_end_time', $goods['gmt_end_time']);

$smarty->assign('categories', get_categories_tree($goods['cat_id'])); // 分类树

/* meta */

$smarty->assign('keywords', htmlspecialchars($goods['keywords']));

$smarty->assign('description', htmlspecialchars($goods['goods_brief']));

$catlist = array();

foreach(get_parent_cats($goods['cat_id']) as $k=>$v)

{

$catlist[] = $v['cat_id'];

}

assign_template('c', $catlist);

/* 上一个商品下一个商品 */

$prev_gid = $db->getOne("SELECT goods_id FROM " .$ecs->table('goods'). " WHERE cat_id=" . $goods['cat_id'] . " AND goods_id > " . $goods['goods_id'] . " AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0 LIMIT 1");

if (!empty($prev_gid))

{

$prev_good['url'] = build_uri('goods', array('gid' => $prev_gid), $goods['goods_name']);

$smarty->assign('prev_good', $prev_good);//上一个商品

}

$next_gid = $db->getOne("SELECT max(goods_id) FROM " . $ecs->table('goods') . " WHERE cat_id=".$goods['cat_id']." AND goods_id < ".$goods['goods_id'] . " AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0");

if (!empty($next_gid))

{

$next_good['url'] = build_uri('goods', array('gid' => $next_gid), $goods['goods_name']);

$smarty->assign('next_good', $next_good);//下一个商品

}

$position = assign_ur_here($goods['cat_id'], $goods['goods_name']);

/* current position */

$smarty->assign('page_title', $position['title']); // 页面标题

$smarty->assign('ur_here', $position['ur_here']); // 当前位置

$properties = get_goods_properties($goods_id); // 获得商品的规格和属性

$smarty->assign('properties', $properties['pro']); // 商品属性

$smarty->assign('specification', $properties['spe']); // 商品规格

$smarty->assign('attribute_linked', get_same_attribute_goods($properties)); // 相同属性的关联商品

$smarty->assign('related_goods', $linked_goods); // 关联商品

$smarty->assign('goods_article_list', get_linked_articles($goods_id)); // 关联文章

$smarty->assign('fittings', get_goods_fittings(array($goods_id))); // 配件

$smarty->assign('rank_prices', get_user_rank_prices($goods_id, $shop_price)); // 会员等级价格

$smarty->assign('pictures', get_goods_gallery($goods_id)); // 商品相册

$smarty->assign('bought_goods', get_also_bought($goods_id)); // 购买了该商品的用户还购买了哪些商品

$smarty->assign('goods_rank', get_goods_rank($goods_id)); // 商品的销售排名

//获取tag

$tag_array = get_tags($goods_id);

$smarty->assign('tags', $tag_array); // 商品的标记

//获取关联礼包

$package_goods_list = get_package_goods_list($goods['goods_id']);

$smarty->assign('package_goods_list',$package_goods_list); // 获取关联礼包

assign_dynamic('goods');

$volume_price_list = get_volume_price_list($goods['goods_id'], '1');

//var_dump($volume_price_list);

$pri_number = array();

foreach($volume_price_list as $k=>$v) {

$pri_number[] = $volume_price_list[$k]['number'];

}

$smarty->assign('pri_number',$pri_number); // 商品优惠价格区间

$lowprice = end($volume_price_list);

$smarty->assign('volume_price_list',$volume_price_list); // 商品优惠价格区间

$smarty->assign('lowprice',$lowprice); // 商品优惠价格区间

}

}

/* 记录浏览历史 */

if (!empty($_COOKIE['ECS']['history']))

{

$history = explode(',', $_COOKIE['ECS']['history']);

array_unshift($history, $goods_id);

$history = array_unique($history);

while (count($history) > $_CFG['history_number'])

{

array_pop($history);

}

setcookie('ECS[history]', implode(',', $history), gmtime() + 3600 * 24 * 30);

}

else

{

setcookie('ECS[history]', $goods_id, gmtime() + 3600 * 24 * 30);

}

/* 更新点击次数 */

$db->query('UPDATE ' . $ecs->table('goods') . " SET click_count = click_count + 1 WHERE goods_id = '$_REQUEST[id]'");

$smarty->assign('now_time', gmtime()); // 当前系统时间

$smarty->display('goods.dwt', $cache_id);

/*------------------------------------------------------ */

//-- PRIVATE FUNCTION

/*------------------------------------------------------ */

/**

* 获得指定商品的关联商品

*

* @access public

* @param integer $goods_id

* @return array

*/

function get_linked_goods($goods_id)

}

/**

* 获得指定商品的关联文章

*

* @access public

* @param integer $goods_id

* @return void

*/

function get_linked_articles($goods_id)

}

/**

* 获得指定商品的各会员等级对应的价格

*

* @access public

* @param integer $goods_id

* @return array

*/

function get_user_rank_prices($goods_id, $shop_price)

}

/**

* 获得购买过该商品的人还买过的商品

*

* @access public

* @param integer $goods_id

* @return array

*/

function get_also_bought($goods_id)

}

/**

* 获得指定商品的销售排名

*

* @access public

* @param integer $goods_id

* @return integer

*/

function get_goods_rank($goods_id)

}

/**

* 获得商品选定的属性的附加总价格

*

* @param integer $goods_id

* @param array $attr

*

* @return void

*/

function get_attr_amount($goods_id, $attr)

}

/**

* 取得跟商品关联的礼包列表

*

* @param string $goods_id 商品编号

*

* @return 礼包列表

*/

function get_package_goods_list($goods_id)

}

?>